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_CLASSIC_UPGRADE dependencies on OTA_CATEGORY_USAGES_TL

Line 77: l_dm_name ota_category_usages_tl.category%Type;

73: p_dm_id IN OUT NOCOPY Number,
74: p_update_id in number default 1 ) is
75: l_category_usage_id ota_category_usages.category_usage_id%Type ;
76: l_object_version_number ota_category_usages.object_version_number%Type ;
77: l_dm_name ota_category_usages_tl.category%Type;
78: l_err_code varchar2(72);
79: l_err_msg varchar2(2000);
80: l_course_min_st_dt date;
81: Cursor csr_check_dm(p_dm in varchar2) is

Line 124: insert into ota_category_usages_tl

120: ,p_category_usage_id => l_category_usage_id
121: ,p_object_version_number => l_object_version_number
122: );
123: p_dm_id := l_category_usage_id;
124: insert into ota_category_usages_tl
125: ( CATEGORY_USAGE_ID,
126: LANGUAGE ,
127: CATEGORY ,
128: DESCRIPTION ,

Line 229: Insert into ota_category_usages_tl

225: Where Category_usage_id = l_category_usage_id
226: and Business_group_id = p_business_group_id
227: and Parent_cat_usage_id = -1 ;
228:
229: Insert into ota_category_usages_tl
230: (Category_usage_Id,
231: Language,
232: Category,
233: Description,

Line 255: From OTA_CATEGORY_USAGES_TL T

251: Where orgtl.organization_id = p_business_group_id
252: and org.organization_id = org.business_group_id
253: and org.organization_id = orgtl.organization_id
254: And Not Exists (Select '1'
255: From OTA_CATEGORY_USAGES_TL T
256: Where T.Category_usage_Id = l_Category_usage_Id
257: And T.Language = Orgtl.Language ) ;
258:
259:

Line 674: l_default_dm Ota_Category_usages_tl.Category_usage_id%Type;

670: From hr_organization_units hou
671: Where hou.business_group_id = p_bg_id
672: and hou.business_group_id = hou.organization_id ;
673:
674: l_default_dm Ota_Category_usages_tl.Category_usage_id%Type;
675: l_root_cat_usage_id ota_category_usages.category_usage_id%Type;
676: l_bg_name hr_organization_units.name%Type ;
677:
678: begin

Line 698: -- 3. Populates the category translation table ota_category_usages_tl

694: -- This procedure does the following :
695: -- 1. Updates ota_booking_deals.category with category_usage_id
696: -- 2. Updates ota_category_usages.Category with Meaning from
697: -- lookup table (earlier it stores lookup code)
698: -- 3. Populates the category translation table ota_category_usages_tl
699: -- 4. Migrates the customer defined lookup codes(not seeded) from FREQUNCY to
700: -- OTA_DURATION_UNITS
701:
702: PROCEDURE Upgrade_Category(

Line 799: Insert into OTA_CATEGORY_USAGES_TL

795: /*
796: ** Insert the TL rows.
797: */
798:
799: Insert into OTA_CATEGORY_USAGES_TL
800: (Category_usage_Id,
801: Language,
802: Category,
803: Description,

Line 824: From OTA_CATEGORY_USAGES_TL T

820: M.Last_Update_Login
821: From OTA_CATEGORY_USAGES M
822: Where M.Category_usage_id Between P_start_pkid AND P_end_pkid
823: And Not Exists (Select '1'
824: From OTA_CATEGORY_USAGES_TL T
825: Where T.Category_usage_Id = M.Category_usage_Id
826: And T.Language = L_Current_Language ) ;
827:
828:

Line 1081: from ota_category_usages ocu, ota_category_usages_tl oct

1077:
1078:
1079: CURSOR c_activity_def is
1080: select ocu.category_usage_id, oct.category, ocu.business_group_id,oct.description
1081: from ota_category_usages ocu, ota_category_usages_tl oct
1082: where ocu.category_usage_id = oct.category_usage_id
1083: and oct.language = Userenv('LANG')
1084: and ocu.type = 'C'
1085: and ocu.category_usage_id between p_start_pkid and p_end_pkid

Line 1093: l_category ota_category_usages_tl.category%type;

1089:
1090: l_object_version_number number;
1091: l_category_usage_id number;
1092: l_activity_id number;
1093: l_category ota_category_usages_tl.category%type;
1094: l_business_group_id number;
1095: l_description ota_category_usages_tl.description%Type;
1096: l_rows_processed number := 0;
1097: l_err_code varchar2(72);

Line 1095: l_description ota_category_usages_tl.description%Type;

1091: l_category_usage_id number;
1092: l_activity_id number;
1093: l_category ota_category_usages_tl.category%type;
1094: l_business_group_id number;
1095: l_description ota_category_usages_tl.description%Type;
1096: l_rows_processed number := 0;
1097: l_err_code varchar2(72);
1098: l_err_msg varchar2(2000);
1099:

Line 1232: FROM ota_category_usages ocu, ota_category_usages_tl oct

1228: WHERE lng.installed_flag in ('I', 'B');
1229:
1230: CURSOR csr_duplicate_category (p_act_name varchar2, p_business_group_id number) is
1231: SELECT ocu.category_usage_id
1232: FROM ota_category_usages ocu, ota_category_usages_tl oct
1233: WHERE oct.category = p_act_name
1234: AND ocu.type ='C'
1235: AND ocu.category_usage_id = oct.category_usage_id
1236: AND ocu.business_group_id = p_business_group_id;

Line 1265: --l_default_dm Ota_Category_usages_tl.Category_usage_id%Type;

1261: l_err_msg varchar2(2000);
1262: l_min_course_start_date date;
1263: l_add_struct_d hr_dflex_utility.l_ignore_dfcode_varray :=
1264: hr_dflex_utility.l_ignore_dfcode_varray();
1265: --l_default_dm Ota_Category_usages_tl.Category_usage_id%Type;
1266: --l_default_dm_name Hr_lookups.Meaning%Type ;
1267: --l_root_cat_usage_id ota_category_usages.category_usage_id%Type;
1268: --l_bg_name hr_organization_units.name%Type ;
1269: Begin

Line 1347: Insert into ota_category_usages_tl

1343: ,P_ATTRIBUTE20 => c_get_act.tad_information20
1344:
1345: );
1346:
1347: Insert into ota_category_usages_tl
1348: (Category_usage_Id,
1349: Language,
1350: Category,
1351: Description,

Line 2517: l_default_dm Ota_Category_usages_tl.Category_usage_id%Type;

2513: From hr_organization_units hou
2514: Where hou.business_group_id = p_bg_id
2515: and hou.business_group_id = hou.organization_id ;
2516:
2517: l_default_dm Ota_Category_usages_tl.Category_usage_id%Type;
2518: l_root_cat_usage_id ota_category_usages.category_usage_id%Type;
2519: l_bg_name hr_organization_units.name%Type ;
2520:
2521: begin