DBA Data[Home] [Help]

APPS.PON_NEGOTIATION_PUBLISH_PVT dependencies on PON_NEG_COPY_DATATYPES_GRP

Line 6204: l_doctype_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

6200:
6201: PROCEDURE LOAD_DOCTYPE_NAME_DATA
6202: IS
6203:
6204: l_doctype_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6205: l_doctype_group_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
6206: BEGIN
6207:
6208: SELECT

Line 6205: l_doctype_group_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

6201: PROCEDURE LOAD_DOCTYPE_NAME_DATA
6202: IS
6203:
6204: l_doctype_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6205: l_doctype_group_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
6206: BEGIN
6207:
6208: SELECT
6209: doctype_id,

Line 6239: l_bizrule_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

6235: PROCEDURE LOAD_BIZRULE_DATA (
6236: p_doctype_id NUMBER
6237: ) IS
6238:
6239: l_bizrule_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
6240: l_doctype_rule_required PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
6241: l_doctype_rule_validity PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
6242: BEGIN
6243:

Line 6240: l_doctype_rule_required PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

6236: p_doctype_id NUMBER
6237: ) IS
6238:
6239: l_bizrule_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
6240: l_doctype_rule_required PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
6241: l_doctype_rule_validity PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
6242: BEGIN
6243:
6244: SELECT

Line 6241: l_doctype_rule_validity PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

6237: ) IS
6238:
6239: l_bizrule_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
6240: l_doctype_rule_required PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
6241: l_doctype_rule_validity PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
6242: BEGIN
6243:
6244: SELECT
6245: BIZRULE.NAME,

Line 6806: l_interface_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

6802:
6803: PROCEDURE RETRIEVE_ERRORS_AND_ROLLBACK (
6804: p_batch_id IN NUMBER
6805: ) IS
6806: l_interface_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
6807: l_column_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
6808: l_table_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
6809: l_interface_line_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6810: l_error_message_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;

Line 6807: l_column_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

6803: PROCEDURE RETRIEVE_ERRORS_AND_ROLLBACK (
6804: p_batch_id IN NUMBER
6805: ) IS
6806: l_interface_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
6807: l_column_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
6808: l_table_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
6809: l_interface_line_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6810: l_error_message_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
6811: l_error_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR100_TYPE;

Line 6808: l_table_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

6804: p_batch_id IN NUMBER
6805: ) IS
6806: l_interface_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
6807: l_column_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
6808: l_table_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
6809: l_interface_line_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6810: l_error_message_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
6811: l_error_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR100_TYPE;
6812: l_created_by PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 6809: l_interface_line_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

6805: ) IS
6806: l_interface_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
6807: l_column_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
6808: l_table_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
6809: l_interface_line_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6810: l_error_message_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
6811: l_error_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR100_TYPE;
6812: l_created_by PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6813: l_creation_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;

Line 6810: l_error_message_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;

6806: l_interface_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
6807: l_column_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
6808: l_table_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
6809: l_interface_line_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6810: l_error_message_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
6811: l_error_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR100_TYPE;
6812: l_created_by PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6813: l_creation_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
6814: l_last_updated_by PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 6811: l_error_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR100_TYPE;

6807: l_column_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
6808: l_table_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
6809: l_interface_line_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6810: l_error_message_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
6811: l_error_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR100_TYPE;
6812: l_created_by PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6813: l_creation_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
6814: l_last_updated_by PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6815: l_last_update_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;

Line 6812: l_created_by PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

6808: l_table_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
6809: l_interface_line_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6810: l_error_message_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
6811: l_error_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR100_TYPE;
6812: l_created_by PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6813: l_creation_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
6814: l_last_updated_by PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6815: l_last_update_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
6816: l_last_update_login PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 6813: l_creation_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;

