APPS.OTA_CLASSIC_UPGRADE dependencies on OTA_OFFERINGS_TL

Line 1496: SELECT Oft.Offering_id FROM ota_offerings off, ota_offerings_tl oft

1492: Group by Language_id , decode(event_type,'SELFPACED','SELFPACED','SCHEDULED');
1493:
1494:
1495: CURSOR c_dup_off(p_name varchar, p_act_ver_id number) is
1496: SELECT Oft.Offering_id FROM ota_offerings off, ota_offerings_tl oft
1497: WHERE off.offering_id = oft.offering_id
1498: AND oft.name = p_name
1499: AND oft.language = USERENV('LANG')
1500: AND off.activity_version_id = p_act_ver_id;

Line 1718: Insert into ota_offerings_tl

1714: p_vendor_id => Ids.vendor_id,
1715: p_language_code => l_language_code -- enh2733966 fnd_natural_lang support --
1716: );
1717:
1718: Insert into ota_offerings_tl
1719: (offering_Id,
1720: Language,
1721: name,
1722: Description,

Line 2555: l_off_name ota_offerings_tl.name%type := p_off_name;

2551: where flt.language_code = fl.language_code
2552: and flt.language = p_language
2553: and fl.language_id = p_language_id ;
2554: l_lang_len number;
2555: l_off_name ota_offerings_tl.name%type := p_off_name;
2556: description fnd_languages_tl.description%type;
2557: begin
2558:
2559: