APPS.FPA_PORTFOLIO_PROJECT_SETS_PVT SQL Statements

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

Line: 11

            SELECT  init_project_set_id, appr_project_set_id
            FROM    FPA_AW_PROJECT_SETS_V
            WHERE   portfolio = p_portfolio_id;

Line: 32

	  select hzp.party_id
	    from pa_project_parties ppp, pa_project_role_types pprt, hz_parties hzp, per_people_f per, fpa_aw_pc_info_v pc
	    where ppp.object_type = 'PJP_PORTFOLIO'
	    and ppp.project_role_id = pprt.project_role_id
	    and pprt.project_role_type = 'PORTFOLIO_OWNER'
	    and ppp.resource_source_id = per.person_id
	    and per.party_id = hzp.party_id
	    and ppp.object_id = pc.portfolio
	    and pc.planning_cycle = p_pc_id;

Line: 46

    PROCEDURE delete_project_set_lines
     ( p_api_version    IN      NUMBER,
       p_project_set_id IN      fpa_aw_project_sets_v.init_project_set_id%TYPE,
       x_return_status  OUT     NOCOPY VARCHAR2,
       x_msg_data       OUT     NOCOPY VARCHAR2,
       x_msg_count      OUT     NOCOPY NUMBER)
    IS

        l_project_id_tbl    SYSTEM.pa_num_tbl_type;

Line: 64

                'FPA.SQL.fpa_portfolio_project_sets_pvt.delete_project_set_lines.begin',
                'Entering FPA_PORTF_PROJECT_SETS.delete_project_set_lines'
            );

Line: 71

            SELECT project_id BULK COLLECT
            INTO   l_project_id_tbl
            FROM   pa_project_set_lines
            WHERE  project_set_id = p_project_set_id;

Line: 79

            PA_PROJECT_SETS_PUB.delete_project_set_line
            (
             p_project_set_id   => p_project_set_id
             ,p_project_id      => l_project_id_tbl(i)
             ,x_return_status   => x_return_status
             ,x_msg_count       => x_msg_count
             ,x_msg_data        => x_msg_data
            );

Line: 99

 	   	  dbms_aw.execute('UPDATE');

Line: 107

                  'FPA.SQL.fpa_portfolio_project_sets.delete_project_set_lines.end',
                  'Exiting fpa_portfolio_project_sets.delete_project_set_lines'
            );

Line: 122

			'FPA.SQL.fpa_portfolio_project_sets.delete_project_set_lines',
			SQLERRM
		);

Line: 134

    END delete_project_set_lines;

Line: 177

        SELECT      portfolio
        INTO        l_portfolio_id
        FROM        fpa_aw_pc_info_v
        WHERE       planning_cycle = p_pc_id;

Line: 183

		SELECT name
		INTO   l_portfolio_name
		FROM   fpa_portfs_vl
		WHERE  portfolio = l_portfolio_id;

Line: 189

		SELECT name
		INTO   l_pc_name
		FROM   fpa_pcs_vl
		WHERE  planning_cycle = p_pc_id;

Line: 205

            delete_project_set_lines
             ( p_api_version    => p_api_version,
               p_project_set_id => l_project_sets.init_project_set_id,
               x_return_status  => x_return_status,
               x_msg_count      => x_msg_count,
               x_msg_data       => x_msg_data);

Line: 212

            delete_project_set_lines
             ( p_api_version    => p_api_version,
               p_project_set_id => l_project_sets.appr_project_set_id,
               x_return_status  => x_return_status,
               x_msg_count      => x_msg_count,
               x_msg_data       => x_msg_data);

Line: 345

           dbms_aw.execute('UPDATE');

Line: 398

         select sc.scenario, sc.planning_cycle, is_initial_scenario,
		 		sc.approved_flag, pc.portfolio, pset.INIT_PROJECT_SET_ID, pset.APPR_PROJECT_SET_ID
		  from fpa_aw_sce_info_v sc, fpa_aw_pc_info_v pc, fpa_aw_project_sets_v pset
          where sc.planning_cycle = pc.planning_cycle
		  and pc.portfolio = pset.portfolio
		  and sc.scenario = p_scen_id;

Line: 455

                SELECT  project BULK COLLECT
                INTO    l_proj_list
                FROM    fpa_aw_proj_info_v
                WHERE   scenario = p_scen_id and
                recommended_funding_status = 'FUNDING_APPROVED';

Line: 466

                SELECT  project BULK COLLECT
                INTO    l_proj_list
                FROM    fpa_aw_proj_info_v
                WHERE   scenario = p_scen_id;

Line: 514

          	dbms_aw.execute('UPDATE');