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_PS_VALIDATE_LGCY_PKG dependencies on IGS_CA_INST_ALL

Line 627: p_n_seq_num IN igs_ca_inst_all.sequence_number%TYPE,

623:
624: -- Validate Unit Offer Option Records before inserting them
625: PROCEDURE validate_uoo ( p_usec_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rec_type,
626: p_c_cal_type IN igs_ca_type.cal_type%TYPE,
627: p_n_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
628: p_n_sup_uoo_id IN OUT NOCOPY igs_ps_unit_ofr_opt_all.sup_uoo_id%TYPE,
629: p_insert_update VARCHAR2,
630: p_conc_flag OUT NOCOPY BOOLEAN)
631: AS

Line 675: cp_load_start_dt igs_ca_inst_all.start_dt%TYPE) IS

671: rec_anon_unit_grading c_anon_unit_grading%ROWTYPE;
672:
673: CURSOR c_anon_grd_method ( cp_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE,
674: cp_ci_seq_num igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE,
675: cp_load_start_dt igs_ca_inst_all.start_dt%TYPE) IS
676: SELECT 1
677: FROM igs_ca_teach_to_load_v a,
678: igs_as_anon_method b
679: WHERE a.teach_cal_type = cp_cal_type

Line 692: l_load_start_dt igs_ca_inst_all.start_dt%TYPE;

688: FROM igs_ca_teach_to_load_v c
689: WHERE c.teach_cal_type = cp_cal_type
690: AND c.teach_ci_sequence_number = cp_ci_seq_num ;
691:
692: l_load_start_dt igs_ca_inst_all.start_dt%TYPE;
693:
694: CURSOR c_anon_assess_grading ( cp_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
695: cp_version_number igs_ps_unit_ver_all.version_number%TYPE ) IS
696: SELECT 1

Line 705: CURSOR c_cal_status ( cp_c_cal_type igs_ca_inst_all.cal_type%TYPE,

701: rec_anon_assess_grading c_anon_assess_grading%ROWTYPE;
702:
703: --Enh bug#2972950
704: --For PSP Enhancements the following cursor was added
705: CURSOR c_cal_status ( cp_c_cal_type igs_ca_inst_all.cal_type%TYPE,
706: cp_n_ci_seq_num igs_ca_inst_all.sequence_number%TYPE ) IS
707: SELECT B.s_cal_status
708: FROM igs_ca_inst_all A,igs_ca_stat B
709: WHERE A.cal_type = cp_c_cal_type

Line 706: cp_n_ci_seq_num igs_ca_inst_all.sequence_number%TYPE ) IS

702:
703: --Enh bug#2972950
704: --For PSP Enhancements the following cursor was added
705: CURSOR c_cal_status ( cp_c_cal_type igs_ca_inst_all.cal_type%TYPE,
706: cp_n_ci_seq_num igs_ca_inst_all.sequence_number%TYPE ) IS
707: SELECT B.s_cal_status
708: FROM igs_ca_inst_all A,igs_ca_stat B
709: WHERE A.cal_type = cp_c_cal_type
710: AND A.sequence_number = cp_n_ci_seq_num

Line 708: FROM igs_ca_inst_all A,igs_ca_stat B

704: --For PSP Enhancements the following cursor was added
705: CURSOR c_cal_status ( cp_c_cal_type igs_ca_inst_all.cal_type%TYPE,
706: cp_n_ci_seq_num igs_ca_inst_all.sequence_number%TYPE ) IS
707: SELECT B.s_cal_status
708: FROM igs_ca_inst_all A,igs_ca_stat B
709: WHERE A.cal_type = cp_c_cal_type
710: AND A.sequence_number = cp_n_ci_seq_num
711: AND A.cal_status = B.cal_status;
712:

Line 751: cal_type igs_ca_inst_all.cal_type%TYPE,

747: WHERE uoo.uoo_id = cp_uoo_id;
748:
749:
750: TYPE teach_cal_rec IS RECORD(
751: cal_type igs_ca_inst_all.cal_type%TYPE,
752: sequence_number igs_ca_inst_all.sequence_number%TYPE
753: );
754: TYPE teachCalendar IS TABLE OF teach_cal_rec INDEX BY BINARY_INTEGER;
755: teachCalendar_tbl teachCalendar;

