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 971: ||' on MSC_ST_RESOURCE_SHIFTS '

967: application_short_name => 'MSC',
968: statement_type => AD_DDL.CREATE_INDEX,
969: statement =>
970: 'create index MSC_ST_RES_SHIFTS_N1_'||v_instance_code
971: ||' on MSC_ST_RESOURCE_SHIFTS '
972: ||'(sr_instance_code, resource_code, department_code, shift_name, organization_code, company_name) '
973: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
974: object_name =>'MSC_ST_RES_SHIFTS_N1_'||v_instance_code);
975:

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

999: END;
1000:
1001: msc_analyse_tables_pk.analyse_table( 'MSC_ST_RESOURCE_GROUPS', v_instance_id, -1);
1002: msc_analyse_tables_pk.analyse_table( 'MSC_ST_DEPARTMENT_RESOURCES', v_instance_id, -1);
1003: msc_analyse_tables_pk.analyse_table( 'MSC_ST_RESOURCE_SHIFTS', v_instance_id, -1);
1004: msc_analyse_tables_pk.analyse_table( 'MSC_ST_RESOURCE_CHANGES', v_instance_id, -1);
1005:
1006: END IF;
1007:

Line 27008: FROM msc_st_resource_shifts

27004:
27005:
27006: CURSOR c6(p_batch_id NUMBER) IS
27007: SELECT rowid
27008: FROM msc_st_resource_shifts
27009: WHERE process_flag IN (G_IN_PROCESS,G_ERROR_FLG)
27010: AND sr_instance_code = v_instance_code
27011: AND batch_id = p_batch_id;
27012:

Line 28464: -- Validation for table MSC_ST_RESOURCE_SHIFTS

28460: COMMIT;
28461: END LOOP;
28462:
28463:
28464: -- Validation for table MSC_ST_RESOURCE_SHIFTS
28465:
28466: --Duplicate records check for the records whose source is XML
28467:
28468: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE

Line 28483: 'UPDATE msc_st_resource_shifts msrs1'

28479:
28480: v_sql_stmt := 19;
28481:
28482: lv_sql_stmt:=
28483: 'UPDATE msc_st_resource_shifts msrs1'
28484: ||' SET process_flag = '||G_ERROR_FLG||','
28485: ||' error_text = '||''''||lv_message_text||''''
28486: ||' WHERE message_id < ( SELECT max(message_id)'
28487: ||' FROM msc_st_resource_shifts msrs2'

Line 28487: ||' FROM msc_st_resource_shifts msrs2'

28483: 'UPDATE msc_st_resource_shifts msrs1'
28484: ||' SET process_flag = '||G_ERROR_FLG||','
28485: ||' error_text = '||''''||lv_message_text||''''
28486: ||' WHERE message_id < ( SELECT max(message_id)'
28487: ||' FROM msc_st_resource_shifts msrs2'
28488: ||' WHERE msrs2.sr_instance_code = msrs1.sr_instance_code'
28489: ||' AND NVL(msrs2.company_name,'||''''||NULL_CHAR||''''||') '
28490: ||' = NVL(msrs1.company_name,'||''''||NULL_CHAR||''''||') '
28491: ||' AND msrs2.organization_code = msrs1.organization_code'

Line 28522: 'UPDATE msc_st_resource_shifts msrs1'

28518:
28519: v_sql_stmt := 20;
28520:
28521: lv_sql_stmt:=
28522: 'UPDATE msc_st_resource_shifts msrs1'
28523: ||' SET process_flag ='||G_ERROR_FLG||','
28524: ||' error_text = '||''''||lv_message_text||''''
28525: ||' WHERE EXISTS ( SELECT 1 FROM msc_st_resource_shifts msrs2'
28526: ||' WHERE msrs2.sr_instance_code = msrs1.sr_instance_code'

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

28521: lv_sql_stmt:=
28522: 'UPDATE msc_st_resource_shifts msrs1'
28523: ||' SET process_flag ='||G_ERROR_FLG||','
28524: ||' error_text = '||''''||lv_message_text||''''
28525: ||' WHERE EXISTS ( SELECT 1 FROM msc_st_resource_shifts msrs2'
28526: ||' WHERE msrs2.sr_instance_code = msrs1.sr_instance_code'
28527: ||' AND NVL(msrs2.company_name,'||''''||NULL_CHAR||''''||') '
28528: ||' = NVL(msrs1.company_name,'||''''||NULL_CHAR||''''||') '
28529: ||' AND msrs2.organization_code = msrs1.organization_code'

Line 28569: ' UPDATE msc_st_resource_shifts '

28565: CLOSE c1;
28566:
28567: v_sql_stmt := 22;
28568: lv_sql_stmt :=
28569: ' UPDATE msc_st_resource_shifts '
28570: ||' SET batch_id = :lv_batch_id'
28571: ||' WHERE process_flag IN ('||G_IN_PROCESS||','||G_ERROR_FLG||')'
28572: ||' AND sr_instance_code = :v_instance_code'
28573: ||' AND NVL(batch_id,'||NULL_VALUE||') = '||NULL_VALUE

Line 28589: UPDATE msc_st_resource_shifts

28585: CLOSE c6;
28586:
28587: v_sql_stmt := 23;
28588: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
28589: UPDATE msc_st_resource_shifts
28590: SET st_transaction_id = msc_st_resource_shifts_s.NEXTVAL,
28591: refresh_id = v_refresh_id,
28592: last_update_date = v_current_date,
28593: last_updated_by = v_current_user,

Line 28590: SET st_transaction_id = msc_st_resource_shifts_s.NEXTVAL,

28586:
28587: v_sql_stmt := 23;
28588: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
28589: UPDATE msc_st_resource_shifts
28590: SET st_transaction_id = msc_st_resource_shifts_s.NEXTVAL,
28591: refresh_id = v_refresh_id,
28592: last_update_date = v_current_date,
28593: last_updated_by = v_current_user,
28594: creation_date = v_current_date,

Line 28620: ' UPDATE msc_st_resource_shifts '

28616:
28617: v_sql_stmt := 24;
28618:
28619: lv_sql_stmt :=
28620: ' UPDATE msc_st_resource_shifts '
28621: ||' SET process_flag ='||G_ERROR_FLG||','
28622: ||' error_text = '||''''||lv_message_text||''''
28623: ||' WHERE deleted_flag = '||SYS_YES
28624: ||' AND process_flag = '||G_IN_PROCESS

Line 28656: (p_table_name => 'MSC_ST_RESOURCE_SHIFTS',

28652: lv_where_str :=
28653: ' AND NVL(deleted_flag,'||NULL_VALUE||') <>'||SYS_NO;
28654:
28655: lv_return := MSC_ST_UTIL.LOG_ERROR
28656: (p_table_name => 'MSC_ST_RESOURCE_SHIFTS',
28657: p_instance_code => v_instance_code,
28658: p_row => lv_column_names,
28659: p_severity => G_SEV_WARNING,
28660: p_message_text => lv_message_text,

Line 28681: p_token_value1 => 'MSC_ST_RESOURCE_SHIFTS');

28677: p_error_code => 'MSC_PP_NO_DELETION',
28678: p_message_text => lv_message_text,
28679: p_error_text => lv_error_text,
28680: p_token1 => 'TABLE_NAME',
28681: p_token_value1 => 'MSC_ST_RESOURCE_SHIFTS');
28682:
28683: IF lv_return <> 0 THEN
28684: RAISE ex_logging_err;
28685: END IF;

Line 28691: 'UPDATE msc_st_resource_shifts msrs'

28687: -- Popluate the Department id from LOCAL_ID table
28688:
28689: v_sql_stmt := 25;
28690: lv_sql_stmt :=
28691: 'UPDATE msc_st_resource_shifts msrs'
28692: ||' SET department_id = (SELECT local_id'
28693: ||' FROM msc_local_id_setup mlis'
28694: ||' WHERE mlis.char1 = msrs.sr_instance_code'
28695: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '

Line 28722: p_token_value3 => 'MSC_ST_RESOURCE_SHIFTS' );

28718: ||' ORGANIZATION_CODE,DEPARTMENT_CODE',
28719: p_token2 => 'MASTER_TABLE',
28720: p_token_value2 => 'MSC_ST_DEPARTMENT_RESOURCES',
28721: p_token3 => 'CHILD_TABLE' ,
28722: p_token_value3 => 'MSC_ST_RESOURCE_SHIFTS' );
28723:
28724: IF lv_return <> 0 THEN
28725: RAISE ex_logging_err;
28726: END IF;

Line 28733: 'UPDATE msc_st_resource_shifts '

28729: -- Error out the reords where department id is NULL
28730:
28731: v_sql_stmt := 26;
28732: lv_sql_stmt:=
28733: 'UPDATE msc_st_resource_shifts '
28734: ||' SET process_flag = '||G_ERROR_FLG||','
28735: ||' error_text = '||''''||lv_message_text||''''
28736: ||' WHERE NVL(department_id,'||NULL_VALUE||') = '||NULL_VALUE
28737: ||' AND sr_instance_code = :v_instance_code'

Line 28749: 'UPDATE msc_st_resource_shifts msrs'

28745:
28746: -- Popluate the resource id from LOCAL_ID table
28747: v_sql_stmt := 27;
28748: lv_sql_stmt:=
28749: 'UPDATE msc_st_resource_shifts msrs'
28750: ||' SET resource_id = (SELECT local_id FROM msc_local_id_setup mlis'
28751: ||' WHERE mlis.char1 = msrs.sr_instance_code'
28752: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '
28753: ||' = NVL(msrs.company_name,'||''''||NULL_CHAR||''''||') '

