1 PACKAGE igs_en_spa_terms_api AS
2 /* $Header: IGSENB1S.pls 120.1 2005/09/23 06:36:36 appldev noship $ */
3
4 g_spa_term_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
5 g_spa_term_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE;
6 EN_SPAT_REC_TYPE IGS_EN_SPA_TERMS%ROWTYPE;
7
8 PROCEDURE set_spa_term_cal_type(p_spa_term_cal_type IN VARCHAR2);
9
10 PROCEDURE set_spa_term_sequence_number(p_spa_term_sequence_number IN NUMBER);
11
12 FUNCTION get_spat_att_type (
13 p_person_id IN NUMBER,
14 p_program_cd IN VARCHAR2,
15 p_term_cal_type IN VARCHAR2,
16 p_term_sequence_NUMBER IN NUMBER
17 ) RETURN VARCHAR2;
18
19 FUNCTION get_spat_att_type_desc (
20 p_person_id IN NUMBER,
21 p_program_cd IN VARCHAR2,
22 p_term_cal_type IN VARCHAR2,
23 p_term_sequence_NUMBER IN NUMBER
24 ) RETURN VARCHAR2;
25
26 FUNCTION get_spat_att_mode(
27 p_person_id IN NUMBER,
28 p_program_cd IN VARCHAR2,
29 p_term_cal_type IN VARCHAR2,
30 p_term_sequence_NUMBER IN NUMBER
31 ) RETURN VARCHAR2;
32
33 FUNCTION get_spat_att_mode_desc(
34 p_person_id IN NUMBER,
35 p_program_cd IN VARCHAR2,
36 p_term_cal_type IN VARCHAR2,
37 p_term_sequence_NUMBER IN NUMBER
38 ) RETURN VARCHAR2;
39
40
41 FUNCTION get_spat_location(
42 p_person_id IN NUMBER,
43 p_program_cd IN VARCHAR2,
44 p_term_cal_type IN VARCHAR2,
45 p_term_sequence_NUMBER IN NUMBER
46 ) RETURN VARCHAR2;
47
48 FUNCTION get_spat_location_desc(
49 p_person_id IN NUMBER,
50 p_program_cd IN VARCHAR2,
51 p_term_cal_type IN VARCHAR2,
52 p_term_sequence_NUMBER IN NUMBER
53 ) RETURN VARCHAR2;
54
55 FUNCTION get_spat_coo_id(
56 p_person_id IN NUMBER,
57 p_program_cd IN VARCHAR2,
58 p_term_cal_type IN VARCHAR2,
59 p_term_sequence_NUMBER IN NUMBER
60 ) RETURN NUMBER;
61
62 FUNCTION get_spat_program_version(
63 p_person_id IN NUMBER,
64 p_program_cd IN VARCHAR2,
65 p_term_cal_type IN VARCHAR2,
66 p_term_sequence_NUMBER IN NUMBER
67 ) RETURN NUMBER;
68
69 FUNCTION get_spat_acad_cal_type(
70 p_person_id IN NUMBER,
71 p_program_cd IN VARCHAR2,
72 p_term_cal_type IN VARCHAR2,
73 p_term_sequence_NUMBER IN NUMBER
74 ) RETURN VARCHAR2;
75
76 FUNCTION get_spat_key_prog_flag(
77 p_person_id IN NUMBER,
78 p_program_cd IN VARCHAR2,
79 p_term_cal_type IN VARCHAR2,
80 p_term_sequence_NUMBER IN NUMBER
81 ) RETURN VARCHAR2;
82
83 FUNCTION get_spat_fee_cat(
84 p_person_id IN NUMBER,
85 p_program_cd IN VARCHAR2,
86 p_term_cal_type IN VARCHAR2,
87 p_term_sequence_NUMBER IN NUMBER
88 ) RETURN VARCHAR2;
89
90 FUNCTION get_spat_class_standing(
91 p_person_id IN NUMBER,
92 p_program_cd IN VARCHAR2,
93 p_term_cal_type IN VARCHAR2,
94 p_term_sequence_NUMBER IN NUMBER
95 ) RETURN NUMBER;
96
97 FUNCTION get_spat_primary_prg(
98 p_person_id IN NUMBER,
99 p_program_cd IN VARCHAR2,
100 p_term_cal_type IN VARCHAR2,
101 p_term_sequence_NUMBER IN NUMBER
102 ) RETURN VARCHAR2;
103
104 FUNCTION get_curr_term(
105 p_cal_type IN VARCHAR2
106 ) RETURN VARCHAR2;
107
108 FUNCTION get_prev_term(
109 p_cal_type IN VARCHAR2
110 ) RETURN VARCHAR2;
111
112 FUNCTION get_next_term(
113 p_cal_type IN VARCHAR2
114 ) RETURN VARCHAR2;
115
116
117 PROCEDURE validate_terms(
118 p_person_id IN NUMBER
119 );
120
121 PROCEDURE check_term_exists(
122 p_person_id IN NUMBER,
123 p_program_cd IN VARCHAR2,
124 p_program_version IN NUMBER,
125 p_term_cal_type IN VARCHAR2,
126 p_term_sequence_number IN NUMBER,
127 p_insert_rec OUT NOCOPY BOOLEAN,
128 p_term_record_id OUT NOCOPY NUMBER);
129
130 PROCEDURE create_update_term_rec(
131 p_person_id IN NUMBER ,
132 p_program_cd IN VARCHAR2,
133 p_term_cal_type IN VARCHAR2,
134 p_term_sequence_NUMBER IN NUMBER,
135 p_ripple_frwrd IN boolean,
136 p_update_rec IN BOOLEAN,
137 p_message_name OUT NOCOPY VARCHAR2,
138 p_coo_id IN NUMBER DEFAULT -1,
139 p_key_program_flag IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
140 p_fee_cat IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
141 p_class_standing_id IN NUMBER DEFAULT -1,
142 p_plan_sht_status IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
143 p_program_changed IN BOOLEAN DEFAULT FALSE
144 );
145
146 PROCEDURE delete_terms_for_program(
147 p_person_id IN NUMBER,
148 p_program_cd IN VARCHAR2);
149
150 PROCEDURE change_key_program_to(
151 p_person_id IN NUMBER,
152 p_program_cd IN VARCHAR2,
153 p_term_cal_type IN VARCHAR2,
154 p_term_sequence_NUMBER IN NUMBER,
155 p_term_rec IN EN_SPAT_REC_TYPE%TYPE);
156
157 FUNCTION get_miss_char RETURN VARCHAR2;
158
159 PROCEDURE backward_gap_fill
160 (
161 p_term_rec IN EN_SPAT_REC_TYPE%TYPE
162 );
163
164 PROCEDURE forward_gap_fill
165 (
166 p_term_rec IN EN_SPAT_REC_TYPE%TYPE
167 );
168
169 END igs_en_spa_terms_api;
[Home] [Help]