APPS.IGS_AS_STD_EXM_INSTN_PKG dependencies on IGS_SC_GEN_001

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

678: x_std_exm_instn_id =>X_STD_EXM_INSTN_ID
679: );
680:
681: IF (x_mode = 'S') THEN
682: igs_sc_gen_001.set_ctx('R');
683: END IF;
684: insert into IGS_AS_STD_EXM_INSTN_ALL (
685: ORG_ID,
686: SEAT_NUMBER,

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

739: new_references.uoo_id,
740: new_references.STD_EXM_INSTN_ID
741: );
742: IF (x_mode = 'S') THEN
743: igs_sc_gen_001.unset_ctx('R');
744: END IF;
745:
746:
747: open c;

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

761: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
762: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
763: fnd_message.set_token ('ERR_CD', SQLCODE);
764: igs_ge_msg_stack.add;
765: igs_sc_gen_001.unset_ctx('R');
766: app_exception.raise_exception;
767: ELSE
768: igs_sc_gen_001.unset_ctx('R');
769: RAISE;

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

764: igs_ge_msg_stack.add;
765: igs_sc_gen_001.unset_ctx('R');
766: app_exception.raise_exception;
767: ELSE
768: igs_sc_gen_001.unset_ctx('R');
769: RAISE;
770: END IF;
771:
772: end INSERT_ROW;

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

916: x_uoo_id => X_UOO_ID,
917: x_std_exm_instn_id => X_STD_EXM_INSTN_ID
918: );
919: IF (x_mode = 'S') THEN
920: igs_sc_gen_001.set_ctx('R');
921: END IF;
922: update IGS_AS_STD_EXM_INSTN_ALL set
923: SEAT_NUMBER = new_references.SEAT_NUMBER,
924: TIMESLOT = new_references.TIMESLOT,

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

932: ;
933: if (sql%notfound) then
934: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
935: igs_ge_msg_stack.add;
936: igs_sc_gen_001.unset_ctx('R');
937: app_exception.raise_exception;
938: end if;
939: IF (x_mode = 'S') THEN
940: igs_sc_gen_001.unset_ctx('R');

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

936: igs_sc_gen_001.unset_ctx('R');
937: app_exception.raise_exception;
938: end if;
939: IF (x_mode = 'S') THEN
940: igs_sc_gen_001.unset_ctx('R');
941: END IF;
942:
943: After_DML(
944: p_action => 'UPDATE',

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

949: IF (SQLCODE = (-28115)) THEN
950: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
951: fnd_message.set_token ('ERR_CD', SQLCODE);
952: igs_ge_msg_stack.add;
953: igs_sc_gen_001.unset_ctx('R');
954: app_exception.raise_exception;
955: ELSE
956: igs_sc_gen_001.unset_ctx('R');
957: RAISE;

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

952: igs_ge_msg_stack.add;
953: igs_sc_gen_001.unset_ctx('R');
954: app_exception.raise_exception;
955: ELSE
956: igs_sc_gen_001.unset_ctx('R');
957: RAISE;
958: END IF;
959:
960: end UPDATE_ROW;

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

1059: x_rowid => X_ROWID
1060: );
1061:
1062: IF (x_mode = 'S') THEN
1063: igs_sc_gen_001.set_ctx('R');
1064: END IF;
1065: delete from IGS_AS_STD_EXM_INSTN_ALL
1066: where ROWID = X_ROWID;
1067: if (sql%notfound) then

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

1066: where ROWID = X_ROWID;
1067: if (sql%notfound) then
1068: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1069: igs_ge_msg_stack.add;
1070: igs_sc_gen_001.unset_ctx('R');
1071: app_exception.raise_exception;
1072: end if;
1073: IF (x_mode = 'S') THEN
1074: igs_sc_gen_001.unset_ctx('R');

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

1070: igs_sc_gen_001.unset_ctx('R');
1071: app_exception.raise_exception;
1072: end if;
1073: IF (x_mode = 'S') THEN
1074: igs_sc_gen_001.unset_ctx('R');
1075: END IF;
1076:
1077: After_DML(
1078: p_action => 'DELETE',