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.ZPB_ACVAL_PVT dependencies on ZPB_AW

Line 385: if zpb_aw.interp('show vl.inseldiff(''' || l_pub_ac_id || ''',''' || l_edt_ac_id || ''')') > 0 then

381: zpb_log.write_statement(G_PKG_NAME,'Tmp cycle does not have any input line members that have changed initialization source');
382:
383: -- initialize solve strcutures for published id to enable comparison
384: initialize_solve_object(l_pub_ac_id);
385: if zpb_aw.interp('show vl.inseldiff(''' || l_pub_ac_id || ''',''' || l_edt_ac_id || ''')') > 0 then
386: x_changeCurrentRun :='N';
387: return;
388: end if;
389:

Line 510: l_dataAw := zpb_aw.get_schema||'.'||zpb_aw.get_shared_aw;

506:
507: begin
508:
509: -- push objects that need to maintain status
510: l_dataAw := zpb_aw.get_schema||'.'||zpb_aw.get_shared_aw;
511: l_dataAwQual := l_dataAw ||'!';
512: -- get line dimension name
513: l_line_dim := zpb_aw.interp('shw CM.GETLINEDIM('''||l_dataAw||''')');
514: l_line_dim := l_dataAWQual || l_line_dim;

Line 513: l_line_dim := zpb_aw.interp('shw CM.GETLINEDIM('''||l_dataAw||''')');

509: -- push objects that need to maintain status
510: l_dataAw := zpb_aw.get_schema||'.'||zpb_aw.get_shared_aw;
511: l_dataAwQual := l_dataAw ||'!';
512: -- get line dimension name
513: l_line_dim := zpb_aw.interp('shw CM.GETLINEDIM('''||l_dataAw||''')');
514: l_line_dim := l_dataAWQual || l_line_dim;
515: l_hier_dim := zpb_aw.interp('shw obj(prp ''HIERDIM'' ' ||'''' || l_line_dim || ''')');
516: l_hier_dim := l_dataAWQual || l_hier_dim;
517: zpb_aw.execute('push ' || l_line_dim);

Line 515: l_hier_dim := zpb_aw.interp('shw obj(prp ''HIERDIM'' ' ||'''' || l_line_dim || ''')');

511: l_dataAwQual := l_dataAw ||'!';
512: -- get line dimension name
513: l_line_dim := zpb_aw.interp('shw CM.GETLINEDIM('''||l_dataAw||''')');
514: l_line_dim := l_dataAWQual || l_line_dim;
515: l_hier_dim := zpb_aw.interp('shw obj(prp ''HIERDIM'' ' ||'''' || l_line_dim || ''')');
516: l_hier_dim := l_dataAWQual || l_hier_dim;
517: zpb_aw.execute('push ' || l_line_dim);
518: zpb_aw.execute('push ' || l_hier_dim);
519:

Line 517: zpb_aw.execute('push ' || l_line_dim);

513: l_line_dim := zpb_aw.interp('shw CM.GETLINEDIM('''||l_dataAw||''')');
514: l_line_dim := l_dataAWQual || l_line_dim;
515: l_hier_dim := zpb_aw.interp('shw obj(prp ''HIERDIM'' ' ||'''' || l_line_dim || ''')');
516: l_hier_dim := l_dataAWQual || l_hier_dim;
517: zpb_aw.execute('push ' || l_line_dim);
518: zpb_aw.execute('push ' || l_hier_dim);
519:
520: validate_currentrun_helper(p_analysis_cycle_id, x_changeCurrentRun);
521: zpb_aw.execute('pop ' || l_hier_dim);

Line 518: zpb_aw.execute('push ' || l_hier_dim);

514: l_line_dim := l_dataAWQual || l_line_dim;
515: l_hier_dim := zpb_aw.interp('shw obj(prp ''HIERDIM'' ' ||'''' || l_line_dim || ''')');
516: l_hier_dim := l_dataAWQual || l_hier_dim;
517: zpb_aw.execute('push ' || l_line_dim);
518: zpb_aw.execute('push ' || l_hier_dim);
519:
520: validate_currentrun_helper(p_analysis_cycle_id, x_changeCurrentRun);
521: zpb_aw.execute('pop ' || l_hier_dim);
522: zpb_aw.execute('pop ' || l_line_dim);

Line 521: zpb_aw.execute('pop ' || l_hier_dim);

517: zpb_aw.execute('push ' || l_line_dim);
518: zpb_aw.execute('push ' || l_hier_dim);
519:
520: validate_currentrun_helper(p_analysis_cycle_id, x_changeCurrentRun);
521: zpb_aw.execute('pop ' || l_hier_dim);
522: zpb_aw.execute('pop ' || l_line_dim);
523: return;
524:
525: end validate_currentrun;

Line 522: zpb_aw.execute('pop ' || l_line_dim);

518: zpb_aw.execute('push ' || l_hier_dim);
519:
520: validate_currentrun_helper(p_analysis_cycle_id, x_changeCurrentRun);
521: zpb_aw.execute('pop ' || l_hier_dim);
522: zpb_aw.execute('pop ' || l_line_dim);
523: return;
524:
525: end validate_currentrun;
526:

Line 541: zpb_aw_status.get_status(p_dataAw,p_first_query);

537: l_equal integer;
538: begin
539: l_dataAwQual := p_dataAw ||'!';
540: -- call the first query
541: zpb_aw_status.get_status(p_dataAw,p_first_query);
542: -- get the valuseset name
543: l_vs := '&' || 'joinchars('''||l_dataAwQual||''' obj(prp ''LASTQUERYVS'' '||''''
544: ||l_dataAwQual||p_line_dim ||'''))';
545: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,'valueset name:' ||l_vs);

Line 548: zpb_aw.execute('push oknullstatus '||l_dataAwQual ||p_line_dim);

544: ||l_dataAwQual||p_line_dim ||'''))';
545: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,'valueset name:' ||l_vs);
546:
547: -- initialize
548: zpb_aw.execute('push oknullstatus '||l_dataAwQual ||p_line_dim);
549: zpb_aw.execute('oknullstatus=y');
550: if (not zpb_aw.interpbool('shw exists(''l_temp_vs'')')) then
551: zpb_aw.execute(' dfn l_temp_vs valueset '||l_dataAwQual ||p_line_dim|| ' aw ' ||p_dataAw);
552: end if;

Line 549: zpb_aw.execute('oknullstatus=y');

545: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,'valueset name:' ||l_vs);
546:
547: -- initialize
548: zpb_aw.execute('push oknullstatus '||l_dataAwQual ||p_line_dim);
549: zpb_aw.execute('oknullstatus=y');
550: if (not zpb_aw.interpbool('shw exists(''l_temp_vs'')')) then
551: zpb_aw.execute(' dfn l_temp_vs valueset '||l_dataAwQual ||p_line_dim|| ' aw ' ||p_dataAw);
552: end if;
553:

Line 550: if (not zpb_aw.interpbool('shw exists(''l_temp_vs'')')) then

546:
547: -- initialize
548: zpb_aw.execute('push oknullstatus '||l_dataAwQual ||p_line_dim);
549: zpb_aw.execute('oknullstatus=y');
550: if (not zpb_aw.interpbool('shw exists(''l_temp_vs'')')) then
551: zpb_aw.execute(' dfn l_temp_vs valueset '||l_dataAwQual ||p_line_dim|| ' aw ' ||p_dataAw);
552: end if;
553:
554: -- lmt the first valueset to the first query

Line 551: zpb_aw.execute(' dfn l_temp_vs valueset '||l_dataAwQual ||p_line_dim|| ' aw ' ||p_dataAw);

547: -- initialize
548: zpb_aw.execute('push oknullstatus '||l_dataAwQual ||p_line_dim);
549: zpb_aw.execute('oknullstatus=y');
550: if (not zpb_aw.interpbool('shw exists(''l_temp_vs'')')) then
551: zpb_aw.execute(' dfn l_temp_vs valueset '||l_dataAwQual ||p_line_dim|| ' aw ' ||p_dataAw);
552: end if;
553:
554: -- lmt the first valueset to the first query
555: zpb_aw.execute('lmt '|| l_dataAwQual ||'l_temp_vs to '

Line 555: zpb_aw.execute('lmt '|| l_dataAwQual ||'l_temp_vs to '

551: zpb_aw.execute(' dfn l_temp_vs valueset '||l_dataAwQual ||p_line_dim|| ' aw ' ||p_dataAw);
552: end if;
553:
554: -- lmt the first valueset to the first query
555: zpb_aw.execute('lmt '|| l_dataAwQual ||'l_temp_vs to '
556: || l_vs );
557:
558: -- generate the valuseset for the second query
559: zpb_aw_status.get_status(p_dataAw,p_second_query);

Line 559: zpb_aw_status.get_status(p_dataAw,p_second_query);

555: zpb_aw.execute('lmt '|| l_dataAwQual ||'l_temp_vs to '
556: || l_vs );
557:
558: -- generate the valuseset for the second query
559: zpb_aw_status.get_status(p_dataAw,p_second_query);
560:
561:
562: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,substr(zpb_aw.interp('rpr w 40 values('||l_dataAwQual ||'l_temp_vs)'),1,254));
563: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,substr(zpb_aw.interp('rpr w 40 values('||l_vs||')'),1,254));

Line 562: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,substr(zpb_aw.interp('rpr w 40 values('||l_dataAwQual ||'l_temp_vs)'),1,254));

558: -- generate the valuseset for the second query
559: zpb_aw_status.get_status(p_dataAw,p_second_query);
560:
561:
562: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,substr(zpb_aw.interp('rpr w 40 values('||l_dataAwQual ||'l_temp_vs)'),1,254));
563: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,substr(zpb_aw.interp('rpr w 40 values('||l_vs||')'),1,254));
564:
565: -- check if the two valusesets are identical
566: l_first_superset := zpb_aw.interpbool('shw inlist(values('||l_dataAwQual||'l_temp_vs)'

Line 563: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,substr(zpb_aw.interp('rpr w 40 values('||l_vs||')'),1,254));

559: zpb_aw_status.get_status(p_dataAw,p_second_query);
560:
561:
562: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,substr(zpb_aw.interp('rpr w 40 values('||l_dataAwQual ||'l_temp_vs)'),1,254));
563: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,substr(zpb_aw.interp('rpr w 40 values('||l_vs||')'),1,254));
564:
565: -- check if the two valusesets are identical
566: l_first_superset := zpb_aw.interpbool('shw inlist(values('||l_dataAwQual||'l_temp_vs)'
567: || ' values('||l_vs||'))');

Line 566: l_first_superset := zpb_aw.interpbool('shw inlist(values('||l_dataAwQual||'l_temp_vs)'

562: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,substr(zpb_aw.interp('rpr w 40 values('||l_dataAwQual ||'l_temp_vs)'),1,254));
563: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,substr(zpb_aw.interp('rpr w 40 values('||l_vs||')'),1,254));
564:
565: -- check if the two valusesets are identical
566: l_first_superset := zpb_aw.interpbool('shw inlist(values('||l_dataAwQual||'l_temp_vs)'
567: || ' values('||l_vs||'))');
568: l_second_superset := zpb_aw.interpbool('shw inlist(values('||l_vs||')'
569: || ' values(l_temp_vs))');
570: if l_first_superset then

