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_PLANNINGCYCLE_PVT dependencies on DBMS_AW

Line 107: dbms_aw.execute('MAINTAIN planning_cycle_d ADD ' || l_pc_s_r.l_pc_id );

103:
104: --DBMS_OUTPUT.put_line('Before Maintain ID.....');
105:
106: -- Add the new scenario to the dimension
107: dbms_aw.execute('MAINTAIN planning_cycle_d ADD ' || l_pc_s_r.l_pc_id );
108:
109: --DBMS_OUTPUT.put_line('Before Limit ID.....');
110: dbms_aw.execute('PUSH planning_cycle_d');
111:

Line 110: dbms_aw.execute('PUSH planning_cycle_d');

106: -- Add the new scenario to the dimension
107: dbms_aw.execute('MAINTAIN planning_cycle_d ADD ' || l_pc_s_r.l_pc_id );
108:
109: --DBMS_OUTPUT.put_line('Before Limit ID.....');
110: dbms_aw.execute('PUSH planning_cycle_d');
111:
112: dbms_aw.execute('LMT planning_cycle_d TO ' || l_pc_s_r.l_pc_id );
113:
114: --DBMS_OUTPUT.put_line('Before setting the Portfolio relation.....portfolio_id=' || p_pc_all_obj.pc_info.portfolio);

Line 112: dbms_aw.execute('LMT planning_cycle_d TO ' || l_pc_s_r.l_pc_id );

108:
109: --DBMS_OUTPUT.put_line('Before Limit ID.....');
110: dbms_aw.execute('PUSH planning_cycle_d');
111:
112: dbms_aw.execute('LMT planning_cycle_d TO ' || l_pc_s_r.l_pc_id );
113:
114: --DBMS_OUTPUT.put_line('Before setting the Portfolio relation.....portfolio_id=' || p_pc_all_obj.pc_info.portfolio);
115:
116: -- Associate the planning cycle with the portfolio

Line 117: dbms_aw.execute('portfolio_pc_r = ' || p_pc_all_obj.pc_info.portfolio );

113:
114: --DBMS_OUTPUT.put_line('Before setting the Portfolio relation.....portfolio_id=' || p_pc_all_obj.pc_info.portfolio);
115:
116: -- Associate the planning cycle with the portfolio
117: dbms_aw.execute('portfolio_pc_r = ' || p_pc_all_obj.pc_info.portfolio );
118:
119: dbms_aw.execute('POP planning_cycle_d');
120:
121: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 119: dbms_aw.execute('POP planning_cycle_d');

115:
116: -- Associate the planning cycle with the portfolio
117: dbms_aw.execute('portfolio_pc_r = ' || p_pc_all_obj.pc_info.portfolio );
118:
119: dbms_aw.execute('POP planning_cycle_d');
120:
121: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
122: FND_LOG.String
123: (

Line 202: dbms_aw.execute('CALL set_pc_class_code_valid_prg('|| p_inv_matrix(1).planning_cycle ||' ,'|| p_inv_matrix(1).pc_category ||')');

198: IF p_inv_matrix(1).pc_category = l_pc_catg THEN
199: NULL;
200: ELSE
201: --DBMS_OUTPUT.put_line(' ..... STARTING EXECUTION OF AW PROGRAMS ..... ');
202: dbms_aw.execute('CALL set_pc_class_code_valid_prg('|| p_inv_matrix(1).planning_cycle ||' ,'|| p_inv_matrix(1).pc_category ||')');
203: END IF;
204:
205: -- Update the InvestMix
206: -- Limit PCID

Line 207: dbms_aw.execute('LMT planning_cycle_d TO ' || p_inv_matrix(1).planning_cycle );

203: END IF;
204:
205: -- Update the InvestMix
206: -- Limit PCID
207: dbms_aw.execute('LMT planning_cycle_d TO ' || p_inv_matrix(1).planning_cycle );
208:
209: FOR i IN p_inv_matrix.FIRST..p_inv_matrix.LAST
210: LOOP
211: --DBMS_OUTPUT.put_line(' ..Inside For loop...p_inv_matrix(i).class_code=' || p_inv_matrix(i).class_code );

Line 215: dbms_aw.execute('LMT class_code_d TO ' || p_inv_matrix(i).class_code );

211: --DBMS_OUTPUT.put_line(' ..Inside For loop...p_inv_matrix(i).class_code=' || p_inv_matrix(i).class_code );
212: --DBMS_OUTPUT.put_line(' ..Inside For loop...p_inv_matrix(i).investment_mix=' || p_inv_matrix(i).investment_mix );
213:
214: -- Limit Class_code_d
215: dbms_aw.execute('LMT class_code_d TO ' || p_inv_matrix(i).class_code );
216: -- Set the funds percentage for each class code
217: dbms_aw.execute('pc_class_code_target_mix_m = ' || p_inv_matrix(i).investment_mix );
218:
219: END LOOP;

Line 217: dbms_aw.execute('pc_class_code_target_mix_m = ' || p_inv_matrix(i).investment_mix );

213:
214: -- Limit Class_code_d
215: dbms_aw.execute('LMT class_code_d TO ' || p_inv_matrix(i).class_code );
216: -- Set the funds percentage for each class code
217: dbms_aw.execute('pc_class_code_target_mix_m = ' || p_inv_matrix(i).investment_mix );
218:
219: END LOOP;
220:
221:

Line 296: dbms_aw.execute('LMT planning_cycle_d TO ' || p_fin_targets_tbl(1).planning_cycle );

292:
293:
294: -- Update the financial targets
295: -- Limit PCID
296: dbms_aw.execute('LMT planning_cycle_d TO ' || p_fin_targets_tbl(1).planning_cycle );
297:
298: FOR i IN p_fin_targets_tbl.FIRST..p_fin_targets_tbl.LAST
299: LOOP
300: --DBMS_OUTPUT.put_line(' ..Inside For loop...p_fin_targets_tbl(i).financial_target_from=' || p_fin_targets_tbl(i).financial_target_from );

Line 319: dbms_aw.execute('LMT financial_metrics_d TO ''' || p_fin_targets_tbl(i).financial_metrics || '''' );

315: RAISE FND_API.G_EXC_ERROR;
316: end if;
317:
318: -- Limit financial_metrics_d
319: dbms_aw.execute('LMT financial_metrics_d TO ''' || p_fin_targets_tbl(i).financial_metrics || '''' );
320: -- Set the targets from for each fin matric
321: dbms_aw.execute('pc_fintargets_range_from_m = ' || p_fin_targets_tbl(i).financial_target_from*l_pc_disply_factor );
322: -- Set the targets to for each fin matric
323: dbms_aw.execute('pc_fintargets_range_to_m = ' || p_fin_targets_tbl(i).financial_target_to*l_pc_disply_factor );

Line 321: dbms_aw.execute('pc_fintargets_range_from_m = ' || p_fin_targets_tbl(i).financial_target_from*l_pc_disply_factor );

317:
318: -- Limit financial_metrics_d
319: dbms_aw.execute('LMT financial_metrics_d TO ''' || p_fin_targets_tbl(i).financial_metrics || '''' );
320: -- Set the targets from for each fin matric
321: dbms_aw.execute('pc_fintargets_range_from_m = ' || p_fin_targets_tbl(i).financial_target_from*l_pc_disply_factor );
322: -- Set the targets to for each fin matric
323: dbms_aw.execute('pc_fintargets_range_to_m = ' || p_fin_targets_tbl(i).financial_target_to*l_pc_disply_factor );
324: END LOOP;
325:

Line 323: dbms_aw.execute('pc_fintargets_range_to_m = ' || p_fin_targets_tbl(i).financial_target_to*l_pc_disply_factor );

319: dbms_aw.execute('LMT financial_metrics_d TO ''' || p_fin_targets_tbl(i).financial_metrics || '''' );
320: -- Set the targets from for each fin matric
321: dbms_aw.execute('pc_fintargets_range_from_m = ' || p_fin_targets_tbl(i).financial_target_from*l_pc_disply_factor );
322: -- Set the targets to for each fin matric
323: dbms_aw.execute('pc_fintargets_range_to_m = ' || p_fin_targets_tbl(i).financial_target_to*l_pc_disply_factor );
324: END LOOP;
325:
326:
327: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 397: dbms_aw.execute('LMT planning_cycle_d TO ' || p_inv_crit_tbl(1).planning_cycle);

393: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Inv_Criteria_Data',
394: 'Limit pc dimension to ' || p_inv_crit_tbl(1).planning_cycle || ' value.'
395: );
396: END IF;
397: dbms_aw.execute('LMT planning_cycle_d TO ' || p_inv_crit_tbl(1).planning_cycle);
398:
399: -- Set the score source
400: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
401: FND_LOG.String

Line 407: dbms_aw.execute('score_type_pc_r = ''' || p_inv_crit_tbl(1).pc_project_score_source || '''');

403: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Inv_Criteria_Data',
404: 'Setting score_type_pc_r to: ' || p_inv_crit_tbl(1).pc_project_score_source || ' value.'
405: );
406: END IF;
407: dbms_aw.execute('score_type_pc_r = ''' || p_inv_crit_tbl(1).pc_project_score_source || '''');
408:
409: -- Set the score scale
410: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
411: FND_LOG.String

Line 417: dbms_aw.execute('pc_project_score_scale_m = ' || p_inv_crit_tbl(1).pc_project_score_scale );

413: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Inv_Criteria_Data',
414: 'Setting pc_project_score_scale_m to: ' || p_inv_crit_tbl(1).pc_project_score_scale || ' value.'
415: );
416: END IF;
417: dbms_aw.execute('pc_project_score_scale_m = ' || p_inv_crit_tbl(1).pc_project_score_scale );
418:
419:
420: FOR i IN p_inv_crit_tbl.FIRST..p_inv_crit_tbl.LAST
421: LOOP

Line 440: dbms_aw.execute('LMT strategic_obj_d TO ' || p_inv_crit_tbl(i).investment_criteria );

436: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Inv_Criteria_Data',
437: 'Limit strategic_obj_d dimension to ' || p_inv_crit_tbl(i).investment_criteria || ' value.'
438: );
439: END IF;
440: dbms_aw.execute('LMT strategic_obj_d TO ' || p_inv_crit_tbl(i).investment_criteria );
441:
442: --DBMS_OUTPUT.put_line(' ..Inside For loop...after setting p_inv_crit_tbl(i).investment_criteria' );
443:
444: -- Set the weights for each strategic_obj

Line 452: dbms_aw.execute('pc_strategic_obj_weights_m = ' || p_inv_crit_tbl(i).pc_inv_criteria_weight );

448: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Inv_Criteria_Data',
449: 'Setting pc_strategic_obj_weights_m: ' || p_inv_crit_tbl(i).pc_inv_criteria_weight || ' value.'
450: );
451: END IF;
452: dbms_aw.execute('pc_strategic_obj_weights_m = ' || p_inv_crit_tbl(i).pc_inv_criteria_weight );
453:
454: --DBMS_OUTPUT.put_line(' ..Inside For loop...after setting p_inv_crit_tbl(i).pc_inv_criteria_weight' );
455:
456: -- Set the target from for each strategic_obj

Line 468: dbms_aw.execute('pc_obj_wscore_targets_from_m = NA');

464:
465: -- If the target_from value from UI is null, update it in AW with NA
466:
467: IF p_inv_crit_tbl(i).pc_inv_crit_score_target_from IS NULL THEN
468: dbms_aw.execute('pc_obj_wscore_targets_from_m = NA');
469: ELSE
470: dbms_aw.execute('pc_obj_wscore_targets_from_m = ' || p_inv_crit_tbl(i).pc_inv_crit_score_target_from );
471: END IF;
472:

Line 470: dbms_aw.execute('pc_obj_wscore_targets_from_m = ' || p_inv_crit_tbl(i).pc_inv_crit_score_target_from );

466:
467: IF p_inv_crit_tbl(i).pc_inv_crit_score_target_from IS NULL THEN
468: dbms_aw.execute('pc_obj_wscore_targets_from_m = NA');
469: ELSE
470: dbms_aw.execute('pc_obj_wscore_targets_from_m = ' || p_inv_crit_tbl(i).pc_inv_crit_score_target_from );
471: END IF;
472:
473: --DBMS_OUTPUT.put_line(' ..Inside For loop...after setting p_inv_crit_tbl(i).pc_inv_crit_score_target_from' );
474:

Line 486: dbms_aw.execute('pc_obj_wscore_targets_to_m = NA');

482: END IF;
483: -- If the target_to value from UI is null, update it in AW with NA
484:
485: IF p_inv_crit_tbl(i).pc_inv_crit_score_target_to IS NULL THEN
486: dbms_aw.execute('pc_obj_wscore_targets_to_m = NA');
487: ELSE
488: dbms_aw.execute('pc_obj_wscore_targets_to_m = ' || p_inv_crit_tbl(i).pc_inv_crit_score_target_to );
489: END IF;
490: --DBMS_OUTPUT.put_line(' ..Inside For loop...after setting p_inv_crit_tbl(i).pc_inv_crit_score_target_to' );

Line 488: dbms_aw.execute('pc_obj_wscore_targets_to_m = ' || p_inv_crit_tbl(i).pc_inv_crit_score_target_to );

484:
485: IF p_inv_crit_tbl(i).pc_inv_crit_score_target_to IS NULL THEN
486: dbms_aw.execute('pc_obj_wscore_targets_to_m = NA');
487: ELSE
488: dbms_aw.execute('pc_obj_wscore_targets_to_m = ' || p_inv_crit_tbl(i).pc_inv_crit_score_target_to );
489: END IF;
490: --DBMS_OUTPUT.put_line(' ..Inside For loop...after setting p_inv_crit_tbl(i).pc_inv_crit_score_target_to' );
491:
492: END LOOP;

Line 502: dbms_aw.execute('call set_pc_invest_criteria_prg(' || p_inv_crit_tbl(1).planning_cycle || ')');

498: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Inv_Criteria_Data',
499: 'Calling AW program: set_pc_invest_criteria_prg( ' || p_inv_crit_tbl(1).planning_cycle || ').'
500: );
501: END IF;
502: dbms_aw.execute('call set_pc_invest_criteria_prg(' || p_inv_crit_tbl(1).planning_cycle || ')');
503: */
504:
505:
506: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 628: dbms_aw.execute('LMT planning_cycle_d TO ' || p_pc_id );

624: END IF;
625: --DBMS_OUTPUT.put_line('Before limiting planning_cycle_d to: ' || p_pc_id );
626:
627: -- Update the status
628: dbms_aw.execute('LMT planning_cycle_d TO ' || p_pc_id );
629:
630: --DBMS_OUTPUT.put_line('Before setting status_pc_r ....');
631: -- Set the new staus
632: dbms_aw.execute('status_pc_r = ''' || p_pc_status_code || '''');

Line 632: dbms_aw.execute('status_pc_r = ''' || p_pc_status_code || '''');

628: dbms_aw.execute('LMT planning_cycle_d TO ' || p_pc_id );
629:
630: --DBMS_OUTPUT.put_line('Before setting status_pc_r ....');
631: -- Set the new staus
632: dbms_aw.execute('status_pc_r = ''' || p_pc_status_code || '''');
633:
634:
635: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
636: FND_LOG.String

Line 688: dbms_aw.execute('LMT planning_cycle_d TO ' || p_pc_id );

684: END IF;
685: --DBMS_OUTPUT.put_line('Before limiting planning_cycle_d to: ' || p_pc_id );
686:
687: -- Limit the PC ID
688: dbms_aw.execute('LMT planning_cycle_d TO ' || p_pc_id );
689:
690: -- Set the new Initiate Date
691:
692: BEGIN

Line 694: /* dbms_aw.execute('MAINTAIN day_d ADD '''

690: -- Set the new Initiate Date
691:
692: BEGIN
693: -- Add new Day to the Day_d dimension
694: /* dbms_aw.execute('MAINTAIN day_d ADD '''
695: || to_char(to_date(p_pc_init_date, 'DD-MON-YYYY'), 'DDMONYYYY' || ''''));
696: */
697: dbms_aw.execute('MAINTAIN day_d ADD ''' || to_char(SYSDATE, 'DDMONYYYY') || '''' );
698: EXCEPTION

Line 697: dbms_aw.execute('MAINTAIN day_d ADD ''' || to_char(SYSDATE, 'DDMONYYYY') || '''' );

693: -- Add new Day to the Day_d dimension
694: /* dbms_aw.execute('MAINTAIN day_d ADD '''
695: || to_char(to_date(p_pc_init_date, 'DD-MON-YYYY'), 'DDMONYYYY' || ''''));
696: */
697: dbms_aw.execute('MAINTAIN day_d ADD ''' || to_char(SYSDATE, 'DDMONYYYY') || '''' );
698: EXCEPTION
699: WHEN OTHERS THEN
700: --DBMS_OUTPUT.put_line(SQLCODE);
701: -- Check for existing dim values, if it already exists during MAINTAIN, then ignore it.

Line 711: dbms_aw.execute('pc_initiate_date_r = ''' || to_char(SYSDATE, 'DDMONYYYY') || '''');

707: --DBMS_OUTPUT.PUT_LINE('....pc_initiate_date:' || SYSDATE);
708:
709:
710:
711: dbms_aw.execute('pc_initiate_date_r = ''' || to_char(SYSDATE, 'DDMONYYYY') || '''');
712:
713: /*
714: dbms_aw.execute('pc_initiate_date_r = '''
715: || to_char(to_date(p_pc_init_date, 'DD-MON-YYYY'), 'DDMONYYYY' || ''''));

Line 714: dbms_aw.execute('pc_initiate_date_r = '''

710:
711: dbms_aw.execute('pc_initiate_date_r = ''' || to_char(SYSDATE, 'DDMONYYYY') || '''');
712:
713: /*
714: dbms_aw.execute('pc_initiate_date_r = '''
715: || to_char(to_date(p_pc_init_date, 'DD-MON-YYYY'), 'DDMONYYYY' || ''''));
716: */
717:
718: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 775: dbms_aw.execute('LMT planning_cycle_d TO ' || p_pc_id );

771: --DBMS_OUTPUT.put_line('Before limiting planning_cycle_d to: ' || p_pc_id );
772:
773: -- Update the Basic Info
774: -- Limit PCID
775: dbms_aw.execute('LMT planning_cycle_d TO ' || p_pc_id );
776:
777: --DBMS_OUTPUT.put_line('Before setting pc_class_code_m ....');
778: -- Set the new class category
779: dbms_aw.execute('pc_category_m = ''' || p_catg_id || '''');

Line 779: dbms_aw.execute('pc_category_m = ''' || p_catg_id || '''');

775: dbms_aw.execute('LMT planning_cycle_d TO ' || p_pc_id );
776:
777: --DBMS_OUTPUT.put_line('Before setting pc_class_code_m ....');
778: -- Set the new class category
779: dbms_aw.execute('pc_category_m = ''' || p_catg_id || '''');
780:
781: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
782: FND_LOG.String
783: (

Line 836: dbms_aw.execute('LMT planning_cycle_d TO ' || p_pc_info.planning_cycle );

832: --DBMS_OUTPUT.put_line('Before limiting planning_cycle_d to: ' || p_pc_info.planning_cycle );
833:
834: -- Update the Calendar
835: -- Limit PCID
836: dbms_aw.execute('LMT planning_cycle_d TO ' || p_pc_info.planning_cycle );
837:
838: --DBMS_OUTPUT.put_line('Before setting Update_Pc_Calendar ....');
839: BEGIN
840: -- Add new calendar to the dimension

Line 841: dbms_aw.execute('MAINTAIN calendar_d ADD ''' || p_pc_info.calendar_name || '''');

837:
838: --DBMS_OUTPUT.put_line('Before setting Update_Pc_Calendar ....');
839: BEGIN
840: -- Add new calendar to the dimension
841: dbms_aw.execute('MAINTAIN calendar_d ADD ''' || p_pc_info.calendar_name || '''');
842: EXCEPTION
843: WHEN OTHERS THEN
844: --DBMS_OUTPUT.put_line(SQLCODE);
845: -- Check for existing dim values, if it already exists during MAINTAIN, then ignore it.

Line 851: dbms_aw.execute('calendar_pc_r = ''' || p_pc_info.calendar_name || '''');

847: NULL;
848: END IF;
849: END;
850: -- Set the new calendar
851: dbms_aw.execute('calendar_pc_r = ''' || p_pc_info.calendar_name || '''');
852:
853: BEGIN
854: -- Add new Period Type to the dimension
855: dbms_aw.execute('MAINTAIN period_type_d ADD ''' || p_pc_info.period_type || '''');

Line 855: dbms_aw.execute('MAINTAIN period_type_d ADD ''' || p_pc_info.period_type || '''');

851: dbms_aw.execute('calendar_pc_r = ''' || p_pc_info.calendar_name || '''');
852:
853: BEGIN
854: -- Add new Period Type to the dimension
855: dbms_aw.execute('MAINTAIN period_type_d ADD ''' || p_pc_info.period_type || '''');
856: EXCEPTION
857: WHEN OTHERS THEN
858: --DBMS_OUTPUT.put_line(SQLCODE);
859: -- Check for existing dim values, if it already exists during MAINTAIN, then ignore it.

Line 865: dbms_aw.execute('period_type_pc_r = ''' || p_pc_info.period_type || '''');

861: NULL;
862: END IF;
863: END;
864: -- Set the new Period Type
865: dbms_aw.execute('period_type_pc_r = ''' || p_pc_info.period_type || '''');
866:
867: BEGIN
868: -- Add new Calendar Period Type to the dimension
869: dbms_aw.execute('MAINTAIN cal_period_type_d ADD ''' || p_pc_info.calendar_name || '.' || p_pc_info.period_type || '''');

Line 869: dbms_aw.execute('MAINTAIN cal_period_type_d ADD ''' || p_pc_info.calendar_name || '.' || p_pc_info.period_type || '''');

865: dbms_aw.execute('period_type_pc_r = ''' || p_pc_info.period_type || '''');
866:
867: BEGIN
868: -- Add new Calendar Period Type to the dimension
869: dbms_aw.execute('MAINTAIN cal_period_type_d ADD ''' || p_pc_info.calendar_name || '.' || p_pc_info.period_type || '''');
870: EXCEPTION
871: WHEN OTHERS THEN
872: --DBMS_OUTPUT.put_line(SQLCODE);
873: -- Check for existing dim values, if it already exists during MAINTAIN, then ignore it.

Line 879: dbms_aw.execute('cal_period_type_pc_r = ''' || p_pc_info.calendar_name || '.' || p_pc_info.period_type || '''');

875: NULL;
876: END IF;
877: END;
878: -- Set the new Calendar Period Type
879: dbms_aw.execute('cal_period_type_pc_r = ''' || p_pc_info.calendar_name || '.' || p_pc_info.period_type || '''');
880:
881: dbms_aw.execute('pc_funding_period_from_m = ''' || p_pc_info.funding_period_from || '''');
882:
883: dbms_aw.execute('pc_funding_period_to_m = ''' || p_pc_info.funding_period_to || '''');

Line 881: dbms_aw.execute('pc_funding_period_from_m = ''' || p_pc_info.funding_period_from || '''');

877: END;
878: -- Set the new Calendar Period Type
879: dbms_aw.execute('cal_period_type_pc_r = ''' || p_pc_info.calendar_name || '.' || p_pc_info.period_type || '''');
880:
881: dbms_aw.execute('pc_funding_period_from_m = ''' || p_pc_info.funding_period_from || '''');
882:
883: dbms_aw.execute('pc_funding_period_to_m = ''' || p_pc_info.funding_period_to || '''');
884:
885: dbms_aw.execute('pc_effective_period_to_m = ''' || p_pc_info.effective_period_to || '''');

Line 883: dbms_aw.execute('pc_funding_period_to_m = ''' || p_pc_info.funding_period_to || '''');

879: dbms_aw.execute('cal_period_type_pc_r = ''' || p_pc_info.calendar_name || '.' || p_pc_info.period_type || '''');
880:
881: dbms_aw.execute('pc_funding_period_from_m = ''' || p_pc_info.funding_period_from || '''');
882:
883: dbms_aw.execute('pc_funding_period_to_m = ''' || p_pc_info.funding_period_to || '''');
884:
885: dbms_aw.execute('pc_effective_period_to_m = ''' || p_pc_info.effective_period_to || '''');
886:
887: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 885: dbms_aw.execute('pc_effective_period_to_m = ''' || p_pc_info.effective_period_to || '''');

881: dbms_aw.execute('pc_funding_period_from_m = ''' || p_pc_info.funding_period_from || '''');
882:
883: dbms_aw.execute('pc_funding_period_to_m = ''' || p_pc_info.funding_period_to || '''');
884:
885: dbms_aw.execute('pc_effective_period_to_m = ''' || p_pc_info.effective_period_to || '''');
886:
887: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
888: FND_LOG.String
889: (

Line 941: dbms_aw.execute('LMT planning_cycle_d TO ' || p_pc_info.planning_cycle );

937: --DBMS_OUTPUT.put_line('Before limiting planning_cycle_d to: ' || p_pc_info.planning_cycle );
938:
939: -- Update the Currency
940: -- Limit PCID
941: dbms_aw.execute('LMT planning_cycle_d TO ' || p_pc_info.planning_cycle );
942:
943: --DBMS_OUTPUT.put_line('Before setting Update_Pc_Currency ....');
944: -- Set the new Currency
945:

Line 946: dbms_aw.execute('pc_currency_m = ''' || p_pc_info.currency_code || '''');

942:
943: --DBMS_OUTPUT.put_line('Before setting Update_Pc_Currency ....');
944: -- Set the new Currency
945:
946: dbms_aw.execute('pc_currency_m = ''' || p_pc_info.currency_code || '''');
947:
948: dbms_aw.execute('pc_conversion_rate_type_m = ''' || p_pc_info.conversion_rate_type || '''');
949:
950: -- BEGIN

Line 948: dbms_aw.execute('pc_conversion_rate_type_m = ''' || p_pc_info.conversion_rate_type || '''');

944: -- Set the new Currency
945:
946: dbms_aw.execute('pc_currency_m = ''' || p_pc_info.currency_code || '''');
947:
948: dbms_aw.execute('pc_conversion_rate_type_m = ''' || p_pc_info.conversion_rate_type || '''');
949:
950: -- BEGIN
951: -- Add new Day to the dimension
952: -- dbms_aw.execute('MAINTAIN day_d ADD ''' || p_pc_info.conversion_rate_date || '''');

Line 952: -- dbms_aw.execute('MAINTAIN day_d ADD ''' || p_pc_info.conversion_rate_date || '''');

948: dbms_aw.execute('pc_conversion_rate_type_m = ''' || p_pc_info.conversion_rate_type || '''');
949:
950: -- BEGIN
951: -- Add new Day to the dimension
952: -- dbms_aw.execute('MAINTAIN day_d ADD ''' || p_pc_info.conversion_rate_date || '''');
953: -- EXCEPTION
954: -- WHEN OTHERS THEN
955: --DBMS_OUTPUT.put_line(SQLCODE);
956: -- Check for existing dim values, if it already exists during MAINTAIN, then ignore it.

Line 980: dbms_aw.execute('currency_date_pc_r = '''

976:
977: --Bug 4254274 : Applying to_date function on variable of type character i.e p_pc_info.conversion_rate_date
978: -- was raising error 'literal does not match format string'
979:
980: dbms_aw.execute('currency_date_pc_r = '''
981: || to_char(fnd_date.chardate_to_date(p_pc_info.conversion_rate_date), 'DDMONYYYY' || ''''));
982:
983: /*dbms_aw.execute('currency_date_pc_r = '''
984: || to_char(to_date(p_pc_info.conversion_rate_date,

Line 983: /*dbms_aw.execute('currency_date_pc_r = '''

979:
980: dbms_aw.execute('currency_date_pc_r = '''
981: || to_char(fnd_date.chardate_to_date(p_pc_info.conversion_rate_date), 'DDMONYYYY' || ''''));
982:
983: /*dbms_aw.execute('currency_date_pc_r = '''
984: || to_char(to_date(p_pc_info.conversion_rate_date,
985: 'DD-MON-YYYY'), 'DDMONYYYY' || ''''));*/
986: else
987: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 998: dbms_aw.execute('currency_date_pc_r = '''

994:
995: --Bug 4254274 : Applying hard coded format for to_date function on sysdate which is in nls_date_format
996: -- was raising error 'literal does not match format string'
997:
998: dbms_aw.execute('currency_date_pc_r = '''
999: || to_char(sysdate,'DDMONYYYY' || ''''));
1000:
1001: /*dbms_aw.execute('currency_date_pc_r = '''
1002: || to_char(to_date(sysdate,

Line 1001: /*dbms_aw.execute('currency_date_pc_r = '''

997:
998: dbms_aw.execute('currency_date_pc_r = '''
999: || to_char(sysdate,'DDMONYYYY' || ''''));
1000:
1001: /*dbms_aw.execute('currency_date_pc_r = '''
1002: || to_char(to_date(sysdate,
1003: 'DD-MON-YYYY'), 'DDMONYYYY' || ''''));*/
1004: end if;
1005:

Line 1062: dbms_aw.execute('LMT planning_cycle_d TO ' || p_pc_info.planning_cycle );

1058: --DBMS_OUTPUT.put_line('Before limiting planning_cycle_d to: ' || p_pc_info.planning_cycle );
1059:
1060: -- Update the Currency
1061: -- Limit PCID
1062: dbms_aw.execute('LMT planning_cycle_d TO ' || p_pc_info.planning_cycle );
1063:
1064: --DBMS_OUTPUT.put_line('Before setting submission_due_date ....');
1065:
1066: BEGIN

Line 1068: dbms_aw.execute('MAINTAIN day_d ADD ''' || p_pc_info.submission_due_date || '''');

1064: --DBMS_OUTPUT.put_line('Before setting submission_due_date ....');
1065:
1066: BEGIN
1067: -- Add new Day to the dimension
1068: dbms_aw.execute('MAINTAIN day_d ADD ''' || p_pc_info.submission_due_date || '''');
1069: EXCEPTION
1070: WHEN OTHERS THEN
1071: --DBMS_OUTPUT.put_line(SQLCODE);
1072: -- Check for existing dim values, if it already exists during MAINTAIN, then ignore it.

Line 1084: dbms_aw.execute('pc_submission_due_date_r = '''

1080:
1081: --Bug 4254274 : Applying to_date function on variable of type character i.e p_pc_info.submission_due_date
1082: -- was raising error 'literal does not match format string'
1083:
1084: dbms_aw.execute('pc_submission_due_date_r = '''
1085: || to_char(fnd_date.chardate_to_date(p_pc_info.submission_due_date), 'DDMONYYYY' || ''''));
1086:
1087: /*dbms_aw.execute('pc_submission_due_date_r = '''
1088: || to_char(to_date(p_pc_info.submission_due_date,

Line 1087: /*dbms_aw.execute('pc_submission_due_date_r = '''

1083:
1084: dbms_aw.execute('pc_submission_due_date_r = '''
1085: || to_char(fnd_date.chardate_to_date(p_pc_info.submission_due_date), 'DDMONYYYY' || ''''));
1086:
1087: /*dbms_aw.execute('pc_submission_due_date_r = '''
1088: || to_char(to_date(p_pc_info.submission_due_date,
1089: 'DD-MON-YYYY'), 'DDMONYYYY' || ''''));*/
1090:
1091: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 1149: dbms_aw.execute('LMT planning_cycle_d TO ' || p_disc_funds.planning_cycle);

1145: --DBMS_OUTPUT.put_line('Before limiting planning_cycle_d to: ' || p_disc_funds.planning_cycle );
1146:
1147: -- Update the Discount
1148: -- Limit PCID
1149: dbms_aw.execute('LMT planning_cycle_d TO ' || p_disc_funds.planning_cycle);
1150:
1151: --DBMS_OUTPUT.put_line('Before setting pc_discount_rate ....'|| p_disc_funds.pc_discount_rate);
1152: -- Set the new pc_discount_rate
1153: dbms_aw.execute('pc_discount_rate_m = ' || p_disc_funds.pc_discount_rate/100);

Line 1153: dbms_aw.execute('pc_discount_rate_m = ' || p_disc_funds.pc_discount_rate/100);

1149: dbms_aw.execute('LMT planning_cycle_d TO ' || p_disc_funds.planning_cycle);
1150:
1151: --DBMS_OUTPUT.put_line('Before setting pc_discount_rate ....'|| p_disc_funds.pc_discount_rate);
1152: -- Set the new pc_discount_rate
1153: dbms_aw.execute('pc_discount_rate_m = ' || p_disc_funds.pc_discount_rate/100);
1154:
1155: --DBMS_OUTPUT.put_line('Before setting pc funding....' || p_disc_funds.pc_funding);
1156:
1157: -- Set the new funds

Line 1158: dbms_aw.execute('pc_funding_m = ' || p_disc_funds.pc_funding );

1154:
1155: --DBMS_OUTPUT.put_line('Before setting pc funding....' || p_disc_funds.pc_funding);
1156:
1157: -- Set the new funds
1158: dbms_aw.execute('pc_funding_m = ' || p_disc_funds.pc_funding );
1159:
1160: --DBMS_OUTPUT.put_line('Before setting factor_d and factor_pc_r....' || p_disc_funds.pc_display_factor);
1161:
1162: dbms_aw.execute('factor_pc_r = ''' || p_disc_funds.pc_display_factor || '''' );

Line 1162: dbms_aw.execute('factor_pc_r = ''' || p_disc_funds.pc_display_factor || '''' );

1158: dbms_aw.execute('pc_funding_m = ' || p_disc_funds.pc_funding );
1159:
1160: --DBMS_OUTPUT.put_line('Before setting factor_d and factor_pc_r....' || p_disc_funds.pc_display_factor);
1161:
1162: dbms_aw.execute('factor_pc_r = ''' || p_disc_funds.pc_display_factor || '''' );
1163:
1164:
1165: --DBMS_OUTPUT.put_line('Outside IF p_disc_funds IS NOT NULL .... ');
1166:

Line 1522: dbms_aw.execute('call SET_PC_INVEST_CRITERIA_PRG(' || p_pc_id || ')');

1518: 'Calling AW Program SET_PC_INVEST_CRITERIA_PRG.'
1519: );
1520: END IF;
1521:
1522: dbms_aw.execute('call SET_PC_INVEST_CRITERIA_PRG(' || p_pc_id || ')');
1523:
1524: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1525: fnd_log.string
1526: (

Line 1584: dbms_aw.execute('push planning_cycle_d');

1580: 'Limiting to passed PC id'
1581: );
1582: END IF;
1583:
1584: dbms_aw.execute('push planning_cycle_d');
1585: dbms_aw.execute('push portfolio_d');
1586: dbms_aw.execute('oknullstatus = y');
1587: dbms_aw.execute('limit planning_cycle_d to ' || p_pc_id);
1588:

Line 1585: dbms_aw.execute('push portfolio_d');

1581: );
1582: END IF;
1583:
1584: dbms_aw.execute('push planning_cycle_d');
1585: dbms_aw.execute('push portfolio_d');
1586: dbms_aw.execute('oknullstatus = y');
1587: dbms_aw.execute('limit planning_cycle_d to ' || p_pc_id);
1588:
1589: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 1586: dbms_aw.execute('oknullstatus = y');

1582: END IF;
1583:
1584: dbms_aw.execute('push planning_cycle_d');
1585: dbms_aw.execute('push portfolio_d');
1586: dbms_aw.execute('oknullstatus = y');
1587: dbms_aw.execute('limit planning_cycle_d to ' || p_pc_id);
1588:
1589: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1590: FND_LOG.String

Line 1587: dbms_aw.execute('limit planning_cycle_d to ' || p_pc_id);

1583:
1584: dbms_aw.execute('push planning_cycle_d');
1585: dbms_aw.execute('push portfolio_d');
1586: dbms_aw.execute('oknullstatus = y');
1587: dbms_aw.execute('limit planning_cycle_d to ' || p_pc_id);
1588:
1589: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1590: FND_LOG.String
1591: (

Line 1597: dbms_aw.execute('limit portfolio_d to portfolio_pc_r');

1593: 'fpa.sql.FPA_PlanningCycle_Pvt.Set_Pc_Approved_Flag',
1594: 'Limiting to portfolio for passed PC id'
1595: );
1596: END IF;
1597: dbms_aw.execute('limit portfolio_d to portfolio_pc_r');
1598:
1599: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1600: FND_LOG.String
1601: (

Line 1607: dbms_aw.execute('limit planning_cycle_d to portfolio_d');

1603: 'fpa.sql.FPA_PlanningCycle_Pvt.Set_Pc_Approved_Flag',
1604: 'Limiting to planning cycles for the same portfolio'
1605: );
1606: END IF;
1607: dbms_aw.execute('limit planning_cycle_d to portfolio_d');
1608:
1609: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1610: FND_LOG.String
1611: (

Line 1617: dbms_aw.execute('pc_last_approved_flag_m = na');

1613: 'fpa.sql.FPA_PlanningCycle_Pvt.Set_Pc_Approved_Flag',
1614: 'Reset last approved flag'
1615: );
1616: END IF;
1617: dbms_aw.execute('pc_last_approved_flag_m = na');
1618:
1619: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1620: FND_LOG.String
1621: (

Line 1627: dbms_aw.execute('limit planning_cycle_d to ' || p_pc_id);

1623: 'fpa.sql.FPA_PlanningCycle_Pvt.Set_Pc_Approved_Flag',
1624: 'Setting last approved flag to passed pc ID'
1625: );
1626: END IF;
1627: dbms_aw.execute('limit planning_cycle_d to ' || p_pc_id);
1628: dbms_aw.execute('pc_last_approved_flag_m = yes');
1629: dbms_aw.execute('pop planning_cycle_d');
1630: dbms_aw.execute('pop portfolio_d');
1631:

Line 1628: dbms_aw.execute('pc_last_approved_flag_m = yes');

1624: 'Setting last approved flag to passed pc ID'
1625: );
1626: END IF;
1627: dbms_aw.execute('limit planning_cycle_d to ' || p_pc_id);
1628: dbms_aw.execute('pc_last_approved_flag_m = yes');
1629: dbms_aw.execute('pop planning_cycle_d');
1630: dbms_aw.execute('pop portfolio_d');
1631:
1632: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 1629: dbms_aw.execute('pop planning_cycle_d');

1625: );
1626: END IF;
1627: dbms_aw.execute('limit planning_cycle_d to ' || p_pc_id);
1628: dbms_aw.execute('pc_last_approved_flag_m = yes');
1629: dbms_aw.execute('pop planning_cycle_d');
1630: dbms_aw.execute('pop portfolio_d');
1631:
1632: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1633: FND_LOG.String

Line 1630: dbms_aw.execute('pop portfolio_d');

1626: END IF;
1627: dbms_aw.execute('limit planning_cycle_d to ' || p_pc_id);
1628: dbms_aw.execute('pc_last_approved_flag_m = yes');
1629: dbms_aw.execute('pop planning_cycle_d');
1630: dbms_aw.execute('pop portfolio_d');
1631:
1632: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1633: FND_LOG.String
1634: (

Line 1692: dbms_aw.execute('push planning_cycle_d');

1688: 'Limiting to passed PC id'
1689: );
1690: END IF;
1691:
1692: dbms_aw.execute('push planning_cycle_d');
1693: dbms_aw.execute('push portfolio_d');
1694: dbms_aw.execute('oknullstatus = y');
1695: dbms_aw.execute('limit planning_cycle_d to ' || p_pc_id);
1696:

Line 1693: dbms_aw.execute('push portfolio_d');

1689: );
1690: END IF;
1691:
1692: dbms_aw.execute('push planning_cycle_d');
1693: dbms_aw.execute('push portfolio_d');
1694: dbms_aw.execute('oknullstatus = y');
1695: dbms_aw.execute('limit planning_cycle_d to ' || p_pc_id);
1696:
1697: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 1694: dbms_aw.execute('oknullstatus = y');

1690: END IF;
1691:
1692: dbms_aw.execute('push planning_cycle_d');
1693: dbms_aw.execute('push portfolio_d');
1694: dbms_aw.execute('oknullstatus = y');
1695: dbms_aw.execute('limit planning_cycle_d to ' || p_pc_id);
1696:
1697: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1698: FND_LOG.String

Line 1695: dbms_aw.execute('limit planning_cycle_d to ' || p_pc_id);

1691:
1692: dbms_aw.execute('push planning_cycle_d');
1693: dbms_aw.execute('push portfolio_d');
1694: dbms_aw.execute('oknullstatus = y');
1695: dbms_aw.execute('limit planning_cycle_d to ' || p_pc_id);
1696:
1697: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1698: FND_LOG.String
1699: (

Line 1705: dbms_aw.execute('limit portfolio_d to portfolio_pc_r');

1701: 'fpa.sql.FPA_PlanningCycle_Pvt.Set_Pc_Last_Flag',
1702: 'Limiting to portfolio for passed PC id'
1703: );
1704: END IF;
1705: dbms_aw.execute('limit portfolio_d to portfolio_pc_r');
1706:
1707: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1708: FND_LOG.String
1709: (

Line 1715: dbms_aw.execute('limit planning_cycle_d to portfolio_d');

1711: 'fpa.sql.FPA_PlanningCycle_Pvt.Set_Pc_Last_Flag',
1712: 'Limiting to planning cycles for the same portfolio'
1713: );
1714: END IF;
1715: dbms_aw.execute('limit planning_cycle_d to portfolio_d');
1716:
1717: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1718: FND_LOG.String
1719: (

Line 1725: dbms_aw.execute('pc_last_flag_m = na');

1721: 'fpa.sql.FPA_PlanningCycle_Pvt.Set_Pc_Last_Flag',
1722: 'Reset last approved flag'
1723: );
1724: END IF;
1725: dbms_aw.execute('pc_last_flag_m = na');
1726:
1727: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1728: FND_LOG.String
1729: (

Line 1735: dbms_aw.execute('limit planning_cycle_d to ' || p_pc_id);

1731: 'fpa.sql.FPA_PlanningCycle_Pvt.Set_Pc_Last_Flag',
1732: 'Setting last approved flag to passed pc ID'
1733: );
1734: END IF;
1735: dbms_aw.execute('limit planning_cycle_d to ' || p_pc_id);
1736: dbms_aw.execute('pc_last_flag_m = yes');
1737: dbms_aw.execute('pop planning_cycle_d');
1738: dbms_aw.execute('pop portfolio_d');
1739:

Line 1736: dbms_aw.execute('pc_last_flag_m = yes');

1732: 'Setting last approved flag to passed pc ID'
1733: );
1734: END IF;
1735: dbms_aw.execute('limit planning_cycle_d to ' || p_pc_id);
1736: dbms_aw.execute('pc_last_flag_m = yes');
1737: dbms_aw.execute('pop planning_cycle_d');
1738: dbms_aw.execute('pop portfolio_d');
1739:
1740: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 1737: dbms_aw.execute('pop planning_cycle_d');

1733: );
1734: END IF;
1735: dbms_aw.execute('limit planning_cycle_d to ' || p_pc_id);
1736: dbms_aw.execute('pc_last_flag_m = yes');
1737: dbms_aw.execute('pop planning_cycle_d');
1738: dbms_aw.execute('pop portfolio_d');
1739:
1740: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1741: FND_LOG.String

Line 1738: dbms_aw.execute('pop portfolio_d');

1734: END IF;
1735: dbms_aw.execute('limit planning_cycle_d to ' || p_pc_id);
1736: dbms_aw.execute('pc_last_flag_m = yes');
1737: dbms_aw.execute('pop planning_cycle_d');
1738: dbms_aw.execute('pop portfolio_d');
1739:
1740: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1741: FND_LOG.String
1742: (

Line 1814: dbms_aw.execute('lmt planning_cycle_d to ' || p_pc_id);

1810: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Annual_Disc_Rates.',
1811: 'Updating Annual discount rates for the PC in AW.');
1812: END IF;
1813:
1814: dbms_aw.execute('lmt planning_cycle_d to ' || p_pc_id);
1815: dbms_aw.execute('lmt time_d to ''' || p_period || '''');
1816: dbms_aw.execute('pc_discount_rate_t_m = ' || p_rate);
1817:
1818: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 1815: dbms_aw.execute('lmt time_d to ''' || p_period || '''');

1811: 'Updating Annual discount rates for the PC in AW.');
1812: END IF;
1813:
1814: dbms_aw.execute('lmt planning_cycle_d to ' || p_pc_id);
1815: dbms_aw.execute('lmt time_d to ''' || p_period || '''');
1816: dbms_aw.execute('pc_discount_rate_t_m = ' || p_rate);
1817:
1818: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1819: FND_LOG.String

Line 1816: dbms_aw.execute('pc_discount_rate_t_m = ' || p_rate);

1812: END IF;
1813:
1814: dbms_aw.execute('lmt planning_cycle_d to ' || p_pc_id);
1815: dbms_aw.execute('lmt time_d to ''' || p_period || '''');
1816: dbms_aw.execute('pc_discount_rate_t_m = ' || p_rate);
1817:
1818: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1819: FND_LOG.String
1820: (FND_LOG.LEVEL_PROCEDURE,