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_SHIFT_TIMES

Line 3460: ELSIF p_table_name = 'MSC_ST_SHIFT_TIMES' THEN

3456: p_transaction_id,
3457: v_instance_code,
3458: p_calendar_code;
3459:
3460: ELSIF p_table_name = 'MSC_ST_SHIFT_TIMES' THEN
3461:
3462: v_sql_stmt := 3;
3463: lv_sql_stmt :=
3464: 'UPDATE msc_st_shift_times'

Line 3464: 'UPDATE msc_st_shift_times'

3460: ELSIF p_table_name = 'MSC_ST_SHIFT_TIMES' THEN
3461:
3462: v_sql_stmt := 3;
3463: lv_sql_stmt :=
3464: 'UPDATE msc_st_shift_times'
3465: ||' set process_flag = '||G_ERROR_FLG||','
3466: ||' error_text = :p_message_text'
3467: ||' WHERE st_transaction_id = :p_transaction_id'
3468: ||' AND sr_instance_code = :instance_code'

Line 3570: 'UPDATE msc_st_shift_times'

3566: p_calendar_code;
3567:
3568: v_sql_stmt := 9;
3569: lv_sql_stmt :=
3570: 'UPDATE msc_st_shift_times'
3571: ||' set process_flag = '||G_PROPAGATION
3572: ||' WHERE sr_instance_code = :instance_code'
3573: ||' AND process_flag = '||G_IN_PROCESS
3574: ||' AND calendar_code = :calendar_code';

Line 3635: | tables msc_st_shift_exceptions and msc_st_shift_times |

