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 865: ||' on MSC_ST_OPERATION_NETWORKS '

861: application_short_name => 'MSC',
862: statement_type => AD_DDL.CREATE_INDEX,
863: statement =>
864: 'create index MSC_ST_OPER_NTWK_N1_'||v_instance_code
865: ||' on MSC_ST_OPERATION_NETWORKS '
866: ||'(assembly_name, organization_code,FROM_OPERATION_SEQ_CODE, TO_OPERATION_SEQ_CODE,sr_instance_code, company_name) '
867: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
868: object_name =>'MSC_ST_OPER_NTWK_N1_'||v_instance_code);
869:

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

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:
883: END IF;
884:

Line 38763: FROM msc_st_operation_networks

38759: -- For OSFM Integration
38760:
38761: CURSOR c9(p_batch_id NUMBER) IS
38762: SELECT rowid
38763: FROM msc_st_operation_networks
38764: WHERE process_flag IN (G_IN_PROCESS,G_ERROR_FLG)
38765: AND sr_instance_code = v_instance_code
38766: AND batch_id = p_batch_id;
38767:

Line 41410: -- Pre processing for MSC_ST_OPERATION_NETWORKS

41406:
41407: END LOOP;
41408:
41409: -- From here added for OSFM Integration
41410: -- Pre processing for MSC_ST_OPERATION_NETWORKS
41411:
41412: --Duplicate records check for the records whose source is XML
41413:
41414: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE

Line 41427: 'UPDATE msc_st_operation_networks mson1 '

41423:
41424: v_sql_stmt := 51;
41425:
41426: lv_sql_stmt :=
41427: 'UPDATE msc_st_operation_networks mson1 '
41428: ||' SET process_flag = '||G_ERROR_FLG||','
41429: ||' error_text = '||''''||lv_message_text||''''
41430: ||' WHERE message_id < ( SELECT max(message_id) '
41431: ||' FROM msc_st_operation_networks mson2'

Line 41431: ||' FROM msc_st_operation_networks mson2'

41427: 'UPDATE msc_st_operation_networks mson1 '
41428: ||' SET process_flag = '||G_ERROR_FLG||','
41429: ||' error_text = '||''''||lv_message_text||''''
41430: ||' WHERE message_id < ( SELECT max(message_id) '
41431: ||' FROM msc_st_operation_networks mson2'
41432: ||' WHERE mson2.assembly_name = mson1.assembly_name'
41433: ||' AND mson2.organization_code = mson1.organization_code'
41434: ||' AND mson2.from_operation_seq_code = mson1.from_operation_seq_code'
41435: ||' AND mson2.to_operation_seq_code = mson1.to_operation_seq_code'

Line 41471: 'UPDATE msc_st_operation_networks mson1'

41467:
41468: v_sql_stmt := 52;
41469:
41470: lv_sql_stmt :=
41471: 'UPDATE msc_st_operation_networks mson1'
41472: ||' SET process_flag = '||G_ERROR_FLG||','
41473: ||' error_text = '||''''||lv_message_text||''''
41474: ||' WHERE EXISTS ( SELECT 1 '
41475: ||' FROM msc_st_operation_networks mson2'

Line 41475: ||' FROM msc_st_operation_networks mson2'

41471: 'UPDATE msc_st_operation_networks mson1'
41472: ||' SET process_flag = '||G_ERROR_FLG||','
41473: ||' error_text = '||''''||lv_message_text||''''
41474: ||' WHERE EXISTS ( SELECT 1 '
41475: ||' FROM msc_st_operation_networks mson2'
41476: ||' WHERE mson2.assembly_name = mson1.assembly_name'
41477: ||' AND mson2.organization_code = mson1.organization_code'
41478: ||' AND mson2.from_operation_seq_code = mson1.from_operation_seq_code'
41479: ||' AND mson2.to_operation_seq_code = mson1.to_operation_seq_code'

Line 41540: ' UPDATE msc_st_operation_networks '

41536:
41537: v_sql_stmt := 54;
41538:
41539: lv_sql_stmt :=
41540: ' UPDATE msc_st_operation_networks '
41541: ||' SET batch_id = :lv_batch_id'
41542: ||' WHERE process_flag IN ('||G_IN_PROCESS||','||G_ERROR_FLG||')'
41543: ||' AND sr_instance_code = :v_instance_code'
41544: ||' AND NVL(batch_id,'||NULL_VALUE||') = '||NULL_VALUE

