APPS.IGS_PS_VAL_UAI dependencies on IGS_CA_INST

Line 39: cp_cal_type IGS_CA_INST_ALL.cal_type%TYPE,

35:
36: cst_active CONSTANT VARCHAR2(8) := 'ACTIVE';
37: v_s_cal_status IGS_CA_STAT.s_cal_status%TYPE;
38: CURSOR c_cal_status(
39: cp_cal_type IGS_CA_INST_ALL.cal_type%TYPE,
40: cp_ci_sequence_number IGS_CA_INST_ALL.sequence_number%TYPE) IS
41: SELECT IGS_CA_STAT.s_cal_status
42: FROM IGS_CA_INST, IGS_CA_STAT
43: WHERE IGS_CA_INST.cal_type = cp_cal_type AND

Line 40: cp_ci_sequence_number IGS_CA_INST_ALL.sequence_number%TYPE) IS

36: cst_active CONSTANT VARCHAR2(8) := 'ACTIVE';
37: v_s_cal_status IGS_CA_STAT.s_cal_status%TYPE;
38: CURSOR c_cal_status(
39: cp_cal_type IGS_CA_INST_ALL.cal_type%TYPE,
40: cp_ci_sequence_number IGS_CA_INST_ALL.sequence_number%TYPE) IS
41: SELECT IGS_CA_STAT.s_cal_status
42: FROM IGS_CA_INST, IGS_CA_STAT
43: WHERE IGS_CA_INST.cal_type = cp_cal_type AND
44: IGS_CA_INST.sequence_number = cp_ci_sequence_number AND

Line 42: FROM IGS_CA_INST, IGS_CA_STAT

38: CURSOR c_cal_status(
39: cp_cal_type IGS_CA_INST_ALL.cal_type%TYPE,
40: cp_ci_sequence_number IGS_CA_INST_ALL.sequence_number%TYPE) IS
41: SELECT IGS_CA_STAT.s_cal_status
42: FROM IGS_CA_INST, IGS_CA_STAT
43: WHERE IGS_CA_INST.cal_type = cp_cal_type AND
44: IGS_CA_INST.sequence_number = cp_ci_sequence_number AND
45: IGS_CA_INST.cal_status = IGS_CA_STAT.cal_status;
46: v_other_detail VARCHAR2(255);

Line 43: WHERE IGS_CA_INST.cal_type = cp_cal_type AND

39: cp_cal_type IGS_CA_INST_ALL.cal_type%TYPE,
40: cp_ci_sequence_number IGS_CA_INST_ALL.sequence_number%TYPE) IS
41: SELECT IGS_CA_STAT.s_cal_status
42: FROM IGS_CA_INST, IGS_CA_STAT
43: WHERE IGS_CA_INST.cal_type = cp_cal_type AND
44: IGS_CA_INST.sequence_number = cp_ci_sequence_number AND
45: IGS_CA_INST.cal_status = IGS_CA_STAT.cal_status;
46: v_other_detail VARCHAR2(255);
47: BEGIN

Line 44: IGS_CA_INST.sequence_number = cp_ci_sequence_number AND

40: cp_ci_sequence_number IGS_CA_INST_ALL.sequence_number%TYPE) IS
41: SELECT IGS_CA_STAT.s_cal_status
42: FROM IGS_CA_INST, IGS_CA_STAT
43: WHERE IGS_CA_INST.cal_type = cp_cal_type AND
44: IGS_CA_INST.sequence_number = cp_ci_sequence_number AND
45: IGS_CA_INST.cal_status = IGS_CA_STAT.cal_status;
46: v_other_detail VARCHAR2(255);
47: BEGIN
48: P_MESSAGE_NAME := null;

Line 45: IGS_CA_INST.cal_status = IGS_CA_STAT.cal_status;

41: SELECT IGS_CA_STAT.s_cal_status
42: FROM IGS_CA_INST, IGS_CA_STAT
43: WHERE IGS_CA_INST.cal_type = cp_cal_type AND
44: IGS_CA_INST.sequence_number = cp_ci_sequence_number AND
45: IGS_CA_INST.cal_status = IGS_CA_STAT.cal_status;
46: v_other_detail VARCHAR2(255);
47: BEGIN
48: P_MESSAGE_NAME := null;
49: OPEN c_cal_status(