APPS.MSC_ATP_PVT dependencies on MSC_APPS_INSTANCES

Line 527: FROM msc_apps_instances

523: -- be null at this point as it is populated in CALL_SCHEDULE_REMOTE
524: --Bug3765793 adding trim functions to remove spaces from db_link
525: SELECT ltrim(rtrim(M2A_DBLINK)), summary_flag
526: INTO MSC_ATP_PVT.G_DATABASE_LINK, l_summary_flag
527: FROM msc_apps_instances
528: WHERE instance_id = p_instance_id;
529:
530: ---bug 2301524:
531: --- 2301524: Summary mode is not supported for backlog workbench.

Line 545: update msc_apps_instances

541: IF PG_DEBUG in ('Y', 'C') THEN
542: msc_sch_wb.atp_debug('Schedule: ' || 'Site is using backlog workbench, update tables and turnoff summary for ODS case');
543: END IF;
544:
545: update msc_apps_instances
546: set summary_flag = 200;
547:
548: MSC_ATP_PVT.G_SUMMARY_FLAG := 'N';
549: ELSIF NVL(l_summary_flag, -1) = 200 AND MSC_ATP_PVT.G_INV_CTP = 5 THEN

Line 933: FROM msc_apps_instances

929: apps_ver
930: INTO l_so_tbl_status,
931: l_summary_flag,
932: MSC_ATP_PVT.G_APPS_VER -- 2300767
933: FROM msc_apps_instances
934: WHERE instance_id = p_instance_id;
935:
936: IF PG_DEBUG in ('Y', 'C') THEN
937: msc_sch_wb.atp_debug('Schedule: ' || 'l_so_tbl_status = '||l_so_tbl_status);

Line 2135: FROM msc_apps_instances

2131: SELECT so_tbl_status,
2132: NVL(summary_flag, 1)
2133: INTO l_so_tbl_status,
2134: l_summary_flag
2135: FROM msc_apps_instances
2136: WHERE instance_id = p_instance_id;
2137:
2138: IF PG_DEBUG in ('Y', 'C') THEN
2139: msc_sch_wb.atp_debug('Schedule: ' || 'l_so_tbl_status = '||l_so_tbl_status);

Line 2168: FROM msc_apps_instances

2164: SELECT so_tbl_status,
2165: NVL(summary_flag, 1)
2166: INTO l_so_tbl_status,
2167: l_summary_flag
2168: FROM msc_apps_instances
2169: WHERE instance_id = p_instance_id;
2170:
2171: IF PG_DEBUG in ('Y', 'C') THEN
2172: msc_sch_wb.atp_debug('Schedule: ' || 'l_so_tbl_status = '||l_so_tbl_status);

Line 17489: FROM msc_apps_instances

17485: END IF;
17486: --Bug3765793 adding trim functions to remove spaces from db_link
17487: SELECT ltrim(rtrim(M2A_DBLINK))
17488: INTO l_dblink
17489: FROM msc_apps_instances
17490: WHERE instance_id = p_instance_id;
17491: IF PG_DEBUG in ('Y', 'C') THEN
17492: msc_sch_wb.atp_debug('Call_Schedule: ' || 'after l_dblink : '||l_dblink);
17493: END IF;

Line 18182: FROM msc_apps_instances

18178: ---bug 2301524: read summary flag
18179: --Bug3765793 adding trim functions to remove spaces from db_link
18180: SELECT NVL(l_dblink,ltrim(rtrim(M2A_DBLINK)))
18181: INTO l_dblink
18182: FROM msc_apps_instances
18183: WHERE instance_id = p_instance_id;
18184: END IF;
18185: --bug3520746 end
18186: SELECT summary_flag, apps_ver

Line 18188: FROM msc_apps_instances

18184: END IF;
18185: --bug3520746 end
18186: SELECT summary_flag, apps_ver
18187: INTO l_summary_flag, MSC_ATP_PVT.G_APPS_VER
18188: FROM msc_apps_instances
18189: WHERE instance_id = p_instance_id;
18190:
18191: IF PG_DEBUG in ('Y', 'C') THEN
18192: msc_sch_wb.atp_debug('Call_Schedule_Remote: ' || 'after get m2a_dblink');

Line 18338: FROM msc_apps_instances

18334: ---bug 2301524: read summary flag
18335: --Bug3765793 adding trim functions to remove spaces from db_link
18336: SELECT NVL(l_dblink,ltrim(rtrim(M2A_DBLINK)))
18337: INTO l_dblink
18338: FROM msc_apps_instances
18339: WHERE instance_id = p_instance_id;
18340: END IF;
18341: --bug3520746 end
18342: SELECT summary_flag, apps_ver

Line 18344: FROM msc_apps_instances

18340: END IF;
18341: --bug3520746 end
18342: SELECT summary_flag, apps_ver
18343: INTO l_summary_flag, MSC_ATP_PVT.G_APPS_VER
18344: FROM msc_apps_instances
18345: WHERE instance_id = p_instance_id;
18346: IF PG_DEBUG in ('Y', 'C') THEN
18347: msc_sch_wb.atp_debug('Call_Schedule_Remote: ' || 'after get m2a_dblink');
18348: msc_sch_wb.atp_debug('Call_Schedule_Remote: ' || 'l_dblink = ' || l_dblink);

Line 18390: update msc_apps_instances

18386: IF PG_DEBUG in ('Y', 'C') THEN
18387: msc_sch_wb.atp_debug('Call_Schedule_Remote: ' || 'Site is using backlog workbench, update tables and turnoff ODS summary');
18388: END IF;
18389:
18390: update msc_apps_instances
18391: set summary_flag = 200;
18392:
18393: MSC_ATP_PVT.G_SUMMARY_FLAG := 'N';
18394: ELSIF l_summary_flag = 200 AND MSC_ATP_PVT.G_INV_CTP = 5 THEN -- INV_CTP check added for summary enhancement