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.GHR_GEN_RPA_NPA dependencies on GHR_PA_REQUESTS

Line 58: PROCEDURE Generate_RPA(p_pa_request_id ghr_pa_requests.pa_request_id%type, p_view_type VARCHAR2, p_xml_string OUT NOCOPY CLOB) IS

54: END wrap_text;
55:
56:
57:
58: PROCEDURE Generate_RPA(p_pa_request_id ghr_pa_requests.pa_request_id%type, p_view_type VARCHAR2, p_xml_string OUT NOCOPY CLOB) IS
59: CURSOR cur_RPA(c_pa_request_id ghr_pa_requests.pa_request_id%type) IS
60: SELECT
61: FAM.NAME ACTION_REQUESTED
62: ,PA_REQUEST_ID

Line 59: CURSOR cur_RPA(c_pa_request_id ghr_pa_requests.pa_request_id%type) IS

55:
56:
57:
58: PROCEDURE Generate_RPA(p_pa_request_id ghr_pa_requests.pa_request_id%type, p_view_type VARCHAR2, p_xml_string OUT NOCOPY CLOB) IS
59: CURSOR cur_RPA(c_pa_request_id ghr_pa_requests.pa_request_id%type) IS
60: SELECT
61: FAM.NAME ACTION_REQUESTED
62: ,PA_REQUEST_ID
63: ,REQUEST_NUMBER

Line 79: ,GHR_PA_REQUESTS.NOA_FAMILY_CODE

75: ,EMPLOYEE_NATIONAL_IDENTIFIER SS_NUMBER
76: ,EMPLOYEE_DATE_OF_BIRTH
77: ,NVL(GHR_UPD_HR_VALIDATION.GET_EXEMP_AWARD_DATE(PA_REQUEST_ID),EFFECTIVE_DATE) EFFECTIVE_DATE
78: ,DECODE(LENGTH(NVL(FIRST_NOA_CODE, '')), 4, SUBSTR(FIRST_NOA_CODE, 2, 3), FIRST_NOA_CODE) FIRST_NOA_CODE
79: ,GHR_PA_REQUESTS.NOA_FAMILY_CODE
80: ,FIRST_NOA_DESC
81: ,FIRST_ACTION_LA_CODE1
82: ,FIRST_ACTION_LA_CODE2
83: ,FIRST_ACTION_LA_DESC1

Line 183: FROM GHR_PA_REQUESTS, GHR_FAMILIES FAM

179: ,NOTEPAD
180: ,ALTERED_PA_REQUEST_ID
181: ,AUTHORIZED_BY_FULL_NAME
182: ,REQUESTED_BY_FULL_NAME
183: FROM GHR_PA_REQUESTS, GHR_FAMILIES FAM
184: WHERE
185: PA_REQUEST_ID = c_pa_request_id
186: AND GHR_PA_REQUESTS.NOA_FAMILY_CODE = FAM.NOA_FAMILY_CODE;
187:

Line 186: AND GHR_PA_REQUESTS.NOA_FAMILY_CODE = FAM.NOA_FAMILY_CODE;

182: ,REQUESTED_BY_FULL_NAME
183: FROM GHR_PA_REQUESTS, GHR_FAMILIES FAM
184: WHERE
185: PA_REQUEST_ID = c_pa_request_id
186: AND GHR_PA_REQUESTS.NOA_FAMILY_CODE = FAM.NOA_FAMILY_CODE;
187:
188: CURSOR c_remarks(c_pa_request_id GHR_PA_REMARKS.pa_request_id%type) IS
189: SELECT
190: pre.description,

Line 205: CURSOR c_agency_use(c_pa_request_id ghr_pa_requests.pa_request_id%type) IS

201: from per_all_people_f per1
202: where per1.person_id = p_person_id
203: and NVL(p_effective_date,TRUNC(sysdate)) between per1.effective_start_date and per1.effective_end_date;
204:
205: CURSOR c_agency_use(c_pa_request_id ghr_pa_requests.pa_request_id%type) IS
206: SELECT rei_information3
207: ,rei_information4
208: ,rei_information5
209: ,rei_information6

Line 238: CURSOR C_SIGNATURES (p_pa_request_id ghr_pa_requests.pa_request_id%type, p_effective_date DATE) IS

234: AND ASG.position_id = PG1.position_id (+)
235: AND PG1.information_type (+) = 'GHR_US_POS_GRP1';
236:
237:
238: CURSOR C_SIGNATURES (p_pa_request_id ghr_pa_requests.pa_request_id%type, p_effective_date DATE) IS
239: SELECT PG1.POEI_INFORMATION4 Office_Symbol,
240: PER.LAST_NAME || ', ' || PER.FIRST_NAME || ' ' || PER.MIDDLE_NAMES FULL_NAME,
241: TO_CHAR(PRH.LAST_UPDATE_DATE, 'MM-DD-YYYY') LAST_UPDATE_DATE
242: FROM GHR_PA_ROUTING_HISTORY PRH,

Line 262: l_pa_request_rec ghr_pa_requests%rowtype;

258: AND ASG.position_id = PG1.position_id (+)
259: AND PG1.information_type (+) = 'GHR_US_POS_GRP1'
260: ORDER BY PRH.LAST_UPDATE_DATE DESC;
261:
262: l_pa_request_rec ghr_pa_requests%rowtype;
263: l_pa_request_rec_out ghr_pa_requests%rowtype;
264: l_cnt_sigs NUMBER;
265: l_signature_rec t_signature_rec;
266: l_rem_ctr NUMBER;

Line 263: l_pa_request_rec_out ghr_pa_requests%rowtype;

259: AND PG1.information_type (+) = 'GHR_US_POS_GRP1'
260: ORDER BY PRH.LAST_UPDATE_DATE DESC;
261:
262: l_pa_request_rec ghr_pa_requests%rowtype;
263: l_pa_request_rec_out ghr_pa_requests%rowtype;
264: l_cnt_sigs NUMBER;
265: l_signature_rec t_signature_rec;
266: l_rem_ctr NUMBER;
267:

Line 662: PROCEDURE Populate_RPAtags(p_pa_request_rec IN ghr_pa_requests%ROWTYPE,

658:
659:
660: END Generate_RPA;
661:
662: PROCEDURE Populate_RPAtags(p_pa_request_rec IN ghr_pa_requests%ROWTYPE,
663: p_rpa_misc_fields t_rpa_misc_fields_rec,
664: p_signature_rec t_signature_rec,
665: p_conti_remarks_concat varchar2,
666: p_displayCRemarks varchar2) IS

Line 1312: PROCEDURE CondPrinting_RPA(p_pa_request_rec_in IN ghr_pa_requests%rowtype,

1308:
1309: p_xml_string:= l_xml_string; -- Fix For Bug # 11780976
1310: END;
1311:
1312: PROCEDURE CondPrinting_RPA(p_pa_request_rec_in IN ghr_pa_requests%rowtype,
1313: p_pa_request_rec_out OUT NOCOPY ghr_pa_requests%rowtype)
1314: IS
1315: l_tmp_auo_amount VARCHAR2(30);
1316: l_tmp_availability VARCHAR2(30);

Line 1313: p_pa_request_rec_out OUT NOCOPY ghr_pa_requests%rowtype)

1309: p_xml_string:= l_xml_string; -- Fix For Bug # 11780976
1310: END;
1311:
1312: PROCEDURE CondPrinting_RPA(p_pa_request_rec_in IN ghr_pa_requests%rowtype,
1313: p_pa_request_rec_out OUT NOCOPY ghr_pa_requests%rowtype)
1314: IS
1315: l_tmp_auo_amount VARCHAR2(30);
1316: l_tmp_availability VARCHAR2(30);
1317: l_auo_amount ghr_pa_requests.to_au_overtime%TYPE;

Line 1317: l_auo_amount ghr_pa_requests.to_au_overtime%TYPE;

1313: p_pa_request_rec_out OUT NOCOPY ghr_pa_requests%rowtype)
1314: IS
1315: l_tmp_auo_amount VARCHAR2(30);
1316: l_tmp_availability VARCHAR2(30);
1317: l_auo_amount ghr_pa_requests.to_au_overtime%TYPE;
1318: l_availability_amt ghr_pa_requests.to_availability_pay%TYPE;
1319: l_multi_error BOOLEAN;
1320: l_auo_premium_pay_indicator ghr_pa_requests.to_auo_premium_pay_indicator%TYPE;
1321: l_ppi_percentage ghr_premium_pay_indicators.ppi_percentage%TYPE;

Line 1318: l_availability_amt ghr_pa_requests.to_availability_pay%TYPE;

1314: IS
1315: l_tmp_auo_amount VARCHAR2(30);
1316: l_tmp_availability VARCHAR2(30);
1317: l_auo_amount ghr_pa_requests.to_au_overtime%TYPE;
1318: l_availability_amt ghr_pa_requests.to_availability_pay%TYPE;
1319: l_multi_error BOOLEAN;
1320: l_auo_premium_pay_indicator ghr_pa_requests.to_auo_premium_pay_indicator%TYPE;
1321: l_ppi_percentage ghr_premium_pay_indicators.ppi_percentage%TYPE;
1322: l_mddds_special_pay_amount ghr_pa_requests.to_total_salary%TYPE;

Line 1320: l_auo_premium_pay_indicator ghr_pa_requests.to_auo_premium_pay_indicator%TYPE;

1316: l_tmp_availability VARCHAR2(30);
1317: l_auo_amount ghr_pa_requests.to_au_overtime%TYPE;
1318: l_availability_amt ghr_pa_requests.to_availability_pay%TYPE;
1319: l_multi_error BOOLEAN;
1320: l_auo_premium_pay_indicator ghr_pa_requests.to_auo_premium_pay_indicator%TYPE;
1321: l_ppi_percentage ghr_premium_pay_indicators.ppi_percentage%TYPE;
1322: l_mddds_special_pay_amount ghr_pa_requests.to_total_salary%TYPE;
1323: l_to_avail_pay ghr_pa_requests.to_availability_pay%TYPE;
1324: l_to_au_overtime ghr_pa_requests.to_au_overtime%TYPE;

Line 1322: l_mddds_special_pay_amount ghr_pa_requests.to_total_salary%TYPE;

1318: l_availability_amt ghr_pa_requests.to_availability_pay%TYPE;
1319: l_multi_error BOOLEAN;
1320: l_auo_premium_pay_indicator ghr_pa_requests.to_auo_premium_pay_indicator%TYPE;
1321: l_ppi_percentage ghr_premium_pay_indicators.ppi_percentage%TYPE;
1322: l_mddds_special_pay_amount ghr_pa_requests.to_total_salary%TYPE;
1323: l_to_avail_pay ghr_pa_requests.to_availability_pay%TYPE;
1324: l_to_au_overtime ghr_pa_requests.to_au_overtime%TYPE;
1325: l_to_organization_id per_assignments_f.organization_id%TYPE;
1326:

Line 1323: l_to_avail_pay ghr_pa_requests.to_availability_pay%TYPE;

1319: l_multi_error BOOLEAN;
1320: l_auo_premium_pay_indicator ghr_pa_requests.to_auo_premium_pay_indicator%TYPE;
1321: l_ppi_percentage ghr_premium_pay_indicators.ppi_percentage%TYPE;
1322: l_mddds_special_pay_amount ghr_pa_requests.to_total_salary%TYPE;
1323: l_to_avail_pay ghr_pa_requests.to_availability_pay%TYPE;
1324: l_to_au_overtime ghr_pa_requests.to_au_overtime%TYPE;
1325: l_to_organization_id per_assignments_f.organization_id%TYPE;
1326:
1327: CURSOR c_percentage_ppi(p_ppi_code ghr_premium_pay_indicators.code%TYPE) IS

Line 1324: l_to_au_overtime ghr_pa_requests.to_au_overtime%TYPE;

1320: l_auo_premium_pay_indicator ghr_pa_requests.to_auo_premium_pay_indicator%TYPE;
1321: l_ppi_percentage ghr_premium_pay_indicators.ppi_percentage%TYPE;
1322: l_mddds_special_pay_amount ghr_pa_requests.to_total_salary%TYPE;
1323: l_to_avail_pay ghr_pa_requests.to_availability_pay%TYPE;
1324: l_to_au_overtime ghr_pa_requests.to_au_overtime%TYPE;
1325: l_to_organization_id per_assignments_f.organization_id%TYPE;
1326:
1327: CURSOR c_percentage_ppi(p_ppi_code ghr_premium_pay_indicators.code%TYPE) IS
1328: SELECT ppi.ppi_percentage

