APPS.IGF_AP_LI_AWARDS_PKG dependencies on IGF_AW_LI_AGR_INTS

Line 92: FROM igf_aw_li_agr_ints A

88: A.paid_amt paid_amt,
89: A.import_status_type import_status,
90: A.import_record_type import_record_type,
91: A.ROWID ROW_ID
92: FROM igf_aw_li_agr_ints A
93: WHERE A.batch_num = cp_batch_id
94: AND A.ci_alternate_code = cp_alternate_code
95: AND A.import_status_type IN ('U','R')
96: ORDER BY A.person_number;

Line 423: UPDATE igf_aw_li_agr_ints

419: END IF; -- for the person id check
420: IF l_error_flag = TRUE THEN
421: l_error_flag := FALSE;
422: --update the legacy interface table column import_status to 'E'
423: UPDATE igf_aw_li_agr_ints
424: SET import_status_type = 'E'
425: WHERE ROWID = l_interface.ROW_ID;
426: -- HERE INCREMENT THE COUNTER FOR THE RECORDS THAT HAVE ERRORS....
427: l_error_record_cnt := l_error_record_cnt + 1;

Line 430: DELETE FROM igf_aw_li_agr_ints

426: -- HERE INCREMENT THE COUNTER FOR THE RECORDS THAT HAVE ERRORS....
427: l_error_record_cnt := l_error_record_cnt + 1;
428: ELSE
429: IF p_del_ind = 'Y' THEN
430: DELETE FROM igf_aw_li_agr_ints
431: WHERE ROWID = l_interface.ROW_ID;
432: l_debug_str := l_debug_str || ' Record Deleted from interface table';
433: ELSE
434: --update the legacy interface table column import_status to 'I'

Line 435: UPDATE igf_aw_li_agr_ints

431: WHERE ROWID = l_interface.ROW_ID;
432: l_debug_str := l_debug_str || ' Record Deleted from interface table';
433: ELSE
434: --update the legacy interface table column import_status to 'I'
435: UPDATE igf_aw_li_agr_ints
436: SET import_status_type = 'I'
437: WHERE ROWID = l_interface.ROW_ID;
438: l_debug_str := l_debug_str || ' Record import_status changed to I';
439: END IF;

Line 509: l_old_person igf_aw_li_agr_ints.person_number%TYPE := '*******';

505: || (reverse chronological order - newest change first)
506: */
507:
508: l_count NUMBER(5) := g_log_tab.COUNT;
509: l_old_person igf_aw_li_agr_ints.person_number%TYPE := '*******';
510:
511: BEGIN
512:
513: FOR i IN 1..l_count LOOP