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_RESOURCE_SHIFTS

Line 979: ||' on MSC_ST_RESOURCE_SHIFTS '

975: application_short_name => 'MSC',
976: statement_type => AD_DDL.CREATE_INDEX,
977: statement =>
978: 'create index MSC_ST_RES_SHIFTS_N1_'||v_instance_code
979: ||' on MSC_ST_RESOURCE_SHIFTS '
980: ||'(sr_instance_code, resource_code, department_code, shift_name, organization_code, company_name) '
981: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
982: object_name =>'MSC_ST_RES_SHIFTS_N1_'||v_instance_code);
983:

Line 1011: msc_analyse_tables_pk.analyse_table( 'MSC_ST_RESOURCE_SHIFTS', v_instance_id, -1);

1007: END;
1008:
1009: msc_analyse_tables_pk.analyse_table( 'MSC_ST_RESOURCE_GROUPS', v_instance_id, -1);
1010: msc_analyse_tables_pk.analyse_table( 'MSC_ST_DEPARTMENT_RESOURCES', v_instance_id, -1);
1011: msc_analyse_tables_pk.analyse_table( 'MSC_ST_RESOURCE_SHIFTS', v_instance_id, -1);
1012: msc_analyse_tables_pk.analyse_table( 'MSC_ST_RESOURCE_CHANGES', v_instance_id, -1);
1013:
1014: END IF;
1015:

Line 30522: FROM msc_st_resource_shifts

30518:
30519:
30520: CURSOR c6(p_batch_id NUMBER) IS
30521: SELECT rowid
30522: FROM msc_st_resource_shifts
30523: WHERE process_flag IN (G_IN_PROCESS,G_ERROR_FLG)
30524: AND sr_instance_code = v_instance_code
30525: AND batch_id = p_batch_id;
30526:

Line 32018: -- Validation for table MSC_ST_RESOURCE_SHIFTS

32014: COMMIT;
32015: END LOOP;
32016:
32017:
32018: -- Validation for table MSC_ST_RESOURCE_SHIFTS
32019:
32020: --Duplicate records check for the records whose source is XML
32021:
32022: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE

Line 32037: 'UPDATE msc_st_resource_shifts msrs1'

32033:
32034: v_sql_stmt := 19;
32035:
32036: lv_sql_stmt:=
32037: 'UPDATE msc_st_resource_shifts msrs1'
32038: ||' SET process_flag = '||G_ERROR_FLG||','
32039: ||' error_text = '||''''||lv_message_text||''''
32040: ||' WHERE message_id < ( SELECT max(message_id)'
32041: ||' FROM msc_st_resource_shifts msrs2'

Line 32041: ||' FROM msc_st_resource_shifts msrs2'

32037: 'UPDATE msc_st_resource_shifts msrs1'
32038: ||' SET process_flag = '||G_ERROR_FLG||','
32039: ||' error_text = '||''''||lv_message_text||''''
32040: ||' WHERE message_id < ( SELECT max(message_id)'
32041: ||' FROM msc_st_resource_shifts msrs2'
32042: ||' WHERE msrs2.sr_instance_code = msrs1.sr_instance_code'
32043: ||' AND NVL(msrs2.company_name,'||''''||NULL_CHAR||''''||') '
32044: ||' = NVL(msrs1.company_name,'||''''||NULL_CHAR||''''||') '
32045: ||' AND msrs2.organization_code = msrs1.organization_code'

Line 32076: 'UPDATE msc_st_resource_shifts msrs1'

32072:
32073: v_sql_stmt := 20;
32074:
32075: lv_sql_stmt:=
32076: 'UPDATE msc_st_resource_shifts msrs1'
32077: ||' SET process_flag ='||G_ERROR_FLG||','
32078: ||' error_text = '||''''||lv_message_text||''''
32079: ||' WHERE EXISTS ( SELECT 1 FROM msc_st_resource_shifts msrs2'
32080: ||' WHERE msrs2.sr_instance_code = msrs1.sr_instance_code'

Line 32079: ||' WHERE EXISTS ( SELECT 1 FROM msc_st_resource_shifts msrs2'

32075: lv_sql_stmt:=
32076: 'UPDATE msc_st_resource_shifts msrs1'
32077: ||' SET process_flag ='||G_ERROR_FLG||','
32078: ||' error_text = '||''''||lv_message_text||''''
32079: ||' WHERE EXISTS ( SELECT 1 FROM msc_st_resource_shifts msrs2'
32080: ||' WHERE msrs2.sr_instance_code = msrs1.sr_instance_code'
32081: ||' AND NVL(msrs2.company_name,'||''''||NULL_CHAR||''''||') '
32082: ||' = NVL(msrs1.company_name,'||''''||NULL_CHAR||''''||') '
32083: ||' AND msrs2.organization_code = msrs1.organization_code'

Line 32123: ' UPDATE msc_st_resource_shifts '

32119: CLOSE c1;
32120:
32121: v_sql_stmt := 22;
32122: lv_sql_stmt :=
32123: ' UPDATE msc_st_resource_shifts '
32124: ||' SET batch_id = :lv_batch_id'
32125: ||' WHERE process_flag IN ('||G_IN_PROCESS||','||G_ERROR_FLG||')'
32126: ||' AND sr_instance_code = :v_instance_code'
32127: ||' AND NVL(batch_id,'||NULL_VALUE||') = '||NULL_VALUE

Line 32143: UPDATE msc_st_resource_shifts

32139: CLOSE c6;
32140:
32141: v_sql_stmt := 23;
32142: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
32143: UPDATE msc_st_resource_shifts
32144: SET st_transaction_id = msc_st_resource_shifts_s.NEXTVAL,
32145: refresh_id = v_refresh_id,
32146: last_update_date = v_current_date,
32147: last_updated_by = v_current_user,

Line 32144: SET st_transaction_id = msc_st_resource_shifts_s.NEXTVAL,

32140:
32141: v_sql_stmt := 23;
32142: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
32143: UPDATE msc_st_resource_shifts
32144: SET st_transaction_id = msc_st_resource_shifts_s.NEXTVAL,
32145: refresh_id = v_refresh_id,
32146: last_update_date = v_current_date,
32147: last_updated_by = v_current_user,
32148: creation_date = v_current_date,

Line 32174: ' UPDATE msc_st_resource_shifts '

32170:
32171: v_sql_stmt := 24;
32172:
32173: lv_sql_stmt :=
32174: ' UPDATE msc_st_resource_shifts '
32175: ||' SET process_flag ='||G_ERROR_FLG||','
32176: ||' error_text = '||''''||lv_message_text||''''
32177: ||' WHERE deleted_flag = '||SYS_YES
32178: ||' AND process_flag = '||G_IN_PROCESS

Line 32210: (p_table_name => 'MSC_ST_RESOURCE_SHIFTS',

32206: lv_where_str :=
32207: ' AND NVL(deleted_flag,'||NULL_VALUE||') <>'||SYS_NO;
32208:
32209: lv_return := MSC_ST_UTIL.LOG_ERROR
32210: (p_table_name => 'MSC_ST_RESOURCE_SHIFTS',
32211: p_instance_code => v_instance_code,
32212: p_row => lv_column_names,
32213: p_severity => G_SEV_WARNING,
32214: p_message_text => lv_message_text,

Line 32235: p_token_value1 => 'MSC_ST_RESOURCE_SHIFTS');

32231: p_error_code => 'MSC_PP_NO_DELETION',
32232: p_message_text => lv_message_text,
32233: p_error_text => lv_error_text,
32234: p_token1 => 'TABLE_NAME',
32235: p_token_value1 => 'MSC_ST_RESOURCE_SHIFTS');
32236:
32237: IF lv_return <> 0 THEN
32238: RAISE ex_logging_err;
32239: END IF;

Line 32245: 'UPDATE msc_st_resource_shifts msrs'

32241: -- Popluate the Department id from LOCAL_ID table
32242:
32243: v_sql_stmt := 25;
32244: lv_sql_stmt :=
32245: 'UPDATE msc_st_resource_shifts msrs'
32246: ||' SET department_id = (SELECT local_id'
32247: ||' FROM msc_local_id_setup mlis'
32248: ||' WHERE mlis.char1 = msrs.sr_instance_code'
32249: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '

Line 32276: p_token_value3 => 'MSC_ST_RESOURCE_SHIFTS' );

32272: ||' ORGANIZATION_CODE,DEPARTMENT_CODE',
32273: p_token2 => 'MASTER_TABLE',
32274: p_token_value2 => 'MSC_ST_DEPARTMENT_RESOURCES',
32275: p_token3 => 'CHILD_TABLE' ,
32276: p_token_value3 => 'MSC_ST_RESOURCE_SHIFTS' );
32277:
32278: IF lv_return <> 0 THEN
32279: RAISE ex_logging_err;
32280: END IF;

Line 32287: 'UPDATE msc_st_resource_shifts '

32283: -- Error out the reords where department id is NULL
32284:
32285: v_sql_stmt := 26;
32286: lv_sql_stmt:=
32287: 'UPDATE msc_st_resource_shifts '
32288: ||' SET process_flag = '||G_ERROR_FLG||','
32289: ||' error_text = '||''''||lv_message_text||''''
32290: ||' WHERE NVL(department_id,'||NULL_VALUE||') = '||NULL_VALUE
32291: ||' AND sr_instance_code = :v_instance_code'

Line 32303: 'UPDATE msc_st_resource_shifts msrs'

32299:
32300: -- Popluate the resource id from LOCAL_ID table
32301: v_sql_stmt := 27;
32302: lv_sql_stmt:=
32303: 'UPDATE msc_st_resource_shifts msrs'
32304: ||' SET resource_id = (SELECT local_id FROM msc_local_id_setup mlis'
32305: ||' WHERE mlis.char1 = msrs.sr_instance_code'
32306: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '
32307: ||' = NVL(msrs.company_name,'||''''||NULL_CHAR||''''||') '

Line 32333: p_token_value3 => 'MSC_ST_RESOURCE_SHIFTS' );

