APPS.PO_COPYDOC_SUB dependencies on PO_LINE_LOCATIONS

Line 19: CURSOR po_shipment_cursor(x_po_line_id po_line_locations.po_line_id%TYPE) IS

15: * Blankets and Releases share the po_line_id in PO_LINES_ALL.
16: * This happened when Releases were entered for a BPA and the BPA
17: * had to be re-approved after being REJECTED.
18: * The same has to be done for Scheculed Relases too. */
19: CURSOR po_shipment_cursor(x_po_line_id po_line_locations.po_line_id%TYPE) IS
20: SELECT *
21: FROM PO_LINE_LOCATIONS
22: WHERE po_line_id = x_po_line_id
23: AND shipment_type not in ('BLANKET','SCHEDULED')

Line 21: FROM PO_LINE_LOCATIONS

17: * had to be re-approved after being REJECTED.
18: * The same has to be done for Scheculed Relases too. */
19: CURSOR po_shipment_cursor(x_po_line_id po_line_locations.po_line_id%TYPE) IS
20: SELECT *
21: FROM PO_LINE_LOCATIONS
22: WHERE po_line_id = x_po_line_id
23: AND shipment_type not in ('BLANKET','SCHEDULED')
24: ORDER BY shipment_num;
25:

Line 174: x_line_location_id IN po_line_locations.line_location_id%TYPE, -- CONSIGNED FPI START

170: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
171: x_line_num IN po_online_report_text.line_num%TYPE,
172: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
173: x_distribution_num IN po_online_report_text.distribution_num%TYPE,
174: x_line_location_id IN po_line_locations.line_location_id%TYPE, -- CONSIGNED FPI START
175: x_po_line_id IN po_lines.po_line_id%TYPE, -- Bug 3557910 Additional Input Parameter PO LINE ID
176: p_transaction_flow_header_id IN NUMBER --< Bug 3546252 >
177: );
178:

Line 1533: x_line_location_id IN po_line_locations.line_location_id%TYPE, -- CONSIGNED FPI START

1529: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1530: x_line_num IN po_online_report_text.line_num%TYPE,
1531: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1532: x_distribution_num IN po_online_report_text.distribution_num%TYPE,
1533: x_line_location_id IN po_line_locations.line_location_id%TYPE, -- CONSIGNED FPI START
1534: x_po_line_id IN po_lines.po_line_id%TYPE, -- Bug 3557910
1535: p_transaction_flow_header_id IN NUMBER --< Bug 3546252 >
1536: ) IS
1537:

Line 1543: x_consigned_flag po_line_locations.consigned_flag%TYPE := NULL;

1539: /* x_expense_accrual_code po_system_parameters.expense_accrual_code%TYPE;Bug7351781*/
1540: x_item_status VARCHAR2(1);
1541: x_progress VARCHAR(4) := NULL;
1542: -- CONSIGNED FPI
1543: x_consigned_flag po_line_locations.consigned_flag%TYPE := NULL;
1544: -- Bug 3557910 Start
1545: x_eam_install_status VARCHAR2(10);
1546: x_eam_profile VARCHAR2(10);
1547: x_osp_line_flag VARCHAR2(10);

Line 1562: FROM po_line_locations

1558: -- CONSIGNED FPI START
1559: -- Bug Fix for #2713973: COPY PO WITH CONSIGNED SHIPMENT LINE FAILS
1560: SELECT consigned_flag
1561: INTO x_consigned_flag
1562: FROM po_line_locations
1563: WHERE line_location_id = x_line_location_id;
1564: -- CONSIGNED FPI END
1565:
1566: po_items_sv2.get_item_status(x_item_id, x_ship_org_id, x_item_status);

Line 2278: x_po_shipment_record po_line_locations%ROWTYPE;

2274: x_inv_org_id IN financials_system_parameters.inventory_organization_id%TYPE) IS
2275:
2276: x_po_header_record po_headers%ROWTYPE;
2277: x_po_line_record po_lines%ROWTYPE;
2278: x_po_shipment_record po_line_locations%ROWTYPE;
2279: x_po_distribution_record po_distributions%ROWTYPE;
2280:
2281: x_line_num po_online_report_text.line_num%TYPE := NULL;
2282: x_shipment_num po_online_report_text.shipment_num%TYPE := NULL;

Line 2863: PO_LINE_LOCATIONS_ALL.transaction_flow_header_id%TYPE;

2859: l_check_txn_flow BOOLEAN;
2860: l_return_status VARCHAR2(1);
2861:
2862: l_transaction_flow_header_id
2863: PO_LINE_LOCATIONS_ALL.transaction_flow_header_id%TYPE;
2864:
2865: BEGIN
2866: l_progress := '000';
2867: