APPS.IGS_PR_VAL_SCPC dependencies on IGS_CA_DA

Line 174: -- Validate that IGS_CA_DA.IGS_CA_DA is not closed.

170: IGS_GE_MSG_STACK.ADD;
171: App_Exception.Raise_Exception;
172: END prgp_val_cause_da;
173: --
174: -- Validate that IGS_CA_DA.IGS_CA_DA is not closed.
175: FUNCTION prgp_val_da_closed(
176: p_dt_alias IN VARCHAR2 ,
177: p_message_name OUT NOCOPY VARCHAR2 )
178: RETURN BOOLEAN AS

Line 181: -- Validate if IGS_CA_DA.IGS_CA_DA is closed.

177: p_message_name OUT NOCOPY VARCHAR2 )
178: RETURN BOOLEAN AS
179: gv_other_detail VARCHAR2(255);
180: BEGIN -- prgp_val_da_closed
181: -- Validate if IGS_CA_DA.IGS_CA_DA is closed.
182: DECLARE
183: v_closed_ind VARCHAR2(1);
184: CURSOR c_da IS
185: SELECT da.closed_ind

Line 186: FROM IGS_CA_DA da

182: DECLARE
183: v_closed_ind VARCHAR2(1);
184: CURSOR c_da IS
185: SELECT da.closed_ind
186: FROM IGS_CA_DA da
187: WHERE da.dt_alias = p_dt_alias;
188: BEGIN
189: -- Set the default message name
190: p_message_name := Null;