Line 41561: UPDATE msc_st_operation_networks

41557:
41558: v_sql_stmt := 55;
41559:
41560: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
41561: UPDATE msc_st_operation_networks
41562: SET st_transaction_id = msc_st_operation_networks_s.NEXTVAL,
41563: refresh_id = v_refresh_id,
41564: last_update_date = v_current_date,
41565: last_updated_by = v_current_user,

Line 41562: SET st_transaction_id = msc_st_operation_networks_s.NEXTVAL,

41558: v_sql_stmt := 55;
41559:
41560: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
41561: UPDATE msc_st_operation_networks
41562: SET st_transaction_id = msc_st_operation_networks_s.NEXTVAL,
41563: refresh_id = v_refresh_id,
41564: last_update_date = v_current_date,
41565: last_updated_by = v_current_user,
41566: creation_date = v_current_date,

Line 41592: (p_table_name => 'MSC_ST_OPERATION_NETWORKS',

41588: lv_where_str :=
41589: ' AND NVL(deleted_flag,'||NULL_VALUE||') NOT IN(1,2)';
41590:
41591: lv_return := MSC_ST_UTIL.LOG_ERROR
41592: (p_table_name => 'MSC_ST_OPERATION_NETWORKS',
41593: p_instance_code => v_instance_code,
41594: p_row => lv_column_names,
41595: p_severity => G_SEV_WARNING,
41596: p_message_text => lv_message_text,

Line 41626: 'UPDATE msc_st_operation_networks'

41622: -- Error out the records whose PLANNING_PCT is NULL
41623:
41624: v_sql_stmt := 56;
41625: lv_sql_stmt :=
41626: 'UPDATE msc_st_operation_networks'
41627: ||' SET process_flag ='||G_ERROR_FLG||','
41628: ||' error_text = '||''''||lv_message_text||''''
41629: ||' WHERE NVL(PLANNING_PCT,'||NULL_VALUE||') = '||NULL_VALUE
41630: ||' AND sr_instance_code = :v_instance_code'

Line 41656: 'UPDATE msc_st_operation_networks'

41652: -- Error out the records whose Assembly Name is NULL
41653:
41654: v_sql_stmt := 57;
41655: lv_sql_stmt :=
41656: 'UPDATE msc_st_operation_networks'
41657: ||' SET process_flag ='||G_ERROR_FLG||','
41658: ||' error_text = '||''''||lv_message_text||''''
41659: ||' WHERE NVL(assembly_name,'||''''||NULL_CHAR||''''||') '
41660: ||' = '||''''||NULL_CHAR||''''

Line 41676: 'UPDATE msc_st_operation_networks '

41672:
41673: v_sql_stmt := 58;
41674:
41675: lv_sql_stmt :=
41676: 'UPDATE msc_st_operation_networks '
41677: ||' SET routing_name = assembly_name'
41678: ||' WHERE sr_instance_code = :v_instance_code'
41679: ||' AND process_flag = '||G_IN_PROCESS
41680: ||' AND NVL(routing_name,'||''''||NULL_CHAR||''''||') '

Line 41703: p_token_value3 => 'MSC_ST_OPERATION_NETWORKS' );

41699: ||'ORGANIZATION_CODE,ROUTING_NAME',
41700: p_token2 => 'MASTER_TABLE',
41701: p_token_value2 => 'MSC_ST_ROUTINGS',
41702: p_token3 => 'CHILD_TABLE' ,
41703: p_token_value3 => 'MSC_ST_OPERATION_NETWORKS' );
41704:
41705: IF lv_return <> 0 THEN
41706: RAISE ex_logging_err;
41707: END IF;

