[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE Insert_Row(
px_ae_line_id IN OUT NOCOPY NUMBER,
px_object_version_number IN OUT NOCOPY NUMBER,
p_last_update_date DATE,
p_last_updated_by NUMBER,
p_creation_date DATE,
p_created_by NUMBER,
p_last_update_login NUMBER,
p_request_id NUMBER,
p_program_application_id NUMBER,
p_program_update_date DATE,
p_program_id NUMBER,
p_accounted_cr NUMBER,
p_accounted_dr NUMBER,
p_accounting_error_code VARCHAR2,
p_ae_header_id NUMBER,
p_ae_line_number NUMBER,
p_ae_line_type_code VARCHAR2,
p_applied_from_trx_hdr_id NUMBER,
p_applied_from_trx_hdr_table VARCHAR2,
p_applied_to_trx_hdr_id NUMBER,
p_applied_to_trx_hdr_table VARCHAR2,
p_code_combination_id NUMBER,
p_currency_code VARCHAR2,
p_currency_conversion_date DATE,
p_currency_conversion_rate NUMBER,
p_currency_conversion_type VARCHAR2,
p_description VARCHAR2,
p_entered_cr NUMBER,
p_entered_dr NUMBER,
p_gl_sl_link_id NUMBER,
p_gl_transfer_error_code VARCHAR2,
px_org_id IN OUT NOCOPY NUMBER,
p_reference1 VARCHAR2,
p_reference2 VARCHAR2,
p_reference3 VARCHAR2,
p_reference4 VARCHAR2,
p_reference5 VARCHAR2,
p_reference6 VARCHAR2,
p_reference7 VARCHAR2,
p_reference8 VARCHAR2,
p_reference9 VARCHAR2,
p_reference10 VARCHAR2,
p_source_id NUMBER,
p_source_table VARCHAR2,
p_stat_amount NUMBER,
p_subledger_doc_sequence_id NUMBER,
p_subledger_doc_sequence_value NUMBER,
p_taxable_accounted_cr NUMBER,
p_taxable_accounted_dr NUMBER,
p_taxable_entered_cr NUMBER,
p_taxable_entered_dr NUMBER,
p_tax_code_id NUMBER,
p_tax_link_id NUMBER,
p_third_party_id NUMBER,
p_third_party_sub_id NUMBER,
p_third_party_type VARCHAR2,
p_ussgl_transaction_code VARCHAR2,
p_attribute_category VARCHAR2,
p_attribute1 VARCHAR2,
p_attribute2 VARCHAR2,
p_attribute3 VARCHAR2,
p_attribute4 VARCHAR2,
p_attribute5 VARCHAR2,
p_attribute6 VARCHAR2,
p_attribute7 VARCHAR2,
p_attribute8 VARCHAR2,
p_attribute9 VARCHAR2,
p_attribute10 VARCHAR2,
p_attribute11 VARCHAR2,
p_attribute12 VARCHAR2,
p_attribute13 VARCHAR2,
p_attribute14 VARCHAR2,
p_attribute15 VARCHAR2)
IS
x_rowid VARCHAR2(30);
SELECT NVL(SUBSTRB(USERENV('CLIENT_INFO'),1,10),-99)
INTO px_org_id
FROM DUAL;
INSERT INTO OZF_AE_LINES_ALL(
ae_line_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,
accounted_cr,
accounted_dr,
accounting_error_code,
ae_header_id,
ae_line_number,
ae_line_type_code,
applied_from_trx_hdr_id,
applied_from_trx_hdr_table,
applied_to_trx_hdr_id,
applied_to_trx_hdr_table,
code_combination_id,
currency_code,
currency_conversion_date,
currency_conversion_rate,
currency_conversion_type,
description,
entered_cr,
entered_dr,
gl_sl_link_id,
gl_transfer_error_code,
org_id,
reference1,
reference2,
reference3,
reference4,
reference5,
reference6,
reference7,
reference8,
reference9,
reference10,
source_id,
source_table,
stat_amount,
subledger_doc_sequence_id,
subledger_doc_sequence_value,
taxable_accounted_cr,
taxable_accounted_dr,
taxable_entered_cr,
taxable_entered_dr,
tax_code_id,
tax_link_id,
third_party_id,
third_party_sub_id,
third_party_type,
ussgl_transaction_code,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15
) VALUES (
px_ae_line_id,
px_object_version_number,
p_last_update_date,
p_last_updated_by,
p_creation_date,
p_created_by,
p_last_update_login,
p_request_id,
p_program_application_id,
p_program_update_date,
p_program_id,
p_accounted_cr,
p_accounted_dr,
p_accounting_error_code,
p_ae_header_id,
p_ae_line_number,
p_ae_line_type_code,
p_applied_from_trx_hdr_id,
p_applied_from_trx_hdr_table,
p_applied_to_trx_hdr_id,
p_applied_to_trx_hdr_table,
p_code_combination_id,
p_currency_code,
p_currency_conversion_date,
p_currency_conversion_rate,
p_currency_conversion_type,
p_description,
p_entered_cr,
p_entered_dr,
p_gl_sl_link_id,
p_gl_transfer_error_code,
px_org_id,
p_reference1,
p_reference2,
p_reference3,
p_reference4,
p_reference5,
p_reference6,
p_reference7,
p_reference8,
p_reference9,
p_reference10,
p_source_id,
p_source_table,
p_stat_amount,
p_subledger_doc_sequence_id,
p_subledger_doc_sequence_value,
p_taxable_accounted_cr,
p_taxable_accounted_dr,
p_taxable_entered_cr,
p_taxable_entered_dr,
p_tax_code_id,
p_tax_link_id,
p_third_party_id,
p_third_party_sub_id,
p_third_party_type,
p_ussgl_transaction_code,
p_attribute_category,
p_attribute1,
p_attribute2,
p_attribute3,
p_attribute4,
p_attribute5,
p_attribute6,
p_attribute7,
p_attribute8,
p_attribute9,
p_attribute10,
p_attribute11,
p_attribute12,
p_attribute13,
p_attribute14,
p_attribute15);
END Insert_Row;
PROCEDURE Update_Row(
p_ae_line_id NUMBER,
p_object_version_number NUMBER,
p_last_update_date DATE,
p_last_updated_by NUMBER,
p_last_update_login NUMBER,
p_request_id NUMBER,
p_program_application_id NUMBER,
p_program_update_date DATE,
p_program_id NUMBER,
p_accounted_cr NUMBER,
p_accounted_dr NUMBER,
p_accounting_error_code VARCHAR2,
p_ae_header_id NUMBER,
p_ae_line_number NUMBER,
p_ae_line_type_code VARCHAR2,
p_applied_from_trx_hdr_id NUMBER,
p_applied_from_trx_hdr_table VARCHAR2,
p_applied_to_trx_hdr_id NUMBER,
p_applied_to_trx_hdr_table VARCHAR2,
p_code_combination_id NUMBER,
p_currency_code VARCHAR2,
p_currency_conversion_date DATE,
p_currency_conversion_rate NUMBER,
p_currency_conversion_type VARCHAR2,
p_description VARCHAR2,
p_entered_cr NUMBER,
p_entered_dr NUMBER,
p_gl_sl_link_id NUMBER,
p_gl_transfer_error_code VARCHAR2,
p_org_id NUMBER,
p_reference1 VARCHAR2,
p_reference2 VARCHAR2,
p_reference3 VARCHAR2,
p_reference4 VARCHAR2,
p_reference5 VARCHAR2,
p_reference6 VARCHAR2,
p_reference7 VARCHAR2,
p_reference8 VARCHAR2,
p_reference9 VARCHAR2,
p_reference10 VARCHAR2,
p_source_id NUMBER,
p_source_table VARCHAR2,
p_stat_amount NUMBER,
p_subledger_doc_sequence_id NUMBER,
p_subledger_doc_sequence_value NUMBER,
p_taxable_accounted_cr NUMBER,
p_taxable_accounted_dr NUMBER,
p_taxable_entered_cr NUMBER,
p_taxable_entered_dr NUMBER,
p_tax_code_id NUMBER,
p_tax_link_id NUMBER,
p_third_party_id NUMBER,
p_third_party_sub_id NUMBER,
p_third_party_type VARCHAR2,
p_ussgl_transaction_code VARCHAR2,
p_attribute_category VARCHAR2,
p_attribute1 VARCHAR2,
p_attribute2 VARCHAR2,
p_attribute3 VARCHAR2,
p_attribute4 VARCHAR2,
p_attribute5 VARCHAR2,
p_attribute6 VARCHAR2,
p_attribute7 VARCHAR2,
p_attribute8 VARCHAR2,
p_attribute9 VARCHAR2,
p_attribute10 VARCHAR2,
p_attribute11 VARCHAR2,
p_attribute12 VARCHAR2,
p_attribute13 VARCHAR2,
p_attribute14 VARCHAR2,
p_attribute15 VARCHAR2)
IS
BEGIN
Update OZF_AE_LINES_ALL
SET
ae_line_id = p_ae_line_id,
object_version_number = p_object_version_number,
last_update_date = p_last_update_date,
last_updated_by = p_last_updated_by,
last_update_login = p_last_update_login,
request_id = p_request_id,
program_application_id = p_program_application_id,
program_update_date = p_program_update_date,
program_id = p_program_id,
accounted_cr = p_accounted_cr,
accounted_dr = p_accounted_dr,
accounting_error_code = p_accounting_error_code,
ae_header_id = p_ae_header_id,
ae_line_number = p_ae_line_number,
ae_line_type_code = p_ae_line_type_code,
applied_from_trx_hdr_id = p_applied_from_trx_hdr_id,
applied_from_trx_hdr_table = p_applied_from_trx_hdr_table,
applied_to_trx_hdr_id = p_applied_to_trx_hdr_id,
applied_to_trx_hdr_table = p_applied_to_trx_hdr_table,
code_combination_id = p_code_combination_id,
currency_code = p_currency_code,
currency_conversion_date = p_currency_conversion_date,
currency_conversion_rate = p_currency_conversion_rate,
currency_conversion_type = p_currency_conversion_type,
description = p_description,
entered_cr = p_entered_cr,
entered_dr = p_entered_dr,
gl_sl_link_id = p_gl_sl_link_id,
gl_transfer_error_code = p_gl_transfer_error_code,
org_id = p_org_id,
reference1 = p_reference1,
reference2 = p_reference2,
reference3 = p_reference3,
reference4 = p_reference4,
reference5 = p_reference5,
reference6 = p_reference6,
reference7 = p_reference7,
reference8 = p_reference8,
reference9 = p_reference9,
reference10 = p_reference10,
source_id = p_source_id,
source_table = p_source_table,
stat_amount = p_stat_amount,
subledger_doc_sequence_id = p_subledger_doc_sequence_id,
subledger_doc_sequence_value = p_subledger_doc_sequence_value,
taxable_accounted_cr = p_taxable_accounted_cr,
taxable_accounted_dr = p_taxable_accounted_dr,
taxable_entered_cr = p_taxable_entered_cr,
taxable_entered_dr = p_taxable_entered_dr,
tax_code_id = p_tax_code_id,
tax_link_id = p_tax_link_id,
third_party_id = p_third_party_id,
third_party_sub_id = p_third_party_sub_id,
third_party_type = p_third_party_type,
ussgl_transaction_code = p_ussgl_transaction_code,
attribute_category = p_attribute_category,
attribute1 = p_attribute1,
attribute2 = p_attribute2,
attribute3 = p_attribute3,
attribute4 = p_attribute4,
attribute5 = p_attribute5,
attribute6 = p_attribute6,
attribute7 = p_attribute7,
attribute8 = p_attribute8,
attribute9 = p_attribute9,
attribute10 = p_attribute10,
attribute11 = p_attribute11,
attribute12 = p_attribute12,
attribute13 = p_attribute13,
attribute14 = p_attribute14,
attribute15 = p_attribute15
WHERE AE_LINE_ID = p_AE_LINE_ID
AND object_version_number = p_object_version_number;
END Update_Row;
PROCEDURE Delete_Row(
p_AE_LINE_ID NUMBER)
IS
BEGIN
DELETE FROM OZF_AE_LINES_ALL
WHERE AE_LINE_ID = p_AE_LINE_ID;
END Delete_Row ;
p_last_update_date DATE,
p_last_updated_by NUMBER,
p_creation_date DATE,
p_created_by NUMBER,
p_last_update_login NUMBER,
p_request_id NUMBER,
p_program_application_id NUMBER,
p_program_update_date DATE,
p_program_id NUMBER,
p_accounted_cr NUMBER,
p_accounted_dr NUMBER,
p_accounting_error_code VARCHAR2,
p_ae_header_id NUMBER,
p_ae_line_number NUMBER,
p_ae_line_type_code VARCHAR2,
p_applied_from_trx_hdr_id NUMBER,
p_applied_from_trx_hdr_table VARCHAR2,
p_applied_to_trx_hdr_id NUMBER,
p_applied_to_trx_hdr_table VARCHAR2,
p_code_combination_id NUMBER,
p_currency_code VARCHAR2,
p_currency_conversion_date DATE,
p_currency_conversion_rate NUMBER,
p_currency_conversion_type VARCHAR2,
p_description VARCHAR2,
p_entered_cr NUMBER,
p_entered_dr NUMBER,
p_gl_sl_link_id NUMBER,
p_gl_transfer_error_code VARCHAR2,
p_org_id NUMBER,
p_reference1 VARCHAR2,
p_reference2 VARCHAR2,
p_reference3 VARCHAR2,
p_reference4 VARCHAR2,
p_reference5 VARCHAR2,
p_reference6 VARCHAR2,
p_reference7 VARCHAR2,
p_reference8 VARCHAR2,
p_reference9 VARCHAR2,
p_reference10 VARCHAR2,
p_source_id NUMBER,
p_source_table VARCHAR2,
p_stat_amount NUMBER,
p_subledger_doc_sequence_id NUMBER,
p_subledger_doc_sequence_value NUMBER,
p_taxable_accounted_cr NUMBER,
p_taxable_accounted_dr NUMBER,
p_taxable_entered_cr NUMBER,
p_taxable_entered_dr NUMBER,
p_tax_code_id NUMBER,
p_tax_link_id NUMBER,
p_third_party_id NUMBER,
p_third_party_sub_id NUMBER,
p_third_party_type VARCHAR2,
p_ussgl_transaction_code VARCHAR2,
p_attribute_category VARCHAR2,
p_attribute1 VARCHAR2,
p_attribute2 VARCHAR2,
p_attribute3 VARCHAR2,
p_attribute4 VARCHAR2,
p_attribute5 VARCHAR2,
p_attribute6 VARCHAR2,
p_attribute7 VARCHAR2,
p_attribute8 VARCHAR2,
p_attribute9 VARCHAR2,
p_attribute10 VARCHAR2,
p_attribute11 VARCHAR2,
p_attribute12 VARCHAR2,
p_attribute13 VARCHAR2,
p_attribute14 VARCHAR2,
p_attribute15 VARCHAR2)
IS
CURSOR C IS
SELECT *
FROM OZF_AE_LINES_ALL
WHERE AE_LINE_ID = p_AE_LINE_ID
FOR UPDATE of AE_LINE_ID NOWAIT;
AND ( ( Recinfo.last_update_date = p_last_update_date)
OR ( ( Recinfo.last_update_date IS NULL )
AND ( p_last_update_date IS NULL )))
AND ( ( Recinfo.last_updated_by = p_last_updated_by)
OR ( ( Recinfo.last_updated_by IS NULL )
AND ( p_last_updated_by IS NULL )))
AND ( ( Recinfo.creation_date = p_creation_date)
OR ( ( Recinfo.creation_date IS NULL )
AND ( p_creation_date IS NULL )))
AND ( ( Recinfo.created_by = p_created_by)
OR ( ( Recinfo.created_by IS NULL )
AND ( p_created_by IS NULL )))
AND ( ( Recinfo.last_update_login = p_last_update_login)
OR ( ( Recinfo.last_update_login IS NULL )
AND ( p_last_update_login IS NULL )))
AND ( ( Recinfo.request_id = p_request_id)
OR ( ( Recinfo.request_id IS NULL )
AND ( p_request_id IS NULL )))
AND ( ( Recinfo.program_application_id = p_program_application_id)
OR ( ( Recinfo.program_application_id IS NULL )
AND ( p_program_application_id IS NULL )))
AND ( ( Recinfo.program_update_date = p_program_update_date)
OR ( ( Recinfo.program_update_date IS NULL )
AND ( p_program_update_date IS NULL )))
AND ( ( Recinfo.program_id = p_program_id)
OR ( ( Recinfo.program_id IS NULL )
AND ( p_program_id IS NULL )))
AND ( ( Recinfo.accounted_cr = p_accounted_cr)
OR ( ( Recinfo.accounted_cr IS NULL )
AND ( p_accounted_cr IS NULL )))
AND ( ( Recinfo.accounted_dr = p_accounted_dr)
OR ( ( Recinfo.accounted_dr IS NULL )
AND ( p_accounted_dr IS NULL )))
AND ( ( Recinfo.accounting_error_code = p_accounting_error_code)
OR ( ( Recinfo.accounting_error_code IS NULL )
AND ( p_accounting_error_code IS NULL )))
AND ( ( Recinfo.ae_header_id = p_ae_header_id)
OR ( ( Recinfo.ae_header_id IS NULL )
AND ( p_ae_header_id IS NULL )))
AND ( ( Recinfo.ae_line_number = p_ae_line_number)
OR ( ( Recinfo.ae_line_number IS NULL )
AND ( p_ae_line_number IS NULL )))
AND ( ( Recinfo.ae_line_type_code = p_ae_line_type_code)
OR ( ( Recinfo.ae_line_type_code IS NULL )
AND ( p_ae_line_type_code IS NULL )))
AND ( ( Recinfo.applied_from_trx_hdr_id = p_applied_from_trx_hdr_id)
OR ( ( Recinfo.applied_from_trx_hdr_id IS NULL )
AND ( p_applied_from_trx_hdr_id IS NULL )))
AND ( ( Recinfo.applied_from_trx_hdr_table = p_applied_from_trx_hdr_table)
OR ( ( Recinfo.applied_from_trx_hdr_table IS NULL )
AND ( p_applied_from_trx_hdr_table IS NULL )))
AND ( ( Recinfo.applied_to_trx_hdr_id = p_applied_to_trx_hdr_id)
OR ( ( Recinfo.applied_to_trx_hdr_id IS NULL )
AND ( p_applied_to_trx_hdr_id IS NULL )))
AND ( ( Recinfo.applied_to_trx_hdr_table = p_applied_to_trx_hdr_table)
OR ( ( Recinfo.applied_to_trx_hdr_table IS NULL )
AND ( p_applied_to_trx_hdr_table IS NULL )))
AND ( ( Recinfo.code_combination_id = p_code_combination_id)
OR ( ( Recinfo.code_combination_id IS NULL )
AND ( p_code_combination_id IS NULL )))
AND ( ( Recinfo.currency_code = p_currency_code)
OR ( ( Recinfo.currency_code IS NULL )
AND ( p_currency_code IS NULL )))
AND ( ( Recinfo.currency_conversion_date = p_currency_conversion_date)
OR ( ( Recinfo.currency_conversion_date IS NULL )
AND ( p_currency_conversion_date IS NULL )))
AND ( ( Recinfo.currency_conversion_rate = p_currency_conversion_rate)
OR ( ( Recinfo.currency_conversion_rate IS NULL )
AND ( p_currency_conversion_rate IS NULL )))
AND ( ( Recinfo.currency_conversion_type = p_currency_conversion_type)
OR ( ( Recinfo.currency_conversion_type IS NULL )
AND ( p_currency_conversion_type IS NULL )))
AND ( ( Recinfo.description = p_description)
OR ( ( Recinfo.description IS NULL )
AND ( p_description IS NULL )))
AND ( ( Recinfo.entered_cr = p_entered_cr)
OR ( ( Recinfo.entered_cr IS NULL )
AND ( p_entered_cr IS NULL )))
AND ( ( Recinfo.entered_dr = p_entered_dr)
OR ( ( Recinfo.entered_dr IS NULL )
AND ( p_entered_dr IS NULL )))
AND ( ( Recinfo.gl_sl_link_id = p_gl_sl_link_id)
OR ( ( Recinfo.gl_sl_link_id IS NULL )
AND ( p_gl_sl_link_id IS NULL )))
AND ( ( Recinfo.gl_transfer_error_code = p_gl_transfer_error_code)
OR ( ( Recinfo.gl_transfer_error_code IS NULL )
AND ( p_gl_transfer_error_code IS NULL )))
AND ( ( Recinfo.org_id = p_org_id)
OR ( ( Recinfo.org_id IS NULL )
AND ( p_org_id IS NULL )))
AND ( ( Recinfo.reference1 = p_reference1)
OR ( ( Recinfo.reference1 IS NULL )
AND ( p_reference1 IS NULL )))
AND ( ( Recinfo.reference2 = p_reference2)
OR ( ( Recinfo.reference2 IS NULL )
AND ( p_reference2 IS NULL )))
AND ( ( Recinfo.reference3 = p_reference3)
OR ( ( Recinfo.reference3 IS NULL )
AND ( p_reference3 IS NULL )))
AND ( ( Recinfo.reference4 = p_reference4)
OR ( ( Recinfo.reference4 IS NULL )
AND ( p_reference4 IS NULL )))
AND ( ( Recinfo.reference5 = p_reference5)
OR ( ( Recinfo.reference5 IS NULL )
AND ( p_reference5 IS NULL )))
AND ( ( Recinfo.reference6 = p_reference6)
OR ( ( Recinfo.reference6 IS NULL )
AND ( p_reference6 IS NULL )))
AND ( ( Recinfo.reference7 = p_reference7)
OR ( ( Recinfo.reference7 IS NULL )
AND ( p_reference7 IS NULL )))
AND ( ( Recinfo.reference8 = p_reference8)
OR ( ( Recinfo.reference8 IS NULL )
AND ( p_reference8 IS NULL )))
AND ( ( Recinfo.reference9 = p_reference9)
OR ( ( Recinfo.reference9 IS NULL )
AND ( p_reference9 IS NULL )))
AND ( ( Recinfo.reference10 = p_reference10)
OR ( ( Recinfo.reference10 IS NULL )
AND ( p_reference10 IS NULL )))
AND ( ( Recinfo.source_id = p_source_id)
OR ( ( Recinfo.source_id IS NULL )
AND ( p_source_id IS NULL )))
AND ( ( Recinfo.source_table = p_source_table)
OR ( ( Recinfo.source_table IS NULL )
AND ( p_source_table IS NULL )))
AND ( ( Recinfo.stat_amount = p_stat_amount)
OR ( ( Recinfo.stat_amount IS NULL )
AND ( p_stat_amount IS NULL )))
AND ( ( Recinfo.subledger_doc_sequence_id = p_subledger_doc_sequence_id)
OR ( ( Recinfo.subledger_doc_sequence_id IS NULL )
AND ( p_subledger_doc_sequence_id IS NULL )))
AND ( ( Recinfo.subledger_doc_sequence_value = p_subledger_doc_sequence_value)
OR ( ( Recinfo.subledger_doc_sequence_value IS NULL )
AND ( p_subledger_doc_sequence_value IS NULL )))
AND ( ( Recinfo.taxable_accounted_cr = p_taxable_accounted_cr)
OR ( ( Recinfo.taxable_accounted_cr IS NULL )
AND ( p_taxable_accounted_cr IS NULL )))
AND ( ( Recinfo.taxable_accounted_dr = p_taxable_accounted_dr)
OR ( ( Recinfo.taxable_accounted_dr IS NULL )
AND ( p_taxable_accounted_dr IS NULL )))
AND ( ( Recinfo.taxable_entered_cr = p_taxable_entered_cr)
OR ( ( Recinfo.taxable_entered_cr IS NULL )
AND ( p_taxable_entered_cr IS NULL )))
AND ( ( Recinfo.taxable_entered_dr = p_taxable_entered_dr)
OR ( ( Recinfo.taxable_entered_dr IS NULL )
AND ( p_taxable_entered_dr IS NULL )))
AND ( ( Recinfo.tax_code_id = p_tax_code_id)
OR ( ( Recinfo.tax_code_id IS NULL )
AND ( p_tax_code_id IS NULL )))
AND ( ( Recinfo.tax_link_id = p_tax_link_id)
OR ( ( Recinfo.tax_link_id IS NULL )
AND ( p_tax_link_id IS NULL )))
AND ( ( Recinfo.third_party_id = p_third_party_id)
OR ( ( Recinfo.third_party_id IS NULL )
AND ( p_third_party_id IS NULL )))
AND ( ( Recinfo.third_party_sub_id = p_third_party_sub_id)
OR ( ( Recinfo.third_party_sub_id IS NULL )
AND ( p_third_party_sub_id IS NULL )))
AND ( ( Recinfo.third_party_type = p_third_party_type)
OR ( ( Recinfo.third_party_type IS NULL )
AND ( p_third_party_type IS NULL )))
AND ( ( Recinfo.ussgl_transaction_code = p_ussgl_transaction_code)
OR ( ( Recinfo.ussgl_transaction_code IS NULL )
AND ( p_ussgl_transaction_code IS NULL )))
AND ( ( Recinfo.attribute_category = p_attribute_category)
OR ( ( Recinfo.attribute_category IS NULL )
AND ( p_attribute_category IS NULL )))
AND ( ( Recinfo.attribute1 = p_attribute1)
OR ( ( Recinfo.attribute1 IS NULL )
AND ( p_attribute1 IS NULL )))
AND ( ( Recinfo.attribute2 = p_attribute2)
OR ( ( Recinfo.attribute2 IS NULL )
AND ( p_attribute2 IS NULL )))
AND ( ( Recinfo.attribute3 = p_attribute3)
OR ( ( Recinfo.attribute3 IS NULL )
AND ( p_attribute3 IS NULL )))
AND ( ( Recinfo.attribute4 = p_attribute4)
OR ( ( Recinfo.attribute4 IS NULL )
AND ( p_attribute4 IS NULL )))
AND ( ( Recinfo.attribute5 = p_attribute5)
OR ( ( Recinfo.attribute5 IS NULL )
AND ( p_attribute5 IS NULL )))
AND ( ( Recinfo.attribute6 = p_attribute6)
OR ( ( Recinfo.attribute6 IS NULL )
AND ( p_attribute6 IS NULL )))
AND ( ( Recinfo.attribute7 = p_attribute7)
OR ( ( Recinfo.attribute7 IS NULL )
AND ( p_attribute7 IS NULL )))
AND ( ( Recinfo.attribute8 = p_attribute8)
OR ( ( Recinfo.attribute8 IS NULL )
AND ( p_attribute8 IS NULL )))
AND ( ( Recinfo.attribute9 = p_attribute9)
OR ( ( Recinfo.attribute9 IS NULL )
AND ( p_attribute9 IS NULL )))
AND ( ( Recinfo.attribute10 = p_attribute10)
OR ( ( Recinfo.attribute10 IS NULL )
AND ( p_attribute10 IS NULL )))
AND ( ( Recinfo.attribute11 = p_attribute11)
OR ( ( Recinfo.attribute11 IS NULL )
AND ( p_attribute11 IS NULL )))
AND ( ( Recinfo.attribute12 = p_attribute12)
OR ( ( Recinfo.attribute12 IS NULL )
AND ( p_attribute12 IS NULL )))
AND ( ( Recinfo.attribute13 = p_attribute13)
OR ( ( Recinfo.attribute13 IS NULL )
AND ( p_attribute13 IS NULL )))
AND ( ( Recinfo.attribute14 = p_attribute14)
OR ( ( Recinfo.attribute14 IS NULL )
AND ( p_attribute14 IS NULL )))
AND ( ( Recinfo.attribute15 = p_attribute15)
OR ( ( Recinfo.attribute15 IS NULL )
AND ( p_attribute15 IS NULL )))
) THEN
RETURN;