[Home] [Help]
3552: p_calendar_code;
3553:
3554: v_sql_stmt := 8;
3555: lv_sql_stmt :=
3556: 'UPDATE msc_st_calendar_shifts'
3557: ||' set process_flag = '||G_PROPAGATION
3558: ||' WHERE sr_instance_code = :instance_code'
3559: ||' AND process_flag = '||G_IN_PROCESS
3560: ||' AND calendar_code = :calendar_code';
3643: P_shift_num NUMBER DEFAULT NULL_VALUE,
3644: p_shift_exist NUMBER DEFAULT NULL_VALUE)
3645: RETURN NUMBER IS
3646: lv_sql_stmt VARCHAR2(5000);
3647: lv_shift_num msc_st_calendar_shifts.shift_num%TYPE;
3648:
3649: BEGIN
3650: lv_shift_num := p_shift_num;
3651:
3741: v_instance_code;
3742:
3743: v_sql_stmt := 6;
3744: lv_sql_stmt :=
3745: 'INSERT INTO msc_st_calendar_shifts '
3746: ||' (calendar_code,'
3747: ||' shift_name,'
3748: ||' shift_num,'
3749: ||' sr_instance_code,'
3774: ||' WHERE st_transaction_id = :p_transaction_id'
3775: ||' AND process_flag = '||G_IN_PROCESS
3776: ||' AND sr_instance_code = :instance_code'
3777: ||' AND NOT EXISTS( SELECT 1 '
3778: ||' FROM MSC_ST_CALENDAR_SHIFTS mcs'
3779: ||' where mcs.calendar_code = mwp.calendar_code'
3780: ||' AND mcs.shift_name = mwp.shift_name'
3781: ||' AND mcs.shift_num = mwp.shift_num'
3782: ||' AND mcs.sr_instance_code = :v_instance_code'
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:
3829: ex_logging_err EXCEPTION;
3830: ex_critical_err EXCEPTION;
3831:
5182: END IF;
5183:
5184:
5185: lv_return := MSC_ST_UTIL.SET_PROCESS_FLAG
5186: (p_table_name => 'MSC_ST_CALENDAR_SHIFTS',
5187: p_instance_id => v_instance_id,
5188: p_instance_code => v_instance_code,
5189: p_process_flag => G_VALID,
5190: p_where_str => lv_where_str,
5486: ||' request_id,'
5487: ||' program_application_id,'
5488: ||' program_id,'
5489: ||' program_update_date'
5490: ||' FROM msc_st_calendar_shifts '
5491: ||' WHERE calendar_code = :calendar_code'
5492: ||' AND sr_instance_code = :sr_instance_code'
5493: ||' AND process_flag = '||G_VALID;
5494:
5610: -- Delete those tables that is collected by collections
5611: v_sql_stmt := 39;
5612:
5613: lv_sql_stmt :=
5614: ' DELETE FROM msc_st_calendar_shifts '
5615: ||' WHERE calendar_code = :calendar_code'
5616: ||' AND sr_instance_code = :sr_instance_code'
5617: ||' AND process_flag = '||G_VALID;
5618:
32419: p_token1 => 'COLUMN_NAMES',
32420: p_token_value1 => 'SR_INSTANCE_CODE,'
32421: ||' ORGANIZATION_CODE,SHIFT_NAME',
32422: p_token2 => 'MASTER_TABLE',
32423: p_token_value2 => 'MSC_ST_CALENDAR_SHIFTS',
32424: p_token3 => 'CHILD_TABLE' ,
32425: p_token_value3 => 'MSC_ST_RESOURCE_SHIFTS' );
32426:
32427: IF lv_return <> 0 THEN
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');
55856: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_CALENDAR_EXCEPTIONS');
55857: END IF;
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');
58466: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_CALENDAR_EXCEPTIONS');
58467: