APPS.WIP_SFCB_UTILITIES dependencies on WIP_PROD_INDICATORS

Line 119: WIP_PROD_INDICATORS.Populate_Efficiency(

115: p_errmesg := 'Failed in Efficiency Phase : '||x_phase|| substr(SQLERRM,1,125);
116: return ;
117: end ;
118:
119: WIP_PROD_INDICATORS.Populate_Efficiency(
120: p_group_id => x_temp_group_id,
121: p_organization_id => p_organization_id,
122: p_date_from => p_date_from,
123: p_date_to => p_date_to,

Line 143: WIP_PROD_INDICATORS.Populate_Efficiency(

139: /* The new section added for the department production indicators
140: */
141: ELSIF p_department_id IS NOT NULL AND p_resource_id IS NULL THEN
142:
143: WIP_PROD_INDICATORS.Populate_Efficiency(
144: p_group_id => x_main_group_id,
145: p_organization_id => p_organization_id,
146: p_date_from => p_date_from,
147: p_date_to => p_date_to,

Line 237: WIP_PROD_INDICATORS.Populate_Utilization(

233: p_errmesg := 'Failed in Utilization Phase : '||x_phase|| substr(SQLERRM,1,125);
234: return ;
235: end ;
236:
237: WIP_PROD_INDICATORS.Populate_Utilization(
238: p_group_id => x_temp_group_id,
239: p_organization_id => p_organization_id,
240: p_date_from => p_date_from,
241: p_date_to => p_date_to,

Line 262: WIP_PROD_INDICATORS.Populate_Utilization(

258:
259: ELSIF p_department_id IS NOT NULL AND p_resource_id IS NULL then
260:
261:
262: WIP_PROD_INDICATORS.Populate_Utilization(
263: p_group_id => x_main_group_id,
264: p_organization_id => p_organization_id,
265: p_date_from => p_date_from,
266: p_date_to => p_date_to,

Line 357: WIP_PROD_INDICATORS.Populate_Productivity(

353: p_errmesg := 'Failed in Productivity Phase : '||x_phase|| substr(SQLERRM,1,125);
354: return ;
355: end ;
356:
357: WIP_PROD_INDICATORS.Populate_Productivity(
358: p_group_id => x_temp_group_id,
359: p_organization_id => p_organization_id,
360: p_date_from => p_date_from,
361: p_date_to => p_date_to,

Line 380: WIP_PROD_INDICATORS.Populate_Productivity(

376:
377:
378: ELSIF p_department_id IS NOT NULL AND p_resource_id IS NULL THEN
379:
380: WIP_PROD_INDICATORS.Populate_Productivity(
381: p_group_id => x_main_group_id,
382: p_organization_id => p_organization_id,
383: p_date_from => p_date_from,
384: p_date_to => p_date_to,

Line 486: WIP_PROD_INDICATORS.Populate_Resource_Load(

482: p_errmesg := 'Failed in Resource Load Phase : '||x_phase|| substr(SQLERRM,1,125);
483: return ;
484: end ;
485:
486: WIP_PROD_INDICATORS.Populate_Resource_Load(
487: p_group_id => x_temp_group_id,
488: p_organization_id => p_organization_id,
489: p_date_from => p_date_from,
490: p_date_to => p_date_to,

Line 508: WIP_PROD_INDICATORS.Populate_Resource_Load(

504: END LOOP ;
505:
506: ELSIF p_department_id IS NOT NULL AND p_resource_id IS NULL THEN
507:
508: WIP_PROD_INDICATORS.Populate_Resource_Load(
509: p_group_id => x_main_group_id,
510: p_organization_id => p_organization_id,
511: p_date_from => p_date_from,
512: p_date_to => p_date_to,

Line 1436: Wip_Prod_Indicators.Calculate_Resource_Avail(

1432:
1433: -- Calculate the resource availability and populate the
1434: -- information into MRP_NET_RESOURCE_AVAIL
1435:
1436: Wip_Prod_Indicators.Calculate_Resource_Avail(
1437: p_organization_id => p_organization_id,
1438: p_date_from => x_sim_date_from,
1439: p_date_to => x_sim_date_to,
1440: p_department_id => null,