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_WGI_PKG dependencies on GHR_PA_REMARKS

Line 253: l_pa_remark_id ghr_pa_remarks.pa_remark_id%TYPE;

249: l_req VARCHAR2 (15);
250: l_in_pay_plan ghr_pa_requests.from_pay_plan%TYPE;
251: l_in_personnel_office_id ghr_pa_requests.personnel_office_id%TYPE;
252: -- Remarks
253: l_pa_remark_id ghr_pa_remarks.pa_remark_id%TYPE;
254: l_pre_object_version_number ghr_pa_remarks.object_version_number%TYPE;
255: l_remark_id1 ghr_pa_remarks.remark_id%TYPE := NULL;
256: l_remark_desc1 ghr_pa_remarks.description%TYPE := NULL;
257: l_remark1_info1 ghr_pa_remarks.remark_code_information1%TYPE

Line 254: l_pre_object_version_number ghr_pa_remarks.object_version_number%TYPE;

250: l_in_pay_plan ghr_pa_requests.from_pay_plan%TYPE;
251: l_in_personnel_office_id ghr_pa_requests.personnel_office_id%TYPE;
252: -- Remarks
253: l_pa_remark_id ghr_pa_remarks.pa_remark_id%TYPE;
254: l_pre_object_version_number ghr_pa_remarks.object_version_number%TYPE;
255: l_remark_id1 ghr_pa_remarks.remark_id%TYPE := NULL;
256: l_remark_desc1 ghr_pa_remarks.description%TYPE := NULL;
257: l_remark1_info1 ghr_pa_remarks.remark_code_information1%TYPE
258: := NULL;

Line 255: l_remark_id1 ghr_pa_remarks.remark_id%TYPE := NULL;

251: l_in_personnel_office_id ghr_pa_requests.personnel_office_id%TYPE;
252: -- Remarks
253: l_pa_remark_id ghr_pa_remarks.pa_remark_id%TYPE;
254: l_pre_object_version_number ghr_pa_remarks.object_version_number%TYPE;
255: l_remark_id1 ghr_pa_remarks.remark_id%TYPE := NULL;
256: l_remark_desc1 ghr_pa_remarks.description%TYPE := NULL;
257: l_remark1_info1 ghr_pa_remarks.remark_code_information1%TYPE
258: := NULL;
259: l_remark1_info2 ghr_pa_remarks.remark_code_information2%TYPE

Line 256: l_remark_desc1 ghr_pa_remarks.description%TYPE := NULL;

252: -- Remarks
253: l_pa_remark_id ghr_pa_remarks.pa_remark_id%TYPE;
254: l_pre_object_version_number ghr_pa_remarks.object_version_number%TYPE;
255: l_remark_id1 ghr_pa_remarks.remark_id%TYPE := NULL;
256: l_remark_desc1 ghr_pa_remarks.description%TYPE := NULL;
257: l_remark1_info1 ghr_pa_remarks.remark_code_information1%TYPE
258: := NULL;
259: l_remark1_info2 ghr_pa_remarks.remark_code_information2%TYPE
260: := NULL;

Line 257: l_remark1_info1 ghr_pa_remarks.remark_code_information1%TYPE

253: l_pa_remark_id ghr_pa_remarks.pa_remark_id%TYPE;
254: l_pre_object_version_number ghr_pa_remarks.object_version_number%TYPE;
255: l_remark_id1 ghr_pa_remarks.remark_id%TYPE := NULL;
256: l_remark_desc1 ghr_pa_remarks.description%TYPE := NULL;
257: l_remark1_info1 ghr_pa_remarks.remark_code_information1%TYPE
258: := NULL;
259: l_remark1_info2 ghr_pa_remarks.remark_code_information2%TYPE
260: := NULL;
261: l_remark1_info3 ghr_pa_remarks.remark_code_information3%TYPE

Line 259: l_remark1_info2 ghr_pa_remarks.remark_code_information2%TYPE