Line 752: sequence_number igs_ca_inst_all.sequence_number%TYPE

748:
749:
750: TYPE teach_cal_rec IS RECORD(
751: cal_type igs_ca_inst_all.cal_type%TYPE,
752: sequence_number igs_ca_inst_all.sequence_number%TYPE
753: );
754: TYPE teachCalendar IS TABLE OF teach_cal_rec INDEX BY BINARY_INTEGER;
755: teachCalendar_tbl teachCalendar;
756: l_n_counter NUMBER(10);

Line 774: cp_seq_num igs_ca_inst_all.sequence_number%TYPE ) IS

770: WHERE teach_cal_type = cp_cal_teach_type
771: AND teach_ci_sequence_number = cp_teach_ci_sequence_number;
772:
773: CURSOR c_teach_to_load ( cp_cal_type igs_ca_type.cal_type%TYPE,
774: cp_seq_num igs_ca_inst_all.sequence_number%TYPE ) IS
775: SELECT load_cal_type lcal_type, load_ci_sequence_number lseq_num
776: FROM igs_ca_teach_to_load_v
777: WHERE
778: teach_cal_type = cp_cal_type AND

Line 830: FUNCTION testCalendar(cp_cal_type igs_ca_inst_all.cal_type%TYPE,

826: l_n_sup_uoo_id igs_ps_unit_ofr_opt_all.sup_uoo_id%TYPE;
827: l_c_valid_fail BOOLEAN := FALSE;
828: l_c_var VARCHAR2(1);
829:
830: FUNCTION testCalendar(cp_cal_type igs_ca_inst_all.cal_type%TYPE,
831: cp_sequence_number igs_ca_inst_all.sequence_number%TYPE) RETURN BOOLEAN AS
832: BEGIN
833: IF teachCalendar_tbl.EXISTS(1) THEN
834: FOR i IN 1..teachCalendar_tbl.last LOOP

Line 831: cp_sequence_number igs_ca_inst_all.sequence_number%TYPE) RETURN BOOLEAN AS

827: l_c_valid_fail BOOLEAN := FALSE;
828: l_c_var VARCHAR2(1);
829:
830: FUNCTION testCalendar(cp_cal_type igs_ca_inst_all.cal_type%TYPE,
831: cp_sequence_number igs_ca_inst_all.sequence_number%TYPE) RETURN BOOLEAN AS
832: BEGIN
833: IF teachCalendar_tbl.EXISTS(1) THEN
834: FOR i IN 1..teachCalendar_tbl.last LOOP
835: IF cp_cal_type=teachCalendar_tbl(i).cal_type AND

Line 1663: FROM igs_ps_unit_ofr_opt_all a,igs_ca_inst_all b

1659: rec_usec_gs_count c_usec_gs_count%ROWTYPE;
1660:
1661: CURSOR c_uoo_id (cp_usec_gs_rec IN OUT NOCOPY igs_ps_generic_pub.usec_gs_rec_type) IS
1662: SELECT uoo_id
1663: FROM igs_ps_unit_ofr_opt_all a,igs_ca_inst_all b
1664: WHERE a.unit_cd = cp_usec_gs_rec.unit_cd
1665: AND a.version_number = cp_usec_gs_rec.version_number
1666: AND a.cal_type = b.cal_type
1667: AND a.ci_sequence_number = b.sequence_number

Line 1710: p_d_start_date IN igs_ca_inst_all.start_dt%TYPE,

