APPS.IGF_AP_MK_ISIR_ACT_PKG dependencies on IGF_AP_LI_ISIR_ACT_INTS

Line 17: TYPE PerTab IS TABLE OF igf_ap_li_isir_act_ints.person_number%TYPE

13:
14: g_log_tab LogTab;
15:
16: -- The PL/SQL table for storing the duplicate person number
17: TYPE PerTab IS TABLE OF igf_ap_li_isir_act_ints.person_number%TYPE
18: index by binary_integer;
19:
20: g_per_tab PerTab;
21:

Line 247: FROM igf_ap_li_isir_act_ints A

243: A.transaction_num_txt transaction_num_txt,
244: A.batch_year_num batch_year_num,
245: A.import_status_type import_status_type,
246: A.ROWID ROW_ID
247: FROM igf_ap_li_isir_act_ints A
248: WHERE A.ci_alternate_code = cp_alternate_code
249: AND A.batch_num = cp_batch_id
250: AND A.import_status_type IN ('U','R')
251: ORDER BY A.person_number;

Line 273: FROM igf_ap_li_isir_act_ints

269: CURSOR c_get_dup_person(cp_alternate_code VARCHAR2,
270: cp_batch_id NUMBER)
271: IS
272: SELECT person_number
273: FROM igf_ap_li_isir_act_ints
274: WHERE ci_alternate_code = cp_alternate_code
275: AND batch_num = cp_batch_id
276: AND import_status_type IN ('U','R')
277: GROUP BY person_number

Line 1094: UPDATE igf_ap_li_isir_act_ints

1090: IF l_error_flag = TRUE THEN
1091: l_error_flag := FALSE;
1092: l_error_record_cnt := l_error_record_cnt + 1;
1093: --update the legacy interface table column import_status to 'E'
1094: UPDATE igf_ap_li_isir_act_ints
1095: SET import_status_type = 'E'
1096: WHERE ROWID = l_get_records.ROW_ID;
1097: ELSE
1098: IF p_del_ind = 'Y' THEN

Line 1099: DELETE FROM igf_ap_li_isir_act_ints

1095: SET import_status_type = 'E'
1096: WHERE ROWID = l_get_records.ROW_ID;
1097: ELSE
1098: IF p_del_ind = 'Y' THEN
1099: DELETE FROM igf_ap_li_isir_act_ints
1100: WHERE ROWID = l_get_records.ROW_ID;
1101: ELSE
1102: --update the legacy interface table column import_status to 'I'
1103: UPDATE igf_ap_li_isir_act_ints

Line 1103: UPDATE igf_ap_li_isir_act_ints

1099: DELETE FROM igf_ap_li_isir_act_ints
1100: WHERE ROWID = l_get_records.ROW_ID;
1101: ELSE
1102: --update the legacy interface table column import_status to 'I'
1103: UPDATE igf_ap_li_isir_act_ints
1104: SET import_status_type = 'I'
1105: WHERE ROWID = l_get_records.ROW_ID;
1106: END IF;
1107: END IF;

Line 1681: l_old_person igf_ap_li_isir_act_ints.person_number%TYPE := '*******';

1677: || (reverse chronological order - newest change first)
1678: */
1679:
1680: l_count NUMBER(5) := g_log_tab.COUNT;
1681: l_old_person igf_ap_li_isir_act_ints.person_number%TYPE := '*******';
1682:
1683: l_person_number VARCHAR2(80);
1684: l_batch_id VARCHAR2(80);
1685: l_award_yr VARCHAR2(80);