eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.MSC_ATP_PVT dependencies on MSC_APPS_INSTANCES

Line 557: FROM msc_apps_instances

553: -- be null at this point as it is populated in CALL_SCHEDULE_REMOTE
554: --Bug3765793 adding trim functions to remove spaces from db_link
555: SELECT ltrim(rtrim(M2A_DBLINK)), summary_flag
556: INTO MSC_ATP_PVT.G_DATABASE_LINK, l_summary_flag
557: FROM msc_apps_instances
558: WHERE instance_id = p_instance_id;
559:
560: ---bug 2301524:
561: --- 2301524: Summary mode is not supported for backlog workbench.

Line 575: update msc_apps_instances

571: IF PG_DEBUG in ('Y', 'C') THEN
572: msc_sch_wb.atp_debug('Schedule: ' || 'Site is using backlog workbench, update tables and turnoff summary for ODS case');
573: END IF;
574:
575: update msc_apps_instances
576: set summary_flag = 200;
577:
578: MSC_ATP_PVT.G_SUMMARY_FLAG := 'N';
579: ELSIF NVL(l_summary_flag, -1) = 200 AND MSC_ATP_PVT.G_INV_CTP = 5 THEN

Line 975: FROM msc_apps_instances

971: apps_ver
972: INTO l_so_tbl_status,
973: l_summary_flag,
974: MSC_ATP_PVT.G_APPS_VER -- 2300767
975: FROM msc_apps_instances
976: WHERE instance_id = p_instance_id;
977:
978: IF PG_DEBUG in ('Y', 'C') THEN
979: msc_sch_wb.atp_debug('Schedule: ' || 'l_so_tbl_status = '||l_so_tbl_status);

Line 2203: FROM msc_apps_instances

2199: SELECT so_tbl_status,
2200: NVL(summary_flag, 1)
2201: INTO l_so_tbl_status,
2202: l_summary_flag
2203: FROM msc_apps_instances
2204: WHERE instance_id = p_instance_id;
2205:
2206: IF PG_DEBUG in ('Y', 'C') THEN
2207: msc_sch_wb.atp_debug('Schedule: ' || 'l_so_tbl_status = '||l_so_tbl_status);

Line 2236: FROM msc_apps_instances

2232: SELECT so_tbl_status,
2233: NVL(summary_flag, 1)
2234: INTO l_so_tbl_status,
2235: l_summary_flag
2236: FROM msc_apps_instances
2237: WHERE instance_id = p_instance_id;
2238:
2239: IF PG_DEBUG in ('Y', 'C') THEN
2240: msc_sch_wb.atp_debug('Schedule: ' || 'l_so_tbl_status = '||l_so_tbl_status);

Line 18362: FROM msc_apps_instances

18358: END IF;
18359: --Bug3765793 adding trim functions to remove spaces from db_link
18360: SELECT ltrim(rtrim(M2A_DBLINK))
18361: INTO l_dblink
18362: FROM msc_apps_instances
18363: WHERE instance_id = p_instance_id;
18364: IF PG_DEBUG in ('Y', 'C') THEN
18365: msc_sch_wb.atp_debug('Call_Schedule: ' || 'after l_dblink : '||l_dblink);
18366: END IF;

Line 19056: FROM msc_apps_instances

19052: ---bug 2301524: read summary flag
19053: --Bug3765793 adding trim functions to remove spaces from db_link
19054: SELECT NVL(l_dblink,ltrim(rtrim(M2A_DBLINK)))
19055: INTO l_dblink
19056: FROM msc_apps_instances
19057: WHERE instance_id = p_instance_id;
19058: END IF;
19059: --bug3520746 end
19060: SELECT summary_flag, apps_ver

Line 19062: FROM msc_apps_instances

19058: END IF;
19059: --bug3520746 end
19060: SELECT summary_flag, apps_ver
19061: INTO l_summary_flag, MSC_ATP_PVT.G_APPS_VER
19062: FROM msc_apps_instances
19063: WHERE instance_id = p_instance_id;
19064:
19065: IF PG_DEBUG in ('Y', 'C') THEN
19066: msc_sch_wb.atp_debug('Call_Schedule_Remote: ' || 'after get m2a_dblink');

Line 19218: FROM msc_apps_instances

19214: ---bug 2301524: read summary flag
19215: --Bug3765793 adding trim functions to remove spaces from db_link
19216: SELECT NVL(l_dblink,ltrim(rtrim(M2A_DBLINK)))
19217: INTO l_dblink
19218: FROM msc_apps_instances
19219: WHERE instance_id = p_instance_id;
19220: END IF;
19221: --bug3520746 end
19222: SELECT summary_flag, apps_ver

Line 19224: FROM msc_apps_instances

19220: END IF;
19221: --bug3520746 end
19222: SELECT summary_flag, apps_ver
19223: INTO l_summary_flag, MSC_ATP_PVT.G_APPS_VER
19224: FROM msc_apps_instances
19225: WHERE instance_id = p_instance_id;
19226: IF PG_DEBUG in ('Y', 'C') THEN
19227: msc_sch_wb.atp_debug('Call_Schedule_Remote: ' || 'after get m2a_dblink');
19228: msc_sch_wb.atp_debug('Call_Schedule_Remote: ' || 'l_dblink = ' || l_dblink);

Line 19270: update msc_apps_instances

19266: IF PG_DEBUG in ('Y', 'C') THEN
19267: msc_sch_wb.atp_debug('Call_Schedule_Remote: ' || 'Site is using backlog workbench, update tables and turnoff ODS summary');
19268: END IF;
19269:
19270: update msc_apps_instances
19271: set summary_flag = 200;
19272:
19273: MSC_ATP_PVT.G_SUMMARY_FLAG := 'N';
19274: ELSIF l_summary_flag = 200 AND MSC_ATP_PVT.G_INV_CTP = 5 THEN -- INV_CTP check added for summary enhancement