DBA Data[Home] [Help]

APPS.HRHIRAPL dependencies on HRHIRAPL

Line 1: PACKAGE BODY hrhirapl AS

1: PACKAGE BODY hrhirapl AS
2: /* $Header: pehirapl.pkb 120.48.12020000.4 2013/02/04 14:33:20 sclakkar ship $ */
3:
4: --
5: ------------------------- BEGIN: employ_applicant --------------------

Line 147: hr_utility.set_location('IN hrhirapl.table_contents',490);

143: function table_contents return varchar2 is
144: l_appls varchar2(4000); -- Bug 3214063
145: l_max number;
146: BEGIN
147: hr_utility.set_location('IN hrhirapl.table_contents',490);
148: l_max := p_table.COUNT;
149: hr_utility.trace('table rows : '||to_char(l_max));
150: for v_index in 1..l_max loop
151:

Line 156: hr_utility.set_location('OUT hrhirapl.table_contents',495);

152: l_appls := l_appls||' ('||to_char(p_table(v_index).id)||')'
153: ||p_table(v_index).process_flag;
154:
155: END LOOP;
156: hr_utility.set_location('OUT hrhirapl.table_contents',495);
157: return(l_appls);
158: END;
159: --
160: --

Line 731: hr_utility.set_location('hrhirapl.make_secondary',1);

727: begin
728: -- # 2366672
729: -- Application needs to be end dated before the apl asg get updated.
730: --
731: hr_utility.set_location('hrhirapl.make_secondary',1);
732: -- +-----------------------------------------------------------------------+
733: -- +------------------------ End Application -----------------------------+
734: -- +-----------------------------------------------------------------------+
735: -- Does the Retain value exist in the table ?

Line 792: hr_utility.set_location('hrhirapl.make_secondary',2);

788: open get_flex_def;
789: fetch get_flex_def into l_col_name;
790: close get_flex_def;
791: --
792: hr_utility.set_location('hrhirapl.make_secondary',2);
793: --
794: -- Update all accepted assignments making them all
795: -- secondary (also end dates the assignment type 'A'
796: -- Unless the update primary_flag is set, in which case

Line 816: hr_utility.set_location('hrhirapl.make_secondary',333);

812: -- Ensure (R)etain or (E)nd date flags have not been set
813: if hr_employee_applicant_api.is_convert(p_table
814: ,l_asg_rec.assignment_id)
815: then
816: hr_utility.set_location('hrhirapl.make_secondary',333);
817: hr_utility.trace(' asg id = '||to_char(l_asg_rec.assignment_id));
818: hr_utility.trace(' start date = '||to_char(l_asg_rec.effective_start_date,'dd/mm/yy'));
819:
820: -- +--------------------------------------------------+

Line 1191: hr_utility.set_location('hrhirapl.make_secondary',3);

1187: ,p_employee_number
1188: ,p_assignment_sequence
1189: ,p_assignment_number);
1190: --
1191: hr_utility.set_location('hrhirapl.make_secondary',3);
1192: --
1193: -- fix for 7120387
1194: declare
1195:

Line 1388: hr_utility.set_location('hrhirapl.make_secondary',4);

1384: if (p_legislation_code = 'GB' ) then
1385: PER_GB_PENSRV_SVPN.AUTO_CALC_FTE(P_ASSIGNMENT_ID => p_assignment_id,P_EFFECTIVE_START_DATE => p_session_date) ;
1386: end if;
1387:
1388: hr_utility.set_location('hrhirapl.make_secondary',4);
1389: --
1390: hr_assignment.load_budget_values(p_assignment_id
1391: ,p_business_group_id
1392: ,p_user_id

Line 1422: hr_utility.set_location('hrhirapl.make_secondary',5);

1418: -- +--------------------------------------------------+
1419: -- +--- End Date assignment --------------------------+
1420: -- +--------------------------------------------------+
1421: --
1422: hr_utility.set_location('hrhirapl.make_secondary',5);
1423: l_chk_assg_end_dated := 'Y'; -- bug 6310975
1424: begin
1425: update per_assignments_f
1426: set effective_end_date = p_start_date -1

Line 1434: hr_utility.set_location('hrhirapl.make_secondary ASGID : '||

1430: per_otherbg_apl_api.close_otherbg_applications(l_asg_rec.assignment_id,p_start_date -1,'HIRE_END');
1431: end if;
1432: exception
1433: when others then
1434: hr_utility.set_location('hrhirapl.make_secondary ASGID : '||
1435: to_char(l_asg_rec.assignment_id),66);
1436: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1437: hr_utility.set_message_token('PROCEDURE','make_secondary ');
1438: hr_utility.set_message_token('STEP','4');

Line 1470: hr_utility.set_location('hrhirapl.make_secondary',500);

1466: */
1467: --
1468: --bug fix 6310975
1469:
1470: hr_utility.set_location('hrhirapl.make_secondary',500);
1471: IF l_chk_assg_end_dated <> 'Y' THEN
1472:
1473:
1474: OPEN get_pay_proposal(l_asg_rec.assignment_id);

Line 1478: hr_utility.set_location('hrhirapl.make_secondary',501);

1474: OPEN get_pay_proposal(l_asg_rec.assignment_id);
1475: FETCH get_pay_proposal INTO l_pay_pspl_id,l_pay_obj_number,l_proposed_sal_n, l_dummy_change_date;
1476: if get_pay_proposal%found then
1477: close get_pay_proposal;
1478: hr_utility.set_location('hrhirapl.make_secondary',501);
1479: hr_utility.set_location('hrhirapl.make_secondary '||l_asg_rec.assignment_id,502);
1480: hr_utility.set_location(' make_secondary.l_dummy_change_date '||l_dummy_change_date,502);
1481: hr_utility.set_location(' make_secondary.l_pay_pspl_id '||l_pay_pspl_id,502);
1482: hr_utility.set_location(' make_secondary.l_proposed_sal_n '|| l_proposed_sal_n,502);

Line 1479: hr_utility.set_location('hrhirapl.make_secondary '||l_asg_rec.assignment_id,502);

1475: FETCH get_pay_proposal INTO l_pay_pspl_id,l_pay_obj_number,l_proposed_sal_n, l_dummy_change_date;
1476: if get_pay_proposal%found then
1477: close get_pay_proposal;
1478: hr_utility.set_location('hrhirapl.make_secondary',501);
1479: hr_utility.set_location('hrhirapl.make_secondary '||l_asg_rec.assignment_id,502);
1480: hr_utility.set_location(' make_secondary.l_dummy_change_date '||l_dummy_change_date,502);
1481: hr_utility.set_location(' make_secondary.l_pay_pspl_id '||l_pay_pspl_id,502);
1482: hr_utility.set_location(' make_secondary.l_proposed_sal_n '|| l_proposed_sal_n,502);
1483:

Line 1513: hr_utility.set_location('hrhirapl.make_secondary',521);

1509: OPEN get_pay_proposal(l_asg_rec.assignment_id);
1510: FETCH get_pay_proposal INTO l_pay_pspl_id,l_pay_obj_number,l_proposed_sal_n, l_dummy_change_date;
1511: if get_pay_proposal%found then
1512: close get_pay_proposal;
1513: hr_utility.set_location('hrhirapl.make_secondary',521);
1514: hr_utility.set_location('hrhirapl.make_secondary '||l_asg_rec.assignment_id,502);
1515:
1516: hr_maintain_proposal_api.cre_or_upd_salary_proposal(
1517: p_validate => false,

Line 1514: hr_utility.set_location('hrhirapl.make_secondary '||l_asg_rec.assignment_id,502);

1510: FETCH get_pay_proposal INTO l_pay_pspl_id,l_pay_obj_number,l_proposed_sal_n, l_dummy_change_date;
1511: if get_pay_proposal%found then
1512: close get_pay_proposal;
1513: hr_utility.set_location('hrhirapl.make_secondary',521);
1514: hr_utility.set_location('hrhirapl.make_secondary '||l_asg_rec.assignment_id,502);
1515:
1516: hr_maintain_proposal_api.cre_or_upd_salary_proposal(
1517: p_validate => false,
1518: p_pay_proposal_id => l_pay_pspl_id ,

Line 1529: hr_utility.set_location('hrhirapl.make_secondary',522);

1525: p_approved_warning => l_approved_warning,
1526: p_payroll_warning => l_payroll_warning,
1527: p_proposed_salary_n => l_proposed_sal_n,
1528: p_business_group_id => p_business_group_id);
1529: hr_utility.set_location('hrhirapl.make_secondary',522);
1530: else
1531: close get_pay_proposal;
1532: end if;
1533:

Line 1535: hr_utility.set_location('hrhirapl.make_secondary',524);

1531: close get_pay_proposal;
1532: end if;
1533:
1534: end if;
1535: hr_utility.set_location('hrhirapl.make_secondary',524);
1536:
1537: --
1538: --bug fix 6310975
1539: --added by amigarg for bug 4882512 end

Line 1549: hr_utility.set_location('hrhirapl.make_secondary',400);

1545: /*else
1546: -- fix for the bug
1547: -- first process the primary assignment id so that the assignment number is
1548: -- correclty generated
1549: hr_utility.set_location('hrhirapl.make_secondary',400);
1550: open csr_ass_cur_for_primary;
1551: loop
1552: fetch csr_ass_cur_for_primary into l_asg_rec; --#2119831
1553: exit when csr_ass_cur_for_primary%NOTFOUND;

Line 1563: hr_utility.set_location('hrhirapl.make_secondary',401);

1559: -- Ensure (R)etain or (E)nd date flags have not been set
1560: if hr_employee_applicant_api.is_convert(p_table
1561: ,l_asg_rec.assignment_id)
1562: then
1563: hr_utility.set_location('hrhirapl.make_secondary',401);
1564: hr_utility.trace(' asg id = '||to_char(l_asg_rec.assignment_id));
1565: hr_utility.trace(' start date = '||to_char(l_asg_rec.effective_start_date,'dd/mm/yy'));
1566:
1567: -- +--------------------------------------------------+

Line 1937: hr_utility.set_location('hrhirapl.make_secondary',402);

1933: ,p_employee_number
1934: ,p_assignment_sequence
1935: ,p_assignment_number);
1936: --
1937: hr_utility.set_location('hrhirapl.make_secondary',402);
1938: begin
1939: update per_assignments_f pa
1940: set pa.assignment_status_type_id = p_assignment_status_type_id
1941: , pa.assignment_type = 'E'

Line 2006: hr_utility.set_location('hrhirapl.make_secondary',4);

2002: end if;
2003: -- End of fix 3564129
2004: -- Bug 401669
2005: --
2006: hr_utility.set_location('hrhirapl.make_secondary',4);
2007: --
2008: hr_assignment.load_budget_values(p_assignment_id
2009: ,p_business_group_id
2010: ,p_user_id

Line 2039: hr_utility.set_location('hrhirapl.make_secondary',5);

2035: -- +--------------------------------------------------+
2036: -- +--- End Date assignment --------------------------+
2037: -- +--------------------------------------------------+
2038: --
2039: hr_utility.set_location('hrhirapl.make_secondary',5);
2040: begin
2041: update per_assignments_f
2042: set effective_end_date = p_start_date -1
2043: where current of csr_ass_cur_for_primary;

Line 2046: hr_utility.set_location('hrhirapl.make_secondary ASGID : '||

2042: set effective_end_date = p_start_date -1
2043: where current of csr_ass_cur_for_primary;
2044: exception
2045: when others then
2046: hr_utility.set_location('hrhirapl.make_secondary ASGID : '||
2047: to_char(l_asg_rec.assignment_id),66);
2048: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
2049: hr_utility.set_message_token('PROCEDURE','make_secondary ');
2050: hr_utility.set_message_token('STEP','4');

Line 2088: hr_utility.set_location('hrhirapl.make_secondary',403);

2084:
2085: -- now process all seconday or non primary assignments
2086:
2087:
2088: hr_utility.set_location('hrhirapl.make_secondary',403);
2089: open csr_ass_cur_for_nonprimary;
2090: loop
2091: fetch csr_ass_cur_for_nonprimary into l_asg_rec; --#2119831
2092: exit when csr_ass_cur_for_nonprimary%NOTFOUND;

Line 2102: hr_utility.set_location('hrhirapl.make_secondary',404);

2098: -- Ensure (R)etain or (E)nd date flags have not been set
2099: if hr_employee_applicant_api.is_convert(p_table
2100: ,l_asg_rec.assignment_id)
2101: then
2102: hr_utility.set_location('hrhirapl.make_secondary',404);
2103: hr_utility.trace(' asg id = '||to_char(l_asg_rec.assignment_id));
2104: hr_utility.trace(' start date = '||to_char(l_asg_rec.effective_start_date,'dd/mm/yy'));
2105:
2106: -- +--------------------------------------------------+

Line 2476: hr_utility.set_location('hrhirapl.make_secondary',405);

2472: ,p_employee_number
2473: ,p_assignment_sequence
2474: ,p_assignment_number);
2475: --
2476: hr_utility.set_location('hrhirapl.make_secondary',405);
2477: begin
2478: update per_assignments_f pa
2479: set pa.assignment_status_type_id = p_assignment_status_type_id
2480: , pa.assignment_type = 'E'

Line 2543: hr_utility.set_location('hrhirapl.make_secondary',406);

2539: ,p_object_version_number => l_asg_status_ovn);
2540: -- End of fix 3564129
2541: -- Bug 401669
2542: --
2543: hr_utility.set_location('hrhirapl.make_secondary',406);
2544: --
2545: hr_assignment.load_budget_values(p_assignment_id
2546: ,p_business_group_id
2547: ,p_user_id

Line 2576: hr_utility.set_location('hrhirapl.make_secondary',407);

2572: -- +--------------------------------------------------+
2573: -- +--- End Date assignment --------------------------+
2574: -- +--------------------------------------------------+
2575: --
2576: hr_utility.set_location('hrhirapl.make_secondary',407);
2577: begin
2578: update per_assignments_f
2579: set effective_end_date = p_start_date -1
2580: where current of csr_ass_cur_for_nonprimary;

Line 2583: hr_utility.set_location('hrhirapl.make_secondary ASGID : '||

2579: set effective_end_date = p_start_date -1
2580: where current of csr_ass_cur_for_nonprimary;
2581: exception
2582: when others then
2583: hr_utility.set_location('hrhirapl.make_secondary ASGID : '||
2584: to_char(l_asg_rec.assignment_id),408);
2585: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
2586: hr_utility.set_message_token('PROCEDURE','make_secondary ');
2587: hr_utility.set_message_token('STEP','4');

Line 2621: hr_utility.set_location('hrhirapl.make_secondary',409);

2617:
2618: end loop;
2619: --
2620: close csr_ass_cur_for_nonprimary;
2621: hr_utility.set_location('hrhirapl.make_secondary',409);
2622: end if;
2623: hr_utility.set_location('hrhirapl.make_secondary',410);
2624: -- end of bug 5498344
2625: commented for bug 5589928*/

Line 2623: hr_utility.set_location('hrhirapl.make_secondary',410);

2619: --
2620: close csr_ass_cur_for_nonprimary;
2621: hr_utility.set_location('hrhirapl.make_secondary',409);
2622: end if;
2623: hr_utility.set_location('hrhirapl.make_secondary',410);
2624: -- end of bug 5498344
2625: commented for bug 5589928*/
2626: --
2627: -- add condition: number of updates should be the same as number

Line 2941: hr_utility.set_location('hrhirapl.create_primary_assignment',1);

2937: --
2938: --
2939: begin
2940: --
2941: hr_utility.set_location('hrhirapl.create_primary_assignment',1);
2942: --
2943: -- VT 06/14/00
2944: open cur_apl_asg;
2945: fetch cur_apl_asg into apl_asg_rec;

Line 3018: hr_utility.set_location('hrhirapl.create_primary_assignment',2);

3014: end if;
3015: end;
3016: end if;
3017: --
3018: hr_utility.set_location('hrhirapl.create_primary_assignment',2);
3019: --
3020: begin
3021: --
3022: --

Line 3129: hr_utility.set_location('hrhirapl.employ_applicant',99);

3125: --
3126: -- Bug #4462906 Moved the hrutility call
3127: -- after SQL%ROWCOUNT check
3128: --
3129: hr_utility.set_location('hrhirapl.employ_applicant',99);
3130: --
3131: hrentmnt.maintain_entries_asg(p_new_primary_id
3132: ,p_business_group_id
3133: ,'HIRE_APPL' -- ,'ASG_CRITERIA' for bug 5547271

Line 3142: hr_utility.set_location('hrhirapl.employ_applicant',100);

3138: ,p_start_date
3139: ,p_end_of_time);
3140: end;
3141: -- Bug 14551643
3142: hr_utility.set_location('hrhirapl.employ_applicant',100);
3143: OPEN emp_asg;
3144: FETCH emp_asg INTO l_rowid;
3145: CLOSE emp_asg;
3146:

Line 3206: hr_utility.set_location('hrhirapl.employ_applicant',101);

3202: ,p_ass_attribute27 => apl_rec.ass_attribute27
3203: ,p_ass_attribute28 => apl_rec.ass_attribute28
3204: ,p_ass_attribute29 => apl_rec.ass_attribute29
3205: ,p_ass_attribute30 => apl_rec.ass_attribute30);
3206: hr_utility.set_location('hrhirapl.employ_applicant',101);
3207: -- Bug 14551643
3208: else
3209: --
3210: hr_utility.set_location('hrhirapl.create_primary_assignment',3);

Line 3210: hr_utility.set_location('hrhirapl.create_primary_assignment',3);

3206: hr_utility.set_location('hrhirapl.employ_applicant',101);
3207: -- Bug 14551643
3208: else
3209: --
3210: hr_utility.set_location('hrhirapl.create_primary_assignment',3);
3211: --
3212:
3213: declare
3214: --

Line 3543: hr_utility.set_location('### 3: hrhirapl.create_primary_assignment ',3979);

3539: -- End changes for bug 13059935
3540:
3541: -- Added for the bug 6497082 starts here
3542:
3543: hr_utility.set_location('### 3: hrhirapl.create_primary_assignment ',3979);
3544: hr_utility.set_location('### 3: hrhirapl.create_primary_assignment '||apl_asg_rec.assignment_status_type_id,3989);
3545: per_people3_pkg.get_default_person_type
3546: (p_required_type => 'ACTIVE_ASSIGN'
3547: ,p_business_group_id => p_business_group_id

Line 3544: hr_utility.set_location('### 3: hrhirapl.create_primary_assignment '||apl_asg_rec.assignment_status_type_id,3989);

3540:
3541: -- Added for the bug 6497082 starts here
3542:
3543: hr_utility.set_location('### 3: hrhirapl.create_primary_assignment ',3979);
3544: hr_utility.set_location('### 3: hrhirapl.create_primary_assignment '||apl_asg_rec.assignment_status_type_id,3989);
3545: per_people3_pkg.get_default_person_type
3546: (p_required_type => 'ACTIVE_ASSIGN'
3547: ,p_business_group_id => p_business_group_id
3548: ,p_legislation_code => p_legislation_code

Line 3551: hr_utility.set_location('### 3: hrhirapl.create_primary_assignment '||l_assignment_status_type_id,3999);

3547: ,p_business_group_id => p_business_group_id
3548: ,p_legislation_code => p_legislation_code
3549: ,p_person_type => l_assignment_status_type_id
3550: );
3551: hr_utility.set_location('### 3: hrhirapl.create_primary_assignment '||l_assignment_status_type_id,3999);
3552:
3553: -- Fix For Bug # 7046591 Starts. Added If Clause ---
3554: -- if emp_asg_rec.vacancy_id is not null then -- fix for the bug#11778052
3555: ----------------------

Line 4015: hr_utility.set_location('hrhirapl.create_primary_assignment',10);

4011: -- End of Bug 3506363
4012: -- End of BEN Call
4013:
4014: --
4015: hr_utility.set_location('hrhirapl.create_primary_assignment',10);
4016:
4017: --
4018: -- Changed the value for set_of_books_if from p_set_of_books_id to
4019: -- emp_asg_rec.set_of_books_id bug #2398327

Line 4094: hr_utility.set_location('### 4: hrhirapl.create_primary_assignment',3981);

4090: where pa.rowid = p_rowid;
4091: --
4092: -- Added for the bug 6497082 starts here
4093:
4094: hr_utility.set_location('### 4: hrhirapl.create_primary_assignment',3981);
4095:
4096: -- Start changes for bug 13059935
4097: ben_dt_trgr_handle.assignment
4098: (p_rowid => p_rowid

Line 4155: hr_utility.set_location('### 4: hrhirapl.create_primary_assignment'||emp_asg_rec.assignment_status_type_id,3991);

4151: ,p_ass_attribute30 => ass_rec.ass_attribute30
4152: );
4153: -- End changes for bug 13059935
4154:
4155: hr_utility.set_location('### 4: hrhirapl.create_primary_assignment'||emp_asg_rec.assignment_status_type_id,3991);
4156: per_people3_pkg.get_default_person_type
4157: (p_required_type => 'ACTIVE_ASSIGN'
4158: ,p_business_group_id => p_business_group_id
4159: ,p_legislation_code => p_legislation_code

Line 4468: hr_utility.set_location('hrhirapl.create_primary_assignment',33);

4464: -- end 2433154
4465: end loop;
4466: --
4467: if ass_cur%ROWCOUNT <1 then
4468: hr_utility.set_location('hrhirapl.create_primary_assignment',33);
4469: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
4470: hr_utility.set_message_token('PROCEDURE','create_primary_assignment');
4471: hr_utility.set_message_token('STEP','3');
4472: hr_utility.raise_error;

Line 4485: hr_utility.set_location('hrhirapl.create_primary_assignment',22);

4481: and p_start_date between pa.effective_start_date
4482: and pa.effective_end_date
4483: for update of pa.effective_end_date;
4484: begin
4485: hr_utility.set_location('hrhirapl.create_primary_assignment',22);
4486: hr_utility.trace(' Update APL asg id => '||to_char(p_new_primary_id));
4487: open app_cur;
4488: loop
4489: fetch app_cur into p_rowid;

Line 4491: hr_utility.set_location('hrhirapl.create_primary_assignment',23);

4487: open app_cur;
4488: loop
4489: fetch app_cur into p_rowid;
4490: exit when app_cur%notfound;
4491: hr_utility.set_location('hrhirapl.create_primary_assignment',23);
4492: update per_assignments_f
4493: set effective_end_date = p_start_date - 1
4494: where rowid = p_rowid;
4495: end loop;

Line 4497: hr_utility.set_location('hrhirapl.create_primary_assignment',44);

4493: set effective_end_date = p_start_date - 1
4494: where rowid = p_rowid;
4495: end loop;
4496: if app_cur%ROWCOUNT <1 then
4497: hr_utility.set_location('hrhirapl.create_primary_assignment',44);
4498: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
4499: hr_utility.set_message_token('PROCEDURE','create_primary_assignment');
4500: hr_utility.set_message_token('STEP','4');
4501: hr_utility.raise_error;

Line 4998: hr_utility.set_location('IN hrhirapl.end_unaccepted_app_assign',303);

4994: l_end_date := p_end_date -1;
4995: --
4996: -- #2264569
4997: --
4998: hr_utility.set_location('IN hrhirapl.end_unaccepted_app_assign',303);
4999: open unacc_cur;
5000: loop
5001: fetch unacc_cur into l_asgid;
5002: exit when unacc_cur%NOTFOUND;

Line 5005: hr_utility.set_location('hrhirapl.end_unaccepted_app_assign',305);

5001: fetch unacc_cur into l_asgid;
5002: exit when unacc_cur%NOTFOUND;
5003: begin
5004: if hr_employee_applicant_api.end_date_exists(p_table,l_asgid) <> 2 then
5005: hr_utility.set_location('hrhirapl.end_unaccepted_app_assign',305);
5006: hr_utility.trace(' **** Asg ID : '||to_char(l_asgid));
5007:
5008: update per_assignments pa
5009: set pa.effective_end_date = l_end_date

Line 5051: hr_utility.set_location('OUT hrhirapl.end_unaccepted_app_assign',310);

5047: hr_utility.raise_error;
5048: end;
5049: end loop;
5050: close unacc_cur;
5051: hr_utility.set_location('OUT hrhirapl.end_unaccepted_app_assign',310);
5052:
5053: end end_unaccepted_app_assign;
5054: --
5055: -- +----------------------END: end_unaccepted_app_assign -------------+

Line 5139: end hrhirapl;

5135: end if;
5136: --
5137: end end_bookings;
5138: ----------------------------END: end_bookings --------------------
5139: end hrhirapl;