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 1902: CTO_UTILITY_PK.convert_uom(

1898: nvl(oel.component_sequence_id,1), --1902818
1899: oel.inventory_item_id,
1900: 0, -- Plan level
1901: -- 1998386
1902: CTO_UTILITY_PK.convert_uom(
1903: oel.order_quantity_uom,
1904: msi.primary_uom_code,
1905: oel.ordered_quantity,
1906: oel.inventory_item_id),

Line 1970: CTO_UTILITY_PK.convert_uom(

1966: -- if the order UOM is different from primary UOM of the item .
1967: -- If ordered UOM and primary UOM are same,the function
1968: -- returns the ordered quantity.
1969:
1970: CTO_UTILITY_PK.convert_uom(
1971: oel.order_quantity_uom,
1972: msi.primary_uom_code,
1973: oel.ordered_quantity,
1974: oel.inventory_item_id),

Line 2009: CTO_UTILITY_PK.convert_uom(

2005: -- if the order UOM is different from primary UOM of the item .
2006: -- If ordered UOM and primary UOM are same,the function
2007: -- returns the ordered quantity.
2008:
2009: CTO_UTILITY_PK.convert_uom(
2010: oel.order_quantity_uom,
2011: msi.primary_uom_code,
2012: oel.ordered_quantity,
2013: oel.inventory_item_id),

Line 2400: CTO_UTILITY_PK.convert_uom(

2396: 2,
2397: nvl(oel.component_sequence_id,1),
2398: oel.inventory_item_id,
2399: 0,
2400: CTO_UTILITY_PK.convert_uom(
2401: oel.order_quantity_uom,
2402: msi.primary_uom_code,
2403: oel.ordered_quantity,
2404: oel.inventory_item_id),

Line 2459: CTO_UTILITY_PK.convert_uom(

2455: 2,
2456: oel.component_sequence_id,
2457: oel.inventory_item_id,
2458: level_number,
2459: CTO_UTILITY_PK.convert_uom(
2460: oel.order_quantity_uom,
2461: msi.primary_uom_code,
2462: oel.ordered_quantity,
2463: oel.inventory_item_id),

Line 2863: CTO_UTILITY_PK.convert_uom(

2859: 1,
2860: p_ship_set.source_organization_id(i),
2861: p_ship_set.inventory_item_id(i),
2862: 1,
2863: CTO_UTILITY_PK.convert_uom(
2864: p_ship_set.quantity_uom(i),
2865: msi.primary_uom_code,
2866: p_ship_set.quantity_ordered(i),
2867: p_ship_set.inventory_item_id(i)),

Line 2908: CTO_UTILITY_PK.convert_uom(

2904: p_ship_set.source_organization_id(p_model_index),
2905: 2, -- BUG no 1288823 modification
2906: p_ship_set.inventory_item_id(p_model_index),
2907: 0,
2908: CTO_UTILITY_PK.convert_uom(
2909: p_ship_set.quantity_uom(p_model_index),
2910: msi.primary_uom_code,
2911: p_ship_set.quantity_ordered(p_model_index),
2912: p_ship_set.inventory_item_id(p_model_index)),

Line 2961: CTO_UTILITY_PK.convert_uom(

2957: -- quantity if the order UOM is different from primary UOM of the item.
2958: -- If ordered UOM and primary UOM are same
2959: -- the function returns the ordered quantity.
2960:
2961: CTO_UTILITY_PK.convert_uom(
2962: bet2.primary_uom_code,
2963: msi.primary_uom_code,
2964: bet2.extended_quantity,
2965: bic.component_item_id),

Line 3329: CTO_UTILITY_PK.convert_uom(

3325: 1,
3326: p_ship_set.source_organization_id(i),
3327: p_ship_set.inventory_item_id(i),
3328: 1,
3329: CTO_UTILITY_PK.convert_uom(
3330: p_ship_set.quantity_uom(i),
3331: msi.primary_uom_code,
3332: p_ship_set.quantity_ordered(i),
3333: p_ship_set.inventory_item_id(i)),

Line 3367: CTO_UTILITY_PK.convert_uom(

3363: p_ship_set.source_organization_id(p_model_index),
3364: 2, -- BUG no 1288823 modification
3365: p_ship_set.inventory_item_id(p_model_index),
3366: 0,
3367: CTO_UTILITY_PK.convert_uom(
3368: p_ship_set.quantity_uom(p_model_index),
3369: msi.primary_uom_code,
3370: p_ship_set.quantity_ordered(p_model_index),
3371: p_ship_set.inventory_item_id(p_model_index)),

Line 3412: CTO_UTILITY_PK.convert_uom(

3408: bet.organization_id,
3409: 2,
3410: bic.component_item_id,
3411: level_number,
3412: CTO_UTILITY_PK.convert_uom(
3413: bet2.primary_uom_code,
3414: msi.primary_uom_code,
3415: bet2.extended_quantity,
3416: bic.component_item_id),

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

4162:
4163:
4164: /* BUG #1957336 Change for preconfigure bom by Sushant Sawant */
4165: /* Changes for patchset J
4166: if( v_program_id = CTO_UTILITY_PK.PC_BOM_PROGRAM_ID ) then
4167: */
4168:
4169:
4170: oe_debug_pub.add('Create_Item: ' || 'p_mode ' || p_mode ,2);

Line 4174: lValidationOrg := CTO_UTILITY_PK.PC_BOM_VALIDATION_ORG ;

4170: oe_debug_pub.add('Create_Item: ' || 'p_mode ' || p_mode ,2);
4171:
4172: if( p_mode = 'PRECONFIG' ) then
4173:
4174: lValidationOrg := CTO_UTILITY_PK.PC_BOM_VALIDATION_ORG ;
4175:
4176: else
4177:
4178: IF PG_DEBUG <> 0 THEN

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

4257: oe_debug_pub.add('Create_Item: ' || 'Number Method is : ' || lNumberMethod,2 );
4258: END IF;
4259:
4260: /* BUG #2172057 Change for preconfigure bom by Sushant Sawant */
4261: if( v_program_id = CTO_UTILITY_PK.PC_BOM_PROGRAM_ID ) then
4262: -- 2663450 : Change the NumberMethod only when it is <> 4.
4263: if lNumberMethod <> 4 then
4264: lNumberMethod := 1 ;
4265: end if;

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

4417: Call to user Defined Method
4418: +--------------------------*/
4419: -- bugfix 2663450: call custom api ..
4420:
4421: if( v_program_id = CTO_UTILITY_PK.PC_BOM_PROGRAM_ID ) then
4422: new_item_num := CTO_CUSTOM_CONFIG_NUMBER.user_item_number
4423: ( model_item_id => pModelId,
4424: model_line_id => NULL,
4425: param1 => NULL,

Line 5497: (select CTO_UTILITY_PK.convert_uom(

5493:
5494: if (o_weight_uom is not null) then
5495: update mtl_system_items a
5496: set (unit_weight, weight_uom_code) =
5497: (select CTO_UTILITY_PK.convert_uom(
5498: o_weight_uom,
5499: nvl( b.weight_uom_code, o_weight_uom) , -- bug# 3358194
5500: o_weight,
5501: b.inventory_item_id)

Line 5513: (select CTO_UTILITY_PK.convert_uom(

5509:
5510: if (o_volume_uom is not null) then -- begin bugfix 4143695
5511: update mtl_system_items a
5512: set (unit_volume, volume_uom_code) =
5513: (select CTO_UTILITY_PK.convert_uom(
5514: o_volume_uom,
5515: nvl(b.volume_uom_code, o_volume_uom), -- bug# 3358194
5516: o_volume,
5517: b.inventory_item_id)

Line 5629: CTO_UTILITY_PK.Create_Sourcing_Rules(

5625: --
5626: IF PG_DEBUG <> 0 THEN
5627: 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);
5628: END IF;
5629: CTO_UTILITY_PK.Create_Sourcing_Rules(
5630: pModelItemId => pModelId,
5631: pConfigId => pConfigId,
5632: pRcvOrgId => v_src_rule.rcv_org_id,
5633: x_return_status => lReturnStatus,

Line 5659: lStatus := CTO_UTILITY_PK.Update_Order_Lines(

5655: -- update bom_cto_order_lines with new config item
5656: --
5657:
5658: lStmtNumber := 120;
5659: lStatus := CTO_UTILITY_PK.Update_Order_Lines(
5660: pLineId => pLineId,
5661: pModelId => pModelId,
5662: pConfigId => pConfigId);
5663:

Line 5678: lStatus := CTO_UTILITY_PK.Update_Src_Orgs(

5674: -- update bom_cto_src_orgs with new config item
5675: --
5676:
5677: lStmtNumber := 130;
5678: lStatus := CTO_UTILITY_PK.Update_Src_Orgs(
5679: pLineId => pLineId,
5680: pModelId => pModelId,
5681: pConfigId => pConfigId);
5682:

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

5783: is
5784:
5785: -- The two cursors ato_weight and ato_volume have the
5786: -- same WHERE clause. The only difference is weight vs. volume.
5787: -- CTO_UTILITY_PK.convert_uom is a wrapper for INV_CONVERT.inv_um_convert to translate
5788: -- -9999 (error value) into 0 (no weight/volume).
5789:
5790:
5791: -- We need to figure out qty-per and then weight of each component in the shipping org,

Line 5810: CTO_UTILITY_PK.convert_uom(l.order_quantity_uom,

5806:
5807:
5808: CURSOR ato_weight(x_a_line_id NUMBER) IS
5809: SELECT SUM( NVL(msi.unit_weight, 0) *
5810: CTO_UTILITY_PK.convert_uom(l.order_quantity_uom,
5811: msi.primary_uom_code,
5812: Round( ( l.ordered_quantity / l_model.ordered_quantity), 7) , /* Support Decimal-Qty for Option Items */
5813: l.inventory_item_id) ) weight,
5814: msi.weight_uom_code uom,

Line 5845: CTO_UTILITY_PK.convert_uom(l.order_quantity_uom,

5841:
5842:
5843: CURSOR ato_volume(x_a_line_id NUMBER) IS
5844: SELECT SUM( NVL(msi.unit_volume, 0) *
5845: CTO_UTILITY_PK.convert_uom(l.order_quantity_uom,
5846: msi.primary_uom_code,
5847: Round( ( l.ordered_quantity / l_model.ordered_quantity) , 7) , /* Support Decimal-Qty for Option Items */
5848: l.inventory_item_id) ) volume,
5849: msi.volume_uom_code uom,

Line 5913: lweight := CTO_UTILITY_PK.convert_uom(

5909: IF PG_DEBUG <> 0 THEN
5910: oe_debug_pub.add ('Create_Item: ' || '===>aw.weight = '||aw.weight||' uom = '||aw.uom||' for item_id '||aw.inventory_item_id,1);
5911: END IF;
5912: -- Bugfix 2301167: Added item_id as a parameter so that item specific conversions take precedence if defined.
5913: lweight := CTO_UTILITY_PK.convert_uom(
5914: from_uom => aw.uom,
5915: to_uom => weight_uom,
5916: quantity => aw.weight,
5917: item_id => aw.inventory_item_id);

Line 5957: lvolume := CTO_UTILITY_PK.convert_uom(

5953: IF PG_DEBUG <> 0 THEN
5954: oe_debug_pub.add ('Create_Item: ' || '===>av.volume = '||av.volume||' uom = '||av.uom||' for item_id '||av.inventory_item_id,1);
5955: END IF;
5956: -- Bugfix 2301167: Added item_id as a parameter so that item specific conversions take precedence if defined.
5957: lvolume := CTO_UTILITY_PK.convert_uom(
5958: from_uom => av.uom,
5959: to_uom => volume_uom,
5960: quantity => av.volume,
5961: item_id => av.inventory_item_id);

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

6132:
6133:
6134: lStmtNumber := 200;
6135:
6136: if ( v_program_id = CTO_UTILITY_PK.PC_BOM_PROGRAM_ID ) then
6137:
6138: lValidationOrg := CTO_UTILITY_PK.PC_BOM_VALIDATION_ORG ;
6139:
6140: else

Line 6138: lValidationOrg := CTO_UTILITY_PK.PC_BOM_VALIDATION_ORG ;

6134: lStmtNumber := 200;
6135:
6136: if ( v_program_id = CTO_UTILITY_PK.PC_BOM_PROGRAM_ID ) then
6137:
6138: lValidationOrg := CTO_UTILITY_PK.PC_BOM_VALIDATION_ORG ;
6139:
6140: else
6141:
6142: /*