APPS.IGF_AP_MK_PROF_ACT_PKG dependencies on IGF_AP_LI_CSS_ACT_INTS

Line 17: TYPE PerTab IS TABLE OF igf_ap_li_css_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_css_act_ints.person_number%TYPE
18: index by binary_integer;
19:
20: g_per_tab PerTab;
21:

Line 100: FROM igf_ap_li_css_act_ints A

96: A.academic_year_txt academic_year_txt,
97: A.stu_record_type stu_record_type,
98: A.import_status_type import_status_type,
99: A.ROWID ROW_ID
100: FROM igf_ap_li_css_act_ints A
101: WHERE A.ci_alternate_code = cp_alternate_code
102: AND A.batch_num = cp_batch_id
103: AND A.import_status_type IN ('U','R')
104: ORDER BY A.person_number;

Line 127: FROM igf_ap_li_css_act_ints

123: CURSOR c_get_dup_person(cp_alternate_code VARCHAR2,
124: cp_batch_id NUMBER)
125: IS
126: SELECT person_number
127: FROM igf_ap_li_css_act_ints
128: WHERE ci_alternate_code = cp_alternate_code
129: AND batch_num = cp_batch_id
130: GROUP BY person_number
131: HAVING COUNT(person_number) > 1;

Line 982: UPDATE igf_ap_li_css_act_ints

978: IF l_error_flag = TRUE THEN
979: l_error_flag := FALSE;
980: l_error_record_cnt := l_error_record_cnt + 1;
981: --update the legacy interface table column import_status to 'E'
982: UPDATE igf_ap_li_css_act_ints
983: SET import_status_type = 'E'
984: WHERE ROWID = l_get_records.ROW_ID;
985: ELSE
986: IF p_del_ind = 'Y' THEN

Line 987: DELETE FROM igf_ap_li_css_act_ints

983: SET import_status_type = 'E'
984: WHERE ROWID = l_get_records.ROW_ID;
985: ELSE
986: IF p_del_ind = 'Y' THEN
987: DELETE FROM igf_ap_li_css_act_ints
988: WHERE ROWID = l_get_records.ROW_ID;
989: ELSE
990: --update the legacy interface table column import_status to 'I'
991: UPDATE igf_ap_li_css_act_ints

Line 991: UPDATE igf_ap_li_css_act_ints

987: DELETE FROM igf_ap_li_css_act_ints
988: WHERE ROWID = l_get_records.ROW_ID;
989: ELSE
990: --update the legacy interface table column import_status to 'I'
991: UPDATE igf_ap_li_css_act_ints
992: SET import_status_type = 'I'
993: WHERE ROWID = l_get_records.ROW_ID;
994: END IF;
995: END IF;

Line 1105: l_old_person igf_ap_li_css_act_ints.person_number%TYPE := '*******';

1101: || (reverse chronological order - newest change first)
1102: */
1103:
1104: l_count NUMBER(5) := g_log_tab.COUNT;
1105: l_old_person igf_ap_li_css_act_ints.person_number%TYPE := '*******';
1106:
1107: l_person_number VARCHAR2(80);
1108: l_batch_id VARCHAR2(80);
1109: l_award_yr VARCHAR2(80);