[Home] [Help]
3399: p_to_line_number IN NUMBER
3400: )
3401: --{
3402: IS
3403: l_amendment_update PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3404: l_disp_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3405:
3406: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3407: l_item_description PON_NEG_COPY_DATATYPES_GRP.VARCHAR2500_TYPE;
3400: )
3401: --{
3402: IS
3403: l_amendment_update PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3404: l_disp_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3405:
3406: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3407: l_item_description PON_NEG_COPY_DATATYPES_GRP.VARCHAR2500_TYPE;
3408: l_category_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3402: IS
3403: l_amendment_update PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3404: l_disp_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3405:
3406: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3407: l_item_description PON_NEG_COPY_DATATYPES_GRP.VARCHAR2500_TYPE;
3408: l_category_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3409: l_category_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
3410: l_ip_category_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3403: l_amendment_update PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3404: l_disp_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3405:
3406: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3407: l_item_description PON_NEG_COPY_DATATYPES_GRP.VARCHAR2500_TYPE;
3408: l_category_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3409: l_category_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
3410: l_ip_category_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3411: l_uom_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
3404: l_disp_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3405:
3406: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3407: l_item_description PON_NEG_COPY_DATATYPES_GRP.VARCHAR2500_TYPE;
3408: l_category_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3409: l_category_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
3410: l_ip_category_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3411: l_uom_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
3412: l_quantity PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3405:
3406: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3407: l_item_description PON_NEG_COPY_DATATYPES_GRP.VARCHAR2500_TYPE;
3408: l_category_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3409: l_category_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
3410: l_ip_category_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3411: l_uom_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
3412: l_quantity PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3413: l_need_by_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE; -- need to change?
3406: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3407: l_item_description PON_NEG_COPY_DATATYPES_GRP.VARCHAR2500_TYPE;
3408: l_category_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3409: l_category_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
3410: l_ip_category_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3411: l_uom_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
3412: l_quantity PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3413: l_need_by_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE; -- need to change?
3414: l_ship_to_location_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3407: l_item_description PON_NEG_COPY_DATATYPES_GRP.VARCHAR2500_TYPE;
3408: l_category_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3409: l_category_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
3410: l_ip_category_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3411: l_uom_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
3412: l_quantity PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3413: l_need_by_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE; -- need to change?
3414: l_ship_to_location_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3415: l_target_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3408: l_category_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3409: l_category_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
3410: l_ip_category_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3411: l_uom_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
3412: l_quantity PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3413: l_need_by_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE; -- need to change?
3414: l_ship_to_location_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3415: l_target_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3416: l_threshold_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3409: l_category_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
3410: l_ip_category_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3411: l_uom_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
3412: l_quantity PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3413: l_need_by_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE; -- need to change?
3414: l_ship_to_location_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3415: l_target_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3416: l_threshold_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3417: l_bid_start_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3410: l_ip_category_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3411: l_uom_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
3412: l_quantity PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3413: l_need_by_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE; -- need to change?
3414: l_ship_to_location_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3415: l_target_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3416: l_threshold_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3417: l_bid_start_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3418: l_note_to_bidders PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
3411: l_uom_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
3412: l_quantity PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3413: l_need_by_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE; -- need to change?
3414: l_ship_to_location_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3415: l_target_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3416: l_threshold_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3417: l_bid_start_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3418: l_note_to_bidders PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
3419: l_attachment_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3412: l_quantity PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3413: l_need_by_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE; -- need to change?
3414: l_ship_to_location_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3415: l_target_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3416: l_threshold_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3417: l_bid_start_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3418: l_note_to_bidders PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
3419: l_attachment_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3420: l_language_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
3413: l_need_by_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE; -- need to change?
3414: l_ship_to_location_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3415: l_target_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3416: l_threshold_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3417: l_bid_start_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3418: l_note_to_bidders PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
3419: l_attachment_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3420: l_language_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
3421: l_reserve_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3414: l_ship_to_location_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3415: l_target_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3416: l_threshold_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3417: l_bid_start_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3418: l_note_to_bidders PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
3419: l_attachment_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3420: l_language_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
3421: l_reserve_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3422: l_display_target_price_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3415: l_target_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3416: l_threshold_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3417: l_bid_start_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3418: l_note_to_bidders PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
3419: l_attachment_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3420: l_language_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
3421: l_reserve_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3422: l_display_target_price_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3423: l_current_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3416: l_threshold_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3417: l_bid_start_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3418: l_note_to_bidders PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
3419: l_attachment_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3420: l_language_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
3421: l_reserve_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3422: l_display_target_price_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3423: l_current_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3424: l_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
3417: l_bid_start_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3418: l_note_to_bidders PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
3419: l_attachment_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3420: l_language_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
3421: l_reserve_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3422: l_display_target_price_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3423: l_current_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3424: l_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
3425: l_lot_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3418: l_note_to_bidders PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
3419: l_attachment_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3420: l_language_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
3421: l_reserve_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3422: l_display_target_price_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3423: l_current_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3424: l_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
3425: l_lot_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3426: l_min_bid_increment PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3419: l_attachment_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3420: l_language_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
3421: l_reserve_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3422: l_display_target_price_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3423: l_current_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3424: l_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
3425: l_lot_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3426: l_min_bid_increment PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3427: l_min_bid_decrement PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3420: l_language_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
3421: l_reserve_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3422: l_display_target_price_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3423: l_current_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3424: l_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
3425: l_lot_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3426: l_min_bid_increment PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3427: l_min_bid_decrement PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3428: l_unit_of_measure PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3421: l_reserve_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3422: l_display_target_price_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3423: l_current_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3424: l_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
3425: l_lot_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3426: l_min_bid_increment PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3427: l_min_bid_decrement PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3428: l_unit_of_measure PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3429: l_po_min_rel_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3422: l_display_target_price_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3423: l_current_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3424: l_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
3425: l_lot_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3426: l_min_bid_increment PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3427: l_min_bid_decrement PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3428: l_unit_of_measure PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3429: l_po_min_rel_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3430: l_has_attributes_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3423: l_current_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3424: l_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
3425: l_lot_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3426: l_min_bid_increment PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3427: l_min_bid_decrement PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3428: l_unit_of_measure PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3429: l_po_min_rel_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3430: l_has_attributes_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3431: l_transportation_origin PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
3424: l_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
3425: l_lot_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3426: l_min_bid_increment PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3427: l_min_bid_decrement PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3428: l_unit_of_measure PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3429: l_po_min_rel_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3430: l_has_attributes_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3431: l_transportation_origin PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
3432: l_transportation_dest PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
3425: l_lot_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3426: l_min_bid_increment PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3427: l_min_bid_decrement PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3428: l_unit_of_measure PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3429: l_po_min_rel_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3430: l_has_attributes_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3431: l_transportation_origin PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
3432: l_transportation_dest PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
3433: l_multiple_prices_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3426: l_min_bid_increment PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3427: l_min_bid_decrement PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3428: l_unit_of_measure PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3429: l_po_min_rel_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3430: l_has_attributes_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3431: l_transportation_origin PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
3432: l_transportation_dest PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
3433: l_multiple_prices_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3434: l_tbd_pricing_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3427: l_min_bid_decrement PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3428: l_unit_of_measure PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3429: l_po_min_rel_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3430: l_has_attributes_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3431: l_transportation_origin PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
3432: l_transportation_dest PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
3433: l_multiple_prices_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3434: l_tbd_pricing_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3435: l_need_by_start_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
3428: l_unit_of_measure PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3429: l_po_min_rel_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3430: l_has_attributes_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3431: l_transportation_origin PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
3432: l_transportation_dest PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
3433: l_multiple_prices_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3434: l_tbd_pricing_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3435: l_need_by_start_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
3436: l_modified_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3429: l_po_min_rel_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3430: l_has_attributes_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3431: l_transportation_origin PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
3432: l_transportation_dest PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
3433: l_multiple_prices_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3434: l_tbd_pricing_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3435: l_need_by_start_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
3436: l_modified_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3437: l_freight_terms_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3430: l_has_attributes_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3431: l_transportation_origin PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
3432: l_transportation_dest PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
3433: l_multiple_prices_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3434: l_tbd_pricing_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3435: l_need_by_start_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
3436: l_modified_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3437: l_freight_terms_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3438: l_org_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3431: l_transportation_origin PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
3432: l_transportation_dest PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
3433: l_multiple_prices_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3434: l_tbd_pricing_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3435: l_need_by_start_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
3436: l_modified_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3437: l_freight_terms_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3438: l_org_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3439: l_has_price_elements_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
3432: l_transportation_dest PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
3433: l_multiple_prices_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3434: l_tbd_pricing_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3435: l_need_by_start_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
3436: l_modified_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3437: l_freight_terms_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3438: l_org_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3439: l_has_price_elements_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
3440: l_line_type_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3433: l_multiple_prices_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3434: l_tbd_pricing_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3435: l_need_by_start_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
3436: l_modified_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3437: l_freight_terms_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3438: l_org_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3439: l_has_price_elements_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
3440: l_line_type_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3441: l_order_type_lookup_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3434: l_tbd_pricing_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3435: l_need_by_start_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
3436: l_modified_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3437: l_freight_terms_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3438: l_org_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3439: l_has_price_elements_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
3440: l_line_type_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3441: l_order_type_lookup_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3442: l_line_origination_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3435: l_need_by_start_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
3436: l_modified_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3437: l_freight_terms_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3438: l_org_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3439: l_has_price_elements_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
3440: l_line_type_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3441: l_order_type_lookup_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3442: l_line_origination_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3443: l_requisition_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
3436: l_modified_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3437: l_freight_terms_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3438: l_org_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3439: l_has_price_elements_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
3440: l_line_type_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3441: l_order_type_lookup_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3442: l_line_origination_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3443: l_requisition_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
3444: l_item_revision PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
3437: l_freight_terms_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3438: l_org_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3439: l_has_price_elements_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
3440: l_line_type_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3441: l_order_type_lookup_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3442: l_line_origination_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3443: l_requisition_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
3444: l_item_revision PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
3445: l_item_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3438: l_org_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3439: l_has_price_elements_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
3440: l_line_type_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3441: l_order_type_lookup_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3442: l_line_origination_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3443: l_requisition_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
3444: l_item_revision PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
3445: l_item_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3446: l_item_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR1000_TYPE;
3439: l_has_price_elements_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
3440: l_line_type_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3441: l_order_type_lookup_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3442: l_line_origination_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3443: l_requisition_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
3444: l_item_revision PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
3445: l_item_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3446: l_item_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR1000_TYPE;
3447: l_price_break_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3440: l_line_type_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3441: l_order_type_lookup_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3442: l_line_origination_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3443: l_requisition_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
3444: l_item_revision PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
3445: l_item_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3446: l_item_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR1000_TYPE;
3447: l_price_break_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3448: l_price_break_neg_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3441: l_order_type_lookup_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3442: l_line_origination_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3443: l_requisition_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
3444: l_item_revision PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
3445: l_item_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3446: l_item_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR1000_TYPE;
3447: l_price_break_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3448: l_price_break_neg_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3449: l_has_shipments_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3442: l_line_origination_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3443: l_requisition_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
3444: l_item_revision PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
3445: l_item_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3446: l_item_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR1000_TYPE;
3447: l_price_break_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3448: l_price_break_neg_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3449: l_has_shipments_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3450: l_source_doc_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
3443: l_requisition_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
3444: l_item_revision PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
3445: l_item_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3446: l_item_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR1000_TYPE;
3447: l_price_break_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3448: l_price_break_neg_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3449: l_has_shipments_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3450: l_source_doc_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
3451: l_source_line_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
3444: l_item_revision PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
3445: l_item_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3446: l_item_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR1000_TYPE;
3447: l_price_break_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3448: l_price_break_neg_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3449: l_has_shipments_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3450: l_source_doc_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
3451: l_source_line_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
3452: l_souce_doc_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3445: l_item_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3446: l_item_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR1000_TYPE;
3447: l_price_break_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3448: l_price_break_neg_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3449: l_has_shipments_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3450: l_source_doc_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
3451: l_source_line_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
3452: l_souce_doc_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3453: l_source_line_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3446: l_item_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR1000_TYPE;
3447: l_price_break_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3448: l_price_break_neg_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3449: l_has_shipments_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3450: l_source_doc_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
3451: l_source_line_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
3452: l_souce_doc_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3453: l_source_line_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3454: l_price_disabled_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3447: l_price_break_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3448: l_price_break_neg_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3449: l_has_shipments_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3450: l_source_doc_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
3451: l_source_line_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
3452: l_souce_doc_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3453: l_source_line_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3454: l_price_disabled_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3455: l_quantity_disabled_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3448: l_price_break_neg_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3449: l_has_shipments_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3450: l_source_doc_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
3451: l_source_line_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
3452: l_souce_doc_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3453: l_source_line_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3454: l_price_disabled_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3455: l_quantity_disabled_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3456: l_job_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3449: l_has_shipments_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3450: l_source_doc_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
3451: l_source_line_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
3452: l_souce_doc_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3453: l_source_line_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3454: l_price_disabled_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3455: l_quantity_disabled_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3456: l_job_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3457: l_additional_job_details PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3450: l_source_doc_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
3451: l_source_line_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
3452: l_souce_doc_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3453: l_source_line_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3454: l_price_disabled_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3455: l_quantity_disabled_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3456: l_job_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3457: l_additional_job_details PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3458: l_po_agreed_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3451: l_source_line_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
3452: l_souce_doc_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3453: l_source_line_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3454: l_price_disabled_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3455: l_quantity_disabled_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3456: l_job_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3457: l_additional_job_details PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3458: l_po_agreed_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3459: l_has_price_differentials_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3452: l_souce_doc_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3453: l_source_line_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3454: l_price_disabled_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3455: l_quantity_disabled_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3456: l_job_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3457: l_additional_job_details PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3458: l_po_agreed_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3459: l_has_price_differentials_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3460: l_differential_response_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
3453: l_source_line_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3454: l_price_disabled_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3455: l_quantity_disabled_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3456: l_job_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3457: l_additional_job_details PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3458: l_po_agreed_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3459: l_has_price_differentials_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3460: l_differential_response_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
3461: l_purchase_basis PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3454: l_price_disabled_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3455: l_quantity_disabled_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3456: l_job_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3457: l_additional_job_details PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3458: l_po_agreed_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3459: l_has_price_differentials_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3460: l_differential_response_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
3461: l_purchase_basis PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3462: l_is_quantity_scored PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3455: l_quantity_disabled_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3456: l_job_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3457: l_additional_job_details PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3458: l_po_agreed_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3459: l_has_price_differentials_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3460: l_differential_response_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
3461: l_purchase_basis PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3462: l_is_quantity_scored PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3463: l_is_need_by_date_scored PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3456: l_job_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3457: l_additional_job_details PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3458: l_po_agreed_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3459: l_has_price_differentials_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3460: l_differential_response_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
3461: l_purchase_basis PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3462: l_is_quantity_scored PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3463: l_is_need_by_date_scored PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3464: l_last_amendment_update PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3457: l_additional_job_details PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3458: l_po_agreed_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3459: l_has_price_differentials_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3460: l_differential_response_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
3461: l_purchase_basis PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3462: l_is_quantity_scored PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3463: l_is_need_by_date_scored PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3464: l_last_amendment_update PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3465: l_modified_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
3458: l_po_agreed_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3459: l_has_price_differentials_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3460: l_differential_response_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
3461: l_purchase_basis PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3462: l_is_quantity_scored PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3463: l_is_need_by_date_scored PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3464: l_last_amendment_update PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3465: l_modified_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
3466: l_price_diff_shipment_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3459: l_has_price_differentials_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3460: l_differential_response_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
3461: l_purchase_basis PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3462: l_is_quantity_scored PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3463: l_is_need_by_date_scored PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3464: l_last_amendment_update PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3465: l_modified_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
3466: l_price_diff_shipment_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3467:
3460: l_differential_response_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
3461: l_purchase_basis PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3462: l_is_quantity_scored PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3463: l_is_need_by_date_scored PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3464: l_last_amendment_update PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3465: l_modified_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
3466: l_price_diff_shipment_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3467:
3468: --
3461: l_purchase_basis PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3462: l_is_quantity_scored PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3463: l_is_need_by_date_scored PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3464: l_last_amendment_update PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3465: l_modified_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
3466: l_price_diff_shipment_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3467:
3468: --
3469: -- Lot based project related columns
3462: l_is_quantity_scored PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3463: l_is_need_by_date_scored PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3464: l_last_amendment_update PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3465: l_modified_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
3466: l_price_diff_shipment_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3467:
3468: --
3469: -- Lot based project related columns
3470: --
3467:
3468: --
3469: -- Lot based project related columns
3470: --
3471: l_group_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3472: l_parent_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3473: l_document_disp_line_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3474: l_max_sub_line_sequence_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3475: l_sub_line_sequence_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3468: --
3469: -- Lot based project related columns
3470: --
3471: l_group_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3472: l_parent_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3473: l_document_disp_line_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3474: l_max_sub_line_sequence_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3475: l_sub_line_sequence_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3476:
3469: -- Lot based project related columns
3470: --
3471: l_group_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3472: l_parent_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3473: l_document_disp_line_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3474: l_max_sub_line_sequence_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3475: l_sub_line_sequence_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3476:
3477: --
3470: --
3471: l_group_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3472: l_parent_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3473: l_document_disp_line_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3474: l_max_sub_line_sequence_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3475: l_sub_line_sequence_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3476:
3477: --
3478: -- Transformation project related columns
3471: l_group_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3472: l_parent_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3473: l_document_disp_line_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3474: l_max_sub_line_sequence_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3475: l_sub_line_sequence_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3476:
3477: --
3478: -- Transformation project related columns
3479: --
3476:
3477: --
3478: -- Transformation project related columns
3479: --
3480: l_has_buyer_pfs_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3481: l_unit_target_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3482: l_unit_display_target_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3483:
3484: l_had_obsoleted_pe PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3477: --
3478: -- Transformation project related columns
3479: --
3480: l_has_buyer_pfs_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3481: l_unit_target_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3482: l_unit_display_target_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3483:
3484: l_had_obsoleted_pe PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3485: l_had_obsolete_attr_group PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3478: -- Transformation project related columns
3479: --
3480: l_has_buyer_pfs_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3481: l_unit_target_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3482: l_unit_display_target_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3483:
3484: l_had_obsoleted_pe PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3485: l_had_obsolete_attr_group PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3486:
3480: l_has_buyer_pfs_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3481: l_unit_target_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3482: l_unit_display_target_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3483:
3484: l_had_obsoleted_pe PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3485: l_had_obsolete_attr_group PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3486:
3487: l_has_active_buyer_pe_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3488: l_has_active_supplier_pe_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3481: l_unit_target_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3482: l_unit_display_target_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3483:
3484: l_had_obsoleted_pe PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3485: l_had_obsolete_attr_group PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3486:
3487: l_has_active_buyer_pe_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3488: l_has_active_supplier_pe_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3489: l_exhibit_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
3483:
3484: l_had_obsoleted_pe PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3485: l_had_obsolete_attr_group PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3486:
3487: l_has_active_buyer_pe_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3488: l_has_active_supplier_pe_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3489: l_exhibit_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
3490: l_rfi_doctype_id NUMBER;
3491: l_has_some_obsolete_attr_group VARCHAR2(1);
3484: l_had_obsoleted_pe PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3485: l_had_obsolete_attr_group PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3486:
3487: l_has_active_buyer_pe_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3488: l_has_active_supplier_pe_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3489: l_exhibit_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
3490: l_rfi_doctype_id NUMBER;
3491: l_has_some_obsolete_attr_group VARCHAR2(1);
3492: l_has_temp_labor_lines VARCHAR2(1);
3485: l_had_obsolete_attr_group PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3486:
3487: l_has_active_buyer_pe_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3488: l_has_active_supplier_pe_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3489: l_exhibit_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
3490: l_rfi_doctype_id NUMBER;
3491: l_has_some_obsolete_attr_group VARCHAR2(1);
3492: l_has_temp_labor_lines VARCHAR2(1);
3493: l_is_succession VARCHAR2(1);
3493: l_is_succession VARCHAR2(1);
3494: l_has_descriptors VARCHAR2(1);
3495:
3496: --Complex work project related columns
3497: l_has_payments_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3498: l_advance_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3499: l_recoupment_rate_percent PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3500: l_progress_pymt_rate_percent PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3501: l_retainage_rate_percent PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3494: l_has_descriptors VARCHAR2(1);
3495:
3496: --Complex work project related columns
3497: l_has_payments_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3498: l_advance_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3499: l_recoupment_rate_percent PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3500: l_progress_pymt_rate_percent PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3501: l_retainage_rate_percent PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3502: l_max_retainage_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3495:
3496: --Complex work project related columns
3497: l_has_payments_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3498: l_advance_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3499: l_recoupment_rate_percent PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3500: l_progress_pymt_rate_percent PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3501: l_retainage_rate_percent PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3502: l_max_retainage_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3503: l_work_approver_user_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3496: --Complex work project related columns
3497: l_has_payments_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3498: l_advance_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3499: l_recoupment_rate_percent PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3500: l_progress_pymt_rate_percent PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3501: l_retainage_rate_percent PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3502: l_max_retainage_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3503: l_work_approver_user_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3504: l_project_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3497: l_has_payments_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3498: l_advance_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3499: l_recoupment_rate_percent PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3500: l_progress_pymt_rate_percent PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3501: l_retainage_rate_percent PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3502: l_max_retainage_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3503: l_work_approver_user_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3504: l_project_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3505: l_project_task_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3498: l_advance_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3499: l_recoupment_rate_percent PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3500: l_progress_pymt_rate_percent PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3501: l_retainage_rate_percent PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3502: l_max_retainage_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3503: l_work_approver_user_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3504: l_project_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3505: l_project_task_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3506: l_project_award_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3499: l_recoupment_rate_percent PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3500: l_progress_pymt_rate_percent PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3501: l_retainage_rate_percent PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3502: l_max_retainage_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3503: l_work_approver_user_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3504: l_project_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3505: l_project_task_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3506: l_project_award_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3507: l_project_expenditure_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3500: l_progress_pymt_rate_percent PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3501: l_retainage_rate_percent PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3502: l_max_retainage_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3503: l_work_approver_user_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3504: l_project_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3505: l_project_task_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3506: l_project_award_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3507: l_project_expenditure_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3508: l_project_exp_organization_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3501: l_retainage_rate_percent PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3502: l_max_retainage_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3503: l_work_approver_user_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3504: l_project_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3505: l_project_task_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3506: l_project_award_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3507: l_project_expenditure_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3508: l_project_exp_organization_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3509: l_project_exp_item_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
3502: l_max_retainage_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3503: l_work_approver_user_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3504: l_project_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3505: l_project_task_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3506: l_project_award_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3507: l_project_expenditure_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3508: l_project_exp_organization_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3509: l_project_exp_item_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
3510:
3503: l_work_approver_user_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3504: l_project_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3505: l_project_task_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3506: l_project_award_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3507: l_project_expenditure_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3508: l_project_exp_organization_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3509: l_project_exp_item_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
3510:
3511: --Staggered closing project
3504: l_project_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3505: l_project_task_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3506: l_project_award_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3507: l_project_expenditure_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3508: l_project_exp_organization_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3509: l_project_exp_item_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
3510:
3511: --Staggered closing project
3512: l_close_bidding_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
3505: l_project_task_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3506: l_project_award_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3507: l_project_expenditure_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3508: l_project_exp_organization_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3509: l_project_exp_item_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
3510:
3511: --Staggered closing project
3512: l_close_bidding_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
3513: l_copy_close_bidding_date varchar2(1);
3508: l_project_exp_organization_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3509: l_project_exp_item_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
3510:
3511: --Staggered closing project
3512: l_close_bidding_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
3513: l_copy_close_bidding_date varchar2(1);
3514:
3515: -- Quantity Based Price Tiers
3516: l_has_quantity_tiers_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3512: l_close_bidding_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
3513: l_copy_close_bidding_date varchar2(1);
3514:
3515: -- Quantity Based Price Tiers
3516: l_has_quantity_tiers_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3517: /***********************************************************
3518: * CLM - Clin Slin project Changes Start.
3519: *********************************************************/
3520:
3517: /***********************************************************
3518: * CLM - Clin Slin project Changes Start.
3519: *********************************************************/
3520:
3521: l_line_num_display PON_NEG_COPY_DATATYPES_GRP.VARCHAR100_TYPE;
3522: l_group_line_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3523: l_clm_info_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3524: l_clm_option_indicator PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3525: l_clm_base_line_num PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3518: * CLM - Clin Slin project Changes Start.
3519: *********************************************************/
3520:
3521: l_line_num_display PON_NEG_COPY_DATATYPES_GRP.VARCHAR100_TYPE;
3522: l_group_line_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3523: l_clm_info_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3524: l_clm_option_indicator PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3525: l_clm_base_line_num PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3526: l_clm_option_num PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3519: *********************************************************/
3520:
3521: l_line_num_display PON_NEG_COPY_DATATYPES_GRP.VARCHAR100_TYPE;
3522: l_group_line_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3523: l_clm_info_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3524: l_clm_option_indicator PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3525: l_clm_base_line_num PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3526: l_clm_option_num PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3527: l_clm_option_from_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
3520:
3521: l_line_num_display PON_NEG_COPY_DATATYPES_GRP.VARCHAR100_TYPE;
3522: l_group_line_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3523: l_clm_info_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3524: l_clm_option_indicator PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3525: l_clm_base_line_num PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3526: l_clm_option_num PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3527: l_clm_option_from_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
3528: l_clm_option_to_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
3521: l_line_num_display PON_NEG_COPY_DATATYPES_GRP.VARCHAR100_TYPE;
3522: l_group_line_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3523: l_clm_info_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3524: l_clm_option_indicator PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3525: l_clm_base_line_num PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3526: l_clm_option_num PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3527: l_clm_option_from_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
3528: l_clm_option_to_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
3529: l_clm_funded_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3522: l_group_line_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3523: l_clm_info_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3524: l_clm_option_indicator PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3525: l_clm_base_line_num PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3526: l_clm_option_num PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3527: l_clm_option_from_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
3528: l_clm_option_to_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
3529: l_clm_funded_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3530:
3523: l_clm_info_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3524: l_clm_option_indicator PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3525: l_clm_base_line_num PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3526: l_clm_option_num PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3527: l_clm_option_from_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
3528: l_clm_option_to_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
3529: l_clm_funded_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3530:
3531: /***********************************************************
3524: l_clm_option_indicator PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3525: l_clm_base_line_num PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3526: l_clm_option_num PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3527: l_clm_option_from_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
3528: l_clm_option_to_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
3529: l_clm_funded_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3530:
3531: /***********************************************************
3532: * CLM - Clin Slin project Changes End.
3525: l_clm_base_line_num PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3526: l_clm_option_num PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3527: l_clm_option_from_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
3528: l_clm_option_to_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
3529: l_clm_funded_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3530:
3531: /***********************************************************
3532: * CLM - Clin Slin project Changes End.
3533: *********************************************************/
3533: *********************************************************/
3534:
3535: --
3536: /* Fed Fields Project */
3537: l_uda_template_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3538: l_clm_contract_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3539: l_clm_idc_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3540: /* Fed Fields Project End */
3541:
3534:
3535: --
3536: /* Fed Fields Project */
3537: l_uda_template_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3538: l_clm_contract_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3539: l_clm_idc_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3540: /* Fed Fields Project End */
3541:
3542: l_return_status VARCHAR2(1) := NULL;
3535: --
3536: /* Fed Fields Project */
3537: l_uda_template_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3538: l_clm_contract_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3539: l_clm_idc_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3540: /* Fed Fields Project End */
3541:
3542: l_return_status VARCHAR2(1) := NULL;
3543: l_msg_count NUMBER;
3543: l_msg_count NUMBER;
3544: l_is_Federal NUMBER := 0;
3545: l_msg_data VARCHAR2(32767);
3546:
3547: l_clm_cost_constraint PON_NEG_COPY_DATATYPES_GRP.VARCHAR100_TYPE;
3548: l_clm_unit_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3549: l_clm_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3550: /* Bug 9787380
3551: Added NEED BY DATE column to be copied in case of New Round creation,
3544: l_is_Federal NUMBER := 0;
3545: l_msg_data VARCHAR2(32767);
3546:
3547: l_clm_cost_constraint PON_NEG_COPY_DATATYPES_GRP.VARCHAR100_TYPE;
3548: l_clm_unit_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3549: l_clm_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3550: /* Bug 9787380
3551: Added NEED BY DATE column to be copied in case of New Round creation,
3552: amendment creation, conform document creation, and copy soliciation. */
3545: l_msg_data VARCHAR2(32767);
3546:
3547: l_clm_cost_constraint PON_NEG_COPY_DATATYPES_GRP.VARCHAR100_TYPE;
3548: l_clm_unit_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3549: l_clm_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3550: /* Bug 9787380
3551: Added NEED BY DATE column to be copied in case of New Round creation,
3552: amendment creation, conform document creation, and copy soliciation. */
3553:
3550: /* Bug 9787380
3551: Added NEED BY DATE column to be copied in case of New Round creation,
3552: amendment creation, conform document creation, and copy soliciation. */
3553:
3554: l_clm_need_by_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
3555: l_source_prev_amend_id NUMBER; -- bug 13504088
3556: -- CLM - Event Based Delivery Project
3557: l_clm_delivery_event_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3558: l_clm_delivery_period PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3553:
3554: l_clm_need_by_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
3555: l_source_prev_amend_id NUMBER; -- bug 13504088
3556: -- CLM - Event Based Delivery Project
3557: l_clm_delivery_event_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3558: l_clm_delivery_period PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3559: l_clm_delivery_period_uom PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3560: l_clm_pop_duration PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3561: l_clm_pop_duration_uom PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3554: l_clm_need_by_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
3555: l_source_prev_amend_id NUMBER; -- bug 13504088
3556: -- CLM - Event Based Delivery Project
3557: l_clm_delivery_event_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3558: l_clm_delivery_period PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3559: l_clm_delivery_period_uom PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3560: l_clm_pop_duration PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3561: l_clm_pop_duration_uom PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3562:
3555: l_source_prev_amend_id NUMBER; -- bug 13504088
3556: -- CLM - Event Based Delivery Project
3557: l_clm_delivery_event_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3558: l_clm_delivery_period PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3559: l_clm_delivery_period_uom PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3560: l_clm_pop_duration PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3561: l_clm_pop_duration_uom PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3562:
3563:
3556: -- CLM - Event Based Delivery Project
3557: l_clm_delivery_event_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3558: l_clm_delivery_period PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3559: l_clm_delivery_period_uom PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3560: l_clm_pop_duration PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3561: l_clm_pop_duration_uom PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3562:
3563:
3564: BEGIN
3557: l_clm_delivery_event_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3558: l_clm_delivery_period PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3559: l_clm_delivery_period_uom PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3560: l_clm_pop_duration PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3561: l_clm_pop_duration_uom PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3562:
3563:
3564: BEGIN
3565:
4814: p_copy_type IN VARCHAR2
4815: )
4816: IS
4817:
4818: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4819: l_attribute_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
4820: l_description PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
4821: l_datatype PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
4822: l_mandatory_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4815: )
4816: IS
4817:
4818: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4819: l_attribute_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
4820: l_description PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
4821: l_datatype PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
4822: l_mandatory_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4823: l_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
4816: IS
4817:
4818: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4819: l_attribute_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
4820: l_description PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
4821: l_datatype PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
4822: l_mandatory_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4823: l_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
4824: l_display_prompt PON_NEG_COPY_DATATYPES_GRP.VARCHAR100_TYPE;
4817:
4818: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4819: l_attribute_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
4820: l_description PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
4821: l_datatype PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
4822: l_mandatory_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4823: l_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
4824: l_display_prompt PON_NEG_COPY_DATATYPES_GRP.VARCHAR100_TYPE;
4825: l_help_text PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
4818: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4819: l_attribute_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
4820: l_description PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
4821: l_datatype PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
4822: l_mandatory_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4823: l_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
4824: l_display_prompt PON_NEG_COPY_DATATYPES_GRP.VARCHAR100_TYPE;
4825: l_help_text PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
4826: l_display_target_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4819: l_attribute_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
4820: l_description PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
4821: l_datatype PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
4822: l_mandatory_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4823: l_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
4824: l_display_prompt PON_NEG_COPY_DATATYPES_GRP.VARCHAR100_TYPE;
4825: l_help_text PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
4826: l_display_target_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4827: l_attribute_list_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4820: l_description PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
4821: l_datatype PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
4822: l_mandatory_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4823: l_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
4824: l_display_prompt PON_NEG_COPY_DATATYPES_GRP.VARCHAR100_TYPE;
4825: l_help_text PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
4826: l_display_target_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4827: l_attribute_list_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4828: l_display_only_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4821: l_datatype PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
4822: l_mandatory_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4823: l_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
4824: l_display_prompt PON_NEG_COPY_DATATYPES_GRP.VARCHAR100_TYPE;
4825: l_help_text PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
4826: l_display_target_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4827: l_attribute_list_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4828: l_display_only_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4829: l_sequence_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4822: l_mandatory_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4823: l_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
4824: l_display_prompt PON_NEG_COPY_DATATYPES_GRP.VARCHAR100_TYPE;
4825: l_help_text PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
4826: l_display_target_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4827: l_attribute_list_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4828: l_display_only_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4829: l_sequence_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4830: l_copied_from_cat_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4823: l_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
4824: l_display_prompt PON_NEG_COPY_DATATYPES_GRP.VARCHAR100_TYPE;
4825: l_help_text PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
4826: l_display_target_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4827: l_attribute_list_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4828: l_display_only_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4829: l_sequence_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4830: l_copied_from_cat_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4831: l_weight PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4824: l_display_prompt PON_NEG_COPY_DATATYPES_GRP.VARCHAR100_TYPE;
4825: l_help_text PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
4826: l_display_target_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4827: l_attribute_list_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4828: l_display_only_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4829: l_sequence_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4830: l_copied_from_cat_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4831: l_weight PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4832: l_scoring_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
4825: l_help_text PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
4826: l_display_target_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4827: l_attribute_list_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4828: l_display_only_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4829: l_sequence_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4830: l_copied_from_cat_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4831: l_weight PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4832: l_scoring_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
4833: l_attr_level PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
4826: l_display_target_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4827: l_attribute_list_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4828: l_display_only_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4829: l_sequence_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4830: l_copied_from_cat_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4831: l_weight PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4832: l_scoring_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
4833: l_attr_level PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
4834: l_attr_group PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
4827: l_attribute_list_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4828: l_display_only_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4829: l_sequence_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4830: l_copied_from_cat_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4831: l_weight PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4832: l_scoring_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
4833: l_attr_level PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
4834: l_attr_group PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
4835: l_attr_max_score PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4828: l_display_only_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4829: l_sequence_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4830: l_copied_from_cat_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4831: l_weight PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4832: l_scoring_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
4833: l_attr_level PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
4834: l_attr_group PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
4835: l_attr_max_score PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4836: l_internal_attr_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4829: l_sequence_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4830: l_copied_from_cat_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4831: l_weight PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4832: l_scoring_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
4833: l_attr_level PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
4834: l_attr_group PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
4835: l_attr_max_score PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4836: l_internal_attr_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4837: l_attr_group_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4830: l_copied_from_cat_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4831: l_weight PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4832: l_scoring_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
4833: l_attr_level PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
4834: l_attr_group PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
4835: l_attr_max_score PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4836: l_internal_attr_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4837: l_attr_group_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4838: l_attr_disp_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4831: l_weight PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4832: l_scoring_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
4833: l_attr_level PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
4834: l_attr_group PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
4835: l_attr_max_score PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4836: l_internal_attr_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4837: l_attr_group_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4838: l_attr_disp_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4839:
4832: l_scoring_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
4833: l_attr_level PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
4834: l_attr_group PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
4835: l_attr_max_score PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4836: l_internal_attr_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4837: l_attr_group_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4838: l_attr_disp_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4839:
4840: l_modified_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4833: l_attr_level PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
4834: l_attr_group PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
4835: l_attr_max_score PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4836: l_internal_attr_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4837: l_attr_group_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4838: l_attr_disp_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4839:
4840: l_modified_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4841: l_modified_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
4834: l_attr_group PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
4835: l_attr_max_score PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4836: l_internal_attr_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4837: l_attr_group_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4838: l_attr_disp_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4839:
4840: l_modified_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4841: l_modified_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
4842: l_last_amendment_update PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4836: l_internal_attr_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4837: l_attr_group_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4838: l_attr_disp_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4839:
4840: l_modified_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4841: l_modified_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
4842: l_last_amendment_update PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4843: l_ip_category_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4844: l_ip_descriptor_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4837: l_attr_group_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4838: l_attr_disp_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4839:
4840: l_modified_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4841: l_modified_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
4842: l_last_amendment_update PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4843: l_ip_category_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4844: l_ip_descriptor_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4845: l_is_obsolete_attribute PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4838: l_attr_disp_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4839:
4840: l_modified_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4841: l_modified_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
4842: l_last_amendment_update PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4843: l_ip_category_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4844: l_ip_descriptor_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4845: l_is_obsolete_attribute PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4846: l_section_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
4839:
4840: l_modified_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4841: l_modified_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
4842: l_last_amendment_update PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4843: l_ip_category_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4844: l_ip_descriptor_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4845: l_is_obsolete_attribute PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4846: l_section_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
4847: l_knockout_score PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4840: l_modified_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4841: l_modified_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
4842: l_last_amendment_update PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4843: l_ip_category_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4844: l_ip_descriptor_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4845: l_is_obsolete_attribute PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4846: l_section_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
4847: l_knockout_score PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4848: l_scoring_method PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
4841: l_modified_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
4842: l_last_amendment_update PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4843: l_ip_category_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4844: l_ip_descriptor_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4845: l_is_obsolete_attribute PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4846: l_section_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
4847: l_knockout_score PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4848: l_scoring_method PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
4849:
4842: l_last_amendment_update PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4843: l_ip_category_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4844: l_ip_descriptor_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4845: l_is_obsolete_attribute PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4846: l_section_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
4847: l_knockout_score PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4848: l_scoring_method PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
4849:
4850: l_has_inactv_hdr_attr_grp VARCHAR2(1);
4843: l_ip_category_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4844: l_ip_descriptor_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4845: l_is_obsolete_attribute PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4846: l_section_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
4847: l_knockout_score PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4848: l_scoring_method PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
4849:
4850: l_has_inactv_hdr_attr_grp VARCHAR2(1);
4851:
4844: l_ip_descriptor_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4845: l_is_obsolete_attribute PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4846: l_section_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
4847: l_knockout_score PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4848: l_scoring_method PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
4849:
4850: l_has_inactv_hdr_attr_grp VARCHAR2(1);
4851:
4852: l_contract_type PON_AUCTION_HEADERS_ALL.CONTRACT_TYPE%TYPE;
5089: p_to_line_number IN NUMBER
5090: )
5091: IS
5092:
5093: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5094: l_attribute_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
5095: l_description PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
5096: l_datatype PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
5097: l_mandatory_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
5090: )
5091: IS
5092:
5093: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5094: l_attribute_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
5095: l_description PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
5096: l_datatype PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
5097: l_mandatory_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
5098: l_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
5091: IS
5092:
5093: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5094: l_attribute_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
5095: l_description PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
5096: l_datatype PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
5097: l_mandatory_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
5098: l_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
5099: l_display_prompt PON_NEG_COPY_DATATYPES_GRP.VARCHAR100_TYPE;
5092:
5093: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5094: l_attribute_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
5095: l_description PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
5096: l_datatype PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
5097: l_mandatory_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
5098: l_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
5099: l_display_prompt PON_NEG_COPY_DATATYPES_GRP.VARCHAR100_TYPE;
5100: l_help_text PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
5093: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5094: l_attribute_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
5095: l_description PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
5096: l_datatype PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
5097: l_mandatory_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
5098: l_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
5099: l_display_prompt PON_NEG_COPY_DATATYPES_GRP.VARCHAR100_TYPE;
5100: l_help_text PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
5101: l_display_target_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
5094: l_attribute_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
5095: l_description PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
5096: l_datatype PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
5097: l_mandatory_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
5098: l_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
5099: l_display_prompt PON_NEG_COPY_DATATYPES_GRP.VARCHAR100_TYPE;
5100: l_help_text PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
5101: l_display_target_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
5102: l_attribute_list_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5095: l_description PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
5096: l_datatype PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
5097: l_mandatory_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
5098: l_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
5099: l_display_prompt PON_NEG_COPY_DATATYPES_GRP.VARCHAR100_TYPE;
5100: l_help_text PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
5101: l_display_target_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
5102: l_attribute_list_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5103: l_display_only_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
5096: l_datatype PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
5097: l_mandatory_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
5098: l_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
5099: l_display_prompt PON_NEG_COPY_DATATYPES_GRP.VARCHAR100_TYPE;
5100: l_help_text PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
5101: l_display_target_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
5102: l_attribute_list_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5103: l_display_only_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
5104: l_sequence_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5097: l_mandatory_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
5098: l_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
5099: l_display_prompt PON_NEG_COPY_DATATYPES_GRP.VARCHAR100_TYPE;
5100: l_help_text PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
5101: l_display_target_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
5102: l_attribute_list_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5103: l_display_only_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
5104: l_sequence_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5105: l_copied_from_cat_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
5098: l_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
5099: l_display_prompt PON_NEG_COPY_DATATYPES_GRP.VARCHAR100_TYPE;
5100: l_help_text PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
5101: l_display_target_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
5102: l_attribute_list_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5103: l_display_only_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
5104: l_sequence_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5105: l_copied_from_cat_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
5106: l_weight PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5099: l_display_prompt PON_NEG_COPY_DATATYPES_GRP.VARCHAR100_TYPE;
5100: l_help_text PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
5101: l_display_target_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
5102: l_attribute_list_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5103: l_display_only_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
5104: l_sequence_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5105: l_copied_from_cat_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
5106: l_weight PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5107: l_scoring_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
5100: l_help_text PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
5101: l_display_target_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
5102: l_attribute_list_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5103: l_display_only_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
5104: l_sequence_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5105: l_copied_from_cat_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
5106: l_weight PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5107: l_scoring_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
5108: l_attr_level PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
5101: l_display_target_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
5102: l_attribute_list_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5103: l_display_only_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
5104: l_sequence_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5105: l_copied_from_cat_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
5106: l_weight PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5107: l_scoring_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
5108: l_attr_level PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
5109: l_attr_group PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
5102: l_attribute_list_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5103: l_display_only_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
5104: l_sequence_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5105: l_copied_from_cat_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
5106: l_weight PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5107: l_scoring_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
5108: l_attr_level PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
5109: l_attr_group PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
5110: l_attr_max_score PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5103: l_display_only_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
5104: l_sequence_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5105: l_copied_from_cat_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
5106: l_weight PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5107: l_scoring_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
5108: l_attr_level PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
5109: l_attr_group PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
5110: l_attr_max_score PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5111: l_internal_attr_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
5104: l_sequence_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5105: l_copied_from_cat_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
5106: l_weight PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5107: l_scoring_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
5108: l_attr_level PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
5109: l_attr_group PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
5110: l_attr_max_score PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5111: l_internal_attr_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
5112: l_attr_group_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5105: l_copied_from_cat_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
5106: l_weight PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5107: l_scoring_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
5108: l_attr_level PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
5109: l_attr_group PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
5110: l_attr_max_score PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5111: l_internal_attr_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
5112: l_attr_group_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5113: l_attr_disp_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5106: l_weight PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5107: l_scoring_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
5108: l_attr_level PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
5109: l_attr_group PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
5110: l_attr_max_score PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5111: l_internal_attr_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
5112: l_attr_group_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5113: l_attr_disp_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5114:
5107: l_scoring_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
5108: l_attr_level PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
5109: l_attr_group PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
5110: l_attr_max_score PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5111: l_internal_attr_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
5112: l_attr_group_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5113: l_attr_disp_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5114:
5115: l_modified_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
5108: l_attr_level PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
5109: l_attr_group PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
5110: l_attr_max_score PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5111: l_internal_attr_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
5112: l_attr_group_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5113: l_attr_disp_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5114:
5115: l_modified_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
5116: l_modified_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
5109: l_attr_group PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
5110: l_attr_max_score PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5111: l_internal_attr_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
5112: l_attr_group_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5113: l_attr_disp_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5114:
5115: l_modified_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
5116: l_modified_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
5117: l_last_amendment_update PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5111: l_internal_attr_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
5112: l_attr_group_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5113: l_attr_disp_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5114:
5115: l_modified_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
5116: l_modified_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
5117: l_last_amendment_update PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5118: l_ip_category_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5119: l_ip_descriptor_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5112: l_attr_group_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5113: l_attr_disp_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5114:
5115: l_modified_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
5116: l_modified_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
5117: l_last_amendment_update PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5118: l_ip_category_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5119: l_ip_descriptor_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5120: l_is_obsolete_attribute PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
5113: l_attr_disp_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5114:
5115: l_modified_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
5116: l_modified_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
5117: l_last_amendment_update PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5118: l_ip_category_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5119: l_ip_descriptor_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5120: l_is_obsolete_attribute PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
5121: l_section_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
5114:
5115: l_modified_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
5116: l_modified_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
5117: l_last_amendment_update PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5118: l_ip_category_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5119: l_ip_descriptor_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5120: l_is_obsolete_attribute PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
5121: l_section_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
5122: l_knockout_score PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5115: l_modified_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
5116: l_modified_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
5117: l_last_amendment_update PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5118: l_ip_category_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5119: l_ip_descriptor_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5120: l_is_obsolete_attribute PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
5121: l_section_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
5122: l_knockout_score PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5123: l_scoring_method PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
5116: l_modified_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
5117: l_last_amendment_update PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5118: l_ip_category_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5119: l_ip_descriptor_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5120: l_is_obsolete_attribute PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
5121: l_section_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
5122: l_knockout_score PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5123: l_scoring_method PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
5124:
5117: l_last_amendment_update PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5118: l_ip_category_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5119: l_ip_descriptor_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5120: l_is_obsolete_attribute PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
5121: l_section_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
5122: l_knockout_score PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5123: l_scoring_method PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
5124:
5125: l_val1 VARCHAR2(300) := NULL;
5118: l_ip_category_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5119: l_ip_descriptor_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5120: l_is_obsolete_attribute PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
5121: l_section_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
5122: l_knockout_score PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5123: l_scoring_method PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
5124:
5125: l_val1 VARCHAR2(300) := NULL;
5126: l_val2 VARCHAR2(300) := NULL;
5119: l_ip_descriptor_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5120: l_is_obsolete_attribute PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
5121: l_section_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
5122: l_knockout_score PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5123: l_scoring_method PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
5124:
5125: l_val1 VARCHAR2(300) := NULL;
5126: l_val2 VARCHAR2(300) := NULL;
5127: l_val3 VARCHAR2(300) := NULL;
6302: p_org_id IN NUMBER,
6303: p_round_number IN NUMBER
6304: )
6305: IS
6306: l_list_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6307: l_sequence PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6308: l_trading_partner_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6309: l_trading_partner_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6310: l_trading_partner_contact_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6303: p_round_number IN NUMBER
6304: )
6305: IS
6306: l_list_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6307: l_sequence PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6308: l_trading_partner_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6309: l_trading_partner_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6310: l_trading_partner_contact_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6311: l_trading_partner_contact_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6304: )
6305: IS
6306: l_list_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6307: l_sequence PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6308: l_trading_partner_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6309: l_trading_partner_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6310: l_trading_partner_contact_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6311: l_trading_partner_contact_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6312: l_new_supplier_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6305: IS
6306: l_list_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6307: l_sequence PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6308: l_trading_partner_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6309: l_trading_partner_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6310: l_trading_partner_contact_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6311: l_trading_partner_contact_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6312: l_new_supplier_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6313: l_new_supplier_contact_fname PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6306: l_list_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6307: l_sequence PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6308: l_trading_partner_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6309: l_trading_partner_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6310: l_trading_partner_contact_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6311: l_trading_partner_contact_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6312: l_new_supplier_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6313: l_new_supplier_contact_fname PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6314: l_new_supplier_contact_lname PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6307: l_sequence PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6308: l_trading_partner_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6309: l_trading_partner_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6310: l_trading_partner_contact_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6311: l_trading_partner_contact_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6312: l_new_supplier_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6313: l_new_supplier_contact_fname PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6314: l_new_supplier_contact_lname PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6315: l_new_supplier_email PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6308: l_trading_partner_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6309: l_trading_partner_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6310: l_trading_partner_contact_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6311: l_trading_partner_contact_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6312: l_new_supplier_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6313: l_new_supplier_contact_fname PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6314: l_new_supplier_contact_lname PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6315: l_new_supplier_email PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6316: l_note_to_new_supplier PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6309: l_trading_partner_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6310: l_trading_partner_contact_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6311: l_trading_partner_contact_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6312: l_new_supplier_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6313: l_new_supplier_contact_fname PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6314: l_new_supplier_contact_lname PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6315: l_new_supplier_email PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6316: l_note_to_new_supplier PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6317: l_wf_user_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
6310: l_trading_partner_contact_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6311: l_trading_partner_contact_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6312: l_new_supplier_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6313: l_new_supplier_contact_fname PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6314: l_new_supplier_contact_lname PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6315: l_new_supplier_email PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6316: l_note_to_new_supplier PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6317: l_wf_user_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
6318: l_invitation_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6311: l_trading_partner_contact_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6312: l_new_supplier_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6313: l_new_supplier_contact_fname PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6314: l_new_supplier_contact_lname PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6315: l_new_supplier_email PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6316: l_note_to_new_supplier PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6317: l_wf_user_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
6318: l_invitation_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6319: l_auction_creation_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
6312: l_new_supplier_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6313: l_new_supplier_contact_fname PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6314: l_new_supplier_contact_lname PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6315: l_new_supplier_email PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6316: l_note_to_new_supplier PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6317: l_wf_user_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
6318: l_invitation_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6319: l_auction_creation_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
6320: l_bid_currency_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
6313: l_new_supplier_contact_fname PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6314: l_new_supplier_contact_lname PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6315: l_new_supplier_email PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6316: l_note_to_new_supplier PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6317: l_wf_user_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
6318: l_invitation_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6319: l_auction_creation_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
6320: l_bid_currency_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
6321: l_number_price_decimals PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6314: l_new_supplier_contact_lname PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6315: l_new_supplier_email PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6316: l_note_to_new_supplier PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6317: l_wf_user_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
6318: l_invitation_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6319: l_auction_creation_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
6320: l_bid_currency_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
6321: l_number_price_decimals PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6322: l_rate PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6315: l_new_supplier_email PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6316: l_note_to_new_supplier PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6317: l_wf_user_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
6318: l_invitation_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6319: l_auction_creation_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
6320: l_bid_currency_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
6321: l_number_price_decimals PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6322: l_rate PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6323: l_derive_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
6316: l_note_to_new_supplier PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6317: l_wf_user_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
6318: l_invitation_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6319: l_auction_creation_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
6320: l_bid_currency_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
6321: l_number_price_decimals PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6322: l_rate PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6323: l_derive_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
6324: l_additional_contact_email PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6317: l_wf_user_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
6318: l_invitation_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6319: l_auction_creation_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
6320: l_bid_currency_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
6321: l_number_price_decimals PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6322: l_rate PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6323: l_derive_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
6324: l_additional_contact_email PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6325: l_round_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6318: l_invitation_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6319: l_auction_creation_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
6320: l_bid_currency_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
6321: l_number_price_decimals PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6322: l_rate PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6323: l_derive_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
6324: l_additional_contact_email PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6325: l_round_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6326: l_supp_acknowledgement PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
6319: l_auction_creation_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
6320: l_bid_currency_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
6321: l_number_price_decimals PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6322: l_rate PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6323: l_derive_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
6324: l_additional_contact_email PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6325: l_round_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6326: l_supp_acknowledgement PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
6327: l_ack_partner_contact_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6320: l_bid_currency_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
6321: l_number_price_decimals PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6322: l_rate PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6323: l_derive_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
6324: l_additional_contact_email PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6325: l_round_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6326: l_supp_acknowledgement PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
6327: l_ack_partner_contact_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6328: l_acknowledgement_time PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
6321: l_number_price_decimals PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6322: l_rate PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6323: l_derive_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
6324: l_additional_contact_email PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6325: l_round_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6326: l_supp_acknowledgement PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
6327: l_ack_partner_contact_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6328: l_acknowledgement_time PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
6329: l_ack_note_to_auctioneer PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
6322: l_rate PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6323: l_derive_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
6324: l_additional_contact_email PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6325: l_round_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6326: l_supp_acknowledgement PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
6327: l_ack_partner_contact_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6328: l_acknowledgement_time PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
6329: l_ack_note_to_auctioneer PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
6330: l_registration_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6323: l_derive_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
6324: l_additional_contact_email PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6325: l_round_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6326: l_supp_acknowledgement PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
6327: l_ack_partner_contact_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6328: l_acknowledgement_time PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
6329: l_ack_note_to_auctioneer PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
6330: l_registration_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6331: l_rate_dsp PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6324: l_additional_contact_email PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6325: l_round_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6326: l_supp_acknowledgement PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
6327: l_ack_partner_contact_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6328: l_acknowledgement_time PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
6329: l_ack_note_to_auctioneer PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
6330: l_registration_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6331: l_rate_dsp PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6332: l_vendor_site_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6325: l_round_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6326: l_supp_acknowledgement PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
6327: l_ack_partner_contact_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6328: l_acknowledgement_time PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
6329: l_ack_note_to_auctioneer PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
6330: l_registration_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6331: l_rate_dsp PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6332: l_vendor_site_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6333: l_vendor_site_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
6326: l_supp_acknowledgement PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
6327: l_ack_partner_contact_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6328: l_acknowledgement_time PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
6329: l_ack_note_to_auctioneer PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
6330: l_registration_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6331: l_rate_dsp PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6332: l_vendor_site_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6333: l_vendor_site_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
6334: l_last_amendment_update PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6327: l_ack_partner_contact_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6328: l_acknowledgement_time PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
6329: l_ack_note_to_auctioneer PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
6330: l_registration_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6331: l_rate_dsp PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6332: l_vendor_site_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6333: l_vendor_site_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
6334: l_last_amendment_update PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6335: l_modified_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
6328: l_acknowledgement_time PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
6329: l_ack_note_to_auctioneer PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
6330: l_registration_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6331: l_rate_dsp PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6332: l_vendor_site_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6333: l_vendor_site_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
6334: l_last_amendment_update PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6335: l_modified_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
6336: -- Lot based bidding project related column
6329: l_ack_note_to_auctioneer PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
6330: l_registration_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6331: l_rate_dsp PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6332: l_vendor_site_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6333: l_vendor_site_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
6334: l_last_amendment_update PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6335: l_modified_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
6336: -- Lot based bidding project related column
6337: l_access_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
6330: l_registration_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6331: l_rate_dsp PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6332: l_vendor_site_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6333: l_vendor_site_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
6334: l_last_amendment_update PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6335: l_modified_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
6336: -- Lot based bidding project related column
6337: l_access_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
6338: l_auction_round_number NUMBER := 0;
6331: l_rate_dsp PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6332: l_vendor_site_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6333: l_vendor_site_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
6334: l_last_amendment_update PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6335: l_modified_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
6336: -- Lot based bidding project related column
6337: l_access_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
6338: l_auction_round_number NUMBER := 0;
6339: -- New Suppleir Registration changes
6333: l_vendor_site_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
6334: l_last_amendment_update PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6335: l_modified_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
6336: -- Lot based bidding project related column
6337: l_access_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
6338: l_auction_round_number NUMBER := 0;
6339: -- New Suppleir Registration changes
6340: l_requested_supplier_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6341: l_requested_supplier_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6336: -- Lot based bidding project related column
6337: l_access_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
6338: l_auction_round_number NUMBER := 0;
6339: -- New Suppleir Registration changes
6340: l_requested_supplier_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6341: l_requested_supplier_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6342: l_requested_supp_contact_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6343: l_requested_supp_contact_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6344: -- warning for inactive suppliers
6337: l_access_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
6338: l_auction_round_number NUMBER := 0;
6339: -- New Suppleir Registration changes
6340: l_requested_supplier_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6341: l_requested_supplier_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6342: l_requested_supp_contact_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6343: l_requested_supp_contact_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6344: -- warning for inactive suppliers
6345: l_inactive_suppliers PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6338: l_auction_round_number NUMBER := 0;
6339: -- New Suppleir Registration changes
6340: l_requested_supplier_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6341: l_requested_supplier_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6342: l_requested_supp_contact_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6343: l_requested_supp_contact_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6344: -- warning for inactive suppliers
6345: l_inactive_suppliers PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6346: l_supplier_names VARCHAR2(2000);
6339: -- New Suppleir Registration changes
6340: l_requested_supplier_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6341: l_requested_supplier_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6342: l_requested_supp_contact_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6343: l_requested_supp_contact_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6344: -- warning for inactive suppliers
6345: l_inactive_suppliers PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6346: l_supplier_names VARCHAR2(2000);
6347: l_last_seq_number NUMBER;
6341: l_requested_supplier_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6342: l_requested_supp_contact_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6343: l_requested_supp_contact_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6344: -- warning for inactive suppliers
6345: l_inactive_suppliers PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6346: l_supplier_names VARCHAR2(2000);
6347: l_last_seq_number NUMBER;
6348: l_from_emd_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE; -- Added by Lion for EMD 04/02/2009
6349: -- bug 7376924, handling inactive supplier contact
6344: -- warning for inactive suppliers
6345: l_inactive_suppliers PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6346: l_supplier_names VARCHAR2(2000);
6347: l_last_seq_number NUMBER;
6348: l_from_emd_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE; -- Added by Lion for EMD 04/02/2009
6349: -- bug 7376924, handling inactive supplier contact
6350: l_inactive_supplier_contacts PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6351:
6352: l_auction_header_id_orig_amend PON_AUCTION_HEADERS_ALL.AUCTION_HEADER_ID_ORIG_AMEND%type;
6346: l_supplier_names VARCHAR2(2000);
6347: l_last_seq_number NUMBER;
6348: l_from_emd_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE; -- Added by Lion for EMD 04/02/2009
6349: -- bug 7376924, handling inactive supplier contact
6350: l_inactive_supplier_contacts PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6351:
6352: l_auction_header_id_orig_amend PON_AUCTION_HEADERS_ALL.AUCTION_HEADER_ID_ORIG_AMEND%type;
6353:
6354: BEGIN
7270: p_user_name IN VARCHAR2,
7271: p_mgr_id IN NUMBER
7272: )
7273: IS
7274: l_list_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7275: l_user_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7276: l_menu_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
7277: l_member_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
7278: l_approver_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
7271: p_mgr_id IN NUMBER
7272: )
7273: IS
7274: l_list_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7275: l_user_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7276: l_menu_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
7277: l_member_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
7278: l_approver_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
7279: l_approval_status PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
7272: )
7273: IS
7274: l_list_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7275: l_user_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7276: l_menu_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
7277: l_member_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
7278: l_approver_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
7279: l_approval_status PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
7280: l_task_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
7273: IS
7274: l_list_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7275: l_user_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7276: l_menu_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
7277: l_member_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
7278: l_approver_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
7279: l_approval_status PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
7280: l_task_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
7281: l_target_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
7274: l_list_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7275: l_user_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7276: l_menu_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
7277: l_member_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
7278: l_approver_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
7279: l_approval_status PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
7280: l_task_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
7281: l_target_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
7282: l_completion_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
7275: l_user_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7276: l_menu_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
7277: l_member_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
7278: l_approver_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
7279: l_approval_status PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
7280: l_task_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
7281: l_target_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
7282: l_completion_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
7283: l_business_group_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7276: l_menu_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
7277: l_member_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
7278: l_approver_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
7279: l_approval_status PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
7280: l_task_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
7281: l_target_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
7282: l_completion_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
7283: l_business_group_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7284: l_effective_start_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
7277: l_member_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
7278: l_approver_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
7279: l_approval_status PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
7280: l_task_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
7281: l_target_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
7282: l_completion_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
7283: l_business_group_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7284: l_effective_start_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
7285: l_effective_end_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
7278: l_approver_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
7279: l_approval_status PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
7280: l_task_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
7281: l_target_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
7282: l_completion_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
7283: l_business_group_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7284: l_effective_start_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
7285: l_effective_end_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
7286: l_user_start_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
7279: l_approval_status PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
7280: l_task_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
7281: l_target_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
7282: l_completion_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
7283: l_business_group_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7284: l_effective_start_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
7285: l_effective_end_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
7286: l_user_start_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
7287: l_user_end_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
7280: l_task_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
7281: l_target_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
7282: l_completion_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
7283: l_business_group_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7284: l_effective_start_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
7285: l_effective_end_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
7286: l_user_start_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
7287: l_user_end_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
7288: l_last_amendment_update PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7281: l_target_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
7282: l_completion_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
7283: l_business_group_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7284: l_effective_start_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
7285: l_effective_end_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
7286: l_user_start_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
7287: l_user_end_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
7288: l_last_amendment_update PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7289: l_modified_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
7282: l_completion_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
7283: l_business_group_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7284: l_effective_start_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
7285: l_effective_end_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
7286: l_user_start_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
7287: l_user_end_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
7288: l_last_amendment_update PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7289: l_modified_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
7290: l_auc_business_group_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7283: l_business_group_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7284: l_effective_start_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
7285: l_effective_end_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
7286: l_user_start_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
7287: l_user_end_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
7288: l_last_amendment_update PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7289: l_modified_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
7290: l_auc_business_group_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7291: l_full_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
7284: l_effective_start_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
7285: l_effective_end_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
7286: l_user_start_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
7287: l_user_end_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
7288: l_last_amendment_update PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7289: l_modified_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
7290: l_auc_business_group_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7291: l_full_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
7292: l_last_notif_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
7285: l_effective_end_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
7286: l_user_start_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
7287: l_user_end_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
7288: l_last_amendment_update PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7289: l_modified_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
7290: l_auc_business_group_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7291: l_full_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
7292: l_last_notif_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
7293: l_is_creator_included BOOLEAN := FALSE;
7286: l_user_start_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
7287: l_user_end_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
7288: l_last_amendment_update PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7289: l_modified_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
7290: l_auc_business_group_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7291: l_full_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
7292: l_last_notif_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
7293: l_is_creator_included BOOLEAN := FALSE;
7294: l_is_manager_included BOOLEAN := FALSE;
7287: l_user_end_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
7288: l_last_amendment_update PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7289: l_modified_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
7290: l_auc_business_group_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7291: l_full_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
7292: l_last_notif_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
7293: l_is_creator_included BOOLEAN := FALSE;
7294: l_is_manager_included BOOLEAN := FALSE;
7295: l_count NUMBER;
7288: l_last_amendment_update PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7289: l_modified_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
7290: l_auc_business_group_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7291: l_full_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
7292: l_last_notif_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
7293: l_is_creator_included BOOLEAN := FALSE;
7294: l_is_manager_included BOOLEAN := FALSE;
7295: l_count NUMBER;
7296: l_inactive_mem VARCHAR2(4000);
9285: l_max_line_number NUMBER := NULL;
9286: l_batch_end NUMBER := NULL;
9287: l_batch_start NUMBER := NULL;
9288:
9289: l_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR100_TYPE;
9290: l_inactive_pe_name VARCHAR2(4000);
9291: l_return_status VARCHAR2(1);
9292: l_batch_size NUMBER;
9293: l_last_line_number NUMBER;
10456: p_auction_header_id IN NUMBER,
10457: p_user_id IN NUMBER,
10458: p_retain_clauses IN VARCHAR2)
10459: IS
10460: l_exhibit_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
10461: l_iscdrl PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
10462: l_associatedline PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
10463: l_exhibit_description PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
10464: BEGIN
10457: p_user_id IN NUMBER,
10458: p_retain_clauses IN VARCHAR2)
10459: IS
10460: l_exhibit_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
10461: l_iscdrl PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
10462: l_associatedline PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
10463: l_exhibit_description PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
10464: BEGIN
10465: /*SELECT
10458: p_retain_clauses IN VARCHAR2)
10459: IS
10460: l_exhibit_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
10461: l_iscdrl PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
10462: l_associatedline PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
10463: l_exhibit_description PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
10464: BEGIN
10465: /*SELECT
10466: EXHIBIT_NUMBER,
10459: IS
10460: l_exhibit_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
10461: l_iscdrl PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
10462: l_associatedline PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
10463: l_exhibit_description PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
10464: BEGIN
10465: /*SELECT
10466: EXHIBIT_NUMBER,
10467: IS_CDRL,