[Home] [Help]
836: --
837: begin
838: select rowid
839: into l_rowid
840: from pay_balance_dimensions_tl
841: where balance_dimension_id = l_balance_dimension_id
842: and language = l_rec.language_code
843: for update nowait;
844: --
841: where balance_dimension_id = l_balance_dimension_id
842: and language = l_rec.language_code
843: for update nowait;
844: --
845: update pay_balance_dimensions_tl
846: set dimension_name = l_database_item_suffix,
847: database_item_suffix = l_database_item_suffix,
848: description = l_description
849: where rowid = l_rowid;
848: description = l_description
849: where rowid = l_rowid;
850: exception
851: when no_data_found then
852: insert into pay_balance_dimensions_tl(
853: BALANCE_DIMENSION_ID,
854: LANGUAGE,
855: SOURCE_LANG,
856: DIMENSION_NAME,