HI,

RECEIPT_INFO_API.Get_Delivery_Date(receipt_sequence);

Tomas

Hi Tomas,

I do not see this API call.. Do you know if this call API exists in APPS9 ?

HI,

no for V9 is valid this one:

PURCHASE_RECEIPT_API.Get_Arrival_Date(order_no_   => ,
                                      line_no_    => ,
                                      release_no_ => ,
                                      receipt_no_ => )

or 

PURCHASE_RECEIPT_API.Get_Delivery_Date(order_no_   => ,
                                      line_no_    => ,
                                      release_no_ => ,
                                      receipt_no_ => )

not sure which one you need to see.

Tomas

Hi Tomas,

This is the API call for the field from Purchase Receipt view

But I want the API call for calculating the actual delivery date in the Register Arrival entry view.

Hi,

my misunderstanding. Here it is:

as OUT is: deliery_date_ (your date what you want)

IN parameters:

contract_ - this you know

arrival_date_ = sysdate

Transport_Lead_Time_ can be null

IFSAPP.Pur_Ord_Date_Calculation_API.Fetch_Calendar_Start_Date(deliery_date_ , IFSAPP.Site_API.Get_Dist_Calendar_Id(contract_), arrival_date_ , Transport_Lead_Time_ );

Tomas

Hi Tomas,

For some reason I’m not able to use this API call in a select statement.

I’m trying to do 

SELECT 

Pur_Ord_Date_Calculation_API.Fetch_Calendar_Start_Date(return_date,IFSAPP.Site_API.Get_Dist_Calendar_Id('1000'),sysdate,ifsapp.Pur_Ord_Date_Calculation_API.Get_Transport_Leadtime('P102108','1','1'))

from dual;

Is there anyway we can get the return_date via a Select statement ? I want to use it in a custom field 

Hi,

as this is not function but procedure, you cannot use it in CF.

you can write your own function like below and that one can be used directly in CF.

and better is not via select.

CREATE OR REPLACE FUNCTION c_return_delivery_date (
  contract_           VARCHAR2,
  arrival_date_       DATE,
  Transport_Lead_Time_ NUMBER) RETURN DATE
AS
  delivery_date_ DATE;
BEGIN

  Pur_Ord_Date_Calculation_API.Fetch_Calendar_Start_Date(delivery_date_,
                                                         IFSAPP.Site_API.Get_Dist_Calendar_Id(contract_),
                                                         arrival_date_ ,
                                                         Transport_Lead_Time_);
  IF delivery_date_ IS NULL THEN
    delivery_date_ := SYSDATE;
  END IF;
  RETURN delivery_date_;
END c_return_delivery_date;

And the best will be put that function into some custom api, that you can grant it to the users.

Tomas