[Home] [Help]
PACKAGE: APPS.OE_ELECMSGS_PVT
Source
1 PACKAGE OE_ELECMSGS_PVT AS
2 /* $Header: OEXVELMS.pls 120.2 2005/09/15 04:27:04 kmuruges ship $ */
3
4 G_PKG_NAME VARCHAR2(15) := 'OE_ELECMSGS_PVT';
5
6 Type Elec_Msgs_Summary_Type IS RECORD
7 ( order_source_id number,
8 orig_sys_document_Ref varchar2(50),
9 sold_to_org_id number,
10 order_number number,
11 order_type_id number,
12 num_msgs number,
13 creation_date date,
14 last_update_date date,
15 last_transaction_type varchar2(30),
16 last_transaction_message varchar2(2000),
17 last_transaction_status varchar2(240),
18 org_id number);
19
20 Type Elec_Msgs_Summary_Tbl IS table Of Elec_Msgs_Summary_Type index by binary_integer;
21
22 PROCEDURE do_query (p_elec_msgs_tbl IN OUT NOCOPY /* file.sql.39 change */ Elec_Msgs_Summary_Tbl,
23 p_order_source_id IN NUMBER,
24 p_orig_sys_document_ref IN VARCHAR2,
25 p_sold_to_org_id IN NUMBER,
26 p_transaction_type IN VARCHAR2,
27 p_start_date_from IN DATE,
28 p_start_date_to IN DATE,
29 p_update_date_from IN DATE,
30 p_update_date_to IN DATE,
31 p_message_status_code IN VARCHAR2
32 );
33
34 PROCEDURE Create_History_Entry (
35 p_order_source_id IN NUMBER,
36 p_sold_to_org_id IN NUMBER,
37 p_orig_sys_document_ref IN VARCHAR2,
38 p_transaction_type IN VARCHAR2,
39 p_document_id IN NUMBER,
40 p_parent_document_id IN NUMBER DEFAULT NULL,
41 p_org_id IN NUMBER DEFAULT NULL,
42 p_change_sequence IN VARCHAR2 DEFAULT NULL,
43 p_itemtype IN VARCHAR2 DEFAULT NULL,
44 p_itemkey IN VARCHAR2 DEFAULT NULL,
45 p_order_number IN NUMBER DEFAULT NULL,
46 p_order_type_id IN NUMBER DEFAULT NULL,
47 p_status IN VARCHAR2 DEFAULT NULL,
48 p_message_text IN VARCHAR2 DEFAULT NULL,
49 p_request_id IN NUMBER DEFAULT NULL,
50 p_header_id IN NUMBER DEFAULT NULL,
51 p_document_disposition IN VARCHAR2 DEFAULT NULL,
52 p_last_update_itemkey IN VARCHAR2 DEFAULT NULL,
53 x_return_status OUT NOCOPY VARCHAR2);
54
55 PROCEDURE Update_History_Entry (
56 p_order_source_id IN NUMBER,
57 p_sold_to_org_id IN NUMBER,
58 p_orig_sys_document_ref IN VARCHAR2,
59 p_transaction_type IN VARCHAR2,
60 p_document_id IN NUMBER,
61 p_parent_document_id IN NUMBER DEFAULT NULL,
62 p_org_id IN NUMBER DEFAULT NULL,
63 p_change_sequence IN VARCHAR2 DEFAULT NULL,
64 p_itemtype IN VARCHAR2 DEFAULT NULL,
65 p_itemkey IN VARCHAR2 DEFAULT NULL,
66 p_order_number IN NUMBER DEFAULT NULL,
67 p_order_type_id IN NUMBER DEFAULT NULL,
68 p_status IN VARCHAR2 DEFAULT NULL,
69 p_message_text IN VARCHAR2 DEFAULT NULL,
70 p_request_id IN NUMBER DEFAULT NULL,
71 p_header_id IN NUMBER DEFAULT NULL,
72 p_document_disposition IN VARCHAR2 DEFAULT NULL,
73 p_last_update_itemkey IN VARCHAR2 DEFAULT NULL,
74 x_return_status OUT NOCOPY VARCHAR2);
75
76 FUNCTION Find_History_Entry (
77 p_order_source_id IN NUMBER,
78 p_orig_sys_document_ref IN VARCHAR2,
79 p_sold_to_org_id IN NUMBER,
80 p_transaction_type IN VARCHAR2,
81 p_document_id IN NUMBER,
82 x_last_itemkey OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
83 x_last_request_id OUT NOCOPY /* file.sql.39 change */ NUMBER)
84 RETURN BOOLEAN;
85
86 FUNCTION Find_Parent_Document_Id (
87 p_order_source_id IN NUMBER,
88 p_orig_sys_document_ref IN VARCHAR2,
89 p_sold_to_org_id IN NUMBER,
90 p_org_id IN NUMBER)
91 RETURN NUMBER;
92
93 PROCEDURE Open_Interface_Purge_Conc_Pgm
94 ( errbuf OUT NOCOPY /* file.sql.39 change */ VARCHAR,
95 retcode OUT NOCOPY /* file.sql.39 change */ NUMBER,
96 p_operating_unit IN NUMBER DEFAULT NULL,
97 p_view_name IN VARCHAR2,
98 -- p_sold_to_org_id IN NUMBER,
99 p_customer_number IN NUMBER,
100 p_order_source_id IN NUMBER,
101 p_default_org_id IN NUMBER DEFAULT NULL,
102 p_process_null_org_id IN VARCHAR2 DEFAULT NULL,
103 p_orig_sys_document_ref_from IN VARCHAR2,
104 p_orig_sys_document_ref_to IN VARCHAR2,
105 p_purge_child_tables IN VARCHAR2 DEFAULT NULL
106 );
107
108 PROCEDURE OEEM_SELECTOR
109 ( p_itemtype in varchar2,
110 p_itemkey in varchar2,
111 p_actid in number,
112 p_funcmode in varchar2,
113 p_x_result in out NOCOPY /* file.sql.39 change */ varchar2
114 );
115
116 PROCEDURE Create_Or_Update_Hist_WF (
117 p_itemtype IN VARCHAR2,
118 p_itemkey IN VARCHAR2,
119 p_actid IN NUMBER,
120 p_funcmode IN VARCHAR2,
121 p_x_result IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
122
123 PROCEDURE Initialize_EM_Access_List (X_Access_List OUT NOCOPY OE_GLOBALS.ACCESS_LIST);
124
125 PROCEDURE Add_Access(Function_Name VARCHAR2);
126
127 END OE_ELECMSGS_PVT;