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_EN_GEN_018 dependencies on IGS_EN_BLK_SUA_INTS

Line 5: TYPE r_msg_rec IS RECORD(upload_id igs_en_blk_sua_ints.upload_id%TYPE,

1: PACKAGE BODY igs_en_gen_018 AS
2: /* $Header: IGSENA8B.pls 120.5 2006/02/23 05:50:59 ckasu ship $ */
3:
4:
5: TYPE r_msg_rec IS RECORD(upload_id igs_en_blk_sua_ints.upload_id%TYPE,
6: type VARCHAR(1),
7: message VARCHAR2(2000));
8:
9: TYPE l_msg_tab IS TABLE OF r_msg_rec INDEX BY BINARY_INTEGER;

Line 91: p_batch_id igs_en_blk_sua_ints.batch_id%TYPE ,

87:
88: PROCEDURE enrpl_log_msg(
89: p_level VARCHAR2,
90: p_message VARCHAR2,
91: p_batch_id igs_en_blk_sua_ints.batch_id%TYPE ,
92: p_person_number igs_en_blk_sua_ints.person_number%TYPE DEFAULT NULL ,
93: p_program_cd igs_en_blk_sua_ints.program_cd%TYPE DEFAULT NULL,
94: p_program_ver igs_en_blk_sua_ints.program_ver_num%TYPE DEFAULT NULL,
95: p_load_alt_code igs_en_blk_sua_ints.alternate_cd%TYPE DEFAULT NULL

Line 92: p_person_number igs_en_blk_sua_ints.person_number%TYPE DEFAULT NULL ,

88: PROCEDURE enrpl_log_msg(
89: p_level VARCHAR2,
90: p_message VARCHAR2,
91: p_batch_id igs_en_blk_sua_ints.batch_id%TYPE ,
92: p_person_number igs_en_blk_sua_ints.person_number%TYPE DEFAULT NULL ,
93: p_program_cd igs_en_blk_sua_ints.program_cd%TYPE DEFAULT NULL,
94: p_program_ver igs_en_blk_sua_ints.program_ver_num%TYPE DEFAULT NULL,
95: p_load_alt_code igs_en_blk_sua_ints.alternate_cd%TYPE DEFAULT NULL
96: )

Line 93: p_program_cd igs_en_blk_sua_ints.program_cd%TYPE DEFAULT NULL,

89: p_level VARCHAR2,
90: p_message VARCHAR2,
91: p_batch_id igs_en_blk_sua_ints.batch_id%TYPE ,
92: p_person_number igs_en_blk_sua_ints.person_number%TYPE DEFAULT NULL ,
93: p_program_cd igs_en_blk_sua_ints.program_cd%TYPE DEFAULT NULL,
94: p_program_ver igs_en_blk_sua_ints.program_ver_num%TYPE DEFAULT NULL,
95: p_load_alt_code igs_en_blk_sua_ints.alternate_cd%TYPE DEFAULT NULL
96: )
97: AS

Line 94: p_program_ver igs_en_blk_sua_ints.program_ver_num%TYPE DEFAULT NULL,

90: p_message VARCHAR2,
91: p_batch_id igs_en_blk_sua_ints.batch_id%TYPE ,
92: p_person_number igs_en_blk_sua_ints.person_number%TYPE DEFAULT NULL ,
93: p_program_cd igs_en_blk_sua_ints.program_cd%TYPE DEFAULT NULL,
94: p_program_ver igs_en_blk_sua_ints.program_ver_num%TYPE DEFAULT NULL,
95: p_load_alt_code igs_en_blk_sua_ints.alternate_cd%TYPE DEFAULT NULL
96: )
97: AS
98: -----------------------------------------------------------------------------------

Line 95: p_load_alt_code igs_en_blk_sua_ints.alternate_cd%TYPE DEFAULT NULL

91: p_batch_id igs_en_blk_sua_ints.batch_id%TYPE ,
92: p_person_number igs_en_blk_sua_ints.person_number%TYPE DEFAULT NULL ,
93: p_program_cd igs_en_blk_sua_ints.program_cd%TYPE DEFAULT NULL,
94: p_program_ver igs_en_blk_sua_ints.program_ver_num%TYPE DEFAULT NULL,
95: p_load_alt_code igs_en_blk_sua_ints.alternate_cd%TYPE DEFAULT NULL
96: )
97: AS
98: -----------------------------------------------------------------------------------
99: --Created by : rvivekan ( Oracle IDC)

Line 121: UPDATE igs_en_blk_sua_ints

