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_ROUTING_OPERATIONS

Line 835: ||' on MSC_ST_ROUTING_OPERATIONS '

831: application_short_name => 'MSC',
832: statement_type => AD_DDL.CREATE_INDEX,
833: statement =>
834: 'create index MSC_ST_ROUTING_OPER_N1_'||v_instance_code
835: ||' on MSC_ST_ROUTING_OPERATIONS '
836: ||'( sr_instance_code, assembly_name, operation_seq_code, organization_code, company_name, routing_name, alternate_routing_designator) '
837: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
838: object_name =>'MSC_ST_ROUTING_OPER_N1_'||v_instance_code);
839:

Line 887: msc_analyse_tables_pk.analyse_table( 'MSC_ST_ROUTING_OPERATIONS', v_instance_id, -1);

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

Line 43497: FROM msc_st_routing_operations

43493: AND deleted_flag = SYS_NO;
43494:
43495: CURSOR c4(p_batch_id NUMBER) IS
43496: SELECT rowid
43497: FROM msc_st_routing_operations
43498: WHERE process_flag IN (G_IN_PROCESS,G_ERROR_FLG)
43499: AND sr_instance_code = v_instance_code
43500: AND batch_id = p_batch_id;
43501:

Line 43504: FROM msc_st_routing_operations

43500: AND batch_id = p_batch_id;
43501:
43502: CURSOR c5(p_batch_id NUMBER) IS
43503: SELECT rowid
43504: FROM msc_st_routing_operations
43505: WHERE process_flag = G_IN_PROCESS
43506: AND sr_instance_code = v_instance_code
43507: AND batch_id = p_batch_id
43508: AND NVL(operation_sequence_id,NULL_VALUE) = NULL_VALUE

Line 43557: FROM msc_st_routing_operations

43553: -- For bug 3549086
43554:
43555: CURSOR c10(p_batch_id NUMBER) IS
43556: SELECT max(rowid)
43557: FROM msc_st_routing_operations
43558: WHERE process_flag IN (G_IN_PROCESS)
43559: AND sr_instance_code = v_instance_code
43560: AND batch_id = p_batch_id
43561: AND NVL(department_id,NULL_VALUE) = NULL_VALUE

Line 44423: -- Validation for MSC_ST_ROUTING_OPERATIONS

44419: END LOOP;
44420:
44421:
44422:
44423: -- Validation for MSC_ST_ROUTING_OPERATIONS
44424:
44425:
44426: --Duplicate records check for the records whose source is XML
44427:

Line 44441: 'UPDATE msc_st_routing_operations msro1 '

44437:
44438: v_sql_stmt := 18;
44439:
44440: lv_sql_stmt :=
44441: 'UPDATE msc_st_routing_operations msro1 '
44442: ||' SET process_flag = '||G_ERROR_FLG||','
44443: ||' error_text = '||''''||lv_message_text||''''
44444: ||' WHERE message_id < ( SELECT max(message_id) '
44445: ||' FROM msc_st_routing_operations msro2'

Line 44445: ||' FROM msc_st_routing_operations msro2'

44441: 'UPDATE msc_st_routing_operations msro1 '
44442: ||' SET process_flag = '||G_ERROR_FLG||','
44443: ||' error_text = '||''''||lv_message_text||''''
44444: ||' WHERE message_id < ( SELECT max(message_id) '
44445: ||' FROM msc_st_routing_operations msro2'
44446: ||' WHERE msro2.sr_instance_code = msro1.sr_instance_code'
44447: ||' AND msro2.organization_code = msro1.organization_code'
44448: ||' AND msro2.effectivity_date = msro1.effectivity_date'
44449: ||' AND NVL(msro2.routing_name,'||''''||NULL_CHAR||''''||') '

Line 44482: 'UPDATE msc_st_routing_operations msro1'

44478: END IF;
44479:
44480: v_sql_stmt := 19;
44481: lv_sql_stmt :=
44482: 'UPDATE msc_st_routing_operations msro1'
44483: ||' SET process_flag = '||G_ERROR_FLG||','
44484: ||' error_text = '||''''||lv_message_text||''''
44485: ||' WHERE EXISTS ( SELECT 1 '
44486: ||' FROM msc_st_routing_operations msro2'

Line 44486: ||' FROM msc_st_routing_operations msro2'

44482: 'UPDATE msc_st_routing_operations msro1'
44483: ||' SET process_flag = '||G_ERROR_FLG||','
44484: ||' error_text = '||''''||lv_message_text||''''
44485: ||' WHERE EXISTS ( SELECT 1 '
44486: ||' FROM msc_st_routing_operations msro2'
44487: ||' WHERE msro2.sr_instance_code = msro1.sr_instance_code'
44488: ||' AND msro2.organization_code = msro1.organization_code'
44489: ||' AND msro2.effectivity_date = msro1.effectivity_date'
44490: ||' AND NVL(msro2.routing_name,'||''''||NULL_CHAR||''''||') '

Line 44560: ' UPDATE msc_st_routing_operations '

44556: FROM dual;
44557:
44558: v_sql_stmt := 21;
44559: lv_sql_stmt :=
44560: ' UPDATE msc_st_routing_operations '
44561: ||' SET batch_id = :lv_batch_id'
44562: ||' WHERE process_flag IN ('||G_IN_PROCESS||','||G_ERROR_FLG||')'
44563: ||' AND sr_instance_code = :v_instance_code'
44564: ||' AND NVL(batch_id,'||NULL_VALUE||') = '||NULL_VALUE

Line 44581: UPDATE msc_st_routing_operations

44577: CLOSE c4;
44578:
44579: v_sql_stmt := 22;
44580: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
44581: UPDATE msc_st_routing_operations
44582: SET st_transaction_id = msc_st_routing_operations_s.NEXTVAL,
44583: refresh_id = v_refresh_id,
44584: last_update_date = v_current_date,
44585: last_updated_by = v_current_user,

Line 44582: SET st_transaction_id = msc_st_routing_operations_s.NEXTVAL,

44578:
44579: v_sql_stmt := 22;
44580: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
44581: UPDATE msc_st_routing_operations
44582: SET st_transaction_id = msc_st_routing_operations_s.NEXTVAL,
44583: refresh_id = v_refresh_id,
44584: last_update_date = v_current_date,
44585: last_updated_by = v_current_user,
44586: creation_date = v_current_date,

