APPS.WIP_JOB_DETAILS dependencies on WIP_OPERATION_RESOURCES

Line 1019: wip_logger.log('wip_operation_resources',l_dummy2);

1015: ' FUCD '||to_date(wo_rec.first_unit_completion_date,WIP_CONSTANTS.DATETIME_FMT) ||
1016: ' LUSD '||to_date(wo_rec.last_unit_start_date,WIP_CONSTANTS.DATETIME_FMT) ||
1017: ' LUCD '||to_date(wo_rec.last_unit_completion_date,WIP_CONSTANTS.DATETIME_FMT) ,l_dummy2);
1018: end loop;
1019: wip_logger.log('wip_operation_resources',l_dummy2);
1020: for wor_rec in (select * from wip_operation_resources where wip_entity_id = cur_job.wip_entity_id and organization_id = cur_job.organization_id order by operation_seq_num) loop
1021: wip_logger.log('Op Seq '||wor_rec.operation_seq_num||' Res Seq '||wor_rec.resource_seq_num||
1022: ' St Dt '||to_date(wor_rec.start_date,WIP_CONSTANTS.DATETIME_FMT) ||
1023: ' Cm Dt '||to_date(wor_rec.completion_date,WIP_CONSTANTS.DATETIME_FMT) ,l_dummy2);

Line 1020: for wor_rec in (select * from wip_operation_resources where wip_entity_id = cur_job.wip_entity_id and organization_id = cur_job.organization_id order by operation_seq_num) loop

1016: ' LUSD '||to_date(wo_rec.last_unit_start_date,WIP_CONSTANTS.DATETIME_FMT) ||
1017: ' LUCD '||to_date(wo_rec.last_unit_completion_date,WIP_CONSTANTS.DATETIME_FMT) ,l_dummy2);
1018: end loop;
1019: wip_logger.log('wip_operation_resources',l_dummy2);
1020: for wor_rec in (select * from wip_operation_resources where wip_entity_id = cur_job.wip_entity_id and organization_id = cur_job.organization_id order by operation_seq_num) loop
1021: wip_logger.log('Op Seq '||wor_rec.operation_seq_num||' Res Seq '||wor_rec.resource_seq_num||
1022: ' St Dt '||to_date(wor_rec.start_date,WIP_CONSTANTS.DATETIME_FMT) ||
1023: ' Cm Dt '||to_date(wor_rec.completion_date,WIP_CONSTANTS.DATETIME_FMT) ,l_dummy2);
1024: end loop;