APPS.IGF_AP_LI_ISIR_IMP_PROC dependencies on IGF_AP_LI_ISIR_INTS

Line 501: igf_ap_li_isir_ints a

497: reject_override_k_flag,
498: rejected_status_change_flag,
499: verification_selection_flag
500: FROM
501: igf_ap_li_isir_ints a
502: WHERE
503: a.batch_num = p_batch_id AND
504: a.import_status_type IN ('U','R')
505: ORDER BY a.person_number;

Line 6270: UPDATE igf_ap_li_isir_ints

6266: fnd_message.set_name('IGF','IGF_AP_PE_NOT_EXIST');
6267: counter := counter+1;
6268: g_message_table(counter).msg_text:=fnd_message.get;
6269:
6270: UPDATE igf_ap_li_isir_ints
6271: SET IMPORT_STATUS_TYPE='E'
6272: WHERE ROWID = c_int_data_rec.ROW_ID ;
6273: END IF;
6274: END IF;

Line 6398: DELETE FROM igf_ap_li_isir_ints

6394: IF NVL(p_cps_import,'N') <> 'Y' THEN
6395: IF p_del_int ='Y' THEN
6396: --Check if the P_DEL_INT parameter is set to "Y"
6397: --If it is set to Y then Delete the Interface Record
6398: DELETE FROM igf_ap_li_isir_ints
6399: WHERE ROWID = c_int_data_rec.ROW_ID ;
6400: ELSE
6401: --Update the Legacy Interface Table column IMPORT_STATUS_FLAG with 'I' implying Imported
6402: UPDATE igf_ap_li_isir_ints

Line 6402: UPDATE igf_ap_li_isir_ints

6398: DELETE FROM igf_ap_li_isir_ints
6399: WHERE ROWID = c_int_data_rec.ROW_ID ;
6400: ELSE
6401: --Update the Legacy Interface Table column IMPORT_STATUS_FLAG with 'I' implying Imported
6402: UPDATE igf_ap_li_isir_ints
6403: SET IMPORT_STATUS_TYPE='I'
6404: WHERE ROWID = c_int_data_rec.ROW_ID ;
6405: END IF;
6406: ELSE -- CPS IMPORT

Line 6414: UPDATE igf_ap_li_isir_ints

6410: END IF;
6411: END IF;
6412:
6413: IF l_valid_for_dml <> 'Y' AND NVL(p_cps_import,'N') <> 'Y' THEN
6414: UPDATE igf_ap_li_isir_ints
6415: SET IMPORT_STATUS_TYPE='E'
6416: WHERE ROWID = c_int_data_rec.ROW_ID ;
6417: END IF;
6418: