15: TYPE G_VARCHAR2_LONG_TABLE is table of VARCHAR2(320) INDEX BY BINARY_INTEGER;
16: TYPE G_VARCHAR2_CODE_TABLE IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;
17: TYPE G_VARCHAR2_HASHTABLE IS TABLE OF VARCHAR2(400) INDEX BY VARCHAR2(64);
18:
19: -- FND_GLOBAL
20: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
21: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
22:
23: -- AMW table/view name
16: TYPE G_VARCHAR2_CODE_TABLE IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;
17: TYPE G_VARCHAR2_HASHTABLE IS TABLE OF VARCHAR2(400) INDEX BY VARCHAR2(64);
18:
19: -- FND_GLOBAL
20: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
21: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
22:
23: -- AMW table/view name
24: G_AMW_USER CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_USER');
17: TYPE G_VARCHAR2_HASHTABLE IS TABLE OF VARCHAR2(400) INDEX BY VARCHAR2(64);
18:
19: -- FND_GLOBAL
20: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
21: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
22:
23: -- AMW table/view name
24: G_AMW_USER CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_USER');
25: G_AMW_USER_RESP_GROUPS CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_USER_RESP_GROUPS');