117:
118: BEGIN
119: l_message:=enrpl_get_msg(p_message);
120:
121: UPDATE igs_en_blk_sua_ints
122: SET ERROR_TXT=l_message,
123: status_flag=DECODE(p_level,'E','E','W1',status_flag,'S'), -- W1 is grp level warning..changing to S here will prevent c_bulk_suas from picking this upload
124: last_updated_by=fnd_global.user_id, last_update_login=fnd_global.login_id, last_update_date=SYSDATE,
125: request_id=fnd_global.conc_request_id, program_id=fnd_global.conc_program_id ,

Line 208: UPDATE igs_en_blk_sua_ints SET ERROR_TXT=l_message , STATUS_FLAG=l_message_table(i).type,

204: l_message_table(i).message:=l_message_table(i).message||';'||'IGS_EN_UA_SECCESS_ADDED_STUD';
205: END IF;
206: END IF;
207: l_message:=enrpl_get_msg(l_message_table(i).message);
208: UPDATE igs_en_blk_sua_ints SET ERROR_TXT=l_message , STATUS_FLAG=l_message_table(i).type,
209: last_updated_by = fnd_global.user_id, last_update_login =fnd_global.login_id,last_update_date=SYSDATE,
210: request_id=fnd_global.conc_request_id, program_id=fnd_global.conc_program_id ,program_application_id=fnd_global.prog_appl_id,
211: program_update_date=SYSDATE
212: WHERE upload_id=l_message_table(i).upload_id;

Line 233: p_upload_id igs_en_blk_sua_ints.upload_id%TYPE,

229:
230:
231: PROCEDURE enrpl_unit_msg(
232: p_level VARCHAR2,
233: p_upload_id igs_en_blk_sua_ints.upload_id%TYPE,
234: p_message VARCHAR2
235: ) AS
236: -----------------------------------------------------------------------------------
237: --Created by : rvivekan ( Oracle IDC)

Line 398: CURSOR c_bulk_persons (cp_batch_id igs_en_blk_sua_ints.batch_id%TYPE) IS

394: -- ckasu 17-JAN-2006 Added igs_ge_gen_003.set_org_id(NULL) as a part of bug#4958173.
395: -------------------------------------------------------------------
396:
397: --Fetches the distinct persons in the batch
398: CURSOR c_bulk_persons (cp_batch_id igs_en_blk_sua_ints.batch_id%TYPE) IS
399: SELECT DISTINCT person_number
400: FROM igs_en_blk_sua_ints
401: WHERE batch_id=cp_batch_id
402: AND status_flag IN ('U','R')

Line 400: FROM igs_en_blk_sua_ints

396:
397: --Fetches the distinct persons in the batch
398: CURSOR c_bulk_persons (cp_batch_id igs_en_blk_sua_ints.batch_id%TYPE) IS
399: SELECT DISTINCT person_number
400: FROM igs_en_blk_sua_ints
401: WHERE batch_id=cp_batch_id
402: AND status_flag IN ('U','R')
403: ORDER BY person_number;
404:

Line 406: CURSOR c_bulk_programs (cp_batch_id igs_en_blk_sua_ints.batch_id%TYPE, cp_person_number igs_pe_person.person_number%TYPE) IS

402: AND status_flag IN ('U','R')
403: ORDER BY person_number;
404:
405: --Fetches the distinct program attempts for the person
406: CURSOR c_bulk_programs (cp_batch_id igs_en_blk_sua_ints.batch_id%TYPE, cp_person_number igs_pe_person.person_number%TYPE) IS
407: SELECT DISTINCT program_cd, program_ver_num
408: FROM igs_en_blk_sua_ints
409: WHERE batch_id=cp_batch_id
410: AND person_number=cp_person_number

Line 408: FROM igs_en_blk_sua_ints

404:
405: --Fetches the distinct program attempts for the person
406: CURSOR c_bulk_programs (cp_batch_id igs_en_blk_sua_ints.batch_id%TYPE, cp_person_number igs_pe_person.person_number%TYPE) IS
407: SELECT DISTINCT program_cd, program_ver_num
408: FROM igs_en_blk_sua_ints
409: WHERE batch_id=cp_batch_id
410: AND person_number=cp_person_number
411: AND status_flag IN ('U','R');
412:

Line 416: CURSOR c_bulk_load (cp_batch_id igs_en_blk_sua_ints.batch_id%TYPE,

412:
413:
414: --Fetches the relevant load calendars depending upon the teach alt codes specified
415: --int the interface table. The person and program attempt are in the context.
416: CURSOR c_bulk_load (cp_batch_id igs_en_blk_sua_ints.batch_id%TYPE,
417: cp_person_number igs_pe_person.person_number%TYPE,
418: cp_program_cd igs_ps_ofr_opt.course_cd%TYPE,
419: cp_program_ver_num igs_en_blk_sua_ints.program_ver_num%TYPE) IS
420: SELECT DISTINCT ttol.load_cal_type cal_type, ttol.load_ci_sequence_number

Line 419: cp_program_ver_num igs_en_blk_sua_ints.program_ver_num%TYPE) IS

