APPS.IGF_AP_ISIR_GEN_PKG dependencies on IGF_AP_TD_ITEM_INST

Line 717: FROM igf_ap_td_item_mst im, igf_ap_td_item_inst ii

713:
714: CURSOR todo_items_for_isir_cur(cp_base_id NUMBER) IS
715: SELECT ii.rowid,
716: ii.*
717: FROM igf_ap_td_item_mst im, igf_ap_td_item_inst ii
718: WHERE ii.base_id = cp_base_id
719: AND im.todo_number = ii.item_sequence_number
720: AND im.system_todo_type_code = 'ISIR'; -- for ISIR type only
721:

Line 1823: igf_ap_td_item_inst_pkg.update_row (

1819: CLOSE get_isir;
1820:
1821: -- update the status to Requested
1822: FOR todo_items_for_isir_rec IN todo_items_for_isir_cur(p_base_id) LOOP
1823: igf_ap_td_item_inst_pkg.update_row (
1824: x_rowid => todo_items_for_isir_rec.rowid ,
1825: x_base_id => p_base_id ,
1826: x_item_sequence_number => todo_items_for_isir_rec.item_sequence_number,
1827: x_status => 'REQ' ,