APPS.FND_FUNCTION dependencies on FND_FORM_FUNCTIONS

Line 75: g_func_name_cache fnd_form_functions.function_name%type := NULL;

71: P_LAST_MENU_ID NUMBER := -1;
72:
73: g_func_id_cache NUMBER := NULL;
74: -- modified for bug#5395351
75: g_func_name_cache fnd_form_functions.function_name%type := NULL;
76:
77:
78: /* AVAILABILITY - This function compares the MAINTENANCE_MODE_SUPPORT
79: ** of a particular function to the APPS_MAINTENANCE_MODE

Line 894: -- MAINTENANCE_MODE_SUPPORT- the value from the column in fnd_form_functions

890: -- Test if function id is accessible under current responsibility.
891: -- Looks only at the menus on current resp, not any grants.
892: -- IN
893: -- function_id - function id to test
894: -- MAINTENANCE_MODE_SUPPORT- the value from the column in fnd_form_functions
895: -- CONTEXT_DEPENDENCE- the value from the column in fnd_form_functions
896: -- TEST_MAINT_AVAILABILTY- 'Y' (default) means check if available for
897: -- current value of profile APPS_MAINTENANCE_MODE
898: -- 'N' means the caller is checking so it's

Line 895: -- CONTEXT_DEPENDENCE- the value from the column in fnd_form_functions

891: -- Looks only at the menus on current resp, not any grants.
892: -- IN
893: -- function_id - function id to test
894: -- MAINTENANCE_MODE_SUPPORT- the value from the column in fnd_form_functions
895: -- CONTEXT_DEPENDENCE- the value from the column in fnd_form_functions
896: -- TEST_MAINT_AVAILABILTY- 'Y' (default) means check if available for
897: -- current value of profile APPS_MAINTENANCE_MODE
898: -- 'N' means the caller is checking so it's
899: -- unnecessary to check.

Line 1230: l_function_name fnd_form_functions.function_name%type := NULL;

1226: ret_bool boolean := FALSE;
1227: L_MAINTENANCE_MODE_SUPPORT varchar2(8) := NULL;
1228: L_CONTEXT_DEPENDENCE varchar2(8) := NULL;
1229: -- modified for bug#5395351
1230: l_function_name fnd_form_functions.function_name%type := NULL;
1231: begin
1232: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
1233: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1234: c_log_head || l_api_name || '.begin',

Line 1290: from FND_FORM_FUNCTIONS F

1286: -- Change function name to id
1287: begin
1288: select F.FUNCTION_NAME, F.MAINTENANCE_MODE_SUPPORT, F.CONTEXT_DEPENDENCE
1289: into l_function_name, L_MAINTENANCE_MODE_SUPPORT, L_CONTEXT_DEPENDENCE
1290: from FND_FORM_FUNCTIONS F
1291: where F.FUNCTION_ID = test_instance_id_maintmode.function_id;
1292: exception
1293: when no_data_found then
1294: -- Invalid function name

Line 1404: from FND_FORM_FUNCTIONS F

1400: -- Bug 5059644. Modified bind variable name from function_id to
1401: -- TEST_INSTANCE_ID.function_id. This change is to avoid FTS.
1402: select F.MAINTENANCE_MODE_SUPPORT, F.CONTEXT_DEPENDENCE
1403: into L_MAINTENANCE_MODE_SUPPORT, L_CONTEXT_DEPENDENCE
1404: from FND_FORM_FUNCTIONS F
1405: where F.function_id = test_instance_id.function_id;
1406: exception
1407: when no_data_found then
1408: -- Invalid function name

Line 1514: from FND_FORM_FUNCTIONS F

1510: -- Change function name to id
1511: begin
1512: select F.FUNCTION_ID, F.MAINTENANCE_MODE_SUPPORT, F.CONTEXT_DEPENDENCE
1513: into function_id, L_MAINTENANCE_MODE_SUPPORT, L_CONTEXT_DEPENDENCE
1514: from FND_FORM_FUNCTIONS F
1515: where F.FUNCTION_NAME = test_instance.function_name;
1516: exception
1517: when no_data_found then
1518: -- Invalid function name

Line 1563: -- MAINTENANCE_MODE_SUPPORT- the value from the column in fnd_form_functions

1559: -- TEST_ID
1560: -- Test if function id is accessible under current responsibility.
1561: -- IN
1562: -- function_id - function id to test
1563: -- MAINTENANCE_MODE_SUPPORT- the value from the column in fnd_form_functions
1564: -- CONTEXT_DEPENDENCE- the value from the column in fnd_form_functions
1565: -- TEST_MAINT_AVAILABILTY- 'Y' (default) means check if available for
1566: -- current value of profile APPS_MAINTENANCE_MODE
1567: -- 'N' means the caller is checking so it's

Line 1564: -- CONTEXT_DEPENDENCE- the value from the column in fnd_form_functions

1560: -- Test if function id is accessible under current responsibility.
1561: -- IN
1562: -- function_id - function id to test
1563: -- MAINTENANCE_MODE_SUPPORT- the value from the column in fnd_form_functions
1564: -- CONTEXT_DEPENDENCE- the value from the column in fnd_form_functions
1565: -- TEST_MAINT_AVAILABILTY- 'Y' (default) means check if available for
1566: -- current value of profile APPS_MAINTENANCE_MODE
1567: -- 'N' means the caller is checking so it's
1568: -- unnecessary to check.

Line 1655: from fnd_form_functions

1651: begin
1652: /* Get the extra columns */
1653: select MAINTENANCE_MODE_SUPPORT, CONTEXT_DEPENDENCE
1654: into L_MAINTENANCE_MODE_SUPPORT, L_CONTEXT_DEPENDENCE
1655: from fnd_form_functions
1656: where function_id = l_function_id;
1657:
1658: exception
1659: when no_data_found then

Line 1663: 'function_id passed to test_id cant be found in fnd_form_functions.');

1659: when no_data_found then
1660: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
1661: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1662: c_log_head || l_api_name || '.end_bad_fnid',
1663: 'function_id passed to test_id cant be found in fnd_form_functions.');
1664: end if;
1665: return FALSE; /* Bad function id passed */
1666: end;
1667:

Line 1711: from FND_FORM_FUNCTIONS F

1707: -- Change function name to id
1708: begin
1709: select F.FUNCTION_ID, F.MAINTENANCE_MODE_SUPPORT, F.CONTEXT_DEPENDENCE
1710: into function_id, L_MAINTENANCE_MODE_SUPPORT, L_CONTEXT_DEPENDENCE
1711: from FND_FORM_FUNCTIONS F
1712: where F.FUNCTION_NAME = test.function_name;
1713: exception
1714: when no_data_found then
1715: -- Invalid function name

Line 2704: from fnd_form_functions

2700: v_function_id := g_func_id_cache; /* If we have it cached, use value */
2701: else /* not cached, hit db */
2702: select function_id
2703: into v_function_id
2704: from fnd_form_functions
2705: where function_name=p_function_name;
2706:
2707: /* Store in cache */
2708: g_func_id_cache := v_function_id;