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_CALENDAR_EXCEPTIONS

Line 3481: ELSIF p_table_name = 'MSC_ST_CALENDAR_EXCEPTIONS' THEN

3477: v_instance_code,
3478: p_calendar_code;
3479:
3480:
3481: ELSIF p_table_name = 'MSC_ST_CALENDAR_EXCEPTIONS' THEN
3482:
3483: v_sql_stmt := 4;
3484: lv_sql_stmt :=
3485: 'UPDATE msc_st_calendar_exceptions'

Line 3485: 'UPDATE msc_st_calendar_exceptions'

3481: ELSIF p_table_name = 'MSC_ST_CALENDAR_EXCEPTIONS' THEN
3482:
3483: v_sql_stmt := 4;
3484: lv_sql_stmt :=
3485: 'UPDATE msc_st_calendar_exceptions'
3486: ||' set process_flag = '||G_ERROR_FLG||','
3487: ||' error_text = :p_message_text'
3488: ||' WHERE st_transaction_id = :p_transaction_id'
3489: ||' AND sr_instance_code = :instance_code'

Line 3585: 'UPDATE msc_st_calendar_exceptions'

3581:
3582:
3583: v_sql_stmt := 10;
3584: lv_sql_stmt :=
3585: 'UPDATE msc_st_calendar_exceptions'
3586: ||' set process_flag = '||G_PROPAGATION
3587: ||' WHERE sr_instance_code = :instance_code'
3588: ||' AND process_flag = '||G_IN_PROCESS
3589: ||' AND calendar_code = :calendar_code';

Line 3875: FROM msc_st_calendar_exceptions

3871: SELECT rowid,
3872: exception_date,
3873: exception_type,
3874: deleted_flag
3875: FROM msc_st_calendar_exceptions
3876: WHERE sr_instance_code = v_instance_code
3877: AND calendar_code = p_calendar_code
3878: AND process_flag = G_IN_PROCESS;
3879:

Line 4663: --validation for the table msc_st_Calendar_exceptions.

4659: END IF;
4660:
4661: END LOOP;
4662:
4663: --validation for the table msc_st_Calendar_exceptions.
4664: --Added to fix the bug#2748859
4665:
4666: --Getting the error message text
4667: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE

Line 4679: UPDATE msc_st_calendar_exceptions mc1

