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.PO_INTERFACE_S dependencies on PO_LINES_INTERFACE

Line 313: po_lines_interface pli,

309: , pli.supplier_part_auxid supplier_part_auxid
310: , pli.catalog_name catalog_name
311: --
312: FROM po_headers_interface phi,
313: po_lines_interface pli,
314: po_distributions_interface pdi
315: WHERE phi.interface_header_id = pli.interface_header_id
316: AND pli.interface_line_id = pdi.interface_line_id
317: AND phi.interface_header_id = x_interface_header_id

Line 356: ** in the po_lines_interface table. Thie determines

352: g_rate_for_req_fields NUMBER; --
353: g_line_requesting_ou_id PO_REQUISITION_LINES_ALL.org_id%TYPE; --
354:
355: /* Global variable to hold number of req lines
356: ** in the po_lines_interface table. Thie determines
357: ** if we copy project_id, task_id from req to rfq
358: */
359: g_req_lines_to_process number:=0;
360:

Line 909: update po_lines_interface pli

905: -- and prl.auction_line_number<>pli.auction_line_number)" in the
906: --following sql.
907:
908: l_progress:='060';
909: update po_lines_interface pli
910: set pli.requisition_line_id= null
911: where pli.interface_header_id= x_interface_header_id
912: and exists
913: (select requisition_line_id

Line 934: UPDATE po_lines_interface pli

930: p_token => l_progress,
931: p_message => 'Sourcing to PO FPH-1: before the update for withdrawn reqs');
932: END IF;
933:
934: UPDATE po_lines_interface pli
935: SET pli.requisition_line_id= null
936: WHERE pli.interface_header_id= x_interface_header_id
937: AND NOT EXISTS
938: (SELECT requisition_line_id

Line 961: FROM po_lines_interface

957: * project/task reference from RFQ to Quote
958: */
959: SELECT count(*)
960: INTO g_req_lines_to_process
961: FROM po_lines_interface
962: WHERE interface_header_id = x_interface_header_id;
963:
964: l_progress:='090';
965:

Line 1372: from po_lines_interface

1368: END IF;
1369:
1370: select distinct 'Y'
1371: into X_line_found
1372: from po_lines_interface
1373: where interface_header_id = x_interface_header_id
1374: and line_num is not null;
1375:
1376: IF g_debug_stmt THEN --< Bug 3210331: use proper debugging >

Line 1379: p_message => 'Create PO : Line found in po_lines_interfaces');

1375:
1376: IF g_debug_stmt THEN --< Bug 3210331: use proper debugging >
1377: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
1378: p_token => l_progress,
1379: p_message => 'Create PO : Line found in po_lines_interfaces');
1380: END IF;
1381:
1382: EXCEPTION
1383: WHEN OTHERS THEN

Line 2757: l_quantity_in_ga_uom PO_LINES_INTERFACE.quantity%TYPE;

2753:
2754: -- Bug 2735840 START
2755: l_uom_convert varchar2(2) := fnd_profile.value('PO_REQ_BPA_UOM_CONVERT');
2756: l_ga_uom PO_LINES.unit_meas_lookup_code%TYPE;
2757: l_quantity_in_ga_uom PO_LINES_INTERFACE.quantity%TYPE;
2758: l_conversion_rate number :=1;
2759: -- Bug 2735840 END
2760:
2761: -- Bug 2875346.

Line 7895: l_interface_line_id PO_LINES_INTERFACE.interface_line_id%TYPE;

7891: l_new_ccid_generated BOOLEAN := FALSE;
7892: l_FB_ERROR_MSG VARCHAR2(2000);
7893:
7894: l_return_status VARCHAR2(1);
7895: l_interface_line_id PO_LINES_INTERFACE.interface_line_id%TYPE;
7896: l_old_interface_line_id PO_LINES_INTERFACE.interface_line_id%TYPE := -1;
7897: l_interface_distribution_id PO_DISTRIBUTIONS_INTERFACE.interface_distribution_id%TYPE;
7898: l_item_category_id PO_LINES_INTERFACE.category_id%TYPE;
7899: l_req_charge_account_id PO_DISTRIBUTIONS_INTERFACE.charge_account_id%TYPE;

Line 7896: l_old_interface_line_id PO_LINES_INTERFACE.interface_line_id%TYPE := -1;

7892: l_FB_ERROR_MSG VARCHAR2(2000);
7893:
7894: l_return_status VARCHAR2(1);
7895: l_interface_line_id PO_LINES_INTERFACE.interface_line_id%TYPE;
7896: l_old_interface_line_id PO_LINES_INTERFACE.interface_line_id%TYPE := -1;
7897: l_interface_distribution_id PO_DISTRIBUTIONS_INTERFACE.interface_distribution_id%TYPE;
7898: l_item_category_id PO_LINES_INTERFACE.category_id%TYPE;
7899: l_req_charge_account_id PO_DISTRIBUTIONS_INTERFACE.charge_account_id%TYPE;
7900: l_req_variance_account_id PO_DISTRIBUTIONS_INTERFACE.variance_account_id%TYPE;

