APPS.IGS_PR_VAL_PRCT dependencies on IGS_CA_INST

Line 18: -- end_sequence_number. Validate the IGS_CA_INST identified by prg_cal_type

14: RETURN BOOLEAN AS
15: gv_other_detail VARCHAR2(255);
16: BEGIN -- prgp_val_prct_ci
17: -- Validate the IGS_PR_RU_CA_TYPE start_sequence_number and
18: -- end_sequence_number. Validate the IGS_CA_INST identified by prg_cal_type
19: -- and end_sequence_number does NOT have a start_dt before the start_dt of
20: -- the IGS_CA_INST identified by prg_cal_type and start_sequence_number.
21: DECLARE
22: v_dummy VARCHAR2(1);

Line 20: -- the IGS_CA_INST identified by prg_cal_type and start_sequence_number.

16: BEGIN -- prgp_val_prct_ci
17: -- Validate the IGS_PR_RU_CA_TYPE start_sequence_number and
18: -- end_sequence_number. Validate the IGS_CA_INST identified by prg_cal_type
19: -- and end_sequence_number does NOT have a start_dt before the start_dt of
20: -- the IGS_CA_INST identified by prg_cal_type and start_sequence_number.
21: DECLARE
22: v_dummy VARCHAR2(1);
23: CURSOR c_start_ci IS
24: SELECT 'X'

Line 25: FROM IGS_CA_INST ci,

21: DECLARE
22: v_dummy VARCHAR2(1);
23: CURSOR c_start_ci IS
24: SELECT 'X'
25: FROM IGS_CA_INST ci,
26: IGS_CA_STAT cs
27: WHERE ci.cal_type = p_prg_cal_type AND
28: ci.sequence_number = p_start_sequence_number AND
29: ci.cal_status = cs.cal_status AND

Line 33: FROM IGS_CA_INST ci,

29: ci.cal_status = cs.cal_status AND
30: cs.s_cal_status = 'ACTIVE';
31: CURSOR c_end_ci IS
32: SELECT 'X'
33: FROM IGS_CA_INST ci,
34: IGS_CA_STAT cs
35: WHERE ci.cal_type = p_prg_cal_type AND
36: ci.sequence_number = p_end_sequence_number AND
37: ci.cal_status = cs.cal_status AND

Line 41: FROM IGS_CA_INST start_ci,

37: ci.cal_status = cs.cal_status AND
38: cs.s_cal_status = 'ACTIVE';
39: CURSOR c_ci IS
40: SELECT 'X'
41: FROM IGS_CA_INST start_ci,
42: IGS_CA_INST end_ci
43: WHERE start_ci.cal_type = p_prg_cal_type AND
44: start_ci.sequence_number = p_start_sequence_number AND
45: end_ci.cal_type = p_prg_cal_type AND

Line 42: IGS_CA_INST end_ci

38: cs.s_cal_status = 'ACTIVE';
39: CURSOR c_ci IS
40: SELECT 'X'
41: FROM IGS_CA_INST start_ci,
42: IGS_CA_INST end_ci
43: WHERE start_ci.cal_type = p_prg_cal_type AND
44: start_ci.sequence_number = p_start_sequence_number AND
45: end_ci.cal_type = p_prg_cal_type AND
46: end_ci.sequence_number = p_end_sequence_number AND