The following lines contain the word 'select', 'insert', 'update' or 'delete':
procedure INSERT_ROW (
PX_PROBLEM_MAP_DETAIL_ID IN OUT NOCOPY NUMBER,
P_PROBLEM_MAP_ID in NUMBER,
P_INCIDENT_TYPE_ID in NUMBER,
P_INVENTORY_ITEM_ID in NUMBER,
P_ORGANIZATION_ID in NUMBER,
P_CATEGORY_ID in NUMBER,
P_MAP_START_DATE_ACTIVE in DATE,
P_MAP_END_DATE_ACTIVE in DATE,
P_PROBLEM_CODE in VARCHAR2,
P_START_DATE_ACTIVE in DATE,
P_END_DATE_ACTIVE in DATE,
P_OBJECT_VERSION_NUMBER in NUMBER,
P_ATTRIBUTE1 in VARCHAR2,
P_ATTRIBUTE2 in VARCHAR2,
P_ATTRIBUTE3 in VARCHAR2,
P_ATTRIBUTE4 in VARCHAR2,
P_ATTRIBUTE5 in VARCHAR2,
P_ATTRIBUTE6 in VARCHAR2,
P_ATTRIBUTE7 in VARCHAR2,
P_ATTRIBUTE8 in VARCHAR2,
P_ATTRIBUTE9 in VARCHAR2,
P_ATTRIBUTE10 in VARCHAR2,
P_ATTRIBUTE11 in VARCHAR2,
P_ATTRIBUTE12 in VARCHAR2,
P_ATTRIBUTE13 in VARCHAR2,
P_ATTRIBUTE14 in VARCHAR2,
P_ATTRIBUTE15 in VARCHAR2,
P_ATTRIBUTE_CATEGORY in VARCHAR2,
P_CREATION_DATE in DATE,
P_CREATED_BY in NUMBER,
P_LAST_UPDATE_DATE in DATE,
P_LAST_UPDATED_BY in NUMBER,
P_LAST_UPDATE_LOGIN in NUMBER,
X_RETURN_STATUS OUT NOCOPY VARCHAR2,
X_MSG_COUNT OUT NOCOPY NUMBER,
X_MSG_DATA OUT NOCOPY VARCHAR2
)
is
cursor c1 is
select cs_sr_prob_code_map_detail_s.nextval
from dual;
insert into CS_SR_PROB_CODE_MAPPING_DETAIL (
PROBLEM_MAP_DETAIL_ID,
PROBLEM_MAP_ID,
INCIDENT_TYPE_ID,
INVENTORY_ITEM_ID,
ORGANIZATION_ID,
CATEGORY_ID,
MAP_START_DATE_ACTIVE,
MAP_END_DATE_ACTIVE,
PROBLEM_CODE,
START_DATE_ACTIVE,
END_DATE_ACTIVE,
OBJECT_VERSION_NUMBER,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_LOGIN,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
ATTRIBUTE_CATEGORY
) values (
PX_PROBLEM_MAP_DETAIL_ID,
P_PROBLEM_MAP_ID,
P_INCIDENT_TYPE_ID,
P_INVENTORY_ITEM_ID,
P_ORGANIZATION_ID,
P_CATEGORY_ID,
P_MAP_START_DATE_ACTIVE,
P_MAP_END_DATE_ACTIVE,
P_PROBLEM_CODE,
P_START_DATE_ACTIVE,
P_END_DATE_ACTIVE,
P_OBJECT_VERSION_NUMBER,
P_LAST_UPDATE_DATE,
P_LAST_UPDATED_BY,
P_CREATION_DATE,
P_CREATED_BY,
P_LAST_UPDATE_LOGIN,
P_ATTRIBUTE1,
P_ATTRIBUTE2,
P_ATTRIBUTE3,
P_ATTRIBUTE4,
P_ATTRIBUTE5,
P_ATTRIBUTE6,
P_ATTRIBUTE7,
P_ATTRIBUTE8,
P_ATTRIBUTE9,
P_ATTRIBUTE10,
P_ATTRIBUTE11,
P_ATTRIBUTE12,
P_ATTRIBUTE13,
P_ATTRIBUTE14,
P_ATTRIBUTE15,
P_ATTRIBUTE_CATEGORY);
end INSERT_ROW;
cursor c1 is select
PROBLEM_MAP_DETAIL_ID,
PROBLEM_MAP_ID,
INCIDENT_TYPE_ID,
INVENTORY_ITEM_ID,
ORGANIZATION_ID,
CATEGORY_ID,
MAP_START_DATE_ACTIVE,
MAP_END_DATE_ACTIVE,
PROBLEM_CODE,
START_DATE_ACTIVE,
END_DATE_ACTIVE,
OBJECT_VERSION_NUMBER,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
ATTRIBUTE_CATEGORY
from CS_SR_PROB_CODE_MAPPING_DETAIL
where PROBLEM_MAP_DETAIL_ID = P_PROBLEM_MAP_DETAIL_ID
for update of PROBLEM_MAP_DETAIL_ID nowait;
procedure UPDATE_ROW (
P_PROBLEM_MAP_DETAIL_ID in NUMBER,
P_PROBLEM_MAP_ID in NUMBER,
P_INCIDENT_TYPE_ID in NUMBER,
P_INVENTORY_ITEM_ID in NUMBER,
P_ORGANIZATION_ID in NUMBER,
P_CATEGORY_ID in NUMBER,
P_MAP_START_DATE_ACTIVE in DATE,
P_MAP_END_DATE_ACTIVE in DATE,
P_PROBLEM_CODE in VARCHAR2,
P_START_DATE_ACTIVE in DATE,
P_END_DATE_ACTIVE in DATE,
P_OBJECT_VERSION_NUMBER in NUMBER,
P_ATTRIBUTE1 in VARCHAR2,
P_ATTRIBUTE2 in VARCHAR2,
P_ATTRIBUTE3 in VARCHAR2,
P_ATTRIBUTE4 in VARCHAR2,
P_ATTRIBUTE5 in VARCHAR2,
P_ATTRIBUTE6 in VARCHAR2,
P_ATTRIBUTE7 in VARCHAR2,
P_ATTRIBUTE8 in VARCHAR2,
P_ATTRIBUTE9 in VARCHAR2,
P_ATTRIBUTE10 in VARCHAR2,
P_ATTRIBUTE11 in VARCHAR2,
P_ATTRIBUTE12 in VARCHAR2,
P_ATTRIBUTE13 in VARCHAR2,
P_ATTRIBUTE14 in VARCHAR2,
P_ATTRIBUTE15 in VARCHAR2,
P_ATTRIBUTE_CATEGORY in VARCHAR2,
P_LAST_UPDATE_DATE in DATE,
P_LAST_UPDATED_BY in NUMBER,
P_LAST_UPDATE_LOGIN in NUMBER,
X_RETURN_STATUS OUT NOCOPY VARCHAR2,
X_MSG_COUNT OUT NOCOPY NUMBER,
X_MSG_DATA OUT NOCOPY VARCHAR2
) is
begin
update CS_SR_PROB_CODE_MAPPING_DETAIL set
PROBLEM_MAP_ID = P_PROBLEM_MAP_ID,
INCIDENT_TYPE_ID = P_INCIDENT_TYPE_ID,
INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID,
ORGANIZATION_ID = P_ORGANIZATION_ID,
CATEGORY_ID = P_CATEGORY_ID,
MAP_START_DATE_ACTIVE = P_MAP_START_DATE_ACTIVE,
MAP_END_DATE_ACTIVE = P_MAP_END_DATE_ACTIVE,
PROBLEM_CODE = P_PROBLEM_CODE,
START_DATE_ACTIVE = P_START_DATE_ACTIVE,
END_DATE_ACTIVE = P_END_DATE_ACTIVE,
OBJECT_VERSION_NUMBER = P_OBJECT_VERSION_NUMBER,
ATTRIBUTE1 = P_ATTRIBUTE1,
ATTRIBUTE2 = P_ATTRIBUTE2,
ATTRIBUTE3 = P_ATTRIBUTE3,
ATTRIBUTE4 = P_ATTRIBUTE4,
ATTRIBUTE5 = P_ATTRIBUTE5,
ATTRIBUTE6 = P_ATTRIBUTE6,
ATTRIBUTE7 = P_ATTRIBUTE7,
ATTRIBUTE8 = P_ATTRIBUTE8,
ATTRIBUTE9 = P_ATTRIBUTE9,
ATTRIBUTE10 = P_ATTRIBUTE10,
ATTRIBUTE11 = P_ATTRIBUTE11,
ATTRIBUTE12 = P_ATTRIBUTE12,
ATTRIBUTE13 = P_ATTRIBUTE13,
ATTRIBUTE14 = P_ATTRIBUTE14,
ATTRIBUTE15 = P_ATTRIBUTE15,
ATTRIBUTE_CATEGORY = P_ATTRIBUTE_CATEGORY,
PROBLEM_MAP_DETAIL_ID = P_PROBLEM_MAP_DETAIL_ID,
LAST_UPDATE_DATE = P_LAST_UPDATE_DATE,
LAST_UPDATED_BY = P_LAST_UPDATED_BY,
LAST_UPDATE_LOGIN = P_LAST_UPDATE_LOGIN
where PROBLEM_MAP_DETAIL_ID = P_PROBLEM_MAP_DETAIL_ID;
end UPDATE_ROW;
procedure DELETE_ROW (
P_PROBLEM_MAP_DETAIL_ID in NUMBER
) is
begin
delete from CS_SR_PROB_CODE_MAPPING_DETAIL
where PROBLEM_MAP_DETAIL_ID = P_PROBLEM_MAP_DETAIL_ID;
end DELETE_ROW; -- Enter further code below as specified in the Package spec.