Line 7898: l_item_category_id PO_LINES_INTERFACE.category_id%TYPE;

7894: l_return_status VARCHAR2(1);
7895: l_interface_line_id PO_LINES_INTERFACE.interface_line_id%TYPE;
7896: l_old_interface_line_id PO_LINES_INTERFACE.interface_line_id%TYPE := -1;
7897: l_interface_distribution_id PO_DISTRIBUTIONS_INTERFACE.interface_distribution_id%TYPE;
7898: l_item_category_id PO_LINES_INTERFACE.category_id%TYPE;
7899: l_req_charge_account_id PO_DISTRIBUTIONS_INTERFACE.charge_account_id%TYPE;
7900: l_req_variance_account_id PO_DISTRIBUTIONS_INTERFACE.variance_account_id%TYPE;
7901: l_destination_organization_id PO_DISTRIBUTIONS_INTERFACE.destination_organization_id%TYPE;
7902: l_destination_ou_id PO_HEADERS_ALL.org_id%TYPE;

Line 7904: l_item_id PO_LINES_INTERFACE.item_id%TYPE;

7900: l_req_variance_account_id PO_DISTRIBUTIONS_INTERFACE.variance_account_id%TYPE;
7901: l_destination_organization_id PO_DISTRIBUTIONS_INTERFACE.destination_organization_id%TYPE;
7902: l_destination_ou_id PO_HEADERS_ALL.org_id%TYPE;
7903:
7904: l_item_id PO_LINES_INTERFACE.item_id%TYPE;
7905: l_category_id PO_LINES_INTERFACE.category_id%TYPE;
7906: l_destination_type_code PO_DISTRIBUTIONS_ALL.destination_type_code%TYPE;
7907: --l_ship_to_organization_id NUMBER;
7908: l_ship_to_location_id PO_DISTRIBUTIONS_INTERFACE.deliver_to_location_id%TYPE;

Line 7905: l_category_id PO_LINES_INTERFACE.category_id%TYPE;

7901: l_destination_organization_id PO_DISTRIBUTIONS_INTERFACE.destination_organization_id%TYPE;
7902: l_destination_ou_id PO_HEADERS_ALL.org_id%TYPE;
7903:
7904: l_item_id PO_LINES_INTERFACE.item_id%TYPE;
7905: l_category_id PO_LINES_INTERFACE.category_id%TYPE;
7906: l_destination_type_code PO_DISTRIBUTIONS_ALL.destination_type_code%TYPE;
7907: --l_ship_to_organization_id NUMBER;
7908: l_ship_to_location_id PO_DISTRIBUTIONS_INTERFACE.deliver_to_location_id%TYPE;
7909: l_deliver_to_person_id PO_DISTRIBUTIONS_INTERFACE.deliver_to_person_id%TYPE;

Line 7910: l_line_type_id PO_LINES_INTERFACE.line_type_id%TYPE;

7906: l_destination_type_code PO_DISTRIBUTIONS_ALL.destination_type_code%TYPE;
7907: --l_ship_to_organization_id NUMBER;
7908: l_ship_to_location_id PO_DISTRIBUTIONS_INTERFACE.deliver_to_location_id%TYPE;
7909: l_deliver_to_person_id PO_DISTRIBUTIONS_INTERFACE.deliver_to_person_id%TYPE;
7910: l_line_type_id PO_LINES_INTERFACE.line_type_id%TYPE;
7911: l_vendor_id PO_VENDORS.vendor_id%TYPE;
7912: l_agent_id PO_HEADERS.agent_id%TYPE;
7913: l_expenditure_organization_id PO_DISTRIBUTIONS_INTERFACE.expenditure_organization_id%TYPE;
7914: l_project_id PO_DISTRIBUTIONS_INTERFACE.project_id%TYPE;

Line 7941: l_req_line_id PO_LINES_INTERFACE.requisition_line_id%TYPE;

7937: l_dest_variance_account_flex VARCHAR2(2000);
7938: --< New start_workflow parameters in FPJ End >
7939:
7940: -- Bug 3463242 START
7941: l_req_line_id PO_LINES_INTERFACE.requisition_line_id%TYPE;
7942: --
7943: l_requesting_ou_id PO_REQUISITION_LINES_ALL.org_id%TYPE;
7944: l_unit_price PO_LINES_INTERFACE.unit_price%TYPE;
7945: l_base_unit_price PO_LINES_INTERFACE.base_unit_price%TYPE;

Line 7944: l_unit_price PO_LINES_INTERFACE.unit_price%TYPE;

7940: -- Bug 3463242 START
7941: l_req_line_id PO_LINES_INTERFACE.requisition_line_id%TYPE;
7942: --
7943: l_requesting_ou_id PO_REQUISITION_LINES_ALL.org_id%TYPE;
7944: l_unit_price PO_LINES_INTERFACE.unit_price%TYPE;
7945: l_base_unit_price PO_LINES_INTERFACE.base_unit_price%TYPE;
7946: l_amount PO_LINES_INTERFACE.amount%TYPE;
7947: l_quantity_dummy PO_LINES_INTERFACE.quantity%TYPE;
7948: l_order_type_lookup_code PO_LINE_TYPES_B.order_type_lookup_code%TYPE;

Line 7945: l_base_unit_price PO_LINES_INTERFACE.base_unit_price%TYPE;

7941: l_req_line_id PO_LINES_INTERFACE.requisition_line_id%TYPE;
7942: --
7943: l_requesting_ou_id PO_REQUISITION_LINES_ALL.org_id%TYPE;
7944: l_unit_price PO_LINES_INTERFACE.unit_price%TYPE;
7945: l_base_unit_price PO_LINES_INTERFACE.base_unit_price%TYPE;
7946: l_amount PO_LINES_INTERFACE.amount%TYPE;
7947: l_quantity_dummy PO_LINES_INTERFACE.quantity%TYPE;
7948: l_order_type_lookup_code PO_LINE_TYPES_B.order_type_lookup_code%TYPE;
7949: l_po_currency_code PO_HEADERS_INTERFACE.currency_code%TYPE;

Line 7946: l_amount PO_LINES_INTERFACE.amount%TYPE;

7942: --
7943: l_requesting_ou_id PO_REQUISITION_LINES_ALL.org_id%TYPE;
7944: l_unit_price PO_LINES_INTERFACE.unit_price%TYPE;
7945: l_base_unit_price PO_LINES_INTERFACE.base_unit_price%TYPE;
7946: l_amount PO_LINES_INTERFACE.amount%TYPE;
7947: l_quantity_dummy PO_LINES_INTERFACE.quantity%TYPE;
7948: l_order_type_lookup_code PO_LINE_TYPES_B.order_type_lookup_code%TYPE;
7949: l_po_currency_code PO_HEADERS_INTERFACE.currency_code%TYPE;
7950: l_req_header_rate_type PO_HEADERS_INTERFACE.rate_type%TYPE;

Line 7947: l_quantity_dummy PO_LINES_INTERFACE.quantity%TYPE;

7943: l_requesting_ou_id PO_REQUISITION_LINES_ALL.org_id%TYPE;
7944: l_unit_price PO_LINES_INTERFACE.unit_price%TYPE;
7945: l_base_unit_price PO_LINES_INTERFACE.base_unit_price%TYPE;
7946: l_amount PO_LINES_INTERFACE.amount%TYPE;
7947: l_quantity_dummy PO_LINES_INTERFACE.quantity%TYPE;
7948: l_order_type_lookup_code PO_LINE_TYPES_B.order_type_lookup_code%TYPE;
7949: l_po_currency_code PO_HEADERS_INTERFACE.currency_code%TYPE;
7950: l_req_header_rate_type PO_HEADERS_INTERFACE.rate_type%TYPE;
7951: l_req_header_rate_date PO_HEADERS_INTERFACE.rate_date%TYPE;

Line 8008: PO_LINES_INTERFACE pli,

8004: phi.rate,
8005: pdi.rate
8006: -- Bug 3463242 END
8007: FROM PO_DISTRIBUTIONS_INTERFACE pdi,
8008: PO_LINES_INTERFACE pli,
8009: PO_HEADERS_INTERFACE phi,
8010: PO_REQUISITION_LINES_ALL prl, --
8011: MTL_PARAMETERS mp,
8012: HR_ORGANIZATION_INFORMATION hoi,

Line 8338: UPDATE po_lines_interface

8334: END IF;
8335:
8336: IF l_interface_line_id <> l_old_interface_line_id THEN
8337: l_progress := '120';
8338: UPDATE po_lines_interface
8339: SET transaction_flow_header_id = l_transaction_flow_header_id
8340: WHERE interface_line_id = l_interface_line_id;
8341:
8342: IF g_debug_stmt THEN --< Bug 3210331: use proper debugging >

Line 8647: from po_lines_interface pli,

8643: pli.item_id,
8644: phi.vendor_id,
8645: phi.vendor_site_id,
8646: pdi.destination_organization_id
8647: from po_lines_interface pli,
8648: po_headers_interface phi,
8649: po_distributions_interface pdi
8650: where phi.interface_header_id = x_interface_header_id
8651: and phi.interface_header_id = pli.interface_header_id

Line 8678: FROM po_lines_interface pli,

8674: phi.rate,
8675: phi.rate_date,
8676: phi.document_subtype,
8677: pli.unit_price --
8678: FROM po_lines_interface pli,
8679: po_headers_interface phi,
8680: po_line_types plt
8681: WHERE phi.interface_header_id = x_interface_header_id
8682: AND phi.interface_header_id = pli.interface_header_id

Line 8702: -- the requisition line id would be null in po_lines_interface .

8698: -- If the line is OPM item with dual uom control then the shipment corresponding
8699: -- to the extra PO line created by Sourcing does not have secondary uom and
8700: -- secondary quantity with ship to organization as process org.
8701: -- default secondary UOM and secondary quantity in such a case (non req backed lines)
8702: -- the requisition line id would be null in po_lines_interface .
8703: -- need to handle that situation in the default_opm_attributes cursor.
8704: -- in case of non req back lines from sourcing , ship_to_organization_id is NULL.
8705: -- so get it from distribution interface table.
8706:

