APPS.IGS_GR_VAL_GC dependencies on IGS_GR_CRMN

Line 119: -- for this IGS_GR_CRMN.

115: RETURN BOOLEAN AS
116:
117: BEGIN -- grdp_val_gc_upd
118: -- Description: Check if any IGS_GR_AWD_CRMN records exist
119: -- for this IGS_GR_CRMN.
120: DECLARE
121: v_gac_exists VARCHAR2(1);
122: CURSOR c_gac IS
123: SELECT 'X'

Line 181: --2. Return a warning if no IGS_GR_CRMN_ROUND_PRD records exist for the

177: IF p_grd_cal_type IS NULL OR
178: p_grd_ci_sequence_number IS NULL THEN
179: RETURN TRUE;
180: END IF;
181: --2. Return a warning if no IGS_GR_CRMN_ROUND_PRD records exist for the
182: --specified IGS_GR_CRMN_ROUND.
183: OPEN c_crdp;
184: FETCH c_crdp INTO v_crdp_exists;
185: IF c_crdp%NOTFOUND THEN

Line 182: --specified IGS_GR_CRMN_ROUND.

178: p_grd_ci_sequence_number IS NULL THEN
179: RETURN TRUE;
180: END IF;
181: --2. Return a warning if no IGS_GR_CRMN_ROUND_PRD records exist for the
182: --specified IGS_GR_CRMN_ROUND.
183: OPEN c_crdp;
184: FETCH c_crdp INTO v_crdp_exists;
185: IF c_crdp%NOTFOUND THEN
186: CLOSE c_crdp;

Line 228: FROM IGS_GR_CRMN gc,

224: DECLARE
225: v_gc_daiv_exists VARCHAR2(1);
226: CURSOR c_gc_daiv IS
227: SELECT 'x'
228: FROM IGS_GR_CRMN gc,
229: IGS_CA_DA_INST_V daiv1,
230: IGS_CA_DA_INST_V daiv2
231: WHERE gc.grd_cal_type = p_grd_cal_type AND
232: gc.grd_ci_sequence_number = p_grd_ci_sequence_number AND

Line 314: FROM IGS_GR_CRMN gc,

310: DECLARE
311: v_gc_daiv_exists VARCHAR2(1);
312: CURSOR c_gc_daiv IS
313: SELECT 'x'
314: FROM IGS_GR_CRMN gc,
315: IGS_CA_DA_INST_V daiv
316: WHERE gc.grd_cal_type = p_grd_cal_type AND
317: gc.grd_ci_sequence_number = p_grd_ci_sequence_number AND
318: gc.ceremony_number = p_ceremony_number AND