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_LACS_REMARKS dependencies on GHR_PA_REQUESTS

Line 3: g_requests_rec ghr_pa_requests%ROWTYPE;

1: PACKAGE BODY GHR_LACS_REMARKS AS
2: /* $Header: ghlacrem.pkb 120.13.12010000.2 2008/12/12 06:15:12 vmididho ship $ */
3: g_requests_rec ghr_pa_requests%ROWTYPE;
4: g_position_id ghr_pa_requests.from_position_id%TYPE;
5: g_pay_plan ghr_pa_requests.from_step_or_rate%TYPE;
6: g_step_or_rate ghr_pa_requests.from_pay_plan%TYPE;
7: g_grade_or_level ghr_pa_requests.from_grade_or_level%TYPE;

Line 4: g_position_id ghr_pa_requests.from_position_id%TYPE;

1: PACKAGE BODY GHR_LACS_REMARKS AS
2: /* $Header: ghlacrem.pkb 120.13.12010000.2 2008/12/12 06:15:12 vmididho ship $ */
3: g_requests_rec ghr_pa_requests%ROWTYPE;
4: g_position_id ghr_pa_requests.from_position_id%TYPE;
5: g_pay_plan ghr_pa_requests.from_step_or_rate%TYPE;
6: g_step_or_rate ghr_pa_requests.from_pay_plan%TYPE;
7: g_grade_or_level ghr_pa_requests.from_grade_or_level%TYPE;
8: g_loc_percentage ghr_locality_pay_areas_f.adjustment_percentage%TYPE;

Line 5: g_pay_plan ghr_pa_requests.from_step_or_rate%TYPE;

1: PACKAGE BODY GHR_LACS_REMARKS AS
2: /* $Header: ghlacrem.pkb 120.13.12010000.2 2008/12/12 06:15:12 vmididho ship $ */
3: g_requests_rec ghr_pa_requests%ROWTYPE;
4: g_position_id ghr_pa_requests.from_position_id%TYPE;
5: g_pay_plan ghr_pa_requests.from_step_or_rate%TYPE;
6: g_step_or_rate ghr_pa_requests.from_pay_plan%TYPE;
7: g_grade_or_level ghr_pa_requests.from_grade_or_level%TYPE;
8: g_loc_percentage ghr_locality_pay_areas_f.adjustment_percentage%TYPE;
9: -- Added for MSL expanded func

Line 6: g_step_or_rate ghr_pa_requests.from_pay_plan%TYPE;

2: /* $Header: ghlacrem.pkb 120.13.12010000.2 2008/12/12 06:15:12 vmididho ship $ */
3: g_requests_rec ghr_pa_requests%ROWTYPE;
4: g_position_id ghr_pa_requests.from_position_id%TYPE;
5: g_pay_plan ghr_pa_requests.from_step_or_rate%TYPE;
6: g_step_or_rate ghr_pa_requests.from_pay_plan%TYPE;
7: g_grade_or_level ghr_pa_requests.from_grade_or_level%TYPE;
8: g_loc_percentage ghr_locality_pay_areas_f.adjustment_percentage%TYPE;
9: -- Added for MSL expanded func
10: g_pay_table_id VARCHAR2(4);

Line 7: g_grade_or_level ghr_pa_requests.from_grade_or_level%TYPE;

3: g_requests_rec ghr_pa_requests%ROWTYPE;
4: g_position_id ghr_pa_requests.from_position_id%TYPE;
5: g_pay_plan ghr_pa_requests.from_step_or_rate%TYPE;
6: g_step_or_rate ghr_pa_requests.from_pay_plan%TYPE;
7: g_grade_or_level ghr_pa_requests.from_grade_or_level%TYPE;
8: g_loc_percentage ghr_locality_pay_areas_f.adjustment_percentage%TYPE;
9: -- Added for MSL expanded func
10: g_pay_table_id VARCHAR2(4);
11: g_new_prd VARCHAR2(10);

Line 20: p_pa_request_id ghr_pa_requests.pa_request_id%TYPE)

16: l_package VARCHAR2(30) := 'GHR_LACS_REMARKS';
17: l_location VARCHAR2(200);
18:
19: PROCEDURE Fetch_Data(
20: p_pa_request_id ghr_pa_requests.pa_request_id%TYPE)
21: IS
22: l_grade_id per_grades.grade_id%TYPE;
23: l_assignment_id per_assignments_f.assignment_id%TYPE;
24: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;

Line 38: FROM ghr_pa_requests

34: -- Fetch PA_REQUESTS Table
35: l_location := 'Apply_894_Rules:Fetch_Data:Fetching PA_REQUESTS';
36: SELECT *
37: INTO g_requests_rec
38: FROM ghr_pa_requests
39: WHERE pa_request_id = p_pa_request_id;
40: g_position_id := g_requests_rec.from_position_id;
41: BEGIN
42: l_location := 'Apply_894_Rules:Fetch_Data:' ||

Line 118: p_pa_request_id ghr_pa_requests.pa_request_id%TYPE,

114:
115: END;
116:
117: PROCEDURE Apply_894_Rules(
118: p_pa_request_id ghr_pa_requests.pa_request_id%TYPE,
119: p_new_prd ghr_pa_requests.pay_rate_determinant%TYPE,
120: p_old_prd ghr_pa_requests.pay_rate_determinant%TYPE,
121: p_out_step_or_rate GHR_PA_REQUESTS.TO_STEP_OR_RATE%TYPE,
122: p_eo_nbr VARCHAR2 := NULL,

Line 119: p_new_prd ghr_pa_requests.pay_rate_determinant%TYPE,

115: END;
116:
117: PROCEDURE Apply_894_Rules(
118: p_pa_request_id ghr_pa_requests.pa_request_id%TYPE,
119: p_new_prd ghr_pa_requests.pay_rate_determinant%TYPE,
120: p_old_prd ghr_pa_requests.pay_rate_determinant%TYPE,
121: p_out_step_or_rate GHR_PA_REQUESTS.TO_STEP_OR_RATE%TYPE,
122: p_eo_nbr VARCHAR2 := NULL,
123: p_eo_date DATE := NULL,

Line 120: p_old_prd ghr_pa_requests.pay_rate_determinant%TYPE,

116:
117: PROCEDURE Apply_894_Rules(
118: p_pa_request_id ghr_pa_requests.pa_request_id%TYPE,
119: p_new_prd ghr_pa_requests.pay_rate_determinant%TYPE,
120: p_old_prd ghr_pa_requests.pay_rate_determinant%TYPE,
121: p_out_step_or_rate GHR_PA_REQUESTS.TO_STEP_OR_RATE%TYPE,
122: p_eo_nbr VARCHAR2 := NULL,
123: p_eo_date DATE := NULL,
124: p_opm_nbr VARCHAR2 := NULL,

Line 121: p_out_step_or_rate GHR_PA_REQUESTS.TO_STEP_OR_RATE%TYPE,

117: PROCEDURE Apply_894_Rules(
118: p_pa_request_id ghr_pa_requests.pa_request_id%TYPE,
119: p_new_prd ghr_pa_requests.pay_rate_determinant%TYPE,
120: p_old_prd ghr_pa_requests.pay_rate_determinant%TYPE,
121: p_out_step_or_rate GHR_PA_REQUESTS.TO_STEP_OR_RATE%TYPE,
122: p_eo_nbr VARCHAR2 := NULL,
123: p_eo_date DATE := NULL,
124: p_opm_nbr VARCHAR2 := NULL,
125: p_opm_date DATE := NULL,

Line 129: l_la_code1 ghr_pa_requests.first_action_la_code1%TYPE;

125: p_opm_date DATE := NULL,
126: p_errbuf IN OUT NOCOPY VARCHAR2,
127: p_retcode IN OUT NOCOPY NUMBER)
128: IS
129: l_la_code1 ghr_pa_requests.first_action_la_code1%TYPE;
130: l_la_code2 ghr_pa_requests.first_action_la_code2%TYPE;
131: l_la_desc1 ghr_pa_requests.first_action_la_desc1%TYPE;
132: --Bug#4256022 Declared l_la_desc1_out variable.
133: l_la_desc1_out ghr_pa_requests.first_action_la_desc1%TYPE;

Line 130: l_la_code2 ghr_pa_requests.first_action_la_code2%TYPE;

126: p_errbuf IN OUT NOCOPY VARCHAR2,
127: p_retcode IN OUT NOCOPY NUMBER)
128: IS
129: l_la_code1 ghr_pa_requests.first_action_la_code1%TYPE;
130: l_la_code2 ghr_pa_requests.first_action_la_code2%TYPE;
131: l_la_desc1 ghr_pa_requests.first_action_la_desc1%TYPE;
132: --Bug#4256022 Declared l_la_desc1_out variable.
133: l_la_desc1_out ghr_pa_requests.first_action_la_desc1%TYPE;
134: l_la_desc2 ghr_pa_requests.first_action_la_desc2%TYPE;

Line 131: l_la_desc1 ghr_pa_requests.first_action_la_desc1%TYPE;

127: p_retcode IN OUT NOCOPY NUMBER)
128: IS
129: l_la_code1 ghr_pa_requests.first_action_la_code1%TYPE;
130: l_la_code2 ghr_pa_requests.first_action_la_code2%TYPE;
131: l_la_desc1 ghr_pa_requests.first_action_la_desc1%TYPE;
132: --Bug#4256022 Declared l_la_desc1_out variable.
133: l_la_desc1_out ghr_pa_requests.first_action_la_desc1%TYPE;
134: l_la_desc2 ghr_pa_requests.first_action_la_desc2%TYPE;
135: --Bug#4256022 Declared l_la_desc2_out variable.

Line 133: l_la_desc1_out ghr_pa_requests.first_action_la_desc1%TYPE;

129: l_la_code1 ghr_pa_requests.first_action_la_code1%TYPE;
130: l_la_code2 ghr_pa_requests.first_action_la_code2%TYPE;
131: l_la_desc1 ghr_pa_requests.first_action_la_desc1%TYPE;
132: --Bug#4256022 Declared l_la_desc1_out variable.
133: l_la_desc1_out ghr_pa_requests.first_action_la_desc1%TYPE;
134: l_la_desc2 ghr_pa_requests.first_action_la_desc2%TYPE;
135: --Bug#4256022 Declared l_la_desc2_out variable.
136: l_la_desc2_out ghr_pa_requests.first_action_la_desc1%TYPE;
137: l_insrt_value1 ghr_pa_requests.first_lac1_information1%TYPE;

Line 134: l_la_desc2 ghr_pa_requests.first_action_la_desc2%TYPE;

130: l_la_code2 ghr_pa_requests.first_action_la_code2%TYPE;
131: l_la_desc1 ghr_pa_requests.first_action_la_desc1%TYPE;
132: --Bug#4256022 Declared l_la_desc1_out variable.
133: l_la_desc1_out ghr_pa_requests.first_action_la_desc1%TYPE;
134: l_la_desc2 ghr_pa_requests.first_action_la_desc2%TYPE;
135: --Bug#4256022 Declared l_la_desc2_out variable.
136: l_la_desc2_out ghr_pa_requests.first_action_la_desc1%TYPE;
137: l_insrt_value1 ghr_pa_requests.first_lac1_information1%TYPE;
138: l_insrt_value2 ghr_pa_requests.first_lac1_information2%TYPE;

Line 136: l_la_desc2_out ghr_pa_requests.first_action_la_desc1%TYPE;

132: --Bug#4256022 Declared l_la_desc1_out variable.
133: l_la_desc1_out ghr_pa_requests.first_action_la_desc1%TYPE;
134: l_la_desc2 ghr_pa_requests.first_action_la_desc2%TYPE;
135: --Bug#4256022 Declared l_la_desc2_out variable.
136: l_la_desc2_out ghr_pa_requests.first_action_la_desc1%TYPE;
137: l_insrt_value1 ghr_pa_requests.first_lac1_information1%TYPE;
138: l_insrt_value2 ghr_pa_requests.first_lac1_information2%TYPE;
139: l_retcode VARCHAR2(50) ; --For NOCOPY Changes
140: l_errbuf NUMBER ; --For NOCOPY Changes

Line 137: l_insrt_value1 ghr_pa_requests.first_lac1_information1%TYPE;

133: l_la_desc1_out ghr_pa_requests.first_action_la_desc1%TYPE;
134: l_la_desc2 ghr_pa_requests.first_action_la_desc2%TYPE;
135: --Bug#4256022 Declared l_la_desc2_out variable.
136: l_la_desc2_out ghr_pa_requests.first_action_la_desc1%TYPE;
137: l_insrt_value1 ghr_pa_requests.first_lac1_information1%TYPE;
138: l_insrt_value2 ghr_pa_requests.first_lac1_information2%TYPE;
139: l_retcode VARCHAR2(50) ; --For NOCOPY Changes
140: l_errbuf NUMBER ; --For NOCOPY Changes
141:

Line 138: l_insrt_value2 ghr_pa_requests.first_lac1_information2%TYPE;

134: l_la_desc2 ghr_pa_requests.first_action_la_desc2%TYPE;
135: --Bug#4256022 Declared l_la_desc2_out variable.
136: l_la_desc2_out ghr_pa_requests.first_action_la_desc1%TYPE;
137: l_insrt_value1 ghr_pa_requests.first_lac1_information1%TYPE;
138: l_insrt_value2 ghr_pa_requests.first_lac1_information2%TYPE;
139: l_retcode VARCHAR2(50) ; --For NOCOPY Changes
140: l_errbuf NUMBER ; --For NOCOPY Changes
141:
142: l_adj_bp ghr_pa_requests.from_adj_basic_pay%type;

Line 142: l_adj_bp ghr_pa_requests.from_adj_basic_pay%type;

138: l_insrt_value2 ghr_pa_requests.first_lac1_information2%TYPE;
139: l_retcode VARCHAR2(50) ; --For NOCOPY Changes
140: l_errbuf NUMBER ; --For NOCOPY Changes
141:
142: l_adj_bp ghr_pa_requests.from_adj_basic_pay%type;
143: l_pay_cap_amount ghr_pa_requests.from_adj_basic_pay%type;
144: l_create_rmk BOOLEAN:=FALSE;
145: l_remark_id ghr_pa_remarks.pa_remark_id%type;
146: l_loc_area_id ghr_duty_Stations_f.locality_pay_area_id%type;

Line 143: l_pay_cap_amount ghr_pa_requests.from_adj_basic_pay%type;

139: l_retcode VARCHAR2(50) ; --For NOCOPY Changes
140: l_errbuf NUMBER ; --For NOCOPY Changes
141:
142: l_adj_bp ghr_pa_requests.from_adj_basic_pay%type;
143: l_pay_cap_amount ghr_pa_requests.from_adj_basic_pay%type;
144: l_create_rmk BOOLEAN:=FALSE;
145: l_remark_id ghr_pa_remarks.pa_remark_id%type;
146: l_loc_area_id ghr_duty_Stations_f.locality_pay_area_id%type;
147: l_loc_perc ghr_locality_pay_areas_f.adjustment_percentage%TYPE;

Line 150: p_eff_date ghr_pa_requests.effective_date%type)

146: l_loc_area_id ghr_duty_Stations_f.locality_pay_area_id%type;
147: l_loc_perc ghr_locality_pay_areas_f.adjustment_percentage%TYPE;
148:
149: CURSOR cur_loc_area_id(p_ds_id ghr_duty_Stations_f.duty_station_id%type,
150: p_eff_date ghr_pa_requests.effective_date%type)
151: IS
152: SELECT locality_pay_area_id
153: FROM ghr_duty_stations_f
154: WHERE duty_station_id=p_ds_id

Line 159: p_eff_date ghr_pa_requests.effective_date%type)

155: AND p_eff_date between effective_start_date and effective_end_date;
156:
157: CURSOR cur_loc_perc
158: (p_ds_loc_area_id ghr_duty_Stations_f.locality_pay_area_id%type,
159: p_eff_date ghr_pa_requests.effective_date%type)
160: IS
161: SELECT adjustment_percentage
162: FROM ghr_locality_pay_areas_f
163: WHERE locality_pay_area_id = p_ds_loc_area_id

Line 167: p_out_step_or_rate GHR_PA_REQUESTS.TO_STEP_OR_RATE%TYPE)

163: WHERE locality_pay_area_id = p_ds_loc_area_id
164: AND p_eff_date between effective_start_date and effective_end_date;
165:
166: PROCEDURE Create_Remark(p_remark_code in ghr_remarks.code%TYPE,
167: p_out_step_or_rate GHR_PA_REQUESTS.TO_STEP_OR_RATE%TYPE)
168: IS
169: l_remark_id ghr_remarks.remark_id%TYPE;
170: l_pa_remark_id ghr_pa_remarks.pa_remark_id%TYPE;
171: l_object_version_nbr ghr_pa_remarks.object_version_number%TYPE;

