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_CPD_EXT_PKG dependencies on IGS_EN_CPD_EXT_ALL

Line 5: old_references igs_en_cpd_ext_all%ROWTYPE;

1: PACKAGE BODY igs_en_cpd_ext_pkg AS
2: /* $Header: IGSEI50B.pls 115.5 2003/06/11 06:37:05 rnirwani ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_en_cpd_ext_all%ROWTYPE;
6: new_references igs_en_cpd_ext_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_en_cpd_ext_all%ROWTYPE;

2: /* $Header: IGSEI50B.pls 115.5 2003/06/11 06:37:05 rnirwani ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_en_cpd_ext_all%ROWTYPE;
6: new_references igs_en_cpd_ext_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 ,

Line 39: FROM IGS_EN_CPD_EXT_ALL

35: */
36:
37: CURSOR cur_old_ref_values IS
38: SELECT *
39: FROM IGS_EN_CPD_EXT_ALL
40: WHERE rowid = x_rowid;
41:
42: BEGIN
43:

Line 216: FROM igs_en_cpd_ext_all

212: || (reverse chronological order - newest change first)
213: */
214: CURSOR cur_rowid IS
215: SELECT rowid
216: FROM igs_en_cpd_ext_all
217: WHERE igs_en_cpd_ext_id = x_igs_en_cpd_ext_id
218: FOR UPDATE NOWAIT;
219:
220: lv_rowid cur_rowid%RowType;

Line 293: FROM igs_en_cpd_ext_all

289: || (reverse chronological order - newest change first)
290: */
291: CURSOR cur_rowid IS
292: SELECT rowid
293: FROM igs_en_cpd_ext_all
294: WHERE ((enrolment_cat = x_enrolment_cat));
295:
296: lv_rowid cur_rowid%RowType;
297:

Line 328: FROM igs_en_cpd_ext_all

324: || (reverse chronological order - newest change first)
325: */
326: CURSOR cur_rowid IS
327: SELECT rowid
328: FROM igs_en_cpd_ext_all
329: WHERE ((enr_method_type = x_enr_method_type));
330:
331: lv_rowid cur_rowid%RowType;
332:

Line 363: FROM igs_en_cpd_ext_all

359: || (reverse chronological order - newest change first)
360: */
361: CURSOR cur_rowid IS
362: SELECT rowid
363: FROM igs_en_cpd_ext_all
364: WHERE ((s_rule_call_cd = x_s_rule_call_cd));
365:
366: lv_rowid cur_rowid%RowType;
367:

Line 398: FROM igs_en_cpd_ext_all

394: || (reverse chronological order - newest change first)
395: */
396: CURSOR cur_rowid IS
397: SELECT rowid
398: FROM igs_en_cpd_ext_all
399: WHERE ((rul_sequence_number = x_sequence_number));
400:
401: lv_rowid cur_rowid%RowType;
402:

Line 435: FROM IGS_EN_CPD_EXT_ALL

431: || (reverse chronological order - newest change first)
432: */
433: CURSOR cur_rowid IS
434: SELECT rowid
435: FROM IGS_EN_CPD_EXT_ALL
436: WHERE s_student_comm_type = x_s_student_comm_type;
437: lv_rowid cur_rowid%RowType;
438:
439: BEGIN

Line 467: FROM IGS_EN_CPD_EXT_ALL

463: || (reverse chronological order - newest change first)
464: */
465: CURSOR cur_rowid IS
466: SELECT rowid
467: FROM IGS_EN_CPD_EXT_ALL
468: WHERE s_enrolment_step_type = x_s_enrolment_step_type;
469: lv_rowid cur_rowid%RowType;
470:
471: BEGIN

Line 576: CURSOR c_cpdext (cp_enr_cat igs_en_cpd_ext_all.enrolment_cat%TYPE,

572: p_inserting IN BOOLEAN ,
573: p_updating IN BOOLEAN ,
574: p_deleting IN BOOLEAN
575: ) AS
576: CURSOR c_cpdext (cp_enr_cat igs_en_cpd_ext_all.enrolment_cat%TYPE,
577: cp_enr_mth igs_en_cpd_ext_all.enr_method_type%TYPE,
578: cp_comm_type igs_en_cpd_ext_all.s_student_comm_type%TYPE,
579: cp_step_type igs_en_cpd_ext_all.s_enrolment_Step_type%TYPE) IS
580: SELECT 'x'

Line 577: cp_enr_mth igs_en_cpd_ext_all.enr_method_type%TYPE,

573: p_updating IN BOOLEAN ,
574: p_deleting IN BOOLEAN
575: ) AS
576: CURSOR c_cpdext (cp_enr_cat igs_en_cpd_ext_all.enrolment_cat%TYPE,
577: cp_enr_mth igs_en_cpd_ext_all.enr_method_type%TYPE,
578: cp_comm_type igs_en_cpd_ext_all.s_student_comm_type%TYPE,
579: cp_step_type igs_en_cpd_ext_all.s_enrolment_Step_type%TYPE) IS
580: SELECT 'x'
581: FROM igs_en_cpd_ext

Line 578: cp_comm_type igs_en_cpd_ext_all.s_student_comm_type%TYPE,

574: p_deleting IN BOOLEAN
575: ) AS
576: CURSOR c_cpdext (cp_enr_cat igs_en_cpd_ext_all.enrolment_cat%TYPE,
577: cp_enr_mth igs_en_cpd_ext_all.enr_method_type%TYPE,
578: cp_comm_type igs_en_cpd_ext_all.s_student_comm_type%TYPE,
579: cp_step_type igs_en_cpd_ext_all.s_enrolment_Step_type%TYPE) IS
580: SELECT 'x'
581: FROM igs_en_cpd_ext
582: WHERE enrolment_cat = cp_enr_cat

