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_INTERFACE_S dependencies on PO_HEADERS_INTERFACE

Line 313: FROM po_headers_interface phi,

309: , pli.ip_category_id ip_category_id
310: , pli.supplier_part_auxid supplier_part_auxid
311: , pli.catalog_name catalog_name
312: --
313: FROM po_headers_interface phi,
314: po_lines_interface pli,
315: po_distributions_interface pdi
316: WHERE phi.interface_header_id = pli.interface_header_id
317: AND pli.interface_line_id = pdi.interface_line_id

Line 345: g_mode po_headers_interface.action%type := null;

341: g_sourcing_errorcode number;
342: g_interface_source_code varchar2(25);
343: --
344:
345: g_mode po_headers_interface.action%type := null;
346: g_group_code po_headers_interface.group_code%type := null;
347: g_document_subtype po_headers_interface.document_subtype%type := null;
348: g_po_release_id number := null;
349: g_document_type varchar2(25) := null;

Line 346: g_group_code po_headers_interface.group_code%type := null;

342: g_interface_source_code varchar2(25);
343: --
344:
345: g_mode po_headers_interface.action%type := null;
346: g_group_code po_headers_interface.group_code%type := null;
347: g_document_subtype po_headers_interface.document_subtype%type := null;
348: g_po_release_id number := null;
349: g_document_type varchar2(25) := null;
350: g_number_records_processed number;

Line 347: g_document_subtype po_headers_interface.document_subtype%type := null;

343: --
344:
345: g_mode po_headers_interface.action%type := null;
346: g_group_code po_headers_interface.group_code%type := null;
347: g_document_subtype po_headers_interface.document_subtype%type := null;
348: g_po_release_id number := null;
349: g_document_type varchar2(25) := null;
350: g_number_records_processed number;
351: g_purchasing_ou_id PO_HEADERS_ALL.org_id%TYPE; --

Line 512: p_interface_header_id IN PO_HEADERS_INTERFACE.interface_header_id%TYPE

508:
509: --
510:
511: FUNCTION validate_interface_records (
512: p_interface_header_id IN PO_HEADERS_INTERFACE.interface_header_id%TYPE
513: ) RETURN BOOLEAN;
514:
515: FUNCTION validate_config_id (
516: p_interface_header_id IN PO_HEADERS_INTERFACE.interface_header_id%TYPE

Line 516: p_interface_header_id IN PO_HEADERS_INTERFACE.interface_header_id%TYPE

512: p_interface_header_id IN PO_HEADERS_INTERFACE.interface_header_id%TYPE
513: ) RETURN BOOLEAN;
514:
515: FUNCTION validate_config_id (
516: p_interface_header_id IN PO_HEADERS_INTERFACE.interface_header_id%TYPE
517: ) RETURN BOOLEAN;
518:
519: --
520:

Line 871: l_style_id PO_HEADERS_INTERFACE.style_id%TYPE;

867: --
868: l_progress VARCHAR2(3) := '000'; --< Bug 3210331 >
869:
870: -- CLM Autocreate
871: l_style_id PO_HEADERS_INTERFACE.style_id%TYPE;
872: l_clm_enabled_flag VARCHAR2(1):= 'N';
873: l_change_process_type PO_DOC_STYLE_HEADERS.change_process_type%TYPE;
874: l_is_clm_flow VARCHAR2(1):= 'N';
875:

Line 900: FROM po_headers_interface phi

896:
897: /* For now a batch has only one header, so get the document header id */
898: SELECT min(phi.interface_header_id)
899: INTO x_interface_header_id
900: FROM po_headers_interface phi
901: WHERE phi.batch_id = p_batch_id;
902:
903: /* Getting the style_id of the target document */
904: SELECT phi.style_id

Line 906: FROM po_headers_interface phi

902:
903: /* Getting the style_id of the target document */
904: SELECT phi.style_id
905: INTO l_style_id
906: FROM po_headers_interface phi
907: WHERE phi.interface_header_id=x_interface_header_id;
908:
909: l_progress := '015';
910: IF g_debug_stmt THEN

Line 1048: FROM po_headers_interface

1044:
1045: /* For now a batch has only one header, so get the document header id */
1046: SELECT min(interface_header_id)
1047: INTO x_interface_header_id
1048: FROM po_headers_interface
1049: WHERE batch_id = p_batch_id; --
1050:
1051: l_progress:='040';
1052: --

Line 1058: FROM po_headers_interface

1054: --
1055: --Modified the select statement to select document_subtype as well.
1056: SELECT document_type_code,document_subtype,nvl(interface_source_code,'NOCODE')
1057: INTO g_document_type,g_document_subtype,g_interface_source_code
1058: FROM po_headers_interface
1059: WHERE interface_header_id = x_interface_header_id;
1060:
1061: -- Populate global variable to indicate whether
1062: -- tax is calculated for this document type

Line 1511: FROM po_headers_interface phi

1507:
1508: --
1509: SELECT phi.style_id
1510: INTO l_style_id
1511: FROM po_headers_interface phi
1512: WHERE phi.interface_header_id = x_interface_header_id;
1513:
1514: IF (l_style_id IS NOT NULL) THEN
1515: l_is_complex_work_po := PO_COMPLEX_WORK_PVT.is_complex_work_style(

Line 2049: --For more comments please refer to update po_headers_interface phi

2045: end if;
2046:
2047: --
2048: --The following insert is modified to take care of defaulting for sourcing
2049: --For more comments please refer to update po_headers_interface phi
2050: --in setup_interface_tables procedure.
2051: /* Bug 2816396
2052: Use the interface table value for pay_on_code when inserting into po_headers.pay_on_code
2053: */

Line 8556: l_po_currency_code PO_HEADERS_INTERFACE.currency_code%TYPE;

8552: l_base_unit_price PO_LINES_INTERFACE.base_unit_price%TYPE;
8553: l_amount PO_LINES_INTERFACE.amount%TYPE;
8554: l_quantity_dummy PO_LINES_INTERFACE.quantity%TYPE;
8555: l_order_type_lookup_code PO_LINE_TYPES_B.order_type_lookup_code%TYPE;
8556: l_po_currency_code PO_HEADERS_INTERFACE.currency_code%TYPE;
8557: l_req_header_rate_type PO_HEADERS_INTERFACE.rate_type%TYPE;
8558: l_req_header_rate_date PO_HEADERS_INTERFACE.rate_date%TYPE;
8559: l_req_header_rate PO_HEADERS_INTERFACE.rate%TYPE;
8560: l_dist_rate PO_DISTRIBUTIONS_INTERFACE.rate%TYPE;

Line 8557: l_req_header_rate_type PO_HEADERS_INTERFACE.rate_type%TYPE;

8553: l_amount PO_LINES_INTERFACE.amount%TYPE;
8554: l_quantity_dummy PO_LINES_INTERFACE.quantity%TYPE;
8555: l_order_type_lookup_code PO_LINE_TYPES_B.order_type_lookup_code%TYPE;
8556: l_po_currency_code PO_HEADERS_INTERFACE.currency_code%TYPE;
8557: l_req_header_rate_type PO_HEADERS_INTERFACE.rate_type%TYPE;
8558: l_req_header_rate_date PO_HEADERS_INTERFACE.rate_date%TYPE;
8559: l_req_header_rate PO_HEADERS_INTERFACE.rate%TYPE;
8560: l_dist_rate PO_DISTRIBUTIONS_INTERFACE.rate%TYPE;
8561: l_rate_for_req_fields PO_HEADERS_INTERFACE.rate%TYPE;

Line 8558: l_req_header_rate_date PO_HEADERS_INTERFACE.rate_date%TYPE;

8554: l_quantity_dummy PO_LINES_INTERFACE.quantity%TYPE;
8555: l_order_type_lookup_code PO_LINE_TYPES_B.order_type_lookup_code%TYPE;
8556: l_po_currency_code PO_HEADERS_INTERFACE.currency_code%TYPE;
8557: l_req_header_rate_type PO_HEADERS_INTERFACE.rate_type%TYPE;
8558: l_req_header_rate_date PO_HEADERS_INTERFACE.rate_date%TYPE;
8559: l_req_header_rate PO_HEADERS_INTERFACE.rate%TYPE;
8560: l_dist_rate PO_DISTRIBUTIONS_INTERFACE.rate%TYPE;
8561: l_rate_for_req_fields PO_HEADERS_INTERFACE.rate%TYPE;
8562: l_po_func_unit_price PO_LINES_ALL.unit_price%TYPE;

Line 8559: l_req_header_rate PO_HEADERS_INTERFACE.rate%TYPE;

8555: l_order_type_lookup_code PO_LINE_TYPES_B.order_type_lookup_code%TYPE;
8556: l_po_currency_code PO_HEADERS_INTERFACE.currency_code%TYPE;
8557: l_req_header_rate_type PO_HEADERS_INTERFACE.rate_type%TYPE;
8558: l_req_header_rate_date PO_HEADERS_INTERFACE.rate_date%TYPE;
8559: l_req_header_rate PO_HEADERS_INTERFACE.rate%TYPE;
8560: l_dist_rate PO_DISTRIBUTIONS_INTERFACE.rate%TYPE;
8561: l_rate_for_req_fields PO_HEADERS_INTERFACE.rate%TYPE;
8562: l_po_func_unit_price PO_LINES_ALL.unit_price%TYPE;
8563: -- Bug 3463242 END

Line 8561: l_rate_for_req_fields PO_HEADERS_INTERFACE.rate%TYPE;

8557: l_req_header_rate_type PO_HEADERS_INTERFACE.rate_type%TYPE;
8558: l_req_header_rate_date PO_HEADERS_INTERFACE.rate_date%TYPE;
8559: l_req_header_rate PO_HEADERS_INTERFACE.rate%TYPE;
8560: l_dist_rate PO_DISTRIBUTIONS_INTERFACE.rate%TYPE;
8561: l_rate_for_req_fields PO_HEADERS_INTERFACE.rate%TYPE;
8562: l_po_func_unit_price PO_LINES_ALL.unit_price%TYPE;
8563: -- Bug 3463242 END
8564:
8565: l_item_in_linv_pou VARCHAR2(1):= 'Y'; -- Bug 3433867

Line 8616: PO_HEADERS_INTERFACE phi,

8612: pdi.rate
8613: -- Bug 3463242 END
8614: FROM PO_DISTRIBUTIONS_INTERFACE pdi,
8615: PO_LINES_INTERFACE pli,
8616: PO_HEADERS_INTERFACE phi,
8617: PO_REQUISITION_LINES_ALL prl, --
8618: MTL_PARAMETERS mp,
8619: HR_ORGANIZATION_INFORMATION hoi,
8620: PO_LINE_TYPES_B plt -- Bug 3463242

Line 9266: po_headers_interface phi,

9262: phi.vendor_id,
9263: phi.vendor_site_id,
9264: pdi.destination_organization_id
9265: from po_lines_interface pli,
9266: po_headers_interface phi,
9267: po_distributions_interface pdi
9268: where phi.interface_header_id = x_interface_header_id
9269: and phi.interface_header_id = pli.interface_header_id
9270: and pdi.interface_distribution_id =

Line 9297: po_headers_interface phi,

9293: phi.rate_date,
9294: phi.document_subtype,
9295: pli.unit_price --
9296: FROM po_lines_interface pli,
9297: po_headers_interface phi,
9298: po_line_types plt
9299: WHERE phi.interface_header_id = x_interface_header_id
9300: AND phi.interface_header_id = pli.interface_header_id
9301: AND pli.requisition_line_id is null

Line 9334: UPDATE po_headers_interface

9330: IF g_debug_stmt THEN --< Bug 3210331: use proper debugging >
9331: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);
9332: END IF;
9333:
9334: UPDATE po_headers_interface
9335: SET process_code = 'IN PROCESS'
9336: WHERE interface_header_id = x_interface_header_id;
9337:
9338: l_progress := '010';

