APPS.PON_NEGOTIATION_COPY_GRP dependencies on PON_NEG_COPY_DATATYPES_GRP

Line 2616: l_amendment_update PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

2612: p_to_line_number IN NUMBER
2613: )
2614: --{
2615: IS
2616: l_amendment_update PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2617: l_disp_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2618:
2619: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2620: l_item_description PON_NEG_COPY_DATATYPES_GRP.VARCHAR2500_TYPE;

Line 2617: l_disp_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

2613: )
2614: --{
2615: IS
2616: l_amendment_update PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2617: l_disp_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2618:
2619: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2620: l_item_description PON_NEG_COPY_DATATYPES_GRP.VARCHAR2500_TYPE;
2621: l_category_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 2619: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

2615: IS
2616: l_amendment_update PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2617: l_disp_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2618:
2619: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2620: l_item_description PON_NEG_COPY_DATATYPES_GRP.VARCHAR2500_TYPE;
2621: l_category_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2622: l_category_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
2623: l_ip_category_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 2620: l_item_description PON_NEG_COPY_DATATYPES_GRP.VARCHAR2500_TYPE;

2616: l_amendment_update PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2617: l_disp_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2618:
2619: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2620: l_item_description PON_NEG_COPY_DATATYPES_GRP.VARCHAR2500_TYPE;
2621: l_category_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2622: l_category_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
2623: l_ip_category_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2624: l_uom_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;

Line 2621: l_category_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

2617: l_disp_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2618:
2619: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2620: l_item_description PON_NEG_COPY_DATATYPES_GRP.VARCHAR2500_TYPE;
2621: l_category_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2622: l_category_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
2623: l_ip_category_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2624: l_uom_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
2625: l_quantity PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 2622: l_category_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;

2618:
2619: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2620: l_item_description PON_NEG_COPY_DATATYPES_GRP.VARCHAR2500_TYPE;
2621: l_category_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2622: l_category_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
2623: l_ip_category_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2624: l_uom_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
2625: l_quantity PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2626: l_need_by_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE; -- need to change?

Line 2623: l_ip_category_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

2619: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2620: l_item_description PON_NEG_COPY_DATATYPES_GRP.VARCHAR2500_TYPE;
2621: l_category_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2622: l_category_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
2623: l_ip_category_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2624: l_uom_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
2625: l_quantity PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2626: l_need_by_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE; -- need to change?
2627: l_ship_to_location_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 2624: l_uom_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;

2620: l_item_description PON_NEG_COPY_DATATYPES_GRP.VARCHAR2500_TYPE;
2621: l_category_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2622: l_category_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
2623: l_ip_category_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2624: l_uom_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
2625: l_quantity PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2626: l_need_by_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE; -- need to change?
2627: l_ship_to_location_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2628: l_target_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 2625: l_quantity PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

2621: l_category_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2622: l_category_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
2623: l_ip_category_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2624: l_uom_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
2625: l_quantity PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2626: l_need_by_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE; -- need to change?
2627: l_ship_to_location_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2628: l_target_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2629: l_threshold_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 2626: l_need_by_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE; -- need to change?

2622: l_category_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
2623: l_ip_category_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2624: l_uom_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
2625: l_quantity PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2626: l_need_by_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE; -- need to change?
2627: l_ship_to_location_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2628: l_target_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2629: l_threshold_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2630: l_bid_start_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 2627: l_ship_to_location_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

2623: l_ip_category_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2624: l_uom_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
2625: l_quantity PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2626: l_need_by_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE; -- need to change?
2627: l_ship_to_location_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2628: l_target_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2629: l_threshold_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2630: l_bid_start_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2631: l_note_to_bidders PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;

Line 2628: l_target_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

2624: l_uom_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
2625: l_quantity PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2626: l_need_by_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE; -- need to change?
2627: l_ship_to_location_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2628: l_target_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2629: l_threshold_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2630: l_bid_start_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2631: l_note_to_bidders PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
2632: l_attachment_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

Line 2629: l_threshold_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

2625: l_quantity PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2626: l_need_by_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE; -- need to change?
2627: l_ship_to_location_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2628: l_target_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2629: l_threshold_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2630: l_bid_start_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2631: l_note_to_bidders PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
2632: l_attachment_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2633: l_language_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;

Line 2630: l_bid_start_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

2626: l_need_by_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE; -- need to change?
2627: l_ship_to_location_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2628: l_target_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2629: l_threshold_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2630: l_bid_start_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2631: l_note_to_bidders PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
2632: l_attachment_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2633: l_language_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
2634: l_reserve_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 2631: l_note_to_bidders PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;

2627: l_ship_to_location_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2628: l_target_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2629: l_threshold_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2630: l_bid_start_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2631: l_note_to_bidders PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
2632: l_attachment_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2633: l_language_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
2634: l_reserve_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2635: l_display_target_price_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

Line 2632: l_attachment_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

2628: l_target_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2629: l_threshold_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2630: l_bid_start_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2631: l_note_to_bidders PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
2632: l_attachment_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2633: l_language_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
2634: l_reserve_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2635: l_display_target_price_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2636: l_current_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 2633: l_language_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;

2629: l_threshold_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2630: l_bid_start_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2631: l_note_to_bidders PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
2632: l_attachment_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2633: l_language_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
2634: l_reserve_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2635: l_display_target_price_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2636: l_current_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2637: l_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;

Line 2634: l_reserve_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

2630: l_bid_start_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2631: l_note_to_bidders PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
2632: l_attachment_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2633: l_language_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
2634: l_reserve_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2635: l_display_target_price_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2636: l_current_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2637: l_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
2638: l_lot_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 2635: l_display_target_price_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

2631: l_note_to_bidders PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
2632: l_attachment_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2633: l_language_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
2634: l_reserve_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2635: l_display_target_price_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2636: l_current_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2637: l_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
2638: l_lot_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2639: l_min_bid_increment PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 2636: l_current_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

2632: l_attachment_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2633: l_language_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
2634: l_reserve_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2635: l_display_target_price_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2636: l_current_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2637: l_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
2638: l_lot_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2639: l_min_bid_increment PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2640: l_min_bid_decrement PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 2637: l_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;

2633: l_language_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
2634: l_reserve_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2635: l_display_target_price_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2636: l_current_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2637: l_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
2638: l_lot_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2639: l_min_bid_increment PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2640: l_min_bid_decrement PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2641: l_unit_of_measure PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

Line 2638: l_lot_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

2634: l_reserve_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2635: l_display_target_price_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2636: l_current_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2637: l_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
2638: l_lot_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2639: l_min_bid_increment PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2640: l_min_bid_decrement PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2641: l_unit_of_measure PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2642: l_po_min_rel_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 2639: l_min_bid_increment PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

2635: l_display_target_price_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2636: l_current_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2637: l_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
2638: l_lot_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2639: l_min_bid_increment PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2640: l_min_bid_decrement PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2641: l_unit_of_measure PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2642: l_po_min_rel_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2643: l_has_attributes_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

Line 2640: l_min_bid_decrement PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

2636: l_current_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2637: l_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
2638: l_lot_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2639: l_min_bid_increment PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2640: l_min_bid_decrement PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2641: l_unit_of_measure PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2642: l_po_min_rel_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2643: l_has_attributes_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2644: l_transportation_origin PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;

Line 2641: l_unit_of_measure PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

2637: l_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
2638: l_lot_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2639: l_min_bid_increment PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2640: l_min_bid_decrement PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2641: l_unit_of_measure PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2642: l_po_min_rel_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2643: l_has_attributes_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2644: l_transportation_origin PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
2645: l_transportation_dest PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;

Line 2642: l_po_min_rel_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

2638: l_lot_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2639: l_min_bid_increment PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2640: l_min_bid_decrement PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2641: l_unit_of_measure PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2642: l_po_min_rel_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2643: l_has_attributes_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2644: l_transportation_origin PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
2645: l_transportation_dest PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
2646: l_multiple_prices_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

Line 2643: l_has_attributes_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

2639: l_min_bid_increment PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2640: l_min_bid_decrement PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2641: l_unit_of_measure PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2642: l_po_min_rel_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2643: l_has_attributes_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2644: l_transportation_origin PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
2645: l_transportation_dest PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
2646: l_multiple_prices_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2647: l_tbd_pricing_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

Line 2644: l_transportation_origin PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;

2640: l_min_bid_decrement PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2641: l_unit_of_measure PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2642: l_po_min_rel_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2643: l_has_attributes_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2644: l_transportation_origin PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
2645: l_transportation_dest PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
2646: l_multiple_prices_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2647: l_tbd_pricing_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2648: l_need_by_start_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;

Line 2645: l_transportation_dest PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;

2641: l_unit_of_measure PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2642: l_po_min_rel_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2643: l_has_attributes_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2644: l_transportation_origin PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
2645: l_transportation_dest PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
2646: l_multiple_prices_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2647: l_tbd_pricing_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2648: l_need_by_start_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
2649: l_modified_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

Line 2646: l_multiple_prices_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

2642: l_po_min_rel_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2643: l_has_attributes_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2644: l_transportation_origin PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
2645: l_transportation_dest PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
2646: l_multiple_prices_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2647: l_tbd_pricing_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2648: l_need_by_start_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
2649: l_modified_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2650: l_freight_terms_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

Line 2647: l_tbd_pricing_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

2643: l_has_attributes_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2644: l_transportation_origin PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
2645: l_transportation_dest PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
2646: l_multiple_prices_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2647: l_tbd_pricing_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2648: l_need_by_start_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
2649: l_modified_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2650: l_freight_terms_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2651: l_org_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 2648: l_need_by_start_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;

2644: l_transportation_origin PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
2645: l_transportation_dest PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
2646: l_multiple_prices_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2647: l_tbd_pricing_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2648: l_need_by_start_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
2649: l_modified_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2650: l_freight_terms_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2651: l_org_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2652: l_has_price_elements_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;

Line 2649: l_modified_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

2645: l_transportation_dest PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
2646: l_multiple_prices_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2647: l_tbd_pricing_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2648: l_need_by_start_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
2649: l_modified_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2650: l_freight_terms_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2651: l_org_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2652: l_has_price_elements_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
2653: l_line_type_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 2650: l_freight_terms_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

2646: l_multiple_prices_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2647: l_tbd_pricing_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2648: l_need_by_start_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
2649: l_modified_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2650: l_freight_terms_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2651: l_org_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2652: l_has_price_elements_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
2653: l_line_type_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2654: l_order_type_lookup_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

Line 2651: l_org_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

2647: l_tbd_pricing_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2648: l_need_by_start_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
2649: l_modified_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2650: l_freight_terms_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2651: l_org_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2652: l_has_price_elements_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
2653: l_line_type_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2654: l_order_type_lookup_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2655: l_line_origination_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

Line 2652: l_has_price_elements_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;

2648: l_need_by_start_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
2649: l_modified_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2650: l_freight_terms_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2651: l_org_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2652: l_has_price_elements_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
2653: l_line_type_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2654: l_order_type_lookup_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2655: l_line_origination_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2656: l_requisition_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;

Line 2653: l_line_type_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

2649: l_modified_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2650: l_freight_terms_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2651: l_org_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2652: l_has_price_elements_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
2653: l_line_type_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2654: l_order_type_lookup_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2655: l_line_origination_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2656: l_requisition_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
2657: l_item_revision PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;

Line 2654: l_order_type_lookup_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

2650: l_freight_terms_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2651: l_org_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2652: l_has_price_elements_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
2653: l_line_type_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2654: l_order_type_lookup_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2655: l_line_origination_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2656: l_requisition_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
2657: l_item_revision PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
2658: l_item_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 2655: l_line_origination_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

2651: l_org_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2652: l_has_price_elements_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
2653: l_line_type_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2654: l_order_type_lookup_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2655: l_line_origination_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2656: l_requisition_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
2657: l_item_revision PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
2658: l_item_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2659: l_item_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR1000_TYPE;

Line 2656: l_requisition_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;

2652: l_has_price_elements_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
2653: l_line_type_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2654: l_order_type_lookup_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2655: l_line_origination_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2656: l_requisition_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
2657: l_item_revision PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
2658: l_item_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2659: l_item_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR1000_TYPE;
2660: l_price_break_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

Line 2657: l_item_revision PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;

2653: l_line_type_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2654: l_order_type_lookup_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2655: l_line_origination_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2656: l_requisition_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
2657: l_item_revision PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
2658: l_item_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2659: l_item_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR1000_TYPE;
2660: l_price_break_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2661: l_price_break_neg_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

Line 2658: l_item_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

2654: l_order_type_lookup_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2655: l_line_origination_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2656: l_requisition_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
2657: l_item_revision PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
2658: l_item_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2659: l_item_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR1000_TYPE;
2660: l_price_break_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2661: l_price_break_neg_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2662: l_has_shipments_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

Line 2659: l_item_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR1000_TYPE;

2655: l_line_origination_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2656: l_requisition_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
2657: l_item_revision PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
2658: l_item_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2659: l_item_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR1000_TYPE;
2660: l_price_break_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2661: l_price_break_neg_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2662: l_has_shipments_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2663: l_source_doc_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;

Line 2660: l_price_break_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

2656: l_requisition_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
2657: l_item_revision PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
2658: l_item_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2659: l_item_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR1000_TYPE;
2660: l_price_break_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2661: l_price_break_neg_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2662: l_has_shipments_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2663: l_source_doc_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
2664: l_source_line_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;

Line 2661: l_price_break_neg_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

2657: l_item_revision PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
2658: l_item_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2659: l_item_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR1000_TYPE;
2660: l_price_break_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2661: l_price_break_neg_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2662: l_has_shipments_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2663: l_source_doc_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
2664: l_source_line_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
2665: l_souce_doc_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 2662: l_has_shipments_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

2658: l_item_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2659: l_item_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR1000_TYPE;
2660: l_price_break_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2661: l_price_break_neg_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2662: l_has_shipments_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2663: l_source_doc_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
2664: l_source_line_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
2665: l_souce_doc_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2666: l_source_line_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 2663: l_source_doc_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;

2659: l_item_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR1000_TYPE;
2660: l_price_break_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2661: l_price_break_neg_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2662: l_has_shipments_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2663: l_source_doc_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
2664: l_source_line_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
2665: l_souce_doc_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2666: l_source_line_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2667: l_price_disabled_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

Line 2664: l_source_line_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;

2660: l_price_break_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2661: l_price_break_neg_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2662: l_has_shipments_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2663: l_source_doc_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
2664: l_source_line_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
2665: l_souce_doc_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2666: l_source_line_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2667: l_price_disabled_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2668: l_quantity_disabled_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

Line 2665: l_souce_doc_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

2661: l_price_break_neg_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2662: l_has_shipments_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2663: l_source_doc_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
2664: l_source_line_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
2665: l_souce_doc_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2666: l_source_line_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2667: l_price_disabled_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2668: l_quantity_disabled_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2669: l_job_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 2666: l_source_line_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

2662: l_has_shipments_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2663: l_source_doc_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
2664: l_source_line_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
2665: l_souce_doc_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2666: l_source_line_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2667: l_price_disabled_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2668: l_quantity_disabled_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2669: l_job_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2670: l_additional_job_details PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;

Line 2667: l_price_disabled_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

2663: l_source_doc_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
2664: l_source_line_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
2665: l_souce_doc_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2666: l_source_line_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2667: l_price_disabled_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2668: l_quantity_disabled_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2669: l_job_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2670: l_additional_job_details PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
2671: l_po_agreed_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 2668: l_quantity_disabled_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

2664: l_source_line_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
2665: l_souce_doc_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2666: l_source_line_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2667: l_price_disabled_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2668: l_quantity_disabled_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2669: l_job_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2670: l_additional_job_details PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
2671: l_po_agreed_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2672: l_has_price_differentials_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

Line 2669: l_job_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

2665: l_souce_doc_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2666: l_source_line_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2667: l_price_disabled_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2668: l_quantity_disabled_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2669: l_job_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2670: l_additional_job_details PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
2671: l_po_agreed_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2672: l_has_price_differentials_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2673: l_differential_response_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;

Line 2670: l_additional_job_details PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;

2666: l_source_line_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2667: l_price_disabled_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2668: l_quantity_disabled_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2669: l_job_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2670: l_additional_job_details PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
2671: l_po_agreed_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2672: l_has_price_differentials_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2673: l_differential_response_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
2674: l_purchase_basis PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

Line 2671: l_po_agreed_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

2667: l_price_disabled_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2668: l_quantity_disabled_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2669: l_job_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2670: l_additional_job_details PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
2671: l_po_agreed_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2672: l_has_price_differentials_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2673: l_differential_response_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
2674: l_purchase_basis PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2675: l_is_quantity_scored PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

Line 2672: l_has_price_differentials_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

2668: l_quantity_disabled_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2669: l_job_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2670: l_additional_job_details PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
2671: l_po_agreed_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2672: l_has_price_differentials_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2673: l_differential_response_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
2674: l_purchase_basis PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2675: l_is_quantity_scored PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2676: l_is_need_by_date_scored PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

Line 2673: l_differential_response_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;

2669: l_job_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2670: l_additional_job_details PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
2671: l_po_agreed_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2672: l_has_price_differentials_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2673: l_differential_response_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
2674: l_purchase_basis PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2675: l_is_quantity_scored PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2676: l_is_need_by_date_scored PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2677: l_last_amendment_update PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 2674: l_purchase_basis PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

2670: l_additional_job_details PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
2671: l_po_agreed_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2672: l_has_price_differentials_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2673: l_differential_response_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
2674: l_purchase_basis PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2675: l_is_quantity_scored PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2676: l_is_need_by_date_scored PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2677: l_last_amendment_update PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2678: l_modified_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;

Line 2675: l_is_quantity_scored PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

2671: l_po_agreed_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2672: l_has_price_differentials_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2673: l_differential_response_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
2674: l_purchase_basis PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2675: l_is_quantity_scored PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2676: l_is_need_by_date_scored PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2677: l_last_amendment_update PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2678: l_modified_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
2679: l_price_diff_shipment_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 2676: l_is_need_by_date_scored PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

2672: l_has_price_differentials_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2673: l_differential_response_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
2674: l_purchase_basis PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2675: l_is_quantity_scored PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2676: l_is_need_by_date_scored PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2677: l_last_amendment_update PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2678: l_modified_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
2679: l_price_diff_shipment_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2680:

Line 2677: l_last_amendment_update PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

2673: l_differential_response_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
2674: l_purchase_basis PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2675: l_is_quantity_scored PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2676: l_is_need_by_date_scored PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2677: l_last_amendment_update PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2678: l_modified_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
2679: l_price_diff_shipment_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2680:
2681: --

Line 2678: l_modified_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;

2674: l_purchase_basis PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2675: l_is_quantity_scored PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2676: l_is_need_by_date_scored PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2677: l_last_amendment_update PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2678: l_modified_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
2679: l_price_diff_shipment_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2680:
2681: --
2682: -- Lot based project related columns

Line 2679: l_price_diff_shipment_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

2675: l_is_quantity_scored PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2676: l_is_need_by_date_scored PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2677: l_last_amendment_update PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2678: l_modified_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
2679: l_price_diff_shipment_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2680:
2681: --
2682: -- Lot based project related columns
2683: --

Line 2684: l_group_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

2680:
2681: --
2682: -- Lot based project related columns
2683: --
2684: l_group_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2685: l_parent_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2686: l_document_disp_line_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2687: l_max_sub_line_sequence_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2688: l_sub_line_sequence_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 2685: l_parent_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

2681: --
2682: -- Lot based project related columns
2683: --
2684: l_group_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2685: l_parent_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2686: l_document_disp_line_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2687: l_max_sub_line_sequence_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2688: l_sub_line_sequence_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2689:

Line 2686: l_document_disp_line_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

2682: -- Lot based project related columns
2683: --
2684: l_group_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2685: l_parent_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2686: l_document_disp_line_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2687: l_max_sub_line_sequence_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2688: l_sub_line_sequence_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2689:
2690: --

Line 2687: l_max_sub_line_sequence_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

2683: --
2684: l_group_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2685: l_parent_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2686: l_document_disp_line_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2687: l_max_sub_line_sequence_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2688: l_sub_line_sequence_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2689:
2690: --
2691: -- Transformation project related columns

Line 2688: l_sub_line_sequence_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

2684: l_group_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2685: l_parent_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2686: l_document_disp_line_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2687: l_max_sub_line_sequence_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2688: l_sub_line_sequence_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2689:
2690: --
2691: -- Transformation project related columns
2692: --

Line 2693: l_has_buyer_pfs_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

2689:
2690: --
2691: -- Transformation project related columns
2692: --
2693: l_has_buyer_pfs_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2694: l_unit_target_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2695: l_unit_display_target_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2696:
2697: l_had_obsoleted_pe PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

Line 2694: l_unit_target_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

2690: --
2691: -- Transformation project related columns
2692: --
2693: l_has_buyer_pfs_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2694: l_unit_target_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2695: l_unit_display_target_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2696:
2697: l_had_obsoleted_pe PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2698: l_had_obsolete_attr_group PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

Line 2695: l_unit_display_target_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

2691: -- Transformation project related columns
2692: --
2693: l_has_buyer_pfs_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2694: l_unit_target_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2695: l_unit_display_target_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2696:
2697: l_had_obsoleted_pe PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2698: l_had_obsolete_attr_group PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2699:

Line 2697: l_had_obsoleted_pe PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

2693: l_has_buyer_pfs_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2694: l_unit_target_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2695: l_unit_display_target_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2696:
2697: l_had_obsoleted_pe PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2698: l_had_obsolete_attr_group PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2699:
2700: l_has_active_buyer_pe_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2701: l_has_active_supplier_pe_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

Line 2698: l_had_obsolete_attr_group PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

2694: l_unit_target_price PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2695: l_unit_display_target_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2696:
2697: l_had_obsoleted_pe PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2698: l_had_obsolete_attr_group PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2699:
2700: l_has_active_buyer_pe_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2701: l_has_active_supplier_pe_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2702:

Line 2700: l_has_active_buyer_pe_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

2696:
2697: l_had_obsoleted_pe PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2698: l_had_obsolete_attr_group PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2699:
2700: l_has_active_buyer_pe_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2701: l_has_active_supplier_pe_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2702:
2703: l_rfi_doctype_id NUMBER;
2704: l_has_some_obsolete_attr_group VARCHAR2(1);

Line 2701: l_has_active_supplier_pe_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

2697: l_had_obsoleted_pe PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2698: l_had_obsolete_attr_group PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2699:
2700: l_has_active_buyer_pe_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2701: l_has_active_supplier_pe_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2702:
2703: l_rfi_doctype_id NUMBER;
2704: l_has_some_obsolete_attr_group VARCHAR2(1);
2705: l_has_temp_labor_lines VARCHAR2(1);

Line 2710: l_has_payments_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

2706: l_is_succession VARCHAR2(1);
2707: l_has_descriptors VARCHAR2(1);
2708:
2709: --Complex work project related columns
2710: l_has_payments_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2711: l_advance_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2712: l_recoupment_rate_percent PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2713: l_progress_pymt_rate_percent PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2714: l_retainage_rate_percent PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 2711: l_advance_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

2707: l_has_descriptors VARCHAR2(1);
2708:
2709: --Complex work project related columns
2710: l_has_payments_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2711: l_advance_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2712: l_recoupment_rate_percent PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2713: l_progress_pymt_rate_percent PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2714: l_retainage_rate_percent PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2715: l_max_retainage_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 2712: l_recoupment_rate_percent PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

2708:
2709: --Complex work project related columns
2710: l_has_payments_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2711: l_advance_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2712: l_recoupment_rate_percent PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2713: l_progress_pymt_rate_percent PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2714: l_retainage_rate_percent PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2715: l_max_retainage_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2716: l_work_approver_user_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 2713: l_progress_pymt_rate_percent PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

2709: --Complex work project related columns
2710: l_has_payments_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2711: l_advance_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2712: l_recoupment_rate_percent PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2713: l_progress_pymt_rate_percent PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2714: l_retainage_rate_percent PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2715: l_max_retainage_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2716: l_work_approver_user_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2717: l_project_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 2714: l_retainage_rate_percent PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

2710: l_has_payments_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2711: l_advance_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2712: l_recoupment_rate_percent PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2713: l_progress_pymt_rate_percent PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2714: l_retainage_rate_percent PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2715: l_max_retainage_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2716: l_work_approver_user_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2717: l_project_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2718: l_project_task_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 2715: l_max_retainage_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

2711: l_advance_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2712: l_recoupment_rate_percent PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2713: l_progress_pymt_rate_percent PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2714: l_retainage_rate_percent PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2715: l_max_retainage_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2716: l_work_approver_user_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2717: l_project_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2718: l_project_task_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2719: l_project_award_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 2716: l_work_approver_user_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

2712: l_recoupment_rate_percent PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2713: l_progress_pymt_rate_percent PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2714: l_retainage_rate_percent PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2715: l_max_retainage_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2716: l_work_approver_user_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2717: l_project_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2718: l_project_task_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2719: l_project_award_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2720: l_project_expenditure_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

Line 2717: l_project_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

2713: l_progress_pymt_rate_percent PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2714: l_retainage_rate_percent PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2715: l_max_retainage_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2716: l_work_approver_user_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2717: l_project_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2718: l_project_task_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2719: l_project_award_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2720: l_project_expenditure_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2721: l_project_exp_organization_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 2718: l_project_task_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

2714: l_retainage_rate_percent PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2715: l_max_retainage_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2716: l_work_approver_user_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2717: l_project_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2718: l_project_task_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2719: l_project_award_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2720: l_project_expenditure_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2721: l_project_exp_organization_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2722: l_project_exp_item_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;

Line 2719: l_project_award_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

2715: l_max_retainage_amount PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2716: l_work_approver_user_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2717: l_project_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2718: l_project_task_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2719: l_project_award_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2720: l_project_expenditure_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2721: l_project_exp_organization_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2722: l_project_exp_item_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
2723:

Line 2720: l_project_expenditure_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

2716: l_work_approver_user_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2717: l_project_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2718: l_project_task_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2719: l_project_award_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2720: l_project_expenditure_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2721: l_project_exp_organization_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2722: l_project_exp_item_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
2723:
2724: --Staggered closing project

Line 2721: l_project_exp_organization_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

2717: l_project_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2718: l_project_task_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2719: l_project_award_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2720: l_project_expenditure_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2721: l_project_exp_organization_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2722: l_project_exp_item_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
2723:
2724: --Staggered closing project
2725: l_close_bidding_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;

Line 2722: l_project_exp_item_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;

2718: l_project_task_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2719: l_project_award_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2720: l_project_expenditure_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2721: l_project_exp_organization_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2722: l_project_exp_item_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
2723:
2724: --Staggered closing project
2725: l_close_bidding_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
2726: l_copy_close_bidding_date varchar2(1);

Line 2725: l_close_bidding_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;

2721: l_project_exp_organization_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2722: l_project_exp_item_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
2723:
2724: --Staggered closing project
2725: l_close_bidding_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
2726: l_copy_close_bidding_date varchar2(1);
2727:
2728: -- Quantity Based Price Tiers
2729: l_has_quantity_tiers_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

Line 2729: l_has_quantity_tiers_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

2725: l_close_bidding_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
2726: l_copy_close_bidding_date varchar2(1);
2727:
2728: -- Quantity Based Price Tiers
2729: l_has_quantity_tiers_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
2730:
2731: BEGIN
2732:
2733: --

Line 3771: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

3767: p_copy_type IN VARCHAR2
3768: )
3769: IS
3770:
3771: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3772: l_attribute_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
3773: l_description PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
3774: l_datatype PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
3775: l_mandatory_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

