DBA Data[Home] [Help]

APPS.PON_RESPONSE_IMPORT_PKG dependencies on PON_NEG_COPY_DATATYPES_GRP

Line 2689: l_line_number_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

2685: p_shipment_type IN pon_bid_shipments.shipment_type%TYPE
2686: )
2687: is
2688: l_module CONSTANT VARCHAR2(32) := 'copy_shipment_interface_to_txn';
2689: l_line_number_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2690: l_shipment_number_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2691: l_auction_header_id_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2692: l_interface_line_id_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2693: l_ship_to_organization_id_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 2690: l_shipment_number_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

2686: )
2687: is
2688: l_module CONSTANT VARCHAR2(32) := 'copy_shipment_interface_to_txn';
2689: l_line_number_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2690: l_shipment_number_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2691: l_auction_header_id_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2692: l_interface_line_id_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2693: l_ship_to_organization_id_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2694: l_ship_to_location_id_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 2691: l_auction_header_id_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

2687: is
2688: l_module CONSTANT VARCHAR2(32) := 'copy_shipment_interface_to_txn';
2689: l_line_number_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2690: l_shipment_number_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2691: l_auction_header_id_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2692: l_interface_line_id_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2693: l_ship_to_organization_id_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2694: l_ship_to_location_id_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2695: l_quantity_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 2692: l_interface_line_id_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

2688: l_module CONSTANT VARCHAR2(32) := 'copy_shipment_interface_to_txn';
2689: l_line_number_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2690: l_shipment_number_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2691: l_auction_header_id_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2692: l_interface_line_id_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2693: l_ship_to_organization_id_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2694: l_ship_to_location_id_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2695: l_quantity_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2696: l_price_type_col PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

Line 2693: l_ship_to_organization_id_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

2689: l_line_number_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2690: l_shipment_number_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2691: l_auction_header_id_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2692: l_interface_line_id_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2693: l_ship_to_organization_id_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2694: l_ship_to_location_id_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2695: l_quantity_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2696: l_price_type_col PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2697: l_bid_currency_unit_price_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 2694: l_ship_to_location_id_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

2690: l_shipment_number_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2691: l_auction_header_id_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2692: l_interface_line_id_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2693: l_ship_to_organization_id_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2694: l_ship_to_location_id_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2695: l_quantity_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2696: l_price_type_col PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2697: l_bid_currency_unit_price_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2698: l_price_discount_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 2695: l_quantity_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

2691: l_auction_header_id_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2692: l_interface_line_id_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2693: l_ship_to_organization_id_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2694: l_ship_to_location_id_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2695: l_quantity_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2696: l_price_type_col PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2697: l_bid_currency_unit_price_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2698: l_price_discount_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2699: l_effective_start_date_col PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;

Line 2696: l_price_type_col PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

2692: l_interface_line_id_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2693: l_ship_to_organization_id_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2694: l_ship_to_location_id_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2695: l_quantity_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2696: l_price_type_col PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2697: l_bid_currency_unit_price_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2698: l_price_discount_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2699: l_effective_start_date_col PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
2700: l_effective_end_date_col PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;

Line 2697: l_bid_currency_unit_price_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

2693: l_ship_to_organization_id_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2694: l_ship_to_location_id_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2695: l_quantity_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2696: l_price_type_col PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2697: l_bid_currency_unit_price_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2698: l_price_discount_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2699: l_effective_start_date_col PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
2700: l_effective_end_date_col PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
2701:

Line 2698: l_price_discount_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

2694: l_ship_to_location_id_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2695: l_quantity_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2696: l_price_type_col PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2697: l_bid_currency_unit_price_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2698: l_price_discount_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2699: l_effective_start_date_col PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
2700: l_effective_end_date_col PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
2701:
2702: l_counter number;

Line 2699: l_effective_start_date_col PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;

2695: l_quantity_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2696: l_price_type_col PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2697: l_bid_currency_unit_price_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2698: l_price_discount_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2699: l_effective_start_date_col PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
2700: l_effective_end_date_col PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
2701:
2702: l_counter number;
2703: l_curr_line_number number;

Line 2700: l_effective_end_date_col PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;

2696: l_price_type_col PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2697: l_bid_currency_unit_price_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2698: l_price_discount_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2699: l_effective_start_date_col PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
2700: l_effective_end_date_col PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
2701:
2702: l_counter number;
2703: l_curr_line_number number;
2704: BEGIN