The following lines contain the word 'select', 'insert', 'update' or 'delete':
| Procedure insert_row |
| |
+======================================================================*/
PROCEDURE insert_row
(x_rowid IN OUT NOCOPY VARCHAR2
,x_application_id IN NUMBER
,x_amb_context_code IN VARCHAR2
,x_product_rule_type_code IN VARCHAR2
,x_product_rule_code IN VARCHAR2
,x_event_class_code IN VARCHAR2
,x_event_type_code IN VARCHAR2
,x_accounting_attribute_code IN VARCHAR2
,x_source_application_id IN NUMBER
,x_source_type_code IN VARCHAR2
,x_source_code IN VARCHAR2
,x_event_class_default_flag IN VARCHAR2
,x_creation_date IN DATE
,x_created_by IN NUMBER
,x_last_update_date IN DATE
,x_last_updated_by IN NUMBER
,x_last_update_login IN NUMBER)
IS
CURSOR c IS
SELECT rowid
FROM xla_aad_hdr_acct_attrs
WHERE application_id = x_application_id
AND amb_context_code = x_amb_context_code
AND product_rule_type_code = x_product_rule_type_code
AND product_rule_code = x_product_rule_code
AND event_class_code = x_event_class_code
AND event_type_code = x_event_type_code
AND accounting_attribute_code = x_accounting_attribute_code
;
xla_utility_pkg.trace('> .insert_row' ,20);
INSERT INTO xla_aad_hdr_acct_attrs
(creation_date
,created_by
,application_id
,amb_context_code
,product_rule_type_code
,product_rule_code
,event_class_code
,event_type_code
,accounting_attribute_code
,source_application_id
,source_type_code
,source_code
,last_update_date
,last_updated_by
,last_update_login)
VALUES
(x_creation_date
,x_created_by
,x_application_id
,x_amb_context_code
,x_product_rule_type_code
,x_product_rule_code
,x_event_class_code
,x_event_type_code
,x_accounting_attribute_code
,x_source_application_id
,x_source_type_code
,x_source_code
,x_last_update_date
,x_last_updated_by
,x_last_update_login)
;
xla_utility_pkg.trace('< .insert_row' ,20);
END insert_row;
SELECT application_id
,amb_context_code
,product_rule_type_code
,product_rule_code
,event_class_code
,event_type_code
,accounting_attribute_code
,source_application_id
,source_type_code
,source_code
,event_class_default_flag
FROM xla_aad_hdr_acct_attrs
WHERE application_id = x_application_id
AND amb_context_code = x_amb_context_code
AND product_rule_type_code = x_product_rule_type_code
AND product_rule_code = x_product_rule_code
AND event_class_code = x_event_class_code
AND event_type_code = x_event_type_code
AND accounting_attribute_code = x_accounting_attribute_code
FOR UPDATE OF application_id NOWAIT;
fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
| Procedure update_row |
| |
+======================================================================*/
PROCEDURE update_row
(x_rowid IN OUT NOCOPY VARCHAR2
,x_application_id IN NUMBER
,x_amb_context_code IN VARCHAR2
,x_product_rule_type_code IN VARCHAR2
,x_product_rule_code IN VARCHAR2
,x_event_class_code IN VARCHAR2
,x_event_type_code IN VARCHAR2
,x_accounting_attribute_code IN VARCHAR2
,x_source_application_id IN NUMBER
,x_source_type_code IN VARCHAR2
,x_source_code IN VARCHAR2
,x_event_class_default_flag IN VARCHAR2
,x_last_update_date IN DATE
,x_last_updated_by IN NUMBER
,x_last_update_login IN NUMBER)
IS
BEGIN
xla_utility_pkg.trace('> .update_row' ,20);
UPDATE xla_aad_hdr_acct_attrs
SET
last_update_date = x_last_update_date
,source_application_id = x_source_application_id
,source_type_code = x_source_type_code
,source_code = x_source_code
,event_class_default_flag = x_event_class_default_flag
,last_updated_by = x_last_updated_by
,last_update_login = x_last_update_login
WHERE application_id = X_application_id
AND amb_context_code = x_amb_context_code
AND product_rule_type_code = x_product_rule_type_code
AND product_rule_code = x_product_rule_code
AND event_class_code = x_event_class_code
AND event_type_code = x_event_type_code
AND accounting_attribute_code = x_accounting_attribute_code;
xla_utility_pkg.trace('< .update_row' ,20);
END update_row;
| Procedure delete_row |
| |
+======================================================================*/
PROCEDURE delete_row
(x_application_id IN NUMBER
,x_amb_context_code IN VARCHAR2
,x_product_rule_type_code IN VARCHAR2
,x_product_rule_code IN VARCHAR2
,x_event_class_code IN VARCHAR2
,x_event_type_code IN VARCHAR2
,x_accounting_attribute_code IN VARCHAR2)
IS
BEGIN
xla_utility_pkg.trace('> .delete_row' ,20);
DELETE FROM xla_aad_hdr_acct_attrs
WHERE application_id = x_application_id
AND amb_context_code = x_amb_context_code
AND product_rule_type_code = x_product_rule_type_code
AND product_rule_code = x_product_rule_code
AND event_class_code = x_event_class_code
AND event_type_code = x_event_type_code
AND accounting_attribute_code = x_accounting_attribute_code;
xla_utility_pkg.trace('< .delete_row' ,20);
END delete_row;