APPS.PQP_GB_TP_EXT_PROCESS dependencies on PQP_EXT_CROSS_PERSON_RECORDS

Line 1493: UPDATE pqp_ext_cross_person_records

1489:
1490: END IF; -- NVL(l_multiproc_data.processing_status, 'U') <> 'P' THEN
1491:
1492: IF l_wait_success THEN
1493: UPDATE pqp_ext_cross_person_records
1494: SET business_group_id = p_business_group_id
1495: ,effective_start_date = p_effective_date
1496: ,request_id = nvl(p_master_request_id, g_master_request_id)
1497: ,processing_status = 'P' -- Processing

Line 1532: INSERT INTO pqp_ext_cross_person_records

1528: ELSE -- NOTFOUND
1529:
1530: -- Not found, insert a new master bg row
1531: -- Bugfix 3671727:ENH1:ENH2 : Added ext_dfn_id and lea_number
1532: INSERT INTO pqp_ext_cross_person_records
1533: (record_type
1534: ,ext_dfn_id
1535: ,lea_number
1536: ,business_group_id

Line 1569: UPDATE pqp_ext_cross_person_records

1565: CLOSE pqp_gb_t1_pension_extracts.csr_multiproc_data;
1566: END IF;
1567:
1568: -- Step 3.2) Updating multiproc data
1569: UPDATE pqp_ext_cross_person_records
1570: SET processing_status = 'U'
1571: ,last_updated_by = fnd_global.user_id
1572: ,last_update_date = SYSDATE
1573: ,last_update_login = fnd_global.login_id

Line 1611: UPDATE pqp_ext_cross_person_records

1607:
1608: -- Error out as the current BG is not an LEA
1609: -- Also, we need to reset the master BG row in multiproc data
1610: -- table to 'E'
1611: UPDATE pqp_ext_cross_person_records
1612: SET processing_status = 'E' -- Error
1613: ,last_updated_by = fnd_global.user_id
1614: ,last_update_date = SYSDATE
1615: ,last_update_login = fnd_global.login_id

Line 2053: UPDATE pqp_ext_cross_person_records

2049: debug('SERIAL:Program Failure, erroring.', 150);
2050: END IF;
2051:
2052: -- First reset the status on multiproc data for master bg row
2053: UPDATE pqp_ext_cross_person_records
2054: SET processing_status = 'E' -- Error
2055: ,last_updated_by = fnd_global.user_id
2056: ,last_update_date = SYSDATE
2057: ,last_update_login = fnd_global.login_id

Line 2136: UPDATE pqp_ext_cross_person_records

2132: debug('PARALLEL:Program Failure, erroring.', 170);
2133: END IF;
2134:
2135: -- First reset the status on multiproc data for master bg row
2136: UPDATE pqp_ext_cross_person_records
2137: SET processing_status = 'E' -- Error
2138: ,last_updated_by = fnd_global.user_id
2139: ,last_update_date = SYSDATE
2140: ,last_update_login = fnd_global.login_id

Line 2172: UPDATE pqp_ext_cross_person_records

2168: END IF; -- End if of collection count > 1 check ...
2169:
2170: -- Step 8) Reset the processing status in master Bg
2171: -- and multiproc rows
2172: UPDATE pqp_ext_cross_person_records
2173: SET processing_status = 'C' -- Completed
2174: ,last_updated_by = fnd_global.user_id
2175: ,last_update_date = SYSDATE
2176: ,last_update_login = fnd_global.login_id

Line 2183: UPDATE pqp_ext_cross_person_records

2179: -- Bugfix 3671727:ENH1:ENH2 : Added these AND clauses
2180: AND ext_dfn_id = p_ext_dfn_id
2181: AND lea_number = g_lea_number;
2182:
2183: UPDATE pqp_ext_cross_person_records
2184: SET processing_status = 'U' -- Back to Unprocessed
2185: ,last_updated_by = fnd_global.user_id
2186: ,last_update_date = SYSDATE
2187: ,last_update_login = fnd_global.login_id

Line 2233: UPDATE pqp_ext_cross_person_records

2229: IF g_debug THEN
2230: debug('Other in :'||l_proc_name, 200);
2231: END IF;
2232: -- First reset the status on multiproc data for master bg row
2233: UPDATE pqp_ext_cross_person_records
2234: SET processing_status = 'E' -- Error
2235: ,last_updated_by = fnd_global.user_id
2236: ,last_update_date = SYSDATE
2237: ,last_update_login = fnd_global.login_id