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
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,
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:
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
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,
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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
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:
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
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,