APPS.IGS_AD_TEST_RESULTS_PKG dependencies on IGS_SC_GEN_001

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

941: x_last_updated_by=>X_LAST_UPDATED_BY,
942: x_last_update_login=>X_LAST_UPDATE_LOGIN,
943: x_active_ind => X_ACTIVE_IND );
944: IF (x_mode = 'S') THEN
945: igs_sc_gen_001.set_ctx('R');
946: END IF;
947: insert into IGS_AD_TEST_RESULTS (
948: TEST_RESULTS_ID
949: ,PERSON_ID

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

1035: ,X_PROGRAM_UPDATE_DATE
1036: ,NEW_REFERENCES.ACTIVE_IND
1037: )RETURNING TEST_RESULTS_ID INTO X_TEST_RESULTS_ID;
1038: IF (x_mode = 'S') THEN
1039: igs_sc_gen_001.unset_ctx('R');
1040: END IF;
1041:
1042:
1043: NEW_REFERENCES.TEST_RESULTS_ID := X_TEST_RESULTS_ID;

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

1056: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
1057: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
1058: fnd_message.set_token ('ERR_CD', SQLCODE);
1059: igs_ge_msg_stack.add;
1060: igs_sc_gen_001.unset_ctx('R');
1061: app_exception.raise_exception;
1062: ELSE
1063: igs_sc_gen_001.unset_ctx('R');
1064: RAISE;

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

1059: igs_ge_msg_stack.add;
1060: igs_sc_gen_001.unset_ctx('R');
1061: app_exception.raise_exception;
1062: ELSE
1063: igs_sc_gen_001.unset_ctx('R');
1064: RAISE;
1065: END IF;
1066:
1067: end INSERT_ROW;

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

1412: end if;
1413: end if;
1414:
1415: IF (x_mode = 'S') THEN
1416: igs_sc_gen_001.set_ctx('R');
1417: END IF;
1418: update IGS_AD_TEST_RESULTS set
1419: PERSON_ID = NEW_REFERENCES.PERSON_ID,
1420: ADMISSION_TEST_TYPE = NEW_REFERENCES.ADMISSION_TEST_TYPE,

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

1460: where ROWID = X_ROWID;
1461: if (sql%notfound) then
1462: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1463: igs_ge_msg_stack.add;
1464: igs_sc_gen_001.unset_ctx('R');
1465: app_exception.raise_exception;
1466: end if;
1467: IF (x_mode = 'S') THEN
1468: igs_sc_gen_001.unset_ctx('R');

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

1464: igs_sc_gen_001.unset_ctx('R');
1465: app_exception.raise_exception;
1466: end if;
1467: IF (x_mode = 'S') THEN
1468: igs_sc_gen_001.unset_ctx('R');
1469: END IF;
1470:
1471:
1472: After_DML (

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

1478: IF (SQLCODE = (-28115)) THEN
1479: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
1480: fnd_message.set_token ('ERR_CD', SQLCODE);
1481: igs_ge_msg_stack.add;
1482: igs_sc_gen_001.unset_ctx('R');
1483: app_exception.raise_exception;
1484: ELSE
1485: igs_sc_gen_001.unset_ctx('R');
1486: RAISE;

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

1481: igs_ge_msg_stack.add;
1482: igs_sc_gen_001.unset_ctx('R');
1483: app_exception.raise_exception;
1484: ELSE
1485: igs_sc_gen_001.unset_ctx('R');
1486: RAISE;
1487: END IF;
1488:
1489: end UPDATE_ROW;

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

1650: p_action => 'DELETE',
1651: x_rowid => X_ROWID
1652: );
1653: IF (x_mode = 'S') THEN
1654: igs_sc_gen_001.set_ctx('R');
1655: END IF;
1656: delete from IGS_AD_TEST_RESULTS
1657: where ROWID = X_ROWID;
1658: if (sql%notfound) then

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

1657: where ROWID = X_ROWID;
1658: if (sql%notfound) then
1659: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1660: igs_ge_msg_stack.add;
1661: igs_sc_gen_001.unset_ctx('R');
1662: app_exception.raise_exception;
1663: end if;
1664: IF (x_mode = 'S') THEN
1665: igs_sc_gen_001.unset_ctx('R');

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

1661: igs_sc_gen_001.unset_ctx('R');
1662: app_exception.raise_exception;
1663: end if;
1664: IF (x_mode = 'S') THEN
1665: igs_sc_gen_001.unset_ctx('R');
1666: END IF;
1667:
1668: After_DML (
1669: p_action => 'DELETE',