APPS.PQP_GB_T1_PENSION_EXTRACTS dependencies on PQP_EXT_CROSS_PERSON_RECORDS

Line 2547: -- rec from pqp_ext_cross_person_records

2543: -- Bugfix 3671727:ENH2
2544: -- Commenting out the cursor call coz the parent
2545: -- request id is not being set in a global in
2546: -- Type 4 code coz its needed to get the master
2547: -- rec from pqp_ext_cross_person_records
2548: /* OPEN csr_request_dets;
2549: FETCH csr_request_dets INTO l_req_dets;
2550: CLOSE csr_request_dets;
2551: */

Line 2556: UPDATE pqp_ext_cross_person_records

2552:
2553: IF pqp_gb_tp_pension_extracts.g_parent_request_id = -1 THEN
2554:
2555: debug(l_proc_name, 20);
2556: UPDATE pqp_ext_cross_person_records
2557: SET processing_status = 'U'
2558: ,request_id = fnd_global.conc_request_id
2559: ,last_updated_by = fnd_global.user_id
2560: ,last_update_date = SYSDATE

Line 10835: FROM pqp_ext_cross_person_records emd

10831: PRAGMA AUTONOMOUS_TRANSACTION;
10832:
10833: CURSOR csr_multirec_person IS
10834: SELECT *
10835: FROM pqp_ext_cross_person_records emd
10836: WHERE emd.record_type = 'X'
10837: AND emd.national_identifier = p_national_identifier
10838: AND emd.ext_dfn_id = ben_ext_thread.g_ext_dfn_id --ENH3
10839: AND emd.lea_number = g_lea_number --ENH3

Line 10864: UPDATE pqp_ext_cross_person_records

10860: IF nvl(l_multirec_per.processing_status,'U') = 'U' THEN
10861: BEGIN -- Attempt an update
10862:
10863: debug(l_proc_name, 20);
10864: UPDATE pqp_ext_cross_person_records
10865: SET business_group_id = p_business_group_id
10866: ,person_id = p_person_id
10867: ,national_identifier = p_national_identifier
10868: ,assignment_id = p_assignment_id

Line 10908: INSERT INTO pqp_ext_cross_person_records

10904: END IF;
10905:
10906: ELSE -- Notfound, Need to insert
10907: debug(l_proc_name, 70);
10908: INSERT INTO pqp_ext_cross_person_records
10909: (record_type
10910: ,ext_dfn_id --ENH3
10911: ,lea_number --ENH3
10912: ,business_group_id

Line 11009: -- pqp_ext_cross_person_records for this persons NI number

11005: -- get processed in the extract for master bg anyway
11006: -- b.2) If not, then we chk if this person is being
11007: -- already processed in another/same extract for cross BG
11008: -- scenario. For this we look for a row in
11009: -- pqp_ext_cross_person_records for this persons NI number
11010: -- i) If row found with 'P', then leave this person
11011: -- ii) If not found or found with NULL or 'U', then we
11012: -- insert/update the row to tell other extracts that
11013: -- mite be running parallely that this person is already