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 763: ||' on MSC_ST_COMPONENT_SUBSTITUTES '

759: application_short_name => 'MSC',
760: statement_type => AD_DDL.CREATE_INDEX,
761: statement =>
762: 'create index MSC_ST_COMP_SUB_N1_'||v_instance_code
763: ||' on MSC_ST_COMPONENT_SUBSTITUTES '
764: ||'(sr_instance_code, assembly_name, component_name, sub_item_name, effectivity_date, operation_seq_code, organization_code,company_name, bom_name, alternate_bom_designator) '
765: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
766: object_name =>'MSC_ST_COMP_SUB_N1_'||v_instance_code);
767:

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

791: END;
792:
793: msc_analyse_tables_pk.analyse_table( 'MSC_ST_BOMS', v_instance_id, -1);
794: msc_analyse_tables_pk.analyse_table( 'MSC_ST_BOM_COMPONENTS', v_instance_id, -1);
795: msc_analyse_tables_pk.analyse_table( 'MSC_ST_COMPONENT_SUBSTITUTES', v_instance_id, -1);
796: msc_analyse_tables_pk.analyse_table( 'MSC_ST_CO_PRODUCTS', v_instance_id, -1);
797:
798:
799: END IF;

Line 35671: FROM msc_st_component_substitutes

35667: AND deleted_flag = SYS_NO;
35668:
35669: CURSOR c6(p_batch_id NUMBER) IS
35670: SELECT rowid
35671: FROM msc_st_component_substitutes
35672: WHERE process_flag IN (G_IN_PROCESS,G_ERROR_FLG)
35673: AND sr_instance_code = v_instance_code
35674: AND batch_id = p_batch_id;
35675:

Line 37442: -- Now validtion for MSC_ST_COMPONENT_SUBSTITUTES

37438: COMMIT;
37439: END LOOP;
37440:
37441:
37442: -- Now validtion for MSC_ST_COMPONENT_SUBSTITUTES
37443:
37444:
37445: --Duplicate records check for the records whose source is XML
37446:

Line 37460: 'UPDATE msc_st_component_substitutes mcs1 '

37456:
37457:
37458: v_sql_stmt := 26;
37459: lv_sql_stmt :=
37460: 'UPDATE msc_st_component_substitutes mcs1 '
37461: ||' SET process_flag ='|| G_ERROR_FLG||','
37462: ||' error_text = '||''''||lv_message_text||''''
37463: ||' WHERE message_id < ( SELECT max(message_id)'
37464: ||' FROM msc_st_component_substitutes mcs2'

Line 37464: ||' FROM msc_st_component_substitutes mcs2'

37460: 'UPDATE msc_st_component_substitutes mcs1 '
37461: ||' SET process_flag ='|| G_ERROR_FLG||','
37462: ||' error_text = '||''''||lv_message_text||''''
37463: ||' WHERE message_id < ( SELECT max(message_id)'
37464: ||' FROM msc_st_component_substitutes mcs2'
37465: ||' WHERE mcs2.sr_instance_code = mcs1.sr_instance_code'
37466: ||' AND mcs2.organization_code = mcs1.organization_code'
37467: ||' AND NVL(mcs2.company_name,'||''''||NULL_CHAR||''''||') '
37468: ||' = NVL(mcs1.company_name, '||''''||NULL_CHAR||''''||') '

Line 37507: 'UPDATE msc_st_component_substitutes mcs1'

37503:
37504: v_sql_stmt := 27;
37505:
37506: lv_sql_stmt :=
37507: 'UPDATE msc_st_component_substitutes mcs1'
37508: ||' SET process_flag = '||G_ERROR_FLG||','
37509: ||' error_text = '||''''||lv_message_text||''''
37510: ||' WHERE EXISTS ( SELECT 1 FROM msc_st_component_substitutes mcs2'
37511: ||' WHERE mcs2.sr_instance_code = mcs1.sr_instance_code'

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

