APPS.IGS_PR_VAL_SOPC dependencies on IGS_PR_S_PRG_CONF

Line 116: v_appeal_ind IGS_PR_S_PRG_CONF.appeal_ind%TYPE;

112: BEGIN -- prgp_val_appeal_ind
113: -- Validate the {s_ou_conf,s_crv_conf}.appeal_ind, checking for:
114: -- * Cannot be set if parent s_prg_conf.appeal_ind is N
115: DECLARE
116: v_appeal_ind IGS_PR_S_PRG_CONF.appeal_ind%TYPE;
117: CURSOR c_sprgc IS
118: SELECT sprgc.appeal_ind
119: FROM IGS_PR_S_PRG_CONF sprgc
120: WHERE sprgc.s_control_num = 1;

Line 119: FROM IGS_PR_S_PRG_CONF sprgc

115: DECLARE
116: v_appeal_ind IGS_PR_S_PRG_CONF.appeal_ind%TYPE;
117: CURSOR c_sprgc IS
118: SELECT sprgc.appeal_ind
119: FROM IGS_PR_S_PRG_CONF sprgc
120: WHERE sprgc.s_control_num = 1;
121: BEGIN
122: -- Set the default message name
123: p_message_name := Null;

Line 162: v_show_cause_ind IGS_PR_S_PRG_CONF.show_cause_ind%TYPE;

158: BEGIN -- prgp_val_cause_ind
159: -- Validate the {s_ou_conf,s_crv_conf}.show_cause_ind, checking for:
160: -- * Cannot be set if parent s_prg_conf.show_cause_ind is N
161: DECLARE
162: v_show_cause_ind IGS_PR_S_PRG_CONF.show_cause_ind%TYPE;
163: CURSOR c_sprgc IS
164: SELECT sprgc.show_cause_ind
165: FROM IGS_PR_S_PRG_CONF sprgc
166: WHERE sprgc.s_control_num = 1;

Line 165: FROM IGS_PR_S_PRG_CONF sprgc

161: DECLARE
162: v_show_cause_ind IGS_PR_S_PRG_CONF.show_cause_ind%TYPE;
163: CURSOR c_sprgc IS
164: SELECT sprgc.show_cause_ind
165: FROM IGS_PR_S_PRG_CONF sprgc
166: WHERE sprgc.s_control_num = 1;
167: BEGIN
168: -- Set the default message name
169: p_message_name := Null;