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

Line 980: insert into ghr_pa_remarks

976:
977: --2) Write into pa_remarks all mandatory remarks for the specific nature_of_action (first and second)
978:
979: if p_first_noa_id is not null then
980: insert into ghr_pa_remarks
981: (pa_remark_id
982: ,pa_request_id
983: ,remark_id
984: ,description

Line 987: select ghr_pa_remarks_s.nextval

983: ,remark_id
984: ,description
985: ,object_version_number
986: )
987: select ghr_pa_remarks_s.nextval
988: ,l_pa_request_id
989: ,rem.remark_id
990: ,rem.description
991: ,1

Line 1018: insert into ghr_pa_remarks

1014: END IF;
1015: -- Bug# 7174094 added l_separation_flag condition in below if condition
1016: if p_second_noa_id is not null AND NOT( l_separation_flag AND p_first_noa_code in ('002'))then
1017: --End Bug# 7174094
1018: insert into ghr_pa_remarks
1019: (pa_remark_id
1020: ,pa_request_id
1021: ,remark_id
1022: ,description

Line 1025: select ghr_pa_remarks_s.nextval

1021: ,remark_id
1022: ,description
1023: ,object_version_number
1024: )
1025: select ghr_pa_remarks_s.nextval
1026: ,l_pa_request_id
1027: ,rem.remark_id
1028: ,rem.description
1029: ,1

Line 3135: delete from ghr_pa_remarks pre

3131: <> nvl(ghr_par_shd.g_old_rec.first_noa_id,hr_api.g_number) then
3132: hr_utility.set_location(l_proc, 9);
3133:
3134: -- delete the existing remarks
3135: delete from ghr_pa_remarks pre
3136: where pre.pa_request_id = p_pa_request_id
3137: and pre.remark_id in
3138: (select remark_id
3139: from ghr_noac_remarks

Line 3144: insert into ghr_pa_remarks

3140: where nature_of_action_id = ghr_par_shd.g_old_rec.first_noa_id);
3141: if p_first_noa_id is not null then
3142: hr_utility.set_location(l_proc, 10);
3143:
3144: insert into ghr_pa_remarks
3145: (pa_remark_id
3146: ,pa_request_id
3147: ,remark_id
3148: ,description

Line 3151: select ghr_pa_remarks_s.nextval

3147: ,remark_id
3148: ,description
3149: ,object_version_number
3150: )
3151: select ghr_pa_remarks_s.nextval
3152: ,p_pa_request_id
3153: ,rem.remark_id
3154: ,rem.description
3155: ,1

Line 3175: delete from ghr_pa_remarks pre

