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_CALENDARS

Line 3170: FROM msc_st_calendars

3166: SELECT 1
3167: INTO lv_rec_count_cal
3168: FROM dual
3169: WHERE EXISTS(SELECT 1
3170: FROM msc_st_calendars
3171: WHERE sr_instance_id = v_instance_id
3172: AND process_flag = G_VALID);
3173:
3174: EXCEPTION

Line 3421: IF p_table_name = 'MSC_ST_CALENDARS' THEN

3417: lv_error_type NUMBER;
3418:
3419: BEGIN
3420:
3421: IF p_table_name = 'MSC_ST_CALENDARS' THEN
3422: v_sql_stmt := 1;
3423: lv_sql_stmt :=
3424: 'UPDATE msc_st_calendars'
3425: ||' set process_flag = '||G_ERROR_FLG||','

Line 3424: 'UPDATE msc_st_calendars'

3420:
3421: IF p_table_name = 'MSC_ST_CALENDARS' THEN
3422: v_sql_stmt := 1;
3423: lv_sql_stmt :=
3424: 'UPDATE msc_st_calendars'
3425: ||' set process_flag = '||G_ERROR_FLG||','
3426: ||' error_text = :p_message_text'
3427: ||' WHERE st_transaction_id = :p_transaction_id'
3428: ||' AND sr_instance_code = :instance_code'

Line 3523: IF p_table_name <> 'MSC_ST_CALENDARS' THEN

3519: p_calendar_code;
3520:
3521: END IF;
3522:
3523: IF p_table_name <> 'MSC_ST_CALENDARS' THEN
3524: v_sql_stmt := 6;
3525: lv_sql_stmt :=
3526: 'UPDATE msc_st_calendars'
3527: ||' set process_flag = '||G_PROPAGATION

Line 3526: 'UPDATE msc_st_calendars'

3522:
3523: IF p_table_name <> 'MSC_ST_CALENDARS' THEN
3524: v_sql_stmt := 6;
3525: lv_sql_stmt :=
3526: 'UPDATE msc_st_calendars'
3527: ||' set process_flag = '||G_PROPAGATION
3528: ||' WHERE sr_instance_code = :instance_code'
3529: ||' AND process_flag = '||G_IN_PROCESS
3530: ||' AND calendar_code = :calendar_code';

Line 3821: lv_calendar_code msc_st_calendars.calendar_code%TYPE;

3817: lv_where_str VARCHAR2(5000);
3818: lv_table_name VARCHAR2(32);
3819: lv_column_names VARCHAR2(5000); --stores concatenated column names
3820:
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;

Line 3822: lv_transaction_id msc_st_calendars.st_transaction_id%TYPE;

3818: lv_table_name VARCHAR2(32);
3819: lv_column_names VARCHAR2(5000); --stores concatenated column names
3820:
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;

Line 3823: lv_calendar_start_date msc_st_calendars.calendar_start_date%TYPE;

3819: lv_column_names VARCHAR2(5000); --stores concatenated column names
3820:
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;

Line 3824: lv_calendar_end_date msc_st_calendars.calendar_end_date%TYPE;

3820:
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:

Line 3841: FROM msc_st_calendars

3837: quarterly_calendar_type,
3838: week_start_day,
3839: overwrite_flag,
3840: deleted_flag
3841: FROM msc_st_calendars
3842: WHERE sr_instance_code = v_instance_code
3843: AND process_flag = G_IN_PROCESS;
3844:
3845: CURSOR c2(p_calendar_code VARCHAR2) IS

Line 3909: UPDATE msc_st_calendars mc1

