DBA Data[Home] [Help]

APPS.WIP_JOB_DETAILS dependencies on WIP_OPERATIONS

Line 1012: wip_logger.log('wip_operations',l_dummy2);

1008: x_err_msg,
1009: x_return_status);
1010:
1011: if (l_logLevel <= wip_constants.trace_logging) then
1012: wip_logger.log('wip_operations',l_dummy2);
1013: for wo_rec in (select * from wip_operations where wip_entity_id = cur_job.wip_entity_id and organization_id = cur_job.organization_id order by operation_seq_num) loop
1014: wip_logger.log('Op Seq '||wo_rec.operation_seq_num||' FUSD '||to_date(wo_rec.first_unit_start_date,WIP_CONSTANTS.DATETIME_FMT)||
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) ||

Line 1013: for wo_rec in (select * from wip_operations where wip_entity_id = cur_job.wip_entity_id and organization_id = cur_job.organization_id order by operation_seq_num) loop

1009: x_return_status);
1010:
1011: if (l_logLevel <= wip_constants.trace_logging) then
1012: wip_logger.log('wip_operations',l_dummy2);
1013: for wo_rec in (select * from wip_operations where wip_entity_id = cur_job.wip_entity_id and organization_id = cur_job.organization_id order by operation_seq_num) loop
1014: wip_logger.log('Op Seq '||wo_rec.operation_seq_num||' FUSD '||to_date(wo_rec.first_unit_start_date,WIP_CONSTANTS.DATETIME_FMT)||
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);