37506: lv_sql_stmt :=
37507: 'UPDATE msc_st_component_substitutes mcs1'
37508: ||' SET process_flag = '||G_ERROR_FLG||','
37509: ||' error_text = '||''''||lv_message_text||''''
37510: ||' WHERE EXISTS ( SELECT 1 FROM msc_st_component_substitutes mcs2'
37511: ||' WHERE mcs2.sr_instance_code = mcs1.sr_instance_code'
37512: ||' AND mcs2.organization_code = mcs1.organization_code'
37513: ||' AND NVL(mcs2.company_name,'||''''||NULL_CHAR||''''||') '
37514: ||' = NVL(mcs1.company_name, '||''''||NULL_CHAR||''''||') '

Line 37559: -- Processing the MSC_ST_COMPONENT_SUBSTITUTES table

37555: ||'COMPANY_NAME ||''~''||'
37556: ||'DELETED_FLAG ';
37557:
37558:
37559: -- Processing the MSC_ST_COMPONENT_SUBSTITUTES table
37560:
37561: LOOP
37562: v_sql_stmt := 28;
37563: lv_cursor_stmt :=

Line 37573: ' UPDATE msc_st_component_substitutes '

37569: CLOSE c1;
37570:
37571: v_sql_stmt := 29;
37572: lv_sql_stmt :=
37573: ' UPDATE msc_st_component_substitutes '
37574: ||' SET batch_id = :lv_batch_id'
37575: ||' WHERE process_flag IN ('||G_IN_PROCESS||','||G_ERROR_FLG||')'
37576: ||' AND sr_instance_code = :v_instance_code'
37577: ||' AND NVL(batch_id,'||NULL_VALUE||') = '||NULL_VALUE

Line 37593: UPDATE msc_st_component_substitutes

37589: CLOSE c6;
37590:
37591: v_sql_stmt := 29;
37592: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
37593: UPDATE msc_st_component_substitutes
37594: SET st_transaction_id = msc_st_component_substitutes_s.NEXTVAL,
37595: refresh_id = v_refresh_id,
37596: last_update_date = v_current_date,
37597: last_updated_by = v_current_user,

Line 37594: SET st_transaction_id = msc_st_component_substitutes_s.NEXTVAL,

37590:
37591: v_sql_stmt := 29;
37592: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
37593: UPDATE msc_st_component_substitutes
37594: SET st_transaction_id = msc_st_component_substitutes_s.NEXTVAL,
37595: refresh_id = v_refresh_id,
37596: last_update_date = v_current_date,
37597: last_updated_by = v_current_user,
37598: creation_date = v_current_date,

Line 37611: p_token_value1 => 'MSC_ST_COMPONENT_SUBSTITUTES');

37607: p_error_code => 'MSC_PP_NO_DELETION',
37608: p_message_text => lv_message_text,
37609: p_error_text => lv_error_text,
37610: p_token1 => 'TABLE_NAME',
37611: p_token_value1 => 'MSC_ST_COMPONENT_SUBSTITUTES');
37612:
37613: IF lv_return <> 0 THEN
37614: RAISE ex_logging_err;
37615: END IF;

Line 37620: ' UPDATE msc_st_component_substitutes'

37616:
37617: --Deletion is not allowed on this table.
37618: v_sql_stmt := 30;
37619: lv_sql_stmt :=
37620: ' UPDATE msc_st_component_substitutes'
37621: ||' SET process_flag = '||G_ERROR_FLG||','
37622: ||' error_text = '||''''||lv_message_text||''''
37623: ||' WHERE deleted_flag = '||SYS_YES
37624: ||' AND process_flag = '||G_IN_PROCESS

Line 37652: (p_table_name => 'MSC_ST_COMPONENT_SUBSTITUTES',

37648: lv_where_str :=
37649: ' AND NVL(deleted_flag,'||NULL_VALUE||')NOT IN (1,2)';
37650:
37651: lv_return := MSC_ST_UTIL.LOG_ERROR
37652: (p_table_name => 'MSC_ST_COMPONENT_SUBSTITUTES',
37653: p_instance_code => v_instance_code,
37654: p_row => lv_column_names,
37655: p_severity => G_SEV_WARNING,
37656: p_message_text => lv_message_text,

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

37681: END IF;
37682:
37683: --Derive SUBSTITUTE ITEM ID
37684: lv_return :=
37685: MSC_ST_UTIL.DERIVE_ITEM_ID(p_table_name => 'MSC_ST_COMPONENT_SUBSTITUTES',
37686: p_item_col_name => 'SUB_ITEM_NAME',
37687: p_item_col_id => 'SUBSTITUTE_ITEM_ID',
37688: p_instance_code => v_instance_code,
37689: p_instance_id => v_instance_id,

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

37713:
37714: -- Populate organization id ,
37715:
37716: lv_return :=
37717: MSC_ST_UTIL.DERIVE_PARTNER_ORG_ID(p_table_name => 'MSC_ST_COMPONENT_SUBSTITUTES',
37718: p_org_partner_name => 'ORGANIZATION_CODE',
37719: p_org_partner_id => 'ORGANIZATION_ID',
37720: p_instance_code => v_instance_code,
37721: p_partner_type => G_ORGANIZATION,

Line 37739: 'UPDATE msc_st_component_substitutes '

37735: v_sql_stmt := 31;
37736:
37737: lv_sql_stmt :=
37738:
37739: 'UPDATE msc_st_component_substitutes '
37740: ||' SET bom_name = assembly_name'
37741: ||' WHERE sr_instance_code = :v_instance_code'
37742: ||' AND process_flag ='||G_IN_PROCESS
37743: ||' AND NVL(bom_name,'||''''||NULL_CHAR||''''||') '

Line 37762: 'UPDATE msc_st_component_substitutes mcs'

37758:
37759: v_sql_stmt := 32;
37760:
37761: lv_sql_stmt:=
37762: 'UPDATE msc_st_component_substitutes mcs'
37763: ||' SET assembly_name = (SELECT char5'
37764: ||' FROM msc_local_id_setup mlis'
37765: ||' WHERE mlis.char1 = mcs.sr_instance_code'
37766: ||' AND mlis.char3 = mcs.organization_code'

Line 37798: p_token_value3 => 'MSC_ST_COMPONENT_SUBSTITUTES');

37794: ||' ALETERNATE_BOM_DESIGNATOR',
37795: p_token2 => 'MASTER_TABLE',
37796: p_token_value2 => 'MSC_ST_BOMS',
37797: p_token3 => 'CHILD_TABLE',
37798: p_token_value3 => 'MSC_ST_COMPONENT_SUBSTITUTES');
37799:
37800: IF lv_return <> 0 THEN
37801: RAISE ex_logging_err;
37802: END IF;

Line 37809: 'UPDATE msc_st_component_substitutes '

37805: -- Error out those records where assembly name is still NULL,
37806:
37807: v_sql_stmt := 33;
37808: lv_sql_stmt :=
37809: 'UPDATE msc_st_component_substitutes '
37810: ||' SET process_flag = '||G_ERROR_FLG||','
37811: ||' error_text = '||''''||lv_message_text||''''
37812: ||' WHERE NVL(assembly_name,'||''''||NULL_CHAR||''''||') '
37813: ||' = '||''''||NULL_CHAR||''''

