APPS.IGS_PE_ATHLETIC_PRG_PKG dependencies on IGS_SC_GEN_001

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

449: x_last_update_login => x_last_update_login
450: );
451:
452: IF (x_mode = 'S') THEN
453: igs_sc_gen_001.set_ctx('R');
454: END IF;
455: INSERT INTO igs_pe_athletic_prg (
456: athletic_prg_id,
457: person_id,

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

483: x_last_updated_by,
484: x_last_update_login
485: );
486: IF (x_mode = 'S') THEN
487: igs_sc_gen_001.unset_ctx('R');
488: END IF;
489:
490:
491: OPEN c;

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

502: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
503: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
504: fnd_message.set_token ('ERR_CD', SQLCODE);
505: igs_ge_msg_stack.add;
506: igs_sc_gen_001.unset_ctx('R');
507: app_exception.raise_exception;
508: ELSE
509: igs_sc_gen_001.unset_ctx('R');
510: RAISE;

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

505: igs_ge_msg_stack.add;
506: igs_sc_gen_001.unset_ctx('R');
507: app_exception.raise_exception;
508: ELSE
509: igs_sc_gen_001.unset_ctx('R');
510: RAISE;
511: END IF;
512: END insert_row;
513:

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

650: x_last_update_login => x_last_update_login
651: );
652:
653: IF (x_mode = 'S') THEN
654: igs_sc_gen_001.set_ctx('R');
655: END IF;
656: UPDATE igs_pe_athletic_prg
657: SET
658: person_id = new_references.person_id,

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

670:
671: IF (SQL%NOTFOUND) THEN
672: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
673: igs_ge_msg_stack.add;
674: igs_sc_gen_001.unset_ctx('R');
675: app_exception.raise_exception;
676: END IF;
677: IF (x_mode = 'S') THEN
678: igs_sc_gen_001.unset_ctx('R');

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

674: igs_sc_gen_001.unset_ctx('R');
675: app_exception.raise_exception;
676: END IF;
677: IF (x_mode = 'S') THEN
678: igs_sc_gen_001.unset_ctx('R');
679: END IF;
680:
681:
682:

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

685: IF (SQLCODE = (-28115)) THEN
686: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
687: fnd_message.set_token ('ERR_CD', SQLCODE);
688: igs_ge_msg_stack.add;
689: igs_sc_gen_001.unset_ctx('R');
690: app_exception.raise_exception;
691: ELSE
692: igs_sc_gen_001.unset_ctx('R');
693: RAISE;

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

688: igs_ge_msg_stack.add;
689: igs_sc_gen_001.unset_ctx('R');
690: app_exception.raise_exception;
691: ELSE
692: igs_sc_gen_001.unset_ctx('R');
693: RAISE;
694: END IF;
695: END update_row;
696:

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

783: x_rowid => x_rowid
784: );
785:
786: IF (x_mode = 'S') THEN
787: igs_sc_gen_001.set_ctx('R');
788: END IF;
789: DELETE FROM igs_pe_athletic_prg
790: WHERE rowid = x_rowid;
791:

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

791:
792: IF (SQL%NOTFOUND) THEN
793: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
794: igs_ge_msg_stack.add;
795: igs_sc_gen_001.unset_ctx('R');
796: app_exception.raise_exception;
797: END IF;
798: IF (x_mode = 'S') THEN
799: igs_sc_gen_001.unset_ctx('R');

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

795: igs_sc_gen_001.unset_ctx('R');
796: app_exception.raise_exception;
797: END IF;
798: IF (x_mode = 'S') THEN
799: igs_sc_gen_001.unset_ctx('R');
800: END IF;
801:
802:
803: END delete_row;