Line 41713: (p_table_name => 'MSC_ST_OPERATION_NETWORKS',

41709: -- Derive the ROUTING_SEQUENCE_ID from LOCAL ID table
41710: v_sql_stmt := 59;
41711: lv_return :=
41712: MSC_ST_UTIL.DERIVE_ROUTING_SEQUENCE_ID
41713: (p_table_name => 'MSC_ST_OPERATION_NETWORKS',
41714: p_rtg_col_name => 'ROUTING_NAME',
41715: p_rtg_col_id => 'ROUTING_SEQUENCE_ID',
41716: p_instance_code => v_instance_code,
41717: p_severity => G_SEV_ERROR,

Line 41751: (p_table_name => 'MSC_ST_OPERATION_NETWORKS',

41747: lv_where_str :=
41748: ' AND NVL(from_op_effectivity_date,SYSDATE-36500 ) = SYSDATE-36500 ' ;
41749:
41750: lv_return := MSC_ST_UTIL.LOG_ERROR
41751: (p_table_name => 'MSC_ST_OPERATION_NETWORKS',
41752: p_instance_code => v_instance_code,
41753: p_row => lv_column_names,
41754: p_severity => G_SEV_WARNING,
41755: p_message_text => lv_message_text,

Line 41789: (p_table_name => 'MSC_ST_OPERATION_NETWORKS',

41785: lv_where_str :=
41786: ' AND NVL(to_op_effectivity_date,SYSDATE-36500 ) = SYSDATE-36500 ' ;
41787:
41788: lv_return := MSC_ST_UTIL.LOG_ERROR
41789: (p_table_name => 'MSC_ST_OPERATION_NETWORKS',
41790: p_instance_code => v_instance_code,
41791: p_row => lv_column_names,
41792: p_severity => G_SEV_WARNING,
41793: p_message_text => lv_message_text,

Line 41826: (p_table_name => 'MSC_ST_OPERATION_NETWORKS',

41822: lv_where_str :=
41823: ' AND NVL(efectivity_date,SYSDATE-36500 ) = SYSDATE-36500 ' ;
41824:
41825: lv_return := MSC_ST_UTIL.LOG_ERROR
41826: (p_table_name => 'MSC_ST_OPERATION_NETWORKS',
41827: p_instance_code => v_instance_code,
41828: p_row => lv_column_names,
41829: p_severity => G_SEV_WARNING,
41830: p_message_text => lv_message_text,

Line 41863: 'UPDATE msc_st_operation_networks'

41859: -- Error out the records whose from_operation_seq_code or to_operation_seq_code is NULL
41860:
41861: v_sql_stmt := 63;
41862: lv_sql_stmt :=
41863: 'UPDATE msc_st_operation_networks'
41864: ||' SET process_flag ='||G_ERROR_FLG||','
41865: ||' error_text = '||''''||lv_message_text||''''
41866: ||' WHERE ( NVL(from_operation_seq_code,'||NULL_VALUE||') ='||NULL_VALUE
41867: ||' OR NVL(to_operation_seq_code,'||NULL_VALUE||') ='||NULL_VALUE ||')'

Line 41896: 'UPDATE msc_st_operation_networks'

41892: -- Error out the records whose from_operation_seq_code is same as to_op_seq_code
41893:
41894: v_sql_stmt := 64;
41895: lv_sql_stmt :=
41896: 'UPDATE msc_st_operation_networks'
41897: ||' SET process_flag ='||G_ERROR_FLG||','
41898: ||' error_text = '||''''||lv_message_text||''''
41899: ||' WHERE NVL(to_operation_seq_code,'||NULL_VALUE||') = NVL(from_operation_seq_code,'||NULL_VALUE||')'
41900: ||' AND sr_instance_code = :v_instance_code'

Line 41914: 'UPDATE msc_st_operation_networks mson'

41910: -- Derive from_operation_sequence id
41911:
41912: v_sql_stmt := 65;
41913: lv_sql_Stmt :=
41914: 'UPDATE msc_st_operation_networks mson'
41915: ||' SET from_op_seq_id= (SELECT local_id'
41916: ||' FROM msc_local_id_setup mlis'
41917: ||' WHERE mlis.char1 = mson.sr_instance_code'
41918: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '

Line 41953: p_token_value3 => 'MSC_ST_OPERATION_NETWORKS' );

41949: ||' ALTERNATE_ROUTING_DESIGNATOR' ,
41950: p_token2 => 'MASTER_TABLE',
41951: p_token_value2 => 'MSC_ST_ROUTING_OPERATIONS',
41952: p_token3 => 'CHILD_TABLE' ,
41953: p_token_value3 => 'MSC_ST_OPERATION_NETWORKS' );
41954:
41955: -- Error out the records whose from_op_seq_id is NULL
41956:
41957: v_sql_stmt := 66;

Line 41959: 'UPDATE msc_st_operation_networks'

41955: -- Error out the records whose from_op_seq_id is NULL
41956:
41957: v_sql_stmt := 66;
41958: lv_sql_stmt :=
41959: 'UPDATE msc_st_operation_networks'
41960: ||' SET process_flag ='||G_ERROR_FLG||','
41961: ||' error_text = '||''''||lv_message_text||''''
41962: ||' WHERE NVL(from_op_seq_id,'||NULL_VALUE||') ='||NULL_VALUE
41963: ||' AND sr_instance_code = :v_instance_code'

Line 41976: 'UPDATE msc_st_operation_networks mson'

41972: -- Derive to_operation_sequence id
41973:
41974: v_sql_stmt := 67;
41975: lv_sql_Stmt :=
41976: 'UPDATE msc_st_operation_networks mson'
41977: ||' SET to_op_seq_id= (SELECT local_id'
41978: ||' FROM msc_local_id_setup mlis'
41979: ||' WHERE mlis.char1 = mson.sr_instance_code'
41980: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '

Line 42015: p_token_value3 => 'MSC_ST_OPERATION_NETWORKS' );

42011: ||' ALTERNATE_ROUTING_DESIGNATOR' ,
42012: p_token2 => 'MASTER_TABLE',
42013: p_token_value2 => 'MSC_ST_ROUTING_OPERATIONS',
42014: p_token3 => 'CHILD_TABLE' ,
42015: p_token_value3 => 'MSC_ST_OPERATION_NETWORKS' );
42016:
42017: IF lv_return <> 0 THEN
42018: RAISE ex_logging_err;
42019: END IF;

Line 42025: 'UPDATE msc_st_operation_networks'

42021: -- Error out the records whose to_op_seq_id is NULL
42022:
42023: v_sql_stmt := 68;
42024: lv_sql_stmt :=
42025: 'UPDATE msc_st_operation_networks'
42026: ||' SET process_flag ='||G_ERROR_FLG||','
42027: ||' error_text = '||''''||lv_message_text||''''
42028: ||' WHERE NVL(to_op_seq_id,'||NULL_VALUE||') ='||NULL_VALUE
42029: ||' AND sr_instance_code = :v_instance_code'

Line 42042: 'UPDATE msc_st_operation_networks mson'

42038:
42039: -- populating from_op_seq_num and to_op_seq_num
42040: v_sql_stmt := 69;
42041: lv_sql_Stmt :=
42042: 'UPDATE msc_st_operation_networks mson'
42043: ||' SET from_op_seq_num= to_number(decode(length(rtrim(from_operation_seq_code,''0123456789'')),'
42044: ||' NULL,from_operation_seq_code,''1'')),'
42045: ||' to_op_seq_num= to_number(decode(length(rtrim(to_operation_seq_code,''0123456789'')),'
42046: ||' NULL,to_operation_seq_code,''1''))'

Line 42080: (p_table_name => 'MSC_ST_OPERATION_NETWORKS',

42076: lv_where_str :=
42077: ' AND NVL(transition_type,'||NULL_VALUE||') NOT IN (1,2)';
42078:
42079: lv_return := MSC_ST_UTIL.LOG_ERROR
42080: (p_table_name => 'MSC_ST_OPERATION_NETWORKS',
42081: p_instance_code => v_instance_code,
42082: p_row => lv_column_names,
42083: p_severity => G_SEV_WARNING,
42084: p_message_text => lv_message_text,

Line 42114: 'UPDATE msc_st_operation_networks'

42110: -- Disable date should be greater than effectivity date if a value is there for disable date
42111:
42112: v_sql_stmt := 71;
42113: lv_sql_stmt :=
42114: 'UPDATE msc_st_operation_networks'
42115: ||' SET process_flag ='||G_ERROR_FLG||','
42116: ||' error_text = '||''''||lv_message_text||''''
42117: ||' WHERE NVL(DISABLE_DATE,SYSDATE-36500) <> SYSDATE-36500'
42118: ||' AND DISABLE_DATE <= EFECTIVITY_DATE '

Line 42137: pEntityName => 'MSC_ST_OPERATION_NETWORKS',

42133: (ERRBUF => lv_error_text,
42134: RETCODE => lv_return,
42135: pBatchID => lv_batch_id,
42136: pInstanceCode => v_instance_code,
42137: pEntityName => 'MSC_ST_OPERATION_NETWORKS',
42138: pInstanceID => v_instance_id);
42139:
42140: IF NVL(lv_return,0) <> 0 THEN
42141: RAISE ex_logging_err;

Line 42165: 'UPDATE msc_st_operation_networks mson1'

42161: END IF;
42162:
42163: v_sql_stmt := 72;
42164: lv_sql_stmt :=
42165: 'UPDATE msc_st_operation_networks mson1'
42166: ||' SET process_flag = '||G_ERROR_FLG||','
42167: ||' error_text = '||''''||lv_message_text||''''
42168: ||' WHERE 1 < ( SELECT COUNT(*) '
42169: ||' FROM msc_st_operation_networks mson2'

Line 42169: ||' FROM msc_st_operation_networks mson2'

42165: 'UPDATE msc_st_operation_networks mson1'
42166: ||' SET process_flag = '||G_ERROR_FLG||','
42167: ||' error_text = '||''''||lv_message_text||''''
42168: ||' WHERE 1 < ( SELECT COUNT(*) '
42169: ||' FROM msc_st_operation_networks mson2'
42170: ||' WHERE mson2.assembly_name = mson1.assembly_name'
42171: ||' AND mson2.organization_code = mson1.organization_code'
42172: ||' AND mson2.from_operation_seq_code = mson1.from_operation_seq_code'
42173: ||' AND mson2.sr_instance_code = mson1.sr_instance_code'

Line 42213: 'UPDATE msc_st_operation_networks mson1'

42209: END IF;
42210:
42211: v_sql_stmt := 73;
42212: lv_sql_stmt :=
42213: 'UPDATE msc_st_operation_networks mson1'
42214: ||' SET process_flag = '||G_ERROR_FLG||','
42215: ||' error_text = '||''''||lv_message_text||''''
42216: ||' WHERE 100 <> ( SELECT SUM(planning_pct) '
42217: ||' FROM msc_st_operation_networks mson2'

Line 42217: ||' FROM msc_st_operation_networks mson2'

42213: 'UPDATE msc_st_operation_networks mson1'
42214: ||' SET process_flag = '||G_ERROR_FLG||','
42215: ||' error_text = '||''''||lv_message_text||''''
42216: ||' WHERE 100 <> ( SELECT SUM(planning_pct) '
42217: ||' FROM msc_st_operation_networks mson2'
42218: ||' WHERE mson2.assembly_name = mson1.assembly_name'
42219: ||' AND mson2.organization_code = mson1.organization_code'
42220: ||' AND mson2.from_operation_seq_code = mson1.from_operation_seq_code'
42221: ||' AND mson2.sr_instance_code = mson1.sr_instance_code'

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

42239: EXECUTE IMMEDIATE lv_sql_stmt USING v_instance_code;
42240:
42241: -- Set the process flag as Valid and derive sr_instance_id
42242: lv_return :=
42243: MSC_ST_UTIL.SET_PROCESS_FLAG(p_table_name => 'MSC_ST_OPERATION_NETWORKS',
42244: p_instance_id => v_instance_id,
42245: p_instance_code => v_instance_code,
42246: p_process_flag => G_VALID,
42247: p_error_text => lv_error_text,

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

42254:
42255: -- At the end calling the LOG_ERROR for logging all errored out records
42256:
42257: lv_return :=
42258: MSC_ST_UTIL.LOG_ERROR(p_table_name => 'MSC_ST_OPERATION_NETWORKS',
42259: p_instance_code => v_instance_code,
42260: p_row => lv_column_names,
42261: p_severity => G_SEV_ERROR,
42262: p_message_text => NULL,

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

50954: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_ROUTINGS');
50955: IF lv_count > 0 Then
50956: prec.bom_flag:= SYS_YES;
50957: End IF;
50958: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_OPERATION_NETWORKS');
50959: IF lv_count > 0 Then
50960: prec.bom_flag:= SYS_YES;
50961: End IF;
50962: END IF;