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_BOM_COMPONENTS

Line 746: ||' on MSC_ST_BOM_COMPONENTS '

742: application_short_name => 'MSC',
743: statement_type => AD_DDL.CREATE_INDEX,
744: statement =>
745: 'create index MSC_ST_BOM_COMP_N1_'||v_instance_code
746: ||' on MSC_ST_BOM_COMPONENTS '
747: ||'(sr_instance_code, assembly_name, component_name, effectivity_date, operation_seq_code, organization_code, company_name, bom_name, alternate_bom_designator) '
748: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
749: object_name =>'MSC_ST_BOM_COMP_N1_'||v_instance_code);
750: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_BOM_COMP_N1_'||v_instance_code);

Line 794: msc_analyse_tables_pk.analyse_table( 'MSC_ST_BOM_COMPONENTS', v_instance_id, -1);

790: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error creating Index MSC_ST_CO_PRODUCTS_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
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:

Line 35274: FROM msc_st_bom_components

35270: ex_logging_err EXCEPTION;
35271:
35272: CURSOR c1 IS
35273: SELECT rowid
35274: FROM msc_st_bom_components
35275: WHERE process_flag = G_IN_PROCESS
35276: AND sr_instance_code = v_instance_code
35277: AND NVL(component_sequence_id,NULL_VALUE) = NULL_VALUE
35278: AND deleted_flag = SYS_NO;

Line 35361: 'update MSC_ST_BOM_COMPONENTS x'

35357: -- for the set of products not including the actual component --
35358: v_sql_stmt := 03;
35359: lv_sql_stmt :=
35360:
35361: 'update MSC_ST_BOM_COMPONENTS x'
35362: || ' set x.primary_flag = 2'
35363: || ' where x.bill_Sequence_id='||l_bill_sequence_id_cur2
35364: || ' and x.primary_flag is null '
35365: || ' and nvl(x.component_type,0) != 10 ' -- component_type is 10 for co products

Line 35387: insert into MSC_ST_BOM_COMPONENTS