415: --int the interface table. The person and program attempt are in the context.
416: CURSOR c_bulk_load (cp_batch_id igs_en_blk_sua_ints.batch_id%TYPE,
417: cp_person_number igs_pe_person.person_number%TYPE,
418: cp_program_cd igs_ps_ofr_opt.course_cd%TYPE,
419: cp_program_ver_num igs_en_blk_sua_ints.program_ver_num%TYPE) IS
420: SELECT DISTINCT ttol.load_cal_type cal_type, ttol.load_ci_sequence_number
421: seq_num, ttol.load_alternate_code alt_cd,ttol.load_start_dt
422: FROM igs_en_blk_sua_ints sui, igs_ca_teach_to_load_v ttol
423: WHERE batch_id=cp_batch_id

Line 422: FROM igs_en_blk_sua_ints sui, igs_ca_teach_to_load_v ttol

418: cp_program_cd igs_ps_ofr_opt.course_cd%TYPE,
419: cp_program_ver_num igs_en_blk_sua_ints.program_ver_num%TYPE) IS
420: SELECT DISTINCT ttol.load_cal_type cal_type, ttol.load_ci_sequence_number
421: seq_num, ttol.load_alternate_code alt_cd,ttol.load_start_dt
422: FROM igs_en_blk_sua_ints sui, igs_ca_teach_to_load_v ttol
423: WHERE batch_id=cp_batch_id
424: AND person_number=cp_person_number
425: AND status_flag IN ('U','R')
426: AND program_cd=cp_program_cd

