1 PACKAGE POR_RCV_TRANSACTION_SV AUTHID CURRENT_USER AS
2 /* $Header: PORRCVTS.pls 115.1 2002/03/06 10:36:42 pkm ship $*/
3
4 /******************************************************************
5 ** Function : insert_transaction_interface
6 ** Description : This is a function called from Java layer
7 ** currently used by return items and correction on the web.
8 ******************************************************************/
9
10 function insert_transaction_interface(
11 p_Transaction_Type in varchar2,
12 p_caller in varchar2,
13 p_Parent_Transaction_Id in number,
14 p_Quantity in number,
15 p_Group_Id in number,
16 p_Group_Id2 in number,
17 p_Transaction_Date in date default sysdate,
18 p_Unit_Of_Measure in varchar2 default null,
19 p_Return_Reason_Id in number default null,
20 p_RMA_reference in varchar2 default null,
21 p_Subinventory in varchar2 default null,
22 p_Receiving_Location_Id in number default null,
23 p_Comments in varchar2 default null) return number;
24
25 /*************************************************************
26 ** Function : Process_Transactions
27 ** Description : This is a procedure that validates
28 ** the transactions and call_txn_processor.
29 **************************************************************/
30
31 function process_transactions(p_group_id in number,
32 p_group_id2 in number,
33 p_caller in varchar2)
34 return number;
35
36 function get_net_delivered_qty(p_txn_id in number) return number;
37 PRAGMA RESTRICT_REFERENCES(get_net_delivered_qty, WNDS, WNPS);
38
39 function get_net_returned_qty(p_txn_id in number) return number;
40 PRAGMA RESTRICT_REFERENCES(get_net_returned_qty, WNDS, WNPS);
41
42 function GET_SHIPMENT_NUM(p_order_type_code in varchar2,
43 p_key_id in number)
44 return varchar2;
45
46 end POR_RCV_TRANSACTION_SV;
[Home] [Help]