The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE Insert_Row
( p_rowid IN OUT NOCOPY VARCHAR2
, p_legal_entity_id NUMBER
, p_zone_code VARCHAR2
, p_usage_type VARCHAR2
, p_stat_type VARCHAR2
, p_period_set_name VARCHAR2
, p_period_type VARCHAR2
, p_start_period_name VARCHAR2
, p_end_period_name VARCHAR2
, p_weight_uom_code VARCHAR2
, p_entity_branch_reference VARCHAR2
, p_conversion_type VARCHAR2
, p_conversion_option VARCHAR2
, p_category_set_id NUMBER
, p_tax_office_code VARCHAR2
, p_tax_office_name VARCHAR2
, p_tax_office_location_id NUMBER
, p_attribute_rule_set_code VARCHAR2
, p_alt_uom_rule_set_code VARCHAR2
, p_triangulation_mode VARCHAR2
, p_reference_period_rule VARCHAR2
, p_pending_invoice_days NUMBER
, p_prior_invoice_days NUMBER
, p_returns_processing VARCHAR2
, p_kit_method VARCHAR2
, p_weight_precision NUMBER
, p_reporting_rounding VARCHAR2
, p_include_establishments VARCHAR2
, p_last_update_date DATE
, p_last_updated_by NUMBER
, p_last_update_login NUMBER
, p_created_by NUMBER
, p_creation_date DATE
)
IS
l_period_type VARCHAR2(200);
SELECT
rowid
FROM
MTL_STAT_TYPE_USAGES
WHERE Legal_Entity_ID = p_legal_entity_id
AND Zone_Code = p_zone_code
AND Usage_Type = p_usage_type
AND Stat_Type = p_stat_type;
INSERT INTO MTL_STAT_TYPE_USAGES(
Legal_Entity_ID
, Zone_Code
, Usage_Type
, Stat_Type
, Start_Period_Name
, Period_Type
, End_Period_Name
, Period_Set_Name
, Weight_UOM_Code
, Entity_Branch_Reference
, Conversion_Type
, Conversion_Option
, Category_Set_ID
, Tax_Office_Code
, Tax_Office_Name
, Tax_Office_Location_ID
, Attribute_Rule_Set_Code
, Alt_Uom_Rule_Set_Code
, Triangulation_Mode
, reference_period_rule
, pending_invoice_days
, prior_invoice_days
, returns_processing
, kit_method
, weight_precision
, reporting_rounding
, include_establishments
, Last_Update_Date
, Last_Updated_By
, Last_Update_Login
, Created_By
, Creation_Date
)
VALUES(
p_legal_entity_id
, p_zone_code
, p_usage_type
, p_stat_type
, p_start_period_name
, l_period_type
, p_end_period_name
, p_period_set_name
, p_weight_uom_code
, p_entity_branch_reference
, p_conversion_type
, p_conversion_option
, p_category_set_id
, p_tax_office_code
, p_tax_office_name
, p_tax_office_location_id
, p_attribute_rule_set_code
, p_alt_uom_rule_set_code
, p_triangulation_mode
, p_reference_period_rule
, p_pending_invoice_days
, p_prior_invoice_days
, p_returns_processing
, p_kit_method
, p_weight_precision
, p_reporting_rounding
, p_include_establishments
, p_last_update_date
, p_last_updated_by
, p_last_update_login
, p_created_by
, p_creation_date
);
END Insert_Row;
SELECT *
FROM MTL_STAT_TYPE_USAGES
WHERE ROWID = p_rowid
FOR UPDATE OF Legal_Entity_ID NOWAIT;
FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
PROCEDURE Update_Row
( p_rowid IN OUT NOCOPY VARCHAR2
, p_legal_entity_id NUMBER
, p_zone_code VARCHAR2
, p_usage_type VARCHAR2
, p_stat_type VARCHAR2
, p_period_set_name VARCHAR2
, p_period_type VARCHAR2
, p_start_period_name VARCHAR2
, p_end_period_name VARCHAR2
, p_weight_uom_code VARCHAR2
, p_entity_branch_reference VARCHAR2
, p_conversion_type VARCHAR2
, p_conversion_option VARCHAR2
, p_category_set_id NUMBER
, p_tax_office_code VARCHAR2
, p_tax_office_name VARCHAR2
, p_tax_office_location_id NUMBER
, p_attribute_rule_set_code VARCHAR2
, p_alt_uom_rule_set_code VARCHAR2
, p_triangulation_mode VARCHAR2
, p_reference_period_rule VARCHAR2
, p_pending_invoice_days NUMBER
, p_prior_invoice_days NUMBER
, p_returns_processing VARCHAR2
, p_kit_method VARCHAR2
, p_weight_precision NUMBER
, p_reporting_rounding VARCHAR2
, p_include_establishments VARCHAR2
, p_last_update_date DATE
, p_last_updated_by NUMBER
, p_last_update_login NUMBER
, p_created_by NUMBER
, p_creation_date DATE
)
IS
l_period_type VARCHAR2(200);
UPDATE MTL_STAT_TYPE_USAGES
SET
Legal_Entity_ID = p_legal_entity_id
, zone_code = p_zone_code
, usage_type = p_usage_type
, stat_type = p_stat_type
, start_period_name = p_start_period_name
, end_period_name = p_end_period_name
, period_set_name = p_period_set_name
, period_type = l_period_type
, weight_uom_code = p_weight_uom_code
, entity_branch_reference = p_entity_branch_reference
, conversion_type = p_conversion_type
, conversion_option = p_conversion_option
, category_set_id = p_category_set_id
, tax_office_code = p_tax_office_code
, tax_office_name = p_tax_office_name
, tax_office_location_id = p_tax_office_location_id
, attribute_rule_set_code = p_attribute_rule_set_code
, alt_uom_rule_set_code = p_alt_uom_rule_set_code
, triangulation_mode = p_triangulation_mode
, reference_period_rule = p_reference_period_rule
, pending_invoice_days = p_pending_invoice_days
, prior_invoice_days = p_prior_invoice_days
, returns_processing = p_returns_processing
, kit_method = p_kit_method
, weight_precision = p_weight_precision
, reporting_rounding = p_reporting_rounding
, include_establishments = p_include_establishments
, last_update_date = p_last_update_date
, last_updated_by = p_last_updated_by
, last_update_login = p_last_update_login
, created_by = p_created_by
, creation_date = p_creation_date
WHERE ROWID = p_rowid;
END Update_Row;
PROCEDURE Delete_Row
( p_rowid IN OUT NOCOPY VARCHAR2
)
IS
BEGIN
DELETE FROM MTL_STAT_TYPE_USAGES
WHERE ROWID = p_rowid;
END Delete_Row;