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 1576: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

1572: l_contract_type pon_auction_headers_all.contract_type%TYPE;
1573: l_last_amendment_update pon_auction_headers_all.amendment_number%TYPE;
1574: l_max_internal_line_num pon_auction_headers_all.max_internal_line_num%TYPE;
1575:
1576: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1577: l_group_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
1578: l_item_description PON_NEG_COPY_DATATYPES_GRP.VARCHAR2500_TYPE;
1579: l_category_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1580: l_category_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;

Line 1577: l_group_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

1573: l_last_amendment_update pon_auction_headers_all.amendment_number%TYPE;
1574: l_max_internal_line_num pon_auction_headers_all.max_internal_line_num%TYPE;
1575:
1576: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1577: l_group_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
1578: l_item_description PON_NEG_COPY_DATATYPES_GRP.VARCHAR2500_TYPE;
1579: l_category_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1580: l_category_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
1581: l_ip_category_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 1578: l_item_description PON_NEG_COPY_DATATYPES_GRP.VARCHAR2500_TYPE;

1574: l_max_internal_line_num pon_auction_headers_all.max_internal_line_num%TYPE;
1575:
1576: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1577: l_group_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
1578: l_item_description PON_NEG_COPY_DATATYPES_GRP.VARCHAR2500_TYPE;
1579: l_category_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1580: l_category_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
1581: l_ip_category_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1582: l_quantity PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 1579: l_category_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

1575:
1576: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1577: l_group_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
1578: l_item_description PON_NEG_COPY_DATATYPES_GRP.VARCHAR2500_TYPE;
1579: l_category_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1580: l_category_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
1581: l_ip_category_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1582: l_quantity PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1583: l_uom_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;

Line 1580: l_category_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;

1576: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1577: l_group_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
1578: l_item_description PON_NEG_COPY_DATATYPES_GRP.VARCHAR2500_TYPE;
1579: l_category_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1580: l_category_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
1581: l_ip_category_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1582: l_quantity PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1583: l_uom_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
1584: l_unit_of_measure PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

Line 1581: l_ip_category_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

1577: l_group_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
1578: l_item_description PON_NEG_COPY_DATATYPES_GRP.VARCHAR2500_TYPE;
1579: l_category_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1580: l_category_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
1581: l_ip_category_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1582: l_quantity PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1583: l_uom_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
1584: l_unit_of_measure PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
1585: l_need_by_start_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;

Line 1582: l_quantity PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

1578: l_item_description PON_NEG_COPY_DATATYPES_GRP.VARCHAR2500_TYPE;
1579: l_category_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1580: l_category_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
1581: l_ip_category_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1582: l_quantity PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1583: l_uom_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
1584: l_unit_of_measure PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
1585: l_need_by_start_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
1586: l_need_by_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;

Line 1583: l_uom_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;

1579: l_category_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1580: l_category_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
1581: l_ip_category_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1582: l_quantity PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1583: l_uom_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
1584: l_unit_of_measure PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
1585: l_need_by_start_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
1586: l_need_by_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
1587: l_target_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 1584: l_unit_of_measure PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

1580: l_category_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
1581: l_ip_category_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1582: l_quantity PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1583: l_uom_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
1584: l_unit_of_measure PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
1585: l_need_by_start_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
1586: l_need_by_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
1587: l_target_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1588: l_bid_start_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 1585: l_need_by_start_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;

1581: l_ip_category_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1582: l_quantity PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1583: l_uom_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
1584: l_unit_of_measure PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
1585: l_need_by_start_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
1586: l_need_by_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
1587: l_target_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1588: l_bid_start_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1589: l_note_to_bidders PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;

Line 1586: l_need_by_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;

1582: l_quantity PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1583: l_uom_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
1584: l_unit_of_measure PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
1585: l_need_by_start_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
1586: l_need_by_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
1587: l_target_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1588: l_bid_start_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1589: l_note_to_bidders PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
1590: l_ship_to_location_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 1587: l_target_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

1583: l_uom_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
1584: l_unit_of_measure PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
1585: l_need_by_start_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
1586: l_need_by_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
1587: l_target_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1588: l_bid_start_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1589: l_note_to_bidders PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
1590: l_ship_to_location_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1591: l_current_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 1588: l_bid_start_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

1584: l_unit_of_measure PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
1585: l_need_by_start_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
1586: l_need_by_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
1587: l_target_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1588: l_bid_start_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1589: l_note_to_bidders PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
1590: l_ship_to_location_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1591: l_current_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1592: l_reserve_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 1589: l_note_to_bidders PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;

1585: l_need_by_start_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
1586: l_need_by_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
1587: l_target_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1588: l_bid_start_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1589: l_note_to_bidders PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
1590: l_ship_to_location_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1591: l_current_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1592: l_reserve_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1593: l_display_target_price_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

Line 1590: l_ship_to_location_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

1586: l_need_by_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
1587: l_target_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1588: l_bid_start_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1589: l_note_to_bidders PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
1590: l_ship_to_location_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1591: l_current_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1592: l_reserve_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1593: l_display_target_price_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
1594: l_po_min_rel_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 1591: l_current_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

1587: l_target_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1588: l_bid_start_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1589: l_note_to_bidders PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
1590: l_ship_to_location_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1591: l_current_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1592: l_reserve_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1593: l_display_target_price_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
1594: l_po_min_rel_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1595: l_line_type_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 1592: l_reserve_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

1588: l_bid_start_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1589: l_note_to_bidders PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
1590: l_ship_to_location_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1591: l_current_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1592: l_reserve_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1593: l_display_target_price_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
1594: l_po_min_rel_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1595: l_line_type_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1596: l_order_type_lookup_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

Line 1593: l_display_target_price_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

1589: l_note_to_bidders PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
1590: l_ship_to_location_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1591: l_current_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1592: l_reserve_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1593: l_display_target_price_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
1594: l_po_min_rel_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1595: l_line_type_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1596: l_order_type_lookup_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
1597: l_item_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 1594: l_po_min_rel_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

1590: l_ship_to_location_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1591: l_current_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1592: l_reserve_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1593: l_display_target_price_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
1594: l_po_min_rel_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1595: l_line_type_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1596: l_order_type_lookup_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
1597: l_item_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1598: l_item_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR1000_TYPE;

Line 1595: l_line_type_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

1591: l_current_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1592: l_reserve_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1593: l_display_target_price_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
1594: l_po_min_rel_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1595: l_line_type_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1596: l_order_type_lookup_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
1597: l_item_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1598: l_item_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR1000_TYPE;
1599: l_item_revision PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;

Line 1596: l_order_type_lookup_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

1592: l_reserve_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1593: l_display_target_price_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
1594: l_po_min_rel_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1595: l_line_type_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1596: l_order_type_lookup_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
1597: l_item_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1598: l_item_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR1000_TYPE;
1599: l_item_revision PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
1600: l_job_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 1597: l_item_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

1593: l_display_target_price_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
1594: l_po_min_rel_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1595: l_line_type_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1596: l_order_type_lookup_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
1597: l_item_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1598: l_item_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR1000_TYPE;
1599: l_item_revision PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
1600: l_job_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1601: l_additional_job_details PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;

Line 1598: l_item_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR1000_TYPE;

1594: l_po_min_rel_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1595: l_line_type_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1596: l_order_type_lookup_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
1597: l_item_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1598: l_item_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR1000_TYPE;
1599: l_item_revision PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
1600: l_job_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1601: l_additional_job_details PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
1602: l_po_agreed_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 1599: l_item_revision PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;

1595: l_line_type_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1596: l_order_type_lookup_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
1597: l_item_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1598: l_item_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR1000_TYPE;
1599: l_item_revision PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
1600: l_job_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1601: l_additional_job_details PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
1602: l_po_agreed_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1603: l_unit_target_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 1600: l_job_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

1596: l_order_type_lookup_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
1597: l_item_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1598: l_item_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR1000_TYPE;
1599: l_item_revision PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
1600: l_job_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1601: l_additional_job_details PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
1602: l_po_agreed_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1603: l_unit_target_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1604: l_unit_display_target_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

Line 1601: l_additional_job_details PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;

1597: l_item_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1598: l_item_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR1000_TYPE;
1599: l_item_revision PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
1600: l_job_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1601: l_additional_job_details PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
1602: l_po_agreed_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1603: l_unit_target_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1604: l_unit_display_target_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
1605: l_differential_response_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;

Line 1602: l_po_agreed_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

1598: l_item_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR1000_TYPE;
1599: l_item_revision PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
1600: l_job_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1601: l_additional_job_details PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
1602: l_po_agreed_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1603: l_unit_target_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1604: l_unit_display_target_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
1605: l_differential_response_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
1606: l_purchase_basis PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

Line 1603: l_unit_target_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

1599: l_item_revision PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
1600: l_job_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1601: l_additional_job_details PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
1602: l_po_agreed_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1603: l_unit_target_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1604: l_unit_display_target_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
1605: l_differential_response_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
1606: l_purchase_basis PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
1607: l_price_disabled_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

Line 1604: l_unit_display_target_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

1600: l_job_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1601: l_additional_job_details PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
1602: l_po_agreed_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1603: l_unit_target_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1604: l_unit_display_target_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
1605: l_differential_response_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
1606: l_purchase_basis PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
1607: l_price_disabled_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
1608: l_quantity_disabled_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

Line 1605: l_differential_response_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;

1601: l_additional_job_details PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
1602: l_po_agreed_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1603: l_unit_target_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1604: l_unit_display_target_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
1605: l_differential_response_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
1606: l_purchase_basis PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
1607: l_price_disabled_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
1608: l_quantity_disabled_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
1609: --R12 - Complex work

Line 1606: l_purchase_basis PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

1602: l_po_agreed_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1603: l_unit_target_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1604: l_unit_display_target_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
1605: l_differential_response_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
1606: l_purchase_basis PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
1607: l_price_disabled_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
1608: l_quantity_disabled_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
1609: --R12 - Complex work
1610: l_advance_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 1607: l_price_disabled_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

1603: l_unit_target_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1604: l_unit_display_target_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
1605: l_differential_response_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
1606: l_purchase_basis PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
1607: l_price_disabled_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
1608: l_quantity_disabled_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
1609: --R12 - Complex work
1610: l_advance_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1611: l_recoupment_rate_percent PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 1608: l_quantity_disabled_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

1604: l_unit_display_target_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
1605: l_differential_response_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
1606: l_purchase_basis PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
1607: l_price_disabled_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
1608: l_quantity_disabled_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
1609: --R12 - Complex work
1610: l_advance_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1611: l_recoupment_rate_percent PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1612: l_progress_pymt_rate_percent PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 1610: l_advance_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

1606: l_purchase_basis PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
1607: l_price_disabled_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
1608: l_quantity_disabled_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
1609: --R12 - Complex work
1610: l_advance_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1611: l_recoupment_rate_percent PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1612: l_progress_pymt_rate_percent PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1613: l_retainage_rate_percent PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1614: l_max_retainage_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 1611: l_recoupment_rate_percent PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

1607: l_price_disabled_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
1608: l_quantity_disabled_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
1609: --R12 - Complex work
1610: l_advance_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1611: l_recoupment_rate_percent PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1612: l_progress_pymt_rate_percent PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1613: l_retainage_rate_percent PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1614: l_max_retainage_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1615: l_project_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 1612: l_progress_pymt_rate_percent PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

1608: l_quantity_disabled_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
1609: --R12 - Complex work
1610: l_advance_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1611: l_recoupment_rate_percent PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1612: l_progress_pymt_rate_percent PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1613: l_retainage_rate_percent PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1614: l_max_retainage_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1615: l_project_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1616: l_project_task_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 1613: l_retainage_rate_percent PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

1609: --R12 - Complex work
1610: l_advance_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1611: l_recoupment_rate_percent PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1612: l_progress_pymt_rate_percent PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1613: l_retainage_rate_percent PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1614: l_max_retainage_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1615: l_project_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1616: l_project_task_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1617: l_project_award_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 1614: l_max_retainage_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

1610: l_advance_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1611: l_recoupment_rate_percent PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1612: l_progress_pymt_rate_percent PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1613: l_retainage_rate_percent PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1614: l_max_retainage_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1615: l_project_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1616: l_project_task_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1617: l_project_award_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1618: l_project_expenditure_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

Line 1615: l_project_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

1611: l_recoupment_rate_percent PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1612: l_progress_pymt_rate_percent PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1613: l_retainage_rate_percent PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1614: l_max_retainage_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1615: l_project_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1616: l_project_task_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1617: l_project_award_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1618: l_project_expenditure_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
1619: l_project_exp_organization_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 1616: l_project_task_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

1612: l_progress_pymt_rate_percent PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1613: l_retainage_rate_percent PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1614: l_max_retainage_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1615: l_project_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1616: l_project_task_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1617: l_project_award_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1618: l_project_expenditure_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
1619: l_project_exp_organization_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1620: l_project_expenditure_item_dt PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;

Line 1617: l_project_award_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

1613: l_retainage_rate_percent PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1614: l_max_retainage_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1615: l_project_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1616: l_project_task_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1617: l_project_award_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1618: l_project_expenditure_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
1619: l_project_exp_organization_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1620: l_project_expenditure_item_dt PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
1621: l_work_approver_user_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 1618: l_project_expenditure_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

1614: l_max_retainage_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1615: l_project_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1616: l_project_task_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1617: l_project_award_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1618: l_project_expenditure_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
1619: l_project_exp_organization_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1620: l_project_expenditure_item_dt PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
1621: l_work_approver_user_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1622:

