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 3474: ELSIF p_table_name = 'MSC_ST_CALENDAR_EXCEPTIONS' THEN

3470: v_instance_code,
3471: p_calendar_code;
3472:
3473:
3474: ELSIF p_table_name = 'MSC_ST_CALENDAR_EXCEPTIONS' THEN
3475:
3476: v_sql_stmt := 4;
3477: lv_sql_stmt :=
3478: 'UPDATE msc_st_calendar_exceptions'

Line 3478: 'UPDATE msc_st_calendar_exceptions'

3474: ELSIF p_table_name = 'MSC_ST_CALENDAR_EXCEPTIONS' THEN
3475:
3476: v_sql_stmt := 4;
3477: lv_sql_stmt :=
3478: 'UPDATE msc_st_calendar_exceptions'
3479: ||' set process_flag = '||G_ERROR_FLG||','
3480: ||' error_text = :p_message_text'
3481: ||' WHERE st_transaction_id = :p_transaction_id'
3482: ||' AND sr_instance_code = :instance_code'

Line 3578: 'UPDATE msc_st_calendar_exceptions'

3574:
3575:
3576: v_sql_stmt := 10;
3577: lv_sql_stmt :=
3578: 'UPDATE msc_st_calendar_exceptions'
3579: ||' set process_flag = '||G_PROPAGATION
3580: ||' WHERE sr_instance_code = :instance_code'
3581: ||' AND process_flag = '||G_IN_PROCESS
3582: ||' AND calendar_code = :calendar_code';

Line 3868: FROM msc_st_calendar_exceptions

3864: SELECT rowid,
3865: exception_date,
3866: exception_type,
3867: deleted_flag
3868: FROM msc_st_calendar_exceptions
3869: WHERE sr_instance_code = v_instance_code
3870: AND calendar_code = p_calendar_code
3871: AND process_flag = G_IN_PROCESS;
3872:

Line 4656: --validation for the table msc_st_Calendar_exceptions.

4652: END IF;
4653:
4654: END LOOP;
4655:
4656: --validation for the table msc_st_Calendar_exceptions.
4657: --Added to fix the bug#2748859
4658:
4659: --Getting the error message text
4660: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE

Line 4672: UPDATE msc_st_calendar_exceptions mc1

