APPS.IGS_CA_INS_ROLL_CI dependencies on IGS_CA_STAT

Line 151: v_derived_cal_status IGS_CA_STAT.s_cal_status%TYPE;

147: v_dai_found BOOLEAN;
148: v_ci_found BOOLEAN;
149: v_related_dt_alias IGS_CA_DA_INST_PAIR.related_dt_alias%TYPE;
150: v_dt_alias IGS_CA_DA_INST_PAIR.DT_ALIAS%TYPE;
151: v_derived_cal_status IGS_CA_STAT.s_cal_status%TYPE;
152: v_val_start_dt IGS_CA_INST.start_dt%TYPE;
153: v_val_end_dt IGS_CA_INST.end_dt%TYPE;
154: v_dairn_start_dt IGS_CA_INST.start_dt%TYPE;
155: v_dairn_end_dt IGS_CA_INST.end_dt%TYPE;

Line 195: cp_cal_status IGS_CA_STAT.CAL_STATUS%TYPE) IS

191: WHERE CAL_TYPE = cp_cal_type AND
192: start_dt = cp_start_dt AND
193: end_dt = cp_end_dt;
194: CURSOR c_derived_cal_status(
195: cp_cal_status IGS_CA_STAT.CAL_STATUS%TYPE) IS
196: SELECT *
197: FROM IGS_CA_STAT
198: WHERE CAL_STATUS = cp_cal_status;
199: CURSOR c_s_log_entry_dai(

Line 197: FROM IGS_CA_STAT

193: end_dt = cp_end_dt;
194: CURSOR c_derived_cal_status(
195: cp_cal_status IGS_CA_STAT.CAL_STATUS%TYPE) IS
196: SELECT *
197: FROM IGS_CA_STAT
198: WHERE CAL_STATUS = cp_cal_status;
199: CURSOR c_s_log_entry_dai(
200: cp_s_log_type IGS_GE_S_LOG_ENTRY.s_log_type%TYPE,
201: cp_creation_dt IGS_GE_S_LOG_ENTRY.creation_dt%TYPE,

Line 765: v_derived_cal_status IGS_CA_STAT.s_cal_status%TYPE;

761: v_dai_found BOOLEAN;
762: v_ci_found BOOLEAN;
763: v_offset_dt_alias IGS_CA_DA_INST_OFST.offset_dt_alias%TYPE;
764: v_dt_alias IGS_CA_DA_INST_OFST.DT_ALIAS%TYPE;
765: v_derived_cal_status IGS_CA_STAT.s_cal_status%TYPE;
766: v_val_start_dt IGS_CA_INST.start_dt%TYPE;
767: v_val_end_dt IGS_CA_INST.end_dt%TYPE;
768: v_dairn_start_dt IGS_CA_INST.start_dt%TYPE;
769: v_dairn_end_dt IGS_CA_INST.end_dt%TYPE;

Line 809: cp_cal_status IGS_CA_STAT.CAL_STATUS%TYPE) IS

805: WHERE CAL_TYPE = cp_cal_type AND
806: start_dt = cp_start_dt AND
807: end_dt = cp_end_dt;
808: CURSOR c_derived_cal_status(
809: cp_cal_status IGS_CA_STAT.CAL_STATUS%TYPE) IS
810: SELECT *
811: FROM IGS_CA_STAT
812: WHERE CAL_STATUS = cp_cal_status;
813: CURSOR c_s_log_entry_dai(

Line 811: FROM IGS_CA_STAT

807: end_dt = cp_end_dt;
808: CURSOR c_derived_cal_status(
809: cp_cal_status IGS_CA_STAT.CAL_STATUS%TYPE) IS
810: SELECT *
811: FROM IGS_CA_STAT
812: WHERE CAL_STATUS = cp_cal_status;
813: CURSOR c_s_log_entry_dai(
814: cp_s_log_type IGS_GE_S_LOG_ENTRY.s_log_type%TYPE,
815: cp_creation_dt IGS_GE_S_LOG_ENTRY.creation_dt%TYPE,

Line 1656: IGS_CA_STAT cs

1652: SELECT ci.CAL_TYPE,
1653: ci.sequence_number,
1654: cs.s_cal_status
1655: FROM IGS_CA_INST ci,
1656: IGS_CA_STAT cs
1657: WHERE ci.CAL_TYPE = cp_cal_type AND
1658: ci.start_dt = cp_start_dt AND
1659: ci.end_dt = cp_end_dt AND
1660: ci.CAL_STATUS = cs.CAL_STATUS;

Line 2076: FROM IGS_CA_STAT

2072: sequence_number = p_sequence_number;
2073: CURSOR c_cal_status(
2074: cp_cal_status IGS_CA_INST.CAL_STATUS%TYPE) IS
2075: SELECT *
2076: FROM IGS_CA_STAT
2077: WHERE CAL_STATUS = cp_cal_status;
2078: BEGIN
2079:
2080: p_message_name:=null;

Line 2145: v_new_cal_status IGS_CA_STAT.CAL_STATUS%TYPE;

2141: v_new_end_dt IGS_CA_INST.end_dt%TYPE;
2142: v_new_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
2143: v_new_alternate_code IGS_CA_INST.alternate_code%TYPE;
2144: l_n_org_id IGS_CA_INST.ORG_ID%TYPE := igs_ge_gen_003.get_org_id;
2145: v_new_cal_status IGS_CA_STAT.CAL_STATUS%TYPE;
2146: v_message_name VARCHAR2(30);
2147: v_cal_instance_rec IGS_CA_INST%ROWTYPE;
2148: v_new_cal_instance_rec IGS_CA_INST%ROWTYPE;
2149: v_cal_type_rec IGS_CA_TYPE%ROWTYPE;

Line 2171: FROM IGS_CA_STAT

2167: end_dt = cp_end_dt;
2168: CURSOR c_cal_status(
2169: cp_cal_status IGS_CA_INST.CAL_STATUS%TYPE) IS
2170: SELECT *
2171: FROM IGS_CA_STAT
2172: WHERE s_cal_status = cp_cal_status;
2173: CURSOR c_cal_type(
2174: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE) IS
2175: SELECT *