APPS.IGS_PS_VALIDATE_LGCY_PKG dependencies on IGS_CA_TYPE

Line 626: p_c_cal_type IN igs_ca_type.cal_type%TYPE,

622:
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)

Line 773: CURSOR c_teach_to_load ( cp_cal_type igs_ca_type.cal_type%TYPE,

769: FROM igs_ca_load_to_teach_v
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

Line 2735: FUNCTION validate_waitlist_allowed ( p_c_cal_type IN igs_ca_type.cal_type%TYPE,

2731: END IF;
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

Line 2749: CURSOR c_waitlist_allowed ( cp_c_cal_type igs_ca_type.cal_type%TYPE,

2745: Change History (in reverse chronological order)
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

Line 2817: p_c_cal_cat IN igs_ca_type.s_cal_cat%TYPE) RETURN BOOLEAN

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
2821: Date Created By: 21-NOV-2002

Line 2830: cp_cal_cat igs_ca_type.s_cal_cat%TYPE ) IS

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
2834: s_cal_cat = cp_cal_cat AND

Line 2832: FROM igs_ca_type

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
2834: s_cal_cat = cp_cal_cat AND
2835: cal_type = cp_cal_type;
2836: rec_cal c_cal%ROWTYPE;