APPS.IGF_AP_ISIR_MATCHED_PKG dependencies on IGF_AP_ISIR_MATCHED_S
Line 32: UPDATE igf_ap_isir_matched set active_isir = 'N'
28: BEGIN
29: FOR l_isir in get_isir(x_isir_id,x_base_id)
30: LOOP
31: 32: UPDATE igf_ap_isir_matched set active_isir = 'N' 33: where row_id = l_isir.row_id;
34:
35: END LOOP;
36:
Line 1864: SELECT igf_ap_isir_matched_s.nextval INTO x_isir_id
1860: l_org_id igf_ap_isir_matched_all.org_id%TYPE := igf_aw_gen.get_org_id;
1861:
1862: BEGIN
1863: 1864: SELECT igf_ap_isir_matched_s.nextval INTO x_isir_id 1865: FROM dual;
1866:
1867:
1868: x_last_update_date := SYSDATE;