eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMW_CONSTRAINT_PVT dependencies on FND_FUNCTION

Line 31: -- copy from FND_FUNCTION.G_BULK_COLLECTS_SUPPORTED (AFSCFNSB.pls 115.51 2003/08/01)

27: -- Populate_User_Vio_For_Vlt,PROCESS_MENU_TREE_DOWN_FOR_CST
28: -- ===============================================================
29:
30:
31: -- copy from FND_FUNCTION.G_BULK_COLLECTS_SUPPORTED (AFSCFNSB.pls 115.51 2003/08/01)
32: -- Bulk collects are a feature that will have the benefit of increasing
33: -- performance and hopefully reducing I/O reads on dev115
34: -- But the problem is they cause random failures in 8.1.6.1 databases
35: -- so we can't use them before 8.1.7.1. (due to database bug 1688232).

Line 46: -- copy from FND_FUNCTION.C_MAX_MENU_ENTRIES (AFSCFNSB.pls 115.51 2003/08/01)

42: -- 2/03- TM- That time is now... we now require 8.1.7.1+.
43: G_BULK_COLLECTS_SUPPORTED VARCHAR2(30) := 'TRUE';
44:
45:
46: -- copy from FND_FUNCTION.C_MAX_MENU_ENTRIES (AFSCFNSB.pls 115.51 2003/08/01)
47: -- This constant is used for recursion detection in the fallback
48: -- runtime menu scan. We keep track of how many items are on the menu,
49: -- and assume if the number of entries on the current
50: -- menu is too high then it's caused by recursion.

Line 54: -- copy from FND_FUNCTION.P_LAST_RESP_ID (AFSCFNSB.pls 115.51 2003/08/01)

50: -- menu is too high then it's caused by recursion.
51: C_MAX_MENU_ENTRIES CONSTANT pls_integer := 10000;
52:
53:
54: -- copy from FND_FUNCTION.P_LAST_RESP_ID (AFSCFNSB.pls 115.51 2003/08/01)
55: -- copy from FND_FUNCTION.P_LAST_RESP_APPL_ID (AFSCFNSB.pls 115.51 2003/08/01)
56: -- copy from FND_FUNCTION.P_LAST_MENU_ID (AFSCFNSB.pls 115.51 2003/08/01)
57: -- This simple cache will avoid the need to find which menu is on
58: -- the current responsibility with SQL every time. We just store

Line 55: -- copy from FND_FUNCTION.P_LAST_RESP_APPL_ID (AFSCFNSB.pls 115.51 2003/08/01)

51: C_MAX_MENU_ENTRIES CONSTANT pls_integer := 10000;
52:
53:
54: -- copy from FND_FUNCTION.P_LAST_RESP_ID (AFSCFNSB.pls 115.51 2003/08/01)
55: -- copy from FND_FUNCTION.P_LAST_RESP_APPL_ID (AFSCFNSB.pls 115.51 2003/08/01)
56: -- copy from FND_FUNCTION.P_LAST_MENU_ID (AFSCFNSB.pls 115.51 2003/08/01)
57: -- This simple cache will avoid the need to find which menu is on
58: -- the current responsibility with SQL every time. We just store
59: -- the menu around after we get it for the current resp.

Line 56: -- copy from FND_FUNCTION.P_LAST_MENU_ID (AFSCFNSB.pls 115.51 2003/08/01)

52:
53:
54: -- copy from FND_FUNCTION.P_LAST_RESP_ID (AFSCFNSB.pls 115.51 2003/08/01)
55: -- copy from FND_FUNCTION.P_LAST_RESP_APPL_ID (AFSCFNSB.pls 115.51 2003/08/01)
56: -- copy from FND_FUNCTION.P_LAST_MENU_ID (AFSCFNSB.pls 115.51 2003/08/01)
57: -- This simple cache will avoid the need to find which menu is on
58: -- the current responsibility with SQL every time. We just store
59: -- the menu around after we get it for the current resp.
60: P_LAST_RESP_ID NUMBER := -1;

Line 179: -- copy from FND_FUNCTION.BULK_COLLECTS_SUPPORTED (AFSCFNSB.pls 115.51 2003/08/01)

175: -- True := BULK COLLECTS SUPPORTED
176: -- False := BULK COLLECTS NOT SUPPORTED
177: --
178: -- Notes
179: -- copy from FND_FUNCTION.BULK_COLLECTS_SUPPORTED (AFSCFNSB.pls 115.51 2003/08/01)
180: -- since it's private function in FND_FUNCTION
181: --
182: -- ===============================================================
183: FUNCTION BULK_COLLECTS_SUPPORTED

Line 180: -- since it's private function in FND_FUNCTION

176: -- False := BULK COLLECTS NOT SUPPORTED
177: --
178: -- Notes
179: -- copy from FND_FUNCTION.BULK_COLLECTS_SUPPORTED (AFSCFNSB.pls 115.51 2003/08/01)
180: -- since it's private function in FND_FUNCTION
181: --
182: -- ===============================================================
183: FUNCTION BULK_COLLECTS_SUPPORTED
184: RETURN boolean

