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 942: 'create index MSC_ST_RESOURCE_GROUPS_N1_'||v_instance_code

938: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
939: application_short_name => 'MSC',
940: statement_type => AD_DDL.CREATE_INDEX,
941: statement =>
942: 'create index MSC_ST_RESOURCE_GROUPS_N1_'||v_instance_code
943: ||' on MSC_ST_RESOURCE_GROUPS '
944: ||'(sr_instance_code, group_code, company_name) '
945: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
946: object_name =>'MSC_ST_RESOURCE_GROUPS_N1_'||v_instance_code);

Line 943: ||' on MSC_ST_RESOURCE_GROUPS '

939: application_short_name => 'MSC',
940: statement_type => AD_DDL.CREATE_INDEX,
941: statement =>
942: 'create index MSC_ST_RESOURCE_GROUPS_N1_'||v_instance_code
943: ||' on MSC_ST_RESOURCE_GROUPS '
944: ||'(sr_instance_code, group_code, company_name) '
945: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
946: object_name =>'MSC_ST_RESOURCE_GROUPS_N1_'||v_instance_code);
947:

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

942: 'create index MSC_ST_RESOURCE_GROUPS_N1_'||v_instance_code
943: ||' on MSC_ST_RESOURCE_GROUPS '
944: ||'(sr_instance_code, group_code, company_name) '
945: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
946: object_name =>'MSC_ST_RESOURCE_GROUPS_N1_'||v_instance_code);
947:
948: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_RESOURCE_GROUPS_N1_'||v_instance_code);
949:
950: EXCEPTION

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

944: ||'(sr_instance_code, group_code, company_name) '
945: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
946: object_name =>'MSC_ST_RESOURCE_GROUPS_N1_'||v_instance_code);
947:
948: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_RESOURCE_GROUPS_N1_'||v_instance_code);
949:
950: EXCEPTION
951: WHEN OTHERS THEN
952: 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 952: 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));

948: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_RESOURCE_GROUPS_N1_'||v_instance_code);
949:
950: EXCEPTION
951: WHEN OTHERS THEN
952: 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));
953: END;
954:
955: BEGIN
956: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

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

1005: WHEN OTHERS THEN
1006: 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));
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:

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

2187: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2188: application_short_name => 'MSC',
2189: statement_type => AD_DDL.DROP_INDEX,
2190: statement =>
2191: 'drop index MSC_ST_RESOURCE_GROUPS_N1_'||v_instance_code,
2192: object_name => 'MSC_ST_RESOURCE_GROUPS_N1_'||v_instance_code);
2193:
2194: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_RESOURCE_GROUPS_N1_'||v_instance_code);
2195:

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

2188: application_short_name => 'MSC',
2189: statement_type => AD_DDL.DROP_INDEX,
2190: statement =>
2191: 'drop index MSC_ST_RESOURCE_GROUPS_N1_'||v_instance_code,
2192: object_name => 'MSC_ST_RESOURCE_GROUPS_N1_'||v_instance_code);
2193:
2194: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_RESOURCE_GROUPS_N1_'||v_instance_code);
2195:
2196: EXCEPTION

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

2190: statement =>
2191: 'drop index MSC_ST_RESOURCE_GROUPS_N1_'||v_instance_code,
2192: object_name => 'MSC_ST_RESOURCE_GROUPS_N1_'||v_instance_code);
2193:
2194: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_RESOURCE_GROUPS_N1_'||v_instance_code);
2195:
2196: EXCEPTION
2197: WHEN OTHERS THEN
2198: 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 2198: 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));

2194: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_RESOURCE_GROUPS_N1_'||v_instance_code);
2195:
2196: EXCEPTION
2197: WHEN OTHERS THEN
2198: 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));
2199: END;
2200:
2201: BEGIN
2202: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

Line 30550: FROM msc_st_resource_groups

30546: company_name,organization_code ;
30547:
30548: CURSOR c9(p_batch_id NUMBER) IS
30549: SELECT rowid
30550: FROM msc_st_resource_groups
30551: WHERE process_flag IN (G_IN_PROCESS,G_ERROR_FLG)
30552: AND sr_instance_code = v_instance_code
30553: AND batch_id = p_batch_id;
30554:

Line 30570: ' UPDATE msc_st_resource_groups mrg1'

30566:
30567: --Duplicate records check for the records whose source is XML
30568: v_sql_stmt := 01;
30569: lv_sql_stmt :=
30570: ' UPDATE msc_st_resource_groups mrg1'
30571: ||' SET process_flag = '||G_ERROR_FLG||','
30572: ||' error_text = '||''''||lv_message_text||''''
30573: ||' WHERE message_id < (SELECT MAX(message_id)'
30574: ||' FROM msc_st_resource_groups mrg2'

Line 30574: ||' FROM msc_st_resource_groups mrg2'

