eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FPA_INVESTMENT_CRITERIA_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 63


		DBMS_AW.Execute('UPDATE');

Line: 107


    SELECT 	fpa_strategic_obj_s.nextval AS l_strobj_id
    FROM dual;

Line: 119


    SELECT language_code
    FROM   fnd_languages
    WHERE  installed_flag IN ('I','B');

Line: 159


                 'Inserting into FPA_OBJECTS_TL'
                );

Line: 165


	-- Seed data insertion should happen using ldt files. Do not execute this insert in seed data mode
	if (upper(p_seeding) <> 'Y') then
     OPEN l_language_csr;

Line: 172


                   INSERT INTO FPA_OBJECTS_TL( object
                          ,id
                          ,name
                          ,description
                          ,LANGUAGE
                          ,SOURCE_LANG
                          ,created_by
                          ,creation_date
                          ,last_updated_by
                          ,last_update_date
                          ,last_update_login)
                    VALUES( 'INVESTMENT_CRITERIA'
                          ,x_strategic_obj_id
                          ,p_investment_rec_type.strategic_obj_name
                          ,p_investment_rec_type.strategic_obj_desc
                          ,l_language
                          ,USERENV('LANG')
                          ,0
                          ,sysdate()
                          ,0
                          ,sysdate()
                          ,0);

Line: 228


PROCEDURE delete_strategicobj_aw
(
  	p_api_version                 IN              NUMBER,
	p_investment_rec_type         IN              fpa_investment_criteria_pvt.investment_rec_type,
	x_return_status               OUT NOCOPY      VARCHAR2,
	x_msg_count                   OUT NOCOPY      NUMBER,
	x_msg_data                    OUT NOCOPY      VARCHAR2
)
IS

    l_api_version            CONSTANT NUMBER    := 1.0;

Line: 251


  	-- Delete the Strategic Objective from the AW space.
	dbms_aw.Execute('maintain strategic_obj_d delete ' || p_Investment_rec_type.strategic_obj_shortname);

Line: 255


  delete from FPA_OBJECTS_TL
   where object = 'INVESTMENT_CRITERIA'
     and id = p_Investment_rec_type.strategic_obj_shortname;

Line: 271


END delete_strategicobj_aw;

Line: 279


PROCEDURE update_strategicobj
(
  	p_commit                      IN              VARCHAR2 := FND_API.G_FALSE,
	p_investment_rec_type         IN              FPA_Investment_Criteria_PVT.Investment_rec_type,
	x_return_status               OUT NOCOPY      VARCHAR2,
	x_msg_count                   OUT NOCOPY      NUMBER,
	x_msg_data                    OUT NOCOPY      VARCHAR2
)
IS

BEGIN

  	IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
		fnd_log.string
		( FND_LOG.LEVEL_PROCEDURE,
		 'fpa.sql.fpa_investment_criteria_pvt.update_strategicobj.begin',
		 'Entering fpa_investment_criteria_pvt.update_strategicobj');

Line: 301


                 'fpa.sql.fpa_investment_criteria_pvt.update_strategicobj.begin',
                 'Updating FPA_OBJECTS_TL for the investment criteria');

Line: 305


  update FPA_OBJECTS_TL
     set  name = p_investment_rec_type.strategic_obj_name
         ,description = p_investment_rec_type.strategic_obj_desc
         ,SOURCE_LANG     = userenv('LANG')
         ,last_update_date = sysdate
   where id = p_investment_rec_type.strategic_obj_shortname
     and object = 'INVESTMENT_CRITERIA'
     and userenv('LANG') IN (LANGUAGE, SOURCE_LANG);

Line: 317


                 'fpa.sql.fpa_investment_criteria_pvt.update_strategicobj.end',
                 'Exiting fpa_investment_criteria_pvt.update_strategicobj');

Line: 334


end Update_StrategicObj;

Line: 343


PROCEDURE update_strategicobj_status_aw
(
        p_commit                      IN              VARCHAR2 := FND_API.G_FALSE,
        p_investment_rec_type         IN              FPA_Investment_Criteria_PVT.Investment_rec_type,
        x_return_status               OUT NOCOPY      VARCHAR2,
        x_msg_count                   OUT NOCOPY      NUMBER,
        x_msg_data                    OUT NOCOPY      VARCHAR2
)
IS

