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_OPERATION_RESOURCES

Line 846: ||' on MSC_ST_OPERATION_RESOURCES '

842: application_short_name => 'MSC',
843: statement_type => AD_DDL.CREATE_INDEX,
844: statement =>
845: 'create index MSC_ST_OPER_RES_N1_'||v_instance_code
846: ||' on MSC_ST_OPERATION_RESOURCES '
847: ||'(sr_instance_code, assembly_name, resource_code, organization_code, company_name, alternate_number, operation_seq_code, resource_seq_code, routing_name, alternate_routing_designator) '
848: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
849: object_name =>'MSC_ST_OPER_RES_N1_'||v_instance_code);
850:

Line 878: msc_analyse_tables_pk.analyse_table( 'MSC_ST_OPERATION_RESOURCES', v_instance_id, -1);

874: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error creating Index MSC_ST_OPER_NTWK_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
875: END;
876:
877: msc_analyse_tables_pk.analyse_table( 'MSC_ST_ROUTINGS', v_instance_id, -1);
878: msc_analyse_tables_pk.analyse_table( 'MSC_ST_OPERATION_RESOURCES', v_instance_id, -1);
879: msc_analyse_tables_pk.analyse_table( 'MSC_ST_ROUTING_OPERATIONS', v_instance_id, -1);
880: msc_analyse_tables_pk.analyse_table( 'MSC_ST_OPERATION_NETWORKS', v_instance_id, -1);
881:
882:

Line 38729: FROM msc_st_operation_resources

38725: AND deleted_flag = SYS_NO;
38726:
38727: CURSOR c6(p_batch_id NUMBER) IS
38728: SELECT rowid
38729: FROM msc_st_operation_resources
38730: WHERE process_flag IN (G_IN_PROCESS,G_ERROR_FLG)
38731: AND sr_instance_code = v_instance_code
38732: AND batch_id = p_batch_id;
38733:

Line 38736: FROM msc_st_operation_resources

38732: AND batch_id = p_batch_id;
38733:
38734: CURSOR c7(p_batch_id NUMBER) IS
38735: SELECT max(rowid)
38736: FROM msc_st_operation_resources
38737: WHERE process_flag = G_IN_PROCESS
38738: AND sr_instance_code = v_instance_code
38739: AND batch_id = p_batch_id
38740: AND NVL(resource_seq_num,NULL_VALUE) = NULL_VALUE

Line 38749: FROM msc_st_operation_resources

38745: alternate_routing_designator,alternate_number;
38746:
38747: CURSOR c8(p_batch_id NUMBER) IS
38748: SELECT max(rowid)
38749: FROM msc_st_operation_resources
38750: WHERE process_flag = G_IN_PROCESS
38751: AND sr_instance_code = v_instance_code
38752: AND batch_id = p_batch_id
38753: AND NVL(resource_seq_num,NULL_VALUE) <> NULL_VALUE

Line 40503: -- Validation for the MSC_ST_OPERATION_RESOURCES

40499:
40500: COMMIT;
40501: END LOOP;
40502:
40503: -- Validation for the MSC_ST_OPERATION_RESOURCES
40504:
40505: --Duplicate records check for the records whose source is XML
40506:
40507: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE

Line 40521: 'UPDATE msc_st_operation_resources msor1 '

40517:
40518: v_sql_stmt := 32;
40519:
40520: lv_sql_stmt:=
40521: 'UPDATE msc_st_operation_resources msor1 '
40522: ||' SET process_flag = '||G_ERROR_FLG||','
40523: ||' error_text = '||''''||lv_message_text||''''
40524: ||' WHERE message_id < ( SELECT max(message_id)'
40525: ||' FROM msc_st_operation_resources msor2'

Line 40525: ||' FROM msc_st_operation_resources msor2'

40521: 'UPDATE msc_st_operation_resources msor1 '
40522: ||' SET process_flag = '||G_ERROR_FLG||','
40523: ||' error_text = '||''''||lv_message_text||''''
40524: ||' WHERE message_id < ( SELECT max(message_id)'
40525: ||' FROM msc_st_operation_resources msor2'
40526: ||' WHERE msor2.sr_instance_code = msor1.sr_instance_code'
40527: ||' AND msor2.organization_code = msor1.organization_code'
40528: ||' AND NVL(msor2.company_name,'||''''||NULL_CHAR||''''||') '
40529: ||' = NVL(msor1.company_name,'||''''||NULL_CHAR||''''||') '

Line 40568: 'UPDATE msc_st_operation_resources msor1'

40564: END IF;
40565:
40566: v_sql_stmt := 33;
40567: lv_sql_stmt :=
40568: 'UPDATE msc_st_operation_resources msor1'
40569: ||' SET process_flag = '||G_ERROR_FLG||','
40570: ||' error_text = '||''''||lv_message_text||''''
40571: ||' WHERE EXISTS ( SELECT 1 '
40572: ||' FROM msc_st_operation_resources msor2'

Line 40572: ||' FROM msc_st_operation_resources msor2'

40568: 'UPDATE msc_st_operation_resources msor1'
40569: ||' SET process_flag = '||G_ERROR_FLG||','
40570: ||' error_text = '||''''||lv_message_text||''''
40571: ||' WHERE EXISTS ( SELECT 1 '
40572: ||' FROM msc_st_operation_resources msor2'
40573: ||' WHERE msor2.sr_instance_code = msor1.sr_instance_code'
40574: ||' AND msor2.organization_code = msor1.organization_code'
40575: ||' AND NVL(msor2.company_name,'||''''||NULL_CHAR||''''||') '
40576: ||' = NVL(msor1.company_name,'||''''||NULL_CHAR||''''||') '

Line 40635: ' UPDATE msc_st_operation_resources '

40631: CLOSE c1;
40632:
40633: v_sql_stmt := 34;
40634: lv_sql_stmt :=
40635: ' UPDATE msc_st_operation_resources '
40636: ||' SET batch_id = :lv_batch_id'
40637: ||' WHERE process_flag IN ('||G_IN_PROCESS||','||G_ERROR_FLG||')'
40638: ||' AND sr_instance_code = :v_instance_code'
40639: ||' AND NVL(batch_id,'||NULL_VALUE||') = '||NULL_VALUE

Line 40655: UPDATE msc_st_operation_resources

40651: CLOSE c6;
40652:
40653: v_sql_stmt := 35;
40654: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
40655: UPDATE msc_st_operation_resources
40656: SET st_transaction_id = msc_st_operation_resources_s.NEXTVAL,
40657: refresh_id = v_refresh_id,
40658: last_update_date = v_current_date,
40659: last_updated_by = v_current_user,

Line 40656: SET st_transaction_id = msc_st_operation_resources_s.NEXTVAL,

40652:
40653: v_sql_stmt := 35;
40654: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
40655: UPDATE msc_st_operation_resources
40656: SET st_transaction_id = msc_st_operation_resources_s.NEXTVAL,
40657: refresh_id = v_refresh_id,
40658: last_update_date = v_current_date,
40659: last_updated_by = v_current_user,
40660: creation_date = v_current_date,

Line 40687: (p_table_name => 'MSC_ST_OPERATION_RESOURCES',

40683: lv_where_str :=
40684: ' AND NVL(deleted_flag,'||NULL_VALUE||') NOT IN(1,2)';
40685:
40686: lv_return := MSC_ST_UTIL.LOG_ERROR
40687: (p_table_name => 'MSC_ST_OPERATION_RESOURCES',
40688: p_instance_code => v_instance_code,
40689: p_row => lv_column_names,
40690: p_severity => G_SEV_WARNING,
40691: p_message_text => 'lv_message_text',

Line 40709: 'UPDATE msc_st_operation_resources '

40705: -- then populate the ASSEMBLY_NAME in that
40706:
40707: v_sql_stmt := 36;
40708: lv_sql_stmt :=
40709: 'UPDATE msc_st_operation_resources '
40710: ||' SET routing_name = assembly_name'
40711: ||' WHERE sr_instance_code = :v_instance_code'
40712: ||' AND process_flag ='||G_IN_PROCESS
40713: ||' AND NVL(routing_name,'||''''||NULL_CHAR||''''||')'

Line 40728: 'UPDATE msc_st_operation_resources '

40724: -- Error out records where resource_usage is NULL
40725:
40726: v_sql_stmt := 37;
40727: lv_sql_stmt :=
40728: 'UPDATE msc_st_operation_resources '
40729: ||' SET process_flag ='||G_ERROR_FLG||','
40730: ||' error_text = '||''''||lv_message_text||''''
40731: ||' WHERE NVL(resource_usage,'||NULL_VALUE||') ='||NULL_VALUE
40732: ||' AND sr_instance_code = :v_instance_code'

Line 40758: (p_table_name => 'MSC_ST_OPERATION_RESOURCES',

40754:
40755: -- Derive the ROUTING_SEQUENCE_ID from LOCAL ID table
40756: lv_return :=
40757: MSC_ST_UTIL.DERIVE_ROUTING_SEQUENCE_ID
40758: (p_table_name => 'MSC_ST_OPERATION_RESOURCES',
40759: p_rtg_col_name => 'ROUTING_NAME',
40760: p_rtg_col_id =>'ROUTING_SEQUENCE_ID',
40761: p_instance_code => v_instance_code,
40762: p_severity => G_SEV_ERROR,

Line 40794: (p_table_name => 'MSC_ST_OPERATION_RESOURCES',

40790: lv_where_str := ' AND NVL(operation_seq_code,'||''''||NULL_CHAR||''''
40791: ||' ) ='||''''||NULL_CHAR||'''' ;
40792:
40793: lv_return := MSC_ST_UTIL.LOG_ERROR
40794: (p_table_name => 'MSC_ST_OPERATION_RESOURCES',
40795: p_instance_code => v_instance_code,
40796: p_row => lv_column_names,
40797: p_severity => G_SEV_WARNING,
40798: p_message_text => lv_message_text,

Line 40832: (p_table_name => 'MSC_ST_OPERATION_RESOURCES',

40828: lv_where_str :=
40829: ' AND NVL(operation_effectivity_date, SYSDATE-36500 ) = SYSDATE-36500 ' ;
40830:
40831: lv_return := MSC_ST_UTIL.LOG_ERROR
40832: (p_table_name => 'MSC_ST_OPERATION_RESOURCES',
40833: p_instance_code => v_instance_code,
40834: p_row => lv_column_names,
40835: p_severity => G_SEV_WARNING,
40836: p_message_text => lv_message_text,

Line 40852: 'UPDATE msc_st_operation_resources msor'

40848: -- Derive operation sequence id from local id table
40849:
40850: v_sql_stmt := 38;
40851: lv_sql_stmt:=
40852: 'UPDATE msc_st_operation_resources msor'
40853: ||' SET operation_sequence_id= (SELECT local_id'
40854: ||' FROM msc_local_id_setup mlis'
40855: ||' WHERE mlis.char1 = msor.sr_instance_code'
40856: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '

Line 40889: p_token_value3 => 'MSC_ST_OPERATION_RESOURCES' );

40885: ||' ALTERNATE_ROUTING_DESIGNATOR' ,
40886: p_token2 => 'MASTER_TABLE',
40887: p_token_value2 => 'MSC_ST_ROUTING_OPERATIONS',
40888: p_token3 => 'CHILD_TABLE' ,
40889: p_token_value3 => 'MSC_ST_OPERATION_RESOURCES' );
40890:
40891: IF lv_return <> 0 THEN
40892: RAISE ex_logging_err;
40893: END IF;

Line 40901: 'UPDATE msc_st_operation_resources'

40897:
40898: v_sql_stmt := 39;
40899:
40900: lv_sql_stmt :=
40901: 'UPDATE msc_st_operation_resources'
40902: ||' SET process_flag = '||G_ERROR_FLG||','
40903: ||' error_text = '||''''||lv_message_text||''''
40904: ||' WHERE NVL(operation_sequence_id,'||NULL_VALUE||') = '||NULL_VALUE
40905: ||' AND sr_instance_code = :v_instance_code'

Line 40936: (p_table_name => 'MSC_ST_OPERATION_RESOURCES',

40932: lv_where_str := ' AND NVL(resource_seq_code,'||''''||NULL_CHAR||''''
40933: ||' ) ='||''''||NULL_CHAR||'''' ;
40934:
40935: lv_return := MSC_ST_UTIL.LOG_ERROR
40936: (p_table_name => 'MSC_ST_OPERATION_RESOURCES',
40937: p_instance_code => v_instance_code,
40938: p_row => lv_column_names,
40939: p_severity => G_SEV_WARNING,
40940: p_message_text => lv_message_text,

Line 40972: (p_table_name => 'MSC_ST_OPERATION_RESOURCES',

40968:
40969: lv_where_str := ' AND NVL(alternate_number,'||NULL_VALUE||') ='||NULL_VALUE ;
40970:
40971: lv_return := MSC_ST_UTIL.LOG_ERROR
40972: (p_table_name => 'MSC_ST_OPERATION_RESOURCES',
40973: p_instance_code => v_instance_code,
40974: p_row => lv_column_names,
40975: p_severity => G_SEV_WARNING,
40976: p_message_text => lv_message_text,

Line 40992: 'UPDATE msc_st_operation_resources msor'

40988: -- Derive resource seq num from the local id table
40989:
40990: v_sql_stmt := 40;
40991: lv_sql_stmt :=
40992: 'UPDATE msc_st_operation_resources msor'
40993: ||' SET resource_seq_num = (SELECT local_id '
40994: ||' FROM msc_local_id_setup mlis'
40995: ||' WHERE mlis.char1 = msor.sr_instance_code'
40996: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '

Line 41033: 'UPDATE msc_st_operation_resources '

41029: -- and resource_seq_num is NULL
41030:
41031: v_sql_stmt := 41;
41032: lv_sql_stmt :=
41033: 'UPDATE msc_st_operation_resources '
41034: ||' SET process_flag = '||G_ERROR_FLG||','
41035: ||' error_text = '||''''||lv_message_text||''''
41036: ||' WHERE NVL(resource_seq_num,'||NULL_VALUE||') ='||NULL_VALUE
41037: ||' AND deleted_flag = '||SYS_YES

Line 41053: 'UPDATE msc_st_operation_resources msor'

41049: -- Derive resource id
41050: v_sql_stmt := 42;
41051:
41052: lv_sql_stmt :=
41053: 'UPDATE msc_st_operation_resources msor'
41054: ||' SET resource_id = (SELECT local_id'
41055: ||' FROM msc_local_id_setup mlis'
41056: ||' WHERE mlis.char1 = msor.sr_instance_code'
41057: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '

Line 41076: 'UPDATE msc_st_operation_resources msor'

41072: -- Derive department id
41073: v_sql_stmt := 43;
41074:
41075: lv_sql_stmt :=
41076: 'UPDATE msc_st_operation_resources msor'
41077: ||' SET department_id = (SELECT local_id'
41078: ||' FROM msc_local_id_setup mlis'
41079: ||' WHERE mlis.char1 = msor.sr_instance_code'
41080: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '

Line 41108: p_token_value3 => 'MSC_ST_OPERATION_RESOURCES' );

41104: ||' OR RESOURCE_CODE' ,
41105: p_token2 => 'MASTER_TABLE',
41106: p_token_value2 => 'MSC_ST_DEPARTMENT_RESOURCES',
41107: p_token3 => 'CHILD_TABLE' ,
41108: p_token_value3 => 'MSC_ST_OPERATION_RESOURCES' );
41109:
41110: IF lv_return <> 0 THEN
41111: RAISE ex_logging_err;
41112: END IF;

Line 41118: 'UPDATE msc_st_operation_resources'

41114: -- Error out records where resource_id or department_id is NULL
41115:
41116: v_sql_stmt := 44;
41117: lv_sql_stmt :=
41118: 'UPDATE msc_st_operation_resources'
41119: ||' SET process_flag ='||G_ERROR_FLG||','
41120: ||' error_text = '||''''||lv_message_text||''''
41121: ||' WHERE (NVL(resource_id,'||NULL_VALUE||') ='|| NULL_VALUE
41122: ||' OR NVL(department_id,'||NULL_VALUE||') ='|| NULL_VALUE||')'

Line 41155: (p_table_name => 'MSC_ST_OPERATION_RESOURCES',

41151: ' AND NVL(basis_type,'||NULL_VALUE||')'
41152: ||' NOT IN (1,2,3,4,5) AND deleted_flag = 2' ;
41153:
41154: lv_return := MSC_ST_UTIL.LOG_ERROR
41155: (p_table_name => 'MSC_ST_OPERATION_RESOURCES',
41156: p_instance_code => v_instance_code,
41157: p_row => lv_column_names,
41158: p_severity => G_SEV_WARNING,
41159: p_message_text => lv_message_text,

Line 41191: (p_table_name => 'MSC_ST_OPERATION_RESOURCES',

41187: lv_where_str := ' AND NVL(principal_flag,'||NULL_VALUE||')'||' NOT IN (1,2)'
41188: ||'AND deleted_flag = 2';
41189:
41190: lv_return := MSC_ST_UTIL.LOG_ERROR
41191: (p_table_name => 'MSC_ST_OPERATION_RESOURCES',
41192: p_instance_code => v_instance_code,
41193: p_row => lv_column_names,
41194: p_severity => G_SEV_WARNING,
41195: p_message_text => lv_message_text,

Line 41214: pEntityName => 'MSC_ST_OPERATION_RESOURCES',

41210: (ERRBUF => lv_error_text,
41211: RETCODE => lv_return,
41212: pBatchID => lv_batch_id,
41213: pInstanceCode => v_instance_code,
41214: pEntityName => 'MSC_ST_OPERATION_RESOURCES',
41215: pInstanceID => v_instance_id);
41216:
41217: IF NVL(lv_return,0) <> 0 THEN
41218: RAISE ex_logging_err;

Line 41233: UPDATE msc_st_operation_resources

41229: IF c7%ROWCOUNT > 0 THEN
41230:
41231: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
41232:
41233: UPDATE msc_st_operation_resources
41234: SET resource_seq_num =
41235: to_number(decode(length(rtrim(resource_seq_code,'0123456789')),
41236: NULL,resource_seq_code,'1'))
41237: WHERE rowid = lb_rowid(j);

Line 41292: FROM msc_st_operation_resources

41288: v_current_date,
41289: v_current_user,
41290: v_current_date,
41291: v_current_user
41292: FROM msc_st_operation_resources
41293: WHERE rowid = lb_rowid(j) ;
41294:
41295: END IF;
41296: CLOSE c7;

Line 41302: 'UPDATE msc_st_operation_resources msor'

41298: -- Update resource seq num from the local id table
41299:
41300: v_sql_stmt := 47;
41301: lv_sql_stmt :=
41302: 'UPDATE msc_st_operation_resources msor'
41303: ||' SET resource_seq_num = (SELECT local_id '
41304: ||' FROM msc_local_id_setup mlis'
41305: ||' WHERE mlis.char1 = msor.sr_instance_code'
41306: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '

Line 41368: FROM msc_st_operation_resources

41364: last_update_date,
41365: last_updated_by,
41366: creation_date,
41367: created_by
41368: FROM msc_st_operation_resources
41369: WHERE rowid = lb_rowid(j) ;
41370:
41371: END IF ;
41372: CLOSE c8 ;

Line 41376: MSC_ST_UTIL.SET_PROCESS_FLAG(p_table_name => 'MSC_ST_OPERATION_RESOURCES',

41372: CLOSE c8 ;
41373:
41374: -- Set the process flag as Valid and derive sr_instance_id
41375: lv_return :=
41376: MSC_ST_UTIL.SET_PROCESS_FLAG(p_table_name => 'MSC_ST_OPERATION_RESOURCES',
41377: p_instance_id => v_instance_id,
41378: p_instance_code => v_instance_code,
41379: p_process_flag => G_VALID,
41380: p_error_text => lv_error_text,

Line 41392: MSC_ST_UTIL.LOG_ERROR(p_table_name =>'MSC_ST_OPERATION_RESOURCES',

41388:
41389: -- At the end calling the LOG_ERROR for logging all errored out records
41390:
41391: lv_return :=
41392: MSC_ST_UTIL.LOG_ERROR(p_table_name =>'MSC_ST_OPERATION_RESOURCES',
41393: p_instance_code =>v_instance_code,
41394: p_row =>lv_column_names,
41395: p_severity =>G_SEV_ERROR,
41396: p_message_text =>NULL,

Line 50946: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_OPERATION_RESOURCES');

50942: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_CALENDAR_EXCEPTIONS');
50943: END IF;
50944:
50945: IF v_rtg_enabled = SYS_YES THEN
50946: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_OPERATION_RESOURCES');
50947: IF lv_count > 0 Then
50948: prec.bom_flag:= SYS_YES;
50949: End IF;
50950: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_ROUTING_OPERATIONS');