1 PACKAGE igs_ps_gen_002 AS
2 /* $Header: IGSPS02S.pls 120.0 2005/06/02 04:22:05 appldev noship $ */
3 /* CAHNGE HISTORY
4 WHO WHEN WHAT
5 smvk 10-Oct-2003 Enh # 3052445. Added p_n_max_wlst_per_stud to the signature of crsp_ins_cv_hist.
6 Nishikant 11DEC2002 ENCR027 Build (Program Length Integration). The signature of the function
7 crsp_get_crv_eftd got modified. The pragma restriction for the functions
8 crsp_get_crv_eftd removed since its modifying the variables in package.
9 Pragma restriction WNPS removed from the function crsp_get_crv_eftd.
10 vvutukur 19-Oct-2002 Enh#2608227.Modified crsp_get_crv_eftd,crsp_ins_cv_hist.
11 ayedubat 25-MAY-2001 procudure,crsp_ins_cv_hist is midified according
12 to the DLD,PSP001-US */
13
14 FUNCTION crsp_get_course_ttl(
15 p_course_cd IN igs_ps_course.course_cd%TYPE )
16 RETURN VARCHAR2;
17
18 FUNCTION crsp_get_crv_eftd( p_person_id IN NUMBER ,
19 p_course_cd IN VARCHAR2)
20 RETURN NUMBER;
21 PRAGMA RESTRICT_REFERENCES(crsp_get_crv_eftd,WNDS,WNPS);
22
23 FUNCTION crsp_get_un_lvl(
24 p_unit_cd IN VARCHAR2 ,
25 p_unit_version_number IN NUMBER ,
26 p_course_cd IN VARCHAR2 ,
27 p_course_version_number IN NUMBER )
28 RETURN VARCHAR2;
29
30 PROCEDURE crsp_ins_cfos_hist(
31 p_course_cd IN VARCHAR2 ,
32 p_version_number IN NUMBER ,
33 p_field_of_study IN VARCHAR2 ,
34 p_last_update_on IN DATE ,
35 p_update_on IN DATE ,
36 p_last_update_who IN VARCHAR2 ,
37 p_percentage IN NUMBER ,
38 p_major_field_ind IN VARCHAR2 DEFAULT 'N');
39
40 PROCEDURE crsp_ins_cv_hist(
41 /*************************************************************
42 Created By :
43 Date Created By :
44 Purpose :
45 Know limitations, enhancements or remarks
46 Change History
47 Who When What
48 sarakshi 27-Jan-2004 Enh##3345205, added column annual_instruction_time in the parameter list
49 vvutukur 19_oct-2002 Enh#2608227.removed references to std_ft_completion_time,std_pt_completion_time as these
50 columns are obsoleted.
51 ayedubat 25-MAY-2001 Added the new columns
52 (reverse chronological order - newest change first)
53 ***************************************************************/
54 p_course_cd IN VARCHAR2 ,
55 p_version_number IN NUMBER ,
56 p_last_update_on IN DATE ,
57 p_update_on IN DATE ,
58 p_last_update_who IN VARCHAR2 ,
59 p_start_dt IN DATE ,
60 p_review_dt IN DATE ,
61 p_expiry_dt IN DATE ,
62 p_end_dt IN DATE ,
63 p_course_status IN VARCHAR2 ,
64 p_title IN VARCHAR2 ,
65 p_short_title IN VARCHAR2 ,
66 p_abbreviation IN VARCHAR2 ,
67 p_supp_exam_permitted_ind IN VARCHAR2 ,
68 p_generic_course_ind IN VARCHAR2 ,
69 p_graduate_students_ind IN VARCHAR2 ,
70 p_count_intrmsn_in_time_ind IN VARCHAR2 ,
71 p_intrmsn_allowed_ind IN VARCHAR2 ,
72 p_course_type IN VARCHAR2 ,
73 p_responsible_org_unit_cd IN VARCHAR2 ,
74 p_responsible_ou_start_dt IN DATE ,
75 p_govt_special_course_type IN VARCHAR2 ,
76 p_qualification_recency IN NUMBER ,
77 p_external_adv_stnd_limit IN NUMBER ,
78 p_internal_adv_stnd_limit IN NUMBER ,
79 p_contact_hours IN NUMBER ,
80 p_credit_points_required IN NUMBER ,
81 p_govt_course_load IN NUMBER ,
82 p_std_annual_load IN NUMBER ,
83 p_course_total_eftsu IN NUMBER ,
84 p_max_intrmsn_duration IN NUMBER ,
85 p_num_of_units_before_intrmsn IN NUMBER ,
86 p_min_sbmsn_percentage IN NUMBER,
87 p_min_cp_per_calendar IN NUMBER,
88 p_approval_date IN DATE,
89 p_external_approval_date IN DATE,
90 p_federal_financial_aid IN VARCHAR2,
91 p_institutional_financial_aid IN VARCHAR2,
92 p_max_cp_per_teaching_period IN NUMBER,
93 p_residency_cp_required IN NUMBER,
94 p_state_financial_aid IN VARCHAR2,
95 p_primary_program_rank IN NUMBER DEFAULT NULL,
96 p_n_max_wlst_per_stud IN NUMBER DEFAULT NULL,
97 p_n_annual_instruction_time IN NUMBER DEFAULT NULL
98 );
99
100 END igs_ps_gen_002;