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.PQP_RIW_ENROLL_WRAPPER dependencies on OTA_DELEGATE_BOOKINGS

Line 8: g_enroll_rec ota_delegate_bookings_v%rowtype;

4: -- =============================================================================
5: -- ~ Package Body Global variables:
6: -- =============================================================================
7: g_package varchar2(33) := 'enrollment_wrapper_api.';
8: g_enroll_rec ota_delegate_bookings_v%rowtype;
9: g_interface_code varchar2(150);
10:
11: -- =============================================================================
12: -- Default_Record_Values:

Line 15: return ota_delegate_bookings_v%rowtype is

11: -- =============================================================================
12: -- Default_Record_Values:
13: -- =============================================================================
14: function Default_Enroll_Rec
15: return ota_delegate_bookings_v%rowtype is
16: l_proc_name constant varchar2(150) := g_package||'Default_Enroll_Rec';
17: l_enroll_rec ota_delegate_bookings_v%rowtype;
18:
19: begin

Line 17: l_enroll_rec ota_delegate_bookings_v%rowtype;

13: -- =============================================================================
14: function Default_Enroll_Rec
15: return ota_delegate_bookings_v%rowtype is
16: l_proc_name constant varchar2(150) := g_package||'Default_Enroll_Rec';
17: l_enroll_rec ota_delegate_bookings_v%rowtype;
18:
19: begin
20:
21: Hr_Utility.set_location(' Entering: '||l_proc_name, 5);

Line 150: return ota_delegate_bookings_v%rowtype is

146: -- Get_Record_Values:
147: -- =============================================================================
148: function Get_Record_Values
149: (p_interface_code in varchar2 default null)
150: return ota_delegate_bookings_v%rowtype is
151:
152: cursor bne_cols(c_interface_code in varchar2) is
153: select lower(bic.interface_col_name) interface_col_name
154: from bne_interface_cols_b bic

Line 166: l_enroll_rec ota_delegate_bookings_v%rowtype;

162: from bne_interface_cols_b bic
163: where bic.interface_code = c_interface_code
164: and bic.display_flag ='N';
165:
166: l_enroll_rec ota_delegate_bookings_v%rowtype;
167: col_name varchar2(150);
168: l_proc_name constant varchar2(150) := g_package||'Get_Record_Values';
169: begin
170:

Line 486: l_date_booking_placed ota_delegate_bookings.date_booking_placed%TYPE;

482:
483: -- p_status_change_comments varchar2(30) default hr_api.g_varchar2;
484: -- p_update_finance_line varchar2(30) default hr_api.g_varchar2;
485: l_tfl_object_version_number number;
486: l_date_booking_placed ota_delegate_bookings.date_booking_placed%TYPE;
487: l_date_status_changed ota_delegate_bookings.date_status_changed%TYPE;
488: c_delegate_assignment_id number default null;
489: c_sponsor_assignment_id number default null;
490:

Line 487: l_date_status_changed ota_delegate_bookings.date_status_changed%TYPE;

483: -- p_status_change_comments varchar2(30) default hr_api.g_varchar2;
484: -- p_update_finance_line varchar2(30) default hr_api.g_varchar2;
485: l_tfl_object_version_number number;
486: l_date_booking_placed ota_delegate_bookings.date_booking_placed%TYPE;
487: l_date_status_changed ota_delegate_bookings.date_status_changed%TYPE;
488: c_delegate_assignment_id number default null;
489: c_sponsor_assignment_id number default null;
490:
491: --$ Get upload mode - "Create and Update" (C) or "Update Only" (U)

Line 505: l_enroll_rec ota_delegate_bookings_v%rowtype;

501: l_bo_id number(9);
502: l_object_version_number number(3);
503: l_obj_ver_num number(3);
504:
505: l_enroll_rec ota_delegate_bookings_v%rowtype;
506: l_interface_code varchar2(40);
507: l_crt_upd_len number;
508:
509: CURSOR booking_csr

Line 512: FROM ota_delegate_bookings b

508:
509: CURSOR booking_csr
510: IS
511: SELECT b.date_booking_placed
512: FROM ota_delegate_bookings b
513: WHERE b.booking_id = p_booking_id;
514:
515:
516: CURSOR deleg_ass_id

Line 804: from ota_delegate_bookings where

800: --g_enroll_rec.is_history_flag := p_is_history_flag ;
801:
802:
803: select object_version_number into l_object_version_number
804: from ota_delegate_bookings where
805: booking_id = l_booking_id;
806:
807: l_enroll_rec := Get_Record_Values(g_interface_code);
808: hr_utility.trace('l_enroll_rec.event_id : ' || l_enroll_rec.event_id);

Line 1344: l_date_booking_placed ota_delegate_bookings.date_booking_placed%TYPE;

1340: l_object_version_number number;
1341: l_tfl_object_version_number number;
1342: l_finance_line_id number;
1343: --
1344: l_date_booking_placed ota_delegate_bookings.date_booking_placed%TYPE;
1345: l_date_status_changed ota_delegate_bookings.date_status_changed%TYPE;
1346:
1347:
1348:

Line 1345: l_date_status_changed ota_delegate_bookings.date_status_changed%TYPE;

1341: l_tfl_object_version_number number;
1342: l_finance_line_id number;
1343: --
1344: l_date_booking_placed ota_delegate_bookings.date_booking_placed%TYPE;
1345: l_date_status_changed ota_delegate_bookings.date_status_changed%TYPE;
1346:
1347:
1348:
1349: CURSOR booking_csr

Line 1352: FROM ota_delegate_bookings b

1348:
1349: CURSOR booking_csr
1350: IS
1351: SELECT b.date_booking_placed
1352: FROM ota_delegate_bookings b
1353: WHERE b.booking_id = p_booking_id;
1354: --
1355:
1356: -- Other variables