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.

[Home] [Help]

APPS.GHR_GEN_RPA_NPA dependencies on GHR_PA_REQUESTS

Line 14: 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

10:
11: l_remarks t_remarks_rec;
12: l_new_line_sep VARCHAR2(10);
13:
14: 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
15: CURSOR cur_RPA(c_pa_request_id ghr_pa_requests.pa_request_id%type) IS
16: SELECT
17: FAM.NAME ACTION_REQUESTED
18: ,PA_REQUEST_ID

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

11: l_remarks t_remarks_rec;
12: l_new_line_sep VARCHAR2(10);
13:
14: 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
15: CURSOR cur_RPA(c_pa_request_id ghr_pa_requests.pa_request_id%type) IS
16: SELECT
17: FAM.NAME ACTION_REQUESTED
18: ,PA_REQUEST_ID
19: ,REQUEST_NUMBER

Line 33: ,GHR_PA_REQUESTS.NOA_FAMILY_CODE

29: ,EMPLOYEE_NATIONAL_IDENTIFIER SS_NUMBER
30: ,EMPLOYEE_DATE_OF_BIRTH
31: ,NVL(GHR_UPD_HR_VALIDATION.GET_EXEMP_AWARD_DATE(PA_REQUEST_ID),EFFECTIVE_DATE) EFFECTIVE_DATE
32: ,DECODE(LENGTH(NVL(FIRST_NOA_CODE, '')), 4, SUBSTR(FIRST_NOA_CODE, 2, 3), FIRST_NOA_CODE) FIRST_NOA_CODE
33: ,GHR_PA_REQUESTS.NOA_FAMILY_CODE
34: ,FIRST_NOA_DESC
35: ,FIRST_ACTION_LA_CODE1
36: ,FIRST_ACTION_LA_CODE2
37: ,FIRST_ACTION_LA_DESC1

Line 133: FROM GHR_PA_REQUESTS, GHR_FAMILIES FAM

129: ,APPROVING_OFFICIAL_WORK_TITLE
130: ,APPROVAL_DATE
131: ,NOTEPAD
132: ,ALTERED_PA_REQUEST_ID
133: FROM GHR_PA_REQUESTS, GHR_FAMILIES FAM
134: WHERE
135: PA_REQUEST_ID = c_pa_request_id
136: AND GHR_PA_REQUESTS.NOA_FAMILY_CODE = FAM.NOA_FAMILY_CODE;
137:

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

132: ,ALTERED_PA_REQUEST_ID
133: FROM GHR_PA_REQUESTS, GHR_FAMILIES FAM
134: WHERE
135: PA_REQUEST_ID = c_pa_request_id
136: AND GHR_PA_REQUESTS.NOA_FAMILY_CODE = FAM.NOA_FAMILY_CODE;
137:
138: CURSOR c_remarks(c_pa_request_id GHR_PA_REMARKS.pa_request_id%type) IS
139: SELECT
140: pre.description,

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

151: from per_all_people_f per1
152: where per1.person_id = p_person_id
153: and NVL(p_effective_date,TRUNC(sysdate)) between per1.effective_start_date and per1.effective_end_date;
154:
155: CURSOR c_agency_use(c_pa_request_id ghr_pa_requests.pa_request_id%type) IS
156: SELECT rei_information3
157: ,rei_information4
158: ,rei_information5
159: ,rei_information6

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

184: AND ASG.position_id = PG1.position_id (+)
185: AND PG1.information_type (+) = 'GHR_US_POS_GRP1';
186:
187:
188: CURSOR C_SIGNATURES (p_pa_request_id ghr_pa_requests.pa_request_id%type, p_effective_date DATE) IS
189: SELECT PG1.POEI_INFORMATION4 Office_Symbol,
190: PER.LAST_NAME || ', ' || PER.FIRST_NAME || ' ' || PER.MIDDLE_NAMES FULL_NAME,
191: TO_CHAR(PRH.LAST_UPDATE_DATE, 'MM-DD-YYYY') LAST_UPDATE_DATE
192: FROM GHR_PA_ROUTING_HISTORY PRH,

Line 212: l_pa_request_rec ghr_pa_requests%rowtype;

208: AND ASG.position_id = PG1.position_id (+)
209: AND PG1.information_type (+) = 'GHR_US_POS_GRP1'
210: ORDER BY PRH.LAST_UPDATE_DATE DESC;
211:
212: l_pa_request_rec ghr_pa_requests%rowtype;
213: l_pa_request_rec_out ghr_pa_requests%rowtype;
214: l_cnt_sigs NUMBER;
215: l_signature_rec t_signature_rec;
216: l_rem_ctr NUMBER;

Line 213: l_pa_request_rec_out ghr_pa_requests%rowtype;

209: AND PG1.information_type (+) = 'GHR_US_POS_GRP1'
210: ORDER BY PRH.LAST_UPDATE_DATE DESC;
211:
212: l_pa_request_rec ghr_pa_requests%rowtype;
213: l_pa_request_rec_out ghr_pa_requests%rowtype;
214: l_cnt_sigs NUMBER;
215: l_signature_rec t_signature_rec;
216: l_rem_ctr NUMBER;
217: BEGIN

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

489:
490:
491: END Generate_RPA;
492:
493: PROCEDURE Populate_RPAtags(p_pa_request_rec IN ghr_pa_requests%ROWTYPE,
494: p_rpa_misc_fields t_rpa_misc_fields_rec,
495: p_signature_rec t_signature_rec) IS
496: l_ctr NUMBER;
497: BEGIN

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

1081: l_xml_string := l_new_line_sep || '';
1082: DBMS_LOB.WRITEAPPEND(p_xml_string, length(l_xml_string), l_xml_string);
1083: END;
1084:
1085: PROCEDURE CondPrinting_RPA(p_pa_request_rec_in IN ghr_pa_requests%rowtype,
1086: p_pa_request_rec_out OUT NOCOPY ghr_pa_requests%rowtype)
1087: IS
1088: l_tmp_auo_amount VARCHAR2(30);
1089: l_tmp_availability VARCHAR2(30);

Line 1086: p_pa_request_rec_out OUT NOCOPY ghr_pa_requests%rowtype)

1082: DBMS_LOB.WRITEAPPEND(p_xml_string, length(l_xml_string), l_xml_string);
1083: END;
1084:
1085: PROCEDURE CondPrinting_RPA(p_pa_request_rec_in IN ghr_pa_requests%rowtype,
1086: p_pa_request_rec_out OUT NOCOPY ghr_pa_requests%rowtype)
1087: IS
1088: l_tmp_auo_amount VARCHAR2(30);
1089: l_tmp_availability VARCHAR2(30);
1090: l_auo_amount ghr_pa_requests.to_au_overtime%TYPE;

Line 1090: l_auo_amount ghr_pa_requests.to_au_overtime%TYPE;

1086: p_pa_request_rec_out OUT NOCOPY ghr_pa_requests%rowtype)
1087: IS
1088: l_tmp_auo_amount VARCHAR2(30);
1089: l_tmp_availability VARCHAR2(30);
1090: l_auo_amount ghr_pa_requests.to_au_overtime%TYPE;
1091: l_availability_amt ghr_pa_requests.to_availability_pay%TYPE;
1092: l_multi_error BOOLEAN;
1093: l_auo_premium_pay_indicator ghr_pa_requests.to_auo_premium_pay_indicator%TYPE;
1094: l_ppi_percentage ghr_premium_pay_indicators.ppi_percentage%TYPE;

Line 1091: l_availability_amt ghr_pa_requests.to_availability_pay%TYPE;

1087: IS
1088: l_tmp_auo_amount VARCHAR2(30);
1089: l_tmp_availability VARCHAR2(30);
1090: l_auo_amount ghr_pa_requests.to_au_overtime%TYPE;
1091: l_availability_amt ghr_pa_requests.to_availability_pay%TYPE;
1092: l_multi_error BOOLEAN;
1093: l_auo_premium_pay_indicator ghr_pa_requests.to_auo_premium_pay_indicator%TYPE;
1094: l_ppi_percentage ghr_premium_pay_indicators.ppi_percentage%TYPE;
1095: l_mddds_special_pay_amount ghr_pa_requests.to_total_salary%TYPE;

Line 1093: l_auo_premium_pay_indicator ghr_pa_requests.to_auo_premium_pay_indicator%TYPE;

1089: l_tmp_availability VARCHAR2(30);
1090: l_auo_amount ghr_pa_requests.to_au_overtime%TYPE;
1091: l_availability_amt ghr_pa_requests.to_availability_pay%TYPE;
1092: l_multi_error BOOLEAN;
1093: l_auo_premium_pay_indicator ghr_pa_requests.to_auo_premium_pay_indicator%TYPE;
1094: l_ppi_percentage ghr_premium_pay_indicators.ppi_percentage%TYPE;
1095: l_mddds_special_pay_amount ghr_pa_requests.to_total_salary%TYPE;
1096: l_to_avail_pay ghr_pa_requests.to_availability_pay%TYPE;
1097: l_to_au_overtime ghr_pa_requests.to_au_overtime%TYPE;

Line 1095: l_mddds_special_pay_amount ghr_pa_requests.to_total_salary%TYPE;

1091: l_availability_amt ghr_pa_requests.to_availability_pay%TYPE;
1092: l_multi_error BOOLEAN;
1093: l_auo_premium_pay_indicator ghr_pa_requests.to_auo_premium_pay_indicator%TYPE;
1094: l_ppi_percentage ghr_premium_pay_indicators.ppi_percentage%TYPE;
1095: l_mddds_special_pay_amount ghr_pa_requests.to_total_salary%TYPE;
1096: l_to_avail_pay ghr_pa_requests.to_availability_pay%TYPE;
1097: l_to_au_overtime ghr_pa_requests.to_au_overtime%TYPE;
1098: l_to_organization_id per_assignments_f.organization_id%TYPE;
1099:

Line 1096: l_to_avail_pay ghr_pa_requests.to_availability_pay%TYPE;

1092: l_multi_error BOOLEAN;
1093: l_auo_premium_pay_indicator ghr_pa_requests.to_auo_premium_pay_indicator%TYPE;
1094: l_ppi_percentage ghr_premium_pay_indicators.ppi_percentage%TYPE;
1095: l_mddds_special_pay_amount ghr_pa_requests.to_total_salary%TYPE;
1096: l_to_avail_pay ghr_pa_requests.to_availability_pay%TYPE;
1097: l_to_au_overtime ghr_pa_requests.to_au_overtime%TYPE;
1098: l_to_organization_id per_assignments_f.organization_id%TYPE;
1099:
1100: CURSOR c_percentage_ppi(p_ppi_code ghr_premium_pay_indicators.code%TYPE) IS

Line 1097: l_to_au_overtime ghr_pa_requests.to_au_overtime%TYPE;

1093: l_auo_premium_pay_indicator ghr_pa_requests.to_auo_premium_pay_indicator%TYPE;
1094: l_ppi_percentage ghr_premium_pay_indicators.ppi_percentage%TYPE;
1095: l_mddds_special_pay_amount ghr_pa_requests.to_total_salary%TYPE;
1096: l_to_avail_pay ghr_pa_requests.to_availability_pay%TYPE;
1097: l_to_au_overtime ghr_pa_requests.to_au_overtime%TYPE;
1098: l_to_organization_id per_assignments_f.organization_id%TYPE;
1099:
1100: CURSOR c_percentage_ppi(p_ppi_code ghr_premium_pay_indicators.code%TYPE) IS
1101: SELECT ppi.ppi_percentage

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

1101: SELECT ppi.ppi_percentage
1102: FROM ghr_premium_pay_indicators ppi
1103: WHERE code = p_ppi_code;
1104:
1105: CURSOR get_mddds_amount(p_pa_request_id ghr_pa_requests.pa_request_id%type) IS
1106: SELECT rei_information11 amount
1107: FROM ghr_pa_request_extra_info
1108: WHERE pa_request_id = p_pa_request_id
1109: AND information_type='GHR_US_PAR_MD_DDS_PAY';

Line 1376: ghr_pa_requests_pkg.get_rei_org_lines(

1372: p_pa_request_rec_out.to_total_salary := NVL(l_mddds_special_pay_amount,0);
1373: END IF;
1374:
1375: IF p_pa_request_rec_in.first_noa_code='002' AND p_pa_request_rec_in.second_noa_code='790' THEN
1376: ghr_pa_requests_pkg.get_rei_org_lines(
1377: p_pa_request_id => p_pa_request_rec_in.pa_request_id,
1378: p_organization_id => l_to_organization_id,
1379: p_position_org_line1 => p_pa_request_rec_out.to_position_org_line1,
1380: p_position_org_line2 => p_pa_request_rec_out.to_position_org_line2,

Line 1393: 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

1389:
1390: /**************************** NPA Start ******************************************/
1391:
1392:
1393: 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
1394:
1395: CURSOR cur_NPA(c_pa_request_id ghr_pa_requests.pa_request_id%type) IS
1396: SELECT
1397: PERSON_ID,

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

1391:
1392:
1393: 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
1394:
1395: CURSOR cur_NPA(c_pa_request_id ghr_pa_requests.pa_request_id%type) IS
1396: SELECT
1397: PERSON_ID,
1398: EMPLOYEE_LAST_NAME ,
1399: EMPLOYEE_FIRST_NAME ,

Line 1496: FROM GHR_PA_REQUESTS PAR

1492: ,PA_REQUEST_ID
1493: ,PA_NOTIFICATION_ID
1494: ,SECOND_NOA_ID
1495: ,ALTERED_PA_REQUEST_ID
1496: FROM GHR_PA_REQUESTS PAR
1497: WHERE PA_REQUEST_ID = c_pa_request_id;
1498:
1499:
1500: CURSOR c_remarks(c_pa_request_id GHR_PA_REMARKS.pa_request_id%type) IS

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

1507: ghr_remarks remk
1508: WHERE remk.remark_id = pre.remark_id
1509: AND pre.pa_request_id = c_pa_request_id;
1510:
1511: CURSOR c_agency_use(c_pa_request_id ghr_pa_requests.pa_request_id%type) IS
1512: SELECT rei_information3
1513: ,rei_information4
1514: ,rei_information5
1515: ,rei_information6

Line 1522: l_pa_request_rec ghr_pa_requests%rowtype;

1518: FROM ghr_pa_request_extra_info
1519: WHERE information_type = 'GHR_US_PAR_GEN_AGENCY_DATA'
1520: AND pa_request_id = c_pa_request_id;
1521:
1522: l_pa_request_rec ghr_pa_requests%rowtype;
1523: l_pa_request_rec_out ghr_pa_requests%rowtype;
1524: l_cnt_sigs NUMBER;
1525: l_signature_rec t_signature_rec;
1526: l_rem_ctr NUMBER;

Line 1523: l_pa_request_rec_out ghr_pa_requests%rowtype;

1519: WHERE information_type = 'GHR_US_PAR_GEN_AGENCY_DATA'
1520: AND pa_request_id = c_pa_request_id;
1521:
1522: l_pa_request_rec ghr_pa_requests%rowtype;
1523: l_pa_request_rec_out ghr_pa_requests%rowtype;
1524: l_cnt_sigs NUMBER;
1525: l_signature_rec t_signature_rec;
1526: l_rem_ctr NUMBER;
1527: BEGIN

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

1734: END Generate_NPA;
1735:
1736:
1737:
1738: PROCEDURE CondPrinting_NPA(p_pa_request_rec_in IN ghr_pa_requests%rowtype,
1739: p_pa_request_rec_out OUT NOCOPY ghr_pa_requests%rowtype)
1740: IS
1741: l_tmp_auo_amount VARCHAR2(30);
1742: l_tmp_availability VARCHAR2(30);

Line 1739: p_pa_request_rec_out OUT NOCOPY ghr_pa_requests%rowtype)

1735:
1736:
1737:
1738: PROCEDURE CondPrinting_NPA(p_pa_request_rec_in IN ghr_pa_requests%rowtype,
1739: p_pa_request_rec_out OUT NOCOPY ghr_pa_requests%rowtype)
1740: IS
1741: l_tmp_auo_amount VARCHAR2(30);
1742: l_tmp_availability VARCHAR2(30);
1743: l_auo_amount ghr_pa_requests.to_au_overtime%TYPE;

Line 1743: l_auo_amount ghr_pa_requests.to_au_overtime%TYPE;

1739: p_pa_request_rec_out OUT NOCOPY ghr_pa_requests%rowtype)
1740: IS
1741: l_tmp_auo_amount VARCHAR2(30);
1742: l_tmp_availability VARCHAR2(30);
1743: l_auo_amount ghr_pa_requests.to_au_overtime%TYPE;
1744: l_availability_amt ghr_pa_requests.to_availability_pay%TYPE;
1745: l_multi_error BOOLEAN;
1746: l_auo_premium_pay_indicator ghr_pa_requests.to_auo_premium_pay_indicator%TYPE;
1747: l_ppi_percentage ghr_premium_pay_indicators.ppi_percentage%TYPE;

