DBA Data[Home] [Help]

APPS.GCS_WF_NTF_PKG dependencies on GCS_CONS_ENG_RUN_DTLS

Line 101: FROM gcs_cons_eng_run_dtls gcerd,

97: l_category_code,
98: l_recipient,
99: -- Bug fix 5245250
100: l_seq
101: FROM gcs_cons_eng_run_dtls gcerd,
102: fem_entities_tl fet_cons,
103: fem_entities_tl fet_child,
104: fem_entities_tl fet_counter,
105: gcs_hierarchies_tl ght,

Line 592: UPDATE gcs_cons_eng_run_dtls

588: OPEN c_ntf_id(p_itemtype, p_itemkey);
589: FETCH c_ntf_id INTO l_ntf_id;
590: CLOSE c_ntf_id;
591:
592: UPDATE gcs_cons_eng_run_dtls
593: SET notification_id = l_ntf_id
594: WHERE run_detail_id = l_run_dtl_id;
595:
596: COMMIT;