Line 1619: l_project_exp_organization_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

1615: l_project_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1616: l_project_task_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1617: l_project_award_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1618: l_project_expenditure_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
1619: l_project_exp_organization_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1620: l_project_expenditure_item_dt PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
1621: l_work_approver_user_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1622:
1623: BEGIN

Line 1620: l_project_expenditure_item_dt PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;

1616: l_project_task_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1617: l_project_award_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1618: l_project_expenditure_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
1619: l_project_exp_organization_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1620: l_project_expenditure_item_dt PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
1621: l_work_approver_user_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1622:
1623: BEGIN
1624: --{

Line 1621: l_work_approver_user_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

1617: l_project_award_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1618: l_project_expenditure_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
1619: l_project_exp_organization_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1620: l_project_expenditure_item_dt PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
1621: l_work_approver_user_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1622:
1623: BEGIN
1624: --{
1625: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

Line 1998: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

1994: PROCEDURE UPDATE_PRICE_FACTORS is
1995:
1996: l_module CONSTANT VARCHAR2(20) := 'UPDATE_PRICE_FACTORS';
1997:
1998: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1999: l_price_element_type_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2000: l_pricing_basis PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2001: l_value PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2002: l_display_target_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

Line 1999: l_price_element_type_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

1995:
1996: l_module CONSTANT VARCHAR2(20) := 'UPDATE_PRICE_FACTORS';
1997:
1998: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1999: l_price_element_type_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2000: l_pricing_basis PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2001: l_value PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2002: l_display_target_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2003: l_display_to_suppliers_flag VARCHAR2(1) := 'Y';

Line 2000: l_pricing_basis PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

1996: l_module CONSTANT VARCHAR2(20) := 'UPDATE_PRICE_FACTORS';
1997:
1998: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1999: l_price_element_type_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2000: l_pricing_basis PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2001: l_value PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2002: l_display_target_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2003: l_display_to_suppliers_flag VARCHAR2(1) := 'Y';
2004: BEGIN

Line 2001: l_value PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

1997:
1998: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1999: l_price_element_type_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2000: l_pricing_basis PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2001: l_value PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2002: l_display_target_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2003: l_display_to_suppliers_flag VARCHAR2(1) := 'Y';
2004: BEGIN
2005: --{

Line 2002: l_display_target_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

1998: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1999: l_price_element_type_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2000: l_pricing_basis PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2001: l_value PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2002: l_display_target_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2003: l_display_to_suppliers_flag VARCHAR2(1) := 'Y';
2004: BEGIN
2005: --{
2006: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

Line 2159: l_attribute_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

2155:
2156: l_module CONSTANT VARCHAR2(22) := 'UPDATE_LINE_ATTRIBUTES';
2157: l_bid_ranking pon_auction_headers_all.bid_ranking%type;
2158: l_max_neg_line_attr_seq_num number;
2159: l_attribute_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2160: l_attribute_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
2161: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2162: l_attr_group PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
2163: l_mandatory_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

Line 2160: l_attribute_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;

2156: l_module CONSTANT VARCHAR2(22) := 'UPDATE_LINE_ATTRIBUTES';
2157: l_bid_ranking pon_auction_headers_all.bid_ranking%type;
2158: l_max_neg_line_attr_seq_num number;
2159: l_attribute_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2160: l_attribute_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
2161: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2162: l_attr_group PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
2163: l_mandatory_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2164: l_display_only_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

Line 2161: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

2157: l_bid_ranking pon_auction_headers_all.bid_ranking%type;
2158: l_max_neg_line_attr_seq_num number;
2159: l_attribute_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2160: l_attribute_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
2161: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2162: l_attr_group PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
2163: l_mandatory_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2164: l_display_only_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2165: l_internal_attr_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

Line 2162: l_attr_group PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;

2158: l_max_neg_line_attr_seq_num number;
2159: l_attribute_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2160: l_attribute_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
2161: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2162: l_attr_group PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
2163: l_mandatory_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2164: l_display_only_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2165: l_internal_attr_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2166: l_datatype PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;

Line 2163: l_mandatory_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

2159: l_attribute_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2160: l_attribute_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
2161: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2162: l_attr_group PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
2163: l_mandatory_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2164: l_display_only_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2165: l_internal_attr_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2166: l_datatype PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
2167: l_display_target_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

Line 2164: l_display_only_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

2160: l_attribute_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
2161: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2162: l_attr_group PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
2163: l_mandatory_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2164: l_display_only_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2165: l_internal_attr_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2166: l_datatype PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
2167: l_display_target_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2168: l_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;

Line 2165: l_internal_attr_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

2161: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2162: l_attr_group PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
2163: l_mandatory_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2164: l_display_only_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2165: l_internal_attr_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2166: l_datatype PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
2167: l_display_target_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2168: l_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
2169: l_scoring_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

Line 2166: l_datatype PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;

2162: l_attr_group PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
2163: l_mandatory_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2164: l_display_only_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2165: l_internal_attr_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2166: l_datatype PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
2167: l_display_target_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2168: l_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
2169: l_scoring_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2170: l_attr_level PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

Line 2167: l_display_target_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

2163: l_mandatory_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2164: l_display_only_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2165: l_internal_attr_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2166: l_datatype PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
2167: l_display_target_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2168: l_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
2169: l_scoring_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2170: l_attr_level PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2171: l_attr_group_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 2168: l_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;

2164: l_display_only_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2165: l_internal_attr_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2166: l_datatype PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
2167: l_display_target_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2168: l_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
2169: l_scoring_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2170: l_attr_level PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2171: l_attr_group_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2172: l_attr_disp_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 2169: l_scoring_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

2165: l_internal_attr_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2166: l_datatype PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
2167: l_display_target_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2168: l_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
2169: l_scoring_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2170: l_attr_level PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2171: l_attr_group_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2172: l_attr_disp_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2173:

Line 2170: l_attr_level PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

2166: l_datatype PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
2167: l_display_target_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2168: l_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
2169: l_scoring_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2170: l_attr_level PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2171: l_attr_group_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2172: l_attr_disp_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2173:
2174:

Line 2171: l_attr_group_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

2167: l_display_target_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2168: l_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
2169: l_scoring_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2170: l_attr_level PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2171: l_attr_group_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2172: l_attr_disp_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2173:
2174:
2175: BEGIN

Line 2172: l_attr_disp_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

2168: l_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
2169: l_scoring_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2170: l_attr_level PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2171: l_attr_group_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2172: l_attr_disp_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2173:
2174:
2175: BEGIN
2176: --{

Line 2484: l_PRICE_ELEMENT_TYPE_ID PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

2480: PROCEDURE SYNCH_PF_VALUES_FOR_UPLOAD is
2481:
2482: l_module CONSTANT VARCHAR2(27) := 'SYNCH_PF_VALUES_FOR_UPLOAD';
2483:
2484: l_PRICE_ELEMENT_TYPE_ID PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2485: l_PRICING_BASIS PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2486:
2487: begin
2488: --{

Line 2485: l_PRICING_BASIS PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

2481:
2482: l_module CONSTANT VARCHAR2(27) := 'SYNCH_PF_VALUES_FOR_UPLOAD';
2483:
2484: l_PRICE_ELEMENT_TYPE_ID PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2485: l_PRICING_BASIS PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2486:
2487: begin
2488: --{
2489:

Line 3294: l_INTERFACE_TYPE PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

3290: x_error_code OUT NOCOPY VARCHAR2,
3291: x_error_message OUT NOCOPY VARCHAR2
3292: ) is
3293:
3294: l_INTERFACE_TYPE PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3295: l_COLUMN_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3296: l_TABLE_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3297: l_INTERFACE_LINE_ID PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3298: l_ERROR_MESSAGE_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;

Line 3295: l_COLUMN_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;

3291: x_error_message OUT NOCOPY VARCHAR2
3292: ) is
3293:
3294: l_INTERFACE_TYPE PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3295: l_COLUMN_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3296: l_TABLE_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3297: l_INTERFACE_LINE_ID PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3298: l_ERROR_MESSAGE_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3299: l_ERROR_VALUE PON_NEG_COPY_DATATYPES_GRP.VARCHAR100_TYPE;

Line 3296: l_TABLE_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

3292: ) is
3293:
3294: l_INTERFACE_TYPE PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3295: l_COLUMN_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3296: l_TABLE_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3297: l_INTERFACE_LINE_ID PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3298: l_ERROR_MESSAGE_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3299: l_ERROR_VALUE PON_NEG_COPY_DATATYPES_GRP.VARCHAR100_TYPE;
3300: l_CREATED_BY PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 3297: l_INTERFACE_LINE_ID PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

3293:
3294: l_INTERFACE_TYPE PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3295: l_COLUMN_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3296: l_TABLE_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3297: l_INTERFACE_LINE_ID PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3298: l_ERROR_MESSAGE_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3299: l_ERROR_VALUE PON_NEG_COPY_DATATYPES_GRP.VARCHAR100_TYPE;
3300: l_CREATED_BY PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3301: l_CREATION_DATE PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;

Line 3298: l_ERROR_MESSAGE_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;

3294: l_INTERFACE_TYPE PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3295: l_COLUMN_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3296: l_TABLE_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3297: l_INTERFACE_LINE_ID PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3298: l_ERROR_MESSAGE_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3299: l_ERROR_VALUE PON_NEG_COPY_DATATYPES_GRP.VARCHAR100_TYPE;
3300: l_CREATED_BY PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3301: l_CREATION_DATE PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
3302: l_LAST_UPDATED_BY PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 3299: l_ERROR_VALUE PON_NEG_COPY_DATATYPES_GRP.VARCHAR100_TYPE;

3295: l_COLUMN_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3296: l_TABLE_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3297: l_INTERFACE_LINE_ID PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3298: l_ERROR_MESSAGE_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3299: l_ERROR_VALUE PON_NEG_COPY_DATATYPES_GRP.VARCHAR100_TYPE;
3300: l_CREATED_BY PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3301: l_CREATION_DATE PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
3302: l_LAST_UPDATED_BY PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3303: l_LAST_UPDATE_DATE PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;

Line 3300: l_CREATED_BY PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

3296: l_TABLE_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3297: l_INTERFACE_LINE_ID PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3298: l_ERROR_MESSAGE_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3299: l_ERROR_VALUE PON_NEG_COPY_DATATYPES_GRP.VARCHAR100_TYPE;
3300: l_CREATED_BY PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3301: l_CREATION_DATE PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
3302: l_LAST_UPDATED_BY PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3303: l_LAST_UPDATE_DATE PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
3304: l_LAST_UPDATE_LOGIN PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 3301: l_CREATION_DATE PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;

3297: l_INTERFACE_LINE_ID PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3298: l_ERROR_MESSAGE_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3299: l_ERROR_VALUE PON_NEG_COPY_DATATYPES_GRP.VARCHAR100_TYPE;
3300: l_CREATED_BY PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3301: l_CREATION_DATE PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
3302: l_LAST_UPDATED_BY PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3303: l_LAST_UPDATE_DATE PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
3304: l_LAST_UPDATE_LOGIN PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3305: l_ENTITY_TYPE PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

Line 3302: l_LAST_UPDATED_BY PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

3298: l_ERROR_MESSAGE_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3299: l_ERROR_VALUE PON_NEG_COPY_DATATYPES_GRP.VARCHAR100_TYPE;
3300: l_CREATED_BY PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3301: l_CREATION_DATE PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
3302: l_LAST_UPDATED_BY PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3303: l_LAST_UPDATE_DATE PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
3304: l_LAST_UPDATE_LOGIN PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3305: l_ENTITY_TYPE PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3306: l_ENTITY_ATTR_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

Line 3303: l_LAST_UPDATE_DATE PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;

3299: l_ERROR_VALUE PON_NEG_COPY_DATATYPES_GRP.VARCHAR100_TYPE;
3300: l_CREATED_BY PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3301: l_CREATION_DATE PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
3302: l_LAST_UPDATED_BY PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3303: l_LAST_UPDATE_DATE PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
3304: l_LAST_UPDATE_LOGIN PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3305: l_ENTITY_TYPE PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3306: l_ENTITY_ATTR_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3307: l_ERROR_VALUE_DATE PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;

Line 3304: l_LAST_UPDATE_LOGIN PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

3300: l_CREATED_BY PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3301: l_CREATION_DATE PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
3302: l_LAST_UPDATED_BY PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3303: l_LAST_UPDATE_DATE PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
3304: l_LAST_UPDATE_LOGIN PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3305: l_ENTITY_TYPE PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3306: l_ENTITY_ATTR_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3307: l_ERROR_VALUE_DATE PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
3308: l_ERROR_VALUE_NUMBER PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 3305: l_ENTITY_TYPE PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

3301: l_CREATION_DATE PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
3302: l_LAST_UPDATED_BY PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3303: l_LAST_UPDATE_DATE PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
3304: l_LAST_UPDATE_LOGIN PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3305: l_ENTITY_TYPE PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3306: l_ENTITY_ATTR_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3307: l_ERROR_VALUE_DATE PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
3308: l_ERROR_VALUE_NUMBER PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3309: l_ERROR_VALUE_DATATYPE PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;

Line 3306: l_ENTITY_ATTR_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

3302: l_LAST_UPDATED_BY PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3303: l_LAST_UPDATE_DATE PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
3304: l_LAST_UPDATE_LOGIN PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3305: l_ENTITY_TYPE PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3306: l_ENTITY_ATTR_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3307: l_ERROR_VALUE_DATE PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
3308: l_ERROR_VALUE_NUMBER PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3309: l_ERROR_VALUE_DATATYPE PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
3310: l_BID_NUMBER PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 3307: l_ERROR_VALUE_DATE PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;

3303: l_LAST_UPDATE_DATE PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
3304: l_LAST_UPDATE_LOGIN PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3305: l_ENTITY_TYPE PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3306: l_ENTITY_ATTR_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3307: l_ERROR_VALUE_DATE PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
3308: l_ERROR_VALUE_NUMBER PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3309: l_ERROR_VALUE_DATATYPE PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
3310: l_BID_NUMBER PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3311: l_LINE_NUMBER PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 3308: l_ERROR_VALUE_NUMBER PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

3304: l_LAST_UPDATE_LOGIN PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3305: l_ENTITY_TYPE PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3306: l_ENTITY_ATTR_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3307: l_ERROR_VALUE_DATE PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
3308: l_ERROR_VALUE_NUMBER PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3309: l_ERROR_VALUE_DATATYPE PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
3310: l_BID_NUMBER PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3311: l_LINE_NUMBER PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3312: l_ATTRIBUTE_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;

Line 3309: l_ERROR_VALUE_DATATYPE PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;

3305: l_ENTITY_TYPE PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3306: l_ENTITY_ATTR_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3307: l_ERROR_VALUE_DATE PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
3308: l_ERROR_VALUE_NUMBER PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3309: l_ERROR_VALUE_DATATYPE PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
3310: l_BID_NUMBER PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3311: l_LINE_NUMBER PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3312: l_ATTRIBUTE_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
3313: l_PRICE_ELEMENT_TYPE_ID PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 3310: l_BID_NUMBER PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

3306: l_ENTITY_ATTR_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3307: l_ERROR_VALUE_DATE PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
3308: l_ERROR_VALUE_NUMBER PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3309: l_ERROR_VALUE_DATATYPE PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
3310: l_BID_NUMBER PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3311: l_LINE_NUMBER PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3312: l_ATTRIBUTE_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
3313: l_PRICE_ELEMENT_TYPE_ID PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3314: l_SHIPMENT_NUMBER PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 3311: l_LINE_NUMBER PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

3307: l_ERROR_VALUE_DATE PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
3308: l_ERROR_VALUE_NUMBER PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3309: l_ERROR_VALUE_DATATYPE PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
3310: l_BID_NUMBER PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3311: l_LINE_NUMBER PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3312: l_ATTRIBUTE_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
3313: l_PRICE_ELEMENT_TYPE_ID PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3314: l_SHIPMENT_NUMBER PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3315: l_PRICE_DIFFERENTIAL_NUMBER PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 3312: l_ATTRIBUTE_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;

3308: l_ERROR_VALUE_NUMBER PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3309: l_ERROR_VALUE_DATATYPE PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
3310: l_BID_NUMBER PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3311: l_LINE_NUMBER PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3312: l_ATTRIBUTE_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
3313: l_PRICE_ELEMENT_TYPE_ID PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3314: l_SHIPMENT_NUMBER PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3315: l_PRICE_DIFFERENTIAL_NUMBER PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3316: l_TOKEN1_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

Line 3313: l_PRICE_ELEMENT_TYPE_ID PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

3309: l_ERROR_VALUE_DATATYPE PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
3310: l_BID_NUMBER PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3311: l_LINE_NUMBER PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3312: l_ATTRIBUTE_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
3313: l_PRICE_ELEMENT_TYPE_ID PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3314: l_SHIPMENT_NUMBER PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3315: l_PRICE_DIFFERENTIAL_NUMBER PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3316: l_TOKEN1_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3317: l_TOKEN1_VALUE PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;

Line 3314: l_SHIPMENT_NUMBER PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

3310: l_BID_NUMBER PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3311: l_LINE_NUMBER PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3312: l_ATTRIBUTE_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
3313: l_PRICE_ELEMENT_TYPE_ID PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3314: l_SHIPMENT_NUMBER PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3315: l_PRICE_DIFFERENTIAL_NUMBER PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3316: l_TOKEN1_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3317: l_TOKEN1_VALUE PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3318: l_TOKEN2_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

Line 3315: l_PRICE_DIFFERENTIAL_NUMBER PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

3311: l_LINE_NUMBER PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3312: l_ATTRIBUTE_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
3313: l_PRICE_ELEMENT_TYPE_ID PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3314: l_SHIPMENT_NUMBER PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3315: l_PRICE_DIFFERENTIAL_NUMBER PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3316: l_TOKEN1_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3317: l_TOKEN1_VALUE PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3318: l_TOKEN2_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3319: l_TOKEN2_VALUE PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;

Line 3316: l_TOKEN1_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

3312: l_ATTRIBUTE_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
3313: l_PRICE_ELEMENT_TYPE_ID PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3314: l_SHIPMENT_NUMBER PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3315: l_PRICE_DIFFERENTIAL_NUMBER PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3316: l_TOKEN1_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3317: l_TOKEN1_VALUE PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3318: l_TOKEN2_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3319: l_TOKEN2_VALUE PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3320: l_TOKEN3_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

Line 3317: l_TOKEN1_VALUE PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;

3313: l_PRICE_ELEMENT_TYPE_ID PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3314: l_SHIPMENT_NUMBER PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3315: l_PRICE_DIFFERENTIAL_NUMBER PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3316: l_TOKEN1_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3317: l_TOKEN1_VALUE PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3318: l_TOKEN2_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3319: l_TOKEN2_VALUE PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3320: l_TOKEN3_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3321: l_TOKEN3_VALUE PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;

Line 3318: l_TOKEN2_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

3314: l_SHIPMENT_NUMBER PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3315: l_PRICE_DIFFERENTIAL_NUMBER PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3316: l_TOKEN1_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3317: l_TOKEN1_VALUE PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3318: l_TOKEN2_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3319: l_TOKEN2_VALUE PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3320: l_TOKEN3_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3321: l_TOKEN3_VALUE PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3322: l_TOKEN4_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

Line 3319: l_TOKEN2_VALUE PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;

3315: l_PRICE_DIFFERENTIAL_NUMBER PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3316: l_TOKEN1_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3317: l_TOKEN1_VALUE PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3318: l_TOKEN2_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3319: l_TOKEN2_VALUE PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3320: l_TOKEN3_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3321: l_TOKEN3_VALUE PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3322: l_TOKEN4_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3323: l_TOKEN4_VALUE PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;

Line 3320: l_TOKEN3_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

3316: l_TOKEN1_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3317: l_TOKEN1_VALUE PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3318: l_TOKEN2_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3319: l_TOKEN2_VALUE PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3320: l_TOKEN3_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3321: l_TOKEN3_VALUE PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3322: l_TOKEN4_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3323: l_TOKEN4_VALUE PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3324: l_TOKEN5_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

Line 3321: l_TOKEN3_VALUE PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;

3317: l_TOKEN1_VALUE PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3318: l_TOKEN2_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3319: l_TOKEN2_VALUE PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3320: l_TOKEN3_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3321: l_TOKEN3_VALUE PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3322: l_TOKEN4_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3323: l_TOKEN4_VALUE PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3324: l_TOKEN5_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3325: l_TOKEN5_VALUE PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;

Line 3322: l_TOKEN4_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

3318: l_TOKEN2_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3319: l_TOKEN2_VALUE PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3320: l_TOKEN3_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3321: l_TOKEN3_VALUE PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3322: l_TOKEN4_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3323: l_TOKEN4_VALUE PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3324: l_TOKEN5_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3325: l_TOKEN5_VALUE PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3326:

Line 3323: l_TOKEN4_VALUE PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;

3319: l_TOKEN2_VALUE PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3320: l_TOKEN3_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3321: l_TOKEN3_VALUE PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3322: l_TOKEN4_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3323: l_TOKEN4_VALUE PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3324: l_TOKEN5_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3325: l_TOKEN5_VALUE PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3326:
3327: l_progress varchar2(200);

Line 3324: l_TOKEN5_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

3320: l_TOKEN3_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3321: l_TOKEN3_VALUE PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3322: l_TOKEN4_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3323: l_TOKEN4_VALUE PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3324: l_TOKEN5_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3325: l_TOKEN5_VALUE PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3326:
3327: l_progress varchar2(200);
3328: l_module CONSTANT VARCHAR2(30) := 'SYNCH_PAYMENTS_FROM_INTERFACE';

Line 3325: l_TOKEN5_VALUE PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;

3321: l_TOKEN3_VALUE PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3322: l_TOKEN4_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3323: l_TOKEN4_VALUE PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3324: l_TOKEN5_NAME PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3325: l_TOKEN5_VALUE PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3326:
3327: l_progress varchar2(200);
3328: l_module CONSTANT VARCHAR2(30) := 'SYNCH_PAYMENTS_FROM_INTERFACE';
3329: