132: );
133:
134: hr_utility.set_location('l_description ' || l_description, 40);
135:
136: ghr_pa_remarks_api.create_pa_remarks
137: (p_validate => false
138: ,p_pa_request_id => p_pa_request_id
139: ,p_remark_id => l_remark.remark_id
140: ,p_description => l_description
182: open c2(p_remark_code => 'P05');
183: fetch c2 into l_remark;
184: if c2%found then
185:
186: ghr_pa_remarks_api.create_pa_remarks
187: (p_validate => false
188: ,p_pa_request_id => p_pa_request_id
189: ,p_remark_id => l_remark.remark_id
190: ,p_description => l_remark.description
221: p_information5 => NULL,
222: p_desc_out => l_description
223: );
224:
225: ghr_pa_remarks_api.create_pa_remarks
226: (p_validate =>false
227: ,p_pa_request_id => p_pa_request_id
228: ,p_remark_id => l_remark.remark_id
229: ,p_description => l_description
269: open c2(p_remark_code => 'P11');
270: fetch c2 into l_remark;
271: if c2%found then
272:
273: ghr_pa_remarks_api.create_pa_remarks
274: (p_validate => false
275: ,p_pa_request_id => p_pa_request_id
276: ,p_remark_id => l_remark.remark_id
277: ,p_description => l_remark.description
317: open c2(p_remark_code => 'B76');
318: fetch c2 into l_remark;
319: if c2%found then
320:
321: ghr_pa_remarks_api.create_pa_remarks
322: (p_validate => false
323: ,p_pa_request_id => p_pa_request_id
324: ,p_remark_id => l_remark.remark_id
325: ,p_description => l_remark.description