APPS.GHR_MASS_CHANGES dependencies on GHR_REMARKS

Line 27: l_pa_remark_code1 ghr_remarks.code%type;

23: l_proc varchar2(72) := g_package || 'create_sf52_for_mass_changes';
24: l_pa_request_rec ghr_pa_requests%rowtype;
25: l_noa_code ghr_pa_requests.first_noa_code%type;
26: l_scd_leave varchar2(30);
27: l_pa_remark_code1 ghr_remarks.code%type;
28: l_pa_remark_code2 ghr_remarks.code%type;
29: l_1_prh_object_version_number ghr_pa_requests.object_version_number%type;
30: l_1_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%type;
31: l_2_prh_object_version_number ghr_pa_requests.object_version_number%type;

Line 28: l_pa_remark_code2 ghr_remarks.code%type;

24: l_pa_request_rec ghr_pa_requests%rowtype;
25: l_noa_code ghr_pa_requests.first_noa_code%type;
26: l_scd_leave varchar2(30);
27: l_pa_remark_code1 ghr_remarks.code%type;
28: l_pa_remark_code2 ghr_remarks.code%type;
29: l_1_prh_object_version_number ghr_pa_requests.object_version_number%type;
30: l_1_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%type;
31: l_2_prh_object_version_number ghr_pa_requests.object_version_number%type;
32: l_2_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%type;

Line 35: l_remark_id ghr_remarks.remark_id%type;

31: l_2_prh_object_version_number ghr_pa_requests.object_version_number%type;
32: l_2_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%type;
33: l_multiple_error_flag boolean;
34: l_dummy varchar2(30);
35: l_remark_id ghr_remarks.remark_id%type;
36: l_description ghr_remarks.description%type;
37: l_pa_remark_id ghr_pa_remarks.pa_remark_id%type;
38: l_object_version_number ghr_pa_remarks.object_version_number%type;
39: l_message varchar2(2000);

Line 36: l_description ghr_remarks.description%type;

32: l_2_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%type;
33: l_multiple_error_flag boolean;
34: l_dummy varchar2(30);
35: l_remark_id ghr_remarks.remark_id%type;
36: l_description ghr_remarks.description%type;
37: l_pa_remark_id ghr_pa_remarks.pa_remark_id%type;
38: l_object_version_number ghr_pa_remarks.object_version_number%type;
39: l_message varchar2(2000);
40: l_error varchar2(30);

Line 1207: p_remark_code in ghr_remarks.code%type

1203:
1204:
1205: Procedure create_remarks
1206: (p_pa_request_rec in ghr_pa_requests%rowtype,
1207: p_remark_code in ghr_remarks.code%type
1208: )
1209: is
1210:
1211: l_proc varchar2(72) := g_package || 'create_remarks';

Line 1212: l_remark_id ghr_remarks.remark_id%type;

1208: )
1209: is
1210:
1211: l_proc varchar2(72) := g_package || 'create_remarks';
1212: l_remark_id ghr_remarks.remark_id%type;
1213: l_description ghr_pa_remarks.description%type;
1214: -- Bug#4256022 Declared the variable l_description_out
1215: l_description_out ghr_pa_remarks.description%type;
1216: l_remark_code_information1 ghr_pa_remarks.remark_code_information1%type;