6809: l_interface_line_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6810: l_error_message_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
6811: l_error_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR100_TYPE;
6812: l_created_by PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6813: l_creation_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
6814: l_last_updated_by PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6815: l_last_update_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
6816: l_last_update_login PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6817: l_request_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 6814: l_last_updated_by PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

6810: l_error_message_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
6811: l_error_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR100_TYPE;
6812: l_created_by PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6813: l_creation_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
6814: l_last_updated_by PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6815: l_last_update_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
6816: l_last_update_login PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6817: l_request_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6818: l_entity_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

Line 6815: l_last_update_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;

6811: l_error_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR100_TYPE;
6812: l_created_by PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6813: l_creation_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
6814: l_last_updated_by PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6815: l_last_update_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
6816: l_last_update_login PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6817: l_request_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6818: l_entity_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
6819: l_entity_attr_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

Line 6816: l_last_update_login PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

6812: l_created_by PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6813: l_creation_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
6814: l_last_updated_by PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6815: l_last_update_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
6816: l_last_update_login PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6817: l_request_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6818: l_entity_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
6819: l_entity_attr_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
6820: l_error_value_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;

Line 6817: l_request_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

6813: l_creation_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
6814: l_last_updated_by PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6815: l_last_update_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
6816: l_last_update_login PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6817: l_request_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6818: l_entity_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
6819: l_entity_attr_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
6820: l_error_value_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
6821: l_error_value_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 6818: l_entity_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

6814: l_last_updated_by PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6815: l_last_update_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
6816: l_last_update_login PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6817: l_request_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6818: l_entity_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
6819: l_entity_attr_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
6820: l_error_value_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
6821: l_error_value_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6822: l_error_value_datatype PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;

Line 6819: l_entity_attr_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

6815: l_last_update_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
6816: l_last_update_login PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6817: l_request_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6818: l_entity_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
6819: l_entity_attr_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
6820: l_error_value_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
6821: l_error_value_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6822: l_error_value_datatype PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
6823: l_auction_header_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 6820: l_error_value_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;

6816: l_last_update_login PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6817: l_request_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6818: l_entity_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
6819: l_entity_attr_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
6820: l_error_value_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
6821: l_error_value_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6822: l_error_value_datatype PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
6823: l_auction_header_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6824: l_bid_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 6821: l_error_value_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

6817: l_request_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6818: l_entity_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
6819: l_entity_attr_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
6820: l_error_value_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
6821: l_error_value_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6822: l_error_value_datatype PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
6823: l_auction_header_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6824: l_bid_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6825: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 6822: l_error_value_datatype PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;

6818: l_entity_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
6819: l_entity_attr_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
6820: l_error_value_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
6821: l_error_value_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6822: l_error_value_datatype PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
6823: l_auction_header_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6824: l_bid_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6825: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6826: l_attribute_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;

Line 6823: l_auction_header_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

6819: l_entity_attr_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
6820: l_error_value_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
6821: l_error_value_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6822: l_error_value_datatype PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
6823: l_auction_header_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6824: l_bid_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6825: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6826: l_attribute_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6827: l_price_element_type_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 6824: l_bid_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

6820: l_error_value_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
6821: l_error_value_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6822: l_error_value_datatype PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
6823: l_auction_header_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6824: l_bid_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6825: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6826: l_attribute_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6827: l_price_element_type_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6828: l_shipment_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 6825: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

6821: l_error_value_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6822: l_error_value_datatype PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
6823: l_auction_header_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6824: l_bid_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6825: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6826: l_attribute_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6827: l_price_element_type_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6828: l_shipment_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6829: l_price_differential_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 6826: l_attribute_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;

6822: l_error_value_datatype PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
6823: l_auction_header_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6824: l_bid_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6825: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6826: l_attribute_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6827: l_price_element_type_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6828: l_shipment_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6829: l_price_differential_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6830: l_expiration_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;

Line 6827: l_price_element_type_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

6823: l_auction_header_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6824: l_bid_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6825: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6826: l_attribute_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6827: l_price_element_type_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6828: l_shipment_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6829: l_price_differential_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6830: l_expiration_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
6831: l_token1_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

