APPS.FPA_PLANNINGCYCLE_PVT SQL Statements

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

Line: 28

	SELECT 	fpa_planning_cycle_s.nextval AS l_pc_id
	FROM dual;

Line: 40

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

Line: 78

                   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( 'PLANNING_CYCLE'
                          ,l_pc_s_r.l_pc_id
                          ,p_pc_all_obj.pc_desc_fields.name
                          ,p_pc_all_obj.pc_desc_fields.description
                          ,l_language
                          ,USERENV('LANG')
                          ,fnd_global.user_id
                          ,sysdate()
                          ,fnd_global.user_id
                          ,sysdate()
                          ,0);

Line: 161

PROCEDURE Update_Pc_Invest_Mix
     ( p_api_version        IN NUMBER,
       p_inv_matrix         IN fpa_pc_inv_matrix_tbl,
       x_return_status      OUT NOCOPY VARCHAR2,
       x_msg_data           OUT NOCOPY VARCHAR2,
       x_msg_count          OUT NOCOPY NUMBER )
IS
l_pc_catg number;

Line: 175

			'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Invest_Mix.begin',
			'Entering FPA_PlanningCycle_Pvt.Update_Pc_Invest_Mix'
		);

Line: 188

      SELECT distinct(pc_category) INTO l_pc_catg
      FROM fpa_aw_pc_inv_matrices_v
      WHERE planning_cycle =  p_inv_matrix(1).planning_cycle;

Line: 205

	-- Update the InvestMix
	-- Limit PCID
	  dbms_aw.execute('LMT planning_cycle_d TO ' || p_inv_matrix(1).planning_cycle );

Line: 226

			'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Invest_Mix.end',
			'Exiting FPA_PlanningCycle_Pvt.Update_Pc_Invest_Mix'
		);

Line: 242

			'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Invest_Mix',
			SQLERRM
		);

Line: 254

END Update_Pc_Invest_Mix;

Line: 256

PROCEDURE Update_Pc_Fin_Targets
     ( p_api_version        IN NUMBER,
       p_fin_targets_tbl    IN fpa_pc_fin_targets_tbl,
       x_return_status      OUT NOCOPY VARCHAR2,
       x_msg_data           OUT NOCOPY VARCHAR2,
       x_msg_count          OUT NOCOPY NUMBER )
IS
l_pc_catg number;

Line: 276

			'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Fin_Targets.begin',
			'Entering FPA_PlanningCycle_Pvt.Update_Pc_Fin_Targets'
		);

Line: 289

  SELECT b.PC_DISPLAY_FACTOR
  INTO l_pc_disply_factor
  FROM  fpa_aw_pc_disc_funds_v b
  WHERE b.planning_cycle = p_fin_targets_tbl(1).planning_cycle;

Line: 295

  SELECT SUBSTR(VALUE,1,1)
    INTO l_decimal_marker
    FROM NLS_SESSION_PARAMETERS
   WHERE PARAMETER = 'NLS_NUMERIC_CHARACTERS';

Line: 300

	-- Update the financial targets
	-- Limit PCID
	  dbms_aw.execute('LMT planning_cycle_d TO ' || p_fin_targets_tbl(1).planning_cycle );

Line: 312

            SELECT meaning
              INTO l_target_name
              FROM fpa_lookups_v
             WHERE lookup_type = 'FPA_PC_FIN_TARGETS'
               AND lookup_code = p_fin_targets_tbl(i).financial_metrics;

Line: 342

			'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Fin_Targets.end',
			'Exiting FPA_PlanningCycle_Pvt.Update_Pc_Fin_Targets'
		);

Line: 360

			'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Fin_Targets',
			SQLERRM
		);

Line: 372

END Update_Pc_Fin_Targets;

Line: 374

PROCEDURE Update_Pc_Inv_Criteria_Data
     ( p_api_version        IN NUMBER,
       p_inv_crit_tbl       IN fpa_pc_inv_criteria_tbl,
       x_return_status      OUT NOCOPY VARCHAR2,
       x_msg_data           OUT NOCOPY VARCHAR2,
       x_msg_count          OUT NOCOPY NUMBER )
IS
l_pc_obj varchar2(3);

Line: 388

	       	'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Inv_Criteria_Data.begin',
		'Entering FPA_PlanningCycle_Pvt.Update_Pc_Inv_Criteria_Data'
		);

