eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

PACKAGE: APPS.GMA_WF_GENRIC_PKG

Source


1 PACKAGE GMA_WF_GENRIC_PKG AUTHID CURRENT_USER AS
2 /*$Header: GMAWSRTS.pls 115.3 2002/12/03 22:41:24 appldev noship $*/
3   TYPE GMA_ACTDAT_WF_ROW  IS RECORD
4  (ACTIVITY_ID  NUMBER(10)
5  ,COLUMN_NAME1    VARCHAR2(32)
6  ,COLUMN_VALUE1   VARCHAR2(240)
7  ,COLUMN_NAME2    VARCHAR2(32)
8  ,COLUMN_VALUE2   VARCHAR2(240)
9  ,COLUMN_NAME3    VARCHAR2(32)
10  ,COLUMN_VALUE3   VARCHAR2(240)
11  ,COLUMN_NAME4    VARCHAR2(32)
12  ,COLUMN_VALUE4   VARCHAR2(240)
13  ,COLUMN_NAME5    VARCHAR2(32)
14  ,COLUMN_VALUE5   VARCHAR2(240)
15  ,COLUMN_NAME6    VARCHAR2(32)
16  ,COLUMN_VALUE6   VARCHAR2(240)
17  ,COLUMN_NAME7    VARCHAR2(32)
18  ,COLUMN_VALUE7   VARCHAR2(240)
19  ,COLUMN_NAME8    VARCHAR2(32)
20  ,COLUMN_VALUE8   VARCHAR2(240)
21  ,COLUMN_NAME9    VARCHAR2(32)
22  ,COLUMN_VALUE9   VARCHAR2(240)
23  ,COLUMN_NAME10   VARCHAR2(32)
24  ,COLUMN_VALUE10    VARCHAR2(240)
25  ,ROLE                 VARCHAR2(30)
26  ,LAST_UPDATE_LOGIN     NUMBER(15)
27  ,LAST_UPDATED_BY    NUMBER(15)
28  ,CREATED_BY        NUMBER(15)
29  ,CREATION_DATE      DATE
30  ,LAST_UPDATE_DATE   DATE
31  ,ENABLE_FLAG        CHAR(1));
32 
33  TYPE ACT_SORTED_DATA_TBL_TYPE IS TABLE OF GMA_ACTDAT_WF_ROW INDEX BY BINARY_INTEGER;
34 
35 
36   TYPE GMA_PROCDAT_WF_ROW  IS RECORD
37  (WF_ITEM_TYPE    VARCHAR2(8)
38  ,PROCESS_NAME    VARCHAR2(30)
39  ,COLUMN_NAME1    VARCHAR2(32)
40  ,COLUMN_VALUE1   VARCHAR2(240)
41  ,COLUMN_NAME2    VARCHAR2(32)
42  ,COLUMN_VALUE2   VARCHAR2(240)
43  ,COLUMN_NAME3    VARCHAR2(32)
44  ,COLUMN_VALUE3   VARCHAR2(240)
45  ,COLUMN_NAME4    VARCHAR2(32)
46  ,COLUMN_VALUE4   VARCHAR2(240)
47  ,COLUMN_NAME5    VARCHAR2(32)
48  ,COLUMN_VALUE5   VARCHAR2(240)
49  ,COLUMN_NAME6    VARCHAR2(32)
50  ,COLUMN_VALUE6   VARCHAR2(240)
51  ,COLUMN_NAME7    VARCHAR2(32)
52  ,COLUMN_VALUE7   VARCHAR2(240)
53  ,COLUMN_NAME8    VARCHAR2(32)
54  ,COLUMN_VALUE8   VARCHAR2(240)
55  ,COLUMN_NAME9    VARCHAR2(32)
56  ,COLUMN_VALUE9   VARCHAR2(240)
57  ,COLUMN_NAME10   VARCHAR2(32)
58  ,COLUMN_VALUE10    VARCHAR2(240)
59  ,ROLE                 VARCHAR2(30)
60  ,LAST_UPDATE_LOGIN     NUMBER(15)
61  ,LAST_UPDATED_BY    NUMBER(15)
62  ,CREATED_BY        NUMBER(15)
63  ,CREATION_DATE      DATE
64  ,LAST_UPDATE_DATE   DATE
65  ,ENABLE_FLAG        CHAR(1));
66 
67  TYPE PROC_SORTED_DATA_TBL_TYPE IS TABLE OF GMA_PROCDAT_WF_ROW INDEX BY BINARY_INTEGER;
68 
69  PROCEDURE SORT_ACT_DATA (P_ACTIVITY_ID NUMBER,
70                       SORTED_DATA IN OUT NOCOPY ACT_SORTED_DATA_TBL_TYPE);
71  PROCEDURE SORT_PROC_DATA (P_WF_ITEM_TYPE VARCHAR2,
72                           P_PROCESS_NAME VARCHAR2,
73                       SORTED_DATA IN OUT NOCOPY PROC_SORTED_DATA_TBL_TYPE);
74 END GMA_WF_GENRIC_PKG;
75 
76 
77