Line 1744: l_availability_amt ghr_pa_requests.to_availability_pay%TYPE;

1740: IS
1741: l_tmp_auo_amount VARCHAR2(30);
1742: l_tmp_availability VARCHAR2(30);
1743: l_auo_amount ghr_pa_requests.to_au_overtime%TYPE;
1744: l_availability_amt ghr_pa_requests.to_availability_pay%TYPE;
1745: l_multi_error BOOLEAN;
1746: l_auo_premium_pay_indicator ghr_pa_requests.to_auo_premium_pay_indicator%TYPE;
1747: l_ppi_percentage ghr_premium_pay_indicators.ppi_percentage%TYPE;
1748: l_mddds_special_pay_amount ghr_pa_requests.to_total_salary%TYPE;

Line 1746: l_auo_premium_pay_indicator ghr_pa_requests.to_auo_premium_pay_indicator%TYPE;

1742: l_tmp_availability VARCHAR2(30);
1743: l_auo_amount ghr_pa_requests.to_au_overtime%TYPE;
1744: l_availability_amt ghr_pa_requests.to_availability_pay%TYPE;
1745: l_multi_error BOOLEAN;
1746: l_auo_premium_pay_indicator ghr_pa_requests.to_auo_premium_pay_indicator%TYPE;
1747: l_ppi_percentage ghr_premium_pay_indicators.ppi_percentage%TYPE;
1748: l_mddds_special_pay_amount ghr_pa_requests.to_total_salary%TYPE;
1749: l_to_avail_pay ghr_pa_requests.to_availability_pay%TYPE;
1750: l_to_au_overtime ghr_pa_requests.to_au_overtime%TYPE;

Line 1748: l_mddds_special_pay_amount ghr_pa_requests.to_total_salary%TYPE;