4675: END IF;
4676:
4677: --Duplicate records check for the records whose source is XML
4678:
4679: UPDATE msc_st_calendar_exceptions mc1
4680: SET process_flag = G_ERROR_FLG,
4681: error_text = lv_message_text
4682: WHERE message_id < (SELECT MAX(message_id)
4683: FROM msc_st_calendar_exceptions mc2

Line 4683: FROM msc_st_calendar_exceptions mc2

4679: UPDATE msc_st_calendar_exceptions mc1
4680: SET process_flag = G_ERROR_FLG,
4681: error_text = lv_message_text
4682: WHERE message_id < (SELECT MAX(message_id)
4683: FROM msc_st_calendar_exceptions mc2
4684: WHERE mc2.sr_instance_code = mc1.sr_instance_code
4685: AND mc2.calendar_code = mc1.calendar_code
4686: AND mc2.exception_date = mc1.exception_date
4687: AND mc2.process_flag = G_IN_PROCESS

Line 4709: UPDATE msc_st_calendar_exceptions mc1

4705: --Duplicate records check for the records whose source is other than XML
4706: --Different SQL is used because in XML we can identify the latest records
4707: --whereas in batch load we cannot.
4708:
4709: UPDATE msc_st_calendar_exceptions mc1
4710: SET process_flag = G_ERROR_FLG,
4711: error_text = lv_message_text
4712: WHERE EXISTS( SELECT 1
4713: FROM msc_st_calendar_exceptions mc2

Line 4713: FROM msc_st_calendar_exceptions mc2

4709: UPDATE msc_st_calendar_exceptions mc1
4710: SET process_flag = G_ERROR_FLG,
4711: error_text = lv_message_text
4712: WHERE EXISTS( SELECT 1
4713: FROM msc_st_calendar_exceptions mc2
4714: WHERE mc2.sr_instance_code = mc1.sr_instance_code
4715: AND mc2.calendar_code = mc1.calendar_code
4716: AND mc2.exception_date = mc1.exception_date
4717: AND mc2.process_flag = G_IN_PROCESS

Line 4730: lv_table_name := 'MSC_ST_CALENDAR_EXCEPTIONS';

4726: --Added to fix the bug#2748859
4727:
4728: FOR rec4 IN c4(rec1.calendar_code)
4729: LOOP
4730: lv_table_name := 'MSC_ST_CALENDAR_EXCEPTIONS';
4731: lv_column_names :=
4732: 'CALENDAR_CODE ||''~''||'
4733: ||'EXCEPTION_DATE ||''~''||'
4734: ||'EXCEPTION_TYPE ||''~''||'

Line 4741: SELECT msc_st_calendar_exceptions_s.NEXTVAL

4737: ||'EXCEPTION_SET_ID ||''~''||'
4738: ||'DELETED_FLAG';
4739:
4740: v_sql_stmt := 18;
4741: SELECT msc_st_calendar_exceptions_s.NEXTVAL
4742: INTO lv_transaction_id
4743: FROM dual;
4744:
4745: v_sql_stmt := 19;

Line 4746: UPDATE msc_st_calendar_exceptions

4742: INTO lv_transaction_id
4743: FROM dual;
4744:
4745: v_sql_stmt := 19;
4746: UPDATE msc_st_calendar_exceptions
4747: SET st_transaction_id = lv_transaction_id,
4748: refresh_id = v_refresh_id,
4749: exception_set_id = -1,
4750: last_update_date = v_current_date,

Line 4816: ' UPDATE msc_st_calendar_exceptions mc'

4812:
4813: IF v_instance_type = G_SCE then
4814: v_sql_stmt := 20;
4815: lv_sql_stmt :=
4816: ' UPDATE msc_st_calendar_exceptions mc'
4817: ||' SET company_id = (SELECT party_id '
4818: ||' FROM hz_parties hp'
4819: ||' WHERE hp.party_name = mc.company_name)'
4820: ||' WHERE st_transaction_id = :lv_transaction_id';

Line 4843: ' UPDATE msc_st_calendar_exceptions '

4839: END IF;
4840: ELSE
4841: v_sql_stmt := 21;
4842: lv_sql_stmt :=
4843: ' UPDATE msc_st_calendar_exceptions '
4844: ||' SET company_id = '||G_COMPANY_ID
4845: ||' WHERE st_transaction_id = :lv_transaction_id';
4846:
4847: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);

Line 4869: (p_table_name => 'MSC_ST_CALENDAR_EXCEPTIONS',

4865:
4866: --Logging a warning for those records where the deleted_flag value
4867: --is other than Yes/No.
4868: lv_return := MSC_ST_UTIL.LOG_ERROR
4869: (p_table_name => 'MSC_ST_CALENDAR_EXCEPTIONS',
4870: p_instance_code => v_instance_code,
4871: p_row => lv_column_names,
4872: p_severity => G_SEV_WARNING,
4873: p_message_text => lv_message_text,

Line 4891: pEntityName => 'MSC_ST_CALENDAR_EXCEPTIONS',

4887: (ERRBUF => lv_error_text,
4888: RETCODE => lv_return,
4889: pBatchID => null,
4890: pInstanceCode => v_instance_code,
4891: pEntityName => 'MSC_ST_CALENDAR_EXCEPTIONS',
4892: pInstanceID => v_instance_id);
4893:
4894: IF lv_return <> 0 THEN
4895: RAISE ex_logging_err;

Line 5212: (p_table_name => 'MSC_ST_CALENDAR_EXCEPTIONS',

5208: RAISE ex_logging_err;
5209: END IF;
5210:
5211: lv_return := MSC_ST_UTIL.SET_PROCESS_FLAG
5212: (p_table_name => 'MSC_ST_CALENDAR_EXCEPTIONS',
5213: p_instance_id => v_instance_id,
5214: p_instance_code => v_instance_code,
5215: p_process_flag => G_VALID,
5216: p_where_str => lv_where_str,

Line 5432: ||' FROM msc_st_calendar_exceptions'

5428: ||' program_id,'
5429: ||' program_update_date,'
5430: ||' refresh_id,'
5431: ||' exception_set_id'
5432: ||' FROM msc_st_calendar_exceptions'
5433: ||' WHERE calendar_code = :calendar_code'
5434: ||' AND sr_instance_code = :sr_instance_code'
5435: ||' AND process_flag = '||G_VALID ;
5436:

Line 55856: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_CALENDAR_EXCEPTIONS');

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
55860: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_OPERATION_RESOURCES');

Line 58466: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_CALENDAR_EXCEPTIONS');

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
58470: v_cal_build := False;