eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_AD_IMP_014 dependencies on IGS_AD_RECRUITMENTS

Line 72: || Removed the processing for 'probability' in the call to TBH igs_ad_recruitments_pkg.insert_row, update_row

68: || removed due to transition of code
69: || class to lookups , new columns added
70: || for codes. the tbh call are modified accordingly .
71: || pkpatel 24-JUL-2001 Bug no.1890270 Admissions Standards and Rules Dld_adsr_setup
72: || Removed the processing for 'probability' in the call to TBH igs_ad_recruitments_pkg.insert_row, update_row
73: || and in the cursor for discrepancy check
74: || (reverse chronological order - newest change first)
75: */
76:

Line 95: FROM igs_ad_recruitments mn_rec

91: WHERE interface_run_id = p_interface_run_id
92: AND status = cst_s_val_2
93: AND ( ( NVL(match_ind,'15') = '15'
94: AND NOT EXISTS (SELECT 1
95: FROM igs_ad_recruitments mn_rec
96: WHERE mn_rec.person_id = in_rec.person_id))
97: OR ( p_rule = cst_rule_val_R
98: AND match_ind IN (cst_mi_val_16, cst_mi_val_25)))
99: UNION ALL

Line 106: FROM igs_ad_recruitments mn_rec

102: AND status = cst_s_val_2
103: AND ( (p_rule = cst_rule_val_I)
104: OR (p_rule = cst_rule_val_R AND match_ind = cst_mi_val_21))
105: AND EXISTS ( SELECT 1
106: FROM igs_ad_recruitments mn_rec
107: WHERE mn_rec.person_id = in_rec.person_id);
108:
109:
110: CURSOR c_null_hdlg_recru_cur(cp_person_id igs_ad_recruitments.person_id%TYPE) IS

Line 110: CURSOR c_null_hdlg_recru_cur(cp_person_id igs_ad_recruitments.person_id%TYPE) IS

106: FROM igs_ad_recruitments mn_rec
107: WHERE mn_rec.person_id = in_rec.person_id);
108:
109:
110: CURSOR c_null_hdlg_recru_cur(cp_person_id igs_ad_recruitments.person_id%TYPE) IS
111: SELECT ROWID, ar.*
112: FROM igs_ad_recruitments ar
113: WHERE person_id = cp_person_id;
114:

Line 112: FROM igs_ad_recruitments ar

108:
109:
110: CURSOR c_null_hdlg_recru_cur(cp_person_id igs_ad_recruitments.person_id%TYPE) IS
111: SELECT ROWID, ar.*
112: FROM igs_ad_recruitments ar
113: WHERE person_id = cp_person_id;
114:
115: c_null_hdlg_recru_rec c_null_hdlg_recru_cur%ROWTYPE;
116:

Line 127: l_recruitments_ID igs_ad_recruitments.recruitment_id%TYPE;

123: l_msg_data VARCHAR2(2000);
124: l_hash_msg_name_text_type_tab igs_ad_gen_016.g_msg_name_text_type_table;
125:
126: l_records_processed NUMBER;
127: l_recruitments_ID igs_ad_recruitments.recruitment_id%TYPE;
128: l_rowid VARCHAR2(30);
129:
130: BEGIN
131:

Line 154: igs_ad_recruitments_pkg.INSERT_ROW (

150: SAVEPOINT before_creatupdate;
151: l_msg_at_index := igs_ge_msg_stack.count_msg;
152:
153: IF recruit_rec.dmlmode = cst_insert THEN
154: igs_ad_recruitments_pkg.INSERT_ROW (
155: X_ROWID => l_rowid,
156: x_CERTAINTY_OF_CHOICE_ID => recruit_rec.CERTAINTY_OF_CHOICE_ID,
157: x_religion_cd => recruit_rec.religion_cd,
158: x_ADV_STUDIES_CLASSES => recruit_rec.ADV_STUDIES_CLASSES,

Line 188: igs_ad_recruitments_pkg.UPDATE_ROW(

184: OPEN c_null_hdlg_recru_cur(recruit_rec.person_id);
185: FETCH c_null_hdlg_recru_cur INTO c_null_hdlg_recru_rec;
186: CLOSE c_null_hdlg_recru_cur;
187:
188: igs_ad_recruitments_pkg.UPDATE_ROW(
189: x_rowid => c_null_hdlg_recru_rec.rowid,
190: x_CERTAINTY_OF_CHOICE_ID => NVL(recruit_rec.CERTAINTY_OF_CHOICE_ID, c_null_hdlg_recru_rec.CERTAINTY_OF_CHOICE_ID),
191: x_religion_cd => NVL(recruit_rec.religion_cd, c_null_hdlg_recru_rec.religion_cd),
192: x_ADV_STUDIES_CLASSES => NVL(recruit_rec.ADV_STUDIES_CLASSES, c_null_hdlg_recru_rec.ADV_STUDIES_CLASSES),

Line 356: FROM igs_ad_recruitments mn_rec

352: , match_ind = cst_mi_val_19
353: WHERE interface_run_id = p_interface_run_id
354: AND status = cst_s_val_2
355: AND EXISTS ( SELECT 1
356: FROM igs_ad_recruitments mn_rec
357: WHERE mn_rec.person_id = in_rec.person_id);
358: COMMIT;
359: END IF;
360:

Line 389: FROM igs_ad_recruitments mn_rec

385: AND status = cst_s_val_2
386: AND NVL (match_ind, cst_mi_val_15) = cst_mi_val_15
387: AND EXISTS (
388: SELECT 1
389: FROM igs_ad_recruitments mn_rec
390: WHERE NVL(mn_rec.adv_studies_classes, -99) = NVL(in_rec.adv_studies_classes,NVL(mn_rec.adv_studies_classes, -99) )
391: AND NVL(mn_rec.certainty_of_choice_id, -99) = NVL(in_rec.certainty_of_choice_id, NVL(mn_rec.certainty_of_choice_id, -99))
392: AND NVL(mn_rec.class_size, -99) = NVL(in_rec.class_size,NVL(mn_rec.class_size, -99) )
393: AND NVL(mn_rec.deactivate_recruit_status,'~') = NVL(in_rec.deactivate_recruit_status, NVL(mn_rec.deactivate_recruit_status,'~') )

Line 423: , dup_recruitment_id = ( SELECT recruitment_id FROM igs_ad_recruitments mn_rec

419: UPDATE igs_ad_recruit_int in_rec
420: SET
421: status = cst_s_val_3
422: , match_ind = cst_mi_val_20
423: , dup_recruitment_id = ( SELECT recruitment_id FROM igs_ad_recruitments mn_rec
424: WHERE mn_rec.person_id = in_rec.person_id)
425: WHERE interface_run_id = p_interface_run_id
426: AND status = cst_s_val_2
427: AND NVL (match_ind, cst_mi_val_15) = cst_mi_val_15

Line 428: AND EXISTS ( SELECT rowid FROM igs_ad_recruitments mn_rec

424: WHERE mn_rec.person_id = in_rec.person_id)
425: WHERE interface_run_id = p_interface_run_id
426: AND status = cst_s_val_2
427: AND NVL (match_ind, cst_mi_val_15) = cst_mi_val_15
428: AND EXISTS ( SELECT rowid FROM igs_ad_recruitments mn_rec
429: WHERE mn_rec.person_id = in_rec.person_id);
430: COMMIT;
431: END IF;
432: