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 186: ghr_pa_remarks_api.create_pa_remarks

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

Line 225: ghr_pa_remarks_api.create_pa_remarks

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

Line 273: ghr_pa_remarks_api.create_pa_remarks

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

Line 321: ghr_pa_remarks_api.create_pa_remarks

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