255: l_remark_id1 ghr_pa_remarks.remark_id%TYPE := NULL;
256: l_remark_desc1 ghr_pa_remarks.description%TYPE := NULL;
257: l_remark1_info1 ghr_pa_remarks.remark_code_information1%TYPE
258: := NULL;
259: l_remark1_info2 ghr_pa_remarks.remark_code_information2%TYPE
260: := NULL;
261: l_remark1_info3 ghr_pa_remarks.remark_code_information3%TYPE
262: := NULL;
263: l_remark_id2 ghr_pa_remarks.remark_id%TYPE := NULL;

Line 261: l_remark1_info3 ghr_pa_remarks.remark_code_information3%TYPE

257: l_remark1_info1 ghr_pa_remarks.remark_code_information1%TYPE
258: := NULL;
259: l_remark1_info2 ghr_pa_remarks.remark_code_information2%TYPE
260: := NULL;
261: l_remark1_info3 ghr_pa_remarks.remark_code_information3%TYPE
262: := NULL;
263: l_remark_id2 ghr_pa_remarks.remark_id%TYPE := NULL;
264: l_remark_desc2 ghr_pa_remarks.description%TYPE := NULL;
265: l_remark2_info1 ghr_pa_remarks.remark_code_information1%TYPE

Line 263: l_remark_id2 ghr_pa_remarks.remark_id%TYPE := NULL;

259: l_remark1_info2 ghr_pa_remarks.remark_code_information2%TYPE
260: := NULL;
261: l_remark1_info3 ghr_pa_remarks.remark_code_information3%TYPE
262: := NULL;
263: l_remark_id2 ghr_pa_remarks.remark_id%TYPE := NULL;
264: l_remark_desc2 ghr_pa_remarks.description%TYPE := NULL;
265: l_remark2_info1 ghr_pa_remarks.remark_code_information1%TYPE
266: := NULL;
267: l_remark2_info2 ghr_pa_remarks.remark_code_information2%TYPE

Line 264: l_remark_desc2 ghr_pa_remarks.description%TYPE := NULL;

260: := NULL;
261: l_remark1_info3 ghr_pa_remarks.remark_code_information3%TYPE
262: := NULL;
263: l_remark_id2 ghr_pa_remarks.remark_id%TYPE := NULL;
264: l_remark_desc2 ghr_pa_remarks.description%TYPE := NULL;
265: l_remark2_info1 ghr_pa_remarks.remark_code_information1%TYPE
266: := NULL;
267: l_remark2_info2 ghr_pa_remarks.remark_code_information2%TYPE
268: := NULL;

Line 265: l_remark2_info1 ghr_pa_remarks.remark_code_information1%TYPE

261: l_remark1_info3 ghr_pa_remarks.remark_code_information3%TYPE
262: := NULL;
263: l_remark_id2 ghr_pa_remarks.remark_id%TYPE := NULL;
264: l_remark_desc2 ghr_pa_remarks.description%TYPE := NULL;
265: l_remark2_info1 ghr_pa_remarks.remark_code_information1%TYPE
266: := NULL;
267: l_remark2_info2 ghr_pa_remarks.remark_code_information2%TYPE
268: := NULL;
269: l_remark2_info3 ghr_pa_remarks.remark_code_information3%TYPE

Line 267: l_remark2_info2 ghr_pa_remarks.remark_code_information2%TYPE

263: l_remark_id2 ghr_pa_remarks.remark_id%TYPE := NULL;
264: l_remark_desc2 ghr_pa_remarks.description%TYPE := NULL;
265: l_remark2_info1 ghr_pa_remarks.remark_code_information1%TYPE
266: := NULL;
267: l_remark2_info2 ghr_pa_remarks.remark_code_information2%TYPE
268: := NULL;
269: l_remark2_info3 ghr_pa_remarks.remark_code_information3%TYPE
270: := NULL;
271: l_commit NUMBER;

Line 269: l_remark2_info3 ghr_pa_remarks.remark_code_information3%TYPE

