[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE Insert_Row
(p_rowid IN OUT NOCOPY VARCHAR2
,p_org_id IN NUMBER
,p_gta_trx_header_id IN NUMBER
,p_gta_trx_line_id IN NUMBER
,p_matched_flag IN VARCHAR2
,p_line_number IN VARCHAR2
,p_ar_trx_line_id IN NUMBER
,p_inventory_item_id IN NUMBER
,p_item_number IN VARCHAR2
,p_item_description IN VARCHAR2
,p_item_model IN VARCHAR2
,p_item_tax_denomination IN VARCHAR2
,p_tax_rate IN NUMBER
,p_uom IN VARCHAR2
,p_uom_name IN VARCHAR2
,p_quantity IN NUMBER
,p_price_flag IN VARCHAR2
,p_unit_price IN NUMBER
,p_unit_tax_price IN NUMBER
,p_amount IN NUMBER
,p_original_currency_amount IN NUMBER
,p_tax_amount IN NUMBER
,p_discount_flag IN VARCHAR2
,p_enabled_flag IN VARCHAR2
,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
--Yao Zhang add for bug#8605196 to support discount line
,p_discount_amount IN NUMBER
,p_discount_tax_amount IN NUMBER
,p_discount_rate IN NUMBER
)
IS
l_procedure_name VARCHAR2(100) :='Insert_Row';
SELECT
ROWID
FROM
ar_gta_trx_lines_all
WHERE gta_trx_line_id=p_gta_trx_line_id;
INSERT INTO ar_gta_trx_lines_all(
org_id
,gta_trx_header_id
,gta_trx_line_id
,matched_flag
,line_number
,ar_trx_line_id
,inventory_item_id
,item_number
,item_description
,item_model
,item_tax_denomination
,tax_rate
,uom
,uom_name
,quantity
,price_flag
,unit_price
,unit_tax_price
,amount
,original_currency_amount
,tax_amount
,discount_flag
,enabled_flag
,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
--yao zhang add for bug#8605196 to support discount line
,discount_amount
,discount_tax_amount
,discount_rate
)
VALUES(
p_org_id
,p_gta_trx_header_id
,p_gta_trx_line_id
,p_matched_flag
,p_line_number
,p_ar_trx_line_id
,p_inventory_item_id
,p_item_number
,p_item_description
,p_item_model
,p_item_tax_denomination
,p_tax_rate
,p_uom
,p_uom_name
,p_quantity
,p_price_flag
,p_unit_price
,p_unit_tax_price
,p_amount
,p_original_currency_amount
,p_tax_amount
,p_discount_flag
,p_enabled_flag
,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
--yao zhang add for bug#8605196 to support discount line
,p_discount_amount
,p_discount_tax_amount
,p_discount_rate
);
fnd_file.PUT_LINE(fnd_file.LOG,'Exception from insert row'||SQLCODE || SQLERRM);
END Insert_Row;
PROCEDURE Update_Row
(p_rowid IN OUT NOCOPY VARCHAR2
,p_org_id IN NUMBER
,p_gta_trx_header_id IN NUMBER
,p_gta_trx_line_id IN NUMBER
,p_line_number IN VARCHAR2
,p_item_number IN VARCHAR2
,p_item_description IN VARCHAR2
,p_item_model IN VARCHAR2
,p_item_tax_denomination IN VARCHAR2
,p_tax_rate IN NUMBER
,p_uom_name IN VARCHAR2
,p_quantity IN NUMBER
,p_unit_price IN NUMBER
,p_amount IN NUMBER
,p_original_currency_amount IN NUMBER
,p_enabled_flag IN VARCHAR2
,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
)
IS
l_procedure_name VARCHAR2(100) :='Update_Row';
UPDATE ar_gta_trx_lines_all
SET
org_id = p_org_id
,gta_trx_header_id = p_gta_trx_header_id
,gta_trx_line_id = p_gta_trx_line_id
,line_number = p_line_number
,item_number = p_item_number
,item_description = p_item_description
,item_model = p_item_model
,item_tax_denomination = p_item_tax_denomination
,tax_rate = p_tax_rate
,uom_name = p_uom_name
,quantity = p_quantity
,unit_price = p_unit_price
,amount = p_amount
,original_currency_amount = p_original_currency_amount
,enabled_flag = p_enabled_flag
,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
WHERE ROWID=p_rowid;
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
)
IS
l_procedure_name VARCHAR2(100) :='Lock_Row';
SELECT
*
FROM
ar_gta_trx_lines_all
WHERE ROWID=p_rowid
FOR UPDATE OF gta_trx_line_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
(
(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;
PROCEDURE Delete_Row
(p_rowid IN OUT NOCOPY VARCHAR2
)
IS
l_procedure_name VARCHAR2(100) :='Delete_Row';
DELETE
FROM AR_GTA_TRX_LINES_ALL
WHERE ROWID = p_rowid;
END Delete_Row;
SELECT org_id,
gta_trx_header_id,
gta_trx_line_id,
matched_flag,
line_number,
ar_trx_line_id,
inventory_item_id,
item_number,
item_description,
item_model,
item_tax_denomination,
tax_rate,
uom,
uom_name,
quantity,
price_flag,
unit_price,
amount,
original_currency_amount,
tax_amount,
discount_flag,
enabled_flag,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
last_update_date,
last_updated_by,
creation_date,
created_by,
last_update_login,
program_id,
program_application_id,
program_update_date,
request_id,
discount_amount,
discount_tax_amount,
discount_rate
INTO x_trx_line_rec.org_id,
x_trx_line_rec.gta_trx_header_id,
x_trx_line_rec.gta_trx_line_id,
x_trx_line_rec.matched_flag,
x_trx_line_rec.line_number,
x_trx_line_rec.ar_trx_line_id,
x_trx_line_rec.inventory_item_id,
x_trx_line_rec.item_number,
x_trx_line_rec.item_description,
x_trx_line_rec.item_model,
x_trx_line_rec.item_tax_denomination,
x_trx_line_rec.tax_rate,
x_trx_line_rec.uom,
x_trx_line_rec.uom_name,
x_trx_line_rec.quantity,
x_trx_line_rec.price_flag,
x_trx_line_rec.unit_price,
x_trx_line_rec.amount,
x_trx_line_rec.original_currency_amount,
x_trx_line_rec.tax_amount,
x_trx_line_rec.discount_flag,
x_trx_line_rec.enabled_flag,
x_trx_line_rec.attribute_category,
x_trx_line_rec.attribute1,
x_trx_line_rec.attribute2,
x_trx_line_rec.attribute3,
x_trx_line_rec.attribute4,
x_trx_line_rec.attribute5,
x_trx_line_rec.attribute6,
x_trx_line_rec.attribute7,
x_trx_line_rec.attribute8,
x_trx_line_rec.attribute9,
x_trx_line_rec.attribute10,
x_trx_line_rec.attribute11,
x_trx_line_rec.attribute12,
x_trx_line_rec.attribute13,
x_trx_line_rec.attribute14,
x_trx_line_rec.attribute15,
x_trx_line_rec.last_update_date,
x_trx_line_rec.last_updated_by,
x_trx_line_rec.creation_date,
x_trx_line_rec.created_by,
x_trx_line_rec.last_update_login,
x_trx_line_rec.program_id,
x_trx_line_rec.program_applicaton_id,
x_trx_line_rec.program_update_date,
x_trx_line_rec.request_id,
x_trx_line_rec.discount_amount,
x_trx_line_rec.discount_tax_amount,
x_trx_line_rec.discount_rate
FROM ar_gta_trx_lines_all
WHERE gta_trx_line_id = p_trx_line_id;