eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_CO_PROCESS dependencies on FND_DSQL

Line 179: fnd_dsql.init;

175: l_list_id := l_cur_c1.document_id;
176: CLOSE cur_c1;
177: END IF;
178:
179: fnd_dsql.init;
180:
181: IF p_sys_ltr_code = 'ADRESID' THEN
182: fnd_dsql.add_text('SELECT DISTINCT email_address, person_id FROM ');
183: ELSIF p_sys_ltr_code IN ('ADADHOC','FAADHOC','GENERIC','ENADHOC','SFADHOC') THEN

Line 182: fnd_dsql.add_text('SELECT DISTINCT email_address, person_id FROM ');

178:
179: fnd_dsql.init;
180:
181: IF p_sys_ltr_code = 'ADRESID' THEN
182: fnd_dsql.add_text('SELECT DISTINCT email_address, person_id FROM ');
183: ELSIF p_sys_ltr_code IN ('ADADHOC','FAADHOC','GENERIC','ENADHOC','SFADHOC') THEN
184: fnd_dsql.add_text('SELECT DISTINCT email_address, party_id FROM ');
185: ELSIF p_sys_ltr_code = 'ADACKMT' THEN
186: fnd_dsql.add_text('SELECT DISTINCT email_address, person_id, adm_appl_number,nominated_course_cd, appl_sequence_number FROM ');

Line 184: fnd_dsql.add_text('SELECT DISTINCT email_address, party_id FROM ');

180:
181: IF p_sys_ltr_code = 'ADRESID' THEN
182: fnd_dsql.add_text('SELECT DISTINCT email_address, person_id FROM ');
183: ELSIF p_sys_ltr_code IN ('ADADHOC','FAADHOC','GENERIC','ENADHOC','SFADHOC') THEN
184: fnd_dsql.add_text('SELECT DISTINCT email_address, party_id FROM ');
185: ELSIF p_sys_ltr_code = 'ADACKMT' THEN
186: fnd_dsql.add_text('SELECT DISTINCT email_address, person_id, adm_appl_number,nominated_course_cd, appl_sequence_number FROM ');
187: ELSIF p_sys_ltr_code = 'ADINTRW' THEN
188: fnd_dsql.add_text('SELECT DISTINCT email_address, person_id, adm_appl_number,nominated_course_cd, appl_sequence_number, panel_code FROM ');

Line 186: fnd_dsql.add_text('SELECT DISTINCT email_address, person_id, adm_appl_number,nominated_course_cd, appl_sequence_number FROM ');

182: fnd_dsql.add_text('SELECT DISTINCT email_address, person_id FROM ');
183: ELSIF p_sys_ltr_code IN ('ADADHOC','FAADHOC','GENERIC','ENADHOC','SFADHOC') THEN
184: fnd_dsql.add_text('SELECT DISTINCT email_address, party_id FROM ');
185: ELSIF p_sys_ltr_code = 'ADACKMT' THEN
186: fnd_dsql.add_text('SELECT DISTINCT email_address, person_id, adm_appl_number,nominated_course_cd, appl_sequence_number FROM ');
187: ELSIF p_sys_ltr_code = 'ADINTRW' THEN
188: fnd_dsql.add_text('SELECT DISTINCT email_address, person_id, adm_appl_number,nominated_course_cd, appl_sequence_number, panel_code FROM ');
189: ELSE
190: fnd_dsql.add_text('SELECT DISTINCT email_address, person_id, adm_appl_number,nominated_course_cd, appl_sequence_number FROM ');

Line 188: fnd_dsql.add_text('SELECT DISTINCT email_address, person_id, adm_appl_number,nominated_course_cd, appl_sequence_number, panel_code FROM ');

184: fnd_dsql.add_text('SELECT DISTINCT email_address, party_id FROM ');
185: ELSIF p_sys_ltr_code = 'ADACKMT' THEN
186: fnd_dsql.add_text('SELECT DISTINCT email_address, person_id, adm_appl_number,nominated_course_cd, appl_sequence_number FROM ');
187: ELSIF p_sys_ltr_code = 'ADINTRW' THEN
188: fnd_dsql.add_text('SELECT DISTINCT email_address, person_id, adm_appl_number,nominated_course_cd, appl_sequence_number, panel_code FROM ');
189: ELSE
190: fnd_dsql.add_text('SELECT DISTINCT email_address, person_id, adm_appl_number,nominated_course_cd, appl_sequence_number FROM ');
191: END IF;
192: corp_get_system_letter_view (p_sys_ltr_code,

Line 190: fnd_dsql.add_text('SELECT DISTINCT email_address, person_id, adm_appl_number,nominated_course_cd, appl_sequence_number FROM ');

186: fnd_dsql.add_text('SELECT DISTINCT email_address, person_id, adm_appl_number,nominated_course_cd, appl_sequence_number FROM ');
187: ELSIF p_sys_ltr_code = 'ADINTRW' THEN
188: fnd_dsql.add_text('SELECT DISTINCT email_address, person_id, adm_appl_number,nominated_course_cd, appl_sequence_number, panel_code FROM ');
189: ELSE
190: fnd_dsql.add_text('SELECT DISTINCT email_address, person_id, adm_appl_number,nominated_course_cd, appl_sequence_number FROM ');
191: END IF;
192: corp_get_system_letter_view (p_sys_ltr_code,
193: l_view_name,
194: l_where_clause);

Line 215: fnd_dsql.add_text(l_view_name || ' WHERE person_id = ' );

211: --
212: IF p_letter_type = 'SYSTEM' THEN
213: IF l_where_clause IS NOT NULL THEN
214: IF p_sys_ltr_code = 'ADINTRW' THEN
215: fnd_dsql.add_text(l_view_name || ' WHERE person_id = ' );
216: fnd_dsql.add_bind(p_person_id);
217: fnd_dsql.add_text(' AND panel_code = ' );
218: fnd_dsql.add_bind(p_parameter_5);
219: ELSE

Line 216: fnd_dsql.add_bind(p_person_id);

212: IF p_letter_type = 'SYSTEM' THEN
213: IF l_where_clause IS NOT NULL THEN
214: IF p_sys_ltr_code = 'ADINTRW' THEN
215: fnd_dsql.add_text(l_view_name || ' WHERE person_id = ' );
216: fnd_dsql.add_bind(p_person_id);
217: fnd_dsql.add_text(' AND panel_code = ' );
218: fnd_dsql.add_bind(p_parameter_5);
219: ELSE
220: fnd_dsql.add_text(l_view_name || ' WHERE person_id = ');

Line 217: fnd_dsql.add_text(' AND panel_code = ' );

213: IF l_where_clause IS NOT NULL THEN
214: IF p_sys_ltr_code = 'ADINTRW' THEN
215: fnd_dsql.add_text(l_view_name || ' WHERE person_id = ' );
216: fnd_dsql.add_bind(p_person_id);
217: fnd_dsql.add_text(' AND panel_code = ' );
218: fnd_dsql.add_bind(p_parameter_5);
219: ELSE
220: fnd_dsql.add_text(l_view_name || ' WHERE person_id = ');
221: fnd_dsql.add_bind(p_person_id);

Line 218: fnd_dsql.add_bind(p_parameter_5);

214: IF p_sys_ltr_code = 'ADINTRW' THEN
215: fnd_dsql.add_text(l_view_name || ' WHERE person_id = ' );
216: fnd_dsql.add_bind(p_person_id);
217: fnd_dsql.add_text(' AND panel_code = ' );
218: fnd_dsql.add_bind(p_parameter_5);
219: ELSE
220: fnd_dsql.add_text(l_view_name || ' WHERE person_id = ');
221: fnd_dsql.add_bind(p_person_id);
222: END IF;

Line 220: fnd_dsql.add_text(l_view_name || ' WHERE person_id = ');

216: fnd_dsql.add_bind(p_person_id);
217: fnd_dsql.add_text(' AND panel_code = ' );
218: fnd_dsql.add_bind(p_parameter_5);
219: ELSE
220: fnd_dsql.add_text(l_view_name || ' WHERE person_id = ');
221: fnd_dsql.add_bind(p_person_id);
222: END IF;
223: fnd_dsql.add_text(' AND '|| l_where_clause);
224: ELSE

Line 221: fnd_dsql.add_bind(p_person_id);

217: fnd_dsql.add_text(' AND panel_code = ' );
218: fnd_dsql.add_bind(p_parameter_5);
219: ELSE
220: fnd_dsql.add_text(l_view_name || ' WHERE person_id = ');
221: fnd_dsql.add_bind(p_person_id);
222: END IF;
223: fnd_dsql.add_text(' AND '|| l_where_clause);
224: ELSE
225: fnd_dsql.add_text(l_view_name || ' WHERE person_id = ');

Line 223: fnd_dsql.add_text(' AND '|| l_where_clause);

219: ELSE
220: fnd_dsql.add_text(l_view_name || ' WHERE person_id = ');
221: fnd_dsql.add_bind(p_person_id);
222: END IF;
223: fnd_dsql.add_text(' AND '|| l_where_clause);
224: ELSE
225: fnd_dsql.add_text(l_view_name || ' WHERE person_id = ');
226: fnd_dsql.add_bind(p_person_id);
227: END IF;

Line 225: fnd_dsql.add_text(l_view_name || ' WHERE person_id = ');

221: fnd_dsql.add_bind(p_person_id);
222: END IF;
223: fnd_dsql.add_text(' AND '|| l_where_clause);
224: ELSE
225: fnd_dsql.add_text(l_view_name || ' WHERE person_id = ');
226: fnd_dsql.add_bind(p_person_id);
227: END IF;
228: ELSE
229: fnd_dsql.add_text(' hz_parties WHERE party_id = ');

Line 226: fnd_dsql.add_bind(p_person_id);

222: END IF;
223: fnd_dsql.add_text(' AND '|| l_where_clause);
224: ELSE
225: fnd_dsql.add_text(l_view_name || ' WHERE person_id = ');
226: fnd_dsql.add_bind(p_person_id);
227: END IF;
228: ELSE
229: fnd_dsql.add_text(' hz_parties WHERE party_id = ');
230: fnd_dsql.add_bind(p_person_id);

Line 229: fnd_dsql.add_text(' hz_parties WHERE party_id = ');

225: fnd_dsql.add_text(l_view_name || ' WHERE person_id = ');
226: fnd_dsql.add_bind(p_person_id);
227: END IF;
228: ELSE
229: fnd_dsql.add_text(' hz_parties WHERE party_id = ');
230: fnd_dsql.add_bind(p_person_id);
231: END IF;
232:
233: ELSIF p_select_type = 'L' THEN

Line 230: fnd_dsql.add_bind(p_person_id);

226: fnd_dsql.add_bind(p_person_id);
227: END IF;
228: ELSE
229: fnd_dsql.add_text(' hz_parties WHERE party_id = ');
230: fnd_dsql.add_bind(p_person_id);
231: END IF;
232:
233: ELSIF p_select_type = 'L' THEN
234: --

Line 277: fnd_dsql.add_text(l_view_name || ' WHERE '|| l_where_clause );

273: l_query_str := 'SELECT distinct person_id FROM '|| '(' || l_query_text || ')';
274:
275: IF l_where_clause IS NOT NULL THEN
276: IF p_sys_ltr_code = 'ADINTRW' THEN
277: fnd_dsql.add_text(l_view_name || ' WHERE '|| l_where_clause );
278: fnd_dsql.add_text(' AND panel_code = ' );
279: fnd_dsql.add_bind(p_parameter_5);
280: ELSE
281: fnd_dsql.add_text(l_view_name || ' WHERE '|| l_where_clause );

Line 278: fnd_dsql.add_text(' AND panel_code = ' );

274:
275: IF l_where_clause IS NOT NULL THEN
276: IF p_sys_ltr_code = 'ADINTRW' THEN
277: fnd_dsql.add_text(l_view_name || ' WHERE '|| l_where_clause );
278: fnd_dsql.add_text(' AND panel_code = ' );
279: fnd_dsql.add_bind(p_parameter_5);
280: ELSE
281: fnd_dsql.add_text(l_view_name || ' WHERE '|| l_where_clause );
282: END IF;

Line 279: fnd_dsql.add_bind(p_parameter_5);

275: IF l_where_clause IS NOT NULL THEN
276: IF p_sys_ltr_code = 'ADINTRW' THEN
277: fnd_dsql.add_text(l_view_name || ' WHERE '|| l_where_clause );
278: fnd_dsql.add_text(' AND panel_code = ' );
279: fnd_dsql.add_bind(p_parameter_5);
280: ELSE
281: fnd_dsql.add_text(l_view_name || ' WHERE '|| l_where_clause );
282: END IF;
283:

Line 281: fnd_dsql.add_text(l_view_name || ' WHERE '|| l_where_clause );

277: fnd_dsql.add_text(l_view_name || ' WHERE '|| l_where_clause );
278: fnd_dsql.add_text(' AND panel_code = ' );
279: fnd_dsql.add_bind(p_parameter_5);
280: ELSE
281: fnd_dsql.add_text(l_view_name || ' WHERE '|| l_where_clause );
282: END IF;
283:
284: --IF l_and_con IS NOT NULL THEN
285: IF l_query_str IS NOT NULL THEN

Line 287: fnd_dsql.add_text(' AND person_id IN ('||l_query_str||' )');

283:
284: --IF l_and_con IS NOT NULL THEN
285: IF l_query_str IS NOT NULL THEN
286: IF p_sys_ltr_code = 'ADINTRW' THEN
287: fnd_dsql.add_text(' AND person_id IN ('||l_query_str||' )');
288: fnd_dsql.add_text(' AND panel_code = ' );
289: fnd_dsql.add_bind(p_parameter_5);
290: ELSE
291: fnd_dsql.add_text('AND person_id IN ('||l_query_str||' )');

Line 288: fnd_dsql.add_text(' AND panel_code = ' );

284: --IF l_and_con IS NOT NULL THEN
285: IF l_query_str IS NOT NULL THEN
286: IF p_sys_ltr_code = 'ADINTRW' THEN
287: fnd_dsql.add_text(' AND person_id IN ('||l_query_str||' )');
288: fnd_dsql.add_text(' AND panel_code = ' );
289: fnd_dsql.add_bind(p_parameter_5);
290: ELSE
291: fnd_dsql.add_text('AND person_id IN ('||l_query_str||' )');
292: END IF;

Line 289: fnd_dsql.add_bind(p_parameter_5);

285: IF l_query_str IS NOT NULL THEN
286: IF p_sys_ltr_code = 'ADINTRW' THEN
287: fnd_dsql.add_text(' AND person_id IN ('||l_query_str||' )');
288: fnd_dsql.add_text(' AND panel_code = ' );
289: fnd_dsql.add_bind(p_parameter_5);
290: ELSE
291: fnd_dsql.add_text('AND person_id IN ('||l_query_str||' )');
292: END IF;
293: END IF;

Line 291: fnd_dsql.add_text('AND person_id IN ('||l_query_str||' )');

287: fnd_dsql.add_text(' AND person_id IN ('||l_query_str||' )');
288: fnd_dsql.add_text(' AND panel_code = ' );
289: fnd_dsql.add_bind(p_parameter_5);
290: ELSE
291: fnd_dsql.add_text('AND person_id IN ('||l_query_str||' )');
292: END IF;
293: END IF;
294: ELSE
295:

Line 296: fnd_dsql.add_text(l_view_name );

292: END IF;
293: END IF;
294: ELSE
295:
296: fnd_dsql.add_text(l_view_name );
297:
298: IF l_query_str IS NOT NULL THEN
299: IF p_sys_ltr_code IN ('ADADHOC','FAADHOC','GENERIC','ENADHOC','SFADHOC') THEN
300: fnd_dsql.add_text(' WHERE party_id IN(' || l_query_str ||' )');

Line 300: fnd_dsql.add_text(' WHERE party_id IN(' || l_query_str ||' )');

296: fnd_dsql.add_text(l_view_name );
297:
298: IF l_query_str IS NOT NULL THEN
299: IF p_sys_ltr_code IN ('ADADHOC','FAADHOC','GENERIC','ENADHOC','SFADHOC') THEN
300: fnd_dsql.add_text(' WHERE party_id IN(' || l_query_str ||' )');
301: ELSE
302: IF p_sys_ltr_code = 'ADINTRW' THEN
303: fnd_dsql.add_text(' WHERE person_id IN(' || l_query_str ||' )');
304: fnd_dsql.add_text(' AND panel_code = ' );

Line 303: fnd_dsql.add_text(' WHERE person_id IN(' || l_query_str ||' )');

299: IF p_sys_ltr_code IN ('ADADHOC','FAADHOC','GENERIC','ENADHOC','SFADHOC') THEN
300: fnd_dsql.add_text(' WHERE party_id IN(' || l_query_str ||' )');
301: ELSE
302: IF p_sys_ltr_code = 'ADINTRW' THEN
303: fnd_dsql.add_text(' WHERE person_id IN(' || l_query_str ||' )');
304: fnd_dsql.add_text(' AND panel_code = ' );
305: fnd_dsql.add_bind(p_parameter_5);
306: ELSE
307: fnd_dsql.add_text(' WHERE person_id IN(' || l_query_str ||' )');

Line 304: fnd_dsql.add_text(' AND panel_code = ' );

300: fnd_dsql.add_text(' WHERE party_id IN(' || l_query_str ||' )');
301: ELSE
302: IF p_sys_ltr_code = 'ADINTRW' THEN
303: fnd_dsql.add_text(' WHERE person_id IN(' || l_query_str ||' )');
304: fnd_dsql.add_text(' AND panel_code = ' );
305: fnd_dsql.add_bind(p_parameter_5);
306: ELSE
307: fnd_dsql.add_text(' WHERE person_id IN(' || l_query_str ||' )');
308: END IF;

Line 305: fnd_dsql.add_bind(p_parameter_5);

301: ELSE
302: IF p_sys_ltr_code = 'ADINTRW' THEN
303: fnd_dsql.add_text(' WHERE person_id IN(' || l_query_str ||' )');
304: fnd_dsql.add_text(' AND panel_code = ' );
305: fnd_dsql.add_bind(p_parameter_5);
306: ELSE
307: fnd_dsql.add_text(' WHERE person_id IN(' || l_query_str ||' )');
308: END IF;
309: END IF;

Line 307: fnd_dsql.add_text(' WHERE person_id IN(' || l_query_str ||' )');

303: fnd_dsql.add_text(' WHERE person_id IN(' || l_query_str ||' )');
304: fnd_dsql.add_text(' AND panel_code = ' );
305: fnd_dsql.add_bind(p_parameter_5);
306: ELSE
307: fnd_dsql.add_text(' WHERE person_id IN(' || l_query_str ||' )');
308: END IF;
309: END IF;
310: END IF;
311: END IF;

Line 341: fnd_dsql.add_text(l_view_name || ' WHERE person_id IN ('||l_str);

337:
338: IF l_where_clause IS NOT NULL THEN
339: IF p_sys_ltr_code = 'ADINTRW' THEN
340: IF l_str IS NOT NULL THEN
341: fnd_dsql.add_text(l_view_name || ' WHERE person_id IN ('||l_str);
342: IF l_group_type = 'STATIC' THEN
343: fnd_dsql.add_bind(p_parameter_1);
344: END IF;
345: fnd_dsql.add_text(') AND '||l_where_clause||' AND panel_code = ' );

Line 343: fnd_dsql.add_bind(p_parameter_1);

339: IF p_sys_ltr_code = 'ADINTRW' THEN
340: IF l_str IS NOT NULL THEN
341: fnd_dsql.add_text(l_view_name || ' WHERE person_id IN ('||l_str);
342: IF l_group_type = 'STATIC' THEN
343: fnd_dsql.add_bind(p_parameter_1);
344: END IF;
345: fnd_dsql.add_text(') AND '||l_where_clause||' AND panel_code = ' );
346: fnd_dsql.add_bind(p_parameter_5);
347: ELSE

Line 345: fnd_dsql.add_text(') AND '||l_where_clause||' AND panel_code = ' );

341: fnd_dsql.add_text(l_view_name || ' WHERE person_id IN ('||l_str);
342: IF l_group_type = 'STATIC' THEN
343: fnd_dsql.add_bind(p_parameter_1);
344: END IF;
345: fnd_dsql.add_text(') AND '||l_where_clause||' AND panel_code = ' );
346: fnd_dsql.add_bind(p_parameter_5);
347: ELSE
348: fnd_dsql.add_text(l_view_name || ' WHERE '||l_where_clause);
349: fnd_dsql.add_text(' AND panel_code = ' );

Line 346: fnd_dsql.add_bind(p_parameter_5);

342: IF l_group_type = 'STATIC' THEN
343: fnd_dsql.add_bind(p_parameter_1);
344: END IF;
345: fnd_dsql.add_text(') AND '||l_where_clause||' AND panel_code = ' );
346: fnd_dsql.add_bind(p_parameter_5);
347: ELSE
348: fnd_dsql.add_text(l_view_name || ' WHERE '||l_where_clause);
349: fnd_dsql.add_text(' AND panel_code = ' );
350: fnd_dsql.add_bind(p_parameter_5);

Line 348: fnd_dsql.add_text(l_view_name || ' WHERE '||l_where_clause);

344: END IF;
345: fnd_dsql.add_text(') AND '||l_where_clause||' AND panel_code = ' );
346: fnd_dsql.add_bind(p_parameter_5);
347: ELSE
348: fnd_dsql.add_text(l_view_name || ' WHERE '||l_where_clause);
349: fnd_dsql.add_text(' AND panel_code = ' );
350: fnd_dsql.add_bind(p_parameter_5);
351: END IF;
352: ELSE

Line 349: fnd_dsql.add_text(' AND panel_code = ' );

345: fnd_dsql.add_text(') AND '||l_where_clause||' AND panel_code = ' );
346: fnd_dsql.add_bind(p_parameter_5);
347: ELSE
348: fnd_dsql.add_text(l_view_name || ' WHERE '||l_where_clause);
349: fnd_dsql.add_text(' AND panel_code = ' );
350: fnd_dsql.add_bind(p_parameter_5);
351: END IF;
352: ELSE
353: IF l_str IS NOT NULL THEN

Line 350: fnd_dsql.add_bind(p_parameter_5);

346: fnd_dsql.add_bind(p_parameter_5);
347: ELSE
348: fnd_dsql.add_text(l_view_name || ' WHERE '||l_where_clause);
349: fnd_dsql.add_text(' AND panel_code = ' );
350: fnd_dsql.add_bind(p_parameter_5);
351: END IF;
352: ELSE
353: IF l_str IS NOT NULL THEN
354: fnd_dsql.add_text(l_view_name || ' WHERE person_id IN ('||l_str);

Line 354: fnd_dsql.add_text(l_view_name || ' WHERE person_id IN ('||l_str);

350: fnd_dsql.add_bind(p_parameter_5);
351: END IF;
352: ELSE
353: IF l_str IS NOT NULL THEN
354: fnd_dsql.add_text(l_view_name || ' WHERE person_id IN ('||l_str);
355: IF l_group_type = 'STATIC' THEN
356: fnd_dsql.add_bind(p_parameter_1);
357: END IF;
358: fnd_dsql.add_text(') AND '||l_where_clause);

Line 356: fnd_dsql.add_bind(p_parameter_1);

352: ELSE
353: IF l_str IS NOT NULL THEN
354: fnd_dsql.add_text(l_view_name || ' WHERE person_id IN ('||l_str);
355: IF l_group_type = 'STATIC' THEN
356: fnd_dsql.add_bind(p_parameter_1);
357: END IF;
358: fnd_dsql.add_text(') AND '||l_where_clause);
359: ELSE
360: fnd_dsql.add_text(l_view_name || ' WHERE '||l_where_clause);

Line 358: fnd_dsql.add_text(') AND '||l_where_clause);

354: fnd_dsql.add_text(l_view_name || ' WHERE person_id IN ('||l_str);
355: IF l_group_type = 'STATIC' THEN
356: fnd_dsql.add_bind(p_parameter_1);
357: END IF;
358: fnd_dsql.add_text(') AND '||l_where_clause);
359: ELSE
360: fnd_dsql.add_text(l_view_name || ' WHERE '||l_where_clause);
361: END IF;
362: END IF;

Line 360: fnd_dsql.add_text(l_view_name || ' WHERE '||l_where_clause);

356: fnd_dsql.add_bind(p_parameter_1);
357: END IF;
358: fnd_dsql.add_text(') AND '||l_where_clause);
359: ELSE
360: fnd_dsql.add_text(l_view_name || ' WHERE '||l_where_clause);
361: END IF;
362: END IF;
363: ELSE
364:

Line 369: fnd_dsql.add_text(l_view_name|| ' WHERE person_id IN ('||l_str);

365: -- adhoc letters will not have where clause
366:
367: IF p_sys_ltr_code = 'ADINTRW' THEN
368: IF l_str IS NOT NULL THEN
369: fnd_dsql.add_text(l_view_name|| ' WHERE person_id IN ('||l_str);
370: IF l_group_type = 'STATIC' THEN
371: fnd_dsql.add_bind(p_parameter_1);
372: END IF;
373: fnd_dsql.add_text(') AND panel_code = ' );

Line 371: fnd_dsql.add_bind(p_parameter_1);

367: IF p_sys_ltr_code = 'ADINTRW' THEN
368: IF l_str IS NOT NULL THEN
369: fnd_dsql.add_text(l_view_name|| ' WHERE person_id IN ('||l_str);
370: IF l_group_type = 'STATIC' THEN
371: fnd_dsql.add_bind(p_parameter_1);
372: END IF;
373: fnd_dsql.add_text(') AND panel_code = ' );
374: fnd_dsql.add_bind(p_parameter_5);
375: ELSE

Line 373: fnd_dsql.add_text(') AND panel_code = ' );

369: fnd_dsql.add_text(l_view_name|| ' WHERE person_id IN ('||l_str);
370: IF l_group_type = 'STATIC' THEN
371: fnd_dsql.add_bind(p_parameter_1);
372: END IF;
373: fnd_dsql.add_text(') AND panel_code = ' );
374: fnd_dsql.add_bind(p_parameter_5);
375: ELSE
376: fnd_dsql.add_text(l_view_name|| ' WHERE ');
377: fnd_dsql.add_text(' panel_code = ' );

Line 374: fnd_dsql.add_bind(p_parameter_5);

370: IF l_group_type = 'STATIC' THEN
371: fnd_dsql.add_bind(p_parameter_1);
372: END IF;
373: fnd_dsql.add_text(') AND panel_code = ' );
374: fnd_dsql.add_bind(p_parameter_5);
375: ELSE
376: fnd_dsql.add_text(l_view_name|| ' WHERE ');
377: fnd_dsql.add_text(' panel_code = ' );
378: fnd_dsql.add_bind(p_parameter_5);

Line 376: fnd_dsql.add_text(l_view_name|| ' WHERE ');

372: END IF;
373: fnd_dsql.add_text(') AND panel_code = ' );
374: fnd_dsql.add_bind(p_parameter_5);
375: ELSE
376: fnd_dsql.add_text(l_view_name|| ' WHERE ');
377: fnd_dsql.add_text(' panel_code = ' );
378: fnd_dsql.add_bind(p_parameter_5);
379: END IF;
380: ELSE

Line 377: fnd_dsql.add_text(' panel_code = ' );

373: fnd_dsql.add_text(') AND panel_code = ' );
374: fnd_dsql.add_bind(p_parameter_5);
375: ELSE
376: fnd_dsql.add_text(l_view_name|| ' WHERE ');
377: fnd_dsql.add_text(' panel_code = ' );
378: fnd_dsql.add_bind(p_parameter_5);
379: END IF;
380: ELSE
381: IF l_str IS NOT NULL THEN

Line 378: fnd_dsql.add_bind(p_parameter_5);

374: fnd_dsql.add_bind(p_parameter_5);
375: ELSE
376: fnd_dsql.add_text(l_view_name|| ' WHERE ');
377: fnd_dsql.add_text(' panel_code = ' );
378: fnd_dsql.add_bind(p_parameter_5);
379: END IF;
380: ELSE
381: IF l_str IS NOT NULL THEN
382: IF p_sys_ltr_code IN ('ADADHOC','FAADHOC','GENERIC','ENADHOC','SFADHOC') THEN

Line 383: fnd_dsql.add_text(l_view_name|| ' WHERE party_id IN ('||l_str);

379: END IF;
380: ELSE
381: IF l_str IS NOT NULL THEN
382: IF p_sys_ltr_code IN ('ADADHOC','FAADHOC','GENERIC','ENADHOC','SFADHOC') THEN
383: fnd_dsql.add_text(l_view_name|| ' WHERE party_id IN ('||l_str);
384: IF l_group_type = 'STATIC' THEN
385: fnd_dsql.add_bind(p_parameter_1);
386: END IF;
387: fnd_dsql.add_text(')');

Line 385: fnd_dsql.add_bind(p_parameter_1);

381: IF l_str IS NOT NULL THEN
382: IF p_sys_ltr_code IN ('ADADHOC','FAADHOC','GENERIC','ENADHOC','SFADHOC') THEN
383: fnd_dsql.add_text(l_view_name|| ' WHERE party_id IN ('||l_str);
384: IF l_group_type = 'STATIC' THEN
385: fnd_dsql.add_bind(p_parameter_1);
386: END IF;
387: fnd_dsql.add_text(')');
388: ELSE
389: fnd_dsql.add_text(l_view_name|| ' WHERE person_id IN ('||l_str);

Line 387: fnd_dsql.add_text(')');

383: fnd_dsql.add_text(l_view_name|| ' WHERE party_id IN ('||l_str);
384: IF l_group_type = 'STATIC' THEN
385: fnd_dsql.add_bind(p_parameter_1);
386: END IF;
387: fnd_dsql.add_text(')');
388: ELSE
389: fnd_dsql.add_text(l_view_name|| ' WHERE person_id IN ('||l_str);
390: IF l_group_type = 'STATIC' THEN
391: fnd_dsql.add_bind(p_parameter_1);

Line 389: fnd_dsql.add_text(l_view_name|| ' WHERE person_id IN ('||l_str);

385: fnd_dsql.add_bind(p_parameter_1);
386: END IF;
387: fnd_dsql.add_text(')');
388: ELSE
389: fnd_dsql.add_text(l_view_name|| ' WHERE person_id IN ('||l_str);
390: IF l_group_type = 'STATIC' THEN
391: fnd_dsql.add_bind(p_parameter_1);
392: END IF;
393: fnd_dsql.add_text(')');

Line 391: fnd_dsql.add_bind(p_parameter_1);

387: fnd_dsql.add_text(')');
388: ELSE
389: fnd_dsql.add_text(l_view_name|| ' WHERE person_id IN ('||l_str);
390: IF l_group_type = 'STATIC' THEN
391: fnd_dsql.add_bind(p_parameter_1);
392: END IF;
393: fnd_dsql.add_text(')');
394: END IF;
395: ELSE

Line 393: fnd_dsql.add_text(')');

389: fnd_dsql.add_text(l_view_name|| ' WHERE person_id IN ('||l_str);
390: IF l_group_type = 'STATIC' THEN
391: fnd_dsql.add_bind(p_parameter_1);
392: END IF;
393: fnd_dsql.add_text(')');
394: END IF;
395: ELSE
396: fnd_dsql.add_text(l_view_name);
397: END IF;

Line 396: fnd_dsql.add_text(l_view_name);

392: END IF;
393: fnd_dsql.add_text(')');
394: END IF;
395: ELSE
396: fnd_dsql.add_text(l_view_name);
397: END IF;
398: END IF;
399: END IF;
400:

Line 418: p_sql_stmt := fnd_dsql.get_text(FALSE);

414: END IF;
415:
416: END IF;
417:
418: p_sql_stmt := fnd_dsql.get_text(FALSE);
419:
420: --** proc level logging.
421: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
422:

Line 1913: fnd_dsql.add_text(' AND ');

1909: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
1910: END IF;
1911: --**
1912:
1913: fnd_dsql.add_text(' AND ');
1914:
1915: IF p_parameter_1 IS NOT NULL THEN
1916: l_pers_group_id := TO_NUMBER(p_parameter_1);
1917: END IF;

Line 1937: fnd_dsql.add_text(' 1=1 ' );

1933: END IF;
1934:
1935: IF p_sys_ltr_code = 'ADMISTM' THEN
1936: IF p_parameter_1 IS NOT NULL THEN
1937: fnd_dsql.add_text(' 1=1 ' );
1938: ELSE
1939: fnd_dsql.add_text(' acad_cal_type = ');
1940: fnd_dsql.add_bind(l_acad_cal_type);
1941: fnd_dsql.add_text(' AND acad_ci_sequence_number = ');

Line 1939: fnd_dsql.add_text(' acad_cal_type = ');

1935: IF p_sys_ltr_code = 'ADMISTM' THEN
1936: IF p_parameter_1 IS NOT NULL THEN
1937: fnd_dsql.add_text(' 1=1 ' );
1938: ELSE
1939: fnd_dsql.add_text(' acad_cal_type = ');
1940: fnd_dsql.add_bind(l_acad_cal_type);
1941: fnd_dsql.add_text(' AND acad_ci_sequence_number = ');
1942: fnd_dsql.add_bind(l_acad_ci_sequence_number);
1943: fnd_dsql.add_text(' AND adm_cal_type = ');

Line 1940: fnd_dsql.add_bind(l_acad_cal_type);

1936: IF p_parameter_1 IS NOT NULL THEN
1937: fnd_dsql.add_text(' 1=1 ' );
1938: ELSE
1939: fnd_dsql.add_text(' acad_cal_type = ');
1940: fnd_dsql.add_bind(l_acad_cal_type);
1941: fnd_dsql.add_text(' AND acad_ci_sequence_number = ');
1942: fnd_dsql.add_bind(l_acad_ci_sequence_number);
1943: fnd_dsql.add_text(' AND adm_cal_type = ');
1944: fnd_dsql.add_bind(l_adm_cal_type);

Line 1941: fnd_dsql.add_text(' AND acad_ci_sequence_number = ');

1937: fnd_dsql.add_text(' 1=1 ' );
1938: ELSE
1939: fnd_dsql.add_text(' acad_cal_type = ');
1940: fnd_dsql.add_bind(l_acad_cal_type);
1941: fnd_dsql.add_text(' AND acad_ci_sequence_number = ');
1942: fnd_dsql.add_bind(l_acad_ci_sequence_number);
1943: fnd_dsql.add_text(' AND adm_cal_type = ');
1944: fnd_dsql.add_bind(l_adm_cal_type);
1945: fnd_dsql.add_text(' AND adm_ci_sequence_number =');

Line 1942: fnd_dsql.add_bind(l_acad_ci_sequence_number);

1938: ELSE
1939: fnd_dsql.add_text(' acad_cal_type = ');
1940: fnd_dsql.add_bind(l_acad_cal_type);
1941: fnd_dsql.add_text(' AND acad_ci_sequence_number = ');
1942: fnd_dsql.add_bind(l_acad_ci_sequence_number);
1943: fnd_dsql.add_text(' AND adm_cal_type = ');
1944: fnd_dsql.add_bind(l_adm_cal_type);
1945: fnd_dsql.add_text(' AND adm_ci_sequence_number =');
1946: fnd_dsql.add_bind(l_adm_ci_sequence_number);

Line 1943: fnd_dsql.add_text(' AND adm_cal_type = ');

1939: fnd_dsql.add_text(' acad_cal_type = ');
1940: fnd_dsql.add_bind(l_acad_cal_type);
1941: fnd_dsql.add_text(' AND acad_ci_sequence_number = ');
1942: fnd_dsql.add_bind(l_acad_ci_sequence_number);
1943: fnd_dsql.add_text(' AND adm_cal_type = ');
1944: fnd_dsql.add_bind(l_adm_cal_type);
1945: fnd_dsql.add_text(' AND adm_ci_sequence_number =');
1946: fnd_dsql.add_bind(l_adm_ci_sequence_number);
1947: fnd_dsql.add_text(' AND adm_process_cat =');

Line 1944: fnd_dsql.add_bind(l_adm_cal_type);

1940: fnd_dsql.add_bind(l_acad_cal_type);
1941: fnd_dsql.add_text(' AND acad_ci_sequence_number = ');
1942: fnd_dsql.add_bind(l_acad_ci_sequence_number);
1943: fnd_dsql.add_text(' AND adm_cal_type = ');
1944: fnd_dsql.add_bind(l_adm_cal_type);
1945: fnd_dsql.add_text(' AND adm_ci_sequence_number =');
1946: fnd_dsql.add_bind(l_adm_ci_sequence_number);
1947: fnd_dsql.add_text(' AND adm_process_cat =');
1948: fnd_dsql.add_bind(p_parameter_4);

Line 1945: fnd_dsql.add_text(' AND adm_ci_sequence_number =');

1941: fnd_dsql.add_text(' AND acad_ci_sequence_number = ');
1942: fnd_dsql.add_bind(l_acad_ci_sequence_number);
1943: fnd_dsql.add_text(' AND adm_cal_type = ');
1944: fnd_dsql.add_bind(l_adm_cal_type);
1945: fnd_dsql.add_text(' AND adm_ci_sequence_number =');
1946: fnd_dsql.add_bind(l_adm_ci_sequence_number);
1947: fnd_dsql.add_text(' AND adm_process_cat =');
1948: fnd_dsql.add_bind(p_parameter_4);
1949: fnd_dsql.add_text(' AND adm_doc_status = ');

Line 1946: fnd_dsql.add_bind(l_adm_ci_sequence_number);

1942: fnd_dsql.add_bind(l_acad_ci_sequence_number);
1943: fnd_dsql.add_text(' AND adm_cal_type = ');
1944: fnd_dsql.add_bind(l_adm_cal_type);
1945: fnd_dsql.add_text(' AND adm_ci_sequence_number =');
1946: fnd_dsql.add_bind(l_adm_ci_sequence_number);
1947: fnd_dsql.add_text(' AND adm_process_cat =');
1948: fnd_dsql.add_bind(p_parameter_4);
1949: fnd_dsql.add_text(' AND adm_doc_status = ');
1950: fnd_dsql.add_bind(p_parameter_5);

Line 1947: fnd_dsql.add_text(' AND adm_process_cat =');

1943: fnd_dsql.add_text(' AND adm_cal_type = ');
1944: fnd_dsql.add_bind(l_adm_cal_type);
1945: fnd_dsql.add_text(' AND adm_ci_sequence_number =');
1946: fnd_dsql.add_bind(l_adm_ci_sequence_number);
1947: fnd_dsql.add_text(' AND adm_process_cat =');
1948: fnd_dsql.add_bind(p_parameter_4);
1949: fnd_dsql.add_text(' AND adm_doc_status = ');
1950: fnd_dsql.add_bind(p_parameter_5);
1951: fnd_dsql.add_text(' AND org_unit_cd = ');

Line 1948: fnd_dsql.add_bind(p_parameter_4);

1944: fnd_dsql.add_bind(l_adm_cal_type);
1945: fnd_dsql.add_text(' AND adm_ci_sequence_number =');
1946: fnd_dsql.add_bind(l_adm_ci_sequence_number);
1947: fnd_dsql.add_text(' AND adm_process_cat =');
1948: fnd_dsql.add_bind(p_parameter_4);
1949: fnd_dsql.add_text(' AND adm_doc_status = ');
1950: fnd_dsql.add_bind(p_parameter_5);
1951: fnd_dsql.add_text(' AND org_unit_cd = ');
1952: fnd_dsql.add_bind(p_parameter_6);

Line 1949: fnd_dsql.add_text(' AND adm_doc_status = ');

1945: fnd_dsql.add_text(' AND adm_ci_sequence_number =');
1946: fnd_dsql.add_bind(l_adm_ci_sequence_number);
1947: fnd_dsql.add_text(' AND adm_process_cat =');
1948: fnd_dsql.add_bind(p_parameter_4);
1949: fnd_dsql.add_text(' AND adm_doc_status = ');
1950: fnd_dsql.add_bind(p_parameter_5);
1951: fnd_dsql.add_text(' AND org_unit_cd = ');
1952: fnd_dsql.add_bind(p_parameter_6);
1953: fnd_dsql.add_text(' AND person_id = ');

Line 1950: fnd_dsql.add_bind(p_parameter_5);

1946: fnd_dsql.add_bind(l_adm_ci_sequence_number);
1947: fnd_dsql.add_text(' AND adm_process_cat =');
1948: fnd_dsql.add_bind(p_parameter_4);
1949: fnd_dsql.add_text(' AND adm_doc_status = ');
1950: fnd_dsql.add_bind(p_parameter_5);
1951: fnd_dsql.add_text(' AND org_unit_cd = ');
1952: fnd_dsql.add_bind(p_parameter_6);
1953: fnd_dsql.add_text(' AND person_id = ');
1954: fnd_dsql.add_bind(l_parameter_7);

Line 1951: fnd_dsql.add_text(' AND org_unit_cd = ');

1947: fnd_dsql.add_text(' AND adm_process_cat =');
1948: fnd_dsql.add_bind(p_parameter_4);
1949: fnd_dsql.add_text(' AND adm_doc_status = ');
1950: fnd_dsql.add_bind(p_parameter_5);
1951: fnd_dsql.add_text(' AND org_unit_cd = ');
1952: fnd_dsql.add_bind(p_parameter_6);
1953: fnd_dsql.add_text(' AND person_id = ');
1954: fnd_dsql.add_bind(l_parameter_7);
1955: fnd_dsql.add_text(' AND adm_appl_number = ');

Line 1952: fnd_dsql.add_bind(p_parameter_6);

1948: fnd_dsql.add_bind(p_parameter_4);
1949: fnd_dsql.add_text(' AND adm_doc_status = ');
1950: fnd_dsql.add_bind(p_parameter_5);
1951: fnd_dsql.add_text(' AND org_unit_cd = ');
1952: fnd_dsql.add_bind(p_parameter_6);
1953: fnd_dsql.add_text(' AND person_id = ');
1954: fnd_dsql.add_bind(l_parameter_7);
1955: fnd_dsql.add_text(' AND adm_appl_number = ');
1956: fnd_dsql.add_bind(l_parameter_8);

Line 1953: fnd_dsql.add_text(' AND person_id = ');

1949: fnd_dsql.add_text(' AND adm_doc_status = ');
1950: fnd_dsql.add_bind(p_parameter_5);
1951: fnd_dsql.add_text(' AND org_unit_cd = ');
1952: fnd_dsql.add_bind(p_parameter_6);
1953: fnd_dsql.add_text(' AND person_id = ');
1954: fnd_dsql.add_bind(l_parameter_7);
1955: fnd_dsql.add_text(' AND adm_appl_number = ');
1956: fnd_dsql.add_bind(l_parameter_8);
1957: fnd_dsql.add_text(' AND nominated_course_cd = ');

Line 1954: fnd_dsql.add_bind(l_parameter_7);

1950: fnd_dsql.add_bind(p_parameter_5);
1951: fnd_dsql.add_text(' AND org_unit_cd = ');
1952: fnd_dsql.add_bind(p_parameter_6);
1953: fnd_dsql.add_text(' AND person_id = ');
1954: fnd_dsql.add_bind(l_parameter_7);
1955: fnd_dsql.add_text(' AND adm_appl_number = ');
1956: fnd_dsql.add_bind(l_parameter_8);
1957: fnd_dsql.add_text(' AND nominated_course_cd = ');
1958: fnd_dsql.add_bind(l_parameter_9);

Line 1955: fnd_dsql.add_text(' AND adm_appl_number = ');

1951: fnd_dsql.add_text(' AND org_unit_cd = ');
1952: fnd_dsql.add_bind(p_parameter_6);
1953: fnd_dsql.add_text(' AND person_id = ');
1954: fnd_dsql.add_bind(l_parameter_7);
1955: fnd_dsql.add_text(' AND adm_appl_number = ');
1956: fnd_dsql.add_bind(l_parameter_8);
1957: fnd_dsql.add_text(' AND nominated_course_cd = ');
1958: fnd_dsql.add_bind(l_parameter_9);
1959: fnd_dsql.add_text(' AND appl_sequence_number = ');

Line 1956: fnd_dsql.add_bind(l_parameter_8);

1952: fnd_dsql.add_bind(p_parameter_6);
1953: fnd_dsql.add_text(' AND person_id = ');
1954: fnd_dsql.add_bind(l_parameter_7);
1955: fnd_dsql.add_text(' AND adm_appl_number = ');
1956: fnd_dsql.add_bind(l_parameter_8);
1957: fnd_dsql.add_text(' AND nominated_course_cd = ');
1958: fnd_dsql.add_bind(l_parameter_9);
1959: fnd_dsql.add_text(' AND appl_sequence_number = ');
1960: fnd_dsql.add_bind(l_parameter_10);

Line 1957: fnd_dsql.add_text(' AND nominated_course_cd = ');

1953: fnd_dsql.add_text(' AND person_id = ');
1954: fnd_dsql.add_bind(l_parameter_7);
1955: fnd_dsql.add_text(' AND adm_appl_number = ');
1956: fnd_dsql.add_bind(l_parameter_8);
1957: fnd_dsql.add_text(' AND nominated_course_cd = ');
1958: fnd_dsql.add_bind(l_parameter_9);
1959: fnd_dsql.add_text(' AND appl_sequence_number = ');
1960: fnd_dsql.add_bind(l_parameter_10);
1961: END IF;

Line 1958: fnd_dsql.add_bind(l_parameter_9);

1954: fnd_dsql.add_bind(l_parameter_7);
1955: fnd_dsql.add_text(' AND adm_appl_number = ');
1956: fnd_dsql.add_bind(l_parameter_8);
1957: fnd_dsql.add_text(' AND nominated_course_cd = ');
1958: fnd_dsql.add_bind(l_parameter_9);
1959: fnd_dsql.add_text(' AND appl_sequence_number = ');
1960: fnd_dsql.add_bind(l_parameter_10);
1961: END IF;
1962:

Line 1959: fnd_dsql.add_text(' AND appl_sequence_number = ');

1955: fnd_dsql.add_text(' AND adm_appl_number = ');
1956: fnd_dsql.add_bind(l_parameter_8);
1957: fnd_dsql.add_text(' AND nominated_course_cd = ');
1958: fnd_dsql.add_bind(l_parameter_9);
1959: fnd_dsql.add_text(' AND appl_sequence_number = ');
1960: fnd_dsql.add_bind(l_parameter_10);
1961: END IF;
1962:
1963: ELSIF P_SYS_LTR_CODE = 'ADACKMT' THEN

Line 1960: fnd_dsql.add_bind(l_parameter_10);

1956: fnd_dsql.add_bind(l_parameter_8);
1957: fnd_dsql.add_text(' AND nominated_course_cd = ');
1958: fnd_dsql.add_bind(l_parameter_9);
1959: fnd_dsql.add_text(' AND appl_sequence_number = ');
1960: fnd_dsql.add_bind(l_parameter_10);
1961: END IF;
1962:
1963: ELSIF P_SYS_LTR_CODE = 'ADACKMT' THEN
1964: IF p_parameter_1 IS NOT NULL THEN

Line 1965: fnd_dsql.add_text(' 1=1 ' );

1961: END IF;
1962:
1963: ELSIF P_SYS_LTR_CODE = 'ADACKMT' THEN
1964: IF p_parameter_1 IS NOT NULL THEN
1965: fnd_dsql.add_text(' 1=1 ' );
1966: ELSE
1967: fnd_dsql.add_text(' acad_cal_type = ');
1968: fnd_dsql.add_bind(l_acad_cal_type);
1969: fnd_dsql.add_text(' AND acad_ci_sequence_number = ');

Line 1967: fnd_dsql.add_text(' acad_cal_type = ');

1963: ELSIF P_SYS_LTR_CODE = 'ADACKMT' THEN
1964: IF p_parameter_1 IS NOT NULL THEN
1965: fnd_dsql.add_text(' 1=1 ' );
1966: ELSE
1967: fnd_dsql.add_text(' acad_cal_type = ');
1968: fnd_dsql.add_bind(l_acad_cal_type);
1969: fnd_dsql.add_text(' AND acad_ci_sequence_number = ');
1970: fnd_dsql.add_bind(l_acad_ci_sequence_number);
1971: fnd_dsql.add_text(' AND adm_cal_type = ');

Line 1968: fnd_dsql.add_bind(l_acad_cal_type);

1964: IF p_parameter_1 IS NOT NULL THEN
1965: fnd_dsql.add_text(' 1=1 ' );
1966: ELSE
1967: fnd_dsql.add_text(' acad_cal_type = ');
1968: fnd_dsql.add_bind(l_acad_cal_type);
1969: fnd_dsql.add_text(' AND acad_ci_sequence_number = ');
1970: fnd_dsql.add_bind(l_acad_ci_sequence_number);
1971: fnd_dsql.add_text(' AND adm_cal_type = ');
1972: fnd_dsql.add_bind(l_adm_cal_type);

Line 1969: fnd_dsql.add_text(' AND acad_ci_sequence_number = ');

1965: fnd_dsql.add_text(' 1=1 ' );
1966: ELSE
1967: fnd_dsql.add_text(' acad_cal_type = ');
1968: fnd_dsql.add_bind(l_acad_cal_type);
1969: fnd_dsql.add_text(' AND acad_ci_sequence_number = ');
1970: fnd_dsql.add_bind(l_acad_ci_sequence_number);
1971: fnd_dsql.add_text(' AND adm_cal_type = ');
1972: fnd_dsql.add_bind(l_adm_cal_type);
1973: fnd_dsql.add_text(' AND adm_ci_sequence_number = ');

Line 1970: fnd_dsql.add_bind(l_acad_ci_sequence_number);

1966: ELSE
1967: fnd_dsql.add_text(' acad_cal_type = ');
1968: fnd_dsql.add_bind(l_acad_cal_type);
1969: fnd_dsql.add_text(' AND acad_ci_sequence_number = ');
1970: fnd_dsql.add_bind(l_acad_ci_sequence_number);
1971: fnd_dsql.add_text(' AND adm_cal_type = ');
1972: fnd_dsql.add_bind(l_adm_cal_type);
1973: fnd_dsql.add_text(' AND adm_ci_sequence_number = ');
1974: fnd_dsql.add_bind(l_adm_ci_sequence_number);

Line 1971: fnd_dsql.add_text(' AND adm_cal_type = ');

1967: fnd_dsql.add_text(' acad_cal_type = ');
1968: fnd_dsql.add_bind(l_acad_cal_type);
1969: fnd_dsql.add_text(' AND acad_ci_sequence_number = ');
1970: fnd_dsql.add_bind(l_acad_ci_sequence_number);
1971: fnd_dsql.add_text(' AND adm_cal_type = ');
1972: fnd_dsql.add_bind(l_adm_cal_type);
1973: fnd_dsql.add_text(' AND adm_ci_sequence_number = ');
1974: fnd_dsql.add_bind(l_adm_ci_sequence_number);
1975: fnd_dsql.add_text(' AND adm_process_cat = ');

Line 1972: fnd_dsql.add_bind(l_adm_cal_type);

1968: fnd_dsql.add_bind(l_acad_cal_type);
1969: fnd_dsql.add_text(' AND acad_ci_sequence_number = ');
1970: fnd_dsql.add_bind(l_acad_ci_sequence_number);
1971: fnd_dsql.add_text(' AND adm_cal_type = ');
1972: fnd_dsql.add_bind(l_adm_cal_type);
1973: fnd_dsql.add_text(' AND adm_ci_sequence_number = ');
1974: fnd_dsql.add_bind(l_adm_ci_sequence_number);
1975: fnd_dsql.add_text(' AND adm_process_cat = ');
1976: fnd_dsql.add_bind(p_parameter_4);

Line 1973: fnd_dsql.add_text(' AND adm_ci_sequence_number = ');

1969: fnd_dsql.add_text(' AND acad_ci_sequence_number = ');
1970: fnd_dsql.add_bind(l_acad_ci_sequence_number);
1971: fnd_dsql.add_text(' AND adm_cal_type = ');
1972: fnd_dsql.add_bind(l_adm_cal_type);
1973: fnd_dsql.add_text(' AND adm_ci_sequence_number = ');
1974: fnd_dsql.add_bind(l_adm_ci_sequence_number);
1975: fnd_dsql.add_text(' AND adm_process_cat = ');
1976: fnd_dsql.add_bind(p_parameter_4);
1977: fnd_dsql.add_text(' AND TRUNC(appl_dt) >= TRUNC(igs_ge_date.igsdate(');

Line 1974: fnd_dsql.add_bind(l_adm_ci_sequence_number);

1970: fnd_dsql.add_bind(l_acad_ci_sequence_number);
1971: fnd_dsql.add_text(' AND adm_cal_type = ');
1972: fnd_dsql.add_bind(l_adm_cal_type);
1973: fnd_dsql.add_text(' AND adm_ci_sequence_number = ');
1974: fnd_dsql.add_bind(l_adm_ci_sequence_number);
1975: fnd_dsql.add_text(' AND adm_process_cat = ');
1976: fnd_dsql.add_bind(p_parameter_4);
1977: fnd_dsql.add_text(' AND TRUNC(appl_dt) >= TRUNC(igs_ge_date.igsdate(');
1978: fnd_dsql.add_bind(p_parameter_5);

Line 1975: fnd_dsql.add_text(' AND adm_process_cat = ');

1971: fnd_dsql.add_text(' AND adm_cal_type = ');
1972: fnd_dsql.add_bind(l_adm_cal_type);
1973: fnd_dsql.add_text(' AND adm_ci_sequence_number = ');
1974: fnd_dsql.add_bind(l_adm_ci_sequence_number);
1975: fnd_dsql.add_text(' AND adm_process_cat = ');
1976: fnd_dsql.add_bind(p_parameter_4);
1977: fnd_dsql.add_text(' AND TRUNC(appl_dt) >= TRUNC(igs_ge_date.igsdate(');
1978: fnd_dsql.add_bind(p_parameter_5);
1979: fnd_dsql.add_text(')) AND TRUNC(appl_dt) <= TRUNC(igs_ge_date.igsdate(');

Line 1976: fnd_dsql.add_bind(p_parameter_4);

1972: fnd_dsql.add_bind(l_adm_cal_type);
1973: fnd_dsql.add_text(' AND adm_ci_sequence_number = ');
1974: fnd_dsql.add_bind(l_adm_ci_sequence_number);
1975: fnd_dsql.add_text(' AND adm_process_cat = ');
1976: fnd_dsql.add_bind(p_parameter_4);
1977: fnd_dsql.add_text(' AND TRUNC(appl_dt) >= TRUNC(igs_ge_date.igsdate(');
1978: fnd_dsql.add_bind(p_parameter_5);
1979: fnd_dsql.add_text(')) AND TRUNC(appl_dt) <= TRUNC(igs_ge_date.igsdate(');
1980: fnd_dsql.add_bind(p_parameter_6);

Line 1977: fnd_dsql.add_text(' AND TRUNC(appl_dt) >= TRUNC(igs_ge_date.igsdate(');

1973: fnd_dsql.add_text(' AND adm_ci_sequence_number = ');
1974: fnd_dsql.add_bind(l_adm_ci_sequence_number);
1975: fnd_dsql.add_text(' AND adm_process_cat = ');
1976: fnd_dsql.add_bind(p_parameter_4);
1977: fnd_dsql.add_text(' AND TRUNC(appl_dt) >= TRUNC(igs_ge_date.igsdate(');
1978: fnd_dsql.add_bind(p_parameter_5);
1979: fnd_dsql.add_text(')) AND TRUNC(appl_dt) <= TRUNC(igs_ge_date.igsdate(');
1980: fnd_dsql.add_bind(p_parameter_6);
1981: fnd_dsql.add_text('))');

Line 1978: fnd_dsql.add_bind(p_parameter_5);

1974: fnd_dsql.add_bind(l_adm_ci_sequence_number);
1975: fnd_dsql.add_text(' AND adm_process_cat = ');
1976: fnd_dsql.add_bind(p_parameter_4);
1977: fnd_dsql.add_text(' AND TRUNC(appl_dt) >= TRUNC(igs_ge_date.igsdate(');
1978: fnd_dsql.add_bind(p_parameter_5);
1979: fnd_dsql.add_text(')) AND TRUNC(appl_dt) <= TRUNC(igs_ge_date.igsdate(');
1980: fnd_dsql.add_bind(p_parameter_6);
1981: fnd_dsql.add_text('))');
1982: END IF;

Line 1979: fnd_dsql.add_text(')) AND TRUNC(appl_dt) <= TRUNC(igs_ge_date.igsdate(');

1975: fnd_dsql.add_text(' AND adm_process_cat = ');
1976: fnd_dsql.add_bind(p_parameter_4);
1977: fnd_dsql.add_text(' AND TRUNC(appl_dt) >= TRUNC(igs_ge_date.igsdate(');
1978: fnd_dsql.add_bind(p_parameter_5);
1979: fnd_dsql.add_text(')) AND TRUNC(appl_dt) <= TRUNC(igs_ge_date.igsdate(');
1980: fnd_dsql.add_bind(p_parameter_6);
1981: fnd_dsql.add_text('))');
1982: END IF;
1983: ELSIF P_SYS_LTR_CODE = 'ADRESID' THEN

Line 1980: fnd_dsql.add_bind(p_parameter_6);

1976: fnd_dsql.add_bind(p_parameter_4);
1977: fnd_dsql.add_text(' AND TRUNC(appl_dt) >= TRUNC(igs_ge_date.igsdate(');
1978: fnd_dsql.add_bind(p_parameter_5);
1979: fnd_dsql.add_text(')) AND TRUNC(appl_dt) <= TRUNC(igs_ge_date.igsdate(');
1980: fnd_dsql.add_bind(p_parameter_6);
1981: fnd_dsql.add_text('))');
1982: END IF;
1983: ELSIF P_SYS_LTR_CODE = 'ADRESID' THEN
1984: IF p_parameter_1 IS NOT NULL THEN

Line 1981: fnd_dsql.add_text('))');

1977: fnd_dsql.add_text(' AND TRUNC(appl_dt) >= TRUNC(igs_ge_date.igsdate(');
1978: fnd_dsql.add_bind(p_parameter_5);
1979: fnd_dsql.add_text(')) AND TRUNC(appl_dt) <= TRUNC(igs_ge_date.igsdate(');
1980: fnd_dsql.add_bind(p_parameter_6);
1981: fnd_dsql.add_text('))');
1982: END IF;
1983: ELSIF P_SYS_LTR_CODE = 'ADRESID' THEN
1984: IF p_parameter_1 IS NOT NULL THEN
1985: fnd_dsql.add_text(' 1=1 ' );

Line 1985: fnd_dsql.add_text(' 1=1 ' );

1981: fnd_dsql.add_text('))');
1982: END IF;
1983: ELSIF P_SYS_LTR_CODE = 'ADRESID' THEN
1984: IF p_parameter_1 IS NOT NULL THEN
1985: fnd_dsql.add_text(' 1=1 ' );
1986: ELSE
1987: fnd_dsql.add_text(' residency_status_cd = ');
1988: fnd_dsql.add_bind(p_parameter_2);
1989: fnd_dsql.add_text(' AND residency_class_cd = ');

Line 1987: fnd_dsql.add_text(' residency_status_cd = ');

1983: ELSIF P_SYS_LTR_CODE = 'ADRESID' THEN
1984: IF p_parameter_1 IS NOT NULL THEN
1985: fnd_dsql.add_text(' 1=1 ' );
1986: ELSE
1987: fnd_dsql.add_text(' residency_status_cd = ');
1988: fnd_dsql.add_bind(p_parameter_2);
1989: fnd_dsql.add_text(' AND residency_class_cd = ');
1990: fnd_dsql.add_bind(p_parameter_3);
1991: fnd_dsql.add_text(' AND TRUNC(evaluation_date) >= TRUNC(igs_ge_date.igsdate( ');

Line 1988: fnd_dsql.add_bind(p_parameter_2);

1984: IF p_parameter_1 IS NOT NULL THEN
1985: fnd_dsql.add_text(' 1=1 ' );
1986: ELSE
1987: fnd_dsql.add_text(' residency_status_cd = ');
1988: fnd_dsql.add_bind(p_parameter_2);
1989: fnd_dsql.add_text(' AND residency_class_cd = ');
1990: fnd_dsql.add_bind(p_parameter_3);
1991: fnd_dsql.add_text(' AND TRUNC(evaluation_date) >= TRUNC(igs_ge_date.igsdate( ');
1992: fnd_dsql.add_bind(p_parameter_4);

Line 1989: fnd_dsql.add_text(' AND residency_class_cd = ');

1985: fnd_dsql.add_text(' 1=1 ' );
1986: ELSE
1987: fnd_dsql.add_text(' residency_status_cd = ');
1988: fnd_dsql.add_bind(p_parameter_2);
1989: fnd_dsql.add_text(' AND residency_class_cd = ');
1990: fnd_dsql.add_bind(p_parameter_3);
1991: fnd_dsql.add_text(' AND TRUNC(evaluation_date) >= TRUNC(igs_ge_date.igsdate( ');
1992: fnd_dsql.add_bind(p_parameter_4);
1993: fnd_dsql.add_text(')) AND TRUNC(evaluation_date) <= TRUNC(igs_ge_date.igsdate( ');

Line 1990: fnd_dsql.add_bind(p_parameter_3);

1986: ELSE
1987: fnd_dsql.add_text(' residency_status_cd = ');
1988: fnd_dsql.add_bind(p_parameter_2);
1989: fnd_dsql.add_text(' AND residency_class_cd = ');
1990: fnd_dsql.add_bind(p_parameter_3);
1991: fnd_dsql.add_text(' AND TRUNC(evaluation_date) >= TRUNC(igs_ge_date.igsdate( ');
1992: fnd_dsql.add_bind(p_parameter_4);
1993: fnd_dsql.add_text(')) AND TRUNC(evaluation_date) <= TRUNC(igs_ge_date.igsdate( ');
1994: fnd_dsql.add_bind(p_parameter_5);

Line 1991: fnd_dsql.add_text(' AND TRUNC(evaluation_date) >= TRUNC(igs_ge_date.igsdate( ');

1987: fnd_dsql.add_text(' residency_status_cd = ');
1988: fnd_dsql.add_bind(p_parameter_2);
1989: fnd_dsql.add_text(' AND residency_class_cd = ');
1990: fnd_dsql.add_bind(p_parameter_3);
1991: fnd_dsql.add_text(' AND TRUNC(evaluation_date) >= TRUNC(igs_ge_date.igsdate( ');
1992: fnd_dsql.add_bind(p_parameter_4);
1993: fnd_dsql.add_text(')) AND TRUNC(evaluation_date) <= TRUNC(igs_ge_date.igsdate( ');
1994: fnd_dsql.add_bind(p_parameter_5);
1995: fnd_dsql.add_text('))');

Line 1992: fnd_dsql.add_bind(p_parameter_4);

1988: fnd_dsql.add_bind(p_parameter_2);
1989: fnd_dsql.add_text(' AND residency_class_cd = ');
1990: fnd_dsql.add_bind(p_parameter_3);
1991: fnd_dsql.add_text(' AND TRUNC(evaluation_date) >= TRUNC(igs_ge_date.igsdate( ');
1992: fnd_dsql.add_bind(p_parameter_4);
1993: fnd_dsql.add_text(')) AND TRUNC(evaluation_date) <= TRUNC(igs_ge_date.igsdate( ');
1994: fnd_dsql.add_bind(p_parameter_5);
1995: fnd_dsql.add_text('))');
1996: END IF;

Line 1993: fnd_dsql.add_text(')) AND TRUNC(evaluation_date) <= TRUNC(igs_ge_date.igsdate( ');

1989: fnd_dsql.add_text(' AND residency_class_cd = ');
1990: fnd_dsql.add_bind(p_parameter_3);
1991: fnd_dsql.add_text(' AND TRUNC(evaluation_date) >= TRUNC(igs_ge_date.igsdate( ');
1992: fnd_dsql.add_bind(p_parameter_4);
1993: fnd_dsql.add_text(')) AND TRUNC(evaluation_date) <= TRUNC(igs_ge_date.igsdate( ');
1994: fnd_dsql.add_bind(p_parameter_5);
1995: fnd_dsql.add_text('))');
1996: END IF;
1997: ELSIF P_SYS_LTR_CODE = 'ADACCEP' THEN

Line 1994: fnd_dsql.add_bind(p_parameter_5);

1990: fnd_dsql.add_bind(p_parameter_3);
1991: fnd_dsql.add_text(' AND TRUNC(evaluation_date) >= TRUNC(igs_ge_date.igsdate( ');
1992: fnd_dsql.add_bind(p_parameter_4);
1993: fnd_dsql.add_text(')) AND TRUNC(evaluation_date) <= TRUNC(igs_ge_date.igsdate( ');
1994: fnd_dsql.add_bind(p_parameter_5);
1995: fnd_dsql.add_text('))');
1996: END IF;
1997: ELSIF P_SYS_LTR_CODE = 'ADACCEP' THEN
1998: IF p_parameter_1 IS NOT NULL THEN

Line 1995: fnd_dsql.add_text('))');

1991: fnd_dsql.add_text(' AND TRUNC(evaluation_date) >= TRUNC(igs_ge_date.igsdate( ');
1992: fnd_dsql.add_bind(p_parameter_4);
1993: fnd_dsql.add_text(')) AND TRUNC(evaluation_date) <= TRUNC(igs_ge_date.igsdate( ');
1994: fnd_dsql.add_bind(p_parameter_5);
1995: fnd_dsql.add_text('))');
1996: END IF;
1997: ELSIF P_SYS_LTR_CODE = 'ADACCEP' THEN
1998: IF p_parameter_1 IS NOT NULL THEN
1999: fnd_dsql.add_text(' 1=1 ' );

Line 1999: fnd_dsql.add_text(' 1=1 ' );

1995: fnd_dsql.add_text('))');
1996: END IF;
1997: ELSIF P_SYS_LTR_CODE = 'ADACCEP' THEN
1998: IF p_parameter_1 IS NOT NULL THEN
1999: fnd_dsql.add_text(' 1=1 ' );
2000: ELSE
2001: fnd_dsql.add_text(' acad_cal_type = ');
2002: fnd_dsql.add_bind(l_acad_cal_type);
2003: fnd_dsql.add_text(' AND acad_ci_sequence_number = ');

Line 2001: fnd_dsql.add_text(' acad_cal_type = ');

1997: ELSIF P_SYS_LTR_CODE = 'ADACCEP' THEN
1998: IF p_parameter_1 IS NOT NULL THEN
1999: fnd_dsql.add_text(' 1=1 ' );
2000: ELSE
2001: fnd_dsql.add_text(' acad_cal_type = ');
2002: fnd_dsql.add_bind(l_acad_cal_type);
2003: fnd_dsql.add_text(' AND acad_ci_sequence_number = ');
2004: fnd_dsql.add_bind(l_acad_ci_sequence_number);
2005: fnd_dsql.add_text(' AND adm_cal_type = ');

Line 2002: fnd_dsql.add_bind(l_acad_cal_type);

1998: IF p_parameter_1 IS NOT NULL THEN
1999: fnd_dsql.add_text(' 1=1 ' );
2000: ELSE
2001: fnd_dsql.add_text(' acad_cal_type = ');
2002: fnd_dsql.add_bind(l_acad_cal_type);
2003: fnd_dsql.add_text(' AND acad_ci_sequence_number = ');
2004: fnd_dsql.add_bind(l_acad_ci_sequence_number);
2005: fnd_dsql.add_text(' AND adm_cal_type = ');
2006: fnd_dsql.add_bind(l_adm_cal_type);

Line 2003: fnd_dsql.add_text(' AND acad_ci_sequence_number = ');

1999: fnd_dsql.add_text(' 1=1 ' );
2000: ELSE
2001: fnd_dsql.add_text(' acad_cal_type = ');
2002: fnd_dsql.add_bind(l_acad_cal_type);
2003: fnd_dsql.add_text(' AND acad_ci_sequence_number = ');
2004: fnd_dsql.add_bind(l_acad_ci_sequence_number);
2005: fnd_dsql.add_text(' AND adm_cal_type = ');
2006: fnd_dsql.add_bind(l_adm_cal_type);
2007: fnd_dsql.add_text(' AND adm_ci_sequence_number = ');

Line 2004: fnd_dsql.add_bind(l_acad_ci_sequence_number);

2000: ELSE
2001: fnd_dsql.add_text(' acad_cal_type = ');
2002: fnd_dsql.add_bind(l_acad_cal_type);
2003: fnd_dsql.add_text(' AND acad_ci_sequence_number = ');
2004: fnd_dsql.add_bind(l_acad_ci_sequence_number);
2005: fnd_dsql.add_text(' AND adm_cal_type = ');
2006: fnd_dsql.add_bind(l_adm_cal_type);
2007: fnd_dsql.add_text(' AND adm_ci_sequence_number = ');
2008: fnd_dsql.add_bind(l_adm_ci_sequence_number);

Line 2005: fnd_dsql.add_text(' AND adm_cal_type = ');

2001: fnd_dsql.add_text(' acad_cal_type = ');
2002: fnd_dsql.add_bind(l_acad_cal_type);
2003: fnd_dsql.add_text(' AND acad_ci_sequence_number = ');
2004: fnd_dsql.add_bind(l_acad_ci_sequence_number);
2005: fnd_dsql.add_text(' AND adm_cal_type = ');
2006: fnd_dsql.add_bind(l_adm_cal_type);
2007: fnd_dsql.add_text(' AND adm_ci_sequence_number = ');
2008: fnd_dsql.add_bind(l_adm_ci_sequence_number);
2009: fnd_dsql.add_text(' AND admission_process_category = ');

Line 2006: fnd_dsql.add_bind(l_adm_cal_type);

2002: fnd_dsql.add_bind(l_acad_cal_type);
2003: fnd_dsql.add_text(' AND acad_ci_sequence_number = ');
2004: fnd_dsql.add_bind(l_acad_ci_sequence_number);
2005: fnd_dsql.add_text(' AND adm_cal_type = ');
2006: fnd_dsql.add_bind(l_adm_cal_type);
2007: fnd_dsql.add_text(' AND adm_ci_sequence_number = ');
2008: fnd_dsql.add_bind(l_adm_ci_sequence_number);
2009: fnd_dsql.add_text(' AND admission_process_category = ');
2010: fnd_dsql.add_bind(p_parameter_4);

Line 2007: fnd_dsql.add_text(' AND adm_ci_sequence_number = ');

2003: fnd_dsql.add_text(' AND acad_ci_sequence_number = ');
2004: fnd_dsql.add_bind(l_acad_ci_sequence_number);
2005: fnd_dsql.add_text(' AND adm_cal_type = ');
2006: fnd_dsql.add_bind(l_adm_cal_type);
2007: fnd_dsql.add_text(' AND adm_ci_sequence_number = ');
2008: fnd_dsql.add_bind(l_adm_ci_sequence_number);
2009: fnd_dsql.add_text(' AND admission_process_category = ');
2010: fnd_dsql.add_bind(p_parameter_4);
2011: fnd_dsql.add_text(' AND TRUNC(appl_dt) >= TRUNC(igs_ge_date.igsdate(');

Line 2008: fnd_dsql.add_bind(l_adm_ci_sequence_number);

2004: fnd_dsql.add_bind(l_acad_ci_sequence_number);
2005: fnd_dsql.add_text(' AND adm_cal_type = ');
2006: fnd_dsql.add_bind(l_adm_cal_type);
2007: fnd_dsql.add_text(' AND adm_ci_sequence_number = ');
2008: fnd_dsql.add_bind(l_adm_ci_sequence_number);
2009: fnd_dsql.add_text(' AND admission_process_category = ');
2010: fnd_dsql.add_bind(p_parameter_4);
2011: fnd_dsql.add_text(' AND TRUNC(appl_dt) >= TRUNC(igs_ge_date.igsdate(');
2012: fnd_dsql.add_bind(p_parameter_5);

Line 2009: fnd_dsql.add_text(' AND admission_process_category = ');

2005: fnd_dsql.add_text(' AND adm_cal_type = ');
2006: fnd_dsql.add_bind(l_adm_cal_type);
2007: fnd_dsql.add_text(' AND adm_ci_sequence_number = ');
2008: fnd_dsql.add_bind(l_adm_ci_sequence_number);
2009: fnd_dsql.add_text(' AND admission_process_category = ');
2010: fnd_dsql.add_bind(p_parameter_4);
2011: fnd_dsql.add_text(' AND TRUNC(appl_dt) >= TRUNC(igs_ge_date.igsdate(');
2012: fnd_dsql.add_bind(p_parameter_5);
2013: fnd_dsql.add_text(' )) AND TRUNC(appl_dt) <= TRUNC(igs_ge_date.igsdate(');

Line 2010: fnd_dsql.add_bind(p_parameter_4);

2006: fnd_dsql.add_bind(l_adm_cal_type);
2007: fnd_dsql.add_text(' AND adm_ci_sequence_number = ');
2008: fnd_dsql.add_bind(l_adm_ci_sequence_number);
2009: fnd_dsql.add_text(' AND admission_process_category = ');
2010: fnd_dsql.add_bind(p_parameter_4);
2011: fnd_dsql.add_text(' AND TRUNC(appl_dt) >= TRUNC(igs_ge_date.igsdate(');
2012: fnd_dsql.add_bind(p_parameter_5);
2013: fnd_dsql.add_text(' )) AND TRUNC(appl_dt) <= TRUNC(igs_ge_date.igsdate(');
2014: fnd_dsql.add_bind(p_parameter_6);

Line 2011: fnd_dsql.add_text(' AND TRUNC(appl_dt) >= TRUNC(igs_ge_date.igsdate(');

2007: fnd_dsql.add_text(' AND adm_ci_sequence_number = ');
2008: fnd_dsql.add_bind(l_adm_ci_sequence_number);
2009: fnd_dsql.add_text(' AND admission_process_category = ');
2010: fnd_dsql.add_bind(p_parameter_4);
2011: fnd_dsql.add_text(' AND TRUNC(appl_dt) >= TRUNC(igs_ge_date.igsdate(');
2012: fnd_dsql.add_bind(p_parameter_5);
2013: fnd_dsql.add_text(' )) AND TRUNC(appl_dt) <= TRUNC(igs_ge_date.igsdate(');
2014: fnd_dsql.add_bind(p_parameter_6);
2015: fnd_dsql.add_text(' )) AND admission_outcome_status = ');

Line 2012: fnd_dsql.add_bind(p_parameter_5);

2008: fnd_dsql.add_bind(l_adm_ci_sequence_number);
2009: fnd_dsql.add_text(' AND admission_process_category = ');
2010: fnd_dsql.add_bind(p_parameter_4);
2011: fnd_dsql.add_text(' AND TRUNC(appl_dt) >= TRUNC(igs_ge_date.igsdate(');
2012: fnd_dsql.add_bind(p_parameter_5);
2013: fnd_dsql.add_text(' )) AND TRUNC(appl_dt) <= TRUNC(igs_ge_date.igsdate(');
2014: fnd_dsql.add_bind(p_parameter_6);
2015: fnd_dsql.add_text(' )) AND admission_outcome_status = ');
2016: fnd_dsql.add_bind(p_parameter_7);

Line 2013: fnd_dsql.add_text(' )) AND TRUNC(appl_dt) <= TRUNC(igs_ge_date.igsdate(');

2009: fnd_dsql.add_text(' AND admission_process_category = ');
2010: fnd_dsql.add_bind(p_parameter_4);
2011: fnd_dsql.add_text(' AND TRUNC(appl_dt) >= TRUNC(igs_ge_date.igsdate(');
2012: fnd_dsql.add_bind(p_parameter_5);
2013: fnd_dsql.add_text(' )) AND TRUNC(appl_dt) <= TRUNC(igs_ge_date.igsdate(');
2014: fnd_dsql.add_bind(p_parameter_6);
2015: fnd_dsql.add_text(' )) AND admission_outcome_status = ');
2016: fnd_dsql.add_bind(p_parameter_7);
2017: END IF;

Line 2014: fnd_dsql.add_bind(p_parameter_6);

2010: fnd_dsql.add_bind(p_parameter_4);
2011: fnd_dsql.add_text(' AND TRUNC(appl_dt) >= TRUNC(igs_ge_date.igsdate(');
2012: fnd_dsql.add_bind(p_parameter_5);
2013: fnd_dsql.add_text(' )) AND TRUNC(appl_dt) <= TRUNC(igs_ge_date.igsdate(');
2014: fnd_dsql.add_bind(p_parameter_6);
2015: fnd_dsql.add_text(' )) AND admission_outcome_status = ');
2016: fnd_dsql.add_bind(p_parameter_7);
2017: END IF;
2018:

Line 2015: fnd_dsql.add_text(' )) AND admission_outcome_status = ');

2011: fnd_dsql.add_text(' AND TRUNC(appl_dt) >= TRUNC(igs_ge_date.igsdate(');
2012: fnd_dsql.add_bind(p_parameter_5);
2013: fnd_dsql.add_text(' )) AND TRUNC(appl_dt) <= TRUNC(igs_ge_date.igsdate(');
2014: fnd_dsql.add_bind(p_parameter_6);
2015: fnd_dsql.add_text(' )) AND admission_outcome_status = ');
2016: fnd_dsql.add_bind(p_parameter_7);
2017: END IF;
2018:
2019: ELSIF P_SYS_LTR_CODE = 'ADREJEC' THEN

Line 2016: fnd_dsql.add_bind(p_parameter_7);

2012: fnd_dsql.add_bind(p_parameter_5);
2013: fnd_dsql.add_text(' )) AND TRUNC(appl_dt) <= TRUNC(igs_ge_date.igsdate(');
2014: fnd_dsql.add_bind(p_parameter_6);
2015: fnd_dsql.add_text(' )) AND admission_outcome_status = ');
2016: fnd_dsql.add_bind(p_parameter_7);
2017: END IF;
2018:
2019: ELSIF P_SYS_LTR_CODE = 'ADREJEC' THEN
2020: IF p_parameter_1 IS NOT NULL THEN

Line 2021: fnd_dsql.add_text(' 1=1 ' );

2017: END IF;
2018:
2019: ELSIF P_SYS_LTR_CODE = 'ADREJEC' THEN
2020: IF p_parameter_1 IS NOT NULL THEN
2021: fnd_dsql.add_text(' 1=1 ' );
2022: ELSE
2023: fnd_dsql.add_text(' acad_cal_type = ');
2024: fnd_dsql.add_bind(l_acad_cal_type);
2025: fnd_dsql.add_text(' AND acad_ci_sequence_number = ');

Line 2023: fnd_dsql.add_text(' acad_cal_type = ');

2019: ELSIF P_SYS_LTR_CODE = 'ADREJEC' THEN
2020: IF p_parameter_1 IS NOT NULL THEN
2021: fnd_dsql.add_text(' 1=1 ' );
2022: ELSE
2023: fnd_dsql.add_text(' acad_cal_type = ');
2024: fnd_dsql.add_bind(l_acad_cal_type);
2025: fnd_dsql.add_text(' AND acad_ci_sequence_number = ');
2026: fnd_dsql.add_bind(l_acad_ci_sequence_number);
2027: fnd_dsql.add_text(' AND adm_cal_type = ');

Line 2024: fnd_dsql.add_bind(l_acad_cal_type);

2020: IF p_parameter_1 IS NOT NULL THEN
2021: fnd_dsql.add_text(' 1=1 ' );
2022: ELSE
2023: fnd_dsql.add_text(' acad_cal_type = ');
2024: fnd_dsql.add_bind(l_acad_cal_type);
2025: fnd_dsql.add_text(' AND acad_ci_sequence_number = ');
2026: fnd_dsql.add_bind(l_acad_ci_sequence_number);
2027: fnd_dsql.add_text(' AND adm_cal_type = ');
2028: fnd_dsql.add_bind(l_adm_cal_type);

Line 2025: fnd_dsql.add_text(' AND acad_ci_sequence_number = ');

2021: fnd_dsql.add_text(' 1=1 ' );
2022: ELSE
2023: fnd_dsql.add_text(' acad_cal_type = ');
2024: fnd_dsql.add_bind(l_acad_cal_type);
2025: fnd_dsql.add_text(' AND acad_ci_sequence_number = ');
2026: fnd_dsql.add_bind(l_acad_ci_sequence_number);
2027: fnd_dsql.add_text(' AND adm_cal_type = ');
2028: fnd_dsql.add_bind(l_adm_cal_type);
2029: fnd_dsql.add_text(' AND adm_ci_sequence_number = ');

Line 2026: fnd_dsql.add_bind(l_acad_ci_sequence_number);

2022: ELSE
2023: fnd_dsql.add_text(' acad_cal_type = ');
2024: fnd_dsql.add_bind(l_acad_cal_type);
2025: fnd_dsql.add_text(' AND acad_ci_sequence_number = ');
2026: fnd_dsql.add_bind(l_acad_ci_sequence_number);
2027: fnd_dsql.add_text(' AND adm_cal_type = ');
2028: fnd_dsql.add_bind(l_adm_cal_type);
2029: fnd_dsql.add_text(' AND adm_ci_sequence_number = ');
2030: fnd_dsql.add_bind(l_adm_ci_sequence_number);

Line 2027: fnd_dsql.add_text(' AND adm_cal_type = ');

2023: fnd_dsql.add_text(' acad_cal_type = ');
2024: fnd_dsql.add_bind(l_acad_cal_type);
2025: fnd_dsql.add_text(' AND acad_ci_sequence_number = ');
2026: fnd_dsql.add_bind(l_acad_ci_sequence_number);
2027: fnd_dsql.add_text(' AND adm_cal_type = ');
2028: fnd_dsql.add_bind(l_adm_cal_type);
2029: fnd_dsql.add_text(' AND adm_ci_sequence_number = ');
2030: fnd_dsql.add_bind(l_adm_ci_sequence_number);
2031: fnd_dsql.add_text(' AND admission_process_category = ');

Line 2028: fnd_dsql.add_bind(l_adm_cal_type);

2024: fnd_dsql.add_bind(l_acad_cal_type);
2025: fnd_dsql.add_text(' AND acad_ci_sequence_number = ');
2026: fnd_dsql.add_bind(l_acad_ci_sequence_number);
2027: fnd_dsql.add_text(' AND adm_cal_type = ');
2028: fnd_dsql.add_bind(l_adm_cal_type);
2029: fnd_dsql.add_text(' AND adm_ci_sequence_number = ');
2030: fnd_dsql.add_bind(l_adm_ci_sequence_number);
2031: fnd_dsql.add_text(' AND admission_process_category = ');
2032: fnd_dsql.add_bind(p_parameter_4);

Line 2029: fnd_dsql.add_text(' AND adm_ci_sequence_number = ');

2025: fnd_dsql.add_text(' AND acad_ci_sequence_number = ');
2026: fnd_dsql.add_bind(l_acad_ci_sequence_number);
2027: fnd_dsql.add_text(' AND adm_cal_type = ');
2028: fnd_dsql.add_bind(l_adm_cal_type);
2029: fnd_dsql.add_text(' AND adm_ci_sequence_number = ');
2030: fnd_dsql.add_bind(l_adm_ci_sequence_number);
2031: fnd_dsql.add_text(' AND admission_process_category = ');
2032: fnd_dsql.add_bind(p_parameter_4);
2033: fnd_dsql.add_text(' AND TRUNC(appl_dt) >= TRUNC(igs_ge_date.igsdate( ');

Line 2030: fnd_dsql.add_bind(l_adm_ci_sequence_number);

2026: fnd_dsql.add_bind(l_acad_ci_sequence_number);
2027: fnd_dsql.add_text(' AND adm_cal_type = ');
2028: fnd_dsql.add_bind(l_adm_cal_type);
2029: fnd_dsql.add_text(' AND adm_ci_sequence_number = ');
2030: fnd_dsql.add_bind(l_adm_ci_sequence_number);
2031: fnd_dsql.add_text(' AND admission_process_category = ');
2032: fnd_dsql.add_bind(p_parameter_4);
2033: fnd_dsql.add_text(' AND TRUNC(appl_dt) >= TRUNC(igs_ge_date.igsdate( ');
2034: fnd_dsql.add_bind(p_parameter_5);

Line 2031: fnd_dsql.add_text(' AND admission_process_category = ');

2027: fnd_dsql.add_text(' AND adm_cal_type = ');
2028: fnd_dsql.add_bind(l_adm_cal_type);
2029: fnd_dsql.add_text(' AND adm_ci_sequence_number = ');
2030: fnd_dsql.add_bind(l_adm_ci_sequence_number);
2031: fnd_dsql.add_text(' AND admission_process_category = ');
2032: fnd_dsql.add_bind(p_parameter_4);
2033: fnd_dsql.add_text(' AND TRUNC(appl_dt) >= TRUNC(igs_ge_date.igsdate( ');
2034: fnd_dsql.add_bind(p_parameter_5);
2035: fnd_dsql.add_text(')) AND TRUNC(appl_dt) <= TRUNC(igs_ge_date.igsdate( ');

Line 2032: fnd_dsql.add_bind(p_parameter_4);

2028: fnd_dsql.add_bind(l_adm_cal_type);
2029: fnd_dsql.add_text(' AND adm_ci_sequence_number = ');
2030: fnd_dsql.add_bind(l_adm_ci_sequence_number);
2031: fnd_dsql.add_text(' AND admission_process_category = ');
2032: fnd_dsql.add_bind(p_parameter_4);
2033: fnd_dsql.add_text(' AND TRUNC(appl_dt) >= TRUNC(igs_ge_date.igsdate( ');
2034: fnd_dsql.add_bind(p_parameter_5);
2035: fnd_dsql.add_text(')) AND TRUNC(appl_dt) <= TRUNC(igs_ge_date.igsdate( ');
2036: fnd_dsql.add_bind(p_parameter_6);

Line 2033: fnd_dsql.add_text(' AND TRUNC(appl_dt) >= TRUNC(igs_ge_date.igsdate( ');

2029: fnd_dsql.add_text(' AND adm_ci_sequence_number = ');
2030: fnd_dsql.add_bind(l_adm_ci_sequence_number);
2031: fnd_dsql.add_text(' AND admission_process_category = ');
2032: fnd_dsql.add_bind(p_parameter_4);
2033: fnd_dsql.add_text(' AND TRUNC(appl_dt) >= TRUNC(igs_ge_date.igsdate( ');
2034: fnd_dsql.add_bind(p_parameter_5);
2035: fnd_dsql.add_text(')) AND TRUNC(appl_dt) <= TRUNC(igs_ge_date.igsdate( ');
2036: fnd_dsql.add_bind(p_parameter_6);
2037: fnd_dsql.add_text(')) AND admission_outcome_status = ');

Line 2034: fnd_dsql.add_bind(p_parameter_5);

2030: fnd_dsql.add_bind(l_adm_ci_sequence_number);
2031: fnd_dsql.add_text(' AND admission_process_category = ');
2032: fnd_dsql.add_bind(p_parameter_4);
2033: fnd_dsql.add_text(' AND TRUNC(appl_dt) >= TRUNC(igs_ge_date.igsdate( ');
2034: fnd_dsql.add_bind(p_parameter_5);
2035: fnd_dsql.add_text(')) AND TRUNC(appl_dt) <= TRUNC(igs_ge_date.igsdate( ');
2036: fnd_dsql.add_bind(p_parameter_6);
2037: fnd_dsql.add_text(')) AND admission_outcome_status = ');
2038: fnd_dsql.add_bind(p_parameter_7);

Line 2035: fnd_dsql.add_text(')) AND TRUNC(appl_dt) <= TRUNC(igs_ge_date.igsdate( ');

2031: fnd_dsql.add_text(' AND admission_process_category = ');
2032: fnd_dsql.add_bind(p_parameter_4);
2033: fnd_dsql.add_text(' AND TRUNC(appl_dt) >= TRUNC(igs_ge_date.igsdate( ');
2034: fnd_dsql.add_bind(p_parameter_5);
2035: fnd_dsql.add_text(')) AND TRUNC(appl_dt) <= TRUNC(igs_ge_date.igsdate( ');
2036: fnd_dsql.add_bind(p_parameter_6);
2037: fnd_dsql.add_text(')) AND admission_outcome_status = ');
2038: fnd_dsql.add_bind(p_parameter_7);
2039: END IF;

Line 2036: fnd_dsql.add_bind(p_parameter_6);

2032: fnd_dsql.add_bind(p_parameter_4);
2033: fnd_dsql.add_text(' AND TRUNC(appl_dt) >= TRUNC(igs_ge_date.igsdate( ');
2034: fnd_dsql.add_bind(p_parameter_5);
2035: fnd_dsql.add_text(')) AND TRUNC(appl_dt) <= TRUNC(igs_ge_date.igsdate( ');
2036: fnd_dsql.add_bind(p_parameter_6);
2037: fnd_dsql.add_text(')) AND admission_outcome_status = ');
2038: fnd_dsql.add_bind(p_parameter_7);
2039: END IF;
2040: ELSIF P_SYS_LTR_CODE = 'ADWAITL' THEN

Line 2037: fnd_dsql.add_text(')) AND admission_outcome_status = ');

2033: fnd_dsql.add_text(' AND TRUNC(appl_dt) >= TRUNC(igs_ge_date.igsdate( ');
2034: fnd_dsql.add_bind(p_parameter_5);
2035: fnd_dsql.add_text(')) AND TRUNC(appl_dt) <= TRUNC(igs_ge_date.igsdate( ');
2036: fnd_dsql.add_bind(p_parameter_6);
2037: fnd_dsql.add_text(')) AND admission_outcome_status = ');
2038: fnd_dsql.add_bind(p_parameter_7);
2039: END IF;
2040: ELSIF P_SYS_LTR_CODE = 'ADWAITL' THEN
2041: IF p_parameter_1 IS NOT NULL THEN

Line 2038: fnd_dsql.add_bind(p_parameter_7);

2034: fnd_dsql.add_bind(p_parameter_5);
2035: fnd_dsql.add_text(')) AND TRUNC(appl_dt) <= TRUNC(igs_ge_date.igsdate( ');
2036: fnd_dsql.add_bind(p_parameter_6);
2037: fnd_dsql.add_text(')) AND admission_outcome_status = ');
2038: fnd_dsql.add_bind(p_parameter_7);
2039: END IF;
2040: ELSIF P_SYS_LTR_CODE = 'ADWAITL' THEN
2041: IF p_parameter_1 IS NOT NULL THEN
2042: fnd_dsql.add_text(' 1=1 ' );

Line 2042: fnd_dsql.add_text(' 1=1 ' );

2038: fnd_dsql.add_bind(p_parameter_7);
2039: END IF;
2040: ELSIF P_SYS_LTR_CODE = 'ADWAITL' THEN
2041: IF p_parameter_1 IS NOT NULL THEN
2042: fnd_dsql.add_text(' 1=1 ' );
2043: ELSE
2044: fnd_dsql.add_text(' acad_cal_type = ');
2045: fnd_dsql.add_bind(l_acad_cal_type);
2046: fnd_dsql.add_text(' AND acad_ci_sequence_number = ');

Line 2044: fnd_dsql.add_text(' acad_cal_type = ');

2040: ELSIF P_SYS_LTR_CODE = 'ADWAITL' THEN
2041: IF p_parameter_1 IS NOT NULL THEN
2042: fnd_dsql.add_text(' 1=1 ' );
2043: ELSE
2044: fnd_dsql.add_text(' acad_cal_type = ');
2045: fnd_dsql.add_bind(l_acad_cal_type);
2046: fnd_dsql.add_text(' AND acad_ci_sequence_number = ');
2047: fnd_dsql.add_bind(l_acad_ci_sequence_number);
2048: fnd_dsql.add_text(' AND adm_cal_type = ');

Line 2045: fnd_dsql.add_bind(l_acad_cal_type);

2041: IF p_parameter_1 IS NOT NULL THEN
2042: fnd_dsql.add_text(' 1=1 ' );
2043: ELSE
2044: fnd_dsql.add_text(' acad_cal_type = ');
2045: fnd_dsql.add_bind(l_acad_cal_type);
2046: fnd_dsql.add_text(' AND acad_ci_sequence_number = ');
2047: fnd_dsql.add_bind(l_acad_ci_sequence_number);
2048: fnd_dsql.add_text(' AND adm_cal_type = ');
2049: fnd_dsql.add_bind(l_adm_cal_type);

Line 2046: fnd_dsql.add_text(' AND acad_ci_sequence_number = ');

2042: fnd_dsql.add_text(' 1=1 ' );
2043: ELSE
2044: fnd_dsql.add_text(' acad_cal_type = ');
2045: fnd_dsql.add_bind(l_acad_cal_type);
2046: fnd_dsql.add_text(' AND acad_ci_sequence_number = ');
2047: fnd_dsql.add_bind(l_acad_ci_sequence_number);
2048: fnd_dsql.add_text(' AND adm_cal_type = ');
2049: fnd_dsql.add_bind(l_adm_cal_type);
2050: fnd_dsql.add_text(' AND adm_ci_sequence_number = ');

Line 2047: fnd_dsql.add_bind(l_acad_ci_sequence_number);

2043: ELSE
2044: fnd_dsql.add_text(' acad_cal_type = ');
2045: fnd_dsql.add_bind(l_acad_cal_type);
2046: fnd_dsql.add_text(' AND acad_ci_sequence_number = ');
2047: fnd_dsql.add_bind(l_acad_ci_sequence_number);
2048: fnd_dsql.add_text(' AND adm_cal_type = ');
2049: fnd_dsql.add_bind(l_adm_cal_type);
2050: fnd_dsql.add_text(' AND adm_ci_sequence_number = ');
2051: fnd_dsql.add_bind(l_adm_ci_sequence_number);

Line 2048: fnd_dsql.add_text(' AND adm_cal_type = ');

2044: fnd_dsql.add_text(' acad_cal_type = ');
2045: fnd_dsql.add_bind(l_acad_cal_type);
2046: fnd_dsql.add_text(' AND acad_ci_sequence_number = ');
2047: fnd_dsql.add_bind(l_acad_ci_sequence_number);
2048: fnd_dsql.add_text(' AND adm_cal_type = ');
2049: fnd_dsql.add_bind(l_adm_cal_type);
2050: fnd_dsql.add_text(' AND adm_ci_sequence_number = ');
2051: fnd_dsql.add_bind(l_adm_ci_sequence_number);
2052: fnd_dsql.add_text(' AND admission_process_category = ');

Line 2049: fnd_dsql.add_bind(l_adm_cal_type);

2045: fnd_dsql.add_bind(l_acad_cal_type);
2046: fnd_dsql.add_text(' AND acad_ci_sequence_number = ');
2047: fnd_dsql.add_bind(l_acad_ci_sequence_number);
2048: fnd_dsql.add_text(' AND adm_cal_type = ');
2049: fnd_dsql.add_bind(l_adm_cal_type);
2050: fnd_dsql.add_text(' AND adm_ci_sequence_number = ');
2051: fnd_dsql.add_bind(l_adm_ci_sequence_number);
2052: fnd_dsql.add_text(' AND admission_process_category = ');
2053: fnd_dsql.add_bind(p_parameter_4);

Line 2050: fnd_dsql.add_text(' AND adm_ci_sequence_number = ');

2046: fnd_dsql.add_text(' AND acad_ci_sequence_number = ');
2047: fnd_dsql.add_bind(l_acad_ci_sequence_number);
2048: fnd_dsql.add_text(' AND adm_cal_type = ');
2049: fnd_dsql.add_bind(l_adm_cal_type);
2050: fnd_dsql.add_text(' AND adm_ci_sequence_number = ');
2051: fnd_dsql.add_bind(l_adm_ci_sequence_number);
2052: fnd_dsql.add_text(' AND admission_process_category = ');
2053: fnd_dsql.add_bind(p_parameter_4);
2054: fnd_dsql.add_text(' AND TRUNC(appl_dt) >= TRUNC(igs_ge_date.igsdate(');

Line 2051: fnd_dsql.add_bind(l_adm_ci_sequence_number);

2047: fnd_dsql.add_bind(l_acad_ci_sequence_number);
2048: fnd_dsql.add_text(' AND adm_cal_type = ');
2049: fnd_dsql.add_bind(l_adm_cal_type);
2050: fnd_dsql.add_text(' AND adm_ci_sequence_number = ');
2051: fnd_dsql.add_bind(l_adm_ci_sequence_number);
2052: fnd_dsql.add_text(' AND admission_process_category = ');
2053: fnd_dsql.add_bind(p_parameter_4);
2054: fnd_dsql.add_text(' AND TRUNC(appl_dt) >= TRUNC(igs_ge_date.igsdate(');
2055: fnd_dsql.add_bind(p_parameter_5);

Line 2052: fnd_dsql.add_text(' AND admission_process_category = ');

2048: fnd_dsql.add_text(' AND adm_cal_type = ');
2049: fnd_dsql.add_bind(l_adm_cal_type);
2050: fnd_dsql.add_text(' AND adm_ci_sequence_number = ');
2051: fnd_dsql.add_bind(l_adm_ci_sequence_number);
2052: fnd_dsql.add_text(' AND admission_process_category = ');
2053: fnd_dsql.add_bind(p_parameter_4);
2054: fnd_dsql.add_text(' AND TRUNC(appl_dt) >= TRUNC(igs_ge_date.igsdate(');
2055: fnd_dsql.add_bind(p_parameter_5);
2056: fnd_dsql.add_text(' )) AND TRUNC(appl_dt) <= TRUNC(igs_ge_date.igsdate(');

Line 2053: fnd_dsql.add_bind(p_parameter_4);

2049: fnd_dsql.add_bind(l_adm_cal_type);
2050: fnd_dsql.add_text(' AND adm_ci_sequence_number = ');
2051: fnd_dsql.add_bind(l_adm_ci_sequence_number);
2052: fnd_dsql.add_text(' AND admission_process_category = ');
2053: fnd_dsql.add_bind(p_parameter_4);
2054: fnd_dsql.add_text(' AND TRUNC(appl_dt) >= TRUNC(igs_ge_date.igsdate(');
2055: fnd_dsql.add_bind(p_parameter_5);
2056: fnd_dsql.add_text(' )) AND TRUNC(appl_dt) <= TRUNC(igs_ge_date.igsdate(');
2057: fnd_dsql.add_bind(p_parameter_6);

Line 2054: fnd_dsql.add_text(' AND TRUNC(appl_dt) >= TRUNC(igs_ge_date.igsdate(');

2050: fnd_dsql.add_text(' AND adm_ci_sequence_number = ');
2051: fnd_dsql.add_bind(l_adm_ci_sequence_number);
2052: fnd_dsql.add_text(' AND admission_process_category = ');
2053: fnd_dsql.add_bind(p_parameter_4);
2054: fnd_dsql.add_text(' AND TRUNC(appl_dt) >= TRUNC(igs_ge_date.igsdate(');
2055: fnd_dsql.add_bind(p_parameter_5);
2056: fnd_dsql.add_text(' )) AND TRUNC(appl_dt) <= TRUNC(igs_ge_date.igsdate(');
2057: fnd_dsql.add_bind(p_parameter_6);
2058: fnd_dsql.add_text(' )) AND admission_outcome_status = ');

Line 2055: fnd_dsql.add_bind(p_parameter_5);

2051: fnd_dsql.add_bind(l_adm_ci_sequence_number);
2052: fnd_dsql.add_text(' AND admission_process_category = ');
2053: fnd_dsql.add_bind(p_parameter_4);
2054: fnd_dsql.add_text(' AND TRUNC(appl_dt) >= TRUNC(igs_ge_date.igsdate(');
2055: fnd_dsql.add_bind(p_parameter_5);
2056: fnd_dsql.add_text(' )) AND TRUNC(appl_dt) <= TRUNC(igs_ge_date.igsdate(');
2057: fnd_dsql.add_bind(p_parameter_6);
2058: fnd_dsql.add_text(' )) AND admission_outcome_status = ');
2059: fnd_dsql.add_bind(p_parameter_7);

Line 2056: fnd_dsql.add_text(' )) AND TRUNC(appl_dt) <= TRUNC(igs_ge_date.igsdate(');

2052: fnd_dsql.add_text(' AND admission_process_category = ');
2053: fnd_dsql.add_bind(p_parameter_4);
2054: fnd_dsql.add_text(' AND TRUNC(appl_dt) >= TRUNC(igs_ge_date.igsdate(');
2055: fnd_dsql.add_bind(p_parameter_5);
2056: fnd_dsql.add_text(' )) AND TRUNC(appl_dt) <= TRUNC(igs_ge_date.igsdate(');
2057: fnd_dsql.add_bind(p_parameter_6);
2058: fnd_dsql.add_text(' )) AND admission_outcome_status = ');
2059: fnd_dsql.add_bind(p_parameter_7);
2060: END IF;

Line 2057: fnd_dsql.add_bind(p_parameter_6);

2053: fnd_dsql.add_bind(p_parameter_4);
2054: fnd_dsql.add_text(' AND TRUNC(appl_dt) >= TRUNC(igs_ge_date.igsdate(');
2055: fnd_dsql.add_bind(p_parameter_5);
2056: fnd_dsql.add_text(' )) AND TRUNC(appl_dt) <= TRUNC(igs_ge_date.igsdate(');
2057: fnd_dsql.add_bind(p_parameter_6);
2058: fnd_dsql.add_text(' )) AND admission_outcome_status = ');
2059: fnd_dsql.add_bind(p_parameter_7);
2060: END IF;
2061: ELSIF P_SYS_LTR_CODE = 'ADNOQUT' THEN

Line 2058: fnd_dsql.add_text(' )) AND admission_outcome_status = ');

2054: fnd_dsql.add_text(' AND TRUNC(appl_dt) >= TRUNC(igs_ge_date.igsdate(');
2055: fnd_dsql.add_bind(p_parameter_5);
2056: fnd_dsql.add_text(' )) AND TRUNC(appl_dt) <= TRUNC(igs_ge_date.igsdate(');
2057: fnd_dsql.add_bind(p_parameter_6);
2058: fnd_dsql.add_text(' )) AND admission_outcome_status = ');
2059: fnd_dsql.add_bind(p_parameter_7);
2060: END IF;
2061: ELSIF P_SYS_LTR_CODE = 'ADNOQUT' THEN
2062: IF p_parameter_1 IS NOT NULL THEN

Line 2059: fnd_dsql.add_bind(p_parameter_7);

2055: fnd_dsql.add_bind(p_parameter_5);
2056: fnd_dsql.add_text(' )) AND TRUNC(appl_dt) <= TRUNC(igs_ge_date.igsdate(');
2057: fnd_dsql.add_bind(p_parameter_6);
2058: fnd_dsql.add_text(' )) AND admission_outcome_status = ');
2059: fnd_dsql.add_bind(p_parameter_7);
2060: END IF;
2061: ELSIF P_SYS_LTR_CODE = 'ADNOQUT' THEN
2062: IF p_parameter_1 IS NOT NULL THEN
2063: fnd_dsql.add_text(' 1=1 ' );

Line 2063: fnd_dsql.add_text(' 1=1 ' );

2059: fnd_dsql.add_bind(p_parameter_7);
2060: END IF;
2061: ELSIF P_SYS_LTR_CODE = 'ADNOQUT' THEN
2062: IF p_parameter_1 IS NOT NULL THEN
2063: fnd_dsql.add_text(' 1=1 ' );
2064: ELSE
2065: fnd_dsql.add_text(' acad_cal_type = ');
2066: fnd_dsql.add_bind(l_acad_cal_type);
2067: fnd_dsql.add_text(' AND acad_ci_sequence_number = ');

Line 2065: fnd_dsql.add_text(' acad_cal_type = ');

2061: ELSIF P_SYS_LTR_CODE = 'ADNOQUT' THEN
2062: IF p_parameter_1 IS NOT NULL THEN
2063: fnd_dsql.add_text(' 1=1 ' );
2064: ELSE
2065: fnd_dsql.add_text(' acad_cal_type = ');
2066: fnd_dsql.add_bind(l_acad_cal_type);
2067: fnd_dsql.add_text(' AND acad_ci_sequence_number = ');
2068: fnd_dsql.add_bind(l_acad_ci_sequence_number);
2069: fnd_dsql.add_text(' AND adm_cal_type = ');

Line 2066: fnd_dsql.add_bind(l_acad_cal_type);

2062: IF p_parameter_1 IS NOT NULL THEN
2063: fnd_dsql.add_text(' 1=1 ' );
2064: ELSE
2065: fnd_dsql.add_text(' acad_cal_type = ');
2066: fnd_dsql.add_bind(l_acad_cal_type);
2067: fnd_dsql.add_text(' AND acad_ci_sequence_number = ');
2068: fnd_dsql.add_bind(l_acad_ci_sequence_number);
2069: fnd_dsql.add_text(' AND adm_cal_type = ');
2070: fnd_dsql.add_bind(l_adm_cal_type);

Line 2067: fnd_dsql.add_text(' AND acad_ci_sequence_number = ');

2063: fnd_dsql.add_text(' 1=1 ' );
2064: ELSE
2065: fnd_dsql.add_text(' acad_cal_type = ');
2066: fnd_dsql.add_bind(l_acad_cal_type);
2067: fnd_dsql.add_text(' AND acad_ci_sequence_number = ');
2068: fnd_dsql.add_bind(l_acad_ci_sequence_number);
2069: fnd_dsql.add_text(' AND adm_cal_type = ');
2070: fnd_dsql.add_bind(l_adm_cal_type);
2071: fnd_dsql.add_text(' AND adm_ci_sequence_number = ');

Line 2068: fnd_dsql.add_bind(l_acad_ci_sequence_number);

2064: ELSE
2065: fnd_dsql.add_text(' acad_cal_type = ');
2066: fnd_dsql.add_bind(l_acad_cal_type);
2067: fnd_dsql.add_text(' AND acad_ci_sequence_number = ');
2068: fnd_dsql.add_bind(l_acad_ci_sequence_number);
2069: fnd_dsql.add_text(' AND adm_cal_type = ');
2070: fnd_dsql.add_bind(l_adm_cal_type);
2071: fnd_dsql.add_text(' AND adm_ci_sequence_number = ');
2072: fnd_dsql.add_bind(l_adm_ci_sequence_number);

Line 2069: fnd_dsql.add_text(' AND adm_cal_type = ');

2065: fnd_dsql.add_text(' acad_cal_type = ');
2066: fnd_dsql.add_bind(l_acad_cal_type);
2067: fnd_dsql.add_text(' AND acad_ci_sequence_number = ');
2068: fnd_dsql.add_bind(l_acad_ci_sequence_number);
2069: fnd_dsql.add_text(' AND adm_cal_type = ');
2070: fnd_dsql.add_bind(l_adm_cal_type);
2071: fnd_dsql.add_text(' AND adm_ci_sequence_number = ');
2072: fnd_dsql.add_bind(l_adm_ci_sequence_number);
2073: fnd_dsql.add_text(' AND admission_process_category = ');

Line 2070: fnd_dsql.add_bind(l_adm_cal_type);

2066: fnd_dsql.add_bind(l_acad_cal_type);
2067: fnd_dsql.add_text(' AND acad_ci_sequence_number = ');
2068: fnd_dsql.add_bind(l_acad_ci_sequence_number);
2069: fnd_dsql.add_text(' AND adm_cal_type = ');
2070: fnd_dsql.add_bind(l_adm_cal_type);
2071: fnd_dsql.add_text(' AND adm_ci_sequence_number = ');
2072: fnd_dsql.add_bind(l_adm_ci_sequence_number);
2073: fnd_dsql.add_text(' AND admission_process_category = ');
2074: fnd_dsql.add_bind(p_parameter_4);

Line 2071: fnd_dsql.add_text(' AND adm_ci_sequence_number = ');

2067: fnd_dsql.add_text(' AND acad_ci_sequence_number = ');
2068: fnd_dsql.add_bind(l_acad_ci_sequence_number);
2069: fnd_dsql.add_text(' AND adm_cal_type = ');
2070: fnd_dsql.add_bind(l_adm_cal_type);
2071: fnd_dsql.add_text(' AND adm_ci_sequence_number = ');
2072: fnd_dsql.add_bind(l_adm_ci_sequence_number);
2073: fnd_dsql.add_text(' AND admission_process_category = ');
2074: fnd_dsql.add_bind(p_parameter_4);
2075: fnd_dsql.add_text(' AND TRUNC(appl_dt) >= TRUNC(igs_ge_date.igsdate(');

Line 2072: fnd_dsql.add_bind(l_adm_ci_sequence_number);

2068: fnd_dsql.add_bind(l_acad_ci_sequence_number);
2069: fnd_dsql.add_text(' AND adm_cal_type = ');
2070: fnd_dsql.add_bind(l_adm_cal_type);
2071: fnd_dsql.add_text(' AND adm_ci_sequence_number = ');
2072: fnd_dsql.add_bind(l_adm_ci_sequence_number);
2073: fnd_dsql.add_text(' AND admission_process_category = ');
2074: fnd_dsql.add_bind(p_parameter_4);
2075: fnd_dsql.add_text(' AND TRUNC(appl_dt) >= TRUNC(igs_ge_date.igsdate(');
2076: fnd_dsql.add_bind(p_parameter_5);

Line 2073: fnd_dsql.add_text(' AND admission_process_category = ');

2069: fnd_dsql.add_text(' AND adm_cal_type = ');
2070: fnd_dsql.add_bind(l_adm_cal_type);
2071: fnd_dsql.add_text(' AND adm_ci_sequence_number = ');
2072: fnd_dsql.add_bind(l_adm_ci_sequence_number);
2073: fnd_dsql.add_text(' AND admission_process_category = ');
2074: fnd_dsql.add_bind(p_parameter_4);
2075: fnd_dsql.add_text(' AND TRUNC(appl_dt) >= TRUNC(igs_ge_date.igsdate(');
2076: fnd_dsql.add_bind(p_parameter_5);
2077: fnd_dsql.add_text(' )) AND TRUNC(appl_dt) <= TRUNC(igs_ge_date.igsdate(');

Line 2074: fnd_dsql.add_bind(p_parameter_4);

2070: fnd_dsql.add_bind(l_adm_cal_type);
2071: fnd_dsql.add_text(' AND adm_ci_sequence_number = ');
2072: fnd_dsql.add_bind(l_adm_ci_sequence_number);
2073: fnd_dsql.add_text(' AND admission_process_category = ');
2074: fnd_dsql.add_bind(p_parameter_4);
2075: fnd_dsql.add_text(' AND TRUNC(appl_dt) >= TRUNC(igs_ge_date.igsdate(');
2076: fnd_dsql.add_bind(p_parameter_5);
2077: fnd_dsql.add_text(' )) AND TRUNC(appl_dt) <= TRUNC(igs_ge_date.igsdate(');
2078: fnd_dsql.add_bind(p_parameter_6);

Line 2075: fnd_dsql.add_text(' AND TRUNC(appl_dt) >= TRUNC(igs_ge_date.igsdate(');

2071: fnd_dsql.add_text(' AND adm_ci_sequence_number = ');
2072: fnd_dsql.add_bind(l_adm_ci_sequence_number);
2073: fnd_dsql.add_text(' AND admission_process_category = ');
2074: fnd_dsql.add_bind(p_parameter_4);
2075: fnd_dsql.add_text(' AND TRUNC(appl_dt) >= TRUNC(igs_ge_date.igsdate(');
2076: fnd_dsql.add_bind(p_parameter_5);
2077: fnd_dsql.add_text(' )) AND TRUNC(appl_dt) <= TRUNC(igs_ge_date.igsdate(');
2078: fnd_dsql.add_bind(p_parameter_6);
2079: fnd_dsql.add_text(' )) AND admission_outcome_status = ');

Line 2076: fnd_dsql.add_bind(p_parameter_5);

2072: fnd_dsql.add_bind(l_adm_ci_sequence_number);
2073: fnd_dsql.add_text(' AND admission_process_category = ');
2074: fnd_dsql.add_bind(p_parameter_4);
2075: fnd_dsql.add_text(' AND TRUNC(appl_dt) >= TRUNC(igs_ge_date.igsdate(');
2076: fnd_dsql.add_bind(p_parameter_5);
2077: fnd_dsql.add_text(' )) AND TRUNC(appl_dt) <= TRUNC(igs_ge_date.igsdate(');
2078: fnd_dsql.add_bind(p_parameter_6);
2079: fnd_dsql.add_text(' )) AND admission_outcome_status = ');
2080: fnd_dsql.add_bind(p_parameter_7);

Line 2077: fnd_dsql.add_text(' )) AND TRUNC(appl_dt) <= TRUNC(igs_ge_date.igsdate(');

2073: fnd_dsql.add_text(' AND admission_process_category = ');
2074: fnd_dsql.add_bind(p_parameter_4);
2075: fnd_dsql.add_text(' AND TRUNC(appl_dt) >= TRUNC(igs_ge_date.igsdate(');
2076: fnd_dsql.add_bind(p_parameter_5);
2077: fnd_dsql.add_text(' )) AND TRUNC(appl_dt) <= TRUNC(igs_ge_date.igsdate(');
2078: fnd_dsql.add_bind(p_parameter_6);
2079: fnd_dsql.add_text(' )) AND admission_outcome_status = ');
2080: fnd_dsql.add_bind(p_parameter_7);
2081: END IF;

Line 2078: fnd_dsql.add_bind(p_parameter_6);

2074: fnd_dsql.add_bind(p_parameter_4);
2075: fnd_dsql.add_text(' AND TRUNC(appl_dt) >= TRUNC(igs_ge_date.igsdate(');
2076: fnd_dsql.add_bind(p_parameter_5);
2077: fnd_dsql.add_text(' )) AND TRUNC(appl_dt) <= TRUNC(igs_ge_date.igsdate(');
2078: fnd_dsql.add_bind(p_parameter_6);
2079: fnd_dsql.add_text(' )) AND admission_outcome_status = ');
2080: fnd_dsql.add_bind(p_parameter_7);
2081: END IF;
2082: ELSIF P_SYS_LTR_CODE = 'ADCONOF' THEN

Line 2079: fnd_dsql.add_text(' )) AND admission_outcome_status = ');

2075: fnd_dsql.add_text(' AND TRUNC(appl_dt) >= TRUNC(igs_ge_date.igsdate(');
2076: fnd_dsql.add_bind(p_parameter_5);
2077: fnd_dsql.add_text(' )) AND TRUNC(appl_dt) <= TRUNC(igs_ge_date.igsdate(');
2078: fnd_dsql.add_bind(p_parameter_6);
2079: fnd_dsql.add_text(' )) AND admission_outcome_status = ');
2080: fnd_dsql.add_bind(p_parameter_7);
2081: END IF;
2082: ELSIF P_SYS_LTR_CODE = 'ADCONOF' THEN
2083: IF p_parameter_1 IS NOT NULL THEN

Line 2080: fnd_dsql.add_bind(p_parameter_7);

2076: fnd_dsql.add_bind(p_parameter_5);
2077: fnd_dsql.add_text(' )) AND TRUNC(appl_dt) <= TRUNC(igs_ge_date.igsdate(');
2078: fnd_dsql.add_bind(p_parameter_6);
2079: fnd_dsql.add_text(' )) AND admission_outcome_status = ');
2080: fnd_dsql.add_bind(p_parameter_7);
2081: END IF;
2082: ELSIF P_SYS_LTR_CODE = 'ADCONOF' THEN
2083: IF p_parameter_1 IS NOT NULL THEN
2084: fnd_dsql.add_text(' 1=1 ' );

Line 2084: fnd_dsql.add_text(' 1=1 ' );

2080: fnd_dsql.add_bind(p_parameter_7);
2081: END IF;
2082: ELSIF P_SYS_LTR_CODE = 'ADCONOF' THEN
2083: IF p_parameter_1 IS NOT NULL THEN
2084: fnd_dsql.add_text(' 1=1 ' );
2085: ELSE
2086: fnd_dsql.add_text(' acad_cal_type = ');
2087: fnd_dsql.add_bind(l_acad_cal_type);
2088: fnd_dsql.add_text(' AND acad_ci_sequence_number = ');

Line 2086: fnd_dsql.add_text(' acad_cal_type = ');

2082: ELSIF P_SYS_LTR_CODE = 'ADCONOF' THEN
2083: IF p_parameter_1 IS NOT NULL THEN
2084: fnd_dsql.add_text(' 1=1 ' );
2085: ELSE
2086: fnd_dsql.add_text(' acad_cal_type = ');
2087: fnd_dsql.add_bind(l_acad_cal_type);
2088: fnd_dsql.add_text(' AND acad_ci_sequence_number = ');
2089: fnd_dsql.add_bind(l_acad_ci_sequence_number);
2090: fnd_dsql.add_text(' AND adm_cal_type = ');

Line 2087: fnd_dsql.add_bind(l_acad_cal_type);

2083: IF p_parameter_1 IS NOT NULL THEN
2084: fnd_dsql.add_text(' 1=1 ' );
2085: ELSE
2086: fnd_dsql.add_text(' acad_cal_type = ');
2087: fnd_dsql.add_bind(l_acad_cal_type);
2088: fnd_dsql.add_text(' AND acad_ci_sequence_number = ');
2089: fnd_dsql.add_bind(l_acad_ci_sequence_number);
2090: fnd_dsql.add_text(' AND adm_cal_type = ');
2091: fnd_dsql.add_bind(l_adm_cal_type);

Line 2088: fnd_dsql.add_text(' AND acad_ci_sequence_number = ');

2084: fnd_dsql.add_text(' 1=1 ' );
2085: ELSE
2086: fnd_dsql.add_text(' acad_cal_type = ');
2087: fnd_dsql.add_bind(l_acad_cal_type);
2088: fnd_dsql.add_text(' AND acad_ci_sequence_number = ');
2089: fnd_dsql.add_bind(l_acad_ci_sequence_number);
2090: fnd_dsql.add_text(' AND adm_cal_type = ');
2091: fnd_dsql.add_bind(l_adm_cal_type);
2092: fnd_dsql.add_text(' AND adm_ci_sequence_number = ');

Line 2089: fnd_dsql.add_bind(l_acad_ci_sequence_number);

2085: ELSE
2086: fnd_dsql.add_text(' acad_cal_type = ');
2087: fnd_dsql.add_bind(l_acad_cal_type);
2088: fnd_dsql.add_text(' AND acad_ci_sequence_number = ');
2089: fnd_dsql.add_bind(l_acad_ci_sequence_number);
2090: fnd_dsql.add_text(' AND adm_cal_type = ');
2091: fnd_dsql.add_bind(l_adm_cal_type);
2092: fnd_dsql.add_text(' AND adm_ci_sequence_number = ');
2093: fnd_dsql.add_bind(l_adm_ci_sequence_number);

Line 2090: fnd_dsql.add_text(' AND adm_cal_type = ');

2086: fnd_dsql.add_text(' acad_cal_type = ');
2087: fnd_dsql.add_bind(l_acad_cal_type);
2088: fnd_dsql.add_text(' AND acad_ci_sequence_number = ');
2089: fnd_dsql.add_bind(l_acad_ci_sequence_number);
2090: fnd_dsql.add_text(' AND adm_cal_type = ');
2091: fnd_dsql.add_bind(l_adm_cal_type);
2092: fnd_dsql.add_text(' AND adm_ci_sequence_number = ');
2093: fnd_dsql.add_bind(l_adm_ci_sequence_number);
2094: fnd_dsql.add_text(' AND admission_process_category = ');

Line 2091: fnd_dsql.add_bind(l_adm_cal_type);

2087: fnd_dsql.add_bind(l_acad_cal_type);
2088: fnd_dsql.add_text(' AND acad_ci_sequence_number = ');
2089: fnd_dsql.add_bind(l_acad_ci_sequence_number);
2090: fnd_dsql.add_text(' AND adm_cal_type = ');
2091: fnd_dsql.add_bind(l_adm_cal_type);
2092: fnd_dsql.add_text(' AND adm_ci_sequence_number = ');
2093: fnd_dsql.add_bind(l_adm_ci_sequence_number);
2094: fnd_dsql.add_text(' AND admission_process_category = ');
2095: fnd_dsql.add_bind(p_parameter_4);

Line 2092: fnd_dsql.add_text(' AND adm_ci_sequence_number = ');

2088: fnd_dsql.add_text(' AND acad_ci_sequence_number = ');
2089: fnd_dsql.add_bind(l_acad_ci_sequence_number);
2090: fnd_dsql.add_text(' AND adm_cal_type = ');
2091: fnd_dsql.add_bind(l_adm_cal_type);
2092: fnd_dsql.add_text(' AND adm_ci_sequence_number = ');
2093: fnd_dsql.add_bind(l_adm_ci_sequence_number);
2094: fnd_dsql.add_text(' AND admission_process_category = ');
2095: fnd_dsql.add_bind(p_parameter_4);
2096: fnd_dsql.add_text(' AND TRUNC(appl_dt) >= TRUNC(igs_ge_date.igsdate(');

Line 2093: fnd_dsql.add_bind(l_adm_ci_sequence_number);

2089: fnd_dsql.add_bind(l_acad_ci_sequence_number);
2090: fnd_dsql.add_text(' AND adm_cal_type = ');
2091: fnd_dsql.add_bind(l_adm_cal_type);
2092: fnd_dsql.add_text(' AND adm_ci_sequence_number = ');
2093: fnd_dsql.add_bind(l_adm_ci_sequence_number);
2094: fnd_dsql.add_text(' AND admission_process_category = ');
2095: fnd_dsql.add_bind(p_parameter_4);
2096: fnd_dsql.add_text(' AND TRUNC(appl_dt) >= TRUNC(igs_ge_date.igsdate(');
2097: fnd_dsql.add_bind(p_parameter_5);

Line 2094: fnd_dsql.add_text(' AND admission_process_category = ');

2090: fnd_dsql.add_text(' AND adm_cal_type = ');
2091: fnd_dsql.add_bind(l_adm_cal_type);
2092: fnd_dsql.add_text(' AND adm_ci_sequence_number = ');
2093: fnd_dsql.add_bind(l_adm_ci_sequence_number);
2094: fnd_dsql.add_text(' AND admission_process_category = ');
2095: fnd_dsql.add_bind(p_parameter_4);
2096: fnd_dsql.add_text(' AND TRUNC(appl_dt) >= TRUNC(igs_ge_date.igsdate(');
2097: fnd_dsql.add_bind(p_parameter_5);
2098: fnd_dsql.add_text(' )) AND TRUNC(appl_dt) <= TRUNC(igs_ge_date.igsdate(');

Line 2095: fnd_dsql.add_bind(p_parameter_4);

2091: fnd_dsql.add_bind(l_adm_cal_type);
2092: fnd_dsql.add_text(' AND adm_ci_sequence_number = ');
2093: fnd_dsql.add_bind(l_adm_ci_sequence_number);
2094: fnd_dsql.add_text(' AND admission_process_category = ');
2095: fnd_dsql.add_bind(p_parameter_4);
2096: fnd_dsql.add_text(' AND TRUNC(appl_dt) >= TRUNC(igs_ge_date.igsdate(');
2097: fnd_dsql.add_bind(p_parameter_5);
2098: fnd_dsql.add_text(' )) AND TRUNC(appl_dt) <= TRUNC(igs_ge_date.igsdate(');
2099: fnd_dsql.add_bind(p_parameter_6);

Line 2096: fnd_dsql.add_text(' AND TRUNC(appl_dt) >= TRUNC(igs_ge_date.igsdate(');

2092: fnd_dsql.add_text(' AND adm_ci_sequence_number = ');
2093: fnd_dsql.add_bind(l_adm_ci_sequence_number);
2094: fnd_dsql.add_text(' AND admission_process_category = ');
2095: fnd_dsql.add_bind(p_parameter_4);
2096: fnd_dsql.add_text(' AND TRUNC(appl_dt) >= TRUNC(igs_ge_date.igsdate(');
2097: fnd_dsql.add_bind(p_parameter_5);
2098: fnd_dsql.add_text(' )) AND TRUNC(appl_dt) <= TRUNC(igs_ge_date.igsdate(');
2099: fnd_dsql.add_bind(p_parameter_6);
2100: fnd_dsql.add_text(' )) AND admission_outcome_status = ');

Line 2097: fnd_dsql.add_bind(p_parameter_5);

2093: fnd_dsql.add_bind(l_adm_ci_sequence_number);
2094: fnd_dsql.add_text(' AND admission_process_category = ');
2095: fnd_dsql.add_bind(p_parameter_4);
2096: fnd_dsql.add_text(' AND TRUNC(appl_dt) >= TRUNC(igs_ge_date.igsdate(');
2097: fnd_dsql.add_bind(p_parameter_5);
2098: fnd_dsql.add_text(' )) AND TRUNC(appl_dt) <= TRUNC(igs_ge_date.igsdate(');
2099: fnd_dsql.add_bind(p_parameter_6);
2100: fnd_dsql.add_text(' )) AND admission_outcome_status = ');
2101: fnd_dsql.add_bind(p_parameter_7);

Line 2098: fnd_dsql.add_text(' )) AND TRUNC(appl_dt) <= TRUNC(igs_ge_date.igsdate(');

2094: fnd_dsql.add_text(' AND admission_process_category = ');
2095: fnd_dsql.add_bind(p_parameter_4);
2096: fnd_dsql.add_text(' AND TRUNC(appl_dt) >= TRUNC(igs_ge_date.igsdate(');
2097: fnd_dsql.add_bind(p_parameter_5);
2098: fnd_dsql.add_text(' )) AND TRUNC(appl_dt) <= TRUNC(igs_ge_date.igsdate(');
2099: fnd_dsql.add_bind(p_parameter_6);
2100: fnd_dsql.add_text(' )) AND admission_outcome_status = ');
2101: fnd_dsql.add_bind(p_parameter_7);
2102: END IF;

Line 2099: fnd_dsql.add_bind(p_parameter_6);

2095: fnd_dsql.add_bind(p_parameter_4);
2096: fnd_dsql.add_text(' AND TRUNC(appl_dt) >= TRUNC(igs_ge_date.igsdate(');
2097: fnd_dsql.add_bind(p_parameter_5);
2098: fnd_dsql.add_text(' )) AND TRUNC(appl_dt) <= TRUNC(igs_ge_date.igsdate(');
2099: fnd_dsql.add_bind(p_parameter_6);
2100: fnd_dsql.add_text(' )) AND admission_outcome_status = ');
2101: fnd_dsql.add_bind(p_parameter_7);
2102: END IF;
2103: ELSIF P_SYS_LTR_CODE = 'ADPADMS' THEN

Line 2100: fnd_dsql.add_text(' )) AND admission_outcome_status = ');

2096: fnd_dsql.add_text(' AND TRUNC(appl_dt) >= TRUNC(igs_ge_date.igsdate(');
2097: fnd_dsql.add_bind(p_parameter_5);
2098: fnd_dsql.add_text(' )) AND TRUNC(appl_dt) <= TRUNC(igs_ge_date.igsdate(');
2099: fnd_dsql.add_bind(p_parameter_6);
2100: fnd_dsql.add_text(' )) AND admission_outcome_status = ');
2101: fnd_dsql.add_bind(p_parameter_7);
2102: END IF;
2103: ELSIF P_SYS_LTR_CODE = 'ADPADMS' THEN
2104: IF p_parameter_1 IS NOT NULL THEN

Line 2101: fnd_dsql.add_bind(p_parameter_7);

2097: fnd_dsql.add_bind(p_parameter_5);
2098: fnd_dsql.add_text(' )) AND TRUNC(appl_dt) <= TRUNC(igs_ge_date.igsdate(');
2099: fnd_dsql.add_bind(p_parameter_6);
2100: fnd_dsql.add_text(' )) AND admission_outcome_status = ');
2101: fnd_dsql.add_bind(p_parameter_7);
2102: END IF;
2103: ELSIF P_SYS_LTR_CODE = 'ADPADMS' THEN
2104: IF p_parameter_1 IS NOT NULL THEN
2105: fnd_dsql.add_text(' 1=1 ' );

Line 2105: fnd_dsql.add_text(' 1=1 ' );

2101: fnd_dsql.add_bind(p_parameter_7);
2102: END IF;
2103: ELSIF P_SYS_LTR_CODE = 'ADPADMS' THEN
2104: IF p_parameter_1 IS NOT NULL THEN
2105: fnd_dsql.add_text(' 1=1 ' );
2106: ELSE
2107: fnd_dsql.add_text(' acad_cal_type = ');
2108: fnd_dsql.add_bind(l_acad_cal_type);
2109: fnd_dsql.add_text(' AND acad_ci_sequence_number = ');

Line 2107: fnd_dsql.add_text(' acad_cal_type = ');

2103: ELSIF P_SYS_LTR_CODE = 'ADPADMS' THEN
2104: IF p_parameter_1 IS NOT NULL THEN
2105: fnd_dsql.add_text(' 1=1 ' );
2106: ELSE
2107: fnd_dsql.add_text(' acad_cal_type = ');
2108: fnd_dsql.add_bind(l_acad_cal_type);
2109: fnd_dsql.add_text(' AND acad_ci_sequence_number = ');
2110: fnd_dsql.add_bind(l_acad_ci_sequence_number);
2111: fnd_dsql.add_text(' AND adm_cal_type = ');

Line 2108: fnd_dsql.add_bind(l_acad_cal_type);

2104: IF p_parameter_1 IS NOT NULL THEN
2105: fnd_dsql.add_text(' 1=1 ' );
2106: ELSE
2107: fnd_dsql.add_text(' acad_cal_type = ');
2108: fnd_dsql.add_bind(l_acad_cal_type);
2109: fnd_dsql.add_text(' AND acad_ci_sequence_number = ');
2110: fnd_dsql.add_bind(l_acad_ci_sequence_number);
2111: fnd_dsql.add_text(' AND adm_cal_type = ');
2112: fnd_dsql.add_bind(l_adm_cal_type);

Line 2109: fnd_dsql.add_text(' AND acad_ci_sequence_number = ');

2105: fnd_dsql.add_text(' 1=1 ' );
2106: ELSE
2107: fnd_dsql.add_text(' acad_cal_type = ');
2108: fnd_dsql.add_bind(l_acad_cal_type);
2109: fnd_dsql.add_text(' AND acad_ci_sequence_number = ');
2110: fnd_dsql.add_bind(l_acad_ci_sequence_number);
2111: fnd_dsql.add_text(' AND adm_cal_type = ');
2112: fnd_dsql.add_bind(l_adm_cal_type);
2113: fnd_dsql.add_text(' AND adm_ci_sequence_number = ');

Line 2110: fnd_dsql.add_bind(l_acad_ci_sequence_number);

2106: ELSE
2107: fnd_dsql.add_text(' acad_cal_type = ');
2108: fnd_dsql.add_bind(l_acad_cal_type);
2109: fnd_dsql.add_text(' AND acad_ci_sequence_number = ');
2110: fnd_dsql.add_bind(l_acad_ci_sequence_number);
2111: fnd_dsql.add_text(' AND adm_cal_type = ');
2112: fnd_dsql.add_bind(l_adm_cal_type);
2113: fnd_dsql.add_text(' AND adm_ci_sequence_number = ');
2114: fnd_dsql.add_bind(l_adm_ci_sequence_number);

Line 2111: fnd_dsql.add_text(' AND adm_cal_type = ');

2107: fnd_dsql.add_text(' acad_cal_type = ');
2108: fnd_dsql.add_bind(l_acad_cal_type);
2109: fnd_dsql.add_text(' AND acad_ci_sequence_number = ');
2110: fnd_dsql.add_bind(l_acad_ci_sequence_number);
2111: fnd_dsql.add_text(' AND adm_cal_type = ');
2112: fnd_dsql.add_bind(l_adm_cal_type);
2113: fnd_dsql.add_text(' AND adm_ci_sequence_number = ');
2114: fnd_dsql.add_bind(l_adm_ci_sequence_number);
2115: fnd_dsql.add_text(' AND adm_process_cat = ');

Line 2112: fnd_dsql.add_bind(l_adm_cal_type);

2108: fnd_dsql.add_bind(l_acad_cal_type);
2109: fnd_dsql.add_text(' AND acad_ci_sequence_number = ');
2110: fnd_dsql.add_bind(l_acad_ci_sequence_number);
2111: fnd_dsql.add_text(' AND adm_cal_type = ');
2112: fnd_dsql.add_bind(l_adm_cal_type);
2113: fnd_dsql.add_text(' AND adm_ci_sequence_number = ');
2114: fnd_dsql.add_bind(l_adm_ci_sequence_number);
2115: fnd_dsql.add_text(' AND adm_process_cat = ');
2116: fnd_dsql.add_bind(p_parameter_4);

Line 2113: fnd_dsql.add_text(' AND adm_ci_sequence_number = ');

2109: fnd_dsql.add_text(' AND acad_ci_sequence_number = ');
2110: fnd_dsql.add_bind(l_acad_ci_sequence_number);
2111: fnd_dsql.add_text(' AND adm_cal_type = ');
2112: fnd_dsql.add_bind(l_adm_cal_type);
2113: fnd_dsql.add_text(' AND adm_ci_sequence_number = ');
2114: fnd_dsql.add_bind(l_adm_ci_sequence_number);
2115: fnd_dsql.add_text(' AND adm_process_cat = ');
2116: fnd_dsql.add_bind(p_parameter_4);
2117: fnd_dsql.add_text(' AND adm_doc_status = ');

Line 2114: fnd_dsql.add_bind(l_adm_ci_sequence_number);

2110: fnd_dsql.add_bind(l_acad_ci_sequence_number);
2111: fnd_dsql.add_text(' AND adm_cal_type = ');
2112: fnd_dsql.add_bind(l_adm_cal_type);
2113: fnd_dsql.add_text(' AND adm_ci_sequence_number = ');
2114: fnd_dsql.add_bind(l_adm_ci_sequence_number);
2115: fnd_dsql.add_text(' AND adm_process_cat = ');
2116: fnd_dsql.add_bind(p_parameter_4);
2117: fnd_dsql.add_text(' AND adm_doc_status = ');
2118: fnd_dsql.add_bind(p_parameter_5);

Line 2115: fnd_dsql.add_text(' AND adm_process_cat = ');

2111: fnd_dsql.add_text(' AND adm_cal_type = ');
2112: fnd_dsql.add_bind(l_adm_cal_type);
2113: fnd_dsql.add_text(' AND adm_ci_sequence_number = ');
2114: fnd_dsql.add_bind(l_adm_ci_sequence_number);
2115: fnd_dsql.add_text(' AND adm_process_cat = ');
2116: fnd_dsql.add_bind(p_parameter_4);
2117: fnd_dsql.add_text(' AND adm_doc_status = ');
2118: fnd_dsql.add_bind(p_parameter_5);
2119: fnd_dsql.add_text(' AND org_unit_cd = ');

Line 2116: fnd_dsql.add_bind(p_parameter_4);

2112: fnd_dsql.add_bind(l_adm_cal_type);
2113: fnd_dsql.add_text(' AND adm_ci_sequence_number = ');
2114: fnd_dsql.add_bind(l_adm_ci_sequence_number);
2115: fnd_dsql.add_text(' AND adm_process_cat = ');
2116: fnd_dsql.add_bind(p_parameter_4);
2117: fnd_dsql.add_text(' AND adm_doc_status = ');
2118: fnd_dsql.add_bind(p_parameter_5);
2119: fnd_dsql.add_text(' AND org_unit_cd = ');
2120: fnd_dsql.add_bind(p_parameter_6);

Line 2117: fnd_dsql.add_text(' AND adm_doc_status = ');

2113: fnd_dsql.add_text(' AND adm_ci_sequence_number = ');
2114: fnd_dsql.add_bind(l_adm_ci_sequence_number);
2115: fnd_dsql.add_text(' AND adm_process_cat = ');
2116: fnd_dsql.add_bind(p_parameter_4);
2117: fnd_dsql.add_text(' AND adm_doc_status = ');
2118: fnd_dsql.add_bind(p_parameter_5);
2119: fnd_dsql.add_text(' AND org_unit_cd = ');
2120: fnd_dsql.add_bind(p_parameter_6);
2121: fnd_dsql.add_text(' AND person_id = ');

Line 2118: fnd_dsql.add_bind(p_parameter_5);

2114: fnd_dsql.add_bind(l_adm_ci_sequence_number);
2115: fnd_dsql.add_text(' AND adm_process_cat = ');
2116: fnd_dsql.add_bind(p_parameter_4);
2117: fnd_dsql.add_text(' AND adm_doc_status = ');
2118: fnd_dsql.add_bind(p_parameter_5);
2119: fnd_dsql.add_text(' AND org_unit_cd = ');
2120: fnd_dsql.add_bind(p_parameter_6);
2121: fnd_dsql.add_text(' AND person_id = ');
2122: fnd_dsql.add_bind(l_parameter_7);

Line 2119: fnd_dsql.add_text(' AND org_unit_cd = ');

2115: fnd_dsql.add_text(' AND adm_process_cat = ');
2116: fnd_dsql.add_bind(p_parameter_4);
2117: fnd_dsql.add_text(' AND adm_doc_status = ');
2118: fnd_dsql.add_bind(p_parameter_5);
2119: fnd_dsql.add_text(' AND org_unit_cd = ');
2120: fnd_dsql.add_bind(p_parameter_6);
2121: fnd_dsql.add_text(' AND person_id = ');
2122: fnd_dsql.add_bind(l_parameter_7);
2123: fnd_dsql.add_text(' AND adm_appl_number = ');

Line 2120: fnd_dsql.add_bind(p_parameter_6);

2116: fnd_dsql.add_bind(p_parameter_4);
2117: fnd_dsql.add_text(' AND adm_doc_status = ');
2118: fnd_dsql.add_bind(p_parameter_5);
2119: fnd_dsql.add_text(' AND org_unit_cd = ');
2120: fnd_dsql.add_bind(p_parameter_6);
2121: fnd_dsql.add_text(' AND person_id = ');
2122: fnd_dsql.add_bind(l_parameter_7);
2123: fnd_dsql.add_text(' AND adm_appl_number = ');
2124: fnd_dsql.add_bind(l_parameter_8);

Line 2121: fnd_dsql.add_text(' AND person_id = ');

2117: fnd_dsql.add_text(' AND adm_doc_status = ');
2118: fnd_dsql.add_bind(p_parameter_5);
2119: fnd_dsql.add_text(' AND org_unit_cd = ');
2120: fnd_dsql.add_bind(p_parameter_6);
2121: fnd_dsql.add_text(' AND person_id = ');
2122: fnd_dsql.add_bind(l_parameter_7);
2123: fnd_dsql.add_text(' AND adm_appl_number = ');
2124: fnd_dsql.add_bind(l_parameter_8);
2125: fnd_dsql.add_text(' AND nominated_course_cd = ');

Line 2122: fnd_dsql.add_bind(l_parameter_7);

2118: fnd_dsql.add_bind(p_parameter_5);
2119: fnd_dsql.add_text(' AND org_unit_cd = ');
2120: fnd_dsql.add_bind(p_parameter_6);
2121: fnd_dsql.add_text(' AND person_id = ');
2122: fnd_dsql.add_bind(l_parameter_7);
2123: fnd_dsql.add_text(' AND adm_appl_number = ');
2124: fnd_dsql.add_bind(l_parameter_8);
2125: fnd_dsql.add_text(' AND nominated_course_cd = ');
2126: fnd_dsql.add_bind(l_parameter_9);

Line 2123: fnd_dsql.add_text(' AND adm_appl_number = ');

2119: fnd_dsql.add_text(' AND org_unit_cd = ');
2120: fnd_dsql.add_bind(p_parameter_6);
2121: fnd_dsql.add_text(' AND person_id = ');
2122: fnd_dsql.add_bind(l_parameter_7);
2123: fnd_dsql.add_text(' AND adm_appl_number = ');
2124: fnd_dsql.add_bind(l_parameter_8);
2125: fnd_dsql.add_text(' AND nominated_course_cd = ');
2126: fnd_dsql.add_bind(l_parameter_9);
2127: fnd_dsql.add_text(' AND appl_sequence_number = ');

Line 2124: fnd_dsql.add_bind(l_parameter_8);

2120: fnd_dsql.add_bind(p_parameter_6);
2121: fnd_dsql.add_text(' AND person_id = ');
2122: fnd_dsql.add_bind(l_parameter_7);
2123: fnd_dsql.add_text(' AND adm_appl_number = ');
2124: fnd_dsql.add_bind(l_parameter_8);
2125: fnd_dsql.add_text(' AND nominated_course_cd = ');
2126: fnd_dsql.add_bind(l_parameter_9);
2127: fnd_dsql.add_text(' AND appl_sequence_number = ');
2128: fnd_dsql.add_bind(l_parameter_10);

Line 2125: fnd_dsql.add_text(' AND nominated_course_cd = ');

2121: fnd_dsql.add_text(' AND person_id = ');
2122: fnd_dsql.add_bind(l_parameter_7);
2123: fnd_dsql.add_text(' AND adm_appl_number = ');
2124: fnd_dsql.add_bind(l_parameter_8);
2125: fnd_dsql.add_text(' AND nominated_course_cd = ');
2126: fnd_dsql.add_bind(l_parameter_9);
2127: fnd_dsql.add_text(' AND appl_sequence_number = ');
2128: fnd_dsql.add_bind(l_parameter_10);
2129: END IF;

Line 2126: fnd_dsql.add_bind(l_parameter_9);

2122: fnd_dsql.add_bind(l_parameter_7);
2123: fnd_dsql.add_text(' AND adm_appl_number = ');
2124: fnd_dsql.add_bind(l_parameter_8);
2125: fnd_dsql.add_text(' AND nominated_course_cd = ');
2126: fnd_dsql.add_bind(l_parameter_9);
2127: fnd_dsql.add_text(' AND appl_sequence_number = ');
2128: fnd_dsql.add_bind(l_parameter_10);
2129: END IF;
2130: ELSIF P_SYS_LTR_CODE = 'ADFUTSE' THEN

Line 2127: fnd_dsql.add_text(' AND appl_sequence_number = ');

2123: fnd_dsql.add_text(' AND adm_appl_number = ');
2124: fnd_dsql.add_bind(l_parameter_8);
2125: fnd_dsql.add_text(' AND nominated_course_cd = ');
2126: fnd_dsql.add_bind(l_parameter_9);
2127: fnd_dsql.add_text(' AND appl_sequence_number = ');
2128: fnd_dsql.add_bind(l_parameter_10);
2129: END IF;
2130: ELSIF P_SYS_LTR_CODE = 'ADFUTSE' THEN
2131: IF p_parameter_1 IS NOT NULL THEN

Line 2128: fnd_dsql.add_bind(l_parameter_10);

2124: fnd_dsql.add_bind(l_parameter_8);
2125: fnd_dsql.add_text(' AND nominated_course_cd = ');
2126: fnd_dsql.add_bind(l_parameter_9);
2127: fnd_dsql.add_text(' AND appl_sequence_number = ');
2128: fnd_dsql.add_bind(l_parameter_10);
2129: END IF;
2130: ELSIF P_SYS_LTR_CODE = 'ADFUTSE' THEN
2131: IF p_parameter_1 IS NOT NULL THEN
2132: fnd_dsql.add_text(' 1=1 ' );

Line 2132: fnd_dsql.add_text(' 1=1 ' );

2128: fnd_dsql.add_bind(l_parameter_10);
2129: END IF;
2130: ELSIF P_SYS_LTR_CODE = 'ADFUTSE' THEN
2131: IF p_parameter_1 IS NOT NULL THEN
2132: fnd_dsql.add_text(' 1=1 ' );
2133: ELSE
2134: fnd_dsql.add_text(' acad_cal_type = ');
2135: fnd_dsql.add_bind(l_acad_cal_type);
2136: fnd_dsql.add_text(' AND acad_ci_sequence_number = ');

Line 2134: fnd_dsql.add_text(' acad_cal_type = ');

2130: ELSIF P_SYS_LTR_CODE = 'ADFUTSE' THEN
2131: IF p_parameter_1 IS NOT NULL THEN
2132: fnd_dsql.add_text(' 1=1 ' );
2133: ELSE
2134: fnd_dsql.add_text(' acad_cal_type = ');
2135: fnd_dsql.add_bind(l_acad_cal_type);
2136: fnd_dsql.add_text(' AND acad_ci_sequence_number = ');
2137: fnd_dsql.add_bind(l_acad_ci_sequence_number);
2138: fnd_dsql.add_text(' AND adm_cal_type = ');

Line 2135: fnd_dsql.add_bind(l_acad_cal_type);

2131: IF p_parameter_1 IS NOT NULL THEN
2132: fnd_dsql.add_text(' 1=1 ' );
2133: ELSE
2134: fnd_dsql.add_text(' acad_cal_type = ');
2135: fnd_dsql.add_bind(l_acad_cal_type);
2136: fnd_dsql.add_text(' AND acad_ci_sequence_number = ');
2137: fnd_dsql.add_bind(l_acad_ci_sequence_number);
2138: fnd_dsql.add_text(' AND adm_cal_type = ');
2139: fnd_dsql.add_bind(l_adm_cal_type);

Line 2136: fnd_dsql.add_text(' AND acad_ci_sequence_number = ');

2132: fnd_dsql.add_text(' 1=1 ' );
2133: ELSE
2134: fnd_dsql.add_text(' acad_cal_type = ');
2135: fnd_dsql.add_bind(l_acad_cal_type);
2136: fnd_dsql.add_text(' AND acad_ci_sequence_number = ');
2137: fnd_dsql.add_bind(l_acad_ci_sequence_number);
2138: fnd_dsql.add_text(' AND adm_cal_type = ');
2139: fnd_dsql.add_bind(l_adm_cal_type);
2140: fnd_dsql.add_text(' AND adm_ci_sequence_number = ');

Line 2137: fnd_dsql.add_bind(l_acad_ci_sequence_number);

2133: ELSE
2134: fnd_dsql.add_text(' acad_cal_type = ');
2135: fnd_dsql.add_bind(l_acad_cal_type);
2136: fnd_dsql.add_text(' AND acad_ci_sequence_number = ');
2137: fnd_dsql.add_bind(l_acad_ci_sequence_number);
2138: fnd_dsql.add_text(' AND adm_cal_type = ');
2139: fnd_dsql.add_bind(l_adm_cal_type);
2140: fnd_dsql.add_text(' AND adm_ci_sequence_number = ');
2141: fnd_dsql.add_bind(l_adm_ci_sequence_number);

Line 2138: fnd_dsql.add_text(' AND adm_cal_type = ');

2134: fnd_dsql.add_text(' acad_cal_type = ');
2135: fnd_dsql.add_bind(l_acad_cal_type);
2136: fnd_dsql.add_text(' AND acad_ci_sequence_number = ');
2137: fnd_dsql.add_bind(l_acad_ci_sequence_number);
2138: fnd_dsql.add_text(' AND adm_cal_type = ');
2139: fnd_dsql.add_bind(l_adm_cal_type);
2140: fnd_dsql.add_text(' AND adm_ci_sequence_number = ');
2141: fnd_dsql.add_bind(l_adm_ci_sequence_number);
2142: fnd_dsql.add_text(' AND admission_process_category = ');

Line 2139: fnd_dsql.add_bind(l_adm_cal_type);

2135: fnd_dsql.add_bind(l_acad_cal_type);
2136: fnd_dsql.add_text(' AND acad_ci_sequence_number = ');
2137: fnd_dsql.add_bind(l_acad_ci_sequence_number);
2138: fnd_dsql.add_text(' AND adm_cal_type = ');
2139: fnd_dsql.add_bind(l_adm_cal_type);
2140: fnd_dsql.add_text(' AND adm_ci_sequence_number = ');
2141: fnd_dsql.add_bind(l_adm_ci_sequence_number);
2142: fnd_dsql.add_text(' AND admission_process_category = ');
2143: fnd_dsql.add_bind(p_parameter_4);

Line 2140: fnd_dsql.add_text(' AND adm_ci_sequence_number = ');

2136: fnd_dsql.add_text(' AND acad_ci_sequence_number = ');
2137: fnd_dsql.add_bind(l_acad_ci_sequence_number);
2138: fnd_dsql.add_text(' AND adm_cal_type = ');
2139: fnd_dsql.add_bind(l_adm_cal_type);
2140: fnd_dsql.add_text(' AND adm_ci_sequence_number = ');
2141: fnd_dsql.add_bind(l_adm_ci_sequence_number);
2142: fnd_dsql.add_text(' AND admission_process_category = ');
2143: fnd_dsql.add_bind(p_parameter_4);
2144: fnd_dsql.add_text(' AND TRUNC(appl_dt) >= TRUNC(igs_ge_date.igsdate(');

Line 2141: fnd_dsql.add_bind(l_adm_ci_sequence_number);

2137: fnd_dsql.add_bind(l_acad_ci_sequence_number);
2138: fnd_dsql.add_text(' AND adm_cal_type = ');
2139: fnd_dsql.add_bind(l_adm_cal_type);
2140: fnd_dsql.add_text(' AND adm_ci_sequence_number = ');
2141: fnd_dsql.add_bind(l_adm_ci_sequence_number);
2142: fnd_dsql.add_text(' AND admission_process_category = ');
2143: fnd_dsql.add_bind(p_parameter_4);
2144: fnd_dsql.add_text(' AND TRUNC(appl_dt) >= TRUNC(igs_ge_date.igsdate(');
2145: fnd_dsql.add_bind(p_parameter_5);

Line 2142: fnd_dsql.add_text(' AND admission_process_category = ');

2138: fnd_dsql.add_text(' AND adm_cal_type = ');
2139: fnd_dsql.add_bind(l_adm_cal_type);
2140: fnd_dsql.add_text(' AND adm_ci_sequence_number = ');
2141: fnd_dsql.add_bind(l_adm_ci_sequence_number);
2142: fnd_dsql.add_text(' AND admission_process_category = ');
2143: fnd_dsql.add_bind(p_parameter_4);
2144: fnd_dsql.add_text(' AND TRUNC(appl_dt) >= TRUNC(igs_ge_date.igsdate(');
2145: fnd_dsql.add_bind(p_parameter_5);
2146: fnd_dsql.add_text(' )) AND TRUNC(appl_dt) <= TRUNC(igs_ge_date.igsdate(');

Line 2143: fnd_dsql.add_bind(p_parameter_4);

2139: fnd_dsql.add_bind(l_adm_cal_type);
2140: fnd_dsql.add_text(' AND adm_ci_sequence_number = ');
2141: fnd_dsql.add_bind(l_adm_ci_sequence_number);
2142: fnd_dsql.add_text(' AND admission_process_category = ');
2143: fnd_dsql.add_bind(p_parameter_4);
2144: fnd_dsql.add_text(' AND TRUNC(appl_dt) >= TRUNC(igs_ge_date.igsdate(');
2145: fnd_dsql.add_bind(p_parameter_5);
2146: fnd_dsql.add_text(' )) AND TRUNC(appl_dt) <= TRUNC(igs_ge_date.igsdate(');
2147: fnd_dsql.add_bind(p_parameter_6);

Line 2144: fnd_dsql.add_text(' AND TRUNC(appl_dt) >= TRUNC(igs_ge_date.igsdate(');

2140: fnd_dsql.add_text(' AND adm_ci_sequence_number = ');
2141: fnd_dsql.add_bind(l_adm_ci_sequence_number);
2142: fnd_dsql.add_text(' AND admission_process_category = ');
2143: fnd_dsql.add_bind(p_parameter_4);
2144: fnd_dsql.add_text(' AND TRUNC(appl_dt) >= TRUNC(igs_ge_date.igsdate(');
2145: fnd_dsql.add_bind(p_parameter_5);
2146: fnd_dsql.add_text(' )) AND TRUNC(appl_dt) <= TRUNC(igs_ge_date.igsdate(');
2147: fnd_dsql.add_bind(p_parameter_6);
2148: fnd_dsql.add_text(' )) AND admission_outcome_status = ');

Line 2145: fnd_dsql.add_bind(p_parameter_5);

2141: fnd_dsql.add_bind(l_adm_ci_sequence_number);
2142: fnd_dsql.add_text(' AND admission_process_category = ');
2143: fnd_dsql.add_bind(p_parameter_4);
2144: fnd_dsql.add_text(' AND TRUNC(appl_dt) >= TRUNC(igs_ge_date.igsdate(');
2145: fnd_dsql.add_bind(p_parameter_5);
2146: fnd_dsql.add_text(' )) AND TRUNC(appl_dt) <= TRUNC(igs_ge_date.igsdate(');
2147: fnd_dsql.add_bind(p_parameter_6);
2148: fnd_dsql.add_text(' )) AND admission_outcome_status = ');
2149: fnd_dsql.add_bind(p_parameter_7);

Line 2146: fnd_dsql.add_text(' )) AND TRUNC(appl_dt) <= TRUNC(igs_ge_date.igsdate(');

2142: fnd_dsql.add_text(' AND admission_process_category = ');
2143: fnd_dsql.add_bind(p_parameter_4);
2144: fnd_dsql.add_text(' AND TRUNC(appl_dt) >= TRUNC(igs_ge_date.igsdate(');
2145: fnd_dsql.add_bind(p_parameter_5);
2146: fnd_dsql.add_text(' )) AND TRUNC(appl_dt) <= TRUNC(igs_ge_date.igsdate(');
2147: fnd_dsql.add_bind(p_parameter_6);
2148: fnd_dsql.add_text(' )) AND admission_outcome_status = ');
2149: fnd_dsql.add_bind(p_parameter_7);
2150: END IF;

Line 2147: fnd_dsql.add_bind(p_parameter_6);

2143: fnd_dsql.add_bind(p_parameter_4);
2144: fnd_dsql.add_text(' AND TRUNC(appl_dt) >= TRUNC(igs_ge_date.igsdate(');
2145: fnd_dsql.add_bind(p_parameter_5);
2146: fnd_dsql.add_text(' )) AND TRUNC(appl_dt) <= TRUNC(igs_ge_date.igsdate(');
2147: fnd_dsql.add_bind(p_parameter_6);
2148: fnd_dsql.add_text(' )) AND admission_outcome_status = ');
2149: fnd_dsql.add_bind(p_parameter_7);
2150: END IF;
2151: ELSIF P_SYS_LTR_CODE = 'ADMFTSA' THEN

Line 2148: fnd_dsql.add_text(' )) AND admission_outcome_status = ');

2144: fnd_dsql.add_text(' AND TRUNC(appl_dt) >= TRUNC(igs_ge_date.igsdate(');
2145: fnd_dsql.add_bind(p_parameter_5);
2146: fnd_dsql.add_text(' )) AND TRUNC(appl_dt) <= TRUNC(igs_ge_date.igsdate(');
2147: fnd_dsql.add_bind(p_parameter_6);
2148: fnd_dsql.add_text(' )) AND admission_outcome_status = ');
2149: fnd_dsql.add_bind(p_parameter_7);
2150: END IF;
2151: ELSIF P_SYS_LTR_CODE = 'ADMFTSA' THEN
2152: IF p_parameter_1 IS NOT NULL THEN

Line 2149: fnd_dsql.add_bind(p_parameter_7);

2145: fnd_dsql.add_bind(p_parameter_5);
2146: fnd_dsql.add_text(' )) AND TRUNC(appl_dt) <= TRUNC(igs_ge_date.igsdate(');
2147: fnd_dsql.add_bind(p_parameter_6);
2148: fnd_dsql.add_text(' )) AND admission_outcome_status = ');
2149: fnd_dsql.add_bind(p_parameter_7);
2150: END IF;
2151: ELSIF P_SYS_LTR_CODE = 'ADMFTSA' THEN
2152: IF p_parameter_1 IS NOT NULL THEN
2153: fnd_dsql.add_text(' 1=1 ' );

Line 2153: fnd_dsql.add_text(' 1=1 ' );

2149: fnd_dsql.add_bind(p_parameter_7);
2150: END IF;
2151: ELSIF P_SYS_LTR_CODE = 'ADMFTSA' THEN
2152: IF p_parameter_1 IS NOT NULL THEN
2153: fnd_dsql.add_text(' 1=1 ' );
2154: ELSE
2155: fnd_dsql.add_text(' acad_cal_type = ');
2156: fnd_dsql.add_bind(l_acad_cal_type);
2157: fnd_dsql.add_text(' AND acad_ci_sequence_number = ');

Line 2155: fnd_dsql.add_text(' acad_cal_type = ');

2151: ELSIF P_SYS_LTR_CODE = 'ADMFTSA' THEN
2152: IF p_parameter_1 IS NOT NULL THEN
2153: fnd_dsql.add_text(' 1=1 ' );
2154: ELSE
2155: fnd_dsql.add_text(' acad_cal_type = ');
2156: fnd_dsql.add_bind(l_acad_cal_type);
2157: fnd_dsql.add_text(' AND acad_ci_sequence_number = ');
2158: fnd_dsql.add_bind(l_acad_ci_sequence_number);
2159: fnd_dsql.add_text(' AND adm_cal_type = ');

Line 2156: fnd_dsql.add_bind(l_acad_cal_type);

2152: IF p_parameter_1 IS NOT NULL THEN
2153: fnd_dsql.add_text(' 1=1 ' );
2154: ELSE
2155: fnd_dsql.add_text(' acad_cal_type = ');
2156: fnd_dsql.add_bind(l_acad_cal_type);
2157: fnd_dsql.add_text(' AND acad_ci_sequence_number = ');
2158: fnd_dsql.add_bind(l_acad_ci_sequence_number);
2159: fnd_dsql.add_text(' AND adm_cal_type = ');
2160: fnd_dsql.add_bind(l_adm_cal_type);

Line 2157: fnd_dsql.add_text(' AND acad_ci_sequence_number = ');

2153: fnd_dsql.add_text(' 1=1 ' );
2154: ELSE
2155: fnd_dsql.add_text(' acad_cal_type = ');
2156: fnd_dsql.add_bind(l_acad_cal_type);
2157: fnd_dsql.add_text(' AND acad_ci_sequence_number = ');
2158: fnd_dsql.add_bind(l_acad_ci_sequence_number);
2159: fnd_dsql.add_text(' AND adm_cal_type = ');
2160: fnd_dsql.add_bind(l_adm_cal_type);
2161: fnd_dsql.add_text(' AND adm_ci_sequence_number = ');

Line 2158: fnd_dsql.add_bind(l_acad_ci_sequence_number);

2154: ELSE
2155: fnd_dsql.add_text(' acad_cal_type = ');
2156: fnd_dsql.add_bind(l_acad_cal_type);
2157: fnd_dsql.add_text(' AND acad_ci_sequence_number = ');
2158: fnd_dsql.add_bind(l_acad_ci_sequence_number);
2159: fnd_dsql.add_text(' AND adm_cal_type = ');
2160: fnd_dsql.add_bind(l_adm_cal_type);
2161: fnd_dsql.add_text(' AND adm_ci_sequence_number = ');
2162: fnd_dsql.add_bind(l_adm_ci_sequence_number);

Line 2159: fnd_dsql.add_text(' AND adm_cal_type = ');

2155: fnd_dsql.add_text(' acad_cal_type = ');
2156: fnd_dsql.add_bind(l_acad_cal_type);
2157: fnd_dsql.add_text(' AND acad_ci_sequence_number = ');
2158: fnd_dsql.add_bind(l_acad_ci_sequence_number);
2159: fnd_dsql.add_text(' AND adm_cal_type = ');
2160: fnd_dsql.add_bind(l_adm_cal_type);
2161: fnd_dsql.add_text(' AND adm_ci_sequence_number = ');
2162: fnd_dsql.add_bind(l_adm_ci_sequence_number);
2163: fnd_dsql.add_text(' AND admission_process_category = ');

Line 2160: fnd_dsql.add_bind(l_adm_cal_type);

2156: fnd_dsql.add_bind(l_acad_cal_type);
2157: fnd_dsql.add_text(' AND acad_ci_sequence_number = ');
2158: fnd_dsql.add_bind(l_acad_ci_sequence_number);
2159: fnd_dsql.add_text(' AND adm_cal_type = ');
2160: fnd_dsql.add_bind(l_adm_cal_type);
2161: fnd_dsql.add_text(' AND adm_ci_sequence_number = ');
2162: fnd_dsql.add_bind(l_adm_ci_sequence_number);
2163: fnd_dsql.add_text(' AND admission_process_category = ');
2164: fnd_dsql.add_bind(p_parameter_4);

Line 2161: fnd_dsql.add_text(' AND adm_ci_sequence_number = ');

2157: fnd_dsql.add_text(' AND acad_ci_sequence_number = ');
2158: fnd_dsql.add_bind(l_acad_ci_sequence_number);
2159: fnd_dsql.add_text(' AND adm_cal_type = ');
2160: fnd_dsql.add_bind(l_adm_cal_type);
2161: fnd_dsql.add_text(' AND adm_ci_sequence_number = ');
2162: fnd_dsql.add_bind(l_adm_ci_sequence_number);
2163: fnd_dsql.add_text(' AND admission_process_category = ');
2164: fnd_dsql.add_bind(p_parameter_4);
2165: fnd_dsql.add_text(' AND TRUNC(appl_dt) >= TRUNC(igs_ge_date.igsdate(');

Line 2162: fnd_dsql.add_bind(l_adm_ci_sequence_number);

2158: fnd_dsql.add_bind(l_acad_ci_sequence_number);
2159: fnd_dsql.add_text(' AND adm_cal_type = ');
2160: fnd_dsql.add_bind(l_adm_cal_type);
2161: fnd_dsql.add_text(' AND adm_ci_sequence_number = ');
2162: fnd_dsql.add_bind(l_adm_ci_sequence_number);
2163: fnd_dsql.add_text(' AND admission_process_category = ');
2164: fnd_dsql.add_bind(p_parameter_4);
2165: fnd_dsql.add_text(' AND TRUNC(appl_dt) >= TRUNC(igs_ge_date.igsdate(');
2166: fnd_dsql.add_bind(p_parameter_5);

Line 2163: fnd_dsql.add_text(' AND admission_process_category = ');

2159: fnd_dsql.add_text(' AND adm_cal_type = ');
2160: fnd_dsql.add_bind(l_adm_cal_type);
2161: fnd_dsql.add_text(' AND adm_ci_sequence_number = ');
2162: fnd_dsql.add_bind(l_adm_ci_sequence_number);
2163: fnd_dsql.add_text(' AND admission_process_category = ');
2164: fnd_dsql.add_bind(p_parameter_4);
2165: fnd_dsql.add_text(' AND TRUNC(appl_dt) >= TRUNC(igs_ge_date.igsdate(');
2166: fnd_dsql.add_bind(p_parameter_5);
2167: fnd_dsql.add_text(' )) AND TRUNC(appl_dt) <= TRUNC(igs_ge_date.igsdate(');

Line 2164: fnd_dsql.add_bind(p_parameter_4);

2160: fnd_dsql.add_bind(l_adm_cal_type);
2161: fnd_dsql.add_text(' AND adm_ci_sequence_number = ');
2162: fnd_dsql.add_bind(l_adm_ci_sequence_number);
2163: fnd_dsql.add_text(' AND admission_process_category = ');
2164: fnd_dsql.add_bind(p_parameter_4);
2165: fnd_dsql.add_text(' AND TRUNC(appl_dt) >= TRUNC(igs_ge_date.igsdate(');
2166: fnd_dsql.add_bind(p_parameter_5);
2167: fnd_dsql.add_text(' )) AND TRUNC(appl_dt) <= TRUNC(igs_ge_date.igsdate(');
2168: fnd_dsql.add_bind(p_parameter_6);

Line 2165: fnd_dsql.add_text(' AND TRUNC(appl_dt) >= TRUNC(igs_ge_date.igsdate(');

2161: fnd_dsql.add_text(' AND adm_ci_sequence_number = ');
2162: fnd_dsql.add_bind(l_adm_ci_sequence_number);
2163: fnd_dsql.add_text(' AND admission_process_category = ');
2164: fnd_dsql.add_bind(p_parameter_4);
2165: fnd_dsql.add_text(' AND TRUNC(appl_dt) >= TRUNC(igs_ge_date.igsdate(');
2166: fnd_dsql.add_bind(p_parameter_5);
2167: fnd_dsql.add_text(' )) AND TRUNC(appl_dt) <= TRUNC(igs_ge_date.igsdate(');
2168: fnd_dsql.add_bind(p_parameter_6);
2169: fnd_dsql.add_text(' )) AND admission_outcome_status = ');

Line 2166: fnd_dsql.add_bind(p_parameter_5);

2162: fnd_dsql.add_bind(l_adm_ci_sequence_number);
2163: fnd_dsql.add_text(' AND admission_process_category = ');
2164: fnd_dsql.add_bind(p_parameter_4);
2165: fnd_dsql.add_text(' AND TRUNC(appl_dt) >= TRUNC(igs_ge_date.igsdate(');
2166: fnd_dsql.add_bind(p_parameter_5);
2167: fnd_dsql.add_text(' )) AND TRUNC(appl_dt) <= TRUNC(igs_ge_date.igsdate(');
2168: fnd_dsql.add_bind(p_parameter_6);
2169: fnd_dsql.add_text(' )) AND admission_outcome_status = ');
2170: fnd_dsql.add_bind(p_parameter_7);

Line 2167: fnd_dsql.add_text(' )) AND TRUNC(appl_dt) <= TRUNC(igs_ge_date.igsdate(');

2163: fnd_dsql.add_text(' AND admission_process_category = ');
2164: fnd_dsql.add_bind(p_parameter_4);
2165: fnd_dsql.add_text(' AND TRUNC(appl_dt) >= TRUNC(igs_ge_date.igsdate(');
2166: fnd_dsql.add_bind(p_parameter_5);
2167: fnd_dsql.add_text(' )) AND TRUNC(appl_dt) <= TRUNC(igs_ge_date.igsdate(');
2168: fnd_dsql.add_bind(p_parameter_6);
2169: fnd_dsql.add_text(' )) AND admission_outcome_status = ');
2170: fnd_dsql.add_bind(p_parameter_7);
2171: END IF;

Line 2168: fnd_dsql.add_bind(p_parameter_6);

2164: fnd_dsql.add_bind(p_parameter_4);
2165: fnd_dsql.add_text(' AND TRUNC(appl_dt) >= TRUNC(igs_ge_date.igsdate(');
2166: fnd_dsql.add_bind(p_parameter_5);
2167: fnd_dsql.add_text(' )) AND TRUNC(appl_dt) <= TRUNC(igs_ge_date.igsdate(');
2168: fnd_dsql.add_bind(p_parameter_6);
2169: fnd_dsql.add_text(' )) AND admission_outcome_status = ');
2170: fnd_dsql.add_bind(p_parameter_7);
2171: END IF;
2172: ELSIF P_SYS_LTR_CODE = 'ADNORSP' THEN

Line 2169: fnd_dsql.add_text(' )) AND admission_outcome_status = ');

2165: fnd_dsql.add_text(' AND TRUNC(appl_dt) >= TRUNC(igs_ge_date.igsdate(');
2166: fnd_dsql.add_bind(p_parameter_5);
2167: fnd_dsql.add_text(' )) AND TRUNC(appl_dt) <= TRUNC(igs_ge_date.igsdate(');
2168: fnd_dsql.add_bind(p_parameter_6);
2169: fnd_dsql.add_text(' )) AND admission_outcome_status = ');
2170: fnd_dsql.add_bind(p_parameter_7);
2171: END IF;
2172: ELSIF P_SYS_LTR_CODE = 'ADNORSP' THEN
2173: IF p_parameter_1 IS NOT NULL THEN

Line 2170: fnd_dsql.add_bind(p_parameter_7);

2166: fnd_dsql.add_bind(p_parameter_5);
2167: fnd_dsql.add_text(' )) AND TRUNC(appl_dt) <= TRUNC(igs_ge_date.igsdate(');
2168: fnd_dsql.add_bind(p_parameter_6);
2169: fnd_dsql.add_text(' )) AND admission_outcome_status = ');
2170: fnd_dsql.add_bind(p_parameter_7);
2171: END IF;
2172: ELSIF P_SYS_LTR_CODE = 'ADNORSP' THEN
2173: IF p_parameter_1 IS NOT NULL THEN
2174: -- person id group if dynamic will not be available.

Line 2176: fnd_dsql.add_text(' 1=1');

2172: ELSIF P_SYS_LTR_CODE = 'ADNORSP' THEN
2173: IF p_parameter_1 IS NOT NULL THEN
2174: -- person id group if dynamic will not be available.
2175: -- all persons in the group already resolved in the build_sql
2176: fnd_dsql.add_text(' 1=1');
2177: ELSE
2178: --** proc level logging.
2179: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
2180:

Line 2190: fnd_dsql.add_text(' acad_cal_type = ');

2186:
2187: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
2188: END IF;
2189: --**
2190: fnd_dsql.add_text(' acad_cal_type = ');
2191: fnd_dsql.add_bind(l_acad_cal_type);
2192: fnd_dsql.add_text(' AND acad_ci_sequence_number = ');
2193: fnd_dsql.add_bind(l_acad_ci_sequence_number);
2194: fnd_dsql.add_text(' AND adm_cal_type = ');

Line 2191: fnd_dsql.add_bind(l_acad_cal_type);

2187: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
2188: END IF;
2189: --**
2190: fnd_dsql.add_text(' acad_cal_type = ');
2191: fnd_dsql.add_bind(l_acad_cal_type);
2192: fnd_dsql.add_text(' AND acad_ci_sequence_number = ');
2193: fnd_dsql.add_bind(l_acad_ci_sequence_number);
2194: fnd_dsql.add_text(' AND adm_cal_type = ');
2195: fnd_dsql.add_bind(l_adm_cal_type);

Line 2192: fnd_dsql.add_text(' AND acad_ci_sequence_number = ');

2188: END IF;
2189: --**
2190: fnd_dsql.add_text(' acad_cal_type = ');
2191: fnd_dsql.add_bind(l_acad_cal_type);
2192: fnd_dsql.add_text(' AND acad_ci_sequence_number = ');
2193: fnd_dsql.add_bind(l_acad_ci_sequence_number);
2194: fnd_dsql.add_text(' AND adm_cal_type = ');
2195: fnd_dsql.add_bind(l_adm_cal_type);
2196: fnd_dsql.add_text(' AND adm_ci_sequence_number = ');

Line 2193: fnd_dsql.add_bind(l_acad_ci_sequence_number);

2189: --**
2190: fnd_dsql.add_text(' acad_cal_type = ');
2191: fnd_dsql.add_bind(l_acad_cal_type);
2192: fnd_dsql.add_text(' AND acad_ci_sequence_number = ');
2193: fnd_dsql.add_bind(l_acad_ci_sequence_number);
2194: fnd_dsql.add_text(' AND adm_cal_type = ');
2195: fnd_dsql.add_bind(l_adm_cal_type);
2196: fnd_dsql.add_text(' AND adm_ci_sequence_number = ');
2197: fnd_dsql.add_bind(l_adm_ci_sequence_number);

Line 2194: fnd_dsql.add_text(' AND adm_cal_type = ');

2190: fnd_dsql.add_text(' acad_cal_type = ');
2191: fnd_dsql.add_bind(l_acad_cal_type);
2192: fnd_dsql.add_text(' AND acad_ci_sequence_number = ');
2193: fnd_dsql.add_bind(l_acad_ci_sequence_number);
2194: fnd_dsql.add_text(' AND adm_cal_type = ');
2195: fnd_dsql.add_bind(l_adm_cal_type);
2196: fnd_dsql.add_text(' AND adm_ci_sequence_number = ');
2197: fnd_dsql.add_bind(l_adm_ci_sequence_number);
2198: fnd_dsql.add_text(' AND admission_process_category = ');

Line 2195: fnd_dsql.add_bind(l_adm_cal_type);

2191: fnd_dsql.add_bind(l_acad_cal_type);
2192: fnd_dsql.add_text(' AND acad_ci_sequence_number = ');
2193: fnd_dsql.add_bind(l_acad_ci_sequence_number);
2194: fnd_dsql.add_text(' AND adm_cal_type = ');
2195: fnd_dsql.add_bind(l_adm_cal_type);
2196: fnd_dsql.add_text(' AND adm_ci_sequence_number = ');
2197: fnd_dsql.add_bind(l_adm_ci_sequence_number);
2198: fnd_dsql.add_text(' AND admission_process_category = ');
2199: fnd_dsql.add_bind(p_parameter_4);

Line 2196: fnd_dsql.add_text(' AND adm_ci_sequence_number = ');

2192: fnd_dsql.add_text(' AND acad_ci_sequence_number = ');
2193: fnd_dsql.add_bind(l_acad_ci_sequence_number);
2194: fnd_dsql.add_text(' AND adm_cal_type = ');
2195: fnd_dsql.add_bind(l_adm_cal_type);
2196: fnd_dsql.add_text(' AND adm_ci_sequence_number = ');
2197: fnd_dsql.add_bind(l_adm_ci_sequence_number);
2198: fnd_dsql.add_text(' AND admission_process_category = ');
2199: fnd_dsql.add_bind(p_parameter_4);
2200: fnd_dsql.add_text(' AND course_cd = ');

Line 2197: fnd_dsql.add_bind(l_adm_ci_sequence_number);

2193: fnd_dsql.add_bind(l_acad_ci_sequence_number);
2194: fnd_dsql.add_text(' AND adm_cal_type = ');
2195: fnd_dsql.add_bind(l_adm_cal_type);
2196: fnd_dsql.add_text(' AND adm_ci_sequence_number = ');
2197: fnd_dsql.add_bind(l_adm_ci_sequence_number);
2198: fnd_dsql.add_text(' AND admission_process_category = ');
2199: fnd_dsql.add_bind(p_parameter_4);
2200: fnd_dsql.add_text(' AND course_cd = ');
2201: fnd_dsql.add_bind(p_parameter_5);

Line 2198: fnd_dsql.add_text(' AND admission_process_category = ');

2194: fnd_dsql.add_text(' AND adm_cal_type = ');
2195: fnd_dsql.add_bind(l_adm_cal_type);
2196: fnd_dsql.add_text(' AND adm_ci_sequence_number = ');
2197: fnd_dsql.add_bind(l_adm_ci_sequence_number);
2198: fnd_dsql.add_text(' AND admission_process_category = ');
2199: fnd_dsql.add_bind(p_parameter_4);
2200: fnd_dsql.add_text(' AND course_cd = ');
2201: fnd_dsql.add_bind(p_parameter_5);
2202: fnd_dsql.add_text(' AND location_cd = ');

Line 2199: fnd_dsql.add_bind(p_parameter_4);

2195: fnd_dsql.add_bind(l_adm_cal_type);
2196: fnd_dsql.add_text(' AND adm_ci_sequence_number = ');
2197: fnd_dsql.add_bind(l_adm_ci_sequence_number);
2198: fnd_dsql.add_text(' AND admission_process_category = ');
2199: fnd_dsql.add_bind(p_parameter_4);
2200: fnd_dsql.add_text(' AND course_cd = ');
2201: fnd_dsql.add_bind(p_parameter_5);
2202: fnd_dsql.add_text(' AND location_cd = ');
2203: fnd_dsql.add_bind(p_parameter_6);

Line 2200: fnd_dsql.add_text(' AND course_cd = ');

2196: fnd_dsql.add_text(' AND adm_ci_sequence_number = ');
2197: fnd_dsql.add_bind(l_adm_ci_sequence_number);
2198: fnd_dsql.add_text(' AND admission_process_category = ');
2199: fnd_dsql.add_bind(p_parameter_4);
2200: fnd_dsql.add_text(' AND course_cd = ');
2201: fnd_dsql.add_bind(p_parameter_5);
2202: fnd_dsql.add_text(' AND location_cd = ');
2203: fnd_dsql.add_bind(p_parameter_6);
2204: fnd_dsql.add_text(' AND attendance_mode = ');

Line 2201: fnd_dsql.add_bind(p_parameter_5);

2197: fnd_dsql.add_bind(l_adm_ci_sequence_number);
2198: fnd_dsql.add_text(' AND admission_process_category = ');
2199: fnd_dsql.add_bind(p_parameter_4);
2200: fnd_dsql.add_text(' AND course_cd = ');
2201: fnd_dsql.add_bind(p_parameter_5);
2202: fnd_dsql.add_text(' AND location_cd = ');
2203: fnd_dsql.add_bind(p_parameter_6);
2204: fnd_dsql.add_text(' AND attendance_mode = ');
2205: fnd_dsql.add_bind(p_parameter_7);

Line 2202: fnd_dsql.add_text(' AND location_cd = ');

2198: fnd_dsql.add_text(' AND admission_process_category = ');
2199: fnd_dsql.add_bind(p_parameter_4);
2200: fnd_dsql.add_text(' AND course_cd = ');
2201: fnd_dsql.add_bind(p_parameter_5);
2202: fnd_dsql.add_text(' AND location_cd = ');
2203: fnd_dsql.add_bind(p_parameter_6);
2204: fnd_dsql.add_text(' AND attendance_mode = ');
2205: fnd_dsql.add_bind(p_parameter_7);
2206: fnd_dsql.add_text(' AND attendance_type=');

Line 2203: fnd_dsql.add_bind(p_parameter_6);

2199: fnd_dsql.add_bind(p_parameter_4);
2200: fnd_dsql.add_text(' AND course_cd = ');
2201: fnd_dsql.add_bind(p_parameter_5);
2202: fnd_dsql.add_text(' AND location_cd = ');
2203: fnd_dsql.add_bind(p_parameter_6);
2204: fnd_dsql.add_text(' AND attendance_mode = ');
2205: fnd_dsql.add_bind(p_parameter_7);
2206: fnd_dsql.add_text(' AND attendance_type=');
2207: fnd_dsql.add_bind(p_parameter_9);

Line 2204: fnd_dsql.add_text(' AND attendance_mode = ');

2200: fnd_dsql.add_text(' AND course_cd = ');
2201: fnd_dsql.add_bind(p_parameter_5);
2202: fnd_dsql.add_text(' AND location_cd = ');
2203: fnd_dsql.add_bind(p_parameter_6);
2204: fnd_dsql.add_text(' AND attendance_mode = ');
2205: fnd_dsql.add_bind(p_parameter_7);
2206: fnd_dsql.add_text(' AND attendance_type=');
2207: fnd_dsql.add_bind(p_parameter_9);
2208: END IF;

Line 2205: fnd_dsql.add_bind(p_parameter_7);

2201: fnd_dsql.add_bind(p_parameter_5);
2202: fnd_dsql.add_text(' AND location_cd = ');
2203: fnd_dsql.add_bind(p_parameter_6);
2204: fnd_dsql.add_text(' AND attendance_mode = ');
2205: fnd_dsql.add_bind(p_parameter_7);
2206: fnd_dsql.add_text(' AND attendance_type=');
2207: fnd_dsql.add_bind(p_parameter_9);
2208: END IF;
2209: ELSIF P_SYS_LTR_CODE = 'ADINTRW' THEN

Line 2206: fnd_dsql.add_text(' AND attendance_type=');

2202: fnd_dsql.add_text(' AND location_cd = ');
2203: fnd_dsql.add_bind(p_parameter_6);
2204: fnd_dsql.add_text(' AND attendance_mode = ');
2205: fnd_dsql.add_bind(p_parameter_7);
2206: fnd_dsql.add_text(' AND attendance_type=');
2207: fnd_dsql.add_bind(p_parameter_9);
2208: END IF;
2209: ELSIF P_SYS_LTR_CODE = 'ADINTRW' THEN
2210: IF p_parameter_1 IS NOT NULL THEN

Line 2207: fnd_dsql.add_bind(p_parameter_9);

2203: fnd_dsql.add_bind(p_parameter_6);
2204: fnd_dsql.add_text(' AND attendance_mode = ');
2205: fnd_dsql.add_bind(p_parameter_7);
2206: fnd_dsql.add_text(' AND attendance_type=');
2207: fnd_dsql.add_bind(p_parameter_9);
2208: END IF;
2209: ELSIF P_SYS_LTR_CODE = 'ADINTRW' THEN
2210: IF p_parameter_1 IS NOT NULL THEN
2211: -- person id group if dynamic will not be available.

Line 2213: fnd_dsql.add_text(' 1=1');

2209: ELSIF P_SYS_LTR_CODE = 'ADINTRW' THEN
2210: IF p_parameter_1 IS NOT NULL THEN
2211: -- person id group if dynamic will not be available.
2212: -- all persons in the group already resolved in the build_sql
2213: fnd_dsql.add_text(' 1=1');
2214: ELSE
2215: fnd_dsql.add_text(' acad_cal_type = ');
2216: fnd_dsql.add_bind(l_acad_cal_type);
2217: fnd_dsql.add_text(' AND acad_ci_sequence_number = ');

Line 2215: fnd_dsql.add_text(' acad_cal_type = ');

2211: -- person id group if dynamic will not be available.
2212: -- all persons in the group already resolved in the build_sql
2213: fnd_dsql.add_text(' 1=1');
2214: ELSE
2215: fnd_dsql.add_text(' acad_cal_type = ');
2216: fnd_dsql.add_bind(l_acad_cal_type);
2217: fnd_dsql.add_text(' AND acad_ci_sequence_number = ');
2218: fnd_dsql.add_bind(l_acad_ci_sequence_number);
2219: fnd_dsql.add_text(' AND adm_cal_type = ');

Line 2216: fnd_dsql.add_bind(l_acad_cal_type);

2212: -- all persons in the group already resolved in the build_sql
2213: fnd_dsql.add_text(' 1=1');
2214: ELSE
2215: fnd_dsql.add_text(' acad_cal_type = ');
2216: fnd_dsql.add_bind(l_acad_cal_type);
2217: fnd_dsql.add_text(' AND acad_ci_sequence_number = ');
2218: fnd_dsql.add_bind(l_acad_ci_sequence_number);
2219: fnd_dsql.add_text(' AND adm_cal_type = ');
2220: fnd_dsql.add_bind(l_adm_cal_type);

Line 2217: fnd_dsql.add_text(' AND acad_ci_sequence_number = ');

2213: fnd_dsql.add_text(' 1=1');
2214: ELSE
2215: fnd_dsql.add_text(' acad_cal_type = ');
2216: fnd_dsql.add_bind(l_acad_cal_type);
2217: fnd_dsql.add_text(' AND acad_ci_sequence_number = ');
2218: fnd_dsql.add_bind(l_acad_ci_sequence_number);
2219: fnd_dsql.add_text(' AND adm_cal_type = ');
2220: fnd_dsql.add_bind(l_adm_cal_type);
2221: fnd_dsql.add_text(' AND adm_ci_sequence_number =');

Line 2218: fnd_dsql.add_bind(l_acad_ci_sequence_number);

2214: ELSE
2215: fnd_dsql.add_text(' acad_cal_type = ');
2216: fnd_dsql.add_bind(l_acad_cal_type);
2217: fnd_dsql.add_text(' AND acad_ci_sequence_number = ');
2218: fnd_dsql.add_bind(l_acad_ci_sequence_number);
2219: fnd_dsql.add_text(' AND adm_cal_type = ');
2220: fnd_dsql.add_bind(l_adm_cal_type);
2221: fnd_dsql.add_text(' AND adm_ci_sequence_number =');
2222: fnd_dsql.add_bind(l_adm_ci_sequence_number);

Line 2219: fnd_dsql.add_text(' AND adm_cal_type = ');

2215: fnd_dsql.add_text(' acad_cal_type = ');
2216: fnd_dsql.add_bind(l_acad_cal_type);
2217: fnd_dsql.add_text(' AND acad_ci_sequence_number = ');
2218: fnd_dsql.add_bind(l_acad_ci_sequence_number);
2219: fnd_dsql.add_text(' AND adm_cal_type = ');
2220: fnd_dsql.add_bind(l_adm_cal_type);
2221: fnd_dsql.add_text(' AND adm_ci_sequence_number =');
2222: fnd_dsql.add_bind(l_adm_ci_sequence_number);
2223: fnd_dsql.add_text(' AND admission_process_category =');

Line 2220: fnd_dsql.add_bind(l_adm_cal_type);

2216: fnd_dsql.add_bind(l_acad_cal_type);
2217: fnd_dsql.add_text(' AND acad_ci_sequence_number = ');
2218: fnd_dsql.add_bind(l_acad_ci_sequence_number);
2219: fnd_dsql.add_text(' AND adm_cal_type = ');
2220: fnd_dsql.add_bind(l_adm_cal_type);
2221: fnd_dsql.add_text(' AND adm_ci_sequence_number =');
2222: fnd_dsql.add_bind(l_adm_ci_sequence_number);
2223: fnd_dsql.add_text(' AND admission_process_category =');
2224: fnd_dsql.add_bind(p_parameter_4);

Line 2221: fnd_dsql.add_text(' AND adm_ci_sequence_number =');

2217: fnd_dsql.add_text(' AND acad_ci_sequence_number = ');
2218: fnd_dsql.add_bind(l_acad_ci_sequence_number);
2219: fnd_dsql.add_text(' AND adm_cal_type = ');
2220: fnd_dsql.add_bind(l_adm_cal_type);
2221: fnd_dsql.add_text(' AND adm_ci_sequence_number =');
2222: fnd_dsql.add_bind(l_adm_ci_sequence_number);
2223: fnd_dsql.add_text(' AND admission_process_category =');
2224: fnd_dsql.add_bind(p_parameter_4);
2225: fnd_dsql.add_text(' AND panel_code= ');

Line 2222: fnd_dsql.add_bind(l_adm_ci_sequence_number);

2218: fnd_dsql.add_bind(l_acad_ci_sequence_number);
2219: fnd_dsql.add_text(' AND adm_cal_type = ');
2220: fnd_dsql.add_bind(l_adm_cal_type);
2221: fnd_dsql.add_text(' AND adm_ci_sequence_number =');
2222: fnd_dsql.add_bind(l_adm_ci_sequence_number);
2223: fnd_dsql.add_text(' AND admission_process_category =');
2224: fnd_dsql.add_bind(p_parameter_4);
2225: fnd_dsql.add_text(' AND panel_code= ');
2226: fnd_dsql.add_bind(p_parameter_5);

Line 2223: fnd_dsql.add_text(' AND admission_process_category =');

2219: fnd_dsql.add_text(' AND adm_cal_type = ');
2220: fnd_dsql.add_bind(l_adm_cal_type);
2221: fnd_dsql.add_text(' AND adm_ci_sequence_number =');
2222: fnd_dsql.add_bind(l_adm_ci_sequence_number);
2223: fnd_dsql.add_text(' AND admission_process_category =');
2224: fnd_dsql.add_bind(p_parameter_4);
2225: fnd_dsql.add_text(' AND panel_code= ');
2226: fnd_dsql.add_bind(p_parameter_5);
2227: fnd_dsql.add_text(' AND TRUNC(interview_date) = TRUNC(igs_ge_date.igsdate(');

Line 2224: fnd_dsql.add_bind(p_parameter_4);

2220: fnd_dsql.add_bind(l_adm_cal_type);
2221: fnd_dsql.add_text(' AND adm_ci_sequence_number =');
2222: fnd_dsql.add_bind(l_adm_ci_sequence_number);
2223: fnd_dsql.add_text(' AND admission_process_category =');
2224: fnd_dsql.add_bind(p_parameter_4);
2225: fnd_dsql.add_text(' AND panel_code= ');
2226: fnd_dsql.add_bind(p_parameter_5);
2227: fnd_dsql.add_text(' AND TRUNC(interview_date) = TRUNC(igs_ge_date.igsdate(');
2228: fnd_dsql.add_bind(p_parameter_6);

Line 2225: fnd_dsql.add_text(' AND panel_code= ');

2221: fnd_dsql.add_text(' AND adm_ci_sequence_number =');
2222: fnd_dsql.add_bind(l_adm_ci_sequence_number);
2223: fnd_dsql.add_text(' AND admission_process_category =');
2224: fnd_dsql.add_bind(p_parameter_4);
2225: fnd_dsql.add_text(' AND panel_code= ');
2226: fnd_dsql.add_bind(p_parameter_5);
2227: fnd_dsql.add_text(' AND TRUNC(interview_date) = TRUNC(igs_ge_date.igsdate(');
2228: fnd_dsql.add_bind(p_parameter_6);
2229: fnd_dsql.add_text(' )) AND attendance_mode= ');

Line 2226: fnd_dsql.add_bind(p_parameter_5);

2222: fnd_dsql.add_bind(l_adm_ci_sequence_number);
2223: fnd_dsql.add_text(' AND admission_process_category =');
2224: fnd_dsql.add_bind(p_parameter_4);
2225: fnd_dsql.add_text(' AND panel_code= ');
2226: fnd_dsql.add_bind(p_parameter_5);
2227: fnd_dsql.add_text(' AND TRUNC(interview_date) = TRUNC(igs_ge_date.igsdate(');
2228: fnd_dsql.add_bind(p_parameter_6);
2229: fnd_dsql.add_text(' )) AND attendance_mode= ');
2230: fnd_dsql.add_bind(p_parameter_7);

Line 2227: fnd_dsql.add_text(' AND TRUNC(interview_date) = TRUNC(igs_ge_date.igsdate(');

2223: fnd_dsql.add_text(' AND admission_process_category =');
2224: fnd_dsql.add_bind(p_parameter_4);
2225: fnd_dsql.add_text(' AND panel_code= ');
2226: fnd_dsql.add_bind(p_parameter_5);
2227: fnd_dsql.add_text(' AND TRUNC(interview_date) = TRUNC(igs_ge_date.igsdate(');
2228: fnd_dsql.add_bind(p_parameter_6);
2229: fnd_dsql.add_text(' )) AND attendance_mode= ');
2230: fnd_dsql.add_bind(p_parameter_7);
2231: fnd_dsql.add_text(' AND attendance_type= ');

Line 2228: fnd_dsql.add_bind(p_parameter_6);

2224: fnd_dsql.add_bind(p_parameter_4);
2225: fnd_dsql.add_text(' AND panel_code= ');
2226: fnd_dsql.add_bind(p_parameter_5);
2227: fnd_dsql.add_text(' AND TRUNC(interview_date) = TRUNC(igs_ge_date.igsdate(');
2228: fnd_dsql.add_bind(p_parameter_6);
2229: fnd_dsql.add_text(' )) AND attendance_mode= ');
2230: fnd_dsql.add_bind(p_parameter_7);
2231: fnd_dsql.add_text(' AND attendance_type= ');
2232: fnd_dsql.add_bind(p_parameter_9);

Line 2229: fnd_dsql.add_text(' )) AND attendance_mode= ');

2225: fnd_dsql.add_text(' AND panel_code= ');
2226: fnd_dsql.add_bind(p_parameter_5);
2227: fnd_dsql.add_text(' AND TRUNC(interview_date) = TRUNC(igs_ge_date.igsdate(');
2228: fnd_dsql.add_bind(p_parameter_6);
2229: fnd_dsql.add_text(' )) AND attendance_mode= ');
2230: fnd_dsql.add_bind(p_parameter_7);
2231: fnd_dsql.add_text(' AND attendance_type= ');
2232: fnd_dsql.add_bind(p_parameter_9);
2233: fnd_dsql.add_text(' AND interview_date > SYSDATE');

Line 2230: fnd_dsql.add_bind(p_parameter_7);

2226: fnd_dsql.add_bind(p_parameter_5);
2227: fnd_dsql.add_text(' AND TRUNC(interview_date) = TRUNC(igs_ge_date.igsdate(');
2228: fnd_dsql.add_bind(p_parameter_6);
2229: fnd_dsql.add_text(' )) AND attendance_mode= ');
2230: fnd_dsql.add_bind(p_parameter_7);
2231: fnd_dsql.add_text(' AND attendance_type= ');
2232: fnd_dsql.add_bind(p_parameter_9);
2233: fnd_dsql.add_text(' AND interview_date > SYSDATE');
2234: END IF;

Line 2231: fnd_dsql.add_text(' AND attendance_type= ');

2227: fnd_dsql.add_text(' AND TRUNC(interview_date) = TRUNC(igs_ge_date.igsdate(');
2228: fnd_dsql.add_bind(p_parameter_6);
2229: fnd_dsql.add_text(' )) AND attendance_mode= ');
2230: fnd_dsql.add_bind(p_parameter_7);
2231: fnd_dsql.add_text(' AND attendance_type= ');
2232: fnd_dsql.add_bind(p_parameter_9);
2233: fnd_dsql.add_text(' AND interview_date > SYSDATE');
2234: END IF;
2235: END IF;

Line 2232: fnd_dsql.add_bind(p_parameter_9);

2228: fnd_dsql.add_bind(p_parameter_6);
2229: fnd_dsql.add_text(' )) AND attendance_mode= ');
2230: fnd_dsql.add_bind(p_parameter_7);
2231: fnd_dsql.add_text(' AND attendance_type= ');
2232: fnd_dsql.add_bind(p_parameter_9);
2233: fnd_dsql.add_text(' AND interview_date > SYSDATE');
2234: END IF;
2235: END IF;
2236: EXCEPTION

Line 2233: fnd_dsql.add_text(' AND interview_date > SYSDATE');

2229: fnd_dsql.add_text(' )) AND attendance_mode= ');
2230: fnd_dsql.add_bind(p_parameter_7);
2231: fnd_dsql.add_text(' AND attendance_type= ');
2232: fnd_dsql.add_bind(p_parameter_9);
2233: fnd_dsql.add_text(' AND interview_date > SYSDATE');
2234: END IF;
2235: END IF;
2236: EXCEPTION
2237: WHEN OTHERS THEN