APPS.IGF_AP_LG_TD_IMP dependencies on IGF_AP_TD_ITEM_INST

Line 305: FROM igf_ap_td_item_inst_v

301: CURSOR c_todo_dup(cp_base_id NUMBER,
302: cp_item_code VARCHAR2)
303: IS
304: SELECT item_sequence_number
305: FROM igf_ap_td_item_inst_v
306: WHERE base_id = cp_base_id
307: AND item_code = cp_item_code;
308:
309: l_todo_dup c_todo_dup%ROWTYPE;

Line 315: FROM igf_ap_td_item_inst

311: CURSOR c_get_rowid(cp_item_seq_number NUMBER,
312: cp_base_id NUMBER)
313: IS
314: SELECT ROWID ROW_ID
315: FROM igf_ap_td_item_inst
316: WHERE base_id = cp_base_id
317: AND item_sequence_number = cp_item_seq_number;
318:
319: l_get_rowid c_get_rowid%ROWTYPE;

Line 661: igf_ap_td_item_inst_pkg.delete_row(

657: l_get_rowid := NULL;
658: OPEN c_get_rowid(l_todo_dup.item_sequence_number,g_baseid_exists.base_id);
659: FETCH c_get_rowid INTO l_get_rowid;
660: CLOSE c_get_rowid;
661: igf_ap_td_item_inst_pkg.delete_row(
662: x_ROWID => l_get_rowid.ROW_ID
663: );
664: END IF;
665: -- museshad FA 140

Line 671: igf_ap_td_item_inst_pkg.insert_row(

667: IF l_item_system_todo_type_code = 'PREFLEND' AND l_get_persons.relationship_cd IS NOT NULL THEN
668: process_pref_lender(g_baseid_exists.base_id, l_get_persons.relationship_cd, l_clprl_id);
669: END IF;
670: -- museshad FA 140
671: igf_ap_td_item_inst_pkg.insert_row(
672: x_MODE => 'R',
673: x_BASE_ID => g_baseid_exists.base_id,
674: x_ROWID => lv_row_id,
675: x_ITEM_SEQUENCE_NUMBER => l_todo_number,

Line 797: FROM igf_ap_td_item_inst_all tdinst,

793: cp_person_id igf_ap_fa_base_rec_all.person_id%TYPE
794: )
795: IS
796: SELECT 1
797: FROM igf_ap_td_item_inst_all tdinst,
798: igf_ap_td_item_mst_all tdmst
799: WHERE tdinst.base_id = cp_base_id
800: AND tdinst.status IN ('INC','REQ','REC')
801: AND tdinst.required_for_application = 'Y'

Line 808: FROM igf_ap_td_item_inst_all tdinst,

804: AND tdmst.career_item = 'N'
805: AND ROWNUM < 2
806: UNION
807: SELECT 1
808: FROM igf_ap_td_item_inst_all tdinst,
809: igf_ap_td_item_mst_all tdmst,
810: igf_ap_fa_base_rec_all fa
811: WHERE tdinst.base_id = fa.base_id
812: AND tdinst.status IN ('INC','REQ','REC')