Line 9356: FROM po_headers_interface

9352: min(document_num)
9353: INTO g_mode,
9354: g_group_code,
9355: x_old_document_num
9356: FROM po_headers_interface
9357: WHERE interface_header_id = x_interface_header_id;
9358:
9359: IF g_debug_stmt THEN --< Bug 3210331: use proper debugging >
9360: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

Line 9376: UPDATE po_headers_interface phi

9372: */
9373:
9374: IF (g_document_type = 'RFQ') THEN
9375: l_progress:='030';
9376: UPDATE po_headers_interface phi
9377: SET po_header_id =
9378: (SELECT ph.po_header_id
9379: FROM po_headers_all ph --
9380: WHERE 'RFQ' = ph.type_lookup_code

Line 9387: UPDATE po_headers_interface phi

9383: WHERE interface_header_id = x_interface_header_id;
9384:
9385: ELSE
9386: l_progress:='040';
9387: UPDATE po_headers_interface phi
9388: SET po_header_id =
9389: (SELECT ph.po_header_id
9390: FROM po_headers_all ph --
9391: WHERE decode(phi.document_subtype,

Line 9417: UPDATE po_headers_interface phi

9413: /* Bug 482648 add currecny_code */
9414:
9415: /* Also get the pay_on_code from the document */
9416:
9417: UPDATE po_headers_interface phi
9418: SET (
9419: rate,
9420: rate_type_code,
9421: rate_date,

Line 9474: ** should already be loaded into the po_headers_interface table.

9470:
9471: /* If we are using automatic numbering, get segment1
9472: ** from the po_unique_identifier_control table.
9473: ** If we are using manual numbering, segment1
9474: ** should already be loaded into the po_headers_interface table.
9475: ** The checks to verify that a manual po number is unique
9476: ** is done on the client side.
9477: */
9478: /* ecso 4/23/98 emergency requisition enhancement

Line 9482: ** and there exists a document_num on po_headers_interface

9478: /* ecso 4/23/98 emergency requisition enhancement
9479: ** For emergency requisitions, there is a reserved po num
9480: ** even though the document has not been created.
9481: ** Add the case where the document is NEW
9482: ** and there exists a document_num on po_headers_interface
9483: */
9484: --
9485: --modified the if condition to include PA
9486: IF (params.po_num_code='AUTOMATIC') AND

Line 9554: po_headers_interface phi

9550: INTO x_po_header_id,
9551: x_pay_on_code,
9552: l_shipping_control --
9553: FROM po_headers_all ph, --
9554: po_headers_interface phi
9555: WHERE phi.interface_header_id = x_interface_header_id
9556: AND ph.segment1 = phi.document_num
9557: AND ph.type_lookup_code='BLANKET'
9558: AND NVL(ph.org_id, -99) = NVL(g_purchasing_ou_id, -99); --

Line 9573: po_headers_interface phi

9569:
9570: SELECT min(interface_line_id)
9571: INTO x_min_interface_line_id
9572: FROM po_lines_interface pli,
9573: po_headers_interface phi
9574: WHERE phi.interface_header_id=pli.interface_header_id
9575: AND phi.interface_header_id = x_interface_header_id;
9576:
9577: l_progress:='100';

Line 9583: --interface tables. But po_headers_interface table would contain values

9579: --modify the following update to default the values for the blanket also.
9580: --track 'PA' for the changes. Also please note that we have added deocode
9581: --for all the terms and conditions.Existing autocreate would not values
9582: --for different terms n condition columns and shipto billto columns in the
9583: --interface tables. But po_headers_interface table would contain values
9584: --for these columns when called from sourcing. So we are not defaulting
9585: --these values from params here but would do this in create_po procedure
9586: --in the order of interface,vendor,params.
9587: /* Bug 2816396

Line 9596: UPDATE po_headers_interface phi

9592: p_token => l_progress,
9593: p_message => 'Sourcing to FPH-6 starts');
9594: END IF;
9595:
9596: UPDATE po_headers_interface phi
9597: SET (po_header_id,
9598: last_update_date,
9599: last_updated_by,
9600: document_num,

Line 9678: -- bug 8802204: Checking the value of the acceptance_required_flag from po_headers_interface

9674: --phi.rate_date,
9675: nvl(phi.rate_date,decode(g_interface_source_code,'SOURCING',decode(phi.rate_type_code,'User',sysdate),phi.rate_date)),
9676: --
9677: phi.rate,
9678: -- bug 8802204: Checking the value of the acceptance_required_flag from po_headers_interface
9679: decode(g_document_type, 'PO',
9680: nvl(phi.acceptance_required_flag,nvl(params.acceptance_required_flag,'N')), /* Bug 7518967 : Default Acceptance Required Check ER: Geting default acceptance_required_flag */
9681: 'PA',nvl(phi.acceptance_required_flag,nvl(params.acceptance_required_flag,'N')),
9682: params.acceptance_required_flag),

Line 9693: FROM po_headers_interface phi2,

9689: 'PA',nvl(phi.min_release_amount,params.min_rel_amount),
9690: null),
9691: phi.document_subtype,
9692: l_shipping_control --
9693: FROM po_headers_interface phi2,
9694: po_lines_interface pli
9695: WHERE phi2.interface_header_id = phi.interface_header_id
9696: AND pli.interface_header_id=phi2.interface_header_id
9697: AND pli.interface_line_id = x_min_interface_line_id)

Line 9714: from po_headers_interface

9710: IF (g_document_subtype = 'RELEASE') THEN
9711:
9712: select po_header_id
9713: into x_po_header_id
9714: from po_headers_interface
9715: where interface_header_id = x_interface_header_id;
9716:
9717: IF g_debug_stmt THEN --< Bug 3210331: use proper debugging >
9718: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

Line 9858: po_headers_interface phi,

9854: -- end of 1548597
9855: prl.drop_ship_flag, --
9856: prl.vmi_flag -- VMI FPH
9857: FROM po_lines_interface pli,
9858: po_headers_interface phi,
9859: po_requisition_lines_all prl, --
9860: po_line_types plt,
9861: po_lines_all pol --
9862: WHERE pli.interface_line_id = pli2.interface_line_id

Line 9901: po_headers_interface phi

9897: x_po_header_id,
9898: nvl(pli.negotiated_by_preparer_flag,'N'),
9899: nvl(pli.firm_flag,'N')
9900: FROM po_lines_interface pli,
9901: po_headers_interface phi
9902: WHERE pli.interface_line_id = pli2.interface_line_id
9903: AND pli.interface_header_id = phi.interface_header_id
9904: AND phi.interface_header_id = x_interface_header_id);*/
9905:

