DBA Data[Home] [Help]

APPS.WIP_JOB_DTLS_SUBSTITUTIONS dependencies on WIP_DATETIMES

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

3208:
3209: current_cpt NUMBER := 0;
3210: begin
3211: for cur_row in res_usage(p_wip_entity_id, p_operation_seq_num, p_resource_seq_num) loop
3212: current_cpt := current_cpt + wip_datetimes.datetime_diff_to_mins(cur_row.completion_date, cur_row.start_date);
3213: update wip_operation_resource_usage
3214: set cumulative_processing_time = current_cpt
3215: where current of res_usage;
3216: end loop;