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_TRAINING_PLAN_UPGRADE dependencies on OTA_DELEGATE_BOOKINGS

Line 20: ota_delegate_bookings tdb,

16: Cursor csr_get_date_completed(p_activity_version_id IN NUMBER, p_person_id IN NUMBER
17: ,p_contact_id in number) IS
18: SELECT min(date_status_changed)
19: FROM ota_events evt,
20: ota_delegate_bookings tdb,
21: ota_booking_status_types bst
22: WHERE evt.activity_version_id=p_activity_version_id
23: AND evt.event_id = tdb.event_id
24: AND bst.booking_status_type_id = tdb.booking_status_type_id

Line 1237: l_max_date_status_changed ota_delegate_bookings.date_status_changed%type;

1233: l_end_date date;
1234:
1235: l_member_status_code ota_lp_member_enrollments.member_status_code%type;
1236: l_old_status ota_lp_member_enrollments.member_status_code%type;
1237: l_max_date_status_changed ota_delegate_bookings.date_status_changed%type;
1238: l_date_status_changed ota_delegate_bookings.date_status_changed%type;
1239: --
1240: CURSOR csr_get_tp IS
1241: SELECT tps.training_plan_id, tps.business_group_id,

Line 1238: l_date_status_changed ota_delegate_bookings.date_status_changed%type;

1234:
1235: l_member_status_code ota_lp_member_enrollments.member_status_code%type;
1236: l_old_status ota_lp_member_enrollments.member_status_code%type;
1237: l_max_date_status_changed ota_delegate_bookings.date_status_changed%type;
1238: l_date_status_changed ota_delegate_bookings.date_status_changed%type;
1239: --
1240: CURSOR csr_get_tp IS
1241: SELECT tps.training_plan_id, tps.business_group_id,
1242: tps.name, tps.description,

Line 1524: l_max_date_status_changed ota_delegate_bookings.date_status_changed%type;

1520: l_member_status_type_flag boolean;
1521: l_status_code ota_lp_enrollments.path_status_code%type;
1522: l_status_type_id varchar2(30);
1523: l_old_status ota_lp_member_enrollments.member_status_code%type;
1524: l_max_date_status_changed ota_delegate_bookings.date_status_changed%type;
1525: l_date_status_changed ota_delegate_bookings.date_status_changed%type;
1526: l_name varchar2(80);
1527: l_lang_len number;
1528: MAX_NAME_LEN constant number := 80;

Line 1525: l_date_status_changed ota_delegate_bookings.date_status_changed%type;

1521: l_status_code ota_lp_enrollments.path_status_code%type;
1522: l_status_type_id varchar2(30);
1523: l_old_status ota_lp_member_enrollments.member_status_code%type;
1524: l_max_date_status_changed ota_delegate_bookings.date_status_changed%type;
1525: l_date_status_changed ota_delegate_bookings.date_status_changed%type;
1526: l_name varchar2(80);
1527: l_lang_len number;
1528: MAX_NAME_LEN constant number := 80;
1529: MAX_DATA_TRUNC_LEN constant number := 10;

Line 1935: l_max_date_status_changed ota_delegate_bookings.date_status_changed%type;

1931: l_end_date date;
1932:
1933: l_member_status_code ota_lp_member_enrollments.member_status_code%type;
1934: l_old_status ota_lp_member_enrollments.member_status_code%type;
1935: l_max_date_status_changed ota_delegate_bookings.date_status_changed%type;
1936: l_date_status_changed ota_delegate_bookings.date_status_changed%type;
1937: l_err_code varchar2(72);
1938: l_err_msg varchar2(2000);
1939:

Line 1936: l_date_status_changed ota_delegate_bookings.date_status_changed%type;

1932:
1933: l_member_status_code ota_lp_member_enrollments.member_status_code%type;
1934: l_old_status ota_lp_member_enrollments.member_status_code%type;
1935: l_max_date_status_changed ota_delegate_bookings.date_status_changed%type;
1936: l_date_status_changed ota_delegate_bookings.date_status_changed%type;
1937: l_err_code varchar2(72);
1938: l_err_msg varchar2(2000);
1939:
1940: CURSOR csr_get_tp IS

Line 2193: l_max_date_status_changed ota_delegate_bookings.date_status_changed%type;

2189: l_tpm_changed boolean;
2190: l_lpm_status_changed boolean;
2191: l_member_status_code ota_lp_member_enrollments.member_status_code%type;
2192: l_old_status ota_lp_member_enrollments.member_status_code%type;
2193: l_max_date_status_changed ota_delegate_bookings.date_status_changed%type;
2194: l_date_status_changed ota_delegate_bookings.date_status_changed%type;
2195: l_dummy number;
2196: l_status ota_booking_status_types.type%type;
2197: l_rows_processed number;

Line 2194: l_date_status_changed ota_delegate_bookings.date_status_changed%type;

2190: l_lpm_status_changed boolean;
2191: l_member_status_code ota_lp_member_enrollments.member_status_code%type;
2192: l_old_status ota_lp_member_enrollments.member_status_code%type;
2193: l_max_date_status_changed ota_delegate_bookings.date_status_changed%type;
2194: l_date_status_changed ota_delegate_bookings.date_status_changed%type;
2195: l_dummy number;
2196: l_status ota_booking_status_types.type%type;
2197: l_rows_processed number;
2198: l_completion_date date;

Line 2232: ota_delegate_bookings tdb,

2228: CURSOR csr_get_status(p_activity_version_id IN NUMBER, p_person_id IN NUMBER
2229: ,p_contact_id in number) IS
2230: SELECT DECODE(bst.type,'C','Z',bst.type) status
2231: FROM ota_events evt,
2232: ota_delegate_bookings tdb,
2233: ota_booking_status_types bst
2234: WHERE evt.activity_version_id=p_activity_version_id
2235: AND evt.event_id = tdb.event_id
2236: AND bst.booking_status_type_id = tdb.booking_status_type_id

Line 2257: FROM ota_delegate_bookings tdb,

2253: AND lpme.LP_ENROLLMENT_ID between p_start_pkid and p_end_pkid;
2254: --
2255: cursor csr_get_lpm_completion_date(p_lpm_enrollment_id IN NUMBER) IS
2256: SELECT trunc(min(nvl(tdb.date_status_changed,tdb.date_booking_placed))) completion_date
2257: FROM ota_delegate_bookings tdb,
2258: ota_lp_member_enrollments lpme,
2259: ota_learning_path_members lpm,
2260: ota_lp_enrollments lpe,
2261: ota_events evt,