APPS.GMA_WF_GENRIC_PKG dependencies on GMA_ACTDATA_WF

Line 8: DATA_REC GMA_ACTDATA_WF%ROWTYPE;

4: SORTED_DATA IN OUT NOCOPY ACT_SORTED_DATA_TBL_TYPE) AS
5: TYPE RETRIEVE_DATA IS REF CURSOR;
6: RET_DATA RETRIEVE_DATA; -- declare cursor variable
7: sql_stmt VARCHAR2(300);
8: DATA_REC GMA_ACTDATA_WF%ROWTYPE;
9: COUNTER1 NUMBER(5) := 10;
10: l_where1 VARCHAR2(40) := ' AND COLUMN_VALUE1 IS NOT NULL ';
11: l_where2 VARCHAR2(40) := ' AND COLUMN_VALUE2 IS NOT NULL ';
12: l_where3 VARCHAR2(40) := ' AND COLUMN_VALUE3 IS NOT NULL ';

Line 25: sql_stmt := 'SELECT * FROM GMA_ACTDATA_WF WHERE ACTIVITY_ID = ' ||P_ACTIVITY_ID;

21: no_cols NUMBER(5);
22: set_where NUMBER(5);
23: i INTEGER := 1;
24: BEGIN
25: sql_stmt := 'SELECT * FROM GMA_ACTDATA_WF WHERE ACTIVITY_ID = ' ||P_ACTIVITY_ID;
26: LOOP
27: IF COUNTER1 > 0 THEN
28: /* Make the last column value in hierarchy NULL */
29: sql_stmt1 := sql_stmt || l_where1 || l_where2 || l_where3

Line 65: UPDATE GMA_ACTDATA_WF

61: SORTED_DATA(i).CREATED_BY :=DATA_REC.CREATED_BY;
62: SORTED_DATA(i).CREATION_DATE :=DATA_REC.CREATION_DATE;
63: SORTED_DATA(i).LAST_UPDATE_DATE :=DATA_REC.LAST_UPDATE_DATE;
64: SORTED_DATA(i).ENABLE_FLAG :=DATA_REC.ENABLE_FLAG;
65: UPDATE GMA_ACTDATA_WF
66: SET SORT_ORDER = i
67: WHERE ACTIVITY_ID = DATA_REC.ACTIVITY_ID
68: AND NVL(COLUMN_VALUE1,0) = NVL(DATA_REC.COLUMN_VALUE1,0)
69: AND NVL(COLUMN_VALUE2,0) = NVL(DATA_REC.COLUMN_VALUE2,0)

Line 192: UPDATE GMA_ACTDATA_WF

188: SORTED_DATA(i).CREATED_BY :=DATA_REC.CREATED_BY;
189: SORTED_DATA(i).CREATION_DATE :=DATA_REC.CREATION_DATE;
190: SORTED_DATA(i).LAST_UPDATE_DATE :=DATA_REC.LAST_UPDATE_DATE;
191: SORTED_DATA(i).ENABLE_FLAG :=DATA_REC.ENABLE_FLAG;
192: UPDATE GMA_ACTDATA_WF
193: SET SORT_ORDER = i
194: WHERE ACTIVITY_ID = DATA_REC.ACTIVITY_ID
195: AND NVL(COLUMN_VALUE1,0) = NVL(DATA_REC.COLUMN_VALUE1,0)
196: AND NVL(COLUMN_VALUE2,0) = NVL(DATA_REC.COLUMN_VALUE2,0)