The following lines contain the word 'select', 'insert', 'update' or 'delete':
sql_stmt := 'SELECT * FROM GMA_ACTDATA_WF WHERE ACTIVITY_ID = ' ||P_ACTIVITY_ID;
SORTED_DATA(i).LAST_UPDATE_LOGIN :=DATA_REC.LAST_UPDATE_LOGIN;
SORTED_DATA(i).LAST_UPDATED_BY :=DATA_REC.LAST_UPDATED_BY;
SORTED_DATA(i).LAST_UPDATE_DATE :=DATA_REC.LAST_UPDATE_DATE;
UPDATE GMA_ACTDATA_WF
SET SORT_ORDER = i
WHERE ACTIVITY_ID = DATA_REC.ACTIVITY_ID
AND NVL(COLUMN_VALUE1,0) = NVL(DATA_REC.COLUMN_VALUE1,0)
AND NVL(COLUMN_VALUE2,0) = NVL(DATA_REC.COLUMN_VALUE2,0)
AND NVL(COLUMN_VALUE3,0) =NVL(DATA_REC.COLUMN_VALUE3,0)
AND NVL(COLUMN_VALUE4,0) =NVL(DATA_REC.COLUMN_VALUE4,0)
AND NVL(COLUMN_VALUE5,0) =NVL(DATA_REC.COLUMN_VALUE5,0)
AND NVL(COLUMN_VALUE6,0) =NVL(DATA_REC.COLUMN_VALUE6,0)
AND NVL(COLUMN_VALUE7,0) =NVL(DATA_REC.COLUMN_VALUE7,0)
AND NVL(COLUMN_VALUE8,0) =NVL(DATA_REC.COLUMN_VALUE8,0)
AND NVL(COLUMN_VALUE9,0) =NVL(DATA_REC.COLUMN_VALUE9,0)
AND NVL(COLUMN_VALUE10,0)=NVL(DATA_REC.COLUMN_VALUE10,0);
SELECT count(*) INTO no_cols
from GMA_ACTCOL_WF_B
WHERE ACTIVITY_ID = P_ACTIVITY_ID;
SORTED_DATA(i).LAST_UPDATE_LOGIN :=DATA_REC.LAST_UPDATE_LOGIN;
SORTED_DATA(i).LAST_UPDATED_BY :=DATA_REC.LAST_UPDATED_BY;
SORTED_DATA(i).LAST_UPDATE_DATE :=DATA_REC.LAST_UPDATE_DATE;
UPDATE GMA_ACTDATA_WF
SET SORT_ORDER = i
WHERE ACTIVITY_ID = DATA_REC.ACTIVITY_ID
AND NVL(COLUMN_VALUE1,0) = NVL(DATA_REC.COLUMN_VALUE1,0)
AND NVL(COLUMN_VALUE2,0) = NVL(DATA_REC.COLUMN_VALUE2,0)
AND NVL(COLUMN_VALUE3,0) =NVL(DATA_REC.COLUMN_VALUE3,0)
AND NVL(COLUMN_VALUE4,0) =NVL(DATA_REC.COLUMN_VALUE4,0)
AND NVL(COLUMN_VALUE5,0) =NVL(DATA_REC.COLUMN_VALUE5,0)
AND NVL(COLUMN_VALUE6,0) =NVL(DATA_REC.COLUMN_VALUE6,0)
AND NVL(COLUMN_VALUE7,0) =NVL(DATA_REC.COLUMN_VALUE7,0)
AND NVL(COLUMN_VALUE8,0) =NVL(DATA_REC.COLUMN_VALUE8,0)
AND NVL(COLUMN_VALUE9,0) =NVL(DATA_REC.COLUMN_VALUE9,0)
AND NVL(COLUMN_VALUE10,0)=NVL(DATA_REC.COLUMN_VALUE10,0);
sql_stmt := 'SELECT * FROM GMA_PROCDATA_WF WHERE WF_ITEM_TYPE = ' ||''''||P_WF_ITEM_TYPE ||'''' ||
' AND PROCESS_NAME = ' || ''''||P_PROCESS_NAME ||'''' ||' ';
SORTED_DATA(i).LAST_UPDATE_LOGIN :=DATA_REC.LAST_UPDATE_LOGIN;
SORTED_DATA(i).LAST_UPDATED_BY :=DATA_REC.LAST_UPDATED_BY;
SORTED_DATA(i).LAST_UPDATE_DATE :=DATA_REC.LAST_UPDATE_DATE;
UPDATE GMA_PROCDATA_WF
SET SORT_ORDER = i
WHERE WF_ITEM_TYPE = DATA_REC.WF_ITEM_TYPE
AND PROCESS_NAME = DATA_REC.PROCESS_NAME
AND NVL(COLUMN_VALUE1,0) = NVL(DATA_REC.COLUMN_VALUE1,0)
AND NVL(COLUMN_VALUE2,0) = NVL(DATA_REC.COLUMN_VALUE2,0)
AND NVL(COLUMN_VALUE3,0) =NVL(DATA_REC.COLUMN_VALUE3,0)
AND NVL(COLUMN_VALUE4,0) =NVL(DATA_REC.COLUMN_VALUE4,0)
AND NVL(COLUMN_VALUE5,0) =NVL(DATA_REC.COLUMN_VALUE5,0)
AND NVL(COLUMN_VALUE6,0) =NVL(DATA_REC.COLUMN_VALUE6,0)
AND NVL(COLUMN_VALUE7,0) =NVL(DATA_REC.COLUMN_VALUE7,0)
AND NVL(COLUMN_VALUE8,0) =NVL(DATA_REC.COLUMN_VALUE8,0)
AND NVL(COLUMN_VALUE9,0) =NVL(DATA_REC.COLUMN_VALUE9,0)
AND NVL(COLUMN_VALUE10,0)=NVL(DATA_REC.COLUMN_VALUE10,0);
SELECT count(*) INTO no_cols
from GMA_PROCCOL_WF_B
WHERE WF_ITEM_TYPE = P_WF_ITEM_TYPE
AND PROCESS_NAME = P_PROCESS_NAME;
SORTED_DATA(i).LAST_UPDATE_LOGIN :=DATA_REC.LAST_UPDATE_LOGIN;
SORTED_DATA(i).LAST_UPDATED_BY :=DATA_REC.LAST_UPDATED_BY;
SORTED_DATA(i).LAST_UPDATE_DATE :=DATA_REC.LAST_UPDATE_DATE;
UPDATE GMA_PROCDATA_WF
SET SORT_ORDER = i
WHERE WF_ITEM_TYPE = DATA_REC.WF_ITEM_TYPE
AND PROCESS_NAME = DATA_REC.PROCESS_NAME
AND NVL(COLUMN_VALUE1,0) = NVL(DATA_REC.COLUMN_VALUE1,0)
AND NVL(COLUMN_VALUE2,0) = NVL(DATA_REC.COLUMN_VALUE2,0)
AND NVL(COLUMN_VALUE3,0) =NVL(DATA_REC.COLUMN_VALUE3,0)
AND NVL(COLUMN_VALUE4,0) =NVL(DATA_REC.COLUMN_VALUE4,0)
AND NVL(COLUMN_VALUE5,0) =NVL(DATA_REC.COLUMN_VALUE5,0)
AND NVL(COLUMN_VALUE6,0) =NVL(DATA_REC.COLUMN_VALUE6,0)
AND NVL(COLUMN_VALUE7,0) =NVL(DATA_REC.COLUMN_VALUE7,0)
AND NVL(COLUMN_VALUE8,0) =NVL(DATA_REC.COLUMN_VALUE8,0)
AND NVL(COLUMN_VALUE9,0) =NVL(DATA_REC.COLUMN_VALUE9,0)
AND NVL(COLUMN_VALUE10,0)=NVL(DATA_REC.COLUMN_VALUE10,0);