eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_CNTRCT_FIN_EXTRACT_PVT dependencies on OKL_PARALLEL_PROCESSES

Line 1052: okl_parallel_processes opp,

1048:
1049: FROM
1050: OKC_K_HEADERS_ALL_B chr,
1051: OKL_K_HEADERS khr,
1052: okl_parallel_processes opp,
1053: HR_OPERATING_UNITS hr_org,
1054: OKC_STATUSES_B status,
1055: OKC_STATUSES_TL status_tl,
1056: OKC_K_PARTY_ROLES_B cust_party_roles,

Line 2081: OKL_PARALLEL_PROCESSES opp,

2077:
2078: FROM
2079: OKC_K_HEADERS_ALL_B chr,
2080: OKL_K_HEADERS khr,
2081: OKL_PARALLEL_PROCESSES opp,
2082: HR_OPERATING_UNITS hr_org,
2083: OKC_STATUSES_B status,
2084: OKC_STATUSES_TL status_tl,
2085: OKC_K_PARTY_ROLES_B cust_party_roles,

Line 2500: DELETE OKL_PARALLEL_PROCESSES

2496:
2497: IF lx_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
2498: write_to_log('Extraction failed for Contract Financial Extract.');
2499:
2500: DELETE OKL_PARALLEL_PROCESSES
2501: WHERE assigned_process = p_assigned_process;
2502:
2503: l_del_row_count := sql%rowcount;
2504:

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

2501: WHERE assigned_process = p_assigned_process;
2502:
2503: l_del_row_count := sql%rowcount;
2504:
2505: write_to_log('Deleted '||l_del_row_count||' rows from OKL_PARALLEL_PROCESSES, for assigned process '||p_assigned_process);
2506: COMMIT;
2507:
2508: retcode := 2;
2509: ELSIF lx_return_status = Okl_Api.G_RET_STS_SUCCESS THEN

Line 2513: DELETE OKL_PARALLEL_PROCESSES

2509: ELSIF lx_return_status = Okl_Api.G_RET_STS_SUCCESS THEN
2510: -- purge data
2511: IF p_assigned_process IS NOT NULL THEN
2512:
2513: DELETE OKL_PARALLEL_PROCESSES
2514: WHERE assigned_process = p_assigned_process;
2515:
2516: l_del_row_count := sql%rowcount;
2517: write_to_log('Purged '||l_del_row_count||' rows from OKL_PARALLEL_PROCESSES, for assigned process '||p_assigned_process);

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

2513: DELETE OKL_PARALLEL_PROCESSES
2514: WHERE assigned_process = p_assigned_process;
2515:
2516: l_del_row_count := sql%rowcount;
2517: write_to_log('Purged '||l_del_row_count||' rows from OKL_PARALLEL_PROCESSES, for assigned process '||p_assigned_process);
2518:
2519: COMMIT;
2520:
2521: END IF;

Line 2541: DELETE OKL_PARALLEL_PROCESSES

2537: write_to_log('Unhandled Exception in pull_extract_data_conc '||sqlcode||':'||sqlerrm);
2538:
2539:
2540: IF p_assigned_process IS NOT NULL THEN
2541: DELETE OKL_PARALLEL_PROCESSES
2542: WHERE assigned_process = p_assigned_process;
2543:
2544: write_to_log('Deleted '||sql%rowcount||' rows from OKL_PARALLEL_PROCESSES, for assigned process '||p_assigned_process);
2545:

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

2540: IF p_assigned_process IS NOT NULL THEN
2541: DELETE OKL_PARALLEL_PROCESSES
2542: WHERE assigned_process = p_assigned_process;
2543:
2544: write_to_log('Deleted '||sql%rowcount||' rows from OKL_PARALLEL_PROCESSES, for assigned process '||p_assigned_process);
2545:
2546:
2547: COMMIT;
2548: