APPS.IGS_PS_UNIT_OFR_OPT_PKG dependencies on IGS_CA_TYPE

Line 966: FUNCTION get_call_number ( p_c_cal_type IN igs_ca_type.cal_type%TYPE,

962: END IF;
963:
964: END Check_Parent_Existance;
965:
966: FUNCTION get_call_number ( p_c_cal_type IN igs_ca_type.cal_type%TYPE,
967: p_n_seq_num IN igs_ca_inst_all.sequence_number%TYPE ) RETURN NUMBER AS
968:
969: -- Cursor to lock all the load calendars for the given teaching calendar instance
970: -- in the table igs_ps_usec_cal_nums

Line 994: CURSOR c_call_number ( cp_cal_type igs_ca_type.cal_type%TYPE,

990: b.teach_cal_type = cp_c_cal_type AND
991: b.teach_ci_sequence_number = cp_n_seq_num;
992:
993: -- Cursor to get the information of igs_ps_usec_cal_nums record, for updating the record
994: CURSOR c_call_number ( cp_cal_type igs_ca_type.cal_type%TYPE,
995: cp_seq_num igs_ca_inst_all.sequence_number%TYPE ) IS
996: SELECT rowid ROW_ID, unit_section_call_number_id call_id
997: FROM igs_ps_usec_cal_nums
998: WHERE calender_type = cp_cal_type AND

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

1000:
1001: rec_call_number c_call_number%ROWTYPE;
1002:
1003: -- Cursor to get load claendar instance information for creating new records in igs_ps_usec_cal_nums
1004: CURSOR c_teach_to_load ( cp_cal_type igs_ca_type.cal_type%TYPE,
1005: cp_seq_num igs_ca_inst_all.sequence_number%TYPE ) IS
1006: SELECT load_cal_type lcal_type, load_ci_sequence_number lseq_num
1007: FROM igs_ca_teach_to_load_v
1008: WHERE