APPS.IGS_HE_EN_SUSA_PKG dependencies on IGS_SC_GEN_001

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

683: x_last_update_login => x_last_update_login
684: );
685:
686: IF (x_mode = 'S') THEN
687: igs_sc_gen_001.set_ctx('R');
688: END IF;
689: INSERT INTO igs_he_en_susa (
690: hesa_en_susa_id,
691: person_id,

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

803: x_last_updated_by,
804: x_last_update_login
805: );
806: IF (x_mode = 'S') THEN
807: igs_sc_gen_001.unset_ctx('R');
808: END IF;
809:
810:
811: OPEN c;

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

822: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
823: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
824: fnd_message.set_token ('ERR_CD', SQLCODE);
825: igs_ge_msg_stack.add;
826: igs_sc_gen_001.unset_ctx('R');
827: app_exception.raise_exception;
828: ELSE
829: igs_sc_gen_001.unset_ctx('R');
830: RAISE;

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

825: igs_ge_msg_stack.add;
826: igs_sc_gen_001.unset_ctx('R');
827: app_exception.raise_exception;
828: ELSE
829: igs_sc_gen_001.unset_ctx('R');
830: RAISE;
831: END IF;
832: END insert_row;
833:

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

1190: x_last_update_login => x_last_update_login
1191: );
1192:
1193: IF (x_mode = 'S') THEN
1194: igs_sc_gen_001.set_ctx('R');
1195: END IF;
1196: UPDATE igs_he_en_susa
1197: SET
1198: person_id = new_references.person_id,

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

1253:
1254: IF (SQL%NOTFOUND) THEN
1255: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1256: igs_ge_msg_stack.add;
1257: igs_sc_gen_001.unset_ctx('R');
1258: app_exception.raise_exception;
1259: END IF;
1260: IF (x_mode = 'S') THEN
1261: igs_sc_gen_001.unset_ctx('R');

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

1257: igs_sc_gen_001.unset_ctx('R');
1258: app_exception.raise_exception;
1259: END IF;
1260: IF (x_mode = 'S') THEN
1261: igs_sc_gen_001.unset_ctx('R');
1262: END IF;
1263:
1264: EXCEPTION
1265: WHEN OTHERS THEN

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

1266: IF (SQLCODE = (-28115)) THEN
1267: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
1268: fnd_message.set_token ('ERR_CD', SQLCODE);
1269: igs_ge_msg_stack.add;
1270: igs_sc_gen_001.unset_ctx('R');
1271: app_exception.raise_exception;
1272: ELSE
1273: igs_sc_gen_001.unset_ctx('R');
1274: RAISE;

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

1269: igs_ge_msg_stack.add;
1270: igs_sc_gen_001.unset_ctx('R');
1271: app_exception.raise_exception;
1272: ELSE
1273: igs_sc_gen_001.unset_ctx('R');
1274: RAISE;
1275: END IF;
1276:
1277: END update_row;

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

1496: x_rowid => x_rowid
1497: );
1498:
1499: IF (x_mode = 'S') THEN
1500: igs_sc_gen_001.set_ctx('R');
1501: END IF;
1502: DELETE FROM igs_he_en_susa
1503: WHERE rowid = x_rowid;
1504:

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

1504:
1505: IF (SQL%NOTFOUND) THEN
1506: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1507: igs_ge_msg_stack.add;
1508: igs_sc_gen_001.unset_ctx('R');
1509: app_exception.raise_exception;
1510: END IF;
1511: IF (x_mode = 'S') THEN
1512: igs_sc_gen_001.unset_ctx('R');

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

1508: igs_sc_gen_001.unset_ctx('R');
1509: app_exception.raise_exception;
1510: END IF;
1511: IF (x_mode = 'S') THEN
1512: igs_sc_gen_001.unset_ctx('R');
1513: END IF;
1514:
1515:
1516: END delete_row;