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.PON_CP_INTRFAC_TO_TRANSACTION dependencies on PON_NEG_COPY_DATATYPES_GRP

Line 1798: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

1794: l_contract_type pon_auction_headers_all.contract_type%TYPE;
1795: l_last_amendment_update pon_auction_headers_all.amendment_number%TYPE;
1796: l_max_internal_line_num pon_auction_headers_all.max_internal_line_num%TYPE;
1797:
1798: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1799: l_group_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
1800: l_item_description PON_NEG_COPY_DATATYPES_GRP.VARCHAR2500_TYPE;
1801: l_category_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1802: l_category_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;

Line 1799: l_group_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

1795: l_last_amendment_update pon_auction_headers_all.amendment_number%TYPE;
1796: l_max_internal_line_num pon_auction_headers_all.max_internal_line_num%TYPE;
1797:
1798: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1799: l_group_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
1800: l_item_description PON_NEG_COPY_DATATYPES_GRP.VARCHAR2500_TYPE;
1801: l_category_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1802: l_category_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
1803: l_ip_category_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 1800: l_item_description PON_NEG_COPY_DATATYPES_GRP.VARCHAR2500_TYPE;

1796: l_max_internal_line_num pon_auction_headers_all.max_internal_line_num%TYPE;
1797:
1798: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1799: l_group_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
1800: l_item_description PON_NEG_COPY_DATATYPES_GRP.VARCHAR2500_TYPE;
1801: l_category_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1802: l_category_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
1803: l_ip_category_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1804: l_quantity PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 1801: l_category_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

1797:
1798: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1799: l_group_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
1800: l_item_description PON_NEG_COPY_DATATYPES_GRP.VARCHAR2500_TYPE;
1801: l_category_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1802: l_category_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
1803: l_ip_category_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1804: l_quantity PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1805: l_uom_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;

Line 1802: l_category_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;

1798: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1799: l_group_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
1800: l_item_description PON_NEG_COPY_DATATYPES_GRP.VARCHAR2500_TYPE;
1801: l_category_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1802: l_category_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
1803: l_ip_category_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1804: l_quantity PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1805: l_uom_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
1806: l_unit_of_measure PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

Line 1803: l_ip_category_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

1799: l_group_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
1800: l_item_description PON_NEG_COPY_DATATYPES_GRP.VARCHAR2500_TYPE;
1801: l_category_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1802: l_category_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
1803: l_ip_category_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1804: l_quantity PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1805: l_uom_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
1806: l_unit_of_measure PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
1807: l_need_by_start_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;

Line 1804: l_quantity PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

1800: l_item_description PON_NEG_COPY_DATATYPES_GRP.VARCHAR2500_TYPE;
1801: l_category_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1802: l_category_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
1803: l_ip_category_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1804: l_quantity PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1805: l_uom_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
1806: l_unit_of_measure PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
1807: l_need_by_start_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
1808: l_need_by_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;

Line 1805: l_uom_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;

1801: l_category_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1802: l_category_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
1803: l_ip_category_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1804: l_quantity PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1805: l_uom_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
1806: l_unit_of_measure PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
1807: l_need_by_start_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
1808: l_need_by_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
1809: --CLM : CLM_NEED_BY_DATE

Line 1806: l_unit_of_measure PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

1802: l_category_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
1803: l_ip_category_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1804: l_quantity PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1805: l_uom_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
1806: l_unit_of_measure PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
1807: l_need_by_start_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
1808: l_need_by_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
1809: --CLM : CLM_NEED_BY_DATE
1810: l_clm_need_by_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;

Line 1807: l_need_by_start_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;

1803: l_ip_category_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1804: l_quantity PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1805: l_uom_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
1806: l_unit_of_measure PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
1807: l_need_by_start_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
1808: l_need_by_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
1809: --CLM : CLM_NEED_BY_DATE
1810: l_clm_need_by_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
1811:

Line 1808: l_need_by_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;

1804: l_quantity PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1805: l_uom_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
1806: l_unit_of_measure PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
1807: l_need_by_start_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
1808: l_need_by_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
1809: --CLM : CLM_NEED_BY_DATE
1810: l_clm_need_by_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
1811:
1812: l_target_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 1810: l_clm_need_by_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;

1806: l_unit_of_measure PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
1807: l_need_by_start_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
1808: l_need_by_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
1809: --CLM : CLM_NEED_BY_DATE
1810: l_clm_need_by_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
1811:
1812: l_target_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1813: l_bid_start_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1814: l_note_to_bidders PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;

Line 1812: l_target_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

1808: l_need_by_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
1809: --CLM : CLM_NEED_BY_DATE
1810: l_clm_need_by_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
1811:
1812: l_target_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1813: l_bid_start_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1814: l_note_to_bidders PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
1815: l_ship_to_location_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1816: l_current_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 1813: l_bid_start_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