4668: END IF;
4669:
4670: --Duplicate records check for the records whose source is XML
4671:
4672: UPDATE msc_st_calendar_exceptions mc1
4673: SET process_flag = G_ERROR_FLG,
4674: error_text = lv_message_text
4675: WHERE message_id < (SELECT MAX(message_id)
4676: FROM msc_st_calendar_exceptions mc2

Line 4676: FROM msc_st_calendar_exceptions mc2

4672: UPDATE msc_st_calendar_exceptions mc1
4673: SET process_flag = G_ERROR_FLG,
4674: error_text = lv_message_text
4675: WHERE message_id < (SELECT MAX(message_id)
4676: FROM msc_st_calendar_exceptions mc2
4677: WHERE mc2.sr_instance_code = mc1.sr_instance_code
4678: AND mc2.calendar_code = mc1.calendar_code
4679: AND mc2.exception_date = mc1.exception_date
4680: AND mc2.process_flag = G_IN_PROCESS

Line 4702: UPDATE msc_st_calendar_exceptions mc1

4698: --Duplicate records check for the records whose source is other than XML
4699: --Different SQL is used because in XML we can identify the latest records
4700: --whereas in batch load we cannot.
4701:
4702: UPDATE msc_st_calendar_exceptions mc1
4703: SET process_flag = G_ERROR_FLG,
4704: error_text = lv_message_text
4705: WHERE EXISTS( SELECT 1
4706: FROM msc_st_calendar_exceptions mc2

Line 4706: FROM msc_st_calendar_exceptions mc2

4702: UPDATE msc_st_calendar_exceptions mc1
4703: SET process_flag = G_ERROR_FLG,
4704: error_text = lv_message_text
4705: WHERE EXISTS( SELECT 1
4706: FROM msc_st_calendar_exceptions mc2
4707: WHERE mc2.sr_instance_code = mc1.sr_instance_code
4708: AND mc2.calendar_code = mc1.calendar_code
4709: AND mc2.exception_date = mc1.exception_date
4710: AND mc2.process_flag = G_IN_PROCESS

Line 4723: lv_table_name := 'MSC_ST_CALENDAR_EXCEPTIONS';

4719: --Added to fix the bug#2748859
4720:
4721: FOR rec4 IN c4(rec1.calendar_code)
4722: LOOP
4723: lv_table_name := 'MSC_ST_CALENDAR_EXCEPTIONS';
4724: lv_column_names :=
4725: 'CALENDAR_CODE ||''~''||'
4726: ||'EXCEPTION_DATE ||''~''||'
4727: ||'EXCEPTION_TYPE ||''~''||'

Line 4734: SELECT msc_st_calendar_exceptions_s.NEXTVAL

4730: ||'EXCEPTION_SET_ID ||''~''||'
4731: ||'DELETED_FLAG';
4732:
4733: v_sql_stmt := 18;
4734: SELECT msc_st_calendar_exceptions_s.NEXTVAL
4735: INTO lv_transaction_id
4736: FROM dual;
4737:
4738: v_sql_stmt := 19;

Line 4739: UPDATE msc_st_calendar_exceptions

4735: INTO lv_transaction_id
4736: FROM dual;
4737:
4738: v_sql_stmt := 19;
4739: UPDATE msc_st_calendar_exceptions
4740: SET st_transaction_id = lv_transaction_id,
4741: refresh_id = v_refresh_id,
4742: exception_set_id = -1,
4743: last_update_date = v_current_date,

Line 4809: ' UPDATE msc_st_calendar_exceptions mc'

4805:
4806: IF v_instance_type = G_SCE then
4807: v_sql_stmt := 20;
4808: lv_sql_stmt :=
4809: ' UPDATE msc_st_calendar_exceptions mc'
4810: ||' SET company_id = (SELECT party_id '
4811: ||' FROM hz_parties hp'
4812: ||' WHERE hp.party_name = mc.company_name)'
4813: ||' WHERE st_transaction_id = :lv_transaction_id';

Line 4836: ' UPDATE msc_st_calendar_exceptions '

4832: END IF;
4833: ELSE
4834: v_sql_stmt := 21;
4835: lv_sql_stmt :=
4836: ' UPDATE msc_st_calendar_exceptions '
4837: ||' SET company_id = '||G_COMPANY_ID
4838: ||' WHERE st_transaction_id = :lv_transaction_id';
4839:
4840: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);

Line 4862: (p_table_name => 'MSC_ST_CALENDAR_EXCEPTIONS',

4858:
4859: --Logging a warning for those records where the deleted_flag value
4860: --is other than Yes/No.
4861: lv_return := MSC_ST_UTIL.LOG_ERROR
4862: (p_table_name => 'MSC_ST_CALENDAR_EXCEPTIONS',
4863: p_instance_code => v_instance_code,
4864: p_row => lv_column_names,
4865: p_severity => G_SEV_WARNING,
4866: p_message_text => lv_message_text,

Line 4884: pEntityName => 'MSC_ST_CALENDAR_EXCEPTIONS',

4880: (ERRBUF => lv_error_text,
4881: RETCODE => lv_return,
4882: pBatchID => null,
4883: pInstanceCode => v_instance_code,
4884: pEntityName => 'MSC_ST_CALENDAR_EXCEPTIONS',
4885: pInstanceID => v_instance_id);
4886:
4887: IF lv_return <> 0 THEN
4888: RAISE ex_logging_err;

Line 5205: (p_table_name => 'MSC_ST_CALENDAR_EXCEPTIONS',

5201: RAISE ex_logging_err;
5202: END IF;
5203:
5204: lv_return := MSC_ST_UTIL.SET_PROCESS_FLAG
5205: (p_table_name => 'MSC_ST_CALENDAR_EXCEPTIONS',
5206: p_instance_id => v_instance_id,
5207: p_instance_code => v_instance_code,
5208: p_process_flag => G_VALID,
5209: p_where_str => lv_where_str,

Line 5425: ||' FROM msc_st_calendar_exceptions'

5421: ||' program_id,'
5422: ||' program_update_date,'
5423: ||' refresh_id,'
5424: ||' exception_set_id'
5425: ||' FROM msc_st_calendar_exceptions'
5426: ||' WHERE calendar_code = :calendar_code'
5427: ||' AND sr_instance_code = :sr_instance_code'
5428: ||' AND process_flag = '||G_VALID ;
5429:

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

50938: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_WORKDAY_PATTERNS');
50939: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_CALENDAR_SHIFTS');
50940: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_SHIFT_TIMES');
50941: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_SHIFT_EXCEPTIONS');
50942: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_CALENDAR_EXCEPTIONS');
50943: END IF;
50944:
50945: IF v_rtg_enabled = SYS_YES THEN
50946: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_OPERATION_RESOURCES');