[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
815: if(l_logLevel <= wip_constants.full_logging) then
816: wip_logger.log('wrote resource instances', l_retStatus);
817: end if;
818:
819: delete wip_operation_resource_usage
820: where (organization_id, wip_entity_id, operation_seq_num, resource_seq_num) in
821: (select organization_id,
822: wip_entity_id,
823: operation_seq_num,
844:
845: for i in 1..x_resTbls.resID.count loop
846: if(x_resTbls.usgStartIdx(i) is not null) then
847: forall j in x_resTbls.usgStartIdx(i)..x_resTbls.usgEndIdx(i)
848: insert into wip_operation_resource_usage
849: (wip_entity_id,
850: operation_seq_num,
851: resource_seq_num,
852: organization_id,
886: if(l_logLevel <= wip_constants.full_logging) then
887: wip_logger.log('wrote resource usages', l_retStatus);
888: end if;
889:
890: insert into wip_operation_resource_usage
891: (wip_entity_id,
892: operation_seq_num,
893: resource_seq_num,
894: organization_id,
925: l_reqID,
926: l_progApplID,
927: l_progID,
928: l_sysdate
929: from wip_operation_resource_usage woru,
930: wip_op_resource_instances wori,
931: wip_operation_resources wor
932: where woru.wip_entity_id = wori.wip_entity_id
933: and woru.operation_seq_num = wori.operation_seq_num