1809: --CLM : CLM_NEED_BY_DATE
1810: l_clm_need_by_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
1811:
1812: l_target_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1813: l_bid_start_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1814: l_note_to_bidders PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
1815: l_ship_to_location_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1816: l_current_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1817: l_reserve_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 1814: l_note_to_bidders PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;

1810: l_clm_need_by_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
1811:
1812: l_target_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1813: l_bid_start_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1814: l_note_to_bidders PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
1815: l_ship_to_location_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1816: l_current_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1817: l_reserve_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1818: l_display_target_price_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

Line 1815: l_ship_to_location_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

1811:
1812: l_target_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1813: l_bid_start_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1814: l_note_to_bidders PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
1815: l_ship_to_location_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1816: l_current_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1817: l_reserve_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1818: l_display_target_price_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
1819: l_po_min_rel_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 1816: l_current_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

1812: l_target_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1813: l_bid_start_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1814: l_note_to_bidders PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
1815: l_ship_to_location_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1816: l_current_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1817: l_reserve_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1818: l_display_target_price_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
1819: l_po_min_rel_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1820: l_line_type_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 1817: l_reserve_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

1813: l_bid_start_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1814: l_note_to_bidders PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
1815: l_ship_to_location_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1816: l_current_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1817: l_reserve_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1818: l_display_target_price_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
1819: l_po_min_rel_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1820: l_line_type_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1821: l_order_type_lookup_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

Line 1818: l_display_target_price_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

1814: l_note_to_bidders PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
1815: l_ship_to_location_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1816: l_current_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1817: l_reserve_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1818: l_display_target_price_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
1819: l_po_min_rel_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1820: l_line_type_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1821: l_order_type_lookup_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
1822: l_item_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 1819: l_po_min_rel_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

1815: l_ship_to_location_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1816: l_current_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1817: l_reserve_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1818: l_display_target_price_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
1819: l_po_min_rel_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1820: l_line_type_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1821: l_order_type_lookup_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
1822: l_item_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1823: l_item_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR1000_TYPE;

Line 1820: l_line_type_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

1816: l_current_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1817: l_reserve_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1818: l_display_target_price_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
1819: l_po_min_rel_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1820: l_line_type_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1821: l_order_type_lookup_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
1822: l_item_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1823: l_item_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR1000_TYPE;
1824: l_item_revision PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;

Line 1821: l_order_type_lookup_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

1817: l_reserve_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1818: l_display_target_price_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
1819: l_po_min_rel_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1820: l_line_type_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1821: l_order_type_lookup_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
1822: l_item_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1823: l_item_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR1000_TYPE;
1824: l_item_revision PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
1825: l_job_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 1822: l_item_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

1818: l_display_target_price_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
1819: l_po_min_rel_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1820: l_line_type_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1821: l_order_type_lookup_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
1822: l_item_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1823: l_item_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR1000_TYPE;
1824: l_item_revision PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
1825: l_job_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1826: l_additional_job_details PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;

Line 1823: l_item_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR1000_TYPE;

1819: l_po_min_rel_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1820: l_line_type_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1821: l_order_type_lookup_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
1822: l_item_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1823: l_item_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR1000_TYPE;
1824: l_item_revision PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
1825: l_job_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1826: l_additional_job_details PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
1827: l_po_agreed_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 1824: l_item_revision PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;

1820: l_line_type_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1821: l_order_type_lookup_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
1822: l_item_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1823: l_item_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR1000_TYPE;
1824: l_item_revision PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
1825: l_job_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1826: l_additional_job_details PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
1827: l_po_agreed_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1828: l_unit_target_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 1825: l_job_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

1821: l_order_type_lookup_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
1822: l_item_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1823: l_item_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR1000_TYPE;
1824: l_item_revision PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
1825: l_job_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1826: l_additional_job_details PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
1827: l_po_agreed_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1828: l_unit_target_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1829: l_unit_display_target_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

Line 1826: l_additional_job_details PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;

1822: l_item_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1823: l_item_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR1000_TYPE;
1824: l_item_revision PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
1825: l_job_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1826: l_additional_job_details PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
1827: l_po_agreed_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1828: l_unit_target_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1829: l_unit_display_target_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
1830: l_differential_response_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;

Line 1827: l_po_agreed_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

1823: l_item_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR1000_TYPE;
1824: l_item_revision PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
1825: l_job_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1826: l_additional_job_details PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
1827: l_po_agreed_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1828: l_unit_target_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1829: l_unit_display_target_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
1830: l_differential_response_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
1831: l_purchase_basis PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

Line 1828: l_unit_target_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

1824: l_item_revision PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
1825: l_job_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1826: l_additional_job_details PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
1827: l_po_agreed_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1828: l_unit_target_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1829: l_unit_display_target_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
1830: l_differential_response_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
1831: l_purchase_basis PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
1832: l_price_disabled_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

Line 1829: l_unit_display_target_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

1825: l_job_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1826: l_additional_job_details PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
1827: l_po_agreed_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1828: l_unit_target_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1829: l_unit_display_target_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
1830: l_differential_response_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
1831: l_purchase_basis PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
1832: l_price_disabled_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
1833: l_quantity_disabled_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

