DBA Data[Home] [Help]

APPS.OTA_ILEARNING dependencies on OTA_TAV_UPD

Line 21: 30-Jan-02 115.7 HDSHAH 2201416 Added Trunc() to l_course_date parameter for ota_tav_upd procedure calls.

17: 29-Jan-02 115.5 HDSHAH 2201416 trunc() included for course_start_date, course_end_date,
18: enrollment_start_date,enrollment_end_date in included for
19: ota_evt_ins.ins and ota_evt_upd.upd procedure calls
20: 29-Jan-02 115.6 DHMULIA 2201416 Added Trunc() to sysdate before calling ota_tav_ins.
21: 30-Jan-02 115.7 HDSHAH 2201416 Added Trunc() to l_course_date parameter for ota_tav_upd procedure calls.
22: 15-Feb-02 115.8 HDSHAH 2209467 p_start_date and p_end_date parameter type changed to varchar2 in
23: crt_or_chk_xml_prcs_tbl and upd_xml_prcs_tbl procedure.
24: 21-Feb-02 115.9 HDSHAH 2236928 Log messages modified.
25: 21-Feb-02 115.10 HDSHAH 2236928 Log messages modified.

Line 273: ota_tav_upd.Upd

269: BEGIN
270: -- clear message before calling API
271: hr_utility.clear_message;
272:
273: ota_tav_upd.Upd
274: (
275: P_activity_version_id => l_activity_version_id -- (Input)
276: ,P_version_name => p_activity_version_name -- (Input)
277: ,P_description => p_description -- (Input)

Line 407: ota_tav_upd.Upd

403: BEGIN
404: -- clear message before calling API
405: hr_utility.clear_message;
406:
407: ota_tav_upd.Upd
408: (
409: P_activity_version_id => l_activity_version_id -- (Input)
410: ,P_version_name => p_activity_version_name -- (Input)
411: ,P_description => p_description -- (Input)

Line 953: ota_tav_upd.Upd

949: BEGIN
950: -- clear message before calling API
951: hr_utility.clear_message;
952: -- Bug#2201416 trunc included for l_course_start_date parameter.
953: ota_tav_upd.Upd
954: (
955: p_activity_version_id => p_activity_version_id -- (Input)
956: ,p_start_date => trunc(l_course_start_date) -- (Input)
957: ,p_object_version_number => l_activity_ovn -- (Input Output)

Line 1250: ota_tav_upd.Upd

1246: BEGIN
1247: -- clear message before calling API
1248: hr_utility.clear_message;
1249: -- Bug#2201416 trunc included for l_course_start_date parameter.
1250: ota_tav_upd.Upd
1251: (
1252: p_activity_version_id => p_activity_version_id -- (Input)
1253: ,p_start_date => trunc(l_course_start_date) -- (Input)
1254: ,p_object_version_number => l_activity_ovn -- (Input Output)