APPS.IGS_PE_ATHLETIC_DTL_PKG dependencies on IGS_SC_GEN_001

Line 442: igs_sc_gen_001.set_ctx('R');

438: x_last_update_login => x_last_update_login
439: );
440:
441: IF (x_mode = 'S') THEN
442: igs_sc_gen_001.set_ctx('R');
443: END IF;
444: INSERT INTO igs_pe_athletic_dtl (
445: athletic_details_id,
446: person_id,

Line 474: igs_sc_gen_001.unset_ctx('R');

470: x_last_updated_by,
471: x_last_update_login
472: );
473: IF (x_mode = 'S') THEN
474: igs_sc_gen_001.unset_ctx('R');
475: END IF;
476:
477:
478: OPEN c;

Line 493: igs_sc_gen_001.unset_ctx('R');

489: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
490: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
491: fnd_message.set_token ('ERR_CD', SQLCODE);
492: igs_ge_msg_stack.add;
493: igs_sc_gen_001.unset_ctx('R');
494: app_exception.raise_exception;
495: ELSE
496: igs_sc_gen_001.unset_ctx('R');
497: RAISE;

Line 496: igs_sc_gen_001.unset_ctx('R');

492: igs_ge_msg_stack.add;
493: igs_sc_gen_001.unset_ctx('R');
494: app_exception.raise_exception;
495: ELSE
496: igs_sc_gen_001.unset_ctx('R');
497: RAISE;
498: END IF;
499: END insert_row;
500:

Line 636: igs_sc_gen_001.set_ctx('R');

632: x_last_update_login => x_last_update_login
633: );
634:
635: IF (x_mode = 'S') THEN
636: igs_sc_gen_001.set_ctx('R');
637: END IF;
638: UPDATE igs_pe_athletic_dtl
639: SET
640: person_id = new_references.person_id,

Line 655: igs_sc_gen_001.unset_ctx('R');

651:
652: IF (SQL%NOTFOUND) THEN
653: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
654: igs_ge_msg_stack.add;
655: igs_sc_gen_001.unset_ctx('R');
656: app_exception.raise_exception;
657: END IF;
658: IF (x_mode = 'S') THEN
659: igs_sc_gen_001.unset_ctx('R');

Line 659: igs_sc_gen_001.unset_ctx('R');

655: igs_sc_gen_001.unset_ctx('R');
656: app_exception.raise_exception;
657: END IF;
658: IF (x_mode = 'S') THEN
659: igs_sc_gen_001.unset_ctx('R');
660: END IF;
661:
662:
663:

Line 670: igs_sc_gen_001.unset_ctx('R');

666: IF (SQLCODE = (-28115)) THEN
667: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
668: fnd_message.set_token ('ERR_CD', SQLCODE);
669: igs_ge_msg_stack.add;
670: igs_sc_gen_001.unset_ctx('R');
671: app_exception.raise_exception;
672: ELSE
673: igs_sc_gen_001.unset_ctx('R');
674: RAISE;

Line 673: igs_sc_gen_001.unset_ctx('R');

669: igs_ge_msg_stack.add;
670: igs_sc_gen_001.unset_ctx('R');
671: app_exception.raise_exception;
672: ELSE
673: igs_sc_gen_001.unset_ctx('R');
674: RAISE;
675: END IF;
676: END update_row;
677:

Line 765: igs_sc_gen_001.set_ctx('R');

761: x_rowid => x_rowid
762: );
763:
764: IF (x_mode = 'S') THEN
765: igs_sc_gen_001.set_ctx('R');
766: END IF;
767: DELETE FROM igs_pe_athletic_dtl
768: WHERE rowid = x_rowid;
769:

Line 773: igs_sc_gen_001.unset_ctx('R');

769:
770: IF (SQL%NOTFOUND) THEN
771: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
772: igs_ge_msg_stack.add;
773: igs_sc_gen_001.unset_ctx('R');
774: app_exception.raise_exception;
775: END IF;
776: IF (x_mode = 'S') THEN
777: igs_sc_gen_001.unset_ctx('R');

Line 777: igs_sc_gen_001.unset_ctx('R');

773: igs_sc_gen_001.unset_ctx('R');
774: app_exception.raise_exception;
775: END IF;
776: IF (x_mode = 'S') THEN
777: igs_sc_gen_001.unset_ctx('R');
778: END IF;
779:
780:
781: END delete_row;