DBA Data[Home] [Help]

APPS.GMA_WF_GENRIC_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 25

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

	SORTED_DATA(i).LAST_UPDATE_LOGIN   :=DATA_REC.LAST_UPDATE_LOGIN;
Line: 60

	SORTED_DATA(i).LAST_UPDATED_BY     :=DATA_REC.LAST_UPDATED_BY;
Line: 63

	SORTED_DATA(i).LAST_UPDATE_DATE    :=DATA_REC.LAST_UPDATE_DATE;
Line: 65

      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);
Line: 107

  SELECT count(*) INTO no_cols
  from  GMA_ACTCOL_WF_B
  WHERE ACTIVITY_ID = P_ACTIVITY_ID;
Line: 186

	SORTED_DATA(i).LAST_UPDATE_LOGIN   :=DATA_REC.LAST_UPDATE_LOGIN;
Line: 187

	SORTED_DATA(i).LAST_UPDATED_BY     :=DATA_REC.LAST_UPDATED_BY;
Line: 190

	SORTED_DATA(i).LAST_UPDATE_DATE    :=DATA_REC.LAST_UPDATE_DATE;
Line: 192

      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);
Line: 258

  sql_stmt := 'SELECT * FROM GMA_PROCDATA_WF WHERE WF_ITEM_TYPE = ' ||''''||P_WF_ITEM_TYPE ||'''' ||
              '   AND  PROCESS_NAME  = ' || ''''||P_PROCESS_NAME ||'''' ||'   ';
Line: 294

	SORTED_DATA(i).LAST_UPDATE_LOGIN   :=DATA_REC.LAST_UPDATE_LOGIN;
Line: 295

	SORTED_DATA(i).LAST_UPDATED_BY     :=DATA_REC.LAST_UPDATED_BY;
Line: 298

	SORTED_DATA(i).LAST_UPDATE_DATE    :=DATA_REC.LAST_UPDATE_DATE;
Line: 300

      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);
Line: 343

  SELECT count(*) INTO no_cols
  from  GMA_PROCCOL_WF_B
  WHERE WF_ITEM_TYPE = P_WF_ITEM_TYPE
    AND PROCESS_NAME = P_PROCESS_NAME;
Line: 424

	SORTED_DATA(i).LAST_UPDATE_LOGIN   :=DATA_REC.LAST_UPDATE_LOGIN;
Line: 425

	SORTED_DATA(i).LAST_UPDATED_BY     :=DATA_REC.LAST_UPDATED_BY;
Line: 428

	SORTED_DATA(i).LAST_UPDATE_DATE    :=DATA_REC.LAST_UPDATE_DATE;
Line: 430

      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);