1 PACKAGE OE_DS_PVT AS
2 /* $Header: OEXVDSRS.pls 120.0.12010000.1 2008/07/25 07:59:39 appldev ship $ */
3
4 TYPE Profile_type IS RECORD
5 ( oe_source_code VARCHAR2(240)
6 , user_id NUMBER
7 , login_id NUMBER
8 , request_id NUMBER
9 , application_id NUMBER
10 , program_id NUMBER);
11
12 profile_values Profile_type;
13
14 FUNCTION DropShipReceive( p_rcv_transaction_id IN NUMBER,
15 p_application_short_name IN VARCHAR2,
16 p_mode IN NUMBER DEFAULT 0)
17 RETURN BOOLEAN;
18
19 FUNCTION Get_mtl_sales_order_id(p_header_id IN NUMBER)
20 RETURN NUMBER;
21
22 Procedure Insert_OE_Drop_Ship_Source
23 ( P_Old_Line_ID In Number,
24 P_New_Line_ID In Number);
25
26 Procedure Check_PO_Approved
27 ( p_application_id IN NUMBER
28 , p_entity_short_name IN VARCHAR2
29 , p_validation_entity_short_name IN VARCHAR2
30 , p_validation_tmplt_short_name IN VARCHAR2
31 , p_record_set_tmplt_short_name IN VARCHAR2
32 , p_scope IN VARCHAR2
33 , p_result OUT NOCOPY /* file.sql.39 change */ NUMBER
34 );
35
36 FUNCTION Check_Req_PO_Cancelled
37 ( p_line_id IN NUMBER
38 , p_header_id IN NUMBER
39 ) RETURN BOOLEAN;
40
41 Procedure OM_PO_Discrepancy_Exists
42 ( p_application_id IN NUMBER
43 , p_entity_short_name IN VARCHAR2
44 , p_validation_entity_short_name IN VARCHAR2
45 , p_validation_tmplt_short_name IN VARCHAR2
46 , p_record_set_tmplt_short_name IN VARCHAR2
47 , p_scope IN VARCHAR2
48 , p_result OUT NOCOPY /* file.sql.39 change */ NUMBER
49 );
50
51 END OE_DS_PVT;