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

Line 3440: ELSIF p_table_name = 'MSC_ST_WORKDAY_PATTERNS' THEN

3436: p_transaction_id,
3437: v_instance_code,
3438: p_calendar_code;
3439:
3440: ELSIF p_table_name = 'MSC_ST_WORKDAY_PATTERNS' THEN
3441:
3442: v_sql_stmt := 2;
3443: lv_sql_stmt :=
3444: 'UPDATE msc_st_workday_patterns'

Line 3444: 'UPDATE msc_st_workday_patterns'

3440: ELSIF p_table_name = 'MSC_ST_WORKDAY_PATTERNS' THEN
3441:
3442: v_sql_stmt := 2;
3443: lv_sql_stmt :=
3444: 'UPDATE msc_st_workday_patterns'
3445: ||' set process_flag = '||G_ERROR_FLG||','
3446: ||' error_text = :p_message_text'
3447: ||' WHERE st_transaction_id = :p_transaction_id'
3448: ||' AND sr_instance_code = :instance_code'

Line 3542: 'UPDATE msc_st_workday_patterns'

3538: END IF;
3539:
3540: v_sql_stmt := 7;
3541: lv_sql_stmt :=
3542: 'UPDATE msc_st_workday_patterns'
3543: ||' set process_flag = '||G_PROPAGATION
3544: ||' WHERE sr_instance_code = :instance_code'
3545: ||' AND process_flag = '||G_IN_PROCESS
3546: ||' AND calendar_code = :calendar_code';

Line 3699: 'UPDATE msc_st_workday_patterns'

3695: END IF;
3696:
3697: v_sql_stmt := 3;
3698: lv_sql_stmt :=
3699: 'UPDATE msc_st_workday_patterns'
3700: ||' SET shift_num = :lv_shift_num'
3701: ||' WHERE st_transaction_id = :p_transaction_id'
3702: ||' AND process_flag = '||G_IN_PROCESS
3703: ||' AND sr_instance_code = :v_instance_code';

Line 3773: ||' FROM msc_st_workday_patterns mwp'

3769: ||' created_by,'
3770: ||' message_id,'
3771: ||' process_flag,'
3772: ||' data_source_type'
3773: ||' FROM msc_st_workday_patterns mwp'
3774: ||' WHERE st_transaction_id = :p_transaction_id'
3775: ||' AND process_flag = '||G_IN_PROCESS
3776: ||' AND sr_instance_code = :instance_code'
3777: ||' AND NOT EXISTS( SELECT 1 '

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 3853: FROM msc_st_workday_patterns

3849: seq_num,
3850: days_on,
3851: days_off,
3852: deleted_flag
3853: FROM msc_st_workday_patterns
3854: WHERE sr_instance_code = v_instance_code
3855: AND calendar_code = p_calendar_code
3856: AND process_flag = G_IN_PROCESS;
3857:

Line 4184: ||' FROM msc_st_workday_patterns mwp '

4180: lv_sql_stmt :=
4181: 'SELECT 1'
4182: ||' FROM msc_calendar_shifts mcs, msc_apps_instances mai '
4183: ||' WHERE NOT EXISTS(SELECT 1 '
4184: ||' FROM msc_st_workday_patterns mwp '
4185: ||' WHERE mwp.shift_name = mcs.shift_name'
4186: ||' AND mcs.calendar_code = mwp.calendar_code'
4187: ||' AND mwp.sr_instance_code = mai.instance_code'
4188: ||' AND mwp.process_flag = '||G_IN_PROCESS||')'

Line 4234: ||' FROM msc_st_workday_patterns'

4230:
4231: v_sql_stmt := 7;
4232: lv_sql_stmt :=
4233: 'SELECT nvl(SUM(nvl(days_on,0) + nvl(days_off,0)),0)'
4234: ||' FROM msc_st_workday_patterns'
4235: ||' WHERE calendar_code = :calendar_code'
4236: ||' AND NVL(shift_name,'||''''||NULL_CHAR||''''||')'
4237: ||' = '||''''||NULL_CHAR||''''
4238: ||' AND deleted_flag <> '||SYS_YES

Line 4301: FROM msc_st_workday_patterns

4297:
4298: SELECT MIN(to_number(decode(length(rtrim(shift_name,'0123456789')),
4299: NULL,shift_name,'0')))
4300: INTO lv_shift_num_gen
4301: FROM msc_st_workday_patterns
4302: WHERE sr_instance_code = v_instance_code
4303: AND calendar_code = rec1.calendar_code
4304: AND process_flag = G_IN_PROCESS
4305: AND shift_name IS NOT NULL;