3631: /*==========================================================================+
3632: | DESCRIPTION : This function inserts a record into the LID table for the |
3633: | new shifts, derives the shift information from the |
3634: | workday pattern table and updates the shift_num in the |
3635: | tables msc_st_shift_exceptions and msc_st_shift_times |
3636: +==========================================================================*/
3637: FUNCTION derive_shift_details
3638: (p_transaction_id NUMBER,
3639: p_company_name VARCHAR2,

Line 3713: 'UPDATE msc_st_shift_times '

3709: v_instance_code;
3710:
3711: v_sql_stmt := 4;
3712: lv_sql_stmt :=
3713: 'UPDATE msc_st_shift_times '
3714: ||' SET shift_num = :lv_shift_num'
3715: ||' WHERE calendar_code = :p_calendar_code'
3716: ||' AND shift_name = :p_shift_name'
3717: ||' AND process_flag = '||G_IN_PROCESS

Line 3865: FROM msc_st_shift_times

3861: shift_num,
3862: from_time,
3863: to_time,
3864: deleted_flag
3865: FROM msc_st_shift_times
3866: WHERE sr_instance_code = v_instance_code
3867: AND calendar_code = p_calendar_code
3868: AND process_flag = G_IN_PROCESS;
3869:

Line 4487: lv_table_name := 'MSC_ST_SHIFT_TIMES';

4483:
4484: --Validation for shift times table.
4485: FOR rec3 IN c3(rec1.calendar_code)
4486: LOOP
4487: lv_table_name := 'MSC_ST_SHIFT_TIMES';
4488: lv_column_names :=
4489: 'CALENDAR_CODE ||''~''||'
4490: ||'SHIFT_NAME ||''~''||'
4491: ||'SHIFT_NUM ||''~''||'

Line 4499: SELECT msc_st_shift_times_s.NEXTVAL

4495: ||'COMPANY_NAME ||''~''||'
4496: ||'DELETED_FLAG';
4497:
4498: v_sql_stmt := 13;
4499: SELECT msc_st_shift_times_s.NEXTVAL
4500: INTO lv_transaction_id
4501: FROM dual;
4502:
4503: v_sql_stmt := 14;

Line 4504: UPDATE msc_st_shift_times

4500: INTO lv_transaction_id
4501: FROM dual;
4502:
4503: v_sql_stmt := 14;
4504: UPDATE msc_st_shift_times
4505: SET st_transaction_id = lv_transaction_id,
4506: refresh_id = v_refresh_id,
4507: last_update_date = v_current_date,
4508: last_updated_by = v_current_user,

Line 4558: (p_table_name => 'MSC_ST_SHIFT_TIMES',

4554:
4555: --Logging a warning for those records where the deleted_flag value
4556: --is other than Yes/No.
4557: lv_return := MSC_ST_UTIL.LOG_ERROR
4558: (p_table_name => 'MSC_ST_SHIFT_TIMES',
4559: p_instance_code => v_instance_code,
4560: p_row => lv_column_names,
4561: p_severity => G_SEV_WARNING,
4562: p_message_text => lv_message_text,

Line 4580: ||' FROM msc_st_shift_times'

4576: lv_sql_stmt :=
4577: 'SELECT 1'
4578: ||' FROM DUAL'
4579: ||' WHERE NOT EXISTS(SELECT 1'
4580: ||' FROM msc_st_shift_times'
4581: ||' WHERE sr_instance_code = :sr_instance_code'
4582: ||' AND process_flag = '||G_IN_PROCESS
4583: ||' AND deleted_flag = '||SYS_NO
4584: ||' AND calendar_code = :calendar_code'

Line 4591: ||' FROM msc_st_shift_times'

4587: ||' AND to_time = :to_time'
4588: ||' AND st_transaction_id <> :lv_transaction_id'
4589: ||' UNION'
4590: ||' SELECT 1'
4591: ||' FROM msc_st_shift_times'
4592: ||' WHERE sr_instance_code = :sr_instance_code'
4593: ||' AND process_flag = '||G_IN_PROCESS
4594: ||' AND deleted_flag = '||SYS_NO
4595: ||' AND calendar_code = :calendar_code'

Line 4602: ||' FROM msc_st_shift_times'

4598: ||' AND from_time < :to_time'
4599: ||' AND st_transaction_id <> :lv_transaction_id'
4600: ||' UNION'
4601: ||' SELECT 1'
4602: ||' FROM msc_st_shift_times'
4603: ||' WHERE sr_instance_code = :sr_instance_code'
4604: ||' AND process_flag = '||G_IN_PROCESS
4605: ||' AND deleted_flag = '||SYS_NO
4606: ||' AND calendar_code = :calendar_code'

Line 4654: pEntityName => 'MSC_ST_SHIFT_TIMES',

4650: (ERRBUF => lv_error_text,
4651: RETCODE => lv_return,
4652: pBatchID => null,
4653: pInstanceCode => v_instance_code,
4654: pEntityName => 'MSC_ST_SHIFT_TIMES',
4655: pInstanceID => v_instance_id);
4656:
4657: IF lv_return <> 0 THEN
4658: RAISE ex_logging_err;

Line 5199: (p_table_name => 'MSC_ST_SHIFT_TIMES',

5195: RAISE ex_logging_err;
5196: END IF;
5197:
5198: lv_return := MSC_ST_UTIL.SET_PROCESS_FLAG
5199: (p_table_name => 'MSC_ST_SHIFT_TIMES',
5200: p_instance_id => v_instance_id,
5201: p_instance_code => v_instance_code,
5202: p_process_flag => G_VALID,
5203: p_where_str => lv_where_str,

Line 5544: ||' FROM msc_st_shift_times '

5540: ||' request_id,'
5541: ||' program_application_id,'
5542: ||' program_id,'
5543: ||' program_update_date'
5544: ||' FROM msc_st_shift_times '
5545: ||' WHERE calendar_code = :calendar_code'
5546: ||' AND sr_instance_code = :sr_instance_code'
5547: ||' AND process_flag = '||G_VALID;
5548:

Line 5629: ' DELETE FROM msc_st_shift_times '

5625:
5626: v_sql_stmt := 40;
5627:
5628: lv_sql_stmt :=
5629: ' DELETE FROM msc_st_shift_times '
5630: ||' WHERE calendar_code = :calendar_code'
5631: ||' AND sr_instance_code = :sr_instance_code'
5632: ||' AND process_flag = '||G_VALID;
5633:

Line 55854: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_SHIFT_TIMES');

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');
55857: END IF;
55858:

Line 58464: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_SHIFT_TIMES');

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');
58467:
58468: LOAD_CALENDAR;