APPS.GMA_WF_GENRIC_PKG dependencies on GMA_PROCDATA_WF

Line 241: DATA_REC GMA_PROCDATA_WF%ROWTYPE;

237: SORTED_DATA IN OUT NOCOPY PROC_SORTED_DATA_TBL_TYPE) IS
238: TYPE RETRIEVE_DATA IS REF CURSOR;
239: RET_DATA RETRIEVE_DATA; -- declare cursor variable
240: sql_stmt VARCHAR2(300);
241: DATA_REC GMA_PROCDATA_WF%ROWTYPE;
242: COUNTER1 NUMBER(5) := 10;
243: l_where1 VARCHAR2(40) := ' AND COLUMN_VALUE1 IS NOT NULL ';
244: l_where2 VARCHAR2(40) := ' AND COLUMN_VALUE2 IS NOT NULL ';
245: l_where3 VARCHAR2(40) := ' AND COLUMN_VALUE3 IS NOT NULL ';

Line 258: sql_stmt := 'SELECT * FROM GMA_PROCDATA_WF WHERE WF_ITEM_TYPE = ' ||''''||P_WF_ITEM_TYPE ||'''' ||

254: no_cols NUMBER(5);
255: set_where NUMBER(5);
256: i INTEGER := 1;
257: BEGIN
258: sql_stmt := 'SELECT * FROM GMA_PROCDATA_WF WHERE WF_ITEM_TYPE = ' ||''''||P_WF_ITEM_TYPE ||'''' ||
259: ' AND PROCESS_NAME = ' || ''''||P_PROCESS_NAME ||'''' ||' ';
260: LOOP
261: IF COUNTER1 > 0 THEN
262: /* Make the last column value in hierarchy NULL */

Line 300: UPDATE GMA_PROCDATA_WF

296: SORTED_DATA(i).CREATED_BY :=DATA_REC.CREATED_BY;
297: SORTED_DATA(i).CREATION_DATE :=DATA_REC.CREATION_DATE;
298: SORTED_DATA(i).LAST_UPDATE_DATE :=DATA_REC.LAST_UPDATE_DATE;
299: SORTED_DATA(i).ENABLE_FLAG :=DATA_REC.ENABLE_FLAG;
300: UPDATE GMA_PROCDATA_WF
301: SET SORT_ORDER = i
302: WHERE WF_ITEM_TYPE = DATA_REC.WF_ITEM_TYPE
303: AND PROCESS_NAME = DATA_REC.PROCESS_NAME
304: AND NVL(COLUMN_VALUE1,0) = NVL(DATA_REC.COLUMN_VALUE1,0)

Line 430: UPDATE GMA_PROCDATA_WF

426: SORTED_DATA(i).CREATED_BY :=DATA_REC.CREATED_BY;
427: SORTED_DATA(i).CREATION_DATE :=DATA_REC.CREATION_DATE;
428: SORTED_DATA(i).LAST_UPDATE_DATE :=DATA_REC.LAST_UPDATE_DATE;
429: SORTED_DATA(i).ENABLE_FLAG :=DATA_REC.ENABLE_FLAG;
430: UPDATE GMA_PROCDATA_WF
431: SET SORT_ORDER = i
432: WHERE WF_ITEM_TYPE = DATA_REC.WF_ITEM_TYPE
433: AND PROCESS_NAME = DATA_REC.PROCESS_NAME
434: AND NVL(COLUMN_VALUE1,0) = NVL(DATA_REC.COLUMN_VALUE1,0)