Line 4310: lv_table_name := 'MSC_ST_WORKDAY_PATTERNS';

4306:
4307: --Workday Pattern is validated for a calendar.
4308: FOR rec2 IN c2(rec1.calendar_code)
4309: LOOP
4310: lv_table_name := 'MSC_ST_WORKDAY_PATTERNS';
4311: lv_seq_num := lv_seq_num + 1;
4312:
4313: lv_column_names :=
4314: 'CALENDAR_CODE ||''~''||'

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;

Line 4330: UPDATE msc_st_workday_patterns

4326: INTO lv_transaction_id
4327: FROM dual;
4328:
4329: v_sql_stmt := 9;
4330: UPDATE msc_st_workday_patterns
4331: SET st_transaction_id = lv_transaction_id,
4332: refresh_id = v_refresh_id,
4333: seq_num = lv_seq_num,
4334: last_update_date = v_current_date,

Line 4348: p_token_value1 => 'MSC_ST_WORKDAY_PATTERNS');

4344: p_error_code => 'MSC_PP_NO_DELETION',
4345: p_message_text => lv_message_text,
4346: p_error_text => lv_error_text,
4347: p_token1 => 'TABLE_NAME',
4348: p_token_value1 => 'MSC_ST_WORKDAY_PATTERNS');
4349:
4350: IF lv_return <> 0 THEN
4351: RAISE ex_logging_err;
4352: END IF;

Line 4390: (p_table_name => 'MSC_ST_WORKDAY_PATTERNS',

4386:
4387: --Logging a warning for those records where the deleted_flag value
4388: --is other than Yes/No.
4389: lv_return := MSC_ST_UTIL.LOG_ERROR
4390: (p_table_name => 'MSC_ST_WORKDAY_PATTERNS',
4391: p_instance_code => v_instance_code,
4392: p_row => lv_column_names,
4393: p_severity => G_SEV_WARNING,
4394: p_message_text => lv_message_text,

Line 4412: pEntityName => 'MSC_ST_WORKDAY_PATTERNS',

4408: (ERRBUF => lv_error_text,
4409: RETCODE => lv_return,
4410: pBatchID => null,
4411: pInstanceCode => v_instance_code,
4412: pEntityName => 'MSC_ST_WORKDAY_PATTERNS',
4413: pInstanceID => v_instance_id);
4414:
4415: IF lv_return <> 0 THEN
4416: RAISE ex_logging_err;

Line 5172: (p_table_name => 'MSC_ST_WORKDAY_PATTERNS',

5168: RAISE ex_logging_err;
5169: END IF;
5170:
5171: lv_return := MSC_ST_UTIL.SET_PROCESS_FLAG
5172: (p_table_name => 'MSC_ST_WORKDAY_PATTERNS',
5173: p_instance_id => v_instance_id,
5174: p_instance_code => v_instance_code,
5175: p_process_flag => G_VALID,
5176: p_where_str => lv_where_str,

Line 5378: ||' FROM msc_st_workday_patterns'

5374: ||' program_application_id,'
5375: ||' program_id,'
5376: ||' program_update_date,'
5377: ||' refresh_id'
5378: ||' FROM msc_st_workday_patterns'
5379: ||' WHERE calendar_code = :calendar_code'
5380: ||' AND sr_instance_code = :sr_instance_code'
5381: ||' AND process_flag = '||G_VALID;
5382:

Line 55852: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_WORKDAY_PATTERNS');

55848: END IF;
55849:
55850: IF v_cal_enabled = SYS_YES THEN
55851: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_CALENDARS');
55852: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_WORKDAY_PATTERNS');
55853: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_CALENDAR_SHIFTS');
55854: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_SHIFT_TIMES');
55855: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_SHIFT_EXCEPTIONS');
55856: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_CALENDAR_EXCEPTIONS');

Line 58462: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_WORKDAY_PATTERNS');

58458: -- calendar
58459: IF p_cal_enabled = SYS_YES and v_req_data = G_NEW_REQUEST THEN
58460: --8725891
58461: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_CALENDARS');
58462: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_WORKDAY_PATTERNS');
58463: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_CALENDAR_SHIFTS');
58464: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_SHIFT_TIMES');
58465: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_SHIFT_EXCEPTIONS');
58466: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_CALENDAR_EXCEPTIONS');