Line 405: IF l_la_code1 IS NOT NULL THEN -- Update GHR_PA_REQUESTS with new LACs

401: l_insrt_value1 := 'Reg. 534.504';
402: END IF;
403:
404: IF p_retcode = 0 THEN
405: IF l_la_code1 IS NOT NULL THEN -- Update GHR_PA_REQUESTS with new LACs
406: l_location := 'Apply_894_Rules:Replacing Insertion Value';
407: SELECT description
408: INTO l_la_desc1
409: FROM fnd_common_lookups fcl

Line 450: l_location := 'Apply_894_Rules:Updating GHR_PA_REQUESTS';

446: p_information1 => l_insrt_value2,
447: p_desc_out => l_la_desc2_out);
448: l_la_desc2 := l_la_desc2_out;
449: END IF;
450: l_location := 'Apply_894_Rules:Updating GHR_PA_REQUESTS';
451: UPDATE GHR_PA_REQUESTS
452: SET first_action_la_code1 = l_la_code1,
453: first_action_la_code2 = l_la_code2,
454: first_action_la_desc1 = l_la_desc1,

Line 451: UPDATE GHR_PA_REQUESTS

447: p_desc_out => l_la_desc2_out);
448: l_la_desc2 := l_la_desc2_out;
449: END IF;
450: l_location := 'Apply_894_Rules:Updating GHR_PA_REQUESTS';
451: UPDATE GHR_PA_REQUESTS
452: SET first_action_la_code1 = l_la_code1,
453: first_action_la_code2 = l_la_code2,
454: first_action_la_desc1 = l_la_desc1,
455: first_action_la_desc2 = DECODE(l_la_code2, NULL, NULL,

Line 561: -- Checking existence of LAC in GHR_PA_REQUESTS

557: p_opm_nbr, p_opm_date,
558: p_retcode, p_errbuf);
559:
560: IF p_retcode = 0 THEN
561: -- Checking existence of LAC in GHR_PA_REQUESTS
562: SELECT first_action_la_code1
563: INTO l_la_code1
564: FROM GHR_PA_REQUESTS
565: WHERE pa_request_id = p_pa_request_id;

