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_NETWORKS

Line 873: ||' on MSC_ST_OPERATION_NETWORKS '

869: application_short_name => 'MSC',
870: statement_type => AD_DDL.CREATE_INDEX,
871: statement =>
872: 'create index MSC_ST_OPER_NTWK_N1_'||v_instance_code
873: ||' on MSC_ST_OPERATION_NETWORKS '
874: ||'(assembly_name, organization_code,FROM_OPERATION_SEQ_CODE, TO_OPERATION_SEQ_CODE,sr_instance_code, company_name) '
875: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
876: object_name =>'MSC_ST_OPER_NTWK_N1_'||v_instance_code);
877:

Line 888: msc_analyse_tables_pk.analyse_table( 'MSC_ST_OPERATION_NETWORKS', v_instance_id, -1);

884:
885: msc_analyse_tables_pk.analyse_table( 'MSC_ST_ROUTINGS', v_instance_id, -1);
886: msc_analyse_tables_pk.analyse_table( 'MSC_ST_OPERATION_RESOURCES', v_instance_id, -1);
887: msc_analyse_tables_pk.analyse_table( 'MSC_ST_ROUTING_OPERATIONS', v_instance_id, -1);
888: msc_analyse_tables_pk.analyse_table( 'MSC_ST_OPERATION_NETWORKS', v_instance_id, -1);
889:
890:
891: END IF;
892:

Line 43547: FROM msc_st_operation_networks

43543: -- For OSFM Integration
43544:
43545: CURSOR c9(p_batch_id NUMBER) IS
43546: SELECT rowid
43547: FROM msc_st_operation_networks
43548: WHERE process_flag IN (G_IN_PROCESS,G_ERROR_FLG)
43549: AND sr_instance_code = v_instance_code
43550: AND batch_id = p_batch_id;
43551:

Line 46286: -- Pre processing for MSC_ST_OPERATION_NETWORKS

46282:
46283: END LOOP;
46284:
46285: -- From here added for OSFM Integration
46286: -- Pre processing for MSC_ST_OPERATION_NETWORKS
46287:
46288: --Duplicate records check for the records whose source is XML
46289:
46290: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE

Line 46303: 'UPDATE msc_st_operation_networks mson1 '

46299:
46300: v_sql_stmt := 51;
46301:
46302: lv_sql_stmt :=
46303: 'UPDATE msc_st_operation_networks mson1 '
46304: ||' SET process_flag = '||G_ERROR_FLG||','
46305: ||' error_text = '||''''||lv_message_text||''''
46306: ||' WHERE message_id < ( SELECT max(message_id) '
46307: ||' FROM msc_st_operation_networks mson2'

Line 46307: ||' FROM msc_st_operation_networks mson2'

46303: 'UPDATE msc_st_operation_networks mson1 '
46304: ||' SET process_flag = '||G_ERROR_FLG||','
46305: ||' error_text = '||''''||lv_message_text||''''
46306: ||' WHERE message_id < ( SELECT max(message_id) '
46307: ||' FROM msc_st_operation_networks mson2'
46308: ||' WHERE mson2.assembly_name = mson1.assembly_name'
46309: ||' AND mson2.organization_code = mson1.organization_code'
46310: ||' AND mson2.from_operation_seq_code = mson1.from_operation_seq_code'
46311: ||' AND mson2.to_operation_seq_code = mson1.to_operation_seq_code'

Line 46347: 'UPDATE msc_st_operation_networks mson1'

46343:
46344: v_sql_stmt := 52;
46345:
46346: lv_sql_stmt :=
46347: 'UPDATE msc_st_operation_networks mson1'
46348: ||' SET process_flag = '||G_ERROR_FLG||','
46349: ||' error_text = '||''''||lv_message_text||''''
46350: ||' WHERE EXISTS ( SELECT 1 '
46351: ||' FROM msc_st_operation_networks mson2'

Line 46351: ||' FROM msc_st_operation_networks mson2'

46347: 'UPDATE msc_st_operation_networks mson1'
46348: ||' SET process_flag = '||G_ERROR_FLG||','
46349: ||' error_text = '||''''||lv_message_text||''''
46350: ||' WHERE EXISTS ( SELECT 1 '
46351: ||' FROM msc_st_operation_networks mson2'
46352: ||' WHERE mson2.assembly_name = mson1.assembly_name'
46353: ||' AND mson2.organization_code = mson1.organization_code'
46354: ||' AND mson2.from_operation_seq_code = mson1.from_operation_seq_code'
46355: ||' AND mson2.to_operation_seq_code = mson1.to_operation_seq_code'

Line 46416: ' UPDATE msc_st_operation_networks '

46412:
46413: v_sql_stmt := 54;
46414:
46415: lv_sql_stmt :=
46416: ' UPDATE msc_st_operation_networks '
46417: ||' SET batch_id = :lv_batch_id'
46418: ||' WHERE process_flag IN ('||G_IN_PROCESS||','||G_ERROR_FLG||')'
46419: ||' AND sr_instance_code = :v_instance_code'
46420: ||' AND NVL(batch_id,'||NULL_VALUE||') = '||NULL_VALUE

Line 46437: UPDATE msc_st_operation_networks

46433:
46434: v_sql_stmt := 55;
46435:
46436: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
46437: UPDATE msc_st_operation_networks
46438: SET st_transaction_id = msc_st_operation_networks_s.NEXTVAL,
46439: refresh_id = v_refresh_id,
46440: last_update_date = v_current_date,
46441: last_updated_by = v_current_user,

Line 46438: SET st_transaction_id = msc_st_operation_networks_s.NEXTVAL,

46434: v_sql_stmt := 55;
46435:
46436: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
46437: UPDATE msc_st_operation_networks
46438: SET st_transaction_id = msc_st_operation_networks_s.NEXTVAL,
46439: refresh_id = v_refresh_id,
46440: last_update_date = v_current_date,
46441: last_updated_by = v_current_user,
46442: creation_date = v_current_date,

Line 46468: (p_table_name => 'MSC_ST_OPERATION_NETWORKS',

46464: lv_where_str :=
46465: ' AND NVL(deleted_flag,'||NULL_VALUE||') NOT IN(1,2)';
46466:
46467: lv_return := MSC_ST_UTIL.LOG_ERROR
46468: (p_table_name => 'MSC_ST_OPERATION_NETWORKS',
46469: p_instance_code => v_instance_code,
46470: p_row => lv_column_names,
46471: p_severity => G_SEV_WARNING,
46472: p_message_text => lv_message_text,

Line 46502: 'UPDATE msc_st_operation_networks'

46498: -- Error out the records whose PLANNING_PCT is NULL
46499:
46500: v_sql_stmt := 56;
46501: lv_sql_stmt :=
46502: 'UPDATE msc_st_operation_networks'
46503: ||' SET process_flag ='||G_ERROR_FLG||','
46504: ||' error_text = '||''''||lv_message_text||''''
46505: ||' WHERE NVL(PLANNING_PCT,'||NULL_VALUE||') = '||NULL_VALUE
46506: ||' AND sr_instance_code = :v_instance_code'

Line 46532: 'UPDATE msc_st_operation_networks'

46528: -- Error out the records whose Assembly Name is NULL
46529:
46530: v_sql_stmt := 57;
46531: lv_sql_stmt :=
46532: 'UPDATE msc_st_operation_networks'
46533: ||' SET process_flag ='||G_ERROR_FLG||','
46534: ||' error_text = '||''''||lv_message_text||''''
46535: ||' WHERE NVL(assembly_name,'||''''||NULL_CHAR||''''||') '
46536: ||' = '||''''||NULL_CHAR||''''

Line 46552: 'UPDATE msc_st_operation_networks '

46548:
46549: v_sql_stmt := 58;
46550:
46551: lv_sql_stmt :=
46552: 'UPDATE msc_st_operation_networks '
46553: ||' SET routing_name = assembly_name'
46554: ||' WHERE sr_instance_code = :v_instance_code'
46555: ||' AND process_flag = '||G_IN_PROCESS
46556: ||' AND NVL(routing_name,'||''''||NULL_CHAR||''''||') '

Line 46579: p_token_value3 => 'MSC_ST_OPERATION_NETWORKS' );

46575: ||'ORGANIZATION_CODE,ROUTING_NAME',
46576: p_token2 => 'MASTER_TABLE',
46577: p_token_value2 => 'MSC_ST_ROUTINGS',
46578: p_token3 => 'CHILD_TABLE' ,
46579: p_token_value3 => 'MSC_ST_OPERATION_NETWORKS' );
46580:
46581: IF lv_return <> 0 THEN
46582: RAISE ex_logging_err;
46583: END IF;