Line 28779: p_token_value3 => 'MSC_ST_RESOURCE_SHIFTS' );

28775: ||' ORGANIZATION_CODE,RESOURCE_CODE',
28776: p_token2 => 'MASTER_TABLE',
28777: p_token_value2 => 'MSC_ST_DEPARTMENT_RESOURCES',
28778: p_token3 => 'CHILD_TABLE' ,
28779: p_token_value3 => 'MSC_ST_RESOURCE_SHIFTS' );
28780:
28781: IF lv_return <> 0 THEN
28782: RAISE ex_logging_err;
28783: END IF;

Line 28789: 'UPDATE msc_st_resource_shifts '

28785: -- Error out the records where resource id is NULL
28786:
28787: v_sql_stmt := 28;
28788: lv_sql_stmt:=
28789: 'UPDATE msc_st_resource_shifts '
28790: ||' SET process_flag = '||G_ERROR_FLG||','
28791: ||' error_text = '||''''||lv_message_text||''''
28792: ||' WHERE NVL(resource_id,'||NULL_VALUE||') = '||NULL_VALUE
28793: ||' AND sr_instance_code = :v_instance_code'

Line 28808: 'UPDATE msc_st_resource_shifts msrs'

28804: -- Derive the SHIFT_NUM
28805:
28806: v_sql_stmt := 29;
28807: lv_sql_stmt :=
28808: 'UPDATE msc_st_resource_shifts msrs'
28809: ||' SET shift_num =(SELECT mlis.local_id'
28810: ||' FROM msc_local_id_setup mlis, msc_st_trading_partners mtp '
28811: ||' WHERE mtp.sr_instance_id = '||v_instance_id
28812: ||' AND mlis.char1 = msrs.sr_instance_code'

Line 28834: 'UPDATE msc_st_resource_shifts msrs'

28830:
28831: /* Bug 2172537 ,instance code not prefixed in calendar and org*/
28832:
28833: lv_sql_stmt :=
28834: 'UPDATE msc_st_resource_shifts msrs'
28835: ||' SET shift_num =(SELECT mlis.local_id'
28836: ||' FROM msc_local_id_setup mlis, msc_trading_partners mtp '
28837: ||' WHERE mtp.sr_instance_id = '||v_instance_id
28838: ||' AND mlis.char1 = msrs.sr_instance_code'

Line 28871: p_token_value3 => 'MSC_ST_RESOURCE_SHIFTS' );

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
28874: RAISE ex_logging_err;
28875: END IF;

Line 28883: 'UPDATE msc_st_resource_shifts '

28879:
28880: v_sql_stmt := 30;
28881:
28882: lv_sql_stmt:=
28883: 'UPDATE msc_st_resource_shifts '
28884: ||' SET process_flag = '||G_ERROR_FLG||','
28885: ||' error_text = '||''''||lv_message_text||''''
28886: ||' WHERE NVL(shift_num,'||NULL_VALUE||') = '||NULL_VALUE
28887: ||' AND sr_instance_code = :v_instance_code'

Line 28904: pEntityName => 'MSC_ST_RESOURCE_SHIFTS',

28900: (ERRBUF => lv_error_text,
28901: RETCODE => lv_return,
28902: pBatchID => lv_batch_id,
28903: pInstanceCode => v_instance_code,
28904: pEntityName => 'MSC_ST_RESOURCE_SHIFTS',
28905: pInstanceID => v_instance_id);
28906:
28907: IF NVL(lv_return,0) <> 0 THEN
28908: RAISE ex_logging_err;

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

28910:
28911:
28912: -- Set the process flag as Valid and populate instance_id
28913: lv_return :=
28914: MSC_ST_UTIL.SET_PROCESS_FLAG(p_table_name => 'MSC_ST_RESOURCE_SHIFTS',
28915: p_instance_id => v_instance_id,
28916: p_instance_code => v_instance_code,
28917: p_process_flag => G_VALID,
28918: p_error_text => lv_error_text,

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

28925:
28926: -- At the end calling the LOG_ERROR for logging all errored out records
28927:
28928: lv_return :=
28929: MSC_ST_UTIL.LOG_ERROR(p_table_name =>'MSC_ST_RESOURCE_SHIFTS',
28930: p_instance_code =>v_instance_code,
28931: p_row =>lv_column_names,
28932: p_severity =>G_ERROR_FLG,
28933: p_message_text =>NULL,

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

50976: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_DEPARTMENT_RESOURCES');
50977: IF lv_count > 0 Then
50978: prec.bom_flag:= SYS_YES;
50979: End IF;
50980: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_RESOURCE_SHIFTS');
50981: IF lv_count > 0 Then
50982: prec.bom_flag:= SYS_YES;
50983: prec.calendar_flag:=SYS_YES;
50984: End IF;