Line 564: FROM GHR_PA_REQUESTS

560: IF p_retcode = 0 THEN
561: -- Checking existence of LAC in GHR_PA_REQUESTS
562: SELECT first_action_la_code1
563: INTO l_la_code1
564: FROM GHR_PA_REQUESTS
565: WHERE pa_request_id = p_pa_request_id;
566: IF l_la_code1 IS NULL THEN
567: p_retcode := 2;
568: p_errbuf := 'Error in Apply_894_Rules: ' ||

Line 611: l_location := 'Apply_895_Rules:Updating GHR_PA_REQUESTS';

607: END IF;
608:
609: BEGIN
610: -- STAGE 2
611: l_location := 'Apply_895_Rules:Updating GHR_PA_REQUESTS';
612:
613: UPDATE GHR_PA_REQUESTS
614: SET first_action_la_code1 = l_la_code1,
615: first_action_la_desc1 = l_la_desc1,

Line 613: UPDATE GHR_PA_REQUESTS

609: BEGIN
610: -- STAGE 2
611: l_location := 'Apply_895_Rules:Updating GHR_PA_REQUESTS';
612:
613: UPDATE GHR_PA_REQUESTS
614: SET first_action_la_code1 = l_la_code1,
615: first_action_la_desc1 = l_la_desc1,
616: first_lac1_information1 = NULL,
617: first_lac1_information2 = NULL,

Line 654: -- Checking existence of LAC in GHR_PA_REQUESTS

650: p_opm_nbr, p_opm_date,
651: p_retcode, p_errbuf);
652:
653: IF p_retcode = 0 THEN
654: -- Checking existence of LAC in GHR_PA_REQUESTS
655: SELECT first_action_la_code1
656: INTO l_la_code1
657: FROM GHR_PA_REQUESTS
658: WHERE pa_request_id = p_pa_request_id;

Line 657: FROM GHR_PA_REQUESTS

653: IF p_retcode = 0 THEN
654: -- Checking existence of LAC in GHR_PA_REQUESTS
655: SELECT first_action_la_code1
656: INTO l_la_code1
657: FROM GHR_PA_REQUESTS
658: WHERE pa_request_id = p_pa_request_id;
659: IF l_la_code1 IS NULL THEN
660: p_retcode := 2;
661: p_errbuf := 'Error in Apply_895_Rules: ' ||

Line 677: PROCEDURE apply_fwfa_rules( p_pa_request_id GHR_PA_REQUESTS.PA_REQUEST_ID%TYPE,

673: END;
674:
675: -- FWFA Changes Bug#4444609
676:
677: PROCEDURE apply_fwfa_rules( p_pa_request_id GHR_PA_REQUESTS.PA_REQUEST_ID%TYPE,
678: p_noa_code GHR_PA_REQUESTS.FIRST_NOA_CODE%TYPE,
679: p_pay_plan GHR_PA_REQUESTS.TO_PAY_PLAN%TYPE,
680: p_errbuf IN OUT NOCOPY VARCHAR2,
681: p_retcode IN OUT NOCOPY NUMBER

Line 678: p_noa_code GHR_PA_REQUESTS.FIRST_NOA_CODE%TYPE,

674:
675: -- FWFA Changes Bug#4444609
676:
677: PROCEDURE apply_fwfa_rules( p_pa_request_id GHR_PA_REQUESTS.PA_REQUEST_ID%TYPE,
678: p_noa_code GHR_PA_REQUESTS.FIRST_NOA_CODE%TYPE,
679: p_pay_plan GHR_PA_REQUESTS.TO_PAY_PLAN%TYPE,
680: p_errbuf IN OUT NOCOPY VARCHAR2,
681: p_retcode IN OUT NOCOPY NUMBER
682: ) is

Line 679: p_pay_plan GHR_PA_REQUESTS.TO_PAY_PLAN%TYPE,

675: -- FWFA Changes Bug#4444609
676:
677: PROCEDURE apply_fwfa_rules( p_pa_request_id GHR_PA_REQUESTS.PA_REQUEST_ID%TYPE,
678: p_noa_code GHR_PA_REQUESTS.FIRST_NOA_CODE%TYPE,
679: p_pay_plan GHR_PA_REQUESTS.TO_PAY_PLAN%TYPE,
680: p_errbuf IN OUT NOCOPY VARCHAR2,
681: p_retcode IN OUT NOCOPY NUMBER
682: ) is
683: l_la_code1 ghr_pa_requests.first_action_la_code1%TYPE;

Line 683: l_la_code1 ghr_pa_requests.first_action_la_code1%TYPE;

679: p_pay_plan GHR_PA_REQUESTS.TO_PAY_PLAN%TYPE,
680: p_errbuf IN OUT NOCOPY VARCHAR2,
681: p_retcode IN OUT NOCOPY NUMBER
682: ) is
683: l_la_code1 ghr_pa_requests.first_action_la_code1%TYPE;
684: l_la_code2 ghr_pa_requests.first_action_la_code2%TYPE;
685: l_la_desc1 ghr_pa_requests.first_action_la_desc1%TYPE;
686: l_la_desc1_out ghr_pa_requests.first_action_la_desc1%TYPE;
687: l_la_desc2 ghr_pa_requests.first_action_la_desc2%TYPE;

Line 684: l_la_code2 ghr_pa_requests.first_action_la_code2%TYPE;

680: p_errbuf IN OUT NOCOPY VARCHAR2,
681: p_retcode IN OUT NOCOPY NUMBER
682: ) is
683: l_la_code1 ghr_pa_requests.first_action_la_code1%TYPE;
684: l_la_code2 ghr_pa_requests.first_action_la_code2%TYPE;
685: l_la_desc1 ghr_pa_requests.first_action_la_desc1%TYPE;
686: l_la_desc1_out ghr_pa_requests.first_action_la_desc1%TYPE;
687: l_la_desc2 ghr_pa_requests.first_action_la_desc2%TYPE;
688: l_la_desc2_out ghr_pa_requests.first_action_la_desc2%TYPE;

Line 685: l_la_desc1 ghr_pa_requests.first_action_la_desc1%TYPE;

681: p_retcode IN OUT NOCOPY NUMBER
682: ) is
683: l_la_code1 ghr_pa_requests.first_action_la_code1%TYPE;
684: l_la_code2 ghr_pa_requests.first_action_la_code2%TYPE;
685: l_la_desc1 ghr_pa_requests.first_action_la_desc1%TYPE;
686: l_la_desc1_out ghr_pa_requests.first_action_la_desc1%TYPE;
687: l_la_desc2 ghr_pa_requests.first_action_la_desc2%TYPE;
688: l_la_desc2_out ghr_pa_requests.first_action_la_desc2%TYPE;
689: l_insrt_value ghr_pa_requests.first_lac1_information1%TYPE;

Line 686: l_la_desc1_out ghr_pa_requests.first_action_la_desc1%TYPE;

682: ) is
683: l_la_code1 ghr_pa_requests.first_action_la_code1%TYPE;
684: l_la_code2 ghr_pa_requests.first_action_la_code2%TYPE;
685: l_la_desc1 ghr_pa_requests.first_action_la_desc1%TYPE;
686: l_la_desc1_out ghr_pa_requests.first_action_la_desc1%TYPE;
687: l_la_desc2 ghr_pa_requests.first_action_la_desc2%TYPE;
688: l_la_desc2_out ghr_pa_requests.first_action_la_desc2%TYPE;
689: l_insrt_value ghr_pa_requests.first_lac1_information1%TYPE;
690:

Line 687: l_la_desc2 ghr_pa_requests.first_action_la_desc2%TYPE;