Line 1830: l_differential_response_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;

1826: l_additional_job_details PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
1827: l_po_agreed_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1828: l_unit_target_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1829: l_unit_display_target_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
1830: l_differential_response_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
1831: l_purchase_basis PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
1832: l_price_disabled_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
1833: l_quantity_disabled_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
1834: --R12 - Complex work

Line 1831: l_purchase_basis PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

1827: l_po_agreed_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1828: l_unit_target_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1829: l_unit_display_target_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
1830: l_differential_response_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
1831: l_purchase_basis PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
1832: l_price_disabled_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
1833: l_quantity_disabled_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
1834: --R12 - Complex work
1835: l_advance_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 1832: l_price_disabled_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

1828: l_unit_target_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1829: l_unit_display_target_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
1830: l_differential_response_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
1831: l_purchase_basis PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
1832: l_price_disabled_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
1833: l_quantity_disabled_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
1834: --R12 - Complex work
1835: l_advance_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1836: l_recoupment_rate_percent PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 1833: l_quantity_disabled_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

1829: l_unit_display_target_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
1830: l_differential_response_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
1831: l_purchase_basis PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
1832: l_price_disabled_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
1833: l_quantity_disabled_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
1834: --R12 - Complex work
1835: l_advance_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1836: l_recoupment_rate_percent PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1837: l_progress_pymt_rate_percent PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 1835: l_advance_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

1831: l_purchase_basis PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
1832: l_price_disabled_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
1833: l_quantity_disabled_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
1834: --R12 - Complex work
1835: l_advance_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1836: l_recoupment_rate_percent PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1837: l_progress_pymt_rate_percent PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1838: l_retainage_rate_percent PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1839: l_max_retainage_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 1836: l_recoupment_rate_percent PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

1832: l_price_disabled_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
1833: l_quantity_disabled_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
1834: --R12 - Complex work
1835: l_advance_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1836: l_recoupment_rate_percent PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1837: l_progress_pymt_rate_percent PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1838: l_retainage_rate_percent PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1839: l_max_retainage_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1840: l_project_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 1837: l_progress_pymt_rate_percent PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

1833: l_quantity_disabled_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
1834: --R12 - Complex work
1835: l_advance_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1836: l_recoupment_rate_percent PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1837: l_progress_pymt_rate_percent PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1838: l_retainage_rate_percent PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1839: l_max_retainage_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1840: l_project_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1841: l_project_task_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 1838: l_retainage_rate_percent PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

1834: --R12 - Complex work
1835: l_advance_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1836: l_recoupment_rate_percent PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1837: l_progress_pymt_rate_percent PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1838: l_retainage_rate_percent PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1839: l_max_retainage_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1840: l_project_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1841: l_project_task_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1842: l_project_award_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 1839: l_max_retainage_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

1835: l_advance_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1836: l_recoupment_rate_percent PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1837: l_progress_pymt_rate_percent PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1838: l_retainage_rate_percent PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1839: l_max_retainage_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1840: l_project_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1841: l_project_task_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1842: l_project_award_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1843: l_project_expenditure_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

Line 1840: l_project_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

1836: l_recoupment_rate_percent PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1837: l_progress_pymt_rate_percent PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1838: l_retainage_rate_percent PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1839: l_max_retainage_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1840: l_project_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1841: l_project_task_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1842: l_project_award_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1843: l_project_expenditure_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
1844: l_project_exp_organization_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 1841: l_project_task_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

1837: l_progress_pymt_rate_percent PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1838: l_retainage_rate_percent PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1839: l_max_retainage_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1840: l_project_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1841: l_project_task_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1842: l_project_award_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1843: l_project_expenditure_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
1844: l_project_exp_organization_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1845: l_project_expenditure_item_dt PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;

Line 1842: l_project_award_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

1838: l_retainage_rate_percent PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1839: l_max_retainage_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1840: l_project_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1841: l_project_task_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1842: l_project_award_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1843: l_project_expenditure_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
1844: l_project_exp_organization_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1845: l_project_expenditure_item_dt PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
1846: l_work_approver_user_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 1843: l_project_expenditure_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

1839: l_max_retainage_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1840: l_project_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1841: l_project_task_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1842: l_project_award_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1843: l_project_expenditure_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
1844: l_project_exp_organization_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1845: l_project_expenditure_item_dt PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
1846: l_work_approver_user_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1847: l_price_break_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

Line 1844: l_project_exp_organization_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

1840: l_project_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1841: l_project_task_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1842: l_project_award_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1843: l_project_expenditure_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
1844: l_project_exp_organization_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1845: l_project_expenditure_item_dt PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
1846: l_work_approver_user_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1847: l_price_break_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
1848: l_price_break_neg_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

Line 1845: l_project_expenditure_item_dt PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;

1841: l_project_task_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1842: l_project_award_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1843: l_project_expenditure_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
1844: l_project_exp_organization_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1845: l_project_expenditure_item_dt PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
1846: l_work_approver_user_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1847: l_price_break_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
1848: l_price_break_neg_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
1849: -- CLM: Event Based Delivery Project

