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_PRICE_BREAK_GRP dependencies on PO_REQUISITIONS_INTERFACE

Line 891: p_request_id IN po_requisitions_interface.request_id%TYPE

887: --
888: /* This procedure is a wrapper for get_price_break */
889: /* It is called by the ReqImport code */
890: Procedure Reqimport_Set_Break_Price(
891: p_request_id IN po_requisitions_interface.request_id%TYPE
892: ) IS
893: l_rowid VARCHAR2(250) := '';
894: l_src_blanket_header_id po_requisition_lines.blanket_po_header_id%TYPE;
895: l_src_blanket_line_num po_requisition_lines.blanket_po_line_num%TYPE;

Line 909: l_uom po_requisitions_interface.unit_of_measure%TYPE;

905: l_currency_code_out po_requisition_lines.currency_code%TYPE;
906: l_rate_type_out po_requisition_lines.rate_type%TYPE;
907: l_rate_date_out po_requisition_lines.rate_date%TYPE;
908: l_rate_out po_requisition_lines.rate%TYPE;
909: l_uom po_requisitions_interface.unit_of_measure%TYPE;
910: l_price_break_id po_line_locations_all.line_location_id%TYPE; --
911: l_progress VARCHAR2(3) := NULL;
912:
913: --

Line 914: l_org_id po_requisitions_interface.org_id%TYPE;

910: l_price_break_id po_line_locations_all.line_location_id%TYPE; --
911: l_progress VARCHAR2(3) := NULL;
912:
913: --
914: l_org_id po_requisitions_interface.org_id%TYPE;
915: l_requisition_header_id po_requisition_lines.requisition_header_id%TYPE;
916: l_requisition_line_id po_requisition_lines.requisition_line_id%TYPE;
917: l_creation_date po_requisitions_interface.creation_date%TYPE;
918: l_item_id po_requisitions_interface.item_id%TYPE;

Line 917: l_creation_date po_requisitions_interface.creation_date%TYPE;

913: --
914: l_org_id po_requisitions_interface.org_id%TYPE;
915: l_requisition_header_id po_requisition_lines.requisition_header_id%TYPE;
916: l_requisition_line_id po_requisition_lines.requisition_line_id%TYPE;
917: l_creation_date po_requisitions_interface.creation_date%TYPE;
918: l_item_id po_requisitions_interface.item_id%TYPE;
919: l_item_revision po_requisitions_interface.item_revision%TYPE;
920: l_category_id po_requisitions_interface.category_id%TYPE;
921: l_line_type_id po_requisitions_interface.line_type_id%TYPE;

Line 918: l_item_id po_requisitions_interface.item_id%TYPE;

914: l_org_id po_requisitions_interface.org_id%TYPE;
915: l_requisition_header_id po_requisition_lines.requisition_header_id%TYPE;
916: l_requisition_line_id po_requisition_lines.requisition_line_id%TYPE;
917: l_creation_date po_requisitions_interface.creation_date%TYPE;
918: l_item_id po_requisitions_interface.item_id%TYPE;
919: l_item_revision po_requisitions_interface.item_revision%TYPE;
920: l_category_id po_requisitions_interface.category_id%TYPE;
921: l_line_type_id po_requisitions_interface.line_type_id%TYPE;
922: l_suggested_vendor_item_num po_requisitions_interface.suggested_vendor_item_num%TYPE;

Line 919: l_item_revision po_requisitions_interface.item_revision%TYPE;

915: l_requisition_header_id po_requisition_lines.requisition_header_id%TYPE;
916: l_requisition_line_id po_requisition_lines.requisition_line_id%TYPE;
917: l_creation_date po_requisitions_interface.creation_date%TYPE;
918: l_item_id po_requisitions_interface.item_id%TYPE;
919: l_item_revision po_requisitions_interface.item_revision%TYPE;
920: l_category_id po_requisitions_interface.category_id%TYPE;
921: l_line_type_id po_requisitions_interface.line_type_id%TYPE;
922: l_suggested_vendor_item_num po_requisitions_interface.suggested_vendor_item_num%TYPE;
923: l_suggested_vendor_id po_requisitions_interface.suggested_vendor_id%TYPE;

Line 920: l_category_id po_requisitions_interface.category_id%TYPE;

916: l_requisition_line_id po_requisition_lines.requisition_line_id%TYPE;
917: l_creation_date po_requisitions_interface.creation_date%TYPE;
918: l_item_id po_requisitions_interface.item_id%TYPE;
919: l_item_revision po_requisitions_interface.item_revision%TYPE;
920: l_category_id po_requisitions_interface.category_id%TYPE;
921: l_line_type_id po_requisitions_interface.line_type_id%TYPE;
922: l_suggested_vendor_item_num po_requisitions_interface.suggested_vendor_item_num%TYPE;
923: l_suggested_vendor_id po_requisitions_interface.suggested_vendor_id%TYPE;
924: l_suggested_vendor_site_id po_requisitions_interface.suggested_vendor_site_id%TYPE;

Line 921: l_line_type_id po_requisitions_interface.line_type_id%TYPE;

917: l_creation_date po_requisitions_interface.creation_date%TYPE;
918: l_item_id po_requisitions_interface.item_id%TYPE;
919: l_item_revision po_requisitions_interface.item_revision%TYPE;
920: l_category_id po_requisitions_interface.category_id%TYPE;
921: l_line_type_id po_requisitions_interface.line_type_id%TYPE;
922: l_suggested_vendor_item_num po_requisitions_interface.suggested_vendor_item_num%TYPE;
923: l_suggested_vendor_id po_requisitions_interface.suggested_vendor_id%TYPE;
924: l_suggested_vendor_site_id po_requisitions_interface.suggested_vendor_site_id%TYPE;
925: -- Bug 3343892

Line 922: l_suggested_vendor_item_num po_requisitions_interface.suggested_vendor_item_num%TYPE;

918: l_item_id po_requisitions_interface.item_id%TYPE;
919: l_item_revision po_requisitions_interface.item_revision%TYPE;
920: l_category_id po_requisitions_interface.category_id%TYPE;
921: l_line_type_id po_requisitions_interface.line_type_id%TYPE;
922: l_suggested_vendor_item_num po_requisitions_interface.suggested_vendor_item_num%TYPE;
923: l_suggested_vendor_id po_requisitions_interface.suggested_vendor_id%TYPE;
924: l_suggested_vendor_site_id po_requisitions_interface.suggested_vendor_site_id%TYPE;
925: -- Bug 3343892
926: l_base_unit_price po_requisitions_interface.base_unit_price%TYPE;

Line 923: l_suggested_vendor_id po_requisitions_interface.suggested_vendor_id%TYPE;

919: l_item_revision po_requisitions_interface.item_revision%TYPE;
920: l_category_id po_requisitions_interface.category_id%TYPE;
921: l_line_type_id po_requisitions_interface.line_type_id%TYPE;
922: l_suggested_vendor_item_num po_requisitions_interface.suggested_vendor_item_num%TYPE;
923: l_suggested_vendor_id po_requisitions_interface.suggested_vendor_id%TYPE;
924: l_suggested_vendor_site_id po_requisitions_interface.suggested_vendor_site_id%TYPE;
925: -- Bug 3343892
926: l_base_unit_price po_requisitions_interface.base_unit_price%TYPE;
927: l_base_unit_price_out po_requisition_lines.base_unit_price%TYPE;

Line 924: l_suggested_vendor_site_id po_requisitions_interface.suggested_vendor_site_id%TYPE;

920: l_category_id po_requisitions_interface.category_id%TYPE;
921: l_line_type_id po_requisitions_interface.line_type_id%TYPE;
922: l_suggested_vendor_item_num po_requisitions_interface.suggested_vendor_item_num%TYPE;
923: l_suggested_vendor_id po_requisitions_interface.suggested_vendor_id%TYPE;
924: l_suggested_vendor_site_id po_requisitions_interface.suggested_vendor_site_id%TYPE;
925: -- Bug 3343892
926: l_base_unit_price po_requisitions_interface.base_unit_price%TYPE;
927: l_base_unit_price_out po_requisition_lines.base_unit_price%TYPE;
928: --

Line 926: l_base_unit_price po_requisitions_interface.base_unit_price%TYPE;

922: l_suggested_vendor_item_num po_requisitions_interface.suggested_vendor_item_num%TYPE;
923: l_suggested_vendor_id po_requisitions_interface.suggested_vendor_id%TYPE;
924: l_suggested_vendor_site_id po_requisitions_interface.suggested_vendor_site_id%TYPE;
925: -- Bug 3343892
926: l_base_unit_price po_requisitions_interface.base_unit_price%TYPE;
927: l_base_unit_price_out po_requisition_lines.base_unit_price%TYPE;
928: --
929:
930: CURSOR req_lines IS

Line 950: FROM po_requisitions_interface pri

946: pri.suggested_vendor_site_id,
947: -- Bug 3343892
948: pri.base_unit_price
949: --
950: FROM po_requisitions_interface pri
951: WHERE pri.autosource_flag in ('Y', 'P')
952: AND pri.item_id is not NULL
953: AND pri.source_type_code = 'VENDOR'
954: AND pri.autosource_doc_header_id is not NULL

Line 1025: UPDATE po_requisitions_interface pri

1021: );
1022:
1023: l_progress := '030';
1024:
1025: UPDATE po_requisitions_interface pri
1026: SET -- Bug 3417479, only set NOT NULL price
1027: -- pri.unit_price = l_base_price_out,
1028: -- pri.base_unit_price = l_base_unit_price_out, --
1029: -- pri.currency_unit_price = l_currency_price_out,