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.FUN_SECURITY dependencies on FND_OBJECT_INSTANCE_SETS

Line 23: FROM fnd_object_instance_sets

19: IS
20: CURSOR c_get_instance_set_id
21: IS
22: SELECT instance_set_id, instance_set_name
23: FROM fnd_object_instance_sets
24: WHERE instance_set_name IN ('FUN_TRX_BATCHES_SET','FUN_TRX_HEADERS_SET','FUN_DIST_LINES_SET');
25: BEGIN
26:
27: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)

Line 78: l_instance_set_batches fnd_object_instance_sets.instance_set_id%TYPE;

74: l_fnd_grant_guid fnd_grants.grant_guid%TYPE;
75: l_fnd_errorcode NUMBER;
76: l_menu_name VARCHAR2(30);
77: l_grant_enabled_flag VARCHAR2(5);
78: l_instance_set_batches fnd_object_instance_sets.instance_set_id%TYPE;
79: l_instance_set_headers fnd_object_instance_sets.instance_set_id%TYPE;
80: l_instance_set_dist fnd_object_instance_sets.instance_set_id%TYPE;
81: l_api_version CONSTANT NUMBER := 1.0;
82: l_api_name CONSTANT VARCHAR2(30) := 'create_assign';

Line 79: l_instance_set_headers fnd_object_instance_sets.instance_set_id%TYPE;

75: l_fnd_errorcode NUMBER;
76: l_menu_name VARCHAR2(30);
77: l_grant_enabled_flag VARCHAR2(5);
78: l_instance_set_batches fnd_object_instance_sets.instance_set_id%TYPE;
79: l_instance_set_headers fnd_object_instance_sets.instance_set_id%TYPE;
80: l_instance_set_dist fnd_object_instance_sets.instance_set_id%TYPE;
81: l_api_version CONSTANT NUMBER := 1.0;
82: l_api_name CONSTANT VARCHAR2(30) := 'create_assign';
83: l_end_date DATE := NULL;

Line 80: l_instance_set_dist fnd_object_instance_sets.instance_set_id%TYPE;

76: l_menu_name VARCHAR2(30);
77: l_grant_enabled_flag VARCHAR2(5);
78: l_instance_set_batches fnd_object_instance_sets.instance_set_id%TYPE;
79: l_instance_set_headers fnd_object_instance_sets.instance_set_id%TYPE;
80: l_instance_set_dist fnd_object_instance_sets.instance_set_id%TYPE;
81: l_api_version CONSTANT NUMBER := 1.0;
82: l_api_name CONSTANT VARCHAR2(30) := 'create_assign';
83: l_end_date DATE := NULL;
84: l_module VARCHAR2(100);

Line 858: l_instance_set_batches fnd_object_instance_sets.instance_set_id%TYPE;

854: l_fnd_grant_guid fnd_grants.grant_guid%TYPE;
855: l_fnd_errorcode NUMBER;
856: l_menu_name VARCHAR2(30);
857: l_start_date DATE;
858: l_instance_set_batches fnd_object_instance_sets.instance_set_id%TYPE;
859: l_instance_set_headers fnd_object_instance_sets.instance_set_id%TYPE;
860: l_instance_set_dist fnd_object_instance_sets.instance_set_id%TYPE;
861: l_grant_guid fnd_grants.grant_guid%TYPE;
862: l_api_version CONSTANT NUMBER := 1.0;

Line 859: l_instance_set_headers fnd_object_instance_sets.instance_set_id%TYPE;

855: l_fnd_errorcode NUMBER;
856: l_menu_name VARCHAR2(30);
857: l_start_date DATE;
858: l_instance_set_batches fnd_object_instance_sets.instance_set_id%TYPE;
859: l_instance_set_headers fnd_object_instance_sets.instance_set_id%TYPE;
860: l_instance_set_dist fnd_object_instance_sets.instance_set_id%TYPE;
861: l_grant_guid fnd_grants.grant_guid%TYPE;
862: l_api_version CONSTANT NUMBER := 1.0;
863: l_api_name CONSTANT VARCHAR2(30) := 'create_assign';

Line 860: l_instance_set_dist fnd_object_instance_sets.instance_set_id%TYPE;

856: l_menu_name VARCHAR2(30);
857: l_start_date DATE;
858: l_instance_set_batches fnd_object_instance_sets.instance_set_id%TYPE;
859: l_instance_set_headers fnd_object_instance_sets.instance_set_id%TYPE;
860: l_instance_set_dist fnd_object_instance_sets.instance_set_id%TYPE;
861: l_grant_guid fnd_grants.grant_guid%TYPE;
862: l_api_version CONSTANT NUMBER := 1.0;
863: l_api_name CONSTANT VARCHAR2(30) := 'create_assign';
864: l_module VARCHAR2(100) := 'fun.plsql.fun_security.update_assign';

Line 1136: fnd_object_instance_sets fis,

1132: INTO l_exists
1133: from DUAL
1134: where exists (select 1
1135: FROM fnd_grants fg,
1136: fnd_object_instance_sets fis,
1137: fnd_menus fm,
1138: fnd_objects fo
1139: WHERE fm.menu_name='FUN_DATA_ACCESS'
1140: AND fo.obj_name IN ('FUN_TRX_BATCHES','FUN_TRX_HEADERS','FUN_DIST_LINES')

Line 1200: fnd_object_instance_sets fis,

1196:
1197: SELECT start_date,end_date
1198: INTO l_start_date,l_end_date
1199: FROM fnd_grants fg,
1200: fnd_object_instance_sets fis,
1201: fnd_menus fm,
1202: fnd_objects fo
1203: WHERE fm.menu_name = 'FUN_DATA_ACCESS'
1204: AND fo.obj_name = 'FUN_TRX_BATCHES'