APPS.IGS_PE_PERS_DISABLTY_PKG dependencies on IGS_SC_GEN_001

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

960: x_last_updated_by=>X_LAST_UPDATED_BY,
961: x_last_update_login=>X_LAST_UPDATE_LOGIN);
962:
963: IF (x_mode = 'S') THEN
964: igs_sc_gen_001.set_ctx('R');
965: END IF;
966: insert into IGS_PE_PERS_DISABLTY (
967: IGS_PE_PERS_DISABLTY_ID
968: ,PERSON_ID

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

1046: ,X_LAST_UPDATED_BY
1047: ,X_LAST_UPDATE_LOGIN
1048: );
1049: IF (x_mode = 'S') THEN
1050: igs_sc_gen_001.unset_ctx('R');
1051: END IF;
1052:
1053: open c;
1054: fetch c into X_ROWID;

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

1065: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
1066: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
1067: fnd_message.set_token ('ERR_CD', SQLCODE);
1068: igs_ge_msg_stack.add;
1069: igs_sc_gen_001.unset_ctx('R');
1070: app_exception.raise_exception;
1071: ELSE
1072: igs_sc_gen_001.unset_ctx('R');
1073: RAISE;

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

1068: igs_ge_msg_stack.add;
1069: igs_sc_gen_001.unset_ctx('R');
1070: app_exception.raise_exception;
1071: ELSE
1072: igs_sc_gen_001.unset_ctx('R');
1073: RAISE;
1074: END IF;
1075:
1076: end INSERT_ROW;

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

1372: x_last_update_date=>X_LAST_UPDATE_DATE,
1373: x_last_updated_by=>X_LAST_UPDATED_BY,
1374: x_last_update_login=>X_LAST_UPDATE_LOGIN);
1375: IF (x_mode = 'S') THEN
1376: igs_sc_gen_001.set_ctx('R');
1377: END IF;
1378: update IGS_PE_PERS_DISABLTY set
1379: SPECIAL_ALLOW_CD = NEW_REFERENCES.SPECIAL_ALLOW_CD,
1380: SUPPORT_LEVEL_CD = NEW_REFERENCES.SUPPORT_LEVEL_CD,

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

1411: where ROWID = X_ROWID;
1412: if (sql%notfound) then
1413: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1414: igs_ge_msg_stack.add;
1415: igs_sc_gen_001.unset_ctx('R');
1416: app_exception.raise_exception;
1417: end if;
1418: IF (x_mode = 'S') THEN
1419: igs_sc_gen_001.unset_ctx('R');

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

1415: igs_sc_gen_001.unset_ctx('R');
1416: app_exception.raise_exception;
1417: end if;
1418: IF (x_mode = 'S') THEN
1419: igs_sc_gen_001.unset_ctx('R');
1420: END IF;
1421:
1422:
1423: After_DML (

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

1429: IF (SQLCODE = (-28115)) THEN
1430: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
1431: fnd_message.set_token ('ERR_CD', SQLCODE);
1432: igs_ge_msg_stack.add;
1433: igs_sc_gen_001.unset_ctx('R');
1434: app_exception.raise_exception;
1435: ELSE
1436: igs_sc_gen_001.unset_ctx('R');
1437: RAISE;

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

1432: igs_ge_msg_stack.add;
1433: igs_sc_gen_001.unset_ctx('R');
1434: app_exception.raise_exception;
1435: ELSE
1436: igs_sc_gen_001.unset_ctx('R');
1437: RAISE;
1438: END IF;
1439:
1440: end UPDATE_ROW;

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

1598: p_action => 'DELETE',
1599: x_rowid => X_ROWID
1600: );
1601: IF (x_mode = 'S') THEN
1602: igs_sc_gen_001.set_ctx('R');
1603: END IF;
1604: delete from IGS_PE_PERS_DISABLTY
1605: where ROWID = X_ROWID;
1606: if (sql%notfound) then

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

1605: where ROWID = X_ROWID;
1606: if (sql%notfound) then
1607: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1608: igs_ge_msg_stack.add;
1609: igs_sc_gen_001.unset_ctx('R');
1610: app_exception.raise_exception;
1611: end if;
1612: IF (x_mode = 'S') THEN
1613: igs_sc_gen_001.unset_ctx('R');

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

1609: igs_sc_gen_001.unset_ctx('R');
1610: app_exception.raise_exception;
1611: end if;
1612: IF (x_mode = 'S') THEN
1613: igs_sc_gen_001.unset_ctx('R');
1614: END IF;
1615:
1616: After_DML (
1617: p_action => 'DELETE',