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_024 dependencies on IGS_AD_TXCPT_INT

Line 68: CURSOR trans_cur(cp_start_int_id igs_ad_txcpt_int.interface_transcript_id%TYPE, --ARVSRINI--

64: l_msg_data VARCHAR2(2000);
65: l_hash_msg_name_text_type_tab igs_ad_gen_016.g_msg_name_text_type_table;
66:
67:
68: CURSOR trans_cur(cp_start_int_id igs_ad_txcpt_int.interface_transcript_id%TYPE, --ARVSRINI--
69: cp_end_int_id igs_ad_txcpt_int.interface_transcript_id%TYPE) IS --ARVSRINI--
70: SELECT cst_insert dmlmode, trans.rowid, trans.*
71: FROM igs_ad_txcpt_int trans
72: WHERE interface_run_id = p_interface_run_id

Line 69: cp_end_int_id igs_ad_txcpt_int.interface_transcript_id%TYPE) IS --ARVSRINI--

65: l_hash_msg_name_text_type_tab igs_ad_gen_016.g_msg_name_text_type_table;
66:
67:
68: CURSOR trans_cur(cp_start_int_id igs_ad_txcpt_int.interface_transcript_id%TYPE, --ARVSRINI--
69: cp_end_int_id igs_ad_txcpt_int.interface_transcript_id%TYPE) IS --ARVSRINI--
70: SELECT cst_insert dmlmode, trans.rowid, trans.*
71: FROM igs_ad_txcpt_int trans
72: WHERE interface_run_id = p_interface_run_id
73: AND trans.status = '2'

Line 71: FROM igs_ad_txcpt_int trans

