3772: BEGIN
3773: -- added by BBK.
3774:
3775: select 1 into p_manually_added_resource
3776: From wip_operation_resources wor
3777: Where wor.wip_entity_id = p_wip_entity_id
3778: and wor.operation_seq_num = p_op_seq_num
3779: and wor.repetitive_schedule_id is NULL
3780: and wor.applied_resource_units <> 0
4607: l_op_seq_num := -1 ;
4608:
4609: select unique wor.operation_seq_num
4610: into l_op_seq_num
4611: from wip_operation_resources wor
4612: where wor.organization_id = p_organization_id
4613: and wor.wip_entity_id = p_wip_entity_id
4614: and wor.operation_seq_num = nvl(p_operation_seq_num,wor.operation_seq_num)
4615: and wor.autocharge_type IN (WIP_CONSTANTS.PO_RECEIPT,