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_COMPONENT_SUBSTITUTES

Line 771: ||' on MSC_ST_COMPONENT_SUBSTITUTES '

767: application_short_name => 'MSC',
768: statement_type => AD_DDL.CREATE_INDEX,
769: statement =>
770: 'create index MSC_ST_COMP_SUB_N1_'||v_instance_code
771: ||' on MSC_ST_COMPONENT_SUBSTITUTES '
772: ||'(sr_instance_code, assembly_name, component_name, sub_item_name, effectivity_date, operation_seq_code, organization_code,company_name, bom_name, alternate_bom_designator) '
773: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
774: object_name =>'MSC_ST_COMP_SUB_N1_'||v_instance_code);
775:

Line 803: msc_analyse_tables_pk.analyse_table( 'MSC_ST_COMPONENT_SUBSTITUTES', v_instance_id, -1);

799: END;
800:
801: msc_analyse_tables_pk.analyse_table( 'MSC_ST_BOMS', v_instance_id, -1);
802: msc_analyse_tables_pk.analyse_table( 'MSC_ST_BOM_COMPONENTS', v_instance_id, -1);
803: msc_analyse_tables_pk.analyse_table( 'MSC_ST_COMPONENT_SUBSTITUTES', v_instance_id, -1);
804: msc_analyse_tables_pk.analyse_table( 'MSC_ST_CO_PRODUCTS', v_instance_id, -1);
805:
806:
807: END IF;

Line 40455: FROM msc_st_component_substitutes

40451: AND deleted_flag = SYS_NO;
40452:
40453: CURSOR c6(p_batch_id NUMBER) IS
40454: SELECT rowid
40455: FROM msc_st_component_substitutes
40456: WHERE process_flag IN (G_IN_PROCESS,G_ERROR_FLG)
40457: AND sr_instance_code = v_instance_code
40458: AND batch_id = p_batch_id;
40459:

Line 42226: -- Now validtion for MSC_ST_COMPONENT_SUBSTITUTES

42222: COMMIT;
42223: END LOOP;
42224:
42225:
42226: -- Now validtion for MSC_ST_COMPONENT_SUBSTITUTES
42227:
42228:
42229: --Duplicate records check for the records whose source is XML
42230:

Line 42244: 'UPDATE msc_st_component_substitutes mcs1 '

42240:
42241:
42242: v_sql_stmt := 26;
42243: lv_sql_stmt :=
42244: 'UPDATE msc_st_component_substitutes mcs1 '
42245: ||' SET process_flag ='|| G_ERROR_FLG||','
42246: ||' error_text = '||''''||lv_message_text||''''
42247: ||' WHERE message_id < ( SELECT max(message_id)'
42248: ||' FROM msc_st_component_substitutes mcs2'

Line 42248: ||' FROM msc_st_component_substitutes mcs2'

42244: 'UPDATE msc_st_component_substitutes mcs1 '
42245: ||' SET process_flag ='|| G_ERROR_FLG||','
42246: ||' error_text = '||''''||lv_message_text||''''
42247: ||' WHERE message_id < ( SELECT max(message_id)'
42248: ||' FROM msc_st_component_substitutes mcs2'
42249: ||' WHERE mcs2.sr_instance_code = mcs1.sr_instance_code'
42250: ||' AND mcs2.organization_code = mcs1.organization_code'
42251: ||' AND NVL(mcs2.company_name,'||''''||NULL_CHAR||''''||') '
42252: ||' = NVL(mcs1.company_name, '||''''||NULL_CHAR||''''||') '

Line 42291: 'UPDATE msc_st_component_substitutes mcs1'

42287:
42288: v_sql_stmt := 27;
42289:
42290: lv_sql_stmt :=
42291: 'UPDATE msc_st_component_substitutes mcs1'
42292: ||' SET process_flag = '||G_ERROR_FLG||','
42293: ||' error_text = '||''''||lv_message_text||''''
42294: ||' WHERE EXISTS ( SELECT 1 FROM msc_st_component_substitutes mcs2'
42295: ||' WHERE mcs2.sr_instance_code = mcs1.sr_instance_code'

Line 42294: ||' WHERE EXISTS ( SELECT 1 FROM msc_st_component_substitutes mcs2'

42290: lv_sql_stmt :=
42291: 'UPDATE msc_st_component_substitutes mcs1'
42292: ||' SET process_flag = '||G_ERROR_FLG||','
42293: ||' error_text = '||''''||lv_message_text||''''
42294: ||' WHERE EXISTS ( SELECT 1 FROM msc_st_component_substitutes mcs2'
42295: ||' WHERE mcs2.sr_instance_code = mcs1.sr_instance_code'
42296: ||' AND mcs2.organization_code = mcs1.organization_code'
42297: ||' AND NVL(mcs2.company_name,'||''''||NULL_CHAR||''''||') '
42298: ||' = NVL(mcs1.company_name, '||''''||NULL_CHAR||''''||') '

Line 42343: -- Processing the MSC_ST_COMPONENT_SUBSTITUTES table

42339: ||'COMPANY_NAME ||''~''||'
42340: ||'DELETED_FLAG ';
42341:
42342:
42343: -- Processing the MSC_ST_COMPONENT_SUBSTITUTES table
42344:
42345: LOOP
42346: v_sql_stmt := 28;
42347: lv_cursor_stmt :=

Line 42357: ' UPDATE msc_st_component_substitutes '

42353: CLOSE c1;
42354:
42355: v_sql_stmt := 29;
42356: lv_sql_stmt :=
42357: ' UPDATE msc_st_component_substitutes '
42358: ||' SET batch_id = :lv_batch_id'
42359: ||' WHERE process_flag IN ('||G_IN_PROCESS||','||G_ERROR_FLG||')'
42360: ||' AND sr_instance_code = :v_instance_code'
42361: ||' AND NVL(batch_id,'||NULL_VALUE||') = '||NULL_VALUE

Line 42377: UPDATE msc_st_component_substitutes

42373: CLOSE c6;
42374:
42375: v_sql_stmt := 29;
42376: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
42377: UPDATE msc_st_component_substitutes
42378: SET st_transaction_id = msc_st_component_substitutes_s.NEXTVAL,
42379: refresh_id = v_refresh_id,
42380: last_update_date = v_current_date,
42381: last_updated_by = v_current_user,

Line 42378: SET st_transaction_id = msc_st_component_substitutes_s.NEXTVAL,

42374:
42375: v_sql_stmt := 29;
42376: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
42377: UPDATE msc_st_component_substitutes
42378: SET st_transaction_id = msc_st_component_substitutes_s.NEXTVAL,
42379: refresh_id = v_refresh_id,
42380: last_update_date = v_current_date,
42381: last_updated_by = v_current_user,
42382: creation_date = v_current_date,

Line 42395: p_token_value1 => 'MSC_ST_COMPONENT_SUBSTITUTES');

42391: p_error_code => 'MSC_PP_NO_DELETION',
42392: p_message_text => lv_message_text,
42393: p_error_text => lv_error_text,
42394: p_token1 => 'TABLE_NAME',
42395: p_token_value1 => 'MSC_ST_COMPONENT_SUBSTITUTES');
42396:
42397: IF lv_return <> 0 THEN
42398: RAISE ex_logging_err;
42399: END IF;

Line 42404: ' UPDATE msc_st_component_substitutes'

42400:
42401: --Deletion is not allowed on this table.
42402: v_sql_stmt := 30;
42403: lv_sql_stmt :=
42404: ' UPDATE msc_st_component_substitutes'
42405: ||' SET process_flag = '||G_ERROR_FLG||','
42406: ||' error_text = '||''''||lv_message_text||''''
42407: ||' WHERE deleted_flag = '||SYS_YES
42408: ||' AND process_flag = '||G_IN_PROCESS

