DBA Data[Home] [Help]

APPS.GHR_WF_WGI_PKG dependencies on GHR_PA_REMARKS

Line 2263: l_pa_remark_id ghr_pa_remarks.pa_remark_id%TYPE;

2259: l_from_step_or_rate ghr_pa_requests.from_step_or_rate%TYPE;
2260: l_from_total_salary ghr_pa_requests.from_total_salary%TYPE;
2261: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
2262: -- Remarks
2263: l_pa_remark_id ghr_pa_remarks.pa_remark_id%TYPE;
2264: l_pre_object_version_number ghr_pa_remarks.object_version_number%TYPE;
2265: l_remark_id1 ghr_pa_remarks.remark_id%TYPE := Null;
2266: l_remark_desc1 ghr_pa_remarks.description%type := Null;
2267: l_remark1_info1 ghr_pa_remarks.remark_code_information1%TYPE := Null;

Line 2264: l_pre_object_version_number ghr_pa_remarks.object_version_number%TYPE;

2260: l_from_total_salary ghr_pa_requests.from_total_salary%TYPE;
2261: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
2262: -- Remarks
2263: l_pa_remark_id ghr_pa_remarks.pa_remark_id%TYPE;
2264: l_pre_object_version_number ghr_pa_remarks.object_version_number%TYPE;
2265: l_remark_id1 ghr_pa_remarks.remark_id%TYPE := Null;
2266: l_remark_desc1 ghr_pa_remarks.description%type := Null;
2267: l_remark1_info1 ghr_pa_remarks.remark_code_information1%TYPE := Null;
2268: l_remark1_info2 ghr_pa_remarks.remark_code_information2%TYPE := Null;

Line 2265: l_remark_id1 ghr_pa_remarks.remark_id%TYPE := Null;

2261: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
2262: -- Remarks
2263: l_pa_remark_id ghr_pa_remarks.pa_remark_id%TYPE;
2264: l_pre_object_version_number ghr_pa_remarks.object_version_number%TYPE;
2265: l_remark_id1 ghr_pa_remarks.remark_id%TYPE := Null;
2266: l_remark_desc1 ghr_pa_remarks.description%type := Null;
2267: l_remark1_info1 ghr_pa_remarks.remark_code_information1%TYPE := Null;
2268: l_remark1_info2 ghr_pa_remarks.remark_code_information2%TYPE := Null;
2269: l_remark1_info3 ghr_pa_remarks.remark_code_information3%TYPE := Null;

Line 2266: l_remark_desc1 ghr_pa_remarks.description%type := Null;

2262: -- Remarks
2263: l_pa_remark_id ghr_pa_remarks.pa_remark_id%TYPE;
2264: l_pre_object_version_number ghr_pa_remarks.object_version_number%TYPE;
2265: l_remark_id1 ghr_pa_remarks.remark_id%TYPE := Null;
2266: l_remark_desc1 ghr_pa_remarks.description%type := Null;
2267: l_remark1_info1 ghr_pa_remarks.remark_code_information1%TYPE := Null;
2268: l_remark1_info2 ghr_pa_remarks.remark_code_information2%TYPE := Null;
2269: l_remark1_info3 ghr_pa_remarks.remark_code_information3%TYPE := Null;
2270: l_remark_id2 ghr_pa_remarks.remark_id%TYPE := Null;

Line 2267: l_remark1_info1 ghr_pa_remarks.remark_code_information1%TYPE := Null;

2263: l_pa_remark_id ghr_pa_remarks.pa_remark_id%TYPE;
2264: l_pre_object_version_number ghr_pa_remarks.object_version_number%TYPE;
2265: l_remark_id1 ghr_pa_remarks.remark_id%TYPE := Null;
2266: l_remark_desc1 ghr_pa_remarks.description%type := Null;
2267: l_remark1_info1 ghr_pa_remarks.remark_code_information1%TYPE := Null;
2268: l_remark1_info2 ghr_pa_remarks.remark_code_information2%TYPE := Null;
2269: l_remark1_info3 ghr_pa_remarks.remark_code_information3%TYPE := Null;
2270: l_remark_id2 ghr_pa_remarks.remark_id%TYPE := Null;
2271: l_remark_desc2 ghr_pa_remarks.description%type := Null;

Line 2268: l_remark1_info2 ghr_pa_remarks.remark_code_information2%TYPE := Null;

2264: l_pre_object_version_number ghr_pa_remarks.object_version_number%TYPE;
2265: l_remark_id1 ghr_pa_remarks.remark_id%TYPE := Null;
2266: l_remark_desc1 ghr_pa_remarks.description%type := Null;
2267: l_remark1_info1 ghr_pa_remarks.remark_code_information1%TYPE := Null;
2268: l_remark1_info2 ghr_pa_remarks.remark_code_information2%TYPE := Null;
2269: l_remark1_info3 ghr_pa_remarks.remark_code_information3%TYPE := Null;
2270: l_remark_id2 ghr_pa_remarks.remark_id%TYPE := Null;
2271: l_remark_desc2 ghr_pa_remarks.description%type := Null;
2272: l_remark2_info1 ghr_pa_remarks.remark_code_information1%TYPE := Null;

Line 2269: l_remark1_info3 ghr_pa_remarks.remark_code_information3%TYPE := Null;

2265: l_remark_id1 ghr_pa_remarks.remark_id%TYPE := Null;
2266: l_remark_desc1 ghr_pa_remarks.description%type := Null;
2267: l_remark1_info1 ghr_pa_remarks.remark_code_information1%TYPE := Null;
2268: l_remark1_info2 ghr_pa_remarks.remark_code_information2%TYPE := Null;
2269: l_remark1_info3 ghr_pa_remarks.remark_code_information3%TYPE := Null;
2270: l_remark_id2 ghr_pa_remarks.remark_id%TYPE := Null;
2271: l_remark_desc2 ghr_pa_remarks.description%type := Null;
2272: l_remark2_info1 ghr_pa_remarks.remark_code_information1%TYPE := Null;
2273: l_remark2_info2 ghr_pa_remarks.remark_code_information2%TYPE := Null;

Line 2270: l_remark_id2 ghr_pa_remarks.remark_id%TYPE := Null;

2266: l_remark_desc1 ghr_pa_remarks.description%type := Null;
2267: l_remark1_info1 ghr_pa_remarks.remark_code_information1%TYPE := Null;
2268: l_remark1_info2 ghr_pa_remarks.remark_code_information2%TYPE := Null;
2269: l_remark1_info3 ghr_pa_remarks.remark_code_information3%TYPE := Null;
2270: l_remark_id2 ghr_pa_remarks.remark_id%TYPE := Null;
2271: l_remark_desc2 ghr_pa_remarks.description%type := Null;
2272: l_remark2_info1 ghr_pa_remarks.remark_code_information1%TYPE := Null;
2273: l_remark2_info2 ghr_pa_remarks.remark_code_information2%TYPE := Null;
2274: l_remark2_info3 ghr_pa_remarks.remark_code_information3%TYPE := Null;

Line 2271: l_remark_desc2 ghr_pa_remarks.description%type := Null;

2267: l_remark1_info1 ghr_pa_remarks.remark_code_information1%TYPE := Null;
2268: l_remark1_info2 ghr_pa_remarks.remark_code_information2%TYPE := Null;
2269: l_remark1_info3 ghr_pa_remarks.remark_code_information3%TYPE := Null;
2270: l_remark_id2 ghr_pa_remarks.remark_id%TYPE := Null;
2271: l_remark_desc2 ghr_pa_remarks.description%type := Null;
2272: l_remark2_info1 ghr_pa_remarks.remark_code_information1%TYPE := Null;
2273: l_remark2_info2 ghr_pa_remarks.remark_code_information2%TYPE := Null;
2274: l_remark2_info3 ghr_pa_remarks.remark_code_information3%TYPE := Null;
2275: --NOCOPY Changes

Line 2272: l_remark2_info1 ghr_pa_remarks.remark_code_information1%TYPE := Null;

2268: l_remark1_info2 ghr_pa_remarks.remark_code_information2%TYPE := Null;
2269: l_remark1_info3 ghr_pa_remarks.remark_code_information3%TYPE := Null;
2270: l_remark_id2 ghr_pa_remarks.remark_id%TYPE := Null;
2271: l_remark_desc2 ghr_pa_remarks.description%type := Null;
2272: l_remark2_info1 ghr_pa_remarks.remark_code_information1%TYPE := Null;
2273: l_remark2_info2 ghr_pa_remarks.remark_code_information2%TYPE := Null;
2274: l_remark2_info3 ghr_pa_remarks.remark_code_information3%TYPE := Null;
2275: --NOCOPY Changes
2276: l_result VARCHAR2(250);

Line 2273: l_remark2_info2 ghr_pa_remarks.remark_code_information2%TYPE := Null;

2269: l_remark1_info3 ghr_pa_remarks.remark_code_information3%TYPE := Null;
2270: l_remark_id2 ghr_pa_remarks.remark_id%TYPE := Null;
2271: l_remark_desc2 ghr_pa_remarks.description%type := Null;
2272: l_remark2_info1 ghr_pa_remarks.remark_code_information1%TYPE := Null;
2273: l_remark2_info2 ghr_pa_remarks.remark_code_information2%TYPE := Null;
2274: l_remark2_info3 ghr_pa_remarks.remark_code_information3%TYPE := Null;
2275: --NOCOPY Changes
2276: l_result VARCHAR2(250);
2277: --

Line 2274: l_remark2_info3 ghr_pa_remarks.remark_code_information3%TYPE := Null;

2270: l_remark_id2 ghr_pa_remarks.remark_id%TYPE := Null;
2271: l_remark_desc2 ghr_pa_remarks.description%type := Null;
2272: l_remark2_info1 ghr_pa_remarks.remark_code_information1%TYPE := Null;
2273: l_remark2_info2 ghr_pa_remarks.remark_code_information2%TYPE := Null;
2274: l_remark2_info3 ghr_pa_remarks.remark_code_information3%TYPE := Null;
2275: --NOCOPY Changes
2276: l_result VARCHAR2(250);
2277: --
2278: -- Fetch PA request details

Line 2437: ghr_pa_remarks_api.create_pa_remarks

2433: );
2434:
2435: -- Create remarks if any, derived from above .
2436: If l_remark_id1 is not null then
2437: ghr_pa_remarks_api.create_pa_remarks
2438: (p_pa_request_id => to_number(itemkey),
2439: p_remark_id => l_remark_id1,
2440: p_description => l_remark_desc1,
2441: p_remark_code_information1 => l_remark1_info1,

Line 2449: ghr_pa_remarks_api.create_pa_remarks

2445: p_object_version_number => l_pre_object_version_number
2446: );
2447: End if;
2448: If l_remark_id2 is not null then
2449: ghr_pa_remarks_api.create_pa_remarks
2450: (p_pa_request_id => to_number(itemkey),
2451: p_remark_id => l_remark_id2,
2452: p_description => l_remark_desc2,
2453: p_remark_code_information1 => l_remark2_info1,