[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT COLUMN_NAME
FROM gma_actcol_wf_b
WHERE activity_id = X_activity_id
ORDER BY Column_hierarchy;
SELECT role
FROM gma_actdata_wf
WHERE activity_id = X_activity_id AND
nvl(column_name1,0) = nvl(X_column_name1,0) AND
nvl(column_value1,0) = nvl(X_column_value1,0) AND
nvl(column_name2,0) = nvl(X_column_name2,0) AND
nvl(column_value2,0) = nvl(X_column_value2,0) AND
nvl(column_name3,0) = nvl(X_column_name3,0) AND
nvl(column_value3,0) = nvl(X_column_value3,0) AND
nvl(column_name4,0) = nvl(X_column_name4,0) AND
nvl(column_value4,0) = nvl(X_column_value4,0) AND
nvl(column_name5,0) = nvl(X_column_name5,0) AND
nvl(column_value5,0) = nvl(X_column_value5,0) AND
nvl(column_name6,0) = nvl(X_column_name6,0) AND
nvl(column_value6,0) = nvl(X_column_value6,0) AND
nvl(column_name7,0) = nvl(X_column_name7,0) AND
nvl(column_value7,0) = nvl(X_column_value7,0) AND
nvl(column_name8,0) = nvl(X_column_name8,0) AND
nvl(column_value8,0) = nvl(X_column_value8,0) AND
nvl(column_name9,0) = nvl(X_column_name9,0) AND
nvl(column_value9,0) = nvl(X_column_value9,0) AND
nvl(column_name10,0) = nvl(X_column_name10,0) AND
nvl(column_value10,0) = nvl(X_column_value10,0);
SELECT activity_id into l_activity_id
FROM gma_actdef_wf
WHERE wf_item_type = p_wf_item_type AND
process_name = p_process_name AND
activity_name = p_activity_name;
SELECT COLUMN_NAME
FROM gma_proccol_wf_b
WHERE wf_item_type = X_wf_item_type
AND process_name = X_process_name
ORDER BY Column_hierarchy;
SELECT ENABLE_FLAG
FROM gma_procdata_wf
WHERE wf_item_type = X_wf_item_type AND
process_name = X_process_name AND
nvl(column_name1,0) = nvl(X_column_name1,0) AND
nvl(column_value1,0) = nvl(X_column_value1,0) AND
nvl(column_name2,0) = nvl(X_column_name2,0) AND
nvl(column_value2,0) = nvl(X_column_value2,0) AND
nvl(column_name3,0) = nvl(X_column_name3,0) AND
nvl(column_value3,0) = nvl(X_column_value3,0) AND
nvl(column_name4,0) = nvl(X_column_name4,0) AND
nvl(column_value4,0) = nvl(X_column_value4,0) AND
nvl(column_name5,0) = nvl(X_column_name5,0) AND
nvl(column_value5,0) = nvl(X_column_value5,0) AND
nvl(column_name6,0) = nvl(X_column_name6,0) AND
nvl(column_value6,0) = nvl(X_column_value6,0) AND
nvl(column_name7,0) = nvl(X_column_name7,0) AND
nvl(column_value7,0) = nvl(X_column_value7,0) AND
nvl(column_name8,0) = nvl(X_column_name8,0) AND
nvl(column_value8,0) = nvl(X_column_value8,0) AND
nvl(column_name9,0) = nvl(X_column_name9,0) AND
nvl(column_value9,0) = nvl(X_column_value9,0) AND
nvl(column_name10,0) = nvl(X_column_name10,0) AND
nvl(column_value10,0) = nvl(X_column_value10,0);
SELECT COLUMN_NAME
FROM gma_actcol_wf_b
WHERE activity_id = X_activity_id
ORDER BY Column_hierarchy;
SELECT ENABLE_FLAG
FROM gma_actdata_wf
WHERE activity_id = X_activity_id AND
nvl(column_name1,0) = nvl(X_column_name1,0) AND
nvl(column_value1,0) = nvl(X_column_value1,0) AND
nvl(column_name2,0) = nvl(X_column_name2,0) AND
nvl(column_value2,0) = nvl(X_column_value2,0) AND
nvl(column_name3,0) = nvl(X_column_name3,0) AND
nvl(column_value3,0) = nvl(X_column_value3,0) AND
nvl(column_name4,0) = nvl(X_column_name4,0) AND
nvl(column_value4,0) = nvl(X_column_value4,0) AND
nvl(column_name5,0) = nvl(X_column_name5,0) AND
nvl(column_value5,0) = nvl(X_column_value5,0) AND
nvl(column_name6,0) = nvl(X_column_name6,0) AND
nvl(column_value6,0) = nvl(X_column_value6,0) AND
nvl(column_name7,0) = nvl(X_column_name7,0) AND
nvl(column_value7,0) = nvl(X_column_value7,0) AND
nvl(column_name8,0) = nvl(X_column_name8,0) AND
nvl(column_value8,0) = nvl(X_column_value8,0) AND
nvl(column_name9,0) = nvl(X_column_name9,0) AND
nvl(column_value9,0) = nvl(X_column_value9,0) AND
nvl(column_name10,0) = nvl(X_column_name10,0) AND
nvl(column_value10,0) = nvl(X_column_value10,0);
SELECT activity_id into l_activity_id
FROM gma_actdef_wf
WHERE wf_item_type = p_wf_item_type AND
process_name = p_process_name AND
activity_name = p_activity_name;
SELECT enable_flag INTO l_enable_flag
FROM GMA_PROCDEF_WF
WHERE wf_item_type = p_wf_item_type AND
process_name = p_process_name;
SELECT COLUMN_NAME,COLUMN_PROMPT
FROM gma_actcol_wf_vl
WHERE activity_id = l_activity_id
ORDER BY Column_hierarchy;
SELECT COLUMN_NAME,COLUMN_PROMPT
FROM gma_proccol_wf_vl
WHERE WF_ITEM_TYPE = P_WF_ITEM_TYPE AND
PROCESS_NAME = p_PROCESS_NAME
ORDER BY Column_hierarchy;
SELECT column_data_sql into l_sql_stmt
FROM GMA_PROCDEF_WF
WHERE WF_ITEM_TYPE = P_WF_ITEM_TYPE AND
PROCESS_NAME = p_PROCESS_NAME;
SELECT column_data_sql,activity_id into l_sql_stmt,l_activity_id
FROM GMA_ACTDEF_WF
WHERE WF_ITEM_TYPE = P_WF_ITEM_TYPE AND
PROCESS_NAME = p_PROCESS_NAME AND
ACTIVITY_NAME= P_ACTIVITY_NAME;