DBA Data[Home] [Help]

PACKAGE: APPS.OE_DROP_SHIP_PVT

Source


1 PACKAGE OE_DROP_SHIP_PVT AUTHID CURRENT_USER as
2 /* $Header: OEXVDPVS.pls 115.1 99/10/20 15:28:10 porting shi $ */
3 
4 FUNCTION get_po_status
5 (
6   p_po_header_id	IN	NUMBER
7 ) return VARCHAR2;
8 
9 /*pragma restrict_references(get_po_status, WNDS, WNPS);*/
10 
11 FUNCTION get_release_status
12 (
13   p_po_release_id	IN	NUMBER
14 ) return VARCHAR2;
15 
16 /*pragma restrict_references(get_release_status, WNDS, WNPS); */
17 
18 
19 Function COMPARE_PO_SO ( p_so_location number,
20                          p_po_location number,
21                          p_so_unit_of_measure varchar2,
22                          p_po_unit_of_measure varchar2,
23                          p_so_schedule_date date,
24                          p_po_schedule_date date,
25                          p_so_ordered_qty number,
26                          p_so_cancelled_qty number,
27 			 p_so_shipped_quantity number,
28                          p_potableused varchar2,
29                          p_headerid number,
30                          p_lineid number) return varchar2;
31 
32 pragma restrict_references(COMPARE_PO_SO, WNDS, WNPS);
33 
34 Function get_hold_name(p_holdid in number) return varchar2;
35 
36 pragma restrict_references(get_hold_name, WNDS, WNPS);
37 
38 PROCEDURE recover_schedule (P_API_Version      In Number,
39                                   P_Return_Status    Out Varchar2,
40                                   P_Msg_Count        Out Number,
41                                   P_MSG_Data         Out Varchar2,
42                                   p_line_id	IN	NUMBER);
43 
44 
45 END OE_DROP_SHIP_PVT;