DBA Data[Home] [Help]

APPS.FPA_PORTFOLIO_PVT dependencies on FPA_OBJECTS_TL

Line 96: INSERT INTO FPA_OBJECTS_TL ( object,id, name,

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: )

Line 207: --Delete portfolio from FPA_OBJECTS_TL

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:

Line 208: DELETE FROM FPA_OBJECTS_TL

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

Line 276: UPDATE FPA_OBJECTS_TL objtl

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