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_AUTO_LINE_LOC_PROCESS_PVT dependencies on PO_LINE_LOCATIONS_ALL

Line 117: l_manual_price_change_flag po_line_locations_all.manual_price_change_flag%TYPE := NULL; --bug 3495772

113:
114:
115: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_SHIPMENT_DRAFT';
116: l_progress VARCHAR2(3) := '000'; --< Bug 3210331 >
117: l_manual_price_change_flag po_line_locations_all.manual_price_change_flag%TYPE := NULL; --bug 3495772
118:
119:
120: l_from_type_lookup_code po_headers_all.type_lookup_code%TYPE;
121:

Line 1060: l_payment_type PO_LINE_LOCATIONS_ALL.payment_type%TYPE;

1056: l_line_unit_price PO_LINES_ALL.unit_price%TYPE;
1057: l_line_quantity PO_LINES_ALL.quantity%TYPE;
1058: l_line_amount PO_LINES_ALL.amount%TYPE;
1059: l_line_purchase_basis PO_LINES_ALL.purchase_basis%TYPE;
1060: l_payment_type PO_LINE_LOCATIONS_ALL.payment_type%TYPE;
1061: l_shipment_type PO_LINE_LOCATIONS_ALL.shipment_type%TYPE;
1062: l_payitem_quantity PO_LINE_LOCATIONS_ALL.quantity%TYPE;
1063: l_payitem_amount PO_LINE_LOCATIONS_ALL.amount%TYPE;
1064: l_payitem_price PO_LINE_LOCATIONS_ALL.price_override%TYPE;

Line 1061: l_shipment_type PO_LINE_LOCATIONS_ALL.shipment_type%TYPE;

1057: l_line_quantity PO_LINES_ALL.quantity%TYPE;
1058: l_line_amount PO_LINES_ALL.amount%TYPE;
1059: l_line_purchase_basis PO_LINES_ALL.purchase_basis%TYPE;
1060: l_payment_type PO_LINE_LOCATIONS_ALL.payment_type%TYPE;
1061: l_shipment_type PO_LINE_LOCATIONS_ALL.shipment_type%TYPE;
1062: l_payitem_quantity PO_LINE_LOCATIONS_ALL.quantity%TYPE;
1063: l_payitem_amount PO_LINE_LOCATIONS_ALL.amount%TYPE;
1064: l_payitem_price PO_LINE_LOCATIONS_ALL.price_override%TYPE;
1065: l_req_tax_code_id PO_REQUISITION_LINES_ALL.tax_code_id%TYPE;

Line 1062: l_payitem_quantity PO_LINE_LOCATIONS_ALL.quantity%TYPE;

1058: l_line_amount PO_LINES_ALL.amount%TYPE;
1059: l_line_purchase_basis PO_LINES_ALL.purchase_basis%TYPE;
1060: l_payment_type PO_LINE_LOCATIONS_ALL.payment_type%TYPE;
1061: l_shipment_type PO_LINE_LOCATIONS_ALL.shipment_type%TYPE;
1062: l_payitem_quantity PO_LINE_LOCATIONS_ALL.quantity%TYPE;
1063: l_payitem_amount PO_LINE_LOCATIONS_ALL.amount%TYPE;
1064: l_payitem_price PO_LINE_LOCATIONS_ALL.price_override%TYPE;
1065: l_req_tax_code_id PO_REQUISITION_LINES_ALL.tax_code_id%TYPE;
1066: l_req_tax_user_override_flag PO_REQUISITION_LINES_ALL.tax_user_override_flag%TYPE;

Line 1063: l_payitem_amount PO_LINE_LOCATIONS_ALL.amount%TYPE;

1059: l_line_purchase_basis PO_LINES_ALL.purchase_basis%TYPE;
1060: l_payment_type PO_LINE_LOCATIONS_ALL.payment_type%TYPE;
1061: l_shipment_type PO_LINE_LOCATIONS_ALL.shipment_type%TYPE;
1062: l_payitem_quantity PO_LINE_LOCATIONS_ALL.quantity%TYPE;
1063: l_payitem_amount PO_LINE_LOCATIONS_ALL.amount%TYPE;
1064: l_payitem_price PO_LINE_LOCATIONS_ALL.price_override%TYPE;
1065: l_req_tax_code_id PO_REQUISITION_LINES_ALL.tax_code_id%TYPE;
1066: l_req_tax_user_override_flag PO_REQUISITION_LINES_ALL.tax_user_override_flag%TYPE;
1067: l_req_tax_status_indicator PO_REQUISITION_LINES_ALL.tax_status_indicator%TYPE;

Line 1064: l_payitem_price PO_LINE_LOCATIONS_ALL.price_override%TYPE;

1060: l_payment_type PO_LINE_LOCATIONS_ALL.payment_type%TYPE;
1061: l_shipment_type PO_LINE_LOCATIONS_ALL.shipment_type%TYPE;
1062: l_payitem_quantity PO_LINE_LOCATIONS_ALL.quantity%TYPE;
1063: l_payitem_amount PO_LINE_LOCATIONS_ALL.amount%TYPE;
1064: l_payitem_price PO_LINE_LOCATIONS_ALL.price_override%TYPE;
1065: l_req_tax_code_id PO_REQUISITION_LINES_ALL.tax_code_id%TYPE;
1066: l_req_tax_user_override_flag PO_REQUISITION_LINES_ALL.tax_user_override_flag%TYPE;
1067: l_req_tax_status_indicator PO_REQUISITION_LINES_ALL.tax_status_indicator%TYPE;
1068: l_tax_name AP_TAX_CODES.name%TYPE;

Line 1078: l_line_loc_id PO_LINE_LOCATIONS_ALL.line_location_id%TYPE;

1074: l_ship_to_location_id NUMBER;
1075: l_payitem_tax_code_id_tbl po_tbl_number;
1076: l_payitems_created NUMBER;
1077: l_routing_name RCV_ROUTING_HEADERS.routing_name%TYPE;
1078: l_line_loc_id PO_LINE_LOCATIONS_ALL.line_location_id%TYPE;
1079: l_po_promised_def_prf VARCHAR2(1) := FND_PROFILE.value('PO_NEED_BY_PROMISE_DEFAULTING');
1080: l_country_of_origin_code VARCHAR2(2);
1081: l_tax_status VARCHAR2(10);
1082: l_encoded_msg VARCHAR2(2000);

Line 1417: -- origin before inserting a new row into po_line_locations_all

1413:
1414: d_progress := 150;
1415: -- now iterate over the rows in the interface table
1416: -- for each row, get the default tax, receiving controls, and country of
1417: -- origin before inserting a new row into po_line_locations_all
1418: OPEN poll_interface_cursor(p_lines.intf_line_id_tbl(i));
1419: LOOP
1420: FETCH poll_interface_cursor INTO line_location_rec;
1421: EXIT

Line 1462: PO_LOG.stmt(d_module, d_progress, 'Inserting payitem into po_line_locations_all');

1458:
1459: d_progress := 210;
1460:
1461: IF (PO_LOG.d_stmt) THEN
1462: PO_LOG.stmt(d_module, d_progress, 'Inserting payitem into po_line_locations_all');
1463: END IF;
1464:
1465: -- insert payitem into po_line_locations_all
1466: --SQL WHAT: Insert payitem, using info in po_line_locations_interface

Line 1465: -- insert payitem into po_line_locations_all

1461: IF (PO_LOG.d_stmt) THEN
1462: PO_LOG.stmt(d_module, d_progress, 'Inserting payitem into po_line_locations_all');
1463: END IF;
1464:
1465: -- insert payitem into po_line_locations_all
1466: --SQL WHAT: Insert payitem, using info in po_line_locations_interface
1467: --SQL WHY : This allows us to insert all payitems in one location.
1468: INSERT
1469: INTO po_line_locations_draft_all

Line 1798: l_tax_attribute_update_code PO_LINE_LOCATIONS_ALL.tax_attribute_update_code%type; --

1794: l_ship_org_name VARCHAR2(60);
1795: l_value_basis PO_LINES_ALL.order_type_lookup_code%TYPE; --
1796: l_outsourced_assembly NUMBER;
1797: x_line_location_id NUMBER;
1798: l_tax_attribute_update_code PO_LINE_LOCATIONS_ALL.tax_attribute_update_code%type; --
1799:
1800: BEGIN
1801:
1802: l_progress := '010';