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 480: fnd_objects obj

476: from dual
477: where not exists
478: (select 'Y'
479: from fnd_grants fg,
480: fnd_objects obj
481: where fg.object_id=obj.object_id
482: and obj.obj_name=p_object_name
483: and fg.grantee_type='USER'
484: and fg.grantee_key='PER:'||to_char(get_party_id)

Line 1410: from fnd_objects

1406: x_msg_data:=null;
1407:
1408: select object_id
1409: into l_object_id
1410: from fnd_objects
1411: where obj_name=p_object_name;
1412: if p_project_role_id is not null then
1413: l_menu_id:=get_menu_id_for_role(p_project_role_id);
1414: else

Line 1584: from fnd_objects

1580: end if;
1581:
1582: select object_id
1583: into l_object_id
1584: from fnd_objects
1585: where obj_name=p_object_name;
1586:
1587: fnd_grants_pkg.lock_grant
1588: (

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

1784:
1785: -----FUNCTION is_role_exists-------------
1786: ----This FUnction is created by Hari. It is used in resource model
1787: --------------------------------------------------------------------------
1788: FUNCTION is_role_exists ( p_object_name IN FND_OBJECTS.OBJ_NAME%TYPE
1789: ,p_object_key_type IN FND_GRANTS.INSTANCE_TYPE%TYPE DEFAULT 'INSTANCE'
1790: ,p_role_id IN FND_MENUS.MENU_ID%TYPE
1791: ,p_object_key IN FND_GRANTS.INSTANCE_PK1_VALUE%TYPE
1792: ,p_party_id IN NUMBER

Line 1837: fnd_objects fo

1833:
1834: SELECT DISTINCT 'Y'
1835: INTO l_dummy
1836: FROM fnd_grants fg ,
1837: fnd_objects fo
1838: WHERE fg.object_id=fo.object_id
1839: AND fo.obj_name = p_object_name
1840: AND fg.INSTANCE_type = l_object_key_type
1841: AND fg.menu_id = p_role_id

Line 1909: FROM fnd_objects

1905: ,pk3_column_name
1906: ,pk4_column_name
1907: ,pk5_column_name
1908: , database_object_name
1909: FROM fnd_objects
1910: WHERE obj_name=p_object_name ;
1911: begin
1912: open c_pk;
1913: fetch c_pk into

Line 1954: l_db_object_name fnd_objects.database_object_name%TYPE;

1950: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
1951: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
1952: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
1953: IS
1954: l_db_object_name fnd_objects.database_object_name%TYPE;
1955: l_db_pk1_column fnd_objects.pk1_column_name%TYPE;
1956: l_db_pk2_column fnd_objects.pk2_column_name%TYPE;
1957: l_db_pk3_column fnd_objects.pk3_column_name%TYPE;
1958: l_db_pk4_column fnd_objects.pk4_column_name%TYPE;

Line 1955: l_db_pk1_column fnd_objects.pk1_column_name%TYPE;

1951: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
1952: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
1953: IS
1954: l_db_object_name fnd_objects.database_object_name%TYPE;
1955: l_db_pk1_column fnd_objects.pk1_column_name%TYPE;
1956: l_db_pk2_column fnd_objects.pk2_column_name%TYPE;
1957: l_db_pk3_column fnd_objects.pk3_column_name%TYPE;
1958: l_db_pk4_column fnd_objects.pk4_column_name%TYPE;
1959: l_db_pk5_column fnd_objects.pk5_column_name%TYPE;

Line 1956: l_db_pk2_column fnd_objects.pk2_column_name%TYPE;

1952: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
1953: IS
1954: l_db_object_name fnd_objects.database_object_name%TYPE;
1955: l_db_pk1_column fnd_objects.pk1_column_name%TYPE;
1956: l_db_pk2_column fnd_objects.pk2_column_name%TYPE;
1957: l_db_pk3_column fnd_objects.pk3_column_name%TYPE;
1958: l_db_pk4_column fnd_objects.pk4_column_name%TYPE;
1959: l_db_pk5_column fnd_objects.pk5_column_name%TYPE;
1960: l_aliased_pk_column VARCHAR2(180);

Line 1957: l_db_pk3_column fnd_objects.pk3_column_name%TYPE;

1953: IS
1954: l_db_object_name fnd_objects.database_object_name%TYPE;
1955: l_db_pk1_column fnd_objects.pk1_column_name%TYPE;
1956: l_db_pk2_column fnd_objects.pk2_column_name%TYPE;
1957: l_db_pk3_column fnd_objects.pk3_column_name%TYPE;
1958: l_db_pk4_column fnd_objects.pk4_column_name%TYPE;
1959: l_db_pk5_column fnd_objects.pk5_column_name%TYPE;
1960: l_aliased_pk_column VARCHAR2(180);
1961: l_aliased_ik_column VARCHAR2(180);

Line 1958: l_db_pk4_column fnd_objects.pk4_column_name%TYPE;

1954: l_db_object_name fnd_objects.database_object_name%TYPE;
1955: l_db_pk1_column fnd_objects.pk1_column_name%TYPE;
1956: l_db_pk2_column fnd_objects.pk2_column_name%TYPE;
1957: l_db_pk3_column fnd_objects.pk3_column_name%TYPE;
1958: l_db_pk4_column fnd_objects.pk4_column_name%TYPE;
1959: l_db_pk5_column fnd_objects.pk5_column_name%TYPE;
1960: l_aliased_pk_column VARCHAR2(180);
1961: l_aliased_ik_column VARCHAR2(180);
1962:

Line 1959: l_db_pk5_column fnd_objects.pk5_column_name%TYPE;

1955: l_db_pk1_column fnd_objects.pk1_column_name%TYPE;
1956: l_db_pk2_column fnd_objects.pk2_column_name%TYPE;
1957: l_db_pk3_column fnd_objects.pk3_column_name%TYPE;
1958: l_db_pk4_column fnd_objects.pk4_column_name%TYPE;
1959: l_db_pk5_column fnd_objects.pk5_column_name%TYPE;
1960: l_aliased_pk_column VARCHAR2(180);
1961: l_aliased_ik_column VARCHAR2(180);
1962:
1963: TYPE DYNAMIC_CUR IS REF CURSOR;