7058:
7059: PROCEDURE LOAD_DOCTYPE_NAME_DATA
7060: IS
7061:
7062: l_doctype_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7063: l_doctype_group_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
7064: BEGIN
7065:
7066: SELECT
7059: PROCEDURE LOAD_DOCTYPE_NAME_DATA
7060: IS
7061:
7062: l_doctype_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7063: l_doctype_group_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
7064: BEGIN
7065:
7066: SELECT
7067: doctype_id,
7093: PROCEDURE LOAD_BIZRULE_DATA (
7094: p_doctype_id NUMBER
7095: ) IS
7096:
7097: l_bizrule_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
7098: l_doctype_rule_required PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
7099: l_doctype_rule_validity PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
7100: BEGIN
7101:
7094: p_doctype_id NUMBER
7095: ) IS
7096:
7097: l_bizrule_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
7098: l_doctype_rule_required PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
7099: l_doctype_rule_validity PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
7100: BEGIN
7101:
7102: SELECT
7095: ) IS
7096:
7097: l_bizrule_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
7098: l_doctype_rule_required PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
7099: l_doctype_rule_validity PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;
7100: BEGIN
7101:
7102: SELECT
7103: BIZRULE.NAME,
7693:
7694: PROCEDURE RETRIEVE_ERRORS_AND_ROLLBACK (
7695: p_batch_id IN NUMBER
7696: ) IS
7697: l_interface_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
7698: l_column_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
7699: l_table_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
7700: l_interface_line_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7701: l_error_message_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
7694: PROCEDURE RETRIEVE_ERRORS_AND_ROLLBACK (
7695: p_batch_id IN NUMBER
7696: ) IS
7697: l_interface_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
7698: l_column_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
7699: l_table_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
7700: l_interface_line_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7701: l_error_message_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
7702: l_error_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR100_TYPE;
7695: p_batch_id IN NUMBER
7696: ) IS
7697: l_interface_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
7698: l_column_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
7699: l_table_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
7700: l_interface_line_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7701: l_error_message_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
7702: l_error_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR100_TYPE;
7703: l_created_by PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7696: ) IS
7697: l_interface_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
7698: l_column_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
7699: l_table_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
7700: l_interface_line_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7701: l_error_message_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
7702: l_error_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR100_TYPE;
7703: l_created_by PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7704: l_creation_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
7697: l_interface_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
7698: l_column_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
7699: l_table_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
7700: l_interface_line_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7701: l_error_message_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
7702: l_error_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR100_TYPE;
7703: l_created_by PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7704: l_creation_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
7705: l_last_updated_by PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7698: l_column_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
7699: l_table_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
7700: l_interface_line_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7701: l_error_message_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
7702: l_error_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR100_TYPE;
7703: l_created_by PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7704: l_creation_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
7705: l_last_updated_by PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7706: l_last_update_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
7699: l_table_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
7700: l_interface_line_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7701: l_error_message_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
7702: l_error_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR100_TYPE;
7703: l_created_by PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7704: l_creation_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
7705: l_last_updated_by PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7706: l_last_update_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
7707: l_last_update_login PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7700: l_interface_line_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7701: l_error_message_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
7702: l_error_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR100_TYPE;
7703: l_created_by PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7704: l_creation_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
7705: l_last_updated_by PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7706: l_last_update_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
7707: l_last_update_login PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7708: l_request_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7701: l_error_message_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_TYPE;
7702: l_error_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR100_TYPE;
7703: l_created_by PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7704: l_creation_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
7705: l_last_updated_by PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7706: l_last_update_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
7707: l_last_update_login PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7708: l_request_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7709: l_entity_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
7702: l_error_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR100_TYPE;
7703: l_created_by PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7704: l_creation_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
7705: l_last_updated_by PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7706: l_last_update_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
7707: l_last_update_login PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7708: l_request_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7709: l_entity_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
7710: l_entity_attr_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
7703: l_created_by PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7704: l_creation_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
7705: l_last_updated_by PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7706: l_last_update_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
7707: l_last_update_login PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7708: l_request_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7709: l_entity_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
7710: l_entity_attr_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
7711: l_error_value_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
7704: l_creation_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
7705: l_last_updated_by PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7706: l_last_update_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
7707: l_last_update_login PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7708: l_request_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7709: l_entity_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
7710: l_entity_attr_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
7711: l_error_value_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
7712: l_error_value_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7705: l_last_updated_by PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7706: l_last_update_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
7707: l_last_update_login PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7708: l_request_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7709: l_entity_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
7710: l_entity_attr_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
7711: l_error_value_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
7712: l_error_value_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7713: l_error_value_datatype PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
7706: l_last_update_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
7707: l_last_update_login PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7708: l_request_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7709: l_entity_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
7710: l_entity_attr_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
7711: l_error_value_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
7712: l_error_value_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7713: l_error_value_datatype PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
7714: l_auction_header_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7707: l_last_update_login PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7708: l_request_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7709: l_entity_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
7710: l_entity_attr_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
7711: l_error_value_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
7712: l_error_value_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7713: l_error_value_datatype PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
7714: l_auction_header_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7715: l_bid_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7708: l_request_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7709: l_entity_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
7710: l_entity_attr_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
7711: l_error_value_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
7712: l_error_value_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7713: l_error_value_datatype PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
7714: l_auction_header_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7715: l_bid_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7716: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7709: l_entity_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
7710: l_entity_attr_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
7711: l_error_value_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
7712: l_error_value_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7713: l_error_value_datatype PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
7714: l_auction_header_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7715: l_bid_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7716: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7717: l_attribute_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
7710: l_entity_attr_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
7711: l_error_value_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
7712: l_error_value_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7713: l_error_value_datatype PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
7714: l_auction_header_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7715: l_bid_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7716: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7717: l_attribute_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
7718: l_price_element_type_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7711: l_error_value_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
7712: l_error_value_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7713: l_error_value_datatype PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
7714: l_auction_header_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7715: l_bid_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7716: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7717: l_attribute_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
7718: l_price_element_type_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7719: l_shipment_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7712: l_error_value_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7713: l_error_value_datatype PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
7714: l_auction_header_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7715: l_bid_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7716: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7717: l_attribute_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
7718: l_price_element_type_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7719: l_shipment_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7720: l_price_differential_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7713: l_error_value_datatype PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_TYPE;
7714: l_auction_header_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7715: l_bid_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7716: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7717: l_attribute_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
7718: l_price_element_type_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7719: l_shipment_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7720: l_price_differential_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7721: l_expiration_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
7714: l_auction_header_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7715: l_bid_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7716: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7717: l_attribute_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
7718: l_price_element_type_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7719: l_shipment_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7720: l_price_differential_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7721: l_expiration_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
7722: l_token1_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
7715: l_bid_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7716: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7717: l_attribute_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
7718: l_price_element_type_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7719: l_shipment_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7720: l_price_differential_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7721: l_expiration_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
7722: l_token1_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
7723: l_token1_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
7716: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7717: l_attribute_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
7718: l_price_element_type_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7719: l_shipment_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7720: l_price_differential_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7721: l_expiration_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
7722: l_token1_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
7723: l_token1_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
7724: l_token2_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
7717: l_attribute_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
7718: l_price_element_type_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7719: l_shipment_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7720: l_price_differential_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7721: l_expiration_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
7722: l_token1_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
7723: l_token1_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
7724: l_token2_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
7725: l_token2_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
7718: l_price_element_type_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7719: l_shipment_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7720: l_price_differential_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7721: l_expiration_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
7722: l_token1_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
7723: l_token1_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
7724: l_token2_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
7725: l_token2_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
7726: l_token3_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
7719: l_shipment_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7720: l_price_differential_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7721: l_expiration_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
7722: l_token1_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
7723: l_token1_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
7724: l_token2_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
7725: l_token2_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
7726: l_token3_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
7727: l_token3_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
7720: l_price_differential_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7721: l_expiration_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
7722: l_token1_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
7723: l_token1_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
7724: l_token2_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
7725: l_token2_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
7726: l_token3_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
7727: l_token3_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
7728: l_token4_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
7721: l_expiration_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
7722: l_token1_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
7723: l_token1_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
7724: l_token2_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
7725: l_token2_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
7726: l_token3_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
7727: l_token3_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
7728: l_token4_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
7729: l_token4_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
7722: l_token1_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
7723: l_token1_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
7724: l_token2_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
7725: l_token2_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
7726: l_token3_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
7727: l_token3_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
7728: l_token4_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
7729: l_token4_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
7730: l_token5_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
7723: l_token1_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
7724: l_token2_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
7725: l_token2_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
7726: l_token3_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
7727: l_token3_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
7728: l_token4_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
7729: l_token4_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
7730: l_token5_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
7731: l_token5_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
7724: l_token2_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
7725: l_token2_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
7726: l_token3_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
7727: l_token3_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
7728: l_token4_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
7729: l_token4_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
7730: l_token5_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
7731: l_token5_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
7732: l_payment_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7725: l_token2_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
7726: l_token3_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
7727: l_token3_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
7728: l_token4_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
7729: l_token4_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
7730: l_token5_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
7731: l_token5_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
7732: l_payment_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7733: l_bid_payment_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7726: l_token3_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
7727: l_token3_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
7728: l_token4_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
7729: l_token4_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
7730: l_token5_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
7731: l_token5_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
7732: l_payment_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7733: l_bid_payment_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7734: BEGIN
7727: l_token3_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
7728: l_token4_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
7729: l_token4_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
7730: l_token5_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
7731: l_token5_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
7732: l_payment_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7733: l_bid_payment_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7734: BEGIN
7735:
7728: l_token4_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
7729: l_token4_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
7730: l_token5_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
7731: l_token5_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
7732: l_payment_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7733: l_bid_payment_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7734: BEGIN
7735:
7736: SELECT
7729: l_token4_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
7730: l_token5_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
7731: l_token5_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;
7732: l_payment_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7733: l_bid_payment_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
7734: BEGIN
7735:
7736: SELECT
7737: INTERFACE_TYPE,