Line 10062: po_headers_interface phi,

10058: nvl(pli.contractor_last_name, prl.candidate_last_name)
10059: --
10060: ,pol.supplier_part_auxid --13876074
10061: FROM po_lines_interface pli,
10062: po_headers_interface phi,
10063: po_requisition_lines_all prl, --
10064: po_line_types plt
10065: ,po_lines_all pol --13876074
10066: WHERE pli.interface_line_id = pli2.interface_line_id

Line 10212: po_headers_interface phi

10208: prd.oke_contract_deliverable_id)
10209: FROM po_requisition_lines_all prl, --
10210: po_req_distributions_all prd, --
10211: po_lines_interface pli,
10212: po_headers_interface phi
10213: WHERE prd.requisition_line_id = prl.requisition_line_id
10214: AND prl.requisition_line_id = pli.requisition_line_id -- Bug:1563888
10215: AND pli.interface_header_id = phi.interface_header_id
10216: AND phi.interface_header_id = x_interface_header_id;

Line 10472: DELETE po_headers_interface

10468: DELETE po_lines_interface
10469: WHERE interface_header_id = x_interface_header_id;
10470:
10471:
10472: DELETE po_headers_interface
10473: WHERE interface_header_id = x_interface_header_id;
10474:
10475: IF g_debug_stmt THEN --< Bug 3210331: use proper debugging >
10476: PO_DEBUG.debug_end(p_log_head => g_log_head||'wrapup');

