eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CTO_CONFIG_BOM_PK dependencies on CTO_UTILITY_PK

Line 409: if( v_program_id = CTO_UTILITY_PK.PC_BOM_PROGRAM_ID AND

405:
406:
407: /* BUG #1957336 Change for preconfigure bom */
408:
409: if( v_program_id = CTO_UTILITY_PK.PC_BOM_PROGRAM_ID AND
410: v_ato_line_id = pLineId and pOrgId = CTO_UTILITY_PK.PC_BOM_CURRENT_ORG ) then
411:
412: lConfigBillId := CTO_UTILITY_PK.PC_BOM_BILL_SEQUENCE_ID ;
413:

Line 410: v_ato_line_id = pLineId and pOrgId = CTO_UTILITY_PK.PC_BOM_CURRENT_ORG ) then

406:
407: /* BUG #1957336 Change for preconfigure bom */
408:
409: if( v_program_id = CTO_UTILITY_PK.PC_BOM_PROGRAM_ID AND
410: v_ato_line_id = pLineId and pOrgId = CTO_UTILITY_PK.PC_BOM_CURRENT_ORG ) then
411:
412: lConfigBillId := CTO_UTILITY_PK.PC_BOM_BILL_SEQUENCE_ID ;
413:
414: oe_debug_pub.add('create_bom_ml: ' || 'Setting Bill ' || lConfigBillId || ' for org ' || pOrgId

Line 412: lConfigBillId := CTO_UTILITY_PK.PC_BOM_BILL_SEQUENCE_ID ;

408:
409: if( v_program_id = CTO_UTILITY_PK.PC_BOM_PROGRAM_ID AND
410: v_ato_line_id = pLineId and pOrgId = CTO_UTILITY_PK.PC_BOM_CURRENT_ORG ) then
411:
412: lConfigBillId := CTO_UTILITY_PK.PC_BOM_BILL_SEQUENCE_ID ;
413:
414: oe_debug_pub.add('create_bom_ml: ' || 'Setting Bill ' || lConfigBillId || ' for org ' || pOrgId
415: || ' for line id ' || pLineId , 1);
416: else

Line 483: if( v_program_id = CTO_UTILITY_PK.PC_BOM_PROGRAM_ID ) then

479:
480:
481: /* BUG #1957336 Change for preconfigure bom */
482:
483: if( v_program_id = CTO_UTILITY_PK.PC_BOM_PROGRAM_ID ) then
484: lOEValidationOrg := CTO_UTILITY_PK.PC_BOM_VALIDATION_ORG ;
485: else
486: /*
487: BUG:3484511

Line 484: lOEValidationOrg := CTO_UTILITY_PK.PC_BOM_VALIDATION_ORG ;

480:
481: /* BUG #1957336 Change for preconfigure bom */
482:
483: if( v_program_id = CTO_UTILITY_PK.PC_BOM_PROGRAM_ID ) then
484: lOEValidationOrg := CTO_UTILITY_PK.PC_BOM_VALIDATION_ORG ;
485: else
486: /*
487: BUG:3484511
488: -----------

Line 735: CTO_UTILITY_PK.convert_uom( bcol1.order_quantity_uom, msi_child.primary_uom_code, bcol1.ordered_quantity , msi_child.inventory_item_id )

731: 1, -- created_by
732: 1, -- last_update_login
733: ic1.item_num,
734: Round(
735: CTO_UTILITY_PK.convert_uom( bcol1.order_quantity_uom, msi_child.primary_uom_code, bcol1.ordered_quantity , msi_child.inventory_item_id )
736: / CTO_UTILITY_PK.convert_uom(bcol2.order_quantity_uom, msi_parent.primary_uom_code, NVL(bcol2.ordered_quantity,1) , msi_parent.inventory_item_id )
737: , 7) , -- qty = comp_qty / model_qty /* Decimal-Qty Support for Option Items */
738: ic1.component_yield_factor,
739: ic1.component_remarks, --Bugfix 7188428

Line 736: / CTO_UTILITY_PK.convert_uom(bcol2.order_quantity_uom, msi_parent.primary_uom_code, NVL(bcol2.ordered_quantity,1) , msi_parent.inventory_item_id )

732: 1, -- last_update_login
733: ic1.item_num,
734: Round(
735: CTO_UTILITY_PK.convert_uom( bcol1.order_quantity_uom, msi_child.primary_uom_code, bcol1.ordered_quantity , msi_child.inventory_item_id )
736: / CTO_UTILITY_PK.convert_uom(bcol2.order_quantity_uom, msi_parent.primary_uom_code, NVL(bcol2.ordered_quantity,1) , msi_parent.inventory_item_id )
737: , 7) , -- qty = comp_qty / model_qty /* Decimal-Qty Support for Option Items */
738: ic1.component_yield_factor,
739: ic1.component_remarks, --Bugfix 7188428
740: --NULL, --ic1.component_remark

Line 1286: if( v_program_id = CTO_UTILITY_PK.PC_BOM_PROGRAM_ID ) then

1282: END IF;
1283:
1284:
1285:
1286: if( v_program_id = CTO_UTILITY_PK.PC_BOM_PROGRAM_ID ) then
1287: IF PG_DEBUG <> 0 THEN
1288: oe_debug_pub.add('Pre configured Item .. ' ,1);
1289: END IF;
1290:

Line 1438: if( v_program_id = CTO_UTILITY_PK.PC_BOM_PROGRAM_ID ) then

1434: for next order in the batch since even when items are
1435: dropped for one order in the batch , the whole batch
1436: should end with warning */
1437:
1438: if( v_program_id = CTO_UTILITY_PK.PC_BOM_PROGRAM_ID ) then
1439: IF PG_DEBUG <> 0 THEN
1440: oe_debug_pub.add ('Will not go through Hold Logic and Notification as Preconfigured Bom' , 1 );
1441: END IF;
1442:

Line 1597: if( v_program_id = CTO_UTILITY_PK.PC_BOM_PROGRAM_ID ) then

1593:
1594:
1595:
1596:
1597: if( v_program_id = CTO_UTILITY_PK.PC_BOM_PROGRAM_ID ) then
1598: v_problem_model_line_num := ' -1 ' ;
1599:
1600: else
1601: select oel.line_number || '.' || oel.shipment_number

Line 1646: v_recipient := CTO_CUSTOM_NOTIFY_PK.get_recipient( p_error_type => CTO_UTILITY_PK.OPT_DROP_AND_ITEM_CREATED

1642: IF PG_DEBUG <> 0 THEN
1643: oe_debug_pub.add('create_bom_ml: ' || 'Getting Custom Recipient..',3);
1644: END IF;
1645:
1646: v_recipient := CTO_CUSTOM_NOTIFY_PK.get_recipient( p_error_type => CTO_UTILITY_PK.OPT_DROP_AND_ITEM_CREATED
1647: ,p_inventory_item_id => pModelId
1648: ,p_organization_id => pOrgId
1649: ,p_line_id => pLineId );
1650:

Line 1785: v_recipient := CTO_CUSTOM_NOTIFY_PK.get_recipient( p_error_type => CTO_UTILITY_PK.OPT_DROP_AND_ITEM_NOT_CREATED

1781: IF PG_DEBUG <> 0 THEN
1782: oe_debug_pub.add('create_bom_ml: ' || 'Getting Custom Recipient..',3);
1783: END IF;
1784:
1785: v_recipient := CTO_CUSTOM_NOTIFY_PK.get_recipient( p_error_type => CTO_UTILITY_PK.OPT_DROP_AND_ITEM_NOT_CREATED
1786: ,p_inventory_item_id => pModelId
1787: ,p_organization_id => pOrgId
1788: ,p_line_id => pLineId );
1789:

Line 1856: cto_utility_pk.apply_create_config_hold( v_ato_line_id, v_header_id, l_return_status, l_msg_count, l_msg_data ) ;

1852:
1853: oe_debug_pub.add('create_bom_ml: ' || 'fetching information for apply hold on lineid '|| to_char(pLineId) ,2);
1854: oe_debug_pub.add('create_bom_ml: ' || 'going to apply hold on lineid '|| to_char(pLineId) ,2);
1855:
1856: cto_utility_pk.apply_create_config_hold( v_ato_line_id, v_header_id, l_return_status, l_msg_count, l_msg_data ) ;
1857:
1858:
1859: l_token(1).token_name := 'ORDER_NUM';
1860: l_token(1).token_value := v_order_number;

Line 4095: CTO_UTILITY_PK.convert_uom( bcol1.order_quantity_uom, msi_child.primary_uom_code, bcol1.ordered_quantity , msi_child.inventory_item_id )

4091: nvl(ic1.operation_seq_num,1),
4092: decode(bcol1.config_item_id, NULL, ic1.component_item_id,bcol1.config_item_id),
4093: ic1.item_num,
4094: Round(
4095: CTO_UTILITY_PK.convert_uom( bcol1.order_quantity_uom, msi_child.primary_uom_code, bcol1.ordered_quantity , msi_child.inventory_item_id )
4096: / CTO_UTILITY_PK.convert_uom(bcol2.order_quantity_uom, msi_parent.primary_uom_code, NVL(bcol2.ordered_quantity,1) , msi_parent.inventory_item_id )
4097: , 7) , -- qty = comp_qty / model_qty /* Decimal-Qty Support for Option Items */
4098: ic1.component_yield_factor,
4099: ic1.component_remarks, --Bugfix 7188428

Line 4096: / CTO_UTILITY_PK.convert_uom(bcol2.order_quantity_uom, msi_parent.primary_uom_code, NVL(bcol2.ordered_quantity,1) , msi_parent.inventory_item_id )

4092: decode(bcol1.config_item_id, NULL, ic1.component_item_id,bcol1.config_item_id),
4093: ic1.item_num,
4094: Round(
4095: CTO_UTILITY_PK.convert_uom( bcol1.order_quantity_uom, msi_child.primary_uom_code, bcol1.ordered_quantity , msi_child.inventory_item_id )
4096: / CTO_UTILITY_PK.convert_uom(bcol2.order_quantity_uom, msi_parent.primary_uom_code, NVL(bcol2.ordered_quantity,1) , msi_parent.inventory_item_id )
4097: , 7) , -- qty = comp_qty / model_qty /* Decimal-Qty Support for Option Items */
4098: ic1.component_yield_factor,
4099: ic1.component_remarks, --Bugfix 7188428
4100: ic1.attribute_category,