Line: 399

	-- Update the investment criteria data
	-- Limit PCID
        IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
                FND_LOG.String
                ( FND_LOG.LEVEL_PROCEDURE,
                'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Inv_Criteria_Data',
                'Limit pc dimension to ' || p_inv_crit_tbl(1).planning_cycle || ' value.'
                );

Line: 414

                'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Inv_Criteria_Data',
                'Setting score_type_pc_r to: ' || p_inv_crit_tbl(1).pc_project_score_source || ' value.'
                );

Line: 424

                'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Inv_Criteria_Data',
                'Setting pc_project_score_scale_m to: ' || p_inv_crit_tbl(1).pc_project_score_scale || ' value.'
                );

Line: 437

                'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Inv_Criteria_Data',
                'Debugging, we are in ' || i || ' value.'
                );

Line: 447

                'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Inv_Criteria_Data',
                'Limit strategic_obj_d dimension to ' || p_inv_crit_tbl(i).investment_criteria || ' value.'
                );

Line: 459

                'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Inv_Criteria_Data',
                'Setting pc_strategic_obj_weights_m: ' || p_inv_crit_tbl(i).pc_inv_criteria_weight || ' value.'
                );

Line: 471

                'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Inv_Criteria_Data',
                'Setting pc_obj_wscore_targets_from_m: ' || p_inv_crit_tbl(i).pc_inv_crit_score_target_from || ' value.'
                );

Line: 476

	-- If the target_from value from UI is null, update it in AW with NA

        IF p_inv_crit_tbl(i).pc_inv_crit_score_target_from IS NULL THEN
          dbms_aw.execute('pc_obj_wscore_targets_from_m = NA');

Line: 490

                'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Inv_Criteria_Data',
                'Setting pc_obj_wscore_targets_to_m: ' || p_inv_crit_tbl(i).pc_inv_crit_score_target_to || ' value.'
                );

Line: 494

	-- If the target_to value from UI is null, update it in AW with NA

        IF p_inv_crit_tbl(i).pc_inv_crit_score_target_to IS NULL THEN
          dbms_aw.execute('pc_obj_wscore_targets_to_m = NA');

Line: 509

                'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Inv_Criteria_Data',
                'Calling AW program: set_pc_invest_criteria_prg( ' || p_inv_crit_tbl(1).planning_cycle || ').'
                );

Line: 521

			'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Inv_Criteria_Data.end',
			'Exiting FPA_PlanningCycle_Pvt.Update_Pc_Inv_Criteria_Data'
		);

Line: 537

			'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Inv_Criteria_Data',
			SQLERRM
		);

Line: 549

END Update_Pc_Inv_Criteria_Data;

Line: 552

PROCEDURE Update_Pc_Desc_Fields
     ( p_api_version        IN NUMBER,
       p_pc_all_obj         IN fpa_pc_all_obj,
       x_return_status      OUT NOCOPY VARCHAR2,
       x_msg_data           OUT NOCOPY VARCHAR2,
       x_msg_count          OUT NOCOPY NUMBER )
IS

BEGIN

	IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
		FND_LOG.String
		(
			FND_LOG.LEVEL_PROCEDURE,
			'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Desc_Fields.begin',
			'Entering FPA_PlanningCycle_Pvt.Update_Pc_Desc_Fields'
		);

Line: 571

	-- Update name and description

    --DBMS_OUTPUT.put_line('Before Updating Update_Pc_Desc_Fields...');

Line: 575

    UPDATE FPA_OBJECTS_TL
    SET  name = p_pc_all_obj.pc_desc_fields.name
        ,description = p_pc_all_obj.pc_desc_fields.description
        ,SOURCE_LANG     = userenv('LANG')
        ,last_update_date = sysdate()
    WHERE id = p_pc_all_obj.pc_desc_fields.id
    AND userenv('LANG') IN (LANGUAGE, SOURCE_LANG)
    AND OBJECT = 'PLANNING_CYCLE'; --Added for bug 6142322

Line: 588

			'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Desc_Fields.end',
			'Exiting FPA_PlanningCycle_Pvt.Update_Pc_Desc_Fields'
		);

Line: 602

			'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Desc_Fields',
			SQLERRM
		);

Line: 614

END Update_Pc_Desc_Fields;

Line: 638

	-- Update the status
	dbms_aw.execute('LMT planning_cycle_d TO ' || p_pc_id );

Line: 762

PROCEDURE Update_Pc_Class_Category
     ( p_api_version        IN NUMBER,
       p_pc_id              IN NUMBER,
       p_catg_id            IN NUMBER,
       x_return_status      OUT NOCOPY VARCHAR2,
       x_msg_data           OUT NOCOPY VARCHAR2,
       x_msg_count          OUT NOCOPY NUMBER )
IS

BEGIN
    --DBMS_OUTPUT.put_line('Inside Update_Pc_Class_Category....');

Line: 778

			'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Class_Category.begin',
			'Entering FPA_PlanningCycle_Pvt.Update_Pc_Class_Category'
		);

Line: 784

	-- Update the Basic Info
	-- Limit PCID
	dbms_aw.execute('LMT planning_cycle_d TO ' || p_pc_id );

Line: 796

			'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Class_Category.end',
			'Exiting FPA_PlanningCycle_Pvt.Update_Pc_Class_Category'
		);

Line: 810

			'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Class_Category',
			SQLERRM
		);

Line: 822

END Update_Pc_Class_Category;

Line: 824

PROCEDURE Update_Pc_Calendar
     ( p_api_version        IN NUMBER,
       p_pc_info            IN fpa_pc_info_obj,
       x_return_status      OUT NOCOPY VARCHAR2,
       x_msg_data           OUT NOCOPY VARCHAR2,
       x_msg_count          OUT NOCOPY NUMBER )
IS

BEGIN
    --DBMS_OUTPUT.put_line('Inside Update_Pc_Calendar....');

Line: 839

			'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Calendar.begin',
			'Entering FPA_PlanningCycle_Pvt.Update_Pc_Calendar'
		);

Line: 845

	-- Update the Calendar
	-- Limit PCID
	dbms_aw.execute('LMT planning_cycle_d TO ' || p_pc_info.planning_cycle );

Line: 902

			'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Calendar.end',
			'Exiting FPA_PlanningCycle_Pvt.Update_Pc_Calendar'
		);

Line: 916

			'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Calendar',
			SQLERRM
		);

Line: 928

END Update_Pc_Calendar;

Line: 930

PROCEDURE Update_Pc_Currency
     ( p_api_version        IN NUMBER,
       p_pc_info            IN fpa_pc_info_obj,
       x_return_status      OUT NOCOPY VARCHAR2,
       x_msg_data           OUT NOCOPY VARCHAR2,
       x_msg_count          OUT NOCOPY NUMBER )
IS

BEGIN
    --DBMS_OUTPUT.put_line('Inside Update_Pc_Currency....');

Line: 944

		 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Currency.begin',
		 'Entering FPA_PlanningCycle_Pvt.Update_Pc_Currency'
		);

Line: 950

	-- Update the Currency
	-- Limit PCID
	dbms_aw.execute('LMT planning_cycle_d TO ' || p_pc_info.planning_cycle );

Line: 983

                 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Currency',
                 'Setting currency_date_pc_r to : ' || to_char(fnd_date.chardate_to_date(p_pc_info.conversion_rate_date), 'MMDDYYYY' || '''') || ' value.'  -- Bug 9264707
                );

Line: 1001

                 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Currency',
                 'Setting currency_date_pc_r to sysdate value.'||to_char(sysdate,'MMDDYYYY' || '''')  -- Bug 9264707
                );

Line: 1021

			'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Currency.end',
			'Exiting FPA_PlanningCycle_Pvt.Update_Pc_Currency'
		);

Line: 1035

			'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Currency',
			SQLERRM
		);

Line: 1047

END Update_Pc_Currency;

Line: 1050

PROCEDURE Update_Pc_Sub_Due_Date
     ( p_api_version        IN NUMBER,
       p_pc_info            IN fpa_pc_info_obj,
       x_return_status      OUT NOCOPY VARCHAR2,
       x_msg_data           OUT NOCOPY VARCHAR2,
       x_msg_count          OUT NOCOPY NUMBER )
IS

BEGIN
    --DBMS_OUTPUT.put_line('Inside Update_Pc_Sub_Due_Date....');

Line: 1065

			'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Sub_Due_Date.begin',
			'Entering FPA_PlanningCycle_Pvt.Update_Pc_Sub_Due_Date'
		);

Line: 1071

	-- Update the Currency
	-- Limit PCID
	dbms_aw.execute('LMT planning_cycle_d TO ' || p_pc_info.planning_cycle );

Line: 1106

			'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Sub_Due_Date.end',
			'Exiting FPA_PlanningCycle_Pvt.Update_Pc_Sub_Due_Date'
		);

Line: 1120

			'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Sub_Due_Date',
			SQLERRM
		);

Line: 1132

END Update_Pc_Sub_Due_Date;

Line: 1136

