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_CL_PRE_PROCESS dependencies on MSC_ST_BIS_PERIODS

Line 49169: | DESCRIPTION : This procedure generates records in msc_st_bis_periods if |

49165: END LOAD_JOB_DETAILS;
49166:
49167:
49168: /*==========================================================================+
49169: | DESCRIPTION : This procedure generates records in msc_st_bis_periods if |
49170: | records are coming into msc_st_trading_partners and/or |
49171: | records are coming in msc_st_calendars. |
49172: +==========================================================================*/
49173: PROCEDURE LOAD_BIS_PERIODS IS

Line 49181: DELETE FROM msc_st_bis_periods where sr_instance_id = v_instance_id;

49177:
49178: IF is_bis_periods_load_reqd = SYS_YES THEN
49179:
49180:
49181: DELETE FROM msc_st_bis_periods where sr_instance_id = v_instance_id;
49182: INSERT INTO msc_st_bis_periods
49183: (organization_id,
49184: period_set_name,
49185: period_name,

Line 49182: INSERT INTO msc_st_bis_periods

49178: IF is_bis_periods_load_reqd = SYS_YES THEN
49179:
49180:
49181: DELETE FROM msc_st_bis_periods where sr_instance_id = v_instance_id;
49182: INSERT INTO msc_st_bis_periods
49183: (organization_id,
49184: period_set_name,
49185: period_name,
49186: start_date,

Line 49233: INSERT INTO msc_st_bis_periods

49229: AND mtp.partner_type = G_ORGANIZATION
49230: AND mtp.sr_instance_id = v_instance_id );
49231: -- insert for those orgs which are coming in now
49232: -- and do not exist in the ODS
49233: INSERT INTO msc_st_bis_periods
49234: (organization_id,
49235: period_set_name,
49236: period_name,
49237: start_date,