Line 46589: (p_table_name => 'MSC_ST_OPERATION_NETWORKS',

46585: -- Derive the ROUTING_SEQUENCE_ID from LOCAL ID table
46586: v_sql_stmt := 59;
46587: lv_return :=
46588: MSC_ST_UTIL.DERIVE_ROUTING_SEQUENCE_ID
46589: (p_table_name => 'MSC_ST_OPERATION_NETWORKS',
46590: p_rtg_col_name => 'ROUTING_NAME',
46591: p_rtg_col_id => 'ROUTING_SEQUENCE_ID',
46592: p_instance_code => v_instance_code,
46593: p_severity => G_SEV_ERROR,

Line 46628: (p_table_name => 'MSC_ST_OPERATION_NETWORKS',

46624: lv_where_str :=
46625: ' AND NVL(from_op_effectivity_date,SYSDATE-36500 ) = SYSDATE-36500 ' ;
46626:
46627: lv_return := MSC_ST_UTIL.LOG_ERROR
46628: (p_table_name => 'MSC_ST_OPERATION_NETWORKS',
46629: p_instance_code => v_instance_code,
46630: p_row => lv_column_names,
46631: p_severity => G_SEV_WARNING,
46632: p_message_text => lv_message_text,

Line 46666: (p_table_name => 'MSC_ST_OPERATION_NETWORKS',

46662: lv_where_str :=
46663: ' AND NVL(to_op_effectivity_date,SYSDATE-36500 ) = SYSDATE-36500 ' ;
46664:
46665: lv_return := MSC_ST_UTIL.LOG_ERROR
46666: (p_table_name => 'MSC_ST_OPERATION_NETWORKS',
46667: p_instance_code => v_instance_code,
46668: p_row => lv_column_names,
46669: p_severity => G_SEV_WARNING,
46670: p_message_text => lv_message_text,

Line 46703: (p_table_name => 'MSC_ST_OPERATION_NETWORKS',

46699: lv_where_str :=
46700: ' AND NVL(efectivity_date,SYSDATE-36500 ) = SYSDATE-36500 ' ;
46701:
46702: lv_return := MSC_ST_UTIL.LOG_ERROR
46703: (p_table_name => 'MSC_ST_OPERATION_NETWORKS',
46704: p_instance_code => v_instance_code,
46705: p_row => lv_column_names,
46706: p_severity => G_SEV_WARNING,
46707: p_message_text => lv_message_text,

Line 46740: 'UPDATE msc_st_operation_networks'

46736: -- Error out the records whose from_operation_seq_code or to_operation_seq_code is NULL
46737:
46738: v_sql_stmt := 63;
46739: lv_sql_stmt :=
46740: 'UPDATE msc_st_operation_networks'
46741: ||' SET process_flag ='||G_ERROR_FLG||','
46742: ||' error_text = '||''''||lv_message_text||''''
46743: ||' WHERE ( NVL(from_operation_seq_code,'||NULL_VALUE||') ='||NULL_VALUE
46744: ||' OR NVL(to_operation_seq_code,'||NULL_VALUE||') ='||NULL_VALUE ||')'

Line 46773: 'UPDATE msc_st_operation_networks'

46769: -- Error out the records whose from_operation_seq_code is same as to_op_seq_code
46770:
46771: v_sql_stmt := 64;
46772: lv_sql_stmt :=
46773: 'UPDATE msc_st_operation_networks'
46774: ||' SET process_flag ='||G_ERROR_FLG||','
46775: ||' error_text = '||''''||lv_message_text||''''
46776: ||' WHERE NVL(to_operation_seq_code,'||NULL_VALUE||') = NVL(from_operation_seq_code,'||NULL_VALUE||')'
46777: ||' AND sr_instance_code = :v_instance_code'

Line 46791: 'UPDATE msc_st_operation_networks mson'

46787: -- Derive from_operation_sequence id
46788:
46789: v_sql_stmt := 65;
46790: lv_sql_Stmt :=
46791: 'UPDATE msc_st_operation_networks mson'
46792: ||' SET from_op_seq_id= (SELECT local_id'
46793: ||' FROM msc_local_id_setup mlis'
46794: ||' WHERE mlis.char1 = mson.sr_instance_code'
46795: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '

Line 46830: p_token_value3 => 'MSC_ST_OPERATION_NETWORKS' );

46826: ||' ALTERNATE_ROUTING_DESIGNATOR' ,
46827: p_token2 => 'MASTER_TABLE',
46828: p_token_value2 => 'MSC_ST_ROUTING_OPERATIONS',
46829: p_token3 => 'CHILD_TABLE' ,
46830: p_token_value3 => 'MSC_ST_OPERATION_NETWORKS' );
46831:
46832: -- Error out the records whose from_op_seq_id is NULL
46833:
46834: v_sql_stmt := 66;

Line 46836: 'UPDATE msc_st_operation_networks'

46832: -- Error out the records whose from_op_seq_id is NULL
46833:
46834: v_sql_stmt := 66;
46835: lv_sql_stmt :=
46836: 'UPDATE msc_st_operation_networks'
46837: ||' SET process_flag ='||G_ERROR_FLG||','
46838: ||' error_text = '||''''||lv_message_text||''''
46839: ||' WHERE NVL(from_op_seq_id,'||NULL_VALUE||') ='||NULL_VALUE
46840: ||' AND sr_instance_code = :v_instance_code'

Line 46853: 'UPDATE msc_st_operation_networks mson'

46849: -- Derive to_operation_sequence id
46850:
46851: v_sql_stmt := 67;
46852: lv_sql_Stmt :=
46853: 'UPDATE msc_st_operation_networks mson'
46854: ||' SET to_op_seq_id= (SELECT local_id'
46855: ||' FROM msc_local_id_setup mlis'
46856: ||' WHERE mlis.char1 = mson.sr_instance_code'
46857: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '

Line 46892: p_token_value3 => 'MSC_ST_OPERATION_NETWORKS' );

46888: ||' ALTERNATE_ROUTING_DESIGNATOR' ,
46889: p_token2 => 'MASTER_TABLE',
46890: p_token_value2 => 'MSC_ST_ROUTING_OPERATIONS',
46891: p_token3 => 'CHILD_TABLE' ,
46892: p_token_value3 => 'MSC_ST_OPERATION_NETWORKS' );
46893:
46894: IF lv_return <> 0 THEN
46895: RAISE ex_logging_err;
46896: END IF;

Line 46902: 'UPDATE msc_st_operation_networks'

46898: -- Error out the records whose to_op_seq_id is NULL
46899:
46900: v_sql_stmt := 68;
46901: lv_sql_stmt :=
46902: 'UPDATE msc_st_operation_networks'
46903: ||' SET process_flag ='||G_ERROR_FLG||','
46904: ||' error_text = '||''''||lv_message_text||''''
46905: ||' WHERE NVL(to_op_seq_id,'||NULL_VALUE||') ='||NULL_VALUE
46906: ||' AND sr_instance_code = :v_instance_code'

Line 46919: 'UPDATE msc_st_operation_networks mson'

46915:
46916: -- populating from_op_seq_num and to_op_seq_num
46917: v_sql_stmt := 69;
46918: lv_sql_Stmt :=
46919: 'UPDATE msc_st_operation_networks mson'
46920: ||' SET from_op_seq_num= to_number(decode(length(rtrim(from_operation_seq_code,''0123456789'')),'
46921: ||' NULL,from_operation_seq_code,''1'')),'
46922: ||' to_op_seq_num= to_number(decode(length(rtrim(to_operation_seq_code,''0123456789'')),'
46923: ||' NULL,to_operation_seq_code,''1''))'

Line 46957: (p_table_name => 'MSC_ST_OPERATION_NETWORKS',

46953: lv_where_str :=
46954: ' AND NVL(transition_type,'||NULL_VALUE||') NOT IN (1,2)';
46955:
46956: lv_return := MSC_ST_UTIL.LOG_ERROR
46957: (p_table_name => 'MSC_ST_OPERATION_NETWORKS',
46958: p_instance_code => v_instance_code,
46959: p_row => lv_column_names,
46960: p_severity => G_SEV_WARNING,
46961: p_message_text => lv_message_text,

Line 46991: 'UPDATE msc_st_operation_networks'

46987: -- Disable date should be greater than effectivity date if a value is there for disable date
46988:
46989: v_sql_stmt := 71;
46990: lv_sql_stmt :=
46991: 'UPDATE msc_st_operation_networks'
46992: ||' SET process_flag ='||G_ERROR_FLG||','
46993: ||' error_text = '||''''||lv_message_text||''''
46994: ||' WHERE NVL(DISABLE_DATE,SYSDATE-36500) <> SYSDATE-36500'
46995: ||' AND DISABLE_DATE <= EFECTIVITY_DATE '

Line 47014: pEntityName => 'MSC_ST_OPERATION_NETWORKS',

47010: (ERRBUF => lv_error_text,
47011: RETCODE => lv_return,
47012: pBatchID => lv_batch_id,
47013: pInstanceCode => v_instance_code,
47014: pEntityName => 'MSC_ST_OPERATION_NETWORKS',
47015: pInstanceID => v_instance_id);
47016:
47017: IF NVL(lv_return,0) <> 0 THEN
47018: RAISE ex_logging_err;

Line 47042: 'UPDATE msc_st_operation_networks mson1'

47038: END IF;
47039:
47040: v_sql_stmt := 72;
47041: lv_sql_stmt :=
47042: 'UPDATE msc_st_operation_networks mson1'
47043: ||' SET process_flag = '||G_ERROR_FLG||','
47044: ||' error_text = '||''''||lv_message_text||''''
47045: ||' WHERE 1 < ( SELECT COUNT(*) '
47046: ||' FROM msc_st_operation_networks mson2'

Line 47046: ||' FROM msc_st_operation_networks mson2'

47042: 'UPDATE msc_st_operation_networks mson1'
47043: ||' SET process_flag = '||G_ERROR_FLG||','
47044: ||' error_text = '||''''||lv_message_text||''''
47045: ||' WHERE 1 < ( SELECT COUNT(*) '
47046: ||' FROM msc_st_operation_networks mson2'
47047: ||' WHERE mson2.assembly_name = mson1.assembly_name'
47048: ||' AND mson2.organization_code = mson1.organization_code'
47049: ||' AND mson2.from_operation_seq_code = mson1.from_operation_seq_code'
47050: ||' AND mson2.sr_instance_code = mson1.sr_instance_code'

Line 47090: 'UPDATE msc_st_operation_networks mson1'

47086: END IF;
47087:
47088: v_sql_stmt := 73;
47089: lv_sql_stmt :=
47090: 'UPDATE msc_st_operation_networks mson1'
47091: ||' SET process_flag = '||G_ERROR_FLG||','
47092: ||' error_text = '||''''||lv_message_text||''''
47093: ||' WHERE 100 <> ( SELECT SUM(planning_pct) '
47094: ||' FROM msc_st_operation_networks mson2'

Line 47094: ||' FROM msc_st_operation_networks mson2'

47090: 'UPDATE msc_st_operation_networks mson1'
47091: ||' SET process_flag = '||G_ERROR_FLG||','
47092: ||' error_text = '||''''||lv_message_text||''''
47093: ||' WHERE 100 <> ( SELECT SUM(planning_pct) '
47094: ||' FROM msc_st_operation_networks mson2'
47095: ||' WHERE mson2.assembly_name = mson1.assembly_name'
47096: ||' AND mson2.organization_code = mson1.organization_code'
47097: ||' AND mson2.from_operation_seq_code = mson1.from_operation_seq_code'
47098: ||' AND mson2.sr_instance_code = mson1.sr_instance_code'

Line 47120: MSC_ST_UTIL.SET_PROCESS_FLAG(p_table_name => 'MSC_ST_OPERATION_NETWORKS',

47116: EXECUTE IMMEDIATE lv_sql_stmt USING v_instance_code;
47117:
47118: -- Set the process flag as Valid and derive sr_instance_id
47119: lv_return :=
47120: MSC_ST_UTIL.SET_PROCESS_FLAG(p_table_name => 'MSC_ST_OPERATION_NETWORKS',
47121: p_instance_id => v_instance_id,
47122: p_instance_code => v_instance_code,
47123: p_process_flag => G_VALID,
47124: p_error_text => lv_error_text,

Line 47135: MSC_ST_UTIL.LOG_ERROR(p_table_name => 'MSC_ST_OPERATION_NETWORKS',

47131:
47132: -- At the end calling the LOG_ERROR for logging all errored out records
47133:
47134: lv_return :=
47135: MSC_ST_UTIL.LOG_ERROR(p_table_name => 'MSC_ST_OPERATION_NETWORKS',
47136: p_instance_code => v_instance_code,
47137: p_row => lv_column_names,
47138: p_severity => G_SEV_ERROR,
47139: p_message_text => NULL,

Line 55872: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_OPERATION_NETWORKS');

55868: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_ROUTINGS');
55869: IF lv_count > 0 Then
55870: prec.bom_flag:= SYS_YES;
55871: End IF;
55872: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_OPERATION_NETWORKS');
55873: IF lv_count > 0 Then
55874: prec.bom_flag:= SYS_YES;
55875: End IF;
55876: END IF;