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.

[Home] [Help]

APPS.OTA_UTILITY dependencies on OTA_CATEGORY_USAGES

Line 1339: ota_category_usages catusg,

1335: CURSOR get_primary_dm_cr IS
1336: SELECT lookup.meaning Dm_Name,
1337: catusg.category Dm_Code
1338: FROM ota_act_cat_inclusions actcat,
1339: ota_category_usages catusg,
1340: hr_lookups lookup
1341: WHERE actcat.category_usage_id= catusg.category_usage_id
1342: AND actcat.primary_flag='Y'
1343: AND catusg.category = lookup.lookup_code

Line 1352: ota_category_usages catusg,

1348: CURSOR get_first_dm_cr IS
1349: SELECT lookup.meaning dm_name,
1350: catusg.category dm_code
1351: FROM ota_act_cat_inclusions actcat,
1352: ota_category_usages catusg,
1353: hr_lookups lookup
1354: WHERE actcat.category_usage_id= catusg.category_usage_id
1355: AND catusg.category = lookup.lookup_code
1356: AND lookup.lookup_type ='ACTIVITY_CATEGORY'

Line 1434: from ota_category_usages_tl ocu , ota_offerings oaf

1430:
1431:
1432: Cursor get_DM is
1433: select ocu.category
1434: from ota_category_usages_tl ocu , ota_offerings oaf
1435: where oaf.delivery_mode_id = ocu.category_usage_id
1436: and oaf.offering_id = p_offering_id
1437: and ocu.Language = USERENV('LANG');
1438:

Line 1938: ota_category_usages catusg,

1934: CURSOR get_primary_dm_cr IS
1935: SELECT lookup.meaning Dm_Name,
1936: catusg.category Dm_Code
1937: FROM ota_act_cat_inclusions actcat,
1938: ota_category_usages catusg,
1939: hr_lookups lookup
1940: WHERE actcat.category_usage_id= catusg.category_usage_id
1941: AND actcat.primary_flag='Y'
1942: AND catusg.category = lookup.lookup_code

Line 1951: ota_category_usages catusg,

1947: CURSOR get_first_dm_cr IS
1948: SELECT lookup.meaning dm_name,
1949: catusg.category dm_code
1950: FROM ota_act_cat_inclusions actcat,
1951: ota_category_usages catusg,
1952: hr_lookups lookup
1953: WHERE actcat.category_usage_id= catusg.category_usage_id
1954: AND catusg.category = lookup.lookup_code
1955: AND lookup.lookup_type ='ACTIVITY_CATEGORY'

Line 2481: parent_id ota_category_usages.parent_cat_usage_id%TYPE;

2477: -- --------------------------------------
2478: -- ----------------------------------------------------------------
2479: Procedure get_catalog_object_path (p_cat_id varchar2, p_path OUT NOCOPY varchar2)
2480: IS
2481: parent_id ota_category_usages.parent_cat_usage_id%TYPE;
2482: full_path varchar2(1000) :=null;
2483: current_cat_usage_id ota_category_usages.category_usage_id%TYPE := p_cat_id;
2484: l_proc VARCHAR2(72) := g_package||'get_catalog_object_path';
2485:

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

2479: Procedure get_catalog_object_path (p_cat_id varchar2, p_path OUT NOCOPY varchar2)
2480: IS
2481: parent_id ota_category_usages.parent_cat_usage_id%TYPE;
2482: full_path varchar2(1000) :=null;
2483: current_cat_usage_id ota_category_usages.category_usage_id%TYPE := p_cat_id;
2484: l_proc VARCHAR2(72) := g_package||'get_catalog_object_path';
2485:
2486: Cursor c_parent_cat_id(current_cat_usage_id IN VARCHAR2)
2487: IS

Line 2489: from ota_category_usages

2485:
2486: Cursor c_parent_cat_id(current_cat_usage_id IN VARCHAR2)
2487: IS
2488: select nvl(parent_cat_usage_id,-1)
2489: from ota_category_usages
2490: where category_usage_id = current_cat_usage_id;
2491:
2492: Begin
2493: loop