APPS.OTA_TIMEZONE_UPGRADE dependencies on OTA_SUPPLIABLE_RESOURCES

Line 12: l_loc_id ota_suppliable_resources.location_id%TYPE;

8: log_type_e constant VARCHAR2(30) := 'E';
9: -- log type is Error
10: l_time_zone ota_events.timezone%TYPE;
11: l_primary_venue ota_events.location_id%TYPE;
12: l_loc_id ota_suppliable_resources.location_id%TYPE;
13: l_trng_center_id ota_suppliable_resources.training_center_id%TYPE;
14: l_err_msg VARCHAR2(2000);
15: l_err VARCHAR2(2000);
16: l_err_code VARCHAR2(72);

Line 13: l_trng_center_id ota_suppliable_resources.training_center_id%TYPE;

9: -- log type is Error
10: l_time_zone ota_events.timezone%TYPE;
11: l_primary_venue ota_events.location_id%TYPE;
12: l_loc_id ota_suppliable_resources.location_id%TYPE;
13: l_trng_center_id ota_suppliable_resources.training_center_id%TYPE;
14: l_err_msg VARCHAR2(2000);
15: l_err VARCHAR2(2000);
16: l_err_code VARCHAR2(72);
17: l_msg VARCHAR2(200);

Line 21: FUNCTION get_location_tz(l_location_id IN ota_suppliable_resources.location_id%TYPE)

17: l_msg VARCHAR2(200);
18: l_others_msg VARCHAR2(200);
19: l_default_msg VARCHAR2(200) := 'Value for the Default timezone is missing';
20:
21: FUNCTION get_location_tz(l_location_id IN ota_suppliable_resources.location_id%TYPE)
22: RETURN VARCHAR2
23: IS
24:
25: l_time_zone ota_events.timezone%TYPE;

Line 83: PROCEDURE get_location_trngcenter_id(l_supplied_resource_id IN ota_suppliable_resources.supplied_resource_id%TYPE,

79:
80: do_upg := l_do_submit;
81: END validate_proc_for_tz_upg;
82:
83: PROCEDURE get_location_trngcenter_id(l_supplied_resource_id IN ota_suppliable_resources.supplied_resource_id%TYPE,
84: l_location_id OUT nocopy ota_suppliable_resources.location_id%TYPE,
85: l_trng_center_id OUT nocopy ota_suppliable_resources.training_center_id%TYPE)
86: IS
87: BEGIN

Line 84: l_location_id OUT nocopy ota_suppliable_resources.location_id%TYPE,

80: do_upg := l_do_submit;
81: END validate_proc_for_tz_upg;
82:
83: PROCEDURE get_location_trngcenter_id(l_supplied_resource_id IN ota_suppliable_resources.supplied_resource_id%TYPE,
84: l_location_id OUT nocopy ota_suppliable_resources.location_id%TYPE,
85: l_trng_center_id OUT nocopy ota_suppliable_resources.training_center_id%TYPE)
86: IS
87: BEGIN
88: SELECT location_id,

Line 85: l_trng_center_id OUT nocopy ota_suppliable_resources.training_center_id%TYPE)

81: END validate_proc_for_tz_upg;
82:
83: PROCEDURE get_location_trngcenter_id(l_supplied_resource_id IN ota_suppliable_resources.supplied_resource_id%TYPE,
84: l_location_id OUT nocopy ota_suppliable_resources.location_id%TYPE,
85: l_trng_center_id OUT nocopy ota_suppliable_resources.training_center_id%TYPE)
86: IS
87: BEGIN
88: SELECT location_id,
89: training_center_id

Line 92: FROM ota_suppliable_resources

88: SELECT location_id,
89: training_center_id
90: INTO l_location_id,
91: l_trng_center_id
92: FROM ota_suppliable_resources
93: WHERE supplied_resource_id = l_supplied_resource_id;
94:
95: EXCEPTION
96: WHEN others THEN

Line 206: l_primary_venue ota_suppliable_resources.supplied_resource_id%TYPE;

202:
203: FUNCTION get_primary_venue_id(l_event_id IN ota_resource_bookings.event_id%TYPE)
204: RETURN NUMBER
205: IS
206: l_primary_venue ota_suppliable_resources.supplied_resource_id%TYPE;
207:
208: CURSOR csr_pri_ven(p_event_id NUMBER) IS
209: SELECT resbkng.supplied_resource_id
210: FROM ota_resource_bookings resbkng

Line 229: FUNCTION get_primary_venue_tz(l_primary_venue IN ota_suppliable_resources.supplied_resource_id%TYPE)

225:
226: RETURN l_primary_venue;
227: END get_primary_venue_id;
228:
229: FUNCTION get_primary_venue_tz(l_primary_venue IN ota_suppliable_resources.supplied_resource_id%TYPE)
230: RETURN VARCHAR2
231: IS
232: l_time_zone ota_events.timezone%TYPE;
233:

Line 236: FROM ota_suppliable_resources res,

232: l_time_zone ota_events.timezone%TYPE;
233:
234: CURSOR csr_pri_ven_tz(p_pri_ven NUMBER) IS
235: SELECT loc.timezone_code
236: FROM ota_suppliable_resources res,
237: hr_locations loc
238: WHERE supplied_resource_id = p_pri_ven
239: AND res.location_id = loc.location_id;
240: BEGIN

Line 256: FUNCTION get_trngcenter_tz(l_trainning_center IN ota_suppliable_resources.training_center_id%TYPE)

252:
253: RETURN l_time_zone;
254: END get_primary_venue_tz;
255:
256: FUNCTION get_trngcenter_tz(l_trainning_center IN ota_suppliable_resources.training_center_id%TYPE)
257: RETURN VARCHAR2
258: IS
259: l_time_zone ota_events.timezone%TYPE;
260:

Line 859: FROM ota_resource_bookings trb,ota_suppliable_resources res

855: trb.resource_booking_id,
856: trb.timezone_code,
857: trb.book_entire_period_flag,
858: res.resource_type
859: FROM ota_resource_bookings trb,ota_suppliable_resources res
860: WHERE trb.status = 'C'
861: and res.resource_type in ('T','V')
862: and trb.required_date_to >=(trunc(sysdate)-14)
863: and trb.supplied_resource_id=res.supplied_resource_id