DBA Data[Home] [Help]

APPS.WSM_LBJ_INTERFACE_PVT dependencies on WIP_DATETIMES

Line 6234: current_cpt := current_cpt + wip_datetimes.datetime_diff_to_mins(

6230: if (p_handle_wip_cur_op = 'Y') then
6231: l_stmt_num := 10;
6232: for wip_row in wip_res_usage(p_wip_entity_id, p_operation_seq_num, p_resource_seq_num)
6233: loop
6234: current_cpt := current_cpt + wip_datetimes.datetime_diff_to_mins(
6235: wip_row.completion_date,
6236: wip_row.start_date);
6237: update wip_operation_resource_usage
6238: set cumulative_processing_time = current_cpt

Line 6246: current_cpt := current_cpt + wip_datetimes.datetime_diff_to_mins(

6242:
6243: l_stmt_num := 20;
6244: for wsm_row in wsm_res_usage(p_wip_entity_id, p_operation_seq_num, p_resource_seq_num)
6245: loop
6246: current_cpt := current_cpt + wip_datetimes.datetime_diff_to_mins(
6247: wsm_row.completion_date,
6248: wsm_row.start_date);
6249: update wsm_copy_op_resource_usage
6250: set cumulative_processing_time = current_cpt