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 411: if( v_program_id = CTO_UTILITY_PK.PC_BOM_PROGRAM_ID AND

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

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

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

Line 414: lConfigBillId := CTO_UTILITY_PK.PC_BOM_BILL_SEQUENCE_ID ;

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

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

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

Line 486: lOEValidationOrg := CTO_UTILITY_PK.PC_BOM_VALIDATION_ORG ;

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

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

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

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

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

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

1308: END IF;
1309:
1310:
1311:
1312: if( v_program_id = CTO_UTILITY_PK.PC_BOM_PROGRAM_ID ) then
1313: IF PG_DEBUG <> 0 THEN
1314: oe_debug_pub.add('Pre configured Item .. ' ,1);
1315: END IF;
1316:

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

1460: for next order in the batch since even when items are
1461: dropped for one order in the batch , the whole batch
1462: should end with warning */
1463:
1464: if( v_program_id = CTO_UTILITY_PK.PC_BOM_PROGRAM_ID ) then
1465: IF PG_DEBUG <> 0 THEN
1466: oe_debug_pub.add ('Will not go through Hold Logic and Notification as Preconfigured Bom' , 1 );
1467: END IF;
1468:

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

1619:
1620:
1621:
1622:
1623: if( v_program_id = CTO_UTILITY_PK.PC_BOM_PROGRAM_ID ) then
1624: v_problem_model_line_num := ' -1 ' ;
1625:
1626: else
1627: select oel.line_number || '.' || oel.shipment_number

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

1668: IF PG_DEBUG <> 0 THEN
1669: oe_debug_pub.add('create_bom_ml: ' || 'Getting Custom Recipient..',3);
1670: END IF;
1671:
1672: v_recipient := CTO_CUSTOM_NOTIFY_PK.get_recipient( p_error_type => CTO_UTILITY_PK.OPT_DROP_AND_ITEM_CREATED
1673: ,p_inventory_item_id => pModelId
1674: ,p_organization_id => pOrgId
1675: ,p_line_id => pLineId );
1676:

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

1807: IF PG_DEBUG <> 0 THEN
1808: oe_debug_pub.add('create_bom_ml: ' || 'Getting Custom Recipient..',3);
1809: END IF;
1810:
1811: v_recipient := CTO_CUSTOM_NOTIFY_PK.get_recipient( p_error_type => CTO_UTILITY_PK.OPT_DROP_AND_ITEM_NOT_CREATED
1812: ,p_inventory_item_id => pModelId
1813: ,p_organization_id => pOrgId
1814: ,p_line_id => pLineId );
1815:

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

1878:
1879: oe_debug_pub.add('create_bom_ml: ' || 'fetching information for apply hold on lineid '|| to_char(pLineId) ,2);
1880: oe_debug_pub.add('create_bom_ml: ' || 'going to apply hold on lineid '|| to_char(pLineId) ,2);
1881:
1882: cto_utility_pk.apply_create_config_hold( v_ato_line_id, v_header_id, l_return_status, l_msg_count, l_msg_data ) ;
1883:
1884:
1885: l_token(1).token_name := 'ORDER_NUM';
1886: l_token(1).token_value := v_order_number;

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

4274: nvl(ic1.operation_seq_num,1),
4275: decode(bcol1.config_item_id, NULL, ic1.component_item_id,bcol1.config_item_id),
4276: ic1.item_num,
4277: Round(
4278: CTO_UTILITY_PK.convert_uom( bcol1.order_quantity_uom, msi_child.primary_uom_code, bcol1.ordered_quantity , msi_child.inventory_item_id )
4279: / CTO_UTILITY_PK.convert_uom(bcol2.order_quantity_uom, msi_parent.primary_uom_code, NVL(bcol2.ordered_quantity,1) , msi_parent.inventory_item_id )
4280: , 7) , -- qty = comp_qty / model_qty /* Decimal-Qty Support for Option Items */
4281: ic1.component_yield_factor,
4282: ic1.component_remarks, --Bugfix 7188428

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

4275: decode(bcol1.config_item_id, NULL, ic1.component_item_id,bcol1.config_item_id),
4276: ic1.item_num,
4277: Round(
4278: CTO_UTILITY_PK.convert_uom( bcol1.order_quantity_uom, msi_child.primary_uom_code, bcol1.ordered_quantity , msi_child.inventory_item_id )
4279: / CTO_UTILITY_PK.convert_uom(bcol2.order_quantity_uom, msi_parent.primary_uom_code, NVL(bcol2.ordered_quantity,1) , msi_parent.inventory_item_id )
4280: , 7) , -- qty = comp_qty / model_qty /* Decimal-Qty Support for Option Items */
4281: ic1.component_yield_factor,
4282: ic1.component_remarks, --Bugfix 7188428
4283: ic1.attribute_category,