DBA Data[Home] [Help]

APPS.IGS_PS_GEN_004 dependencies on IGS_EN_NSTD_USEC_DL_V

Line 122: p_durationdays IN OUT NOCOPY igs_en_nstd_usec_dl_v.ENR_DL_TOTAL_DAYS%TYPE,

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,
126: p_function_name igs_en_nstd_usec_dl.function_name%TYPE,

Line 123: p_round_method igs_en_nstd_usec_dl_v.round_method%TYPE,

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,
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,

Line 124: p_OffsetDuration igs_en_nstd_usec_dl_v.offset_duration%TYPE,

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,
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,

Line 303: durationdays igs_en_nstd_usec_dl_v.ENR_DL_TOTAL_DAYS%TYPE;

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) ;
307:

Line 304: round_method igs_en_nstd_usec_dl_v.round_method%TYPE;

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) ;
307:
308: -- Cursor to obtain the Teach Calendar end date

Line 305: OffsetDuration igs_en_nstd_usec_dl_v.offset_duration%TYPE;

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) ;
307:
308: -- Cursor to obtain the Teach Calendar end date
309: -- modifying the following cursor to select start date also. Also modified the from and where clause