APPS.PQP_GB_T1_PENSION_EXTRACTS dependencies on PQP_EXT_CROSS_PERSON_RECORDS

Line 2575: -- rec from pqp_ext_cross_person_records

2571: -- Bugfix 3671727:ENH2
2572: -- Commenting out the cursor call coz the parent
2573: -- request id is not being set in a global in
2574: -- Type 4 code coz its needed to get the master
2575: -- rec from pqp_ext_cross_person_records
2576: /* OPEN csr_request_dets;
2577: FETCH csr_request_dets INTO l_req_dets;
2578: CLOSE csr_request_dets;
2579: */

Line 2584: UPDATE pqp_ext_cross_person_records

2580:
2581: IF pqp_gb_tp_pension_extracts.g_parent_request_id = -1 THEN
2582:
2583: debug(l_proc_name, 20);
2584: UPDATE pqp_ext_cross_person_records
2585: SET processing_status = 'U'
2586: ,request_id = fnd_global.conc_request_id
2587: ,last_updated_by = fnd_global.user_id
2588: ,last_update_date = SYSDATE

Line 11032: FROM pqp_ext_cross_person_records emd

11028: PRAGMA AUTONOMOUS_TRANSACTION;
11029:
11030: CURSOR csr_multirec_person IS
11031: SELECT *
11032: FROM pqp_ext_cross_person_records emd
11033: WHERE emd.record_type = 'X'
11034: AND emd.national_identifier = p_national_identifier
11035: AND emd.ext_dfn_id = ben_ext_thread.g_ext_dfn_id --ENH3
11036: AND emd.lea_number = g_lea_number --ENH3

Line 11061: UPDATE pqp_ext_cross_person_records

11057: IF nvl(l_multirec_per.processing_status,'U') = 'U' THEN
11058: BEGIN -- Attempt an update
11059:
11060: debug(l_proc_name, 20);
11061: UPDATE pqp_ext_cross_person_records
11062: SET business_group_id = p_business_group_id
11063: ,person_id = p_person_id
11064: ,national_identifier = p_national_identifier
11065: ,assignment_id = p_assignment_id

Line 11105: INSERT INTO pqp_ext_cross_person_records

11101: END IF;
11102:
11103: ELSE -- Notfound, Need to insert
11104: debug(l_proc_name, 70);
11105: INSERT INTO pqp_ext_cross_person_records
11106: (record_type
11107: ,ext_dfn_id --ENH3
11108: ,lea_number --ENH3
11109: ,business_group_id

Line 11206: -- pqp_ext_cross_person_records for this persons NI number

11202: -- get processed in the extract for master bg anyway
11203: -- b.2) If not, then we chk if this person is being
11204: -- already processed in another/same extract for cross BG
11205: -- scenario. For this we look for a row in
11206: -- pqp_ext_cross_person_records for this persons NI number
11207: -- i) If row found with 'P', then leave this person
11208: -- ii) If not found or found with NULL or 'U', then we
11209: -- insert/update the row to tell other extracts that
11210: -- mite be running parallely that this person is already