APPS.BOM_OPRESOURCE_PVT dependencies on BOM_OPERATION_RESOURCES

Line 386: from bom_operation_resources bor

382: Select 'x' dummy
383: From dual
384: Where exists(
385: Select null
386: from bom_operation_resources bor
387: where bor.operation_sequence_id = P_OpSeqId
388: and bor.resource_seq_num = P_NewSeqNum
389: and (bor.resource_seq_num <> P_OldSeqNum
390: or P_OldSeqNum is null));

Line 423: from bom_operation_resources bor

419: Select 'x' dummy
420: From dual
421: Where exists(
422: select null
423: from bom_operation_resources bor
424: where operation_sequence_id = P_OpSeqId
425: and (resource_seq_num <> P_SeqNum or
426: P_SeqNum is null)
427: and schedule_flag = P_SchedType);

Line 437: from bom_operation_resources

433: select 'x' dummy
434: from dual
435: where exists(
436: select null
437: from bom_operation_resources
438: where operation_sequence_id = P_OpSeqId
439: and (P_SeqNum is null or
440: resource_seq_num <> P_SeqNum)
441: and autocharge_type = l_POMove);

Line 993: Insert into bom_operation_resources(

989: Else
990: l_ProgramUpdate := sysdate;
991: End if;
992:
993: Insert into bom_operation_resources(
994: operation_sequence_id,
995: resource_seq_num,
996: resource_id,
997: activity_id,

Line 1140: From bom_operation_resources bor

1136: l_ApplicationId NUMBER;
1137: cursor l_ExistingOpResource_csr(P_OpSeqId number,
1138: P_SeqNum number) is
1139: Select *
1140: From bom_operation_resources bor
1141: Where bor.operation_sequence_id = P_OpSeqId
1142: And bor.resource_seq_num = P_SeqNum;
1143: l_ResourceFound BOOLEAN := false;
1144: BEGIN

Line 1347: update bom_operation_resources set

1343: Else
1344: l_ProgramUpdate := sysdate;
1345: End if;
1346:
1347: update bom_operation_resources set
1348: resource_seq_num = l_resource_rec.new_resource_seq_num,
1349: resource_id = l_resource_rec.resource_id,
1350: activity_id = l_resource_rec.activity_id,
1351: standard_rate_flag = l_resource_rec.standard_rate_flag,

Line 1482: delete bom_operation_resources

1478: End If; -- assign
1479:
1480: x_resource_rec := l_resource_rec;
1481:
1482: delete bom_operation_resources
1483: where operation_sequence_id = l_resource_rec.operation_sequence_id
1484: and resource_seq_num = l_resource_rec.resource_seq_num;
1485:
1486: If sql%notfound then