1 PACKAGE igs_co_gen_003 AS
2 /* $Header: IGSCO20S.pls 120.1 2005/09/30 04:10:28 appldev ship $ */
3
4 /*******************************************************************************
5 Created by : rbezawad
6 Date created : 04-Feb-2002
7 Purpose : Function to Get Person Name and Address for Correspondence.
8
9 Known limitations/enhancements/remarks:
10
11 Change History: (who, when, what: NO CREATION RECORDS HERE!)
12 Who When What
13
14 *******************************************************************************/
15 FUNCTION get_per_addr_for_corr (
16 p_person_id IN NUMBER,
17 p_case_type IN VARCHAR2 DEFAULT 'INITCAP'
18 ) RETURN VARCHAR2;
19
20 PRAGMA RESTRICT_REFERENCES(get_per_addr_for_corr,WNDS,WNPS);
21
22
23 /*******************************************************************************
24 Created by : rbezawad
25 Date created : 04-Feb-2002
26 Purpose : Function to get Application Instance Descriptive Flex-Field values.
27
28 Known limitations/enhancements/remarks:
29
30 Change History: (who, when, what: NO CREATION RECORDS HERE!)
31 Who When What
32
33 *******************************************************************************/
34 FUNCTION get_prg_appl_inst_dff_values (
35 p_person_id IN NUMBER,
36 p_admission_appl_number IN NUMBER,
37 p_nominated_course_cd IN VARCHAR2,
38 p_sequence_number IN NUMBER
39 ) RETURN VARCHAR2;
40
41 PRAGMA RESTRICT_REFERENCES(get_prg_appl_inst_dff_values,WNDS,WNPS);
42
43
44 /*******************************************************************************
45 Created by : rbezawad
46 Date created : 04-Feb-2002
47 Purpose : Function to get Expected Program Completion Date.
48
49 Known limitations/enhancements/remarks:
50
51 Change History: (who, when, what: NO CREATION RECORDS HERE!)
52 Who When What
53 knag 29-OCT-2002 For bug 2647482 Added parameters
54 p_attendance_type and p_location_cd
55 *******************************************************************************/
56 FUNCTION get_program_completion_dt (
57 p_course_cd IN igs_ad_ps_appl_inst_aplinst_v.course_cd%TYPE,
58 p_version_number IN igs_ad_ps_appl_inst_aplinst_v.crv_version_number%TYPE,
59 p_acad_cal_type IN igs_ad_ps_appl_inst_aplinst_v.acad_cal_type%TYPE,
60 p_adm_cal_type IN igs_ad_ps_appl_inst_aplinst_v.adm_cal_type%TYPE,
61 p_adm_ci_sequence_number IN igs_ad_ps_appl_inst_aplinst_v.adm_ci_sequence_number%TYPE,
62 p_attendance_type IN igs_ad_ps_appl_inst_aplinst_v.attendance_type%TYPE,
63 p_attendance_mode IN igs_ad_ps_appl_inst_aplinst_v.attendance_mode%TYPE DEFAULT NULL,
64 p_location_cd IN igs_ad_ps_appl_inst_aplinst_v.location_cd%TYPE DEFAULT NULL
65 ) RETURN DATE;
66
67
68
69 /*******************************************************************************
70 Created by : rbezawad
71 Date created : 04-Feb-2002
72 Purpose : Function to get the Residency Descriptive Flex-Field values.
73
74 Known limitations/enhancements/remarks:
75
76 Change History: (who, when, what: NO CREATION RECORDS HERE!)
77 Who When What
78
79 *******************************************************************************/
80 FUNCTION get_residency_dff_values (
81 p_resident_details_id IN NUMBER
82 ) RETURN VARCHAR2;
83
84 PRAGMA RESTRICT_REFERENCES(get_residency_dff_values,WNDS,WNPS);
85
86
87 /*******************************************************************************
88 Created by : rbezawad
89 Date created : 04-Feb-2002
90 Purpose : Function to get the Student Citizenship Status.
91
92 Known limitations/enhancements/remarks:
93
94 Change History: (who, when, what: NO CREATION RECORDS HERE!)
95 Who When What
96
97 *******************************************************************************/
98 FUNCTION get_student_citizenship_status(
99 p_person_id IN NUMBER
100 ) RETURN VARCHAR2;
101
102 PRAGMA RESTRICT_REFERENCES(get_student_citizenship_status,WNDS,WNPS);
103
104 END igs_co_gen_003;