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.PA_SECURITY_PVT dependencies on FND_OBJECTS

Line 470: fnd_objects obj

466: from dual
467: where not exists
468: (select 'Y'
469: from fnd_grants fg,
470: fnd_objects obj
471: where fg.object_id=obj.object_id
472: and obj.obj_name=p_object_name
473: and fg.grantee_type='USER'
474: and fg.grantee_key='PER:'||to_char(get_party_id)

Line 1399: from fnd_objects

1395: x_msg_data:=null;
1396:
1397: select object_id
1398: into l_object_id
1399: from fnd_objects
1400: where obj_name=p_object_name;
1401: if p_project_role_id is not null then
1402: l_menu_id:=get_menu_id_for_role(p_project_role_id);
1403: else

Line 1573: from fnd_objects

1569: end if;
1570:
1571: select object_id
1572: into l_object_id
1573: from fnd_objects
1574: where obj_name=p_object_name;
1575:
1576: fnd_grants_pkg.lock_grant
1577: (

Line 1777: FUNCTION is_role_exists ( p_object_name IN FND_OBJECTS.OBJ_NAME%TYPE

1773:
1774: -----FUNCTION is_role_exists-------------
1775: ----This FUnction is created by Hari. It is used in resource model
1776: --------------------------------------------------------------------------
1777: FUNCTION is_role_exists ( p_object_name IN FND_OBJECTS.OBJ_NAME%TYPE
1778: ,p_object_key_type IN FND_GRANTS.INSTANCE_TYPE%TYPE DEFAULT 'INSTANCE'
1779: ,p_role_id IN FND_MENUS.MENU_ID%TYPE
1780: ,p_object_key IN FND_GRANTS.INSTANCE_PK1_VALUE%TYPE
1781: ,p_party_id IN NUMBER

Line 1826: fnd_objects fo

1822:
1823: SELECT DISTINCT 'Y'
1824: INTO l_dummy
1825: FROM fnd_grants fg ,
1826: fnd_objects fo
1827: WHERE fg.object_id=fo.object_id
1828: AND fo.obj_name = p_object_name
1829: AND fg.INSTANCE_type = l_object_key_type
1830: AND fg.menu_id = p_role_id

Line 1898: FROM fnd_objects

1894: ,pk3_column_name
1895: ,pk4_column_name
1896: ,pk5_column_name
1897: , database_object_name
1898: FROM fnd_objects
1899: WHERE obj_name=p_object_name ;
1900: begin
1901: open c_pk;
1902: fetch c_pk into

Line 1943: l_db_object_name fnd_objects.database_object_name%TYPE;

1939: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
1940: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
1941: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
1942: IS
1943: l_db_object_name fnd_objects.database_object_name%TYPE;
1944: l_db_pk1_column fnd_objects.pk1_column_name%TYPE;
1945: l_db_pk2_column fnd_objects.pk2_column_name%TYPE;
1946: l_db_pk3_column fnd_objects.pk3_column_name%TYPE;
1947: l_db_pk4_column fnd_objects.pk4_column_name%TYPE;

Line 1944: l_db_pk1_column fnd_objects.pk1_column_name%TYPE;

1940: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
1941: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
1942: IS
1943: l_db_object_name fnd_objects.database_object_name%TYPE;
1944: l_db_pk1_column fnd_objects.pk1_column_name%TYPE;
1945: l_db_pk2_column fnd_objects.pk2_column_name%TYPE;
1946: l_db_pk3_column fnd_objects.pk3_column_name%TYPE;
1947: l_db_pk4_column fnd_objects.pk4_column_name%TYPE;
1948: l_db_pk5_column fnd_objects.pk5_column_name%TYPE;

Line 1945: l_db_pk2_column fnd_objects.pk2_column_name%TYPE;

1941: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
1942: IS
1943: l_db_object_name fnd_objects.database_object_name%TYPE;
1944: l_db_pk1_column fnd_objects.pk1_column_name%TYPE;
1945: l_db_pk2_column fnd_objects.pk2_column_name%TYPE;
1946: l_db_pk3_column fnd_objects.pk3_column_name%TYPE;
1947: l_db_pk4_column fnd_objects.pk4_column_name%TYPE;
1948: l_db_pk5_column fnd_objects.pk5_column_name%TYPE;
1949: l_aliased_pk_column VARCHAR2(180);

Line 1946: l_db_pk3_column fnd_objects.pk3_column_name%TYPE;

1942: IS
1943: l_db_object_name fnd_objects.database_object_name%TYPE;
1944: l_db_pk1_column fnd_objects.pk1_column_name%TYPE;
1945: l_db_pk2_column fnd_objects.pk2_column_name%TYPE;
1946: l_db_pk3_column fnd_objects.pk3_column_name%TYPE;
1947: l_db_pk4_column fnd_objects.pk4_column_name%TYPE;
1948: l_db_pk5_column fnd_objects.pk5_column_name%TYPE;
1949: l_aliased_pk_column VARCHAR2(180);
1950: l_aliased_ik_column VARCHAR2(180);

Line 1947: l_db_pk4_column fnd_objects.pk4_column_name%TYPE;

1943: l_db_object_name fnd_objects.database_object_name%TYPE;
1944: l_db_pk1_column fnd_objects.pk1_column_name%TYPE;
1945: l_db_pk2_column fnd_objects.pk2_column_name%TYPE;
1946: l_db_pk3_column fnd_objects.pk3_column_name%TYPE;
1947: l_db_pk4_column fnd_objects.pk4_column_name%TYPE;
1948: l_db_pk5_column fnd_objects.pk5_column_name%TYPE;
1949: l_aliased_pk_column VARCHAR2(180);
1950: l_aliased_ik_column VARCHAR2(180);
1951:

Line 1948: l_db_pk5_column fnd_objects.pk5_column_name%TYPE;

1944: l_db_pk1_column fnd_objects.pk1_column_name%TYPE;
1945: l_db_pk2_column fnd_objects.pk2_column_name%TYPE;
1946: l_db_pk3_column fnd_objects.pk3_column_name%TYPE;
1947: l_db_pk4_column fnd_objects.pk4_column_name%TYPE;
1948: l_db_pk5_column fnd_objects.pk5_column_name%TYPE;
1949: l_aliased_pk_column VARCHAR2(180);
1950: l_aliased_ik_column VARCHAR2(180);
1951:
1952: TYPE DYNAMIC_CUR IS REF CURSOR;