APPS.PO_INVOICES_SV2 dependencies on PO_LINE_LOCATIONS

Line 28: RETURN PO_LINE_LOCATIONS.SHIP_TO_LOCATION_ID%TYPE IS

24: Bug: 5125624
25: ==================================================================*/
26:
27: FUNCTION get_ship_to_location_id (p_po_line_location_id IN NUMBER)
28: RETURN PO_LINE_LOCATIONS.SHIP_TO_LOCATION_ID%TYPE IS
29: l_ship_to_location_id PO_LINE_LOCATIONS.SHIP_TO_LOCATION_ID%TYPE;
30: BEGIN
31:
32: SELECT

Line 29: l_ship_to_location_id PO_LINE_LOCATIONS.SHIP_TO_LOCATION_ID%TYPE;

25: ==================================================================*/
26:
27: FUNCTION get_ship_to_location_id (p_po_line_location_id IN NUMBER)
28: RETURN PO_LINE_LOCATIONS.SHIP_TO_LOCATION_ID%TYPE IS
29: l_ship_to_location_id PO_LINE_LOCATIONS.SHIP_TO_LOCATION_ID%TYPE;
30: BEGIN
31:
32: SELECT
33: ship_to_location_id INTO l_ship_to_location_id

Line 35: po_line_locations_all

31:
32: SELECT
33: ship_to_location_id INTO l_ship_to_location_id
34: FROM
35: po_line_locations_all
36: WHERE
37: line_location_id = p_po_line_location_id;
38: IF (g_asn_debug = 'Y') THEN
39: asn_debug.put_line('po_line_location_id = ' || p_po_line_location_id || ' has ship to location id = ' || l_ship_to_location_id);

Line 232: po_line_locations_all plls,

228: --Bugfix 5407632 - Using _all tables instead of views.
229: po_headers_all phs,
230: -- po_releases_all prs, /*Bug 5443196*/
231: po_lines_all pls,
232: po_line_locations_all plls,
233: rcv_shipment_headers rsh,
234: rcv_shipment_lines rsl,
235: inl_ship_lines_all isl, -- PoR with LCM project
236: rcv_transactions rts

Line 327: po_line_locations_all plls,

323: --Bugfix 5407632 - Using _all tables instead of views.
324: po_headers_all phs,
325: po_releases_all prs,
326: po_lines_all pls,
327: po_line_locations_all plls,
328: rcv_shipment_headers rsh,
329: rcv_shipment_lines rsl,
330: inl_ship_lines_all isl, -- PoR with LCM project
331: rcv_transactions rts

Line 441: po_line_locations plls,

437: po_vendors pvds,
438: po_headers phs,
439: po_releases prs,
440: po_lines pls,
441: po_line_locations plls,
442: rcv_shipment_headers rsh,
443: rcv_shipment_lines rsl,
444: inl_ship_lines_all isl, -- PoR with LCM project
445: rcv_transactions rts

Line 582: x_curr_shipment_type po_line_locations_all.shipment_type%type;

578: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
579: /* */
580:
581: /* R12 Complex Work.*/
582: x_curr_shipment_type po_line_locations_all.shipment_type%type;
583:
584: /*Bug: 5125624*/
585: l_ship_to_location_id PO_LINE_LOCATIONS.SHIP_TO_LOCATION_ID%TYPE;
586: l_tax_classification_code VARCHAR2(30);

Line 585: l_ship_to_location_id PO_LINE_LOCATIONS.SHIP_TO_LOCATION_ID%TYPE;

581: /* R12 Complex Work.*/
582: x_curr_shipment_type po_line_locations_all.shipment_type%type;
583:
584: /*Bug: 5125624*/
585: l_ship_to_location_id PO_LINE_LOCATIONS.SHIP_TO_LOCATION_ID%TYPE;
586: l_tax_classification_code VARCHAR2(30);
587:
588: X_curr_receipt_num rcv_shipment_headers.receipt_num%TYPE := NULL; /* bug 7512542 */
589: X_curr_por_summary_code po_vendor_sites.pay_on_receipt_summary_code%TYPE := NULL; /* bug 7512542 */

Line 1194: update rcv_txns, po_line_locations and po_distributions accordingly *****/

1190:
1191: END IF; /** change in one of the curr_ variables **/
1192:
1193: /**** Create invoice distribution(s) , tax distribution(s) and
1194: update rcv_txns, po_line_locations and po_distributions accordingly *****/
1195:
1196:
1197: X_progress := '140'; -- receipt_invoices
1198:

Line 2278: l_ship_to_location_id PO_LINE_LOCATIONS.SHIP_TO_LOCATION_ID%TYPE;

2274: X_line_count NUMBER;
2275: x_org_id NUMBER; --Bug# 2492041
2276:
2277: /*Bug: 5125624*/
2278: l_ship_to_location_id PO_LINE_LOCATIONS.SHIP_TO_LOCATION_ID%TYPE;
2279: l_tax_classification_code VARCHAR2(30);
2280: x_invoiced_quantity NUMBER :=0; -- Added for bug 6822594
2281: x_invoiced_unit_price NUMBER :=0; -- Added for bug 6822594
2282: X_invoiced_amount NUMBER :=0; -- Added for bug 6822594

Line 3585: l_ship_to_location_id PO_LINE_LOCATIONS.SHIP_TO_LOCATION_ID%TYPE;

3581: l_api_name VARCHAR2(50) := 'create_invoice_distr';
3582: i NUMBER;
3583:
3584: /*Bug: 5125624*/
3585: l_ship_to_location_id PO_LINE_LOCATIONS.SHIP_TO_LOCATION_ID%TYPE;
3586: l_tax_classification_code VARCHAR2(30);
3587:
3588: BEGIN
3589: SAVEPOINT create_invoice_distr_sp;