Line 3772: l_attribute_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;

3768: )
3769: IS
3770:
3771: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3772: l_attribute_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
3773: l_description PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
3774: l_datatype PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
3775: l_mandatory_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3776: l_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;

Line 3773: l_description PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;

3769: IS
3770:
3771: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3772: l_attribute_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
3773: l_description PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
3774: l_datatype PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
3775: l_mandatory_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3776: l_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
3777: l_display_prompt PON_NEG_COPY_DATATYPES_GRP.VARCHAR100_TYPE;

Line 3774: l_datatype PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;

3770:
3771: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3772: l_attribute_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
3773: l_description PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
3774: l_datatype PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
3775: l_mandatory_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3776: l_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
3777: l_display_prompt PON_NEG_COPY_DATATYPES_GRP.VARCHAR100_TYPE;
3778: l_help_text PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;

Line 3775: l_mandatory_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

3771: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3772: l_attribute_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
3773: l_description PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
3774: l_datatype PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
3775: l_mandatory_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3776: l_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
3777: l_display_prompt PON_NEG_COPY_DATATYPES_GRP.VARCHAR100_TYPE;
3778: l_help_text PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3779: l_display_target_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

Line 3776: l_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;

3772: l_attribute_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
3773: l_description PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
3774: l_datatype PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
3775: l_mandatory_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3776: l_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
3777: l_display_prompt PON_NEG_COPY_DATATYPES_GRP.VARCHAR100_TYPE;
3778: l_help_text PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3779: l_display_target_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3780: l_attribute_list_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 3777: l_display_prompt PON_NEG_COPY_DATATYPES_GRP.VARCHAR100_TYPE;

3773: l_description PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
3774: l_datatype PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
3775: l_mandatory_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3776: l_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
3777: l_display_prompt PON_NEG_COPY_DATATYPES_GRP.VARCHAR100_TYPE;
3778: l_help_text PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3779: l_display_target_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3780: l_attribute_list_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3781: l_display_only_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

Line 3778: l_help_text PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;

3774: l_datatype PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
3775: l_mandatory_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3776: l_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
3777: l_display_prompt PON_NEG_COPY_DATATYPES_GRP.VARCHAR100_TYPE;
3778: l_help_text PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3779: l_display_target_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3780: l_attribute_list_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3781: l_display_only_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3782: l_sequence_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 3779: l_display_target_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

3775: l_mandatory_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3776: l_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
3777: l_display_prompt PON_NEG_COPY_DATATYPES_GRP.VARCHAR100_TYPE;
3778: l_help_text PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3779: l_display_target_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3780: l_attribute_list_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3781: l_display_only_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3782: l_sequence_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3783: l_copied_from_cat_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

Line 3780: l_attribute_list_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

3776: l_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
3777: l_display_prompt PON_NEG_COPY_DATATYPES_GRP.VARCHAR100_TYPE;
3778: l_help_text PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3779: l_display_target_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3780: l_attribute_list_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3781: l_display_only_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3782: l_sequence_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3783: l_copied_from_cat_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3784: l_weight PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 3781: l_display_only_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

3777: l_display_prompt PON_NEG_COPY_DATATYPES_GRP.VARCHAR100_TYPE;
3778: l_help_text PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3779: l_display_target_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3780: l_attribute_list_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3781: l_display_only_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3782: l_sequence_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3783: l_copied_from_cat_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3784: l_weight PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3785: l_scoring_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

Line 3782: l_sequence_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

3778: l_help_text PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
3779: l_display_target_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3780: l_attribute_list_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3781: l_display_only_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3782: l_sequence_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3783: l_copied_from_cat_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3784: l_weight PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3785: l_scoring_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3786: l_attr_level PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

Line 3783: l_copied_from_cat_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

3779: l_display_target_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3780: l_attribute_list_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3781: l_display_only_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3782: l_sequence_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3783: l_copied_from_cat_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3784: l_weight PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3785: l_scoring_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3786: l_attr_level PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3787: l_attr_group PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;

Line 3784: l_weight PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

3780: l_attribute_list_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3781: l_display_only_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3782: l_sequence_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3783: l_copied_from_cat_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3784: l_weight PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3785: l_scoring_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3786: l_attr_level PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3787: l_attr_group PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
3788: l_attr_max_score PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 3785: l_scoring_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

3781: l_display_only_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3782: l_sequence_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3783: l_copied_from_cat_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3784: l_weight PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3785: l_scoring_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3786: l_attr_level PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3787: l_attr_group PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
3788: l_attr_max_score PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3789: l_internal_attr_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

Line 3786: l_attr_level PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

3782: l_sequence_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3783: l_copied_from_cat_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3784: l_weight PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3785: l_scoring_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3786: l_attr_level PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3787: l_attr_group PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
3788: l_attr_max_score PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3789: l_internal_attr_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3790: l_attr_group_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 3787: l_attr_group PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;

3783: l_copied_from_cat_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3784: l_weight PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3785: l_scoring_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3786: l_attr_level PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3787: l_attr_group PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
3788: l_attr_max_score PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3789: l_internal_attr_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3790: l_attr_group_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3791: l_attr_disp_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 3788: l_attr_max_score PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

3784: l_weight PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3785: l_scoring_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3786: l_attr_level PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3787: l_attr_group PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
3788: l_attr_max_score PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3789: l_internal_attr_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3790: l_attr_group_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3791: l_attr_disp_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3792:

Line 3789: l_internal_attr_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

3785: l_scoring_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3786: l_attr_level PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3787: l_attr_group PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
3788: l_attr_max_score PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3789: l_internal_attr_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3790: l_attr_group_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3791: l_attr_disp_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3792:
3793: l_modified_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

Line 3790: l_attr_group_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

3786: l_attr_level PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3787: l_attr_group PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
3788: l_attr_max_score PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3789: l_internal_attr_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3790: l_attr_group_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3791: l_attr_disp_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3792:
3793: l_modified_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3794: l_modified_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;

Line 3791: l_attr_disp_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

3787: l_attr_group PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
3788: l_attr_max_score PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3789: l_internal_attr_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3790: l_attr_group_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3791: l_attr_disp_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3792:
3793: l_modified_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3794: l_modified_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
3795: l_last_amendment_update PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 3793: l_modified_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

3789: l_internal_attr_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3790: l_attr_group_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3791: l_attr_disp_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3792:
3793: l_modified_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3794: l_modified_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
3795: l_last_amendment_update PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3796: l_ip_category_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3797: l_ip_descriptor_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 3794: l_modified_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;

3790: l_attr_group_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3791: l_attr_disp_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3792:
3793: l_modified_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3794: l_modified_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
3795: l_last_amendment_update PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3796: l_ip_category_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3797: l_ip_descriptor_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3798: l_is_obsolete_attribute PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

Line 3795: l_last_amendment_update PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

3791: l_attr_disp_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3792:
3793: l_modified_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3794: l_modified_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
3795: l_last_amendment_update PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3796: l_ip_category_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3797: l_ip_descriptor_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3798: l_is_obsolete_attribute PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3799: l_section_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;

Line 3796: l_ip_category_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

3792:
3793: l_modified_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3794: l_modified_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
3795: l_last_amendment_update PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3796: l_ip_category_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3797: l_ip_descriptor_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3798: l_is_obsolete_attribute PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3799: l_section_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
3800: l_knockout_score PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 3797: l_ip_descriptor_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

3793: l_modified_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3794: l_modified_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
3795: l_last_amendment_update PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3796: l_ip_category_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3797: l_ip_descriptor_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3798: l_is_obsolete_attribute PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3799: l_section_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
3800: l_knockout_score PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3801: l_scoring_method PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

Line 3798: l_is_obsolete_attribute PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

3794: l_modified_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
3795: l_last_amendment_update PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3796: l_ip_category_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3797: l_ip_descriptor_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3798: l_is_obsolete_attribute PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3799: l_section_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
3800: l_knockout_score PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3801: l_scoring_method PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3802:

Line 3799: l_section_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;

3795: l_last_amendment_update PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3796: l_ip_category_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3797: l_ip_descriptor_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3798: l_is_obsolete_attribute PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3799: l_section_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
3800: l_knockout_score PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3801: l_scoring_method PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3802:
3803: l_has_inactv_hdr_attr_grp VARCHAR2(1);

Line 3800: l_knockout_score PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

3796: l_ip_category_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3797: l_ip_descriptor_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3798: l_is_obsolete_attribute PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3799: l_section_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
3800: l_knockout_score PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3801: l_scoring_method PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3802:
3803: l_has_inactv_hdr_attr_grp VARCHAR2(1);
3804:

Line 3801: l_scoring_method PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

3797: l_ip_descriptor_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3798: l_is_obsolete_attribute PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
3799: l_section_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
3800: l_knockout_score PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3801: l_scoring_method PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3802:
3803: l_has_inactv_hdr_attr_grp VARCHAR2(1);
3804:
3805: l_contract_type PON_AUCTION_HEADERS_ALL.CONTRACT_TYPE%TYPE;

Line 4046: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

4042: p_to_line_number IN NUMBER
4043: )
4044: IS
4045:
4046: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4047: l_attribute_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
4048: l_description PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
4049: l_datatype PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
4050: l_mandatory_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

Line 4047: l_attribute_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;

4043: )
4044: IS
4045:
4046: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4047: l_attribute_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
4048: l_description PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
4049: l_datatype PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
4050: l_mandatory_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4051: l_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;

Line 4048: l_description PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;

4044: IS
4045:
4046: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4047: l_attribute_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
4048: l_description PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
4049: l_datatype PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
4050: l_mandatory_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4051: l_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
4052: l_display_prompt PON_NEG_COPY_DATATYPES_GRP.VARCHAR100_TYPE;

Line 4049: l_datatype PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;

4045:
4046: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4047: l_attribute_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
4048: l_description PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
4049: l_datatype PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
4050: l_mandatory_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4051: l_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
4052: l_display_prompt PON_NEG_COPY_DATATYPES_GRP.VARCHAR100_TYPE;
4053: l_help_text PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;

Line 4050: l_mandatory_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

4046: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4047: l_attribute_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
4048: l_description PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
4049: l_datatype PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
4050: l_mandatory_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4051: l_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
4052: l_display_prompt PON_NEG_COPY_DATATYPES_GRP.VARCHAR100_TYPE;
4053: l_help_text PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
4054: l_display_target_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

Line 4051: l_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;

4047: l_attribute_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
4048: l_description PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
4049: l_datatype PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
4050: l_mandatory_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4051: l_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
4052: l_display_prompt PON_NEG_COPY_DATATYPES_GRP.VARCHAR100_TYPE;
4053: l_help_text PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
4054: l_display_target_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4055: l_attribute_list_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 4052: l_display_prompt PON_NEG_COPY_DATATYPES_GRP.VARCHAR100_TYPE;

4048: l_description PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
4049: l_datatype PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
4050: l_mandatory_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4051: l_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
4052: l_display_prompt PON_NEG_COPY_DATATYPES_GRP.VARCHAR100_TYPE;
4053: l_help_text PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
4054: l_display_target_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4055: l_attribute_list_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4056: l_display_only_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

Line 4053: l_help_text PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;

4049: l_datatype PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
4050: l_mandatory_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4051: l_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
4052: l_display_prompt PON_NEG_COPY_DATATYPES_GRP.VARCHAR100_TYPE;
4053: l_help_text PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
4054: l_display_target_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4055: l_attribute_list_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4056: l_display_only_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4057: l_sequence_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 4054: l_display_target_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

4050: l_mandatory_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4051: l_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
4052: l_display_prompt PON_NEG_COPY_DATATYPES_GRP.VARCHAR100_TYPE;
4053: l_help_text PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
4054: l_display_target_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4055: l_attribute_list_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4056: l_display_only_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4057: l_sequence_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4058: l_copied_from_cat_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

Line 4055: l_attribute_list_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

4051: l_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
4052: l_display_prompt PON_NEG_COPY_DATATYPES_GRP.VARCHAR100_TYPE;
4053: l_help_text PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
4054: l_display_target_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4055: l_attribute_list_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4056: l_display_only_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4057: l_sequence_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4058: l_copied_from_cat_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4059: l_weight PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 4056: l_display_only_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

4052: l_display_prompt PON_NEG_COPY_DATATYPES_GRP.VARCHAR100_TYPE;
4053: l_help_text PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
4054: l_display_target_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4055: l_attribute_list_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4056: l_display_only_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4057: l_sequence_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4058: l_copied_from_cat_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4059: l_weight PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4060: l_scoring_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

Line 4057: l_sequence_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