Line 568: l_second_superset := zpb_aw.interpbool('shw inlist(values('||l_vs||')'

564:
565: -- check if the two valusesets are identical
566: l_first_superset := zpb_aw.interpbool('shw inlist(values('||l_dataAwQual||'l_temp_vs)'
567: || ' values('||l_vs||'))');
568: l_second_superset := zpb_aw.interpbool('shw inlist(values('||l_vs||')'
569: || ' values(l_temp_vs))');
570: if l_first_superset then
571: if l_second_superset then
572: l_equal := 0;

Line 584: zpb_aw.execute('pop oknullstatus '||l_dataAwQual ||p_line_dim);

580: l_equal := 3;
581: end if;
582: end if;
583:
584: zpb_aw.execute('pop oknullstatus '||l_dataAwQual ||p_line_dim);
585: return l_equal;
586:
587: exception
588: when others then

Line 611: l_dataAw := zpb_aw.get_schema||'.'||zpb_aw.get_shared_aw;

607: l_line_dim zpb_cycle_model_dimensions.dimension_name%type;
608:
609: begin
610:
611: l_dataAw := zpb_aw.get_schema||'.'||zpb_aw.get_shared_aw;
612: l_dataAwQual := l_dataAw ||'!';
613:
614: -- get line dimension name
615: l_line_dim := zpb_aw.interp('shw CM.GETLINEDIM('''||l_dataAw||''')');

Line 615: l_line_dim := zpb_aw.interp('shw CM.GETLINEDIM('''||l_dataAw||''')');

611: l_dataAw := zpb_aw.get_schema||'.'||zpb_aw.get_shared_aw;
612: l_dataAwQual := l_dataAw ||'!';
613:
614: -- get line dimension name
615: l_line_dim := zpb_aw.interp('shw CM.GETLINEDIM('''||l_dataAw||''')');
616: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,'line_dim:' ||l_dataAwQual || l_line_dim);
617:
618: x_equal := compare_queries(l_dataAw,p_first_query,p_second_query,l_line_dim);
619: -- cleanup and return

Line 620: if (not zpb_aw.interpbool('shw exists(''l_temp_vs'')')) then

616: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,'line_dim:' ||l_dataAwQual || l_line_dim);
617:
618: x_equal := compare_queries(l_dataAw,p_first_query,p_second_query,l_line_dim);
619: -- cleanup and return
620: if (not zpb_aw.interpbool('shw exists(''l_temp_vs'')')) then
621: zpb_aw.execute('delete l_temp_vs aw ' ||l_dataAw);
622: end if;
623:
624: exception

Line 621: zpb_aw.execute('delete l_temp_vs aw ' ||l_dataAw);

617:
618: x_equal := compare_queries(l_dataAw,p_first_query,p_second_query,l_line_dim);
619: -- cleanup and return
620: if (not zpb_aw.interpbool('shw exists(''l_temp_vs'')')) then
621: zpb_aw.execute('delete l_temp_vs aw ' ||l_dataAw);
622: end if;
623:
624: exception
625: when others then

Line 646: l_dataAw := zpb_aw.get_schema||'.'||zpb_aw.get_shared_aw;

642: return_status varchar2(4000);
643: msg_count number;
644: msg_data varchar2(4000);
645: begin
646: l_dataAw := zpb_aw.get_schema||'.'||zpb_aw.get_shared_aw;
647: -- zpb_aw.execute('aw attach '|| zpb_aw.get_schema||'.'||zpb_aw.get_code_aw(fnd_global.user_id) || ' ro');
648: zpb_aw.execute('push oknullstatus ');
649: zpb_aw.execute('oknullstatus=y');
650: /*

Line 647: -- zpb_aw.execute('aw attach '|| zpb_aw.get_schema||'.'||zpb_aw.get_code_aw(fnd_global.user_id) || ' ro');

643: msg_count number;
644: msg_data varchar2(4000);
645: begin
646: l_dataAw := zpb_aw.get_schema||'.'||zpb_aw.get_shared_aw;
647: -- zpb_aw.execute('aw attach '|| zpb_aw.get_schema||'.'||zpb_aw.get_code_aw(fnd_global.user_id) || ' ro');
648: zpb_aw.execute('push oknullstatus ');
649: zpb_aw.execute('oknullstatus=y');
650: /*
651: zpb_aw.initialize_workspace(1.0, FND_API.G_FALSE,

Line 648: zpb_aw.execute('push oknullstatus ');

644: msg_data varchar2(4000);
645: begin
646: l_dataAw := zpb_aw.get_schema||'.'||zpb_aw.get_shared_aw;
647: -- zpb_aw.execute('aw attach '|| zpb_aw.get_schema||'.'||zpb_aw.get_code_aw(fnd_global.user_id) || ' ro');
648: zpb_aw.execute('push oknullstatus ');
649: zpb_aw.execute('oknullstatus=y');
650: /*
651: zpb_aw.initialize_workspace(1.0, FND_API.G_FALSE,
652: FND_API.G_VALID_LEVEL_FULL, return_status, msg_count,

Line 649: zpb_aw.execute('oknullstatus=y');

645: begin
646: l_dataAw := zpb_aw.get_schema||'.'||zpb_aw.get_shared_aw;
647: -- zpb_aw.execute('aw attach '|| zpb_aw.get_schema||'.'||zpb_aw.get_code_aw(fnd_global.user_id) || ' ro');
648: zpb_aw.execute('push oknullstatus ');
649: zpb_aw.execute('oknullstatus=y');
650: /*
651: zpb_aw.initialize_workspace(1.0, FND_API.G_FALSE,
652: FND_API.G_VALID_LEVEL_FULL, return_status, msg_count,
653: msg_data, fnd_global.user_id, 'ZPB_MANAGER_RESP');

Line 651: zpb_aw.initialize_workspace(1.0, FND_API.G_FALSE,

647: -- zpb_aw.execute('aw attach '|| zpb_aw.get_schema||'.'||zpb_aw.get_code_aw(fnd_global.user_id) || ' ro');
648: zpb_aw.execute('push oknullstatus ');
649: zpb_aw.execute('oknullstatus=y');
650: /*
651: zpb_aw.initialize_workspace(1.0, FND_API.G_FALSE,
652: FND_API.G_VALID_LEVEL_FULL, return_status, msg_count,
653: msg_data, fnd_global.user_id, 'ZPB_MANAGER_RESP');
654: */
655: zpb_log.write_event(G_PKG_NAME||l_api_name,zpb_aw.interp('rpr w 30 aw(list)'));

Line 655: zpb_log.write_event(G_PKG_NAME||l_api_name,zpb_aw.interp('rpr w 30 aw(list)'));

651: zpb_aw.initialize_workspace(1.0, FND_API.G_FALSE,
652: FND_API.G_VALID_LEVEL_FULL, return_status, msg_count,
653: msg_data, fnd_global.user_id, 'ZPB_MANAGER_RESP');
654: */
655: zpb_log.write_event(G_PKG_NAME||l_api_name,zpb_aw.interp('rpr w 30 aw(list)'));
656: zpb_aw.execute('call sv.get.solvedef('''||p_analysis_cycle_id||''' NA yes)');
657: zpb_aw.execute('call cm.setinsels('''||p_analysis_cycle_id||''')');
658: zpb_aw.execute('call cm.setoutsels('''||p_analysis_cycle_id||''', '''||p_analysis_cycle_id||''')');
659:

Line 656: zpb_aw.execute('call sv.get.solvedef('''||p_analysis_cycle_id||''' NA yes)');

652: FND_API.G_VALID_LEVEL_FULL, return_status, msg_count,
653: msg_data, fnd_global.user_id, 'ZPB_MANAGER_RESP');
654: */
655: zpb_log.write_event(G_PKG_NAME||l_api_name,zpb_aw.interp('rpr w 30 aw(list)'));
656: zpb_aw.execute('call sv.get.solvedef('''||p_analysis_cycle_id||''' NA yes)');
657: zpb_aw.execute('call cm.setinsels('''||p_analysis_cycle_id||''')');
658: zpb_aw.execute('call cm.setoutsels('''||p_analysis_cycle_id||''', '''||p_analysis_cycle_id||''')');
659:
660: end initialize_solve_object;

Line 657: zpb_aw.execute('call cm.setinsels('''||p_analysis_cycle_id||''')');

653: msg_data, fnd_global.user_id, 'ZPB_MANAGER_RESP');
654: */
655: zpb_log.write_event(G_PKG_NAME||l_api_name,zpb_aw.interp('rpr w 30 aw(list)'));
656: zpb_aw.execute('call sv.get.solvedef('''||p_analysis_cycle_id||''' NA yes)');
657: zpb_aw.execute('call cm.setinsels('''||p_analysis_cycle_id||''')');
658: zpb_aw.execute('call cm.setoutsels('''||p_analysis_cycle_id||''', '''||p_analysis_cycle_id||''')');
659:
660: end initialize_solve_object;
661:

Line 658: zpb_aw.execute('call cm.setoutsels('''||p_analysis_cycle_id||''', '''||p_analysis_cycle_id||''')');

654: */
655: zpb_log.write_event(G_PKG_NAME||l_api_name,zpb_aw.interp('rpr w 30 aw(list)'));
656: zpb_aw.execute('call sv.get.solvedef('''||p_analysis_cycle_id||''' NA yes)');
657: zpb_aw.execute('call cm.setinsels('''||p_analysis_cycle_id||''')');
658: zpb_aw.execute('call cm.setoutsels('''||p_analysis_cycle_id||''', '''||p_analysis_cycle_id||''')');
659:
660: end initialize_solve_object;
661:
662:

Line 672: zpb_aw.execute('pop oknullstatus');

668: msg_count number;
669: msg_data varchar2(4000);
670: begin
671:
672: zpb_aw.execute('pop oknullstatus');
673: -- zpb_aw.execute('aw detach '|| zpb_aw.get_schema||'.'||p_data_aw );
674: -- zpb_aw.execute('aw detach '|| zpb_aw.get_schema||'.'||zpb_aw.get_code_aw(fnd_global.user_id) );
675:
676: zpb_log.write_statement(G_PKG_NAME||l_api_name,zpb_aw.interp('rpr w 30 aw(list)'));

Line 673: -- zpb_aw.execute('aw detach '|| zpb_aw.get_schema||'.'||p_data_aw );

669: msg_data varchar2(4000);
670: begin
671:
672: zpb_aw.execute('pop oknullstatus');
673: -- zpb_aw.execute('aw detach '|| zpb_aw.get_schema||'.'||p_data_aw );
674: -- zpb_aw.execute('aw detach '|| zpb_aw.get_schema||'.'||zpb_aw.get_code_aw(fnd_global.user_id) );
675:
676: zpb_log.write_statement(G_PKG_NAME||l_api_name,zpb_aw.interp('rpr w 30 aw(list)'));
677:

Line 674: -- zpb_aw.execute('aw detach '|| zpb_aw.get_schema||'.'||zpb_aw.get_code_aw(fnd_global.user_id) );

670: begin
671:
672: zpb_aw.execute('pop oknullstatus');
673: -- zpb_aw.execute('aw detach '|| zpb_aw.get_schema||'.'||p_data_aw );
674: -- zpb_aw.execute('aw detach '|| zpb_aw.get_schema||'.'||zpb_aw.get_code_aw(fnd_global.user_id) );
675:
676: zpb_log.write_statement(G_PKG_NAME||l_api_name,zpb_aw.interp('rpr w 30 aw(list)'));
677:
678: -- dont call clean_workspace because it resets the context also. Will have to fix this later.

Line 676: zpb_log.write_statement(G_PKG_NAME||l_api_name,zpb_aw.interp('rpr w 30 aw(list)'));

672: zpb_aw.execute('pop oknullstatus');
673: -- zpb_aw.execute('aw detach '|| zpb_aw.get_schema||'.'||p_data_aw );
674: -- zpb_aw.execute('aw detach '|| zpb_aw.get_schema||'.'||zpb_aw.get_code_aw(fnd_global.user_id) );
675:
676: zpb_log.write_statement(G_PKG_NAME||l_api_name,zpb_aw.interp('rpr w 30 aw(list)'));
677:
678: -- dont call clean_workspace because it resets the context also. Will have to fix this later.
679: -- zpb_aw.clean_workspace(1.0, FND_API.G_FALSE, FND_API.G_VALID_LEVEL_FULL, return_status, msg_count, msg_data);
680:

Line 679: -- zpb_aw.clean_workspace(1.0, FND_API.G_FALSE, FND_API.G_VALID_LEVEL_FULL, return_status, msg_count, msg_data);

675:
676: zpb_log.write_statement(G_PKG_NAME||l_api_name,zpb_aw.interp('rpr w 30 aw(list)'));
677:
678: -- dont call clean_workspace because it resets the context also. Will have to fix this later.
679: -- zpb_aw.clean_workspace(1.0, FND_API.G_FALSE, FND_API.G_VALID_LEVEL_FULL, return_status, msg_count, msg_data);
680:
681: end detach_aw;
682:
683:

Line 714: zpb_aw.execute('push SV.LN.DIM ');

710: begin
711:
712: ZPB_LOG.WRITE(G_PKG_NAME || '.' || l_api_name, 'Validating if solve is equal to model ' || to_char(p_analysis_cycle_id) || '.');
713: -- initialize_solve_object(p_analysis_cycle_id);
714: zpb_aw.execute('push SV.LN.DIM ');
715: l_pushed_solve := 'Y';
716: l_dataAw := zpb_aw.get_schema||'.'||zpb_aw.get_shared_aw;
717:
718: l_line_dim := zpb_aw.interp('shw CM.GETLINEDIM('''||l_dataAw||''')');

Line 716: l_dataAw := zpb_aw.get_schema||'.'||zpb_aw.get_shared_aw;

712: ZPB_LOG.WRITE(G_PKG_NAME || '.' || l_api_name, 'Validating if solve is equal to model ' || to_char(p_analysis_cycle_id) || '.');
713: -- initialize_solve_object(p_analysis_cycle_id);
714: zpb_aw.execute('push SV.LN.DIM ');
715: l_pushed_solve := 'Y';
716: l_dataAw := zpb_aw.get_schema||'.'||zpb_aw.get_shared_aw;
717:
718: l_line_dim := zpb_aw.interp('shw CM.GETLINEDIM('''||l_dataAw||''')');
719:
720:

Line 718: l_line_dim := zpb_aw.interp('shw CM.GETLINEDIM('''||l_dataAw||''')');

714: zpb_aw.execute('push SV.LN.DIM ');
715: l_pushed_solve := 'Y';
716: l_dataAw := zpb_aw.get_schema||'.'||zpb_aw.get_shared_aw;
717:
718: l_line_dim := zpb_aw.interp('shw CM.GETLINEDIM('''||l_dataAw||''')');
719:
720:
721: -- get the valuseset name
722: l_vs := '&' || 'joinchars('''||l_dataAw||'!'' obj(prp ''LASTQUERYVS'' '||''''

Line 732: zpb_aw.execute('pop SV.LN.DIM ');

728: -- cycle not defined properly yet. so return without doing any validation
729: -- not information will be provided in the validation page
730: if query_identifier%notfound then
731: x_comparision := 4;
732: zpb_aw.execute('pop SV.LN.DIM ');
733: return;
734: end if;
735:
736: close query_identifier;

Line 740: zpb_aw_status.get_status(l_dataAw,l_query_name);

736: close query_identifier;
737:
738: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,'query is :' ||l_query_name);
739:
740: zpb_aw_status.get_status(l_dataAw,l_query_name);
741:
742: if zpb_aw.interpbool('shw inlist(values(SV.LN.DIM) values('||
743: l_vs||'))') then
744: if zpb_aw.interpbool('shw inlist(values('|| l_vs||') values(SV.LN.DIM))') then

Line 742: if zpb_aw.interpbool('shw inlist(values(SV.LN.DIM) values('||

738: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,'query is :' ||l_query_name);
739:
740: zpb_aw_status.get_status(l_dataAw,l_query_name);
741:
742: if zpb_aw.interpbool('shw inlist(values(SV.LN.DIM) values('||
743: l_vs||'))') then
744: if zpb_aw.interpbool('shw inlist(values('|| l_vs||') values(SV.LN.DIM))') then
745: x_comparision := '0';
746: else

Line 744: if zpb_aw.interpbool('shw inlist(values('|| l_vs||') values(SV.LN.DIM))') then

740: zpb_aw_status.get_status(l_dataAw,l_query_name);
741:
742: if zpb_aw.interpbool('shw inlist(values(SV.LN.DIM) values('||
743: l_vs||'))') then
744: if zpb_aw.interpbool('shw inlist(values('|| l_vs||') values(SV.LN.DIM))') then
745: x_comparision := '0';
746: else
747: x_comparision := '1';
748: end if;

Line 750: if zpb_aw.interpbool('shw inlist(values('|| l_vs||') values(SV.LN.DIM))') then

746: else
747: x_comparision := '1';
748: end if;
749: else
750: if zpb_aw.interpbool('shw inlist(values('|| l_vs||') values(SV.LN.DIM))') then
751: x_comparision := '2';
752: else
753: x_comparision := '3';
754: end if;

Line 756: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,substr(zpb_aw.interp('rpr values('||l_vs||')'),1,254) );

752: else
753: x_comparision := '3';
754: end if;
755: end if;
756: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,substr(zpb_aw.interp('rpr values('||l_vs||')'),1,254) );
757: zpb_aw.execute('pop SV.LN.DIM ');
758: return;
759:
760: exception

Line 757: zpb_aw.execute('pop SV.LN.DIM ');

753: x_comparision := '3';
754: end if;
755: end if;
756: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,substr(zpb_aw.interp('rpr values('||l_vs||')'),1,254) );
757: zpb_aw.execute('pop SV.LN.DIM ');
758: return;
759:
760: exception
761: when others then

Line 764: zpb_aw.execute('pop SV.LN.DIM ');

760: exception
761: when others then
762: x_comparision := 4;
763: if l_pushed_solve = 'Y' then
764: zpb_aw.execute('pop SV.LN.DIM ');
765: end if;
766: zpb_log.write_event(G_PKG_NAME||'.'||l_api_name,to_char(sqlcode) ||':'|| substr(sqlerrm,1,90));
767:
768: end val_solve_eq_model;

Line 808: zpb_aw.execute('push SV.LN.DIM ');

804: );
805: begin
806:
807: -- initialize_solve_object(p_analysis_cycle_id);
808: zpb_aw.execute('push SV.LN.DIM ');
809: l_pushed_solve := 'Y';
810: l_dataAw := zpb_aw.get_schema||'.'||zpb_aw.get_shared_aw;
811:
812: l_line_dim := zpb_aw.interp('shw CM.GETLINEDIM('''||l_dataAw||''')');

Line 810: l_dataAw := zpb_aw.get_schema||'.'||zpb_aw.get_shared_aw;

806:
807: -- initialize_solve_object(p_analysis_cycle_id);
808: zpb_aw.execute('push SV.LN.DIM ');
809: l_pushed_solve := 'Y';
810: l_dataAw := zpb_aw.get_schema||'.'||zpb_aw.get_shared_aw;
811:
812: l_line_dim := zpb_aw.interp('shw CM.GETLINEDIM('''||l_dataAw||''')');
813:
814: zpb_aw.execute('lmt SV.LN.DIM keep SV.DEF.VAR(SV.DEF.PROP.DIM ''TYPE'') eq ''LOADED''');

Line 812: l_line_dim := zpb_aw.interp('shw CM.GETLINEDIM('''||l_dataAw||''')');

808: zpb_aw.execute('push SV.LN.DIM ');
809: l_pushed_solve := 'Y';
810: l_dataAw := zpb_aw.get_schema||'.'||zpb_aw.get_shared_aw;
811:
812: l_line_dim := zpb_aw.interp('shw CM.GETLINEDIM('''||l_dataAw||''')');
813:
814: zpb_aw.execute('lmt SV.LN.DIM keep SV.DEF.VAR(SV.DEF.PROP.DIM ''TYPE'') eq ''LOADED''');
815:
816:

Line 814: zpb_aw.execute('lmt SV.LN.DIM keep SV.DEF.VAR(SV.DEF.PROP.DIM ''TYPE'') eq ''LOADED''');

810: l_dataAw := zpb_aw.get_schema||'.'||zpb_aw.get_shared_aw;
811:
812: l_line_dim := zpb_aw.interp('shw CM.GETLINEDIM('''||l_dataAw||''')');
813:
814: zpb_aw.execute('lmt SV.LN.DIM keep SV.DEF.VAR(SV.DEF.PROP.DIM ''TYPE'') eq ''LOADED''');
815:
816:
817: -- get the valuseset name
818: l_vs := '&' || 'joinchars('''||l_dataAw||'!'' obj(prp ''LASTQUERYVS'' '||''''

Line 847: zpb_aw.execute('pop SV.LN.DIM ');

843: -- if any query is not properly defined then donot perform any validation
844: -- and return. Allso return if all line items are being selected
845: if l_path_exists <> 'y' or l_name_exists <> 'y' or l_selection_type = 'ALL_LINE_ITEMS_SELECTION_TYPE' then
846: x_isvalid := 'Y';
847: zpb_aw.execute('pop SV.LN.DIM ');
848: return;
849: end if;
850:
851: l_query_name := l_query_path ||'/' || l_query_name;

Line 855: zpb_aw_status.get_status(l_dataAw,l_query_name);

851: l_query_name := l_query_path ||'/' || l_query_name;
852: -- l_query_name := 'System Private/Controller/AC11736/MODEL_QUERY_5894';
853:
854: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,'query is :' ||l_query_name);
855: zpb_aw_status.get_status(l_dataAw,l_query_name);
856:
857: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,substr(zpb_aw.interp('rpr values('||l_vs||')'),1,254) );
858:
859: zpb_aw.execute(' lmt SV.LN.DIM keep filterlines(values(sv.ln.dim) if inlist(values('||l_vs||') value) then na else value)');

Line 857: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,substr(zpb_aw.interp('rpr values('||l_vs||')'),1,254) );

853:
854: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,'query is :' ||l_query_name);
855: zpb_aw_status.get_status(l_dataAw,l_query_name);
856:
857: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,substr(zpb_aw.interp('rpr values('||l_vs||')'),1,254) );
858:
859: zpb_aw.execute(' lmt SV.LN.DIM keep filterlines(values(sv.ln.dim) if inlist(values('||l_vs||') value) then na else value)');
860: end loop;
861:

Line 859: zpb_aw.execute(' lmt SV.LN.DIM keep filterlines(values(sv.ln.dim) if inlist(values('||l_vs||') value) then na else value)');

855: zpb_aw_status.get_status(l_dataAw,l_query_name);
856:
857: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,substr(zpb_aw.interp('rpr values('||l_vs||')'),1,254) );
858:
859: zpb_aw.execute(' lmt SV.LN.DIM keep filterlines(values(sv.ln.dim) if inlist(values('||l_vs||') value) then na else value)');
860: end loop;
861:
862:
863: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,substr(zpb_aw.interp('rpr values(SV.LN.DIM)'),1,255) );

Line 863: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,substr(zpb_aw.interp('rpr values(SV.LN.DIM)'),1,255) );

859: zpb_aw.execute(' lmt SV.LN.DIM keep filterlines(values(sv.ln.dim) if inlist(values('||l_vs||') value) then na else value)');
860: end loop;
861:
862:
863: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,substr(zpb_aw.interp('rpr values(SV.LN.DIM)'),1,255) );
864:
865: if zpb_aw.interpbool('shw statlen(SV.LN.DIM) gt 0 ') then
866: x_isvalid := 'N';
867: x_dim_members := zpb_aw.interp('shw joinchars(joincols(filterlines(values(SV.LN.DIM) joinchars(''\'''' value ''\'''')) '',''))');

Line 865: if zpb_aw.interpbool('shw statlen(SV.LN.DIM) gt 0 ') then

861:
862:
863: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,substr(zpb_aw.interp('rpr values(SV.LN.DIM)'),1,255) );
864:
865: if zpb_aw.interpbool('shw statlen(SV.LN.DIM) gt 0 ') then
866: x_isvalid := 'N';
867: x_dim_members := zpb_aw.interp('shw joinchars(joincols(filterlines(values(SV.LN.DIM) joinchars(''\'''' value ''\'''')) '',''))');
868: if length(x_dim_members) > 0 then
869: x_dim_members := substr(x_dim_members,1,length(x_dim_members)-1);

Line 867: x_dim_members := zpb_aw.interp('shw joinchars(joincols(filterlines(values(SV.LN.DIM) joinchars(''\'''' value ''\'''')) '',''))');

863: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,substr(zpb_aw.interp('rpr values(SV.LN.DIM)'),1,255) );
864:
865: if zpb_aw.interpbool('shw statlen(SV.LN.DIM) gt 0 ') then
866: x_isvalid := 'N';
867: x_dim_members := zpb_aw.interp('shw joinchars(joincols(filterlines(values(SV.LN.DIM) joinchars(''\'''' value ''\'''')) '',''))');
868: if length(x_dim_members) > 0 then
869: x_dim_members := substr(x_dim_members,1,length(x_dim_members)-1);
870: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,substr(x_dim_members,1,254));
871: end if;

Line 876: zpb_aw.execute('pop SV.LN.DIM ');

872: else
873: x_isvalid := 'Y';
874: end if;
875:
876: zpb_aw.execute('pop SV.LN.DIM ');
877: return;
878:
879: exception
880: when others then

Line 883: zpb_aw.execute('pop SV.LN.DIM ');

879: exception
880: when others then
881: x_isvalid := 'Y';
882: if l_pushed_solve = 'Y' then
883: zpb_aw.execute('pop SV.LN.DIM ');
884: end if;
885:
886: zpb_log.write_event(G_PKG_NAME,to_char(sqlcode) ||':'|| substr(sqlerrm,1,90));
887:

Line 931: zpb_aw.execute('push SV.LN.DIM ');

927:
928: begin
929:
930: ZPB_LOG.WRITE(G_PKG_NAME || '.' || l_api_name, 'Validating if generate worksheet tasks have input line member ' || to_char(p_analysis_cycle_id) || '.');
931: zpb_aw.execute('push SV.LN.DIM ');
932: l_pushed_solve := 'Y';
933: x_isvalid := 'Y';
934: l_dataAw := zpb_aw.get_schema||'.'||zpb_aw.get_shared_aw;
935:

Line 934: l_dataAw := zpb_aw.get_schema||'.'||zpb_aw.get_shared_aw;

930: ZPB_LOG.WRITE(G_PKG_NAME || '.' || l_api_name, 'Validating if generate worksheet tasks have input line member ' || to_char(p_analysis_cycle_id) || '.');
931: zpb_aw.execute('push SV.LN.DIM ');
932: l_pushed_solve := 'Y';
933: x_isvalid := 'Y';
934: l_dataAw := zpb_aw.get_schema||'.'||zpb_aw.get_shared_aw;
935:
936: l_line_dim := zpb_aw.interp('shw CM.GETLINEDIM('''||l_dataAw||''')');
937:
938: zpb_aw.execute('lmt SV.LN.DIM to SV.DEF.VAR(SV.DEF.PROP.DIM ''TYPE'') eq ''LOADED''');