32329: ||' ORGANIZATION_CODE,RESOURCE_CODE',
32330: p_token2 => 'MASTER_TABLE',
32331: p_token_value2 => 'MSC_ST_DEPARTMENT_RESOURCES',
32332: p_token3 => 'CHILD_TABLE' ,
32333: p_token_value3 => 'MSC_ST_RESOURCE_SHIFTS' );
32334:
32335: IF lv_return <> 0 THEN
32336: RAISE ex_logging_err;
32337: END IF;

Line 32343: 'UPDATE msc_st_resource_shifts '

32339: -- Error out the records where resource id is NULL
32340:
32341: v_sql_stmt := 28;
32342: lv_sql_stmt:=
32343: 'UPDATE msc_st_resource_shifts '
32344: ||' SET process_flag = '||G_ERROR_FLG||','
32345: ||' error_text = '||''''||lv_message_text||''''
32346: ||' WHERE NVL(resource_id,'||NULL_VALUE||') = '||NULL_VALUE
32347: ||' AND sr_instance_code = :v_instance_code'

Line 32362: 'UPDATE msc_st_resource_shifts msrs'

32358: -- Derive the SHIFT_NUM
32359:
32360: v_sql_stmt := 29;
32361: lv_sql_stmt :=
32362: 'UPDATE msc_st_resource_shifts msrs'
32363: ||' SET shift_num =(SELECT mlis.local_id'
32364: ||' FROM msc_local_id_setup mlis, msc_st_trading_partners mtp '
32365: ||' WHERE mtp.sr_instance_id = '||v_instance_id
32366: ||' AND mlis.char1 = msrs.sr_instance_code'

Line 32388: 'UPDATE msc_st_resource_shifts msrs'

32384:
32385: /* Bug 2172537 ,instance code not prefixed in calendar and org*/
32386:
32387: lv_sql_stmt :=
32388: 'UPDATE msc_st_resource_shifts msrs'
32389: ||' SET shift_num =(SELECT mlis.local_id'
32390: ||' FROM msc_local_id_setup mlis, msc_trading_partners mtp '
32391: ||' WHERE mtp.sr_instance_id = '||v_instance_id
32392: ||' AND mlis.char1 = msrs.sr_instance_code'

Line 32425: p_token_value3 => 'MSC_ST_RESOURCE_SHIFTS' );

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
32428: RAISE ex_logging_err;
32429: END IF;

Line 32437: 'UPDATE msc_st_resource_shifts '

32433:
32434: v_sql_stmt := 30;
32435:
32436: lv_sql_stmt:=
32437: 'UPDATE msc_st_resource_shifts '
32438: ||' SET process_flag = '||G_ERROR_FLG||','
32439: ||' error_text = '||''''||lv_message_text||''''
32440: ||' WHERE NVL(shift_num,'||NULL_VALUE||') = '||NULL_VALUE
32441: ||' AND sr_instance_code = :v_instance_code'

Line 32458: pEntityName => 'MSC_ST_RESOURCE_SHIFTS',

32454: (ERRBUF => lv_error_text,
32455: RETCODE => lv_return,
32456: pBatchID => lv_batch_id,
32457: pInstanceCode => v_instance_code,
32458: pEntityName => 'MSC_ST_RESOURCE_SHIFTS',
32459: pInstanceID => v_instance_id);
32460:
32461: IF NVL(lv_return,0) <> 0 THEN
32462: RAISE ex_logging_err;

Line 32468: MSC_ST_UTIL.SET_PROCESS_FLAG(p_table_name => 'MSC_ST_RESOURCE_SHIFTS',

32464:
32465:
32466: -- Set the process flag as Valid and populate instance_id
32467: lv_return :=
32468: MSC_ST_UTIL.SET_PROCESS_FLAG(p_table_name => 'MSC_ST_RESOURCE_SHIFTS',
32469: p_instance_id => v_instance_id,
32470: p_instance_code => v_instance_code,
32471: p_process_flag => G_VALID,
32472: p_error_text => lv_error_text,

Line 32483: MSC_ST_UTIL.LOG_ERROR(p_table_name =>'MSC_ST_RESOURCE_SHIFTS',

32479:
32480: -- At the end calling the LOG_ERROR for logging all errored out records
32481:
32482: lv_return :=
32483: MSC_ST_UTIL.LOG_ERROR(p_table_name =>'MSC_ST_RESOURCE_SHIFTS',
32484: p_instance_code =>v_instance_code,
32485: p_row =>lv_column_names,
32486: p_severity =>G_ERROR_FLG,
32487: p_message_text =>NULL,

Line 55902: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_RESOURCE_SHIFTS');

55898: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_SETUP_TRANSITIONS');
55899: IF lv_count > 0 Then
55900: prec.bom_flag:= SYS_YES;
55901: End IF;
55902: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_RESOURCE_SHIFTS');
55903: IF lv_count > 0 Then
55904: prec.bom_flag:= SYS_YES;
55905: prec.calendar_flag:=SYS_YES;
55906: End IF;