APPS.IGC_CC_OPN_UPD_GET_LNK_PUB dependencies on IGC_CC_HEADERS_ALL

Line 2689: UPDATE igc_cc_headers_all ICH

2685:
2686: l_itemkey := TO_CHAR(l_cc_header_id) || '-' || l_seq;
2687: l_itemtype := 'CCAPPWF';
2688:
2689: UPDATE igc_cc_headers_all ICH
2690: SET ICH.cc_ctrl_status = l_new_ctrl_status,
2691: ICH.cc_apprvl_status = l_new_apprvl_status,
2692: ICH.wf_item_type = 'CCAPPWF',
2693: ICH.wf_item_key = l_itemkey

Line 2887: UPDATE igc_cc_headers_all ICH

2883: g_debug_msg := 'CC Update APi Open, Close, On Hold Actions begins here ...';
2884: Output_Debug( l_full_path,p_debug_msg => g_debug_msg);
2885: END IF;
2886:
2887: UPDATE igc_cc_headers_all ICH
2888: SET ICH.cc_ctrl_status = l_new_ctrl_status
2889: WHERE ICH.cc_header_id = l_cc_header_id
2890: AND ICH.cc_num = l_cc_header_rec.cc_num
2891: AND ICH.set_of_books_id = l_cc_header_rec.set_of_books_id

Line 3514: UPDATE igc_cc_headers_all ICH

3510: INTO l_cc_ref_num;
3511:
3512: IF (c_check_dup_ref_num%NOTFOUND) THEN
3513:
3514: UPDATE igc_cc_headers_all ICH
3515: SET ICH.cc_ref_num = p_cc_ref_num
3516: WHERE ICH.cc_header_id = l_cc_header_id
3517: AND ICH.cc_num = p_cc_num
3518: AND ICH.set_of_books_id = p_set_of_books_id