Line 8954: FROM po_lines_interface pli,

8950: l_progress:='090';
8951:
8952: SELECT min(interface_line_id)
8953: INTO x_min_interface_line_id
8954: FROM po_lines_interface pli,
8955: po_headers_interface phi
8956: WHERE phi.interface_header_id=pli.interface_header_id
8957: AND phi.interface_header_id = x_interface_header_id;
8958:

Line 9075: po_lines_interface pli

9071: null),
9072: phi.document_subtype,
9073: l_shipping_control --
9074: FROM po_headers_interface phi2,
9075: po_lines_interface pli
9076: WHERE phi2.interface_header_id = phi.interface_header_id
9077: AND pli.interface_header_id=phi2.interface_header_id
9078: AND pli.interface_line_id = x_min_interface_line_id)
9079: WHERE interface_header_id = x_interface_header_id;

Line 9134: UPDATE po_lines_interface pli2

9130: -- for x_uom_convert, since UOM checking is now handled in
9131: -- source_blanket_line.
9132:
9133: l_progress:='120';
9134: UPDATE po_lines_interface pli2
9135: SET (
9136: line_num,
9137: item_id,
9138: category_id,

Line 9238: FROM po_lines_interface pli,

9234: nvl(pli.preferred_grade,prl.preferred_grade),
9235: -- end of 1548597
9236: prl.drop_ship_flag, --
9237: prl.vmi_flag -- VMI FPH
9238: FROM po_lines_interface pli,
9239: po_headers_interface phi,
9240: po_requisition_lines_all prl, --
9241: po_line_types plt,
9242: po_lines_all pol --

Line 9266: UPDATE po_lines_interface pli2

9262:
9263: /* CONSIGNED FPI Start */
9264: ELSE -- CONSIGNED FPI
9265: l_progress:='130';
9266: UPDATE po_lines_interface pli2
9267: SET (
9268: po_header_id,
9269: negotiated_by_preparer_flag,
9270: firm_flag

Line 9276: FROM po_lines_interface pli,

9272: (SELECT
9273: x_po_header_id,
9274: nvl(pli.negotiated_by_preparer_flag,'N'),
9275: nvl(pli.firm_flag,'N')
9276: FROM po_lines_interface pli,
9277: po_headers_interface phi
9278: WHERE pli.interface_line_id = pli2.interface_line_id
9279: AND pli.interface_header_id = phi.interface_header_id
9280: AND phi.interface_header_id = x_interface_header_id);

Line 9314: UPDATE po_lines_interface pli2

9310: -- Added note_to_vendor - iali 08/26/99
9311: /*Bug 1391523 . Added market price to the update statement */
9312:
9313: l_progress:='150';
9314: UPDATE po_lines_interface pli2
9315: SET (
9316: line_num,
9317: item_id,
9318: job_id, --

Line 9433: FROM po_lines_interface pli,

9429: nvl(pli.expiration_date, prl.assignment_end_date),
9430: nvl(pli.contractor_first_name, prl.candidate_first_name),
9431: nvl(pli.contractor_last_name, prl.candidate_last_name)
9432: --
9433: FROM po_lines_interface pli,
9434: po_headers_interface phi,
9435: po_requisition_lines_all prl, --
9436: po_line_types plt
9437: WHERE pli.interface_line_id = pli2.interface_line_id

Line 9581: po_lines_interface pli,

9577: decode(pli.consigned_flag,'Y',null,
9578: prd.oke_contract_deliverable_id)
9579: FROM po_requisition_lines_all prl, --
9580: po_req_distributions_all prd, --
9581: po_lines_interface pli,
9582: po_headers_interface phi
9583: WHERE prd.requisition_line_id = prl.requisition_line_id
9584: AND prl.requisition_line_id = pli.requisition_line_id -- Bug:1563888
9585: AND pli.interface_header_id = phi.interface_header_id

Line 9768: update po_lines_interface

9764: x_vendor_product_num,
9765: x_purchasing_uom);
9766:
9767: if (x_vendor_product_num is not null) then
9768: update po_lines_interface
9769: set vendor_product_num = x_vendor_product_num
9770: where rowid = x_rowid;
9771:
9772: end if;

Line 9838: DELETE po_lines_interface

9834: DELETE po_line_locations_interface
9835: WHERE interface_header_id = x_interface_header_id;
9836: --
9837:
9838: DELETE po_lines_interface
9839: WHERE interface_header_id = x_interface_header_id;
9840:
9841:
9842: DELETE po_headers_interface

Line 9907: x_vmi_flag PO_LINES_INTERFACE.VMI_FLAG%TYPE; /* VMI FPH */

9903: x_bid_line_number number;
9904: x_row_id varchar2(25) := null;
9905: --
9906:
9907: x_vmi_flag PO_LINES_INTERFACE.VMI_FLAG%TYPE; /* VMI FPH */
9908: x_drop_ship_flag PO_LINES_INTERFACE.DROP_SHIP_FLAG%TYPE; --
9909:
9910: x_source_doc_id number; -- FPI GA
9911: x_source_doc_line_id number; -- FPI GA

Line 9908: x_drop_ship_flag PO_LINES_INTERFACE.DROP_SHIP_FLAG%TYPE; --

9904: x_row_id varchar2(25) := null;
9905: --
9906:
9907: x_vmi_flag PO_LINES_INTERFACE.VMI_FLAG%TYPE; /* VMI FPH */
9908: x_drop_ship_flag PO_LINES_INTERFACE.DROP_SHIP_FLAG%TYPE; --
9909:
9910: x_source_doc_id number; -- FPI GA
9911: x_source_doc_line_id number; -- FPI GA
9912:

Line 9915: l_supplier_ref_number PO_LINES_INTERFACE.supplier_ref_number%TYPE; --

9911: x_source_doc_line_id number; -- FPI GA
9912:
9913: x_consigned_flag VARCHAR2(1) := 'N'; --CONSIGNED FPI
9914: x_create_new_line VARCHAR2(1) := 'N'; --GA FPI
9915: l_supplier_ref_number PO_LINES_INTERFACE.supplier_ref_number%TYPE; --
9916:
9917: l_contract_id PO_LINES_ALL.contract_id%TYPE; --
9918:
9919: /* Bug 3201308 start */

Line 9945: FROM po_lines_interface pli

9941:
9942: /* Bug 1949160. Created a cursor to retrieve requisition line-id */
9943: CURSOR interface_lines_temp IS
9944: SELECT pli.requisition_line_id
9945: FROM po_lines_interface pli
9946: WHERE pli.interface_header_id = x_interface_header_id
9947: -- bug 4000047: start: requisition lines should be entered
9948: -- into PO the same order they appear in the requisition
9949: ORDER BY pli.requisition_line_id;

Line 9981: FROM po_lines_interface pli,

9977: pli.from_line_id, -- FPI GA
9978: pli.consigned_flag, -- CONSIGNED FPI
9979: pli.contract_id, --
9980: pli.supplier_ref_number --
9981: FROM po_lines_interface pli,
9982: po_distributions_interface pld
9983: WHERE pli.interface_header_id=x_interface_header_id
9984: AND pli.interface_line_id=pld.interface_line_id
9985: AND pld.interface_distribution_id =

Line 10074: UPDATE po_lines_interface pli

10070: -- use requisition numbers
10071:
10072: l_progress:='035';
10073:
10074: UPDATE po_lines_interface pli
10075: SET pli.shipment_num = 1,
10076: pli.line_num =
10077: (
10078: SELECT prl.line_num

Line 10102: UPDATE po_lines_interface pli

10098: EXIT WHEN interface_lines_temp%NOTFOUND;
10099:
10100: l_progress := '050';
10101:
10102: UPDATE po_lines_interface pli
10103: SET pli.line_num = x_count,
10104: pli.shipment_num = 1
10105: WHERE pli.requisition_line_id = x_requisition_line_id
10106: AND pli.interface_header_id = x_interface_header_id

Line 10202: FROM po_lines_interface pli

10198: SELECT MIN(pli.line_num),
10199: pli.po_line_id
10200: INTO x_po_line_num,
10201: x_po_line_id
10202: FROM po_lines_interface pli
10203: WHERE pli.interface_header_id = x_interface_header_id
10204: AND pli.line_num IS NOT NULL
10205: AND pli.line_type_id = x_line_type_id
10206: AND NVL(pli.item_id, -1) = NVL(x_item_id, -1)

Line 10249: UPDATE po_lines_interface pli

10245: p_token => l_progress,
10246: p_message => 'Group_interface_lines progress is :'|| l_progress);
10247: END IF; -- debug logging
10248:
10249: UPDATE po_lines_interface pli
10250: SET pli.line_num = x_po_line_num
10251: WHERE pli.interface_header_id = x_interface_header_id
10252: AND pli.requisition_line_id = x_requisition_line_id;
10253:

Line 10272: UPDATE po_lines_interface pli

10268: -- use requisition numbers
10269:
10270: l_progress := '100';
10271:
10272: UPDATE po_lines_interface pli
10273: SET pli.shipment_num =
10274: ( SELECT prl.line_num
10275: FROM po_requisition_lines_all prl
10276: WHERE prl.requisition_line_id = pli.requisition_line_id )

Line 10294: UPDATE po_lines_interface pli

10290: EXIT WHEN interface_lines_temp%NOTFOUND;
10291:
10292: l_progress := '110';
10293:
10294: UPDATE po_lines_interface pli
10295: SET pli.shipment_num = x_count
10296: WHERE pli.requisition_line_id = x_requisition_line_id
10297: AND pli.interface_header_id = x_interface_header_id
10298: AND pli.shipment_num IS NULL;

Line 10353: UPDATE po_lines_interface pli

10349: EXIT WHEN interface_lines_temp%NOTFOUND;
10350:
10351: l_progress := '150';
10352:
10353: UPDATE po_lines_interface pli
10354: SET pli.line_num = x_line_num + x_count,
10355: pli.shipment_num = 1
10356: WHERE pli.requisition_line_id = x_requisition_line_id
10357: AND pli.interface_header_id = x_interface_header_id

Line 10455: FROM po_lines_interface pli

10451: SELECT MIN(pli.line_num),
10452: pli.po_line_id
10453: INTO x_po_line_num,
10454: x_po_line_id
10455: FROM po_lines_interface pli
10456: WHERE pli.interface_header_id = x_interface_header_id
10457: AND pli.line_num IS NOT NULL
10458: AND pli.line_type_id = x_line_type_id
10459: AND NVL(pli.item_id, -1) = NVL(x_item_id, -1)

Line 10499: UPDATE po_lines_interface pli

10495: p_token => l_progress,
10496: p_message => 'Group_interface_lines: Line_num is :'|| x_po_line_num);
10497: END IF;
10498:
10499: UPDATE po_lines_interface pli
10500: SET pli.line_num = x_po_line_num
10501: WHERE pli.interface_header_id = x_interface_header_id
10502: AND pli.requisition_line_id = x_requisition_line_id;
10503:

Line 10548: -- statement and now updating the po_lines_interface in a loop using

10544: -- Prior to this fix, for Releases, the shipment number was
10545: -- derived by adding requisition line number to the current
10546: -- maximum shipment number. Due to this shipment numbers
10547: -- were getting skipped. Hence commented the following update
10548: -- statement and now updating the po_lines_interface in a loop using
10549: -- a cursor.
10550:
10551: OPEN interface_lines_temp;
10552: LOOP

Line 10560: UPDATE po_lines_interface pli

10556: EXIT WHEN interface_lines_temp%NOTFOUND;
10557:
10558: l_progress := '220';
10559:
10560: UPDATE po_lines_interface pli
10561: SET pli.shipment_num = x_shipment_num + x_count
10562: WHERE pli.requisition_line_id = x_requisition_line_id
10563: AND pli.interface_header_id = x_interface_header_id
10564: AND pli.line_num IS NOT NULL

Line 10597: FROM po_lines_interface pli

10593: -- Get maximum line number in interface table, to be used later
10594:
10595: SELECT NVL(max(pli.line_num), 0)
10596: INTO l_max_iface_line_num
10597: FROM po_lines_interface pli
10598: WHERE pli.interface_header_id = x_interface_header_id;
10599:
10600: --
10601:

Line 10654: UPDATE po_lines_interface pli

10650: -- to DEFAULT.
10651:
10652: -- Do not group; simply add 1 to each successive interface line
10653:
10654: UPDATE po_lines_interface pli
10655: SET pli.line_num = l_max_iface_line_num + 1
10656: WHERE pli.rowid = x_row_id
10657: AND pli.line_num IS NULL;
10658:

Line 11059: FROM po_lines_interface pli

11055: -- SQL Join: business logic for combining two lines
11056:
11057: SELECT min(pli.line_num)
11058: INTO x_po_line_num
11059: FROM po_lines_interface pli
11060: , po_requisition_lines_all prl
11061: , po_line_types_b PLT --
11062: WHERE pli.interface_header_id = x_interface_header_id
11063: AND pli.line_num is not null

Line 11218: FROM po_lines_interface pli

11214: END IF;
11215:
11216: SELECT MIN(pli.line_num)
11217: INTO x_po_line_num
11218: FROM po_lines_interface pli
11219: WHERE pli.interface_header_id = x_interface_header_id
11220: AND pli.line_num is not null
11221: AND pli.line_type_id = x_line_type_id
11222: AND nvl(pli.item_id, -1) = nvl(x_item_id, -1)

Line 11271: UPDATE po_lines_interface pli

11267:
11268: -- Since get_shipment_num will need it, we update the
11269: -- line number here.
11270:
11271: UPDATE po_lines_interface pli
11272: SET pli.line_num = x_po_line_num
11273: WHERE pli.interface_header_id = x_interface_header_id
11274: AND pli.requisition_line_id = x_requisition_line_id;
11275:

Line 11328: UPDATE po_lines_interface pli2

11324: --po_lines table as we are not supporting add to functionality.
11325:
11326: l_progress := '400';
11327:
11328: UPDATE po_lines_interface pli2
11329: SET (pli2.line_num, pli2.shipment_num) =
11330: (
11331: SELECT (NVL(max(pli.line_num), 0) + 1), 1
11332: FROM po_lines_interface pli

Line 11332: FROM po_lines_interface pli

11328: UPDATE po_lines_interface pli2
11329: SET (pli2.line_num, pli2.shipment_num) =
11330: (
11331: SELECT (NVL(max(pli.line_num), 0) + 1), 1
11332: FROM po_lines_interface pli
11333: WHERE pli.interface_header_id = x_interface_header_id
11334: )
11335: WHERE pli2.rowid = x_row_id;
11336:

Line 11371: p_message => 'Before select max line_num from po_lines_interface');

11367: l_progress:='420';
11368: IF g_debug_stmt THEN --< Bug 3210331: use proper debugging >
11369: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
11370: p_token => l_progress,
11371: p_message => 'Before select max line_num from po_lines_interface');
11372: END IF;
11373:
11374: SELECT NVL(max(pli.line_num), 0)
11375: INTO x_int_line_num

