APPS.EGO_POST_PROCESS_MESSAGE_PVT dependencies on EGO_UCCNET_ADD_CIC_INFO

Line 85: EGO_UCCNET_ADD_CIC_INFO euaci,

81: ) AS ITEM_RESPONSE_TAG
82: FROM
83: FND_LOOKUP_VALUES corrective_action_lkup,
84: FND_LOOKUP_VALUES status_lkup,
85: EGO_UCCNET_ADD_CIC_INFO euaci,
86: MTL_ITEM_BULKLOAD_RECS mibr
87: WHERE
88: corrective_action_lkup.LANGUAGE (+) = c_language_code
89: AND corrective_action_lkup.ENABLED_FLAG (+) = 'Y'

Line 399: UPDATE EGO_UCCNET_ADD_CIC_INFO

395: mibr.BUNDLE_ID = selected_bundles.BUNDLE_ID
396: AND selected_bundles.RN BETWEEN p_start_index AND ( p_start_index + p_bundles_window_size - 1 )
397: AND mibr.BUNDLE_COLLECTION_ID = TO_NUMBER ( p_pk1_value ) );
398:
399: UPDATE EGO_UCCNET_ADD_CIC_INFO
400: SET MESSAGE_SENT_FLAG = 'Y'
401: WHERE MESSAGE_SENT_FLAG = 'N'
402: AND LAST_UPDATE_DATE = TO_DATE ( p_last_update_date, EGO_POST_PROCESS_MESSAGE_PVT.G_DATE_FORMAT )
403: AND ( CLN_ID ) IN

Line 454: UPDATE EGO_UCCNET_ADD_CIC_INFO

450: mibr.BUNDLE_ID = selected_bundles.BUNDLE_ID
451: AND selected_bundles.RN BETWEEN p_start_index AND ( p_start_index + p_bundles_window_size - 1 )
452: AND mibr.BUNDLE_COLLECTION_ID = TO_NUMBER ( p_pk1_value ) );
453:
454: UPDATE EGO_UCCNET_ADD_CIC_INFO
455: SET MESSAGE_SENT_FLAG = 'Y'
456: WHERE MESSAGE_SENT_FLAG = 'N'
457: AND LAST_UPDATE_DATE = TO_DATE ( p_last_update_date, EGO_POST_PROCESS_MESSAGE_PVT.G_DATE_FORMAT )
458: AND ( CLN_ID, SOURCE_SYSTEM_ID, SOURCE_SYSTEM_REFERENCE ) IN

Line 560: INSERT INTO EGO_UCCNET_ADD_CIC_INFO

556: WHERE
557: CLN_ID = TO_NUMBER( p_bundle_id_tbl(i) ) ;
558:
559: -- insert the rows for all the items in the bundle with given corrective info
560: INSERT INTO EGO_UCCNET_ADD_CIC_INFO
561: (
562: CLN_ID
563: , SOURCE_SYSTEM_ID
564: , SOURCE_SYSTEM_REFERENCE

Line 610: INSERT INTO EGO_UCCNET_ADD_CIC_INFO

606: SOURCE_SYSTEM_REFERENCE = p_source_system_ref_tbl(i)
607: AND SOURCE_SYSTEM_ID = TO_NUMBER( p_source_system_id_tbl(i) )
608: AND CLN_ID = TO_NUMBER( p_bundle_id_tbl(i) );
609:
610: INSERT INTO EGO_UCCNET_ADD_CIC_INFO
611: (
612: CLN_ID
613: , SOURCE_SYSTEM_ID
614: , SOURCE_SYSTEM_REFERENCE