3171: if nvl(p_second_noa_id,hr_api.g_number)
3172: <> nvl(ghr_par_shd.g_old_rec.second_noa_id,hr_api.g_number) then
3173:
3174: -- delete the existing remarks
3175: delete from ghr_pa_remarks pre
3176: where pre.pa_request_id = p_pa_request_id
3177: and pre.remark_id in
3178: (select remark_id
3179: from ghr_noac_remarks

Line 3193: insert into ghr_pa_remarks

3189: END IF;
3190: -- Bug# 7174094 added l_separation_flag condition in below if condition
3191: if p_second_noa_id is not null AND NOT( l_separation_flag AND p_first_noa_code in ('002'))then
3192: --End Bug# 7174094
3193: insert into ghr_pa_remarks
3194: (pa_remark_id
3195: ,pa_request_id
3196: ,remark_id
3197: ,description

Line 3200: select ghr_pa_remarks_s.nextval

3196: ,remark_id
3197: ,description
3198: ,object_version_number
3199: )
3200: select ghr_pa_remarks_s.nextval
3201: ,p_pa_request_id
3202: ,rem.remark_id
3203: ,rem.description
3204: ,1

Line 5013: l_pa_remark_id ghr_pa_remarks.pa_remark_id%type;

5009:
5010: l_proc varchar2(72) := g_package || 'update_detail_remarks';
5011: l_remark_id ghr_remarks.remark_id%type;
5012: l_remark_description ghr_remarks.description%type;
5013: l_pa_remark_id ghr_pa_remarks.pa_remark_id%type;
5014: l_rem_ovn ghr_pa_remarks.OBJECT_VERSION_NUMBER%type;
5015: l_remk_desc ghr_pa_remarks.description%type;
5016:
5017: cursor cur_get_detail_info is

Line 5014: l_rem_ovn ghr_pa_remarks.OBJECT_VERSION_NUMBER%type;

5010: l_proc varchar2(72) := g_package || 'update_detail_remarks';
5011: l_remark_id ghr_remarks.remark_id%type;
5012: l_remark_description ghr_remarks.description%type;
5013: l_pa_remark_id ghr_pa_remarks.pa_remark_id%type;
5014: l_rem_ovn ghr_pa_remarks.OBJECT_VERSION_NUMBER%type;
5015: l_remk_desc ghr_pa_remarks.description%type;
5016:
5017: cursor cur_get_detail_info is
5018: SELECT rei_information13 Organization,

Line 5015: l_remk_desc ghr_pa_remarks.description%type;

5011: l_remark_id ghr_remarks.remark_id%type;
5012: l_remark_description ghr_remarks.description%type;
5013: l_pa_remark_id ghr_pa_remarks.pa_remark_id%type;
5014: l_rem_ovn ghr_pa_remarks.OBJECT_VERSION_NUMBER%type;
5015: l_remk_desc ghr_pa_remarks.description%type;
5016:
5017: cursor cur_get_detail_info is
5018: SELECT rei_information13 Organization,
5019: rei_information5 position_id,

Line 5045: object_version_number from ghr_pa_remarks

5041: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
5042:
5043: cursor c_remk_desc is
5044: select description,pa_remark_id,
5045: object_version_number from ghr_pa_remarks
5046: where remark_id =l_remark_id
5047: and pa_request_id = p_pa_request_id;
5048:
5049:

Line 5088: delete from ghr_pa_remarks

5084: l_pa_remark_id := c_remk_desc_rec.pa_remark_id;
5085: l_rem_ovn := c_remk_desc_rec.object_version_number;
5086: END LOOP;
5087: IF l_detail_org IS NULL AND l_pa_remark_id IS NOT NULL THEN
5088: delete from ghr_pa_remarks
5089: where pa_remark_id = l_pa_remark_id;
5090: ELSIF l_pa_remark_id IS NULL AND l_detail_org IS NOT NULL THEN
5091: ghr_pa_remarks_api.create_pa_remarks
5092: (

Line 5091: ghr_pa_remarks_api.create_pa_remarks

5087: IF l_detail_org IS NULL AND l_pa_remark_id IS NOT NULL THEN
5088: delete from ghr_pa_remarks
5089: where pa_remark_id = l_pa_remark_id;
5090: ELSIF l_pa_remark_id IS NULL AND l_detail_org IS NOT NULL THEN
5091: ghr_pa_remarks_api.create_pa_remarks
5092: (
5093: p_PA_REQUEST_ID => p_pa_request_id,
5094: p_REMARK_ID => l_remark_id,
5095: p_DESCRIPTION => l_remark_description,

Line 5100: ghr_pa_remarks_api.update_pa_remarks

5096: P_PA_REMARK_ID => l_pa_remark_id,
5097: p_remark_code_information1 => l_detail_org, --Bug# 12683854
5098: p_OBJECT_VERSION_NUMBER => l_rem_ovn);
5099: ELSIF l_pa_remark_id IS NOT NULL AND NVL(l_remk_desc,'@@') <> l_remark_description THEN
5100: ghr_pa_remarks_api.update_pa_remarks
5101: (p_pa_remark_id => l_pa_remark_id
5102: ,p_object_version_number => l_rem_ovn
5103: ,p_remark_code_information1 => l_detail_org--Bug# 12683854
5104: ,p_remark_code_information2 => NULL

Line 5133: delete from ghr_pa_remarks

5129: l_pa_remark_id := c_remk_desc_rec.pa_remark_id;
5130: l_rem_ovn := c_remk_desc_rec.object_version_number;
5131: END LOOP;
5132: IF l_detail_position_id IS NULL AND l_pa_remark_id IS NOT NULL THEN
5133: delete from ghr_pa_remarks
5134: where pa_remark_id = l_pa_remark_id;
5135: ELSIF l_pa_remark_id IS NULL AND l_detail_position_id IS NOT NULL THEN
5136: ghr_pa_remarks_api.create_pa_remarks
5137: (

Line 5136: ghr_pa_remarks_api.create_pa_remarks

5132: IF l_detail_position_id IS NULL AND l_pa_remark_id IS NOT NULL THEN
5133: delete from ghr_pa_remarks
5134: where pa_remark_id = l_pa_remark_id;
5135: ELSIF l_pa_remark_id IS NULL AND l_detail_position_id IS NOT NULL THEN
5136: ghr_pa_remarks_api.create_pa_remarks
5137: (
5138: p_PA_REQUEST_ID => p_pa_request_id,
5139: p_REMARK_ID => l_remark_id,
5140: p_DESCRIPTION => l_remark_description,

Line 5145: ghr_pa_remarks_api.update_pa_remarks

5141: P_PA_REMARK_ID => l_pa_remark_id,
5142: p_remark_code_information1 => l_detail_position_name, --Bug# 12683854
5143: p_OBJECT_VERSION_NUMBER => l_rem_ovn);
5144: ELSIF l_pa_remark_id IS NOT NULL AND NVL(l_remk_desc,'@@') <> l_remark_description THEN
5145: ghr_pa_remarks_api.update_pa_remarks
5146: (p_pa_remark_id => l_pa_remark_id
5147: ,p_object_version_number => l_rem_ovn
5148: ,p_remark_code_information1 => l_detail_position_name --Bug# 12683854
5149: ,p_remark_code_information2 => NULL

Line 5180: delete from ghr_pa_remarks

5176: l_pa_remark_id := c_remk_desc_rec.pa_remark_id;
5177: l_rem_ovn := c_remk_desc_rec.object_version_number;
5178: END LOOP;
5179: IF l_pa_remark_id is NOT NULL AND l_detail_pay_plan IS NULL THEN
5180: delete from ghr_pa_remarks
5181: where pa_remark_id = l_pa_remark_id;
5182: ELSIF l_pa_remark_id is NULL AND l_detail_pay_plan IS NOT NULL THEN
5183: ghr_pa_remarks_api.create_pa_remarks
5184: (

Line 5183: ghr_pa_remarks_api.create_pa_remarks

5179: IF l_pa_remark_id is NOT NULL AND l_detail_pay_plan IS NULL THEN
5180: delete from ghr_pa_remarks
5181: where pa_remark_id = l_pa_remark_id;
5182: ELSIF l_pa_remark_id is NULL AND l_detail_pay_plan IS NOT NULL THEN
5183: ghr_pa_remarks_api.create_pa_remarks
5184: (
5185: p_PA_REQUEST_ID => p_pa_request_id,
5186: p_REMARK_ID => l_remark_id,
5187: p_DESCRIPTION => l_remark_description,

Line 5193: ghr_pa_remarks_api.update_pa_remarks

5189: p_remark_code_information1 => l_detail_pay_plan, --Bug# 12683854
5190: p_OBJECT_VERSION_NUMBER => l_rem_ovn);
5191:
5192: ELSIF l_pa_remark_id IS NOT NULL AND NVL(l_remk_desc,'@@') <> l_remark_description THEN
5193: ghr_pa_remarks_api.update_pa_remarks
5194: (p_pa_remark_id => l_pa_remark_id
5195: ,p_object_version_number => l_rem_ovn
5196: ,p_remark_code_information1 => l_detail_pay_plan--Bug# 12683854
5197: ,p_remark_code_information2 => NULL

Line 5223: delete from ghr_pa_remarks

5219: l_pa_remark_id := c_remk_desc_rec.pa_remark_id;
5220: l_rem_ovn := c_remk_desc_rec.object_version_number;
5221: END LOOP;
5222: IF l_pa_remark_id IS NOT NULL AND l_detail_grade IS NULL THEN
5223: delete from ghr_pa_remarks
5224: where pa_remark_id = l_pa_remark_id;
5225: ELSIF l_pa_remark_id IS NULL AND l_detail_grade IS NOT NULL THEN
5226: ghr_pa_remarks_api.create_pa_remarks
5227: (

Line 5226: ghr_pa_remarks_api.create_pa_remarks

5222: IF l_pa_remark_id IS NOT NULL AND l_detail_grade IS NULL THEN
5223: delete from ghr_pa_remarks
5224: where pa_remark_id = l_pa_remark_id;
5225: ELSIF l_pa_remark_id IS NULL AND l_detail_grade IS NOT NULL THEN
5226: ghr_pa_remarks_api.create_pa_remarks
5227: (
5228: p_PA_REQUEST_ID => p_pa_request_id,
5229: p_REMARK_ID => l_remark_id,
5230: p_DESCRIPTION => l_remark_description,

Line 5235: ghr_pa_remarks_api.update_pa_remarks

5231: P_PA_REMARK_ID => l_pa_remark_id,
5232: p_remark_code_information1 => l_detail_grade, --Bug# 12683854
5233: p_OBJECT_VERSION_NUMBER => l_rem_ovn);
5234: ELSIF l_pa_remark_id IS NOT NULL AND NVL(l_remk_desc,'@@') <> l_remark_description THEN
5235: ghr_pa_remarks_api.update_pa_remarks
5236: (p_pa_remark_id => l_pa_remark_id
5237: ,p_object_version_number => l_rem_ovn
5238: ,p_remark_code_information1 => l_detail_grade--Bug# 12683854
5239: ,p_remark_code_information2 => NULL

Line 5267: delete from ghr_pa_remarks

5263: l_pa_remark_id := c_remk_desc_rec.pa_remark_id;
5264: l_rem_ovn := c_remk_desc_rec.object_version_number;
5265: END LOOP;
5266: IF l_pa_remark_id IS NOT NULL AND l_detail_job_id IS NULL THEN
5267: delete from ghr_pa_remarks
5268: where pa_remark_id = l_pa_remark_id;
5269: ELSIF l_pa_remark_id IS NULL AND l_detail_job_id IS NOT NULL THEN
5270: ghr_pa_remarks_api.create_pa_remarks
5271: (

Line 5270: ghr_pa_remarks_api.create_pa_remarks

5266: IF l_pa_remark_id IS NOT NULL AND l_detail_job_id IS NULL THEN
5267: delete from ghr_pa_remarks
5268: where pa_remark_id = l_pa_remark_id;
5269: ELSIF l_pa_remark_id IS NULL AND l_detail_job_id IS NOT NULL THEN
5270: ghr_pa_remarks_api.create_pa_remarks
5271: (
5272: p_PA_REQUEST_ID => p_pa_request_id,
5273: p_REMARK_ID => l_remark_id,
5274: p_DESCRIPTION => l_remark_description,

Line 5279: ghr_pa_remarks_api.update_pa_remarks

5275: P_PA_REMARK_ID => l_pa_remark_id,
5276: p_remark_code_information1 => l_detail_job, --Bug# 12683854
5277: p_OBJECT_VERSION_NUMBER => l_rem_ovn);
5278: ELSIF l_pa_remark_id IS NOT NULL AND NVL(l_remk_desc,'@@') <> l_remark_description THEN
5279: ghr_pa_remarks_api.update_pa_remarks
5280: (p_pa_remark_id => l_pa_remark_id
5281: ,p_object_version_number => l_rem_ovn
5282: ,p_remark_code_information1 => l_detail_job --Bug# 12683854
5283: ,p_remark_code_information2 => NULL

Line 5310: delete from ghr_pa_remarks

5306: l_pa_remark_id := c_remk_desc_rec.pa_remark_id;
5307: l_rem_ovn := c_remk_desc_rec.object_version_number;
5308: END LOOP;
5309: IF l_pa_remark_id IS NOT NULL AND l_detail_location_id IS NULL THEN
5310: delete from ghr_pa_remarks
5311: where pa_remark_id = l_pa_remark_id;
5312: ELSIF l_pa_remark_id IS NULL AND l_detail_location_id IS NOT NULL THEN
5313: ghr_pa_remarks_api.create_pa_remarks
5314: (

Line 5313: ghr_pa_remarks_api.create_pa_remarks

5309: IF l_pa_remark_id IS NOT NULL AND l_detail_location_id IS NULL THEN
5310: delete from ghr_pa_remarks
5311: where pa_remark_id = l_pa_remark_id;
5312: ELSIF l_pa_remark_id IS NULL AND l_detail_location_id IS NOT NULL THEN
5313: ghr_pa_remarks_api.create_pa_remarks
5314: (
5315: p_PA_REQUEST_ID => p_pa_request_id,
5316: p_REMARK_ID => l_remark_id,
5317: p_DESCRIPTION => l_remark_description,

Line 5322: ghr_pa_remarks_api.update_pa_remarks

5318: P_PA_REMARK_ID => l_pa_remark_id,
5319: p_remark_code_information1 => l_detail_location, --Bug# 12683854
5320: p_OBJECT_VERSION_NUMBER => l_rem_ovn);
5321: ELSIF l_pa_remark_id IS NOT NULL AND NVL(l_remk_desc,'@@') <> l_remark_description THEN
5322: ghr_pa_remarks_api.update_pa_remarks
5323: (p_pa_remark_id => l_pa_remark_id
5324: ,p_object_version_number => l_rem_ovn
5325: ,p_remark_code_information1 => l_detail_location --Bug# 12683854
5326: ,p_remark_code_information2 => NULL