APPS.IGS_PE_EIT_PKG dependencies on IGS_SC_GEN_001

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

511: x_last_update_login => x_last_update_login
512: );
513:
514: IF (x_mode = 'S') THEN
515: igs_sc_gen_001.set_ctx('R');
516: END IF;
517: INSERT INTO igs_pe_eit (
518: pe_eit_id,
519: person_id,

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

547: x_last_updated_by,
548: x_last_update_login
549: );
550: IF (x_mode = 'S') THEN
551: igs_sc_gen_001.unset_ctx('R');
552: END IF;
553:
554:
555: OPEN c;

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

566: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
567: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
568: fnd_message.set_token ('ERR_CD', SQLCODE);
569: igs_ge_msg_stack.add;
570: igs_sc_gen_001.unset_ctx('R');
571: app_exception.raise_exception;
572: ELSE
573: igs_sc_gen_001.unset_ctx('R');
574: RAISE;

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

569: igs_ge_msg_stack.add;
570: igs_sc_gen_001.unset_ctx('R');
571: app_exception.raise_exception;
572: ELSE
573: igs_sc_gen_001.unset_ctx('R');
574: RAISE;
575: END IF;
576: END insert_row;
577:

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

719: x_last_update_login => x_last_update_login
720: );
721:
722: IF (x_mode = 'S') THEN
723: igs_sc_gen_001.set_ctx('R');
724: END IF;
725: UPDATE igs_pe_eit
726: SET
727: person_id = new_references.person_id,

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

740:
741: IF (SQL%NOTFOUND) THEN
742: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
743: igs_ge_msg_stack.add;
744: igs_sc_gen_001.unset_ctx('R');
745: app_exception.raise_exception;
746: END IF;
747: IF (x_mode = 'S') THEN
748: igs_sc_gen_001.unset_ctx('R');

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

744: igs_sc_gen_001.unset_ctx('R');
745: app_exception.raise_exception;
746: END IF;
747: IF (x_mode = 'S') THEN
748: igs_sc_gen_001.unset_ctx('R');
749: END IF;
750:
751:
752:

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

755: IF (SQLCODE = (-28115)) THEN
756: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
757: fnd_message.set_token ('ERR_CD', SQLCODE);
758: igs_ge_msg_stack.add;
759: igs_sc_gen_001.unset_ctx('R');
760: app_exception.raise_exception;
761: ELSE
762: igs_sc_gen_001.unset_ctx('R');
763: RAISE;

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

758: igs_ge_msg_stack.add;
759: igs_sc_gen_001.unset_ctx('R');
760: app_exception.raise_exception;
761: ELSE
762: igs_sc_gen_001.unset_ctx('R');
763: RAISE;
764: END IF;
765: END update_row;
766:

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

856: x_rowid => x_rowid
857: );
858:
859: IF (x_mode = 'S') THEN
860: igs_sc_gen_001.set_ctx('R');
861: END IF;
862: DELETE FROM igs_pe_eit
863: WHERE rowid = x_rowid;
864:

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

864:
865: IF (SQL%NOTFOUND) THEN
866: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
867: igs_ge_msg_stack.add;
868: igs_sc_gen_001.unset_ctx('R');
869: app_exception.raise_exception;
870: END IF;
871: IF (x_mode = 'S') THEN
872: igs_sc_gen_001.unset_ctx('R');

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

868: igs_sc_gen_001.unset_ctx('R');
869: app_exception.raise_exception;
870: END IF;
871: IF (x_mode = 'S') THEN
872: igs_sc_gen_001.unset_ctx('R');
873: END IF;
874:
875:
876: END delete_row;