APPS.CTO_AUTO_PROCURE_PK dependencies on PO_LINES

Line 1424: l_new_unit_price po_lines.unit_price%TYPE;

1420: p_rate_type po_headers.rate_type%TYPE;
1421: p_rate po_headers.rate%TYPE;
1422: p_org_id po_headers.org_id%TYPE;
1423:
1424: l_new_unit_price po_lines.unit_price%TYPE;
1425: --l_extended_precision NUMBER;
1426: lStmtNo NUMBER;
1427: PRECISION number; /* number of digits to right of decimal*/
1428: ext_precision number; /* precision if more precision needed*/

Line 3479: From po_lines_all pol,

3475: begin
3476:
3477: Select 'X'
3478: into line_exists
3479: From po_lines_all pol,
3480: Po_headers_all poh
3481: Where
3482: poh.type_lookup_code = 'BLANKET'
3483: AND poh.approved_flag = 'Y'

Line 3526: l_po_uom_code po_lines_all.unit_meas_lookup_code%type;

3522: l_model_qty Number := 0;
3523: l_ratio Number;
3524: l_prim_uom_qty Number;
3525: l_prim_uom Bom_cto_order_lines.order_quantity_uom%type;
3526: l_po_uom_code po_lines_all.unit_meas_lookup_code%type;
3527: l_po_uom Bom_cto_order_lines.order_quantity_uom%type;
3528: l_conv_qty Number;
3529: l_model_po_uom Bom_cto_order_lines.order_quantity_uom%type;
3530: l_model_order_uom Bom_cto_order_lines.order_quantity_uom%type;

Line 3580: From po_lines_all pol,

3576: Select pol.unit_price,
3577: muom.uom_code
3578: into l_unit_price,
3579: l_po_uom
3580: From po_lines_all pol,
3581: Po_headers_all poh,
3582: mtl_units_of_measure muom
3583: Where
3584: poh.type_lookup_code = 'BLANKET'

Line 3804: oe_debug_pub.add(lpad(' ',g_pg_level) || 'insert_blanket_line: ' || 'Inerting into po_lines_interface',1);

3800:
3801:
3802:
3803: IF PG_DEBUG <> 0 THEN
3804: oe_debug_pub.add(lpad(' ',g_pg_level) || 'insert_blanket_line: ' || 'Inerting into po_lines_interface',1);
3805:
3806: oe_debug_pub.add(lpad(' ',g_pg_level) || 'insert_blanket_line: ' || 'Start date = '||to_char(p_start_date),2);
3807:
3808: oe_debug_pub.add(lpad(' ',g_pg_level) || 'insert_blanket_line: ' || 'End date ='||to_char(p_end_date),2);

Line 3826: Insert into po_lines_interface(

3822: -- Done by Renga Kannan on 04/30/04
3823: -- Allow_price_override_flag and not_to_exceed_price should not be
3824: -- copied from model as it will not make any sense. And there
3825: -- no way to derive these fileds also.
3826: Insert into po_lines_interface(
3827: interface_line_id,
3828: interface_header_id,
3829: Line_num,
3830: line_type_id,

Line 3858: po_lines_interface_s.nextval,

3854: tax_code_id,
3855: effective_date,
3856: expiration_date)
3857: select
3858: po_lines_interface_s.nextval,
3859: p_int_header_id,
3860: null,
3861: pol.line_type_id,
3862: p_item_id,

Line 3890: from po_lines_all pol,

3886: pol.closed_date,
3887: pol.tax_code_id,
3888: decode(poh.start_date,null,p_start_date,poh.start_date),
3889: decode(poh.end_date,null,p_end_date,poh.end_date)
3890: from po_lines_all pol,
3891: po_headers_all poh
3892: where pol.po_line_id =p_doc_line_id
3893: and poh.po_header_id = pol.po_header_id;
3894:

Line 3904: Insert into Po_lines_interface(

3900:
3901: -- Modified by Renga Kannan on 04/16/2002
3902: -- Added ship_to_location_id in the interface table.
3903:
3904: Insert into Po_lines_interface(
3905: interface_line_id,
3906: interface_header_id,
3907: line_num,
3908: shipment_num,

Line 3946: po_lines_interface_s.nextval,

3942: shipment_attribute15,
3943: last_update_date)
3944: --price_override) -- Check with Beth
3945: select
3946: po_lines_interface_s.nextval,
3947: p_int_header_id,
3948: null,
3949: poll.shipment_num,
3950: poll.shipment_type,

Line 3994: po_lines_all pol

3990: sysdate
3991: -- p_price*poll.price_discount/100
3992: -- price_discount
3993: from po_line_locations_all poll,
3994: po_lines_all pol
3995: where pol.po_line_id = p_doc_line_id
3996: and pol.po_line_id = poll.po_line_id;
3997:
3998: IF PG_DEBUG <> 0 THEN