APPS.ZPB_DC_DISTRIBUTE dependencies on ZPB_AW

Line 231: --ZPB_AW.INITIALIZE_USER(p_api_version => 1.0,

227: --We know that user's AW is now available for distribution
228: --Do distribution
229: zpb_log.WRITE_STATEMENT(l_api_name ,'User AW available');
230: --Initialise User AW and attach read write
231: --ZPB_AW.INITIALIZE_USER(p_api_version => 1.0,
232: -- p_init_msg_list => FND_API.G_FALSE,
233: -- p_validation_level => p_validation_level,
234: -- x_return_status => x_return_status,
235: -- x_msg_count => x_msg_count,

Line 339: zpb_aw.EXECUTE(l_command);

335: ',' || '''' || 'S' || '''' ||
336: ',' || '''' || l_currency_view || '''' ||
337: ')';
338: zpb_log.WRITE_STATEMENT(l_api_name ,'Create Structure Command =' || l_command);
339: zpb_aw.EXECUTE(l_command);
340: zpb_log.WRITE_STATEMENT(l_api_name ,'Structure Created');
341: END IF;
342:
343: --Do data distribution

Line 353: zpb_aw.EXECUTE(l_command);

349: ',' || '''' || 'D' || '''' ||
350: ',' || '''' || l_currency_view || '''' ||
351: ')';
352: zpb_log.WRITE_STATEMENT(l_api_name ,'Distribute Data Command =' || l_command);
353: zpb_aw.EXECUTE(l_command);
354: zpb_log.WRITE_STATEMENT(l_api_name ,'Distribute Distributed');
355:
356: l_command := 'call sv.exe.dcsolve('''||l_template_id||''' '''||
357: l_dist_pending_row_rec.ac_instance_id||''' '''||

Line 361: zpb_aw.EXECUTE(l_command);

357: l_dist_pending_row_rec.ac_instance_id||''' '''||
358: l_dist_pending_row_rec.generate_template_task_id||''')';
359:
360: zpb_log.WRITE_STATEMENT(l_api_name ,'Recalc Command =' || l_command);
361: zpb_aw.EXECUTE(l_command);
362: zpb_log.WRITE_STATEMENT(l_api_name ,'Recalculated');
363:
364: --Commit data to AW
365: l_command := 'call pa.commit()';

Line 366: zpb_aw.EXECUTE(l_command);

362: zpb_log.WRITE_STATEMENT(l_api_name ,'Recalculated');
363:
364: --Commit data to AW
365: l_command := 'call pa.commit()';
366: zpb_aw.EXECUTE(l_command);
367: zpb_log.WRITE_STATEMENT(l_api_name ,'Data Committed');
368:
369: --Update ZPB_DC_OBJECTS with the currency
370: IF (l_currency_flag = 'Y') THEN

Line 387: ZPB_AW.clean_workspace (

383:
384: --All distribution is done
385: --DO the AW clean up
386: --
387: ZPB_AW.clean_workspace (
388: p_api_version => 1.0,
389: p_init_msg_list => FND_API.G_FALSE,
390: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
391: x_return_status => l_return_status,