DBA Data[Home] [Help]

APPS.OKL_K_LINE_FIN_EXT_PVT dependencies on OKL_PARALLEL_PROCESSES

Line 1426: okl_parallel_processes opp,

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

Line 3541: okl_parallel_processes opp,

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

Line 5566: okl_parallel_processes opp,

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

Line 6488: DELETE OKL_PARALLEL_PROCESSES

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

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

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

Line 6501: DELETE OKL_PARALLEL_PROCESSES

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

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

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

Line 6529: DELETE OKL_PARALLEL_PROCESSES

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

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

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