265: l_remark2_info1 ghr_pa_remarks.remark_code_information1%TYPE
266: := NULL;
267: l_remark2_info2 ghr_pa_remarks.remark_code_information2%TYPE
268: := NULL;
269: l_remark2_info3 ghr_pa_remarks.remark_code_information3%TYPE
270: := NULL;
271: l_commit NUMBER;
272: ------------ Bug 3680601
273: l_grp_box_id ghr_pois.groupbox_id%type;

Line 328: from ghr_pa_remarks

324: cursor val_pa_remarks(p_pa_request_id in number,
325: p_remark_id in number)
326: is
327: select 1
328: from ghr_pa_remarks
329: where pa_request_id = p_pa_request_id
330: and pa_remark_id = p_remark_id;
331:
332: m_val_pa_remarks val_pa_remarks%rowtype;

Line 1837: ghr_pa_remarks_api.create_pa_remarks (

1833: OPEN val_pa_remarks(p_pa_request_id => l_pa_request_id,
1834: p_remark_id => l_remark_id1);
1835: FETCH val_pa_remarks into m_val_pa_remarks;
1836: IF val_pa_remarks%NOTFOUND THEN
1837: ghr_pa_remarks_api.create_pa_remarks (
1838: p_pa_request_id => l_pa_request_id,
1839: p_remark_id => l_remark_id1,
1840: p_description => l_remark_desc1,
1841: p_remark_code_information1 => l_remark1_info1,

Line 1861: ghr_pa_remarks_api.create_pa_remarks (

1857: OPEN val_pa_remarks(p_pa_request_id => l_pa_request_id,
1858: p_remark_id => l_remark_id2);
1859: FETCH val_pa_remarks into m_val_pa_remarks;
1860: IF val_pa_remarks%NOTFOUND THEN
1861: ghr_pa_remarks_api.create_pa_remarks (
1862: p_pa_request_id => l_pa_request_id,
1863: p_remark_id => l_remark_id2,
1864: p_description => l_remark_desc2,
1865: p_remark_code_information1 => l_remark2_info1,

Line 2428: p_remark_id1 OUT NOCOPY ghr_pa_remarks.remark_id%TYPE,

2424: p_first_action_la_code1 IN OUT NOCOPY ghr_pa_requests.first_action_la_code1%TYPE,
2425: p_first_action_la_desc1 IN OUT NOCOPY ghr_pa_requests.first_action_la_desc1%TYPE,
2426: p_first_action_la_code2 IN OUT NOCOPY ghr_pa_requests.first_action_la_code2%TYPE,
2427: p_first_action_la_desc2 IN OUT NOCOPY ghr_pa_requests.first_action_la_desc2%TYPE,
2428: p_remark_id1 OUT NOCOPY ghr_pa_remarks.remark_id%TYPE,
2429: p_remark_desc1 OUT NOCOPY ghr_pa_remarks.description%TYPE,
2430: p_remark1_info1 OUT NOCOPY ghr_pa_remarks.remark_code_information1%TYPE,
2431: p_remark1_info2 OUT NOCOPY ghr_pa_remarks.remark_code_information2%TYPE,
2432: p_remark1_info3 OUT NOCOPY ghr_pa_remarks.remark_code_information3%TYPE,

Line 2429: p_remark_desc1 OUT NOCOPY ghr_pa_remarks.description%TYPE,

2425: p_first_action_la_desc1 IN OUT NOCOPY ghr_pa_requests.first_action_la_desc1%TYPE,
2426: p_first_action_la_code2 IN OUT NOCOPY ghr_pa_requests.first_action_la_code2%TYPE,
2427: p_first_action_la_desc2 IN OUT NOCOPY ghr_pa_requests.first_action_la_desc2%TYPE,
2428: p_remark_id1 OUT NOCOPY ghr_pa_remarks.remark_id%TYPE,
2429: p_remark_desc1 OUT NOCOPY ghr_pa_remarks.description%TYPE,
2430: p_remark1_info1 OUT NOCOPY ghr_pa_remarks.remark_code_information1%TYPE,
2431: p_remark1_info2 OUT NOCOPY ghr_pa_remarks.remark_code_information2%TYPE,
2432: p_remark1_info3 OUT NOCOPY ghr_pa_remarks.remark_code_information3%TYPE,
2433: p_remark_id2 OUT NOCOPY ghr_pa_remarks.remark_id%TYPE,

Line 2430: p_remark1_info1 OUT NOCOPY ghr_pa_remarks.remark_code_information1%TYPE,

2426: p_first_action_la_code2 IN OUT NOCOPY ghr_pa_requests.first_action_la_code2%TYPE,
2427: p_first_action_la_desc2 IN OUT NOCOPY ghr_pa_requests.first_action_la_desc2%TYPE,
2428: p_remark_id1 OUT NOCOPY ghr_pa_remarks.remark_id%TYPE,
2429: p_remark_desc1 OUT NOCOPY ghr_pa_remarks.description%TYPE,
2430: p_remark1_info1 OUT NOCOPY ghr_pa_remarks.remark_code_information1%TYPE,
2431: p_remark1_info2 OUT NOCOPY ghr_pa_remarks.remark_code_information2%TYPE,
2432: p_remark1_info3 OUT NOCOPY ghr_pa_remarks.remark_code_information3%TYPE,
2433: p_remark_id2 OUT NOCOPY ghr_pa_remarks.remark_id%TYPE,
2434: p_remark_desc2 OUT NOCOPY ghr_pa_remarks.description%TYPE,

Line 2431: p_remark1_info2 OUT NOCOPY ghr_pa_remarks.remark_code_information2%TYPE,

2427: p_first_action_la_desc2 IN OUT NOCOPY ghr_pa_requests.first_action_la_desc2%TYPE,
2428: p_remark_id1 OUT NOCOPY ghr_pa_remarks.remark_id%TYPE,
2429: p_remark_desc1 OUT NOCOPY ghr_pa_remarks.description%TYPE,
2430: p_remark1_info1 OUT NOCOPY ghr_pa_remarks.remark_code_information1%TYPE,
2431: p_remark1_info2 OUT NOCOPY ghr_pa_remarks.remark_code_information2%TYPE,
2432: p_remark1_info3 OUT NOCOPY ghr_pa_remarks.remark_code_information3%TYPE,
2433: p_remark_id2 OUT NOCOPY ghr_pa_remarks.remark_id%TYPE,
2434: p_remark_desc2 OUT NOCOPY ghr_pa_remarks.description%TYPE,
2435: p_remark2_info1 OUT NOCOPY ghr_pa_remarks.remark_code_information1%TYPE,

Line 2432: p_remark1_info3 OUT NOCOPY ghr_pa_remarks.remark_code_information3%TYPE,

2428: p_remark_id1 OUT NOCOPY ghr_pa_remarks.remark_id%TYPE,
2429: p_remark_desc1 OUT NOCOPY ghr_pa_remarks.description%TYPE,
2430: p_remark1_info1 OUT NOCOPY ghr_pa_remarks.remark_code_information1%TYPE,
2431: p_remark1_info2 OUT NOCOPY ghr_pa_remarks.remark_code_information2%TYPE,
2432: p_remark1_info3 OUT NOCOPY ghr_pa_remarks.remark_code_information3%TYPE,
2433: p_remark_id2 OUT NOCOPY ghr_pa_remarks.remark_id%TYPE,
2434: p_remark_desc2 OUT NOCOPY ghr_pa_remarks.description%TYPE,
2435: p_remark2_info1 OUT NOCOPY ghr_pa_remarks.remark_code_information1%TYPE,
2436: p_remark2_info2 OUT NOCOPY ghr_pa_remarks.remark_code_information2%TYPE,

Line 2433: p_remark_id2 OUT NOCOPY ghr_pa_remarks.remark_id%TYPE,

2429: p_remark_desc1 OUT NOCOPY ghr_pa_remarks.description%TYPE,
2430: p_remark1_info1 OUT NOCOPY ghr_pa_remarks.remark_code_information1%TYPE,
2431: p_remark1_info2 OUT NOCOPY ghr_pa_remarks.remark_code_information2%TYPE,
2432: p_remark1_info3 OUT NOCOPY ghr_pa_remarks.remark_code_information3%TYPE,
2433: p_remark_id2 OUT NOCOPY ghr_pa_remarks.remark_id%TYPE,
2434: p_remark_desc2 OUT NOCOPY ghr_pa_remarks.description%TYPE,
2435: p_remark2_info1 OUT NOCOPY ghr_pa_remarks.remark_code_information1%TYPE,
2436: p_remark2_info2 OUT NOCOPY ghr_pa_remarks.remark_code_information2%TYPE,
2437: p_remark2_info3 OUT NOCOPY ghr_pa_remarks.remark_code_information3%TYPE

Line 2434: p_remark_desc2 OUT NOCOPY ghr_pa_remarks.description%TYPE,

2430: p_remark1_info1 OUT NOCOPY ghr_pa_remarks.remark_code_information1%TYPE,
2431: p_remark1_info2 OUT NOCOPY ghr_pa_remarks.remark_code_information2%TYPE,
2432: p_remark1_info3 OUT NOCOPY ghr_pa_remarks.remark_code_information3%TYPE,
2433: p_remark_id2 OUT NOCOPY ghr_pa_remarks.remark_id%TYPE,
2434: p_remark_desc2 OUT NOCOPY ghr_pa_remarks.description%TYPE,
2435: p_remark2_info1 OUT NOCOPY ghr_pa_remarks.remark_code_information1%TYPE,
2436: p_remark2_info2 OUT NOCOPY ghr_pa_remarks.remark_code_information2%TYPE,
2437: p_remark2_info3 OUT NOCOPY ghr_pa_remarks.remark_code_information3%TYPE
2438: )

Line 2435: p_remark2_info1 OUT NOCOPY ghr_pa_remarks.remark_code_information1%TYPE,

2431: p_remark1_info2 OUT NOCOPY ghr_pa_remarks.remark_code_information2%TYPE,
2432: p_remark1_info3 OUT NOCOPY ghr_pa_remarks.remark_code_information3%TYPE,
2433: p_remark_id2 OUT NOCOPY ghr_pa_remarks.remark_id%TYPE,
2434: p_remark_desc2 OUT NOCOPY ghr_pa_remarks.description%TYPE,
2435: p_remark2_info1 OUT NOCOPY ghr_pa_remarks.remark_code_information1%TYPE,
2436: p_remark2_info2 OUT NOCOPY ghr_pa_remarks.remark_code_information2%TYPE,
2437: p_remark2_info3 OUT NOCOPY ghr_pa_remarks.remark_code_information3%TYPE
2438: )
2439: IS

Line 2436: p_remark2_info2 OUT NOCOPY ghr_pa_remarks.remark_code_information2%TYPE,

2432: p_remark1_info3 OUT NOCOPY ghr_pa_remarks.remark_code_information3%TYPE,
2433: p_remark_id2 OUT NOCOPY ghr_pa_remarks.remark_id%TYPE,
2434: p_remark_desc2 OUT NOCOPY ghr_pa_remarks.description%TYPE,
2435: p_remark2_info1 OUT NOCOPY ghr_pa_remarks.remark_code_information1%TYPE,
2436: p_remark2_info2 OUT NOCOPY ghr_pa_remarks.remark_code_information2%TYPE,
2437: p_remark2_info3 OUT NOCOPY ghr_pa_remarks.remark_code_information3%TYPE
2438: )
2439: IS
2440: l_eq_pay_plan ghr_pa_requests.from_pay_plan%TYPE;

Line 2437: p_remark2_info3 OUT NOCOPY ghr_pa_remarks.remark_code_information3%TYPE

2433: p_remark_id2 OUT NOCOPY ghr_pa_remarks.remark_id%TYPE,
2434: p_remark_desc2 OUT NOCOPY ghr_pa_remarks.description%TYPE,
2435: p_remark2_info1 OUT NOCOPY ghr_pa_remarks.remark_code_information1%TYPE,
2436: p_remark2_info2 OUT NOCOPY ghr_pa_remarks.remark_code_information2%TYPE,
2437: p_remark2_info3 OUT NOCOPY ghr_pa_remarks.remark_code_information3%TYPE
2438: )
2439: IS
2440: l_eq_pay_plan ghr_pa_requests.from_pay_plan%TYPE;
2441: l_from_pay_plan ghr_pa_requests.from_pay_plan%TYPE;

Line 2444: l_remark_desc1 ghr_pa_remarks.description%TYPE := NULL;

2440: l_eq_pay_plan ghr_pa_requests.from_pay_plan%TYPE;
2441: l_from_pay_plan ghr_pa_requests.from_pay_plan%TYPE;
2442: l_remark_id1 ghr_remarks.remark_id%TYPE;
2443: l_remark_code1 ghr_remarks.code%TYPE := NULL;
2444: l_remark_desc1 ghr_pa_remarks.description%TYPE := NULL;
2445: l_remark_desc1_out ghr_pa_remarks.description%TYPE;
2446: l_remark_code2 ghr_remarks.code%TYPE := NULL;
2447: l_remark_desc2 ghr_pa_remarks.description%TYPE := NULL;
2448: l_remark_desc2_out ghr_pa_remarks.description%TYPE;

Line 2445: l_remark_desc1_out ghr_pa_remarks.description%TYPE;

2441: l_from_pay_plan ghr_pa_requests.from_pay_plan%TYPE;
2442: l_remark_id1 ghr_remarks.remark_id%TYPE;
2443: l_remark_code1 ghr_remarks.code%TYPE := NULL;
2444: l_remark_desc1 ghr_pa_remarks.description%TYPE := NULL;
2445: l_remark_desc1_out ghr_pa_remarks.description%TYPE;
2446: l_remark_code2 ghr_remarks.code%TYPE := NULL;
2447: l_remark_desc2 ghr_pa_remarks.description%TYPE := NULL;
2448: l_remark_desc2_out ghr_pa_remarks.description%TYPE;
2449: l_remark1_ins1 VARCHAR2 (150) := NULL;

