[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
p_last_update_login NUMBER
)
IS
CURSOR C IS
SELECT *
FROM mtl_client_parameters
WHERE rowid = X_Rowid
FOR UPDATE of client_id NOWAIT;
FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
AND ( (Recinfo.last_update_login = p_last_update_login)
OR ( (Recinfo.last_update_login IS NULL)
AND (p_last_update_login IS NULL)))
) then
return;
/* Procedure to Insert record for MTL_CLIENT_PARAMETERS table
*/
PROCEDURE insert_row (X_Rowid IN OUT NOCOPY VARCHAR2,
p_client_id NUMBER,
p_client_code VARCHAR2,
p_client_number VARCHAR2,
p_trading_partner_site_id NUMBER,
p_receipt_asn_exists_code VARCHAR2,
p_rma_receipt_routing_id NUMBER,
p_group_by_customer_flag VARCHAR2,
p_group_by_freight_terms_flag VARCHAR2,
p_group_by_fob_flag VARCHAR2,
p_group_by_ship_method_flag VARCHAR2,
p_otm_enabled VARCHAR2,
p_ship_confirm_rule_id NUMBER,
p_autocreate_del_orders_flag VARCHAR2,
p_delivery_report_set_id NUMBER,
p_lpn_prefix VARCHAR2,
p_lpn_suffix VARCHAR2,
p_ucc_128_suffix_flag VARCHAR2,
p_total_lpn_length NUMBER,
p_lpn_starting_number 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_last_update_date DATE,
p_last_updated_by NUMBER,
p_creation_date DATE,
p_created_by NUMBER,
p_last_update_login NUMBER
) IS
CURSOR C IS SELECT rowid FROM mtl_client_parameters
WHERE client_id = p_client_id;
INSERT INTO mtl_client_parameters(
client_id,
client_code,
client_number,
trading_partner_site_id,
receipt_asn_exists_code,
rma_receipt_routing_id,
group_by_customer_flag,
group_by_freight_terms_flag,
group_by_fob_flag,
group_by_ship_method_flag,
otm_enabled,
ship_confirm_rule_id,
autocreate_del_orders_flag,
delivery_report_set_id,
lpn_prefix,
lpn_suffix,
ucc_128_suffix_flag,
total_lpn_length,
lpn_starting_number,
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
)
VALUES (
p_client_id,
p_client_code,
p_client_number,
p_trading_partner_site_id,
p_receipt_asn_exists_code,
p_rma_receipt_routing_id,
p_group_by_customer_flag,
p_group_by_freight_terms_flag,
p_group_by_fob_flag,
p_group_by_ship_method_flag,
p_otm_enabled,
p_ship_confirm_rule_id,
p_autocreate_del_orders_flag,
p_delivery_report_set_id,
p_lpn_prefix,
p_lpn_suffix,
p_ucc_128_suffix_flag,
p_total_lpn_length,
p_lpn_starting_number,
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_last_update_date,
p_last_updated_by,
p_creation_date,
p_created_by,
p_last_update_login);
END Insert_Row;
/* Procedure to Update record for MTL_CLIENT_PARAMETERS table
*/
PROCEDURE update_row (X_Rowid VARCHAR2,
p_client_id NUMBER,
p_client_code VARCHAR2,
p_client_number VARCHAR2,
p_trading_partner_site_id NUMBER,
p_receipt_asn_exists_code VARCHAR2,
p_rma_receipt_routing_id NUMBER,
p_group_by_customer_flag VARCHAR2,
p_group_by_freight_terms_flag VARCHAR2,
p_group_by_fob_flag VARCHAR2,
p_group_by_ship_method_flag VARCHAR2,
p_otm_enabled VARCHAR2,
p_ship_confirm_rule_id NUMBER,
p_autocreate_del_orders_flag VARCHAR2,
p_delivery_report_set_id NUMBER,
p_lpn_prefix VARCHAR2,
p_lpn_suffix VARCHAR2,
p_ucc_128_suffix_flag VARCHAR2,
p_total_lpn_length NUMBER,
p_lpn_starting_number 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_last_update_date DATE,
p_last_updated_by NUMBER,
p_creation_date DATE,
p_created_by NUMBER,
p_last_update_login NUMBER
) IS
BEGIN
UPDATE mtl_client_parameters
SET
trading_partner_site_id = p_trading_partner_site_id,
receipt_asn_exists_code = p_receipt_asn_exists_code,
rma_receipt_routing_id = p_rma_receipt_routing_id,
group_by_customer_flag = p_group_by_customer_flag,
group_by_freight_terms_flag = p_group_by_freight_terms_flag,
group_by_fob_flag = p_group_by_fob_flag,
group_by_ship_method_flag = p_group_by_ship_method_flag,
otm_enabled = p_otm_enabled,
ship_confirm_rule_id = p_ship_confirm_rule_id,
autocreate_del_orders_flag = p_autocreate_del_orders_flag,
delivery_report_set_id = p_delivery_report_set_id,
lpn_prefix = p_lpn_prefix,
lpn_suffix = p_lpn_suffix,
ucc_128_suffix_flag = p_ucc_128_suffix_flag,
total_lpn_length = p_total_lpn_length,
lpn_starting_number = p_lpn_starting_number,
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,
last_update_date = p_last_update_date,
last_updated_by = p_last_updated_by,
last_update_login = p_last_update_login
WHERE Rowid = X_Rowid;
END update_Row;