4053: l_help_text PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
4054: l_display_target_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4055: l_attribute_list_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4056: l_display_only_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4057: l_sequence_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4058: l_copied_from_cat_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4059: l_weight PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4060: l_scoring_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
4061: l_attr_level PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

Line 4058: l_copied_from_cat_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

4054: l_display_target_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4055: l_attribute_list_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4056: l_display_only_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4057: l_sequence_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4058: l_copied_from_cat_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4059: l_weight PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4060: l_scoring_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
4061: l_attr_level PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
4062: l_attr_group PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;

Line 4059: l_weight PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

4055: l_attribute_list_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4056: l_display_only_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4057: l_sequence_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4058: l_copied_from_cat_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4059: l_weight PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4060: l_scoring_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
4061: l_attr_level PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
4062: l_attr_group PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
4063: l_attr_max_score PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 4060: l_scoring_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

4056: l_display_only_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4057: l_sequence_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4058: l_copied_from_cat_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4059: l_weight PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4060: l_scoring_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
4061: l_attr_level PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
4062: l_attr_group PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
4063: l_attr_max_score PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4064: l_internal_attr_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

Line 4061: l_attr_level PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

4057: l_sequence_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4058: l_copied_from_cat_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4059: l_weight PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4060: l_scoring_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
4061: l_attr_level PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
4062: l_attr_group PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
4063: l_attr_max_score PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4064: l_internal_attr_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4065: l_attr_group_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 4062: l_attr_group PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;

4058: l_copied_from_cat_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4059: l_weight PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4060: l_scoring_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
4061: l_attr_level PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
4062: l_attr_group PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
4063: l_attr_max_score PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4064: l_internal_attr_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4065: l_attr_group_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4066: l_attr_disp_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 4063: l_attr_max_score PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

4059: l_weight PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4060: l_scoring_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
4061: l_attr_level PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
4062: l_attr_group PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
4063: l_attr_max_score PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4064: l_internal_attr_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4065: l_attr_group_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4066: l_attr_disp_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4067:

Line 4064: l_internal_attr_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

4060: l_scoring_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
4061: l_attr_level PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
4062: l_attr_group PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
4063: l_attr_max_score PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4064: l_internal_attr_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4065: l_attr_group_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4066: l_attr_disp_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4067:
4068: l_modified_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

Line 4065: l_attr_group_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

4061: l_attr_level PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
4062: l_attr_group PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
4063: l_attr_max_score PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4064: l_internal_attr_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4065: l_attr_group_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4066: l_attr_disp_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4067:
4068: l_modified_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4069: l_modified_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;

Line 4066: l_attr_disp_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

4062: l_attr_group PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
4063: l_attr_max_score PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4064: l_internal_attr_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4065: l_attr_group_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4066: l_attr_disp_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4067:
4068: l_modified_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4069: l_modified_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
4070: l_last_amendment_update PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 4068: l_modified_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

4064: l_internal_attr_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4065: l_attr_group_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4066: l_attr_disp_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4067:
4068: l_modified_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4069: l_modified_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
4070: l_last_amendment_update PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4071: l_ip_category_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4072: l_ip_descriptor_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 4069: l_modified_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;

4065: l_attr_group_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4066: l_attr_disp_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4067:
4068: l_modified_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4069: l_modified_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
4070: l_last_amendment_update PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4071: l_ip_category_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4072: l_ip_descriptor_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4073: l_is_obsolete_attribute PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

Line 4070: l_last_amendment_update PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

4066: l_attr_disp_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4067:
4068: l_modified_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4069: l_modified_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
4070: l_last_amendment_update PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4071: l_ip_category_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4072: l_ip_descriptor_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4073: l_is_obsolete_attribute PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4074: l_section_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;

Line 4071: l_ip_category_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

4067:
4068: l_modified_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4069: l_modified_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
4070: l_last_amendment_update PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4071: l_ip_category_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4072: l_ip_descriptor_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4073: l_is_obsolete_attribute PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4074: l_section_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
4075: l_knockout_score PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 4072: l_ip_descriptor_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

4068: l_modified_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4069: l_modified_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
4070: l_last_amendment_update PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4071: l_ip_category_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4072: l_ip_descriptor_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4073: l_is_obsolete_attribute PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4074: l_section_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
4075: l_knockout_score PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4076: l_scoring_method PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

Line 4073: l_is_obsolete_attribute PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

4069: l_modified_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
4070: l_last_amendment_update PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4071: l_ip_category_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4072: l_ip_descriptor_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4073: l_is_obsolete_attribute PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4074: l_section_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
4075: l_knockout_score PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4076: l_scoring_method PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
4077:

Line 4074: l_section_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;

4070: l_last_amendment_update PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4071: l_ip_category_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4072: l_ip_descriptor_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4073: l_is_obsolete_attribute PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4074: l_section_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
4075: l_knockout_score PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4076: l_scoring_method PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
4077:
4078: l_val1 VARCHAR2(300) := NULL;

Line 4075: l_knockout_score PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

4071: l_ip_category_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4072: l_ip_descriptor_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4073: l_is_obsolete_attribute PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4074: l_section_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
4075: l_knockout_score PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4076: l_scoring_method PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
4077:
4078: l_val1 VARCHAR2(300) := NULL;
4079: l_val2 VARCHAR2(300) := NULL;

Line 4076: l_scoring_method PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

4072: l_ip_descriptor_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4073: l_is_obsolete_attribute PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
4074: l_section_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
4075: l_knockout_score PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4076: l_scoring_method PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
4077:
4078: l_val1 VARCHAR2(300) := NULL;
4079: l_val2 VARCHAR2(300) := NULL;
4080: l_val3 VARCHAR2(300) := NULL;

Line 5173: l_list_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

5169: p_org_id IN NUMBER,
5170: p_round_number IN NUMBER
5171: )
5172: IS
5173: l_list_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5174: l_sequence PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5175: l_trading_partner_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
5176: l_trading_partner_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5177: l_trading_partner_contact_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;

Line 5174: l_sequence PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

5170: p_round_number IN NUMBER
5171: )
5172: IS
5173: l_list_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5174: l_sequence PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5175: l_trading_partner_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
5176: l_trading_partner_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5177: l_trading_partner_contact_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
5178: l_trading_partner_contact_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 5175: l_trading_partner_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;

5171: )
5172: IS
5173: l_list_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5174: l_sequence PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5175: l_trading_partner_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
5176: l_trading_partner_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5177: l_trading_partner_contact_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
5178: l_trading_partner_contact_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5179: l_new_supplier_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;

Line 5176: l_trading_partner_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

5172: IS
5173: l_list_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5174: l_sequence PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5175: l_trading_partner_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
5176: l_trading_partner_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5177: l_trading_partner_contact_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
5178: l_trading_partner_contact_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5179: l_new_supplier_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
5180: l_new_supplier_contact_fname PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;

Line 5177: l_trading_partner_contact_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;

5173: l_list_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5174: l_sequence PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5175: l_trading_partner_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
5176: l_trading_partner_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5177: l_trading_partner_contact_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
5178: l_trading_partner_contact_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5179: l_new_supplier_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
5180: l_new_supplier_contact_fname PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
5181: l_new_supplier_contact_lname PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;

Line 5178: l_trading_partner_contact_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

5174: l_sequence PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5175: l_trading_partner_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
5176: l_trading_partner_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5177: l_trading_partner_contact_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
5178: l_trading_partner_contact_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5179: l_new_supplier_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
5180: l_new_supplier_contact_fname PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
5181: l_new_supplier_contact_lname PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
5182: l_new_supplier_email PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;

Line 5179: l_new_supplier_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;

5175: l_trading_partner_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
5176: l_trading_partner_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5177: l_trading_partner_contact_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
5178: l_trading_partner_contact_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5179: l_new_supplier_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
5180: l_new_supplier_contact_fname PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
5181: l_new_supplier_contact_lname PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
5182: l_new_supplier_email PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
5183: l_note_to_new_supplier PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;

Line 5180: l_new_supplier_contact_fname PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;

5176: l_trading_partner_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5177: l_trading_partner_contact_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
5178: l_trading_partner_contact_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5179: l_new_supplier_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
5180: l_new_supplier_contact_fname PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
5181: l_new_supplier_contact_lname PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
5182: l_new_supplier_email PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
5183: l_note_to_new_supplier PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
5184: l_wf_user_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