1744: l_availability_amt ghr_pa_requests.to_availability_pay%TYPE;
1745: l_multi_error BOOLEAN;
1746: l_auo_premium_pay_indicator ghr_pa_requests.to_auo_premium_pay_indicator%TYPE;
1747: l_ppi_percentage ghr_premium_pay_indicators.ppi_percentage%TYPE;
1748: l_mddds_special_pay_amount ghr_pa_requests.to_total_salary%TYPE;
1749: l_to_avail_pay ghr_pa_requests.to_availability_pay%TYPE;
1750: l_to_au_overtime ghr_pa_requests.to_au_overtime%TYPE;
1751: l_to_organization_id per_assignments_f.organization_id%TYPE;
1752: l_pos_ei_data per_position_extra_info%rowtype;

Line 1749: l_to_avail_pay ghr_pa_requests.to_availability_pay%TYPE;

1745: l_multi_error BOOLEAN;
1746: l_auo_premium_pay_indicator ghr_pa_requests.to_auo_premium_pay_indicator%TYPE;
1747: l_ppi_percentage ghr_premium_pay_indicators.ppi_percentage%TYPE;
1748: l_mddds_special_pay_amount ghr_pa_requests.to_total_salary%TYPE;
1749: l_to_avail_pay ghr_pa_requests.to_availability_pay%TYPE;
1750: l_to_au_overtime ghr_pa_requests.to_au_overtime%TYPE;
1751: l_to_organization_id per_assignments_f.organization_id%TYPE;
1752: l_pos_ei_data per_position_extra_info%rowtype;
1753: l_poi VARCHAR2(30);

Line 1750: l_to_au_overtime ghr_pa_requests.to_au_overtime%TYPE;

1746: l_auo_premium_pay_indicator ghr_pa_requests.to_auo_premium_pay_indicator%TYPE;
1747: l_ppi_percentage ghr_premium_pay_indicators.ppi_percentage%TYPE;
1748: l_mddds_special_pay_amount ghr_pa_requests.to_total_salary%TYPE;
1749: l_to_avail_pay ghr_pa_requests.to_availability_pay%TYPE;
1750: l_to_au_overtime ghr_pa_requests.to_au_overtime%TYPE;
1751: l_to_organization_id per_assignments_f.organization_id%TYPE;
1752: l_pos_ei_data per_position_extra_info%rowtype;
1753: l_poi VARCHAR2(30);
1754:

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

1756: SELECT ppi.ppi_percentage
1757: FROM ghr_premium_pay_indicators ppi
1758: WHERE code = p_ppi_code;
1759:
1760: CURSOR get_mddds_amount(p_pa_request_id ghr_pa_requests.pa_request_id%type) IS
1761: SELECT rei_information11 amount
1762: FROM ghr_pa_request_extra_info
1763: WHERE pa_request_id = p_pa_request_id
1764: AND information_type='GHR_US_PAR_MD_DDS_PAY';

Line 2040: ghr_pa_requests_pkg.get_rei_org_lines(

2036: p_pa_request_rec_out.to_total_salary := NVL(l_mddds_special_pay_amount,0);
2037: END IF;
2038:
2039: IF p_pa_request_rec_in.first_noa_code='002' AND p_pa_request_rec_in.second_noa_code='790' THEN
2040: ghr_pa_requests_pkg.get_rei_org_lines(
2041: p_pa_request_id => p_pa_request_rec_in.pa_request_id,
2042: p_organization_id => l_to_organization_id,
2043: p_position_org_line1 => p_pa_request_rec_out.to_position_org_line1,
2044: p_position_org_line2 => p_pa_request_rec_out.to_position_org_line2,

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

2064: END IF;
2065: END CondPrinting_NPA;
2066:
2067:
2068: PROCEDURE Populate_NPAtags(p_pa_request_rec IN ghr_pa_requests%ROWTYPE,
2069: p_npa_misc_fields t_npa_misc_fields_rec) IS
2070: l_ctr NUMBER;
2071: BEGIN
2072: l_ctr := 1;