67:
68: CURSOR trans_cur(cp_start_int_id igs_ad_txcpt_int.interface_transcript_id%TYPE, --ARVSRINI--
69: cp_end_int_id igs_ad_txcpt_int.interface_transcript_id%TYPE) IS --ARVSRINI--
70: SELECT cst_insert dmlmode, trans.rowid, trans.*
71: FROM igs_ad_txcpt_int trans
72: WHERE interface_run_id = p_interface_run_id
73: AND trans.status = '2'
74: AND ( NOT EXISTS (SELECT 1
75: FROM IGS_AD_TRANSCRIPT trans_oss

Line 84: FROM igs_ad_txcpt_int trans

80: AND UPDATE_TRANSCRIPT_ID IS NULL
81: AND interface_transcript_id BETWEEN cp_start_int_id AND cp_end_int_id --ARVSRINI--
82: UNION ALL
83: SELECT cst_update dmlmode, trans.rowid, trans.*
84: FROM igs_ad_txcpt_int trans
85: WHERE interface_run_id = p_interface_run_id
86: AND status = '2'
87: AND ( p_rule = 'I' OR (p_rule = 'R' AND trans.match_ind = '21'))
88: AND interface_transcript_id BETWEEN cp_start_int_id AND cp_end_int_id --ARVSRINI--

Line 136: l_transcript_id igs_ad_txcpt_int.transcript_id%TYPE;

132: l_rowid VARCHAR2(25);
133: l_var VARCHAR2(25);
134: l_validation_status NUMBER;
135: l_err_code VARCHAR2(25);
136: l_transcript_id igs_ad_txcpt_int.transcript_id%TYPE;
137: l_error_code VARCHAR2(4) := NULL;
138: l_error_text VARCHAR2(2000):= NULL;
139:
140: BEGIN

Line 185: UPDATE igs_ad_txcpt_int

181: X_OVERRIDE => NVL(p_trans_record.override_ind, 'N'),
182: X_OVERRIDE_ID => FND_GLOBAL.USER_ID,
183: X_OVERRIDE_DATE => TRUNC(SYSDATE)
184: );
185: UPDATE igs_ad_txcpt_int
186: SET status = cst_s_val_1,
187: error_code = cst_ec_val_NULL,
188: transcript_id = l_transcript_id,
189: match_ind = DECODE (

Line 210: igs_ad_imp_001.logerrormessage(p_trans_record.interface_transcript_id,l_msg_data,'IGS_AD_TXCPT_INT');

206: l_error_text := l_msg_data;
207: l_error_code := 'E322';
208:
209: IF p_enable_log = 'Y' THEN
210: igs_ad_imp_001.logerrormessage(p_trans_record.interface_transcript_id,l_msg_data,'IGS_AD_TXCPT_INT');
211: END IF;
212: ELSE
213: l_error_text := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E518', 8405) ;
214: l_error_code := 'E518';

Line 232: UPDATE igs_ad_txcpt_int

228: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
229: END IF;
230:
231: END IF;
232: UPDATE igs_ad_txcpt_int
233: SET status = cst_s_val_3,
234: error_code = l_error_code,
235: error_text = l_error_text ,
236: match_ind = DECODE (

Line 259: l_transcript_id igs_ad_txcpt_int.transcript_id%TYPE;

255: l_rowid VARCHAR2(25);
256: l_var VARCHAR2(25);
257: l_validation_status NUMBER;
258: l_err_code VARCHAR2(25);
259: l_transcript_id igs_ad_txcpt_int.transcript_id%TYPE;
260: l_msg_at_index NUMBER := 0;
261: l_return_status VARCHAR2(1);
262: l_msg_count NUMBER ;
263: l_msg_data VARCHAR2(2000);

Line 315: UPDATE igs_ad_txcpt_int

311: X_OVERRIDE_DATE => TRUNC(SYSDATE)
312:
313: );
314:
315: UPDATE igs_ad_txcpt_int
316: SET status = cst_s_val_1,
317: error_code = cst_ec_val_NULL,
318: transcript_id = dup_cur_rec.transcript_id,
319: match_ind = DECODE (

Line 341: igs_ad_imp_001.logerrormessage(p_trans_record.interface_transcript_id,l_msg_data,'IGS_AD_TXCPT_INT');

337: l_error_text := l_msg_data;
338: l_error_code := 'E014';
339:
340: IF p_enable_log = 'Y' THEN
341: igs_ad_imp_001.logerrormessage(p_trans_record.interface_transcript_id,l_msg_data,'IGS_AD_TXCPT_INT');
342: END IF;
343: ELSE
344: l_error_text := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E518', 8405);
345: l_error_code := 'E518';

Line 363: UPDATE igs_ad_txcpt_int

359: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
360: END IF;
361:
362: END IF;
363: UPDATE igs_ad_txcpt_int
364: SET status = cst_s_val_3,
365: error_code = l_error_code,
366: error_text = l_error_text ,
367: match_ind = DECODE (

Line 379: UPDATE IGS_AD_TXCPT_INT trans

375:
376:
377: BEGIN
378: --If given invalid update transcript ID then error out.
379: UPDATE IGS_AD_TXCPT_INT trans
380: SET
381: status = '3', error_code = 'E707',
382: error_text = igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E707', 8405)
383: WHERE interface_run_id = p_interface_run_id

Line 393: UPDATE IGS_AD_TXCPT_INT trans

389: COMMIT;
390:
391: -- jchin - bug 4629226 Put an error in the interface table if the transcript source is external.
392:
393: UPDATE IGS_AD_TXCPT_INT trans
394: SET
395: status = '3', error_code = 'E334',
396: error_text = igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E334', 8405)
397: WHERE interface_run_id = p_interface_run_id

Line 409: UPDATE igs_ad_txcpt_int

405: COMMIT;
406:
407: -- 1. Set STATUS to 3 for interface records with RULE = E or I and MATCH IND is not null and not '15'
408: IF p_rule IN ('E', 'I') THEN
409: UPDATE igs_ad_txcpt_int
410: SET
411: status = '3'
412: , error_code = 'E700'
413: , error_text = igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E700', 8405)

Line 422: UPDATE igs_ad_txcpt_int

418: COMMIT;
419:
420: -- 2. Set STATUS to 1 for interface records with RULE = R and MATCH IND = 17,18,19,22,23,24,27
421: IF p_rule = 'R' THEN
422: UPDATE igs_ad_txcpt_int
423: SET
424: status = '1', error_code = NULL
425: WHERE interface_run_id = p_interface_run_id
426: AND status = '2'

Line 433: UPDATE igs_ad_txcpt_int trans

429: COMMIT;
430:
431: -- 3. Set STATUS to 3 for interface records with multiple matching duplicate system records for RULE = I
432: IF p_rule = 'I' THEN
433: UPDATE igs_ad_txcpt_int trans
434: SET
435: status = '3'
436: , match_ind = '13'
437: WHERE interface_run_id = p_interface_run_id

Line 451: UPDATE igs_ad_txcpt_int trans

447: COMMIT;
448: -- 4. Set STATUS to 3 for interface records with multiple matching duplicate system record for RULE = R
449: -- and either MATCH IND IN (15, 21) OR IS NULL
450: IF p_rule = 'R' THEN
451: UPDATE igs_ad_txcpt_int trans
452: SET
453: status = '3'
454: , match_ind = '13'
455: WHERE interface_run_id = p_interface_run_id

Line 470: UPDATE igs_ad_txcpt_int trans

466: COMMIT;
467: -- 5. Set STATUS to 1 and MATCH IND to 19 for interface records with RULE = E matching OSS record(s)
468: IF p_rule = 'E' THEN
469: --If multiple exact matches are found and child records are present then error out
470: UPDATE igs_ad_txcpt_int trans
471: SET
472: status = '1'
473: , match_ind = '19'
474: , transcript_id = update_transcript_id

Line 479: UPDATE igs_ad_txcpt_int trans

475: WHERE interface_run_id = p_interface_run_id
476: AND status = '2'
477: AND update_transcript_id IS NOT NULL;
478:
479: UPDATE igs_ad_txcpt_int trans
480: SET
481: status = '3'
482: , match_ind = '19'
483: ,error_code = 'E708'

Line 495: UPDATE igs_ad_txcpt_int trans

491: WHERE education_id = trans.education_id
492: AND TRUNC(date_of_issue) = TRUNC(trans.date_of_issue)
493: );
494: COMMIT;
495: UPDATE igs_ad_txcpt_int trans
496: SET
497: status = '1'
498: , match_ind = '19'
499: , transcript_id = ( SELECT transcript_id FROM IGS_AD_TRANSCRIPT trans_oss

Line 530: FROM igs_ad_txcpt_int

526:
527: l_total_records_prcessed := 0;
528:
529: SELECT COUNT(interface_transcript_id) INTO l_count_interface_txpt_id
530: FROM igs_ad_txcpt_int
531: WHERE interface_run_id = p_interface_run_id
532: AND status =2 ;
533: LOOP
534: EXIT WHEN l_total_records_prcessed >= l_count_interface_txpt_id;

Line 538: FROM igs_ad_txcpt_int

534: EXIT WHEN l_total_records_prcessed >= l_count_interface_txpt_id;
535: SELECT
536: MIN(interface_transcript_id) , MAX(interface_transcript_id)
537: INTO l_minint , l_maxint
538: FROM igs_ad_txcpt_int
539: WHERE interface_run_id = p_interface_run_id
540: AND status =2
541: AND rownum < =100;
542:

Line 567: UPDATE igs_ad_txcpt_int trans

563:
564: /*Set STATUS to 1 and MATCH IND to 23 for interface records with RULE = R matching OSS record(s) in
565: ALL updateable column values, if column nullification is not allowed then the 2 DECODE should be replaced by a single NVL*/
566: IF p_rule = 'R' THEN
567: UPDATE igs_ad_txcpt_int trans
568: SET
569: status = '1'
570: , match_ind = '23'
571: WHERE interface_run_id = p_interface_run_id

Line 603: UPDATE igs_ad_txcpt_int trans

599:
600: --Set STATUS to 3 and MATCH IND = 20 for interface records with RULE = R and
601: --MATCH IND <> 21, 25, ones failed above discrepancy check
602: IF p_rule = 'R' THEN
603: UPDATE igs_ad_txcpt_int trans
604: SET
605: status = '3'
606: , match_ind = '20'
607: , dup_transcript_id = trans.update_transcript_id

Line 612: UPDATE igs_ad_txcpt_int trans

608: WHERE trans.interface_run_id = p_interface_run_id
609: AND status = '2'
610: AND update_transcript_id IS NOT NULL;
611: COMMIT;
612: UPDATE igs_ad_txcpt_int trans
613: SET
614: status = '3'
615: , match_ind = '20'
616: , dup_transcript_id= ( SELECT transcript_id FROM IGS_AD_TRANSCRIPT trans_oss

Line 632: UPDATE igs_ad_txcpt_int trans

628:
629:
630: --Set STATUS to 3 for interface records with RULE = R and invalid MATCH IND
631: IF p_rule = 'R' THEN
632: UPDATE igs_ad_txcpt_int trans
633: SET
634: status = '3'
635: , error_code = 'E700'
636: , error_text = igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E700', 8405)

Line 648: FROM igs_ad_txcpt_int

644: UPDATE igs_ad_trmdt_int a
645: SET interface_run_id = p_interface_run_id,
646: (person_id,education_id, transcript_id)
647: = (SELECT person_id,education_id, NVL(update_transcript_id, transcript_id)
648: FROM igs_ad_txcpt_int
649: WHERE interface_transcript_id = a.interface_transcript_id)
650: WHERE status IN ('1','2','4')
651: AND interface_transcript_id IN (SELECT interface_transcript_id
652: FROM igs_ad_txcpt_int

Line 652: FROM igs_ad_txcpt_int

648: FROM igs_ad_txcpt_int
649: WHERE interface_transcript_id = a.interface_transcript_id)
650: WHERE status IN ('1','2','4')
651: AND interface_transcript_id IN (SELECT interface_transcript_id
652: FROM igs_ad_txcpt_int
653: WHERE interface_run_id = p_interface_run_id
654: AND status IN ('1','4'));
655:
656: -- If record failed only due to child record failure

Line 953: AND EXISTS (SELECT 1 FROM igs_ad_txcpt_int trans, igs_ad_code_classes_v code

949: ,error_code = 'E334'
950: ,error_Text = igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E334', 8405)
951: WHERE interface_run_id = p_interface_run_id
952: AND status = '2'
953: AND EXISTS (SELECT 1 FROM igs_ad_txcpt_int trans, igs_ad_code_classes_v code
954: WHERE trans.interface_transcript_id = term.interface_transcript_id
955: AND trans.transcript_source = code.code_id
956: AND code.class = 'TRANSCRIPT_SOURCE'
957: AND code.system_status = 'THIRD_PARTY_TRANSFER_EVAL'

Line 1389: AND EXISTS (SELECT 1 FROM igs_ad_txcpt_int trans, igs_ad_code_classes_v code,

1385: , error_code = 'E334'
1386: ,error_Text = igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E334', 8405)
1387: WHERE interface_run_id = p_interface_run_id
1388: AND status = '2'
1389: AND EXISTS (SELECT 1 FROM igs_ad_txcpt_int trans, igs_ad_code_classes_v code,
1390: igs_ad_trmdt_int term
1391: WHERE trans.interface_transcript_id = term.interface_transcript_id
1392: AND term.interface_term_dtls_id = unit.interface_term_dtls_id
1393: AND trans.transcript_source = code.code_id