[Home] [Help]
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,
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)'));
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||''')');
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.
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;