APPS.IGS_PS_GEN_004 dependencies on IGS_PS_NSUS_RTN

Line 1765: l_n_cons_id IGS_PS_NSUS_RTN.NON_STD_USEC_RTN_ID%TYPE;

1761: -- l_d_retention_dt DATE; -- Holds the final calculated retention date, returned to the form.
1762: l_tab_holidays tab_date_type; -- Holds the date's of Holidays.
1763: l_b_found BOOLEAN; -- Boolean variable holds true/false. contains value true if it finds a hit.
1764:
1765: l_n_cons_id IGS_PS_NSUS_RTN.NON_STD_USEC_RTN_ID%TYPE;
1766:
1767: FUNCTION is_holiday(p_d_date IN DATE) RETURN BOOLEAN IS
1768: /***********************************************************************************************
1769: Created By : smvk

Line 1996: l_n_cons_id IGS_PS_NSUS_RTN.NON_STD_USEC_RTN_ID%TYPE;

1992: l_n_meet_days NUMBER; -- local variable to hold number of meeting days.
1993: l_n_offset_days NUMBER; -- local variable to hold offset days.
1994: l_d_init_retention_dt DATE; -- local variable to hold initial retention date.
1995: -- l_d_retention_dt DATE; -- local variable to hold retention date.
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

Line 2394: FROM igs_ps_nsus_rtn

2390:
2391: FUNCTION get_inst_constraint_id RETURN NUMBER IS
2392: CURSOR c_call_cnstr IS
2393: SELECT non_std_usec_rtn_id
2394: FROM igs_ps_nsus_rtn
2395: WHERE definition_code = 'INSTITUTION'
2396: AND ROWNUM <2 ;
2397:
2398: l_n_cons_id IGS_PS_NSUS_RTN.NON_STD_USEC_RTN_ID%TYPE;

Line 2398: l_n_cons_id IGS_PS_NSUS_RTN.NON_STD_USEC_RTN_ID%TYPE;

2394: FROM igs_ps_nsus_rtn
2395: WHERE definition_code = 'INSTITUTION'
2396: AND ROWNUM <2 ;
2397:
2398: l_n_cons_id IGS_PS_NSUS_RTN.NON_STD_USEC_RTN_ID%TYPE;
2399:
2400: BEGIN
2401: OPEN c_call_cnstr;
2402: FETCH c_call_cnstr INTO l_n_cons_id ;