DBA Data[Home] [Help]

APPS.WSM_LBJ_INTERFACE_PVT dependencies on WIP_DATETIMES

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

6246: if (p_handle_wip_cur_op = 'Y') then
6247: l_stmt_num := 10;
6248: for wip_row in wip_res_usage(p_wip_entity_id, p_operation_seq_num, p_resource_seq_num)
6249: loop
6250: current_cpt := current_cpt + wip_datetimes.datetime_diff_to_mins(
6251: wip_row.completion_date,
6252: wip_row.start_date);
6253: update wip_operation_resource_usage
6254: set cumulative_processing_time = current_cpt

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

6258:
6259: l_stmt_num := 20;
6260: for wsm_row in wsm_res_usage(p_wip_entity_id, p_operation_seq_num, p_resource_seq_num)
6261: loop
6262: current_cpt := current_cpt + wip_datetimes.datetime_diff_to_mins(
6263: wsm_row.completion_date,
6264: wsm_row.start_date);
6265: update wsm_copy_op_resource_usage
6266: set cumulative_processing_time = current_cpt