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.

APPS.MSC_POST_PRO dependencies on MSC_ATP_SUMMARY_RES

Line 1817: msc_util.msc_log('LOAD_RESOURCES: ' || 'Delete Data from MSC_ATP_SUMMARY_RES');

1813: -- Data for share_partition='N' has already been deleted
1814: IF p_share_partition = 'Y' THEN
1815: msc_util.msc_log('LOAD_RESOURCES: ' || 'Share partition ');
1816: --- first delete data from the table
1817: msc_util.msc_log('LOAD_RESOURCES: ' || 'Delete Data from MSC_ATP_SUMMARY_RES');
1818: DELETE MSC_ATP_SUMMARY_RES where plan_id = p_plan_id;
1819: msc_util.msc_log('LOAD_RESOURCES: ' || 'After deleting old resources info');
1820: END IF;
1821:

Line 1818: DELETE MSC_ATP_SUMMARY_RES where plan_id = p_plan_id;

1814: IF p_share_partition = 'Y' THEN
1815: msc_util.msc_log('LOAD_RESOURCES: ' || 'Share partition ');
1816: --- first delete data from the table
1817: msc_util.msc_log('LOAD_RESOURCES: ' || 'Delete Data from MSC_ATP_SUMMARY_RES');
1818: DELETE MSC_ATP_SUMMARY_RES where plan_id = p_plan_id;
1819: msc_util.msc_log('LOAD_RESOURCES: ' || 'After deleting old resources info');
1820: END IF;
1821:
1822: -- The actual SQLs moved to private procedures for modularity : summary enhancement

Line 1833: msc_util.msc_log('LOAD_RESOURCES: ' || 'After inserting into MSC_ATP_SUMMARY_RES');

1829: msc_util.msc_log('LOAD_RESOURCES: ' || 'Insert data into res table');
1830:
1831: load_res_full_unopt_batch(p_plan_id, p_plan_start_date, p_sys_date);
1832:
1833: msc_util.msc_log('LOAD_RESOURCES: ' || 'After inserting into MSC_ATP_SUMMARY_RES');
1834: ELSE
1835: -- constrained plan
1836: msc_util.msc_log('LOAD_RESOURCES: ' || 'Constrained plan.');
1837: msc_util.msc_log('LOAD_RESOURCES: ' || 'Insert data into res table');

Line 1841: msc_util.msc_log('LOAD_RESOURCES: ' || 'After inserting into MSC_ATP_SUMMARY_RES');

1837: msc_util.msc_log('LOAD_RESOURCES: ' || 'Insert data into res table');
1838:
1839: load_res_full_opt_batch(p_plan_id, p_plan_start_date, p_sys_date);
1840:
1841: msc_util.msc_log('LOAD_RESOURCES: ' || 'After inserting into MSC_ATP_SUMMARY_RES');
1842: END IF;
1843:
1844: ELSE --- if l_use_batching =1
1845: msc_util.msc_log('LOAD_RESOURCES: ' || 'Not doing Batching');

Line 1854: msc_util.msc_log('LOAD_RESOURCES: ' || 'After inserting into MSC_ATP_SUMMARY_RES');

1850: msc_util.msc_log('LOAD_RESOURCES: ' || 'Insert data into res table');
1851:
1852: load_res_full_unopt_nobatch(p_plan_id, p_plan_start_date, p_sys_date);
1853:
1854: msc_util.msc_log('LOAD_RESOURCES: ' || 'After inserting into MSC_ATP_SUMMARY_RES');
1855: ELSE
1856: -- 2859130 constrained plan
1857: msc_util.msc_log('LOAD_RESOURCES: ' || 'Constrained plan.');
1858: msc_util.msc_log('LOAD_RESOURCES: ' || 'Insert data into res table');

Line 1862: msc_util.msc_log('LOAD_RESOURCES: ' || 'After inserting into MSC_ATP_SUMMARY_RES');

1858: msc_util.msc_log('LOAD_RESOURCES: ' || 'Insert data into res table');
1859:
1860: load_res_full_opt_nobatch(p_plan_id, p_plan_start_date, p_sys_date);
1861:
1862: msc_util.msc_log('LOAD_RESOURCES: ' || 'After inserting into MSC_ATP_SUMMARY_RES');
1863: END IF;
1864:
1865: END IF; --- if l_use_batching = 1
1866:

Line 1872: msc_util.msc_log('LOAD_RESOURCES: ' || 'Loading net summary in MSC_ATP_SUMMARY_RES');

1868:
1869: ELSE -- Net refresh - for summary enhancement
1870: -- IF p_full_refresh = 1 THEN -- Full refresh - for summary enhancement
1871:
1872: msc_util.msc_log('LOAD_RESOURCES: ' || 'Loading net summary in MSC_ATP_SUMMARY_RES');
1873: -- since at this point we need to bother only about ATP generated records we dont look for opt/unopt or batching
1874: load_res_data_net(p_plan_id, p_last_refresh_number, p_new_refresh_number, p_sys_date);
1875: msc_util.msc_log('LOAD_RESOURCES: ' || 'After loading net summary in MSC_ATP_SUMMARY_RES');
1876:

Line 1875: msc_util.msc_log('LOAD_RESOURCES: ' || 'After loading net summary in MSC_ATP_SUMMARY_RES');

1871:
1872: msc_util.msc_log('LOAD_RESOURCES: ' || 'Loading net summary in MSC_ATP_SUMMARY_RES');
1873: -- since at this point we need to bother only about ATP generated records we dont look for opt/unopt or batching
1874: load_res_data_net(p_plan_id, p_last_refresh_number, p_new_refresh_number, p_sys_date);
1875: msc_util.msc_log('LOAD_RESOURCES: ' || 'After loading net summary in MSC_ATP_SUMMARY_RES');
1876:
1877: END IF;
1878: END LOAD_RESOURCES;
1879:

Line 8147: INSERT INTO MSC_ATP_SUMMARY_RES(

8143:
8144: l_user_id := FND_GLOBAL.USER_ID;
8145:
8146: -- summary enhancement - made changes to make it consistent with regular SQLs in MSCRATPB
8147: INSERT INTO MSC_ATP_SUMMARY_RES(
8148: plan_id,
8149: department_id,
8150: resource_id,
8151: organization_id,

Line 8299: INSERT INTO MSC_ATP_SUMMARY_RES(

8295:
8296: l_user_id := FND_GLOBAL.USER_ID;
8297:
8298: -- summary enhancement - made changes to make it consistent with regular SQLs in MSCRATPB
8299: INSERT INTO MSC_ATP_SUMMARY_RES(
8300: plan_id,
8301: department_id,
8302: resource_id,
8303: organization_id,

Line 8443: INSERT INTO MSC_ATP_SUMMARY_RES(

8439:
8440: l_user_id := FND_GLOBAL.USER_ID;
8441:
8442: -- summary enhancement - made changes to make it consistent with regular SQLs in MSCRATPB
8443: INSERT INTO MSC_ATP_SUMMARY_RES(
8444: plan_id,
8445: department_id,
8446: resource_id,
8447: organization_id,

Line 8560: INSERT INTO MSC_ATP_SUMMARY_RES(

8556:
8557: l_user_id := FND_GLOBAL.USER_ID;
8558:
8559: -- summary enhancement - made changes to make it consistent with regular SQLs in MSCRATPB
8560: INSERT INTO MSC_ATP_SUMMARY_RES(
8561: plan_id,
8562: department_id,
8563: resource_id,
8564: organization_id,

Line 8719: UPDATE MSC_ATP_SUMMARY_RES

8715:
8716: msc_util.msc_log('LOAD_RES_DATA_NET: ' || 'l_resource_id_tab.COUNT := ' || l_resource_id_tab.COUNT);
8717:
8718: forall j IN l_resource_id_tab.first.. l_resource_id_tab.last
8719: UPDATE MSC_ATP_SUMMARY_RES
8720: SET sd_qty = sd_qty + l_sd_quantity_tab(j),
8721: last_update_date = p_sys_date,
8722: last_updated_by = l_user_id
8723: WHERE plan_id = p_plan_id

Line 8755: INSERT INTO MSC_ATP_SUMMARY_RES (

8751:
8752: msc_util.msc_log('LOAD_RES_DATA_NET: ' || 'l_ins_resource_id_tab.COUNT := ' || l_ins_resource_id_tab.COUNT);
8753:
8754: forall j IN l_ins_resource_id_tab.first.. l_ins_resource_id_tab.last
8755: INSERT INTO MSC_ATP_SUMMARY_RES (
8756: plan_id,
8757: department_id,
8758: resource_id,
8759: organization_id,

Line 8843: l_sql_stmt := 'ALTER TABLE MSC_ATP_SUMMARY_RES TRUNCATE PARTITION ' ||

8839:
8840: msc_util.msc_log('Truncate_Summ_Plan_Partition: ' || 'truncate partition for res');
8841: l_partition_name := 'ATP_SUMMARY_RES_' || to_char(p_plan_id);
8842: msc_util.msc_log('Truncate_Summ_Plan_Partition: ' || 'Partition name : ' || l_partition_name);
8843: l_sql_stmt := 'ALTER TABLE MSC_ATP_SUMMARY_RES TRUNCATE PARTITION ' ||
8844: l_partition_name || ' DROP STORAGE';
8845:
8846: BEGIN
8847: msc_util.msc_log('Before alter table MSC_ATP_SUMMARY_RES');

Line 8847: msc_util.msc_log('Before alter table MSC_ATP_SUMMARY_RES');

8843: l_sql_stmt := 'ALTER TABLE MSC_ATP_SUMMARY_RES TRUNCATE PARTITION ' ||
8844: l_partition_name || ' DROP STORAGE';
8845:
8846: BEGIN
8847: msc_util.msc_log('Before alter table MSC_ATP_SUMMARY_RES');
8848: ad_ddl.do_ddl(APPLSYS_SCHEMA => p_applsys_schema,
8849: APPLICATION_SHORT_NAME => 'MSC',
8850: STATEMENT_TYPE => ad_ddl.alter_table,
8851: STATEMENT => l_sql_stmt,

Line 8852: OBJECT_NAME => 'MSC_ATP_SUMMARY_RES');

8848: ad_ddl.do_ddl(APPLSYS_SCHEMA => p_applsys_schema,
8849: APPLICATION_SHORT_NAME => 'MSC',
8850: STATEMENT_TYPE => ad_ddl.alter_table,
8851: STATEMENT => l_sql_stmt,
8852: OBJECT_NAME => 'MSC_ATP_SUMMARY_RES');
8853: END;
8854: msc_util.msc_log('Truncate_Summ_Plan_Partition: ' || 'After truncating res partition');
8855:
8856: ------------------------------------------------

Line 8913: tabname=>'MSC_ATP_SUMMARY_RES',

8909: l_partition_name := 'ATP_SUMMARY_RES_' || to_char(p_plan_id);
8910: END IF;
8911:
8912: fnd_stats.gather_table_stats(ownname=>l_msc_schema,
8913: tabname=>'MSC_ATP_SUMMARY_RES',
8914: partname=>l_partition_name,
8915: granularity=>'PARTITION',
8916: percent =>10);
8917: msc_util.msc_log('Gather_Summ_Plan_Stats: ' || 'After gathering stats for Res tables');