Line 1846: l_work_approver_user_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

1842: l_project_award_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1843: l_project_expenditure_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
1844: l_project_exp_organization_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1845: l_project_expenditure_item_dt PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
1846: l_work_approver_user_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1847: l_price_break_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
1848: l_price_break_neg_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
1849: -- CLM: Event Based Delivery Project
1850: l_clm_delivery_event_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

Line 1847: l_price_break_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

1843: l_project_expenditure_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
1844: l_project_exp_organization_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1845: l_project_expenditure_item_dt PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
1846: l_work_approver_user_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1847: l_price_break_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
1848: l_price_break_neg_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
1849: -- CLM: Event Based Delivery Project
1850: l_clm_delivery_event_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
1851: l_clm_delivery_period PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 1848: l_price_break_neg_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

1844: l_project_exp_organization_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1845: l_project_expenditure_item_dt PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
1846: l_work_approver_user_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1847: l_price_break_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
1848: l_price_break_neg_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
1849: -- CLM: Event Based Delivery Project
1850: l_clm_delivery_event_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
1851: l_clm_delivery_period PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1852: l_clm_delivery_period_uom PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

Line 1850: l_clm_delivery_event_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

1846: l_work_approver_user_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1847: l_price_break_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
1848: l_price_break_neg_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
1849: -- CLM: Event Based Delivery Project
1850: l_clm_delivery_event_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
1851: l_clm_delivery_period PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1852: l_clm_delivery_period_uom PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
1853: l_clm_pop_duration PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1854: l_clm_pop_duration_uom PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

Line 1851: l_clm_delivery_period PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

1847: l_price_break_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
1848: l_price_break_neg_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
1849: -- CLM: Event Based Delivery Project
1850: l_clm_delivery_event_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
1851: l_clm_delivery_period PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1852: l_clm_delivery_period_uom PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
1853: l_clm_pop_duration PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1854: l_clm_pop_duration_uom PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
1855:

Line 1852: l_clm_delivery_period_uom PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

1848: l_price_break_neg_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
1849: -- CLM: Event Based Delivery Project
1850: l_clm_delivery_event_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
1851: l_clm_delivery_period PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1852: l_clm_delivery_period_uom PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
1853: l_clm_pop_duration PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1854: l_clm_pop_duration_uom PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
1855:
1856: BEGIN

Line 1853: l_clm_pop_duration PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

1849: -- CLM: Event Based Delivery Project
1850: l_clm_delivery_event_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
1851: l_clm_delivery_period PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1852: l_clm_delivery_period_uom PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
1853: l_clm_pop_duration PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1854: l_clm_pop_duration_uom PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
1855:
1856: BEGIN
1857: --{

Line 1854: l_clm_pop_duration_uom PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

1850: l_clm_delivery_event_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
1851: l_clm_delivery_period PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1852: l_clm_delivery_period_uom PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
1853: l_clm_pop_duration PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1854: l_clm_pop_duration_uom PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
1855:
1856: BEGIN
1857: --{
1858: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

Line 2259: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

2255: PROCEDURE UPDATE_PRICE_FACTORS is
2256:
2257: l_module CONSTANT VARCHAR2(20) := 'UPDATE_PRICE_FACTORS';
2258:
2259: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2260: l_price_element_type_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2261: l_pricing_basis PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2262: l_value PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2263: l_display_target_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

Line 2260: l_price_element_type_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

2256:
2257: l_module CONSTANT VARCHAR2(20) := 'UPDATE_PRICE_FACTORS';
2258:
2259: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2260: l_price_element_type_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2261: l_pricing_basis PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2262: l_value PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2263: l_display_target_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2264: l_display_to_suppliers_flag VARCHAR2(1) := 'Y';

Line 2261: l_pricing_basis PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

2257: l_module CONSTANT VARCHAR2(20) := 'UPDATE_PRICE_FACTORS';
2258:
2259: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2260: l_price_element_type_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2261: l_pricing_basis PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2262: l_value PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2263: l_display_target_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2264: l_display_to_suppliers_flag VARCHAR2(1) := 'Y';
2265: BEGIN

Line 2262: l_value PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

2258:
2259: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2260: l_price_element_type_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2261: l_pricing_basis PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2262: l_value PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2263: l_display_target_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2264: l_display_to_suppliers_flag VARCHAR2(1) := 'Y';
2265: BEGIN
2266: --{

Line 2263: l_display_target_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

2259: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2260: l_price_element_type_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2261: l_pricing_basis PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2262: l_value PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2263: l_display_target_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2264: l_display_to_suppliers_flag VARCHAR2(1) := 'Y';
2265: BEGIN
2266: --{
2267: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

Line 2420: l_attribute_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

2416:
2417: l_module CONSTANT VARCHAR2(22) := 'UPDATE_LINE_ATTRIBUTES';
2418: l_bid_ranking pon_auction_headers_all.bid_ranking%type;
2419: l_max_neg_line_attr_seq_num number;
2420: l_attribute_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2421: l_attribute_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
2422: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2423: l_attr_group PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
2424: l_mandatory_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

Line 2421: l_attribute_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;

2417: l_module CONSTANT VARCHAR2(22) := 'UPDATE_LINE_ATTRIBUTES';
2418: l_bid_ranking pon_auction_headers_all.bid_ranking%type;
2419: l_max_neg_line_attr_seq_num number;
2420: l_attribute_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2421: l_attribute_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
2422: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2423: l_attr_group PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
2424: l_mandatory_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2425: l_display_only_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

Line 2422: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

2418: l_bid_ranking pon_auction_headers_all.bid_ranking%type;
2419: l_max_neg_line_attr_seq_num number;
2420: l_attribute_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2421: l_attribute_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
2422: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2423: l_attr_group PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
2424: l_mandatory_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2425: l_display_only_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2426: l_internal_attr_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

Line 2423: l_attr_group PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;

2419: l_max_neg_line_attr_seq_num number;
2420: l_attribute_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2421: l_attribute_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
2422: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2423: l_attr_group PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
2424: l_mandatory_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2425: l_display_only_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2426: l_internal_attr_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2427: l_datatype PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;

Line 2424: l_mandatory_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

2420: l_attribute_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2421: l_attribute_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
2422: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2423: l_attr_group PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
2424: l_mandatory_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2425: l_display_only_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2426: l_internal_attr_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2427: l_datatype PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
2428: l_display_target_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

Line 2425: l_display_only_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

2421: l_attribute_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
2422: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2423: l_attr_group PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
2424: l_mandatory_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2425: l_display_only_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2426: l_internal_attr_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2427: l_datatype PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
2428: l_display_target_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2429: l_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;

Line 2426: l_internal_attr_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

2422: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2423: l_attr_group PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
2424: l_mandatory_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2425: l_display_only_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2426: l_internal_attr_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2427: l_datatype PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
2428: l_display_target_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2429: l_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
2430: l_scoring_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

Line 2427: l_datatype PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;

2423: l_attr_group PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
2424: l_mandatory_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2425: l_display_only_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2426: l_internal_attr_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2427: l_datatype PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
2428: l_display_target_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2429: l_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
2430: l_scoring_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2431: l_attr_level PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

Line 2428: l_display_target_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

2424: l_mandatory_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2425: l_display_only_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2426: l_internal_attr_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2427: l_datatype PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
2428: l_display_target_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2429: l_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
2430: l_scoring_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2431: l_attr_level PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2432: l_attr_group_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 2429: l_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;

2425: l_display_only_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2426: l_internal_attr_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2427: l_datatype PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
2428: l_display_target_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2429: l_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
2430: l_scoring_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2431: l_attr_level PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2432: l_attr_group_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2433: l_attr_disp_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 2430: l_scoring_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

2426: l_internal_attr_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2427: l_datatype PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
2428: l_display_target_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2429: l_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
2430: l_scoring_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2431: l_attr_level PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2432: l_attr_group_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2433: l_attr_disp_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2434:

Line 2431: l_attr_level PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

2427: l_datatype PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
2428: l_display_target_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2429: l_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
2430: l_scoring_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2431: l_attr_level PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2432: l_attr_group_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2433: l_attr_disp_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2434:
2435:

Line 2432: l_attr_group_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

2428: l_display_target_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2429: l_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
2430: l_scoring_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2431: l_attr_level PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2432: l_attr_group_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2433: l_attr_disp_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2434:
2435:
2436: BEGIN

Line 2433: l_attr_disp_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

2429: l_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
2430: l_scoring_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2431: l_attr_level PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2432: l_attr_group_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2433: l_attr_disp_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2434:
2435:
2436: BEGIN
2437: --{

Line 2745: l_PRICE_ELEMENT_TYPE_ID PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

2741: PROCEDURE SYNCH_PF_VALUES_FOR_UPLOAD is
2742:
2743: l_module CONSTANT VARCHAR2(27) := 'SYNCH_PF_VALUES_FOR_UPLOAD';
2744:
2745: l_PRICE_ELEMENT_TYPE_ID PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2746: l_PRICING_BASIS PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2747:
2748: begin
2749: --{

Line 2746: l_PRICING_BASIS PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

2742:
2743: l_module CONSTANT VARCHAR2(27) := 'SYNCH_PF_VALUES_FOR_UPLOAD';
2744:
2745: l_PRICE_ELEMENT_TYPE_ID PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2746: l_PRICING_BASIS PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2747:
2748: begin
2749: --{
2750:

Line 3589: l_INTERFACE_TYPE PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

3585: x_error_code OUT NOCOPY VARCHAR2,
3586: x_error_message OUT NOCOPY VARCHAR2
3587: ) is
3588:
3589: l_INTERFACE_TYPE PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3590: l_COLUMN_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3591: l_TABLE_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3592: l_INTERFACE_LINE_ID PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3593: l_ERROR_MESSAGE_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;

Line 3590: l_COLUMN_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;

3586: x_error_message OUT NOCOPY VARCHAR2
3587: ) is
3588:
3589: l_INTERFACE_TYPE PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3590: l_COLUMN_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3591: l_TABLE_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3592: l_INTERFACE_LINE_ID PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3593: l_ERROR_MESSAGE_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3594: l_ERROR_VALUE PON_NEG_COPY_DATATYPES_GRP.VARCHAR100_TYPE;

Line 3591: l_TABLE_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

3587: ) is
3588:
3589: l_INTERFACE_TYPE PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3590: l_COLUMN_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3591: l_TABLE_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3592: l_INTERFACE_LINE_ID PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3593: l_ERROR_MESSAGE_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3594: l_ERROR_VALUE PON_NEG_COPY_DATATYPES_GRP.VARCHAR100_TYPE;
3595: l_CREATED_BY PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 3592: l_INTERFACE_LINE_ID PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

3588:
3589: l_INTERFACE_TYPE PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3590: l_COLUMN_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3591: l_TABLE_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3592: l_INTERFACE_LINE_ID PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3593: l_ERROR_MESSAGE_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3594: l_ERROR_VALUE PON_NEG_COPY_DATATYPES_GRP.VARCHAR100_TYPE;
3595: l_CREATED_BY PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3596: l_CREATION_DATE PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;

Line 3593: l_ERROR_MESSAGE_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;

3589: l_INTERFACE_TYPE PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3590: l_COLUMN_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3591: l_TABLE_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3592: l_INTERFACE_LINE_ID PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3593: l_ERROR_MESSAGE_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3594: l_ERROR_VALUE PON_NEG_COPY_DATATYPES_GRP.VARCHAR100_TYPE;
3595: l_CREATED_BY PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3596: l_CREATION_DATE PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
3597: l_LAST_UPDATED_BY PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 3594: l_ERROR_VALUE PON_NEG_COPY_DATATYPES_GRP.VARCHAR100_TYPE;

3590: l_COLUMN_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3591: l_TABLE_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3592: l_INTERFACE_LINE_ID PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3593: l_ERROR_MESSAGE_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3594: l_ERROR_VALUE PON_NEG_COPY_DATATYPES_GRP.VARCHAR100_TYPE;
3595: l_CREATED_BY PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3596: l_CREATION_DATE PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
3597: l_LAST_UPDATED_BY PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3598: l_LAST_UPDATE_DATE PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;

Line 3595: l_CREATED_BY PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

3591: l_TABLE_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3592: l_INTERFACE_LINE_ID PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3593: l_ERROR_MESSAGE_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3594: l_ERROR_VALUE PON_NEG_COPY_DATATYPES_GRP.VARCHAR100_TYPE;
3595: l_CREATED_BY PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3596: l_CREATION_DATE PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
3597: l_LAST_UPDATED_BY PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3598: l_LAST_UPDATE_DATE PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
3599: l_LAST_UPDATE_LOGIN PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 3596: l_CREATION_DATE PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;

3592: l_INTERFACE_LINE_ID PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3593: l_ERROR_MESSAGE_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3594: l_ERROR_VALUE PON_NEG_COPY_DATATYPES_GRP.VARCHAR100_TYPE;
3595: l_CREATED_BY PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3596: l_CREATION_DATE PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
3597: l_LAST_UPDATED_BY PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3598: l_LAST_UPDATE_DATE PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
3599: l_LAST_UPDATE_LOGIN PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3600: l_ENTITY_TYPE PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

Line 3597: l_LAST_UPDATED_BY PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

3593: l_ERROR_MESSAGE_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3594: l_ERROR_VALUE PON_NEG_COPY_DATATYPES_GRP.VARCHAR100_TYPE;
3595: l_CREATED_BY PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3596: l_CREATION_DATE PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
3597: l_LAST_UPDATED_BY PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3598: l_LAST_UPDATE_DATE PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
3599: l_LAST_UPDATE_LOGIN PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3600: l_ENTITY_TYPE PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3601: l_ENTITY_ATTR_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

Line 3598: l_LAST_UPDATE_DATE PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;

3594: l_ERROR_VALUE PON_NEG_COPY_DATATYPES_GRP.VARCHAR100_TYPE;
3595: l_CREATED_BY PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3596: l_CREATION_DATE PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
3597: l_LAST_UPDATED_BY PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3598: l_LAST_UPDATE_DATE PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
3599: l_LAST_UPDATE_LOGIN PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3600: l_ENTITY_TYPE PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3601: l_ENTITY_ATTR_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3602: l_ERROR_VALUE_DATE PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;

Line 3599: l_LAST_UPDATE_LOGIN PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

3595: l_CREATED_BY PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3596: l_CREATION_DATE PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
3597: l_LAST_UPDATED_BY PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3598: l_LAST_UPDATE_DATE PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
3599: l_LAST_UPDATE_LOGIN PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3600: l_ENTITY_TYPE PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3601: l_ENTITY_ATTR_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3602: l_ERROR_VALUE_DATE PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
3603: l_ERROR_VALUE_NUMBER PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 3600: l_ENTITY_TYPE PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

3596: l_CREATION_DATE PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
3597: l_LAST_UPDATED_BY PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3598: l_LAST_UPDATE_DATE PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
3599: l_LAST_UPDATE_LOGIN PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3600: l_ENTITY_TYPE PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3601: l_ENTITY_ATTR_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3602: l_ERROR_VALUE_DATE PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
3603: l_ERROR_VALUE_NUMBER PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3604: l_ERROR_VALUE_DATATYPE PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;

Line 3601: l_ENTITY_ATTR_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

3597: l_LAST_UPDATED_BY PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3598: l_LAST_UPDATE_DATE PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
3599: l_LAST_UPDATE_LOGIN PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3600: l_ENTITY_TYPE PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3601: l_ENTITY_ATTR_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3602: l_ERROR_VALUE_DATE PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
3603: l_ERROR_VALUE_NUMBER PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3604: l_ERROR_VALUE_DATATYPE PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
3605: l_BID_NUMBER PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 3602: l_ERROR_VALUE_DATE PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;

3598: l_LAST_UPDATE_DATE PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
3599: l_LAST_UPDATE_LOGIN PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3600: l_ENTITY_TYPE PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3601: l_ENTITY_ATTR_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3602: l_ERROR_VALUE_DATE PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
3603: l_ERROR_VALUE_NUMBER PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3604: l_ERROR_VALUE_DATATYPE PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
3605: l_BID_NUMBER PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3606: l_LINE_NUMBER PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 3603: l_ERROR_VALUE_NUMBER PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

3599: l_LAST_UPDATE_LOGIN PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3600: l_ENTITY_TYPE PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3601: l_ENTITY_ATTR_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3602: l_ERROR_VALUE_DATE PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
3603: l_ERROR_VALUE_NUMBER PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3604: l_ERROR_VALUE_DATATYPE PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
3605: l_BID_NUMBER PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3606: l_LINE_NUMBER PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3607: l_ATTRIBUTE_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;

Line 3604: l_ERROR_VALUE_DATATYPE PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;

3600: l_ENTITY_TYPE PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3601: l_ENTITY_ATTR_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3602: l_ERROR_VALUE_DATE PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
3603: l_ERROR_VALUE_NUMBER PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3604: l_ERROR_VALUE_DATATYPE PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
3605: l_BID_NUMBER PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3606: l_LINE_NUMBER PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3607: l_ATTRIBUTE_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
3608: l_PRICE_ELEMENT_TYPE_ID PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 3605: l_BID_NUMBER PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

3601: l_ENTITY_ATTR_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3602: l_ERROR_VALUE_DATE PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
3603: l_ERROR_VALUE_NUMBER PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3604: l_ERROR_VALUE_DATATYPE PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
3605: l_BID_NUMBER PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3606: l_LINE_NUMBER PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3607: l_ATTRIBUTE_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
3608: l_PRICE_ELEMENT_TYPE_ID PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3609: l_SHIPMENT_NUMBER PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 3606: l_LINE_NUMBER PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

3602: l_ERROR_VALUE_DATE PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
3603: l_ERROR_VALUE_NUMBER PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3604: l_ERROR_VALUE_DATATYPE PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
3605: l_BID_NUMBER PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3606: l_LINE_NUMBER PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3607: l_ATTRIBUTE_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
3608: l_PRICE_ELEMENT_TYPE_ID PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3609: l_SHIPMENT_NUMBER PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3610: l_PRICE_DIFFERENTIAL_NUMBER PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 3607: l_ATTRIBUTE_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;

3603: l_ERROR_VALUE_NUMBER PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3604: l_ERROR_VALUE_DATATYPE PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
3605: l_BID_NUMBER PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3606: l_LINE_NUMBER PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3607: l_ATTRIBUTE_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
3608: l_PRICE_ELEMENT_TYPE_ID PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3609: l_SHIPMENT_NUMBER PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3610: l_PRICE_DIFFERENTIAL_NUMBER PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3611: l_TOKEN1_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

Line 3608: l_PRICE_ELEMENT_TYPE_ID PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

3604: l_ERROR_VALUE_DATATYPE PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
3605: l_BID_NUMBER PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3606: l_LINE_NUMBER PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3607: l_ATTRIBUTE_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
3608: l_PRICE_ELEMENT_TYPE_ID PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3609: l_SHIPMENT_NUMBER PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3610: l_PRICE_DIFFERENTIAL_NUMBER PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3611: l_TOKEN1_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3612: l_TOKEN1_VALUE PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;

Line 3609: l_SHIPMENT_NUMBER PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

3605: l_BID_NUMBER PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3606: l_LINE_NUMBER PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3607: l_ATTRIBUTE_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
3608: l_PRICE_ELEMENT_TYPE_ID PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3609: l_SHIPMENT_NUMBER PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3610: l_PRICE_DIFFERENTIAL_NUMBER PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3611: l_TOKEN1_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3612: l_TOKEN1_VALUE PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3613: l_TOKEN2_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

Line 3610: l_PRICE_DIFFERENTIAL_NUMBER PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

3606: l_LINE_NUMBER PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3607: l_ATTRIBUTE_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
3608: l_PRICE_ELEMENT_TYPE_ID PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3609: l_SHIPMENT_NUMBER PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3610: l_PRICE_DIFFERENTIAL_NUMBER PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3611: l_TOKEN1_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3612: l_TOKEN1_VALUE PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3613: l_TOKEN2_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3614: l_TOKEN2_VALUE PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;

Line 3611: l_TOKEN1_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

3607: l_ATTRIBUTE_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
3608: l_PRICE_ELEMENT_TYPE_ID PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3609: l_SHIPMENT_NUMBER PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3610: l_PRICE_DIFFERENTIAL_NUMBER PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3611: l_TOKEN1_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3612: l_TOKEN1_VALUE PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3613: l_TOKEN2_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3614: l_TOKEN2_VALUE PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3615: l_TOKEN3_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

Line 3612: l_TOKEN1_VALUE PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;

3608: l_PRICE_ELEMENT_TYPE_ID PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3609: l_SHIPMENT_NUMBER PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3610: l_PRICE_DIFFERENTIAL_NUMBER PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3611: l_TOKEN1_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3612: l_TOKEN1_VALUE PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3613: l_TOKEN2_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3614: l_TOKEN2_VALUE PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3615: l_TOKEN3_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3616: l_TOKEN3_VALUE PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;

Line 3613: l_TOKEN2_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

3609: l_SHIPMENT_NUMBER PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3610: l_PRICE_DIFFERENTIAL_NUMBER PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3611: l_TOKEN1_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3612: l_TOKEN1_VALUE PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3613: l_TOKEN2_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3614: l_TOKEN2_VALUE PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3615: l_TOKEN3_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3616: l_TOKEN3_VALUE PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3617: l_TOKEN4_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

Line 3614: l_TOKEN2_VALUE PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;

3610: l_PRICE_DIFFERENTIAL_NUMBER PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3611: l_TOKEN1_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3612: l_TOKEN1_VALUE PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3613: l_TOKEN2_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3614: l_TOKEN2_VALUE PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3615: l_TOKEN3_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3616: l_TOKEN3_VALUE PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3617: l_TOKEN4_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3618: l_TOKEN4_VALUE PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;

Line 3615: l_TOKEN3_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

3611: l_TOKEN1_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3612: l_TOKEN1_VALUE PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3613: l_TOKEN2_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3614: l_TOKEN2_VALUE PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3615: l_TOKEN3_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3616: l_TOKEN3_VALUE PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3617: l_TOKEN4_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3618: l_TOKEN4_VALUE PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3619: l_TOKEN5_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

Line 3616: l_TOKEN3_VALUE PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;

3612: l_TOKEN1_VALUE PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3613: l_TOKEN2_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3614: l_TOKEN2_VALUE PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3615: l_TOKEN3_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3616: l_TOKEN3_VALUE PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3617: l_TOKEN4_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3618: l_TOKEN4_VALUE PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3619: l_TOKEN5_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3620: l_TOKEN5_VALUE PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;

Line 3617: l_TOKEN4_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

3613: l_TOKEN2_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3614: l_TOKEN2_VALUE PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3615: l_TOKEN3_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3616: l_TOKEN3_VALUE PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3617: l_TOKEN4_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3618: l_TOKEN4_VALUE PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3619: l_TOKEN5_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3620: l_TOKEN5_VALUE PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3621:

Line 3618: l_TOKEN4_VALUE PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;

3614: l_TOKEN2_VALUE PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3615: l_TOKEN3_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3616: l_TOKEN3_VALUE PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3617: l_TOKEN4_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3618: l_TOKEN4_VALUE PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3619: l_TOKEN5_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3620: l_TOKEN5_VALUE PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3621:
3622: l_progress varchar2(200);

Line 3619: l_TOKEN5_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

3615: l_TOKEN3_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3616: l_TOKEN3_VALUE PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3617: l_TOKEN4_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3618: l_TOKEN4_VALUE PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3619: l_TOKEN5_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3620: l_TOKEN5_VALUE PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3621:
3622: l_progress varchar2(200);
3623: l_module CONSTANT VARCHAR2(30) := 'SYNCH_PAYMENTS_FROM_INTERFACE';

Line 3620: l_TOKEN5_VALUE PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;

3616: l_TOKEN3_VALUE PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3617: l_TOKEN4_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3618: l_TOKEN4_VALUE PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3619: l_TOKEN5_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3620: l_TOKEN5_VALUE PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3621:
3622: l_progress varchar2(200);
3623: l_module CONSTANT VARCHAR2(30) := 'SYNCH_PAYMENTS_FROM_INTERFACE';
3624: