DBA Data[Home] [Help]

APPS.PON_RESPONSE_IMPORT_PKG dependencies on PON_NEG_COPY_DATATYPES_GRP

Line 2902: l_line_number_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

2898: p_shipment_type IN pon_bid_shipments.shipment_type%TYPE
2899: )
2900: is
2901: l_module CONSTANT VARCHAR2(32) := 'copy_shipment_interface_to_txn';
2902: l_line_number_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2903: l_shipment_number_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2904: l_auction_header_id_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2905: l_interface_line_id_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2906: l_ship_to_organization_id_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 2903: l_shipment_number_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

2899: )
2900: is
2901: l_module CONSTANT VARCHAR2(32) := 'copy_shipment_interface_to_txn';
2902: l_line_number_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2903: l_shipment_number_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2904: l_auction_header_id_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2905: l_interface_line_id_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2906: l_ship_to_organization_id_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2907: l_ship_to_location_id_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 2904: l_auction_header_id_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

2900: is
2901: l_module CONSTANT VARCHAR2(32) := 'copy_shipment_interface_to_txn';
2902: l_line_number_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2903: l_shipment_number_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2904: l_auction_header_id_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2905: l_interface_line_id_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2906: l_ship_to_organization_id_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2907: l_ship_to_location_id_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2908: l_quantity_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 2905: l_interface_line_id_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

2901: l_module CONSTANT VARCHAR2(32) := 'copy_shipment_interface_to_txn';
2902: l_line_number_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2903: l_shipment_number_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2904: l_auction_header_id_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2905: l_interface_line_id_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2906: l_ship_to_organization_id_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2907: l_ship_to_location_id_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2908: l_quantity_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2909: l_price_type_col PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

Line 2906: l_ship_to_organization_id_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

2902: l_line_number_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2903: l_shipment_number_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2904: l_auction_header_id_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2905: l_interface_line_id_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2906: l_ship_to_organization_id_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2907: l_ship_to_location_id_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2908: l_quantity_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2909: l_price_type_col PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2910: l_bid_currency_unit_price_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 2907: l_ship_to_location_id_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

2903: l_shipment_number_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2904: l_auction_header_id_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2905: l_interface_line_id_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2906: l_ship_to_organization_id_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2907: l_ship_to_location_id_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2908: l_quantity_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2909: l_price_type_col PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2910: l_bid_currency_unit_price_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2911: l_price_discount_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 2908: l_quantity_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

2904: l_auction_header_id_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2905: l_interface_line_id_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2906: l_ship_to_organization_id_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2907: l_ship_to_location_id_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2908: l_quantity_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2909: l_price_type_col PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2910: l_bid_currency_unit_price_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2911: l_price_discount_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2912: l_effective_start_date_col PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;

Line 2909: l_price_type_col PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

2905: l_interface_line_id_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2906: l_ship_to_organization_id_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2907: l_ship_to_location_id_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2908: l_quantity_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2909: l_price_type_col PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2910: l_bid_currency_unit_price_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2911: l_price_discount_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2912: l_effective_start_date_col PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
2913: l_effective_end_date_col PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;

Line 2910: l_bid_currency_unit_price_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

2906: l_ship_to_organization_id_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2907: l_ship_to_location_id_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2908: l_quantity_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2909: l_price_type_col PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2910: l_bid_currency_unit_price_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2911: l_price_discount_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2912: l_effective_start_date_col PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
2913: l_effective_end_date_col PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
2914:

Line 2911: l_price_discount_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

2907: l_ship_to_location_id_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2908: l_quantity_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2909: l_price_type_col PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2910: l_bid_currency_unit_price_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2911: l_price_discount_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2912: l_effective_start_date_col PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
2913: l_effective_end_date_col PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
2914:
2915: l_counter number;

Line 2912: l_effective_start_date_col PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;

2908: l_quantity_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2909: l_price_type_col PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2910: l_bid_currency_unit_price_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2911: l_price_discount_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2912: l_effective_start_date_col PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
2913: l_effective_end_date_col PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
2914:
2915: l_counter number;
2916: l_curr_line_number number;

Line 2913: l_effective_end_date_col PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;

2909: l_price_type_col PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2910: l_bid_currency_unit_price_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2911: l_price_discount_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2912: l_effective_start_date_col PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
2913: l_effective_end_date_col PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
2914:
2915: l_counter number;
2916: l_curr_line_number number;
2917: BEGIN