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.AK_OBJECT_PVT dependencies on AK_OBJECT_ATTRIBUTE_NAVIGATION

Line 1557: from AK_OBJECT_ATTRIBUTE_NAVIGATION

1553: p_value_number IN NUMBER
1554: ) return BOOLEAN is
1555: cursor l_checkexist_1_csr is
1556: select 1
1557: from AK_OBJECT_ATTRIBUTE_NAVIGATION
1558: where DATABASE_OBJECT_NAME = p_database_object_name
1559: and ATTRIBUTE_APPLICATION_ID = p_attribute_application_id
1560: and ATTRIBUTE_CODE = p_attribute_code
1561: and VALUE_VARCHAR2 = p_value_varchar2

Line 1566: from AK_OBJECT_ATTRIBUTE_NAVIGATION

1562: and VALUE_DATE is null
1563: and VALUE_NUMBER is null;
1564: cursor l_checkexist_2_csr is
1565: select 1
1566: from AK_OBJECT_ATTRIBUTE_NAVIGATION
1567: where DATABASE_OBJECT_NAME = p_database_object_name
1568: and ATTRIBUTE_APPLICATION_ID = p_attribute_application_id
1569: and ATTRIBUTE_CODE = p_attribute_code
1570: and VALUE_VARCHAR2 is null

Line 1575: from AK_OBJECT_ATTRIBUTE_NAVIGATION

1571: and VALUE_DATE = p_value_date
1572: and VALUE_NUMBER is null;
1573: cursor l_checkexist_3_csr is
1574: select 1
1575: from AK_OBJECT_ATTRIBUTE_NAVIGATION
1576: where DATABASE_OBJECT_NAME = p_database_object_name
1577: and ATTRIBUTE_APPLICATION_ID = p_attribute_application_id
1578: and ATTRIBUTE_CODE = p_attribute_code
1579: and VALUE_VARCHAR2 is null

Line 1978: from AK_OBJECT_ATTRIBUTE_NAVIGATION

1974: and attribute_application_id = p_attribute_application_id
1975: and attribute_code = p_attribute_code;
1976: cursor l_get_navigations_csr is
1977: select value_varchar2, value_date, value_number
1978: from AK_OBJECT_ATTRIBUTE_NAVIGATION
1979: where database_object_name = p_database_object_name
1980: and attribute_application_id = p_attribute_application_id
1981: and attribute_code = p_attribute_code;
1982: cursor l_get_region_item_csr is

Line 2064: -- AK_OBJECT_ATTRIBUTE_NAVIGATION

2060: -- If we are not deleting any referencing records, we cannot
2061: -- delete the object attribute if it is being referenced in any of
2062: -- following tables.
2063: --
2064: -- AK_OBJECT_ATTRIBUTE_NAVIGATION
2065: --
2066: open l_get_navigations_csr;
2067: fetch l_get_navigations_csr into l_value_varchar2, l_value_date,
2068: l_value_number;

Line 2133: -- AK_OBJECT_ATTRIBUTE_NAVIGATION

2129: else
2130: --
2131: -- Otherwise, delete all referencing rows in other tables
2132: --
2133: -- AK_OBJECT_ATTRIBUTE_NAVIGATION
2134: --
2135: open l_get_navigations_csr;
2136: loop
2137: fetch l_get_navigations_csr into l_value_varchar2, l_value_date,

Line 2442: delete from ak_object_attribute_navigation

2438: -- delete object attribute navigation record once we checked that there
2439: -- are no references to it, or all references have been deleted.
2440: --
2441: if (p_value_varchar2 is not null) then
2442: delete from ak_object_attribute_navigation
2443: where database_object_name = p_database_object_name
2444: and attribute_application_id = p_attribute_application_id
2445: and attribute_code = p_attribute_code
2446: and value_varchar2 = p_value_varchar2

Line 2450: delete from ak_object_attribute_navigation

2446: and value_varchar2 = p_value_varchar2
2447: and value_date is null
2448: and value_number is null;
2449: elsif (p_value_date is not null) then
2450: delete from ak_object_attribute_navigation
2451: where database_object_name = p_database_object_name
2452: and attribute_application_id = p_attribute_application_id
2453: and attribute_code = p_attribute_code
2454: and value_varchar2 is null

Line 2458: delete from ak_object_attribute_navigation

2454: and value_varchar2 is null
2455: and value_date = p_value_date
2456: and value_number is null;
2457: elsif (p_value_number is not null) then
2458: delete from ak_object_attribute_navigation
2459: where database_object_name = p_database_object_name
2460: and attribute_application_id = p_attribute_application_id
2461: and attribute_code = p_attribute_code
2462: and value_varchar2 is null

Line 4562: insert into AK_OBJECT_ATTRIBUTE_NAVIGATION (

4558: p_create_or_update => 'CREATE') then
4559: null;
4560: end if;
4561:
4562: insert into AK_OBJECT_ATTRIBUTE_NAVIGATION (
4563: DATABASE_OBJECT_NAME,
4564: ATTRIBUTE_APPLICATION_ID,
4565: ATTRIBUTE_CODE,
4566: VALUE_VARCHAR2,