Line 44612: (p_table_name => 'MSC_ST_ROUTING_OPERATIONS',

44608: lv_where_str :=
44609: ' AND NVL(deleted_flag,'||NULL_VALUE||') <>'||SYS_NO;
44610:
44611: lv_return := MSC_ST_UTIL.LOG_ERROR
44612: (p_table_name => 'MSC_ST_ROUTING_OPERATIONS',
44613: p_instance_code => v_instance_code,
44614: p_row => lv_column_names,
44615: p_severity => G_SEV_WARNING,
44616: p_message_text => lv_message_text,

Line 44644: MSC_ST_UTIL.DERIVE_PARTNER_ORG_ID(p_table_name => 'MSC_ST_ROUTING_OPERATIONS',

44640: END IF;
44641:
44642: -- derive organization id ,
44643: lv_return :=
44644: MSC_ST_UTIL.DERIVE_PARTNER_ORG_ID(p_table_name => 'MSC_ST_ROUTING_OPERATIONS',
44645: p_org_partner_name =>'ORGANIZATION_CODE',
44646: p_org_partner_id =>'ORGANIZATION_ID',
44647: p_instance_code => v_instance_code,
44648: p_partner_type => G_ORGANIZATION,

Line 44664: 'UPDATE msc_st_routing_operations '

44660: -- ASSEMBLY NAME in ROUTING_NAME column for all such records
44661: v_sql_stmt := 23;
44662:
44663: lv_sql_stmt :=
44664: 'UPDATE msc_st_routing_operations '
44665: ||' SET routing_name = assembly_name'
44666: ||' WHERE sr_instance_code = :v_instance_code'
44667: ||' AND process_flag = '||G_IN_PROCESS
44668: ||' AND NVL(routing_name,'||''''||NULL_CHAR||''''||') '

Line 44689: p_token_value3 => 'MSC_ST_ROUTING_OPERATIONS' );

44685: ||'ORGANIZATION_CODE,ROUTING_NAME',
44686: p_token2 => 'MASTER_TABLE',
44687: p_token_value2 => 'MSC_ST_ROUTINGS',
44688: p_token3 => 'CHILD_TABLE' ,
44689: p_token_value3 => 'MSC_ST_ROUTING_OPERATIONS' );
44690:
44691: IF lv_return <> 0 THEN
44692: RAISE ex_logging_err;
44693: END IF;

Line 44699: (p_table_name => 'MSC_ST_ROUTING_OPERATIONS',

44695: -- Derive the ROUTING_SEQUENCE_ID from LOCAL ID table
44696:
44697: lv_return :=
44698: MSC_ST_UTIL.DERIVE_ROUTING_SEQUENCE_ID
44699: (p_table_name => 'MSC_ST_ROUTING_OPERATIONS',
44700: p_rtg_col_name => 'ROUTING_NAME',
44701: p_rtg_col_id => 'ROUTING_SEQUENCE_ID',
44702: p_instance_code => v_instance_code,
44703: p_severity => G_SEV_ERROR,

Line 44734: (p_table_name => 'MSC_ST_ROUTING_OPERATIONS',

44730: lv_where_str :=
44731: ' AND NVL(effectivity_date,SYSDATE-36500 ) = SYSDATE-36500 ' ;
44732:
44733: lv_return := MSC_ST_UTIL.LOG_ERROR
44734: (p_table_name => 'MSC_ST_ROUTING_OPERATIONS',
44735: p_instance_code => v_instance_code,
44736: p_row => lv_column_names,
44737: p_severity => G_SEV_WARNING,
44738: p_message_text => lv_message_text,

Line 44771: (p_table_name => 'MSC_ST_ROUTING_OPERATIONS',

44767: ' AND NVL(operation_seq_code,'||''''||NULL_CHAR||''''||') '
44768: ||' = '||''''||NULL_CHAR||'''' ;
44769:
44770: lv_return := MSC_ST_UTIL.LOG_ERROR
44771: (p_table_name => 'MSC_ST_ROUTING_OPERATIONS',
44772: p_instance_code => v_instance_code,
44773: p_row => lv_column_names,
44774: p_severity => G_SEV_WARNING,
44775: p_message_text => lv_message_text,

Line 44791: 'UPDATE msc_st_routing_operations msro'

44787: -- Derive operation_sequence id, operation_seq_num
44788:
44789: v_sql_stmt := 24;
44790: lv_sql_Stmt :=
44791: 'UPDATE msc_st_routing_operations msro'
44792: ||' SET (operation_sequence_id,operation_seq_num)= (SELECT local_id,number1'
44793: ||' FROM msc_local_id_setup mlis'
44794: ||' WHERE mlis.char1 = msro.sr_instance_code'
44795: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '

Line 44820: 'UPDATE msc_st_routing_operations msro'

44816: /*
44817: v_sql_stmt := 25;
44818:
44819: lv_sql_stmt :=
44820: 'UPDATE msc_st_routing_operations msro'
44821: ||' SET operation_seq_num = ( SELECT number1'
44822: ||' FROM msc_local_id_setup mlis'
44823: ||' WHERE local_id = msro.operation_sequence_id'
44824: ||' AND mlis.entity_name = ''OPERATION_SEQUENCE_ID'' '

Line 44851: 'UPDATE msc_st_routing_operations'

44847: -- Error out if DELETED_FLAG = SYS_YES but operation_sequence_id is NULL
44848:
44849: v_sql_stmt := 26;
44850: lv_sql_stmt :=
44851: 'UPDATE msc_st_routing_operations'
44852: ||' SET process_flag ='||G_ERROR_FLG||','
44853: ||' error_text = '||''''||lv_message_text||''''
44854: ||' WHERE NVL(operation_sequence_id,'||NULL_VALUE||') ='||NULL_VALUE
44855: ||' AND deleted_flag ='||SYS_YES

Line 44883: ' UPDATE msc_st_routing_operations '

44879: -- Error out record if department_code is null/resource_code is NULL and line_flag=2
44880:
44881: v_sql_stmt := 26.1;
44882: lv_sql_stmt :=
44883: ' UPDATE msc_st_routing_operations '
44884: ||' SET process_flag = '||G_ERROR_FLG||','
44885: ||' error_text = '||''''||lv_message_text||''''
44886: ||' WHERE NVL(department_code,'||''''||NULL_CHAR||''''||')'
44887: ||' = '||''''||NULL_CHAR||''''

Line 44901: 'UPDATE msc_st_routing_operations msro'

44897:
44898: -- Derive department id
44899: v_sql_stmt := 27;
44900: lv_sql_stmt :=
44901: 'UPDATE msc_st_routing_operations msro'
44902: ||' SET department_id= (SELECT local_id'
44903: ||' FROM msc_local_id_setup mlis'
44904: ||' WHERE mlis.char1 = msro.sr_instance_code'
44905: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '

Line 44933: UPDATE msc_st_routing_operations

44929: IF c10%ROWCOUNT > 0 THEN
44930:
44931: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
44932:
44933: UPDATE msc_st_routing_operations
44934: SET department_id = msc_st_department_id_s.NEXTVAL
44935: WHERE rowid = lb_rowid(j);
44936:
44937:

Line 44976: FROM msc_st_routing_operations

44972: v_current_date,
44973: v_current_user,
44974: v_current_date,
44975: v_current_user
44976: FROM msc_st_routing_operations
44977: WHERE rowid = lb_rowid(j);
44978:
44979: END IF;
44980: CLOSE c10;

Line 44986: 'UPDATE msc_st_routing_operations msdr'

44982: -- Now derive department id
44983: v_sql_stmt:= 15;
44984:
44985: lv_sql_stmt :=
44986: 'UPDATE msc_st_routing_operations msdr'
44987: ||' SET department_id= (SELECT local_id'
44988: ||' FROM msc_local_id_setup mlis'
44989: ||' WHERE mlis.char1 = msdr.sr_instance_code'
44990: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '

Line 45020: p_token_value3 => 'MSC_ST_ROUTING_OPERATIONS' );

45016: ||'ORGANIZATION_CODE,DEPARTMENT_CODE',
45017: p_token2 => 'MASTER_TABLE',
45018: p_token_value2 => 'MSC_ST_DEPARTMENT_RESOURCES',
45019: p_token3 => 'CHILD_TABLE' ,
45020: p_token_value3 => 'MSC_ST_ROUTING_OPERATIONS' );
45021:
45022: IF lv_return <> 0 THEN
45023: RAISE ex_logging_err;
45024: END IF;

Line 45030: 'UPDATE msc_st_routing_operations '

45026: -- Log an error if unable to derive department id
45027:
45028: v_sql_stmt := 28;
45029: lv_sql_stmt :=
45030: 'UPDATE msc_st_routing_operations '
45031: ||' SET process_flag ='||G_ERROR_FLG||','
45032: ||' error_text = '||''''||lv_message_text||''''
45033: ||' WHERE NVL(department_id,'||NULL_VALUE||') ='||NULL_VALUE
45034: ||' AND sr_instance_code = :v_instance_code'

Line 45066: (p_table_name => 'MSC_ST_ROUTING_OPERATIONS',

45062: lv_where_str := ' AND NVL(option_dependent_flag,'||NULL_VALUE||')'
45063: ||' NOT IN (1,2) AND deleted_flag = '||SYS_NO ;
45064:
45065: lv_return := MSC_ST_UTIL.LOG_ERROR
45066: (p_table_name => 'MSC_ST_ROUTING_OPERATIONS',
45067: p_instance_code => v_instance_code,
45068: p_row => lv_column_names,
45069: p_severity => G_SEV_WARNING,
45070: p_message_text => lv_message_text,

Line 45089: pEntityName => 'MSC_ST_ROUTING_OPERATIONS',

45085: (ERRBUF => lv_error_text,
45086: RETCODE => lv_return,
45087: pBatchID => lv_batch_id,
45088: pInstanceCode => v_instance_code,
45089: pEntityName => 'MSC_ST_ROUTING_OPERATIONS',
45090: pInstanceID => v_instance_id);
45091:
45092: IF NVL(lv_return,0) <> 0 THEN
45093: RAISE ex_logging_err;

Line 45110: UPDATE msc_st_routing_operations

45106: IF c5%ROWCOUNT > 0 THEN
45107:
45108: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
45109:
45110: UPDATE msc_st_routing_operations
45111: SET operation_sequence_id = msc_st_operation_sequence_id_s.NEXTVAL ,
45112: operation_seq_num =
45113: to_number(decode(length(rtrim(operation_seq_code,'0123456789')),
45114: NULL,operation_seq_code,'1'))

Line 45168: FROM msc_st_routing_operations

45164: v_current_date,
45165: v_current_user,
45166: v_current_date,
45167: v_current_user
45168: FROM msc_st_routing_operations
45169: WHERE rowid = lb_rowid(j) ;
45170:
45171: END IF;
45172: CLOSE c5;

Line 45203: ||' FROM msc_st_routing_operations msro,'

45199: ||' msro.last_updated_by,'
45200: ||' msro.creation_date,'
45201: ||' msro.created_by,'
45202: ||' msro.REFRESH_ID'
45203: ||' FROM msc_st_routing_operations msro,'
45204: ||' msc_st_bom_components msbc,'
45205: ||' msc_local_id_setup mlis'
45206: ||' WHERE msbc.bill_sequence_id = mlis.number1'
45207: ||' AND mlis.entity_name = ''ROUTING_SEQUENCE_ID'' '

Line 45229: ||' FROM msc_st_routing_operations msro,'

45225: ||' msro.last_updated_by,'
45226: ||' msro.creation_date,'
45227: ||' msro.created_by,'
45228: ||' msro.REFRESH_ID'
45229: ||' FROM msc_st_routing_operations msro,'
45230: ||' msc_bom_components mbc,'
45231: ||' msc_local_id_setup mlis,'
45232: ||' msc_local_id_setup mlis1'
45233: ||' WHERE mbc.component_sequence_id = mlis1.local_id '

Line 45255: MSC_ST_UTIL.SET_PROCESS_FLAG(p_table_name => 'MSC_ST_ROUTING_OPERATIONS',

45251: v_instance_id,v_instance_id,v_instance_code,v_instance_id,lv_batch_id;
45252:
45253: -- Set the process flag as Valid and derive sr_instance_id
45254: lv_return :=
45255: MSC_ST_UTIL.SET_PROCESS_FLAG(p_table_name => 'MSC_ST_ROUTING_OPERATIONS',
45256: p_instance_id => v_instance_id,
45257: p_instance_code => v_instance_code,
45258: p_process_flag => G_VALID,
45259: p_error_text => lv_error_text,

Line 45271: MSC_ST_UTIL.LOG_ERROR(p_table_name => 'MSC_ST_ROUTING_OPERATIONS',

45267:
45268: -- At the end calling the LOG_ERROR for logging all errored out records
45269:
45270: lv_return :=
45271: MSC_ST_UTIL.LOG_ERROR(p_table_name => 'MSC_ST_ROUTING_OPERATIONS',
45272: p_instance_code => v_instance_code,
45273: p_row => lv_column_names,
45274: p_severity => G_SEV_ERROR,
45275: p_message_text => NULL,

Line 45704: p_token_value2 => 'MSC_ST_ROUTING_OPERATIONS',

45700: ||'ORGANIZATION_CODE,ROUTING_NAME,'
45701: ||' OPERATION_SEQ_CODE,EFFECTIVITY_DATE,'
45702: ||' ALTERNATE_ROUTING_DESIGNATOR' ,
45703: p_token2 => 'MASTER_TABLE',
45704: p_token_value2 => 'MSC_ST_ROUTING_OPERATIONS',
45705: p_token3 => 'CHILD_TABLE' ,
45706: p_token_value3 => 'MSC_ST_OPERATION_RESOURCES' );
45707:
45708: IF lv_return <> 0 THEN

Line 46828: p_token_value2 => 'MSC_ST_ROUTING_OPERATIONS',

46824: ||'ORGANIZATION_CODE,ROUTING_NAME,'
46825: ||' FROM_OPERATION_SEQ_CODE,FROM_OP_EFFECTIVITY_DATE,'
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

Line 46890: p_token_value2 => 'MSC_ST_ROUTING_OPERATIONS',

46886: ||'ORGANIZATION_CODE,ROUTING_NAME,'
46887: ||' TO_OPERATION_SEQ_CODE,TO_OP_EFFECTIVITY_DATE,'
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

Line 55864: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_ROUTING_OPERATIONS');

55860: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_OPERATION_RESOURCES');
55861: IF lv_count > 0 Then
55862: prec.bom_flag:= SYS_YES;
55863: End IF;
55864: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_ROUTING_OPERATIONS');
55865: IF lv_count > 0 Then
55866: prec.bom_flag:= SYS_YES;
55867: End IF;
55868: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_ROUTINGS');