API call for Actual Delivery Date

HI,

RECEIPT_INFO_API.Get_Delivery_Date(receipt_sequence);

Tomas

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,

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,

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