Line 10657: FROM po_headers_interface phi

10653: INTO x_document_num,
10654: x_document_type_code,
10655: x_document_subtype,
10656: x_release_num
10657: FROM po_headers_interface phi
10658: WHERE phi.interface_header_id = x_interface_header_id;
10659:
10660: IF (g_document_type = 'RFQ') THEN
10661: x_document_subtype := 'RFQ';

Line 12840: po_headers_interface phi

12836:
12837: SELECT por.po_release_id
12838: INTO g_po_release_id
12839: FROM po_releases_all por, --
12840: po_headers_interface phi
12841: WHERE phi.interface_header_id = x_interface_header_id
12842: AND phi.release_num = por.release_num
12843: AND phi.po_header_id = por.po_header_id
12844: AND NVL(por.org_id, -99) = NVL(g_purchasing_ou_id, -99) --

Line 12881: FROM po_headers_interface PHI,

12877: );
12878:
12879: SELECT POL.po_line_id
12880: INTO l_po_line_id
12881: FROM po_headers_interface PHI,
12882: po_lines_all POL
12883: WHERE PHI.interface_header_id = x_interface_header_id
12884: AND PHI.po_header_id = POL.po_header_id
12885: AND POL.line_num = x_po_line_num;

Line 13022: po_headers_interface phi,

13018: 'INVENTORY', 'Y',
13019: 'SHOP FLOOR','Y')
13020: INTO x_receipt_required_flag
13021: FROM po_lines_interface pli,
13022: po_headers_interface phi,
13023: po_requisition_lines_all prl, --
13024: mtl_system_items msi,
13025: po_line_types plt,
13026: po_vendors pov,

Line 13092: PO_HEADERS_INTERFACE PHI

13088: PO_LINE_TYPES PLT ,
13089: PO_SYSTEM_PARAMETERS_ALL PSP , --
13090: FINANCIALS_SYSTEM_PARAMS_ALL FSP, --
13091: PO_VENDORS POV,
13092: PO_HEADERS_INTERFACE PHI
13093: WHERE PLI.LINE_NUM = x_po_line_num
13094: AND PLI.shipment_num is not null
13095: AND NVL(psp.org_id, -99) = NVL(g_purchasing_ou_id, -99) --
13096: AND NVL(fsp.org_id, -99) = NVL(g_purchasing_ou_id, -99) --

Line 13213: PO_HEADERS_INTERFACE PHI

13209: PO_LINE_TYPES PLT ,
13210: PO_SYSTEM_PARAMETERS_ALL PSP , --
13211: FINANCIALS_SYSTEM_PARAMS_ALL FSP, --
13212: PO_VENDORS POV,
13213: PO_HEADERS_INTERFACE PHI
13214: WHERE PLI.LINE_NUM = x_po_line_num
13215: AND PLI.shipment_num is not null
13216: AND PLI.item_id = MSI.inventory_item_id
13217: AND MSI.organization_id=

Line 13304: PO_HEADERS_INTERFACE

13300: l_progress:='180';
13301: SELECT document_subtype
13302: into x_check_doc_sub_type
13303: from
13304: PO_HEADERS_INTERFACE
13305: WHERE
13306: INTERFACE_HEADER_ID=x_interface_header_id;
13307: exception
13308: When others then

Line 13341: PO_HEADERS_INTERFACE PHI

13337: PO_LINE_TYPES PLT ,
13338: PO_SYSTEM_PARAMETERS_ALL PSP , --
13339: FINANCIALS_SYSTEM_PARAMS_ALL FSP, --
13340: PO_VENDORS POV,
13341: PO_HEADERS_INTERFACE PHI
13342: WHERE PLI.LINE_NUM = x_po_line_num
13343: AND PLI.shipment_num is not null
13344: AND NVL(psp.org_id, -99) = NVL(g_purchasing_ou_id, -99) --
13345: AND NVL(fsp.org_id, -99) = NVL(g_purchasing_ou_id, -99) --

Line 14484: p_interface_header_id IN PO_HEADERS_INTERFACE.interface_header_id%TYPE

14480: --End of Comments
14481: ----------------------------------------------------------------------------
14482:
14483: FUNCTION validate_interface_records (
14484: p_interface_header_id IN PO_HEADERS_INTERFACE.interface_header_id%TYPE
14485: ) RETURN BOOLEAN IS
14486:
14487: l_api_name CONSTANT VARCHAR2(30) := 'validate_interface_records';
14488: l_pass_validations BOOLEAN;

Line 14522: p_interface_header_id IN PO_HEADERS_INTERFACE.interface_header_id%TYPE

14518: --End of Comments
14519: ----------------------------------------------------------------------------
14520:
14521: FUNCTION validate_config_id (
14522: p_interface_header_id IN PO_HEADERS_INTERFACE.interface_header_id%TYPE
14523: ) RETURN BOOLEAN IS
14524:
14525: l_api_name CONSTANT VARCHAR2(30) := 'validate_config_id';
14526: l_num_config_id_lines NUMBER;

Line 14814: l_rate_type PO_HEADERS_INTERFACE.rate_type%TYPE;

14810: l_po_ou_sob_id GL_SETS_OF_BOOKS.set_of_books_id%TYPE;
14811: l_inverse_rate_display_flag VARCHAR2(1) := 'N';
14812: l_display_rate NUMBER;
14813: l_progress VARCHAR2(3) := '000';
14814: l_rate_type PO_HEADERS_INTERFACE.rate_type%TYPE;
14815: l_api_name CONSTANT VARCHAR2(30) := 'get_rate_for_req_price'; --< Bug 3210331 >
14816:
14817: BEGIN
14818: IF g_debug_stmt THEN --< Bug 3210331: use proper debugging >