PACKAGE: APPS.OE_DS_PVT

Source

1 PACKAGE OE_DS_PVT AUTHID CURRENT_USER AS
2 /* $Header: OEXVDSRS.pls 120.0.12020000.2 2013/03/11 10:16:46 lnammina ship $ */
3 
4 --16429262 Flag to indentify call Create Reservations from Dropship SO Issue Processing
5 G_DS_SOISSUE_FLAG VARCHAR2(1) := 'N';
6 
7 TYPE Profile_type IS RECORD
8 ( oe_source_code VARCHAR2(240)
9 , user_id        NUMBER
10 , login_id       NUMBER
11 , request_id     NUMBER
12 , application_id NUMBER
13 , program_id     NUMBER);
14 
15 profile_values  Profile_type;
16 
17 FUNCTION DropShipReceive( p_rcv_transaction_id      IN  NUMBER,
18                           p_application_short_name  IN  VARCHAR2,
19                           p_mode                    IN  NUMBER DEFAULT 0)
20 RETURN BOOLEAN;
21 
22 FUNCTION Get_mtl_sales_order_id(p_header_id IN NUMBER)
23 RETURN NUMBER;
24 
25 Procedure Insert_OE_Drop_Ship_Source
26 ( P_Old_Line_ID                 In Number,
27   P_New_Line_ID                 In Number);
28 
29 Procedure Check_PO_Approved
30 ( p_application_id               IN   NUMBER
31 , p_entity_short_name            IN   VARCHAR2
32 , p_validation_entity_short_name IN   VARCHAR2
33 , p_validation_tmplt_short_name  IN   VARCHAR2
34 , p_record_set_tmplt_short_name  IN   VARCHAR2
35 , p_scope                        IN   VARCHAR2
36 , p_result                       OUT NOCOPY /* file.sql.39 change */  NUMBER
37 );
38 
39 FUNCTION Check_Req_PO_Cancelled
40 ( p_line_id        IN    NUMBER
41 , p_header_id      IN    NUMBER
42 ) RETURN BOOLEAN;
43 
44 Procedure OM_PO_Discrepancy_Exists
45 ( p_application_id               IN   NUMBER
46 , p_entity_short_name            IN   VARCHAR2
47 , p_validation_entity_short_name IN   VARCHAR2
48 , p_validation_tmplt_short_name  IN   VARCHAR2
49 , p_record_set_tmplt_short_name  IN   VARCHAR2
50 , p_scope                        IN   VARCHAR2
51 , p_result                       OUT NOCOPY /* file.sql.39 change */  NUMBER
52 );
53 
54 END OE_DS_PVT;