Line 252: -- copy from FND_FUNCTION.PROCESS_MENU_TREE_DOWN_FOR_MN (AFSCFNSB.pls 115.51 2003/08/01)

248: -- True := function accessible
249: -- False := function not accessible
250: --
251: -- Notes
252: -- copy from FND_FUNCTION.PROCESS_MENU_TREE_DOWN_FOR_MN (AFSCFNSB.pls 115.51 2003/08/01)
253: -- and modify for AMW to use dynamic sql
254: --
255: -- 12.21.2004 tsho: set default NULL for p_access_given_date, p_access_given_by
256: -- 12.21.2004 tsho: fix for performance bug 4036679

Line 588: -- copy from FND_FUNCTION.PROCESS_MENU_TREE_DOWN_FOR_MN (AFSCFNSB.pls 115.51 2003/08/01)

584: -- True := function accessible
585: -- False := function not accessible
586: --
587: -- Notes
588: -- copy from FND_FUNCTION.PROCESS_MENU_TREE_DOWN_FOR_MN (AFSCFNSB.pls 115.51 2003/08/01)
589: -- and modify for AMW to use dynamic sql
590: --
591: -- 12.21.2004 tsho: set default NULL for p_access_given_date, p_access_given_by
592: -- 12.21.2004 tsho: fix for performance bug 4036679

Line 905: -- copy from FND_FUNCTION.PROCESS_MENU_TREE_DOWN (AFSCFNSB.pls 115.51 2003/08/01)

901: -- True := function accessible
902: -- False := function not accessible
903: --
904: -- Notes
905: -- copy from FND_FUNCTION.PROCESS_MENU_TREE_DOWN (AFSCFNSB.pls 115.51 2003/08/01)
906: -- and modify for AMW to use dynamic sql
907: --
908: -- 12.21.2004 tsho: set default NULL for p_access_given_date, p_access_given_by
909: -- ===============================================================

Line 1010: -- copy from FND_FUNCTION.TEST_ID_NO_GRANTS (AFSCFNSB.pls 115.51 2003/08/01)

1006: -- True := function accessible
1007: -- False := function not accessible
1008: --
1009: -- Notes
1010: -- copy from FND_FUNCTION.TEST_ID_NO_GRANTS (AFSCFNSB.pls 115.51 2003/08/01)
1011: -- and modify for AMW to use dynamic sql.
1012: --
1013: -- FND_FUNCTION.TEST_ID_NO_GRANTS calls FND_FUNCTION.IS_FUNCTION_ON_MENU,
1014: -- since FND_FUNCTION.IS_FUNCTION_ON_MENU will use table FND_COMPILED_MENU_FUNCTIONS,

Line 1013: -- FND_FUNCTION.TEST_ID_NO_GRANTS calls FND_FUNCTION.IS_FUNCTION_ON_MENU,

1009: -- Notes
1010: -- copy from FND_FUNCTION.TEST_ID_NO_GRANTS (AFSCFNSB.pls 115.51 2003/08/01)
1011: -- and modify for AMW to use dynamic sql.
1012: --
1013: -- FND_FUNCTION.TEST_ID_NO_GRANTS calls FND_FUNCTION.IS_FUNCTION_ON_MENU,
1014: -- since FND_FUNCTION.IS_FUNCTION_ON_MENU will use table FND_COMPILED_MENU_FUNCTIONS,
1015: -- we won't have this compiled table for AMW, so we just use the uncompiled one
1016: -- (aka, call PROCESS_MENU_TREE_DOWN no matter what we have exclusions or not).
1017: --

Line 1014: -- since FND_FUNCTION.IS_FUNCTION_ON_MENU will use table FND_COMPILED_MENU_FUNCTIONS,

1010: -- copy from FND_FUNCTION.TEST_ID_NO_GRANTS (AFSCFNSB.pls 115.51 2003/08/01)
1011: -- and modify for AMW to use dynamic sql.
1012: --
1013: -- FND_FUNCTION.TEST_ID_NO_GRANTS calls FND_FUNCTION.IS_FUNCTION_ON_MENU,
1014: -- since FND_FUNCTION.IS_FUNCTION_ON_MENU will use table FND_COMPILED_MENU_FUNCTIONS,
1015: -- we won't have this compiled table for AMW, so we just use the uncompiled one
1016: -- (aka, call PROCESS_MENU_TREE_DOWN no matter what we have exclusions or not).
1017: --
1018: -- use FND_FUNCTION.AVAILABILITY(maintenance_mode_support) directly,

Line 1018: -- use FND_FUNCTION.AVAILABILITY(maintenance_mode_support) directly,

1014: -- since FND_FUNCTION.IS_FUNCTION_ON_MENU will use table FND_COMPILED_MENU_FUNCTIONS,
1015: -- we won't have this compiled table for AMW, so we just use the uncompiled one
1016: -- (aka, call PROCESS_MENU_TREE_DOWN no matter what we have exclusions or not).
1017: --
1018: -- use FND_FUNCTION.AVAILABILITY(maintenance_mode_support) directly,
1019: -- since it's public function of FND_FUNCTION package and no need to modify for AMW.
1020: --
1021: -- ===============================================================
1022: FUNCTION TEST_ID_NO_GRANTS (

Line 1019: -- since it's public function of FND_FUNCTION package and no need to modify for AMW.

1015: -- we won't have this compiled table for AMW, so we just use the uncompiled one
1016: -- (aka, call PROCESS_MENU_TREE_DOWN no matter what we have exclusions or not).
1017: --
1018: -- use FND_FUNCTION.AVAILABILITY(maintenance_mode_support) directly,
1019: -- since it's public function of FND_FUNCTION package and no need to modify for AMW.
1020: --
1021: -- ===============================================================
1022: FUNCTION TEST_ID_NO_GRANTS (
1023: function_id in number,

Line 1069: if(FND_FUNCTION.AVAILABILITY(MAINTENANCE_MODE_SUPPORT) = 'Y') then

1065: if(result = FALSE) then
1066: return FALSE;
1067: else
1068: if(L_TEST_MAINT_AVAILABILITY) then
1069: if(FND_FUNCTION.AVAILABILITY(MAINTENANCE_MODE_SUPPORT) = 'Y') then
1070: return TRUE;
1071: else
1072: return FALSE;
1073: end if;

Line 1122: -- copy from FND_FUNCTION.TEST_INSTANCE_ID_MAINTMODE (AFSCFNSB.pls 115.51 2003/08/01)

1118: -- True := function accessible
1119: -- False := function not accessible
1120: --
1121: -- Notes
1122: -- copy from FND_FUNCTION.TEST_INSTANCE_ID_MAINTMODE (AFSCFNSB.pls 115.51 2003/08/01)
1123: -- and modify for AMW to use dynamic sql.
1124: --
1125: -- since AMW constraint doesn't support data security (row base),
1126: -- but supports static function security (function base).

Line 1127: -- Unlike in FND_FUNCTION.TEST_INSTANCE_ID_MAINTMODE,

1123: -- and modify for AMW to use dynamic sql.
1124: --
1125: -- since AMW constraint doesn't support data security (row base),
1126: -- but supports static function security (function base).
1127: -- Unlike in FND_FUNCTION.TEST_INSTANCE_ID_MAINTMODE,
1128: -- here the passed-in object_name should always be NULL
1129: -- and we won't check data security
1130: --
1131: -- use FND_FUNCTION.AVAILABILITY(maintenance_mode_support) directly,

Line 1131: -- use FND_FUNCTION.AVAILABILITY(maintenance_mode_support) directly,

1127: -- Unlike in FND_FUNCTION.TEST_INSTANCE_ID_MAINTMODE,
1128: -- here the passed-in object_name should always be NULL
1129: -- and we won't check data security
1130: --
1131: -- use FND_FUNCTION.AVAILABILITY(maintenance_mode_support) directly,
1132: -- since it's public function of FND_FUNCTION package and no need to modify for AMW.
1133: --
1134: -- ===============================================================
1135: FUNCTION TEST_INSTANCE_ID_MAINTMODE (

Line 1132: -- since it's public function of FND_FUNCTION package and no need to modify for AMW.

1128: -- here the passed-in object_name should always be NULL
1129: -- and we won't check data security
1130: --
1131: -- use FND_FUNCTION.AVAILABILITY(maintenance_mode_support) directly,
1132: -- since it's public function of FND_FUNCTION package and no need to modify for AMW.
1133: --
1134: -- ===============================================================
1135: FUNCTION TEST_INSTANCE_ID_MAINTMODE (
1136: function_id IN NUMBER,

Line 1183: if(FND_FUNCTION.AVAILABILITY(L_MAINTENANCE_MODE_SUPPORT) = 'Y') then

1179: end if;
1180:
1181: <>
1182: if (ret_bool = TRUE) then
1183: if(FND_FUNCTION.AVAILABILITY(L_MAINTENANCE_MODE_SUPPORT) = 'Y') then
1184: ret_bool := TRUE;
1185: else
1186: ret_bool := FALSE;
1187: end if;

Line 1223: -- copy from FND_FUNCTION.TEST_ID (AFSCFNSB.pls 115.51 2003/08/01)

1219: -- True := function accessible
1220: -- False := function not accessible
1221: --
1222: -- Notes
1223: -- copy from FND_FUNCTION.TEST_ID (AFSCFNSB.pls 115.51 2003/08/01)
1224: --
1225: -- ===============================================================
1226: function TEST_ID(
1227: function_id IN NUMBER,