APPS.IGF_AP_LG_TD_IMP dependencies on IGF_AP_LI_TODO_INTS

Line 167: p_rel_cd IN igf_ap_li_todo_ints.relationship_cd%TYPE,

163:
164: -- museshad (FA 140). Forward declaration
165: PROCEDURE process_pref_lender(
166: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
167: p_rel_cd IN igf_ap_li_todo_ints.relationship_cd%TYPE,
168: p_clprl_id OUT NOCOPY igf_sl_cl_pref_lenders.clprl_id%TYPE
169: );
170: -- museshad (FA 140)
171:

Line 198: l_old_person_number igf_ap_li_todo_ints.person_number%TYPE := '******';

194: l_error VARCHAR2(10);
195: lv_row_id VARCHAR2(80) := NULL;
196: lv_person_id igs_pe_hz_parties.party_id%TYPE := NULL;
197: lv_base_id igf_ap_fa_base_rec_all.base_id%TYPE := NULL;
198: l_old_person_number igf_ap_li_todo_ints.person_number%TYPE := '******';
199: l_current_person_number igf_ap_li_todo_ints.person_number%TYPE := NULL;
200: l_person_skip_flag BOOLEAN := FALSE;
201: l_success_record_cnt NUMBER := 0;
202: l_error_record_cnt NUMBER := 0;

Line 199: l_current_person_number igf_ap_li_todo_ints.person_number%TYPE := NULL;

195: lv_row_id VARCHAR2(80) := NULL;
196: lv_person_id igs_pe_hz_parties.party_id%TYPE := NULL;
197: lv_base_id igf_ap_fa_base_rec_all.base_id%TYPE := NULL;
198: l_old_person_number igf_ap_li_todo_ints.person_number%TYPE := '******';
199: l_current_person_number igf_ap_li_todo_ints.person_number%TYPE := NULL;
200: l_person_skip_flag BOOLEAN := FALSE;
201: l_success_record_cnt NUMBER := 0;
202: l_error_record_cnt NUMBER := 0;
203: l_todo_flag BOOLEAN := FALSE;

Line 257: FROM igf_ap_li_todo_ints

253: import_status_type,
254: import_record_type,
255: relationship_cd,
256: ROWID ROW_ID
257: FROM igf_ap_li_todo_ints
258: WHERE ci_alternate_code = cp_alternate_code
259: AND batch_num = cp_batch_id
260: AND import_status_type IN ('U','R')
261:

Line 458: UPDATE igf_ap_li_todo_ints

454: add_log_table(l_get_persons.person_number,l_error,fnd_message.get);
455: l_person_skip_flag := TRUE;
456: END IF;
457: IF l_person_skip_flag = TRUE THEN
458: UPDATE igf_ap_li_todo_ints
459: SET import_status_type = 'E'
460: WHERE ci_alternate_code = l_get_alternate_code.alternate_code
461: AND person_number = l_get_persons.person_number
462: AND batch_num = p_batch_id;

Line 693: DELETE FROM igf_ap_li_todo_ints

689: l_success_record_cnt := l_success_record_cnt + 1;
690: l_todo_flag := TRUE;
691: l_todo_number := NULL;
692: IF p_del_ind = 'Y' THEN
693: DELETE FROM igf_ap_li_todo_ints
694: WHERE ROWID = l_get_persons.ROW_ID;
695: ELSE
696: --update the legacy interface table column import_status to 'I'
697: UPDATE igf_ap_li_todo_ints

Line 697: UPDATE igf_ap_li_todo_ints

693: DELETE FROM igf_ap_li_todo_ints
694: WHERE ROWID = l_get_persons.ROW_ID;
695: ELSE
696: --update the legacy interface table column import_status to 'I'
697: UPDATE igf_ap_li_todo_ints
698: SET import_status_type = 'I'
699: WHERE ROWID = l_get_persons.ROW_ID;
700: END IF;
701: END IF;

Line 711: UPDATE igf_ap_li_todo_ints

707: IF l_error_flag = TRUE THEN
708: l_error_flag := FALSE;
709: l_error_record_cnt := l_error_record_cnt + 1;
710: --update the legacy interface table column import_status to 'E'
711: UPDATE igf_ap_li_todo_ints
712: SET import_status_type = 'E'
713: WHERE ROWID = l_get_persons.ROW_ID;
714: END IF;
715: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 1011: p_rel_cd IN igf_ap_li_todo_ints.relationship_cd%TYPE,

1007: END update_fabase_rec;
1008:
1009: PROCEDURE process_pref_lender(
1010: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
1011: p_rel_cd IN igf_ap_li_todo_ints.relationship_cd%TYPE,
1012: p_clprl_id OUT NOCOPY igf_sl_cl_pref_lenders.clprl_id%TYPE
1013: )
1014: IS
1015:

Line 1167: l_old_person igf_ap_li_todo_ints.person_number%TYPE := '*******';

1163: || (reverse chronological order - newest change first)
1164: */
1165:
1166: l_count NUMBER(5) := g_log_tab.COUNT;
1167: l_old_person igf_ap_li_todo_ints.person_number%TYPE := '*******';
1168:
1169: l_person_number VARCHAR2(80);
1170: l_batch_id VARCHAR2(80);
1171: l_award_yr VARCHAR2(80);