eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_COPYDOC_S1 dependencies on PO_LINE_LOCATIONS

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

25: FROM PO_LINES
26: WHERE po_header_id = x_po_header_id
27: ORDER BY line_num;
28:
29: CURSOR po_shipment_cursor(x_po_line_id po_line_locations.po_line_id%TYPE) IS
30: SELECT *
31: FROM PO_LINE_LOCATIONS
32: WHERE po_line_id = x_po_line_id
33: AND SHIPMENT_TYPE NOT IN ('SCHEDULED','BLANKET') --Bug: 1773758 1992096

Line 31: FROM PO_LINE_LOCATIONS

27: ORDER BY line_num;
28:
29: CURSOR po_shipment_cursor(x_po_line_id po_line_locations.po_line_id%TYPE) IS
30: SELECT *
31: FROM PO_LINE_LOCATIONS
32: WHERE po_line_id = x_po_line_id
33: AND SHIPMENT_TYPE NOT IN ('SCHEDULED','BLANKET') --Bug: 1773758 1992096
34: ORDER BY shipment_num;
35:

Line 69: x_po_shipment_record IN po_line_locations%ROWTYPE,

65: x_return_code OUT NOCOPY NUMBER
66: );
67:
68: PROCEDURE insert_shipment(
69: x_po_shipment_record IN po_line_locations%ROWTYPE,
70: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
71: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
72: x_line_num IN po_online_report_text.line_num%TYPE,
73: x_accrue_on_receipt_flag IN VARCHAR2,

Line 142: x_po_shipment_record IN OUT NOCOPY PO_LINE_LOCATIONS%ROWTYPE,

138: p_online_report_id IN NUMBER,
139: p_line_num IN NUMBER,
140: p_inv_org_id IN NUMBER,
141: p_item_id IN NUMBER, -- Bug 3433867
142: x_po_shipment_record IN OUT NOCOPY PO_LINE_LOCATIONS%ROWTYPE,
143: x_sequence IN OUT NOCOPY NUMBER,
144: x_return_code OUT NOCOPY NUMBER,
145: p_is_complex_work_po IN BOOLEAN --
146: );

Line 159: p_po_shipment_rec IN PO_LINE_LOCATIONS%ROWTYPE,

155: p_copy_attachments IN BOOLEAN,
156: p_online_report_id IN NUMBER,
157: p_po_header_rec IN PO_HEADERS%ROWTYPE,
158: p_po_line_rec IN PO_LINES%ROWTYPE,
159: p_po_shipment_rec IN PO_LINE_LOCATIONS%ROWTYPE,
160: p_sob_id IN FINANCIALS_SYSTEM_PARAMETERS.set_of_books_id%TYPE,
161: x_po_distribution_rec IN OUT NOCOPY PO_DISTRIBUTIONS%ROWTYPE,
162: x_sequence IN OUT NOCOPY NUMBER,
163: x_return_code OUT NOCOPY NUMBER

Line 1163: x_po_shipment_record IN po_line_locations%ROWTYPE,

1159: END insert_line;
1160:
1161:
1162: PROCEDURE insert_shipment(
1163: x_po_shipment_record IN po_line_locations%ROWTYPE,
1164: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1165: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1166: x_line_num IN po_online_report_text.line_num%TYPE,
1167: x_accrue_on_receipt_flag IN VARCHAR2,

Line 1178: l_to_ship_to_location_id po_line_locations.ship_to_location_id%TYPE;

1174: l_progress VARCHAR2(4);
1175:
1176: --bug #2717053: changed var names/types to conform to standards
1177: l_vendor_site_id po_headers.vendor_site_id%TYPE := null;
1178: l_to_ship_to_location_id po_line_locations.ship_to_location_id%TYPE;
1179: l_to_ship_to_organization_id po_line_locations.ship_to_organization_id%TYPE;
1180: l_item_id po_lines.item_id%TYPE := null;
1181: l_count number:= 0;
1182: l_quantity po_line_locations.quantity%TYPE;

Line 1179: l_to_ship_to_organization_id po_line_locations.ship_to_organization_id%TYPE;

1175:
1176: --bug #2717053: changed var names/types to conform to standards
1177: l_vendor_site_id po_headers.vendor_site_id%TYPE := null;
1178: l_to_ship_to_location_id po_line_locations.ship_to_location_id%TYPE;
1179: l_to_ship_to_organization_id po_line_locations.ship_to_organization_id%TYPE;
1180: l_item_id po_lines.item_id%TYPE := null;
1181: l_count number:= 0;
1182: l_quantity po_line_locations.quantity%TYPE;
1183: l_quote_type_code po_headers.quote_type_lookup_code%TYPE := null;

Line 1182: l_quantity po_line_locations.quantity%TYPE;

1178: l_to_ship_to_location_id po_line_locations.ship_to_location_id%TYPE;
1179: l_to_ship_to_organization_id po_line_locations.ship_to_organization_id%TYPE;
1180: l_item_id po_lines.item_id%TYPE := null;
1181: l_count number:= 0;
1182: l_quantity po_line_locations.quantity%TYPE;
1183: l_quote_type_code po_headers.quote_type_lookup_code%TYPE := null;
1184:
1185: x_sob_id number:= null;
1186:

Line 1192: po_line_locations.consigned_flag%TYPE := null;

1188: -- Bug Fix for #2697755: COPY PO WITH CONSIGNED SHIPMENT LINE FAILS
1189: l_vendor_id
1190: po_headers.vendor_id%TYPE := null;
1191: l_consigned_flag
1192: po_line_locations.consigned_flag%TYPE := null;
1193: l_consigned_from_supplier_flag
1194: po_asl_attributes.consigned_from_supplier_flag%TYPE := null;
1195: l_enable_vmi_flag
1196: po_asl_attributes.enable_vmi_flag%TYPE := null;

Line 1198: po_line_locations.accrue_on_receipt_flag%TYPE := null;

1194: po_asl_attributes.consigned_from_supplier_flag%TYPE := null;
1195: l_enable_vmi_flag
1196: po_asl_attributes.enable_vmi_flag%TYPE := null;
1197: l_accrue_on_receipt_flag
1198: po_line_locations.accrue_on_receipt_flag%TYPE := null;
1199: l_closed_code
1200: po_line_locations.closed_code%TYPE := null;
1201: l_closed_reason
1202: po_line_locations.closed_reason%TYPE := null;

Line 1200: po_line_locations.closed_code%TYPE := null;

1196: po_asl_attributes.enable_vmi_flag%TYPE := null;
1197: l_accrue_on_receipt_flag
1198: po_line_locations.accrue_on_receipt_flag%TYPE := null;
1199: l_closed_code
1200: po_line_locations.closed_code%TYPE := null;
1201: l_closed_reason
1202: po_line_locations.closed_reason%TYPE := null;
1203: l_inspection_required_flag
1204: po_line_locations.inspection_required_flag%TYPE := null;

Line 1202: po_line_locations.closed_reason%TYPE := null;

1198: po_line_locations.accrue_on_receipt_flag%TYPE := null;
1199: l_closed_code
1200: po_line_locations.closed_code%TYPE := null;
1201: l_closed_reason
1202: po_line_locations.closed_reason%TYPE := null;
1203: l_inspection_required_flag
1204: po_line_locations.inspection_required_flag%TYPE := null;
1205: l_receipt_required_flag
1206: po_line_locations.receipt_required_flag%TYPE := null;

Line 1204: po_line_locations.inspection_required_flag%TYPE := null;

1200: po_line_locations.closed_code%TYPE := null;
1201: l_closed_reason
1202: po_line_locations.closed_reason%TYPE := null;
1203: l_inspection_required_flag
1204: po_line_locations.inspection_required_flag%TYPE := null;
1205: l_receipt_required_flag
1206: po_line_locations.receipt_required_flag%TYPE := null;
1207: l_match_option
1208: po_line_locations.match_option%TYPE := null;

Line 1206: po_line_locations.receipt_required_flag%TYPE := null;

1202: po_line_locations.closed_reason%TYPE := null;
1203: l_inspection_required_flag
1204: po_line_locations.inspection_required_flag%TYPE := null;
1205: l_receipt_required_flag
1206: po_line_locations.receipt_required_flag%TYPE := null;
1207: l_match_option
1208: po_line_locations.match_option%TYPE := null;
1209: l_last_billing_date date := null;
1210: l_consigned_billing_cycle number := null;

Line 1208: po_line_locations.match_option%TYPE := null;

1204: po_line_locations.inspection_required_flag%TYPE := null;
1205: l_receipt_required_flag
1206: po_line_locations.receipt_required_flag%TYPE := null;
1207: l_match_option
1208: po_line_locations.match_option%TYPE := null;
1209: l_last_billing_date date := null;
1210: l_consigned_billing_cycle number := null;
1211: l_invoice_close_tolerance number := null;
1212: l_item_inv_asset_flag

Line 1227: l_line_value_basis PO_LINE_LOCATIONS_ALL.value_basis%type;

1223: x_secondary_quantity PO_LINES_ALL.SECONDARY_QUANTITY%TYPE := NULL;
1224: --
1225:
1226: -- Bug 4958300
1227: l_line_value_basis PO_LINE_LOCATIONS_ALL.value_basis%type;
1228: l_line_matching_basis PO_LINE_LOCATIONS_ALL.matching_basis%type;
1229: --
1230:
1231: BEGIN

Line 1228: l_line_matching_basis PO_LINE_LOCATIONS_ALL.matching_basis%type;

1224: --
1225:
1226: -- Bug 4958300
1227: l_line_value_basis PO_LINE_LOCATIONS_ALL.value_basis%type;
1228: l_line_matching_basis PO_LINE_LOCATIONS_ALL.matching_basis%type;
1229: --
1230:
1231: BEGIN
1232:

Line 1513: INSERT INTO PO_LINE_LOCATIONS (

1509: END IF;
1510:
1511: --
1512:
1513: INSERT INTO PO_LINE_LOCATIONS (
1514: accrue_on_receipt_flag,
1515: allow_substitute_receipts_flag,
1516: approved_date,
1517: approved_flag,

Line 2720: x_po_shipment_record IN OUT NOCOPY PO_LINE_LOCATIONS%ROWTYPE,

2716: p_online_report_id IN NUMBER,
2717: p_line_num IN NUMBER,
2718: p_inv_org_id IN NUMBER,
2719: p_item_id IN NUMBER, -- Bug 3433867
2720: x_po_shipment_record IN OUT NOCOPY PO_LINE_LOCATIONS%ROWTYPE,
2721: x_sequence IN OUT NOCOPY NUMBER,
2722: x_return_code OUT NOCOPY NUMBER,
2723: p_is_complex_work_po IN BOOLEAN --
2724: ) IS

Line 2811: from po_line_locations

2807: /* Get the item_id, accrue on receipt flag, and expense accrual code */
2808:
2809: select receipt_required_flag
2810: into l_poll_receipt_required_flag
2811: from po_line_locations
2812: where line_location_id = p_orig_line_location_id;
2813:
2814: l_progress := '050';
2815:

Line 2983: p_po_shipment_rec IN PO_LINE_LOCATIONS%ROWTYPE,

2979: p_copy_attachments IN BOOLEAN,
2980: p_online_report_id IN NUMBER,
2981: p_po_header_rec IN PO_HEADERS%ROWTYPE,
2982: p_po_line_rec IN PO_LINES%ROWTYPE,
2983: p_po_shipment_rec IN PO_LINE_LOCATIONS%ROWTYPE,
2984: p_sob_id IN FINANCIALS_SYSTEM_PARAMETERS.set_of_books_id%TYPE,
2985: x_po_distribution_rec IN OUT NOCOPY PO_DISTRIBUTIONS%ROWTYPE,
2986: x_sequence IN OUT NOCOPY NUMBER,
2987: x_return_code OUT NOCOPY NUMBER

Line 2998: l_line_location_id PO_LINE_LOCATIONS_ALL.line_location_id%TYPE;

2994:
2995: --: use local vars for this to handle BPA case
2996: l_line_id PO_LINES_ALL.po_line_id%TYPE;
2997: l_line_num PO_LINES_ALL.line_num%TYPE;
2998: l_line_location_id PO_LINE_LOCATIONS_ALL.line_location_id%TYPE;
2999: l_shipment_num PO_LINE_LOCATIONS_ALL.shipment_num%TYPE;
3000: l_distribution_type PO_DISTRIBUTIONS_ALL.distribution_type%TYPE;
3001:
3002: BEGIN

Line 2999: l_shipment_num PO_LINE_LOCATIONS_ALL.shipment_num%TYPE;

2995: --: use local vars for this to handle BPA case
2996: l_line_id PO_LINES_ALL.po_line_id%TYPE;
2997: l_line_num PO_LINES_ALL.line_num%TYPE;
2998: l_line_location_id PO_LINE_LOCATIONS_ALL.line_location_id%TYPE;
2999: l_shipment_num PO_LINE_LOCATIONS_ALL.shipment_num%TYPE;
3000: l_distribution_type PO_DISTRIBUTIONS_ALL.distribution_type%TYPE;
3001:
3002: BEGIN
3003:

Line 3193: x_po_shipment_record po_line_locations%ROWTYPE;

3189: COPYDOC_FATAL EXCEPTION;
3190:
3191: x_po_header_record PO_HEADERS%ROWTYPE;
3192: x_po_line_record po_lines%ROWTYPE;
3193: x_po_shipment_record po_line_locations%ROWTYPE;
3194: x_po_distribution_record po_distributions%ROWTYPE;
3195:
3196: x_orig_po_line_id po_lines.po_line_id%TYPE;
3197: x_orig_line_location_id po_line_locations.line_location_id%TYPE;

Line 3197: x_orig_line_location_id po_line_locations.line_location_id%TYPE;

3193: x_po_shipment_record po_line_locations%ROWTYPE;
3194: x_po_distribution_record po_distributions%ROWTYPE;
3195:
3196: x_orig_po_line_id po_lines.po_line_id%TYPE;
3197: x_orig_line_location_id po_line_locations.line_location_id%TYPE;
3198: x_orig_po_distribution_id po_distributions.po_distribution_id%TYPE;
3199:
3200: x_line_num po_online_report_text.line_num%TYPE := NULL;
3201: x_shipment_num po_online_report_text.shipment_num%TYPE := NULL;

Line 3215: PO_LINE_LOCATIONS_ALL.transaction_flow_header_id%TYPE;

3211: x_orig_quotation_class_code po_headers.quotation_class_code%TYPE := NULL;
3212:
3213: --< Shared Proc FPJ Start >
3214: l_orig_txn_flow_header_id
3215: PO_LINE_LOCATIONS_ALL.transaction_flow_header_id%TYPE;
3216: l_generate_new_accounts BOOLEAN := FALSE;
3217: --< Shared Proc FPJ End >
3218: l_calling_program VARCHAR2(30); --
3219: l_return_status VARCHAR2(1); --

Line 3613: FROM PO_LINE_LOCATIONS

3609: ) RETURN BOOLEAN IS
3610:
3611: CURSOR l_po_shipment_csr(p_po_header_id PO_HEADERS_ALL.po_header_id%TYPE) IS
3612: SELECT line_location_id
3613: FROM PO_LINE_LOCATIONS
3614: WHERE po_header_id = p_po_header_id
3615: AND SHIPMENT_TYPE NOT IN ('SCHEDULED','BLANKET');
3616:
3617: l_line_location_id PO_LINE_LOCATIONS.line_location_id%TYPE;

Line 3617: l_line_location_id PO_LINE_LOCATIONS.line_location_id%TYPE;

3613: FROM PO_LINE_LOCATIONS
3614: WHERE po_header_id = p_po_header_id
3615: AND SHIPMENT_TYPE NOT IN ('SCHEDULED','BLANKET');
3616:
3617: l_line_location_id PO_LINE_LOCATIONS.line_location_id%TYPE;
3618:
3619: BEGIN
3620: OPEN l_po_shipment_csr(p_po_header_id);
3621: