[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE Insert_Row
(p_row_id IN OUT NOCOPY VARCHAR2
,p_ra_gl_date IN DATE
,P_ra_gl_period IN VARCHAR
,p_set_of_books_id IN NUMBER
,p_bill_to_customer_id IN NUMBER
,p_bill_to_customer_number IN VARCHAR2
,p_bill_to_customer_name IN VARCHAR2
,p_source IN VARCHAR2
,p_org_id IN NUMBER
,p_legal_entity_id IN NUMBER
,p_rule_header_id IN NUMBER
,p_gta_trx_header_id IN NUMBER
,p_gta_trx_number IN VARCHAR2
,p_group_number IN NUMBER
,p_version IN NUMBER
,p_latest_version_flag IN VARCHAR2
,p_transaction_date IN DATE
,p_ra_trx_id IN NUMBER
,p_ra_trx_number IN VARCHAR2
,p_description IN VARCHAR2
,p_customer_address IN VARCHAR2
,p_customer_phone IN VARCHAR2
,p_customer_address_phone IN VARCHAR2
,p_bank_account_name IN VARCHAR2
,p_bank_account_number IN VARCHAR2
,p_bank_account_name_number IN VARCHAR2
,p_fp_tax_registration_number IN VARCHAR2
,p_tp_tax_registration_number IN VARCHAR2
,p_ra_currency_code IN VARCHAR2
,p_conversion_type IN VARCHAR2
,p_conversion_date IN DATE
,p_conversion_rate IN NUMBER
,p_gta_batch_number IN VARCHAR2
,p_gt_invoice_number IN VARCHAR2
,p_gt_invoice_date IN DATE
,p_gt_invoice_net_amount IN NUMBER
,P_gt_invoice_tax_amount IN NUMBER
,p_status IN VARCHAR2
,p_sales_list_flag IN VARCHAR2
,p_cancel_flag IN VARCHAR2
,p_gt_invoice_type IN VARCHAR2
,p_gt_invoice_class IN VARCHAR2
,p_gt_tax_month IN VARCHAR2
,p_issuer_name IN VARCHAR2
,p_reviewer_name IN VARCHAR2
,p_payee_name IN VARCHAR2
,p_tax_code IN VARCHAR2
,p_tax_rate IN NUMBER
,p_generator_id IN NUMBER
,p_export_request_id IN NUMBER
,p_request_id IN NUMBER
,p_program_application_id IN NUMBER
,p_program_id IN NUMBER
,p_program_update_date IN DATE
,p_attribute_category IN VARCHAR2
,p_attribute1 IN VARCHAR2
,p_attribute2 IN VARCHAR2
,p_attribute3 IN VARCHAR2
,p_attribute4 IN VARCHAR2
,p_attribute5 IN VARCHAR2
,p_attribute6 IN VARCHAR2
,p_attribute7 IN VARCHAR2
,p_attribute8 IN VARCHAR2
,p_attribute9 IN VARCHAR2
,p_attribute10 IN VARCHAR2
,p_attribute11 IN VARCHAR2
,p_attribute12 IN VARCHAR2
,p_attribute13 IN VARCHAR2
,p_attribute14 IN VARCHAR2
,p_attribute15 IN VARCHAR2
,p_creation_date IN DATE
,p_created_by IN NUMBER
,p_last_update_date IN DATE
,p_last_updated_by IN NUMBER
,p_last_update_login IN NUMBER
,p_invoice_type IN VARCHAR2 --added by subba for R12.1
--Yao Zhang add begin for bug#8605196 consolidate invoices
,p_consolidation_id IN NUMBER
,p_consolidation_flag IN VARCHAR2
,p_consolidation_trx_num IN VARCHAR2
--Yao Zhang add end for bug#8605196 consolidate invoices
)
IS
l_procedure_name VARCHAR2(100) :='Insert_Row';
SELECT
ROWID
FROM
ar_gta_trx_headers_all
WHERE
gta_trx_header_id=p_gta_trx_header_id;
INSERT INTO ar_gta_trx_headers_all(
ra_gl_date
,ra_gl_period
,set_of_books_id
,bill_to_customer_id
,bill_to_customer_number
,bill_to_customer_name
,source
,org_id
,legal_entity_id
,rule_header_id
,gta_trx_header_id
,gta_trx_number
,group_number
,version
,latest_version_flag
,transaction_date
,ra_trx_id
,ra_trx_number
,description
,customer_address
,customer_phone
,customer_address_phone
,bank_account_name
,bank_account_number
,bank_account_name_number
,fp_tax_registration_number
,tp_tax_registration_number
,ra_currency_code
,conversion_type
,conversion_date
,conversion_rate
,gta_batch_number
,gt_invoice_number
,gt_invoice_date
,gt_invoice_net_amount
,gt_invoice_tax_amount
,status
,sales_list_flag
,cancel_flag
,gt_invoice_type
,gt_invoice_class
,gt_tax_month
,issuer_name
,reviewer_name
,payee_name
,tax_code
,tax_rate
,generator_id
,export_request_id
,request_id
,program_application_id
,program_id
,program_update_date
,attribute_category
,attribute1
,attribute2
,attribute3
,attribute4
,attribute5
,attribute6
,attribute7
,attribute8
,attribute9
,attribute10
,attribute11
,attribute12
,attribute13
,attribute14
,attribute15
,creation_date
,created_by
,last_update_date
,last_updated_by
,last_update_login
,invoice_type --added by subba for R12.1
--Yao Zhang add begin for bug#8605196 consolidate invoices
,consolidation_flag
,consolidation_id
,consolidation_trx_num
--Yao Zhang add end for bug#8605196 consolidate invoices
)
VALUES(
p_ra_gl_date
,P_ra_gl_period
,p_set_of_books_id
,p_bill_to_customer_id
,p_bill_to_customer_number
,p_bill_to_customer_name
,p_source
,p_org_id
,p_legal_entity_id
,p_rule_header_id
,p_gta_trx_header_id
,p_gta_trx_number
,p_group_number
,p_version
,p_latest_version_flag
,p_transaction_date
,p_ra_trx_id
,p_ra_trx_number
,p_description
,p_customer_address
,p_customer_phone
,p_customer_address_phone
,p_bank_account_name
,p_bank_account_number
,p_bank_account_name_number
,p_fp_tax_registration_number
,p_tp_tax_registration_number
,p_ra_currency_code
,p_conversion_type
,p_conversion_date
,p_conversion_rate
,p_gta_batch_number
,p_gt_invoice_number
,p_gt_invoice_date
,p_gt_invoice_net_amount
,P_gt_invoice_tax_amount
,p_status
,p_sales_list_flag
,p_cancel_flag
,p_gt_invoice_type
,p_gt_invoice_class
,p_gt_tax_month
,p_issuer_name
,p_reviewer_name
,p_payee_name
,p_tax_code
,p_tax_rate
,p_generator_id
,p_export_request_id
,p_request_id
,p_program_application_id
,p_program_id
,p_program_update_date
,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
,p_creation_date
,p_created_by
,p_last_update_date
,p_last_updated_by
,p_last_update_login
,p_invoice_type --added by subba for R12.1
--Yao Zhang add begin for bug#8605196 consolidate invoices
,p_consolidation_flag
,p_consolidation_id
,p_consolidation_trx_num
--Yao Zhang add end for bug#8605196 consolidate invoices
);
fnd_file.PUT_LINE(fnd_file.LOG,'Exception from header insert row'||SQLCODE || SQLERRM);
END Insert_Row;
PROCEDURE Update_Row
(p_row_id IN OUT NOCOPY VARCHAR2
,p_ra_gl_date IN DATE
,P_ra_gl_period IN VARCHAR
,p_set_of_books_id IN NUMBER
,p_bill_to_customer_id IN NUMBER
,p_bill_to_customer_number IN VARCHAR2
,p_bill_to_customer_name IN VARCHAR2
,p_source IN VARCHAR2
,p_org_id IN NUMBER
,p_legal_entity_id IN NUMBER
,p_rule_header_id IN NUMBER
,p_gta_trx_header_id IN NUMBER
,p_gta_trx_number IN VARCHAR2
,p_group_number IN NUMBER
,p_version IN NUMBER
,p_latest_version_flag IN VARCHAR2
,p_transaction_date IN DATE
,p_ra_trx_id IN NUMBER
,p_ra_trx_number IN VARCHAR2
,p_description IN VARCHAR2
,p_customer_address IN VARCHAR2
,p_customer_phone IN VARCHAR2
,p_customer_address_phone IN VARCHAR2
,p_bank_account_name IN VARCHAR2
,p_bank_account_number IN VARCHAR2
,p_bank_account_name_number IN VARCHAR2
,p_fp_tax_registration_number IN VARCHAR2
,p_tp_tax_registration_number IN VARCHAR2
,p_ra_currency_code IN VARCHAR2
,p_conversion_type IN VARCHAR2
,p_conversion_date IN DATE
,p_conversion_rate IN NUMBER
,p_gta_batch_number IN VARCHAR2
,p_gt_invoice_number IN VARCHAR2
,p_gt_invoice_date IN DATE
,p_gt_invoice_net_amount IN NUMBER
,P_gt_invoice_tax_amount IN NUMBER
,p_status IN VARCHAR2
,p_sales_list_flag IN VARCHAR2
,p_cancel_flag IN VARCHAR2
,p_gt_invoice_type IN VARCHAR2
,p_gt_invoice_class IN VARCHAR2
,p_gt_tax_month IN VARCHAR2
,p_issuer_name IN VARCHAR2
,p_reviewer_name IN VARCHAR2
,p_payee_name IN VARCHAR2
,p_tax_code IN VARCHAR2
,p_tax_rate IN NUMBER
,p_generator_id IN NUMBER
,p_export_request_id IN NUMBER
,p_request_id IN NUMBER
,p_program_application_id IN NUMBER
,p_program_id IN NUMBER
,p_program_update_date IN DATE
,p_attribute_category IN VARCHAR2
,p_attribute1 IN VARCHAR2
,p_attribute2 IN VARCHAR2
,p_attribute3 IN VARCHAR2
,p_attribute4 IN VARCHAR2
,p_attribute5 IN VARCHAR2
,p_attribute6 IN VARCHAR2
,p_attribute7 IN VARCHAR2
,p_attribute8 IN VARCHAR2
,p_attribute9 IN VARCHAR2
,p_attribute10 IN VARCHAR2
,p_attribute11 IN VARCHAR2
,p_attribute12 IN VARCHAR2
,p_attribute13 IN VARCHAR2
,p_attribute14 IN VARCHAR2
,p_attribute15 IN VARCHAR2
,p_creation_date IN DATE
,p_created_by IN NUMBER
,p_last_update_date IN DATE
,p_last_updated_by IN NUMBER
,p_last_update_login IN NUMBER
,p_invoice_type IN VARCHAR2 --added by subba for R12.1
)
IS
l_procedure_name VARCHAR2(100) :='Update_Row';
UPDATE ar_gta_trx_headers_all
SET
ra_gl_date = p_ra_gl_date
,ra_gl_period = p_ra_gl_period
,set_of_books_id = p_set_of_books_id
,bill_to_customer_id = p_bill_to_customer_id
,bill_to_customer_number = p_bill_to_customer_number
,bill_to_customer_name = p_bill_to_customer_name
,source = p_source
,org_id = p_org_id
,legal_entity_id = p_legal_entity_id
,rule_header_id = p_rule_header_id
,gta_trx_header_id = p_gta_trx_header_id
,gta_trx_number = p_gta_trx_number
,group_number = p_group_number
,version = p_version
,latest_version_flag = p_latest_version_flag
,transaction_date = p_transaction_date
,ra_trx_id = p_ra_trx_id
,ra_trx_number = p_ra_trx_number
,description = p_description
,customer_address = p_customer_address
,customer_phone = p_customer_phone
,customer_address_phone = p_customer_address_phone
,bank_account_name = p_bank_account_name
,bank_account_number = p_bank_account_number
,bank_account_name_number = p_bank_account_name_number
,fp_tax_registration_number = p_fp_tax_registration_number
,tp_tax_registration_number = p_tp_tax_registration_number
,ra_currency_code = p_ra_currency_code
,conversion_type = p_conversion_type
,conversion_date = p_conversion_date
,conversion_rate = p_conversion_rate
,gta_batch_number = p_gta_batch_number
,gt_invoice_number = p_gt_invoice_number
,gt_invoice_date = p_gt_invoice_date
,gt_invoice_net_amount = p_gt_invoice_net_amount
,gt_invoice_tax_amount = P_gt_invoice_tax_amount
,status = p_status
,sales_list_flag = p_sales_list_flag
,cancel_flag = p_cancel_flag
,gt_invoice_type = p_gt_invoice_type
,gt_invoice_class = p_gt_invoice_class
,gt_tax_month = p_gt_tax_month
,issuer_name = p_issuer_name
,reviewer_name = p_reviewer_name
,payee_name = p_payee_name
,tax_code = p_tax_code
,tax_rate = p_tax_rate
,generator_id = p_generator_id
,export_request_id = p_export_request_id
,request_id = p_request_id
,program_application_id = p_program_application_id
,program_id = p_program_id
,program_update_date = p_program_update_date
,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
,creation_date = p_creation_date
,created_by = p_created_by
,last_update_date = p_last_update_date
,last_updated_by = p_last_updated_by
,last_update_login = p_last_update_login
,invoice_type = p_invoice_type --added by subba for R12.1
WHERE ROWID=p_row_id;
END Update_Row;
,p_program_update_date IN DATE
,p_attribute_category IN VARCHAR2
,p_attribute1 IN VARCHAR2
,p_attribute2 IN VARCHAR2
,p_attribute3 IN VARCHAR2
,p_attribute4 IN VARCHAR2
,p_attribute5 IN VARCHAR2
,p_attribute6 IN VARCHAR2
,p_attribute7 IN VARCHAR2
,p_attribute8 IN VARCHAR2
,p_attribute9 IN VARCHAR2
,p_attribute10 IN VARCHAR2
,p_attribute11 IN VARCHAR2
,p_attribute12 IN VARCHAR2
,p_attribute13 IN VARCHAR2
,p_attribute14 IN VARCHAR2
,p_attribute15 IN VARCHAR2
,p_creation_date IN DATE
,p_created_by IN NUMBER
,p_last_update_date IN DATE
,p_last_updated_by IN NUMBER
,p_last_update_login IN NUMBER
,p_invoice_type IN VARCHAR2 --added by subba for R12.1
)
IS
l_procedure_name VARCHAR2(100) :='Lock_Row';
SELECT
*
FROM
ar_gta_trx_headers_all
WHERE ROWID=p_row_id
FOR UPDATE OF gta_trx_header_id NOWAIT;
FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
(recinfo.last_update_date=p_last_update_date)
AND
(recinfo.last_updated_by=p_last_updated_by)
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_id=p_program_id)
OR
(
(recinfo.program_id IS NULL)
AND
(p_program_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
(
(rtrim(recinfo.attribute_category)=p_attribute_category)
OR
(
(rtrim(recinfo.attribute_category) IS NULL)
AND
(p_attribute_category IS NULL)
)
)
AND
(
(rtrim(recinfo.attribute1)=p_attribute1)
OR
(
(rtrim(recinfo.attribute1) IS NULL)
AND
(p_attribute1 IS NULL)
)
)
AND
(
(rtrim(recinfo.attribute2)=p_attribute2)
OR
(
(rtrim(recinfo.attribute2) IS NULL)
AND
(p_attribute2 IS NULL)
)
)
AND
(
(rtrim(recinfo.attribute3)=p_attribute3)
OR
(
(rtrim(recinfo.attribute3) IS NULL)
AND
(p_attribute3 IS NULL)
)
)
AND
(
(rtrim(recinfo.attribute4)=p_attribute4)
OR
(
(rtrim(recinfo.attribute4) IS NULL)
AND
(p_attribute4 IS NULL)
)
)
AND
(
(rtrim(recinfo.attribute5)=p_attribute5)
OR
(
(rtrim(recinfo.attribute5) IS NULL)
AND
(p_attribute5 IS NULL)
)
)
AND
(
(rtrim(recinfo.attribute6)=p_attribute6)
OR
(
(rtrim(recinfo.attribute6) IS NULL)
AND
(p_attribute6 IS NULL)
)
)
AND
(
(rtrim(recinfo.attribute7)=p_attribute7)
OR
(
(rtrim(recinfo.attribute7) IS NULL)
AND
(p_attribute7 IS NULL)
)
)
AND
(
(rtrim(recinfo.attribute8)=p_attribute8)
OR
(
(rtrim(recinfo.attribute8) IS NULL)
AND
(p_attribute8 IS NULL)
)
)
AND
(
(rtrim(recinfo.attribute9)=p_attribute9)
OR
(
(rtrim(recinfo.attribute9) IS NULL)
AND
(p_attribute9 IS NULL)
)
)
AND
(
(rtrim(recinfo.attribute10)=p_attribute10)
OR
(
(rtrim(recinfo.attribute10) IS NULL)
AND
(p_attribute10 IS NULL)
)
)
AND
(
(rtrim(recinfo.attribute11)=p_attribute11)
OR
(
(rtrim(recinfo.attribute11) IS NULL)
AND
(p_attribute11 IS NULL)
)
)
AND
(
(rtrim(recinfo.attribute12)=p_attribute12)
OR
(
(rtrim(recinfo.attribute12) IS NULL)
AND
(p_attribute12 IS NULL)
)
)
AND
(
(rtrim(recinfo.attribute13)=p_attribute13)
OR
(
(rtrim(recinfo.attribute13) IS NULL)
AND
(p_attribute13 IS NULL)
)
)
AND
(
(rtrim(recinfo.attribute14)=p_attribute14)
OR
(
(rtrim(recinfo.attribute14) IS NULL)
AND
(p_attribute14 IS NULL)
)
)
AND
(
(rtrim(recinfo.attribute15)=p_attribute15)
OR
(
(rtrim(recinfo.attribute15) IS NULL)
AND
(p_attribute15 IS NULL)
)
)
AND (rtrim(recinfo.invoice_type) = p_invoice_type) --added by subba for R12.1
)
THEN
RETURN;
PROCEDURE Delete_Row
(p_rowid IN OUT NOCOPY VARCHAR2
)
IS
l_procedure_name VARCHAR2(100) :='Delete_Row';
SELECT gta_trx_number
, consolidation_flag
INTO l_consol_trx_num
,l_consolidation_flag
FROM AR_GTA_TRX_HEADERS_ALL
WHERE rowid = p_rowid;
UPDATE AR_GTA_TRX_HEADERS_ALL
SET STATUS = 'DRAFT'
,CONSOLIDATION_FLAG = NULL
,CONSOLIDATION_TRX_NUM = NULL
-- modified by Allen Yang for bug #8882568 concurrency control 05-Sep-2009
-------------------------------------------------------------------
,CONSOLIDATION_REQUEST_ID = NULL
,CONSOLIDATION_ID = NULL
-------------------------------------------------------------------
WHERE CONSOLIDATION_TRX_NUM = l_consol_trx_num
AND CONSOLIDATION_FLAG = '1';
DELETE
FROM
ar_gta_trx_headers_all
WHERE rowid = p_rowid;
END Delete_Row;
SELECT
ra_gl_date
,ra_gl_period
,set_of_books_id
,bill_to_customer_id
,bill_to_customer_number
,bill_to_customer_name
,source
,org_id
,legal_entity_id
,rule_header_id
,gta_trx_header_id
,gta_trx_number
,group_number
,version
,latest_version_flag
,transaction_date
,ra_trx_id
,ra_trx_number
,description
,customer_address
,customer_phone
,customer_address_phone
,bank_account_name
,bank_account_number
,bank_account_name_number
,fp_tax_registration_number
,tp_tax_registration_number
,ra_currency_code
,conversion_type
,conversion_date
,conversion_rate
,gta_batch_number
,gt_invoice_number
,gt_invoice_date
,gt_invoice_net_amount
,gt_invoice_tax_amount
,status
,sales_list_flag
,cancel_flag
,gt_invoice_type
,gt_invoice_class
,gt_tax_month
,issuer_name
,reviewer_name
,payee_name
,tax_code
,tax_rate
,generator_id
,request_id
,program_application_id
,program_id
,program_update_date
,attribute_category
,attribute1
,attribute2
,attribute3
,attribute4
,attribute5
,attribute6
,attribute7
,attribute8
,attribute9
,attribute10
,attribute11
,attribute12
,attribute13
,attribute14
,attribute15
,creation_date
,created_by
,last_update_date
,last_updated_by
,last_update_login
,invoice_type --added by subba for R12.1
--Yao Zhang add for bug8605196
,consolidation_flag
,consolidation_id
,consolidation_trx_num
INTO
x_trx_header_rec.ra_gl_date
,x_trx_header_rec.ra_gl_period
,x_trx_header_rec.set_of_books_id
,x_trx_header_rec.bill_to_customer_id
,x_trx_header_rec.bill_to_customer_number
,x_trx_header_rec.bill_to_customer_name
,x_trx_header_rec.source
,x_trx_header_rec.org_id
,x_trx_header_rec.legal_entity_id
,x_trx_header_rec.rule_header_id
,x_trx_header_rec.gta_trx_header_id
,x_trx_header_rec.gta_trx_number
,x_trx_header_rec.group_number
,x_trx_header_rec.version
,x_trx_header_rec.latest_version_flag
,x_trx_header_rec.transaction_date
,x_trx_header_rec.ra_trx_id
,x_trx_header_rec.ra_trx_number
,x_trx_header_rec.description
,x_trx_header_rec.customer_address
,x_trx_header_rec.customer_phone
,x_trx_header_rec.customer_address_phone
,x_trx_header_rec.bank_account_name
,x_trx_header_rec.bank_account_number
,x_trx_header_rec.bank_account_name_number
,x_trx_header_rec.fp_tax_registration_number
,x_trx_header_rec.tp_tax_registration_number
,x_trx_header_rec.ra_currency_code
,x_trx_header_rec.conversion_type
,x_trx_header_rec.conversion_date
,x_trx_header_rec.conversion_rate
,x_trx_header_rec.gta_batch_number
,x_trx_header_rec.gt_invoice_number
,x_trx_header_rec.gt_invoice_date
,x_trx_header_rec.gt_invoice_net_amount
,x_trx_header_rec.gt_invoice_tax_amount
,x_trx_header_rec.status
,x_trx_header_rec.sales_list_flag
,x_trx_header_rec.cancel_flag
,x_trx_header_rec.gt_invoice_type
,x_trx_header_rec.gt_invoice_class
,x_trx_header_rec.gt_tax_month
,x_trx_header_rec.issuer_name
,x_trx_header_rec.reviewer_name
,x_trx_header_rec.payee_name
,x_trx_header_rec.tax_code
,x_trx_header_rec.tax_rate
,x_trx_header_rec.generator_id
,x_trx_header_rec.request_id
,x_trx_header_rec.program_application_id
,x_trx_header_rec.program_id
,x_trx_header_rec.program_update_date
,x_trx_header_rec.attribute_category
,x_trx_header_rec.attribute1
,x_trx_header_rec.attribute2
,x_trx_header_rec.attribute3
,x_trx_header_rec.attribute4
,x_trx_header_rec.attribute5
,x_trx_header_rec.attribute6
,x_trx_header_rec.attribute7
,x_trx_header_rec.attribute8
,x_trx_header_rec.attribute9
,x_trx_header_rec.attribute10
,x_trx_header_rec.attribute11
,x_trx_header_rec.attribute12
,x_trx_header_rec.attribute13
,x_trx_header_rec.attribute14
,x_trx_header_rec.attribute15
,x_trx_header_rec.creation_date
,x_trx_header_rec.created_by
,x_trx_header_rec.last_update_date
,x_trx_header_rec.last_updated_by
,x_trx_header_rec.last_update_login
,x_trx_header_rec.invoice_type --added by subba for R12.1
--Yao Zhang add for bug8605196
,x_trx_header_rec.consolidation_flag
,x_trx_header_rec.consolidation_id
,x_trx_header_rec.consolidation_trx_num
FROM
ar_gta_trx_headers_all
WHERE gta_trx_header_id=p_header_id;
SELECT gta_trx_number
INTO l_consol_trx_num
FROM AR_GTA_TRX_HEADERS_ALL
WHERE rowid = p_rowid;
UPDATE AR_GTA_TRX_HEADERS_ALL
SET STATUS = 'DRAFT'
, CONSOLIDATION_FLAG = NULL
, CONSOLIDATION_TRX_NUM = NULL
-- added by Allen Yang for bug #8882568 concurrency control 05-Sep-2009
-------------------------------------------------------------------
, CONSOLIDATION_REQUEST_ID = NULL
, CONSOLIDATION_ID = NULL
-------------------------------------------------------------------
WHERE CONSOLIDATION_TRX_NUM = l_consol_trx_num
AND CONSOLIDATION_FLAG = '1';
/* will delete_record in form trigger, so remove the logic here
DELETE
FROM
ar_gta_trx_headers_all
WHERE rowid = p_rowid;