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 8118: INSERT INTO MSC_ATP_SUMMARY_RES(

8114:
8115: l_user_id := FND_GLOBAL.USER_ID;
8116:
8117: -- summary enhancement - made changes to make it consistent with regular SQLs in MSCRATPB
8118: INSERT INTO MSC_ATP_SUMMARY_RES(
8119: plan_id,
8120: department_id,
8121: resource_id,
8122: organization_id,

Line 8270: INSERT INTO MSC_ATP_SUMMARY_RES(

8266:
8267: l_user_id := FND_GLOBAL.USER_ID;
8268:
8269: -- summary enhancement - made changes to make it consistent with regular SQLs in MSCRATPB
8270: INSERT INTO MSC_ATP_SUMMARY_RES(
8271: plan_id,
8272: department_id,
8273: resource_id,
8274: organization_id,

Line 8414: INSERT INTO MSC_ATP_SUMMARY_RES(

8410:
8411: l_user_id := FND_GLOBAL.USER_ID;
8412:
8413: -- summary enhancement - made changes to make it consistent with regular SQLs in MSCRATPB
8414: INSERT INTO MSC_ATP_SUMMARY_RES(
8415: plan_id,
8416: department_id,
8417: resource_id,
8418: organization_id,

Line 8531: INSERT INTO MSC_ATP_SUMMARY_RES(

8527:
8528: l_user_id := FND_GLOBAL.USER_ID;
8529:
8530: -- summary enhancement - made changes to make it consistent with regular SQLs in MSCRATPB
8531: INSERT INTO MSC_ATP_SUMMARY_RES(
8532: plan_id,
8533: department_id,
8534: resource_id,
8535: organization_id,

Line 8690: UPDATE MSC_ATP_SUMMARY_RES

8686:
8687: msc_util.msc_log('LOAD_RES_DATA_NET: ' || 'l_resource_id_tab.COUNT := ' || l_resource_id_tab.COUNT);
8688:
8689: forall j IN l_resource_id_tab.first.. l_resource_id_tab.last
8690: UPDATE MSC_ATP_SUMMARY_RES
8691: SET sd_qty = sd_qty + l_sd_quantity_tab(j),
8692: last_update_date = p_sys_date,
8693: last_updated_by = l_user_id
8694: WHERE plan_id = p_plan_id

Line 8726: INSERT INTO MSC_ATP_SUMMARY_RES (

8722:
8723: msc_util.msc_log('LOAD_RES_DATA_NET: ' || 'l_ins_resource_id_tab.COUNT := ' || l_ins_resource_id_tab.COUNT);
8724:
8725: forall j IN l_ins_resource_id_tab.first.. l_ins_resource_id_tab.last
8726: INSERT INTO MSC_ATP_SUMMARY_RES (
8727: plan_id,
8728: department_id,
8729: resource_id,
8730: organization_id,

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

8810:
8811: msc_util.msc_log('Truncate_Summ_Plan_Partition: ' || 'truncate partition for res');
8812: l_partition_name := 'ATP_SUMMARY_RES_' || to_char(p_plan_id);
8813: msc_util.msc_log('Truncate_Summ_Plan_Partition: ' || 'Partition name : ' || l_partition_name);
8814: l_sql_stmt := 'ALTER TABLE MSC_ATP_SUMMARY_RES TRUNCATE PARTITION ' ||
8815: l_partition_name || ' DROP STORAGE';
8816:
8817: BEGIN
8818: msc_util.msc_log('Before alter table MSC_ATP_SUMMARY_RES');

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

8814: l_sql_stmt := 'ALTER TABLE MSC_ATP_SUMMARY_RES TRUNCATE PARTITION ' ||
8815: l_partition_name || ' DROP STORAGE';
8816:
8817: BEGIN
8818: msc_util.msc_log('Before alter table MSC_ATP_SUMMARY_RES');
8819: ad_ddl.do_ddl(APPLSYS_SCHEMA => p_applsys_schema,
8820: APPLICATION_SHORT_NAME => 'MSC',
8821: STATEMENT_TYPE => ad_ddl.alter_table,
8822: STATEMENT => l_sql_stmt,

Line 8823: OBJECT_NAME => 'MSC_ATP_SUMMARY_RES');

8819: ad_ddl.do_ddl(APPLSYS_SCHEMA => p_applsys_schema,
8820: APPLICATION_SHORT_NAME => 'MSC',
8821: STATEMENT_TYPE => ad_ddl.alter_table,
8822: STATEMENT => l_sql_stmt,
8823: OBJECT_NAME => 'MSC_ATP_SUMMARY_RES');
8824: END;
8825: msc_util.msc_log('Truncate_Summ_Plan_Partition: ' || 'After truncating res partition');
8826:
8827: ------------------------------------------------

Line 8875: tabname=>'MSC_ATP_SUMMARY_RES',

8871: l_partition_name := 'ATP_SUMMARY_RES_' || to_char(p_plan_id);
8872: END IF;
8873:
8874: fnd_stats.gather_table_stats(ownname=>'MSC',
8875: tabname=>'MSC_ATP_SUMMARY_RES',
8876: partname=>l_partition_name,
8877: granularity=>'PARTITION',
8878: percent =>10);
8879: msc_util.msc_log('Gather_Summ_Plan_Stats: ' || 'After gathering stats for Res tables');