Line 11376: FROM po_lines_interface pli

11372: END IF;
11373:
11374: SELECT NVL(max(pli.line_num), 0)
11375: INTO x_int_line_num
11376: FROM po_lines_interface pli
11377: WHERE pli.interface_header_id = x_interface_header_id;
11378:
11379: IF (x_line_num >= x_int_line_num) THEN
11380: x_line_num := x_line_num;

Line 11396: UPDATE po_lines_interface pli

11392: END IF;
11393:
11394: IF (x_requisition_line_id IS NOT NULL) THEN
11395:
11396: UPDATE po_lines_interface pli
11397: SET pli.line_num = x_line_num + 1,
11398: pli.shipment_num = 1
11399: WHERE pli.interface_header_id = x_interface_header_id
11400: AND pli.requisition_line_id = x_requisition_line_id;

Line 11406: UPDATE po_lines_interface pli

11402: ELSE
11403:
11404: -- no backing req line; use rowid
11405:
11406: UPDATE po_lines_interface pli
11407: SET pli.line_num = x_line_num + 1,
11408: pli.shipment_num = 1
11409: WHERE pli.rowid = x_row_id;
11410:

Line 11518: FROM po_lines_interface PLI

11514: SELECT min(line_num)
11515: , po_line_id
11516: INTO x_po_line_num
11517: , x_po_line_id
11518: FROM po_lines_interface PLI
11519: , po_line_types_b PLT --
11520: WHERE pli.interface_header_id = x_interface_header_id
11521: AND pli.line_num is not null
11522: AND pli.LINE_TYPE_ID = x_line_type_id

