DBA Data[Home] [Help]

APPS.AMW_CONSTRAINT_PVT dependencies on FND_PROFILE

Line 31: G_AMW_USER CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_USER');

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

Line 32: G_AMW_USER_RESP_GROUPS CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_USER_RESP_GROUPS');

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

Line 33: G_AMW_RESPONSIBILITY CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_RESPONSIBILITY');

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

Line 34: G_AMW_RESP_FUNCTIONS CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_RESP_FUNCTIONS');

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

Line 35: G_AMW_MENUS CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_MENUS');

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

Line 36: G_AMW_MENU_ENTRIES CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_MENU_ENTRIES');

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

Line 37: G_AMW_FORM_FUNCTIONS_VL CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_FORM_FUNCTIONS_VL');

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

Line 38: G_AMW_COMPILED_MENU_FUNCTIONS CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_COMPILED_MENU_FUNCTIONS');

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

Line 39: G_AMW_GRANTS CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_GRANTS');

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

Line 40: G_AMW_USER_ROLES CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_USER_ROLES');

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:

Line 41: G_AMW_USER_ROLE_ASSIGNMENTS CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_USER_ROLE_ASSIGNMENTS');

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:

Line 42: G_AMW_REQUEST_GROUP_UNITS CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_REQUEST_GROUP_UNITS');

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

Line 43: G_AMW_CONCURRENT_PROGRAMS_VL CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_CONCURRENT_PROGRAMS_VL');

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