Line 42436: (p_table_name => 'MSC_ST_COMPONENT_SUBSTITUTES',

42432: lv_where_str :=
42433: ' AND NVL(deleted_flag,'||NULL_VALUE||')NOT IN (1,2)';
42434:
42435: lv_return := MSC_ST_UTIL.LOG_ERROR
42436: (p_table_name => 'MSC_ST_COMPONENT_SUBSTITUTES',
42437: p_instance_code => v_instance_code,
42438: p_row => lv_column_names,
42439: p_severity => G_SEV_WARNING,
42440: p_message_text => lv_message_text,

Line 42469: MSC_ST_UTIL.DERIVE_ITEM_ID(p_table_name => 'MSC_ST_COMPONENT_SUBSTITUTES',

42465: END IF;
42466:
42467: --Derive SUBSTITUTE ITEM ID
42468: lv_return :=
42469: MSC_ST_UTIL.DERIVE_ITEM_ID(p_table_name => 'MSC_ST_COMPONENT_SUBSTITUTES',
42470: p_item_col_name => 'SUB_ITEM_NAME',
42471: p_item_col_id => 'SUBSTITUTE_ITEM_ID',
42472: p_instance_code => v_instance_code,
42473: p_instance_id => v_instance_id,

Line 42501: MSC_ST_UTIL.DERIVE_PARTNER_ORG_ID(p_table_name => 'MSC_ST_COMPONENT_SUBSTITUTES',

42497:
42498: -- Populate organization id ,
42499:
42500: lv_return :=
42501: MSC_ST_UTIL.DERIVE_PARTNER_ORG_ID(p_table_name => 'MSC_ST_COMPONENT_SUBSTITUTES',
42502: p_org_partner_name => 'ORGANIZATION_CODE',
42503: p_org_partner_id => 'ORGANIZATION_ID',
42504: p_instance_code => v_instance_code,
42505: p_partner_type => G_ORGANIZATION,

Line 42523: 'UPDATE msc_st_component_substitutes '

42519: v_sql_stmt := 31;
42520:
42521: lv_sql_stmt :=
42522:
42523: 'UPDATE msc_st_component_substitutes '
42524: ||' SET bom_name = assembly_name'
42525: ||' WHERE sr_instance_code = :v_instance_code'
42526: ||' AND process_flag ='||G_IN_PROCESS
42527: ||' AND NVL(bom_name,'||''''||NULL_CHAR||''''||') '

Line 42546: 'UPDATE msc_st_component_substitutes mcs'

42542:
42543: v_sql_stmt := 32;
42544:
42545: lv_sql_stmt:=
42546: 'UPDATE msc_st_component_substitutes mcs'
42547: ||' SET assembly_name = (SELECT char5'
42548: ||' FROM msc_local_id_setup mlis'
42549: ||' WHERE mlis.char1 = mcs.sr_instance_code'
42550: ||' AND mlis.char3 = mcs.organization_code'

Line 42582: p_token_value3 => 'MSC_ST_COMPONENT_SUBSTITUTES');

42578: ||' ALETERNATE_BOM_DESIGNATOR',
42579: p_token2 => 'MASTER_TABLE',
42580: p_token_value2 => 'MSC_ST_BOMS',
42581: p_token3 => 'CHILD_TABLE',
42582: p_token_value3 => 'MSC_ST_COMPONENT_SUBSTITUTES');
42583:
42584: IF lv_return <> 0 THEN
42585: RAISE ex_logging_err;
42586: END IF;

Line 42593: 'UPDATE msc_st_component_substitutes '

42589: -- Error out those records where assembly name is still NULL,
42590:
42591: v_sql_stmt := 33;
42592: lv_sql_stmt :=
42593: 'UPDATE msc_st_component_substitutes '
42594: ||' SET process_flag = '||G_ERROR_FLG||','
42595: ||' error_text = '||''''||lv_message_text||''''
42596: ||' WHERE NVL(assembly_name,'||''''||NULL_CHAR||''''||') '
42597: ||' = '||''''||NULL_CHAR||''''

Line 42611: (p_table_name => 'MSC_ST_COMPONENT_SUBSTITUTES',

42607:
42608: -- Derive bill sequence id
42609: lv_return :=
42610: MSC_ST_UTIL.DERIVE_BILL_SEQUENCE_ID
42611: (p_table_name => 'MSC_ST_COMPONENT_SUBSTITUTES',
42612: p_bom_col_name => 'BOM_NAME',
42613: p_bom_col_id => 'BILL_SEQUENCE_ID',
42614: p_instance_code => v_instance_code,
42615: p_severity => G_SEV_ERROR,

Line 42647: (p_table_name => 'MSC_ST_COMPONENT_SUBSTITUTES',

42643: lv_where_str :=
42644: ' AND NVL(effectivity_date,SYSDATE-36500 ) = SYSDATE-36500' ;
42645:
42646: lv_return := MSC_ST_UTIL.LOG_ERROR
42647: (p_table_name => 'MSC_ST_COMPONENT_SUBSTITUTES',
42648: p_instance_code => v_instance_code,
42649: p_row => lv_column_names,
42650: p_severity => G_SEV_WARNING,
42651: p_message_text => lv_message_text,

Line 42667: 'UPDATE msc_st_component_substitutes mcs'

42663: -- Now derive the component sequence id for the Unique key combination
42664: v_sql_stmt := 34;
42665:
42666: lv_sql_stmt :=
42667: 'UPDATE msc_st_component_substitutes mcs'
42668: ||' SET component_sequence_id= (SELECT local_id '
42669: ||' FROM msc_local_id_setup mlis'
42670: ||' WHERE mlis.char1 = mcs.sr_instance_code'
42671: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '

Line 42704: p_token_value3 => 'MSC_ST_COMPONENT_SUBSTITUTES');

42700: ||' ALETERNATE_BOM_DESIGNATOR,OPERATION_SEQ_CODE',
42701: p_token2 => 'MASTER_TABLE',
42702: p_token_value2 => 'MSC_ST_BOM_COMPONENTS',
42703: p_token3 => 'CHILD_TABLE',
42704: p_token_value3 => 'MSC_ST_COMPONENT_SUBSTITUTES');
42705:
42706:
42707: IF lv_return <> 0 THEN
42708: RAISE ex_logging_err;

Line 42713: 'UPDATE msc_st_component_substitutes '

42709: END IF;
42710:
42711: v_sql_stmt := 35;
42712: lv_sql_stmt:=
42713: 'UPDATE msc_st_component_substitutes '
42714: ||' SET process_flag ='|| G_ERROR_FLG||','
42715: ||' error_text ='||''''||lv_message_text||''''
42716: ||' WHERE NVL(component_sequence_id,'||NULL_VALUE||')='|| NULL_VALUE
42717: ||' AND sr_instance_code = :v_instance_code'

Line 42746: (p_table_name => 'MSC_ST_COMPONENT_SUBSTITUTES',

42742:
42743: lv_where_str := ' AND NVL(usage_quantity,'||NULL_VALUE||')='|| NULL_VALUE ;
42744:
42745: lv_return := MSC_ST_UTIL.LOG_ERROR
42746: (p_table_name => 'MSC_ST_COMPONENT_SUBSTITUTES',
42747: p_instance_code => v_instance_code,
42748: p_row => lv_column_names,
42749: p_severity => G_SEV_WARNING,
42750: p_message_text => lv_message_text,

Line 42784: (p_table_name => 'MSC_ST_COMPONENT_SUBSTITUTES',

42780:
42781: lv_where_str := ' AND NVL(priority,'||NULL_VALUE||')='|| NULL_VALUE ;
42782:
42783: lv_return := MSC_ST_UTIL.LOG_ERROR
42784: (p_table_name => 'MSC_ST_COMPONENT_SUBSTITUTES',
42785: p_instance_code => v_instance_code,
42786: p_row => lv_column_names,
42787: p_severity => G_SEV_WARNING,
42788: p_message_text => lv_message_text,

Line 42808: pEntityName => 'MSC_ST_COMPONENT_SUBSTITUTES',

42804: (ERRBUF => lv_error_text,
42805: RETCODE => lv_return,
42806: pBatchID => lv_batch_id,
42807: pInstanceCode => v_instance_code,
42808: pEntityName => 'MSC_ST_COMPONENT_SUBSTITUTES',
42809: pInstanceID => v_instance_id);
42810:
42811: IF NVL(lv_return,0) <> 0 THEN
42812: RAISE ex_logging_err;

Line 42817: MSC_ST_UTIL.SET_PROCESS_FLAG(p_table_name => 'MSC_ST_COMPONENT_SUBSTITUTES',

42813: END IF;
42814:
42815: -- Set the process flag as Valid and poulate instance_id
42816: lv_return :=
42817: MSC_ST_UTIL.SET_PROCESS_FLAG(p_table_name => 'MSC_ST_COMPONENT_SUBSTITUTES',
42818: p_instance_id => v_instance_id,
42819: p_instance_code => v_instance_code,
42820: p_process_flag => G_VALID,
42821: p_error_text => lv_error_text,

Line 42832: msc_st_util.log_error(p_table_name => 'MSC_ST_COMPONENT_SUBSTITUTES',

42828:
42829: -- At the end calling the LOG_ERROR for logging all errored out records
42830:
42831: lv_return :=
42832: msc_st_util.log_error(p_table_name => 'MSC_ST_COMPONENT_SUBSTITUTES',
42833: p_instance_code => v_instance_code,
42834: p_row => lv_column_names,
42835: p_severity => G_SEV_ERROR,
42836: p_error_text => lv_error_text,

Line 55832: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_COMPONENT_SUBSTITUTES');

55828: End IF;
55829: END IF;
55830:
55831: IF v_bom_enabled = SYS_YES THEN
55832: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_COMPONENT_SUBSTITUTES');
55833: IF lv_count > 0 Then
55834: prec.bom_flag:= SYS_YES;
55835: End IF;
55836: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_BOM_COMPONENTS');