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.

APPS.EGO_PUB_WS_AG dependencies on EGO_PUB_WS_UTIL

Line 87: EGO_PUB_WS_UTIL.Populate_Input_Identifier(p_session_id => p_session_id,

83: WHERE session_id = p_session_id;
84:
85: IF (l_ag_id IS NOT NULL) THEN
86:
87: EGO_PUB_WS_UTIL.Populate_Input_Identifier(p_session_id => p_session_id,
88: p_input_id => l_index,
89: p_param_name => 'AttributeGroupId',
90: p_param_value => l_ag_id
91: );

Line 93: EGO_PUB_WS_UTIL.Log_Error(p_session_id => p_session_id,

89: p_param_name => 'AttributeGroupId',
90: p_param_value => l_ag_id
91: );
92:
93: EGO_PUB_WS_UTIL.Log_Error(p_session_id => p_session_id,
94: p_input_id => l_index,
95: p_err_code => 'EGO_INVALID_AG_ID',
96: p_err_message => 'Invalid Attribute Group Id');
97:

Line 100: EGO_PUB_WS_UTIL.Populate_Input_Identifier(p_session_id => p_session_id,

96: p_err_message => 'Invalid Attribute Group Id');
97:
98: ELSE
99:
100: EGO_PUB_WS_UTIL.Populate_Input_Identifier(p_session_id => p_session_id,
101: p_input_id => l_index,
102: p_param_name => 'AttributeGroupName',
103: p_param_value => l_ag_name
104: );

Line 106: EGO_PUB_WS_UTIL.Log_Error(p_session_id => p_session_id,

102: p_param_name => 'AttributeGroupName',
103: p_param_value => l_ag_name
104: );
105:
106: EGO_PUB_WS_UTIL.Log_Error(p_session_id => p_session_id,
107: p_input_id => l_index,
108: p_err_code => 'EGO_INVALID_AG_NAME',
109: p_err_message => 'Invalid Attribute Group Name');
110:

Line 132: l_xpath_expr EGO_PUB_WS_UTIL.xpath_expr_array_type;

128: l_config_option VARCHAR2(100);
129: l_language_search_str VARCHAR2(1000);
130:
131: --array to store XML path expressions to retrieve single-value params
132: l_xpath_expr EGO_PUB_WS_UTIL.xpath_expr_array_type;
133:
134: --array to store single_value parameter names
135: l_param_names EGO_PUB_WS_UTIL.parameter_name_array_type;
136:

Line 135: l_param_names EGO_PUB_WS_UTIL.parameter_name_array_type;

131: --array to store XML path expressions to retrieve single-value params
132: l_xpath_expr EGO_PUB_WS_UTIL.xpath_expr_array_type;
133:
134: --array to store single_value parameter names
135: l_param_names EGO_PUB_WS_UTIL.parameter_name_array_type;
136:
137: l_param_value VARCHAR2(10);
138:
139: l_param_names_count NUMBER;

Line 144: -- in EGO_PUB_WS_UTIL - Get_Numeric_Param_Value, Get_Char_Param_Value,

140:
141: BEGIN
142: --get invocation mode for the web service
143: -- replacing following SELECT query with newly added function
144: -- in EGO_PUB_WS_UTIL - Get_Numeric_Param_Value, Get_Char_Param_Value,
145: -- Get_Date_Param_Value functions
146:
147: /*SELECT CHAR_VALUE
148: INTO l_mode

Line 155: l_mode := EGO_PUB_WS_UTIL.Get_Char_Param_Value(p_session_id, 'MODE', NULL, NULL);

151: AND session_id = p_session_id;
152: */
153: --insert into EGO.tr_temp VALUES('create param P_session_id :', p_session_id);
154:
155: l_mode := EGO_PUB_WS_UTIL.Get_Char_Param_Value(p_session_id, 'MODE', NULL, NULL);
156:
157: --insert into EGO.tr_temp VALUES('create param P_mode :', l_mode);
158:
159: --get web service name

Line 170: -- in EGO_PUB_WS_UTIL - Get_Numeric_Param_Value, Get_Char_Param_Value,

166:
167: IF l_mode = 'BATCH' THEN
168:
169: -- replacing following SELECT query with newly added function
170: -- in EGO_PUB_WS_UTIL - Get_Numeric_Param_Value, Get_Char_Param_Value,
171: -- Get_Date_Param_Value functions
172:
173: /*SELECT numeric_value
174: INTO l_batch_id

Line 180: l_batch_id := EGO_PUB_WS_UTIL.Get_Numeric_Param_Value(p_session_id, 'BATCH_ID', NULL, NULL);

176: WHERE PARAMETER_NAME = 'BATCH_ID'
177: AND session_id = p_session_id;
178: */
179:
180: l_batch_id := EGO_PUB_WS_UTIL.Get_Numeric_Param_Value(p_session_id, 'BATCH_ID', NULL, NULL);
181:
182: -- default configuration parameters to 'Y' for l_params_names
183:
184: --initialize arrays of parameter names

Line 185: l_param_names := EGO_PUB_WS_UTIL.parameter_name_array_type();

181:
182: -- default configuration parameters to 'Y' for l_params_names
183:
184: --initialize arrays of parameter names
185: l_param_names := EGO_PUB_WS_UTIL.parameter_name_array_type();
186:
187: EGO_PUB_WS_UTIL.Get_Parameter_Names(l_web_service_name, l_param_names);
188:
189: l_param_names_count := l_param_names.COUNT;

Line 187: EGO_PUB_WS_UTIL.Get_Parameter_Names(l_web_service_name, l_param_names);

183:
184: --initialize arrays of parameter names
185: l_param_names := EGO_PUB_WS_UTIL.parameter_name_array_type();
186:
187: EGO_PUB_WS_UTIL.Get_Parameter_Names(l_web_service_name, l_param_names);
188:
189: l_param_names_count := l_param_names.COUNT;
190:
191: FOR position IN 1..l_param_names.COUNT

Line 223: WHERE PARAMETER_NAME = EGO_PUB_WS_UTIL.G_SYNC_PARAM

219:
220: SELECT CHAR_VALUE
221: INTO l_param_value
222: FROM EGO_PUB_BAT_PARAMS_B
223: WHERE PARAMETER_NAME = EGO_PUB_WS_UTIL.G_SYNC_PARAM
224: AND TYPE_ID = l_batch_id;
225:
226: IF l_param_value = 'PUBLISH' THEN
227: l_param_value := 'N';

Line 254: WHERE PARAMETER_NAME = EGO_PUB_WS_UTIL.G_TRIGGER_IMPORT_PARAM

250:
251: SELECT CHAR_VALUE
252: INTO l_param_value
253: FROM EGO_PUB_BAT_PARAMS_B
254: WHERE PARAMETER_NAME = EGO_PUB_WS_UTIL.G_TRIGGER_IMPORT_PARAM
255: AND TYPE_ID = l_batch_id;
256:
257: INSERT INTO EGO_PUB_WS_CONFIG ( session_id,
258: odi_session_id,

Line 283: l_param_names := EGO_PUB_WS_UTIL.parameter_name_array_type();

279: -- AND STORE THEM IN TABLE EGO_PUB_WS_CONFIG
280: --
281:
282: --initialize arrays of parameter names
283: l_param_names := EGO_PUB_WS_UTIL.parameter_name_array_type();
284: EGO_PUB_WS_UTIL.Get_Parameter_Names(l_web_service_name, l_param_names);
285:
286: l_xpath_expr := EGO_PUB_WS_UTIL.xpath_expr_array_type();
287: EGO_PUB_WS_UTIL.Get_Xpath_Expr(l_web_service_name, l_xpath_expr);

Line 284: EGO_PUB_WS_UTIL.Get_Parameter_Names(l_web_service_name, l_param_names);

280: --
281:
282: --initialize arrays of parameter names
283: l_param_names := EGO_PUB_WS_UTIL.parameter_name_array_type();
284: EGO_PUB_WS_UTIL.Get_Parameter_Names(l_web_service_name, l_param_names);
285:
286: l_xpath_expr := EGO_PUB_WS_UTIL.xpath_expr_array_type();
287: EGO_PUB_WS_UTIL.Get_Xpath_Expr(l_web_service_name, l_xpath_expr);
288:

Line 286: l_xpath_expr := EGO_PUB_WS_UTIL.xpath_expr_array_type();

282: --initialize arrays of parameter names
283: l_param_names := EGO_PUB_WS_UTIL.parameter_name_array_type();
284: EGO_PUB_WS_UTIL.Get_Parameter_Names(l_web_service_name, l_param_names);
285:
286: l_xpath_expr := EGO_PUB_WS_UTIL.xpath_expr_array_type();
287: EGO_PUB_WS_UTIL.Get_Xpath_Expr(l_web_service_name, l_xpath_expr);
288:
289: --retrieve all single-value parameters of interest from XML
290: --and store them in table EGO_PUB_WS_CONFIG

Line 287: EGO_PUB_WS_UTIL.Get_Xpath_Expr(l_web_service_name, l_xpath_expr);

283: l_param_names := EGO_PUB_WS_UTIL.parameter_name_array_type();
284: EGO_PUB_WS_UTIL.Get_Parameter_Names(l_web_service_name, l_param_names);
285:
286: l_xpath_expr := EGO_PUB_WS_UTIL.xpath_expr_array_type();
287: EGO_PUB_WS_UTIL.Get_Xpath_Expr(l_web_service_name, l_xpath_expr);
288:
289: --retrieve all single-value parameters of interest from XML
290: --and store them in table EGO_PUB_WS_CONFIG
291:

Line 299: l_config_option := upper(EGO_PUB_WS_UTIL.Get_ODI_Input_Parameter(p_session_id, l_xpath_expr(position)));

295:
296: FOR position IN 1..l_param_names.COUNT
297: LOOP
298:
299: l_config_option := upper(EGO_PUB_WS_UTIL.Get_ODI_Input_Parameter(p_session_id, l_xpath_expr(position)));
300:
301: --insert into EGO.tr_temp VALUES('create param l_config_option :', l_config_option);
302: --if parameter is not provided, assume a default value of 'Y' (Yes)
303: --commit;

Line 326: EGO_PUB_WS_UTIL.Create_Fnd_Security(p_session_id,

322: END IF;
323:
324: END LOOP;
325: END IF;
326: EGO_PUB_WS_UTIL.Create_Fnd_Security(p_session_id,
327: l_mode,
328: l_batch_id,
329: l_web_service_name
330: );

Line 338: l_language_search_str := EGO_PUB_WS_UTIL.Get_Language_Search_Str(l_web_service_name);

334: --
335:
336:
337: --RETRIEVING LIST OF LANGUAGES
338: l_language_search_str := EGO_PUB_WS_UTIL.Get_Language_Search_Str(l_web_service_name);
339:
340: --Inserts language options in Config table
341: EGO_PUB_WS_UTIL.Config_Languages(p_session_id,
342: l_language_search_str,

Line 341: EGO_PUB_WS_UTIL.Config_Languages(p_session_id,

337: --RETRIEVING LIST OF LANGUAGES
338: l_language_search_str := EGO_PUB_WS_UTIL.Get_Language_Search_Str(l_web_service_name);
339:
340: --Inserts language options in Config table
341: EGO_PUB_WS_UTIL.Config_Languages(p_session_id,
342: l_language_search_str,
343: l_web_service_name);
344:
345: EXCEPTION

Line 395: -- in EGO_PUB_WS_UTIL - Get_Numeric_Param_Value, Get_Char_Param_Value,

391: BEGIN
392:
393: --identify web service invocation mode
394: -- replacing following SELECT query with newly added function
395: -- in EGO_PUB_WS_UTIL - Get_Numeric_Param_Value, Get_Char_Param_Value,
396: -- Get_Date_Param_Value functions
397:
398: /*SELECT char_value
399: INTO l_mode

Line 407: l_mode := EGO_PUB_WS_UTIL.Get_Char_Param_Value(p_session_id, 'MODE', NULL, NULL);

403: */
404:
405: --insert into EGO.tr_temp values('create input entities p_session_id :', p_session_id);
406:
407: l_mode := EGO_PUB_WS_UTIL.Get_Char_Param_Value(p_session_id, 'MODE', NULL, NULL);
408:
409: --insert into EGO.tr_temp values('create input entities l_mode :', l_mode);
410: --commit;
411:

Line 418: -- in EGO_PUB_WS_UTIL - Get_Numeric_Param_Value, Get_Char_Param_Value,

414: CASE WHEN l_mode = 'BATCH' THEN
415:
416: --retrieving batchId from ego_pub_ws_config table
417: -- replacing following SELECT query with newly added function
418: -- in EGO_PUB_WS_UTIL - Get_Numeric_Param_Value, Get_Char_Param_Value,
419: -- Get_Date_Param_Value functions
420: /*SELECT NUMERIC_VALUE
421: INTO l_batch_id
422: FROM EGO_PUB_WS_CONFIG

Line 427: l_batch_id := EGO_PUB_WS_UTIL.Get_Numeric_Param_Value(p_session_id,'BATCH_ID', NULL, NULL);

423: WHERE SESSION_ID = p_session_id
424: AND PARAMETER_NAME = 'BATCH_ID';
425: */
426:
427: l_batch_id := EGO_PUB_WS_UTIL.Get_Numeric_Param_Value(p_session_id,'BATCH_ID', NULL, NULL);
428:
429: --retrieving all end-attributegroups batch from publication framework entity tables
430: --and inserting data into ODI metadata input table
431:

Line 788: EGO_PUB_WS_UTIL.Init_Security(p_session_id, l_web_service_name);

784: FROM EGO_PUB_WS_PARAMS
785: WHERE SESSION_ID = p_session_id;
786:
787: --Initialize FND security
788: EGO_PUB_WS_UTIL.Init_Security(p_session_id, l_web_service_name);
789:
790: --Check on the sync privilege for the end-attributegroup.
791: --If end-attributegroup has no sync privilege, then remove end-attributegroup
792: --from EGO_PUB_WS_ENTITIES table.

Line 1025: l_mode := EGO_PUB_WS_UTIL.Get_Char_Param_Value(p_session_id, 'MODE', NULL, NULL);

1021:
1022: --EXPLODE VS FOR ALL END CVSs
1023: --calling EGO_PUB_WS_VS.Explode_Value_Sets procedure.
1024:
1025: l_mode := EGO_PUB_WS_UTIL.Get_Char_Param_Value(p_session_id, 'MODE', NULL, NULL);
1026:
1027: IF l_mode = 'LIST' THEN
1028: l_param_cvs := EGO_PUB_WS_UTIL.Get_Char_Param_Value(p_session_id, 'CHILD_VALUESETS', NULL, NULL);
1029: ELSIF l_mode = 'BATCH' THEN

Line 1028: l_param_cvs := EGO_PUB_WS_UTIL.Get_Char_Param_Value(p_session_id, 'CHILD_VALUESETS', NULL, NULL);

1024:
1025: l_mode := EGO_PUB_WS_UTIL.Get_Char_Param_Value(p_session_id, 'MODE', NULL, NULL);
1026:
1027: IF l_mode = 'LIST' THEN
1028: l_param_cvs := EGO_PUB_WS_UTIL.Get_Char_Param_Value(p_session_id, 'CHILD_VALUESETS', NULL, NULL);
1029: ELSIF l_mode = 'BATCH' THEN
1030: l_batch_id := EGO_PUB_WS_UTIL.Get_Numeric_Param_Value(p_session_id,'BATCH_ID', NULL, NULL);
1031: l_param_cvs := EGO_PUB_WS_UTIL.Get_Char_Param_Value(p_session_id, 'CHILD_VALUESETS', NULL, NULL);
1032: END IF;

Line 1030: l_batch_id := EGO_PUB_WS_UTIL.Get_Numeric_Param_Value(p_session_id,'BATCH_ID', NULL, NULL);

1026:
1027: IF l_mode = 'LIST' THEN
1028: l_param_cvs := EGO_PUB_WS_UTIL.Get_Char_Param_Value(p_session_id, 'CHILD_VALUESETS', NULL, NULL);
1029: ELSIF l_mode = 'BATCH' THEN
1030: l_batch_id := EGO_PUB_WS_UTIL.Get_Numeric_Param_Value(p_session_id,'BATCH_ID', NULL, NULL);
1031: l_param_cvs := EGO_PUB_WS_UTIL.Get_Char_Param_Value(p_session_id, 'CHILD_VALUESETS', NULL, NULL);
1032: END IF;
1033:
1034: IF l_param_cvs = 'Y' THEN

Line 1031: l_param_cvs := EGO_PUB_WS_UTIL.Get_Char_Param_Value(p_session_id, 'CHILD_VALUESETS', NULL, NULL);

1027: IF l_mode = 'LIST' THEN
1028: l_param_cvs := EGO_PUB_WS_UTIL.Get_Char_Param_Value(p_session_id, 'CHILD_VALUESETS', NULL, NULL);
1029: ELSIF l_mode = 'BATCH' THEN
1030: l_batch_id := EGO_PUB_WS_UTIL.Get_Numeric_Param_Value(p_session_id,'BATCH_ID', NULL, NULL);
1031: l_param_cvs := EGO_PUB_WS_UTIL.Get_Char_Param_Value(p_session_id, 'CHILD_VALUESETS', NULL, NULL);
1032: END IF;
1033:
1034: IF l_param_cvs = 'Y' THEN
1035: EGO_PUB_WS_VS.Explode_Value_Set(p_session_id);

Line 1175: l_mode := EGO_PUB_WS_UTIL.Get_Char_Param_Value(p_session_id, 'MODE', NULL, NULL);

1171: */
1172:
1173: --Explode Attribute Group for all end-valuesets selected
1174:
1175: l_mode := EGO_PUB_WS_UTIL.Get_Char_Param_Value(p_session_id, 'MODE', NULL, NULL);
1176:
1177: IF l_mode = 'LIST' THEN
1178: l_param_vs := EGO_PUB_WS_UTIL.Get_Char_Param_Value(p_session_id, 'VALUESETS', NULL, NULL);
1179: ELSIF l_mode = 'BATCH' THEN

Line 1178: l_param_vs := EGO_PUB_WS_UTIL.Get_Char_Param_Value(p_session_id, 'VALUESETS', NULL, NULL);

1174:
1175: l_mode := EGO_PUB_WS_UTIL.Get_Char_Param_Value(p_session_id, 'MODE', NULL, NULL);
1176:
1177: IF l_mode = 'LIST' THEN
1178: l_param_vs := EGO_PUB_WS_UTIL.Get_Char_Param_Value(p_session_id, 'VALUESETS', NULL, NULL);
1179: ELSIF l_mode = 'BATCH' THEN
1180: l_batch_id := EGO_PUB_WS_UTIL.Get_Numeric_Param_Value(p_session_id,'BATCH_ID', NULL, NULL);
1181: l_param_vs := EGO_PUB_WS_UTIL.Get_Char_Param_Value(p_session_id, 'VALUESETS', NULL, NULL);
1182: END IF;

Line 1180: l_batch_id := EGO_PUB_WS_UTIL.Get_Numeric_Param_Value(p_session_id,'BATCH_ID', NULL, NULL);

1176:
1177: IF l_mode = 'LIST' THEN
1178: l_param_vs := EGO_PUB_WS_UTIL.Get_Char_Param_Value(p_session_id, 'VALUESETS', NULL, NULL);
1179: ELSIF l_mode = 'BATCH' THEN
1180: l_batch_id := EGO_PUB_WS_UTIL.Get_Numeric_Param_Value(p_session_id,'BATCH_ID', NULL, NULL);
1181: l_param_vs := EGO_PUB_WS_UTIL.Get_Char_Param_Value(p_session_id, 'VALUESETS', NULL, NULL);
1182: END IF;
1183:
1184: IF l_param_vs = 'Y' THEN

Line 1181: l_param_vs := EGO_PUB_WS_UTIL.Get_Char_Param_Value(p_session_id, 'VALUESETS', NULL, NULL);

1177: IF l_mode = 'LIST' THEN
1178: l_param_vs := EGO_PUB_WS_UTIL.Get_Char_Param_Value(p_session_id, 'VALUESETS', NULL, NULL);
1179: ELSIF l_mode = 'BATCH' THEN
1180: l_batch_id := EGO_PUB_WS_UTIL.Get_Numeric_Param_Value(p_session_id,'BATCH_ID', NULL, NULL);
1181: l_param_vs := EGO_PUB_WS_UTIL.Get_Char_Param_Value(p_session_id, 'VALUESETS', NULL, NULL);
1182: END IF;
1183:
1184: IF l_param_vs = 'Y' THEN
1185: Explode_Attribute_Group(p_session_id);