APPS.IGS_PS_GEN_004 dependencies on IGS_PS_USEC_OCCURS

Line 14: FUNCTION check_dl_date( p_uooid IN igs_ps_usec_occurs.uoo_id%TYPE,

10: --------------------------------------------------------------------------
11:
12:
13: -- forward declaration of the function check_dl_date
14: FUNCTION check_dl_date( p_uooid IN igs_ps_usec_occurs.uoo_id%TYPE,
15: p_date IN DATE,
16: p_formula_method IN igs_en_nsu_dlstp.formula_method%TYPE,
17: p_last_meeting_date IN DATE DEFAULT NULL
18: )

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;

Line 279: FROM igs_ps_usec_occurs

275: -- not to inculde no set day unit section occurrence as a part of Bug # 3060089.
276: CURSOR cur_occur_unitsection
277: IS
278: SELECT start_date,end_date,to_be_announced,monday, tuesday,wednesday,thursday,friday,saturday,sunday
279: FROM igs_ps_usec_occurs
280: WHERE uoo_id=p_v_uoo_id
281: AND NO_SET_DAY_IND = 'N';
282:
283: occur_unitsection_rec cur_occur_unitsection%ROWTYPE;

Line 1538: FUNCTION check_dl_date( p_uooid IN igs_ps_usec_occurs.uoo_id%TYPE,

1534: RAISE;
1535:
1536: END calpl_constraint_resolve;
1537:
1538: FUNCTION check_dl_date( p_uooid IN igs_ps_usec_occurs.uoo_id%TYPE,
1539: p_date IN DATE,
1540: p_formula_method IN igs_en_nsu_dlstp.formula_method%TYPE,
1541: p_last_meeting_date IN DATE
1542: )

Line 1567: CURSOR cur_cal_seq (cp_uoo_id igs_ps_usec_occurs.uoo_id%TYPE) IS

1563: l_return VARCHAR2(1) ; -- decide whether old date exists as deadline or not
1564: p_unit_sec_end_date DATE;
1565:
1566: -- Cursor to get the cal type and sequence number for a given uoo_id
1567: CURSOR cur_cal_seq (cp_uoo_id igs_ps_usec_occurs.uoo_id%TYPE) IS
1568: SELECT cal_type,ci_sequence_number
1569: FROM igs_ps_unit_ofr_opt
1570: WHERE uoo_id = cp_uoo_id;
1571:

Line 2000: FROM igs_ps_usec_occurs

1996: l_n_cons_id IGS_PS_NSUS_RTN.NON_STD_USEC_RTN_ID%TYPE;
1997:
1998: CURSOR c_uso (cp_n_uoo_id IN NUMBER) IS
1999: SELECT start_date,end_date,to_be_announced,monday, tuesday,wednesday,thursday,friday,saturday,sunday
2000: FROM igs_ps_usec_occurs
2001: WHERE uoo_id=cp_n_uoo_id
2002: AND NO_SET_DAY_IND = 'N';
2003:
2004: l_tab_meeting_days tab_date_type; -- local PL/SQL table to hold meeting dates of unit section