[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE Insert_Row(
px_claim_line_history_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_created_from VARCHAR2,
p_claim_history_id NUMBER,
p_claim_id NUMBER,
p_claim_line_id NUMBER,
p_line_number NUMBER,
p_split_from_claim_line_id NUMBER,
p_amount NUMBER,
p_acctd_amount NUMBER,
p_currency_code VARCHAR2,
p_exchange_rate_type VARCHAR2,
p_exchange_rate_date DATE,
p_exchange_rate NUMBER,
p_set_of_books_id NUMBER,
p_valid_flag VARCHAR2,
p_source_object_id NUMBER,
p_source_object_class VARCHAR2,
p_source_object_type_id NUMBER,
p_source_object_line_id NUMBER,
p_plan_id NUMBER,
p_offer_id NUMBER,
p_payment_method VARCHAR2,
p_payment_reference_id NUMBER,
p_payment_reference_number VARCHAR2,
p_payment_reference_date DATE,
p_voucher_id NUMBER,
p_voucher_number VARCHAR2,
p_payment_status VARCHAR2,
p_approved_flag VARCHAR2,
p_approved_date DATE,
p_approved_by NUMBER,
p_settled_date DATE,
p_settled_by NUMBER,
p_performance_complete_flag VARCHAR2,
p_performance_attached_flag 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,
px_org_id IN OUT NOCOPY NUMBER,
p_utilization_id NUMBER,
p_claim_currency_amount NUMBER,
p_item_id NUMBER,
p_item_description VARCHAR2,
p_quantity NUMBER,
p_quantity_uom VARCHAR2,
p_rate NUMBER,
p_activity_type VARCHAR2,
p_activity_id NUMBER,
p_earnings_associated_flag VARCHAR2,
p_comments VARCHAR2,
p_related_cust_account_id NUMBER,
p_relationship_type VARCHAR2,
p_tax_code VARCHAR2,
p_select_cust_children_flag VARCHAR2,
p_buy_group_cust_account_id NUMBER,
p_credit_to VARCHAR2,
p_sale_date DATE,
p_item_type VARCHAR2,
p_tax_amount NUMBER,
p_claim_curr_tax_amount NUMBER,
p_activity_line_id NUMBER,
p_offer_type VARCHAR2,
p_prorate_earnings_flag VARCHAR2,
p_earnings_end_date DATE
)
IS
x_rowid VARCHAR2(30);
INSERT INTO OZF_CLAIM_LINES_HIST_ALL(
claim_line_history_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,
claim_history_id,
claim_id,
claim_line_id,
line_number,
split_from_claim_line_id,
amount,
acctd_amount,
currency_code,
exchange_rate_type,
exchange_rate_date,
exchange_rate,
set_of_books_id,
valid_flag,
source_object_id,
source_object_class,
source_object_type_id,
source_object_line_id,
plan_id,
offer_id,
payment_method,
payment_reference_id,
payment_reference_number,
payment_reference_date,
voucher_id,
voucher_number,
payment_status,
approved_flag,
approved_date,
approved_by,
settled_date,
settled_by,
performance_complete_flag,
performance_attached_flag,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
org_id,
utilization_id,
claim_currency_amount,
item_id,
item_description,
quantity,
quantity_uom,
rate,
activity_type,
activity_id,
earnings_associated_flag,
comments,
related_cust_account_id,
relationship_type,
tax_code,
select_cust_children_flag,
buy_group_cust_account_id,
credit_to,
sale_date,
item_type,
tax_amount,
claim_curr_tax_amount,
activity_line_id,
offer_type,
prorate_earnings_flag,
earnings_end_date
) VALUES (
px_claim_line_history_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_created_from,
p_claim_history_id,
p_claim_id,
p_claim_line_id,
p_line_number,
p_split_from_claim_line_id,
p_amount,
p_acctd_amount,
p_currency_code,
p_exchange_rate_type,
p_exchange_rate_date,
p_exchange_rate,
p_set_of_books_id,
p_valid_flag,
p_source_object_id,
p_source_object_class,
p_source_object_type_id,
p_source_object_line_id,
p_plan_id,
p_offer_id,
p_payment_method,
p_payment_reference_id,
p_payment_reference_number,
p_payment_reference_date,
p_voucher_id,
p_voucher_number,
p_payment_status,
p_approved_flag,
p_approved_date,
p_approved_by,
p_settled_date,
p_settled_by,
p_performance_complete_flag,
p_performance_attached_flag,
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,
px_org_id,
p_utilization_id,
p_claim_currency_amount,
p_item_id,
p_item_description,
p_quantity,
p_quantity_uom,
p_rate,
p_activity_type,
p_activity_id,
p_earnings_associated_flag,
p_comments,
p_related_cust_account_id,
p_relationship_type,
p_tax_code,
p_select_cust_children_flag,
p_buy_group_cust_account_id,
p_credit_to,
p_sale_date,
p_item_type,
p_tax_amount,
p_claim_curr_tax_amount,
p_activity_line_id,
p_offer_type,
p_prorate_earnings_flag,
p_earnings_end_date
);
END Insert_Row;
PROCEDURE Update_Row(
p_claim_line_history_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_created_from VARCHAR2,
p_claim_history_id NUMBER,
p_claim_id NUMBER,
p_claim_line_id NUMBER,
p_line_number NUMBER,
p_split_from_claim_line_id NUMBER,
p_amount NUMBER,
p_acctd_amount NUMBER,
p_currency_code VARCHAR2,
p_exchange_rate_type VARCHAR2,
p_exchange_rate_date DATE,
p_exchange_rate NUMBER,
p_set_of_books_id NUMBER,
p_valid_flag VARCHAR2,
p_source_object_id NUMBER,
p_source_object_class VARCHAR2,
p_source_object_type_id NUMBER,
p_source_object_line_id NUMBER,
p_plan_id NUMBER,
p_offer_id NUMBER,
p_payment_method VARCHAR2,
p_payment_reference_id NUMBER,
p_payment_reference_number VARCHAR2,
p_payment_reference_date DATE,
p_voucher_id NUMBER,
p_voucher_number VARCHAR2,
p_payment_status VARCHAR2,
p_approved_flag VARCHAR2,
p_approved_date DATE,
p_approved_by NUMBER,
p_settled_date DATE,
p_settled_by NUMBER,
p_performance_complete_flag VARCHAR2,
p_performance_attached_flag 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,
p_org_id NUMBER,
p_utilization_id NUMBER,
p_claim_currency_amount NUMBER,
p_item_id NUMBER,
p_item_description VARCHAR2,
p_quantity NUMBER,
p_quantity_uom VARCHAR2,
p_rate NUMBER,
p_activity_type VARCHAR2,
p_activity_id NUMBER,
p_earnings_associated_flag VARCHAR2,
p_comments VARCHAR2,
p_related_cust_account_id NUMBER,
p_relationship_type VARCHAR2,
p_tax_code VARCHAR2,
p_select_cust_children_flag VARCHAR2,
p_buy_group_cust_account_id NUMBER,
p_credit_to VARCHAR2,
p_sale_date DATE,
p_item_type VARCHAR2,
p_tax_amount NUMBER,
p_claim_curr_tax_amount NUMBER,
p_activity_line_id NUMBER,
p_offer_type VARCHAR2,
p_prorate_earnings_flag VARCHAR2,
p_earnings_end_date DATE
)
IS
BEGIN
UPDATE OZF_CLAIM_LINES_HIST_ALL
SET claim_line_history_id = p_claim_line_history_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,
created_from = p_created_from,
claim_history_id = p_claim_history_id,
claim_id = p_claim_id,
claim_line_id = p_claim_line_id,
line_number = p_line_number,
split_from_claim_line_id = p_split_from_claim_line_id,
amount = p_amount,
acctd_amount = p_acctd_amount,
currency_code = p_currency_code,
exchange_rate_type = p_exchange_rate_type,
exchange_rate_date = p_exchange_rate_date,
exchange_rate = p_exchange_rate,
set_of_books_id = p_set_of_books_id,
valid_flag = p_valid_flag,
source_object_id = p_source_object_id,
source_object_class = p_source_object_class,
source_object_type_id = p_source_object_type_id,
source_object_line_id = p_source_object_line_id,
plan_id = p_plan_id,
offer_id = p_offer_id,
payment_method = p_payment_method,
payment_reference_id = p_payment_reference_id,
payment_reference_number = p_payment_reference_number,
payment_reference_date = p_payment_reference_date,
voucher_id = p_voucher_id,
voucher_number = p_voucher_number,
payment_status = p_payment_status,
approved_flag = p_approved_flag,
approved_date = p_approved_date,
approved_by = p_approved_by,
settled_date = p_settled_date,
settled_by = p_settled_by,
performance_complete_flag = p_performance_complete_flag,
performance_attached_flag = p_performance_attached_flag,
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,
org_id = p_org_id,
utilization_id = p_utilization_id,
claim_currency_amount = p_claim_currency_amount,
item_id = p_item_id,
item_description = p_item_description,
quantity = p_quantity,
quantity_uom = p_quantity_uom,
rate = p_rate,
activity_type = p_activity_type,
activity_id = p_activity_id,
earnings_associated_flag = p_earnings_associated_flag,
comments = p_comments,
related_cust_account_id = p_related_cust_account_id,
relationship_type = p_relationship_type,
tax_code = p_tax_code,
select_cust_children_flag = p_select_cust_children_flag,
buy_group_cust_account_id = p_buy_group_cust_account_id,
credit_to = p_credit_to,
sale_date = p_sale_date,
item_type = p_item_type,
tax_amount = p_tax_amount,
claim_curr_tax_amount = p_claim_curr_tax_amount,
activity_line_id = p_activity_line_id,
offer_type = p_offer_type,
prorate_earnings_flag = p_prorate_earnings_flag,
earnings_end_date = p_earnings_end_date
WHERE CLAIM_LINE_HISTORY_ID = p_CLAIM_LINE_HISTORY_ID
AND object_version_number = p_object_version_number;
END Update_Row;
PROCEDURE Delete_Row(
p_claim_line_history_id NUMBER
)
IS
BEGIN
DELETE FROM OZF_CLAIM_LINES_HIST_ALL
WHERE CLAIM_LINE_HISTORY_ID = p_CLAIM_LINE_HISTORY_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_created_from VARCHAR2,
p_claim_history_id NUMBER,
p_claim_id NUMBER,
p_claim_line_id NUMBER,
p_line_number NUMBER,
p_split_from_claim_line_id NUMBER,
p_amount NUMBER,
p_acctd_amount NUMBER,
p_currency_code VARCHAR2,
p_exchange_rate_type VARCHAR2,
p_exchange_rate_date DATE,
p_exchange_rate NUMBER,
p_set_of_books_id NUMBER,
p_valid_flag VARCHAR2,
p_source_object_id NUMBER,
p_source_object_class VARCHAR2,
p_source_object_type_id NUMBER,
p_source_object_line_id NUMBER,
p_plan_id NUMBER,
p_offer_id NUMBER,
p_payment_method VARCHAR2,
p_payment_reference_id NUMBER,
p_payment_reference_number VARCHAR2,
p_payment_reference_date DATE,
p_voucher_id NUMBER,
p_voucher_number VARCHAR2,
p_payment_status VARCHAR2,
p_approved_flag VARCHAR2,
p_approved_date DATE,
p_approved_by NUMBER,
p_settled_date DATE,
p_settled_by NUMBER,
p_performance_complete_flag VARCHAR2,
p_performance_attached_flag 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,
p_org_id NUMBER,
p_utilization_id NUMBER,
p_claim_currency_amount NUMBER,
p_item_id NUMBER,
p_item_description VARCHAR2,
p_quantity NUMBER,
p_quantity_uom VARCHAR2,
p_rate NUMBER,
p_activity_type VARCHAR2,
p_activity_id NUMBER,
p_earnings_associated_flag VARCHAR2,
p_comments VARCHAR2,
p_related_cust_account_id NUMBER,
p_relationship_type VARCHAR2,
p_tax_code VARCHAR2,
p_select_cust_children_flag VARCHAR2,
p_buy_group_cust_account_id NUMBER,
p_credit_to VARCHAR2,
p_sale_date DATE,
p_item_type VARCHAR2,
p_tax_amount NUMBER,
p_claim_curr_tax_amount NUMBER,
p_activity_line_id NUMBER,
p_offer_type VARCHAR2,
p_prorate_earnings_flag VARCHAR2,
p_earnings_end_date DATE
)
IS
CURSOR C IS
SELECT *
FROM OZF_CLAIM_LINES_HIST_ALL
WHERE CLAIM_LINE_HISTORY_ID = p_CLAIM_LINE_HISTORY_ID
FOR UPDATE of CLAIM_LINE_HISTORY_ID NOWAIT;
FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
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.created_from = p_created_from)
OR ( ( Recinfo.created_from IS NULL )
AND ( p_created_from IS NULL )))
AND ( ( Recinfo.claim_history_id = p_claim_history_id)
OR ( ( Recinfo.claim_history_id IS NULL )
AND ( p_claim_history_id IS NULL )))
AND ( ( Recinfo.claim_id = p_claim_id)
OR ( ( Recinfo.claim_id IS NULL )
AND ( p_claim_id IS NULL )))
AND ( ( Recinfo.claim_line_id = p_claim_line_id)
OR ( ( Recinfo.claim_line_id IS NULL )
AND ( p_claim_line_id IS NULL )))
AND ( ( Recinfo.line_number = p_line_number)
OR ( ( Recinfo.line_number IS NULL )
AND ( p_line_number IS NULL )))
AND ( ( Recinfo.split_from_claim_line_id = p_split_from_claim_line_id)
OR ( ( Recinfo.split_from_claim_line_id IS NULL )
AND ( p_split_from_claim_line_id IS NULL )))
AND ( ( Recinfo.amount = p_amount)
OR ( ( Recinfo.amount IS NULL )
AND ( p_amount IS NULL )))
AND ( ( Recinfo.acctd_amount = p_acctd_amount)
OR ( ( Recinfo.acctd_amount IS NULL )
AND ( p_acctd_amount IS NULL )))
AND ( ( Recinfo.currency_code = p_currency_code)
OR ( ( Recinfo.currency_code IS NULL )
AND ( p_currency_code IS NULL )))
AND ( ( Recinfo.exchange_rate_type = p_exchange_rate_type)
OR ( ( Recinfo.exchange_rate_type IS NULL )
AND ( p_exchange_rate_type IS NULL )))
AND ( ( Recinfo.exchange_rate_date = p_exchange_rate_date)
OR ( ( Recinfo.exchange_rate_date IS NULL )
AND ( p_exchange_rate_date IS NULL )))
AND ( ( Recinfo.exchange_rate = p_exchange_rate)
OR ( ( Recinfo.exchange_rate IS NULL )
AND ( p_exchange_rate IS NULL )))
AND ( ( Recinfo.set_of_books_id = p_set_of_books_id)
OR ( ( Recinfo.set_of_books_id IS NULL )
AND ( p_set_of_books_id IS NULL )))
AND ( ( Recinfo.valid_flag = p_valid_flag)
OR ( ( Recinfo.valid_flag IS NULL )
AND ( p_valid_flag IS NULL )))
AND ( ( Recinfo.source_object_id = p_source_object_id)
OR ( ( Recinfo.source_object_id IS NULL )
AND ( p_source_object_id IS NULL )))
AND ( ( Recinfo.source_object_class = p_source_object_class)
OR ( ( Recinfo.source_object_class IS NULL )
AND ( p_source_object_class IS NULL )))
AND ( ( Recinfo.source_object_type_id = p_source_object_type_id)
OR ( ( Recinfo.source_object_type_id IS NULL )
AND ( p_source_object_type_id IS NULL )))
AND ( ( Recinfo.source_object_line_id = p_source_object_line_id)
OR ( ( Recinfo.source_object_line_id IS NULL )
AND ( p_source_object_line_id IS NULL )))
AND ( ( Recinfo.plan_id = p_plan_id)
OR ( ( Recinfo.plan_id IS NULL )
AND ( p_plan_id IS NULL )))
AND ( ( Recinfo.offer_id = p_offer_id)
OR ( ( Recinfo.offer_id IS NULL )
AND ( p_offer_id IS NULL )))
AND ( ( Recinfo.payment_method = p_payment_method)
OR ( ( Recinfo.payment_method IS NULL )
AND ( p_payment_method IS NULL )))
AND ( ( Recinfo.payment_reference_id = p_payment_reference_id)
OR ( ( Recinfo.payment_reference_id IS NULL )
AND ( p_payment_reference_id IS NULL )))
AND ( ( Recinfo.payment_reference_number = p_payment_reference_number)
OR ( ( Recinfo.payment_reference_number IS NULL )
AND ( p_payment_reference_number IS NULL )))
AND ( ( Recinfo.payment_reference_date = p_payment_reference_date)
OR ( ( Recinfo.payment_reference_date IS NULL )
AND ( p_payment_reference_date IS NULL )))
AND ( ( Recinfo.voucher_id = p_voucher_id)
OR ( ( Recinfo.voucher_id IS NULL )
AND ( p_voucher_id IS NULL )))
AND ( ( Recinfo.voucher_number = p_voucher_number)
OR ( ( Recinfo.voucher_number IS NULL )
AND ( p_voucher_number IS NULL )))
AND ( ( Recinfo.payment_status = p_payment_status)
OR ( ( Recinfo.payment_status IS NULL )
AND ( p_payment_status IS NULL )))
AND ( ( Recinfo.approved_flag = p_approved_flag)
OR ( ( Recinfo.approved_flag IS NULL )
AND ( p_approved_flag IS NULL )))
AND ( ( Recinfo.approved_date = p_approved_date)
OR ( ( Recinfo.approved_date IS NULL )
AND ( p_approved_date IS NULL )))
AND ( ( Recinfo.approved_by = p_approved_by)
OR ( ( Recinfo.approved_by IS NULL )
AND ( p_approved_by IS NULL )))
AND ( ( Recinfo.settled_date = p_settled_date)
OR ( ( Recinfo.settled_date IS NULL )
AND ( p_settled_date IS NULL )))
AND ( ( Recinfo.settled_by = p_settled_by)
OR ( ( Recinfo.settled_by IS NULL )
AND ( p_settled_by IS NULL )))
AND ( ( Recinfo.performance_complete_flag = p_performance_complete_flag)
OR ( ( Recinfo.performance_complete_flag IS NULL )
AND ( p_performance_complete_flag IS NULL )))
AND ( ( Recinfo.performance_attached_flag = p_performance_attached_flag)
OR ( ( Recinfo.performance_attached_flag IS NULL )
AND ( p_performance_attached_flag 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 )))
AND ( ( Recinfo.org_id = p_org_id)
OR ( ( Recinfo.org_id IS NULL )
AND ( p_org_id IS NULL )))
AND ( ( Recinfo.utilization_id = p_utilization_id)
OR ( ( Recinfo.utilization_id IS NULL )
AND ( p_utilization_id IS NULL )))
AND ( ( Recinfo.claim_currency_amount = p_claim_currency_amount)
OR ( ( Recinfo.claim_currency_amount IS NULL )
AND ( p_claim_currency_amount IS NULL )))
AND ( ( Recinfo.item_id = p_item_id)
OR ( ( Recinfo.item_id IS NULL )
AND ( p_item_id IS NULL )))
AND ( ( Recinfo.item_description = p_item_description)
OR ( ( Recinfo.item_description IS NULL )
AND ( p_item_description IS NULL )))
AND ( ( Recinfo.quantity = p_quantity)
OR ( ( Recinfo.quantity IS NULL )
AND ( p_quantity IS NULL )))
AND ( ( Recinfo.quantity_uom = p_quantity_uom)
OR ( ( Recinfo.quantity_uom IS NULL )
AND ( p_quantity_uom IS NULL )))
AND ( ( Recinfo.rate = p_rate)
OR ( ( Recinfo.rate IS NULL )
AND ( p_rate IS NULL )))
AND ( ( Recinfo.activity_type = p_activity_type)
OR ( ( Recinfo.activity_type IS NULL )
AND ( p_activity_type IS NULL )))
AND ( ( Recinfo.activity_id = p_activity_id)
OR ( ( Recinfo.activity_id IS NULL )
AND ( p_activity_id IS NULL )))
AND ( ( Recinfo.earnings_associated_flag = p_earnings_associated_flag)
OR ( ( Recinfo.earnings_associated_flag IS NULL )
AND ( p_earnings_associated_flag IS NULL )))
AND ( ( Recinfo.comments = p_comments)
OR ( ( Recinfo.comments IS NULL )
AND ( p_comments IS NULL )))
AND ( ( Recinfo.related_cust_account_id = p_related_cust_account_id)
OR ( ( Recinfo.related_cust_account_id IS NULL )
AND ( p_related_cust_account_id IS NULL )))
AND ( ( Recinfo.relationship_type = p_relationship_type)
OR ( ( Recinfo.relationship_type IS NULL )
AND ( p_relationship_type IS NULL )))
AND ( ( Recinfo.tax_code = p_tax_code)
OR ( ( Recinfo.tax_code IS NULL )
AND ( p_tax_code IS NULL )))
AND ( ( Recinfo.select_cust_children_flag = p_select_cust_children_flag)
OR ( ( Recinfo.select_cust_children_flag IS NULL )
AND ( p_select_cust_children_flag IS NULL )))
AND ( ( Recinfo.buy_group_cust_account_id = p_buy_group_cust_account_id)
OR ( ( Recinfo.buy_group_cust_account_id IS NULL )
AND ( p_buy_group_cust_account_id IS NULL )))
AND ( ( Recinfo.credit_to = p_credit_to)
OR ( ( Recinfo.credit_to IS NULL )
AND ( p_credit_to IS NULL )))
AND ( ( Recinfo.sale_date = p_sale_date)
OR ( ( Recinfo.sale_date IS NULL )
AND ( p_sale_date IS NULL )))
AND ( ( Recinfo.item_type = p_item_type)
OR ( ( Recinfo.item_type IS NULL )
AND ( p_item_type IS NULL )))
AND ( ( Recinfo.tax_amount = p_tax_amount)
OR ( ( Recinfo.tax_amount IS NULL )
AND ( p_tax_amount IS NULL )))
AND ( ( Recinfo.claim_curr_tax_amount = p_claim_curr_tax_amount)
OR ( ( Recinfo.claim_curr_tax_amount IS NULL )
AND ( p_claim_curr_tax_amount IS NULL )))
AND ( ( Recinfo.activity_line_id = p_activity_line_id)
OR ( ( Recinfo.activity_line_id IS NULL )
AND ( p_activity_line_id IS NULL )))
AND ( ( Recinfo.offer_type = p_offer_type)
OR ( ( Recinfo.offer_type IS NULL )
AND ( p_offer_type IS NULL )))
AND ( ( Recinfo.prorate_earnings_flag = p_prorate_earnings_flag)
OR ( ( Recinfo.prorate_earnings_flag IS NULL )
AND ( p_prorate_earnings_flag IS NULL )))
AND ( ( Recinfo.earnings_end_date = p_earnings_end_date)
OR ( ( Recinfo.earnings_end_date IS NULL )
AND ( p_earnings_end_date IS NULL )))
) THEN
RETURN;