1 Package OE_PO_CALLBACK_UTIL AUTHID CURRENT_USER As
2 /* $Header: OEXDPOCS.pls 115.0 99/07/26 11:07:30 porting shi $ */
3
4 Procedure Update_Req_Info(P_API_Version In Number,
5 P_Return_Status Out Varchar2,
6 P_Msg_Count Out Number,
7 P_MSG_Data Out Varchar2,
8 P_Interface_Source_Code In Varchar2,
9 P_Interface_Source_Line_ID In Number,
10 P_Requisition_Header_ID In Number,
11 P_Requisition_Line_ID In Number);
12
13 Procedure Insert_SO_Drop_Ship_Sources
14 ( P_Drop_Ship_Source_ID In Number
15 , P_Header_ID In Number
16 , P_Line_ID In Number
17 , P_Org_ID In Number
18 , P_Destination_Organization_ID In Number
19 , P_Requisition_Header_ID In Number
20 , P_Requisition_Line_ID In Number
21 , P_PO_Header_ID In Number
22 , P_PO_Line_ID In Number
23 , P_Line_Location_ID In Number
24 , P_PO_Release_ID In Number Default Null);
25
26 -- Update_All_Reqs_In_Process is an OE procedure that is called by
27 -- Oracle Purchasing to update requisition information for a drop shipped line.
28 -- This procedure is called in the Requisition Import (ReqImport) process of
29 -- Oracle Purchasing.
30
31 Procedure Update_All_Reqs_In_Process
32 ( P_API_Version In Number
33 , P_Return_Status Out Varchar2
34 , P_Msg_Count Out Number
35 , P_MSG_Data Out Varchar2
36 , P_Requisition_Header_ID In Number
37 , P_Request_Id In Number
38 , P_Process_Flag In Varchar2);
39
40 -- Update_PO_Info is an OE procedure that is called by Oracle Purchasing to
41 -- update purchase order information for a drop shipped line. This procedure
42 -- is called in the Auto create process of Oracle Purchasing
43
44 Procedure Update_PO_Info
45 ( P_API_Version In Number
46 , P_Return_Status Out Varchar2
47 , P_Msg_Count Out Number
48 , P_MSG_Data Out Varchar2
49 , P_Req_Header_ID In Number
50 , P_Req_Line_ID In Number
51 , P_PO_Header_Id In Number
52 , P_PO_Line_Id In Number
53 , P_Line_Location_ID In Number
54 , P_PO_Release_ID In Number Default Null);
55
56 Function Valid_Drop_Ship_Source_ID
57 (P_Drop_Ship_Source_ID In Number)
58 Return Boolean;
59
60 Function Req_Line_Is_Drop_Ship
61 (P_Req_Line_Id In Number)
62 Return Number;
63
64 Function PO_Line_Location_Is_Drop_Ship
65 (P_PO_Line_Location_Id In Number)
66 Return Number;
67
68 End OE_PO_CALLBACK_UTIL;
[Home] [Help]