30570: ' UPDATE msc_st_resource_groups mrg1'
30571: ||' SET process_flag = '||G_ERROR_FLG||','
30572: ||' error_text = '||''''||lv_message_text||''''
30573: ||' WHERE message_id < (SELECT MAX(message_id)'
30574: ||' FROM msc_st_resource_groups mrg2'
30575: ||' WHERE mrg2.sr_instance_code = mrg1.sr_instance_code'
30576: ||' AND mrg2.group_code = mrg1.group_code'
30577: ||' AND NVL(mrg2.company_name, ' ||''''||NULL_CHAR||''''||') = '
30578: ||' NVL(mrg1.company_name, ' ||''''||NULL_CHAR||''''||')'

Line 30606: ' UPDATE msc_st_resource_groups mrg1'

30602: --Different SQL is used because in XML we can identify the latest records
30603: --whereas in batch load we cannot.
30604: v_sql_stmt := 02;
30605: lv_sql_stmt :=
30606: ' UPDATE msc_st_resource_groups mrg1'
30607: ||' SET process_flag = '||G_ERROR_FLG||','
30608: ||' error_text = '||''''||lv_message_text||''''
30609: ||' WHERE EXISTS( SELECT 1 '
30610: ||' FROM msc_st_resource_groups mrg2'

Line 30610: ||' FROM msc_st_resource_groups mrg2'

30606: ' UPDATE msc_st_resource_groups mrg1'
30607: ||' SET process_flag = '||G_ERROR_FLG||','
30608: ||' error_text = '||''''||lv_message_text||''''
30609: ||' WHERE EXISTS( SELECT 1 '
30610: ||' FROM msc_st_resource_groups mrg2'
30611: ||' WHERE mrg2.sr_instance_code = mrg1.sr_instance_code'
30612: ||' AND mrg2.group_code = mrg1.group_code'
30613: ||' AND NVL(mrg2.company_name, ' ||''''||NULL_CHAR||''''||') = '
30614: ||' NVL(mrg1.company_name, ' ||''''||NULL_CHAR||''''||')'

Line 30648: ' UPDATE msc_st_resource_groups '

30644: FROM dual;
30645:
30646: v_sql_stmt := 04;
30647: lv_sql_stmt :=
30648: ' UPDATE msc_st_resource_groups '
30649: ||' SET batch_id = :lv_batch_id'
30650: ||' WHERE process_flag IN ('||G_IN_PROCESS||','||G_ERROR_FLG||')'
30651: ||' AND sr_instance_code = :v_instance_code'
30652: ||' AND NVL(batch_id,'||NULL_VALUE||') = '||NULL_VALUE

Line 30670: UPDATE msc_st_resource_groups

30666: CLOSE c9;
30667:
30668: v_sql_stmt := 05;
30669: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
30670: UPDATE msc_st_resource_groups
30671: SET st_transaction_id = msc_st_resource_groups_s.NEXTVAL,
30672: refresh_id = v_refresh_id,
30673: last_update_date = v_current_date,
30674: last_updated_by = v_current_user,

Line 30671: SET st_transaction_id = msc_st_resource_groups_s.NEXTVAL,

30667:
30668: v_sql_stmt := 05;
30669: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
30670: UPDATE msc_st_resource_groups
30671: SET st_transaction_id = msc_st_resource_groups_s.NEXTVAL,
30672: refresh_id = v_refresh_id,
30673: last_update_date = v_current_date,
30674: last_updated_by = v_current_user,
30675: creation_date = v_current_date,

Line 30685: p_token_value1 => 'MSC_ST_RESOURCE_GROUPS');

30681: p_error_code => 'MSC_PP_NO_DELETION',
30682: p_message_text => lv_message_text,
30683: p_error_text => lv_error_text,
30684: p_token1 => 'TABLE_NAME',
30685: p_token_value1 => 'MSC_ST_RESOURCE_GROUPS');
30686:
30687: IF lv_return <> 0 THEN
30688: RAISE ex_logging_err;
30689: END IF;

Line 30694: ' UPDATE msc_st_resource_groups '

30690:
30691: --Deletion is not allowed for this entity.
30692: v_sql_stmt := 06;
30693: lv_sql_stmt :=
30694: ' UPDATE msc_st_resource_groups '
30695: ||' SET process_flag = '||G_ERROR_FLG||','
30696: ||' error_text = '||''''||lv_message_text||''''
30697: ||' WHERE deleted_flag = '||SYS_YES
30698: ||' AND process_flag = '||G_IN_PROCESS

Line 30723: ' UPDATE msc_st_resource_groups '

30719: END IF;
30720:
30721: v_sql_stmt := 07;
30722: lv_sql_stmt :=
30723: ' UPDATE msc_st_resource_groups '
30724: ||' SET process_flag = '||G_ERROR_FLG||','
30725: ||' error_text = '||''''||lv_message_text||''''
30726: ||' WHERE (group_code IS NULL '
30727: ||' OR meaning IS NULL) '

