DBA Data[Home] [Help]

APPS.IGS_PS_GENERIC_PVT dependencies on IGS_PS_CREATE_GENERIC_PKG

Line 216: igs_ps_create_generic_pkg.create_uso_ins_ovrd(p_uso_ins_tbl,p_uso_ins_status,p_calling_context);

212: -- Call the Unit Section Occurrence Instructors sub process
213: IF p_uso_ins_tbl.COUNT > 0 THEN
214: SAVEPOINT create_uso_ins;
215:
216: igs_ps_create_generic_pkg.create_uso_ins_ovrd(p_uso_ins_tbl,p_uso_ins_status,p_calling_context);
217:
218: l_record_exists := TRUE;
219:
220: IF p_uso_ins_status = 'E' THEN

Line 239: igs_ps_create_generic_pkg.create_uso_facility(p_usec_occurs_facility_tbl,p_uso_facility_status,p_calling_context);

235: -- Call the Unit Section Occurrence Facilities sub process
236: IF p_usec_occurs_facility_tbl.COUNT > 0 THEN
237: SAVEPOINT create_uso_facility;
238:
239: igs_ps_create_generic_pkg.create_uso_facility(p_usec_occurs_facility_tbl,p_uso_facility_status,p_calling_context);
240: l_record_exists := TRUE;
241:
242: IF p_uso_facility_status = 'E' THEN
243: --Set the API status to 'E'

Line 283: igs_ps_create_generic_pkg.create_usec_teach_resp_ovrd(p_usec_teach_resp_ovrd_tbl,p_usec_teach_resp_ovrd_status,p_calling_context);

279: -- Call the Unit Section teaching responsibility Override sub process
280: IF p_usec_teach_resp_ovrd_tbl.COUNT > 0 THEN
281: SAVEPOINT create_usec_teach_resp_ovrd;
282:
283: igs_ps_create_generic_pkg.create_usec_teach_resp_ovrd(p_usec_teach_resp_ovrd_tbl,p_usec_teach_resp_ovrd_status,p_calling_context);
284: l_record_exists := TRUE;
285:
286: IF p_usec_teach_resp_ovrd_status = 'E' THEN
287: --Set the API status to 'E'

Line 305: igs_ps_create_generic_pkg.create_usec_notes(p_usec_notes_tbl,p_usec_notes_status,p_calling_context);

301: -- Call the Unit Section Notes sub process
302: IF p_usec_notes_tbl.COUNT > 0 THEN
303: SAVEPOINT create_usec_notes;
304:
305: igs_ps_create_generic_pkg.create_usec_notes(p_usec_notes_tbl,p_usec_notes_status,p_calling_context);
306: l_record_exists := TRUE;
307:
308: IF p_usec_notes_status = 'E' THEN
309: --Set the API status to 'E'

Line 327: igs_ps_create_generic_pkg.create_usec_assmnt(p_usec_assmnt_tbl,p_usec_assmnt_status,p_calling_context);

323: -- Call the Unit Section Assessment sub process
324: IF p_usec_assmnt_tbl.COUNT > 0 THEN
325: SAVEPOINT create_usec_assmnt;
326:
327: igs_ps_create_generic_pkg.create_usec_assmnt(p_usec_assmnt_tbl,p_usec_assmnt_status,p_calling_context);
328: l_record_exists := TRUE;
329:
330: IF p_usec_assmnt_status = 'E' THEN
331: --Set the API status to 'E'

Line 348: igs_ps_create_generic_pkg.create_usec_plus_hr(p_usec_plus_hr_tbl,p_usec_plus_hr_status,p_calling_context);

344: -- Call the Unit Section Plus Hour sub process
345: IF p_usec_plus_hr_tbl.COUNT > 0 THEN
346: SAVEPOINT create_usec_plus_hr;
347:
348: igs_ps_create_generic_pkg.create_usec_plus_hr(p_usec_plus_hr_tbl,p_usec_plus_hr_status,p_calling_context);
349: l_record_exists := TRUE;
350:
351: IF p_usec_plus_hr_status = 'E' THEN
352: --Set the API status to 'E'

Line 369: igs_ps_create_generic_pkg.create_usec_cat(p_usec_cat_tbl,p_usec_cat_status,p_calling_context);

365: -- Call the Unit Section Categories sub process
366: IF p_usec_cat_tbl.COUNT > 0 THEN
367: SAVEPOINT create_usec_cat;
368:
369: igs_ps_create_generic_pkg.create_usec_cat(p_usec_cat_tbl,p_usec_cat_status,p_calling_context);
370: l_record_exists := TRUE;
371:
372: IF p_usec_cat_status = 'E' THEN
373: --Set the API status to 'E'

Line 390: igs_ps_create_generic_pkg.create_usec_rule(p_usec_rule_tbl,p_usec_rule_status,p_calling_context);

386: -- Call the Unit Section Rule sub process
387: IF p_usec_rule_tbl.COUNT > 0 THEN
388: SAVEPOINT create_usec_rule;
389:
390: igs_ps_create_generic_pkg.create_usec_rule(p_usec_rule_tbl,p_usec_rule_status,p_calling_context);
391: l_record_exists := TRUE;
392:
393: IF p_usec_rule_status = 'E' THEN
394: --Set the API status to 'E'

Line 411: igs_ps_create_generic_pkg.create_usec_cross_group(p_usec_cross_group_tbl,p_usec_cross_group_status,p_calling_context);

407: -- Call the Unit Section Cross Listed Group sub process
408: IF p_usec_cross_group_tbl.COUNT > 0 THEN
409: SAVEPOINT create_usec_cross_group;
410:
411: igs_ps_create_generic_pkg.create_usec_cross_group(p_usec_cross_group_tbl,p_usec_cross_group_status,p_calling_context);
412: l_record_exists := TRUE;
413:
414: IF p_usec_cross_group_status = 'E' THEN
415: --Set the API status to 'E'

Line 433: igs_ps_create_generic_pkg.create_usec_meet_with(p_usec_meet_with_tbl,p_usec_meet_with_status,p_calling_context);

429: -- Call the Unit Section Meet With Group sub process
430: IF p_usec_meet_with_tbl.COUNT > 0 THEN
431: SAVEPOINT create_usec_meet_with;
432:
433: igs_ps_create_generic_pkg.create_usec_meet_with(p_usec_meet_with_tbl,p_usec_meet_with_status,p_calling_context);
434: l_record_exists := TRUE;
435:
436: IF p_usec_meet_with_status = 'E' THEN
437: --Set the API status to 'E'

Line 454: igs_ps_create_generic_pkg.create_usec_waitlist(p_usec_waitlist_tbl,p_usec_waitlist_status,p_calling_context);

450: -- Call the Unit Section Waitlist sub process
451: IF p_usec_waitlist_tbl.COUNT > 0 THEN
452: SAVEPOINT create_usec_waitlist;
453:
454: igs_ps_create_generic_pkg.create_usec_waitlist(p_usec_waitlist_tbl,p_usec_waitlist_status,p_calling_context);
455: l_record_exists := TRUE;
456:
457: IF p_usec_waitlist_status = 'E' THEN
458: --Set the API status to 'E'

Line 475: igs_ps_create_generic_pkg.create_usec_res_seat(p_usec_res_seat_tbl,p_usec_res_seat_status,p_calling_context);

471: -- Call the Unit Section Reserve Seating sub process
472: IF p_usec_res_seat_tbl.COUNT > 0 THEN
473: SAVEPOINT create_usec_res_seat;
474:
475: igs_ps_create_generic_pkg.create_usec_res_seat(p_usec_res_seat_tbl,p_usec_res_seat_status,p_calling_context);
476: l_record_exists := TRUE;
477:
478: IF p_usec_res_seat_status = 'E' THEN
479: --Set the API status to 'E'

Line 496: igs_ps_create_generic_pkg.create_usec_sp_fee(p_usec_sp_fee_tbl,p_usec_sp_fee_status,p_calling_context);

492: -- Call the Unit Section Special Fees sub process
493: IF p_usec_sp_fee_tbl.COUNT > 0 THEN
494: SAVEPOINT create_usec_sp_fee;
495:
496: igs_ps_create_generic_pkg.create_usec_sp_fee(p_usec_sp_fee_tbl,p_usec_sp_fee_status,p_calling_context);
497: l_record_exists := TRUE;
498:
499: IF p_usec_sp_fee_status = 'E' THEN
500: --Set the API status to 'E'

Line 517: igs_ps_create_generic_pkg.create_usec_ret(p_usec_ret_tbl,p_usec_ret_status,p_calling_context);

513: -- Call the Unit Section Retention sub process
514: IF p_usec_ret_tbl.COUNT > 0 THEN
515: SAVEPOINT create_usec_ret;
516:
517: igs_ps_create_generic_pkg.create_usec_ret(p_usec_ret_tbl,p_usec_ret_status,p_calling_context);
518: l_record_exists := TRUE;
519:
520: IF p_usec_ret_status = 'E' THEN
521: --Set the API status to 'E'

Line 538: igs_ps_create_generic_pkg.create_usec_ret_dtl(p_usec_ret_dtl_tbl,p_usec_ret_dtl_status,p_calling_context);

534: -- Call the Unit Section Retention Details sub process
535: IF p_usec_ret_dtl_tbl.COUNT > 0 THEN
536: SAVEPOINT create_usec_ret_dtl;
537:
538: igs_ps_create_generic_pkg.create_usec_ret_dtl(p_usec_ret_dtl_tbl,p_usec_ret_dtl_status,p_calling_context);
539: l_record_exists := TRUE;
540:
541: IF p_usec_ret_dtl_status = 'E' THEN
542: --Set the API status to 'E'

Line 559: igs_ps_create_generic_pkg.create_usec_enr_dead(p_usec_enr_dead_tbl,p_usec_enr_dead_status,p_calling_context);

555: -- Call the Unit Section Enrollment Deadline sub process
556: IF p_usec_enr_dead_tbl.COUNT > 0 THEN
557: SAVEPOINT create_usec_enr_dead;
558:
559: igs_ps_create_generic_pkg.create_usec_enr_dead(p_usec_enr_dead_tbl,p_usec_enr_dead_status,p_calling_context);
560: l_record_exists := TRUE;
561:
562: IF p_usec_enr_dead_status = 'E' THEN
563: --Set the API status to 'E'

Line 580: igs_ps_create_generic_pkg.create_usec_enr_dis(p_usec_enr_dis_tbl,p_usec_enr_dis_status,p_calling_context);

576: -- Call the Unit Section Enrollment Discontinuation sub process
577: IF p_usec_enr_dis_tbl.COUNT > 0 THEN
578: SAVEPOINT create_usec_enr_dis;
579:
580: igs_ps_create_generic_pkg.create_usec_enr_dis(p_usec_enr_dis_tbl,p_usec_enr_dis_status,p_calling_context);
581: l_record_exists := TRUE;
582:
583: IF p_usec_enr_dis_status = 'E' THEN
584: --Set the API status to 'E'

Line 601: igs_ps_create_generic_pkg.create_usec_teach_resp(p_usec_teach_resp_tbl,p_usec_teach_resp_status,p_calling_context);

597: -- Call the Unit Section Teaching Responsibility (for Update only) sub process
598: IF p_usec_teach_resp_tbl.COUNT > 0 THEN
599: SAVEPOINT create_usec_teach_resp;
600:
601: igs_ps_create_generic_pkg.create_usec_teach_resp(p_usec_teach_resp_tbl,p_usec_teach_resp_status,p_calling_context);
602: l_record_exists := TRUE;
603:
604: IF p_usec_teach_resp_status = 'E' THEN
605: --Set the API status to 'E'

Line 622: igs_ps_create_generic_pkg.create_usec_ass_item_grp(p_usec_ass_item_grp_tbl,p_usec_ass_item_grp_status,p_calling_context);

618: -- Call the Unit Section Assessment Item Group sub process
619: IF p_usec_ass_item_grp_tbl.COUNT > 0 THEN
620: SAVEPOINT create_usec_ass_item_grp;
621:
622: igs_ps_create_generic_pkg.create_usec_ass_item_grp(p_usec_ass_item_grp_tbl,p_usec_ass_item_grp_status,p_calling_context);
623: l_record_exists := TRUE;
624:
625: IF p_usec_ass_item_grp_status = 'E' THEN
626: --Set the API status to 'E'