BEGIN

        IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
                fnd_log.string
                (
                        FND_LOG.LEVEL_PROCEDURE,
                        'fpa.sql.fpa_resourcetype_pvt.create_resourcetype.begin',
                        'Entering fpa_resourcetype_pvt.create_resourcetype'
                );

Line: 381


end update_strategicobj_status_aw;

Line: 386


PROCEDURE update_strategicobj_level_aw
(
        p_commit                      IN              VARCHAR2 := FND_API.G_FALSE,
        p_investment_rec_type         IN              FPA_Investment_Criteria_PVT.Investment_rec_type,
        x_return_status               OUT NOCOPY      VARCHAR2,
        x_msg_count                   OUT NOCOPY      NUMBER,
        x_msg_data                    OUT NOCOPY      VARCHAR2
) is

begin

        IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
                fnd_log.string
                (
                        FND_LOG.LEVEL_PROCEDURE,
                        'fpa.sql.FPA_Investment_Criteria_PVT.update_strategicobj_level_aw.begin',
                        'Entering FPA_Investment_Criteria_PVT.update_strategicobj_level_aw'
                );

Line: 423


end update_strategicobj_level_aw;

Line: 430


PROCEDURE update_strategicobj_weight_aw
(
	  p_Investment_rec_type         IN              FPA_Investment_Criteria_PVT.Investment_rec_type,
	  x_return_status               OUT NOCOPY      varchar2,
	  x_msg_count                   OUT NOCOPY      number,
	  x_msg_data                    OUT NOCOPY      varchar2
)
IS

	l_api_version                   CONSTANT NUMBER := 1.0;

Line: 514


END update_strategicobj_weight_aw;

Line: 518


PROCEDURE Update_ProjectTypeObjScore_AW
(
  	p_commit                      	IN              VARCHAR2 := FND_API.G_FALSE,
	p_Investment_rec_type         	IN              FPA_Investment_Criteria_PVT.Investment_rec_type,
	x_return_status               	OUT NOCOPY      VARCHAR2,
	x_msg_count                   	OUT NOCOPY      NUMBER,
	x_msg_data                    	OUT NOCOPY      VARCHAR2
)
IS

BEGIN

  	-- Attach the AW space read write.

	-- limit the project dimension to the current project
	DBMS_AW.Execute('lmt project_type_d to '''
		|| p_Investment_rec_type.project_type_shortname || '''');

Line: 552


		DBMS_AW.Execute('update');

Line: 568


END update_projecttypeobjscore_aw;

Line: 575


PROCEDURE update_strategicobj_wscore_aw
(
  	p_api_version			IN		NUMBER,
	p_commit                      	IN              VARCHAR2 := FND_API.G_FALSE,
	p_Investment_rec_type         	IN              FPA_Investment_Criteria_PVT.Investment_rec_type,
	x_return_status               	OUT NOCOPY      VARCHAR2,
	x_msg_count                   	OUT NOCOPY      NUMBER,
	x_msg_data                    	OUT NOCOPY      VARCHAR2
)
IS

	l_api_version			CONSTANT	number := 1.0;

Line: 602


		DBMS_AW.Execute('update');

Line: 618


END update_strategicobj_wscore_aw;

Line: 624


PROCEDURE Update_ProjectTypeObjWScore_AW
(
  	p_api_version                 	IN              NUMBER,
	p_commit                      	IN              VARCHAR2 := FND_API.G_FALSE,
	p_investment_rec_type         	IN              FPA_Investment_Criteria_PVT.Investment_rec_type,
	x_return_status               	OUT NOCOPY      VARCHAR2,
	x_msg_count                   	OUT NOCOPY      NUMBER,
	x_msg_data                    	OUT NOCOPY      VARCHAR2
)
IS

	l_api_version                   CONSTANT NUMBER := 1.0;

Line: 667


		DBMS_AW.Execute('update');

Line: 683


END update_projecttypeobjwscore_aw;

Line: 691


PROCEDURE Update_StrategicObj_AScore_AW
(
  	p_api_version			IN		number,
	p_commit                      	IN              varchar2 := FND_API.G_FALSE,
	p_Investment_rec_type         	IN              FPA_Investment_Criteria_PVT.Investment_rec_type,
	x_return_status               	OUT NOCOPY      varchar2,
	x_msg_count                   	OUT NOCOPY      number,
	x_msg_data                    	OUT NOCOPY      varchar2
)
IS

	l_api_version			CONSTANT	number := 1.0;

Line: 719


	select tab_id
	into l_obj_group_tab_id
	from fpa_inv_criteria_vl
	where shortname = 'FPASTRALIGN';

Line: 725


	l_sql := 'select tab_id ' ||
           '  from fpa_inv_criteria_vl ' ||
           ' where parent_tab_id = ' || l_obj_group_tab_id;

Line: 746


		select distinct count(a.tab_id), b.shortname
		into l_obj_count, l_obj_member_name
		from fpa_inv_criteria_vl a, fpa_inv_criteria_vl b
		where a.parent_tab_id = l_temp_tab_id
		and b.tab_id = l_temp_tab_id
		group by b.shortname;

Line: 773


	DBMS_AW.Execute('update');

Line: 788


END update_strategicobj_ascore_aw;

Line: 795


procedure Update_ProjectTypeObjAScore_AW(
  p_commit                      IN              varchar2 := FND_API.G_FALSE
 ,p_Investment_rec_type         IN              FPA_Investment_Criteria_PVT.Investment_rec_type
 ,x_return_status               OUT NOCOPY      varchar2
 ,x_msg_count                   OUT NOCOPY      number
 ,x_msg_data                    OUT NOCOPY      varchar2
) is

begin

  -- Attach the AW space read write
  DBMS_AW.Execute('aw attach ' || p_Investment_rec_type.AW_space || ' rw first');

Line: 858


end Update_ProjectTypeObjAScore_AW;

Line: 915


		DBMS_AW.Execute('update');

Line: 999


PROCEDURE update_strategicobj_status_aw
(
    p_commit                      IN              VARCHAR2 := FND_API.G_FALSE,
    p_strategic_obj_shortname     IN              NUMBER,
    p_strategic_obj_desc          IN              VARCHAR2,
    p_strategic_obj_name          IN              VARCHAR2,
    p_strategic_obj_level         IN              VARCHAR2,
    p_strategic_obj_parent        IN              VARCHAR2,
    p_strategic_obj_status        IN              VARCHAR2,
    x_return_status               OUT NOCOPY      VARCHAR2,
    x_msg_count                   OUT NOCOPY      NUMBER,
    x_msg_data                    OUT NOCOPY      VARCHAR2
)
IS
  l_Investment_rec_type  FPA_Investment_Criteria_PVT.Investment_rec_type;

Line: 1021


  update_strategicobj_status_aw( p_commit              => p_commit,
                                 p_investment_rec_type => l_Investment_rec_type,
                                 x_return_status       => x_return_status,
                                 x_msg_count           => x_msg_count,
                                 x_msg_data            => x_msg_data);

Line: 1026


END update_strategicobj_status_aw;

Line: 1043


PROCEDURE update_strategicobj_level_aw
(
        p_commit                      IN              VARCHAR2 := FND_API.G_FALSE,
        p_strategic_obj_shortname     IN              NUMBER,
        p_strategic_obj_desc          IN              VARCHAR2,
        p_strategic_obj_name          IN              VARCHAR2,
        p_strategic_obj_level         IN              VARCHAR2,
        p_strategic_obj_parent        IN              VARCHAR2,
        x_return_status               OUT NOCOPY      VARCHAR2,
        x_msg_count                   OUT NOCOPY      NUMBER,
        x_msg_data                    OUT NOCOPY      VARCHAR2
)
IS
  l_Investment_rec_type  FPA_Investment_Criteria_PVT.Investment_rec_type;

Line: 1063


    update_strategicobj_level_aw ( p_commit              => p_commit,
                                   p_investment_rec_type => l_Investment_rec_type,
                                   x_return_status       => x_return_status,
                                   x_msg_count           => x_msg_count,
                                   x_msg_data            => x_msg_data);

Line: 1068


END update_strategicobj_level_aw;