DBA Data[Home] [Help]

APPS.AMW_VIOLATION_PVT dependencies on FND_PROFILE

Line 24: G_AMW_USER CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_USER');

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');
26: G_AMW_RESPONSIBILITY CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_RESPONSIBILITY');
27: G_AMW_RESP_FUNCTIONS CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_RESP_FUNCTIONS');
28: G_AMW_MENUS CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_MENUS');

Line 25: G_AMW_USER_RESP_GROUPS CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_USER_RESP_GROUPS');

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');
26: G_AMW_RESPONSIBILITY CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_RESPONSIBILITY');
27: G_AMW_RESP_FUNCTIONS CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_RESP_FUNCTIONS');
28: G_AMW_MENUS CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_MENUS');
29: G_AMW_MENU_ENTRIES CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_MENU_ENTRIES');

Line 26: G_AMW_RESPONSIBILITY CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_RESPONSIBILITY');

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');
26: G_AMW_RESPONSIBILITY CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_RESPONSIBILITY');
27: G_AMW_RESP_FUNCTIONS CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_RESP_FUNCTIONS');
28: G_AMW_MENUS CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_MENUS');
29: G_AMW_MENU_ENTRIES CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_MENU_ENTRIES');
30: G_AMW_FORM_FUNCTIONS_VL CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_FORM_FUNCTIONS_VL');

Line 27: G_AMW_RESP_FUNCTIONS CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_RESP_FUNCTIONS');

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');
26: G_AMW_RESPONSIBILITY CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_RESPONSIBILITY');
27: G_AMW_RESP_FUNCTIONS CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_RESP_FUNCTIONS');
28: G_AMW_MENUS CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_MENUS');
29: G_AMW_MENU_ENTRIES CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_MENU_ENTRIES');
30: G_AMW_FORM_FUNCTIONS_VL CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_FORM_FUNCTIONS_VL');
31: G_AMW_COMPILED_MENU_FUNCTIONS CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_COMPILED_MENU_FUNCTIONS');

Line 28: G_AMW_MENUS CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_MENUS');

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');
26: G_AMW_RESPONSIBILITY CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_RESPONSIBILITY');
27: G_AMW_RESP_FUNCTIONS CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_RESP_FUNCTIONS');
28: G_AMW_MENUS CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_MENUS');
29: G_AMW_MENU_ENTRIES CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_MENU_ENTRIES');
30: G_AMW_FORM_FUNCTIONS_VL CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_FORM_FUNCTIONS_VL');
31: G_AMW_COMPILED_MENU_FUNCTIONS CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_COMPILED_MENU_FUNCTIONS');
32: G_AMW_GRANTS CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_GRANTS');

Line 29: G_AMW_MENU_ENTRIES CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_MENU_ENTRIES');

25: G_AMW_USER_RESP_GROUPS CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_USER_RESP_GROUPS');
26: G_AMW_RESPONSIBILITY CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_RESPONSIBILITY');
27: G_AMW_RESP_FUNCTIONS CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_RESP_FUNCTIONS');
28: G_AMW_MENUS CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_MENUS');
29: G_AMW_MENU_ENTRIES CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_MENU_ENTRIES');
30: G_AMW_FORM_FUNCTIONS_VL CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_FORM_FUNCTIONS_VL');
31: G_AMW_COMPILED_MENU_FUNCTIONS CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_COMPILED_MENU_FUNCTIONS');
32: G_AMW_GRANTS CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_GRANTS');
33: G_AMW_USER_ROLES CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_USER_ROLES');

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

26: G_AMW_RESPONSIBILITY CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_RESPONSIBILITY');
27: G_AMW_RESP_FUNCTIONS CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_RESP_FUNCTIONS');
28: G_AMW_MENUS CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_MENUS');
29: G_AMW_MENU_ENTRIES CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_MENU_ENTRIES');
30: G_AMW_FORM_FUNCTIONS_VL CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_FORM_FUNCTIONS_VL');
31: G_AMW_COMPILED_MENU_FUNCTIONS CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_COMPILED_MENU_FUNCTIONS');
32: G_AMW_GRANTS CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_GRANTS');
33: G_AMW_USER_ROLES CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_USER_ROLES');
34: G_AMW_USER_ROLE_ASSIGNMENTS CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_USER_ROLE_ASSIGNMENTS');

