APPS.EGO_PUB_WS_AG dependencies on EGO_PUB_BAT_PARAMS_B

Line 218: -- write 'SYNC' param value from EGO_PUB_BAT_PARAMS_B into EGO_PUB_WS_CONFIG table

214:
215: END IF;
216: END LOOP;
217:
218: -- write 'SYNC' param value from EGO_PUB_BAT_PARAMS_B into EGO_PUB_WS_CONFIG table
219:
220: SELECT CHAR_VALUE
221: INTO l_param_value
222: FROM EGO_PUB_BAT_PARAMS_B

Line 222: FROM EGO_PUB_BAT_PARAMS_B

218: -- write 'SYNC' param value from EGO_PUB_BAT_PARAMS_B into EGO_PUB_WS_CONFIG table
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

Line 249: -- write 'TRIGGER_IMPORT' param value from EGO_PUB_BAT_PARAMS_B into EGO_PUB_WS_CONFIG table

245: sysdate,
246: 0,
247: l_web_service_name);
248:
249: -- write 'TRIGGER_IMPORT' param value from EGO_PUB_BAT_PARAMS_B into EGO_PUB_WS_CONFIG table
250:
251: SELECT CHAR_VALUE
252: INTO l_param_value
253: FROM EGO_PUB_BAT_PARAMS_B

Line 253: FROM EGO_PUB_BAT_PARAMS_B

249: -- write 'TRIGGER_IMPORT' param value from EGO_PUB_BAT_PARAMS_B into EGO_PUB_WS_CONFIG table
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,