DBA Data[Home] [Help]

APPS.CTO_BOM_RTG_PK dependencies on CTO_MSUTIL_PUB

Line 703: cto_msutil_pub.bom_batch_id,effectivity_date,disable_date

699:
700: insert into bom_inventory_comps_interface(component_item_id,bill_sequence_id, batch_id,
701: effectivity_date,disable_date)
702: select component_item_id, bill_sequence_id,
703: cto_msutil_pub.bom_batch_id,effectivity_date,disable_date
704: from bom_inventory_components
705: where bill_sequence_id = lComItmBillId; -- 3543547 lItmBillId;
706:
707: IF PG_DEBUG <> 0 THEN

Line 735: cto_msutil_pub.bom_batch_id,effectivity_date,disable_date

731:
732: insert into bom_inventory_comps_interface(component_item_id,bill_sequence_id, batch_id,
733: effectivity_date,disable_date)
734: select distinct a.base_model_id, b.bill_sequence_id,
735: cto_msutil_pub.bom_batch_id,effectivity_date,disable_date
736: from bom_ato_configurations a,bom_inventory_components b
737: where a.config_item_id = b.component_item_id
738: and b.bill_sequence_id = lComItmBillId; -- 3543547 lItmBillId
739:

Line 1459: and batch_id = cto_msutil_pub.bom_batch_id;

1455:
1456: -- 3543547 Replace lItmBillId with lComItmBillId
1457: delete from bom_inventory_comps_interface
1458: where bill_sequence_id = lComItmBillId
1459: and batch_id = cto_msutil_pub.bom_batch_id;
1460:
1461: lCnt := sql%rowcount;
1462: IF PG_DEBUG <> 0 THEN
1463: oe_debug_pub.add('Deleted from bici, rows::'||lCnt);

Line 1469: and batch_id = cto_msutil_pub.bom_batch_id;

1465:
1466: --Bugfix 11056452
1467: delete from bom_bill_of_mtls_interface
1468: where bill_sequence_id = lComItmBillId
1469: and batch_id = cto_msutil_pub.bom_batch_id;
1470:
1471: lCnt := sql%rowcount;
1472: IF PG_DEBUG <> 0 THEN
1473: oe_debug_pub.add('Deleted from bmi, rows::'||lCnt);