APPS.OKL_K_LINE_FIN_EXT_PVT dependencies on OKL_PARALLEL_PROCESSES

Line 1425: okl_parallel_processes opp,

1421:
1422: FROM
1423: OKC_K_HEADERS_ALL_B chr,
1424: OKL_K_HEADERS khr,
1425: okl_parallel_processes opp,
1426: HR_OPERATING_UNITS hr_org,
1427: OKC_STATUSES_B status,
1428: OKC_STATUSES_TL status_tl,
1429: OKC_K_PARTY_ROLES_B cust_party_roles,

Line 3540: okl_parallel_processes opp,

3536:
3537: FROM
3538: OKC_K_HEADERS_ALL_B chr,
3539: OKL_K_HEADERS khr,
3540: okl_parallel_processes opp,
3541: HR_OPERATING_UNITS hr_org,
3542: OKC_STATUSES_B status,
3543: OKC_STATUSES_TL status_tl,
3544: OKC_K_PARTY_ROLES_B cust_party_roles,

Line 5565: okl_parallel_processes opp,

5561:
5562: FROM
5563: OKC_K_HEADERS_ALL_B chr,
5564: OKL_K_HEADERS khr,
5565: okl_parallel_processes opp,
5566: HR_OPERATING_UNITS hr_org,
5567: OKC_STATUSES_B status,
5568: OKC_STATUSES_TL status_tl,
5569: OKC_K_PARTY_ROLES_B cust_party_roles,

Line 6487: DELETE OKL_PARALLEL_PROCESSES

6483:
6484: IF lx_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
6485: write_to_log('Extraction failed for Contract Line Financial Extract.');
6486:
6487: DELETE OKL_PARALLEL_PROCESSES
6488: WHERE assigned_process = p_assigned_process;
6489:
6490: l_del_row_count := sql%rowcount;
6491:

Line 6492: write_to_log('Deleted '||l_del_row_count||' rows from OKL_PARALLEL_PROCESSES, for assigned process '||p_assigned_process);

6488: WHERE assigned_process = p_assigned_process;
6489:
6490: l_del_row_count := sql%rowcount;
6491:
6492: write_to_log('Deleted '||l_del_row_count||' rows from OKL_PARALLEL_PROCESSES, for assigned process '||p_assigned_process);
6493: COMMIT;
6494:
6495: retcode := 2;
6496: ELSIF lx_return_status = Okl_Api.G_RET_STS_SUCCESS THEN

Line 6500: DELETE OKL_PARALLEL_PROCESSES

6496: ELSIF lx_return_status = Okl_Api.G_RET_STS_SUCCESS THEN
6497: -- purge data
6498: IF p_assigned_process IS NOT NULL THEN
6499:
6500: DELETE OKL_PARALLEL_PROCESSES
6501: WHERE assigned_process = p_assigned_process;
6502:
6503: l_del_row_count := sql%rowcount;
6504: write_to_log('Purged '||l_del_row_count||' rows from OKL_PARALLEL_PROCESSES, for assigned process '||p_assigned_process);

Line 6504: write_to_log('Purged '||l_del_row_count||' rows from OKL_PARALLEL_PROCESSES, for assigned process '||p_assigned_process);

6500: DELETE OKL_PARALLEL_PROCESSES
6501: WHERE assigned_process = p_assigned_process;
6502:
6503: l_del_row_count := sql%rowcount;
6504: write_to_log('Purged '||l_del_row_count||' rows from OKL_PARALLEL_PROCESSES, for assigned process '||p_assigned_process);
6505:
6506: COMMIT;
6507:
6508: END IF;

Line 6528: DELETE OKL_PARALLEL_PROCESSES

6524: write_to_log('Unhandled Exception in pull_extract_data_conc '||sqlcode||':'||sqlerrm);
6525:
6526:
6527: IF p_assigned_process IS NOT NULL THEN
6528: DELETE OKL_PARALLEL_PROCESSES
6529: WHERE assigned_process = p_assigned_process;
6530:
6531: write_to_log('Deleted '||sql%rowcount||' rows from OKL_PARALLEL_PROCESSES, for assigned process '||p_assigned_process);
6532:

Line 6531: write_to_log('Deleted '||sql%rowcount||' rows from OKL_PARALLEL_PROCESSES, for assigned process '||p_assigned_process);

6527: IF p_assigned_process IS NOT NULL THEN
6528: DELETE OKL_PARALLEL_PROCESSES
6529: WHERE assigned_process = p_assigned_process;
6530:
6531: write_to_log('Deleted '||sql%rowcount||' rows from OKL_PARALLEL_PROCESSES, for assigned process '||p_assigned_process);
6532:
6533:
6534: COMMIT;
6535: