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_RECRUIT_INT

Line 81: l_error_code igs_ad_recruit_int.error_code%TYPE;

77: l_prog_label VARCHAR2(100);
78: l_label VARCHAR2(100);
79: l_debug_str VARCHAR2(2000);
80: l_request_id NUMBER;
81: l_error_code igs_ad_recruit_int.error_code%TYPE;
82:
83:
84:
85:

Line 89: CURSOR c_igs_ad_recruit_int IS

85:
86: PROCEDURE crt_upd_recruitments_dtls(
87: p_interface_run_id NUMBER)
88: AS
89: CURSOR c_igs_ad_recruit_int IS
90: SELECT cst_insert dmlmode, rowid, in_rec.* FROM igs_ad_recruit_int in_rec
91: WHERE interface_run_id = p_interface_run_id
92: AND status = cst_s_val_2
93: AND ( ( NVL(match_ind,'15') = '15'

Line 90: SELECT cst_insert dmlmode, rowid, in_rec.* FROM igs_ad_recruit_int in_rec

86: PROCEDURE crt_upd_recruitments_dtls(
87: p_interface_run_id NUMBER)
88: AS
89: CURSOR c_igs_ad_recruit_int IS
90: SELECT cst_insert dmlmode, rowid, in_rec.* FROM igs_ad_recruit_int in_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

Line 100: SELECT cst_update dmlmode, rowid, in_rec.* FROM igs_ad_recruit_int in_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
100: SELECT cst_update dmlmode, rowid, in_rec.* FROM igs_ad_recruit_int in_rec
101: WHERE interface_run_id = p_interface_run_id
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))

Line 119: l_error_text igs_ad_recruit_int.error_text%TYPE;

115: c_null_hdlg_recru_rec c_null_hdlg_recru_cur%ROWTYPE;
116:
117: l_status VARCHAR2(1);
118: l_error_code VARCHAR2(30);
119: l_error_text igs_ad_recruit_int.error_text%TYPE;
120: l_msg_at_index NUMBER := 0;
121: l_return_status VARCHAR2(1);
122: l_msg_count NUMBER ;
123: l_msg_data VARCHAR2(2000);

Line 146: FOR recruit_rec IN c_igs_ad_recruit_int

142: END IF;
143:
144: l_records_processed := 0;
145:
146: FOR recruit_rec IN c_igs_ad_recruit_int
147: LOOP
148: BEGIN
149:
150: SAVEPOINT before_creatupdate;

Line 217: UPDATE igs_ad_recruit_int

213: x_mode =>'R'
214: );
215: END IF;
216:
217: UPDATE igs_ad_recruit_int
218: SET
219: status = cst_s_val_1
220: , match_ind = DECODE (recruit_rec.dmlmode,cst_update, cst_mi_val_18,cst_insert, cst_mi_val_11)
221: WHERE rowid = recruit_rec.rowid;

Line 254: igs_ad_imp_001.logerrormessage(recruit_rec.interface_recruitment_id,l_msg_data,'IGS_AD_RECRUIT_INT');

250: l_error_text := NVL(l_msg_data,igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', l_error_code, 8405));
251:
252: IF l_hash_msg_name_text_type_tab(l_msg_count-1).name <> 'ORA' THEN
253: IF p_enable_log = 'Y' THEN
254: igs_ad_imp_001.logerrormessage(recruit_rec.interface_recruitment_id,l_msg_data,'IGS_AD_RECRUIT_INT');
255: END IF;
256: ELSE
257: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
258:

Line 275: UPDATE igs_ad_recruit_int

271:
272: END IF;
273:
274:
275: UPDATE igs_ad_recruit_int
276: SET
277: status = cst_s_val_3
278: , match_ind = DECODE ( recruit_rec.dmlmode, cst_update, DECODE ( match_ind, NULL, cst_mi_val_12, match_ind)
279: ,cst_insert, DECODE ( p_rule, cst_rule_val_R,

Line 322: UPDATE igs_ad_recruit_int

318: END IF;
319:
320: -- Set STATUS to 3 for interface records with RULE = E or I and MATCH IND
321: IF p_rule IN ('E','I') THEN
322: UPDATE igs_ad_recruit_int
323: SET
324: status = cst_s_val_3
325: , error_code = cst_ec_val_E700
326: , error_text = cst_et_val_E700

Line 336: UPDATE igs_ad_recruit_int

332:
333: -- Set STATUS to 1 for interface records with RULE = R and
334: -- MATCH IND = 17,18,19,22,23,24,27
335: IF p_rule IN ('R') THEN
336: UPDATE igs_ad_recruit_int
337: SET
338: status = cst_s_val_1
339: WHERE interface_run_id = p_interface_run_id
340: AND status = cst_s_val_2

Line 349: UPDATE igs_ad_recruit_int in_rec

345:
346: -- Set STATUS to 1 and MATCH IND to 19 for interface records with RULE =
347: -- E matching OSS record(s)
348: IF p_rule IN ('E') THEN
349: UPDATE igs_ad_recruit_int in_rec
350: SET
351: status = cst_s_val_1
352: , match_ind = cst_mi_val_19
353: WHERE interface_run_id = p_interface_run_id

Line 380: UPDATE igs_ad_recruit_int in_rec

376: -- Set STATUS to 1 and MATCH IND to 23 for interface records with RULE = R matching
377: -- OSS record(s) in ALL updateable column values, if column nullification is not
378: -- allowed then the 2 DECODE should be replaced by a single NVL
379: IF p_rule IN ('R') THEN
380: UPDATE igs_ad_recruit_int in_rec
381: SET
382: status = cst_s_val_1
383: , match_ind = cst_mi_val_23
384: WHERE interface_run_id = p_interface_run_id

Line 419: UPDATE igs_ad_recruit_int in_rec

415:
416: -- Set STATUS to 3 and MATCH IND = 20 for interface records with RULE = R and MATCH IND
417: -- <> 21, 25, ones failed discrepancy check
418: IF p_rule IN ('R') THEN
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

Line 435: UPDATE igs_ad_recruit_int

431: END IF;
432:
433: -- Set STATUS to 3 for interface records with RULE = R and invalid MATCH IND
434: IF p_rule IN ('R') THEN
435: UPDATE igs_ad_recruit_int
436: SET
437: status = cst_s_val_3
438: , error_code = cst_ec_val_E700
439: , error_text = cst_et_val_E700