APPS.IGS_PR_VAL_SPCA dependencies on IGS_PR_S_PRG_CONF

Line 19: v_appeal_ind IGS_PR_S_PRG_CONF.appeal_ind%TYPE;

15: -- Validate the appeal length field checking for,
16: -- * Cannot be set if s_prg_conf.appeal_ind is N
17: -- * Warn if not set if s_prg_conf.appeal_ind is Y
18: DECLARE
19: v_appeal_ind IGS_PR_S_PRG_CONF.appeal_ind%TYPE;
20: CURSOR c_sprgc IS
21: SELECT sprgc.appeal_ind
22: FROM IGS_PR_S_PRG_CONF sprgc
23: WHERE sprgc.s_control_num = 1;

Line 22: FROM IGS_PR_S_PRG_CONF sprgc

18: DECLARE
19: v_appeal_ind IGS_PR_S_PRG_CONF.appeal_ind%TYPE;
20: CURSOR c_sprgc IS
21: SELECT sprgc.appeal_ind
22: FROM IGS_PR_S_PRG_CONF sprgc
23: WHERE sprgc.s_control_num = 1;
24: BEGIN
25: -- Set the default message name
26: p_message_name := Null;

Line 71: v_show_cause_ind IGS_PR_S_PRG_CONF.show_cause_ind%TYPE;

67: -- Validate the show cause length field checking for,
68: -- * Cannot be set if s_prg_conf.show_cause_ind is N
69: -- * Warn if not set if s_prg_conf.show_cause_ind is Y
70: DECLARE
71: v_show_cause_ind IGS_PR_S_PRG_CONF.show_cause_ind%TYPE;
72: CURSOR c_sprgc IS
73: SELECT sprgc.show_cause_ind
74: FROM IGS_PR_S_PRG_CONF sprgc
75: WHERE sprgc.s_control_num = 1;

Line 74: FROM IGS_PR_S_PRG_CONF sprgc

70: DECLARE
71: v_show_cause_ind IGS_PR_S_PRG_CONF.show_cause_ind%TYPE;
72: CURSOR c_sprgc IS
73: SELECT sprgc.show_cause_ind
74: FROM IGS_PR_S_PRG_CONF sprgc
75: WHERE sprgc.s_control_num = 1;
76: BEGIN
77: -- Set the default message name
78: p_message_name := Null;