APPS.GHR_SF52_API dependencies on GHR_PA_REMARKS

Line 956: insert into ghr_pa_remarks

952:
953: --2) Write into pa_remarks all mandatory remarks for the specific nature_of_action (first and second)
954:
955: if p_first_noa_id is not null then
956: insert into ghr_pa_remarks
957: (pa_remark_id
958: ,pa_request_id
959: ,remark_id
960: ,description

Line 963: select ghr_pa_remarks_s.nextval

959: ,remark_id
960: ,description
961: ,object_version_number
962: )
963: select ghr_pa_remarks_s.nextval
964: ,l_pa_request_id
965: ,rem.remark_id
966: ,rem.description
967: ,1

Line 983: insert into ghr_pa_remarks

979: -- and nvl(rem.date_to,l_effective_date));
980: end if;
981:
982: if p_second_noa_id is not null then
983: insert into ghr_pa_remarks
984: (pa_remark_id
985: ,pa_request_id
986: ,remark_id
987: ,description

Line 990: select ghr_pa_remarks_s.nextval

986: ,remark_id
987: ,description
988: ,object_version_number
989: )
990: select ghr_pa_remarks_s.nextval
991: ,l_pa_request_id
992: ,rem.remark_id
993: ,rem.description
994: ,1

Line 2991: delete from ghr_pa_remarks pre

2987: <> nvl(ghr_par_shd.g_old_rec.first_noa_id,hr_api.g_number) then
2988: hr_utility.set_location(l_proc, 9);
2989:
2990: -- delete the existing remarks
2991: delete from ghr_pa_remarks pre
2992: where pre.pa_request_id = p_pa_request_id
2993: and pre.remark_id in
2994: (select remark_id
2995: from ghr_noac_remarks

Line 3000: insert into ghr_pa_remarks

2996: where nature_of_action_id = ghr_par_shd.g_old_rec.first_noa_id);
2997: if p_first_noa_id is not null then
2998: hr_utility.set_location(l_proc, 10);
2999:
3000: insert into ghr_pa_remarks
3001: (pa_remark_id
3002: ,pa_request_id
3003: ,remark_id
3004: ,description

Line 3007: select ghr_pa_remarks_s.nextval

3003: ,remark_id
3004: ,description
3005: ,object_version_number
3006: )
3007: select ghr_pa_remarks_s.nextval
3008: ,p_pa_request_id
3009: ,rem.remark_id
3010: ,rem.description
3011: ,1

Line 3031: delete from ghr_pa_remarks pre

3027: if nvl(p_second_noa_id,hr_api.g_number)
3028: <> nvl(ghr_par_shd.g_old_rec.second_noa_id,hr_api.g_number) then
3029:
3030: -- delete the existing remarks
3031: delete from ghr_pa_remarks pre
3032: where pre.pa_request_id = p_pa_request_id
3033: and pre.remark_id in
3034: (select remark_id
3035: from ghr_noac_remarks

Line 3038: insert into ghr_pa_remarks

3034: (select remark_id
3035: from ghr_noac_remarks
3036: where nature_of_action_id = ghr_par_shd.g_old_rec.second_noa_id);
3037: if p_second_noa_id is not null then
3038: insert into ghr_pa_remarks
3039: (pa_remark_id
3040: ,pa_request_id
3041: ,remark_id
3042: ,description

Line 3045: select ghr_pa_remarks_s.nextval

3041: ,remark_id
3042: ,description
3043: ,object_version_number
3044: )
3045: select ghr_pa_remarks_s.nextval
3046: ,p_pa_request_id
3047: ,rem.remark_id
3048: ,rem.description
3049: ,1