APPS.GHR_PROCESS_SF52 dependencies on GHR_PA_REMARKS

Line 6915: l_pa_remark_id ghr_pa_remarks.pa_remark_id%type;

6911: l_pa_request_id ghr_pa_requests.pa_request_id%type;
6912: l_sf52_dual_sec_rec ghr_pa_requests%rowtype;
6913: l_sf52_dual_first_rec ghr_pa_requests%rowtype;
6914: l_ovn ghr_pa_requests.object_version_number%type;
6915: l_pa_remark_id ghr_pa_remarks.pa_remark_id%type;
6916: l_object_version_number ghr_pa_remarks.object_version_number%type;
6917: --8737212
6918: l_u_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%TYPE;
6919: l_u_prh_object_version_number ghr_pa_routing_history.object_version_number%TYPE;

Line 6916: l_object_version_number ghr_pa_remarks.object_version_number%type;

6912: l_sf52_dual_sec_rec ghr_pa_requests%rowtype;
6913: l_sf52_dual_first_rec ghr_pa_requests%rowtype;
6914: l_ovn ghr_pa_requests.object_version_number%type;
6915: l_pa_remark_id ghr_pa_remarks.pa_remark_id%type;
6916: l_object_version_number ghr_pa_remarks.object_version_number%type;
6917: --8737212
6918: l_u_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%TYPE;
6919: l_u_prh_object_version_number ghr_pa_routing_history.object_version_number%TYPE;
6920:

Line 6949: from ghr_pa_remarks parem, ghr_remarks rem

6945: parem.remark_code_information2,
6946: parem.remark_code_information3,
6947: parem.remark_code_information4,
6948: parem.remark_code_information5
6949: from ghr_pa_remarks parem, ghr_remarks rem
6950: where parem.pa_request_id = p_sf52_data.pa_request_id
6951: and parem.remark_id = rem.remark_id
6952: and substr(rem.code,1,1) = 'C';
6953: -- 8272695

Line 7007: ghr_pa_remarks_api.create_pa_remarks

7003: -- population of remarks 8272695
7004: for rec_remarks in c_get_remarks
7005: loop
7006:
7007: ghr_pa_remarks_api.create_pa_remarks
7008: (p_validate => false
7009: ,p_pa_request_id => l_pa_request_id
7010: ,p_remark_id => rec_remarks.remark_id
7011: ,p_description => rec_remarks.description