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

Line 1: PACKAGE BODY igs_en_cpd_ext_pkg AS

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;

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 11: x_igs_en_cpd_ext_id IN NUMBER ,

7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 ,
11: x_igs_en_cpd_ext_id IN NUMBER ,
12: x_enrolment_cat IN VARCHAR2 ,
13: x_enr_method_type IN VARCHAR2 ,
14: x_s_student_comm_type IN VARCHAR2 ,
15: x_step_order_num IN NUMBER ,

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 60: new_references.igs_en_cpd_ext_id := x_igs_en_cpd_ext_id;

56: END IF;
57: CLOSE cur_old_ref_values;
58:
59: -- Populate New Values.
60: new_references.igs_en_cpd_ext_id := x_igs_en_cpd_ext_id;
61: new_references.enrolment_cat := x_enrolment_cat;
62: new_references.enr_method_type := x_enr_method_type;
63: new_references.s_student_comm_type := x_s_student_comm_type;
64: new_references.step_order_num := x_step_order_num;

Line 203: x_igs_en_cpd_ext_id IN NUMBER

199: END check_parent_existance;
200:
201:
202: FUNCTION get_pk_for_validation (
203: x_igs_en_cpd_ext_id IN NUMBER
204: ) RETURN BOOLEAN AS
205: /*
206: || Created By : [email protected]
207: || Created On : 22-JUN-2001

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 217: WHERE igs_en_cpd_ext_id = x_igs_en_cpd_ext_id

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;
221:

Line 255: FROM igs_en_cpd_ext

251: || (reverse chronological order - newest change first)
252: */
253: CURSOR cur_rowid IS
254: SELECT rowid
255: FROM igs_en_cpd_ext
256: WHERE enrolment_cat = x_enrolment_cat
257: AND enr_method_type = x_enr_method_type
258: AND s_enrolment_step_type = x_s_enrolment_step_type
259: AND s_student_comm_type = x_s_student_comm_type

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 490: x_igs_en_cpd_ext_id IN NUMBER ,

