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_ITEM_PK dependencies on CTO_UTILITY_PK

Line 1995: CTO_UTILITY_PK.convert_uom(

1991: nvl(oel.component_sequence_id,1), --1902818
1992: oel.inventory_item_id,
1993: 0, -- Plan level
1994: -- 1998386
1995: CTO_UTILITY_PK.convert_uom(
1996: oel.order_quantity_uom,
1997: msi.primary_uom_code,
1998: oel.ordered_quantity,
1999: oel.inventory_item_id),

Line 2063: CTO_UTILITY_PK.convert_uom(

2059: -- if the order UOM is different from primary UOM of the item .
2060: -- If ordered UOM and primary UOM are same,the function
2061: -- returns the ordered quantity.
2062:
2063: CTO_UTILITY_PK.convert_uom(
2064: oel.order_quantity_uom,
2065: msi.primary_uom_code,
2066: oel.ordered_quantity,
2067: oel.inventory_item_id),

Line 2102: CTO_UTILITY_PK.convert_uom(

2098: -- if the order UOM is different from primary UOM of the item .
2099: -- If ordered UOM and primary UOM are same,the function
2100: -- returns the ordered quantity.
2101:
2102: CTO_UTILITY_PK.convert_uom(
2103: oel.order_quantity_uom,
2104: msi.primary_uom_code,
2105: oel.ordered_quantity,
2106: oel.inventory_item_id),

Line 2493: CTO_UTILITY_PK.convert_uom(

2489: 2,
2490: nvl(oel.component_sequence_id,1),
2491: oel.inventory_item_id,
2492: 0,
2493: CTO_UTILITY_PK.convert_uom(
2494: oel.order_quantity_uom,
2495: msi.primary_uom_code,
2496: oel.ordered_quantity,
2497: oel.inventory_item_id),

Line 2552: CTO_UTILITY_PK.convert_uom(

2548: 2,
2549: oel.component_sequence_id,
2550: oel.inventory_item_id,
2551: level_number,
2552: CTO_UTILITY_PK.convert_uom(
2553: oel.order_quantity_uom,
2554: msi.primary_uom_code,
2555: oel.ordered_quantity,
2556: oel.inventory_item_id),

Line 2956: CTO_UTILITY_PK.convert_uom(

2952: 1,
2953: p_ship_set.source_organization_id(i),
2954: p_ship_set.inventory_item_id(i),
2955: 1,
2956: CTO_UTILITY_PK.convert_uom(
2957: p_ship_set.quantity_uom(i),
2958: msi.primary_uom_code,
2959: p_ship_set.quantity_ordered(i),
2960: p_ship_set.inventory_item_id(i)),

Line 3001: CTO_UTILITY_PK.convert_uom(

2997: p_ship_set.source_organization_id(p_model_index),
2998: 2, -- BUG no 1288823 modification
2999: p_ship_set.inventory_item_id(p_model_index),
3000: 0,
3001: CTO_UTILITY_PK.convert_uom(
3002: p_ship_set.quantity_uom(p_model_index),
3003: msi.primary_uom_code,
3004: p_ship_set.quantity_ordered(p_model_index),
3005: p_ship_set.inventory_item_id(p_model_index)),

Line 3054: CTO_UTILITY_PK.convert_uom(

3050: -- quantity if the order UOM is different from primary UOM of the item.
3051: -- If ordered UOM and primary UOM are same
3052: -- the function returns the ordered quantity.
3053:
3054: CTO_UTILITY_PK.convert_uom(
3055: bet2.primary_uom_code,
3056: msi.primary_uom_code,
3057: bet2.extended_quantity,
3058: bic.component_item_id),

Line 3422: CTO_UTILITY_PK.convert_uom(

3418: 1,
3419: p_ship_set.source_organization_id(i),
3420: p_ship_set.inventory_item_id(i),
3421: 1,
3422: CTO_UTILITY_PK.convert_uom(
3423: p_ship_set.quantity_uom(i),
3424: msi.primary_uom_code,
3425: p_ship_set.quantity_ordered(i),
3426: p_ship_set.inventory_item_id(i)),

Line 3460: CTO_UTILITY_PK.convert_uom(

3456: p_ship_set.source_organization_id(p_model_index),
3457: 2, -- BUG no 1288823 modification
3458: p_ship_set.inventory_item_id(p_model_index),
3459: 0,
3460: CTO_UTILITY_PK.convert_uom(
3461: p_ship_set.quantity_uom(p_model_index),
3462: msi.primary_uom_code,
3463: p_ship_set.quantity_ordered(p_model_index),
3464: p_ship_set.inventory_item_id(p_model_index)),

Line 3505: CTO_UTILITY_PK.convert_uom(

3501: bet.organization_id,
3502: 2,
3503: bic.component_item_id,
3504: level_number,
3505: CTO_UTILITY_PK.convert_uom(
3506: bet2.primary_uom_code,
3507: msi.primary_uom_code,
3508: bet2.extended_quantity,
3509: bic.component_item_id),

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

4257:
4258:
4259: /* BUG #1957336 Change for preconfigure bom by Sushant Sawant */
4260: /* Changes for patchset J
4261: if( v_program_id = CTO_UTILITY_PK.PC_BOM_PROGRAM_ID ) then
4262: */
4263:
4264:
4265: oe_debug_pub.add('Create_Item: ' || 'p_mode ' || p_mode ,2);

Line 4269: lValidationOrg := CTO_UTILITY_PK.PC_BOM_VALIDATION_ORG ;

4265: oe_debug_pub.add('Create_Item: ' || 'p_mode ' || p_mode ,2);
4266:
4267: if( p_mode = 'PRECONFIG' ) then
4268:
4269: lValidationOrg := CTO_UTILITY_PK.PC_BOM_VALIDATION_ORG ;
4270:
4271: else
4272:
4273: IF PG_DEBUG <> 0 THEN

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

4352: oe_debug_pub.add('Create_Item: ' || 'Number Method is : ' || lNumberMethod,2 );
4353: END IF;
4354:
4355: /* BUG #2172057 Change for preconfigure bom by Sushant Sawant */
4356: if( v_program_id = CTO_UTILITY_PK.PC_BOM_PROGRAM_ID ) then
4357: -- 2663450 : Change the NumberMethod only when it is <> 4.
4358: if lNumberMethod <> 4 then
4359: lNumberMethod := 1 ;
4360: end if;

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

4512: Call to user Defined Method
4513: +--------------------------*/
4514: -- bugfix 2663450: call custom api ..
4515:
4516: if( v_program_id = CTO_UTILITY_PK.PC_BOM_PROGRAM_ID ) then
4517: new_item_num := CTO_CUSTOM_CONFIG_NUMBER.user_item_number
4518: ( model_item_id => pModelId,
4519: model_line_id => NULL,
4520: param1 => NULL,

Line 5653: (select CTO_UTILITY_PK.convert_uom(

5649:
5650: if (o_weight_uom is not null) then
5651: update mtl_system_items a
5652: set (unit_weight, weight_uom_code) =
5653: (select CTO_UTILITY_PK.convert_uom(
5654: o_weight_uom,
5655: nvl( b.weight_uom_code, o_weight_uom) , -- bug# 3358194
5656: o_weight,
5657: b.inventory_item_id)

Line 5669: (select CTO_UTILITY_PK.convert_uom(

5665:
5666: if (o_volume_uom is not null) then -- begin bugfix 4143695
5667: update mtl_system_items a
5668: set (unit_volume, volume_uom_code) =
5669: (select CTO_UTILITY_PK.convert_uom(
5670: o_volume_uom,
5671: nvl(b.volume_uom_code, o_volume_uom), -- bug# 3358194
5672: o_volume,
5673: b.inventory_item_id)

Line 5788: CTO_UTILITY_PK.Create_Sourcing_Rules(

5784: --
5785: IF PG_DEBUG <> 0 THEN
5786: oe_debug_pub.add ('Create_Item: ' || 'Copying src rule for cfg item '||to_char(pConfigId)||' in org '||to_char(v_src_rule.rcv_org_id), 2);
5787: END IF;
5788: CTO_UTILITY_PK.Create_Sourcing_Rules(
5789: pModelItemId => pModelId,
5790: pConfigId => pConfigId,
5791: pRcvOrgId => v_src_rule.rcv_org_id,
5792: x_return_status => lReturnStatus,

Line 5818: lStatus := CTO_UTILITY_PK.Update_Order_Lines(

5814: -- update bom_cto_order_lines with new config item
5815: --
5816:
5817: lStmtNumber := 120;
5818: lStatus := CTO_UTILITY_PK.Update_Order_Lines(
5819: pLineId => pLineId,
5820: pModelId => pModelId,
5821: pConfigId => pConfigId);
5822:

Line 5837: lStatus := CTO_UTILITY_PK.Update_Src_Orgs(

5833: -- update bom_cto_src_orgs with new config item
5834: --
5835:
5836: lStmtNumber := 130;
5837: lStatus := CTO_UTILITY_PK.Update_Src_Orgs(
5838: pLineId => pLineId,
5839: pModelId => pModelId,
5840: pConfigId => pConfigId);
5841:

Line 5946: -- CTO_UTILITY_PK.convert_uom is a wrapper for INV_CONVERT.inv_um_convert to translate

5942: is
5943:
5944: -- The two cursors ato_weight and ato_volume have the
5945: -- same WHERE clause. The only difference is weight vs. volume.
5946: -- CTO_UTILITY_PK.convert_uom is a wrapper for INV_CONVERT.inv_um_convert to translate
5947: -- -9999 (error value) into 0 (no weight/volume).
5948:
5949:
5950: -- We need to figure out qty-per and then weight of each component in the shipping org,

Line 5969: CTO_UTILITY_PK.convert_uom(l.order_quantity_uom,

5965:
5966:
5967: CURSOR ato_weight(x_a_line_id NUMBER) IS
5968: SELECT SUM( NVL(msi.unit_weight, 0) *
5969: CTO_UTILITY_PK.convert_uom(l.order_quantity_uom,
5970: msi.primary_uom_code,
5971: Round( ( l.ordered_quantity / l_model.ordered_quantity), 7) , /* Support Decimal-Qty for Option Items */
5972: l.inventory_item_id) ) weight,
5973: msi.weight_uom_code uom,

Line 6004: CTO_UTILITY_PK.convert_uom(l.order_quantity_uom,

6000:
6001:
6002: CURSOR ato_volume(x_a_line_id NUMBER) IS
6003: SELECT SUM( NVL(msi.unit_volume, 0) *
6004: CTO_UTILITY_PK.convert_uom(l.order_quantity_uom,
6005: msi.primary_uom_code,
6006: Round( ( l.ordered_quantity / l_model.ordered_quantity) , 7) , /* Support Decimal-Qty for Option Items */
6007: l.inventory_item_id) ) volume,
6008: msi.volume_uom_code uom,

Line 6074: lweight := CTO_UTILITY_PK.convert_uom(

6070: IF PG_DEBUG <> 0 THEN
6071: oe_debug_pub.add ('Create_Item: ' || '===>aw.weight = '||aw.weight||' uom = '||aw.uom||' for item_id '||aw.inventory_item_id,1);
6072: END IF;
6073: -- Bugfix 2301167: Added item_id as a parameter so that item specific conversions take precedence if defined.
6074: lweight := CTO_UTILITY_PK.convert_uom(
6075: from_uom => aw.uom,
6076: to_uom => weight_uom,
6077: quantity => aw.weight,
6078: item_id => aw.inventory_item_id);

Line 6131: lvolume := CTO_UTILITY_PK.convert_uom(

6127: IF PG_DEBUG <> 0 THEN
6128: oe_debug_pub.add ('Create_Item: ' || '===>av.volume = '||av.volume||' uom = '||av.uom||' for item_id '||av.inventory_item_id,1);
6129: END IF;
6130: -- Bugfix 2301167: Added item_id as a parameter so that item specific conversions take precedence if defined.
6131: lvolume := CTO_UTILITY_PK.convert_uom(
6132: from_uom => av.uom,
6133: to_uom => volume_uom,
6134: quantity => av.volume,
6135: item_id => av.inventory_item_id);

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

6317:
6318:
6319: lStmtNumber := 200;
6320:
6321: if ( v_program_id = CTO_UTILITY_PK.PC_BOM_PROGRAM_ID ) then
6322:
6323: lValidationOrg := CTO_UTILITY_PK.PC_BOM_VALIDATION_ORG ;
6324:
6325: else

Line 6323: lValidationOrg := CTO_UTILITY_PK.PC_BOM_VALIDATION_ORG ;

6319: lStmtNumber := 200;
6320:
6321: if ( v_program_id = CTO_UTILITY_PK.PC_BOM_PROGRAM_ID ) then
6322:
6323: lValidationOrg := CTO_UTILITY_PK.PC_BOM_VALIDATION_ORG ;
6324:
6325: else
6326:
6327: /*