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 754: ||' on MSC_ST_BOM_COMPONENTS '

750: application_short_name => 'MSC',
751: statement_type => AD_DDL.CREATE_INDEX,
752: statement =>
753: 'create index MSC_ST_BOM_COMP_N1_'||v_instance_code
754: ||' on MSC_ST_BOM_COMPONENTS '
755: ||'(sr_instance_code, assembly_name, component_name, effectivity_date, operation_seq_code, organization_code, company_name, bom_name, alternate_bom_designator) '
756: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
757: object_name =>'MSC_ST_BOM_COMP_N1_'||v_instance_code);
758: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_BOM_COMP_N1_'||v_instance_code);

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

798: 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));
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:

Line 40058: FROM msc_st_bom_components

40054: ex_logging_err EXCEPTION;
40055:
40056: CURSOR c1 IS
40057: SELECT rowid
40058: FROM msc_st_bom_components
40059: WHERE process_flag = G_IN_PROCESS
40060: AND sr_instance_code = v_instance_code
40061: AND NVL(component_sequence_id,NULL_VALUE) = NULL_VALUE
40062: AND deleted_flag = SYS_NO;

Line 40145: 'update MSC_ST_BOM_COMPONENTS x'

40141: -- for the set of products not including the actual component --
40142: v_sql_stmt := 03;
40143: lv_sql_stmt :=
40144:
40145: 'update MSC_ST_BOM_COMPONENTS x'
40146: || ' set x.primary_flag = 2'
40147: || ' where x.bill_Sequence_id='||l_bill_sequence_id_cur2
40148: || ' and x.primary_flag is null '
40149: || ' and nvl(x.component_type,0) != 10 ' -- component_type is 10 for co products

Line 40171: insert into MSC_ST_BOM_COMPONENTS

40167:
40168: EXIT WHEN cur3%NOTFOUND;
40169:
40170: v_sql_stmt := 05;
40171: insert into MSC_ST_BOM_COMPONENTS
40172: ( INVENTORY_ITEM_ID,
40173: BILL_SEQUENCE_ID,
40174: COMPONENT_TYPE,
40175: USAGE_QUANTITY,

Line 40227: FROM MSC_ST_BOM_COMPONENTS x

40223: v_instance_code,
40224: l_primary_flag_cur3,
40225: 3,
40226: 2
40227: FROM MSC_ST_BOM_COMPONENTS x
40228: WHERE x.bill_Sequence_id = l_bill_sequence_id_cur2
40229: AND x.sr_instance_id = v_instance_id
40230: AND rownum = 1; -- so that in the next loop only 1 record is inserted
40231:

Line 40287: 'UPDATE msc_st_bom_components mbc'

40283:
40284: v_sql_stmt := 08;
40285: -- Derive the component_sequence_id --
40286: lv_sql_stmt :=
40287: 'UPDATE msc_st_bom_components mbc'
40288: ||' SET component_sequence_id= (SELECT local_id '
40289: ||' FROM msc_local_id_setup mlis'
40290: ||' WHERE mlis.char1 = mbc.sr_instance_code'
40291: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '

Line 40319: UPDATE msc_st_bom_components

40315:
40316: IF c1%ROWCOUNT > 0 THEN
40317: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
40318:
40319: UPDATE msc_st_bom_components
40320: SET component_sequence_id = msc_st_component_sequence_id_s.NEXTVAL
40321: WHERE rowid = lb_rowid(j);
40322:
40323:

Line 40366: FROM msc_st_bom_components

40362: v_current_date,
40363: v_current_user,
40364: v_current_date,
40365: v_current_user
40366: FROM msc_st_bom_components
40367: WHERE rowid = lb_rowid(j) ;
40368:
40369: END IF;
40370: CLOSE c1;

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

40372: End Loop;
40373:
40374: -- Set the process flag as Valid and poulate instance_id
40375: lv_return :=
40376: MSC_ST_UTIL.SET_PROCESS_FLAG(p_table_name => 'MSC_ST_BOM_COMPONENTS',
40377: p_instance_id => v_instance_id,
40378: p_instance_code => v_instance_code,
40379: p_process_flag => G_VALID,
40380: p_error_text => lv_error_text,

Line 40439: FROM msc_st_bom_components

40435: AND deleted_flag = SYS_NO;
40436:
40437: CURSOR c4(p_batch_id NUMBER) IS
40438: SELECT rowid
40439: FROM msc_st_bom_components
40440: WHERE process_flag IN (G_IN_PROCESS,G_ERROR_FLG)
40441: AND sr_instance_code = v_instance_code
40442: AND batch_id = p_batch_id;
40443:

Line 40446: FROM msc_st_bom_components

40442: AND batch_id = p_batch_id;
40443:
40444: CURSOR c5(p_batch_id NUMBER) IS
40445: SELECT rowid
40446: FROM msc_st_bom_components
40447: WHERE process_flag = G_IN_PROCESS
40448: AND sr_instance_code = v_instance_code
40449: AND batch_id = p_batch_id
40450: AND NVL(component_sequence_id,NULL_VALUE) = NULL_VALUE

Line 40462: FROM msc_st_bom_components mbc, msc_local_id_setup mlis

40458: AND batch_id = p_batch_id;
40459:
40460: CURSOR c7(p_batch_id NUMBER) IS
40461: SELECT mlis.rowid
40462: FROM msc_st_bom_components mbc, msc_local_id_setup mlis
40463: WHERE mlis.char1 = mbc.sr_instance_code
40464: AND NVL(mlis.char2,'-23453') = NVL(mbc.company_name,'-23453')
40465: AND mlis.char3 = mbc.organization_code
40466: AND mlis.char4 = mbc.bom_name

Line 41084: -- Now Validation for MSC_ST_BOM_COMPONENTS

41080: COMMIT;
41081: END LOOP;
41082:
41083:
41084: -- Now Validation for MSC_ST_BOM_COMPONENTS
41085:
41086: --Duplicate records check for the records whose source is XML
41087:
41088: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE

Line 41101: 'UPDATE msc_st_bom_components mbc1'

41097:
41098: v_sql_stmt := 11;
41099:
41100: lv_sql_stmt :=
41101: 'UPDATE msc_st_bom_components mbc1'
41102: ||' SET process_flag = '||G_ERROR_FLG ||','
41103: ||' error_text = '||''''||lv_message_text||''''
41104: ||' WHERE message_id < ( SELECT max(message_id)'
41105: ||' FROM msc_st_bom_components mbc2'

Line 41105: ||' FROM msc_st_bom_components mbc2'

41101: 'UPDATE msc_st_bom_components mbc1'
41102: ||' SET process_flag = '||G_ERROR_FLG ||','
41103: ||' error_text = '||''''||lv_message_text||''''
41104: ||' WHERE message_id < ( SELECT max(message_id)'
41105: ||' FROM msc_st_bom_components mbc2'
41106: ||' WHERE mbc2.sr_instance_code = mbc1.sr_instance_code'
41107: ||' AND mbc2.organization_code = mbc1.organization_code'
41108: ||' AND NVL(mbc2.bom_name,'||''''||NULL_CHAR||''''||') '
41109: ||' = NVL(mbc1.bom_name, '||''''||NULL_CHAR||''''||') '

Line 41145: 'UPDATE msc_st_bom_components mbc1'

41141: END IF;
41142:
41143: v_sql_stmt := 12;
41144: lv_sql_stmt:=
41145: 'UPDATE msc_st_bom_components mbc1'
41146: ||' SET process_flag ='|| G_ERROR_FLG||','
41147: ||' error_text = '||''''||lv_message_text||''''
41148: ||' WHERE EXISTS ( SELECT 1'
41149: ||' FROM msc_st_bom_components mbc2'

