DBA Data[Home] [Help]

APPS.PON_NEGOTIATION_PUBLISH_PVT dependencies on PON_NEG_COPY_DATATYPES_GRP

Line 7062: l_doctype_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

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

Line 7063: l_doctype_group_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

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,

Line 7097: l_bizrule_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

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:

Line 7098: l_doctype_rule_required PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

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

Line 7099: l_doctype_rule_validity PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE;

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,

Line 7697: l_interface_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

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;

Line 7698: l_column_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_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;

Line 7699: l_table_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_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;

Line 7700: l_interface_line_id 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;

Line 7701: l_error_message_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR2000_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;

Line 7702: l_error_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR100_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;

Line 7703: l_created_by PON_NEG_COPY_DATATYPES_GRP.NUMBER_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;

Line 7704: l_creation_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_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;

Line 7705: l_last_updated_by 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;

Line 7706: l_last_update_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_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;

Line 7707: l_last_update_login PON_NEG_COPY_DATATYPES_GRP.NUMBER_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;

Line 7708: l_request_id 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;
7712: l_error_value_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 7709: l_entity_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_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;

Line 7710: l_entity_attr_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_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;

Line 7711: l_error_value_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;
7715: l_bid_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 7712: l_error_value_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;

Line 7713: l_error_value_datatype PON_NEG_COPY_DATATYPES_GRP.VARCHAR20_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;

Line 7714: l_auction_header_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_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;

Line 7715: l_bid_number 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;

Line 7716: l_line_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;

Line 7717: l_attribute_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_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;

Line 7718: l_price_element_type_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_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;

Line 7719: l_shipment_number 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;
7723: l_token1_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_TYPE;

Line 7720: l_price_differential_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;
7724: l_token2_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

Line 7721: l_expiration_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_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;

Line 7722: l_token1_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_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;

Line 7723: l_token1_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_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;

Line 7724: l_token2_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_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;

Line 7725: l_token2_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_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;

Line 7726: l_token3_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_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;

Line 7727: l_token3_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_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;

Line 7728: l_token4_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_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;

Line 7729: l_token4_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_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;

Line 7730: l_token5_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_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

Line 7731: l_token5_value PON_NEG_COPY_DATATYPES_GRP.VARCHAR300_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
7735:

Line 7732: l_payment_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_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:
7736: SELECT

Line 7733: l_bid_payment_id PON_NEG_COPY_DATATYPES_GRP.NUMBER_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
7737: INTERFACE_TYPE,