[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE Insert_Row(
p_request_line_id NUMBER,
p_object_version_number 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_create_from VARCHAR2,
p_request_header_id NUMBER,
p_product_context VARCHAR2,
p_inventory_item_id NUMBER,
p_prod_catg_id NUMBER,
p_product_cat_set_id NUMBER,
p_product_cost NUMBER,
p_item_uom VARCHAR2,
p_requested_discount_type VARCHAR2,
p_requested_discount_value NUMBER,
p_cost_basis VARCHAR2,
p_max_qty NUMBER,
p_limit_qty NUMBER,
p_design_win VARCHAR2,
p_end_customer_price NUMBER,
p_requested_line_amount NUMBER,
p_approved_discount_type VARCHAR2,
p_approved_discount_value NUMBER,
p_approved_amount NUMBER,
p_total_requested_amount NUMBER,
p_total_approved_amount NUMBER,
p_approved_max_qty NUMBER,
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_vendor_approved_flag VARCHAR2,
p_vendor_item_code VARCHAR2,
p_start_date DATE,
p_end_date DATE,
p_end_customer_price_type VARCHAR2,
p_end_customer_tolerance_type VARCHAR2,
p_end_customer_tolerance_value NUMBER,
p_security_group_id NUMBER,
p_org_id NUMBER,
p_rejection_code VARCHAR2,
p_discount_currency VARCHAR2,
p_product_cost_currency VARCHAR2,
p_end_customer_currency VARCHAR2,
p_approved_discount_currency VARCHAR2)
IS
BEGIN
INSERT INTO OZF_SD_REQUEST_LINES_ALL(
request_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,
create_from,
request_header_id,
product_context,
inventory_item_id,
prod_catg_id,
product_cat_set_id,
product_cost,
item_uom,
requested_discount_type,
requested_discount_value,
cost_basis,
max_qty,
limit_qty,
design_win,
end_customer_price,
requested_line_amount,
approved_discount_type,
approved_discount_value,
approved_amount,
total_requested_amount,
total_approved_amount,
approved_max_qty,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
vendor_approved_flag,
vendor_item_code,
start_date,
end_date,
end_customer_price_type,
end_customer_tolerance_type,
end_customer_tolerance_value,
security_group_id,
org_id,
rejection_code,
requested_discount_currency,
product_cost_currency,
end_customer_currency,
approved_discount_currency
)
VALUES(
p_request_line_id,
p_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_create_from,
p_request_header_id,
p_product_context,
p_inventory_item_id,
p_prod_catg_id,
p_product_cat_set_id,
p_product_cost,
p_item_uom,
p_requested_discount_type,
p_requested_discount_value,
p_cost_basis,
p_max_qty,
p_limit_qty,
p_design_win,
p_end_customer_price,
p_requested_line_amount,
p_approved_discount_type,
p_approved_discount_value,
p_approved_amount,
p_total_requested_amount,
p_total_approved_amount,
p_approved_max_qty,
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_vendor_approved_flag,
p_vendor_item_code,
p_start_date,
p_end_date,
p_end_customer_price_type,
p_end_customer_tolerance_type,
p_end_customer_tolerance_value,
p_security_group_id,
p_org_id,
p_rejection_code,
p_discount_currency,
p_product_cost_currency,
p_end_customer_currency,
p_approved_discount_currency);
END Insert_Row;
PROCEDURE Update_Row(
p_request_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_create_from VARCHAR2,
p_request_header_id NUMBER,
p_product_context VARCHAR2,
p_inventory_item_id NUMBER,
p_prod_catg_id NUMBER,
p_product_cat_set_id NUMBER,
p_product_cost NUMBER,
p_item_uom VARCHAR2,
p_requested_discount_type VARCHAR2,
p_requested_discount_value NUMBER,
p_cost_basis VARCHAR2,
p_max_qty NUMBER,
p_limit_qty NUMBER,
p_design_win VARCHAR2,
p_end_customer_price NUMBER,
p_requested_line_amount NUMBER,
p_approved_discount_type VARCHAR2,
p_approved_discount_value NUMBER,
p_approved_amount NUMBER,
p_total_requested_amount NUMBER,
p_total_approved_amount NUMBER,
p_approved_max_qty NUMBER,
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_vendor_approved_flag VARCHAR2,
p_vendor_item_code VARCHAR2,
p_start_date DATE,
p_end_date DATE,
p_end_customer_price_type VARCHAR2,
p_end_customer_tolerance_type VARCHAR2,
p_end_customer_tolerance_value NUMBER,
p_security_group_id NUMBER,
p_org_id NUMBER,
p_rejection_code VARCHAR2,
p_discount_currency VARCHAR2,
p_product_cost_currency VARCHAR2,
p_end_customer_currency VARCHAR2,
p_approved_discount_currency VARCHAR2)
IS
BEGIN
UPDATE OZF_SD_REQUEST_LINES_ALL
SET request_line_id = p_request_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,
create_from = p_create_from,
request_header_id = p_request_header_id,
product_context = p_product_context,
inventory_item_id = p_inventory_item_id,
prod_catg_id = p_prod_catg_id,
product_cat_set_id = p_product_cat_set_id,
product_cost = p_product_cost,
item_uom = p_item_uom,
requested_discount_type = p_requested_discount_type,
requested_discount_value = p_requested_discount_value,
cost_basis = p_cost_basis,
max_qty = p_max_qty,
limit_qty = p_limit_qty,
design_win = p_design_win,
end_customer_price = p_end_customer_price,
requested_line_amount = p_requested_line_amount,
approved_discount_type = p_approved_discount_type,
approved_discount_value = p_approved_discount_value,
approved_amount = p_approved_amount,
total_requested_amount = p_total_requested_amount,
total_approved_amount = p_total_approved_amount,
approved_max_qty = p_approved_max_qty,
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,
vendor_approved_flag = p_vendor_approved_flag,
vendor_item_code = p_vendor_item_code,
start_date = p_start_date,
end_date = p_end_date,
end_customer_price_type = p_end_customer_price_type,
end_customer_tolerance_type = p_end_customer_tolerance_type,
end_customer_tolerance_value = p_end_customer_tolerance_value,
security_group_id = p_security_group_id,
org_id = p_org_id,
rejection_code = p_rejection_code,
requested_discount_currency = p_discount_currency,
product_cost_currency = p_product_cost_currency,
end_customer_currency = p_end_customer_currency,
approved_discount_currency = p_approved_discount_currency
WHERE request_line_id =p_request_line_id;
END Update_Row;