[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
CLAIM_ID
,OBJECT_VERSION_NUMBER
,LAST_UPDATE_DATE
,LAST_UPDATED_BY
,CREATION_DATE
,CREATED_BY
,LAST_UPDATE_LOGIN
,REQUEST_ID
,PROGRAM_APPLICATION_ID
,PROGRAM_UPDATE_DATE
,PROGRAM_ID
,CREATED_FROM
,BATCH_ID
,CLAIM_NUMBER
,CLAIM_TYPE_ID
,CLAIM_CLASS
,CLAIM_DATE
,DUE_DATE
,OWNER_ID
,HISTORY_EVENT
,HISTORY_EVENT_DATE
,HISTORY_EVENT_DESCRIPTION
,SPLIT_FROM_CLAIM_ID
,DUPLICATE_CLAIM_ID
,SPLIT_DATE
,ROOT_CLAIM_ID
,AMOUNT
,AMOUNT_ADJUSTED
,AMOUNT_REMAINING
,AMOUNT_SETTLED
,ACCTD_AMOUNT
,ACCTD_AMOUNT_REMAINING
,TAX_AMOUNT
,TAX_CODE
,TAX_CALCULATION_FLAG
,CURRENCY_CODE
,EXCHANGE_RATE_TYPE
,EXCHANGE_RATE_DATE
,EXCHANGE_RATE
,SET_OF_BOOKS_ID
,ORIGINAL_CLAIM_DATE
,SOURCE_OBJECT_ID
,SOURCE_OBJECT_CLASS
,SOURCE_OBJECT_TYPE_ID
,SOURCE_OBJECT_NUMBER
,CUST_ACCOUNT_ID
,CUST_BILLTO_ACCT_SITE_ID
,CUST_SHIPTO_ACCT_SITE_ID
,LOCATION_ID
,PAY_RELATED_ACCOUNT_FLAG
,RELATED_CUST_ACCOUNT_ID
,RELATED_SITE_USE_ID
,RELATIONSHIP_TYPE
,VENDOR_ID
,VENDOR_SITE_ID
,REASON_TYPE
,REASON_CODE_ID
,TASK_TEMPLATE_GROUP_ID
,STATUS_CODE
,USER_STATUS_ID
,SALES_REP_ID
,COLLECTOR_ID
,CONTACT_ID
,BROKER_ID
,TERRITORY_ID
,CUSTOMER_REF_DATE
,CUSTOMER_REF_NUMBER
,ASSIGNED_TO
,RECEIPT_ID
,RECEIPT_NUMBER
,DOC_SEQUENCE_ID
,DOC_SEQUENCE_VALUE
,GL_DATE
,PAYMENT_METHOD
,VOUCHER_ID
,VOUCHER_NUMBER
,PAYMENT_REFERENCE_ID
,PAYMENT_REFERENCE_NUMBER
,PAYMENT_REFERENCE_DATE
,PAYMENT_STATUS
,APPROVED_FLAG
,APPROVED_DATE
,APPROVED_BY
,SETTLED_DATE
,SETTLED_BY
,EFFECTIVE_DATE
,CUSTOM_SETUP_ID
,TASK_ID
,COUNTRY_ID
,COMMENTS
,ATTRIBUTE_CATEGORY
,ATTRIBUTE1
,ATTRIBUTE2
,ATTRIBUTE3
,ATTRIBUTE4
,ATTRIBUTE5
,ATTRIBUTE6
,ATTRIBUTE7
,ATTRIBUTE8
,ATTRIBUTE9
,ATTRIBUTE10
,ATTRIBUTE11
,ATTRIBUTE12
,ATTRIBUTE13
,ATTRIBUTE14
,ATTRIBUTE15
,DEDUCTION_ATTRIBUTE_CATEGORY
,DEDUCTION_ATTRIBUTE1
,DEDUCTION_ATTRIBUTE2
,DEDUCTION_ATTRIBUTE3
,DEDUCTION_ATTRIBUTE4
,DEDUCTION_ATTRIBUTE5
,DEDUCTION_ATTRIBUTE6
,DEDUCTION_ATTRIBUTE7
,DEDUCTION_ATTRIBUTE8
,DEDUCTION_ATTRIBUTE9
,DEDUCTION_ATTRIBUTE10
,DEDUCTION_ATTRIBUTE11
,DEDUCTION_ATTRIBUTE12
,DEDUCTION_ATTRIBUTE13
,DEDUCTION_ATTRIBUTE14
,DEDUCTION_ATTRIBUTE15
,ORG_ID
,CUSTOMER_REASON -- 11.5.10 Enhancements. TM should pass.
,SHIP_TO_CUST_ACCOUNT_ID
,LEGAL_ENTITY_ID
INTO
x_claim_rec.claim_id
,x_claim_rec.object_version_number
,x_claim_rec.last_update_date
,x_claim_rec.last_updated_by
,x_claim_rec.creation_date
,x_claim_rec.created_by
,x_claim_rec.last_update_login
,x_claim_rec.request_id
,x_claim_rec.program_application_id
,x_claim_rec.program_update_date
,x_claim_rec.program_id
,x_claim_rec.created_from
,x_claim_rec.batch_id
,x_claim_rec.claim_number
,x_claim_rec.claim_type_id
,x_claim_rec.claim_class
,x_claim_rec.claim_date
,x_claim_rec.due_date
,x_claim_rec.owner_id
,x_claim_rec.history_event
,x_claim_rec.history_event_date
,x_claim_rec.history_event_description
,x_claim_rec.split_from_claim_id
,x_claim_rec.duplicate_claim_id
,x_claim_rec.split_date
,x_claim_rec.root_claim_id
,x_claim_rec.amount
,x_claim_rec.amount_adjusted
,x_claim_rec.amount_remaining
,x_claim_rec.amount_settled
,x_claim_rec.acctd_amount
,x_claim_rec.acctd_amount_remaining
,x_claim_rec.tax_amount
,x_claim_rec.tax_code
,x_claim_rec.tax_calculation_flag
,x_claim_rec.currency_code
,x_claim_rec.exchange_rate_type
,x_claim_rec.exchange_rate_date
,x_claim_rec.exchange_rate
,x_claim_rec.set_of_books_id
,x_claim_rec.original_claim_date
,x_claim_rec.source_object_id
,x_claim_rec.source_object_class
,x_claim_rec.source_object_type_id
,x_claim_rec.source_object_number
,x_claim_rec.cust_account_id
,x_claim_rec.cust_billto_acct_site_id
,x_claim_rec.cust_shipto_acct_site_id
,x_claim_rec.location_id
,x_claim_rec.pay_related_account_flag
,x_claim_rec.related_cust_account_id
,x_claim_rec.related_site_use_id
,x_claim_rec.relationship_type
,x_claim_rec.vendor_id
,x_claim_rec.vendor_site_id
,x_claim_rec.reason_type
,x_claim_rec.reason_code_id
,x_claim_rec.task_template_group_id
,x_claim_rec.status_code
,x_claim_rec.user_status_id
,x_claim_rec.sales_rep_id
,x_claim_rec.collector_id
,x_claim_rec.contact_id
,x_claim_rec.broker_id
,x_claim_rec.territory_id
,x_claim_rec.customer_ref_date
,x_claim_rec.customer_ref_number
,x_claim_rec.assigned_to
,x_claim_rec.receipt_id
,x_claim_rec.receipt_number
,x_claim_rec.doc_sequence_id
,x_claim_rec.doc_sequence_value
,x_claim_rec.gl_date
,x_claim_rec.payment_method
,x_claim_rec.voucher_id
,x_claim_rec.voucher_number
,x_claim_rec.payment_reference_id
,x_claim_rec.payment_reference_number
,x_claim_rec.payment_reference_date
,x_claim_rec.payment_status
,x_claim_rec.approved_flag
,x_claim_rec.approved_date
,x_claim_rec.approved_by
,x_claim_rec.settled_date
,x_claim_rec.settled_by
,x_claim_rec.effective_date
,x_claim_rec.custom_setup_id
,x_claim_rec.task_id
,x_claim_rec.country_id
,x_claim_rec.comments
,x_claim_rec.attribute_category
,x_claim_rec.attribute1
,x_claim_rec.attribute2
,x_claim_rec.attribute3
,x_claim_rec.attribute4
,x_claim_rec.attribute5
,x_claim_rec.attribute6
,x_claim_rec.attribute7
,x_claim_rec.attribute8
,x_claim_rec.attribute9
,x_claim_rec.attribute10
,x_claim_rec.attribute11
,x_claim_rec.attribute12
,x_claim_rec.attribute13
,x_claim_rec.attribute14
,x_claim_rec.attribute15
,x_claim_rec.deduction_attribute_category
,x_claim_rec.deduction_attribute1
,x_claim_rec.deduction_attribute2
,x_claim_rec.deduction_attribute3
,x_claim_rec.deduction_attribute4
,x_claim_rec.deduction_attribute5
,x_claim_rec.deduction_attribute6
,x_claim_rec.deduction_attribute7
,x_claim_rec.deduction_attribute8
,x_claim_rec.deduction_attribute9
,x_claim_rec.deduction_attribute10
,x_claim_rec.deduction_attribute11
,x_claim_rec.deduction_attribute12
,x_claim_rec.deduction_attribute13
,x_claim_rec.deduction_attribute14
,x_claim_rec.deduction_attribute15
,x_claim_rec.org_id
,x_claim_rec.customer_reason -- 11.5.10 Enhancements. TM should pass.
,x_claim_rec.ship_to_cust_account_id
,x_claim_rec.legal_entity_id
FROM ozf_claims_all
WHERE claim_id = p_claim_id ;
PROCEDURE Insert_Int_Distributions
( p_int_distributions_rec IN RA_Int_Distributions_Rec_Type
,x_return_status OUT NOCOPY VARCHAR2
) IS
BEGIN
INSERT INTO RA_INTERFACE_DISTRIBUTIONS_ALL
(
INTERFACE_DISTRIBUTION_ID,
INTERFACE_LINE_ID,
INTERFACE_LINE_CONTEXT,
INTERFACE_LINE_ATTRIBUTE1,
INTERFACE_LINE_ATTRIBUTE2,
INTERFACE_LINE_ATTRIBUTE3,
INTERFACE_LINE_ATTRIBUTE4,
INTERFACE_LINE_ATTRIBUTE5,
INTERFACE_LINE_ATTRIBUTE6,
INTERFACE_LINE_ATTRIBUTE7,
INTERFACE_LINE_ATTRIBUTE8,
INTERFACE_LINE_ATTRIBUTE9,
INTERFACE_LINE_ATTRIBUTE10,
INTERFACE_LINE_ATTRIBUTE11,
INTERFACE_LINE_ATTRIBUTE12,
INTERFACE_LINE_ATTRIBUTE13,
INTERFACE_LINE_ATTRIBUTE14,
INTERFACE_LINE_ATTRIBUTE15,
ACCOUNT_CLASS,
AMOUNT,
ACCTD_AMOUNT,
PERCENT,
INTERFACE_STATUS,
REQUEST_ID,
CODE_COMBINATION_ID,
SEGMENT1,
SEGMENT2,
SEGMENT3,
SEGMENT4,
SEGMENT5,
SEGMENT6,
SEGMENT7,
SEGMENT8,
SEGMENT9,
SEGMENT10,
SEGMENT11,
SEGMENT12,
SEGMENT13,
SEGMENT14,
SEGMENT15,
SEGMENT16,
SEGMENT17,
SEGMENT18,
SEGMENT19,
SEGMENT20,
SEGMENT21,
SEGMENT22,
SEGMENT23,
SEGMENT24,
SEGMENT25,
SEGMENT26,
SEGMENT27,
SEGMENT28,
SEGMENT29,
SEGMENT30,
COMMENTS,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN,
ORG_ID,
INTERIM_TAX_CCID,
INTERIM_TAX_SEGMENT1,
INTERIM_TAX_SEGMENT2,
INTERIM_TAX_SEGMENT3,
INTERIM_TAX_SEGMENT4,
INTERIM_TAX_SEGMENT5,
INTERIM_TAX_SEGMENT6,
INTERIM_TAX_SEGMENT7,
INTERIM_TAX_SEGMENT8,
INTERIM_TAX_SEGMENT9,
INTERIM_TAX_SEGMENT10,
INTERIM_TAX_SEGMENT11,
INTERIM_TAX_SEGMENT12,
INTERIM_TAX_SEGMENT13,
INTERIM_TAX_SEGMENT14,
INTERIM_TAX_SEGMENT15,
INTERIM_TAX_SEGMENT16,
INTERIM_TAX_SEGMENT17,
INTERIM_TAX_SEGMENT18,
INTERIM_TAX_SEGMENT19,
INTERIM_TAX_SEGMENT20,
INTERIM_TAX_SEGMENT21,
INTERIM_TAX_SEGMENT22,
INTERIM_TAX_SEGMENT23,
INTERIM_TAX_SEGMENT24,
INTERIM_TAX_SEGMENT25,
INTERIM_TAX_SEGMENT26,
INTERIM_TAX_SEGMENT27,
INTERIM_TAX_SEGMENT28,
INTERIM_TAX_SEGMENT29,
INTERIM_TAX_SEGMENT30
)
VALUES
(
p_int_distributions_rec.interface_distribution_id,
p_int_distributions_rec.interface_line_id,
p_int_distributions_rec.interface_line_context,
p_int_distributions_rec.interface_line_attribute1,
p_int_distributions_rec.interface_line_attribute2,
p_int_distributions_rec.interface_line_attribute3,
p_int_distributions_rec.interface_line_attribute4,
p_int_distributions_rec.interface_line_attribute5,
p_int_distributions_rec.interface_line_attribute6,
p_int_distributions_rec.interface_line_attribute7,
p_int_distributions_rec.interface_line_attribute8,
p_int_distributions_rec.interface_line_attribute9,
p_int_distributions_rec.interface_line_attribute10,
p_int_distributions_rec.interface_line_attribute11,
p_int_distributions_rec.interface_line_attribute12,
p_int_distributions_rec.interface_line_attribute13,
p_int_distributions_rec.interface_line_attribute14,
p_int_distributions_rec.interface_line_attribute15,
p_int_distributions_rec.account_class,
p_int_distributions_rec.amount,
p_int_distributions_rec.acctd_amount,
p_int_distributions_rec.percent,
p_int_distributions_rec.interface_status,
p_int_distributions_rec.request_id,
p_int_distributions_rec.code_combination_id,
p_int_distributions_rec.segment1,
p_int_distributions_rec.segment2,
p_int_distributions_rec.segment3,
p_int_distributions_rec.segment4,
p_int_distributions_rec.segment5,
p_int_distributions_rec.segment6,
p_int_distributions_rec.segment7,
p_int_distributions_rec.segment8,
p_int_distributions_rec.segment9,
p_int_distributions_rec.segment10,
p_int_distributions_rec.segment11,
p_int_distributions_rec.segment12,
p_int_distributions_rec.segment13,
p_int_distributions_rec.segment14,
p_int_distributions_rec.segment15,
p_int_distributions_rec.segment16,
p_int_distributions_rec.segment17,
p_int_distributions_rec.segment18,
p_int_distributions_rec.segment19,
p_int_distributions_rec.segment20,
p_int_distributions_rec.segment21,
p_int_distributions_rec.segment22,
p_int_distributions_rec.segment23,
p_int_distributions_rec.segment24,
p_int_distributions_rec.segment25,
p_int_distributions_rec.segment26,
p_int_distributions_rec.segment27,
p_int_distributions_rec.segment28,
p_int_distributions_rec.segment29,
p_int_distributions_rec.segment30,
p_int_distributions_rec.comments,
p_int_distributions_rec.attribute_category,
p_int_distributions_rec.attribute1,
p_int_distributions_rec.attribute2,
p_int_distributions_rec.attribute3,
p_int_distributions_rec.attribute4,
p_int_distributions_rec.attribute5,
p_int_distributions_rec.attribute6,
p_int_distributions_rec.attribute7,
p_int_distributions_rec.attribute8,
p_int_distributions_rec.attribute9,
p_int_distributions_rec.attribute10,
p_int_distributions_rec.attribute11,
p_int_distributions_rec.attribute12,
p_int_distributions_rec.attribute13,
p_int_distributions_rec.attribute14,
p_int_distributions_rec.attribute15,
p_int_distributions_rec.created_by,
p_int_distributions_rec.creation_date,
p_int_distributions_rec.last_updated_by,
p_int_distributions_rec.last_update_date,
p_int_distributions_rec.last_update_login,
p_int_distributions_rec.org_id,
p_int_distributions_rec.interim_tax_ccid,
p_int_distributions_rec.interim_tax_segment1,
p_int_distributions_rec.interim_tax_segment2,
p_int_distributions_rec.interim_tax_segment3,
p_int_distributions_rec.interim_tax_segment4,
p_int_distributions_rec.interim_tax_segment5,
p_int_distributions_rec.interim_tax_segment6,
p_int_distributions_rec.interim_tax_segment7,
p_int_distributions_rec.interim_tax_segment8,
p_int_distributions_rec.interim_tax_segment9,
p_int_distributions_rec.interim_tax_segment10,
p_int_distributions_rec.interim_tax_segment11,
p_int_distributions_rec.interim_tax_segment12,
p_int_distributions_rec.interim_tax_segment13,
p_int_distributions_rec.interim_tax_segment14,
p_int_distributions_rec.interim_tax_segment15,
p_int_distributions_rec.interim_tax_segment16,
p_int_distributions_rec.interim_tax_segment17,
p_int_distributions_rec.interim_tax_segment18,
p_int_distributions_rec.interim_tax_segment19,
p_int_distributions_rec.interim_tax_segment20,
p_int_distributions_rec.interim_tax_segment21,
p_int_distributions_rec.interim_tax_segment22,
p_int_distributions_rec.interim_tax_segment23,
p_int_distributions_rec.interim_tax_segment24,
p_int_distributions_rec.interim_tax_segment25,
p_int_distributions_rec.interim_tax_segment26,
p_int_distributions_rec.interim_tax_segment27,
p_int_distributions_rec.interim_tax_segment28,
p_int_distributions_rec.interim_tax_segment29,
p_int_distributions_rec.interim_tax_segment30
);
END Insert_Int_Distributions ;
PROCEDURE Insert_Interface_Line
( p_interface_line_rec IN RA_Interface_Lines_Rec_Type
,x_return_status OUT NOCOPY VARCHAR2
) IS
BEGIN
INSERT INTO RA_INTERFACE_LINES_ALL
( CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, INTERFACE_LINE_ATTRIBUTE1
, INTERFACE_LINE_ATTRIBUTE2
, INTERFACE_LINE_ATTRIBUTE3
, INTERFACE_LINE_ATTRIBUTE4
, INTERFACE_LINE_ATTRIBUTE5
, INTERFACE_LINE_ATTRIBUTE6
, INTERFACE_LINE_ATTRIBUTE7
, INTERFACE_LINE_ATTRIBUTE8
, INTERFACE_LINE_ATTRIBUTE9
, INTERFACE_LINE_ATTRIBUTE10
, INTERFACE_LINE_ATTRIBUTE11
, INTERFACE_LINE_ATTRIBUTE12
, INTERFACE_LINE_ATTRIBUTE13
, INTERFACE_LINE_ATTRIBUTE14
, INTERFACE_LINE_ATTRIBUTE15
, INTERFACE_LINE_CONTEXT
, BATCH_SOURCE_NAME
, GL_DATE
, SET_OF_BOOKS_ID
, LINE_TYPE
, DESCRIPTION
, CURRENCY_CODE
, AMOUNT
, CONVERSION_TYPE
, CONVERSION_DATE
, CONVERSION_RATE
, CUST_TRX_TYPE_ID
, TERM_ID
, ORIG_SYSTEM_BILL_CUSTOMER_ID
, ORIG_SYSTEM_BILL_ADDRESS_ID
, ORIG_SYSTEM_BILL_CONTACT_ID
, ORIG_SYSTEM_SHIP_CUSTOMER_ID
, ORIG_SYSTEM_SHIP_ADDRESS_ID
, ORIG_SYSTEM_SHIP_CONTACT_ID
, ORIG_SYSTEM_SOLD_CUSTOMER_ID
, ORG_ID
, AGREEMENT_ID
, COMMENTS
, CREDIT_METHOD_FOR_ACCT_RULE
, CREDIT_METHOD_FOR_INSTALLMENTS
, CUSTOMER_BANK_ACCOUNT_ID
, DOCUMENT_NUMBER
, DOCUMENT_NUMBER_SEQUENCE_ID
, HEADER_ATTRIBUTE_CATEGORY
, HEADER_ATTRIBUTE1
, HEADER_ATTRIBUTE2
, HEADER_ATTRIBUTE3
, HEADER_ATTRIBUTE4
, HEADER_ATTRIBUTE5
, HEADER_ATTRIBUTE6
, HEADER_ATTRIBUTE7
, HEADER_ATTRIBUTE8
, HEADER_ATTRIBUTE9
, HEADER_ATTRIBUTE10
, HEADER_ATTRIBUTE11
, HEADER_ATTRIBUTE12
, HEADER_ATTRIBUTE13
, HEADER_ATTRIBUTE14
, HEADER_ATTRIBUTE15
, INITIAL_CUSTOMER_TRX_ID
, INTERNAL_NOTES
, INVOICING_RULE_ID
, ORIG_SYSTEM_BATCH_NAME
, PREVIOUS_CUSTOMER_TRX_ID
, PRIMARY_SALESREP_ID
, PRINTING_OPTION
, PURCHASE_ORDER
, PURCHASE_ORDER_REVISION
, PURCHASE_ORDER_DATE
, REASON_CODE
, RECEIPT_METHOD_ID
, RELATED_CUSTOMER_TRX_ID
, TERRITORY_ID
, TRX_DATE
, TRX_NUMBER
, MEMO_LINE_ID
, TAX_CODE
, INVENTORY_ITEM_ID
, QUANTITY
, UOM_CODE
, UNIT_SELLING_PRICE
, LEGAL_ENTITY_ID
, SOURCE_APPLICATION_ID
, SOURCE_ENTITY_CODE
,SOURCE_EVENT_CLASS_CODE
)
VALUES (
p_interface_line_rec.created_by
, p_interface_line_rec.creation_date
, p_interface_line_rec.last_updated_by
, p_interface_line_rec.last_update_date
, p_interface_line_rec.interface_line_attribute1
, p_interface_line_rec.interface_line_attribute2
, p_interface_line_rec.interface_line_attribute3
, p_interface_line_rec.interface_line_attribute4
, p_interface_line_rec.interface_line_attribute5
, p_interface_line_rec.interface_line_attribute6
, p_interface_line_rec.interface_line_attribute7
, p_interface_line_rec.interface_line_attribute8
, p_interface_line_rec.interface_line_attribute9
, p_interface_line_rec.interface_line_attribute10
, p_interface_line_rec.interface_line_attribute11
, p_interface_line_rec.interface_line_attribute12
, p_interface_line_rec.interface_line_attribute13
, p_interface_line_rec.interface_line_attribute14
, p_interface_line_rec.interface_line_attribute15
, p_interface_line_rec.interface_line_context
, p_interface_line_rec.batch_source_name
, p_interface_line_rec.gl_date
, p_interface_line_rec.set_of_books_id
, p_interface_line_rec.line_type
, p_interface_line_rec.description
, p_interface_line_rec.currency_code
, p_interface_line_rec.amount
, p_interface_line_rec.conversion_type
, p_interface_line_rec.conversion_date
, p_interface_line_rec.conversion_rate
, p_interface_line_rec.cust_trx_type_id
, p_interface_line_rec.term_id
, p_interface_line_rec.orig_system_bill_customer_id
, p_interface_line_rec.orig_system_bill_address_id
, p_interface_line_rec.orig_system_bill_contact_id
, p_interface_line_rec.orig_system_ship_customer_id
, p_interface_line_rec.orig_system_ship_address_id
, p_interface_line_rec.orig_system_ship_contact_id
, p_interface_line_rec.orig_system_sold_customer_id
, p_interface_line_rec.org_id
, p_interface_line_rec.agreement_id
, p_interface_line_rec.comments
, p_interface_line_rec.credit_method_for_acct_rule
, p_interface_line_rec.credit_method_for_installments
, p_interface_line_rec.customer_bank_account_id
, p_interface_line_rec.document_number
, p_interface_line_rec.document_number_sequence_id
, p_interface_line_rec.header_attribute_category
, p_interface_line_rec.header_attribute1
, p_interface_line_rec.header_attribute2
, p_interface_line_rec.header_attribute3
, p_interface_line_rec.header_attribute4
, p_interface_line_rec.header_attribute5
, p_interface_line_rec.header_attribute6
, p_interface_line_rec.header_attribute7
, p_interface_line_rec.header_attribute8
, p_interface_line_rec.header_attribute9
, p_interface_line_rec.header_attribute10
, p_interface_line_rec.header_attribute11
, p_interface_line_rec.header_attribute12
, p_interface_line_rec.header_attribute13
, p_interface_line_rec.header_attribute14
, p_interface_line_rec.header_attribute15
, p_interface_line_rec.initial_customer_trx_id
, p_interface_line_rec.internal_notes
, p_interface_line_rec.invoicing_rule_id
, p_interface_line_rec.orig_system_batch_name
, p_interface_line_rec.previous_customer_trx_id
, p_interface_line_rec.primary_salesrep_id
, p_interface_line_rec.printing_option
, p_interface_line_rec.purchase_order
, p_interface_line_rec.purchase_order_revision
, p_interface_line_rec.purchase_order_date
, p_interface_line_rec.reason_code
, p_interface_line_rec.receipt_method_id
, p_interface_line_rec.related_customer_trx_id
, p_interface_line_rec.territory_id
, p_interface_line_rec.trx_date
, p_interface_line_rec.trx_number
, p_interface_line_rec.memo_line_id
, p_interface_line_rec.tax_code
, p_interface_line_rec.inventory_item_id
, p_interface_line_rec.quantity
, p_interface_line_rec.uom_code
, p_interface_line_rec.unit_selling_price
, p_interface_line_rec.legal_entity_id
, 682
,'OZF_CLAIMS'
, 'TRADE_MGT_RECEIVABLES'
);
END Insert_Interface_Line ;
PROCEDURE Insert_Interface_Tax
( p_interface_tax_rec IN RA_Interface_Lines_Rec_Type
,x_return_status OUT NOCOPY VARCHAR2
) IS
BEGIN
INSERT INTO RA_INTERFACE_LINES_ALL
( CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, INTERFACE_LINE_ATTRIBUTE1
, INTERFACE_LINE_ATTRIBUTE2
, INTERFACE_LINE_ATTRIBUTE3
, INTERFACE_LINE_ATTRIBUTE4
, INTERFACE_LINE_ATTRIBUTE5
, INTERFACE_LINE_ATTRIBUTE6
, INTERFACE_LINE_ATTRIBUTE7
, INTERFACE_LINE_ATTRIBUTE8
, INTERFACE_LINE_ATTRIBUTE9
, INTERFACE_LINE_ATTRIBUTE10
, INTERFACE_LINE_ATTRIBUTE11
, INTERFACE_LINE_ATTRIBUTE12
, INTERFACE_LINE_ATTRIBUTE13
, INTERFACE_LINE_ATTRIBUTE14
, INTERFACE_LINE_ATTRIBUTE15
, INTERFACE_LINE_CONTEXT
, LINK_TO_LINE_ATTRIBUTE1
, LINK_TO_LINE_ATTRIBUTE2
, LINK_TO_LINE_ATTRIBUTE3
, LINK_TO_LINE_ATTRIBUTE4
, LINK_TO_LINE_ATTRIBUTE5
, LINK_TO_LINE_ATTRIBUTE6
, LINK_TO_LINE_ATTRIBUTE7
, LINK_TO_LINE_ATTRIBUTE8
, LINK_TO_LINE_ATTRIBUTE9
, LINK_TO_LINE_ATTRIBUTE10
, LINK_TO_LINE_ATTRIBUTE11
, LINK_TO_LINE_ATTRIBUTE12
, LINK_TO_LINE_ATTRIBUTE13
, LINK_TO_LINE_ATTRIBUTE14
, LINK_TO_LINE_ATTRIBUTE15
, LINK_TO_LINE_CONTEXT
, LINE_TYPE
, TAX_CODE
, TAX_RATE
, DESCRIPTION
, BATCH_SOURCE_NAME
, SET_OF_BOOKS_ID
, CUST_TRX_TYPE_ID
, GL_DATE
, CURRENCY_CODE
, CONVERSION_TYPE
, CONVERSION_RATE
, ORG_ID
,LEGAL_ENTITY_ID
)
VALUES (
p_interface_tax_rec.created_by
, p_interface_tax_rec.creation_date
, p_interface_tax_rec.last_updated_by
, p_interface_tax_rec.last_update_date
, p_interface_tax_rec.interface_line_attribute1
, p_interface_tax_rec.interface_line_attribute2
, p_interface_tax_rec.interface_line_attribute3
, p_interface_tax_rec.interface_line_attribute4
, p_interface_tax_rec.interface_line_attribute5
, p_interface_tax_rec.interface_line_attribute6
, p_interface_tax_rec.interface_line_attribute7
, p_interface_tax_rec.interface_line_attribute8
, p_interface_tax_rec.interface_line_attribute9
, p_interface_tax_rec.interface_line_attribute10
, p_interface_tax_rec.interface_line_attribute11
, p_interface_tax_rec.interface_line_attribute12
, p_interface_tax_rec.interface_line_attribute13
, p_interface_tax_rec.interface_line_attribute14
, p_interface_tax_rec.interface_line_attribute15
, p_interface_tax_rec.interface_line_context
, p_interface_tax_rec.link_to_line_attribute1
, p_interface_tax_rec.link_to_line_attribute2
, p_interface_tax_rec.link_to_line_attribute3
, p_interface_tax_rec.link_to_line_attribute4
, p_interface_tax_rec.link_to_line_attribute5
, p_interface_tax_rec.link_to_line_attribute6
, p_interface_tax_rec.link_to_line_attribute7
, p_interface_tax_rec.link_to_line_attribute8
, p_interface_tax_rec.link_to_line_attribute9
, p_interface_tax_rec.link_to_line_attribute10
, p_interface_tax_rec.link_to_line_attribute11
, p_interface_tax_rec.link_to_line_attribute12
, p_interface_tax_rec.link_to_line_attribute13
, p_interface_tax_rec.link_to_line_attribute14
, p_interface_tax_rec.link_to_line_attribute15
, p_interface_tax_rec.link_to_line_context
, p_interface_tax_rec.line_type
, p_interface_tax_rec.tax_code
, p_interface_tax_rec.tax_rate
, p_interface_tax_rec.description
, p_interface_tax_rec.batch_source_name
, p_interface_tax_rec.set_of_books_id
, p_interface_tax_rec.cust_trx_type_id
, p_interface_tax_rec.gl_date
, p_interface_tax_rec.currency_code
, p_interface_tax_rec.conversion_type
, p_interface_tax_rec.conversion_rate
, p_interface_tax_rec.org_id
, p_interface_tax_rec.legal_entity_id
);
END Insert_Interface_Tax;
PROCEDURE Insert_Interface_Sales_Credits(
p_int_sales_credits_rec IN RA_Int_Sales_Credits_Rec_Type
,x_return_status OUT NOCOPY VARCHAR2
)
IS
BEGIN
INSERT INTO RA_INTERFACE_SALESCREDITS_ALL(
CREATED_BY ,
CREATION_DATE ,
LAST_UPDATED_BY ,
LAST_UPDATE_DATE ,
LAST_UPDATE_LOGIN ,
SALESREP_ID ,
SALES_CREDIT_TYPE_ID ,
SALES_CREDIT_PERCENT_SPLIT ,
ATTRIBUTE_CATEGORY ,
ATTRIBUTE1 ,
ATTRIBUTE2 ,
ATTRIBUTE3 ,
ATTRIBUTE4 ,
ATTRIBUTE5 ,
ATTRIBUTE6 ,
ATTRIBUTE7 ,
ATTRIBUTE8 ,
ATTRIBUTE9 ,
ATTRIBUTE10 ,
ATTRIBUTE11 ,
ATTRIBUTE12 ,
ATTRIBUTE13 ,
ATTRIBUTE14 ,
ATTRIBUTE15 ,
INTERFACE_LINE_CONTEXT ,
INTERFACE_LINE_ATTRIBUTE1 ,
INTERFACE_LINE_ATTRIBUTE2 ,
INTERFACE_LINE_ATTRIBUTE3 ,
INTERFACE_LINE_ATTRIBUTE4 ,
INTERFACE_LINE_ATTRIBUTE5 ,
INTERFACE_LINE_ATTRIBUTE6 ,
INTERFACE_LINE_ATTRIBUTE7 ,
INTERFACE_LINE_ATTRIBUTE8 ,
INTERFACE_LINE_ATTRIBUTE9 ,
INTERFACE_LINE_ATTRIBUTE10 ,
INTERFACE_LINE_ATTRIBUTE11 ,
INTERFACE_LINE_ATTRIBUTE12 ,
INTERFACE_LINE_ATTRIBUTE13 ,
INTERFACE_LINE_ATTRIBUTE14 ,
INTERFACE_LINE_ATTRIBUTE15 ,
ORG_ID
)
VALUES (
p_int_sales_credits_rec.CREATED_BY ,
p_int_sales_credits_rec.CREATION_DATE ,
p_int_sales_credits_rec.LAST_UPDATED_BY ,
p_int_sales_credits_rec.LAST_UPDATE_DATE ,
p_int_sales_credits_rec.LAST_UPDATE_LOGIN ,
p_int_sales_credits_rec.SALESREP_ID ,
p_int_sales_credits_rec.SALES_CREDIT_TYPE_ID ,
p_int_sales_credits_rec.SALES_CREDIT_PERCENT_SPLIT ,
p_int_sales_credits_rec.ATTRIBUTE_CATEGORY ,
p_int_sales_credits_rec.ATTRIBUTE1 ,
p_int_sales_credits_rec.ATTRIBUTE2 ,
p_int_sales_credits_rec.ATTRIBUTE3 ,
p_int_sales_credits_rec.ATTRIBUTE4 ,
p_int_sales_credits_rec.ATTRIBUTE5 ,
p_int_sales_credits_rec.ATTRIBUTE6 ,
p_int_sales_credits_rec.ATTRIBUTE7 ,
p_int_sales_credits_rec.ATTRIBUTE8 ,
p_int_sales_credits_rec.ATTRIBUTE9 ,
p_int_sales_credits_rec.ATTRIBUTE10 ,
p_int_sales_credits_rec.ATTRIBUTE11 ,
p_int_sales_credits_rec.ATTRIBUTE12 ,
p_int_sales_credits_rec.ATTRIBUTE13 ,
p_int_sales_credits_rec.ATTRIBUTE14 ,
p_int_sales_credits_rec.ATTRIBUTE15 ,
p_int_sales_credits_rec.INTERFACE_LINE_CONTEXT ,
p_int_sales_credits_rec.INTERFACE_LINE_ATTRIBUTE1 ,
p_int_sales_credits_rec.INTERFACE_LINE_ATTRIBUTE2 ,
p_int_sales_credits_rec.INTERFACE_LINE_ATTRIBUTE3 ,
p_int_sales_credits_rec.INTERFACE_LINE_ATTRIBUTE4 ,
p_int_sales_credits_rec.INTERFACE_LINE_ATTRIBUTE5 ,
p_int_sales_credits_rec.INTERFACE_LINE_ATTRIBUTE6 ,
p_int_sales_credits_rec.INTERFACE_LINE_ATTRIBUTE7 ,
p_int_sales_credits_rec.INTERFACE_LINE_ATTRIBUTE8 ,
p_int_sales_credits_rec.INTERFACE_LINE_ATTRIBUTE9 ,
p_int_sales_credits_rec.INTERFACE_LINE_ATTRIBUTE10 ,
p_int_sales_credits_rec.INTERFACE_LINE_ATTRIBUTE11 ,
p_int_sales_credits_rec.INTERFACE_LINE_ATTRIBUTE12 ,
p_int_sales_credits_rec.INTERFACE_LINE_ATTRIBUTE13 ,
p_int_sales_credits_rec.INTERFACE_LINE_ATTRIBUTE14 ,
p_int_sales_credits_rec.INTERFACE_LINE_ATTRIBUTE15 ,
p_int_sales_credits_rec.ORG_ID
);
END Insert_Interface_Sales_Credits;
SELECT item_id
FROM ozf_claim_lines
WHERE claim_line_id = cv_claim_line_id
AND item_type = 'MEMO_LINE';--11.5.10 Enhancements.
SELECT sp.batch_source_id,
sp.billback_trx_type_id,
sp.cm_trx_type_id
FROM ozf_sys_parameters sp ;
SELECT name
FROM ra_batch_sources
WHERE batch_source_id = p_id ;
SELECT NVL(transaction_type,0)
FROM ozf_claim_types
WHERE claim_type_id = p_id ;
SELECT cm_trx_type_id
, dm_trx_type_id
, cb_trx_type_id
FROM ozf_claim_types_all_b
WHERE claim_type_id = cv_claim_type_id;
SELECT description
FROM ar_memo_lines
WHERE memo_line_id = p_id;
SELECT cust_acct_site_id
FROM hz_cust_site_uses
WHERE site_use_id = p_id ;
SELECT cas.cust_account_id
, cas.cust_acct_site_id
FROM hz_cust_acct_sites cas
, hz_cust_site_uses csu
WHERE cas.cust_acct_site_id = csu.cust_acct_site_id
AND csu.site_use_id = p_shipto_site_id;
SELECT reason_code
FROM ozf_reason_codes_all_b
WHERE reason_code_id = p_id;
SELECT invoicing_reason_code
FROM ozf_reason_codes_all_b
WHERE reason_code_id = p_id;
SELECT post_to_gl
FROM ra_cust_trx_types
WHERE cust_trx_type_id = p_trx_type_id;
SELECT default_term
FROM ra_cust_trx_types trx
, ozf_claim_types_all_b ct
WHERE trx.cust_trx_type_id = ct.dm_trx_type_id
AND ct.claim_type_id = cv_claim_type_id;
SELECT standard_terms
FROM hz_customer_profiles
WHERE cust_account_id = cv_cust_account_id
AND site_use_id IS NULL;
SELECT payment_term_id
FROM hz_cust_accounts
WHERE cust_account_id = cv_cust_account_id;
SELECT standard_terms
FROM hz_customer_profiles
WHERE cust_account_id = cv_cust_account_id
AND site_use_id = cv_site_use_id;
SELECT use.payment_term_id
FROM hz_cust_site_uses use
, hz_cust_acct_sites site
WHERE site.cust_acct_site_id = use.cust_acct_site_id
AND site.cust_account_id = cv_cust_account_id
AND use.site_use_id = cv_site_use_id;
SELECT item_id
, quantity
, quantity_uom
, rate
, item_type
, item_description
, source_object_class -- added for bug 4716020
FROM ozf_claim_lines
WHERE claim_line_id = cv_claim_line_id;
SELECT SUBSTRB(name,1,30) name
FROM ozf_reason_codes_vl
WHERE reason_code_id = cv_reason_code_id;
SELECT SUBSTRB(description, 1, 240)
FROM mtl_system_items_vl
WHERE inventory_item_id = cv_inventory_item_id
AND organization_id = FND_PROFILE.VALUE('AMS_ITEM_ORGANIZATION_ID');
SELECT SUBSTR(offer_code,1,50)
FROM ozf_offers offer, ozf_claim_lines_all line
WHERE qp_list_header_id = line.offer_id
AND claim_line_id = cv_claim_line_id;
SELECT SUBSTRB(category_desc,1,240)
FROM eni_prod_den_hrchy_parents_v
WHERE category_id = cv_category_id;
SELECT channel_name
FROM ams_media_channels_vl
WHERE channel_id = cv_media_channel_id;
p_x_interface_line_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
p_x_interface_line_rec.LAST_UPDATE_DATE := SYSDATE;
x_interface_tax_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
x_interface_tax_rec.LAST_UPDATE_DATE := SYSDATE;
SELECT SUBSTRB(name,1,30) name
-- [END OF BUG 3500049 FIXING]
FROM ozf_reason_codes_vl
WHERE reason_code_id = cv_reason_code_id;
p_x_int_distributions_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
p_x_int_distributions_rec.LAST_UPDATE_DATE := SYSDATE;
SELECT sales_credit_type_id
FROM ra_salesreps
WHERE salesrep_id = cv_salesrep_id;
Insert_Interface_Line(l_interface_line_rec,
x_return_status);
l_int_sales_credits_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
l_int_sales_credits_rec.LAST_UPDATE_DATE := SYSDATE;
Insert_Interface_Sales_Credits(
l_int_sales_credits_rec,
x_return_status
);
Insert_Interface_Tax( l_interface_tax_rec,
x_return_status
);
Insert_Int_Distributions(l_int_distributions_rec,
x_return_status);
SELECT SUM(NVL(cll.claim_currency_amount,0)),
NVL(cll.claim_currency_amount,0)
FROM ozf_claim_lines cll
WHERE cll.claim_id = p_claim_id;
SELECT cll.claim_line_id
, NVL(cll.claim_currency_amount,0)
, cll.tax_code
, Get_Memo_Line_Id(cll.claim_line_id)
, cll.earnings_associated_flag
, cll.source_object_class
FROM ozf_claim_lines cll
WHERE cll.claim_id = p_claim_id;
SELECT osp.post_to_gl
FROM ozf_sys_parameters_all osp
, ozf_claims_all oc
WHERE NVL(osp.org_id, -99) = NVL(oc.org_id, -99)
AND oc.claim_id = p_id;
/* ------- Begin Update Claim Payment Status ----------------- */
UPDATE ozf_claims_all
SET payment_status = 'INTERFACED'
WHERE claim_id = p_claim_id;
/* ------- End Update Claim Payment Status ------------------- */
/* ------- Begin Standard API Calls --------------------------- */
--Standard check of commit
IF FND_API.To_Boolean ( p_commit ) THEN
COMMIT WORK;