[Home] [Help]
481: for update nowait;
482:
483: cursor c_resUsgs is
484: select 1
485: from wip_operation_resource_usage woru,
486: wip_operation_resources wor
487: where wor.wip_entity_id = p_wipEntityID
488: and wor.organization_id = p_orgID
489: and ( wor.operation_seq_num < p_maxOpSeqNum
835: if(l_logLevel <= wip_constants.full_logging) then
836: wip_logger.log('wrote resource instances', l_retStatus);
837: end if;
838:
839: delete wip_operation_resource_usage
840: where (organization_id, wip_entity_id, operation_seq_num, resource_seq_num) in
841: (select organization_id,
842: wip_entity_id,
843: operation_seq_num,
864:
865: for i in 1..x_resTbls.resID.count loop
866: if(x_resTbls.usgStartIdx(i) is not null) then
867: forall j in x_resTbls.usgStartIdx(i)..x_resTbls.usgEndIdx(i)
868: insert into wip_operation_resource_usage
869: (wip_entity_id,
870: operation_seq_num,
871: resource_seq_num,
872: organization_id,
906: if(l_logLevel <= wip_constants.full_logging) then
907: wip_logger.log('wrote resource usages', l_retStatus);
908: end if;
909:
910: insert into wip_operation_resource_usage
911: (wip_entity_id,
912: operation_seq_num,
913: resource_seq_num,
914: organization_id,
945: l_reqID,
946: l_progApplID,
947: l_progID,
948: l_sysdate
949: from wip_operation_resource_usage woru,
950: wip_op_resource_instances wori,
951: wip_operation_resources wor
952: where woru.wip_entity_id = wori.wip_entity_id
953: and woru.operation_seq_num = wori.operation_seq_num