DBA Data[Home] [Help]

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;