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_EXCEPTIONS

Line 3501: ELSIF p_table_name = 'MSC_ST_SHIFT_EXCEPTIONS' THEN

3497: p_transaction_id,
3498: v_instance_code,
3499: p_calendar_code;
3500:
3501: ELSIF p_table_name = 'MSC_ST_SHIFT_EXCEPTIONS' THEN
3502:
3503: v_sql_stmt := 5;
3504: lv_sql_stmt :=
3505: 'UPDATE msc_st_shift_exceptions'

Line 3505: 'UPDATE msc_st_shift_exceptions'

3501: ELSIF p_table_name = 'MSC_ST_SHIFT_EXCEPTIONS' THEN
3502:
3503: v_sql_stmt := 5;
3504: lv_sql_stmt :=
3505: 'UPDATE msc_st_shift_exceptions'
3506: ||' set process_flag = '||G_ERROR_FLG||','
3507: ||' error_text = :p_message_text'
3508: ||' WHERE st_transaction_id = :p_transaction_id'
3509: ||' AND sr_instance_code = :instance_code'

Line 3599: 'UPDATE msc_st_shift_exceptions'

3595: p_calendar_code;
3596:
3597: v_sql_stmt := 11;
3598: lv_sql_stmt :=
3599: 'UPDATE msc_st_shift_exceptions'
3600: ||' set process_flag = '||G_PROPAGATION
3601: ||' WHERE sr_instance_code = :instance_code'
3602: ||' AND process_flag = '||G_IN_PROCESS
3603: ||' 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 3729: 'UPDATE msc_st_shift_exceptions '

3725: v_instance_code;
3726:
3727: v_sql_stmt := 5;
3728: lv_sql_stmt :=
3729: 'UPDATE msc_st_shift_exceptions '
3730: ||' SET shift_num = :lv_shift_num'
3731: ||' WHERE calendar_code = :p_calendar_code'
3732: ||' AND shift_name = :p_shift_name'
3733: ||' AND process_flag = '||G_IN_PROCESS

Line 3886: FROM msc_st_shift_exceptions

3882: shift_name,
3883: exception_date,
3884: exception_type,
3885: deleted_flag
3886: FROM msc_st_shift_exceptions
3887: WHERE sr_instance_code = v_instance_code
3888: AND calendar_code = p_calendar_code
3889: AND process_flag = G_IN_PROCESS;
3890:

Line 4900: --validation for the table msc_st_shift_exceptions.

4896: END IF;
4897:
4898: END LOOP;
4899:
4900: --validation for the table msc_st_shift_exceptions.
4901: --Added to fix the bug#2748859
4902:
4903: --Getting the error message text
4904: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE

Line 4916: UPDATE msc_st_shift_exceptions mc1

4912: END IF;
4913:
4914: --Duplicate records check for the records whose source is XML
4915:
4916: UPDATE msc_st_shift_exceptions mc1
4917: SET process_flag = G_ERROR_FLG,
4918: error_text = lv_message_text
4919: WHERE message_id < (SELECT MAX(message_id)
4920: FROM msc_st_shift_exceptions mc2

Line 4920: FROM msc_st_shift_exceptions mc2

4916: UPDATE msc_st_shift_exceptions mc1
4917: SET process_flag = G_ERROR_FLG,
4918: error_text = lv_message_text
4919: WHERE message_id < (SELECT MAX(message_id)
4920: FROM msc_st_shift_exceptions mc2
4921: WHERE mc2.sr_instance_code = mc1.sr_instance_code
4922: AND mc2.calendar_code = mc1.calendar_code
4923: AND mc2.exception_date = mc1.exception_date
4924: AND nvl(mc2.shift_name,NULL_CHAR) = nvl(mc1.shift_name,NULL_CHAR)

Line 4948: UPDATE msc_st_shift_exceptions mc1

4944: --Duplicate records check for the records whose source is other than XML
4945: --Different SQL is used because in XML we can identify the latest records
4946: --whereas in batch load we cannot.
4947:
4948: UPDATE msc_st_shift_exceptions mc1
4949: SET process_flag = G_ERROR_FLG,
4950: error_text = lv_message_text
4951: WHERE EXISTS( SELECT 1
4952: FROM msc_st_shift_exceptions mc2

Line 4952: FROM msc_st_shift_exceptions mc2

4948: UPDATE msc_st_shift_exceptions mc1
4949: SET process_flag = G_ERROR_FLG,
4950: error_text = lv_message_text
4951: WHERE EXISTS( SELECT 1
4952: FROM msc_st_shift_exceptions mc2
4953: WHERE mc2.sr_instance_code = mc1.sr_instance_code
4954: AND mc2.calendar_code = mc1.calendar_code
4955: AND mc2.exception_date = mc1.exception_date
4956: AND nvl(mc2.shift_name,NULL_CHAR) = nvl(mc1.shift_name,NULL_CHAR)

Line 4970: lv_table_name := 'MSC_ST_SHIFT_EXCEPTIONS';

4966: --Added to fix the bug#2748859
4967:
4968: FOR rec5 IN c5(rec1.calendar_code)
4969: LOOP
4970: lv_table_name := 'MSC_ST_SHIFT_EXCEPTIONS';
4971: lv_column_names :=
4972: 'CALENDAR_CODE ||''~''||'
4973: ||'EXCEPTION_DATE ||''~''||'
4974: ||'EXCEPTION_TYPE ||''~''||'

Line 4983: SELECT msc_st_shift_exceptions_s.NEXTVAL

4979: ||'EXCEPTION_SET_ID||''~''||'
4980: ||'DELETED_FLAG';
4981:
4982: v_sql_stmt := 22;
4983: SELECT msc_st_shift_exceptions_s.NEXTVAL
4984: INTO lv_transaction_id
4985: FROM dual;
4986:
4987: v_sql_stmt := 23;

Line 4988: UPDATE msc_st_shift_exceptions

4984: INTO lv_transaction_id
4985: FROM dual;
4986:
4987: v_sql_stmt := 23;
4988: UPDATE msc_st_shift_exceptions
4989: SET st_transaction_id = lv_transaction_id,
4990: refresh_id = v_refresh_id,
4991: exception_set_id = -1,
4992: last_update_date = v_current_date,

Line 5005: p_token_value1 => 'MSC_ST_SHIFT_EXCEPTIONS');

5001: p_error_code => 'MSC_PP_NO_DELETION',
5002: p_message_text => lv_message_text,
5003: p_error_text => lv_error_text,
5004: p_token1 => 'TABLE_NAME',
5005: p_token_value1 => 'MSC_ST_SHIFT_EXCEPTIONS');
5006:
5007: IF lv_return <> 0 THEN
5008: RAISE ex_logging_err;
5009: END IF;

Line 5072: ' UPDATE msc_st_shift_exceptions mc'

5068:
5069: IF v_instance_type = G_SCE then
5070: v_sql_stmt := 24;
5071: lv_sql_stmt :=
5072: ' UPDATE msc_st_shift_exceptions mc'
5073: ||' SET company_id = (SELECT party_id '
5074: ||' FROM hz_parties hp'
5075: ||' WHERE hp.party_name = mc.company_name)'
5076: ||' WHERE st_transaction_id = :lv_transaction_id ';

Line 5099: ' UPDATE msc_st_shift_exceptions'

5095: END IF;
5096: ELSE
5097: v_sql_stmt := 25;
5098: lv_sql_stmt :=
5099: ' UPDATE msc_st_shift_exceptions'
5100: ||' SET company_id = '||G_COMPANY_ID
5101: ||' WHERE st_transaction_id = :lv_transaction_id ';
5102:
5103: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);

Line 5125: (p_table_name => 'MSC_ST_SHIFT_EXCEPTIONS',

5121:
5122: --Logging a warning for those records where the deleted_flag value
5123: --is other than Yes/No.
5124: lv_return := MSC_ST_UTIL.LOG_ERROR
5125: (p_table_name => 'MSC_ST_SHIFT_EXCEPTIONS',
5126: p_instance_code => v_instance_code,
5127: p_row => lv_column_names,
5128: p_severity => G_SEV_WARNING,
5129: p_message_text => lv_message_text,

Line 5147: pEntityName => 'MSC_ST_SHIFT_EXCEPTIONS',

5143: (ERRBUF => lv_error_text,
5144: RETCODE => lv_return,
5145: pBatchID => null,
5146: pInstanceCode => v_instance_code,
5147: pEntityName => 'MSC_ST_SHIFT_EXCEPTIONS',
5148: pInstanceID => v_instance_id);
5149:
5150: IF lv_return <> 0 THEN
5151: RAISE ex_logging_err;

Line 5225: (p_table_name => 'MSC_ST_SHIFT_EXCEPTIONS',

5221: RAISE ex_logging_err;
5222: END IF;
5223:
5224: lv_return := MSC_ST_UTIL.SET_PROCESS_FLAG
5225: (p_table_name => 'MSC_ST_SHIFT_EXCEPTIONS',
5226: p_instance_id => v_instance_id,
5227: p_instance_code => v_instance_code,
5228: p_process_flag => G_VALID,
5229: p_where_str => lv_where_str,

Line 5600: ||' FROM msc_st_shift_exceptions'

5596: ||' program_id,'
5597: ||' program_update_date,'
5598: ||' refresh_id,'
5599: ||' exception_set_id'
5600: ||' FROM msc_st_shift_exceptions'
5601: ||' WHERE calendar_code = :calendar_code'
5602: ||' AND sr_instance_code = :sr_instance_code'
5603: ||' AND process_flag = '||G_VALID;
5604:

Line 5644: ' DELETE FROM msc_st_shift_exceptions '

5640:
5641: v_sql_stmt := 41;
5642:
5643: lv_sql_stmt :=
5644: ' DELETE FROM msc_st_shift_exceptions '
5645: ||' WHERE calendar_code = :calendar_code'
5646: ||' AND sr_instance_code = :sr_instance_code'
5647: ||' AND process_flag = '||G_VALID;
5648:

Line 55855: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_SHIFT_EXCEPTIONS');

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:
55859: IF v_rtg_enabled = SYS_YES THEN

Line 58465: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_SHIFT_EXCEPTIONS');

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;
58469: ELSE