APPS.CTO_AUTO_PROCURE_PK dependencies on CTO_UTILITY_PK

Line 850: CTO_UTILITY_PK.check_cto_can_create_supply (

846: --and custom api CTO_CUSTOM_SUPPLY_CHECK_PK.Check_Supply.
847: --Enhacement for R12 is, concurrent program should not create supply
848: --if custom api returns 'N'
849:
850: CTO_UTILITY_PK.check_cto_can_create_supply (
851: P_config_item_id => so_line.inventory_item_id,
852: P_org_id => so_line.ship_from_org_id,
853: x_can_create_supply => v_can_create_supply,--declare
854: p_source_type => v_source_type,

Line 1114: l_source_document_type_id := cto_utility_pk.get_source_document_id ( pLineId => so_line.line_id );

1110: -- Req/PO/Inv. The status will not be changed to PO_REQ_REQUESTED.
1111: l_inv_quantity := 0;
1112:
1113: -- get the line document_id
1114: l_source_document_type_id := cto_utility_pk.get_source_document_id ( pLineId => so_line.line_id );
1115:
1116: select sum(nvl(reservation_quantity, 0))
1117: into l_inv_quantity
1118: from mtl_reservations

Line 2389: l_source_document_type_id := CTO_UTILITY_PK.get_source_document_id ( p_line_id );

2385: l_source_document_type_id NUMBER;
2386:
2387: BEGIN
2388: -- get the document ID from
2389: l_source_document_type_id := CTO_UTILITY_PK.get_source_document_id ( p_line_id );
2390:
2391: -- get all the lines from the so_lines
2392: -- for the line_id passed into the cursor
2393: FOR so_line in get_so_line ( p_line_id ) LOOP

Line 2844: l_prim_uom_qty := CTO_UTILITY_PK.convert_uom(

2840:
2841: if nvl( pur_comp.list_price_per_unit,0) <> 0 then
2842:
2843: lStmtNumber := 40;
2844: l_prim_uom_qty := CTO_UTILITY_PK.convert_uom(
2845: from_uom => pur_comp.uom_code,
2846: to_uom => pur_comp.prim_uom_code,
2847: quantity => pur_comp.comp_qty,
2848: item_id => pur_comp.comp_item_id);

Line 3601: l_conv_qty := CTO_UTILITY_PK.convert_uom(

3597: or (pol.po_line_id = p_doc_line_id)
3598: )
3599: AND muom.unit_of_measure = unit_meas_lookup_code
3600: AND rownum = 1; -- Added by renga Kannan on 04/15/02
3601: l_conv_qty := CTO_UTILITY_PK.convert_uom(
3602: from_uom => buy_comps.uom_code,
3603: to_uom => l_po_uom,
3604: quantity => buy_comps.comp_qty,
3605: item_id => buy_comps.comp_item_id);

Line 3622: l_conv_qty := CTO_UTILITY_PK.convert_uom(

3618: l_unit_price := 0;
3619: End;
3620: If l_unit_price <> 0 then
3621: -- Comvert the UOM here
3622: l_conv_qty := CTO_UTILITY_PK.convert_uom(
3623: from_uom => buy_Comps.uom_code,
3624: to_uom => l_po_uom,
3625: quantity => buy_comps.comp_qty,
3626: item_id => buy_comps.comp_item_id);