Line 11561: UPDATE po_lines_interface pli

11557: END;
11558:
11559: l_progress := '470';
11560:
11561: UPDATE po_lines_interface pli
11562: SET pli.line_num = x_po_line_num
11563: WHERE pli.interface_header_id = x_interface_header_id
11564: AND pli.requisition_line_id = x_requisition_line_id;
11565:

Line 11571: p_message => 'After update of po_lines_interface line_num');

11567:
11568: IF g_debug_stmt THEN --< Bug 3210331: use proper debugging >
11569: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
11570: p_token => l_progress,
11571: p_message => 'After update of po_lines_interface line_num');
11572: END IF;
11573:
11574: ELSE
11575:

Line 11590: po_lines_interface pli

11586: SELECT pol.po_line_id
11587: INTO x_po_line_id
11588: FROM po_lines_all pol,
11589: po_headers_all poh,
11590: po_lines_interface pli
11591: WHERE pol.po_header_id = poh.po_header_id
11592: AND poh.segment1 = x_document_num
11593: AND NVL(poh.org_id, -99) = NVL(g_purchasing_ou_id, -99)
11594: AND poh.type_lookup_code = 'BLANKET' -- Bug# 1746943

Line 12299: FROM po_lines_interface pli,

12295: decode(psp.expense_accrual_code,'PERIOD END', 'N', 'Y')),
12296: 'INVENTORY', 'Y',
12297: 'SHOP FLOOR','Y')
12298: INTO x_receipt_required_flag
12299: FROM po_lines_interface pli,
12300: po_headers_interface phi,
12301: po_requisition_lines_all prl, --
12302: mtl_system_items msi,
12303: po_line_types plt,

