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 176: x_line_location_id IN po_line_locations.line_location_id%TYPE, -- CONSIGNED FPI START

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

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

1665: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1666: x_line_num IN po_online_report_text.line_num%TYPE,
1667: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1668: x_distribution_num IN po_online_report_text.distribution_num%TYPE,
1669: x_line_location_id IN po_line_locations.line_location_id%TYPE, -- CONSIGNED FPI START
1670: x_po_line_id IN po_lines.po_line_id%TYPE, -- Bug 3557910
1671: p_transaction_flow_header_id IN NUMBER --< Bug 3546252 >
1672: ) IS
1673:

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

1675: /* x_expense_accrual_code po_system_parameters.expense_accrual_code%TYPE;Bug7351781*/
1676: x_item_status VARCHAR2(1);
1677: x_progress VARCHAR(4) := NULL;
1678: -- CONSIGNED FPI
1679: x_consigned_flag po_line_locations.consigned_flag%TYPE := NULL;
1680: -- Bug 3557910 Start
1681: x_eam_install_status VARCHAR2(10);
1682: x_eam_profile VARCHAR2(10);
1683: x_osp_line_flag VARCHAR2(10);

Line 1698: FROM po_line_locations

1694: -- CONSIGNED FPI START
1695: -- Bug Fix for #2713973: COPY PO WITH CONSIGNED SHIPMENT LINE FAILS
1696: SELECT consigned_flag
1697: INTO x_consigned_flag
1698: FROM po_line_locations
1699: WHERE line_location_id = x_line_location_id;
1700: -- CONSIGNED FPI END
1701:
1702: po_items_sv2.get_item_status(x_item_id, x_ship_org_id, x_item_status);

Line 2424: x_po_shipment_record po_line_locations%ROWTYPE;

2420: x_inv_org_id IN financials_system_parameters.inventory_organization_id%TYPE) IS
2421:
2422: x_po_header_record po_headers%ROWTYPE;
2423: x_po_line_record po_lines%ROWTYPE;
2424: x_po_shipment_record po_line_locations%ROWTYPE;
2425: x_po_distribution_record po_distributions%ROWTYPE;
2426:
2427: x_line_num po_online_report_text.line_num%TYPE := NULL;
2428: x_shipment_num po_online_report_text.shipment_num%TYPE := NULL;

Line 3057: PO_LINE_LOCATIONS_ALL.transaction_flow_header_id%TYPE;

3053: l_check_txn_flow BOOLEAN;
3054: l_return_status VARCHAR2(1);
3055:
3056: l_transaction_flow_header_id
3057: PO_LINE_LOCATIONS_ALL.transaction_flow_header_id%TYPE;
3058:
3059: BEGIN
3060: l_progress := '000';
3061: