APPS.FPA_INVESTMENT_CRITERIA_PVT dependencies on FPA_OBJECTS_TL

Line 159: 'Inserting into FPA_OBJECTS_TL'

155: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
156: fnd_log.string
157: (FND_LOG.LEVEL_PROCEDURE,
158: 'fpa.sql.fpa_investment_criteria_pvt.create_strategicobj_aw',
159: 'Inserting into FPA_OBJECTS_TL'
160: );
161: END IF;
162:
163: -- Open the cursor and insert p_strategic_obj_name, pc_desc for each language code

Line 164: -- insert into fpa_objects_tl only when user creates str. obj from the UI.

160: );
161: END IF;
162:
163: -- Open the cursor and insert p_strategic_obj_name, pc_desc for each language code
164: -- insert into fpa_objects_tl only when user creates str. obj from the UI.
165: -- Seed data insertion should happen using ldt files. Do not execute this insert in seed data mode
166: if (upper(p_seeding) <> 'Y') then
167: OPEN l_language_csr;
168: LOOP

Line 172: INSERT INTO FPA_OBJECTS_TL( object

168: LOOP
169: FETCH l_language_csr INTO l_language;
170: EXIT WHEN l_language_csr%NOTFOUND;
171:
172: INSERT INTO FPA_OBJECTS_TL( object
173: ,id
174: ,name
175: ,description
176: ,LANGUAGE

Line 254: --Delete from FPA_OBJECTS_TL

250:
251: -- Delete the Strategic Objective from the AW space.
252: dbms_aw.Execute('maintain strategic_obj_d delete ' || p_Investment_rec_type.strategic_obj_shortname);
253:
254: --Delete from FPA_OBJECTS_TL
255: delete from FPA_OBJECTS_TL
256: where object = 'INVESTMENT_CRITERIA'
257: and id = p_Investment_rec_type.strategic_obj_shortname;
258:

Line 255: delete from FPA_OBJECTS_TL

251: -- Delete the Strategic Objective from the AW space.
252: dbms_aw.Execute('maintain strategic_obj_d delete ' || p_Investment_rec_type.strategic_obj_shortname);
253:
254: --Delete from FPA_OBJECTS_TL
255: delete from FPA_OBJECTS_TL
256: where object = 'INVESTMENT_CRITERIA'
257: and id = p_Investment_rec_type.strategic_obj_shortname;
258:
259:

Line 302: 'Updating FPA_OBJECTS_TL for the investment criteria');

298: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
299: fnd_log.string
300: (FND_LOG.LEVEL_PROCEDURE,
301: 'fpa.sql.fpa_investment_criteria_pvt.update_strategicobj.begin',
302: 'Updating FPA_OBJECTS_TL for the investment criteria');
303: END IF;
304:
305: update FPA_OBJECTS_TL
306: set name = p_investment_rec_type.strategic_obj_name

Line 305: update FPA_OBJECTS_TL

301: 'fpa.sql.fpa_investment_criteria_pvt.update_strategicobj.begin',
302: 'Updating FPA_OBJECTS_TL for the investment criteria');
303: END IF;
304:
305: update FPA_OBJECTS_TL
306: set name = p_investment_rec_type.strategic_obj_name
307: ,description = p_investment_rec_type.strategic_obj_desc
308: ,SOURCE_LANG = userenv('LANG')
309: ,last_update_date = sysdate