[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE NAME: insert_line
===========================================================================*/
PROCEDURE insert_line (x_rowid IN OUT NOCOPY VARCHAR2,
x_express_name IN VARCHAR2,
x_sequence_num IN NUMBER,
x_creation_date IN DATE,
x_last_update_date IN DATE,
x_po_header_id IN NUMBER,
x_po_line_id IN NUMBER,
x_created_by IN NUMBER,
x_last_update_login IN NUMBER,
x_item_id IN NUMBER,
x_line_type_id IN NUMBER,
x_item_revision IN VARCHAR2,
x_category_id IN NUMBER,
x_unit_meas_lookup_code IN VARCHAR2,
x_suggested_quantity IN NUMBER, --KitSupport FPJ
x_unit_price IN NUMBER,
x_suggested_vendor_id IN NUMBER,
x_suggested_vendor_site_id IN NUMBER,
x_suggested_vendor_contact_id IN NUMBER,
x_suggested_vendor_prod_code IN VARCHAR2,
x_suggested_buyer_id IN NUMBER,
x_rfq_required_flag IN VARCHAR2,
x_vendor_source_context IN VARCHAR2,
x_source_type_code IN VARCHAR2,
x_source_organization_id IN NUMBER,
x_source_subinventory IN VARCHAR2,
x_item_description IN VARCHAR2,
x_attribute_category IN VARCHAR2,
x_attribute1 IN VARCHAR2,
x_attribute2 IN VARCHAR2,
x_attribute3 IN VARCHAR2,
x_attribute4 IN VARCHAR2,
x_attribute5 IN VARCHAR2,
x_attribute6 IN VARCHAR2,
x_attribute7 IN VARCHAR2,
x_attribute8 IN VARCHAR2,
x_attribute9 IN VARCHAR2,
x_attribute10 IN VARCHAR2,
x_attribute11 IN VARCHAR2,
x_attribute12 IN VARCHAR2,
x_attribute13 IN VARCHAR2,
x_attribute14 IN VARCHAR2,
x_attribute15 IN VARCHAR2,
x_amount IN NUMBER, --
x_negotiated_by_preparer_flag IN VARCHAR2, --
p_org_id IN NUMBER DEFAULT NULL --
)
IS
x_progress VARCHAR2(3) := '';
SELECT rowid
FROM PO_REQEXPRESS_LINES
WHERE express_name = x_express_name
AND sequence_num = x_sequence_num;
INSERT INTO PO_REQEXPRESS_LINES (
express_name,
sequence_num,
last_update_date,
last_updated_by,
creation_date,
po_header_id,
po_line_id,
created_by,
last_update_login,
item_id,
line_type_id,
item_revision,
category_id,
unit_meas_lookup_code,
suggested_quantity, --KitSupport FPJ
unit_price,
suggested_vendor_id,
suggested_vendor_site_id,
suggested_vendor_contact_id,
suggested_vendor_product_code,
suggested_buyer_id,
rfq_required_flag,
vendor_source_context,
source_type_code,
source_organization_id,
source_subinventory,
item_description,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
amount,
negotiated_by_preparer_flag,--
Org_Id, --
ip_category_id --
)
VALUES (
x_express_name,
x_sequence_num,
x_last_update_date,
x_created_by,
x_creation_date,
x_po_header_id,
x_po_line_id,
x_created_by,
x_last_update_login,
x_item_id,
x_line_type_id,
x_item_revision,
x_category_id,
x_unit_meas_lookup_code,
x_suggested_quantity, --KitSupport FPJ
x_unit_price,
x_suggested_vendor_id,
x_suggested_vendor_site_id,
x_suggested_vendor_contact_id,
x_suggested_vendor_prod_code,
x_suggested_buyer_id,
x_rfq_required_flag,
x_vendor_source_context,
x_source_type_code,
x_source_organization_id,
x_source_subinventory,
x_item_description,
x_attribute_category,
x_attribute1,
x_attribute2,
x_attribute3,
x_attribute4,
x_attribute5,
x_attribute6,
x_attribute7,
x_attribute8,
x_attribute9,
x_attribute10,
x_attribute11,
x_attribute12,
x_attribute13,
x_attribute14,
x_attribute15,
x_amount,
x_negotiated_by_preparer_flag, --
p_org_id, --
l_ip_category_id --
);
PO_MESSAGE_S.SQL_ERROR('INSERT_HEADER', x_progress, sqlcode);
PROCEDURE NAME: update_line
===========================================================================*/
PROCEDURE update_line (x_rowid VARCHAR2,
x_express_name VARCHAR2,
x_sequence_num NUMBER,
x_last_updated_by NUMBER,
x_last_update_date DATE,
x_po_header_id NUMBER,
x_po_line_id NUMBER,
x_last_update_login NUMBER,
x_item_id NUMBER,
x_line_type_id NUMBER,
x_item_revision VARCHAR2,
x_category_id NUMBER,
x_unit_meas_lookup_code VARCHAR2,
x_suggested_quantity NUMBER, --KitSupport FPJ
x_unit_price NUMBER,
x_suggested_vendor_id NUMBER,
x_suggested_vendor_site_id NUMBER,
x_suggested_vendor_contact_id NUMBER,
x_suggested_vendor_prod_code VARCHAR2,
x_suggested_buyer_id NUMBER,
x_rfq_required_flag VARCHAR2,
x_vendor_source_context VARCHAR2,
x_source_type_code VARCHAR2,
x_source_organization_id NUMBER,
x_source_subinventory VARCHAR2,
x_item_description VARCHAR2,
x_attribute_category VARCHAR2,
x_attribute1 VARCHAR2,
x_attribute2 VARCHAR2,
x_attribute3 VARCHAR2,
x_attribute4 VARCHAR2,
x_attribute5 VARCHAR2,
x_attribute6 VARCHAR2,
x_attribute7 VARCHAR2,
x_attribute8 VARCHAR2,
x_attribute9 VARCHAR2,
x_attribute10 VARCHAR2,
x_attribute11 VARCHAR2,
x_attribute12 VARCHAR2,
x_attribute13 VARCHAR2,
x_attribute14 VARCHAR2,
x_attribute15 VARCHAR2,
x_amount NUMBER, --
x_negotiated_by_preparer_flag VARCHAR2) --
IS
x_progress VARCHAR2(3) := '';
UPDATE PO_REQEXPRESS_LINES
SET express_name = x_express_name,
sequence_num = x_sequence_num,
last_update_date = x_last_update_date,
last_updated_by = x_last_updated_by,
po_header_id = x_po_header_id,
po_line_id = x_po_line_id,
last_update_login = x_last_update_login,
item_id = x_item_id,
line_type_id = x_line_type_id,
item_revision = x_item_revision,
category_id = x_category_id,
unit_meas_lookup_code = x_unit_meas_lookup_code,
suggested_quantity = x_suggested_quantity, --KitSupport FPJ
unit_price = x_unit_price,
suggested_vendor_id = x_suggested_vendor_id,
suggested_vendor_site_id = x_suggested_vendor_site_id,
suggested_vendor_contact_id = x_suggested_vendor_contact_id,
suggested_vendor_product_code = x_suggested_vendor_prod_code,
suggested_buyer_id = x_suggested_buyer_id,
rfq_required_flag = x_rfq_required_flag,
vendor_source_context = x_vendor_source_context,
source_type_code = x_source_type_code,
source_organization_id = x_source_organization_id,
source_subinventory = x_source_subinventory,
item_description = x_item_description,
attribute_category = x_attribute_category,
attribute1 = x_attribute1,
attribute2 = x_attribute2,
attribute3 = x_attribute3,
attribute4 = x_attribute4,
attribute5 = x_attribute5,
attribute6 = x_attribute6,
attribute7 = x_attribute7,
attribute8 = x_attribute8,
attribute9 = x_attribute9,
attribute10 = x_attribute10,
attribute11 = x_attribute11,
attribute12 = x_attribute12,
attribute13 = x_attribute13,
attribute14 = x_attribute14,
attribute15 = x_attribute15,
amount = x_amount,
negotiated_by_preparer_flag = x_negotiated_by_preparer_flag, --
ip_category_id = l_ip_category_id --
WHERE rowid = x_rowid;
PO_ATTRIBUTE_VALUES_PVT.update_attributes
(
p_doc_type => 'REQ_TEMPLATE'
, p_po_line_id => NULL
, p_req_template_name => x_express_name
, p_req_template_line_num => x_sequence_num
, p_org_id => PO_MOAC_UTILS_PVT.get_current_org_id
, p_ip_category_id => l_ip_category_id
, p_language => userenv('LANG')
, p_item_description => x_item_description
);
PO_MESSAGE_S.SQL_ERROR('UPDATE_LINES', x_progress, sqlcode);
SELECT *
FROM PO_REQEXPRESS_LINES
WHERE rowid = x_rowid
FOR UPDATE of express_name NOWAIT;
FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
PROCEDURE NAME: delete_line
===========================================================================*/
PROCEDURE delete_line (x_rowid VARCHAR2)
IS
--
l_req_template_name PO_REQEXPRESS_LINES_ALL.express_name%TYPE;
DELETE FROM PO_REQEXPRESS_LINES
WHERE rowid = X_Rowid
--
RETURNING
express_name,
sequence_num,
org_id
INTO
l_req_template_name,
l_req_template_line_num,
l_org_id;
PO_ATTRIBUTE_VALUES_PVT.delete_attributes
(
p_doc_type => 'REQ_TEMPLATE'
, p_req_template_name => l_req_template_name
, p_req_template_line_num => l_req_template_line_num
, p_org_id => l_org_id
);