Line 1332: CURSOR get_mddds_amount(p_pa_request_id ghr_pa_requests.pa_request_id%type) IS

1328: SELECT ppi.ppi_percentage
1329: FROM ghr_premium_pay_indicators ppi
1330: WHERE code = p_ppi_code;
1331:
1332: CURSOR get_mddds_amount(p_pa_request_id ghr_pa_requests.pa_request_id%type) IS
1333: SELECT rei_information11 amount
1334: FROM ghr_pa_request_extra_info
1335: WHERE pa_request_id = p_pa_request_id
1336: AND information_type='GHR_US_PAR_MD_DDS_PAY';

Line 1607: ghr_pa_requests_pkg.get_rei_org_lines(

1603: p_pa_request_rec_out.to_total_salary := NVL(l_mddds_special_pay_amount,0);
1604: END IF;
1605:
1606: IF p_pa_request_rec_in.first_noa_code='002' AND p_pa_request_rec_in.second_noa_code='790' THEN
1607: ghr_pa_requests_pkg.get_rei_org_lines(
1608: p_pa_request_id => p_pa_request_rec_in.pa_request_id,
1609: p_organization_id => l_to_organization_id,
1610: p_position_org_line1 => p_pa_request_rec_out.to_position_org_line1,
1611: p_position_org_line2 => p_pa_request_rec_out.to_position_org_line2,

Line 1624: PROCEDURE Generate_NPA(p_pa_request_id ghr_pa_requests.pa_request_id%type, p_view_type VARCHAR2, p_xml_string OUT NOCOPY CLOB) IS

1620:
1621: /**************************** NPA Start ******************************************/
1622:
1623:
1624: PROCEDURE Generate_NPA(p_pa_request_id ghr_pa_requests.pa_request_id%type, p_view_type VARCHAR2, p_xml_string OUT NOCOPY CLOB) IS
1625:
1626: CURSOR cur_NPA(c_pa_request_id ghr_pa_requests.pa_request_id%type) IS
1627: SELECT
1628: PERSON_ID,

Line 1626: CURSOR cur_NPA(c_pa_request_id ghr_pa_requests.pa_request_id%type) IS

1622:
1623:
1624: PROCEDURE Generate_NPA(p_pa_request_id ghr_pa_requests.pa_request_id%type, p_view_type VARCHAR2, p_xml_string OUT NOCOPY CLOB) IS
1625:
1626: CURSOR cur_NPA(c_pa_request_id ghr_pa_requests.pa_request_id%type) IS
1627: SELECT
1628: PERSON_ID,
1629: EMPLOYEE_LAST_NAME ,
1630: EMPLOYEE_FIRST_NAME ,

Line 1729: FROM GHR_PA_REQUESTS PAR

1725: ,PA_REQUEST_ID
1726: ,PA_NOTIFICATION_ID
1727: ,SECOND_NOA_ID
1728: ,ALTERED_PA_REQUEST_ID
1729: FROM GHR_PA_REQUESTS PAR
1730: WHERE PA_REQUEST_ID = c_pa_request_id;
1731:
1732:
1733: CURSOR c_remarks(c_pa_request_id GHR_PA_REMARKS.pa_request_id%type) IS

Line 1744: CURSOR c_agency_use(c_pa_request_id ghr_pa_requests.pa_request_id%type) IS

1740: ghr_remarks remk
1741: WHERE remk.remark_id = pre.remark_id
1742: AND pre.pa_request_id = c_pa_request_id;
1743:
1744: CURSOR c_agency_use(c_pa_request_id ghr_pa_requests.pa_request_id%type) IS
1745: SELECT rei_information3
1746: ,rei_information4
1747: ,rei_information5
1748: ,rei_information6

Line 1755: l_pa_request_rec ghr_pa_requests%rowtype;

1751: FROM ghr_pa_request_extra_info
1752: WHERE information_type = 'GHR_US_PAR_GEN_AGENCY_DATA'
1753: AND pa_request_id = c_pa_request_id;
1754:
1755: l_pa_request_rec ghr_pa_requests%rowtype;
1756: l_pa_request_rec_out ghr_pa_requests%rowtype;
1757: l_cnt_sigs NUMBER;
1758: l_signature_rec t_signature_rec;
1759: l_rem_ctr NUMBER;

Line 1756: l_pa_request_rec_out ghr_pa_requests%rowtype;

1752: WHERE information_type = 'GHR_US_PAR_GEN_AGENCY_DATA'
1753: AND pa_request_id = c_pa_request_id;
1754:
1755: l_pa_request_rec ghr_pa_requests%rowtype;
1756: l_pa_request_rec_out ghr_pa_requests%rowtype;
1757: l_cnt_sigs NUMBER;
1758: l_signature_rec t_signature_rec;
1759: l_rem_ctr NUMBER;
1760:

Line 2054: PROCEDURE CondPrinting_NPA(p_pa_request_rec_in IN ghr_pa_requests%rowtype,

2050: END Generate_NPA;
2051:
2052:
2053:
2054: PROCEDURE CondPrinting_NPA(p_pa_request_rec_in IN ghr_pa_requests%rowtype,
2055: p_pa_request_rec_out OUT NOCOPY ghr_pa_requests%rowtype)
2056: IS
2057: l_tmp_auo_amount VARCHAR2(30);
2058: l_tmp_availability VARCHAR2(30);

Line 2055: p_pa_request_rec_out OUT NOCOPY ghr_pa_requests%rowtype)

2051:
2052:
2053:
2054: PROCEDURE CondPrinting_NPA(p_pa_request_rec_in IN ghr_pa_requests%rowtype,
2055: p_pa_request_rec_out OUT NOCOPY ghr_pa_requests%rowtype)
2056: IS
2057: l_tmp_auo_amount VARCHAR2(30);
2058: l_tmp_availability VARCHAR2(30);
2059: l_auo_amount ghr_pa_requests.to_au_overtime%TYPE;

Line 2059: l_auo_amount ghr_pa_requests.to_au_overtime%TYPE;

2055: p_pa_request_rec_out OUT NOCOPY ghr_pa_requests%rowtype)
2056: IS
2057: l_tmp_auo_amount VARCHAR2(30);
2058: l_tmp_availability VARCHAR2(30);
2059: l_auo_amount ghr_pa_requests.to_au_overtime%TYPE;
2060: l_availability_amt ghr_pa_requests.to_availability_pay%TYPE;
2061: l_multi_error BOOLEAN;
2062: l_auo_premium_pay_indicator ghr_pa_requests.to_auo_premium_pay_indicator%TYPE;
2063: l_ppi_percentage ghr_premium_pay_indicators.ppi_percentage%TYPE;

Line 2060: l_availability_amt ghr_pa_requests.to_availability_pay%TYPE;

2056: IS
2057: l_tmp_auo_amount VARCHAR2(30);
2058: l_tmp_availability VARCHAR2(30);
2059: l_auo_amount ghr_pa_requests.to_au_overtime%TYPE;
2060: l_availability_amt ghr_pa_requests.to_availability_pay%TYPE;
2061: l_multi_error BOOLEAN;
2062: l_auo_premium_pay_indicator ghr_pa_requests.to_auo_premium_pay_indicator%TYPE;
2063: l_ppi_percentage ghr_premium_pay_indicators.ppi_percentage%TYPE;
2064: l_mddds_special_pay_amount ghr_pa_requests.to_total_salary%TYPE;

Line 2062: l_auo_premium_pay_indicator ghr_pa_requests.to_auo_premium_pay_indicator%TYPE;

2058: l_tmp_availability VARCHAR2(30);
2059: l_auo_amount ghr_pa_requests.to_au_overtime%TYPE;
2060: l_availability_amt ghr_pa_requests.to_availability_pay%TYPE;
2061: l_multi_error BOOLEAN;
2062: l_auo_premium_pay_indicator ghr_pa_requests.to_auo_premium_pay_indicator%TYPE;
2063: l_ppi_percentage ghr_premium_pay_indicators.ppi_percentage%TYPE;
2064: l_mddds_special_pay_amount ghr_pa_requests.to_total_salary%TYPE;
2065: l_to_avail_pay ghr_pa_requests.to_availability_pay%TYPE;
2066: l_to_au_overtime ghr_pa_requests.to_au_overtime%TYPE;

Line 2064: l_mddds_special_pay_amount ghr_pa_requests.to_total_salary%TYPE;

2060: l_availability_amt ghr_pa_requests.to_availability_pay%TYPE;
2061: l_multi_error BOOLEAN;
2062: l_auo_premium_pay_indicator ghr_pa_requests.to_auo_premium_pay_indicator%TYPE;
2063: l_ppi_percentage ghr_premium_pay_indicators.ppi_percentage%TYPE;
2064: l_mddds_special_pay_amount ghr_pa_requests.to_total_salary%TYPE;
2065: l_to_avail_pay ghr_pa_requests.to_availability_pay%TYPE;
2066: l_to_au_overtime ghr_pa_requests.to_au_overtime%TYPE;
2067: l_to_organization_id per_assignments_f.organization_id%TYPE;
2068: l_pos_ei_data per_position_extra_info%rowtype;

Line 2065: l_to_avail_pay ghr_pa_requests.to_availability_pay%TYPE;

2061: l_multi_error BOOLEAN;
2062: l_auo_premium_pay_indicator ghr_pa_requests.to_auo_premium_pay_indicator%TYPE;
2063: l_ppi_percentage ghr_premium_pay_indicators.ppi_percentage%TYPE;
2064: l_mddds_special_pay_amount ghr_pa_requests.to_total_salary%TYPE;
2065: l_to_avail_pay ghr_pa_requests.to_availability_pay%TYPE;
2066: l_to_au_overtime ghr_pa_requests.to_au_overtime%TYPE;
2067: l_to_organization_id per_assignments_f.organization_id%TYPE;
2068: l_pos_ei_data per_position_extra_info%rowtype;
2069: l_poi VARCHAR2(30);

Line 2066: l_to_au_overtime ghr_pa_requests.to_au_overtime%TYPE;

2062: l_auo_premium_pay_indicator ghr_pa_requests.to_auo_premium_pay_indicator%TYPE;
2063: l_ppi_percentage ghr_premium_pay_indicators.ppi_percentage%TYPE;
2064: l_mddds_special_pay_amount ghr_pa_requests.to_total_salary%TYPE;
2065: l_to_avail_pay ghr_pa_requests.to_availability_pay%TYPE;
2066: l_to_au_overtime ghr_pa_requests.to_au_overtime%TYPE;
2067: l_to_organization_id per_assignments_f.organization_id%TYPE;
2068: l_pos_ei_data per_position_extra_info%rowtype;
2069: l_poi VARCHAR2(30);
2070:

Line 2076: CURSOR get_mddds_amount(p_pa_request_id ghr_pa_requests.pa_request_id%type) IS

2072: SELECT ppi.ppi_percentage
2073: FROM ghr_premium_pay_indicators ppi
2074: WHERE code = p_ppi_code;
2075:
2076: CURSOR get_mddds_amount(p_pa_request_id ghr_pa_requests.pa_request_id%type) IS
2077: SELECT rei_information11 amount
2078: FROM ghr_pa_request_extra_info
2079: WHERE pa_request_id = p_pa_request_id
2080: AND information_type='GHR_US_PAR_MD_DDS_PAY';

Line 2360: ghr_pa_requests_pkg.get_rei_org_lines(

2356: p_pa_request_rec_out.to_total_salary := NVL(l_mddds_special_pay_amount,0);
2357: END IF;
2358:
2359: IF p_pa_request_rec_in.first_noa_code='002' AND p_pa_request_rec_in.second_noa_code='790' THEN
2360: ghr_pa_requests_pkg.get_rei_org_lines(
2361: p_pa_request_id => p_pa_request_rec_in.pa_request_id,
2362: p_organization_id => l_to_organization_id,
2363: p_position_org_line1 => p_pa_request_rec_out.to_position_org_line1,
2364: p_position_org_line2 => p_pa_request_rec_out.to_position_org_line2,

Line 2388: PROCEDURE Populate_NPAtags(p_pa_request_rec IN ghr_pa_requests%ROWTYPE,

2384: END IF;
2385: END CondPrinting_NPA;
2386:
2387:
2388: PROCEDURE Populate_NPAtags(p_pa_request_rec IN ghr_pa_requests%ROWTYPE,
2389: p_npa_misc_fields t_npa_misc_fields_rec) IS
2390: l_ctr NUMBER;
2391: BEGIN
2392: l_ctr := 1;