DBA Data[Home] [Help]

APPS.IGS_PS_VAL_ATL dependencies on IGS_CA_TYPE

Line 21: v_closed_ind IGS_CA_TYPE.closed_ind%TYPE;

17: p_message_name OUT NOCOPY VARCHAR2 )
18: RETURN BOOLEAN AS
19: BEGIN
20: DECLARE
21: v_closed_ind IGS_CA_TYPE.closed_ind%TYPE;
22: v_s_cal_cat IGS_CA_TYPE.s_cal_cat%TYPE;
23: CURSOR c_ci_scc_ct IS
24: SELECT closed_ind,
25: s_cal_cat

Line 22: v_s_cal_cat IGS_CA_TYPE.s_cal_cat%TYPE;

18: RETURN BOOLEAN AS
19: BEGIN
20: DECLARE
21: v_closed_ind IGS_CA_TYPE.closed_ind%TYPE;
22: v_s_cal_cat IGS_CA_TYPE.s_cal_cat%TYPE;
23: CURSOR c_ci_scc_ct IS
24: SELECT closed_ind,
25: s_cal_cat
26: FROM IGS_CA_TYPE

Line 26: FROM IGS_CA_TYPE

22: v_s_cal_cat IGS_CA_TYPE.s_cal_cat%TYPE;
23: CURSOR c_ci_scc_ct IS
24: SELECT closed_ind,
25: s_cal_cat
26: FROM IGS_CA_TYPE
27: WHERE cal_type = p_cal_type;
28: BEGIN
29: -- This module validates the clendar category and
30: -- closed indicator for an IGS_EN_ATD_TYPE_LOAD record