1 PACKAGE IGS_PS_GEN_004 AUTHID CURRENT_USER AS
2 /* $Header: IGSPS04S.pls 120.0 2005/06/01 16:25:22 appldev noship $ */
3
4 TYPE tab_date_type IS TABLE OF DATE INDEX BY BINARY_INTEGER;
5
6 PROCEDURE crsp_ins_fsr_hist(
7 p_course_cd IN VARCHAR2 ,
8 p_version_number IN NUMBER ,
9 p_funding_source IN VARCHAR2 ,
10 p_last_update_on IN DATE ,
11 p_update_on IN DATE ,
12 p_last_update_who IN VARCHAR2 ,
13 p_dflt_ind IN VARCHAR2 DEFAULT 'N',
14 p_restricted_ind IN VARCHAR2 )
15 ;
16
17 FUNCTION crsp_val_call_nbr(
18 p_cal_type IN IGS_PS_UNIT_OFR_OPT_ALL.cal_type%TYPE ,
19 p_ci_sequence_number IN IGS_PS_UNIT_OFR_OPT_ALL.ci_sequence_number%TYPE,
20 p_call_number IN IGS_PS_UNIT_OFR_OPT_ALL.call_number%TYPE
21 )
22 RETURN BOOLEAN;
23
24 ------------------------------------------------------------------
25 --Created by : ssomani ( Oracle IDC)
26 --Date created: 9-APR-2001
27 --
28 --Purpose: Created as pasrt of the build for DLD Enrollment Setup : Calendar, Access, Timeslots (Version 1a)
29 -- Used for deadline date calculation for Enrollment setup.
30 -- Called from IGSPS101.pll and IGSPS083.pll
31 --
32 --Known limitations/enhancements and/or remarks:
33 --1. For the functions Variation_cuttoff, Record_cutoff and Grading_Schema,
34 --the parameter p_function_name = 'FUNCTION'
35 --For Discontinuation Dealdine calculation p_function_name = NULL
36 --2. The parameter p_setup_id is the corresponding setup id from tables IGS_EN_NSU_DLSTP (for FUNCTION) or
37 -- IGS_EN_NSD_DLSTP for Discontinuation.
38 --Change History:
39 --Who When What
40 -------------------------------------------------------------------
41 FUNCTION recal_dl_date (p_v_uoo_id IGS_PS_USEC_OCCURS_V.uoo_id%TYPE,
42 p_formula_method igs_en_nsu_dlstp.formula_method%TYPE,
43 p_durationdays IN OUT NOCOPY igs_en_nstd_usec_dl_v.ENR_DL_TOTAL_DAYS%TYPE,
44 p_round_method igs_en_nstd_usec_dl_v.round_method%TYPE,
45 p_OffsetDuration igs_en_nstd_usec_dl_v.offset_duration%TYPE,
46 p_offsetdays IN OUT NOCOPY NUMBER,
47 p_function_name igs_en_nstd_usec_dl.function_name%type,
48 p_setup_id igs_en_nstd_usec_dl.non_std_usec_dls_id%type,
49 p_offset_dt_code igs_en_nsu_dlstp.offset_dt_code%type,
50 p_msg OUT NOCOPY VARCHAR2
51 )
52 RETURN DATE;
53
54 ------------------------------------------------------------------
55 --Created by : pradhakr ( Oracle IDC)
56 --Date created: 9-APR-2001
57 --
58 --Purpose: Created as part of the build for DLD Enrollment Setup : Calendar, Access, Timeslots (Version 1a)
59 -- Used for deadline date calculation for Enrollment setup by applying Offset Constraints.
60 -- Called from IGSPS101.pll and IGSPS083.pll
61 --
62 --Known limitations/enhancements and/or remarks:
63 --
64 --Change History:
65 --Who When What
66 -------------------------------------------------------------------
67
68 PROCEDURE calpl_constraint_resolve (
69 p_date_val IN OUT NOCOPY IGS_EN_NSTD_USEC_DL.ENR_DL_DATE%TYPE,
70 p_offset_cnstr_id IN IGS_EN_DL_OFFSET_CONS.ENR_DL_OFFSET_CONS_ID%TYPE,
71 p_type IN IGS_EN_NSTD_USEC_DL.FUNCTION_NAME%TYPE,
72 p_deadline_type IN VARCHAR2,
73 p_msg_name OUT NOCOPY VARCHAR2 );
74
75 FUNCTION f_retention_offset_date ( p_n_uoo_id IN NUMBER,
76 p_c_formula_method IN VARCHAR2,
77 p_c_round_method IN VARCHAR2,
78 p_c_incl_wkend_duration IN VARCHAR2,
79 p_n_offset_value IN NUMBER
80 ) RETURN DATE;
81
82 FUNCTION get_weekends ( p_d_start_dt IN DATE,
83 p_d_end_dt IN DATE
84 ) RETURN NUMBER;
85
86 PROCEDURE populate_holidays ( p_d_start_dt IN DATE,
87 p_d_end_dt IN DATE,
88 p_c_incl_weekends IN VARCHAR2,
89 p_tab_holiday IN OUT NOCOPY tab_date_type
90 ) ;
91 FUNCTION duration_days( p_n_uoo_id IN NUMBER,
92 p_d_us_st_dt IN DATE,
93 p_d_end_dt IN DATE,
94 p_c_formula_method IN VARCHAR2,
95 p_c_round_method IN VARCHAR2,
96 p_c_incl_wkend_duration IN VARCHAR2,
97 p_n_offset_value IN NUMBER,
98 p_c_msg OUT NOCOPY VARCHAR2) RETURN DATE;
99
100 FUNCTION meeting_days ( p_n_uoo_id IN NUMBER,
101 p_d_us_st_dt IN DATE,
102 p_d_end_dt IN DATE,
103 p_c_formula_method IN VARCHAR2,
104 p_c_round_method IN VARCHAR2,
105 p_c_incl_wkend_duration IN VARCHAR2,
106 p_n_offset_value IN NUMBER,
107 p_c_msg OUT NOCOPY VARCHAR2) RETURN DATE;
108
109 PROCEDURE sort_date_array (p_tab_array IN OUT NOCOPY tab_date_type);
110
111 FUNCTION get_inst_constraint_id RETURN NUMBER;
112
113 PROCEDURE round_up( p_c_round_method IN VARCHAR2,
114 p_n_value IN OUT NOCOPY NUMBER);
115
116 END IGS_PS_GEN_004;