59: --
60:
61: PROCEDURE add_to_cart (
62: p_api_version IN NUMBER ,
63: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
64: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
65: p_person_number IN VARCHAR2,
66: p_career IN VARCHAR2,
67: p_program_code IN VARCHAR2,
60:
61: PROCEDURE add_to_cart (
62: p_api_version IN NUMBER ,
63: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
64: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
65: p_person_number IN VARCHAR2,
66: p_career IN VARCHAR2,
67: p_program_code IN VARCHAR2,
68: p_term_alt_code IN VARCHAR2,
74: x_msg_data OUT NOCOPY VARCHAR2);
75:
76: PROCEDURE enroll_cart(
77: p_api_version IN NUMBER ,
78: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
79: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
80: p_person_number IN VARCHAR2,
81: p_career IN VARCHAR2,
82: p_program_code IN VARCHAR2,
75:
76: PROCEDURE enroll_cart(
77: p_api_version IN NUMBER ,
78: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
79: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
80: p_person_number IN VARCHAR2,
81: p_career IN VARCHAR2,
82: p_program_code IN VARCHAR2,
83: p_term_alt_code IN VARCHAR2,
86: x_msg_data OUT NOCOPY VARCHAR2);
87:
88: PROCEDURE clean_up_cart(
89: p_api_version IN NUMBER ,
90: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
91: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
92: p_person_number IN VARCHAR2,
93: p_career IN VARCHAR2,
94: p_program_code IN VARCHAR2,
87:
88: PROCEDURE clean_up_cart(
89: p_api_version IN NUMBER ,
90: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
91: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
92: p_person_number IN VARCHAR2,
93: p_career IN VARCHAR2,
94: p_program_code IN VARCHAR2,
95: p_term_alt_code IN VARCHAR2,
98: x_msg_data OUT NOCOPY VARCHAR2);
99:
100: PROCEDURE drop_all_section(
101: p_api_version IN NUMBER ,
102: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
103: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
104: p_person_number IN VARCHAR2,
105: p_career IN VARCHAR2,
106: p_program_code IN VARCHAR2,
99:
100: PROCEDURE drop_all_section(
101: p_api_version IN NUMBER ,
102: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
103: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
104: p_person_number IN VARCHAR2,
105: p_career IN VARCHAR2,
106: p_program_code IN VARCHAR2,
107: p_term_alt_code IN VARCHAR2,
110: x_msg_data OUT NOCOPY VARCHAR2);
111:
112: PROCEDURE drop_section_by_call_number(
113: p_api_version IN NUMBER ,
114: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
115: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
116: p_person_number IN VARCHAR2,
117: p_career IN VARCHAR2,
118: p_program_code IN VARCHAR2,
111:
112: PROCEDURE drop_section_by_call_number(
113: p_api_version IN NUMBER ,
114: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
115: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
116: p_person_number IN VARCHAR2,
117: p_career IN VARCHAR2,
118: p_program_code IN VARCHAR2,
119: p_term_alt_code IN VARCHAR2,
125: x_msg_data OUT NOCOPY VARCHAR2);
126:
127: PROCEDURE evaluate_person_steps(
128: p_api_version IN NUMBER ,
129: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
130: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
131: p_person_number IN VARCHAR2,
132: p_career IN VARCHAR2,
133: p_program_code IN VARCHAR2,
126:
127: PROCEDURE evaluate_person_steps(
128: p_api_version IN NUMBER ,
129: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
130: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
131: p_person_number IN VARCHAR2,
132: p_career IN VARCHAR2,
133: p_program_code IN VARCHAR2,
134: p_term_alt_code IN VARCHAR2,
137: x_msg_data OUT NOCOPY VARCHAR2);
138:
139: PROCEDURE list_schedule(
140: p_api_version IN NUMBER ,
141: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
142: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
143: P_person_number IN VARCHAR2,
144: P_career IN VARCHAR2,
145: P_program_code IN VARCHAR2,
138:
139: PROCEDURE list_schedule(
140: p_api_version IN NUMBER ,
141: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
142: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
143: P_person_number IN VARCHAR2,
144: P_career IN VARCHAR2,
145: P_program_code IN VARCHAR2,
146: P_term_alt_code IN VARCHAR2,
150: x_msg_data OUT NOCOPY VARCHAR2);
151:
152: PROCEDURE list_section_in_cart(
153: p_api_version IN NUMBER ,
154: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
155: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
156: p_person_number IN VARCHAR2,
157: p_career IN VARCHAR2,
158: p_program_code IN VARCHAR2,
151:
152: PROCEDURE list_section_in_cart(
153: p_api_version IN NUMBER ,
154: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
155: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
156: p_person_number IN VARCHAR2,
157: p_career IN VARCHAR2,
158: p_program_code IN VARCHAR2,
159: p_term_alt_code IN VARCHAR2,
163: x_msg_data OUT NOCOPY VARCHAR2);
164:
165: PROCEDURE remove_from_cart(
166: p_api_version IN NUMBER ,
167: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
168: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
169: p_person_number IN VARCHAR2,
170: p_career IN VARCHAR2,
171: p_program_code IN VARCHAR2,
164:
165: PROCEDURE remove_from_cart(
166: p_api_version IN NUMBER ,
167: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
168: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
169: p_person_number IN VARCHAR2,
170: p_career IN VARCHAR2,
171: p_program_code IN VARCHAR2,
172: p_term_alt_code IN VARCHAR2,
176: x_msg_data OUT NOCOPY VARCHAR2);
177:
178: PROCEDURE update_enroll_stats(
179: p_api_version IN NUMBER ,
180: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
181: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
182: p_person_number IN VARCHAR2,
183: p_career IN VARCHAR2,
184: p_program_code IN VARCHAR2,
177:
178: PROCEDURE update_enroll_stats(
179: p_api_version IN NUMBER ,
180: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
181: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
182: p_person_number IN VARCHAR2,
183: p_career IN VARCHAR2,
184: p_program_code IN VARCHAR2,
185: p_term_alt_code IN VARCHAR2,
189: x_msg_data OUT NOCOPY VARCHAR2);
190:
191: PROCEDURE validate_career_program(
192: p_api_version IN NUMBER ,
193: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
194: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
195: p_person_number IN VARCHAR2,
196: p_career IN VARCHAR2,
197: p_program_code IN VARCHAR2,
190:
191: PROCEDURE validate_career_program(
192: p_api_version IN NUMBER ,
193: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
194: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
195: p_person_number IN VARCHAR2,
196: p_career IN VARCHAR2,
197: p_program_code IN VARCHAR2,
198: x_primary_code OUT NOCOPY VARCHAR2,
202: x_msg_data OUT NOCOPY VARCHAR2);
203:
204: PROCEDURE validate_person_details(
205: p_api_version IN NUMBER,
206: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
207: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
208: p_person_number IN VARCHAR2,
209: x_default_term_alt_code OUT NOCOPY VARCHAR2,
210: x_career_tbl OUT NOCOPY career_tbl_type,
203:
204: PROCEDURE validate_person_details(
205: p_api_version IN NUMBER,
206: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
207: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
208: p_person_number IN VARCHAR2,
209: x_default_term_alt_code OUT NOCOPY VARCHAR2,
210: x_career_tbl OUT NOCOPY career_tbl_type,
211: x_term_tbl OUT NOCOPY term_tbl_type,
215: x_msg_data OUT NOCOPY VARCHAR2);
216:
217: PROCEDURE validate_term(
218: p_api_version IN NUMBER ,
219: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
220: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
221: p_term_alt_code IN VARCHAR2,
222: x_return_status OUT NOCOPY VARCHAR2,
223: x_msg_count OUT NOCOPY NUMBER,
216:
217: PROCEDURE validate_term(
218: p_api_version IN NUMBER ,
219: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
220: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
221: p_term_alt_code IN VARCHAR2,
222: x_return_status OUT NOCOPY VARCHAR2,
223: x_msg_count OUT NOCOPY NUMBER,
224: x_msg_data OUT NOCOPY VARCHAR2);
224: x_msg_data OUT NOCOPY VARCHAR2);
225:
226: PROCEDURE waitlist(
227: p_api_version IN NUMBER ,
228: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
229: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
230: p_person_number IN VARCHAR2,
231: p_career IN VARCHAR2,
232: p_program_code IN VARCHAR2,
225:
226: PROCEDURE waitlist(
227: p_api_version IN NUMBER ,
228: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
229: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
230: p_person_number IN VARCHAR2,
231: p_career IN VARCHAR2,
232: p_program_code IN VARCHAR2,
233: p_term_alt_code IN VARCHAR2,