Line 30753: ' UPDATE msc_st_resource_groups '

30749: END IF;
30750:
30751: v_sql_stmt := 08;
30752: lv_sql_stmt :=
30753: ' UPDATE msc_st_resource_groups '
30754: ||' SET process_flag = '||G_ERROR_FLG||','
30755: ||' error_text = '||''''||lv_message_text||''''
30756: ||' WHERE from_date > to_date '
30757: ||' AND batch_id = :lv_batch_id'

Line 30773: p_token_value1 => 'MSC_ST_RESOURCE_GROUPS');

30769: p_error_code => 'MSC_PP_NO_UPDATION',
30770: p_message_text => lv_message_text,
30771: p_error_text => lv_error_text,
30772: p_token1 => 'TABLE_NAME',
30773: p_token_value1 => 'MSC_ST_RESOURCE_GROUPS');
30774:
30775: IF lv_return <> 0 THEN
30776: RAISE ex_logging_err;
30777: END IF;

Line 30783: ' UPDATE msc_st_resource_groups mrg1'

30779: --Updation is not allowed on this entity(this is done to make the
30780: --Post-Processor in sync with the collection program).
30781: v_sql_stmt := 09;
30782: lv_sql_stmt :=
30783: ' UPDATE msc_st_resource_groups mrg1'
30784: ||' SET process_flag = '||G_ERROR_FLG||','
30785: ||' error_text = '||''''||lv_message_text||''''
30786: ||' WHERE process_flag = '||G_IN_PROCESS
30787: ||' AND batch_id = :lv_batch_id'

Line 30823: (p_table_name => 'MSC_ST_RESOURCE_GROUPS',

30819: lv_where_str :=
30820: ' AND NVL(enabled_flag,'||NULL_VALUE||') NOT IN (1,2) ';
30821:
30822: lv_return := MSC_ST_UTIL.LOG_ERROR
30823: (p_table_name => 'MSC_ST_RESOURCE_GROUPS',
30824: p_instance_code => v_instance_code,
30825: p_row => lv_column_names,
30826: p_severity => G_SEV_WARNING,
30827: p_message_text => lv_message_text,

Line 30845: pEntityName => 'MSC_ST_RESOURCE_GROUPS',

30841: (ERRBUF => lv_error_text,
30842: RETCODE => lv_return,
30843: pBatchID => lv_batch_id,
30844: pInstanceCode => v_instance_code,
30845: pEntityName => 'MSC_ST_RESOURCE_GROUPS',
30846: pInstanceID => v_instance_id);
30847:
30848: IF NVL(lv_return,0) <> 0 THEN
30849: RAISE ex_logging_err;

Line 30853: (p_table_name => 'MSC_ST_RESOURCE_GROUPS',

30849: RAISE ex_logging_err;
30850: END IF;
30851:
30852: lv_return := MSC_ST_UTIL.SET_PROCESS_FLAG
30853: (p_table_name => 'MSC_ST_RESOURCE_GROUPS',
30854: p_instance_id => v_instance_id,
30855: p_instance_code => v_instance_code,
30856: p_process_flag => G_VALID,
30857: p_error_text => lv_error_text,

Line 30866: (p_table_name => 'MSC_ST_RESOURCE_GROUPS',

30862: RAISE ex_logging_err;
30863: END IF;
30864:
30865: lv_return := MSC_ST_UTIL.LOG_ERROR
30866: (p_table_name => 'MSC_ST_RESOURCE_GROUPS',
30867: p_instance_code => v_instance_code,
30868: p_row => lv_column_names,
30869: p_severity => G_SEV_ERROR,
30870: p_message_text => NULL,

Line 30909: ||' FROM msc_st_resource_groups'

30905: ||' last_update_date,'
30906: ||' last_updated_by,'
30907: ||' creation_date,'
30908: ||' created_by '
30909: ||' FROM msc_st_resource_groups'
30910: ||' WHERE sr_instance_code = :sr_instance_code'
30911: ||' AND batch_id = :lv_batch_id'
30912: ||' AND process_flag = '||G_VALID;
30913:

Line 31171: -- in the msc_st_resource_groups entity.

31167: RAISE ex_logging_err;
31168: END IF;
31169:
31170: -- Resource group Name should refer to a valid group code
31171: -- in the msc_st_resource_groups entity.
31172: v_sql_stmt := 08;
31173:
31174: lv_sql_stmt :=
31175: ' UPDATE msc_st_department_resources mdr'

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

55882: End IF;
55883: END IF;
55884:
55885: IF v_resources_enabled = SYS_YES THEN
55886: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_RESOURCE_GROUPS');
55887: IF lv_count > 0 Then
55888: prec.bom_flag:= SYS_YES;
55889: End IF;
55890: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_DEPARTMENT_RESOURCES');