Line 2447: l_remark_desc2 ghr_pa_remarks.description%TYPE := NULL;

2443: l_remark_code1 ghr_remarks.code%TYPE := NULL;
2444: l_remark_desc1 ghr_pa_remarks.description%TYPE := NULL;
2445: l_remark_desc1_out ghr_pa_remarks.description%TYPE;
2446: l_remark_code2 ghr_remarks.code%TYPE := NULL;
2447: l_remark_desc2 ghr_pa_remarks.description%TYPE := NULL;
2448: l_remark_desc2_out ghr_pa_remarks.description%TYPE;
2449: l_remark1_ins1 VARCHAR2 (150) := NULL;
2450: l_remark1_ins2 VARCHAR2 (150) := NULL;
2451: l_remark1_ins3 VARCHAR2 (150) := NULL;

Line 2448: l_remark_desc2_out ghr_pa_remarks.description%TYPE;

2444: l_remark_desc1 ghr_pa_remarks.description%TYPE := NULL;
2445: l_remark_desc1_out ghr_pa_remarks.description%TYPE;
2446: l_remark_code2 ghr_remarks.code%TYPE := NULL;
2447: l_remark_desc2 ghr_pa_remarks.description%TYPE := NULL;
2448: l_remark_desc2_out ghr_pa_remarks.description%TYPE;
2449: l_remark1_ins1 VARCHAR2 (150) := NULL;
2450: l_remark1_ins2 VARCHAR2 (150) := NULL;
2451: l_remark1_ins3 VARCHAR2 (150) := NULL;
2452: l_remark2_ins1 VARCHAR2 (150) := NULL;