APPS.OTA_TRB_API_PROCEDURES dependencies on OTA_OFFERINGS

Line 97: ota_offerings off

93: cursor chk_number is
94: select 1
95: from ota_suppliable_resources sr,
96: ota_events e,
97: ota_offerings off
98: where sr.supplied_resource_id = p_supplied_resource_id
99: and e.event_id = l_event_id
100: and off.offering_id = e.parent_offering_id --bug 3494404
101: and sr.delegates_per_unit >=

Line 849: ota_offerings off

845: cursor chk_primven is
846: select 1
847: from ota_resource_bookings rb,
848: ota_events e,
849: ota_offerings off
850: where e.event_id = rb.event_id
851: and off.offering_id = e.parent_offering_id --bug 3494404
852: and ((rb.required_date_from between
853: p_req_from and p_req_to)

Line 2059: l_language_code ota_offerings.language_code%type;

2055: --l_language_id ota_events.language_id%type; -- 2733966
2056: l_competence_id per_competence_elements.competence_id%type;
2057: l_proficiency_level_id per_competence_elements.proficiency_level_id%type;
2058: l_step_value number := null;
2059: l_language_code ota_offerings.language_code%type;
2060:
2061: cursor c_resource
2062: IS
2063: SELECT resource_type, trainer_id

Line 2089: OTA_OFFERINGS_VL off

2085: IS
2086: SELECT ev.event_type,ev.parent_event_id ,off.language_code
2087: FROM
2088: OTA_EVENTS ev,
2089: OTA_OFFERINGS_VL off
2090: WHERE ev.EVENT_ID = p_event_id
2091: AND ev.parent_offering_id = off.offering_id;
2092:
2093: Cursor

Line 2098: OTA_OFFERINGS_VL off

2094: c_event_lang (p_event_id number)
2095: IS
2096: select off.language_code
2097: From OTA_EVENTS ev,
2098: OTA_OFFERINGS_VL off
2099: WHERE EVENT_ID = p_event_id
2100: AND ev.parent_offering_id = off.offering_id;
2101:
2102: cursor c_comp_lang(p_language_code in varchar2)