APPS.GHR_SF52_UPDATE dependencies on GHR_PA_REMARKS

Line 26: FROM GHR_PA_REMARKS parem,

22: )
23: is
24: CURSOR c1(p_remark_code in varchar2) is
25: SELECT 1
26: FROM GHR_PA_REMARKS parem,
27: GHR_REMARKS grem
28: WHERE parem.remark_id = grem.remark_id
29: AND grem.code = p_remark_code
30: AND parem.pa_request_id = p_pa_request_id;

Line 73: l_pa_remark_id ghr_pa_remarks.pa_remark_id%type;

69:
70: l_proc varchar2(100) := 'Populate_Remarks';
71: l_found varchar2(1);
72: l_remark c2%rowtype;
73: l_pa_remark_id ghr_pa_remarks.pa_remark_id%type;
74: l_object_version_number ghr_pa_remarks.object_version_number%type;
75: l_description ghr_remarks.description%type;
76: l_user_table_name pay_user_tables.user_table_name%type;
77: l_retained_grade_info ghr_pay_calc.retained_grade_rec_type;

Line 74: l_object_version_number ghr_pa_remarks.object_version_number%type;

70: l_proc varchar2(100) := 'Populate_Remarks';
71: l_found varchar2(1);
72: l_remark c2%rowtype;
73: l_pa_remark_id ghr_pa_remarks.pa_remark_id%type;
74: l_object_version_number ghr_pa_remarks.object_version_number%type;
75: l_description ghr_remarks.description%type;
76: l_user_table_name pay_user_tables.user_table_name%type;
77: l_retained_grade_info ghr_pay_calc.retained_grade_rec_type;
78: l_retained_grade varchar2(10);

Line 136: ghr_pa_remarks_api.create_pa_remarks

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

Line 185: ghr_pa_remarks_api.create_pa_remarks

181: open c2(p_remark_code => 'P05');
182: fetch c2 into l_remark;
183: if c2%found then
184:
185: ghr_pa_remarks_api.create_pa_remarks
186: (p_validate => false
187: ,p_pa_request_id => p_pa_request_id
188: ,p_remark_id => l_remark.remark_id
189: ,p_description => l_remark.description

Line 224: ghr_pa_remarks_api.create_pa_remarks

220: p_information5 => NULL,
221: p_desc_out => l_description
222: );
223:
224: ghr_pa_remarks_api.create_pa_remarks
225: (p_validate =>false
226: ,p_pa_request_id => p_pa_request_id
227: ,p_remark_id => l_remark.remark_id
228: ,p_description => l_description

Line 272: ghr_pa_remarks_api.create_pa_remarks

268: open c2(p_remark_code => 'P11');
269: fetch c2 into l_remark;
270: if c2%found then
271:
272: ghr_pa_remarks_api.create_pa_remarks
273: (p_validate => false
274: ,p_pa_request_id => p_pa_request_id
275: ,p_remark_id => l_remark.remark_id
276: ,p_description => l_remark.description

Line 320: ghr_pa_remarks_api.create_pa_remarks

316: open c2(p_remark_code => 'B76');
317: fetch c2 into l_remark;
318: if c2%found then
319:
320: ghr_pa_remarks_api.create_pa_remarks
321: (p_validate => false
322: ,p_pa_request_id => p_pa_request_id
323: ,p_remark_id => l_remark.remark_id
324: ,p_description => l_remark.description