386: -- OUT NOCOPY parameters are of LOAD Calendar Category
387: cst_fee CONSTANT igs_ca_type.s_cal_cat%TYPE :='FEE';
388:
389: -- Variables to storing Load Calendar Instance
390: l_c_load_cal_type igs_ca_inst_all.cal_type%TYPE;
391: l_n_load_seq_num igs_ca_inst_all.sequence_number%TYPE;
392:
393: l_c_message_name fnd_new_messages.message_name%TYPE;
394:
387: cst_fee CONSTANT igs_ca_type.s_cal_cat%TYPE :='FEE';
388:
389: -- Variables to storing Load Calendar Instance
390: l_c_load_cal_type igs_ca_inst_all.cal_type%TYPE;
391: l_n_load_seq_num igs_ca_inst_all.sequence_number%TYPE;
392:
393: l_c_message_name fnd_new_messages.message_name%TYPE;
394:
395: -- Check the system status of the load calendar instance, should be ACTIVE before a FTCI is created
392:
393: l_c_message_name fnd_new_messages.message_name%TYPE;
394:
395: -- Check the system status of the load calendar instance, should be ACTIVE before a FTCI is created
396: CURSOR cur_load_cal_status (cp_load_cal_type igs_ca_inst_all.cal_type%TYPE ,
397: cp_load_cal_seq_num igs_ca_inst_all.sequence_number%TYPE)
398: IS
399: SELECT s.s_cal_status
400: FROM igs_ca_inst i,
393: l_c_message_name fnd_new_messages.message_name%TYPE;
394:
395: -- Check the system status of the load calendar instance, should be ACTIVE before a FTCI is created
396: CURSOR cur_load_cal_status (cp_load_cal_type igs_ca_inst_all.cal_type%TYPE ,
397: cp_load_cal_seq_num igs_ca_inst_all.sequence_number%TYPE)
398: IS
399: SELECT s.s_cal_status
400: FROM igs_ca_inst i,
401: igs_ca_stat s