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 895: p_request_id IN po_requisitions_interface.request_id%TYPE

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

Line 913: l_uom po_requisitions_interface.unit_of_measure%TYPE;

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

Line 918: l_org_id po_requisitions_interface.org_id%TYPE;

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

Line 921: l_creation_date po_requisitions_interface.creation_date%TYPE;

917: --
918: l_org_id po_requisitions_interface.org_id%TYPE;
919: l_requisition_header_id po_requisition_lines.requisition_header_id%TYPE;
920: l_requisition_line_id po_requisition_lines.requisition_line_id%TYPE;
921: l_creation_date po_requisitions_interface.creation_date%TYPE;
922: l_item_id po_requisitions_interface.item_id%TYPE;
923: l_item_revision po_requisitions_interface.item_revision%TYPE;
924: l_category_id po_requisitions_interface.category_id%TYPE;
925: l_line_type_id po_requisitions_interface.line_type_id%TYPE;

Line 922: l_item_id po_requisitions_interface.item_id%TYPE;

918: l_org_id po_requisitions_interface.org_id%TYPE;
919: l_requisition_header_id po_requisition_lines.requisition_header_id%TYPE;
920: l_requisition_line_id po_requisition_lines.requisition_line_id%TYPE;
921: l_creation_date po_requisitions_interface.creation_date%TYPE;
922: l_item_id po_requisitions_interface.item_id%TYPE;
923: l_item_revision po_requisitions_interface.item_revision%TYPE;
924: l_category_id po_requisitions_interface.category_id%TYPE;
925: l_line_type_id po_requisitions_interface.line_type_id%TYPE;
926: l_suggested_vendor_item_num po_requisitions_interface.suggested_vendor_item_num%TYPE;

Line 923: l_item_revision po_requisitions_interface.item_revision%TYPE;

919: l_requisition_header_id po_requisition_lines.requisition_header_id%TYPE;
920: l_requisition_line_id po_requisition_lines.requisition_line_id%TYPE;
921: l_creation_date po_requisitions_interface.creation_date%TYPE;
922: l_item_id po_requisitions_interface.item_id%TYPE;
923: l_item_revision po_requisitions_interface.item_revision%TYPE;
924: l_category_id po_requisitions_interface.category_id%TYPE;
925: l_line_type_id po_requisitions_interface.line_type_id%TYPE;
926: l_suggested_vendor_item_num po_requisitions_interface.suggested_vendor_item_num%TYPE;
927: l_suggested_vendor_id po_requisitions_interface.suggested_vendor_id%TYPE;

Line 924: l_category_id po_requisitions_interface.category_id%TYPE;

920: l_requisition_line_id po_requisition_lines.requisition_line_id%TYPE;
921: l_creation_date po_requisitions_interface.creation_date%TYPE;
922: l_item_id po_requisitions_interface.item_id%TYPE;
923: l_item_revision po_requisitions_interface.item_revision%TYPE;
924: l_category_id po_requisitions_interface.category_id%TYPE;
925: l_line_type_id po_requisitions_interface.line_type_id%TYPE;
926: l_suggested_vendor_item_num po_requisitions_interface.suggested_vendor_item_num%TYPE;
927: l_suggested_vendor_id po_requisitions_interface.suggested_vendor_id%TYPE;
928: l_suggested_vendor_site_id po_requisitions_interface.suggested_vendor_site_id%TYPE;

Line 925: l_line_type_id po_requisitions_interface.line_type_id%TYPE;

921: l_creation_date po_requisitions_interface.creation_date%TYPE;
922: l_item_id po_requisitions_interface.item_id%TYPE;
923: l_item_revision po_requisitions_interface.item_revision%TYPE;
924: l_category_id po_requisitions_interface.category_id%TYPE;
925: l_line_type_id po_requisitions_interface.line_type_id%TYPE;
926: l_suggested_vendor_item_num po_requisitions_interface.suggested_vendor_item_num%TYPE;
927: l_suggested_vendor_id po_requisitions_interface.suggested_vendor_id%TYPE;
928: l_suggested_vendor_site_id po_requisitions_interface.suggested_vendor_site_id%TYPE;
929: -- Bug 3343892

Line 926: l_suggested_vendor_item_num po_requisitions_interface.suggested_vendor_item_num%TYPE;

922: l_item_id po_requisitions_interface.item_id%TYPE;
923: l_item_revision po_requisitions_interface.item_revision%TYPE;
924: l_category_id po_requisitions_interface.category_id%TYPE;
925: l_line_type_id po_requisitions_interface.line_type_id%TYPE;
926: l_suggested_vendor_item_num po_requisitions_interface.suggested_vendor_item_num%TYPE;
927: l_suggested_vendor_id po_requisitions_interface.suggested_vendor_id%TYPE;
928: l_suggested_vendor_site_id po_requisitions_interface.suggested_vendor_site_id%TYPE;
929: -- Bug 3343892
930: l_base_unit_price po_requisitions_interface.base_unit_price%TYPE;

Line 927: l_suggested_vendor_id po_requisitions_interface.suggested_vendor_id%TYPE;

923: l_item_revision po_requisitions_interface.item_revision%TYPE;
924: l_category_id po_requisitions_interface.category_id%TYPE;
925: l_line_type_id po_requisitions_interface.line_type_id%TYPE;
926: l_suggested_vendor_item_num po_requisitions_interface.suggested_vendor_item_num%TYPE;
927: l_suggested_vendor_id po_requisitions_interface.suggested_vendor_id%TYPE;
928: l_suggested_vendor_site_id po_requisitions_interface.suggested_vendor_site_id%TYPE;
929: -- Bug 3343892
930: l_base_unit_price po_requisitions_interface.base_unit_price%TYPE;
931: l_base_unit_price_out po_requisition_lines.base_unit_price%TYPE;

Line 928: l_suggested_vendor_site_id po_requisitions_interface.suggested_vendor_site_id%TYPE;

924: l_category_id po_requisitions_interface.category_id%TYPE;
925: l_line_type_id po_requisitions_interface.line_type_id%TYPE;
926: l_suggested_vendor_item_num po_requisitions_interface.suggested_vendor_item_num%TYPE;
927: l_suggested_vendor_id po_requisitions_interface.suggested_vendor_id%TYPE;
928: l_suggested_vendor_site_id po_requisitions_interface.suggested_vendor_site_id%TYPE;
929: -- Bug 3343892
930: l_base_unit_price po_requisitions_interface.base_unit_price%TYPE;
931: l_base_unit_price_out po_requisition_lines.base_unit_price%TYPE;
932: --

Line 930: l_base_unit_price po_requisitions_interface.base_unit_price%TYPE;

926: l_suggested_vendor_item_num po_requisitions_interface.suggested_vendor_item_num%TYPE;
927: l_suggested_vendor_id po_requisitions_interface.suggested_vendor_id%TYPE;
928: l_suggested_vendor_site_id po_requisitions_interface.suggested_vendor_site_id%TYPE;
929: -- Bug 3343892
930: l_base_unit_price po_requisitions_interface.base_unit_price%TYPE;
931: l_base_unit_price_out po_requisition_lines.base_unit_price%TYPE;
932: --
933:
934: CURSOR req_lines IS

Line 954: FROM po_requisitions_interface pri

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

Line 1029: UPDATE po_requisitions_interface pri

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