Line 936: l_line_dim := zpb_aw.interp('shw CM.GETLINEDIM('''||l_dataAw||''')');

932: l_pushed_solve := 'Y';
933: x_isvalid := 'Y';
934: l_dataAw := zpb_aw.get_schema||'.'||zpb_aw.get_shared_aw;
935:
936: l_line_dim := zpb_aw.interp('shw CM.GETLINEDIM('''||l_dataAw||''')');
937:
938: zpb_aw.execute('lmt SV.LN.DIM to SV.DEF.VAR(SV.DEF.PROP.DIM ''TYPE'') eq ''LOADED''');
939:
940:

Line 938: zpb_aw.execute('lmt SV.LN.DIM to SV.DEF.VAR(SV.DEF.PROP.DIM ''TYPE'') eq ''LOADED''');

934: l_dataAw := zpb_aw.get_schema||'.'||zpb_aw.get_shared_aw;
935:
936: l_line_dim := zpb_aw.interp('shw CM.GETLINEDIM('''||l_dataAw||''')');
937:
938: zpb_aw.execute('lmt SV.LN.DIM to SV.DEF.VAR(SV.DEF.PROP.DIM ''TYPE'') eq ''LOADED''');
939:
940:
941: -- get the valuseset name
942: l_vs := '&' || 'joinchars('''||l_dataAw||'!'' obj(prp ''LASTQUERYVS'' '||''''

Line 946: zpb_aw.execute(' push '||l_vs);

942: l_vs := '&' || 'joinchars('''||l_dataAw||'!'' obj(prp ''LASTQUERYVS'' '||''''
943: ||l_dataAw||'!' ||l_line_dim ||'''))';
944:
945: /* for bug 4771735 --> Restrict the valueset also to type Loaded */
946: zpb_aw.execute(' push '||l_vs);
947: zpb_aw.execute(' lmt '||l_vs||' keep values(SV.LN.DIM)');
948: /* FOR BUG 4771735 */
949:
950: l_task_exists := 'n';

Line 947: zpb_aw.execute(' lmt '||l_vs||' keep values(SV.LN.DIM)');

943: ||l_dataAw||'!' ||l_line_dim ||'''))';
944:
945: /* for bug 4771735 --> Restrict the valueset also to type Loaded */
946: zpb_aw.execute(' push '||l_vs);
947: zpb_aw.execute(' lmt '||l_vs||' keep values(SV.LN.DIM)');
948: /* FOR BUG 4771735 */
949:
950: l_task_exists := 'n';
951: for each in generate_task loop

Line 978: zpb_aw.execute('pop SV.LN.DIM ');

974: -- if any query is not properly defined then donot perform any validation
975: -- and return
976: if l_path_exists <> 'y' or l_name_exists <> 'y' then
977: x_isvalid := 'Y';
978: zpb_aw.execute('pop SV.LN.DIM ');
979: -- for bug 4771735
980: zpb_aw.execute('pop '||l_vs);
981: return;
982: end if;

Line 980: zpb_aw.execute('pop '||l_vs);

976: if l_path_exists <> 'y' or l_name_exists <> 'y' then
977: x_isvalid := 'Y';
978: zpb_aw.execute('pop SV.LN.DIM ');
979: -- for bug 4771735
980: zpb_aw.execute('pop '||l_vs);
981: return;
982: end if;
983:
984: -- only validate this task if it is not selecting all lines

Line 991: zpb_aw_status.get_status(l_dataAw,l_query_name);

987: if l_selection_type <> 'ALL_LINE_ITEMS_SELECTION_TYPE' then
988: l_query_name := l_query_path ||'/' || l_query_name;
989:
990: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,'query is :' ||l_query_name);
991: zpb_aw_status.get_status(l_dataAw,l_query_name);
992:
993: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,substr(zpb_aw.interp('rpr values('||l_vs||')'),1,254) );
994: if not zpb_aw.interpbool('shw inlist(values(SV.LN.DIM) values('||
995: l_vs||'))') then

Line 993: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,substr(zpb_aw.interp('rpr values('||l_vs||')'),1,254) );

989:
990: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,'query is :' ||l_query_name);
991: zpb_aw_status.get_status(l_dataAw,l_query_name);
992:
993: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,substr(zpb_aw.interp('rpr values('||l_vs||')'),1,254) );
994: if not zpb_aw.interpbool('shw inlist(values(SV.LN.DIM) values('||
995: l_vs||'))') then
996:
997: x_isvalid := 'N';

Line 994: if not zpb_aw.interpbool('shw inlist(values(SV.LN.DIM) values('||

990: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,'query is :' ||l_query_name);
991: zpb_aw_status.get_status(l_dataAw,l_query_name);
992:
993: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,substr(zpb_aw.interp('rpr values('||l_vs||')'),1,254) );
994: if not zpb_aw.interpbool('shw inlist(values(SV.LN.DIM) values('||
995: l_vs||'))') then
996:
997: x_isvalid := 'N';
998: zpb_aw.execute('lmt '||l_vs||' remove values(SV.LN.DIM)');

Line 998: zpb_aw.execute('lmt '||l_vs||' remove values(SV.LN.DIM)');

994: if not zpb_aw.interpbool('shw inlist(values(SV.LN.DIM) values('||
995: l_vs||'))') then
996:
997: x_isvalid := 'N';
998: zpb_aw.execute('lmt '||l_vs||' remove values(SV.LN.DIM)');
999: l_dim_members := zpb_aw.interp('shw joinchars(joincols(filterlines(values('||l_vs||') joinchars(''\'''' value ''\'''')) '',''))');
1000: if length(l_dim_members) > 0 then
1001: l_dim_members := substr(l_dim_members,1,length(l_dim_members)-1);
1002: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,substr(l_dim_members,1,254));

Line 999: l_dim_members := zpb_aw.interp('shw joinchars(joincols(filterlines(values('||l_vs||') joinchars(''\'''' value ''\'''')) '',''))');

995: l_vs||'))') then
996:
997: x_isvalid := 'N';
998: zpb_aw.execute('lmt '||l_vs||' remove values(SV.LN.DIM)');
999: l_dim_members := zpb_aw.interp('shw joinchars(joincols(filterlines(values('||l_vs||') joinchars(''\'''' value ''\'''')) '',''))');
1000: if length(l_dim_members) > 0 then
1001: l_dim_members := substr(l_dim_members,1,length(l_dim_members)-1);
1002: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,substr(l_dim_members,1,254));
1003: end if;

Line 1019: zpb_aw.execute('pop SV.LN.DIM ');

1015:
1016: -- if task not defined properly then return success
1017: if l_task_exists <> 'y' then
1018: x_isvalid := 'Y';
1019: zpb_aw.execute('pop SV.LN.DIM ');
1020: -- for bug 4771735
1021: zpb_aw.execute('pop '||l_vs);
1022: return;
1023: end if;

Line 1021: zpb_aw.execute('pop '||l_vs);

1017: if l_task_exists <> 'y' then
1018: x_isvalid := 'Y';
1019: zpb_aw.execute('pop SV.LN.DIM ');
1020: -- for bug 4771735
1021: zpb_aw.execute('pop '||l_vs);
1022: return;
1023: end if;
1024:
1025: zpb_aw.execute('pop SV.LN.DIM ');

Line 1025: zpb_aw.execute('pop SV.LN.DIM ');

1021: zpb_aw.execute('pop '||l_vs);
1022: return;
1023: end if;
1024:
1025: zpb_aw.execute('pop SV.LN.DIM ');
1026: -- for bug 4771735
1027: zpb_aw.execute('pop '||l_vs);
1028:
1029: if length(x_task_name) > 0 then

Line 1027: zpb_aw.execute('pop '||l_vs);

1023: end if;
1024:
1025: zpb_aw.execute('pop SV.LN.DIM ');
1026: -- for bug 4771735
1027: zpb_aw.execute('pop '||l_vs);
1028:
1029: if length(x_task_name) > 0 then
1030: x_task_name := substr(x_task_name,1,length(x_task_name)-1);
1031: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,substr(x_task_name,1,254));

Line 1043: zpb_aw.execute('pop SV.LN.DIM ');

1039: exception
1040: when others then
1041: x_isvalid := 'Y';
1042: if l_pushed_solve = 'Y' then
1043: zpb_aw.execute('pop SV.LN.DIM ');
1044: -- for bug 4771735
1045: zpb_aw.execute('pop '||l_vs);
1046: end if;
1047: zpb_log.write_event(G_PKG_NAME||'.'||l_api_name,to_char(sqlcode) ||':'|| substr(sqlerrm,1,90));

Line 1045: zpb_aw.execute('pop '||l_vs);

1041: x_isvalid := 'Y';
1042: if l_pushed_solve = 'Y' then
1043: zpb_aw.execute('pop SV.LN.DIM ');
1044: -- for bug 4771735
1045: zpb_aw.execute('pop '||l_vs);
1046: end if;
1047: zpb_log.write_event(G_PKG_NAME||'.'||l_api_name,to_char(sqlcode) ||':'|| substr(sqlerrm,1,90));
1048:
1049: end val_solve_gt_than_load;

Line 1088: zpb_aw.execute('push SV.LN.DIM ');

1084: and name in ('TEMPLATE_DATAENTRY_OBJ_PATH','TEMPLATE_DATAENTRY_OBJ_NAME');
1085: begin
1086:
1087: ZPB_LOG.WRITE(G_PKG_NAME || '.' || l_api_name, 'Validating if all generate worksheet tasks have an input line member ' || to_char(p_analysis_cycle_id));
1088: zpb_aw.execute('push SV.LN.DIM ');
1089: l_pushed_solve := 'Y';
1090: x_invalid_tasks_list := '';
1091: l_dataAw := zpb_aw.get_schema||'.'||zpb_aw.get_shared_aw;
1092:

Line 1091: l_dataAw := zpb_aw.get_schema||'.'||zpb_aw.get_shared_aw;

1087: ZPB_LOG.WRITE(G_PKG_NAME || '.' || l_api_name, 'Validating if all generate worksheet tasks have an input line member ' || to_char(p_analysis_cycle_id));
1088: zpb_aw.execute('push SV.LN.DIM ');
1089: l_pushed_solve := 'Y';
1090: x_invalid_tasks_list := '';
1091: l_dataAw := zpb_aw.get_schema||'.'||zpb_aw.get_shared_aw;
1092:
1093: l_line_dim := zpb_aw.interp('shw CM.GETLINEDIM('''||l_dataAw||''')');
1094:
1095: zpb_aw.execute('lmt SV.LN.DIM keep (SV.DEF.VAR(SV.DEF.PROP.DIM ''TYPE'') eq ''INPUT'' or SV.DEF.VAR(SV.DEF.PROP.DIM ''TYPE'') eq ''INITIALIZED'')');

Line 1093: l_line_dim := zpb_aw.interp('shw CM.GETLINEDIM('''||l_dataAw||''')');

1089: l_pushed_solve := 'Y';
1090: x_invalid_tasks_list := '';
1091: l_dataAw := zpb_aw.get_schema||'.'||zpb_aw.get_shared_aw;
1092:
1093: l_line_dim := zpb_aw.interp('shw CM.GETLINEDIM('''||l_dataAw||''')');
1094:
1095: zpb_aw.execute('lmt SV.LN.DIM keep (SV.DEF.VAR(SV.DEF.PROP.DIM ''TYPE'') eq ''INPUT'' or SV.DEF.VAR(SV.DEF.PROP.DIM ''TYPE'') eq ''INITIALIZED'')');
1096:
1097:

Line 1095: zpb_aw.execute('lmt SV.LN.DIM keep (SV.DEF.VAR(SV.DEF.PROP.DIM ''TYPE'') eq ''INPUT'' or SV.DEF.VAR(SV.DEF.PROP.DIM ''TYPE'') eq ''INITIALIZED'')');

1091: l_dataAw := zpb_aw.get_schema||'.'||zpb_aw.get_shared_aw;
1092:
1093: l_line_dim := zpb_aw.interp('shw CM.GETLINEDIM('''||l_dataAw||''')');
1094:
1095: zpb_aw.execute('lmt SV.LN.DIM keep (SV.DEF.VAR(SV.DEF.PROP.DIM ''TYPE'') eq ''INPUT'' or SV.DEF.VAR(SV.DEF.PROP.DIM ''TYPE'') eq ''INITIALIZED'')');
1096:
1097:
1098: -- get the valuseset name
1099: l_vs := '&' || 'joinchars('''||l_dataAw||'!'' obj(prp ''LASTQUERYVS'' '||''''

Line 1126: zpb_aw.execute('pop SV.LN.DIM ');

1122: -- if any query is not properly defined then donot perform any validation
1123: -- and return
1124: if l_path_exists <> 'y' or l_name_exists <> 'y' then
1125: x_isvalid := 'Y';
1126: zpb_aw.execute('pop SV.LN.DIM ');
1127: return;
1128: end if;
1129:
1130: l_query_name := l_query_path ||'/' || l_query_name;

Line 1134: zpb_aw_status.get_status(l_dataAw,l_query_name);

1130: l_query_name := l_query_path ||'/' || l_query_name;
1131: -- l_query_name := 'System Private/Controller/AC11736/MODEL_QUERY_5894';
1132:
1133: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,'query is :' ||l_query_name);
1134: zpb_aw_status.get_status(l_dataAw,l_query_name);
1135:
1136: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,substr(zpb_aw.interp('rpr values('||l_vs||')'),1,254) );
1137: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,substr(zpb_aw.interp('rpr values(SV.LN.DIM)'),1,254) );
1138: zpb_aw.execute('lmt '|| l_vs || ' keep values(SV.LN.DIM)');

Line 1136: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,substr(zpb_aw.interp('rpr values('||l_vs||')'),1,254) );

1132:
1133: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,'query is :' ||l_query_name);
1134: zpb_aw_status.get_status(l_dataAw,l_query_name);
1135:
1136: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,substr(zpb_aw.interp('rpr values('||l_vs||')'),1,254) );
1137: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,substr(zpb_aw.interp('rpr values(SV.LN.DIM)'),1,254) );
1138: zpb_aw.execute('lmt '|| l_vs || ' keep values(SV.LN.DIM)');
1139:
1140: -- add to the list of invalid tasks if the validation fails

Line 1137: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,substr(zpb_aw.interp('rpr values(SV.LN.DIM)'),1,254) );

1133: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,'query is :' ||l_query_name);
1134: zpb_aw_status.get_status(l_dataAw,l_query_name);
1135:
1136: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,substr(zpb_aw.interp('rpr values('||l_vs||')'),1,254) );
1137: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,substr(zpb_aw.interp('rpr values(SV.LN.DIM)'),1,254) );
1138: zpb_aw.execute('lmt '|| l_vs || ' keep values(SV.LN.DIM)');
1139:
1140: -- add to the list of invalid tasks if the validation fails
1141: if zpb_aw.interpbool('shw statlen('||l_vs||') gt 0 ') then

Line 1138: zpb_aw.execute('lmt '|| l_vs || ' keep values(SV.LN.DIM)');

1134: zpb_aw_status.get_status(l_dataAw,l_query_name);
1135:
1136: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,substr(zpb_aw.interp('rpr values('||l_vs||')'),1,254) );
1137: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,substr(zpb_aw.interp('rpr values(SV.LN.DIM)'),1,254) );
1138: zpb_aw.execute('lmt '|| l_vs || ' keep values(SV.LN.DIM)');
1139:
1140: -- add to the list of invalid tasks if the validation fails
1141: if zpb_aw.interpbool('shw statlen('||l_vs||') gt 0 ') then
1142: x_isvalid := 'Y';

Line 1141: if zpb_aw.interpbool('shw statlen('||l_vs||') gt 0 ') then

1137: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,substr(zpb_aw.interp('rpr values(SV.LN.DIM)'),1,254) );
1138: zpb_aw.execute('lmt '|| l_vs || ' keep values(SV.LN.DIM)');
1139:
1140: -- add to the list of invalid tasks if the validation fails
1141: if zpb_aw.interpbool('shw statlen('||l_vs||') gt 0 ') then
1142: x_isvalid := 'Y';
1143: else
1144: x_isvalid := 'N';
1145: x_invalid_tasks_list := x_invalid_tasks_list || ',' ||l_task_name;

Line 1155: zpb_aw.execute('pop SV.LN.DIM ');

1151: if l_task_exists <> 'y' then
1152: x_isvalid := 'Y';
1153: end if;
1154:
1155: zpb_aw.execute('pop SV.LN.DIM ');
1156:
1157: -- remove extra comma from the front
1158: if x_isvalid = 'N' and length(x_invalid_tasks_list) > 0 then
1159: x_invalid_tasks_list := substr(x_invalid_tasks_list,2);

Line 1169: zpb_aw.execute('pop SV.LN.DIM ');

1165: exception
1166: when others then
1167: x_isvalid := 'Y';
1168: if l_pushed_solve = 'Y' then
1169: zpb_aw.execute('pop SV.LN.DIM ');
1170: end if;
1171: zpb_log.write_event(G_PKG_NAME||'.'||l_api_name,to_char(sqlcode) ||':'|| substr(sqlerrm,1,90));
1172:
1173: end validate_generate_worksheet;

Line 1365: l_dataAw := zpb_aw.get_schema||'.'||zpb_aw.get_shared_aw || '!';

1361: -- Initialize API return status to success
1362: x_return_status := FND_API.G_RET_STS_SUCCESS;
1363: x_isvalid := 'Y';
1364: ZPB_LOG.WRITE(G_PKG_NAME || '.' || l_api_name,'validating solve input levels');
1365: l_dataAw := zpb_aw.get_schema||'.'||zpb_aw.get_shared_aw || '!';
1366: l_alldims_invalid := 'N';
1367: zpb_aw.execute('lmt ' || l_dataAw ||'instance to '''|| p_analysis_cycle_id ||'''');
1368: l_lineDim := zpb_aw.interp('shw CM.GETLINEDIM(''SHARED'')');
1369: zpb_aw.execute('lmt ' || l_dataAw ||l_lineDim || ' to values(sv.ln.dim)');

Line 1367: zpb_aw.execute('lmt ' || l_dataAw ||'instance to '''|| p_analysis_cycle_id ||'''');

1363: x_isvalid := 'Y';
1364: ZPB_LOG.WRITE(G_PKG_NAME || '.' || l_api_name,'validating solve input levels');
1365: l_dataAw := zpb_aw.get_schema||'.'||zpb_aw.get_shared_aw || '!';
1366: l_alldims_invalid := 'N';
1367: zpb_aw.execute('lmt ' || l_dataAw ||'instance to '''|| p_analysis_cycle_id ||'''');
1368: l_lineDim := zpb_aw.interp('shw CM.GETLINEDIM(''SHARED'')');
1369: zpb_aw.execute('lmt ' || l_dataAw ||l_lineDim || ' to values(sv.ln.dim)');
1370:
1371: -- first find all lines which have no input selections on any

Line 1368: l_lineDim := zpb_aw.interp('shw CM.GETLINEDIM(''SHARED'')');

1364: ZPB_LOG.WRITE(G_PKG_NAME || '.' || l_api_name,'validating solve input levels');
1365: l_dataAw := zpb_aw.get_schema||'.'||zpb_aw.get_shared_aw || '!';
1366: l_alldims_invalid := 'N';
1367: zpb_aw.execute('lmt ' || l_dataAw ||'instance to '''|| p_analysis_cycle_id ||'''');
1368: l_lineDim := zpb_aw.interp('shw CM.GETLINEDIM(''SHARED'')');
1369: zpb_aw.execute('lmt ' || l_dataAw ||l_lineDim || ' to values(sv.ln.dim)');
1370:
1371: -- first find all lines which have no input selections on any
1372: -- dimension

Line 1369: zpb_aw.execute('lmt ' || l_dataAw ||l_lineDim || ' to values(sv.ln.dim)');

1365: l_dataAw := zpb_aw.get_schema||'.'||zpb_aw.get_shared_aw || '!';
1366: l_alldims_invalid := 'N';
1367: zpb_aw.execute('lmt ' || l_dataAw ||'instance to '''|| p_analysis_cycle_id ||'''');
1368: l_lineDim := zpb_aw.interp('shw CM.GETLINEDIM(''SHARED'')');
1369: zpb_aw.execute('lmt ' || l_dataAw ||l_lineDim || ' to values(sv.ln.dim)');
1370:
1371: -- first find all lines which have no input selections on any
1372: -- dimension
1373: open member_c;

Line 1391: l_timedim := zpb_aw.interp('shw dl.gettimedim');

1387: fetch member_c into l_currentLine;
1388: end loop; -- while member loop
1389: close member_c;
1390:
1391: l_timedim := zpb_aw.interp('shw dl.gettimedim');
1392: -- run the validation for every input level row
1393: -- initialize for traversing the list of dimensions
1394: l_length := nvl(length(p_inputDims),0);
1395:

Line 1411: l_hierdim := zpb_aw.interp('shw obj(prp ''HIERDIM'' ' ||''''

1407: l_nextpos := instr(p_inputDims,',', l_currpos);
1408:
1409: l_currentDim := substr(p_inputDims,l_currpos,l_nextpos - l_currpos);
1410: l_dimValid := 'Y';
1411: l_hierdim := zpb_aw.interp('shw obj(prp ''HIERDIM'' ' ||''''
1412: ||l_dataAw ||l_currentdim ||''')');
1413:
1414: l_cuminputvs := zpb_aw.interp('shw obj(prp ''DINPUTVS'' ' ||''''
1415: ||l_dataAw||l_currentdim ||''')')||'(' ||

Line 1414: l_cuminputvs := zpb_aw.interp('shw obj(prp ''DINPUTVS'' ' ||''''

1410: l_dimValid := 'Y';
1411: l_hierdim := zpb_aw.interp('shw obj(prp ''HIERDIM'' ' ||''''
1412: ||l_dataAw ||l_currentdim ||''')');
1413:
1414: l_cuminputvs := zpb_aw.interp('shw obj(prp ''DINPUTVS'' ' ||''''
1415: ||l_dataAw||l_currentdim ||''')')||'(' ||
1416: l_dataAw ||l_lineDim || ' ' || l_dataAw || 'DINPUTVSPOINTER'
1417: || '(' || l_dataAw || 'UNIVDIM ''' || l_currentDim
1418: || '''))' ;

Line 1421: l_parentRel := zpb_aw.interp('shw obj(prp ''PARENTREL'' ' ||''''

1417: || '(' || l_dataAw || 'UNIVDIM ''' || l_currentDim
1418: || '''))' ;
1419:
1420: --dbms_output.put_line(l_cuminputvs);
1421: l_parentRel := zpb_aw.interp('shw obj(prp ''PARENTREL'' ' ||''''
1422: ||l_dataAw ||l_currentdim ||''')');
1423:
1424: -- check that there are no line items which have null query objects
1425: open nullselections_c(l_currentDim, l_timedim);

Line 1465: substr(zpb_aw.interp('shw values('||

1461: || l_currentLine||l_currentDim||l_inputSelection );
1462:
1463:
1464: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,'cuminputvs ' ||
1465: substr(zpb_aw.interp('shw values('||
1466: l_dataAw|| l_cuminputvs||')'),1,200));
1467:
1468:
1469: zpb_aw.execute('lmt ' || l_dataAw ||l_lineDim || ' to ''' ||

Line 1469: zpb_aw.execute('lmt ' || l_dataAw ||l_lineDim || ' to ''' ||

1465: substr(zpb_aw.interp('shw values('||
1466: l_dataAw|| l_cuminputvs||')'),1,200));
1467:
1468:
1469: zpb_aw.execute('lmt ' || l_dataAw ||l_lineDim || ' to ''' ||
1470: l_currentLine||'''');
1471:
1472: -- verify that no parent-child comination exists on any
1473: -- output hierarchy

Line 1481: zpb_aw.execute('lmt '|| l_dataAw || l_hierdim || ' to ''' || l_hierarchy || '''');

1477: fetch outputhierarchy_c into l_hierarchy;
1478:
1479: while outputhierarchy_c%found loop
1480:
1481: zpb_aw.execute('lmt '|| l_dataAw || l_hierdim || ' to ''' || l_hierarchy || '''');
1482: /*dbms_output.put_line(substr('shw statlen('||l_dataAw||l_cuminputvs||
1483: ') eq statlen(lmt('||l_dataAw||l_cuminputvs
1484: || ' remove ancestors using '|| l_dataAw || l_parentRel ||'))',1,250));
1485: */

Line 1486: if not zpb_aw.interpbool('shw statlen('||l_dataAw||l_cuminputvs||

1482: /*dbms_output.put_line(substr('shw statlen('||l_dataAw||l_cuminputvs||
1483: ') eq statlen(lmt('||l_dataAw||l_cuminputvs
1484: || ' remove ancestors using '|| l_dataAw || l_parentRel ||'))',1,250));
1485: */
1486: if not zpb_aw.interpbool('shw statlen('||l_dataAw||l_cuminputvs||
1487: ') eq statlen(lmt('||l_dataAw||l_cuminputvs
1488: || ' remove ancestors using '|| l_dataAw || l_parentRel ||'))') OR
1489: zpb_aw.interpbool('shw statlen('||l_dataAw||l_cuminputvs||
1490: ') eq 0') then

Line 1489: zpb_aw.interpbool('shw statlen('||l_dataAw||l_cuminputvs||

1485: */
1486: if not zpb_aw.interpbool('shw statlen('||l_dataAw||l_cuminputvs||
1487: ') eq statlen(lmt('||l_dataAw||l_cuminputvs
1488: || ' remove ancestors using '|| l_dataAw || l_parentRel ||'))') OR
1489: zpb_aw.interpbool('shw statlen('||l_dataAw||l_cuminputvs||
1490: ') eq 0') then
1491:
1492: -- get all the line members that use this input selection
1493: l_dimvalid := 'N';

Line 1718: l_timedim := zpb_aw.interp('shw dl.gettimedim');

1714: x_isvalid := 'Y';
1715:
1716: ZPB_LOG.WRITE(G_PKG_NAME || '.' || l_api_name,'validating solve levels');
1717:
1718: l_timedim := zpb_aw.interp('shw dl.gettimedim');
1719:
1720: l_dataAw := zpb_aw.get_schema||'.'||zpb_aw.get_shared_aw || '!';
1721: zpb_aw.execute('lmt ' || l_dataAw ||'instance to '''|| p_analysis_cycle_id ||'''');
1722: l_lineDim := zpb_aw.interp('shw CM.GETLINEDIM(''SHARED'')');

Line 1720: l_dataAw := zpb_aw.get_schema||'.'||zpb_aw.get_shared_aw || '!';

1716: ZPB_LOG.WRITE(G_PKG_NAME || '.' || l_api_name,'validating solve levels');
1717:
1718: l_timedim := zpb_aw.interp('shw dl.gettimedim');
1719:
1720: l_dataAw := zpb_aw.get_schema||'.'||zpb_aw.get_shared_aw || '!';
1721: zpb_aw.execute('lmt ' || l_dataAw ||'instance to '''|| p_analysis_cycle_id ||'''');
1722: l_lineDim := zpb_aw.interp('shw CM.GETLINEDIM(''SHARED'')');
1723: zpb_aw.execute('lmt ' || l_dataAw ||l_lineDim || ' to values(sv.ln.dim)');
1724:

Line 1721: zpb_aw.execute('lmt ' || l_dataAw ||'instance to '''|| p_analysis_cycle_id ||'''');

1717:
1718: l_timedim := zpb_aw.interp('shw dl.gettimedim');
1719:
1720: l_dataAw := zpb_aw.get_schema||'.'||zpb_aw.get_shared_aw || '!';
1721: zpb_aw.execute('lmt ' || l_dataAw ||'instance to '''|| p_analysis_cycle_id ||'''');
1722: l_lineDim := zpb_aw.interp('shw CM.GETLINEDIM(''SHARED'')');
1723: zpb_aw.execute('lmt ' || l_dataAw ||l_lineDim || ' to values(sv.ln.dim)');
1724:
1725:

Line 1722: l_lineDim := zpb_aw.interp('shw CM.GETLINEDIM(''SHARED'')');

1718: l_timedim := zpb_aw.interp('shw dl.gettimedim');
1719:
1720: l_dataAw := zpb_aw.get_schema||'.'||zpb_aw.get_shared_aw || '!';
1721: zpb_aw.execute('lmt ' || l_dataAw ||'instance to '''|| p_analysis_cycle_id ||'''');
1722: l_lineDim := zpb_aw.interp('shw CM.GETLINEDIM(''SHARED'')');
1723: zpb_aw.execute('lmt ' || l_dataAw ||l_lineDim || ' to values(sv.ln.dim)');
1724:
1725:
1726: -- initialize for traversing the list of dimensions

Line 1723: zpb_aw.execute('lmt ' || l_dataAw ||l_lineDim || ' to values(sv.ln.dim)');

1719:
1720: l_dataAw := zpb_aw.get_schema||'.'||zpb_aw.get_shared_aw || '!';
1721: zpb_aw.execute('lmt ' || l_dataAw ||'instance to '''|| p_analysis_cycle_id ||'''');
1722: l_lineDim := zpb_aw.interp('shw CM.GETLINEDIM(''SHARED'')');
1723: zpb_aw.execute('lmt ' || l_dataAw ||l_lineDim || ' to values(sv.ln.dim)');
1724:
1725:
1726: -- initialize for traversing the list of dimensions
1727: l_length := nvl(length(p_outputDims),0);

Line 1741: l_hierdim := zpb_aw.interp('shw obj(prp ''HIERDIM'' ' ||''''

1737: l_nextpos := instr(p_outputDims,',', l_currpos);
1738: --dbms_output.put_line('getting cur dim');
1739: l_currentDim := substr(p_outputDims,l_currpos,l_nextpos - l_currpos);
1740: --dbms_output.put_line(l_currentDim);
1741: l_hierdim := zpb_aw.interp('shw obj(prp ''HIERDIM'' ' ||''''
1742: ||l_dataAw ||l_currentdim ||''')');
1743: l_cuminputvs := zpb_aw.interp('shw obj(prp ''DINPUTVS'' ' ||''''
1744: ||l_dataAw||l_currentdim ||''')')||'(' ||
1745: l_dataAw ||l_lineDim || ' ' || l_dataAw || 'DINPUTVSPOINTER'

Line 1743: l_cuminputvs := zpb_aw.interp('shw obj(prp ''DINPUTVS'' ' ||''''

1739: l_currentDim := substr(p_outputDims,l_currpos,l_nextpos - l_currpos);
1740: --dbms_output.put_line(l_currentDim);
1741: l_hierdim := zpb_aw.interp('shw obj(prp ''HIERDIM'' ' ||''''
1742: ||l_dataAw ||l_currentdim ||''')');
1743: l_cuminputvs := zpb_aw.interp('shw obj(prp ''DINPUTVS'' ' ||''''
1744: ||l_dataAw||l_currentdim ||''')')||'(' ||
1745: l_dataAw ||l_lineDim || ' ' || l_dataAw || 'DINPUTVSPOINTER'
1746: || '(' || l_dataAw || 'UNIVDIM ''' || l_currentDim
1747: || '''))' ;

Line 1748: l_parentRel := zpb_aw.interp('shw obj(prp ''PARENTREL'' ' ||''''

1744: ||l_dataAw||l_currentdim ||''')')||'(' ||
1745: l_dataAw ||l_lineDim || ' ' || l_dataAw || 'DINPUTVSPOINTER'
1746: || '(' || l_dataAw || 'UNIVDIM ''' || l_currentDim
1747: || '''))' ;
1748: l_parentRel := zpb_aw.interp('shw obj(prp ''PARENTREL'' ' ||''''
1749: ||l_dataAw ||l_currentdim ||''')');
1750: l_outputvs := zpb_aw.interp('shw obj(prp ''HOUTPUTVS'' ' ||''''
1751: ||l_dataAw ||l_currentdim ||''')') ||'(' ||
1752: l_dataAw ||l_lineDim || ' ' || l_dataAw || 'HOUTPUTVSPOINTER.'

Line 1750: l_outputvs := zpb_aw.interp('shw obj(prp ''HOUTPUTVS'' ' ||''''

1746: || '(' || l_dataAw || 'UNIVDIM ''' || l_currentDim
1747: || '''))' ;
1748: l_parentRel := zpb_aw.interp('shw obj(prp ''PARENTREL'' ' ||''''
1749: ||l_dataAw ||l_currentdim ||''')');
1750: l_outputvs := zpb_aw.interp('shw obj(prp ''HOUTPUTVS'' ' ||''''
1751: ||l_dataAw ||l_currentdim ||''')') ||'(' ||
1752: l_dataAw ||l_lineDim || ' ' || l_dataAw || 'HOUTPUTVSPOINTER.'
1753: || zpb_aw.interp('shw obj(prp ''NAMEFRAGMENT'' ' ||''''
1754: ||l_dataAw ||l_currentdim ||''')')

Line 1753: || zpb_aw.interp('shw obj(prp ''NAMEFRAGMENT'' ' ||''''

1749: ||l_dataAw ||l_currentdim ||''')');
1750: l_outputvs := zpb_aw.interp('shw obj(prp ''HOUTPUTVS'' ' ||''''
1751: ||l_dataAw ||l_currentdim ||''')') ||'(' ||
1752: l_dataAw ||l_lineDim || ' ' || l_dataAw || 'HOUTPUTVSPOINTER.'
1753: || zpb_aw.interp('shw obj(prp ''NAMEFRAGMENT'' ' ||''''
1754: ||l_dataAw ||l_currentdim ||''')')
1755: || ')' ;
1756: -- check that there are no line items which have null query objects
1757:

Line 1772: zpb_aw.execute('lmt ' || l_dataAw ||l_lineDim || ' to ''' ||

1768:
1769: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name, 'cur line = '
1770: || l_currentLine||l_currentDim||l_outputSelection );
1771:
1772: zpb_aw.execute('lmt ' || l_dataAw ||l_lineDim || ' to ''' ||
1773: l_currentLine||'''');
1774:
1775: -- verify that no parent-child comination exists on any
1776: -- output hierarchy

Line 1777: zpb_aw.execute('lmt '|| l_dataAw || l_hierdim || ' to ''' || l_hierarchy || '''');

1773: l_currentLine||'''');
1774:
1775: -- verify that no parent-child comination exists on any
1776: -- output hierarchy
1777: zpb_aw.execute('lmt '|| l_dataAw || l_hierdim || ' to ''' || l_hierarchy || '''');
1778: /*dbms_output.put_line('shw statlen(lmt('||l_dataAw||l_outputvs
1779: || ' remove lmt('||l_dataAw||l_cuminputvs ||
1780: ' add descendants using ' || l_dataAw ||
1781: l_parentRel || '))) ne 0');

Line 1790: if zpb_aw.interpbool('shw statlen(lmt('||l_dataAw||l_outputvs

1786: --
1787: -- check 2:
1788: -- there is at least one i/s member who is feeding an o/s
1789: -- member by being its ancestor or equal to it
1790: if zpb_aw.interpbool('shw statlen(lmt('||l_dataAw||l_outputvs
1791: || ' remove lmt('||l_dataAw||l_cuminputvs ||
1792: ' add descendants using ' || l_dataAw ||
1793: l_parentRel || '))) ne 0')
1794: then

Line 1930: l_dataAw := zpb_aw.get_schema||'.'||zpb_aw.get_shared_aw;

1926:
1927: ZPB_LOG.WRITE(G_PKG_NAME || '.' || l_api_name, 'Validating if template lines exist in model ' || to_char(p_analysis_cycle_id) || '.');
1928: x_isvalid := 'Y';
1929: -- initialize_solve_object(p_analysis_cycle_id);
1930: l_dataAw := zpb_aw.get_schema||'.'||zpb_aw.get_shared_aw;
1931:
1932: l_line_dim := zpb_aw.interp('shw CM.GETLINEDIM('''||l_dataAw||''')');
1933:
1934: open query_model;

Line 1932: l_line_dim := zpb_aw.interp('shw CM.GETLINEDIM('''||l_dataAw||''')');

1928: x_isvalid := 'Y';
1929: -- initialize_solve_object(p_analysis_cycle_id);
1930: l_dataAw := zpb_aw.get_schema||'.'||zpb_aw.get_shared_aw;
1931:
1932: l_line_dim := zpb_aw.interp('shw CM.GETLINEDIM('''||l_dataAw||''')');
1933:
1934: open query_model;
1935: fetch query_model into l_model_query;
1936:

Line 2101: zpb_aw.execute('push SV.LN.DIM ');

2097: -- Initialize API return status to success
2098: x_return_status := FND_API.G_RET_STS_SUCCESS;
2099:
2100: -- initialize_solve_object(p_analysis_cycle_id);
2101: zpb_aw.execute('push SV.LN.DIM ');
2102: l_pushed_solve := 'Y';
2103: l_dataAw := zpb_aw.get_schema||'.'||zpb_aw.get_shared_aw;
2104:
2105: l_line_dim := zpb_aw.interp('shw CM.GETLINEDIM('''||l_dataAw||''')');

Line 2103: l_dataAw := zpb_aw.get_schema||'.'||zpb_aw.get_shared_aw;

2099:
2100: -- initialize_solve_object(p_analysis_cycle_id);
2101: zpb_aw.execute('push SV.LN.DIM ');
2102: l_pushed_solve := 'Y';
2103: l_dataAw := zpb_aw.get_schema||'.'||zpb_aw.get_shared_aw;
2104:
2105: l_line_dim := zpb_aw.interp('shw CM.GETLINEDIM('''||l_dataAw||''')');
2106:
2107: -- limit dimension to non-initialized and input

Line 2105: l_line_dim := zpb_aw.interp('shw CM.GETLINEDIM('''||l_dataAw||''')');

2101: zpb_aw.execute('push SV.LN.DIM ');
2102: l_pushed_solve := 'Y';
2103: l_dataAw := zpb_aw.get_schema||'.'||zpb_aw.get_shared_aw;
2104:
2105: l_line_dim := zpb_aw.interp('shw CM.GETLINEDIM('''||l_dataAw||''')');
2106:
2107: -- limit dimension to non-initialized and input
2108: zpb_aw.execute('lmt SV.LN.DIM keep SV.DEF.VAR(SV.DEF.PROP.DIM ''TYPE'') eq ''INPUT'' and nafill(SV.DEF.VAR(SV.DEF.PROP.DIM ''DATA_SOURCE''),'''') eq ''''');
2109:

Line 2108: zpb_aw.execute('lmt SV.LN.DIM keep SV.DEF.VAR(SV.DEF.PROP.DIM ''TYPE'') eq ''INPUT'' and nafill(SV.DEF.VAR(SV.DEF.PROP.DIM ''DATA_SOURCE''),'''') eq ''''');

2104:
2105: l_line_dim := zpb_aw.interp('shw CM.GETLINEDIM('''||l_dataAw||''')');
2106:
2107: -- limit dimension to non-initialized and input
2108: zpb_aw.execute('lmt SV.LN.DIM keep SV.DEF.VAR(SV.DEF.PROP.DIM ''TYPE'') eq ''INPUT'' and nafill(SV.DEF.VAR(SV.DEF.PROP.DIM ''DATA_SOURCE''),'''') eq ''''');
2109:
2110:
2111: -- get the valuseset name
2112: l_vs := '&' || 'joinchars('''||l_dataAw||'!'' obj(prp ''LASTQUERYVS'' '||''''

Line 2137: zpb_aw.execute('pop SV.LN.DIM ');

2133: -- if any query is not properly defined then donot perform any validation
2134: -- and return. Allso return if all line items are being selected
2135: if l_path_exists <> 'y' or l_name_exists <> 'y' then
2136: x_isvalid := 'Y';
2137: zpb_aw.execute('pop SV.LN.DIM ');
2138: return;
2139: end if;
2140:
2141: l_query_name := l_query_path ||'/' || l_query_name;

Line 2145: zpb_aw_status.get_status(l_dataAw,l_query_name);

2141: l_query_name := l_query_path ||'/' || l_query_name;
2142: -- l_query_name := 'System Private/Controller/AC11736/MODEL_QUERY_5894';
2143:
2144: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,'query is :' ||l_query_name);
2145: zpb_aw_status.get_status(l_dataAw,l_query_name);
2146:
2147: --zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,substr(zpb_aw.interp('rpr values('||l_vs||')'),1,254) );
2148:
2149: zpb_aw.execute(' lmt SV.LN.DIM keep filterlines(values(sv.ln.dim) if inlist(values('||l_vs||') value) then na else value)');

Line 2147: --zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,substr(zpb_aw.interp('rpr values('||l_vs||')'),1,254) );

2143:
2144: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,'query is :' ||l_query_name);
2145: zpb_aw_status.get_status(l_dataAw,l_query_name);
2146:
2147: --zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,substr(zpb_aw.interp('rpr values('||l_vs||')'),1,254) );
2148:
2149: zpb_aw.execute(' lmt SV.LN.DIM keep filterlines(values(sv.ln.dim) if inlist(values('||l_vs||') value) then na else value)');
2150: end loop;
2151:

Line 2149: zpb_aw.execute(' lmt SV.LN.DIM keep filterlines(values(sv.ln.dim) if inlist(values('||l_vs||') value) then na else value)');

2145: zpb_aw_status.get_status(l_dataAw,l_query_name);
2146:
2147: --zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,substr(zpb_aw.interp('rpr values('||l_vs||')'),1,254) );
2148:
2149: zpb_aw.execute(' lmt SV.LN.DIM keep filterlines(values(sv.ln.dim) if inlist(values('||l_vs||') value) then na else value)');
2150: end loop;
2151:
2152:
2153: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,substr(zpb_aw.interp('rpr values(SV.LN.DIM)'),1,255) );

Line 2153: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,substr(zpb_aw.interp('rpr values(SV.LN.DIM)'),1,255) );

2149: zpb_aw.execute(' lmt SV.LN.DIM keep filterlines(values(sv.ln.dim) if inlist(values('||l_vs||') value) then na else value)');
2150: end loop;
2151:
2152:
2153: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,substr(zpb_aw.interp('rpr values(SV.LN.DIM)'),1,255) );
2154:
2155: if zpb_aw.interpbool('shw statlen(SV.LN.DIM) gt 0 ') then
2156: x_isvalid := 'N';
2157: x_dim_members := zpb_aw.interp('shw joinchars(joincols(filterlines(values(SV.LN.DIM) joinchars(''\'''' value ''\'''')) '',''))');

Line 2155: if zpb_aw.interpbool('shw statlen(SV.LN.DIM) gt 0 ') then

2151:
2152:
2153: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,substr(zpb_aw.interp('rpr values(SV.LN.DIM)'),1,255) );
2154:
2155: if zpb_aw.interpbool('shw statlen(SV.LN.DIM) gt 0 ') then
2156: x_isvalid := 'N';
2157: x_dim_members := zpb_aw.interp('shw joinchars(joincols(filterlines(values(SV.LN.DIM) joinchars(''\'''' value ''\'''')) '',''))');
2158: if length(x_dim_members) > 0 then
2159: x_dim_members := substr(x_dim_members,1,length(x_dim_members)-1);

Line 2157: x_dim_members := zpb_aw.interp('shw joinchars(joincols(filterlines(values(SV.LN.DIM) joinchars(''\'''' value ''\'''')) '',''))');

2153: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,substr(zpb_aw.interp('rpr values(SV.LN.DIM)'),1,255) );
2154:
2155: if zpb_aw.interpbool('shw statlen(SV.LN.DIM) gt 0 ') then
2156: x_isvalid := 'N';
2157: x_dim_members := zpb_aw.interp('shw joinchars(joincols(filterlines(values(SV.LN.DIM) joinchars(''\'''' value ''\'''')) '',''))');
2158: if length(x_dim_members) > 0 then
2159: x_dim_members := substr(x_dim_members,1,length(x_dim_members)-1);
2160: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,substr(x_dim_members,1,254));
2161: end if;

Line 2166: zpb_aw.execute('pop SV.LN.DIM ');

2162: else
2163: x_isvalid := 'Y';
2164: end if;
2165:
2166: zpb_aw.execute('pop SV.LN.DIM ');
2167: return;
2168:
2169: exception
2170: WHEN FND_API.G_EXC_ERROR THEN

Line 2276: l_dataAw := zpb_aw.get_schema||'.'||zpb_aw.get_shared_aw(fnd_global.user_id);

2272: x_return_status := FND_API.G_RET_STS_SUCCESS;
2273:
2274:
2275: ZPB_LOG.WRITE(G_PKG_NAME || '.' || l_api_name,'validating solve levels');
2276: l_dataAw := zpb_aw.get_schema||'.'||zpb_aw.get_shared_aw(fnd_global.user_id);
2277: x_isvalid := 'Y';
2278: l_timedim := zpb_aw.interp('shw dl.gettimedim');
2279:
2280: open output_info;

Line 2278: l_timedim := zpb_aw.interp('shw dl.gettimedim');

2274:
2275: ZPB_LOG.WRITE(G_PKG_NAME || '.' || l_api_name,'validating solve levels');
2276: l_dataAw := zpb_aw.get_schema||'.'||zpb_aw.get_shared_aw(fnd_global.user_id);
2277: x_isvalid := 'Y';
2278: l_timedim := zpb_aw.interp('shw dl.gettimedim');
2279:
2280: open output_info;
2281:
2282: -- run the validation for every output level row

Line 2298: l_common_hier := zpb_aw.interp('shw cm.cmp.level('''||l_dataAw||

2294: fetch input_info into l_input_selection_name;
2295:
2296: while input_info%found loop
2297: l_inp_level_found := 'y';
2298: l_common_hier := zpb_aw.interp('shw cm.cmp.level('''||l_dataAw||
2299: ''','''||l_input_selection_name ||
2300: ''','''||l_output_selection_name ||
2301: ''','''||l_hierarchy ||
2302: ''','''||l_dim||''')');

Line 2570: l_dataAw := zpb_aw.get_schema||'.'||zpb_aw.get_shared_aw || '!';

2566: -- Initialize API return status to success
2567: x_return_status := FND_API.G_RET_STS_SUCCESS;
2568: x_isvalid := 'Y';
2569: ZPB_LOG.WRITE(G_PKG_NAME || '.' || l_api_name,'validating solve output levels');
2570: l_dataAw := zpb_aw.get_schema||'.'||zpb_aw.get_shared_aw || '!';
2571: l_alldims_invalid := 'N';
2572: zpb_aw.execute('lmt ' || l_dataAw ||'instance to '''|| p_analysis_cycle_id ||'''');
2573: l_lineDim := zpb_aw.interp('shw CM.GETLINEDIM(''SHARED'')');
2574: zpb_aw.execute('lmt ' || l_dataAw ||l_lineDim || ' to values(sv.ln.dim)');

Line 2572: zpb_aw.execute('lmt ' || l_dataAw ||'instance to '''|| p_analysis_cycle_id ||'''');

2568: x_isvalid := 'Y';
2569: ZPB_LOG.WRITE(G_PKG_NAME || '.' || l_api_name,'validating solve output levels');
2570: l_dataAw := zpb_aw.get_schema||'.'||zpb_aw.get_shared_aw || '!';
2571: l_alldims_invalid := 'N';
2572: zpb_aw.execute('lmt ' || l_dataAw ||'instance to '''|| p_analysis_cycle_id ||'''');
2573: l_lineDim := zpb_aw.interp('shw CM.GETLINEDIM(''SHARED'')');
2574: zpb_aw.execute('lmt ' || l_dataAw ||l_lineDim || ' to values(sv.ln.dim)');
2575: -- first find all lines which have no output selections on any
2576: -- dimension

Line 2573: l_lineDim := zpb_aw.interp('shw CM.GETLINEDIM(''SHARED'')');

2569: ZPB_LOG.WRITE(G_PKG_NAME || '.' || l_api_name,'validating solve output levels');
2570: l_dataAw := zpb_aw.get_schema||'.'||zpb_aw.get_shared_aw || '!';
2571: l_alldims_invalid := 'N';
2572: zpb_aw.execute('lmt ' || l_dataAw ||'instance to '''|| p_analysis_cycle_id ||'''');
2573: l_lineDim := zpb_aw.interp('shw CM.GETLINEDIM(''SHARED'')');
2574: zpb_aw.execute('lmt ' || l_dataAw ||l_lineDim || ' to values(sv.ln.dim)');
2575: -- first find all lines which have no output selections on any
2576: -- dimension
2577: open member_c;

Line 2574: zpb_aw.execute('lmt ' || l_dataAw ||l_lineDim || ' to values(sv.ln.dim)');

2570: l_dataAw := zpb_aw.get_schema||'.'||zpb_aw.get_shared_aw || '!';
2571: l_alldims_invalid := 'N';
2572: zpb_aw.execute('lmt ' || l_dataAw ||'instance to '''|| p_analysis_cycle_id ||'''');
2573: l_lineDim := zpb_aw.interp('shw CM.GETLINEDIM(''SHARED'')');
2574: zpb_aw.execute('lmt ' || l_dataAw ||l_lineDim || ' to values(sv.ln.dim)');
2575: -- first find all lines which have no output selections on any
2576: -- dimension
2577: open member_c;
2578: fetch member_c into l_currentLine;

Line 2596: l_timedim := zpb_aw.interp('shw dl.gettimedim');

2592: end loop; -- while member loop
2593: close member_c;
2594:
2595:
2596: l_timedim := zpb_aw.interp('shw dl.gettimedim');
2597: -- run the validation for every output selection row
2598: -- initialize for traversing the list of dimensions
2599: l_length := nvl(length(p_outputDims),0);
2600:

Line 2614: l_hierdim := l_dataAw || zpb_aw.interp('shw obj(prp ''HIERDIM'' ' ||''''

2610:
2611: l_nextpos := instr(p_outputDims,',', l_currpos);
2612: l_currentDim := substr(p_outputDims,l_currpos,l_nextpos - l_currpos);
2613: l_dimValid := 'Y';
2614: l_hierdim := l_dataAw || zpb_aw.interp('shw obj(prp ''HIERDIM'' ' ||''''
2615: ||l_dataAw ||l_currentdim ||''')');
2616: l_outputvs := l_dataAw || zpb_aw.interp('shw obj(prp ''HOUTPUTVS'' ' ||''''
2617: ||l_dataAw ||l_currentdim ||''')') ||'(' ||
2618: l_dataAw ||l_lineDim || ' ' || l_dataAw || 'HOUTPUTVSPOINTER.'

Line 2616: l_outputvs := l_dataAw || zpb_aw.interp('shw obj(prp ''HOUTPUTVS'' ' ||''''

2612: l_currentDim := substr(p_outputDims,l_currpos,l_nextpos - l_currpos);
2613: l_dimValid := 'Y';
2614: l_hierdim := l_dataAw || zpb_aw.interp('shw obj(prp ''HIERDIM'' ' ||''''
2615: ||l_dataAw ||l_currentdim ||''')');
2616: l_outputvs := l_dataAw || zpb_aw.interp('shw obj(prp ''HOUTPUTVS'' ' ||''''
2617: ||l_dataAw ||l_currentdim ||''')') ||'(' ||
2618: l_dataAw ||l_lineDim || ' ' || l_dataAw || 'HOUTPUTVSPOINTER.'
2619: || zpb_aw.interp('shw obj(prp ''NAMEFRAGMENT'' ' ||''''
2620: ||l_dataAw ||l_currentdim ||''')')

Line 2619: || zpb_aw.interp('shw obj(prp ''NAMEFRAGMENT'' ' ||''''

2615: ||l_dataAw ||l_currentdim ||''')');
2616: l_outputvs := l_dataAw || zpb_aw.interp('shw obj(prp ''HOUTPUTVS'' ' ||''''
2617: ||l_dataAw ||l_currentdim ||''')') ||'(' ||
2618: l_dataAw ||l_lineDim || ' ' || l_dataAw || 'HOUTPUTVSPOINTER.'
2619: || zpb_aw.interp('shw obj(prp ''NAMEFRAGMENT'' ' ||''''
2620: ||l_dataAw ||l_currentdim ||''')')
2621: || ')' ;
2622:
2623: --dbms_output.put_line(l_outputvs);

Line 2624: l_cuminputvs := l_dataAw || zpb_aw.interp('shw obj(prp ''DINPUTVS'' ' ||''''

2620: ||l_dataAw ||l_currentdim ||''')')
2621: || ')' ;
2622:
2623: --dbms_output.put_line(l_outputvs);
2624: l_cuminputvs := l_dataAw || zpb_aw.interp('shw obj(prp ''DINPUTVS'' ' ||''''
2625: ||l_dataAw ||l_currentdim ||''')');
2626: l_parentRel := l_dataAw || zpb_aw.interp('shw obj(prp ''PARENTREL'' ' ||''''
2627: ||l_dataAw ||l_currentdim ||''')');
2628:

Line 2626: l_parentRel := l_dataAw || zpb_aw.interp('shw obj(prp ''PARENTREL'' ' ||''''

2622:
2623: --dbms_output.put_line(l_outputvs);
2624: l_cuminputvs := l_dataAw || zpb_aw.interp('shw obj(prp ''DINPUTVS'' ' ||''''
2625: ||l_dataAw ||l_currentdim ||''')');
2626: l_parentRel := l_dataAw || zpb_aw.interp('shw obj(prp ''PARENTREL'' ' ||''''
2627: ||l_dataAw ||l_currentdim ||''')');
2628:
2629: -- check that there are no line items which have null query objects
2630: open nullselections_c(l_currentDim, l_timedim);

Line 2663: zpb_aw.execute('lmt ' || l_dataAw ||l_lineDim || ' to ''' || l_currentLine||'''');

2659: open selection_member_c(l_currentDim,l_outputSelection);
2660: fetch selection_member_c into l_currentLine;
2661: close selection_member_c;
2662: -- dbms_output.put_line('cur line = ' || l_currentLine||l_currentDim||l_outputSelection );
2663: zpb_aw.execute('lmt ' || l_dataAw ||l_lineDim || ' to ''' || l_currentLine||'''');
2664:
2665: -- verify that no output selection member is an ancestor of
2666: -- an input selection member
2667: zpb_aw.execute('lmt '|| l_hierdim || ' to ''' || l_hierarchy||'''');

Line 2667: zpb_aw.execute('lmt '|| l_hierdim || ' to ''' || l_hierarchy||'''');

2663: zpb_aw.execute('lmt ' || l_dataAw ||l_lineDim || ' to ''' || l_currentLine||'''');
2664:
2665: -- verify that no output selection member is an ancestor of
2666: -- an input selection member
2667: zpb_aw.execute('lmt '|| l_hierdim || ' to ''' || l_hierarchy||'''');
2668:
2669:
2670:
2671:

Line 2672: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,zpb_aw.interp('shw statlen(' || l_outputvs ||') ne statlen('||

2668:
2669:
2670:
2671:
2672: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,zpb_aw.interp('shw statlen(' || l_outputvs ||') ne statlen('||
2673: 'lmt(' || l_outputvs|| ' remove lmt(lmt('
2674: ||l_cuminputvs || ' add ancestors using '||l_parentRel||
2675: ') remove ' || l_cuminputvs ||')))'));
2676:

Line 2684: if zpb_aw.interpbool('shw statlen(' || l_outputvs ||') ne statlen('||

2680: -- condition 2: output selection valueset is empty
2681:
2682: -- condition 3: no parent-child relation in the output hierarchy itself
2683:
2684: if zpb_aw.interpbool('shw statlen(' || l_outputvs ||') ne statlen('||
2685: 'lmt(' || l_outputvs|| ' remove lmt(lmt(' ||
2686: l_cuminputvs || ' add ancestors using '||l_parentRel||
2687: ') remove ' || l_cuminputvs ||')))')
2688: OR

Line 2689: zpb_aw.interpbool('shw statlen('|| l_outputvs|| ') eq 0')

2685: 'lmt(' || l_outputvs|| ' remove lmt(lmt(' ||
2686: l_cuminputvs || ' add ancestors using '||l_parentRel||
2687: ') remove ' || l_cuminputvs ||')))')
2688: OR
2689: zpb_aw.interpbool('shw statlen('|| l_outputvs|| ') eq 0')
2690: OR
2691: zpb_aw.interpbool('shw statlen('||l_outputvs||') ne ' ||
2692: ' statlen(lmt(' ||l_outputvs ||
2693: ' remove ancestors using ' || l_parentRel || '))') then

Line 2691: zpb_aw.interpbool('shw statlen('||l_outputvs||') ne ' ||

2687: ') remove ' || l_cuminputvs ||')))')
2688: OR
2689: zpb_aw.interpbool('shw statlen('|| l_outputvs|| ') eq 0')
2690: OR
2691: zpb_aw.interpbool('shw statlen('||l_outputvs||') ne ' ||
2692: ' statlen(lmt(' ||l_outputvs ||
2693: ' remove ancestors using ' || l_parentRel || '))') then
2694:
2695: -- get all the line members that use this output selection

Line 2824: l_dataAw := zpb_aw.get_schema||'.'||zpb_aw.get_shared_aw||'!';

2820: -- Initialize API return status to success
2821: x_return_status := FND_API.G_RET_STS_SUCCESS;
2822:
2823: ZPB_LOG.WRITE(G_PKG_NAME || '.' || l_api_name,'validating solve levels');
2824: l_dataAw := zpb_aw.get_schema||'.'||zpb_aw.get_shared_aw||'!';
2825: x_isvalid := 'Y';
2826: l_timedim := zpb_aw.interp('shw dl.gettimedim');
2827:
2828: -- find all the hierarchies that this level belongs to

Line 2826: l_timedim := zpb_aw.interp('shw dl.gettimedim');

2822:
2823: ZPB_LOG.WRITE(G_PKG_NAME || '.' || l_api_name,'validating solve levels');
2824: l_dataAw := zpb_aw.get_schema||'.'||zpb_aw.get_shared_aw||'!';
2825: x_isvalid := 'Y';
2826: l_timedim := zpb_aw.interp('shw dl.gettimedim');
2827:
2828: -- find all the hierarchies that this level belongs to
2829: l_hierdim := l_dataAw || zpb_aw.interp('shw obj(prp ''HIERDIM'' ' ||''''
2830: ||l_dataAw ||l_timedim||''')');

Line 2829: l_hierdim := l_dataAw || zpb_aw.interp('shw obj(prp ''HIERDIM'' ' ||''''

2825: x_isvalid := 'Y';
2826: l_timedim := zpb_aw.interp('shw dl.gettimedim');
2827:
2828: -- find all the hierarchies that this level belongs to
2829: l_hierdim := l_dataAw || zpb_aw.interp('shw obj(prp ''HIERDIM'' ' ||''''
2830: ||l_dataAw ||l_timedim||''')');
2831: l_hierlvlvs := l_dataAw || zpb_aw.interp('shw obj(prp ''HIERLEVELVS'' ' ||''''
2832: ||l_hierdim ||''')');
2833:

Line 2831: l_hierlvlvs := l_dataAw || zpb_aw.interp('shw obj(prp ''HIERLEVELVS'' ' ||''''

2827:
2828: -- find all the hierarchies that this level belongs to
2829: l_hierdim := l_dataAw || zpb_aw.interp('shw obj(prp ''HIERDIM'' ' ||''''
2830: ||l_dataAw ||l_timedim||''')');
2831: l_hierlvlvs := l_dataAw || zpb_aw.interp('shw obj(prp ''HIERLEVELVS'' ' ||''''
2832: ||l_hierdim ||''')');
2833:
2834: zpb_aw.execute('lmt ' || l_hierdim ||' to instat( ' || l_hierlvlvs || ' ''' ||
2835: p_hrz_level||''')');

Line 2834: zpb_aw.execute('lmt ' || l_hierdim ||' to instat( ' || l_hierlvlvs || ' ''' ||

2830: ||l_dataAw ||l_timedim||''')');
2831: l_hierlvlvs := l_dataAw || zpb_aw.interp('shw obj(prp ''HIERLEVELVS'' ' ||''''
2832: ||l_hierdim ||''')');
2833:
2834: zpb_aw.execute('lmt ' || l_hierdim ||' to instat( ' || l_hierlvlvs || ' ''' ||
2835: p_hrz_level||''')');
2836: l_hierlist := zpb_aw.interp('shw joinchars(joincols(filterlines(charlist('||
2837: l_hierdim|| ') joinchars(''\'''' value ''\'''')) '',''))');
2838: -- remove the trailing comma

Line 2836: l_hierlist := zpb_aw.interp('shw joinchars(joincols(filterlines(charlist('||

2832: ||l_hierdim ||''')');
2833:
2834: zpb_aw.execute('lmt ' || l_hierdim ||' to instat( ' || l_hierlvlvs || ' ''' ||
2835: p_hrz_level||''')');
2836: l_hierlist := zpb_aw.interp('shw joinchars(joincols(filterlines(charlist('||
2837: l_hierdim|| ') joinchars(''\'''' value ''\'''')) '',''))');
2838: -- remove the trailing comma
2839: l_hierlist := '(' || substr(l_hierlist,1,length(l_hierlist)-1) || ')';
2840: