1 PACKAGE EGO_ITEM_WS_PVT AUTHID CURRENT_USER AS
2 /* $Header: EGOVIWSS.pls 120.1 2010/10/06 07:55:57 nendrapu noship $ */
3 /*==========================================================================+
4 | Copyright (c) 1993 Oracle Corporation Belmont, California, USA |
5 | All rights reserved. |
6 +===========================================================================+
7 | |
8 | File Name : EGOVIWSS.pls |
9 | DESCRIPTION : This file contains the procedures required for |
10 | Item Web service. |
11 | |
12 | |
13 +==========================================================================*/
14
15 ---------------------------------------------------------------
16 -- Global Variables and Constants --
17 ---------------------------------------------------------------
18 G_CURRENT_USER_ID NUMBER := FND_GLOBAL.User_Id;
19 G_CURRENT_LOGIN_ID NUMBER := FND_GLOBAL.Login_Id;
20
21
22 PROCEDURE POPULATE_AGS(sessionId IN NUMBER,
23 odisessionId IN NUMBER,
24 dataLevelId IN NUMBER
25 );
26
27 PROCEDURE POPULATE_GTIN_DETAILS(sessionId IN NUMBER,
28 odisessionId IN NUMBER
29 );
30
31 PROCEDURE POPULATE_Transaction_Attrs(sessionId IN NUMBER,
32 odisessionId IN NUMBER
33 );
34
35 PROCEDURE Invocation_Mode ( p_session_id IN NUMBER,
36 p_odi_session_id IN NUMBER,
37 p_search_str IN VARCHAR2,
38 x_mode OUT NOCOPY VARCHAR2,
39 x_batch_id OUT NOCOPY NUMBER );
40
41 PROCEDURE process_bom_explosions(p_session_id IN NUMBER,
42 p_odi_session_id IN NUMBER,
43 p_index IN NUMBER,
44 pk1_value IN VARCHAR2 ,
45 pk2_value IN varchar2,
46 pk3_value IN varchar2,
47 rev_date IN Date,
48 alternate_desg IN VARCHAR2 DEFAULT NULL,
49 levels_explode IN NUMBER DEFAULT 60,
50 explode_option IN NUMBER,
51 explode_std_bom IN VARCHAR2, -- Bug 8752314 : CMR Change
52 group_id OUT NOCOPY NUMBER,
53 x_error_code OUT NOCOPY VARCHAR2 ,
54 x_error_message OUT NOCOPY VARCHAR2
55 );
56
57 PROCEDURE Preprocess_Item_Input(p_session_id IN NUMBER,
58 p_odi_session_id IN NUMBER );
59
60 PROCEDURE process_configurations(p_session_id IN NUMBER,
61 p_odi_session_id IN NUMBER);
62
63 PROCEDURE process_non_batch_flow(p_session_id IN NUMBER,
64 p_odi_session_id IN NUMBER,
65 p_exists_inv_id IN NUMBER,
66 p_exists_inv_name IN NUMBER,
67 p_exists_org_id IN NUMBER,
68 p_exists_org_code IN NUMBER,
69 p_exists_rev_id IN NUMBER,
70 p_exists_revision IN NUMBER,
71 p_exists_rev_date IN NUMBER ,
72 p_mode OUT NOCOPY VARCHAR2
73 );
74
75 FUNCTION Validate_Item(p_session_id IN NUMBER,
76 p_odi_session_id IN NUMBER,
77 p_inv_id in number,
78 p_org_id in NUMBER ,
79 p_segment1 in varchar2,
80 p_segment2 in varchar2,
81 p_segment3 in varchar2,
82 p_segment4 in varchar2,
83 p_segment5 in varchar2,
84 p_segment6 in varchar2,
85 p_segment7 in varchar2,
86 p_segment8 in varchar2,
87 p_segment9 in varchar2,
88 p_segment10 in varchar2,
89 p_segment11 in varchar2,
90 p_segment12 in varchar2,
91 p_segment13 in varchar2,
92 p_segment14 in varchar2,
93 p_segment15 in varchar2,
94 p_segment16 in varchar2,
95 p_segment17 in varchar2,
96 p_segment18 in varchar2,
97 p_segment19 in varchar2,
98 p_segment20 in varchar2,
99 p_index in number,
100 p_inv_item_id OUT NOCOPY number
101 ) RETURN BOOLEAN;
102
103 function Validate_organization(p_session_id IN NUMBER,
104 p_odi_session_id IN NUMBER,
105 p_org_id in NUMBER ,
106 p_org_code IN VARCHAR2,
107 p_index in number,
108 p_organization_id OUT NOCOPY number
109 ) RETURN BOOLEAN;
110
111 function validate_revision_details(p_session_id IN NUMBER,
112 p_odi_session_id IN NUMBER,
113 p_inv_id IN NUMBER,
114 p_org_id IN NUMBER,
115 p_rev_id in NUMBER ,
116 p_revision IN varchar2,
117 p_rev_date IN DATE,
118 p_index in number,
119 p_revision_id OUT NOCOPY NUMBER ,
120 p_revision_date OUT NOCOPY DATE
121 ) RETURN BOOLEAN;
122
123
124 function validate_structure_name(p_session_id IN NUMBER,
125 p_odi_session_id IN NUMBER,
126 p_org_id IN NUMBER,
127 p_structure_name IN varchar2,
128 p_input_id IN NUMBER
129 ) RETURN BOOLEAN ;
130
131
132 PROCEDURE check_security(p_session_id IN NUMBER,
133 p_odi_session_id IN NUMBER,
134 p_priv_check IN VARCHAR2,
135 p_for_exploded_items IN VARCHAR2,
136 x_return_status OUT NOCOPY VARCHAR2
137 );
138
139 /* Bug 8659248 : Added the Below procedure for getting the security details of the
140 user who is publishing the Items */
141 PROCEDURE Init_Security_details(p_session_id IN NUMBER,
142 p_odi_session_id IN NUMBER,
143 p_return_status OUT NOCOPY VARCHAR2);
144
145
146 PROCEDURE POPULATE_SEGMENTS(p_session_id IN NUMBER,
147 p_odi_session_id IN NUMBER,
148 p_segment1 in varchar2,
149 p_segment2 in varchar2,
150 p_segment3 in varchar2,
151 p_segment4 in varchar2,
152 p_segment5 in varchar2,
153 p_segment6 in varchar2,
154 p_segment7 in varchar2,
155 p_segment8 in varchar2,
156 p_segment9 in varchar2,
157 p_segment10 in varchar2,
158 p_segment11 in varchar2,
159 p_segment12 in varchar2,
160 p_segment13 in varchar2,
161 p_segment14 in varchar2,
162 p_segment15 in varchar2,
163 p_segment16 in varchar2,
164 p_segment17 in varchar2,
165 p_segment18 in varchar2,
166 p_segment19 in varchar2,
167 p_segment20 in varchar2,
168 p_index in number );
169
170 PROCEDURE POPULATE_REVISION_DETAILS(p_session_id IN NUMBER,
171 p_odi_session_id IN NUMBER,
172 p_rev_id NUMBER,
173 p_revision VARCHAR,
174 p_rev_date DATE,
175 p_index NUMBER);
176
177 END EGO_ITEM_WS_PVT;