3905: END IF;
3906:
3907: --Duplicate records check for the records whose source is XML
3908:
3909: UPDATE msc_st_calendars mc1
3910: SET process_flag = G_ERROR_FLG,
3911: error_text = lv_message_text
3912: WHERE message_id < (SELECT MAX(message_id)
3913: FROM msc_st_calendars mc2

Line 3913: FROM msc_st_calendars mc2

3909: UPDATE msc_st_calendars mc1
3910: SET process_flag = G_ERROR_FLG,
3911: error_text = lv_message_text
3912: WHERE message_id < (SELECT MAX(message_id)
3913: FROM msc_st_calendars mc2
3914: WHERE mc2.sr_instance_code = mc1.sr_instance_code
3915: AND mc2.calendar_code = mc1.calendar_code
3916: AND mc2.process_flag = G_IN_PROCESS
3917: AND NVL(mc2.message_id,NULL_VALUE) <>NULL_VALUE)

Line 3937: UPDATE msc_st_calendars mc1

3933: --Duplicate records check for the records whose source is other than XML
3934: --Different SQL is used because in XML we can identify the latest records
3935: --whereas in batch load we cannot.
3936:
3937: UPDATE msc_st_calendars mc1
3938: SET process_flag = G_ERROR_FLG,
3939: error_text = lv_message_text
3940: WHERE EXISTS( SELECT 1
3941: FROM msc_st_calendars mc2

Line 3941: FROM msc_st_calendars mc2

3937: UPDATE msc_st_calendars mc1
3938: SET process_flag = G_ERROR_FLG,
3939: error_text = lv_message_text
3940: WHERE EXISTS( SELECT 1
3941: FROM msc_st_calendars mc2
3942: WHERE mc2.sr_instance_code = mc1.sr_instance_code
3943: AND mc2.calendar_code = mc1.calendar_code
3944: AND mc2.process_flag = G_IN_PROCESS
3945: AND NVL(mc2.message_id,NULL_VALUE) = NULL_VALUE

Line 3958: lv_table_name := 'MSC_ST_CALENDARS';--used for error propagation

3954: LOOP
3955: BEGIN
3956:
3957: lv_calendar_code := rec1.calendar_code;--used for error propagation
3958: lv_table_name := 'MSC_ST_CALENDARS';--used for error propagation
3959:
3960: lv_column_names :=
3961: 'CALENDAR_CODE ||''~''||'
3962: ||'CALENDAR_START_DATE ||''~''||'

Line 3975: SELECT msc_st_calendars_s.NEXTVAL

3971: ||'DAYS_OFF ||''~''||'
3972: ||'DELETED_FLAG';
3973:
3974: v_sql_stmt := 1;
3975: SELECT msc_st_calendars_s.NEXTVAL
3976: INTO lv_transaction_id
3977: FROM dual;
3978:
3979: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Refresh ID: '||v_refresh_id);

Line 3984: 'UPDATE msc_st_calendars '

3980:
3981: --Update the transaction_id and the who columns
3982: v_sql_stmt := 2;
3983: lv_sql_stmt :=
3984: 'UPDATE msc_st_calendars '
3985: ||' SET st_transaction_id = :lv_transaction_id,'
3986: ||' refresh_id = '||v_refresh_id ||','
3987: ||' last_update_date = :v_current_date,'
3988: ||' last_updated_by = :v_current_user,'

Line 4034: p_token_value1 => 'MSC_ST_CALENDARS');

4030: p_error_code => 'MSC_PP_NO_DELETION',
4031: p_message_text => lv_message_text,
4032: p_error_text => lv_error_text,
4033: p_token1 => 'TABLE_NAME',
4034: p_token_value1 => 'MSC_ST_CALENDARS');
4035:
4036: IF lv_return <> 0 THEN
4037: RAISE ex_logging_err;
4038: END IF;

Line 4268: pEntityName => 'MSC_ST_CALENDARS',

4264: (ERRBUF => lv_error_text,
4265: RETCODE => lv_return,
4266: pBatchID => null,
4267: pInstanceCode => v_instance_code,
4268: pEntityName => 'MSC_ST_CALENDARS',
4269: pInstanceID => v_instance_id);
4270:
4271: IF lv_return <> 0 THEN
4272: RAISE ex_logging_err;

Line 4282: (p_table_name => 'MSC_ST_CALENDARS',

4278:
4279: --Logging a warning for those records where the deleted_flag value
4280: --is other than Yes/No.
4281: lv_return := MSC_ST_UTIL.LOG_ERROR
4282: (p_table_name => 'MSC_ST_CALENDARS',
4283: p_instance_code => v_instance_code,
4284: p_row => lv_column_names,
4285: p_severity => G_SEV_WARNING,
4286: p_message_text => lv_message_text,

Line 5159: (p_table_name => 'MSC_ST_CALENDARS',

5155:
5156: lv_where_str :=
5157: ' AND calendar_code = '||''''||rec1.calendar_code||'''';
5158: lv_return := MSC_ST_UTIL.SET_PROCESS_FLAG
5159: (p_table_name => 'MSC_ST_CALENDARS',
5160: p_instance_id => v_instance_id,
5161: p_instance_code => v_instance_code,
5162: p_process_flag => G_VALID,
5163: p_where_str => lv_where_str,

Line 5319: ||' FROM msc_st_calendars'

5315: ||' program_update_date,'
5316: ||' refresh_id,'
5317: ||' overwrite_flag,'
5318: ||' week_start_day'
5319: ||' FROM msc_st_calendars'
5320: ||' WHERE calendar_code = :calendar_code'
5321: ||' AND sr_instance_code = :sr_instance_code'
5322: ||' AND process_flag = '||G_VALID;
5323:

Line 54055: | records are coming in msc_st_calendars. |

54051:
54052: /*==========================================================================+
54053: | DESCRIPTION : This procedure generates records in msc_st_bis_periods if |
54054: | records are coming into msc_st_trading_partners and/or |
54055: | records are coming in msc_st_calendars. |
54056: +==========================================================================*/
54057: PROCEDURE LOAD_BIS_PERIODS IS
54058: lv_error_text VARCHAR2(250);
54059:

Line 55851: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_CALENDARS');

55847: End IF;
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');

Line 57371: FROM msc_st_calendars

57367: lv_sql_stmt VARCHAR2(4000);
57368:
57369: CURSOR c1 IS
57370: SELECT calendar_code
57371: FROM msc_st_calendars
57372: WHERE process_flag = G_VALID
57373: AND sr_instance_id = v_instance_id;
57374:
57375: BEGIN

Line 58461: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_CALENDARS');

58457: v_total_worker_num := p_total_worker_num;
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');