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 671: X_to_entity_name => 'BOM_OPERATION_SEQUENCES',

667: X_from_pk2_value => null,
668: X_from_pk3_value => null,
669: X_from_pk4_value => null,
670: X_from_pk5_value => null,
671: X_to_entity_name => 'BOM_OPERATION_SEQUENCES',
672: X_to_pk1_value => to_char(
673: l_operation_rec.operation_sequence_id),
674: X_to_pk2_value => null,
675: X_to_pk3_value => null,

Line 885: Select bom_operation_sequences_s.nextval new_op_seq_id

881: l_ProgramId number;
882: l_ApplicationId number;
883: l_ProgramUpdate date;
884: cursor l_NewOper_csr is
885: Select bom_operation_sequences_s.nextval new_op_seq_id
886: from dual;
887: BEGIN
888: -- Standard Start of API savepoint
889: SAVEPOINT CreateOperation_Pvt;

Line 1162: Insert into bom_operation_sequences(

1158: Else
1159: l_ProgramUpdate := sysdate;
1160: End if;
1161:
1162: Insert into bom_operation_sequences(
1163: operation_sequence_id,
1164: routing_sequence_id,
1165: operation_seq_num,
1166: last_update_date,

Line 1341: From bom_operation_sequences bos

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

Line 1626: update bom_operation_sequences set

1622: Else
1623: l_ProgramUpdate := sysdate;
1624: End if;
1625:
1626: update bom_operation_sequences set
1627: operation_seq_num = l_operation_rec.new_operation_seq_num,
1628: last_update_date = sysdate,
1629: last_updated_by = l_UserId,
1630: creation_date = sysdate,

Line 1774: bom_operation_sequences bos

1770: bor.organization_id,
1771: bor.alternate_routing_designator,
1772: bor.routing_type
1773: From bom_operational_routings bor,
1774: bom_operation_sequences bos
1775: Where bor.routing_sequence_id = bos.routing_sequence_id
1776: and (bos.operation_sequence_id = P_OpSeqId
1777: Or
1778: (bos.routing_sequence_id = P_RtgSeqId and