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.OTA_UTILITY dependencies on OTA_CATEGORY_USAGES

Line 1275: ota_category_usages catusg,

1271: CURSOR get_primary_dm_cr IS
1272: SELECT lookup.meaning Dm_Name,
1273: catusg.category Dm_Code
1274: FROM ota_act_cat_inclusions actcat,
1275: ota_category_usages catusg,
1276: hr_lookups lookup
1277: WHERE actcat.category_usage_id= catusg.category_usage_id
1278: AND actcat.primary_flag='Y'
1279: AND catusg.category = lookup.lookup_code

Line 1288: ota_category_usages catusg,

1284: CURSOR get_first_dm_cr IS
1285: SELECT lookup.meaning dm_name,
1286: catusg.category dm_code
1287: FROM ota_act_cat_inclusions actcat,
1288: ota_category_usages catusg,
1289: hr_lookups lookup
1290: WHERE actcat.category_usage_id= catusg.category_usage_id
1291: AND catusg.category = lookup.lookup_code
1292: AND lookup.lookup_type ='ACTIVITY_CATEGORY'

Line 1370: from ota_category_usages_tl ocu , ota_offerings oaf

1366:
1367:
1368: Cursor get_DM is
1369: select ocu.category
1370: from ota_category_usages_tl ocu , ota_offerings oaf
1371: where oaf.delivery_mode_id = ocu.category_usage_id
1372: and oaf.offering_id = p_offering_id
1373: and ocu.Language = USERENV('LANG');
1374:

Line 1874: ota_category_usages catusg,

1870: CURSOR get_primary_dm_cr IS
1871: SELECT lookup.meaning Dm_Name,
1872: catusg.category Dm_Code
1873: FROM ota_act_cat_inclusions actcat,
1874: ota_category_usages catusg,
1875: hr_lookups lookup
1876: WHERE actcat.category_usage_id= catusg.category_usage_id
1877: AND actcat.primary_flag='Y'
1878: AND catusg.category = lookup.lookup_code

Line 1887: ota_category_usages catusg,

1883: CURSOR get_first_dm_cr IS
1884: SELECT lookup.meaning dm_name,
1885: catusg.category dm_code
1886: FROM ota_act_cat_inclusions actcat,
1887: ota_category_usages catusg,
1888: hr_lookups lookup
1889: WHERE actcat.category_usage_id= catusg.category_usage_id
1890: AND catusg.category = lookup.lookup_code
1891: AND lookup.lookup_type ='ACTIVITY_CATEGORY'

Line 2417: parent_id ota_category_usages.parent_cat_usage_id%TYPE;

2413: -- --------------------------------------
2414: -- ----------------------------------------------------------------
2415: Procedure get_catalog_object_path (p_cat_id varchar2, p_path OUT NOCOPY varchar2)
2416: IS
2417: parent_id ota_category_usages.parent_cat_usage_id%TYPE;
2418: full_path varchar2(1000) :=null;
2419: current_cat_usage_id ota_category_usages.category_usage_id%TYPE := p_cat_id;
2420: l_proc VARCHAR2(72) := g_package||'get_catalog_object_path';
2421:

Line 2419: current_cat_usage_id ota_category_usages.category_usage_id%TYPE := p_cat_id;

2415: Procedure get_catalog_object_path (p_cat_id varchar2, p_path OUT NOCOPY varchar2)
2416: IS
2417: parent_id ota_category_usages.parent_cat_usage_id%TYPE;
2418: full_path varchar2(1000) :=null;
2419: current_cat_usage_id ota_category_usages.category_usage_id%TYPE := p_cat_id;
2420: l_proc VARCHAR2(72) := g_package||'get_catalog_object_path';
2421:
2422: Cursor c_parent_cat_id(current_cat_usage_id IN VARCHAR2)
2423: IS

Line 2425: from ota_category_usages

2421:
2422: Cursor c_parent_cat_id(current_cat_usage_id IN VARCHAR2)
2423: IS
2424: select nvl(parent_cat_usage_id,-1)
2425: from ota_category_usages
2426: where category_usage_id = current_cat_usage_id;
2427:
2428: Begin
2429: loop