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_SLA_ACC_SOURCES_PVT dependencies on OKL_PARALLEL_PROCESSES

Line 8079: ,okl_parallel_processes opp

8075: ,fa_dep.asset_id asset_id
8076: FROM fa_deprn_summary fa_dep
8077: ,okc_k_items okc_item
8078: ,okc_k_lines_b ast
8079: ,okl_parallel_processes opp
8080: WHERE fa_dep.book_type_code = p_book_type_code
8081: AND fa_dep.period_counter = p_period_counter
8082: AND fa_dep.deprn_source_code = 'DEPRN'
8083: AND fa_dep.deprn_run_id IS NOT NULL

Line 8282: DELETE OKL_PARALLEL_PROCESSES

8278: END LOOP; -- Loop on get_okl_assets_csr
8279: CLOSE get_okl_assets_csr; -- Close the Cursor
8280: -- Now Delete all the processed records from parallel process table
8281: FORALL khr_index IN l_khr_id_tbl.FIRST .. l_khr_id_tbl.LAST
8282: DELETE OKL_PARALLEL_PROCESSES
8283: WHERE khr_id = l_khr_id_tbl(khr_index);
8284: -- Return the Proper Return status
8285: retcode := 0; -- 0 Indicates 'S'uccess Status
8286: EXCEPTION

Line 8529: -- Bulk Insert all the records into the OKL_PARALLEL_PROCESSES

8525: l_volume_tbl(dep_index) := l_deprn_contracts_tbl(dep_index).no_of_assets;
8526: l_assigned_process_tbl(dep_index) := TO_CHAR(l_seq_next);
8527: END LOOP;
8528: log_msg(FND_FILE.LOG, 'Successfully Populated the Individual Collection Tables object_value, khr_id, volume tables');
8529: -- Bulk Insert all the records into the OKL_PARALLEL_PROCESSES
8530: log_msg(FND_FILE.LOG, 'Before calling the Bulk Insert into the OKL_PARALLEL_PROCESSES' );
8531: FORALL dep_index IN l_deprn_contracts_tbl.FIRST .. l_deprn_contracts_tbl.LAST
8532: INSERT INTO OKL_PARALLEL_PROCESSES (
8533: OBJECT_TYPE

Line 8530: log_msg(FND_FILE.LOG, 'Before calling the Bulk Insert into the OKL_PARALLEL_PROCESSES' );

8526: l_assigned_process_tbl(dep_index) := TO_CHAR(l_seq_next);
8527: END LOOP;
8528: log_msg(FND_FILE.LOG, 'Successfully Populated the Individual Collection Tables object_value, khr_id, volume tables');
8529: -- Bulk Insert all the records into the OKL_PARALLEL_PROCESSES
8530: log_msg(FND_FILE.LOG, 'Before calling the Bulk Insert into the OKL_PARALLEL_PROCESSES' );
8531: FORALL dep_index IN l_deprn_contracts_tbl.FIRST .. l_deprn_contracts_tbl.LAST
8532: INSERT INTO OKL_PARALLEL_PROCESSES (
8533: OBJECT_TYPE
8534: ,OBJECT_VALUE

Line 8532: INSERT INTO OKL_PARALLEL_PROCESSES (

8528: log_msg(FND_FILE.LOG, 'Successfully Populated the Individual Collection Tables object_value, khr_id, volume tables');
8529: -- Bulk Insert all the records into the OKL_PARALLEL_PROCESSES
8530: log_msg(FND_FILE.LOG, 'Before calling the Bulk Insert into the OKL_PARALLEL_PROCESSES' );
8531: FORALL dep_index IN l_deprn_contracts_tbl.FIRST .. l_deprn_contracts_tbl.LAST
8532: INSERT INTO OKL_PARALLEL_PROCESSES (
8533: OBJECT_TYPE
8534: ,OBJECT_VALUE
8535: ,ASSIGNED_PROCESS
8536: ,PROCESS_STATUS

Line 8550: log_msg(FND_FILE.LOG, 'After calling the Bulk Insert into the OKL_PARALLEL_PROCESSES' );

8546: ,SYSDATE -- Creation Date
8547: ,l_khr_id_tbl(dep_index) -- KHR_ID
8548: ,l_volume_tbl(dep_index) -- Volume
8549: );
8550: log_msg(FND_FILE.LOG, 'After calling the Bulk Insert into the OKL_PARALLEL_PROCESSES' );
8551: -- Commit the Records
8552: COMMIT;
8553: log_msg(FND_FILE.LOG, 'Committed the Insertion of the OKL_PARALLEL_PROCESSES Records' );
8554: -- Create l_num_workers number of Workers

Line 8553: log_msg(FND_FILE.LOG, 'Committed the Insertion of the OKL_PARALLEL_PROCESSES Records' );

8549: );
8550: log_msg(FND_FILE.LOG, 'After calling the Bulk Insert into the OKL_PARALLEL_PROCESSES' );
8551: -- Commit the Records
8552: COMMIT;
8553: log_msg(FND_FILE.LOG, 'Committed the Insertion of the OKL_PARALLEL_PROCESSES Records' );
8554: -- Create l_num_workers number of Workers
8555: FOR i in 1..l_num_workers
8556: LOOP -- put all workers into a table
8557: l_worker_load(i).worker_number := i;

Line 8610: UPDATE OKL_PARALLEL_PROCESSES

8606: END LOOP;
8607: -- Now Bulk Update the Contract Numbers in Parallel Processes with the
8608: -- Assigned Worker Number
8609: FORALL dep_index in l_deprn_contracts_tbl.FIRST .. l_deprn_contracts_tbl.LAST
8610: UPDATE OKL_PARALLEL_PROCESSES
8611: SET assigned_process = l_seq_next || '-' || l_assigned_process_tbl(dep_index)
8612: ,process_status = 'ASSIGNED'
8613: WHERE object_type = G_OBJECT_TYPE_DEP_KHR
8614: AND object_value = l_object_value_tbl(dep_index)

Line 8617: log_msg(FND_FILE.LOG, 'Updated the Records in OKL_PARALLEL_PROCESSES with the Assigned Process' );

8613: WHERE object_type = G_OBJECT_TYPE_DEP_KHR
8614: AND object_value = l_object_value_tbl(dep_index)
8615: AND process_status = 'PENDING_ASSIGNMENT'
8616: AND khr_id = l_khr_id_tbl(dep_index);
8617: log_msg(FND_FILE.LOG, 'Updated the Records in OKL_PARALLEL_PROCESSES with the Assigned Process' );
8618: -- COMMIT the Updation;
8619: COMMIT;
8620: log_msg(FND_FILE.LOG, 'Committed the Updation Changes' );
8621: FOR i in l_worker_load.FIRST .. l_worker_load.LAST