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_GROUPS

Line 934: 'create index MSC_ST_RESOURCE_GROUPS_N1_'||v_instance_code

930: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
931: application_short_name => 'MSC',
932: statement_type => AD_DDL.CREATE_INDEX,
933: statement =>
934: 'create index MSC_ST_RESOURCE_GROUPS_N1_'||v_instance_code
935: ||' on MSC_ST_RESOURCE_GROUPS '
936: ||'(sr_instance_code, group_code, company_name) '
937: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
938: object_name =>'MSC_ST_RESOURCE_GROUPS_N1_'||v_instance_code);

Line 935: ||' on MSC_ST_RESOURCE_GROUPS '

931: application_short_name => 'MSC',
932: statement_type => AD_DDL.CREATE_INDEX,
933: statement =>
934: 'create index MSC_ST_RESOURCE_GROUPS_N1_'||v_instance_code
935: ||' on MSC_ST_RESOURCE_GROUPS '
936: ||'(sr_instance_code, group_code, company_name) '
937: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
938: object_name =>'MSC_ST_RESOURCE_GROUPS_N1_'||v_instance_code);
939:

Line 938: object_name =>'MSC_ST_RESOURCE_GROUPS_N1_'||v_instance_code);

934: 'create index MSC_ST_RESOURCE_GROUPS_N1_'||v_instance_code
935: ||' on MSC_ST_RESOURCE_GROUPS '
936: ||'(sr_instance_code, group_code, company_name) '
937: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
938: object_name =>'MSC_ST_RESOURCE_GROUPS_N1_'||v_instance_code);
939:
940: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_RESOURCE_GROUPS_N1_'||v_instance_code);
941:
942: EXCEPTION

Line 940: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_RESOURCE_GROUPS_N1_'||v_instance_code);

936: ||'(sr_instance_code, group_code, company_name) '
937: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
938: object_name =>'MSC_ST_RESOURCE_GROUPS_N1_'||v_instance_code);
939:
940: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_RESOURCE_GROUPS_N1_'||v_instance_code);
941:
942: EXCEPTION
943: WHEN OTHERS THEN
944: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error creating Index MSC_ST_RESOURCE_GROUPS_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));

Line 944: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error creating Index MSC_ST_RESOURCE_GROUPS_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));

940: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_RESOURCE_GROUPS_N1_'||v_instance_code);
941:
942: EXCEPTION
943: WHEN OTHERS THEN
944: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error creating Index MSC_ST_RESOURCE_GROUPS_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
945: END;
946:
947: BEGIN
948: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

Line 1001: msc_analyse_tables_pk.analyse_table( 'MSC_ST_RESOURCE_GROUPS', v_instance_id, -1);

997: WHEN OTHERS THEN
998: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error creating Index MSC_ST_RES_CHANGES_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
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:

Line 2183: 'drop index MSC_ST_RESOURCE_GROUPS_N1_'||v_instance_code,

2179: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2180: application_short_name => 'MSC',
2181: statement_type => AD_DDL.DROP_INDEX,
2182: statement =>
2183: 'drop index MSC_ST_RESOURCE_GROUPS_N1_'||v_instance_code,
2184: object_name => 'MSC_ST_RESOURCE_GROUPS_N1_'||v_instance_code);
2185:
2186: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_RESOURCE_GROUPS_N1_'||v_instance_code);
2187:

Line 2184: object_name => 'MSC_ST_RESOURCE_GROUPS_N1_'||v_instance_code);

2180: application_short_name => 'MSC',
2181: statement_type => AD_DDL.DROP_INDEX,
2182: statement =>
2183: 'drop index MSC_ST_RESOURCE_GROUPS_N1_'||v_instance_code,
2184: object_name => 'MSC_ST_RESOURCE_GROUPS_N1_'||v_instance_code);
2185:
2186: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_RESOURCE_GROUPS_N1_'||v_instance_code);
2187:
2188: EXCEPTION

Line 2186: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_RESOURCE_GROUPS_N1_'||v_instance_code);

2182: statement =>
2183: 'drop index MSC_ST_RESOURCE_GROUPS_N1_'||v_instance_code,
2184: object_name => 'MSC_ST_RESOURCE_GROUPS_N1_'||v_instance_code);
2185:
2186: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_RESOURCE_GROUPS_N1_'||v_instance_code);
2187:
2188: EXCEPTION
2189: WHEN OTHERS THEN
2190: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error dropping Index MSC_ST_RESOURCE_GROUPS_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));

Line 2190: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error dropping Index MSC_ST_RESOURCE_GROUPS_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));

2186: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_RESOURCE_GROUPS_N1_'||v_instance_code);
2187:
2188: EXCEPTION
2189: WHEN OTHERS THEN
2190: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error dropping Index MSC_ST_RESOURCE_GROUPS_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
2191: END;
2192:
2193: BEGIN
2194: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

Line 27036: FROM msc_st_resource_groups

27032: company_name,organization_code ;
27033:
27034: CURSOR c9(p_batch_id NUMBER) IS
27035: SELECT rowid
27036: FROM msc_st_resource_groups
27037: WHERE process_flag IN (G_IN_PROCESS,G_ERROR_FLG)
27038: AND sr_instance_code = v_instance_code
27039: AND batch_id = p_batch_id;
27040:

Line 27056: ' UPDATE msc_st_resource_groups mrg1'

27052:
27053: --Duplicate records check for the records whose source is XML
27054: v_sql_stmt := 01;
27055: lv_sql_stmt :=
27056: ' UPDATE msc_st_resource_groups mrg1'
27057: ||' SET process_flag = '||G_ERROR_FLG||','
27058: ||' error_text = '||''''||lv_message_text||''''
27059: ||' WHERE message_id < (SELECT MAX(message_id)'
27060: ||' FROM msc_st_resource_groups mrg2'

Line 27060: ||' FROM msc_st_resource_groups mrg2'

27056: ' UPDATE msc_st_resource_groups mrg1'
27057: ||' SET process_flag = '||G_ERROR_FLG||','
27058: ||' error_text = '||''''||lv_message_text||''''
27059: ||' WHERE message_id < (SELECT MAX(message_id)'
27060: ||' FROM msc_st_resource_groups mrg2'
27061: ||' WHERE mrg2.sr_instance_code = mrg1.sr_instance_code'
27062: ||' AND mrg2.group_code = mrg1.group_code'
27063: ||' AND NVL(mrg2.company_name, ' ||''''||NULL_CHAR||''''||') = '
27064: ||' NVL(mrg1.company_name, ' ||''''||NULL_CHAR||''''||')'

Line 27092: ' UPDATE msc_st_resource_groups mrg1'

27088: --Different SQL is used because in XML we can identify the latest records
27089: --whereas in batch load we cannot.
27090: v_sql_stmt := 02;
27091: lv_sql_stmt :=
27092: ' UPDATE msc_st_resource_groups mrg1'
27093: ||' SET process_flag = '||G_ERROR_FLG||','
27094: ||' error_text = '||''''||lv_message_text||''''
27095: ||' WHERE EXISTS( SELECT 1 '
27096: ||' FROM msc_st_resource_groups mrg2'

Line 27096: ||' FROM msc_st_resource_groups mrg2'

27092: ' UPDATE msc_st_resource_groups mrg1'
27093: ||' SET process_flag = '||G_ERROR_FLG||','
27094: ||' error_text = '||''''||lv_message_text||''''
27095: ||' WHERE EXISTS( SELECT 1 '
27096: ||' FROM msc_st_resource_groups mrg2'
27097: ||' WHERE mrg2.sr_instance_code = mrg1.sr_instance_code'
27098: ||' AND mrg2.group_code = mrg1.group_code'
27099: ||' AND NVL(mrg2.company_name, ' ||''''||NULL_CHAR||''''||') = '
27100: ||' NVL(mrg1.company_name, ' ||''''||NULL_CHAR||''''||')'

Line 27134: ' UPDATE msc_st_resource_groups '

27130: FROM dual;
27131:
27132: v_sql_stmt := 04;
27133: lv_sql_stmt :=
27134: ' UPDATE msc_st_resource_groups '
27135: ||' SET batch_id = :lv_batch_id'
27136: ||' WHERE process_flag IN ('||G_IN_PROCESS||','||G_ERROR_FLG||')'
27137: ||' AND sr_instance_code = :v_instance_code'
27138: ||' AND NVL(batch_id,'||NULL_VALUE||') = '||NULL_VALUE

Line 27156: UPDATE msc_st_resource_groups

27152: CLOSE c9;
27153:
27154: v_sql_stmt := 05;
27155: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
27156: UPDATE msc_st_resource_groups
27157: SET st_transaction_id = msc_st_resource_groups_s.NEXTVAL,
27158: refresh_id = v_refresh_id,
27159: last_update_date = v_current_date,
27160: last_updated_by = v_current_user,

Line 27157: SET st_transaction_id = msc_st_resource_groups_s.NEXTVAL,

27153:
27154: v_sql_stmt := 05;
27155: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
27156: UPDATE msc_st_resource_groups
27157: SET st_transaction_id = msc_st_resource_groups_s.NEXTVAL,
27158: refresh_id = v_refresh_id,
27159: last_update_date = v_current_date,
27160: last_updated_by = v_current_user,
27161: creation_date = v_current_date,

Line 27171: p_token_value1 => 'MSC_ST_RESOURCE_GROUPS');

27167: p_error_code => 'MSC_PP_NO_DELETION',
27168: p_message_text => lv_message_text,
27169: p_error_text => lv_error_text,
27170: p_token1 => 'TABLE_NAME',
27171: p_token_value1 => 'MSC_ST_RESOURCE_GROUPS');
27172:
27173: IF lv_return <> 0 THEN
27174: RAISE ex_logging_err;
27175: END IF;

Line 27180: ' UPDATE msc_st_resource_groups '

27176:
27177: --Deletion is not allowed for this entity.
27178: v_sql_stmt := 06;
27179: lv_sql_stmt :=
27180: ' UPDATE msc_st_resource_groups '
27181: ||' SET process_flag = '||G_ERROR_FLG||','
27182: ||' error_text = '||''''||lv_message_text||''''
27183: ||' WHERE deleted_flag = '||SYS_YES
27184: ||' AND process_flag = '||G_IN_PROCESS

Line 27209: ' UPDATE msc_st_resource_groups '

27205: END IF;
27206:
27207: v_sql_stmt := 07;
27208: lv_sql_stmt :=
27209: ' UPDATE msc_st_resource_groups '
27210: ||' SET process_flag = '||G_ERROR_FLG||','
27211: ||' error_text = '||''''||lv_message_text||''''
27212: ||' WHERE (group_code IS NULL '
27213: ||' OR meaning IS NULL) '

Line 27239: ' UPDATE msc_st_resource_groups '

27235: END IF;
27236:
27237: v_sql_stmt := 08;
27238: lv_sql_stmt :=
27239: ' UPDATE msc_st_resource_groups '
27240: ||' SET process_flag = '||G_ERROR_FLG||','
27241: ||' error_text = '||''''||lv_message_text||''''
27242: ||' WHERE from_date > to_date '
27243: ||' AND batch_id = :lv_batch_id'

Line 27259: p_token_value1 => 'MSC_ST_RESOURCE_GROUPS');

27255: p_error_code => 'MSC_PP_NO_UPDATION',
27256: p_message_text => lv_message_text,
27257: p_error_text => lv_error_text,
27258: p_token1 => 'TABLE_NAME',
27259: p_token_value1 => 'MSC_ST_RESOURCE_GROUPS');
27260:
27261: IF lv_return <> 0 THEN
27262: RAISE ex_logging_err;
27263: END IF;

Line 27269: ' UPDATE msc_st_resource_groups mrg1'

27265: --Updation is not allowed on this entity(this is done to make the
27266: --Post-Processor in sync with the collection program).
27267: v_sql_stmt := 09;
27268: lv_sql_stmt :=
27269: ' UPDATE msc_st_resource_groups mrg1'
27270: ||' SET process_flag = '||G_ERROR_FLG||','
27271: ||' error_text = '||''''||lv_message_text||''''
27272: ||' WHERE process_flag = '||G_IN_PROCESS
27273: ||' AND batch_id = :lv_batch_id'

Line 27309: (p_table_name => 'MSC_ST_RESOURCE_GROUPS',

27305: lv_where_str :=
27306: ' AND NVL(enabled_flag,'||NULL_VALUE||') NOT IN (1,2) ';
27307:
27308: lv_return := MSC_ST_UTIL.LOG_ERROR
27309: (p_table_name => 'MSC_ST_RESOURCE_GROUPS',
27310: p_instance_code => v_instance_code,
27311: p_row => lv_column_names,
27312: p_severity => G_SEV_WARNING,
27313: p_message_text => lv_message_text,

Line 27331: pEntityName => 'MSC_ST_RESOURCE_GROUPS',

27327: (ERRBUF => lv_error_text,
27328: RETCODE => lv_return,
27329: pBatchID => lv_batch_id,
27330: pInstanceCode => v_instance_code,
27331: pEntityName => 'MSC_ST_RESOURCE_GROUPS',
27332: pInstanceID => v_instance_id);
27333:
27334: IF NVL(lv_return,0) <> 0 THEN
27335: RAISE ex_logging_err;

Line 27339: (p_table_name => 'MSC_ST_RESOURCE_GROUPS',

27335: RAISE ex_logging_err;
27336: END IF;
27337:
27338: lv_return := MSC_ST_UTIL.SET_PROCESS_FLAG
27339: (p_table_name => 'MSC_ST_RESOURCE_GROUPS',
27340: p_instance_id => v_instance_id,
27341: p_instance_code => v_instance_code,
27342: p_process_flag => G_VALID,
27343: p_error_text => lv_error_text,

Line 27352: (p_table_name => 'MSC_ST_RESOURCE_GROUPS',

27348: RAISE ex_logging_err;
27349: END IF;
27350:
27351: lv_return := MSC_ST_UTIL.LOG_ERROR
27352: (p_table_name => 'MSC_ST_RESOURCE_GROUPS',
27353: p_instance_code => v_instance_code,
27354: p_row => lv_column_names,
27355: p_severity => G_SEV_ERROR,
27356: p_message_text => NULL,

Line 27395: ||' FROM msc_st_resource_groups'

27391: ||' last_update_date,'
27392: ||' last_updated_by,'
27393: ||' creation_date,'
27394: ||' created_by '
27395: ||' FROM msc_st_resource_groups'
27396: ||' WHERE sr_instance_code = :sr_instance_code'
27397: ||' AND batch_id = :lv_batch_id'
27398: ||' AND process_flag = '||G_VALID;
27399:

Line 27617: -- in the msc_st_resource_groups entity.

27613: RAISE ex_logging_err;
27614: END IF;
27615:
27616: -- Resource group Name should refer to a valid group code
27617: -- in the msc_st_resource_groups entity.
27618: v_sql_stmt := 08;
27619:
27620: lv_sql_stmt :=
27621: ' UPDATE msc_st_department_resources mdr'

Line 50972: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_RESOURCE_GROUPS');

50968: End IF;
50969: END IF;
50970:
50971: IF v_resources_enabled = SYS_YES THEN
50972: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_RESOURCE_GROUPS');
50973: IF lv_count > 0 Then
50974: prec.bom_flag:= SYS_YES;
50975: End IF;
50976: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_DEPARTMENT_RESOURCES');