Line 579: cp_step_type igs_en_cpd_ext_all.s_enrolment_Step_type%TYPE) IS

575: ) AS
576: CURSOR c_cpdext (cp_enr_cat igs_en_cpd_ext_all.enrolment_cat%TYPE,
577: cp_enr_mth igs_en_cpd_ext_all.enr_method_type%TYPE,
578: cp_comm_type igs_en_cpd_ext_all.s_student_comm_type%TYPE,
579: cp_step_type igs_en_cpd_ext_all.s_enrolment_Step_type%TYPE) IS
580: SELECT 'x'
581: FROM igs_en_cpd_ext
582: WHERE enrolment_cat = cp_enr_cat
583: AND enr_method_type = cp_enr_mth

Line 587: CURSOR c_catprc (cp_enr_cat igs_en_cpd_ext_all.enrolment_cat%TYPE,

583: AND enr_method_type = cp_enr_mth
584: AND s_student_comm_type = cp_comm_type
585: AND s_enrolment_Step_type = cp_step_type;
586:
587: CURSOR c_catprc (cp_enr_cat igs_en_cpd_ext_all.enrolment_cat%TYPE,
588: cp_enr_mth igs_en_cpd_ext_all.enr_method_type%TYPE,
589: cp_comm_type igs_en_cpd_ext_all.s_student_comm_type%TYPE) IS
590: SELECT rowid row_id,
591: enrolment_cat,

Line 588: cp_enr_mth igs_en_cpd_ext_all.enr_method_type%TYPE,

584: AND s_student_comm_type = cp_comm_type
585: AND s_enrolment_Step_type = cp_step_type;
586:
587: CURSOR c_catprc (cp_enr_cat igs_en_cpd_ext_all.enrolment_cat%TYPE,
588: cp_enr_mth igs_en_cpd_ext_all.enr_method_type%TYPE,
589: cp_comm_type igs_en_cpd_ext_all.s_student_comm_type%TYPE) IS
590: SELECT rowid row_id,
591: enrolment_cat,
592: s_student_comm_type,

Line 589: cp_comm_type igs_en_cpd_ext_all.s_student_comm_type%TYPE) IS

585: AND s_enrolment_Step_type = cp_step_type;
586:
587: CURSOR c_catprc (cp_enr_cat igs_en_cpd_ext_all.enrolment_cat%TYPE,
588: cp_enr_mth igs_en_cpd_ext_all.enr_method_type%TYPE,
589: cp_comm_type igs_en_cpd_ext_all.s_student_comm_type%TYPE) IS
590: SELECT rowid row_id,
591: enrolment_cat,
592: s_student_comm_type,
593: enr_method_type,

Line 601: l_step_type igs_en_cpd_ext_all.s_enrolment_Step_type%TYPE;

597: WHERE enrolment_cat = cp_enr_cat
598: AND s_student_comm_type = cp_comm_type
599: AND enr_method_type = cp_enr_mth;
600:
601: l_step_type igs_en_cpd_ext_all.s_enrolment_Step_type%TYPE;
602: l_record_exist varchar2(1);
603: l_catprc c_catprc%ROWTYPE;
604:
605: BEGIN

Line 691: FROM igs_en_cpd_ext_all

687: || (reverse chronological order - newest change first)
688: */
689: CURSOR c IS
690: SELECT rowid
691: FROM igs_en_cpd_ext_all
692: WHERE igs_en_cpd_ext_id = x_igs_en_cpd_ext_id;
693:
694: x_last_update_date DATE;
695: x_last_updated_by NUMBER;

Line 745: INSERT INTO igs_en_cpd_ext_all (

741: x_last_update_login => x_last_update_login,
742: x_stud_audit_lim => x_stud_audit_lim
743: );
744:
745: INSERT INTO igs_en_cpd_ext_all (
746: igs_en_cpd_ext_id,
747: org_id,
748: enrolment_cat,
749: enr_method_type,

Line 830: FROM igs_en_cpd_ext_all

826: notification_flag,
827: s_rule_call_cd,
828: rul_sequence_number,
829: stud_audit_lim
830: FROM igs_en_cpd_ext_all
831: WHERE rowid = x_rowid
832: FOR UPDATE NOWAIT;
833:
834: tlinfo c1%ROWTYPE;

Line 940: UPDATE igs_en_cpd_ext_all

936: x_last_update_login => x_last_update_login,
937: x_stud_audit_lim => x_stud_audit_lim
938: );
939:
940: UPDATE igs_en_cpd_ext_all
941: SET
942: enrolment_cat = new_references.enrolment_cat,
943: enr_method_type = new_references.enr_method_type,
944: s_student_comm_type = new_references.s_student_comm_type,

Line 993: FROM igs_en_cpd_ext_all

989: || (reverse chronological order - newest change first)
990: */
991: CURSOR c1 IS
992: SELECT rowid
993: FROM igs_en_cpd_ext_all
994: WHERE igs_en_cpd_ext_id = x_igs_en_cpd_ext_id;
995:
996: BEGIN
997:

Line 1058: DELETE FROM igs_en_cpd_ext_all

1054: p_action => 'DELETE',
1055: x_rowid => x_rowid
1056: );
1057:
1058: DELETE FROM igs_en_cpd_ext_all
1059: WHERE rowid = x_rowid;
1060:
1061: IF (SQL%NOTFOUND) THEN
1062: RAISE NO_DATA_FOUND;