APPS.IGS_FI_VAL_FTCI dependencies on IGS_CA_INST

Line 42: v_sub_cal_type IGS_CA_INST_REL.sub_cal_type%TYPE;

38: BEGIN -- finp_val_ftci_account
39: -- Validate the IGS_FI_F_TYP_CA_INST calendar instance
40: -- is a subordinate of the IGS_FI_ACC finace calendar instance.
41: DECLARE
42: v_sub_cal_type IGS_CA_INST_REL.sub_cal_type%TYPE;
43: CURSOR c_cir IS
44: SELECT sub_cal_type
45: FROM IGS_CA_INST_REL
46: WHERE sub_cal_type = p_fee_cal_type AND

Line 45: FROM IGS_CA_INST_REL

41: DECLARE
42: v_sub_cal_type IGS_CA_INST_REL.sub_cal_type%TYPE;
43: CURSOR c_cir IS
44: SELECT sub_cal_type
45: FROM IGS_CA_INST_REL
46: WHERE sub_cal_type = p_fee_cal_type AND
47: sub_ci_sequence_number = p_fee_ci_sequence_number ;
48: BEGIN
49: -- Set the default message number

Line 81: v_sub_cal_type IGS_CA_INST_REL.sub_cal_type%TYPE;

77: RETURN BOOLEAN AS
78: gv_other_detail VARCHAR2(255);
79: BEGIN
80: DECLARE
81: v_sub_cal_type IGS_CA_INST_REL.sub_cal_type%TYPE;
82: cst_cal_cat CONSTANT VARCHAR2(8):= 'TEACHING';
83: CURSOR c_cir IS
84: SELECT cir.sub_cal_type
85: FROM IGS_CA_INST_REL cir

Line 85: FROM IGS_CA_INST_REL cir

81: v_sub_cal_type IGS_CA_INST_REL.sub_cal_type%TYPE;
82: cst_cal_cat CONSTANT VARCHAR2(8):= 'TEACHING';
83: CURSOR c_cir IS
84: SELECT cir.sub_cal_type
85: FROM IGS_CA_INST_REL cir
86: WHERE cir.sub_cal_type = p_fee_cal_type AND
87: cir.sub_ci_sequence_number = p_fee_ci_sequence_number AND
88: cir.sup_cal_type IN ( SELECT ct.CAL_TYPE
89: FROM IGS_CA_TYPE ct

Line 375: FROM IGS_CA_INST ci,

371: fcfl.fee_ci_sequence_number = p_fee_ci_sequence_number;
372: CURSOR c_fee_ci IS
373: SELECT cs.s_cal_status,
374: ct.S_CAL_CAT
375: FROM IGS_CA_INST ci,
376: IGS_CA_TYPE ct,
377: IGS_CA_STAT cs
378: WHERE ci.CAL_TYPE = p_fee_cal_type AND
379: ci.sequence_number = p_fee_ci_sequence_number AND

Line 390: l_c_load_cal_type igs_ca_inst_all.cal_type%TYPE;

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:

Line 391: l_n_load_seq_num igs_ca_inst_all.sequence_number%TYPE;

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

Line 396: CURSOR cur_load_cal_status (cp_load_cal_type igs_ca_inst_all.cal_type%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
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,

Line 397: cp_load_cal_seq_num igs_ca_inst_all.sequence_number%TYPE)

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

Line 400: FROM igs_ca_inst i,

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
402: WHERE s.cal_status = i.cal_status
403: AND i.cal_type = cp_load_cal_type
404: AND i.sequence_number = cp_load_cal_seq_num;