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.

[Home] [Help]

APPS.OKL_CNTRCT_FIN_EXTRACT_PVT dependencies on OKL_PARALLEL_PROCESSES

Line 1038: okl_parallel_processes opp,

1034:
1035: FROM
1036: OKC_K_HEADERS_ALL_B chr,
1037: OKL_K_HEADERS khr,
1038: okl_parallel_processes opp,
1039: HR_OPERATING_UNITS hr_org,
1040: OKC_STATUSES_B status,
1041: OKC_STATUSES_TL status_tl,
1042: OKC_K_PARTY_ROLES_B cust_party_roles,

Line 2067: OKL_PARALLEL_PROCESSES opp,

2063:
2064: FROM
2065: OKC_K_HEADERS_ALL_B chr,
2066: OKL_K_HEADERS khr,
2067: OKL_PARALLEL_PROCESSES opp,
2068: HR_OPERATING_UNITS hr_org,
2069: OKC_STATUSES_B status,
2070: OKC_STATUSES_TL status_tl,
2071: OKC_K_PARTY_ROLES_B cust_party_roles,

Line 2486: DELETE OKL_PARALLEL_PROCESSES

2482:
2483: IF lx_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
2484: write_to_log('Extraction failed for Contract Financial Extract.');
2485:
2486: DELETE OKL_PARALLEL_PROCESSES
2487: WHERE assigned_process = p_assigned_process;
2488:
2489: l_del_row_count := sql%rowcount;
2490:

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

2487: WHERE assigned_process = p_assigned_process;
2488:
2489: l_del_row_count := sql%rowcount;
2490:
2491: write_to_log('Deleted '||l_del_row_count||' rows from OKL_PARALLEL_PROCESSES, for assigned process '||p_assigned_process);
2492: COMMIT;
2493:
2494: retcode := 2;
2495: ELSIF lx_return_status = Okl_Api.G_RET_STS_SUCCESS THEN

Line 2499: DELETE OKL_PARALLEL_PROCESSES

2495: ELSIF lx_return_status = Okl_Api.G_RET_STS_SUCCESS THEN
2496: -- purge data
2497: IF p_assigned_process IS NOT NULL THEN
2498:
2499: DELETE OKL_PARALLEL_PROCESSES
2500: WHERE assigned_process = p_assigned_process;
2501:
2502: l_del_row_count := sql%rowcount;
2503: write_to_log('Purged '||l_del_row_count||' rows from OKL_PARALLEL_PROCESSES, for assigned process '||p_assigned_process);

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

2499: DELETE OKL_PARALLEL_PROCESSES
2500: WHERE assigned_process = p_assigned_process;
2501:
2502: l_del_row_count := sql%rowcount;
2503: write_to_log('Purged '||l_del_row_count||' rows from OKL_PARALLEL_PROCESSES, for assigned process '||p_assigned_process);
2504:
2505: COMMIT;
2506:
2507: END IF;

Line 2527: DELETE OKL_PARALLEL_PROCESSES

2523: write_to_log('Unhandled Exception in pull_extract_data_conc '||sqlcode||':'||sqlerrm);
2524:
2525:
2526: IF p_assigned_process IS NOT NULL THEN
2527: DELETE OKL_PARALLEL_PROCESSES
2528: WHERE assigned_process = p_assigned_process;
2529:
2530: write_to_log('Deleted '||sql%rowcount||' rows from OKL_PARALLEL_PROCESSES, for assigned process '||p_assigned_process);
2531:

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

2526: IF p_assigned_process IS NOT NULL THEN
2527: DELETE OKL_PARALLEL_PROCESSES
2528: WHERE assigned_process = p_assigned_process;
2529:
2530: write_to_log('Deleted '||sql%rowcount||' rows from OKL_PARALLEL_PROCESSES, for assigned process '||p_assigned_process);
2531:
2532:
2533: COMMIT;
2534: