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 32: CURSOR po_shipment_cursor(x_po_line_id po_line_locations.po_line_id%TYPE) IS

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

Line 34: FROM PO_LINE_LOCATIONS

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

Line 91: x_po_shipment_record IN po_line_locations%ROWTYPE,

87: x_return_code OUT NOCOPY NUMBER
88: );
89:
90: PROCEDURE insert_shipment(
91: x_po_shipment_record IN po_line_locations%ROWTYPE,
92: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
93: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
94: x_line_num IN po_online_report_text.line_num%TYPE,
95: x_accrue_on_receipt_flag IN VARCHAR2,

Line 167: x_po_shipment_record IN OUT NOCOPY PO_LINE_LOCATIONS%ROWTYPE,

163: p_online_report_id IN NUMBER,
164: p_line_num IN NUMBER,
165: p_inv_org_id IN NUMBER,
166: p_item_id IN NUMBER, -- Bug 3433867
167: x_po_shipment_record IN OUT NOCOPY PO_LINE_LOCATIONS%ROWTYPE,
168: x_sequence IN OUT NOCOPY NUMBER,
169: x_return_code OUT NOCOPY NUMBER,
170: p_is_complex_work_po IN BOOLEAN --
171: );

Line 184: p_po_shipment_rec IN PO_LINE_LOCATIONS%ROWTYPE,

180: p_copy_attachments IN BOOLEAN,
181: p_online_report_id IN NUMBER,
182: p_po_header_rec IN PO_HEADERS%ROWTYPE,
183: p_po_line_rec IN PO_LINES%ROWTYPE,
184: p_po_shipment_rec IN PO_LINE_LOCATIONS%ROWTYPE,
185: p_sob_id IN FINANCIALS_SYSTEM_PARAMETERS.set_of_books_id%TYPE,
186: x_po_distribution_rec IN OUT NOCOPY PO_DISTRIBUTIONS%ROWTYPE,
187: x_sequence IN OUT NOCOPY NUMBER,
188: x_return_code OUT NOCOPY NUMBER

Line 1283: x_po_shipment_record IN po_line_locations%ROWTYPE,

1279: END insert_line;
1280:
1281:
1282: PROCEDURE insert_shipment(
1283: x_po_shipment_record IN po_line_locations%ROWTYPE,
1284: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1285: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1286: x_line_num IN po_online_report_text.line_num%TYPE,
1287: x_accrue_on_receipt_flag IN VARCHAR2,

Line 1298: l_to_ship_to_location_id po_line_locations.ship_to_location_id%TYPE;

1294: l_progress VARCHAR2(4);
1295:
1296: --bug #2717053: changed var names/types to conform to standards
1297: l_vendor_site_id po_headers.vendor_site_id%TYPE := null;
1298: l_to_ship_to_location_id po_line_locations.ship_to_location_id%TYPE;
1299: l_to_ship_to_organization_id po_line_locations.ship_to_organization_id%TYPE;
1300: l_item_id po_lines.item_id%TYPE := null;
1301: l_count number:= 0;
1302: l_quantity po_line_locations.quantity%TYPE;

Line 1299: l_to_ship_to_organization_id po_line_locations.ship_to_organization_id%TYPE;

1295:
1296: --bug #2717053: changed var names/types to conform to standards
1297: l_vendor_site_id po_headers.vendor_site_id%TYPE := null;
1298: l_to_ship_to_location_id po_line_locations.ship_to_location_id%TYPE;
1299: l_to_ship_to_organization_id po_line_locations.ship_to_organization_id%TYPE;
1300: l_item_id po_lines.item_id%TYPE := null;
1301: l_count number:= 0;
1302: l_quantity po_line_locations.quantity%TYPE;
1303: l_quote_type_code po_headers.quote_type_lookup_code%TYPE := null;

Line 1302: l_quantity po_line_locations.quantity%TYPE;

1298: l_to_ship_to_location_id po_line_locations.ship_to_location_id%TYPE;
1299: l_to_ship_to_organization_id po_line_locations.ship_to_organization_id%TYPE;
1300: l_item_id po_lines.item_id%TYPE := null;
1301: l_count number:= 0;
1302: l_quantity po_line_locations.quantity%TYPE;
1303: l_quote_type_code po_headers.quote_type_lookup_code%TYPE := null;
1304:
1305: x_sob_id number:= null;
1306:

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

1308: -- Bug Fix for #2697755: COPY PO WITH CONSIGNED SHIPMENT LINE FAILS
1309: l_vendor_id
1310: po_headers.vendor_id%TYPE := null;
1311: l_consigned_flag
1312: po_line_locations.consigned_flag%TYPE := null;
1313: l_consigned_from_supplier_flag
1314: po_asl_attributes.consigned_from_supplier_flag%TYPE := null;
1315: l_enable_vmi_flag
1316: po_asl_attributes.enable_vmi_flag%TYPE := null;

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

1314: po_asl_attributes.consigned_from_supplier_flag%TYPE := null;
1315: l_enable_vmi_flag
1316: po_asl_attributes.enable_vmi_flag%TYPE := null;
1317: l_accrue_on_receipt_flag
1318: po_line_locations.accrue_on_receipt_flag%TYPE := null;
1319: l_closed_code
1320: po_line_locations.closed_code%TYPE := null;
1321: l_closed_reason
1322: po_line_locations.closed_reason%TYPE := null;

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

1316: po_asl_attributes.enable_vmi_flag%TYPE := null;
1317: l_accrue_on_receipt_flag
1318: po_line_locations.accrue_on_receipt_flag%TYPE := null;
1319: l_closed_code
1320: po_line_locations.closed_code%TYPE := null;
1321: l_closed_reason
1322: po_line_locations.closed_reason%TYPE := null;
1323: l_inspection_required_flag
1324: po_line_locations.inspection_required_flag%TYPE := null;

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

1318: po_line_locations.accrue_on_receipt_flag%TYPE := null;
1319: l_closed_code
1320: po_line_locations.closed_code%TYPE := null;
1321: l_closed_reason
1322: po_line_locations.closed_reason%TYPE := null;
1323: l_inspection_required_flag
1324: po_line_locations.inspection_required_flag%TYPE := null;
1325: l_receipt_required_flag
1326: po_line_locations.receipt_required_flag%TYPE := null;

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

1320: po_line_locations.closed_code%TYPE := null;
1321: l_closed_reason
1322: po_line_locations.closed_reason%TYPE := null;
1323: l_inspection_required_flag
1324: po_line_locations.inspection_required_flag%TYPE := null;
1325: l_receipt_required_flag
1326: po_line_locations.receipt_required_flag%TYPE := null;
1327: l_match_option
1328: po_line_locations.match_option%TYPE := null;

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

1322: po_line_locations.closed_reason%TYPE := null;
1323: l_inspection_required_flag
1324: po_line_locations.inspection_required_flag%TYPE := null;
1325: l_receipt_required_flag
1326: po_line_locations.receipt_required_flag%TYPE := null;
1327: l_match_option
1328: po_line_locations.match_option%TYPE := null;
1329: l_last_billing_date date := null;
1330: l_consigned_billing_cycle number := null;

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

1324: po_line_locations.inspection_required_flag%TYPE := null;
1325: l_receipt_required_flag
1326: po_line_locations.receipt_required_flag%TYPE := null;
1327: l_match_option
1328: po_line_locations.match_option%TYPE := null;
1329: l_last_billing_date date := null;
1330: l_consigned_billing_cycle number := null;
1331: l_invoice_close_tolerance number := null;
1332: l_item_inv_asset_flag

Line 1347: l_line_value_basis PO_LINE_LOCATIONS_ALL.value_basis%type;

1343: x_secondary_quantity PO_LINES_ALL.SECONDARY_QUANTITY%TYPE := NULL;
1344: --
1345:
1346: -- Bug 4958300
1347: l_line_value_basis PO_LINE_LOCATIONS_ALL.value_basis%type;
1348: l_line_matching_basis PO_LINE_LOCATIONS_ALL.matching_basis%type;
1349: --
1350:
1351: l_clm_delivery_event_code po_lines_all.clm_delivery_event_code%type;

Line 1348: l_line_matching_basis PO_LINE_LOCATIONS_ALL.matching_basis%type;

1344: --
1345:
1346: -- Bug 4958300
1347: l_line_value_basis PO_LINE_LOCATIONS_ALL.value_basis%type;
1348: l_line_matching_basis PO_LINE_LOCATIONS_ALL.matching_basis%type;
1349: --
1350:
1351: l_clm_delivery_event_code po_lines_all.clm_delivery_event_code%type;
1352:

Line 1642: INSERT INTO PO_LINE_LOCATIONS (

1638: END IF;
1639:
1640: --
1641:
1642: INSERT INTO PO_LINE_LOCATIONS (
1643: accrue_on_receipt_flag,
1644: allow_substitute_receipts_flag,
1645: approved_date,
1646: approved_flag,

Line 3053: x_po_shipment_record IN OUT NOCOPY PO_LINE_LOCATIONS%ROWTYPE,

3049: p_online_report_id IN NUMBER,
3050: p_line_num IN NUMBER,
3051: p_inv_org_id IN NUMBER,
3052: p_item_id IN NUMBER, -- Bug 3433867
3053: x_po_shipment_record IN OUT NOCOPY PO_LINE_LOCATIONS%ROWTYPE,
3054: x_sequence IN OUT NOCOPY NUMBER,
3055: x_return_code OUT NOCOPY NUMBER,
3056: p_is_complex_work_po IN BOOLEAN --
3057: ) IS

Line 3144: from po_line_locations

3140: /* Get the item_id, accrue on receipt flag, and expense accrual code */
3141:
3142: select receipt_required_flag
3143: into l_poll_receipt_required_flag
3144: from po_line_locations
3145: where line_location_id = p_orig_line_location_id;
3146:
3147: l_progress := '050';
3148:

Line 3316: p_po_shipment_rec IN PO_LINE_LOCATIONS%ROWTYPE,

3312: p_copy_attachments IN BOOLEAN,
3313: p_online_report_id IN NUMBER,
3314: p_po_header_rec IN PO_HEADERS%ROWTYPE,
3315: p_po_line_rec IN PO_LINES%ROWTYPE,
3316: p_po_shipment_rec IN PO_LINE_LOCATIONS%ROWTYPE,
3317: p_sob_id IN FINANCIALS_SYSTEM_PARAMETERS.set_of_books_id%TYPE,
3318: x_po_distribution_rec IN OUT NOCOPY PO_DISTRIBUTIONS%ROWTYPE,
3319: x_sequence IN OUT NOCOPY NUMBER,
3320: x_return_code OUT NOCOPY NUMBER

Line 3331: l_line_location_id PO_LINE_LOCATIONS_ALL.line_location_id%TYPE;

3327:
3328: --: use local vars for this to handle BPA case
3329: l_line_id PO_LINES_ALL.po_line_id%TYPE;
3330: l_line_num PO_LINES_ALL.line_num%TYPE;
3331: l_line_location_id PO_LINE_LOCATIONS_ALL.line_location_id%TYPE;
3332: l_shipment_num PO_LINE_LOCATIONS_ALL.shipment_num%TYPE;
3333: l_distribution_type PO_DISTRIBUTIONS_ALL.distribution_type%TYPE;
3334:
3335: BEGIN

Line 3332: l_shipment_num PO_LINE_LOCATIONS_ALL.shipment_num%TYPE;

3328: --: use local vars for this to handle BPA case
3329: l_line_id PO_LINES_ALL.po_line_id%TYPE;
3330: l_line_num PO_LINES_ALL.line_num%TYPE;
3331: l_line_location_id PO_LINE_LOCATIONS_ALL.line_location_id%TYPE;
3332: l_shipment_num PO_LINE_LOCATIONS_ALL.shipment_num%TYPE;
3333: l_distribution_type PO_DISTRIBUTIONS_ALL.distribution_type%TYPE;
3334:
3335: BEGIN
3336:

Line 3526: x_po_shipment_record po_line_locations%ROWTYPE;

3522: COPYDOC_FATAL EXCEPTION;
3523:
3524: x_po_header_record PO_HEADERS%ROWTYPE;
3525: x_po_line_record po_lines%ROWTYPE;
3526: x_po_shipment_record po_line_locations%ROWTYPE;
3527: x_po_distribution_record po_distributions%ROWTYPE;
3528:
3529: x_orig_po_line_id po_lines.po_line_id%TYPE;
3530: x_orig_line_location_id po_line_locations.line_location_id%TYPE;

Line 3530: x_orig_line_location_id po_line_locations.line_location_id%TYPE;

3526: x_po_shipment_record po_line_locations%ROWTYPE;
3527: x_po_distribution_record po_distributions%ROWTYPE;
3528:
3529: x_orig_po_line_id po_lines.po_line_id%TYPE;
3530: x_orig_line_location_id po_line_locations.line_location_id%TYPE;
3531: x_orig_po_distribution_id po_distributions.po_distribution_id%TYPE;
3532:
3533: x_document_num VARCHAR(100);
3534: x_line_num po_online_report_text.line_num%TYPE := NULL;

Line 3549: PO_LINE_LOCATIONS_ALL.transaction_flow_header_id%TYPE;

3545: x_orig_quotation_class_code po_headers.quotation_class_code%TYPE := NULL;
3546:
3547: --< Shared Proc FPJ Start >
3548: l_orig_txn_flow_header_id
3549: PO_LINE_LOCATIONS_ALL.transaction_flow_header_id%TYPE;
3550: l_generate_new_accounts BOOLEAN := FALSE;
3551: --< Shared Proc FPJ End >
3552: l_calling_program VARCHAR2(30); --
3553: l_return_status VARCHAR2(1); --

Line 4245: FROM PO_LINE_LOCATIONS

4241: ) RETURN BOOLEAN IS
4242:
4243: CURSOR l_po_shipment_csr(p_po_header_id PO_HEADERS_ALL.po_header_id%TYPE) IS
4244: SELECT line_location_id
4245: FROM PO_LINE_LOCATIONS
4246: WHERE po_header_id = p_po_header_id
4247: AND SHIPMENT_TYPE NOT IN ('SCHEDULED','BLANKET');
4248:
4249: l_line_location_id PO_LINE_LOCATIONS.line_location_id%TYPE;

Line 4249: l_line_location_id PO_LINE_LOCATIONS.line_location_id%TYPE;

4245: FROM PO_LINE_LOCATIONS
4246: WHERE po_header_id = p_po_header_id
4247: AND SHIPMENT_TYPE NOT IN ('SCHEDULED','BLANKET');
4248:
4249: l_line_location_id PO_LINE_LOCATIONS.line_location_id%TYPE;
4250:
4251: BEGIN
4252: OPEN l_po_shipment_csr(p_po_header_id);
4253:

Line 4642: ,x_po_shipment_record IN OUT NOCOPY PO_LINE_LOCATIONS%ROWTYPE

4638: ,p_from_pk_value IN NUMBER
4639: ,p_to_pk_value IN NUMBER
4640: ,x_po_header_record IN OUT NOCOPY PO_HEADERS%ROWTYPE
4641: ,x_po_line_record IN OUT NOCOPY po_lines%ROWTYPE
4642: ,x_po_shipment_record IN OUT NOCOPY PO_LINE_LOCATIONS%ROWTYPE
4643: ,x_po_distribution_rec IN OUT NOCOPY PO_DISTRIBUTIONS%ROWTYPE
4644: ,x_return_status OUT NOCOPY VARCHAR2
4645: ,x_msg_count OUT NOCOPY NUMBER
4646: ,x_msg_data OUT NOCOPY VARCHAR2

Line 4763: FROM po_lines_all pl, po_line_locations_all pll

4759: -- Update POP Dates only if delivery event is not used.
4760:
4761: SELECT pl.CLM_DELIVERY_EVENT_CODE
4762: INTO l_clm_delivery_event_code
4763: FROM po_lines_all pl, po_line_locations_all pll
4764: WHERE pll.LINE_LOCATION_ID = p_from_pk_value
4765: AND pll.po_line_id = pl.po_line_id;
4766:
4767: UPDATE PO_LINE_LOCATIONS_ALL

Line 4767: UPDATE PO_LINE_LOCATIONS_ALL

4763: FROM po_lines_all pl, po_line_locations_all pll
4764: WHERE pll.LINE_LOCATION_ID = p_from_pk_value
4765: AND pll.po_line_id = pl.po_line_id;
4766:
4767: UPDATE PO_LINE_LOCATIONS_ALL
4768: SET uda_template_id = x_po_shipment_record.uda_template_id,
4769: clm_period_perf_end_date = decode(l_clm_delivery_event_code, --
4770: null, x_po_shipment_record.clm_period_perf_end_date,
4771: null),

Line 4781: FROM po_line_locations_all

4777: END IF;
4778:
4779: SELECT UDA_TEMPLATE_ID
4780: INTO l_template_id
4781: FROM po_line_locations_all
4782: WHERE LINE_LOCATION_ID = p_from_pk_value;
4783:
4784: IF l_template_id IS NULL THEN
4785: RETURN;