APPS.PQP_GB_TP_EXT_PROCESS dependencies on PQP_EXT_CROSS_PERSON_RECORDS

Line 1503: UPDATE pqp_ext_cross_person_records

1499:
1500: END IF; -- NVL(l_multiproc_data.processing_status, 'U') <> 'P' THEN
1501:
1502: IF l_wait_success THEN
1503: UPDATE pqp_ext_cross_person_records
1504: SET business_group_id = p_business_group_id
1505: ,effective_start_date = p_effective_date
1506: ,request_id = nvl(p_master_request_id, g_master_request_id)
1507: ,processing_status = 'P' -- Processing

Line 1542: INSERT INTO pqp_ext_cross_person_records

1538: ELSE -- NOTFOUND
1539:
1540: -- Not found, insert a new master bg row
1541: -- Bugfix 3671727:ENH1:ENH2 : Added ext_dfn_id and lea_number
1542: INSERT INTO pqp_ext_cross_person_records
1543: (record_type
1544: ,ext_dfn_id
1545: ,lea_number
1546: ,business_group_id

Line 1579: UPDATE pqp_ext_cross_person_records

1575: CLOSE pqp_gb_t1_pension_extracts.csr_multiproc_data;
1576: END IF;
1577:
1578: -- Step 3.2) Updating multiproc data
1579: UPDATE pqp_ext_cross_person_records
1580: SET processing_status = 'U'
1581: ,last_updated_by = fnd_global.user_id
1582: ,last_update_date = SYSDATE
1583: ,last_update_login = fnd_global.login_id

Line 1621: UPDATE pqp_ext_cross_person_records

1617:
1618: -- Error out as the current BG is not an LEA
1619: -- Also, we need to reset the master BG row in multiproc data
1620: -- table to 'E'
1621: UPDATE pqp_ext_cross_person_records
1622: SET processing_status = 'E' -- Error
1623: ,last_updated_by = fnd_global.user_id
1624: ,last_update_date = SYSDATE
1625: ,last_update_login = fnd_global.login_id

Line 2063: UPDATE pqp_ext_cross_person_records

2059: debug('SERIAL:Program Failure, erroring.', 150);
2060: END IF;
2061:
2062: -- First reset the status on multiproc data for master bg row
2063: UPDATE pqp_ext_cross_person_records
2064: SET processing_status = 'E' -- Error
2065: ,last_updated_by = fnd_global.user_id
2066: ,last_update_date = SYSDATE
2067: ,last_update_login = fnd_global.login_id

Line 2146: UPDATE pqp_ext_cross_person_records

2142: debug('PARALLEL:Program Failure, erroring.', 170);
2143: END IF;
2144:
2145: -- First reset the status on multiproc data for master bg row
2146: UPDATE pqp_ext_cross_person_records
2147: SET processing_status = 'E' -- Error
2148: ,last_updated_by = fnd_global.user_id
2149: ,last_update_date = SYSDATE
2150: ,last_update_login = fnd_global.login_id

Line 2182: UPDATE pqp_ext_cross_person_records

2178: END IF; -- End if of collection count > 1 check ...
2179:
2180: -- Step 8) Reset the processing status in master Bg
2181: -- and multiproc rows
2182: UPDATE pqp_ext_cross_person_records
2183: SET processing_status = 'C' -- Completed
2184: ,last_updated_by = fnd_global.user_id
2185: ,last_update_date = SYSDATE
2186: ,last_update_login = fnd_global.login_id

Line 2193: UPDATE pqp_ext_cross_person_records

2189: -- Bugfix 3671727:ENH1:ENH2 : Added these AND clauses
2190: AND ext_dfn_id = p_ext_dfn_id
2191: AND lea_number = g_lea_number;
2192:
2193: UPDATE pqp_ext_cross_person_records
2194: SET processing_status = 'U' -- Back to Unprocessed
2195: ,last_updated_by = fnd_global.user_id
2196: ,last_update_date = SYSDATE
2197: ,last_update_login = fnd_global.login_id

Line 2243: UPDATE pqp_ext_cross_person_records

2239: IF g_debug THEN
2240: debug('Other in :'||l_proc_name, 200);
2241: END IF;
2242: -- First reset the status on multiproc data for master bg row
2243: UPDATE pqp_ext_cross_person_records
2244: SET processing_status = 'E' -- Error
2245: ,last_updated_by = fnd_global.user_id
2246: ,last_update_date = SYSDATE
2247: ,last_update_login = fnd_global.login_id