Line 41149: ||' FROM msc_st_bom_components mbc2'

41145: 'UPDATE msc_st_bom_components mbc1'
41146: ||' SET process_flag ='|| G_ERROR_FLG||','
41147: ||' error_text = '||''''||lv_message_text||''''
41148: ||' WHERE EXISTS ( SELECT 1'
41149: ||' FROM msc_st_bom_components mbc2'
41150: ||' WHERE mbc2.sr_instance_code = mbc1.sr_instance_code'
41151: ||' AND mbc2.organization_code = mbc1.organization_code'
41152: ||' AND NVL(mbc2.bom_name,'||''''||NULL_CHAR||''''||') '
41153: ||' = NVL(mbc1.bom_name, '||''''||NULL_CHAR||''''||') '

Line 41204: -- Process msc_st_bom_components table

41200: ||'DRIVING_ITEM_NAME ||''~''||'
41201: ||'COMPANY_NAME' ;
41202:
41203:
41204: -- Process msc_st_bom_components table
41205:
41206: LOOP
41207: v_sql_stmt := 13;
41208: lv_cursor_stmt :=

Line 41218: ' UPDATE msc_st_bom_components '

41214: CLOSE c1;
41215:
41216: v_sql_stmt := 14;
41217: lv_sql_stmt :=
41218: ' UPDATE msc_st_bom_components '
41219: ||' SET batch_id = :lv_batch_id'
41220: ||' WHERE process_flag IN ('||G_IN_PROCESS||','||G_ERROR_FLG||')'
41221: ||' AND sr_instance_code = :v_instance_code'
41222: ||' AND NVL(batch_id,'||NULL_VALUE||') = '||NULL_VALUE

Line 41238: UPDATE msc_st_bom_components

41234: CLOSE c4;
41235:
41236: v_sql_stmt := 1;
41237: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
41238: UPDATE msc_st_bom_components
41239: SET st_transaction_id = msc_st_bom_components_s.NEXTVAL,
41240: refresh_id = v_refresh_id,
41241: last_update_date = v_current_date,
41242: last_updated_by = v_current_user,

Line 41239: SET st_transaction_id = msc_st_bom_components_s.NEXTVAL,

41235:
41236: v_sql_stmt := 1;
41237: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
41238: UPDATE msc_st_bom_components
41239: SET st_transaction_id = msc_st_bom_components_s.NEXTVAL,
41240: refresh_id = v_refresh_id,
41241: last_update_date = v_current_date,
41242: last_updated_by = v_current_user,
41243: creation_date = v_current_date,

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

41260:
41261: -- Populate Inventory Item id for component name
41262:
41263: lv_return :=
41264: MSC_ST_UTIL.DERIVE_ITEM_ID(p_table_name => 'MSC_ST_BOM_COMPONENTS',
41265: p_item_col_name => 'COMPONENT_NAME',
41266: p_item_col_id => 'INVENTORY_ITEM_ID',
41267: p_instance_code => v_instance_code,
41268: p_instance_id => v_instance_id,

Line 41299: (p_table_name => 'MSC_ST_BOM_COMPONENTS',

41295:
41296: lv_where_str := ' AND NVL(deleted_flag,'||NULL_VALUE||')NOT IN (1,2)';
41297:
41298: lv_return := MSC_ST_UTIL.LOG_ERROR
41299: (p_table_name => 'MSC_ST_BOM_COMPONENTS',
41300: p_instance_code => v_instance_code,
41301: p_row => lv_column_names,
41302: p_severity => G_SEV_WARNING,
41303: p_message_text => lv_message_text,

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

41329:
41330: -- Populate organization id
41331:
41332: lv_return :=
41333: MSC_ST_UTIL.DERIVE_PARTNER_ORG_ID(p_table_name => 'MSC_ST_BOM_COMPONENTS',
41334: p_org_partner_name =>'ORGANIZATION_CODE',
41335: p_org_partner_id =>'ORGANIZATION_ID',
41336: p_instance_code => v_instance_code,
41337: p_partner_type => G_ORGANIZATION,

Line 41356: 'UPDATE msc_st_bom_components '

41352: v_sql_stmt := 17;
41353:
41354: lv_sql_stmt :=
41355:
41356: 'UPDATE msc_st_bom_components '
41357: ||' SET bom_name = assembly_name'
41358: ||' WHERE sr_instance_code = :v_instance_code'
41359: ||' AND process_flag ='||G_IN_PROCESS
41360: ||' AND NVL(bom_name,'||''''||NULL_CHAR||''''||') '

Line 41379: 'UPDATE msc_st_bom_components mbc'

41375:
41376: v_sql_stmt := 18;
41377:
41378: lv_sql_stmt:=
41379: 'UPDATE msc_st_bom_components mbc'
41380: ||' SET assembly_name = (SELECT char5'
41381: ||' FROM msc_local_id_setup mlis'
41382: ||' WHERE mlis.char1 = mbc.sr_instance_code'
41383: ||' AND mlis.char3 = mbc.organization_code'

Line 41417: p_token_value3 => 'MSC_ST_BOM_COMPONENTS');

41413: ||'ALETERNATE_BOM_DESIGNATOR',
41414: p_token2 => 'MASTER_TABLE',
41415: p_token_value2 => 'MSC_ST_BOMS',
41416: p_token3 => 'CHILD_TABLE',
41417: p_token_value3 => 'MSC_ST_BOM_COMPONENTS');
41418:
41419: IF lv_return <> 0 THEN
41420: RAISE ex_logging_err;
41421: END IF;

Line 41428: 'UPDATE MSC_ST_BOM_COMPONENTS'

41424:
41425: v_sql_stmt := 19;
41426:
41427: lv_sql_stmt :=
41428: 'UPDATE MSC_ST_BOM_COMPONENTS'
41429: ||' SET process_flag = '||G_ERROR_FLG||','
41430: ||' error_text = '||''''||lv_message_text||''''
41431: ||' WHERE NVL(assembly_name,'||''''||NULL_CHAR||''''||') '
41432: ||' = '||''''||NULL_CHAR||''''

Line 41456: p_token_value3 => 'MSC_ST_BOM_COMPONENTS');

41452: ||'ALETERNATE_BOM_DESIGNATOR',
41453: p_token2 => 'MASTER_TABLE',
41454: p_token_value2 => 'MSC_ST_BOMS',
41455: p_token3 => 'CHILD_TABLE',
41456: p_token_value3 => 'MSC_ST_BOM_COMPONENTS');
41457:
41458: IF lv_return <> 0 THEN
41459: RAISE ex_logging_err;
41460: END IF;

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

41459: RAISE ex_logging_err;
41460: END IF;
41461:
41462:
41463: -- Derive the Bill Sequence Id for the MSC_ST_BOM_COMPONENTS
41464: lv_return :=
41465: MSC_ST_UTIL.DERIVE_BILL_SEQUENCE_ID
41466: (p_table_name => 'MSC_ST_BOM_COMPONENTS',
41467: p_bom_col_name => 'BOM_NAME',

Line 41466: (p_table_name => 'MSC_ST_BOM_COMPONENTS',

41462:
41463: -- Derive the Bill Sequence Id for the MSC_ST_BOM_COMPONENTS
41464: lv_return :=
41465: MSC_ST_UTIL.DERIVE_BILL_SEQUENCE_ID
41466: (p_table_name => 'MSC_ST_BOM_COMPONENTS',
41467: p_bom_col_name => 'BOM_NAME',
41468: p_bom_col_id => 'BILL_SEQUENCE_ID',
41469: p_instance_code => v_instance_code,
41470: p_severity => G_SEV_ERROR,

Line 41501: (p_table_name => 'MSC_ST_BOM_COMPONENTS',

41497: ' AND NVL(operation_seq_code,'||''''||NULL_CHAR||''''||') '
41498: ||' = '||''''||NULL_CHAR||'''' ;
41499:
41500: lv_return := MSC_ST_UTIL.LOG_ERROR
41501: (p_table_name => 'MSC_ST_BOM_COMPONENTS',
41502: p_instance_code => v_instance_code,
41503: p_row => lv_column_names,
41504: p_severity => G_SEV_WARNING,
41505: p_message_text => lv_message_text,

Line 41540: (p_table_name => 'MSC_ST_BOM_COMPONENTS',

41536: lv_where_str :=
41537: ' AND NVL(effectivity_date,SYSDATE-36500 ) = SYSDATE-36500' ;
41538:
41539: lv_return := MSC_ST_UTIL.LOG_ERROR
41540: (p_table_name => 'MSC_ST_BOM_COMPONENTS',
41541: p_instance_code => v_instance_code,
41542: p_row => lv_column_names,
41543: p_severity => G_SEV_WARNING,
41544: p_message_text => lv_message_text,

Line 41560: 'UPDATE msc_st_bom_components mbc'

41556:
41557: -- Derive the component_sequence_id
41558: v_sql_stmt := 20;
41559: lv_sql_stmt :=
41560: 'UPDATE msc_st_bom_components mbc'
41561: ||' SET component_sequence_id= (SELECT local_id '
41562: ||' FROM msc_local_id_setup mlis'
41563: ||' WHERE mlis.char1 = mbc.sr_instance_code'
41564: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '

Line 41602: 'UPDATE msc_st_bom_components '

41598:
41599: v_sql_stmt := 21;
41600:
41601: lv_sql_stmt:=
41602: 'UPDATE msc_st_bom_components '
41603: ||' SET process_flag ='|| G_ERROR_FLG||','
41604: ||' error_text = '||''''||lv_message_text||''''
41605: ||' WHERE NVL(component_sequence_id,'||NULL_VALUE||')='|| NULL_VALUE
41606: ||' AND deleted_flag ='|| SYS_YES

Line 41634: 'UPDATE msc_st_bom_components mbc'

41630: -- Now we are checking the overlapping of effectivity date of components
41631: v_sql_stmt := 22;
41632:
41633: lv_sql_stmt:=
41634: 'UPDATE msc_st_bom_components mbc'
41635: ||' SET process_flag = '||G_ERROR_FLG||','
41636: ||' error_text = '||''''||lv_message_text||''''
41637: ||' WHERE EXISTS (SELECT 1 FROM'
41638: ||' msc_local_id_setup mlis'

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

41689:
41690: -- Populate the using_assembly_id from assembly name
41691:
41692: lv_return :=
41693: MSC_ST_UTIL.DERIVE_ITEM_ID(p_table_name =>'MSC_ST_BOM_COMPONENTS',
41694: p_item_col_name => 'ASSEMBLY_NAME',
41695: p_item_col_id =>'USING_ASSEMBLY_ID',
41696: p_instance_code => v_instance_code,
41697: p_instance_id => v_instance_id,

Line 41730: (p_table_name => 'MSC_ST_BOM_COMPONENTS',

41726: lv_where_str :=
41727: ' AND NVL(usage_quantity,'||NULL_VALUE||')='|| NULL_VALUE ;
41728:
41729: lv_return := MSC_ST_UTIL.LOG_ERROR
41730: (p_table_name => 'MSC_ST_BOM_COMPONENTS',
41731: p_instance_code => v_instance_code,
41732: p_row => lv_column_names,
41733: p_severity => G_SEV_WARNING,
41734: p_message_text => lv_message_text,

Line 41766: ' UPDATE msc_st_bom_components mbc'

41762: -- If UOM is provided validate the UOM_CODE
41763: v_sql_stmt := 23;
41764:
41765: lv_sql_stmt :=
41766: ' UPDATE msc_st_bom_components mbc'
41767: ||' SET process_flag = '||G_ERROR_FLG||','
41768: ||' error_text = '||''''||lv_message_text||''''
41769: ||' WHERE NOT EXISTS (SELECT 1'
41770: ||' FROM msc_units_of_measure muom'

Line 41811: (p_table_name => 'MSC_ST_BOM_COMPONENTS',

41807: lv_where_str :=
41808: ' AND NVL(component_yield_factor,'||NULL_VALUE||')= '||NULL_VALUE ;
41809:
41810: lv_return := MSC_ST_UTIL.LOG_ERROR
41811: (p_table_name => 'MSC_ST_BOM_COMPONENTS',
41812: p_instance_code => v_instance_code,
41813: p_row => lv_column_names,
41814: p_severity => G_SEV_WARNING,
41815: p_message_text => lv_message_text,

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

41840:
41841: --Derive driving item id
41842:
41843: lv_return :=
41844: MSC_ST_UTIL.DERIVE_ITEM_ID(p_table_name => 'MSC_ST_BOM_COMPONENTS',
41845: p_item_col_name => 'DRIVING_ITEM_NAME',
41846: p_item_col_id => 'DRIVING_ITEM_ID',
41847: p_instance_code => v_instance_code,
41848: p_instance_id => v_instance_id,

Line 41879: (p_table_name => 'MSC_ST_BOM_COMPONENTS',

41875:
41876: lv_where_str := ' AND use_up_code NOT IN (1,2)';
41877:
41878: lv_return := MSC_ST_UTIL.LOG_ERROR
41879: (p_table_name => 'MSC_ST_BOM_COMPONENTS',
41880: p_instance_code => v_instance_code,
41881: p_row => lv_column_names,
41882: p_severity => G_SEV_WARNING,
41883: p_message_text => lv_message_text,

Line 41915: (p_table_name => 'MSC_ST_BOM_COMPONENTS',

41911:
41912: lv_where_str := ' AND optional_component NOT IN (1,2)';
41913:
41914: lv_return := MSC_ST_UTIL.LOG_ERROR
41915: (p_table_name => 'MSC_ST_BOM_COMPONENTS',
41916: p_instance_code => v_instance_code,
41917: p_row => lv_column_names,
41918: p_severity => G_SEV_WARNING,
41919: p_message_text => lv_message_text,

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

41948: lv_where_str :=
41949: ' AND NVL(wip_supply_type,'||NULL_VALUE||') NOT IN (1,2,3,4,5,6,7)';
41950:
41951: lv_return :=
41952: MSC_ST_UTIL.LOG_ERROR (p_table_name => 'MSC_ST_BOM_COMPONENTS',
41953: p_instance_code => v_instance_code,
41954: p_row => lv_column_names,
41955: p_severity => G_SEV_WARNING,
41956: p_message_text => lv_message_text,

Line 41991: (p_table_name => 'MSC_ST_BOM_COMPONENTS',

41987: lv_where_str :=
41988: ' AND NVL(component_type,'||NULL_VALUE||') NOT IN (-1,1,2)';
41989:
41990: lv_return := MSC_ST_UTIL.LOG_ERROR
41991: (p_table_name => 'MSC_ST_BOM_COMPONENTS',
41992: p_instance_code => v_instance_code,
41993: p_row => lv_column_names,
41994: p_severity => G_SEV_WARNING,
41995: p_message_text => lv_message_text,

Line 42029: (p_table_name => 'MSC_ST_BOM_COMPONENTS',

42025: lv_where_str :=
42026: ' AND NVL(atp_flag,'||NULL_VALUE||')NOT IN (1,2)';
42027:
42028: lv_return := MSC_ST_UTIL.LOG_ERROR
42029: (p_table_name => 'MSC_ST_BOM_COMPONENTS',
42030: p_instance_code => v_instance_code,
42031: p_row => lv_column_names,
42032: p_severity => G_SEV_WARNING,
42033: p_message_text => lv_message_text,

Line 42052: pEntityName => 'MSC_ST_BOM_COMPONENTS',

42048: (ERRBUF => lv_error_text,
42049: RETCODE => lv_return,
42050: pBatchID => lv_batch_id,
42051: pInstanceCode => v_instance_code,
42052: pEntityName => 'MSC_ST_BOM_COMPONENTS',
42053: pInstanceID => v_instance_id);
42054:
42055: IF NVL(lv_return,0) <> 0 THEN
42056: RAISE ex_logging_err;

Line 42062: 'UPDATE MSC_ST_BOM_COMPONENTS'

42058:
42059: v_sql_stmt := 23.1;
42060:
42061: lv_sql_stmt :=
42062: 'UPDATE MSC_ST_BOM_COMPONENTS'
42063: ||' SET usage_quantity = ( usage_quantity / decode(component_yield_factor,0,1,abs(component_yield_factor)) )* nvl(planning_factor,100)/100'
42064: ||' WHERE process_flag = '||G_IN_PROCESS
42065: ||' AND sr_instance_code = :v_instance_code'
42066: ||' AND batch_id = :lv_batch_id';

Line 42085: UPDATE msc_st_bom_components

42081: IF c5%ROWCOUNT > 0 THEN
42082:
42083: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
42084:
42085: UPDATE msc_st_bom_components
42086: SET component_sequence_id = msc_st_component_sequence_id_s.NEXTVAL
42087: WHERE rowid = lb_rowid(j);
42088:
42089: v_sql_stmt := 23;

Line 42145: FROM msc_st_bom_components

42141: v_current_date,
42142: v_current_user,
42143: v_current_date,
42144: v_current_user
42145: FROM msc_st_bom_components
42146: WHERE rowid = lb_rowid(j) ;
42147:
42148: END IF;
42149: CLOSE c5;

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

42154: /*
42155: lv_sql_stmt :=
42156: 'UPDATE msc_local_id_setup mlis'
42157: ||' SET date2 = SYSDATE'
42158: ||' WHERE EXISTS ( SELECT 1 FROM msc_st_bom_components mbc'
42159: ||' WHERE mlis.char1 = mbc.sr_instance_code'
42160: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '
42161: ||' = NVL(mbc.company_name,'||''''||NULL_CHAR||''''||') '
42162: ||' AND mlis.char3 = mbc.organization_code'

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

42191: CLOSE c7;
42192:
42193: -- Set the process flag as Valid and poulate instance_id
42194: lv_return :=
42195: MSC_ST_UTIL.SET_PROCESS_FLAG(p_table_name => 'MSC_ST_BOM_COMPONENTS',
42196: p_instance_id => v_instance_id,
42197: p_instance_code => v_instance_code,
42198: p_process_flag => G_VALID,
42199: p_error_text => lv_error_text,

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

42206:
42207: -- At the end calling the LOG_ERROR for logging all errored out records
42208:
42209: lv_return :=
42210: msc_st_util.log_error(p_table_name =>'MSC_ST_BOM_COMPONENTS',
42211: p_instance_code =>v_instance_code,
42212: p_row =>lv_column_names,
42213: p_severity =>G_SEV_ERROR,
42214: p_message_text => NULL,

Line 42702: p_token_value2 => 'MSC_ST_BOM_COMPONENTS',

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

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

43424: RAISe ex_logging_err;
43425: END IF;
43426:
43427: COMMIT;
43428: -- Now Updating the tables MSC_ST_BOMS and MSC_ST_BOM_COMPONENTS.
43429:
43430: LOAD_CO_PRODUCT_BOMS;
43431:
43432:

Line 45204: ||' msc_st_bom_components msbc,'

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'' '
45208: ||' AND mlis.local_id = msro.routing_sequence_id'

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

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');
55837: IF lv_count > 0 Then
55838: prec.bom_flag:= SYS_YES;
55839: End IF;
55840: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_BOMS');