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_WORKDAY_PATTERNS_S

Line 3825: lv_seq_num msc_st_workday_patterns.seq_num%TYPE := 0;

3821: lv_calendar_code msc_st_calendars.calendar_code%TYPE;
3822: lv_transaction_id msc_st_calendars.st_transaction_id%TYPE;
3823: lv_calendar_start_date msc_st_calendars.calendar_start_date%TYPE;
3824: lv_calendar_end_date msc_st_calendars.calendar_end_date%TYPE;
3825: lv_seq_num msc_st_workday_patterns.seq_num%TYPE := 0;
3826: lv_message_text msc_errors.error_text%TYPE;
3827: lv_shift_num msc_st_calendar_shifts.shift_num%TYPE;
3828:
3829: ex_logging_err EXCEPTION;

Line 4325: SELECT msc_st_workday_patterns_s.NEXTVAL

4321: ||'COMPANY_NAME ||''~''||'
4322: ||'DELETED_FLAG';
4323:
4324: v_sql_stmt := 8;
4325: SELECT msc_st_workday_patterns_s.NEXTVAL
4326: INTO lv_transaction_id
4327: FROM dual;
4328:
4329: v_sql_stmt := 9;