APPS.MSC_CL_PRE_PROCESS dependencies on MSC_ST_CALENDAR_SHIFTS

Line 3549: 'UPDATE msc_st_calendar_shifts'

3545: p_calendar_code;
3546:
3547: v_sql_stmt := 8;
3548: lv_sql_stmt :=
3549: 'UPDATE msc_st_calendar_shifts'
3550: ||' set process_flag = '||G_PROPAGATION
3551: ||' WHERE sr_instance_code = :instance_code'
3552: ||' AND process_flag = '||G_IN_PROCESS
3553: ||' AND calendar_code = :calendar_code';

Line 3640: lv_shift_num msc_st_calendar_shifts.shift_num%TYPE;

3636: P_shift_num NUMBER DEFAULT NULL_VALUE,
3637: p_shift_exist NUMBER DEFAULT NULL_VALUE)
3638: RETURN NUMBER IS
3639: lv_sql_stmt VARCHAR2(5000);
3640: lv_shift_num msc_st_calendar_shifts.shift_num%TYPE;
3641:
3642: BEGIN
3643: lv_shift_num := p_shift_num;
3644:

Line 3738: 'INSERT INTO msc_st_calendar_shifts '

3734: v_instance_code;
3735:
3736: v_sql_stmt := 6;
3737: lv_sql_stmt :=
3738: 'INSERT INTO msc_st_calendar_shifts '
3739: ||' (calendar_code,'
3740: ||' shift_name,'
3741: ||' shift_num,'
3742: ||' sr_instance_code,'

Line 3771: ||' FROM MSC_ST_CALENDAR_SHIFTS mcs'

3767: ||' WHERE st_transaction_id = :p_transaction_id'
3768: ||' AND process_flag = '||G_IN_PROCESS
3769: ||' AND sr_instance_code = :instance_code'
3770: ||' AND NOT EXISTS( SELECT 1 '
3771: ||' FROM MSC_ST_CALENDAR_SHIFTS mcs'
3772: ||' where mcs.calendar_code = mwp.calendar_code'
3773: ||' AND mcs.shift_name = mwp.shift_name'
3774: ||' AND mcs.shift_num = mwp.shift_num'
3775: ||' AND mcs.sr_instance_code = :v_instance_code'

Line 3820: lv_shift_num msc_st_calendar_shifts.shift_num%TYPE;

3816: lv_calendar_start_date msc_st_calendars.calendar_start_date%TYPE;
3817: lv_calendar_end_date msc_st_calendars.calendar_end_date%TYPE;
3818: lv_seq_num msc_st_workday_patterns.seq_num%TYPE := 0;
3819: lv_message_text msc_errors.error_text%TYPE;
3820: lv_shift_num msc_st_calendar_shifts.shift_num%TYPE;
3821:
3822: ex_logging_err EXCEPTION;
3823: ex_critical_err EXCEPTION;
3824:

Line 5179: (p_table_name => 'MSC_ST_CALENDAR_SHIFTS',

5175: END IF;
5176:
5177:
5178: lv_return := MSC_ST_UTIL.SET_PROCESS_FLAG
5179: (p_table_name => 'MSC_ST_CALENDAR_SHIFTS',
5180: p_instance_id => v_instance_id,
5181: p_instance_code => v_instance_code,
5182: p_process_flag => G_VALID,
5183: p_where_str => lv_where_str,

Line 5483: ||' FROM msc_st_calendar_shifts '

5479: ||' request_id,'
5480: ||' program_application_id,'
5481: ||' program_id,'
5482: ||' program_update_date'
5483: ||' FROM msc_st_calendar_shifts '
5484: ||' WHERE calendar_code = :calendar_code'
5485: ||' AND sr_instance_code = :sr_instance_code'
5486: ||' AND process_flag = '||G_VALID;
5487:

Line 5607: ' DELETE FROM msc_st_calendar_shifts '

5603: -- Delete those tables that is collected by collections
5604: v_sql_stmt := 39;
5605:
5606: lv_sql_stmt :=
5607: ' DELETE FROM msc_st_calendar_shifts '
5608: ||' WHERE calendar_code = :calendar_code'
5609: ||' AND sr_instance_code = :sr_instance_code'
5610: ||' AND process_flag = '||G_VALID;
5611:

Line 28869: p_token_value2 => 'MSC_ST_CALENDAR_SHIFTS',

28865: p_token1 => 'COLUMN_NAMES',
28866: p_token_value1 => 'SR_INSTANCE_CODE,'
28867: ||' ORGANIZATION_CODE,SHIFT_NAME',
28868: p_token2 => 'MASTER_TABLE',
28869: p_token_value2 => 'MSC_ST_CALENDAR_SHIFTS',
28870: p_token3 => 'CHILD_TABLE' ,
28871: p_token_value3 => 'MSC_ST_RESOURCE_SHIFTS' );
28872:
28873: IF lv_return <> 0 THEN

Line 50939: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_CALENDAR_SHIFTS');

50935:
50936: IF v_cal_enabled = SYS_YES THEN
50937: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_CALENDARS');
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;