35383:
35384: EXIT WHEN cur3%NOTFOUND;
35385:
35386: v_sql_stmt := 05;
35387: insert into MSC_ST_BOM_COMPONENTS
35388: ( INVENTORY_ITEM_ID,
35389: BILL_SEQUENCE_ID,
35390: COMPONENT_TYPE,
35391: USAGE_QUANTITY,

Line 35443: FROM MSC_ST_BOM_COMPONENTS x

35439: v_instance_code,
35440: l_primary_flag_cur3,
35441: 3,
35442: 2
35443: FROM MSC_ST_BOM_COMPONENTS x
35444: WHERE x.bill_Sequence_id = l_bill_sequence_id_cur2
35445: AND x.sr_instance_id = v_instance_id
35446: AND rownum = 1; -- so that in the next loop only 1 record is inserted
35447:

Line 35503: 'UPDATE msc_st_bom_components mbc'

35499:
35500: v_sql_stmt := 08;
35501: -- Derive the component_sequence_id --
35502: lv_sql_stmt :=
35503: 'UPDATE msc_st_bom_components mbc'
35504: ||' SET component_sequence_id= (SELECT local_id '
35505: ||' FROM msc_local_id_setup mlis'
35506: ||' WHERE mlis.char1 = mbc.sr_instance_code'
35507: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '

Line 35535: UPDATE msc_st_bom_components

35531:
35532: IF c1%ROWCOUNT > 0 THEN
35533: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
35534:
35535: UPDATE msc_st_bom_components
35536: SET component_sequence_id = msc_st_component_sequence_id_s.NEXTVAL
35537: WHERE rowid = lb_rowid(j);
35538:
35539:

Line 35582: FROM msc_st_bom_components

35578: v_current_date,
35579: v_current_user,
35580: v_current_date,
35581: v_current_user
35582: FROM msc_st_bom_components
35583: WHERE rowid = lb_rowid(j) ;
35584:
35585: END IF;
35586: CLOSE c1;

Line 35592: MSC_ST_UTIL.SET_PROCESS_FLAG(p_table_name => 'MSC_ST_BOM_COMPONENTS',

35588: End Loop;
35589:
35590: -- Set the process flag as Valid and poulate instance_id
35591: lv_return :=
35592: MSC_ST_UTIL.SET_PROCESS_FLAG(p_table_name => 'MSC_ST_BOM_COMPONENTS',
35593: p_instance_id => v_instance_id,
35594: p_instance_code => v_instance_code,
35595: p_process_flag => G_VALID,
35596: p_error_text => lv_error_text,

Line 35655: FROM msc_st_bom_components

35651: AND deleted_flag = SYS_NO;
35652:
35653: CURSOR c4(p_batch_id NUMBER) IS
35654: SELECT rowid
35655: FROM msc_st_bom_components
35656: WHERE process_flag IN (G_IN_PROCESS,G_ERROR_FLG)
35657: AND sr_instance_code = v_instance_code
35658: AND batch_id = p_batch_id;
35659:

Line 35662: FROM msc_st_bom_components

35658: AND batch_id = p_batch_id;
35659:
35660: CURSOR c5(p_batch_id NUMBER) IS
35661: SELECT rowid
35662: FROM msc_st_bom_components
35663: WHERE process_flag = G_IN_PROCESS
35664: AND sr_instance_code = v_instance_code
35665: AND batch_id = p_batch_id
35666: AND NVL(component_sequence_id,NULL_VALUE) = NULL_VALUE

Line 35678: FROM msc_st_bom_components mbc, msc_local_id_setup mlis

35674: AND batch_id = p_batch_id;
35675:
35676: CURSOR c7(p_batch_id NUMBER) IS
35677: SELECT mlis.rowid
35678: FROM msc_st_bom_components mbc, msc_local_id_setup mlis
35679: WHERE mlis.char1 = mbc.sr_instance_code
35680: AND NVL(mlis.char2,'-23453') = NVL(mbc.company_name,'-23453')
35681: AND mlis.char3 = mbc.organization_code
35682: AND mlis.char4 = mbc.bom_name

Line 36300: -- Now Validation for MSC_ST_BOM_COMPONENTS

36296: COMMIT;
36297: END LOOP;
36298:
36299:
36300: -- Now Validation for MSC_ST_BOM_COMPONENTS
36301:
36302: --Duplicate records check for the records whose source is XML
36303:
36304: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE

Line 36317: 'UPDATE msc_st_bom_components mbc1'

36313:
36314: v_sql_stmt := 11;
36315:
36316: lv_sql_stmt :=
36317: 'UPDATE msc_st_bom_components mbc1'
36318: ||' SET process_flag = '||G_ERROR_FLG ||','
36319: ||' error_text = '||''''||lv_message_text||''''
36320: ||' WHERE message_id < ( SELECT max(message_id)'
36321: ||' FROM msc_st_bom_components mbc2'

Line 36321: ||' FROM msc_st_bom_components mbc2'

36317: 'UPDATE msc_st_bom_components mbc1'
36318: ||' SET process_flag = '||G_ERROR_FLG ||','
36319: ||' error_text = '||''''||lv_message_text||''''
36320: ||' WHERE message_id < ( SELECT max(message_id)'
36321: ||' FROM msc_st_bom_components mbc2'
36322: ||' WHERE mbc2.sr_instance_code = mbc1.sr_instance_code'
36323: ||' AND mbc2.organization_code = mbc1.organization_code'
36324: ||' AND NVL(mbc2.bom_name,'||''''||NULL_CHAR||''''||') '
36325: ||' = NVL(mbc1.bom_name, '||''''||NULL_CHAR||''''||') '

Line 36361: 'UPDATE msc_st_bom_components mbc1'

36357: END IF;
36358:
36359: v_sql_stmt := 12;
36360: lv_sql_stmt:=
36361: 'UPDATE msc_st_bom_components mbc1'
36362: ||' SET process_flag ='|| G_ERROR_FLG||','
36363: ||' error_text = '||''''||lv_message_text||''''
36364: ||' WHERE EXISTS ( SELECT 1'
36365: ||' FROM msc_st_bom_components mbc2'

Line 36365: ||' FROM msc_st_bom_components mbc2'

36361: 'UPDATE msc_st_bom_components mbc1'
36362: ||' SET process_flag ='|| G_ERROR_FLG||','
36363: ||' error_text = '||''''||lv_message_text||''''
36364: ||' WHERE EXISTS ( SELECT 1'
36365: ||' FROM msc_st_bom_components mbc2'
36366: ||' WHERE mbc2.sr_instance_code = mbc1.sr_instance_code'
36367: ||' AND mbc2.organization_code = mbc1.organization_code'
36368: ||' AND NVL(mbc2.bom_name,'||''''||NULL_CHAR||''''||') '
36369: ||' = NVL(mbc1.bom_name, '||''''||NULL_CHAR||''''||') '