683: l_la_code1 ghr_pa_requests.first_action_la_code1%TYPE;
684: l_la_code2 ghr_pa_requests.first_action_la_code2%TYPE;
685: l_la_desc1 ghr_pa_requests.first_action_la_desc1%TYPE;
686: l_la_desc1_out ghr_pa_requests.first_action_la_desc1%TYPE;
687: l_la_desc2 ghr_pa_requests.first_action_la_desc2%TYPE;
688: l_la_desc2_out ghr_pa_requests.first_action_la_desc2%TYPE;
689: l_insrt_value ghr_pa_requests.first_lac1_information1%TYPE;
690:
691: BEGIN

Line 688: l_la_desc2_out ghr_pa_requests.first_action_la_desc2%TYPE;

684: l_la_code2 ghr_pa_requests.first_action_la_code2%TYPE;
685: l_la_desc1 ghr_pa_requests.first_action_la_desc1%TYPE;
686: l_la_desc1_out ghr_pa_requests.first_action_la_desc1%TYPE;
687: l_la_desc2 ghr_pa_requests.first_action_la_desc2%TYPE;
688: l_la_desc2_out ghr_pa_requests.first_action_la_desc2%TYPE;
689: l_insrt_value ghr_pa_requests.first_lac1_information1%TYPE;
690:
691: BEGIN
692: p_retcode := 0;

Line 689: l_insrt_value ghr_pa_requests.first_lac1_information1%TYPE;

685: l_la_desc1 ghr_pa_requests.first_action_la_desc1%TYPE;
686: l_la_desc1_out ghr_pa_requests.first_action_la_desc1%TYPE;
687: l_la_desc2 ghr_pa_requests.first_action_la_desc2%TYPE;
688: l_la_desc2_out ghr_pa_requests.first_action_la_desc2%TYPE;
689: l_insrt_value ghr_pa_requests.first_lac1_information1%TYPE;
690:
691: BEGIN
692: p_retcode := 0;
693: p_errbuf := NULL;

Line 708: l_la_desc1 := ghr_pa_requests_pkg.get_lookup_description(800,'GHR_US_LEGAL_AUTHORITY',l_la_code1);

704: l_la_code2 := 'ZLM';
705: END IF;
706: END IF;
707:
708: l_la_desc1 := ghr_pa_requests_pkg.get_lookup_description(800,'GHR_US_LEGAL_AUTHORITY',l_la_code1);
709: l_la_desc2 := ghr_pa_requests_pkg.get_lookup_description(800,'GHR_US_LEGAL_AUTHORITY',l_la_code2);
710:
711: IF (l_la_code1 = 'ZLM') THEN
712: l_insrt_value := 'P.L. 108-411, Sec. 301 dated 10-30-04.';

Line 709: l_la_desc2 := ghr_pa_requests_pkg.get_lookup_description(800,'GHR_US_LEGAL_AUTHORITY',l_la_code2);

705: END IF;
706: END IF;
707:
708: l_la_desc1 := ghr_pa_requests_pkg.get_lookup_description(800,'GHR_US_LEGAL_AUTHORITY',l_la_code1);
709: l_la_desc2 := ghr_pa_requests_pkg.get_lookup_description(800,'GHR_US_LEGAL_AUTHORITY',l_la_code2);
710:
711: IF (l_la_code1 = 'ZLM') THEN
712: l_insrt_value := 'P.L. 108-411, Sec. 301 dated 10-30-04.';
713: ghr_mass_actions_pkg.replace_insertion_values

Line 729: UPDATE GHR_PA_REQUESTS

725: p_desc_out => l_la_desc2_out);
726: l_la_desc2 := l_la_desc2_out;
727: END IF;
728:
729: UPDATE GHR_PA_REQUESTS
730: SET first_action_la_code1 = l_la_code1,
731: first_action_la_code2 = l_la_code2,
732: first_action_la_desc1 = l_la_desc1,
733: first_action_la_desc2 = l_la_Desc2,