Line 12362: FROM PO_LINES_INTERFACE PLI,

12358: SELECT PLI.shipment_num
12359: ,PLI.requisition_line_id
12360: INTO x_po_shipment_num
12361: ,x_req_line_to_check
12362: FROM PO_LINES_INTERFACE PLI,
12363: PO_REQUISITION_LINES_ALL PRL, --
12364: --bug 1942696 hr_location changes to reflect the new view
12365: MTL_SYSTEM_ITEMS MSI ,
12366: PO_LINE_TYPES PLT ,

Line 12484: FROM PO_LINES_INTERFACE PLI,

12480: to improve the performance
12481: */
12482: SELECT PLI.shipment_num
12483: INTO x_po_shipment_num
12484: FROM PO_LINES_INTERFACE PLI,
12485: PO_REQUISITION_LINES_ALL PRL, --
12486: MTL_SYSTEM_ITEMS MSI ,
12487: PO_LINE_TYPES PLT ,
12488: PO_SYSTEM_PARAMETERS_ALL PSP , --

Line 12611: FROM PO_LINES_INTERFACE PLI,

12607:
12608: l_progress:='190';
12609: SELECT PLI.shipment_num
12610: INTO x_po_shipment_num
12611: FROM PO_LINES_INTERFACE PLI,
12612: PO_REQUISITION_LINES_ALL PRL, --
12613: --bug 1942696 hr_location changes to reflect the new view
12614: MTL_SYSTEM_ITEMS MSI ,
12615: PO_LINE_TYPES PLT ,