Line 36420: -- Process msc_st_bom_components table

36416: ||'DRIVING_ITEM_NAME ||''~''||'
36417: ||'COMPANY_NAME' ;
36418:
36419:
36420: -- Process msc_st_bom_components table
36421:
36422: LOOP
36423: v_sql_stmt := 13;
36424: lv_cursor_stmt :=

Line 36434: ' UPDATE msc_st_bom_components '

36430: CLOSE c1;
36431:
36432: v_sql_stmt := 14;
36433: lv_sql_stmt :=
36434: ' UPDATE msc_st_bom_components '
36435: ||' SET batch_id = :lv_batch_id'
36436: ||' WHERE process_flag IN ('||G_IN_PROCESS||','||G_ERROR_FLG||')'
36437: ||' AND sr_instance_code = :v_instance_code'
36438: ||' AND NVL(batch_id,'||NULL_VALUE||') = '||NULL_VALUE

Line 36454: UPDATE msc_st_bom_components

36450: CLOSE c4;
36451:
36452: v_sql_stmt := 1;
36453: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
36454: UPDATE msc_st_bom_components
36455: SET st_transaction_id = msc_st_bom_components_s.NEXTVAL,
36456: refresh_id = v_refresh_id,
36457: last_update_date = v_current_date,
36458: last_updated_by = v_current_user,

Line 36455: SET st_transaction_id = msc_st_bom_components_s.NEXTVAL,

36451:
36452: v_sql_stmt := 1;
36453: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
36454: UPDATE msc_st_bom_components
36455: SET st_transaction_id = msc_st_bom_components_s.NEXTVAL,
36456: refresh_id = v_refresh_id,
36457: last_update_date = v_current_date,
36458: last_updated_by = v_current_user,
36459: creation_date = v_current_date,

Line 36480: MSC_ST_UTIL.DERIVE_ITEM_ID(p_table_name => 'MSC_ST_BOM_COMPONENTS',

36476:
36477: -- Populate Inventory Item id for component name
36478:
36479: lv_return :=
36480: MSC_ST_UTIL.DERIVE_ITEM_ID(p_table_name => 'MSC_ST_BOM_COMPONENTS',
36481: p_item_col_name => 'COMPONENT_NAME',
36482: p_item_col_id => 'INVENTORY_ITEM_ID',
36483: p_instance_code => v_instance_code,
36484: p_instance_id => v_instance_id,

Line 36515: (p_table_name => 'MSC_ST_BOM_COMPONENTS',

36511:
36512: lv_where_str := ' AND NVL(deleted_flag,'||NULL_VALUE||')NOT IN (1,2)';
36513:
36514: lv_return := MSC_ST_UTIL.LOG_ERROR
36515: (p_table_name => 'MSC_ST_BOM_COMPONENTS',
36516: p_instance_code => v_instance_code,
36517: p_row => lv_column_names,
36518: p_severity => G_SEV_WARNING,
36519: p_message_text => lv_message_text,

Line 36549: MSC_ST_UTIL.DERIVE_PARTNER_ORG_ID(p_table_name => 'MSC_ST_BOM_COMPONENTS',

36545:
36546: -- Populate organization id
36547:
36548: lv_return :=
36549: MSC_ST_UTIL.DERIVE_PARTNER_ORG_ID(p_table_name => 'MSC_ST_BOM_COMPONENTS',
36550: p_org_partner_name =>'ORGANIZATION_CODE',
36551: p_org_partner_id =>'ORGANIZATION_ID',
36552: p_instance_code => v_instance_code,
36553: p_partner_type => G_ORGANIZATION,

Line 36572: 'UPDATE msc_st_bom_components '

36568: v_sql_stmt := 17;
36569:
36570: lv_sql_stmt :=
36571:
36572: 'UPDATE msc_st_bom_components '
36573: ||' SET bom_name = assembly_name'
36574: ||' WHERE sr_instance_code = :v_instance_code'
36575: ||' AND process_flag ='||G_IN_PROCESS
36576: ||' AND NVL(bom_name,'||''''||NULL_CHAR||''''||') '

Line 36595: 'UPDATE msc_st_bom_components mbc'

36591:
36592: v_sql_stmt := 18;
36593:
36594: lv_sql_stmt:=
36595: 'UPDATE msc_st_bom_components mbc'
36596: ||' SET assembly_name = (SELECT char5'
36597: ||' FROM msc_local_id_setup mlis'
36598: ||' WHERE mlis.char1 = mbc.sr_instance_code'
36599: ||' AND mlis.char3 = mbc.organization_code'

Line 36633: p_token_value3 => 'MSC_ST_BOM_COMPONENTS');

36629: ||'ALETERNATE_BOM_DESIGNATOR',
36630: p_token2 => 'MASTER_TABLE',
36631: p_token_value2 => 'MSC_ST_BOMS',
36632: p_token3 => 'CHILD_TABLE',
36633: p_token_value3 => 'MSC_ST_BOM_COMPONENTS');
36634:
36635: IF lv_return <> 0 THEN
36636: RAISE ex_logging_err;
36637: END IF;

Line 36644: 'UPDATE MSC_ST_BOM_COMPONENTS'

36640:
36641: v_sql_stmt := 19;
36642:
36643: lv_sql_stmt :=
36644: 'UPDATE MSC_ST_BOM_COMPONENTS'
36645: ||' SET process_flag = '||G_ERROR_FLG||','
36646: ||' error_text = '||''''||lv_message_text||''''
36647: ||' WHERE NVL(assembly_name,'||''''||NULL_CHAR||''''||') '
36648: ||' = '||''''||NULL_CHAR||''''

Line 36672: p_token_value3 => 'MSC_ST_BOM_COMPONENTS');

36668: ||'ALETERNATE_BOM_DESIGNATOR',
36669: p_token2 => 'MASTER_TABLE',
36670: p_token_value2 => 'MSC_ST_BOMS',
36671: p_token3 => 'CHILD_TABLE',
36672: p_token_value3 => 'MSC_ST_BOM_COMPONENTS');
36673:
36674: IF lv_return <> 0 THEN
36675: RAISE ex_logging_err;
36676: END IF;

Line 36679: -- Derive the Bill Sequence Id for the MSC_ST_BOM_COMPONENTS

36675: RAISE ex_logging_err;
36676: END IF;
36677:
36678:
36679: -- Derive the Bill Sequence Id for the MSC_ST_BOM_COMPONENTS
36680: lv_return :=
36681: MSC_ST_UTIL.DERIVE_BILL_SEQUENCE_ID
36682: (p_table_name => 'MSC_ST_BOM_COMPONENTS',
36683: p_bom_col_name => 'BOM_NAME',

Line 36682: (p_table_name => 'MSC_ST_BOM_COMPONENTS',

36678:
36679: -- Derive the Bill Sequence Id for the MSC_ST_BOM_COMPONENTS
36680: lv_return :=
36681: MSC_ST_UTIL.DERIVE_BILL_SEQUENCE_ID
36682: (p_table_name => 'MSC_ST_BOM_COMPONENTS',
36683: p_bom_col_name => 'BOM_NAME',
36684: p_bom_col_id => 'BILL_SEQUENCE_ID',
36685: p_instance_code => v_instance_code,
36686: p_severity => G_SEV_ERROR,

Line 36717: (p_table_name => 'MSC_ST_BOM_COMPONENTS',

36713: ' AND NVL(operation_seq_code,'||''''||NULL_CHAR||''''||') '
36714: ||' = '||''''||NULL_CHAR||'''' ;
36715:
36716: lv_return := MSC_ST_UTIL.LOG_ERROR
36717: (p_table_name => 'MSC_ST_BOM_COMPONENTS',
36718: p_instance_code => v_instance_code,
36719: p_row => lv_column_names,
36720: p_severity => G_SEV_WARNING,
36721: p_message_text => lv_message_text,

Line 36756: (p_table_name => 'MSC_ST_BOM_COMPONENTS',

36752: lv_where_str :=
36753: ' AND NVL(effectivity_date,SYSDATE-36500 ) = SYSDATE-36500' ;
36754:
36755: lv_return := MSC_ST_UTIL.LOG_ERROR
36756: (p_table_name => 'MSC_ST_BOM_COMPONENTS',
36757: p_instance_code => v_instance_code,
36758: p_row => lv_column_names,
36759: p_severity => G_SEV_WARNING,
36760: p_message_text => lv_message_text,

Line 36776: 'UPDATE msc_st_bom_components mbc'

36772:
36773: -- Derive the component_sequence_id
36774: v_sql_stmt := 20;
36775: lv_sql_stmt :=
36776: 'UPDATE msc_st_bom_components mbc'
36777: ||' SET component_sequence_id= (SELECT local_id '
36778: ||' FROM msc_local_id_setup mlis'
36779: ||' WHERE mlis.char1 = mbc.sr_instance_code'
36780: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '

Line 36818: 'UPDATE msc_st_bom_components '

36814:
36815: v_sql_stmt := 21;
36816:
36817: lv_sql_stmt:=
36818: 'UPDATE msc_st_bom_components '
36819: ||' SET process_flag ='|| G_ERROR_FLG||','
36820: ||' error_text = '||''''||lv_message_text||''''
36821: ||' WHERE NVL(component_sequence_id,'||NULL_VALUE||')='|| NULL_VALUE
36822: ||' AND deleted_flag ='|| SYS_YES

Line 36850: 'UPDATE msc_st_bom_components mbc'

36846: -- Now we are checking the overlapping of effectivity date of components
36847: v_sql_stmt := 22;
36848:
36849: lv_sql_stmt:=
36850: 'UPDATE msc_st_bom_components mbc'
36851: ||' SET process_flag = '||G_ERROR_FLG||','
36852: ||' error_text = '||''''||lv_message_text||''''
36853: ||' WHERE EXISTS (SELECT 1 FROM'
36854: ||' msc_local_id_setup mlis'

Line 36909: MSC_ST_UTIL.DERIVE_ITEM_ID(p_table_name =>'MSC_ST_BOM_COMPONENTS',

36905:
36906: -- Populate the using_assembly_id from assembly name
36907:
36908: lv_return :=
36909: MSC_ST_UTIL.DERIVE_ITEM_ID(p_table_name =>'MSC_ST_BOM_COMPONENTS',
36910: p_item_col_name => 'ASSEMBLY_NAME',
36911: p_item_col_id =>'USING_ASSEMBLY_ID',
36912: p_instance_code => v_instance_code,
36913: p_instance_id => v_instance_id,

Line 36946: (p_table_name => 'MSC_ST_BOM_COMPONENTS',

36942: lv_where_str :=
36943: ' AND NVL(usage_quantity,'||NULL_VALUE||')='|| NULL_VALUE ;
36944:
36945: lv_return := MSC_ST_UTIL.LOG_ERROR
36946: (p_table_name => 'MSC_ST_BOM_COMPONENTS',
36947: p_instance_code => v_instance_code,
36948: p_row => lv_column_names,
36949: p_severity => G_SEV_WARNING,
36950: p_message_text => lv_message_text,

Line 36982: ' UPDATE msc_st_bom_components mbc'

36978: -- If UOM is provided validate the UOM_CODE
36979: v_sql_stmt := 23;
36980:
36981: lv_sql_stmt :=
36982: ' UPDATE msc_st_bom_components mbc'
36983: ||' SET process_flag = '||G_ERROR_FLG||','
36984: ||' error_text = '||''''||lv_message_text||''''
36985: ||' WHERE NOT EXISTS (SELECT 1'
36986: ||' FROM msc_units_of_measure muom'

Line 37027: (p_table_name => 'MSC_ST_BOM_COMPONENTS',

37023: lv_where_str :=
37024: ' AND NVL(component_yield_factor,'||NULL_VALUE||')= '||NULL_VALUE ;
37025:
37026: lv_return := MSC_ST_UTIL.LOG_ERROR
37027: (p_table_name => 'MSC_ST_BOM_COMPONENTS',
37028: p_instance_code => v_instance_code,
37029: p_row => lv_column_names,
37030: p_severity => G_SEV_WARNING,
37031: p_message_text => lv_message_text,

Line 37060: MSC_ST_UTIL.DERIVE_ITEM_ID(p_table_name => 'MSC_ST_BOM_COMPONENTS',

37056:
37057: --Derive driving item id
37058:
37059: lv_return :=
37060: MSC_ST_UTIL.DERIVE_ITEM_ID(p_table_name => 'MSC_ST_BOM_COMPONENTS',
37061: p_item_col_name => 'DRIVING_ITEM_NAME',
37062: p_item_col_id => 'DRIVING_ITEM_ID',
37063: p_instance_code => v_instance_code,
37064: p_instance_id => v_instance_id,

Line 37095: (p_table_name => 'MSC_ST_BOM_COMPONENTS',

37091:
37092: lv_where_str := ' AND use_up_code NOT IN (1,2)';
37093:
37094: lv_return := MSC_ST_UTIL.LOG_ERROR
37095: (p_table_name => 'MSC_ST_BOM_COMPONENTS',
37096: p_instance_code => v_instance_code,
37097: p_row => lv_column_names,
37098: p_severity => G_SEV_WARNING,
37099: p_message_text => lv_message_text,

Line 37131: (p_table_name => 'MSC_ST_BOM_COMPONENTS',

37127:
37128: lv_where_str := ' AND optional_component NOT IN (1,2)';
37129:
37130: lv_return := MSC_ST_UTIL.LOG_ERROR
37131: (p_table_name => 'MSC_ST_BOM_COMPONENTS',
37132: p_instance_code => v_instance_code,
37133: p_row => lv_column_names,
37134: p_severity => G_SEV_WARNING,
37135: p_message_text => lv_message_text,

Line 37168: MSC_ST_UTIL.LOG_ERROR (p_table_name => 'MSC_ST_BOM_COMPONENTS',

37164: lv_where_str :=
37165: ' AND NVL(wip_supply_type,'||NULL_VALUE||') NOT IN (1,2,3,4,5,6,7)';
37166:
37167: lv_return :=
37168: MSC_ST_UTIL.LOG_ERROR (p_table_name => 'MSC_ST_BOM_COMPONENTS',
37169: p_instance_code => v_instance_code,
37170: p_row => lv_column_names,
37171: p_severity => G_SEV_WARNING,
37172: p_message_text => lv_message_text,

Line 37207: (p_table_name => 'MSC_ST_BOM_COMPONENTS',

37203: lv_where_str :=
37204: ' AND NVL(component_type,'||NULL_VALUE||') NOT IN (-1,1,2)';
37205:
37206: lv_return := MSC_ST_UTIL.LOG_ERROR
37207: (p_table_name => 'MSC_ST_BOM_COMPONENTS',
37208: p_instance_code => v_instance_code,
37209: p_row => lv_column_names,
37210: p_severity => G_SEV_WARNING,
37211: p_message_text => lv_message_text,

Line 37245: (p_table_name => 'MSC_ST_BOM_COMPONENTS',

37241: lv_where_str :=
37242: ' AND NVL(atp_flag,'||NULL_VALUE||')NOT IN (1,2)';
37243:
37244: lv_return := MSC_ST_UTIL.LOG_ERROR
37245: (p_table_name => 'MSC_ST_BOM_COMPONENTS',
37246: p_instance_code => v_instance_code,
37247: p_row => lv_column_names,
37248: p_severity => G_SEV_WARNING,
37249: p_message_text => lv_message_text,

Line 37268: pEntityName => 'MSC_ST_BOM_COMPONENTS',

37264: (ERRBUF => lv_error_text,
37265: RETCODE => lv_return,
37266: pBatchID => lv_batch_id,
37267: pInstanceCode => v_instance_code,
37268: pEntityName => 'MSC_ST_BOM_COMPONENTS',
37269: pInstanceID => v_instance_id);
37270:
37271: IF NVL(lv_return,0) <> 0 THEN
37272: RAISE ex_logging_err;

Line 37278: 'UPDATE MSC_ST_BOM_COMPONENTS'

37274:
37275: v_sql_stmt := 23.1;
37276:
37277: lv_sql_stmt :=
37278: 'UPDATE MSC_ST_BOM_COMPONENTS'
37279: ||' SET usage_quantity = ( usage_quantity / decode(component_yield_factor,0,1,abs(component_yield_factor)) )* nvl(planning_factor,100)/100'
37280: ||' WHERE process_flag = '||G_IN_PROCESS
37281: ||' AND sr_instance_code = :v_instance_code'
37282: ||' AND batch_id = :lv_batch_id';

Line 37301: UPDATE msc_st_bom_components

37297: IF c5%ROWCOUNT > 0 THEN
37298:
37299: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
37300:
37301: UPDATE msc_st_bom_components
37302: SET component_sequence_id = msc_st_component_sequence_id_s.NEXTVAL
37303: WHERE rowid = lb_rowid(j);
37304:
37305: v_sql_stmt := 23;

Line 37361: FROM msc_st_bom_components

37357: v_current_date,
37358: v_current_user,
37359: v_current_date,
37360: v_current_user
37361: FROM msc_st_bom_components
37362: WHERE rowid = lb_rowid(j) ;
37363:
37364: END IF;
37365: CLOSE c5;

Line 37374: ||' WHERE EXISTS ( SELECT 1 FROM msc_st_bom_components mbc'

37370: /*
37371: lv_sql_stmt :=
37372: 'UPDATE msc_local_id_setup mlis'
37373: ||' SET date2 = SYSDATE'
37374: ||' WHERE EXISTS ( SELECT 1 FROM msc_st_bom_components mbc'
37375: ||' WHERE mlis.char1 = mbc.sr_instance_code'
37376: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '
37377: ||' = NVL(mbc.company_name,'||''''||NULL_CHAR||''''||') '
37378: ||' AND mlis.char3 = mbc.organization_code'

Line 37411: MSC_ST_UTIL.SET_PROCESS_FLAG(p_table_name => 'MSC_ST_BOM_COMPONENTS',

37407: CLOSE c7;
37408:
37409: -- Set the process flag as Valid and poulate instance_id
37410: lv_return :=
37411: MSC_ST_UTIL.SET_PROCESS_FLAG(p_table_name => 'MSC_ST_BOM_COMPONENTS',
37412: p_instance_id => v_instance_id,
37413: p_instance_code => v_instance_code,
37414: p_process_flag => G_VALID,
37415: p_error_text => lv_error_text,

Line 37426: msc_st_util.log_error(p_table_name =>'MSC_ST_BOM_COMPONENTS',

37422:
37423: -- At the end calling the LOG_ERROR for logging all errored out records
37424:
37425: lv_return :=
37426: msc_st_util.log_error(p_table_name =>'MSC_ST_BOM_COMPONENTS',
37427: p_instance_code =>v_instance_code,
37428: p_row =>lv_column_names,
37429: p_severity =>G_SEV_ERROR,
37430: p_message_text => NULL,

Line 37918: p_token_value2 => 'MSC_ST_BOM_COMPONENTS',

37914: p_token_value1 => 'BOM_NAME,SR_INSTANCE_CODE,EFFECTIVITY_DATE'
37915: ||' COMPANY_NAME,COMPONENT_NAME'
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:

Line 38644: -- Now Updating the tables MSC_ST_BOMS and MSC_ST_BOM_COMPONENTS.

38640: RAISe ex_logging_err;
38641: END IF;
38642:
38643: COMMIT;
38644: -- Now Updating the tables MSC_ST_BOMS and MSC_ST_BOM_COMPONENTS.
38645:
38646: LOAD_CO_PRODUCT_BOMS;
38647:
38648:

Line 40420: ||' msc_st_bom_components msbc,'

40416: ||' msro.creation_date,'
40417: ||' msro.created_by,'
40418: ||' msro.REFRESH_ID'
40419: ||' FROM msc_st_routing_operations msro,'
40420: ||' msc_st_bom_components msbc,'
40421: ||' msc_local_id_setup mlis'
40422: ||' WHERE msbc.bill_sequence_id = mlis.number1'
40423: ||' AND mlis.entity_name = ''ROUTING_SEQUENCE_ID'' '
40424: ||' AND mlis.local_id = msro.routing_sequence_id'

Line 50922: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_BOM_COMPONENTS');

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');
50923: IF lv_count > 0 Then
50924: prec.bom_flag:= SYS_YES;
50925: End IF;
50926: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_BOMS');