APPS.PO_SHIPMENTS_SV4 dependencies on PO_LINES_ALL

Line 1040: -- PO_LINES_ALL

1036: --Pre-reqs:
1037: -- Before calling this procedure one must call validate_delete_line_loc
1038: -- to ensure that deletion of the line location is a valid action
1039: --Modifies:
1040: -- PO_LINES_ALL
1041: -- PO_LINE_LOCATIONS_ALL
1042: --Locks:
1043: -- None
1044: --Function:

Line 1085: l_po_lines_rec PO_LINES_ALL%ROWTYPE;

1081: l_vendor_id PO_HEADERS_ALL.vendor_id%TYPE;
1082: l_vendor_site_id PO_HEADERS_ALL.vendor_site_id%TYPE;
1083: l_currency_code PO_HEADERS_ALL.currency_code%TYPE;
1084: l_org_id PO_HEADERS_ALL.org_id%TYPE;
1085: l_po_lines_rec PO_LINES_ALL%ROWTYPE;
1086: l_base_unit_price PO_LINES_ALL.base_unit_price%TYPE;
1087: l_from_line_location_id PO_LINES_ALL.from_line_location_id%TYPE := NULL;
1088: l_shipment_type PO_LINE_LOCATIONS_ALL.shipment_type%TYPE := NULL;
1089: l_ga_entity_type PO_PRICE_DIFFERENTIALS.entity_type%TYPE := NULL;

Line 1086: l_base_unit_price PO_LINES_ALL.base_unit_price%TYPE;

1082: l_vendor_site_id PO_HEADERS_ALL.vendor_site_id%TYPE;
1083: l_currency_code PO_HEADERS_ALL.currency_code%TYPE;
1084: l_org_id PO_HEADERS_ALL.org_id%TYPE;
1085: l_po_lines_rec PO_LINES_ALL%ROWTYPE;
1086: l_base_unit_price PO_LINES_ALL.base_unit_price%TYPE;
1087: l_from_line_location_id PO_LINES_ALL.from_line_location_id%TYPE := NULL;
1088: l_shipment_type PO_LINE_LOCATIONS_ALL.shipment_type%TYPE := NULL;
1089: l_ga_entity_type PO_PRICE_DIFFERENTIALS.entity_type%TYPE := NULL;
1090: l_ga_entity_id PO_PRICE_DIFFERENTIALS.entity_id%TYPE := NULL;

Line 1087: l_from_line_location_id PO_LINES_ALL.from_line_location_id%TYPE := NULL;

1083: l_currency_code PO_HEADERS_ALL.currency_code%TYPE;
1084: l_org_id PO_HEADERS_ALL.org_id%TYPE;
1085: l_po_lines_rec PO_LINES_ALL%ROWTYPE;
1086: l_base_unit_price PO_LINES_ALL.base_unit_price%TYPE;
1087: l_from_line_location_id PO_LINES_ALL.from_line_location_id%TYPE := NULL;
1088: l_shipment_type PO_LINE_LOCATIONS_ALL.shipment_type%TYPE := NULL;
1089: l_ga_entity_type PO_PRICE_DIFFERENTIALS.entity_type%TYPE := NULL;
1090: l_ga_entity_id PO_PRICE_DIFFERENTIALS.entity_id%TYPE := NULL;
1091: l_is_source_info_changed BOOLEAN := FALSE;

Line 1124: FROM po_lines_all

1120: END IF;
1121:
1122: SELECT *
1123: INTO l_po_lines_rec
1124: FROM po_lines_all
1125: WHERE po_line_id = p_po_line_id;
1126:
1127: d_pos := 40;
1128: IF (PO_LOG.d_stmt) THEN

Line 1236: -- Update the line price and from_line_location_id in PO_LINES_ALL

1232: PO_LOG.stmt(d_module, 'boolean coverted to char: l_is_source_info_changed', PO_CORE_S.boolean_to_flag(l_is_source_info_changed));
1233: END IF;
1234:
1235: d_pos := 120;
1236: -- Update the line price and from_line_location_id in PO_LINES_ALL
1237: PO_SOURCING2_SV.update_line_price(
1238: p_po_line_id => l_po_lines_rec.po_line_id,
1239: p_price => l_price,
1240: p_base_unit_price => l_base_unit_price,