APPS.IGS_CA_VAL_DAIP dependencies on IGS_CA_DA_INST_PAIR

Line 72: -- Validate that IGS_CA_DA_INST_PAIR.cal_type and

68: p_message_name OUT NOCOPY VARCHAR2 )
69: RETURN BOOLEAN AS
70: gv_other_detail VARCHAR2(255);
71: BEGIN -- calp_val_daip_ct
72: -- Validate that IGS_CA_DA_INST_PAIR.cal_type and
73: -- IGS_CA_DA_INST_PAIR.related_cal_type are the same.
74: DECLARE
75: BEGIN
76: -- 1. Check parameters

Line 73: -- IGS_CA_DA_INST_PAIR.related_cal_type are the same.

69: RETURN BOOLEAN AS
70: gv_other_detail VARCHAR2(255);
71: BEGIN -- calp_val_daip_ct
72: -- Validate that IGS_CA_DA_INST_PAIR.cal_type and
73: -- IGS_CA_DA_INST_PAIR.related_cal_type are the same.
74: DECLARE
75: BEGIN
76: -- 1. Check parameters
77: IF (p_cal_type IS NULL OR

Line 151: -- Validate that only one IGS_CA_DA_INST_PAIR record is defined for each

147: p_message_name OUT NOCOPY VARCHAR2 )
148: RETURN BOOLEAN AS
149: gv_other_detail VARCHAR2(255);
150: BEGIN -- calp_val_daip_unique
151: -- Validate that only one IGS_CA_DA_INST_PAIR record is defined for each
152: -- IGS_CA_DA_INST.
153: DECLARE
154: CURSOR c_daip IS
155: SELECT 'x'

Line 156: FROM IGS_CA_DA_INST_PAIR daip

152: -- IGS_CA_DA_INST.
153: DECLARE
154: CURSOR c_daip IS
155: SELECT 'x'
156: FROM IGS_CA_DA_INST_PAIR daip
157: WHERE daip.dt_alias = p_dt_alias AND
158: daip.dai_sequence_number = p_dai_sequence_number AND
159: daip.cal_type = p_cal_type AND
160: daip.ci_sequence_number = p_ci_sequence_number AND