Line 31: G_AMW_COMPILED_MENU_FUNCTIONS CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_COMPILED_MENU_FUNCTIONS');

27: G_AMW_RESP_FUNCTIONS CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_RESP_FUNCTIONS');
28: G_AMW_MENUS CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_MENUS');
29: G_AMW_MENU_ENTRIES CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_MENU_ENTRIES');
30: G_AMW_FORM_FUNCTIONS_VL CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_FORM_FUNCTIONS_VL');
31: G_AMW_COMPILED_MENU_FUNCTIONS CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_COMPILED_MENU_FUNCTIONS');
32: G_AMW_GRANTS CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_GRANTS');
33: G_AMW_USER_ROLES CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_USER_ROLES');
34: G_AMW_USER_ROLE_ASSIGNMENTS CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_USER_ROLE_ASSIGNMENTS');
35: G_AMW_REQUEST_GROUP_UNITS CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_REQUEST_GROUP_UNITS');

Line 32: G_AMW_GRANTS CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_GRANTS');

28: G_AMW_MENUS CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_MENUS');
29: G_AMW_MENU_ENTRIES CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_MENU_ENTRIES');
30: G_AMW_FORM_FUNCTIONS_VL CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_FORM_FUNCTIONS_VL');
31: G_AMW_COMPILED_MENU_FUNCTIONS CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_COMPILED_MENU_FUNCTIONS');
32: G_AMW_GRANTS CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_GRANTS');
33: G_AMW_USER_ROLES CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_USER_ROLES');
34: G_AMW_USER_ROLE_ASSIGNMENTS CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_USER_ROLE_ASSIGNMENTS');
35: G_AMW_REQUEST_GROUP_UNITS CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_REQUEST_GROUP_UNITS');
36: G_AMW_CONCURRENT_PROGRAMS_VL CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_CONCURRENT_PROGRAMS_VL');

Line 33: G_AMW_USER_ROLES CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_USER_ROLES');

29: G_AMW_MENU_ENTRIES CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_MENU_ENTRIES');
30: G_AMW_FORM_FUNCTIONS_VL CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_FORM_FUNCTIONS_VL');
31: G_AMW_COMPILED_MENU_FUNCTIONS CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_COMPILED_MENU_FUNCTIONS');
32: G_AMW_GRANTS CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_GRANTS');
33: G_AMW_USER_ROLES CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_USER_ROLES');
34: G_AMW_USER_ROLE_ASSIGNMENTS CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_USER_ROLE_ASSIGNMENTS');
35: G_AMW_REQUEST_GROUP_UNITS CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_REQUEST_GROUP_UNITS');
36: G_AMW_CONCURRENT_PROGRAMS_VL CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_CONCURRENT_PROGRAMS_VL');
37: G_AMW_ALL_ROLES_VL CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_ALL_ROLES_VL');

Line 34: G_AMW_USER_ROLE_ASSIGNMENTS CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_USER_ROLE_ASSIGNMENTS');

30: G_AMW_FORM_FUNCTIONS_VL CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_FORM_FUNCTIONS_VL');
31: G_AMW_COMPILED_MENU_FUNCTIONS CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_COMPILED_MENU_FUNCTIONS');
32: G_AMW_GRANTS CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_GRANTS');
33: G_AMW_USER_ROLES CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_USER_ROLES');
34: G_AMW_USER_ROLE_ASSIGNMENTS CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_USER_ROLE_ASSIGNMENTS');
35: G_AMW_REQUEST_GROUP_UNITS CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_REQUEST_GROUP_UNITS');
36: G_AMW_CONCURRENT_PROGRAMS_VL CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_CONCURRENT_PROGRAMS_VL');
37: G_AMW_ALL_ROLES_VL CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_ALL_ROLES_VL');
38: G_AMW_RESPONSIBILITY_VL CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_RESPONSIBILITY_VL');

Line 35: G_AMW_REQUEST_GROUP_UNITS CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_REQUEST_GROUP_UNITS');

