27: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
28: G_SECURITY_GROUP_ID NUMBER := FND_GLOBAL.SECURITY_GROUP_ID;
29:
30: -- AMW table/view name
31: G_AMW_USER CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_USER');
32: G_AMW_USER_RESP_GROUPS CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_USER_RESP_GROUPS');
33: G_AMW_RESPONSIBILITY CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_RESPONSIBILITY');
34: G_AMW_RESP_FUNCTIONS CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_RESP_FUNCTIONS');
35: G_AMW_MENUS CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_MENUS');
28: G_SECURITY_GROUP_ID NUMBER := FND_GLOBAL.SECURITY_GROUP_ID;
29:
30: -- AMW table/view name
31: G_AMW_USER CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_USER');
32: G_AMW_USER_RESP_GROUPS CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_USER_RESP_GROUPS');
33: G_AMW_RESPONSIBILITY CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_RESPONSIBILITY');
34: G_AMW_RESP_FUNCTIONS CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_RESP_FUNCTIONS');
35: G_AMW_MENUS CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_MENUS');
36: G_AMW_MENU_ENTRIES CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_MENU_ENTRIES');
29:
30: -- AMW table/view name
31: G_AMW_USER CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_USER');
32: G_AMW_USER_RESP_GROUPS CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_USER_RESP_GROUPS');
33: G_AMW_RESPONSIBILITY CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_RESPONSIBILITY');
34: G_AMW_RESP_FUNCTIONS CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_RESP_FUNCTIONS');
35: G_AMW_MENUS CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_MENUS');
36: G_AMW_MENU_ENTRIES CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_MENU_ENTRIES');
37: G_AMW_FORM_FUNCTIONS_VL CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_FORM_FUNCTIONS_VL');
30: -- AMW table/view name
31: G_AMW_USER CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_USER');
32: G_AMW_USER_RESP_GROUPS CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_USER_RESP_GROUPS');
33: G_AMW_RESPONSIBILITY CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_RESPONSIBILITY');
34: G_AMW_RESP_FUNCTIONS CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_RESP_FUNCTIONS');
35: G_AMW_MENUS CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_MENUS');
36: G_AMW_MENU_ENTRIES CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_MENU_ENTRIES');
37: G_AMW_FORM_FUNCTIONS_VL CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_FORM_FUNCTIONS_VL');
38: G_AMW_COMPILED_MENU_FUNCTIONS CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_COMPILED_MENU_FUNCTIONS');
31: G_AMW_USER CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_USER');
32: G_AMW_USER_RESP_GROUPS CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_USER_RESP_GROUPS');
33: G_AMW_RESPONSIBILITY CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_RESPONSIBILITY');
34: G_AMW_RESP_FUNCTIONS CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_RESP_FUNCTIONS');
35: G_AMW_MENUS CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_MENUS');
36: G_AMW_MENU_ENTRIES CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_MENU_ENTRIES');
37: G_AMW_FORM_FUNCTIONS_VL CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_FORM_FUNCTIONS_VL');
38: G_AMW_COMPILED_MENU_FUNCTIONS CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_COMPILED_MENU_FUNCTIONS');
39: G_AMW_GRANTS CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_GRANTS');
32: G_AMW_USER_RESP_GROUPS CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_USER_RESP_GROUPS');
33: G_AMW_RESPONSIBILITY CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_RESPONSIBILITY');
34: G_AMW_RESP_FUNCTIONS CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_RESP_FUNCTIONS');
35: G_AMW_MENUS CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_MENUS');
36: G_AMW_MENU_ENTRIES CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_MENU_ENTRIES');
37: G_AMW_FORM_FUNCTIONS_VL CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_FORM_FUNCTIONS_VL');
38: G_AMW_COMPILED_MENU_FUNCTIONS CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_COMPILED_MENU_FUNCTIONS');
39: G_AMW_GRANTS CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_GRANTS');
40: G_AMW_USER_ROLES CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_USER_ROLES');
33: G_AMW_RESPONSIBILITY CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_RESPONSIBILITY');
34: G_AMW_RESP_FUNCTIONS CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_RESP_FUNCTIONS');
35: G_AMW_MENUS CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_MENUS');
36: G_AMW_MENU_ENTRIES CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_MENU_ENTRIES');
37: G_AMW_FORM_FUNCTIONS_VL CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_FORM_FUNCTIONS_VL');
38: G_AMW_COMPILED_MENU_FUNCTIONS CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_COMPILED_MENU_FUNCTIONS');
39: G_AMW_GRANTS CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_GRANTS');
40: G_AMW_USER_ROLES CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_USER_ROLES');
41: G_AMW_USER_ROLE_ASSIGNMENTS CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_USER_ROLE_ASSIGNMENTS');
34: G_AMW_RESP_FUNCTIONS CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_RESP_FUNCTIONS');
35: G_AMW_MENUS CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_MENUS');
36: G_AMW_MENU_ENTRIES CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_MENU_ENTRIES');
37: G_AMW_FORM_FUNCTIONS_VL CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_FORM_FUNCTIONS_VL');
38: G_AMW_COMPILED_MENU_FUNCTIONS CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_COMPILED_MENU_FUNCTIONS');
39: G_AMW_GRANTS CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_GRANTS');
40: G_AMW_USER_ROLES CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_USER_ROLES');
41: G_AMW_USER_ROLE_ASSIGNMENTS CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_USER_ROLE_ASSIGNMENTS');
42: G_AMW_REQUEST_GROUP_UNITS CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_REQUEST_GROUP_UNITS');
35: G_AMW_MENUS CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_MENUS');
36: G_AMW_MENU_ENTRIES CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_MENU_ENTRIES');
37: G_AMW_FORM_FUNCTIONS_VL CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_FORM_FUNCTIONS_VL');
38: G_AMW_COMPILED_MENU_FUNCTIONS CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_COMPILED_MENU_FUNCTIONS');
39: G_AMW_GRANTS CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_GRANTS');
40: G_AMW_USER_ROLES CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_USER_ROLES');
41: G_AMW_USER_ROLE_ASSIGNMENTS CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_USER_ROLE_ASSIGNMENTS');
42: G_AMW_REQUEST_GROUP_UNITS CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_REQUEST_GROUP_UNITS');
43: G_AMW_CONCURRENT_PROGRAMS_VL CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_CONCURRENT_PROGRAMS_VL');
36: G_AMW_MENU_ENTRIES CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_MENU_ENTRIES');
37: G_AMW_FORM_FUNCTIONS_VL CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_FORM_FUNCTIONS_VL');
38: G_AMW_COMPILED_MENU_FUNCTIONS CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_COMPILED_MENU_FUNCTIONS');
39: G_AMW_GRANTS CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_GRANTS');
40: G_AMW_USER_ROLES CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_USER_ROLES');
41: G_AMW_USER_ROLE_ASSIGNMENTS CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_USER_ROLE_ASSIGNMENTS');
42: G_AMW_REQUEST_GROUP_UNITS CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_REQUEST_GROUP_UNITS');
43: G_AMW_CONCURRENT_PROGRAMS_VL CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_CONCURRENT_PROGRAMS_VL');
44:
37: G_AMW_FORM_FUNCTIONS_VL CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_FORM_FUNCTIONS_VL');
38: G_AMW_COMPILED_MENU_FUNCTIONS CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_COMPILED_MENU_FUNCTIONS');
39: G_AMW_GRANTS CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_GRANTS');
40: G_AMW_USER_ROLES CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_USER_ROLES');
41: G_AMW_USER_ROLE_ASSIGNMENTS CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_USER_ROLE_ASSIGNMENTS');
42: G_AMW_REQUEST_GROUP_UNITS CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_REQUEST_GROUP_UNITS');
43: G_AMW_CONCURRENT_PROGRAMS_VL CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_CONCURRENT_PROGRAMS_VL');
44:
45:
38: G_AMW_COMPILED_MENU_FUNCTIONS CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_COMPILED_MENU_FUNCTIONS');
39: G_AMW_GRANTS CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_GRANTS');
40: G_AMW_USER_ROLES CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_USER_ROLES');
41: G_AMW_USER_ROLE_ASSIGNMENTS CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_USER_ROLE_ASSIGNMENTS');
42: G_AMW_REQUEST_GROUP_UNITS CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_REQUEST_GROUP_UNITS');
43: G_AMW_CONCURRENT_PROGRAMS_VL CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_CONCURRENT_PROGRAMS_VL');
44:
45:
46: -- AMW constraint
39: G_AMW_GRANTS CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_GRANTS');
40: G_AMW_USER_ROLES CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_USER_ROLES');
41: G_AMW_USER_ROLE_ASSIGNMENTS CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_USER_ROLE_ASSIGNMENTS');
42: G_AMW_REQUEST_GROUP_UNITS CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_REQUEST_GROUP_UNITS');
43: G_AMW_CONCURRENT_PROGRAMS_VL CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_CONCURRENT_PROGRAMS_VL');
44:
45:
46: -- AMW constraint
47: G_OBJ_TYPE CONSTANT VARCHAR2(80) := 'Constraint';