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 54053: | DESCRIPTION : This procedure generates records in msc_st_bis_periods if |

54049: END LOAD_JOB_DETAILS;
54050:
54051:
54052: /*==========================================================================+
54053: | DESCRIPTION : This procedure generates records in msc_st_bis_periods if |
54054: | records are coming into msc_st_trading_partners and/or |
54055: | records are coming in msc_st_calendars. |
54056: +==========================================================================*/
54057: PROCEDURE LOAD_BIS_PERIODS IS

Line 54065: DELETE FROM msc_st_bis_periods where sr_instance_id = v_instance_id;

54061:
54062: IF is_bis_periods_load_reqd = SYS_YES THEN
54063:
54064:
54065: DELETE FROM msc_st_bis_periods where sr_instance_id = v_instance_id;
54066: INSERT INTO msc_st_bis_periods
54067: (organization_id,
54068: period_set_name,
54069: period_name,

Line 54066: INSERT INTO msc_st_bis_periods

54062: IF is_bis_periods_load_reqd = SYS_YES THEN
54063:
54064:
54065: DELETE FROM msc_st_bis_periods where sr_instance_id = v_instance_id;
54066: INSERT INTO msc_st_bis_periods
54067: (organization_id,
54068: period_set_name,
54069: period_name,
54070: start_date,

Line 54121: INSERT INTO msc_st_bis_periods

54117:
54118:
54119: -- insert for those orgs which are coming in now
54120: -- and do not exist in the ODS
54121: INSERT INTO msc_st_bis_periods
54122: (organization_id,
54123: period_set_name,
54124: period_name,
54125: start_date,

Line 54182: update msc_st_bis_periods msbp

54178: );
54179: END IF;
54180: COMMIT;
54181: --changes for bug 8613033
54182: update msc_st_bis_periods msbp
54183: set msbp.year_start_date=
54184: (
54185: select mcm.year_start_date from msc_calendar_months mcm
54186: where mcm.sr_instance_id = v_instance_id

Line 54202: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'msc_st_bis_periods : Rows updated - '||SQL%ROWCOUNT);

54198: )
54199: where msbp.sr_instance_id = v_instance_id;
54200:
54201: commit;
54202: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'msc_st_bis_periods : Rows updated - '||SQL%ROWCOUNT);
54203: --end of changes for bug 8613033
54204: EXCEPTION
54205: WHEN OTHERS THEN
54206: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_BIS_PERIODS'||'('