Line 6828: l_shipment_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

6824: l_bid_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6825: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6826: l_attribute_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6827: l_price_element_type_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6828: l_shipment_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6829: l_price_differential_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6830: l_expiration_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
6831: l_token1_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
6832: l_token1_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;

Line 6829: l_price_differential_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

6825: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6826: l_attribute_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6827: l_price_element_type_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6828: l_shipment_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6829: l_price_differential_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6830: l_expiration_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
6831: l_token1_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
6832: l_token1_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6833: l_token2_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

Line 6830: l_expiration_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;

6826: l_attribute_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6827: l_price_element_type_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6828: l_shipment_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6829: l_price_differential_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6830: l_expiration_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
6831: l_token1_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
6832: l_token1_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6833: l_token2_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
6834: l_token2_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;

Line 6831: l_token1_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

6827: l_price_element_type_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6828: l_shipment_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6829: l_price_differential_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6830: l_expiration_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
6831: l_token1_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
6832: l_token1_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6833: l_token2_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
6834: l_token2_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6835: l_token3_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

Line 6832: l_token1_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;

6828: l_shipment_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6829: l_price_differential_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6830: l_expiration_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
6831: l_token1_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
6832: l_token1_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6833: l_token2_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
6834: l_token2_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6835: l_token3_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
6836: l_token3_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;

Line 6833: l_token2_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

6829: l_price_differential_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6830: l_expiration_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
6831: l_token1_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
6832: l_token1_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6833: l_token2_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
6834: l_token2_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6835: l_token3_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
6836: l_token3_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6837: l_token4_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

Line 6834: l_token2_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;

6830: l_expiration_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
6831: l_token1_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
6832: l_token1_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6833: l_token2_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
6834: l_token2_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6835: l_token3_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
6836: l_token3_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6837: l_token4_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
6838: l_token4_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;

Line 6835: l_token3_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

6831: l_token1_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
6832: l_token1_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6833: l_token2_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
6834: l_token2_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6835: l_token3_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
6836: l_token3_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6837: l_token4_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
6838: l_token4_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6839: l_token5_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

Line 6836: l_token3_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;

6832: l_token1_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6833: l_token2_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
6834: l_token2_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6835: l_token3_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
6836: l_token3_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6837: l_token4_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
6838: l_token4_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6839: l_token5_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
6840: l_token5_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;

Line 6837: l_token4_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

6833: l_token2_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
6834: l_token2_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6835: l_token3_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
6836: l_token3_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6837: l_token4_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
6838: l_token4_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6839: l_token5_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
6840: l_token5_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6841: l_payment_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 6838: l_token4_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;

6834: l_token2_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6835: l_token3_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
6836: l_token3_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6837: l_token4_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
6838: l_token4_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6839: l_token5_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
6840: l_token5_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6841: l_payment_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6842: l_bid_payment_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 6839: l_token5_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

6835: l_token3_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
6836: l_token3_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6837: l_token4_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
6838: l_token4_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6839: l_token5_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
6840: l_token5_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6841: l_payment_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6842: l_bid_payment_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6843: BEGIN

Line 6840: l_token5_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;

6836: l_token3_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6837: l_token4_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
6838: l_token4_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6839: l_token5_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
6840: l_token5_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6841: l_payment_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6842: l_bid_payment_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6843: BEGIN
6844:

Line 6841: l_payment_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

6837: l_token4_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
6838: l_token4_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6839: l_token5_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
6840: l_token5_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6841: l_payment_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6842: l_bid_payment_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6843: BEGIN
6844:
6845: SELECT

Line 6842: l_bid_payment_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

6838: l_token4_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6839: l_token5_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
6840: l_token5_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
6841: l_payment_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6842: l_bid_payment_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6843: BEGIN
6844:
6845: SELECT
6846: INTERFACE_TYPE,