DBA Data[Home] [Help]

APPS.WIP_JOB_DTLS_SUBSTITUTIONS dependencies on WIP_DATETIMES

Line 3085: current_cpt := current_cpt + wip_datetimes.datetime_diff_to_mins(cur_row.completion_date, cur_row.start_date);

3081:
3082: current_cpt NUMBER := 0;
3083: begin
3084: for cur_row in res_usage(p_wip_entity_id, p_operation_seq_num, p_resource_seq_num) loop
3085: current_cpt := current_cpt + wip_datetimes.datetime_diff_to_mins(cur_row.completion_date, cur_row.start_date);
3086: update wip_operation_resource_usage
3087: set cumulative_processing_time = current_cpt
3088: where current of res_usage;
3089: end loop;