486:
487: PROCEDURE before_dml (
488: p_action IN VARCHAR2,
489: x_rowid IN VARCHAR2 ,
490: x_igs_en_cpd_ext_id IN NUMBER ,
491: x_enrolment_cat IN VARCHAR2 ,
492: x_enr_method_type IN VARCHAR2 ,
493: x_s_student_comm_type IN VARCHAR2 ,
494: x_step_order_num IN NUMBER ,

Line 521: x_igs_en_cpd_ext_id,

517:
518: set_column_values (
519: p_action,
520: x_rowid,
521: x_igs_en_cpd_ext_id,
522: x_enrolment_cat,
523: x_enr_method_type,
524: x_s_student_comm_type,
525: x_step_order_num,

Line 541: new_references.igs_en_cpd_ext_id

537:
538: IF (p_action = 'INSERT') THEN
539: -- Call all the procedures related to Before Insert.
540: IF ( get_pk_for_validation(
541: new_references.igs_en_cpd_ext_id
542: )
543: ) THEN
544: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
545: igs_ge_msg_stack.add;

Line 557: new_references.igs_en_cpd_ext_id

553: check_parent_existance;
554: ELSIF (p_action = 'VALIDATE_INSERT') THEN
555: -- Call all the procedures related to Before Insert.
556: IF ( get_pk_for_validation (
557: new_references.igs_en_cpd_ext_id
558: )
559: ) THEN
560: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
561: igs_ge_msg_stack.add;

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 581: FROM igs_en_cpd_ext

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
584: AND s_student_comm_type = cp_comm_type
585: AND s_enrolment_Step_type = cp_step_type;

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 668: x_igs_en_cpd_ext_id IN OUT NOCOPY NUMBER,

664:
665:
666: PROCEDURE insert_row (
667: x_rowid IN OUT NOCOPY VARCHAR2,
668: x_igs_en_cpd_ext_id IN OUT NOCOPY NUMBER,
669: x_enrolment_cat IN VARCHAR2,
670: x_enr_method_type IN VARCHAR2,
671: x_s_student_comm_type IN VARCHAR2,
672: x_step_order_num IN NUMBER,

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 692: WHERE igs_en_cpd_ext_id = x_igs_en_cpd_ext_id;

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;
696: x_last_update_login NUMBER;

Line 719: SELECT igs_en_cpd_ext_s.NEXTVAL

715: igs_ge_msg_stack.add;
716: app_exception.raise_exception;
717: END IF;
718:
719: SELECT igs_en_cpd_ext_s.NEXTVAL
720: INTO x_igs_en_cpd_ext_id
721: FROM dual;
722:
723: new_references.org_id := igs_ge_gen_003.get_org_id;

Line 720: INTO x_igs_en_cpd_ext_id

716: app_exception.raise_exception;
717: END IF;
718:
719: SELECT igs_en_cpd_ext_s.NEXTVAL
720: INTO x_igs_en_cpd_ext_id
721: FROM dual;
722:
723: new_references.org_id := igs_ge_gen_003.get_org_id;
724:

Line 728: x_igs_en_cpd_ext_id => x_igs_en_cpd_ext_id,

724:
725: before_dml(
726: p_action => 'INSERT',
727: x_rowid => x_rowid,
728: x_igs_en_cpd_ext_id => x_igs_en_cpd_ext_id,
729: x_enrolment_cat => x_enrolment_cat,
730: x_enr_method_type => x_enr_method_type,
731: x_s_student_comm_type => x_s_student_comm_type,
732: x_step_order_num => x_step_order_num,

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 746: igs_en_cpd_ext_id,

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,
750: s_student_comm_type,

Line 763: new_references.igs_en_cpd_ext_id,

759: last_update_date,
760: last_updated_by,
761: last_update_login
762: ) VALUES (
763: new_references.igs_en_cpd_ext_id,
764: new_references.org_id,
765: new_references.enrolment_cat,
766: new_references.enr_method_type,
767: new_references.s_student_comm_type,

Line 799: x_igs_en_cpd_ext_id IN NUMBER,

795:
796:
797: PROCEDURE lock_row (
798: x_rowid IN VARCHAR2,
799: x_igs_en_cpd_ext_id IN NUMBER,
800: x_enrolment_cat IN VARCHAR2,
801: x_enr_method_type IN VARCHAR2,
802: x_s_student_comm_type IN VARCHAR2,
803: x_step_order_num IN NUMBER,

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 874: x_igs_en_cpd_ext_id IN NUMBER,

870:
871:
872: PROCEDURE update_row (
873: x_rowid IN VARCHAR2,
874: x_igs_en_cpd_ext_id IN NUMBER,
875: x_enrolment_cat IN VARCHAR2,
876: x_enr_method_type IN VARCHAR2,
877: x_s_student_comm_type IN VARCHAR2,
878: x_step_order_num IN NUMBER,

Line 923: x_igs_en_cpd_ext_id => x_igs_en_cpd_ext_id,

919:
920: before_dml(
921: p_action => 'UPDATE',
922: x_rowid => x_rowid,
923: x_igs_en_cpd_ext_id => x_igs_en_cpd_ext_id,
924: x_enrolment_cat => x_enrolment_cat,
925: x_enr_method_type => x_enr_method_type,
926: x_s_student_comm_type => x_s_student_comm_type,
927: x_step_order_num => x_step_order_num,

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 970: x_igs_en_cpd_ext_id IN OUT NOCOPY NUMBER,

966:
967:
968: PROCEDURE add_row (
969: x_rowid IN OUT NOCOPY VARCHAR2,
970: x_igs_en_cpd_ext_id IN OUT NOCOPY NUMBER,
971: x_enrolment_cat IN VARCHAR2,
972: x_enr_method_type IN VARCHAR2,
973: x_s_student_comm_type IN VARCHAR2,
974: x_step_order_num IN NUMBER,

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 994: WHERE igs_en_cpd_ext_id = x_igs_en_cpd_ext_id;

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:
998: OPEN c1;

Line 1005: x_igs_en_cpd_ext_id,

1001: CLOSE c1;
1002:
1003: insert_row (
1004: x_rowid,
1005: x_igs_en_cpd_ext_id,
1006: x_enrolment_cat,
1007: x_enr_method_type,
1008: x_s_student_comm_type,
1009: x_step_order_num,

Line 1023: x_igs_en_cpd_ext_id,

1019: CLOSE c1;
1020:
1021: update_row (
1022: x_rowid,
1023: x_igs_en_cpd_ext_id,
1024: x_enrolment_cat,
1025: x_enr_method_type,
1026: x_s_student_comm_type,
1027: x_step_order_num,

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;

Line 1072: END igs_en_cpd_ext_pkg;

1068: );
1069:
1070: END delete_row;
1071:
1072: END igs_en_cpd_ext_pkg;