Line 5181: l_new_supplier_contact_lname PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;

5177: l_trading_partner_contact_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
5178: l_trading_partner_contact_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5179: l_new_supplier_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
5180: l_new_supplier_contact_fname PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
5181: l_new_supplier_contact_lname PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
5182: l_new_supplier_email PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
5183: l_note_to_new_supplier PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
5184: l_wf_user_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
5185: l_invitation_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 5182: l_new_supplier_email PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;

5178: l_trading_partner_contact_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5179: l_new_supplier_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
5180: l_new_supplier_contact_fname PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
5181: l_new_supplier_contact_lname PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
5182: l_new_supplier_email PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
5183: l_note_to_new_supplier PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
5184: l_wf_user_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
5185: l_invitation_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5186: l_auction_creation_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;

Line 5183: l_note_to_new_supplier PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;

5179: l_new_supplier_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
5180: l_new_supplier_contact_fname PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
5181: l_new_supplier_contact_lname PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
5182: l_new_supplier_email PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
5183: l_note_to_new_supplier PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
5184: l_wf_user_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
5185: l_invitation_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5186: l_auction_creation_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
5187: l_bid_currency_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;

Line 5184: l_wf_user_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

5180: l_new_supplier_contact_fname PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
5181: l_new_supplier_contact_lname PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
5182: l_new_supplier_email PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
5183: l_note_to_new_supplier PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
5184: l_wf_user_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
5185: l_invitation_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5186: l_auction_creation_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
5187: l_bid_currency_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
5188: l_number_price_decimals PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 5185: l_invitation_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

5181: l_new_supplier_contact_lname PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
5182: l_new_supplier_email PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
5183: l_note_to_new_supplier PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
5184: l_wf_user_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
5185: l_invitation_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5186: l_auction_creation_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
5187: l_bid_currency_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
5188: l_number_price_decimals PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5189: l_rate PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 5186: l_auction_creation_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;

5182: l_new_supplier_email PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
5183: l_note_to_new_supplier PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
5184: l_wf_user_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
5185: l_invitation_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5186: l_auction_creation_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
5187: l_bid_currency_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
5188: l_number_price_decimals PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5189: l_rate PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5190: l_derive_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;

Line 5187: l_bid_currency_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;

5183: l_note_to_new_supplier PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
5184: l_wf_user_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
5185: l_invitation_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5186: l_auction_creation_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
5187: l_bid_currency_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
5188: l_number_price_decimals PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5189: l_rate PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5190: l_derive_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
5191: l_additional_contact_email PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;

Line 5188: l_number_price_decimals PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

5184: l_wf_user_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
5185: l_invitation_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5186: l_auction_creation_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
5187: l_bid_currency_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
5188: l_number_price_decimals PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5189: l_rate PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5190: l_derive_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
5191: l_additional_contact_email PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
5192: l_round_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 5189: l_rate PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

5185: l_invitation_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5186: l_auction_creation_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
5187: l_bid_currency_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
5188: l_number_price_decimals PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5189: l_rate PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5190: l_derive_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
5191: l_additional_contact_email PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
5192: l_round_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5193: l_supp_acknowledgement PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

Line 5190: l_derive_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;

5186: l_auction_creation_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
5187: l_bid_currency_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
5188: l_number_price_decimals PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5189: l_rate PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5190: l_derive_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
5191: l_additional_contact_email PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
5192: l_round_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5193: l_supp_acknowledgement PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
5194: l_ack_partner_contact_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 5191: l_additional_contact_email PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;

5187: l_bid_currency_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
5188: l_number_price_decimals PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5189: l_rate PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5190: l_derive_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
5191: l_additional_contact_email PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
5192: l_round_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5193: l_supp_acknowledgement PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
5194: l_ack_partner_contact_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5195: l_acknowledgement_time PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;

Line 5192: l_round_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

5188: l_number_price_decimals PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5189: l_rate PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5190: l_derive_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
5191: l_additional_contact_email PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
5192: l_round_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5193: l_supp_acknowledgement PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
5194: l_ack_partner_contact_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5195: l_acknowledgement_time PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
5196: l_ack_note_to_auctioneer PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;

Line 5193: l_supp_acknowledgement PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

5189: l_rate PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5190: l_derive_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
5191: l_additional_contact_email PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
5192: l_round_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5193: l_supp_acknowledgement PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
5194: l_ack_partner_contact_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5195: l_acknowledgement_time PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
5196: l_ack_note_to_auctioneer PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
5197: l_registration_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 5194: l_ack_partner_contact_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

5190: l_derive_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
5191: l_additional_contact_email PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
5192: l_round_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5193: l_supp_acknowledgement PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
5194: l_ack_partner_contact_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5195: l_acknowledgement_time PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
5196: l_ack_note_to_auctioneer PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
5197: l_registration_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5198: l_rate_dsp PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 5195: l_acknowledgement_time PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;

5191: l_additional_contact_email PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
5192: l_round_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5193: l_supp_acknowledgement PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
5194: l_ack_partner_contact_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5195: l_acknowledgement_time PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
5196: l_ack_note_to_auctioneer PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
5197: l_registration_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5198: l_rate_dsp PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5199: l_vendor_site_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 5196: l_ack_note_to_auctioneer PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;

5192: l_round_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5193: l_supp_acknowledgement PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
5194: l_ack_partner_contact_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5195: l_acknowledgement_time PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
5196: l_ack_note_to_auctioneer PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
5197: l_registration_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5198: l_rate_dsp PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5199: l_vendor_site_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5200: l_vendor_site_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;

Line 5197: l_registration_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

5193: l_supp_acknowledgement PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
5194: l_ack_partner_contact_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5195: l_acknowledgement_time PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
5196: l_ack_note_to_auctioneer PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
5197: l_registration_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5198: l_rate_dsp PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5199: l_vendor_site_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5200: l_vendor_site_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
5201: l_last_amendment_update PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 5198: l_rate_dsp PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

5194: l_ack_partner_contact_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5195: l_acknowledgement_time PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
5196: l_ack_note_to_auctioneer PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
5197: l_registration_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5198: l_rate_dsp PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5199: l_vendor_site_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5200: l_vendor_site_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
5201: l_last_amendment_update PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5202: l_modified_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

Line 5199: l_vendor_site_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

5195: l_acknowledgement_time PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
5196: l_ack_note_to_auctioneer PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
5197: l_registration_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5198: l_rate_dsp PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5199: l_vendor_site_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5200: l_vendor_site_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
5201: l_last_amendment_update PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5202: l_modified_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
5203: -- Lot based bidding project related column

Line 5200: l_vendor_site_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;

5196: l_ack_note_to_auctioneer PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
5197: l_registration_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5198: l_rate_dsp PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5199: l_vendor_site_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5200: l_vendor_site_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
5201: l_last_amendment_update PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5202: l_modified_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
5203: -- Lot based bidding project related column
5204: l_access_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

Line 5201: l_last_amendment_update PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

5197: l_registration_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5198: l_rate_dsp PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5199: l_vendor_site_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5200: l_vendor_site_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
5201: l_last_amendment_update PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5202: l_modified_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
5203: -- Lot based bidding project related column
5204: l_access_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
5205: l_auction_round_number NUMBER := 0;

Line 5202: l_modified_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

5198: l_rate_dsp PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5199: l_vendor_site_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5200: l_vendor_site_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
5201: l_last_amendment_update PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5202: l_modified_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
5203: -- Lot based bidding project related column
5204: l_access_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
5205: l_auction_round_number NUMBER := 0;
5206: -- New Suppleir Registration changes

Line 5204: l_access_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

5200: l_vendor_site_code PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
5201: l_last_amendment_update PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5202: l_modified_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
5203: -- Lot based bidding project related column
5204: l_access_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
5205: l_auction_round_number NUMBER := 0;
5206: -- New Suppleir Registration changes
5207: l_requested_supplier_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5208: l_requested_supplier_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;

Line 5207: l_requested_supplier_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

5203: -- Lot based bidding project related column
5204: l_access_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
5205: l_auction_round_number NUMBER := 0;
5206: -- New Suppleir Registration changes
5207: l_requested_supplier_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5208: l_requested_supplier_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
5209: l_requested_supp_contact_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5210: l_requested_supp_contact_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
5211: -- warning for inactive suppliers

Line 5208: l_requested_supplier_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;

5204: l_access_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
5205: l_auction_round_number NUMBER := 0;
5206: -- New Suppleir Registration changes
5207: l_requested_supplier_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5208: l_requested_supplier_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
5209: l_requested_supp_contact_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5210: l_requested_supp_contact_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
5211: -- warning for inactive suppliers
5212: l_inactive_suppliers PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;

Line 5209: l_requested_supp_contact_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

5205: l_auction_round_number NUMBER := 0;
5206: -- New Suppleir Registration changes
5207: l_requested_supplier_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5208: l_requested_supplier_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
5209: l_requested_supp_contact_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5210: l_requested_supp_contact_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
5211: -- warning for inactive suppliers
5212: l_inactive_suppliers PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
5213: l_supplier_names VARCHAR2(2000);

Line 5210: l_requested_supp_contact_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;

5206: -- New Suppleir Registration changes
5207: l_requested_supplier_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5208: l_requested_supplier_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
5209: l_requested_supp_contact_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5210: l_requested_supp_contact_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
5211: -- warning for inactive suppliers
5212: l_inactive_suppliers PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
5213: l_supplier_names VARCHAR2(2000);
5214: l_last_seq_number NUMBER;

Line 5212: l_inactive_suppliers PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;

5208: l_requested_supplier_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
5209: l_requested_supp_contact_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5210: l_requested_supp_contact_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
5211: -- warning for inactive suppliers
5212: l_inactive_suppliers PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
5213: l_supplier_names VARCHAR2(2000);
5214: l_last_seq_number NUMBER;
5215: -- bug 7376924, handling inactive supplier contact
5216: l_inactive_supplier_contacts PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 5216: l_inactive_supplier_contacts PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

5212: l_inactive_suppliers PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
5213: l_supplier_names VARCHAR2(2000);
5214: l_last_seq_number NUMBER;
5215: -- bug 7376924, handling inactive supplier contact
5216: l_inactive_supplier_contacts PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5217:
5218: l_auction_header_id_orig_amend PON_AUCTION_HEADERS_ALL.AUCTION_HEADER_ID_ORIG_AMEND%type;
5219:
5220: BEGIN

Line 6128: l_list_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

6124: p_user_name IN VARCHAR2,
6125: p_mgr_id IN NUMBER
6126: )
6127: IS
6128: l_list_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6129: l_user_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6130: l_menu_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
6131: l_member_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
6132: l_approver_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

Line 6129: l_user_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

6125: p_mgr_id IN NUMBER
6126: )
6127: IS
6128: l_list_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6129: l_user_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6130: l_menu_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
6131: l_member_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
6132: l_approver_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
6133: l_approval_status PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

Line 6130: l_menu_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

6126: )
6127: IS
6128: l_list_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6129: l_user_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6130: l_menu_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
6131: l_member_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
6132: l_approver_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
6133: l_approval_status PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
6134: l_task_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;

Line 6131: l_member_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

6127: IS
6128: l_list_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6129: l_user_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6130: l_menu_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
6131: l_member_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
6132: l_approver_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
6133: l_approval_status PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
6134: l_task_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
6135: l_target_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;

Line 6132: l_approver_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

6128: l_list_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6129: l_user_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6130: l_menu_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
6131: l_member_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
6132: l_approver_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
6133: l_approval_status PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
6134: l_task_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
6135: l_target_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
6136: l_completion_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;

Line 6133: l_approval_status PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

6129: l_user_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6130: l_menu_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
6131: l_member_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
6132: l_approver_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
6133: l_approval_status PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
6134: l_task_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
6135: l_target_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
6136: l_completion_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
6137: l_business_group_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 6134: l_task_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;

6130: l_menu_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
6131: l_member_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
6132: l_approver_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
6133: l_approval_status PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
6134: l_task_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
6135: l_target_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
6136: l_completion_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
6137: l_business_group_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6138: l_effective_start_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;

Line 6135: l_target_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;

6131: l_member_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
6132: l_approver_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
6133: l_approval_status PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
6134: l_task_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
6135: l_target_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
6136: l_completion_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
6137: l_business_group_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6138: l_effective_start_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
6139: l_effective_end_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;

Line 6136: l_completion_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;

6132: l_approver_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
6133: l_approval_status PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
6134: l_task_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
6135: l_target_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
6136: l_completion_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
6137: l_business_group_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6138: l_effective_start_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
6139: l_effective_end_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
6140: l_user_start_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;

Line 6137: l_business_group_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

6133: l_approval_status PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
6134: l_task_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
6135: l_target_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
6136: l_completion_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
6137: l_business_group_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6138: l_effective_start_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
6139: l_effective_end_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
6140: l_user_start_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
6141: l_user_end_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;

Line 6138: l_effective_start_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;

6134: l_task_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
6135: l_target_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
6136: l_completion_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
6137: l_business_group_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6138: l_effective_start_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
6139: l_effective_end_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
6140: l_user_start_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
6141: l_user_end_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
6142: l_last_amendment_update PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 6139: l_effective_end_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;

6135: l_target_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
6136: l_completion_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
6137: l_business_group_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6138: l_effective_start_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
6139: l_effective_end_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
6140: l_user_start_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
6141: l_user_end_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
6142: l_last_amendment_update PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6143: l_modified_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

Line 6140: l_user_start_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;

6136: l_completion_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
6137: l_business_group_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6138: l_effective_start_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
6139: l_effective_end_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
6140: l_user_start_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
6141: l_user_end_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
6142: l_last_amendment_update PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6143: l_modified_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
6144: l_auc_business_group_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 6141: l_user_end_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;

6137: l_business_group_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6138: l_effective_start_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
6139: l_effective_end_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
6140: l_user_start_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
6141: l_user_end_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
6142: l_last_amendment_update PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6143: l_modified_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
6144: l_auc_business_group_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6145: l_full_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;

Line 6142: l_last_amendment_update PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

6138: l_effective_start_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
6139: l_effective_end_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
6140: l_user_start_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
6141: l_user_end_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
6142: l_last_amendment_update PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6143: l_modified_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
6144: l_auc_business_group_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6145: l_full_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6146: l_last_notif_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;

Line 6143: l_modified_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

6139: l_effective_end_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
6140: l_user_start_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
6141: l_user_end_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
6142: l_last_amendment_update PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6143: l_modified_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
6144: l_auc_business_group_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6145: l_full_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6146: l_last_notif_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
6147: l_is_creator_included BOOLEAN := FALSE;

Line 6144: l_auc_business_group_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

6140: l_user_start_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
6141: l_user_end_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
6142: l_last_amendment_update PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6143: l_modified_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
6144: l_auc_business_group_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6145: l_full_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6146: l_last_notif_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
6147: l_is_creator_included BOOLEAN := FALSE;
6148: l_is_manager_included BOOLEAN := FALSE;

Line 6145: l_full_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;

6141: l_user_end_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
6142: l_last_amendment_update PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6143: l_modified_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
6144: l_auc_business_group_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6145: l_full_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6146: l_last_notif_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
6147: l_is_creator_included BOOLEAN := FALSE;
6148: l_is_manager_included BOOLEAN := FALSE;
6149: l_count NUMBER;

Line 6146: l_last_notif_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;

6142: l_last_amendment_update PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6143: l_modified_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
6144: l_auc_business_group_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6145: l_full_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6146: l_last_notif_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
6147: l_is_creator_included BOOLEAN := FALSE;
6148: l_is_manager_included BOOLEAN := FALSE;
6149: l_count NUMBER;
6150: l_inactive_mem VARCHAR2(4000);

Line 8121: l_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR100_TYPE;

8117: l_max_line_number NUMBER := NULL;
8118: l_batch_end NUMBER := NULL;
8119: l_batch_start NUMBER := NULL;
8120:
8121: l_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR100_TYPE;
8122: l_inactive_pe_name VARCHAR2(4000);
8123: l_return_status VARCHAR2(1);
8124: l_batch_size NUMBER;
8125: l_last_line_number NUMBER;