92: --dbms_output.put_line('before insert');
93:
94:
95: -- Insert the record on the pa_objects_tl table
96: INSERT INTO FPA_OBJECTS_TL ( object,id, name,
97: description, language, source_lang,
98: created_by, creation_date, last_updated_by,
99: last_update_date, last_update_login
100: )
203: );
204: END IF;
205:
206:
207: --Delete portfolio from FPA_OBJECTS_TL
208: DELETE FROM FPA_OBJECTS_TL
209: WHERE object = 'PORTFOLIO'
210: AND id = p_portfolio_id;
211:
204: END IF;
205:
206:
207: --Delete portfolio from FPA_OBJECTS_TL
208: DELETE FROM FPA_OBJECTS_TL
209: WHERE object = 'PORTFOLIO'
210: AND id = p_portfolio_id;
211:
212: -- CHANGES PENDING
272: 'fpa.sql.fpa_portfolio_pvt.update_portfolio_Descr.begin',
273: 'Entering fpa_portfolo_pvt.update_portfolio_descr'
274: );
275: END IF;
276: UPDATE FPA_OBJECTS_TL objtl
277: SET objtl.NAME =p_portfolio_rec.portfolio_name,
278: objtl.DESCRIPTION =p_portfolio_rec.portfolio_desc,
279: objtl.SOURCE_LANG = userenv('LANG')
280: where objtl.id = p_portfolio_rec.portfolio_id