APPS.IGS_PS_GEN_004 dependencies on IGS_EN_NSU_DLSTP

Line 16: p_formula_method IN igs_en_nsu_dlstp.formula_method%TYPE,

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: )
19: RETURN DATE;
20:

Line 121: p_formula_method igs_en_nsu_dlstp.formula_method%TYPE,

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,
125: p_offsetdays IN OUT NOCOPY NUMBER,

Line 128: p_offset_dt_code igs_en_nsu_dlstp.offset_dt_code%TYPE,

124: p_OffsetDuration igs_en_nstd_usec_dl_v.offset_duration%TYPE,
125: p_offsetdays IN OUT NOCOPY NUMBER,
126: p_function_name igs_en_nstd_usec_dl.function_name%TYPE,
127: p_setup_id igs_en_nstd_usec_dl.non_std_usec_dls_id%TYPE,
128: p_offset_dt_code igs_en_nsu_dlstp.offset_dt_code%TYPE,
129: p_msg OUT NOCOPY VARCHAR2
130: )
131: RETURN DATE IS
132: ------------------------------------------------------------------

Line 144: --2. The parameter p_setup_id is the corresponding setup id from tables IGS_EN_NSU_DLSTP (for FUNCTION) or

140: --Known limitations/enhancements and/or remarks:
141: --1. For the functions Variation_cuttoff, Record_cutoff and Grading_Schema,
142: --the parameter p_function_name = 'FUNCTION'
143: --For Discontinuation Dealdine calculation p_function_name = NULL
144: --2. The parameter p_setup_id is the corresponding setup id from tables IGS_EN_NSU_DLSTP (for FUNCTION) or
145: -- IGS_EN_NSD_DLSTP for Discontinuation.
146: --Change History:
147: --Who When What
148: --sarakshi 01-Sep-2005 bug#4114829, added cursor c_weekend_disc such that for discontinuation deadline it checks the respective tables for weekend inclusion

Line 302: formula_method igs_en_nsu_dlstp.formula_method%TYPE ;

298: offsetdays NUMBER DEFAULT 0;
299: l_n_offsetdays NUMBER DEFAULT 0;
300: l_no_meeting_day_checked VARCHAR2(10);
301:
302: formula_method igs_en_nsu_dlstp.formula_method%TYPE ;
303: durationdays igs_en_nstd_usec_dl_v.ENR_DL_TOTAL_DAYS%TYPE;
304: round_method igs_en_nstd_usec_dl_v.round_method%TYPE;
305: OffsetDuration igs_en_nstd_usec_dl_v.offset_duration%TYPE;
306: Meeting_day VARCHAR2(10) ;

Line 326: FROM igs_en_nsu_dlstp_all

322:
323: --Cursor to get the check whether we have to include weekends or not
324: CURSOR c_weekend (cp_n_id IN NUMBER) IS
325: SELECT incl_wkend_duration_flag
326: FROM igs_en_nsu_dlstp_all
327: WHERE non_std_usec_dls_id = cp_n_id;
328:
329: l_c_include_weekends igs_en_nsu_dlstp_all.incl_wkend_duration_flag%TYPE;
330:

Line 329: l_c_include_weekends igs_en_nsu_dlstp_all.incl_wkend_duration_flag%TYPE;

325: SELECT incl_wkend_duration_flag
326: FROM igs_en_nsu_dlstp_all
327: WHERE non_std_usec_dls_id = cp_n_id;
328:
329: l_c_include_weekends igs_en_nsu_dlstp_all.incl_wkend_duration_flag%TYPE;
330:
331: --Cursor to get the check whether we have to include weekends or not for the discontinuation deadline
332: CURSOR c_weekend_disc (cp_n_id IN NUMBER) IS
333: SELECT incl_wkend_duration_flag

Line 1540: p_formula_method IN igs_en_nsu_dlstp.formula_method%TYPE,

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: )
1543: RETURN DATE
1544: ------------------------------------------------------------------