1706: END post_usec_grd_sch;
1707:
1708: PROCEDURE validate_usec_occurs ( p_uso_rec IN OUT NOCOPY igs_ps_generic_pub.uso_rec_type,
1709: p_n_uoo_id IN igs_ps_unit_ofr_opt_all.uoo_id%TYPE,
1710: p_d_start_date IN igs_ca_inst_all.start_dt%TYPE,
1711: p_d_end_date IN igs_ca_inst_all.end_dt%TYPE,
1712: p_n_building_code IN NUMBER,
1713: p_n_room_code IN NUMBER,
1714: p_n_dedicated_building_code IN NUMBER,

Line 1711: p_d_end_date IN igs_ca_inst_all.end_dt%TYPE,

1707:
1708: PROCEDURE validate_usec_occurs ( p_uso_rec IN OUT NOCOPY igs_ps_generic_pub.uso_rec_type,
1709: p_n_uoo_id IN igs_ps_unit_ofr_opt_all.uoo_id%TYPE,
1710: p_d_start_date IN igs_ca_inst_all.start_dt%TYPE,
1711: p_d_end_date IN igs_ca_inst_all.end_dt%TYPE,
1712: p_n_building_code IN NUMBER,
1713: p_n_room_code IN NUMBER,
1714: p_n_dedicated_building_code IN NUMBER,
1715: p_n_dedicated_room_code IN NUMBER,

Line 2736: p_n_seq_num IN igs_ca_inst_all.sequence_number%TYPE ) RETURN BOOLEAN

2732: CLOSE c_uoo_id;
2733: END get_uoo_id;
2734:
2735: FUNCTION validate_waitlist_allowed ( p_c_cal_type IN igs_ca_type.cal_type%TYPE,
2736: p_n_seq_num IN igs_ca_inst_all.sequence_number%TYPE ) RETURN BOOLEAN
2737: AS
2738: /***********************************************************************************************
2739: Created By : shtatiko
2740: Date Created By: 21-NOV-2002

Line 2750: cp_n_seq_num igs_ca_inst_all.sequence_number%TYPE ) IS

2746: Who When What
2747: smvk 10-Oct-2003 Bug # 3052445. Modified the procedure.
2748: ********************************************************************************************** */
2749: CURSOR c_waitlist_allowed ( cp_c_cal_type igs_ca_type.cal_type%TYPE,
2750: cp_n_seq_num igs_ca_inst_all.sequence_number%TYPE ) IS
2751: SELECT inst.waitlist_alwd
2752: FROM igs_en_inst_wlst_opt inst,
2753: igs_ca_load_to_teach_v lot
2754: WHERE

Line 2816: FUNCTION validate_cal_cat ( p_c_cal_type IN igs_ca_inst_all.cal_type%TYPE,

2812: RETURN FALSE;
2813: END IF;
2814: END validate_gs_type;
2815:
2816: FUNCTION validate_cal_cat ( p_c_cal_type IN igs_ca_inst_all.cal_type%TYPE,
2817: p_c_cal_cat IN igs_ca_type.s_cal_cat%TYPE) RETURN BOOLEAN
2818: AS
2819: /***********************************************************************************************
2820: Created By : shtatiko

Line 2829: CURSOR c_cal ( cp_cal_type igs_ca_inst_all.cal_type%TYPE,

2825: Known limitations,enhancements,remarks:
2826: Change History (in reverse chronological order)
2827: Who When What
2828: ********************************************************************************************** */
2829: CURSOR c_cal ( cp_cal_type igs_ca_inst_all.cal_type%TYPE,
2830: cp_cal_cat igs_ca_type.s_cal_cat%TYPE ) IS
2831: SELECT 1
2832: FROM igs_ca_type
2833: WHERE

Line 3992: l_d_start_dt igs_ca_inst_all.start_dt%TYPE;

3988: ***********************************************************************************************/
3989:
3990: l_c_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE;
3991: l_n_seq_num igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE;
3992: l_d_start_dt igs_ca_inst_all.start_dt%TYPE;
3993: l_d_end_dt igs_ca_inst_all.end_dt%TYPE;
3994: l_c_message VARCHAR2(30);
3995: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;
3996:

Line 3993: l_d_end_dt igs_ca_inst_all.end_dt%TYPE;

3989:
3990: l_c_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE;
3991: l_n_seq_num igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE;
3992: l_d_start_dt igs_ca_inst_all.start_dt%TYPE;
3993: l_d_end_dt igs_ca_inst_all.end_dt%TYPE;
3994: l_c_message VARCHAR2(30);
3995: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;
3996:
3997: CURSOR c_uso_chk(p_n_uso_id NUMBER) IS