DBA Data[Home] [Help]

APPS.MSC_ATP_REQ dependencies on MSC_POST_PRO

Line 4927: l_summary_flag NOT IN (MSC_POST_PRO.G_SF_SUMMARY_NOT_RUN, MSC_POST_PRO.G_SF_PREALLOC_COMPLETED,

4923: ELSE
4924:
4925: -- Check if full summary has been run - for summary enhancement
4926: IF MSC_ATP_PVT.G_SUMMARY_FLAG = 'Y' AND
4927: l_summary_flag NOT IN (MSC_POST_PRO.G_SF_SUMMARY_NOT_RUN, MSC_POST_PRO.G_SF_PREALLOC_COMPLETED,
4928: MSC_POST_PRO.G_SF_FULL_SUMMARY_RUNNING) THEN
4929: -- Summary SQL can be used
4930: MSC_ATP_PVT.G_SUMMARY_SQL := 'Y';
4931: ELSE

Line 4928: MSC_POST_PRO.G_SF_FULL_SUMMARY_RUNNING) THEN

4924:
4925: -- Check if full summary has been run - for summary enhancement
4926: IF MSC_ATP_PVT.G_SUMMARY_FLAG = 'Y' AND
4927: l_summary_flag NOT IN (MSC_POST_PRO.G_SF_SUMMARY_NOT_RUN, MSC_POST_PRO.G_SF_PREALLOC_COMPLETED,
4928: MSC_POST_PRO.G_SF_FULL_SUMMARY_RUNNING) THEN
4929: -- Summary SQL can be used
4930: MSC_ATP_PVT.G_SUMMARY_SQL := 'Y';
4931: ELSE
4932: -- Use the SQL for non summary case

Line 5857: l_summary_flag NOT IN (MSC_POST_PRO.G_SF_SUMMARY_NOT_RUN, MSC_POST_PRO.G_SF_PREALLOC_COMPLETED,

5853: END IF;
5854:
5855: -- Check if full summary has been run - for summary enhancement
5856: IF MSC_ATP_PVT.G_SUMMARY_FLAG = 'Y' AND
5857: l_summary_flag NOT IN (MSC_POST_PRO.G_SF_SUMMARY_NOT_RUN, MSC_POST_PRO.G_SF_PREALLOC_COMPLETED,
5858: MSC_POST_PRO.G_SF_FULL_SUMMARY_RUNNING) THEN
5859: -- Summary SQL can be used
5860: l_summary_sql := 'Y';
5861: ELSE

Line 5858: MSC_POST_PRO.G_SF_FULL_SUMMARY_RUNNING) THEN

5854:
5855: -- Check if full summary has been run - for summary enhancement
5856: IF MSC_ATP_PVT.G_SUMMARY_FLAG = 'Y' AND
5857: l_summary_flag NOT IN (MSC_POST_PRO.G_SF_SUMMARY_NOT_RUN, MSC_POST_PRO.G_SF_PREALLOC_COMPLETED,
5858: MSC_POST_PRO.G_SF_FULL_SUMMARY_RUNNING) THEN
5859: -- Summary SQL can be used
5860: l_summary_sql := 'Y';
5861: ELSE
5862: -- Use the SQL for non summary case

Line 11471: IF l_summary_flag NOT IN (MSC_POST_PRO.G_SF_SUMMARY_NOT_RUN, MSC_POST_PRO.G_SF_PREALLOC_COMPLETED,

11467: IF PG_DEBUG in ('Y', 'C') THEN
11468: msc_sch_wb.atp_debug('Get_Supplier_Atp_Info: ' || 'l_summary_flag := ' || l_summary_flag);
11469: END IF;
11470:
11471: IF l_summary_flag NOT IN (MSC_POST_PRO.G_SF_SUMMARY_NOT_RUN, MSC_POST_PRO.G_SF_PREALLOC_COMPLETED,
11472: MSC_POST_PRO.G_SF_FULL_SUMMARY_RUNNING) THEN
11473: -- Summary SQL can be used
11474: l_summary_sql := 'Y';
11475: ELSE

Line 11472: MSC_POST_PRO.G_SF_FULL_SUMMARY_RUNNING) THEN

11468: msc_sch_wb.atp_debug('Get_Supplier_Atp_Info: ' || 'l_summary_flag := ' || l_summary_flag);
11469: END IF;
11470:
11471: IF l_summary_flag NOT IN (MSC_POST_PRO.G_SF_SUMMARY_NOT_RUN, MSC_POST_PRO.G_SF_PREALLOC_COMPLETED,
11472: MSC_POST_PRO.G_SF_FULL_SUMMARY_RUNNING) THEN
11473: -- Summary SQL can be used
11474: l_summary_sql := 'Y';
11475: ELSE
11476: l_summary_sql := 'N';