Line 37827: (p_table_name => 'MSC_ST_COMPONENT_SUBSTITUTES',

37823:
37824: -- Derive bill sequence id
37825: lv_return :=
37826: MSC_ST_UTIL.DERIVE_BILL_SEQUENCE_ID
37827: (p_table_name => 'MSC_ST_COMPONENT_SUBSTITUTES',
37828: p_bom_col_name => 'BOM_NAME',
37829: p_bom_col_id => 'BILL_SEQUENCE_ID',
37830: p_instance_code => v_instance_code,
37831: p_severity => G_SEV_ERROR,

Line 37863: (p_table_name => 'MSC_ST_COMPONENT_SUBSTITUTES',

37859: lv_where_str :=
37860: ' AND NVL(effectivity_date,SYSDATE-36500 ) = SYSDATE-36500' ;
37861:
37862: lv_return := MSC_ST_UTIL.LOG_ERROR
37863: (p_table_name => 'MSC_ST_COMPONENT_SUBSTITUTES',
37864: p_instance_code => v_instance_code,
37865: p_row => lv_column_names,
37866: p_severity => G_SEV_WARNING,
37867: p_message_text => lv_message_text,

Line 37883: 'UPDATE msc_st_component_substitutes mcs'

37879: -- Now derive the component sequence id for the Unique key combination
37880: v_sql_stmt := 34;
37881:
37882: lv_sql_stmt :=
37883: 'UPDATE msc_st_component_substitutes mcs'
37884: ||' SET component_sequence_id= (SELECT local_id '
37885: ||' FROM msc_local_id_setup mlis'
37886: ||' WHERE mlis.char1 = mcs.sr_instance_code'
37887: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '

Line 37920: p_token_value3 => 'MSC_ST_COMPONENT_SUBSTITUTES');

37916: ||' ALETERNATE_BOM_DESIGNATOR,OPERATION_SEQ_CODE',
37917: p_token2 => 'MASTER_TABLE',
37918: p_token_value2 => 'MSC_ST_BOM_COMPONENTS',
37919: p_token3 => 'CHILD_TABLE',
37920: p_token_value3 => 'MSC_ST_COMPONENT_SUBSTITUTES');
37921:
37922:
37923: IF lv_return <> 0 THEN
37924: RAISE ex_logging_err;

Line 37929: 'UPDATE msc_st_component_substitutes '

37925: END IF;
37926:
37927: v_sql_stmt := 35;
37928: lv_sql_stmt:=
37929: 'UPDATE msc_st_component_substitutes '
37930: ||' SET process_flag ='|| G_ERROR_FLG||','
37931: ||' error_text ='||''''||lv_message_text||''''
37932: ||' WHERE NVL(component_sequence_id,'||NULL_VALUE||')='|| NULL_VALUE
37933: ||' AND sr_instance_code = :v_instance_code'

Line 37962: (p_table_name => 'MSC_ST_COMPONENT_SUBSTITUTES',

37958:
37959: lv_where_str := ' AND NVL(usage_quantity,'||NULL_VALUE||')='|| NULL_VALUE ;
37960:
37961: lv_return := MSC_ST_UTIL.LOG_ERROR
37962: (p_table_name => 'MSC_ST_COMPONENT_SUBSTITUTES',
37963: p_instance_code => v_instance_code,
37964: p_row => lv_column_names,
37965: p_severity => G_SEV_WARNING,
37966: p_message_text => lv_message_text,

Line 38000: (p_table_name => 'MSC_ST_COMPONENT_SUBSTITUTES',

37996:
37997: lv_where_str := ' AND NVL(priority,'||NULL_VALUE||')='|| NULL_VALUE ;
37998:
37999: lv_return := MSC_ST_UTIL.LOG_ERROR
38000: (p_table_name => 'MSC_ST_COMPONENT_SUBSTITUTES',
38001: p_instance_code => v_instance_code,
38002: p_row => lv_column_names,
38003: p_severity => G_SEV_WARNING,
38004: p_message_text => lv_message_text,

Line 38024: pEntityName => 'MSC_ST_COMPONENT_SUBSTITUTES',

38020: (ERRBUF => lv_error_text,
38021: RETCODE => lv_return,
38022: pBatchID => lv_batch_id,
38023: pInstanceCode => v_instance_code,
38024: pEntityName => 'MSC_ST_COMPONENT_SUBSTITUTES',
38025: pInstanceID => v_instance_id);
38026:
38027: IF NVL(lv_return,0) <> 0 THEN
38028: RAISE ex_logging_err;

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

38029: END IF;
38030:
38031: -- Set the process flag as Valid and poulate instance_id
38032: lv_return :=
38033: MSC_ST_UTIL.SET_PROCESS_FLAG(p_table_name => 'MSC_ST_COMPONENT_SUBSTITUTES',
38034: p_instance_id => v_instance_id,
38035: p_instance_code => v_instance_code,
38036: p_process_flag => G_VALID,
38037: p_error_text => lv_error_text,

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

38044:
38045: -- At the end calling the LOG_ERROR for logging all errored out records
38046:
38047: lv_return :=
38048: msc_st_util.log_error(p_table_name => 'MSC_ST_COMPONENT_SUBSTITUTES',
38049: p_instance_code => v_instance_code,
38050: p_row => lv_column_names,
38051: p_severity => G_SEV_ERROR,
38052: p_error_text => lv_error_text,

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

50914: End IF;
50915: END IF;
50916:
50917: IF v_bom_enabled = SYS_YES THEN
50918: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_COMPONENT_SUBSTITUTES');
50919: IF lv_count > 0 Then
50920: prec.bom_flag:= SYS_YES;
50921: End IF;
50922: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_BOM_COMPONENTS');