Line 12751: update po_lines_interface

12747: */
12748:
12749: if x_requisition_line_id is not null then
12750: l_progress := '010';
12751: update po_lines_interface
12752: set shipment_num= x_po_shipment_num
12753: where interface_header_id=x_interface_header_id
12754: and requisition_line_id=x_requisition_line_id;
12755:

Line 12758: update po_lines_interface

12754: and requisition_line_id=x_requisition_line_id;
12755:
12756: else
12757: l_progress := '015';
12758: update po_lines_interface
12759: set shipment_num= x_po_shipment_num
12760: where interface_header_id=x_interface_header_id
12761: and rowid=x_row_id;
12762: end if;

Line 12808: from po_lines_interface pli

12804:
12805: l_progress := '040';
12806: select nvl(max(line_num),0)
12807: into x_int_line_num
12808: from po_lines_interface pli
12809: where pli.interface_header_id = x_interface_header_id;
12810:
12811: IF (x_line_num >= x_int_line_num) THEN
12812: x_line_num := x_line_num;

Line 12818: update po_lines_interface

12814: x_line_num := x_int_line_num;
12815: END IF;
12816:
12817: l_progress := '050';
12818: update po_lines_interface
12819: set line_num = x_line_num + 1
12820: where interface_header_id = x_interface_header_id
12821: and requisition_line_id = x_requisition_line_id;
12822: -- Bug 6072900

Line 12848: from po_lines_interface pli

12844: ** assigned in the interface table.
12845: */
12846: select nvl(max(shipment_num),0)
12847: into x_int_shipment_num
12848: from po_lines_interface pli
12849: where pli.interface_header_id = x_interface_header_id
12850: and pli.line_num = x_po_line_num;
12851:
12852: -- End of fix. Bug 605715, lpo, 01/05/98

Line 12882: from po_lines_interface pli

12878: ** assigned in the interface table.
12879: */
12880: select nvl(max(shipment_num),0)
12881: into x_int_shipment_num
12882: from po_lines_interface pli
12883: where pli.interface_header_id = x_interface_header_id;
12884:
12885: -- End of fix. Bug 605715, lpo, 01/05/98
12886:

Line 12899: update po_lines_interface

12895: END IF;
12896:
12897: if x_requisition_line_id is not null then
12898: l_progress := '110';
12899: update po_lines_interface
12900: set shipment_num = x_shipment_num + 1
12901: where interface_header_id=x_interface_header_id
12902: and requisition_line_id=x_requisition_line_id;
12903: else

Line 12905: update po_lines_interface

12901: where interface_header_id=x_interface_header_id
12902: and requisition_line_id=x_requisition_line_id;
12903: else
12904: l_progress := '120';
12905: update po_lines_interface
12906: set shipment_num = x_shipment_num + 1
12907: where interface_header_id=x_interface_header_id
12908: and rowid=x_row_id;
12909: end if;

Line 13223: records from po_lines_interface table to po_line_locations_all table

13219: /*============================================================================
13220: Name : CREATE_PRICE_BREAK
13221: Type : Private
13222: Function : This procedure is called from 'create_line'. This procedure inserts
13223: records from po_lines_interface table to po_line_locations_all table
13224: for the price break information.
13225: Pre-req : None
13226: Parameters:
13227: IN : p_po_line_id IN NUMBER REQUIRED

Line 13631: FROM po_lines_interface PLI, po_requisition_lines PRL

13627: END IF;
13628:
13629: SELECT count(*)
13630: INTO l_num_config_id_lines
13631: FROM po_lines_interface PLI, po_requisition_lines PRL
13632: WHERE PLI.interface_header_id = p_interface_header_id
13633: AND PLI.requisition_line_id = PRL.requisition_line_id -- JOIN
13634: AND PRL.supplier_ref_number IS NOT NULL;
13635:

Line 13982: -- p_interface_line_id: id of the line in po_lines_interface

13978: -- populated, use that information. Otherwise, create a default
13979: -- payitem. Also create DELIVERY and ADVANCE payitems as necessary.
13980: --Parameters:
13981: -- IN:
13982: -- p_interface_line_id: id of the line in po_lines_interface
13983: -- p_po_line_id: id of the line in po_lines_all
13984: -- p_precision: precision of the currency desired. Used to round amounts.
13985: -- p_ext_precision: extended precision of the currency desired.
13986: -- Used to round prices

Line 14712: -- p_interface_line_id: id of the line in po_lines_interface

14708: -- IN:
14709: -- p_req_line_id: id of the requisition line that is the source of
14710: -- the po line; null if no backing req.
14711: -- p_po_line_id: id of the line in po_lines_all
14712: -- p_interface_line_id: id of the line in po_lines_interface
14713: -- p_precision: precision of the currency desired. Used to round amounts.
14714: -- p_ext_precision: extended precision of the currency desired.
14715: -- Used to round prices
14716: -- OUT: