APPS.IGS_PS_GEN_004 dependencies on IGS_PS_USEC_OCCURS_V

Line 120: FUNCTION recal_dl_date (p_v_uoo_id IGS_PS_USEC_OCCURS_V.uoo_id%TYPE,

116: RETURN FALSE;
117: END IF;
118: END crsp_val_call_nbr;
119:
120: FUNCTION recal_dl_date (p_v_uoo_id IGS_PS_USEC_OCCURS_V.uoo_id%TYPE,
121: p_formula_method igs_en_nsu_dlstp.formula_method%TYPE,
122: p_durationdays IN OUT NOCOPY igs_en_nstd_usec_dl_v.ENR_DL_TOTAL_DAYS%TYPE,
123: p_round_method igs_en_nstd_usec_dl_v.round_method%TYPE,
124: p_OffsetDuration igs_en_nstd_usec_dl_v.offset_duration%TYPE,

Line 215: from igs_ps_usec_occurs_v

211: --for formula method = 'M'
212:
213: CURSOR cur_mon is
214: select 'TRUE'
215: from igs_ps_usec_occurs_v
216: where uoo_id = p_v_uoo_id and
217: monday = 'Y';
218:
219: CURSOR cur_tue IS

Line 221: from igs_ps_usec_occurs_v

217: monday = 'Y';
218:
219: CURSOR cur_tue IS
220: select 'TRUE'
221: from igs_ps_usec_occurs_v
222: where uoo_id = p_v_uoo_id and
223: tuesday = 'Y';
224:
225: CURSOR cur_wed IS

Line 227: from igs_ps_usec_occurs_v

223: tuesday = 'Y';
224:
225: CURSOR cur_wed IS
226: select 'TRUE'
227: from igs_ps_usec_occurs_v
228: where uoo_id = p_v_uoo_id and
229: wednesday = 'Y';
230:
231: CURSOR cur_thu IS

Line 233: from igs_ps_usec_occurs_v

229: wednesday = 'Y';
230:
231: CURSOR cur_thu IS
232: select 'TRUE'
233: from igs_ps_usec_occurs_v
234: where uoo_id = p_v_uoo_id and
235: thursday = 'Y';
236:
237: CURSOR cur_fri IS

Line 239: from igs_ps_usec_occurs_v

235: thursday = 'Y';
236:
237: CURSOR cur_fri IS
238: select 'TRUE'
239: from igs_ps_usec_occurs_v
240: where uoo_id = p_v_uoo_id and
241: friday = 'Y';
242:
243: CURSOR cur_sat IS

Line 245: from igs_ps_usec_occurs_v

241: friday = 'Y';
242:
243: CURSOR cur_sat IS
244: select 'TRUE'
245: from igs_ps_usec_occurs_v
246: where uoo_id = p_v_uoo_id and
247: saturday = 'Y';
248:
249: CURSOR cur_sun IS

Line 251: from igs_ps_usec_occurs_v

247: saturday = 'Y';
248:
249: CURSOR cur_sun IS
250: select 'TRUE'
251: from igs_ps_usec_occurs_v
252: where uoo_id = p_v_uoo_id and
253: sunday = 'Y';
254:
255: meetingdays NUMBER DEFAULT 0;