Line 447: CURSOR c_bulk_suas (cp_batch_id igs_en_blk_sua_ints.batch_id%TYPE,

443: WHERE ttol.load_cal_type=cp_load_cal_type
444: AND ttol.load_ci_sequence_number=cp_load_seq_num;
445:
446: --Fetches the induvidual sua records from the interface table
447: CURSOR c_bulk_suas (cp_batch_id igs_en_blk_sua_ints.batch_id%TYPE,
448: cp_person_number igs_pe_person.person_number%TYPE,
449: cp_program_cd igs_ps_ofr_opt.course_cd%TYPE,
450: cp_program_ver_num igs_en_blk_sua_ints.program_ver_num%TYPE,
451: cp_teach_cal_type igs_ca_inst.cal_type%TYPE,

Line 450: cp_program_ver_num igs_en_blk_sua_ints.program_ver_num%TYPE,

446: --Fetches the induvidual sua records from the interface table
447: CURSOR c_bulk_suas (cp_batch_id igs_en_blk_sua_ints.batch_id%TYPE,
448: cp_person_number igs_pe_person.person_number%TYPE,
449: cp_program_cd igs_ps_ofr_opt.course_cd%TYPE,
450: cp_program_ver_num igs_en_blk_sua_ints.program_ver_num%TYPE,
451: cp_teach_cal_type igs_ca_inst.cal_type%TYPE,
452: cp_teach_seq_num igs_ca_inst.sequence_number%TYPE,
453: cp_teach_alternate_cd igs_ca_inst.alternate_code%TYPE
454: ) IS

Line 471: FROM igs_en_blk_sua_ints sui

467: sui.alternate_cd alt_cd,
468: sui.core_indicator_code,
469: sui.update_core_flag,
470: enrp_get_uoo_info(sui.unit_cd,sui.unit_ver_num,cp_teach_cal_type,cp_teach_seq_num,sui.location_cd,sui.unit_class) uoo_info
471: FROM igs_en_blk_sua_ints sui
472: WHERE batch_id=cp_batch_id
473: AND person_number=cp_person_number
474: AND status_flag IN ('U','R')
475: AND program_cd=cp_program_cd

Line 484: cp_program_ver_num igs_en_blk_sua_ints.program_ver_num%TYPE) IS

480:
481: --Used to check if the student has the relevant program attempt
482: CURSOR c_stdnt_ps_att (cp_person_id igs_pe_person.person_id%TYPE,
483: cp_program_cd igs_ps_ofr_opt.course_cd%TYPE,
484: cp_program_ver_num igs_en_blk_sua_ints.program_ver_num%TYPE) IS
485: SELECT course_attempt_status, primary_program_type FROM igs_en_stdnt_ps_att
486: WHERE person_id = cp_person_id
487: AND course_cd = cp_program_cd
488: AND version_number= cp_program_ver_num;

Line 503: CURSOR c_invalid_teach (cp_batch_id igs_en_blk_sua_ints.batch_id%TYPE) IS

499:
500:
501: --Retrieves the interface records with invalid teach alt codes
502: -- replaced view igs_ca_inst with igs_ca_inst_all for perf bug#4961316
503: CURSOR c_invalid_teach (cp_batch_id igs_en_blk_sua_ints.batch_id%TYPE) IS
504: SELECT sui.upload_id, sui.alternate_cd alt_cd
505: FROM igs_en_blk_sua_ints sui,igs_ca_inst_all cal
506: WHERE sui.batch_id=cp_batch_id
507: AND status_flag IN ('U','R')

Line 505: FROM igs_en_blk_sua_ints sui,igs_ca_inst_all cal

501: --Retrieves the interface records with invalid teach alt codes
502: -- replaced view igs_ca_inst with igs_ca_inst_all for perf bug#4961316
503: CURSOR c_invalid_teach (cp_batch_id igs_en_blk_sua_ints.batch_id%TYPE) IS
504: SELECT sui.upload_id, sui.alternate_cd alt_cd
505: FROM igs_en_blk_sua_ints sui,igs_ca_inst_all cal
506: WHERE sui.batch_id=cp_batch_id
507: AND status_flag IN ('U','R')
508: AND cal.alternate_code(+)=sui.alternate_cd
509: AND cal.alternate_code IS NULL;

Line 512: CURSOR c_invalid_teach2load (cp_batch_id igs_en_blk_sua_ints.batch_id%TYPE) IS

508: AND cal.alternate_code(+)=sui.alternate_cd
509: AND cal.alternate_code IS NULL;
510:
511: --Retrieves the interface records with invalid teach 2 load relationship
512: CURSOR c_invalid_teach2load (cp_batch_id igs_en_blk_sua_ints.batch_id%TYPE) IS
513: SELECT sui.upload_id, sui.alternate_cd alt_cd,cal.cal_type,cal.sequence_number
514: FROM igs_en_blk_sua_ints sui,
515: igs_ca_inst cal
516: WHERE sui.alternate_cd=cal.alternate_code

Line 514: FROM igs_en_blk_sua_ints sui,

510:
511: --Retrieves the interface records with invalid teach 2 load relationship
512: CURSOR c_invalid_teach2load (cp_batch_id igs_en_blk_sua_ints.batch_id%TYPE) IS
513: SELECT sui.upload_id, sui.alternate_cd alt_cd,cal.cal_type,cal.sequence_number
514: FROM igs_en_blk_sua_ints sui,
515: igs_ca_inst cal
516: WHERE sui.alternate_cd=cal.alternate_code
517: AND batch_id=cp_batch_id
518: AND status_flag IN ('U','R')

Line 524: CURSOR c_batch_desc (cp_batch_id igs_en_blk_sua_ints.batch_id%TYPE) IS

520: FROM igs_ca_teach_to_load_v ttol
521: WHERE cal.cal_type=ttol.teach_cal_type
522: AND cal.sequence_number=ttol.teach_ci_sequence_number);
523:
524: CURSOR c_batch_desc (cp_batch_id igs_en_blk_sua_ints.batch_id%TYPE) IS
525: SELECT batch_desc
526: FROM igs_en_bat_sua_ints
527: WHERE batch_id=cp_batch_id;
528:

Line 529: CURSOR c_delete_bat (cp_batch_id igs_en_blk_sua_ints.batch_id%TYPE) IS

525: SELECT batch_desc
526: FROM igs_en_bat_sua_ints
527: WHERE batch_id=cp_batch_id;
528:
529: CURSOR c_delete_bat (cp_batch_id igs_en_blk_sua_ints.batch_id%TYPE) IS
530: SELECT '1'
531: FROM igs_en_blk_sua_ints
532: WHERE batch_id=cp_batch_id;
533:

Line 531: FROM igs_en_blk_sua_ints

527: WHERE batch_id=cp_batch_id;
528:
529: CURSOR c_delete_bat (cp_batch_id igs_en_blk_sua_ints.batch_id%TYPE) IS
530: SELECT '1'
531: FROM igs_en_blk_sua_ints
532: WHERE batch_id=cp_batch_id;
533:
534:
535: cst_discontin VARCHAR2(40) :='DISCONTIN';

Line 1214: DELETE FROM igs_en_blk_sua_ints WHERE batch_id=p_batch_id AND status_flag='S';

1210: END IF;
1211:
1212: --Delete the successfully processed records from the interface table if required
1213: IF p_deletion_flag='Y' THEN
1214: DELETE FROM igs_en_blk_sua_ints WHERE batch_id=p_batch_id AND status_flag='S';
1215: OPEN c_delete_bat (p_batch_id);
1216: FETCH c_delete_bat INTO l_dummy;
1217: IF c_delete_bat%NOTFOUND THEN
1218: DELETE FROM igs_en_bat_sua_ints WHERE batch_id=p_batch_id;