APPS.BOM_OPERATION_PVT dependencies on BOM_OPERATION_SEQUENCES

Line 32: From bom_operation_sequences bos

28: cursor l_operation_csr (P_OpSeqId number) is
29: Select bos.routing_sequence_id,
30: bos.operation_type,
31: bos.operation_seq_num
32: From bom_operation_sequences bos
33: Where operation_sequence_id = P_OpSeqId;
34: cursor l_assy_csr(P_RtgSeqId number) is
35: Select assembly_item_id,
36: organization_id,

Line 272: From bom_operation_sequences bos

268: Select 'x' dummy
269: From dual
270: Where exists(
271: Select null
272: From bom_operation_sequences bos
273: where bos.routing_sequence_id = P_RtgSeqId
274: and bos.effectivity_date = P_EffDate
275: and bos.operation_seq_num = P_OpSeqNum
276: and nvl(bos.operation_type, g_event) =

Line 303: from bom_operation_sequences

299: select 'x' dummy
300: From dual
301: Where exists (
302: select null
303: from bom_operation_sequences
304: where operation_sequence_id <> P_OpSeqId
305: and routing_sequence_id = P_RtgSeqId
306: and operation_seq_num = P_OpSeqNum
307: and nvl(operation_type, g_event) =

Line 327: From bom_operation_sequences bos,

323: cursor l_OldOpCode_csr(P_OpSeqId number) is
324: Select bos.standard_operation_id,
325: bso.operation_code,
326: nvl(bos.reference_flag, 2) reference_flag
327: From bom_operation_sequences bos,
328: bom_standard_operations bso
329: Where operation_sequence_id = P_OpSeqId
330: And bos.standard_operation_id =
331: bso.standard_operation_id;

Line 346: and entity_name = 'BOM_OPERATION_SEQUENCES');

342: Where exists(
343: Select null
344: From fnd_attached_documents
345: Where pk1_value = to_char(P_OpSeqId)
346: and entity_name = 'BOM_OPERATION_SEQUENCES');
347: cursor l_StdOp_csr(P_OpType number, P_RtgSeqId number,
348: P_StdOpId number) is
349: select bso.DEPARTMENT_ID,
350: bso.MINIMUM_TRANSFER_QUANTITY,

Line 675: X_to_entity_name => 'BOM_OPERATION_SEQUENCES',

671: X_from_pk2_value => null,
672: X_from_pk3_value => null,
673: X_from_pk4_value => null,
674: X_from_pk5_value => null,
675: X_to_entity_name => 'BOM_OPERATION_SEQUENCES',
676: X_to_pk1_value => to_char(
677: l_operation_rec.operation_sequence_id),
678: X_to_pk2_value => null,
679: X_to_pk3_value => null,

Line 889: Select bom_operation_sequences_s.nextval new_op_seq_id

885: l_ProgramId number;
886: l_ApplicationId number;
887: l_ProgramUpdate date;
888: cursor l_NewOper_csr is
889: Select bom_operation_sequences_s.nextval new_op_seq_id
890: from dual;
891: BEGIN
892: -- Standard Start of API savepoint
893: SAVEPOINT CreateOperation_Pvt;

Line 1166: Insert into bom_operation_sequences(

1162: Else
1163: l_ProgramUpdate := sysdate;
1164: End if;
1165:
1166: Insert into bom_operation_sequences(
1167: operation_sequence_id,
1168: routing_sequence_id,
1169: operation_seq_num,
1170: last_update_date,

Line 1345: From bom_operation_sequences bos

1341: cursor l_ExistingOperation_csr(P_OpSeqId number,
1342: P_RtgSeqId number, P_OpType number, P_SeqNum number,
1343: P_EffDate date) is
1344: Select *
1345: From bom_operation_sequences bos
1346: Where bos.operation_sequence_id = P_OpSeqId
1347: Or (bos.routing_sequence_id = P_RtgSeqId and
1348: nvl(bos.operation_type, g_event) =
1349: nvl(P_OpType, g_event) and

Line 1630: update bom_operation_sequences set

1626: Else
1627: l_ProgramUpdate := sysdate;
1628: End if;
1629:
1630: update bom_operation_sequences set
1631: operation_seq_num = l_operation_rec.new_operation_seq_num,
1632: last_update_date = sysdate,
1633: last_updated_by = l_UserId,
1634: creation_date = sysdate,

Line 1778: bom_operation_sequences bos

1774: bor.organization_id,
1775: bor.alternate_routing_designator,
1776: bor.routing_type
1777: From bom_operational_routings bor,
1778: bom_operation_sequences bos
1779: Where bor.routing_sequence_id = bos.routing_sequence_id
1780: and (bos.operation_sequence_id = P_OpSeqId
1781: Or
1782: (bos.routing_sequence_id = P_RtgSeqId and