The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE Insert_Row(X_rowid IN OUT NOCOPY VARCHAR2,
X_summary_id IN OUT NOCOPY NUMBER,
X_organization_id NUMBER,
X_summary_type NUMBER,
X_summary_code VARCHAR2,
X_kanban_plan_id NUMBER,
X_node_type NUMBER,
X_source_organization_id NUMBER,
X_supplier_id NUMBER,
X_supplier_site_id NUMBER,
X_subinventory_name VARCHAR2,
X_locator_id NUMBER,
X_wip_line_id NUMBER,
X_x NUMBER,
X_y NUMBER) IS
CURSOR C1 IS SELECT rowid FROM FLM_KANBAN_SUMMARY
WHERE summary_id = X_summary_id;
CURSOR C2 IS SELECT flm_kanban_summary_s.nextval FROM sys.dual;
INSERT INTO FLM_KANBAN_SUMMARY(
SUMMARY_ID
,ORGANIZATION_ID
,SUMMARY_TYPE
,SUMMARY_CODE
,KANBAN_PLAN_ID
,CREATED_BY
,CREATION_DATE
,LAST_UPDATED_BY
,LAST_UPDATE_DATE
,LAST_UPDATE_LOGIN
,NODE_TYPE
,SOURCE_ORGANIZATION_ID
,SUPPLIER_ID
,SUPPLIER_SITE_ID
,SUBINVENTORY_NAME
,LOCATOR_ID
,WIP_LINE_ID
,X_COORDINATE
,Y_COORDINATE
) VALUES (
X_SUMMARY_ID
,X_ORGANIZATION_ID
,X_SUMMARY_TYPE
,X_SUMMARY_CODE
,X_KANBAN_PLAN_ID
,FND_GLOBAL.USER_ID
,SYSDATE
,FND_GLOBAL.USER_ID
,SYSDATE
,FND_GLOBAL.LOGIN_ID
,X_NODE_TYPE
,X_SOURCE_ORGANIZATION_ID
,X_SUPPLIER_ID
,X_SUPPLIER_SITE_ID
,X_SUBINVENTORY_NAME
,X_LOCATOR_ID
,X_WIP_LINE_ID
,X_X
,X_Y
);
END Insert_Row;
SELECT *
FROM FLM_KANBAN_SUMMARY
WHERE rowid = X_rowid
FOR UPDATE of summary_id NOWAIT;
FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
PROCEDURE Update_Row(X_rowid VARCHAR2,
X_summary_id NUMBER,
X_organization_id NUMBER,
X_summary_type NUMBER,
X_summary_code VARCHAR2,
X_kanban_plan_id NUMBER,
X_node_type NUMBER,
X_source_organization_id NUMBER,
X_supplier_id NUMBER,
X_supplier_site_id NUMBER,
X_subinventory_name VARCHAR2,
X_locator_id NUMBER,
X_wip_line_id NUMBER,
X_x NUMBER,
X_y NUMBER) IS
BEGIN
UPDATE FLM_KANBAN_SUMMARY
SET
summary_id = X_summary_id,
organization_id = X_organization_id,
summary_type = X_summary_type,
summary_code = X_summary_code,
kanban_plan_id = X_kanban_plan_id,
LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
LAST_UPDATE_DATE = SYSDATE,
LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
node_type = X_node_type,
source_organization_id = X_source_organization_id,
supplier_id = X_supplier_id,
supplier_site_id = X_supplier_site_id,
subinventory_name = X_subinventory_name,
locator_id = X_locator_id,
wip_line_id = X_wip_line_id,
x_coordinate = X_x,
y_coordinate = X_y
WHERE rowid = X_rowid;
END Update_Row;
PROCEDURE Delete_Row(X_rowid VARCHAR2) IS
BEGIN
DELETE FROM FLM_KANBAN_SUMMARY
WHERE rowid = X_Rowid;
END Delete_Row;