DBA Data[Home] [Help]

APPS.IGS_PS_GEN_004 dependencies on IGS_EN_NSTD_USEC_DL

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 126: p_function_name igs_en_nstd_usec_dl.function_name%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,
129: p_msg OUT NOCOPY VARCHAR2
130: )

Line 127: p_setup_id igs_en_nstd_usec_dl.non_std_usec_dls_id%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,
129: p_msg OUT NOCOPY VARCHAR2
130: )
131: RETURN DATE IS

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

Line 1032: p_date_val IN OUT NOCOPY IGS_EN_NSTD_USEC_DL.ENR_DL_DATE%TYPE,

1028:
1029:
1030:
1031: PROCEDURE calpl_constraint_resolve (
1032: p_date_val IN OUT NOCOPY IGS_EN_NSTD_USEC_DL.ENR_DL_DATE%TYPE,
1033: p_offset_cnstr_id IN IGS_EN_DL_OFFSET_CONS.ENR_DL_OFFSET_CONS_ID%TYPE,
1034: p_type IN IGS_EN_NSTD_USEC_DL.FUNCTION_NAME%TYPE,
1035: p_deadline_type IN VARCHAR2,
1036: p_msg_name OUT NOCOPY VARCHAR2 )

Line 1034: p_type IN IGS_EN_NSTD_USEC_DL.FUNCTION_NAME%TYPE,

1030:
1031: PROCEDURE calpl_constraint_resolve (
1032: p_date_val IN OUT NOCOPY IGS_EN_NSTD_USEC_DL.ENR_DL_DATE%TYPE,
1033: p_offset_cnstr_id IN IGS_EN_DL_OFFSET_CONS.ENR_DL_OFFSET_CONS_ID%TYPE,
1034: p_type IN IGS_EN_NSTD_USEC_DL.FUNCTION_NAME%TYPE,
1035: p_deadline_type IN VARCHAR2,
1036: p_msg_name OUT NOCOPY VARCHAR2 )
1037: AS
1038: