APPS.IGS_PR_GEN_005 dependencies on IGS_PR_S_PRG_CAL

Line 24: v_stream_number igs_pr_s_prg_cal.stream_num%TYPE;

20: v_cutoff_dt DATE;
21: v_level VARCHAR2 (10);
22: v_org_unit_cd igs_or_unit.org_unit_cd%TYPE;
23: v_ou_start_dt igs_or_unit.start_dt%TYPE;
24: v_stream_number igs_pr_s_prg_cal.stream_num%TYPE;
25: v_show_cause_length igs_pr_s_prg_cal.show_cause_length%TYPE;
26: v_appeal_length igs_pr_s_prg_cal.appeal_length%TYPE;
27: BEGIN
28: IF igs_pr_gen_005.igs_pr_get_appeal_alwd (

Line 25: v_show_cause_length igs_pr_s_prg_cal.show_cause_length%TYPE;

21: v_level VARCHAR2 (10);
22: v_org_unit_cd igs_or_unit.org_unit_cd%TYPE;
23: v_ou_start_dt igs_or_unit.start_dt%TYPE;
24: v_stream_number igs_pr_s_prg_cal.stream_num%TYPE;
25: v_show_cause_length igs_pr_s_prg_cal.show_cause_length%TYPE;
26: v_appeal_length igs_pr_s_prg_cal.appeal_length%TYPE;
27: BEGIN
28: IF igs_pr_gen_005.igs_pr_get_appeal_alwd (
29: p_progression_rule_cat,

Line 26: v_appeal_length igs_pr_s_prg_cal.appeal_length%TYPE;

22: v_org_unit_cd igs_or_unit.org_unit_cd%TYPE;
23: v_ou_start_dt igs_or_unit.start_dt%TYPE;
24: v_stream_number igs_pr_s_prg_cal.stream_num%TYPE;
25: v_show_cause_length igs_pr_s_prg_cal.show_cause_length%TYPE;
26: v_appeal_length igs_pr_s_prg_cal.appeal_length%TYPE;
27: BEGIN
28: IF igs_pr_gen_005.igs_pr_get_appeal_alwd (
29: p_progression_rule_cat,
30: p_pra_sequence_number,

Line 97: v_stream_number igs_pr_s_prg_cal.stream_num%TYPE;

93: cst_sc CONSTANT VARCHAR2 (10) := 'SC';
94: v_level VARCHAR2 (10);
95: v_org_unit_cd igs_or_unit.org_unit_cd%TYPE;
96: v_ou_start_dt igs_or_unit.start_dt%TYPE;
97: v_stream_number igs_pr_s_prg_cal.stream_num%TYPE;
98: v_show_cause_length igs_pr_s_prg_cal.show_cause_length%TYPE;
99: v_appeal_length igs_pr_s_prg_cal.appeal_length%TYPE;
100: v_expiry_dt DATE;
101: v_cutoff_dt DATE;

Line 98: v_show_cause_length igs_pr_s_prg_cal.show_cause_length%TYPE;

94: v_level VARCHAR2 (10);
95: v_org_unit_cd igs_or_unit.org_unit_cd%TYPE;
96: v_ou_start_dt igs_or_unit.start_dt%TYPE;
97: v_stream_number igs_pr_s_prg_cal.stream_num%TYPE;
98: v_show_cause_length igs_pr_s_prg_cal.show_cause_length%TYPE;
99: v_appeal_length igs_pr_s_prg_cal.appeal_length%TYPE;
100: v_expiry_dt DATE;
101: v_cutoff_dt DATE;
102: BEGIN

Line 99: v_appeal_length igs_pr_s_prg_cal.appeal_length%TYPE;

95: v_org_unit_cd igs_or_unit.org_unit_cd%TYPE;
96: v_ou_start_dt igs_or_unit.start_dt%TYPE;
97: v_stream_number igs_pr_s_prg_cal.stream_num%TYPE;
98: v_show_cause_length igs_pr_s_prg_cal.show_cause_length%TYPE;
99: v_appeal_length igs_pr_s_prg_cal.appeal_length%TYPE;
100: v_expiry_dt DATE;
101: v_cutoff_dt DATE;
102: BEGIN
103: IF igs_pr_gen_005.igs_pr_get_cause_alwd (

Line 1275: FROM igs_pr_s_prg_cal spc1,

1271: WHERE ci2.cal_type = p_prg_cal_type
1272: AND ci2.sequence_number = p_prg_ci_sequence_number)
1273: AND (-- Logic from CALP_GET_CAL_STREAM.
1274: EXISTS ( SELECT 'x'
1275: FROM igs_pr_s_prg_cal spc1,
1276: igs_pr_s_prg_cal spc2
1277: WHERE spc1.s_control_num = 1
1278: AND spc2.s_control_num = 1
1279: AND spc1.prg_cal_type = p_prg_cal_type

Line 1276: igs_pr_s_prg_cal spc2

1272: AND ci2.sequence_number = p_prg_ci_sequence_number)
1273: AND (-- Logic from CALP_GET_CAL_STREAM.
1274: EXISTS ( SELECT 'x'
1275: FROM igs_pr_s_prg_cal spc1,
1276: igs_pr_s_prg_cal spc2
1277: WHERE spc1.s_control_num = 1
1278: AND spc2.s_control_num = 1
1279: AND spc1.prg_cal_type = p_prg_cal_type
1280: AND spc2.prg_cal_type = ci1.cal_type