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 302: dbms_aw.execute('LMT planning_cycle_d TO ' || p_fin_targets_tbl(1).planning_cycle );

298: WHERE PARAMETER = 'NLS_NUMERIC_CHARACTERS';
299:
300: -- Update the financial targets
301: -- Limit PCID
302: dbms_aw.execute('LMT planning_cycle_d TO ' || p_fin_targets_tbl(1).planning_cycle );
303:
304: FOR i IN p_fin_targets_tbl.FIRST..p_fin_targets_tbl.LAST
305: LOOP
306: --DBMS_OUTPUT.put_line(' ..Inside For loop...p_fin_targets_tbl(i).financial_target_from=' || p_fin_targets_tbl(i).financial_target_from );

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

324: -- Limit financial_metrics_d
325: l_financial_target_from_c := REPLACE( To_Char(p_fin_targets_tbl(i).financial_target_from*l_pc_disply_factor), l_decimal_marker,'.');
326: l_financial_target_to_c := REPLACE( To_Char(p_fin_targets_tbl(i).financial_target_to*l_pc_disply_factor), l_decimal_marker,'.');
327:
328: dbms_aw.execute('LMT financial_metrics_d TO ''' || p_fin_targets_tbl(i).financial_metrics || '''' );
329: -- Set the targets from for each fin matric
330: --dbms_aw.execute('pc_fintargets_range_from_m = ' || p_fin_targets_tbl(i).financial_target_from*l_pc_disply_factor );
331: dbms_aw.execute('pc_fintargets_range_from_m = ' || l_financial_target_from_c );
332: -- Set the targets to for each fin matric

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

326: l_financial_target_to_c := REPLACE( To_Char(p_fin_targets_tbl(i).financial_target_to*l_pc_disply_factor), l_decimal_marker,'.');
327:
328: dbms_aw.execute('LMT financial_metrics_d TO ''' || p_fin_targets_tbl(i).financial_metrics || '''' );
329: -- Set the targets from for each fin matric
330: --dbms_aw.execute('pc_fintargets_range_from_m = ' || p_fin_targets_tbl(i).financial_target_from*l_pc_disply_factor );
331: dbms_aw.execute('pc_fintargets_range_from_m = ' || l_financial_target_from_c );
332: -- Set the targets to for each fin matric
333: --dbms_aw.execute('pc_fintargets_range_to_m = ' || p_fin_targets_tbl(i).financial_target_to*l_pc_disply_factor );
334: dbms_aw.execute('pc_fintargets_range_to_m = ' || l_financial_target_to_c );

Line 331: dbms_aw.execute('pc_fintargets_range_from_m = ' || l_financial_target_from_c );

327:
328: dbms_aw.execute('LMT financial_metrics_d TO ''' || p_fin_targets_tbl(i).financial_metrics || '''' );
329: -- Set the targets from for each fin matric
330: --dbms_aw.execute('pc_fintargets_range_from_m = ' || p_fin_targets_tbl(i).financial_target_from*l_pc_disply_factor );
331: dbms_aw.execute('pc_fintargets_range_from_m = ' || l_financial_target_from_c );
332: -- Set the targets to for each fin matric
333: --dbms_aw.execute('pc_fintargets_range_to_m = ' || p_fin_targets_tbl(i).financial_target_to*l_pc_disply_factor );
334: dbms_aw.execute('pc_fintargets_range_to_m = ' || l_financial_target_to_c );
335: END LOOP;

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

329: -- Set the targets from for each fin matric
330: --dbms_aw.execute('pc_fintargets_range_from_m = ' || p_fin_targets_tbl(i).financial_target_from*l_pc_disply_factor );
331: dbms_aw.execute('pc_fintargets_range_from_m = ' || l_financial_target_from_c );
332: -- Set the targets to for each fin matric
333: --dbms_aw.execute('pc_fintargets_range_to_m = ' || p_fin_targets_tbl(i).financial_target_to*l_pc_disply_factor );
334: dbms_aw.execute('pc_fintargets_range_to_m = ' || l_financial_target_to_c );
335: END LOOP;
336:
337:

Line 334: dbms_aw.execute('pc_fintargets_range_to_m = ' || l_financial_target_to_c );

330: --dbms_aw.execute('pc_fintargets_range_from_m = ' || p_fin_targets_tbl(i).financial_target_from*l_pc_disply_factor );
331: dbms_aw.execute('pc_fintargets_range_from_m = ' || l_financial_target_from_c );
332: -- Set the targets to for each fin matric
333: --dbms_aw.execute('pc_fintargets_range_to_m = ' || p_fin_targets_tbl(i).financial_target_to*l_pc_disply_factor );
334: dbms_aw.execute('pc_fintargets_range_to_m = ' || l_financial_target_to_c );
335: END LOOP;
336:
337:
338: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

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

404: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Inv_Criteria_Data',
405: 'Limit pc dimension to ' || p_inv_crit_tbl(1).planning_cycle || ' value.'
406: );
407: END IF;
408: dbms_aw.execute('LMT planning_cycle_d TO ' || p_inv_crit_tbl(1).planning_cycle);
409:
410: -- Set the score source
411: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
412: FND_LOG.String

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

414: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Inv_Criteria_Data',
415: 'Setting score_type_pc_r to: ' || p_inv_crit_tbl(1).pc_project_score_source || ' value.'
416: );
417: END IF;
418: dbms_aw.execute('score_type_pc_r = ''' || p_inv_crit_tbl(1).pc_project_score_source || '''');
419:
420: -- Set the score scale
421: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
422: FND_LOG.String

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

424: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Inv_Criteria_Data',
425: 'Setting pc_project_score_scale_m to: ' || p_inv_crit_tbl(1).pc_project_score_scale || ' value.'
426: );
427: END IF;
428: dbms_aw.execute('pc_project_score_scale_m = ' || p_inv_crit_tbl(1).pc_project_score_scale );
429:
430:
431: FOR i IN p_inv_crit_tbl.FIRST..p_inv_crit_tbl.LAST
432: LOOP

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

447: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Inv_Criteria_Data',
448: 'Limit strategic_obj_d dimension to ' || p_inv_crit_tbl(i).investment_criteria || ' value.'
449: );
450: END IF;
451: dbms_aw.execute('LMT strategic_obj_d TO ' || p_inv_crit_tbl(i).investment_criteria );
452:
453: --DBMS_OUTPUT.put_line(' ..Inside For loop...after setting p_inv_crit_tbl(i).investment_criteria' );
454:
455: -- Set the weights for each strategic_obj

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

459: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Inv_Criteria_Data',
460: 'Setting pc_strategic_obj_weights_m: ' || p_inv_crit_tbl(i).pc_inv_criteria_weight || ' value.'
461: );
462: END IF;
463: dbms_aw.execute('pc_strategic_obj_weights_m = ' || p_inv_crit_tbl(i).pc_inv_criteria_weight );
464:
465: --DBMS_OUTPUT.put_line(' ..Inside For loop...after setting p_inv_crit_tbl(i).pc_inv_criteria_weight' );
466:
467: -- Set the target from for each strategic_obj

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

475:
476: -- If the target_from value from UI is null, update it in AW with NA
477:
478: IF p_inv_crit_tbl(i).pc_inv_crit_score_target_from IS NULL THEN
479: dbms_aw.execute('pc_obj_wscore_targets_from_m = NA');
480: ELSE
481: dbms_aw.execute('pc_obj_wscore_targets_from_m = ' || p_inv_crit_tbl(i).pc_inv_crit_score_target_from );
482: END IF;
483:

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

477:
478: IF p_inv_crit_tbl(i).pc_inv_crit_score_target_from IS NULL THEN
479: dbms_aw.execute('pc_obj_wscore_targets_from_m = NA');
480: ELSE
481: dbms_aw.execute('pc_obj_wscore_targets_from_m = ' || p_inv_crit_tbl(i).pc_inv_crit_score_target_from );
482: END IF;
483:
484: --DBMS_OUTPUT.put_line(' ..Inside For loop...after setting p_inv_crit_tbl(i).pc_inv_crit_score_target_from' );
485:

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

493: END IF;
494: -- If the target_to value from UI is null, update it in AW with NA
495:
496: IF p_inv_crit_tbl(i).pc_inv_crit_score_target_to IS NULL THEN
497: dbms_aw.execute('pc_obj_wscore_targets_to_m = NA');
498: ELSE
499: dbms_aw.execute('pc_obj_wscore_targets_to_m = ' || p_inv_crit_tbl(i).pc_inv_crit_score_target_to );
500: END IF;
501: --DBMS_OUTPUT.put_line(' ..Inside For loop...after setting p_inv_crit_tbl(i).pc_inv_crit_score_target_to' );

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

495:
496: IF p_inv_crit_tbl(i).pc_inv_crit_score_target_to IS NULL THEN
497: dbms_aw.execute('pc_obj_wscore_targets_to_m = NA');
498: ELSE
499: dbms_aw.execute('pc_obj_wscore_targets_to_m = ' || p_inv_crit_tbl(i).pc_inv_crit_score_target_to );
500: END IF;
501: --DBMS_OUTPUT.put_line(' ..Inside For loop...after setting p_inv_crit_tbl(i).pc_inv_crit_score_target_to' );
502:
503: END LOOP;

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

509: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Inv_Criteria_Data',
510: 'Calling AW program: set_pc_invest_criteria_prg( ' || p_inv_crit_tbl(1).planning_cycle || ').'
511: );
512: END IF;
513: dbms_aw.execute('call set_pc_invest_criteria_prg(' || p_inv_crit_tbl(1).planning_cycle || ')');
514: */
515:
516:
517: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

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

635: END IF;
636: --DBMS_OUTPUT.put_line('Before limiting planning_cycle_d to: ' || p_pc_id );
637:
638: -- Update the status
639: dbms_aw.execute('LMT planning_cycle_d TO ' || p_pc_id );
640:
641: --DBMS_OUTPUT.put_line('Before setting status_pc_r ....');
642: -- Set the new staus
643: dbms_aw.execute('status_pc_r = ''' || p_pc_status_code || '''');

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

639: dbms_aw.execute('LMT planning_cycle_d TO ' || p_pc_id );
640:
641: --DBMS_OUTPUT.put_line('Before setting status_pc_r ....');
642: -- Set the new staus
643: dbms_aw.execute('status_pc_r = ''' || p_pc_status_code || '''');
644:
645:
646: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
647: FND_LOG.String

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

695: END IF;
696: --DBMS_OUTPUT.put_line('Before limiting planning_cycle_d to: ' || p_pc_id );
697:
698: -- Limit the PC ID
699: dbms_aw.execute('LMT planning_cycle_d TO ' || p_pc_id );
700:
701: -- Set the new Initiate Date
702:
703: BEGIN

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

701: -- Set the new Initiate Date
702:
703: BEGIN
704: -- Add new Day to the Day_d dimension
705: /* dbms_aw.execute('MAINTAIN day_d ADD '''
706: || to_char(to_date(p_pc_init_date, 'DD-MON-YYYY'), 'DDMONYYYY' || ''''));
707: */
708: dbms_aw.execute('MAINTAIN day_d ADD ''' || to_char(SYSDATE, 'MMDDYYYY') || '''' ); -- Bug 9264707
709: EXCEPTION

Line 708: dbms_aw.execute('MAINTAIN day_d ADD ''' || to_char(SYSDATE, 'MMDDYYYY') || '''' ); -- Bug 9264707

704: -- Add new Day to the Day_d dimension
705: /* dbms_aw.execute('MAINTAIN day_d ADD '''
706: || to_char(to_date(p_pc_init_date, 'DD-MON-YYYY'), 'DDMONYYYY' || ''''));
707: */
708: dbms_aw.execute('MAINTAIN day_d ADD ''' || to_char(SYSDATE, 'MMDDYYYY') || '''' ); -- Bug 9264707
709: EXCEPTION
710: WHEN OTHERS THEN
711: --DBMS_OUTPUT.put_line(SQLCODE);
712: -- Check for existing dim values, if it already exists during MAINTAIN, then ignore it.

Line 722: dbms_aw.execute('pc_initiate_date_r = ''' || to_char(SYSDATE, 'MMDDYYYY') || ''''); -- Bug 9264707

718: --DBMS_OUTPUT.PUT_LINE('....pc_initiate_date:' || SYSDATE);
719:
720:
721:
722: dbms_aw.execute('pc_initiate_date_r = ''' || to_char(SYSDATE, 'MMDDYYYY') || ''''); -- Bug 9264707
723:
724: /*
725: dbms_aw.execute('pc_initiate_date_r = '''
726: || to_char(to_date(p_pc_init_date, 'DD-MON-YYYY'), 'DDMONYYYY' || ''''));

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

721:
722: dbms_aw.execute('pc_initiate_date_r = ''' || to_char(SYSDATE, 'MMDDYYYY') || ''''); -- Bug 9264707
723:
724: /*
725: dbms_aw.execute('pc_initiate_date_r = '''
726: || to_char(to_date(p_pc_init_date, 'DD-MON-YYYY'), 'DDMONYYYY' || ''''));
727: */
728:
729: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

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

782: --DBMS_OUTPUT.put_line('Before limiting planning_cycle_d to: ' || p_pc_id );
783:
784: -- Update the Basic Info
785: -- Limit PCID
786: dbms_aw.execute('LMT planning_cycle_d TO ' || p_pc_id );
787:
788: --DBMS_OUTPUT.put_line('Before setting pc_class_code_m ....');
789: -- Set the new class category
790: dbms_aw.execute('pc_category_m = ''' || p_catg_id || '''');

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

786: dbms_aw.execute('LMT planning_cycle_d TO ' || p_pc_id );
787:
788: --DBMS_OUTPUT.put_line('Before setting pc_class_code_m ....');
789: -- Set the new class category
790: dbms_aw.execute('pc_category_m = ''' || p_catg_id || '''');
791:
792: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
793: FND_LOG.String
794: (

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

843: --DBMS_OUTPUT.put_line('Before limiting planning_cycle_d to: ' || p_pc_info.planning_cycle );
844:
845: -- Update the Calendar
846: -- Limit PCID
847: dbms_aw.execute('LMT planning_cycle_d TO ' || p_pc_info.planning_cycle );
848:
849: --DBMS_OUTPUT.put_line('Before setting Update_Pc_Calendar ....');
850: BEGIN
851: -- Add new calendar to the dimension

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

848:
849: --DBMS_OUTPUT.put_line('Before setting Update_Pc_Calendar ....');
850: BEGIN
851: -- Add new calendar to the dimension
852: dbms_aw.execute('MAINTAIN calendar_d ADD ''' || p_pc_info.calendar_name || '''');
853: EXCEPTION
854: WHEN OTHERS THEN
855: --DBMS_OUTPUT.put_line(SQLCODE);
856: -- Check for existing dim values, if it already exists during MAINTAIN, then ignore it.

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

858: NULL;
859: END IF;
860: END;
861: -- Set the new calendar
862: dbms_aw.execute('calendar_pc_r = ''' || p_pc_info.calendar_name || '''');
863:
864: BEGIN
865: -- Add new Period Type to the dimension
866: dbms_aw.execute('MAINTAIN period_type_d ADD ''' || p_pc_info.period_type || '''');

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

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

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

872: NULL;
873: END IF;
874: END;
875: -- Set the new Period Type
876: dbms_aw.execute('period_type_pc_r = ''' || p_pc_info.period_type || '''');
877:
878: BEGIN
879: -- Add new Calendar Period Type to the dimension
880: dbms_aw.execute('MAINTAIN cal_period_type_d ADD ''' || p_pc_info.calendar_name || '.' || p_pc_info.period_type || '''');

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

876: dbms_aw.execute('period_type_pc_r = ''' || p_pc_info.period_type || '''');
877:
878: BEGIN
879: -- Add new Calendar Period Type to the dimension
880: dbms_aw.execute('MAINTAIN cal_period_type_d ADD ''' || p_pc_info.calendar_name || '.' || p_pc_info.period_type || '''');
881: EXCEPTION
882: WHEN OTHERS THEN
883: --DBMS_OUTPUT.put_line(SQLCODE);
884: -- Check for existing dim values, if it already exists during MAINTAIN, then ignore it.

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

886: NULL;
887: END IF;
888: END;
889: -- Set the new Calendar Period Type
890: dbms_aw.execute('cal_period_type_pc_r = ''' || p_pc_info.calendar_name || '.' || p_pc_info.period_type || '''');
891:
892: dbms_aw.execute('pc_funding_period_from_m = ''' || p_pc_info.funding_period_from || '''');
893:
894: dbms_aw.execute('pc_funding_period_to_m = ''' || p_pc_info.funding_period_to || '''');

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

888: END;
889: -- Set the new Calendar Period Type
890: dbms_aw.execute('cal_period_type_pc_r = ''' || p_pc_info.calendar_name || '.' || p_pc_info.period_type || '''');
891:
892: dbms_aw.execute('pc_funding_period_from_m = ''' || p_pc_info.funding_period_from || '''');
893:
894: dbms_aw.execute('pc_funding_period_to_m = ''' || p_pc_info.funding_period_to || '''');
895:
896: dbms_aw.execute('pc_effective_period_to_m = ''' || p_pc_info.effective_period_to || '''');

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

890: dbms_aw.execute('cal_period_type_pc_r = ''' || p_pc_info.calendar_name || '.' || p_pc_info.period_type || '''');
891:
892: dbms_aw.execute('pc_funding_period_from_m = ''' || p_pc_info.funding_period_from || '''');
893:
894: dbms_aw.execute('pc_funding_period_to_m = ''' || p_pc_info.funding_period_to || '''');
895:
896: dbms_aw.execute('pc_effective_period_to_m = ''' || p_pc_info.effective_period_to || '''');
897:
898: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

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

892: dbms_aw.execute('pc_funding_period_from_m = ''' || p_pc_info.funding_period_from || '''');
893:
894: dbms_aw.execute('pc_funding_period_to_m = ''' || p_pc_info.funding_period_to || '''');
895:
896: dbms_aw.execute('pc_effective_period_to_m = ''' || p_pc_info.effective_period_to || '''');
897:
898: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
899: FND_LOG.String
900: (

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

948: --DBMS_OUTPUT.put_line('Before limiting planning_cycle_d to: ' || p_pc_info.planning_cycle );
949:
950: -- Update the Currency
951: -- Limit PCID
952: dbms_aw.execute('LMT planning_cycle_d TO ' || p_pc_info.planning_cycle );
953:
954: --DBMS_OUTPUT.put_line('Before setting Update_Pc_Currency ....');
955: -- Set the new Currency
956:

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

953:
954: --DBMS_OUTPUT.put_line('Before setting Update_Pc_Currency ....');
955: -- Set the new Currency
956:
957: dbms_aw.execute('pc_currency_m = ''' || p_pc_info.currency_code || '''');
958:
959: dbms_aw.execute('pc_conversion_rate_type_m = ''' || p_pc_info.conversion_rate_type || '''');
960:
961: -- BEGIN

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

955: -- Set the new Currency
956:
957: dbms_aw.execute('pc_currency_m = ''' || p_pc_info.currency_code || '''');
958:
959: dbms_aw.execute('pc_conversion_rate_type_m = ''' || p_pc_info.conversion_rate_type || '''');
960:
961: -- BEGIN
962: -- Add new Day to the dimension
963: -- dbms_aw.execute('MAINTAIN day_d ADD ''' || p_pc_info.conversion_rate_date || '''');

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

959: dbms_aw.execute('pc_conversion_rate_type_m = ''' || p_pc_info.conversion_rate_type || '''');
960:
961: -- BEGIN
962: -- Add new Day to the dimension
963: -- dbms_aw.execute('MAINTAIN day_d ADD ''' || p_pc_info.conversion_rate_date || '''');
964: -- EXCEPTION
965: -- WHEN OTHERS THEN
966: --DBMS_OUTPUT.put_line(SQLCODE);
967: -- Check for existing dim values, if it already exists during MAINTAIN, then ignore it.

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

987:
988: --Bug 4254274 : Applying to_date function on variable of type character i.e p_pc_info.conversion_rate_date
989: -- was raising error 'literal does not match format string'
990:
991: dbms_aw.execute('currency_date_pc_r = '''
992: || to_char(fnd_date.chardate_to_date(p_pc_info.conversion_rate_date), 'MMDDYYYY' || '''')); -- Bug 9264707
993:
994: /*dbms_aw.execute('currency_date_pc_r = '''
995: || to_char(to_date(p_pc_info.conversion_rate_date,

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

990:
991: dbms_aw.execute('currency_date_pc_r = '''
992: || to_char(fnd_date.chardate_to_date(p_pc_info.conversion_rate_date), 'MMDDYYYY' || '''')); -- Bug 9264707
993:
994: /*dbms_aw.execute('currency_date_pc_r = '''
995: || to_char(to_date(p_pc_info.conversion_rate_date,
996: 'DD-MON-YYYY'), 'DDMONYYYY' || ''''));*/
997: else
998: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

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

1005:
1006: --Bug 4254274 : Applying hard coded format for to_date function on sysdate which is in nls_date_format
1007: -- was raising error 'literal does not match format string'
1008:
1009: dbms_aw.execute('currency_date_pc_r = '''
1010: || to_char(sysdate,'MMDDYYYY' || '''')); -- Bug 9264707
1011:
1012: /*dbms_aw.execute('currency_date_pc_r = '''
1013: || to_char(to_date(sysdate,

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

1008:
1009: dbms_aw.execute('currency_date_pc_r = '''
1010: || to_char(sysdate,'MMDDYYYY' || '''')); -- Bug 9264707
1011:
1012: /*dbms_aw.execute('currency_date_pc_r = '''
1013: || to_char(to_date(sysdate,
1014: 'DD-MON-YYYY'), 'DDMONYYYY' || ''''));*/
1015: end if;
1016:

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

1069: --DBMS_OUTPUT.put_line('Before limiting planning_cycle_d to: ' || p_pc_info.planning_cycle );
1070:
1071: -- Update the Currency
1072: -- Limit PCID
1073: dbms_aw.execute('LMT planning_cycle_d TO ' || p_pc_info.planning_cycle );
1074:
1075: --DBMS_OUTPUT.put_line('Before setting submission_due_date ....');
1076:
1077: BEGIN

Line 1079: dbms_aw.execute('MAINTAIN day_d ADD ''' || to_char(p_pc_info.submission_due_date, 'MMDDYYYY' || '''')); -- Bug 9264707

1075: --DBMS_OUTPUT.put_line('Before setting submission_due_date ....');
1076:
1077: BEGIN
1078: -- Add new Day to the dimension
1079: dbms_aw.execute('MAINTAIN day_d ADD ''' || to_char(p_pc_info.submission_due_date, 'MMDDYYYY' || '''')); -- Bug 9264707
1080: EXCEPTION
1081: WHEN OTHERS THEN
1082: --DBMS_OUTPUT.put_line(SQLCODE);
1083: -- Check for existing dim values, if it already exists during MAINTAIN, then ignore it.

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

1091:
1092: --Bug 4254274 : Applying to_date function on variable of type character i.e p_pc_info.submission_due_date
1093: -- was raising error 'literal does not match format string'
1094:
1095: dbms_aw.execute('pc_submission_due_date_r = '''
1096: || to_char(fnd_date.chardate_to_date(p_pc_info.submission_due_date), 'MMDDYYYY' || '''')); -- Bug 9264707
1097:
1098: /*dbms_aw.execute('pc_submission_due_date_r = '''
1099: || to_char(to_date(p_pc_info.submission_due_date,

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

1094:
1095: dbms_aw.execute('pc_submission_due_date_r = '''
1096: || to_char(fnd_date.chardate_to_date(p_pc_info.submission_due_date), 'MMDDYYYY' || '''')); -- Bug 9264707
1097:
1098: /*dbms_aw.execute('pc_submission_due_date_r = '''
1099: || to_char(to_date(p_pc_info.submission_due_date,
1100: 'DD-MON-YYYY'), 'DDMONYYYY' || ''''));*/
1101:
1102: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

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

1160: --DBMS_OUTPUT.put_line('Before limiting planning_cycle_d to: ' || p_disc_funds.planning_cycle );
1161:
1162: -- Update the Discount
1163: -- Limit PCID
1164: dbms_aw.execute('LMT planning_cycle_d TO ' || p_disc_funds.planning_cycle);
1165:
1166: --DBMS_OUTPUT.put_line('Before setting pc_discount_rate ....'|| p_disc_funds.pc_discount_rate);
1167: -- Set the new pc_discount_rate
1168: -- Bug Ref : 8882256

Line 1174: dbms_aw.execute('pc_discount_rate_m = ' || l_pc_discount_rate_c);

1170: INTO l_decimal_marker
1171: FROM NLS_SESSION_PARAMETERS
1172: WHERE PARAMETER = 'NLS_NUMERIC_CHARACTERS';
1173: l_pc_discount_rate_c := REPLACE( To_Char(p_disc_funds.pc_discount_rate/100), l_decimal_marker,'.');
1174: dbms_aw.execute('pc_discount_rate_m = ' || l_pc_discount_rate_c);
1175:
1176: --DBMS_OUTPUT.put_line('Before setting pc funding....' || p_disc_funds.pc_funding);
1177:
1178: -- Set the new funds

Line 1180: dbms_aw.execute('pc_funding_m = ' || l_pc_funding_c );

1176: --DBMS_OUTPUT.put_line('Before setting pc funding....' || p_disc_funds.pc_funding);
1177:
1178: -- Set the new funds
1179: l_pc_funding_c := REPLACE( To_Char(p_disc_funds.pc_funding), l_decimal_marker,'.');
1180: dbms_aw.execute('pc_funding_m = ' || l_pc_funding_c );
1181: --DBMS_OUTPUT.put_line('Before setting factor_d and factor_pc_r....' || p_disc_funds.pc_display_factor);
1182:
1183: dbms_aw.execute('factor_pc_r = ''' || p_disc_funds.pc_display_factor || '''' );
1184:

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

1179: l_pc_funding_c := REPLACE( To_Char(p_disc_funds.pc_funding), l_decimal_marker,'.');
1180: dbms_aw.execute('pc_funding_m = ' || l_pc_funding_c );
1181: --DBMS_OUTPUT.put_line('Before setting factor_d and factor_pc_r....' || p_disc_funds.pc_display_factor);
1182:
1183: dbms_aw.execute('factor_pc_r = ''' || p_disc_funds.pc_display_factor || '''' );
1184:
1185:
1186: --DBMS_OUTPUT.put_line('Outside IF p_disc_funds IS NOT NULL .... ');
1187:

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

1538: 'Calling AW Program SET_PC_INVEST_CRITERIA_PRG.'
1539: );
1540: END IF;
1541:
1542: dbms_aw.execute('call SET_PC_INVEST_CRITERIA_PRG(' || p_pc_id || ')');
1543:
1544: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1545: fnd_log.string
1546: (

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

1600: 'Limiting to passed PC id'
1601: );
1602: END IF;
1603:
1604: dbms_aw.execute('push planning_cycle_d');
1605: dbms_aw.execute('push portfolio_d');
1606: dbms_aw.execute('oknullstatus = y');
1607: dbms_aw.execute('limit planning_cycle_d to ' || p_pc_id);
1608:

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

1601: );
1602: END IF;
1603:
1604: dbms_aw.execute('push planning_cycle_d');
1605: dbms_aw.execute('push portfolio_d');
1606: dbms_aw.execute('oknullstatus = y');
1607: dbms_aw.execute('limit planning_cycle_d to ' || p_pc_id);
1608:
1609: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

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

1602: END IF;
1603:
1604: dbms_aw.execute('push planning_cycle_d');
1605: dbms_aw.execute('push portfolio_d');
1606: dbms_aw.execute('oknullstatus = y');
1607: dbms_aw.execute('limit planning_cycle_d to ' || p_pc_id);
1608:
1609: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1610: FND_LOG.String

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

1603:
1604: dbms_aw.execute('push planning_cycle_d');
1605: dbms_aw.execute('push portfolio_d');
1606: dbms_aw.execute('oknullstatus = y');
1607: dbms_aw.execute('limit planning_cycle_d to ' || p_pc_id);
1608:
1609: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1610: FND_LOG.String
1611: (

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

1613: 'fpa.sql.FPA_PlanningCycle_Pvt.Set_Pc_Approved_Flag',
1614: 'Limiting to portfolio for passed PC id'
1615: );
1616: END IF;
1617: dbms_aw.execute('limit portfolio_d to portfolio_pc_r');
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 portfolio_d');

1623: 'fpa.sql.FPA_PlanningCycle_Pvt.Set_Pc_Approved_Flag',
1624: 'Limiting to planning cycles for the same portfolio'
1625: );
1626: END IF;
1627: dbms_aw.execute('limit planning_cycle_d to portfolio_d');
1628:
1629: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1630: FND_LOG.String
1631: (

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

1633: 'fpa.sql.FPA_PlanningCycle_Pvt.Set_Pc_Approved_Flag',
1634: 'Reset last approved flag'
1635: );
1636: END IF;
1637: dbms_aw.execute('pc_last_approved_flag_m = na');
1638:
1639: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1640: FND_LOG.String
1641: (

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

1643: 'fpa.sql.FPA_PlanningCycle_Pvt.Set_Pc_Approved_Flag',
1644: 'Setting last approved flag to passed pc ID'
1645: );
1646: END IF;
1647: dbms_aw.execute('limit planning_cycle_d to ' || p_pc_id);
1648: dbms_aw.execute('pc_last_approved_flag_m = yes');
1649: dbms_aw.execute('pop planning_cycle_d');
1650: dbms_aw.execute('pop portfolio_d');
1651:

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

1644: 'Setting last approved flag to passed pc ID'
1645: );
1646: END IF;
1647: dbms_aw.execute('limit planning_cycle_d to ' || p_pc_id);
1648: dbms_aw.execute('pc_last_approved_flag_m = yes');
1649: dbms_aw.execute('pop planning_cycle_d');
1650: dbms_aw.execute('pop portfolio_d');
1651:
1652: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

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

1645: );
1646: END IF;
1647: dbms_aw.execute('limit planning_cycle_d to ' || p_pc_id);
1648: dbms_aw.execute('pc_last_approved_flag_m = yes');
1649: dbms_aw.execute('pop planning_cycle_d');
1650: dbms_aw.execute('pop portfolio_d');
1651:
1652: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1653: FND_LOG.String

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

1646: END IF;
1647: dbms_aw.execute('limit planning_cycle_d to ' || p_pc_id);
1648: dbms_aw.execute('pc_last_approved_flag_m = yes');
1649: dbms_aw.execute('pop planning_cycle_d');
1650: dbms_aw.execute('pop portfolio_d');
1651:
1652: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1653: FND_LOG.String
1654: (

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

1708: 'Limiting to passed PC id'
1709: );
1710: END IF;
1711:
1712: dbms_aw.execute('push planning_cycle_d');
1713: dbms_aw.execute('push portfolio_d');
1714: dbms_aw.execute('oknullstatus = y');
1715: dbms_aw.execute('limit planning_cycle_d to ' || p_pc_id);
1716:

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

1709: );
1710: END IF;
1711:
1712: dbms_aw.execute('push planning_cycle_d');
1713: dbms_aw.execute('push portfolio_d');
1714: dbms_aw.execute('oknullstatus = y');
1715: dbms_aw.execute('limit planning_cycle_d to ' || p_pc_id);
1716:
1717: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

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

1710: END IF;
1711:
1712: dbms_aw.execute('push planning_cycle_d');
1713: dbms_aw.execute('push portfolio_d');
1714: dbms_aw.execute('oknullstatus = y');
1715: dbms_aw.execute('limit planning_cycle_d to ' || p_pc_id);
1716:
1717: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1718: FND_LOG.String

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

1711:
1712: dbms_aw.execute('push planning_cycle_d');
1713: dbms_aw.execute('push portfolio_d');
1714: dbms_aw.execute('oknullstatus = y');
1715: dbms_aw.execute('limit planning_cycle_d to ' || p_pc_id);
1716:
1717: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1718: FND_LOG.String
1719: (

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

1721: 'fpa.sql.FPA_PlanningCycle_Pvt.Set_Pc_Last_Flag',
1722: 'Limiting to portfolio for passed PC id'
1723: );
1724: END IF;
1725: dbms_aw.execute('limit portfolio_d to portfolio_pc_r');
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 portfolio_d');

1731: 'fpa.sql.FPA_PlanningCycle_Pvt.Set_Pc_Last_Flag',
1732: 'Limiting to planning cycles for the same portfolio'
1733: );
1734: END IF;
1735: dbms_aw.execute('limit planning_cycle_d to portfolio_d');
1736:
1737: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1738: FND_LOG.String
1739: (

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

1741: 'fpa.sql.FPA_PlanningCycle_Pvt.Set_Pc_Last_Flag',
1742: 'Reset last approved flag'
1743: );
1744: END IF;
1745: dbms_aw.execute('pc_last_flag_m = na');
1746:
1747: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1748: FND_LOG.String
1749: (

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

1751: 'fpa.sql.FPA_PlanningCycle_Pvt.Set_Pc_Last_Flag',
1752: 'Setting last approved flag to passed pc ID'
1753: );
1754: END IF;
1755: dbms_aw.execute('limit planning_cycle_d to ' || p_pc_id);
1756: dbms_aw.execute('pc_last_flag_m = yes');
1757: dbms_aw.execute('pop planning_cycle_d');
1758: dbms_aw.execute('pop portfolio_d');
1759:

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

1752: 'Setting last approved flag to passed pc ID'
1753: );
1754: END IF;
1755: dbms_aw.execute('limit planning_cycle_d to ' || p_pc_id);
1756: dbms_aw.execute('pc_last_flag_m = yes');
1757: dbms_aw.execute('pop planning_cycle_d');
1758: dbms_aw.execute('pop portfolio_d');
1759:
1760: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

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

1753: );
1754: END IF;
1755: dbms_aw.execute('limit planning_cycle_d to ' || p_pc_id);
1756: dbms_aw.execute('pc_last_flag_m = yes');
1757: dbms_aw.execute('pop planning_cycle_d');
1758: dbms_aw.execute('pop portfolio_d');
1759:
1760: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1761: FND_LOG.String

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

1754: END IF;
1755: dbms_aw.execute('limit planning_cycle_d to ' || p_pc_id);
1756: dbms_aw.execute('pc_last_flag_m = yes');
1757: dbms_aw.execute('pop planning_cycle_d');
1758: dbms_aw.execute('pop portfolio_d');
1759:
1760: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1761: FND_LOG.String
1762: (

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

1830: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Annual_Disc_Rates.',
1831: 'Updating Annual discount rates for the PC in AW.');
1832: END IF;
1833:
1834: dbms_aw.execute('lmt planning_cycle_d to ' || p_pc_id);
1835: dbms_aw.execute('lmt time_d to ''' || p_period || '''');
1836: dbms_aw.execute('pc_discount_rate_t_m = ' || p_rate);
1837:
1838: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

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

1831: 'Updating Annual discount rates for the PC in AW.');
1832: END IF;
1833:
1834: dbms_aw.execute('lmt planning_cycle_d to ' || p_pc_id);
1835: dbms_aw.execute('lmt time_d to ''' || p_period || '''');
1836: dbms_aw.execute('pc_discount_rate_t_m = ' || p_rate);
1837:
1838: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1839: FND_LOG.String

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

1832: END IF;
1833:
1834: dbms_aw.execute('lmt planning_cycle_d to ' || p_pc_id);
1835: dbms_aw.execute('lmt time_d to ''' || p_period || '''');
1836: dbms_aw.execute('pc_discount_rate_t_m = ' || p_rate);
1837:
1838: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1839: FND_LOG.String
1840: (FND_LOG.LEVEL_PROCEDURE,