31: G_AMW_COMPILED_MENU_FUNCTIONS CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_COMPILED_MENU_FUNCTIONS');
32: G_AMW_GRANTS CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_GRANTS');
33: G_AMW_USER_ROLES CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_USER_ROLES');
34: G_AMW_USER_ROLE_ASSIGNMENTS CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_USER_ROLE_ASSIGNMENTS');
35: G_AMW_REQUEST_GROUP_UNITS CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_REQUEST_GROUP_UNITS');
36: G_AMW_CONCURRENT_PROGRAMS_VL CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_CONCURRENT_PROGRAMS_VL');
37: G_AMW_ALL_ROLES_VL CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_ALL_ROLES_VL');
38: G_AMW_RESPONSIBILITY_VL CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_RESPONSIBILITY_VL');
39: G_AMW_MENUS_VL CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_MENUS_VL');

Line 36: G_AMW_CONCURRENT_PROGRAMS_VL CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_CONCURRENT_PROGRAMS_VL');

32: G_AMW_GRANTS CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_GRANTS');
33: G_AMW_USER_ROLES CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_USER_ROLES');
34: G_AMW_USER_ROLE_ASSIGNMENTS CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_USER_ROLE_ASSIGNMENTS');
35: G_AMW_REQUEST_GROUP_UNITS CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_REQUEST_GROUP_UNITS');
36: G_AMW_CONCURRENT_PROGRAMS_VL CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_CONCURRENT_PROGRAMS_VL');
37: G_AMW_ALL_ROLES_VL CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_ALL_ROLES_VL');
38: G_AMW_RESPONSIBILITY_VL CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_RESPONSIBILITY_VL');
39: G_AMW_MENUS_VL CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_MENUS_VL');
40: G_AMW_USER_ROLE_ASSIGNMENTS_V CONSTANT VARCHAR2(30) := 'WF_USER_ROLE_ASSIGNMENTS_V';

Line 37: G_AMW_ALL_ROLES_VL CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_ALL_ROLES_VL');

33: G_AMW_USER_ROLES CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_USER_ROLES');
34: G_AMW_USER_ROLE_ASSIGNMENTS CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_USER_ROLE_ASSIGNMENTS');
35: G_AMW_REQUEST_GROUP_UNITS CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_REQUEST_GROUP_UNITS');
36: G_AMW_CONCURRENT_PROGRAMS_VL CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_CONCURRENT_PROGRAMS_VL');
37: G_AMW_ALL_ROLES_VL CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_ALL_ROLES_VL');
38: G_AMW_RESPONSIBILITY_VL CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_RESPONSIBILITY_VL');
39: G_AMW_MENUS_VL CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_MENUS_VL');
40: G_AMW_USER_ROLE_ASSIGNMENTS_V CONSTANT VARCHAR2(30) := 'WF_USER_ROLE_ASSIGNMENTS_V';
41:

Line 38: G_AMW_RESPONSIBILITY_VL CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_RESPONSIBILITY_VL');

34: G_AMW_USER_ROLE_ASSIGNMENTS CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_USER_ROLE_ASSIGNMENTS');
35: G_AMW_REQUEST_GROUP_UNITS CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_REQUEST_GROUP_UNITS');
36: G_AMW_CONCURRENT_PROGRAMS_VL CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_CONCURRENT_PROGRAMS_VL');
37: G_AMW_ALL_ROLES_VL CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_ALL_ROLES_VL');
38: G_AMW_RESPONSIBILITY_VL CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_RESPONSIBILITY_VL');
39: G_AMW_MENUS_VL CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_MENUS_VL');
40: G_AMW_USER_ROLE_ASSIGNMENTS_V CONSTANT VARCHAR2(30) := 'WF_USER_ROLE_ASSIGNMENTS_V';
41:
42: -- ===============================================================

Line 39: G_AMW_MENUS_VL CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_MENUS_VL');

35: G_AMW_REQUEST_GROUP_UNITS CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_REQUEST_GROUP_UNITS');
36: G_AMW_CONCURRENT_PROGRAMS_VL CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_CONCURRENT_PROGRAMS_VL');
37: G_AMW_ALL_ROLES_VL CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_ALL_ROLES_VL');
38: G_AMW_RESPONSIBILITY_VL CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_RESPONSIBILITY_VL');
39: G_AMW_MENUS_VL CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_MENUS_VL');
40: G_AMW_USER_ROLE_ASSIGNMENTS_V CONSTANT VARCHAR2(30) := 'WF_USER_ROLE_ASSIGNMENTS_V';
41:
42: -- ===============================================================
43: -- Function name