APPS.PO_SHIPMENTS_SV4 dependencies on PO_LINES_ALL

Line 1020: -- PO_LINES_ALL

1016: --Pre-reqs:
1017: -- Before calling this procedure one must call validate_delete_line_loc
1018: -- to ensure that deletion of the line location is a valid action
1019: --Modifies:
1020: -- PO_LINES_ALL
1021: -- PO_LINE_LOCATIONS_ALL
1022: --Locks:
1023: -- None
1024: --Function:

Line 1065: l_po_lines_rec PO_LINES_ALL%ROWTYPE;

1061: l_vendor_id PO_HEADERS_ALL.vendor_id%TYPE;
1062: l_vendor_site_id PO_HEADERS_ALL.vendor_site_id%TYPE;
1063: l_currency_code PO_HEADERS_ALL.currency_code%TYPE;
1064: l_org_id PO_HEADERS_ALL.org_id%TYPE;
1065: l_po_lines_rec PO_LINES_ALL%ROWTYPE;
1066: l_base_unit_price PO_LINES_ALL.base_unit_price%TYPE;
1067: l_from_line_location_id PO_LINES_ALL.from_line_location_id%TYPE := NULL;
1068: l_shipment_type PO_LINE_LOCATIONS_ALL.shipment_type%TYPE := NULL;
1069: l_ga_entity_type PO_PRICE_DIFFERENTIALS.entity_type%TYPE := NULL;

Line 1066: l_base_unit_price PO_LINES_ALL.base_unit_price%TYPE;

1062: l_vendor_site_id PO_HEADERS_ALL.vendor_site_id%TYPE;
1063: l_currency_code PO_HEADERS_ALL.currency_code%TYPE;
1064: l_org_id PO_HEADERS_ALL.org_id%TYPE;
1065: l_po_lines_rec PO_LINES_ALL%ROWTYPE;
1066: l_base_unit_price PO_LINES_ALL.base_unit_price%TYPE;
1067: l_from_line_location_id PO_LINES_ALL.from_line_location_id%TYPE := NULL;
1068: l_shipment_type PO_LINE_LOCATIONS_ALL.shipment_type%TYPE := NULL;
1069: l_ga_entity_type PO_PRICE_DIFFERENTIALS.entity_type%TYPE := NULL;
1070: l_ga_entity_id PO_PRICE_DIFFERENTIALS.entity_id%TYPE := NULL;

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

1063: l_currency_code PO_HEADERS_ALL.currency_code%TYPE;
1064: l_org_id PO_HEADERS_ALL.org_id%TYPE;
1065: l_po_lines_rec PO_LINES_ALL%ROWTYPE;
1066: l_base_unit_price PO_LINES_ALL.base_unit_price%TYPE;
1067: l_from_line_location_id PO_LINES_ALL.from_line_location_id%TYPE := NULL;
1068: l_shipment_type PO_LINE_LOCATIONS_ALL.shipment_type%TYPE := NULL;
1069: l_ga_entity_type PO_PRICE_DIFFERENTIALS.entity_type%TYPE := NULL;
1070: l_ga_entity_id PO_PRICE_DIFFERENTIALS.entity_id%TYPE := NULL;
1071: l_is_source_info_changed BOOLEAN := FALSE;

Line 1104: FROM po_lines_all

1100: END IF;
1101:
1102: SELECT *
1103: INTO l_po_lines_rec
1104: FROM po_lines_all
1105: WHERE po_line_id = p_po_line_id;
1106:
1107: d_pos := 40;
1108: IF (PO_LOG.d_stmt) THEN

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

1212: 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));
1213: END IF;
1214:
1215: d_pos := 120;
1216: -- Update the line price and from_line_location_id in PO_LINES_ALL
1217: PO_SOURCING2_SV.update_line_price(
1218: p_po_line_id => l_po_lines_rec.po_line_id,
1219: p_price => l_price,
1220: p_base_unit_price => l_base_unit_price,