PROCEDURE Update_Pc_Discount_funds
     ( p_api_version        IN NUMBER,
       p_disc_funds         IN fpa_pc_discount_obj,
       x_return_status      OUT NOCOPY VARCHAR2,
       x_msg_data           OUT NOCOPY VARCHAR2,
       x_msg_count          OUT NOCOPY NUMBER )
IS
l_decimal_marker VARCHAR2(1) ;

Line: 1155

			'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Discount_funds.begin',
			'Entering FPA_PlanningCycle_Pvt.Update_Pc_Discount_funds'
		);

Line: 1162

  	-- Update the Discount
    -- Limit PCID
    dbms_aw.execute('LMT planning_cycle_d TO ' || p_disc_funds.planning_cycle);

Line: 1169

     SELECT SUBSTR(VALUE,1,1)
       INTO l_decimal_marker
       FROM NLS_SESSION_PARAMETERS
      WHERE PARAMETER = 'NLS_NUMERIC_CHARACTERS';

Line: 1192

			'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Discount_funds.end',
			'Exiting FPA_PlanningCycle_Pvt.Update_Pc_Discount_funds'
		);

Line: 1206

			'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Discount_funds',
			SQLERRM
		);

Line: 1218

END Update_Pc_Discount_funds;

Line: 1247

        SELECT count(p.name)
        INTO l_pcName_Count
        FROM fpa_aw_pc_info_v a, fpa_pcs_vl p
        WHERE a.planning_cycle = p.planning_cycle
        AND portfolio = p_portfolio_id
        AND p.name = p_pc_name ;

Line: 1255

        SELECT count(p.name)
        INTO l_pcName_Count
        FROM fpa_aw_pc_info_v a, fpa_pcs_vl p
        WHERE a.planning_cycle = p.planning_cycle
        AND portfolio = p_portfolio_id
        AND p.name = p_pc_name
        AND a.planning_cycle <> p_pc_id ;

Line: 1299

PROCEDURE Pa_Distrb_Lists_Insert_Row (
       p_api_version    IN NUMBER,
       p_distr_list     IN fpa_pc_distr_list_obj,
       p_list_id 	    IN OUT NOCOPY NUMBER,
       x_return_status  OUT NOCOPY VARCHAR2,
       x_msg_data       OUT NOCOPY VARCHAR2,
       x_msg_count      OUT NOCOPY NUMBER )

IS
l_list_id NUMBER;

Line: 1315

			'fpa.sql.FPA_Process_Pvt.Pa_Distrb_Lists_Insert_Row.begin',
			'Entering FPA_Process_Pvt.Pa_Distrb_Lists_Insert_Row'
		);

Line: 1322

     PA_DISTRIBUTION_LISTS_PKG.INSERT_ROW
            (
                P_LIST_ID => l_list_id,
                P_NAME => l_obj_name,
                P_DESCRIPTION => p_distr_list.description,
                P_RECORD_VERSION_NUMBER => NULL,
                P_CREATED_BY =>	fnd_global.user_id,
                P_CREATION_DATE => sysdate,
                P_LAST_UPDATED_BY => fnd_global.user_id,
                P_LAST_UPDATE_DATE => sysdate,
                P_LAST_UPDATE_LOGIN => fnd_global.user_id
            );

Line: 1338

     PA_OBJECT_DIST_LISTS_PKG.INSERT_ROW
            (
                P_LIST_ID => l_list_id,
                P_OBJECT_TYPE => p_distr_list.object_type,
                P_OBJECT_ID => p_distr_list.object_id,
                P_RECORD_VERSION_NUMBER => NULL,
                P_CREATED_BY =>	fnd_global.user_id,
                P_CREATION_DATE => sysdate,
                P_LAST_UPDATED_BY => fnd_global.user_id,
                P_LAST_UPDATE_DATE => sysdate,
                P_LAST_UPDATE_LOGIN => fnd_global.user_id
            );

Line: 1356

			'fpa.sql.FPA_Process_Pvt.Pa_Distrb_Lists_Insert_Row.end',
			'Exiting FPA_Process_Pvt.Pa_Distrb_Lists_Insert_Row'
		);

Line: 1373

			'fpa.sql.FPA_Process_Pvt.Pa_Distrb_Lists_Insert_Row',
			SQLERRM
		);

Line: 1385

END Pa_Distrb_Lists_Insert_Row;

Line: 1388

