eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
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;