PROCEDURE Pa_Dist_List_Items_Update_Row (
       p_api_version           IN NUMBER,
       p_distr_list_items_tbl  fpa_pc_distr_list_items_tbl,
       x_return_status         OUT NOCOPY VARCHAR2,
       x_msg_data              OUT NOCOPY VARCHAR2,
       x_msg_count             OUT NOCOPY NUMBER )
IS
l_list_item_id NUMBER;

Line: 1402

			'fpa.sql.FPA_Process_Pvt.Pa_Dist_List_Items_Update_Row.begin',
			'Entering FPA_Process_Pvt.Pa_Dist_List_Items_Update_Row'
		);

Line: 1411

         SELECT list_id INTO l_list_id
   	     FROM  pa_object_dist_lists
         WHERE object_id = p_distr_list_items_tbl(1).planning_cycle
		 AND object_type = 'PJP_PLANNING_CYCLE';

Line: 1434

              PA_DIST_LIST_ITEMS_PKG.Update_Row
                (
                    P_LIST_ITEM_ID   => p_distr_list_items_tbl(i).list_item_id,
                    P_LIST_ID        => l_list_id,
                    P_RECIPIENT_TYPE => p_distr_list_items_tbl(i).recipient_type,
                    P_RECIPIENT_ID   => p_distr_list_items_tbl(i).recipient_id,
                    P_ACCESS_LEVEL   => NULL,
                    P_MENU_ID        => NULL,
                    P_EMAIL          => p_distr_list_items_tbl(i).email_exists,
                    P_RECORD_VERSION_NUMBER => NULL,
                    P_LAST_UPDATED_BY   => fnd_global.user_id,
                    P_LAST_UPDATE_DATE  => sysdate,
                    P_LAST_UPDATE_LOGIN => fnd_global.user_id
                );

Line: 1454

                PA_DIST_LIST_ITEMS_PKG.INSERT_ROW
                 (
                    P_LIST_ITEM_ID => l_list_item_id,
                    P_LIST_ID => l_list_id,
                    P_RECIPIENT_TYPE => p_distr_list_items_tbl(i).recipient_type,
                    P_RECIPIENT_ID => p_distr_list_items_tbl(i).recipient_id,
                    P_ACCESS_LEVEL => NULL,
                    P_MENU_ID => NULL,
                    P_EMAIL => p_distr_list_items_tbl(i).email_exists,
                    P_RECORD_VERSION_NUMBER => NULL,
                    P_CREATED_BY =>	fnd_global.user_id,
                    P_CREATION_DATE => sysdate,
                    P_LAST_UPDATED_BY => fnd_global.user_id,
                    P_LAST_UPDATE_DATE => sysdate,
                    P_LAST_UPDATE_LOGIN => fnd_global.user_id
                 );

Line: 1482

			'fpa.sql.FPA_Process_Pvt.Pa_Dist_List_Items_Update_Row.end',
			'Exiting FPA_Process_Pvt.Pa_Dist_List_Items_Update_Row'
		);

Line: 1499

			'fpa.sql.FPA_Process_Pvt.Pa_Dist_List_Items_Update_Row',
			SQLERRM
		);

Line: 1511

END Pa_Dist_List_Items_Update_Row;

Line: 1796

PROCEDURE Update_Pc_Annual_Disc_Rates
     ( p_api_version        IN NUMBER,
       p_pc_id              IN NUMBER,
       p_period             IN VARCHAR2,
       p_rate               IN VARCHAR2,
       x_return_status      OUT NOCOPY VARCHAR2,
       x_msg_data           OUT NOCOPY VARCHAR2,
       x_msg_count          OUT NOCOPY NUMBER )
is

  l_api_version            CONSTANT NUMBER    := 1.0;

Line: 1813

     'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Annual_Disc_Rates.begin',
     'Entering FPA_PlanningCycle_Pvt.Update_Pc_Annual_Disc_Rates');

Line: 1821

       'FPA.SQL.FPA_PlanningCycle_Pvt.Update_Pc_Annual_Disc_Rates.',
       'Checking API version.');

Line: 1830

     'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Annual_Disc_Rates.',
     'Updating Annual discount rates for the PC in AW.');

Line: 1841

     'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Annual_Disc_Rates.',
     'Done Updating  Annual discount rates for the PC in AW.');

Line: 1848

     'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Annual_Disc_Rates.end',
     'Entering FPA_PlanningCycle_Pvt.Update_Pc_Annual_Disc_Rates');

Line: 1861

        'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Annual_Disc_Rates',
        SQLERRM);

Line: 1871

END Update_Pc_Annual_Disc_Rates;