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_CO_PRODUCTS

Line 789: 'create index MSC_ST_CO_PRODUCTS_N1_'||v_instance_code

785: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
786: application_short_name => 'MSC',
787: statement_type => AD_DDL.CREATE_INDEX,
788: statement =>
789: 'create index MSC_ST_CO_PRODUCTS_N1_'||v_instance_code
790: ||' on MSC_ST_CO_PRODUCTS '
791: ||'(co_product_name,component_name,sr_instance_code,company_name ) '
792: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
793: object_name =>'MSC_ST_CO_PRODUCTS_N1_'||v_instance_code);

Line 790: ||' on MSC_ST_CO_PRODUCTS '

786: application_short_name => 'MSC',
787: statement_type => AD_DDL.CREATE_INDEX,
788: statement =>
789: 'create index MSC_ST_CO_PRODUCTS_N1_'||v_instance_code
790: ||' on MSC_ST_CO_PRODUCTS '
791: ||'(co_product_name,component_name,sr_instance_code,company_name ) '
792: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
793: object_name =>'MSC_ST_CO_PRODUCTS_N1_'||v_instance_code);
794: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_CO_PRODUCTS_N1_'||v_instance_code);

Line 793: object_name =>'MSC_ST_CO_PRODUCTS_N1_'||v_instance_code);

789: 'create index MSC_ST_CO_PRODUCTS_N1_'||v_instance_code
790: ||' on MSC_ST_CO_PRODUCTS '
791: ||'(co_product_name,component_name,sr_instance_code,company_name ) '
792: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
793: object_name =>'MSC_ST_CO_PRODUCTS_N1_'||v_instance_code);
794: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_CO_PRODUCTS_N1_'||v_instance_code);
795:
796: EXCEPTION
797: WHEN OTHERS THEN

Line 794: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_CO_PRODUCTS_N1_'||v_instance_code);

790: ||' on MSC_ST_CO_PRODUCTS '
791: ||'(co_product_name,component_name,sr_instance_code,company_name ) '
792: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
793: object_name =>'MSC_ST_CO_PRODUCTS_N1_'||v_instance_code);
794: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_CO_PRODUCTS_N1_'||v_instance_code);
795:
796: EXCEPTION
797: WHEN OTHERS THEN
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));

Line 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));

794: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_CO_PRODUCTS_N1_'||v_instance_code);
795:
796: EXCEPTION
797: WHEN OTHERS THEN
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);

Line 804: msc_analyse_tables_pk.analyse_table( 'MSC_ST_CO_PRODUCTS', v_instance_id, -1);

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;
808:

Line 2074: 'drop index MSC_ST_CO_PRODUCTS_N1_'||v_instance_code,

2070: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2071: application_short_name => 'MSC',
2072: statement_type => AD_DDL.DROP_INDEX,
2073: statement =>
2074: 'drop index MSC_ST_CO_PRODUCTS_N1_'||v_instance_code,
2075: object_name => 'MSC_ST_CO_PRODUCTS_N1_'||v_instance_code);
2076:
2077: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_CO_PRODUCTS_N1_'||v_instance_code);
2078: EXCEPTION

Line 2075: object_name => 'MSC_ST_CO_PRODUCTS_N1_'||v_instance_code);

2071: application_short_name => 'MSC',
2072: statement_type => AD_DDL.DROP_INDEX,
2073: statement =>
2074: 'drop index MSC_ST_CO_PRODUCTS_N1_'||v_instance_code,
2075: object_name => 'MSC_ST_CO_PRODUCTS_N1_'||v_instance_code);
2076:
2077: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_CO_PRODUCTS_N1_'||v_instance_code);
2078: EXCEPTION
2079: WHEN OTHERS THEN

Line 2077: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_CO_PRODUCTS_N1_'||v_instance_code);

2073: statement =>
2074: 'drop index MSC_ST_CO_PRODUCTS_N1_'||v_instance_code,
2075: object_name => 'MSC_ST_CO_PRODUCTS_N1_'||v_instance_code);
2076:
2077: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_CO_PRODUCTS_N1_'||v_instance_code);
2078: EXCEPTION
2079: WHEN OTHERS THEN
2080: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error dropping Index MSC_ST_CO_PRODUCTS_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
2081: END;

Line 2080: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error dropping Index MSC_ST_CO_PRODUCTS_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));

2076:
2077: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_CO_PRODUCTS_N1_'||v_instance_code);
2078: EXCEPTION
2079: WHEN OTHERS THEN
2080: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error dropping Index MSC_ST_CO_PRODUCTS_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
2081: END;
2082:
2083: END IF;
2084:

Line 40073: || ' from msc_st_co_products mcp'

40069: v_query_str1 := ' select mcp.co_product_id, '
40070: || ' mcp.component_id, '
40071: || ' mcp.split, '
40072: || ' mcp.primary_flag '
40073: || ' from msc_st_co_products mcp'
40074: || ' where process_flag = '|| G_VALID
40075: || ' and sr_instance_code = :v_instance_code ';
40076:
40077:

Line 40105: || ' from msc_st_co_products mcp'

40101: v_query_str3 := ' select mcp.co_product_id, '
40102: || ' mcp.component_id, '
40103: || ' mcp.split, '
40104: || ' mcp.primary_flag '
40105: || ' from msc_st_co_products mcp'
40106: || ' where process_flag = '|| G_VALID
40107: || ' and component_id = :lv_assembly_item_id '
40108: || ' and co_product_id <> :lv_co_product_id ';
40109:

Line 40480: FROM msc_st_co_products

40476:
40477: -- For Co Products --
40478: CURSOR c8(p_batch_id NUMBER) IS
40479: SELECT rowid
40480: FROM msc_st_co_products
40481: WHERE process_flag IN (G_IN_PROCESS,G_ERROR_FLG)
40482: AND sr_instance_code = v_instance_code
40483: AND batch_id = p_batch_id;
40484:

Line 40487: FROM msc_st_co_products

40483: AND batch_id = p_batch_id;
40484:
40485: CURSOR c9 IS
40486: SELECT max(rowid)
40487: FROM msc_st_co_products
40488: WHERE process_flag = G_IN_PROCESS
40489: AND sr_instance_code = v_instance_code
40490: AND NVL(co_product_group_id,NULL_VALUE) = NULL_VALUE
40491: AND deleted_flag = SYS_NO

Line 42848: -- Now validtion for MSC_ST_CO_PRODUCTS

42844: COMMIT;
42845: END LOOP;
42846:
42847: -- For OSFM Integration. Support for Co Products --
42848: -- Now validtion for MSC_ST_CO_PRODUCTS
42849:
42850: --Duplicate records check for the records whose source is XML
42851:
42852: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE

Line 42865: 'UPDATE msc_st_co_products mcp1 '

42861:
42862:
42863: v_sql_stmt := 36;
42864: lv_sql_stmt :=
42865: 'UPDATE msc_st_co_products mcp1 '
42866: ||' SET process_flag ='|| G_ERROR_FLG||','
42867: ||' error_text = '||''''||lv_message_text||''''
42868: ||' WHERE message_id < ( SELECT max(message_id)'
42869: ||' FROM msc_st_co_products mcp2'

Line 42869: ||' FROM msc_st_co_products mcp2'

42865: 'UPDATE msc_st_co_products mcp1 '
42866: ||' SET process_flag ='|| G_ERROR_FLG||','
42867: ||' error_text = '||''''||lv_message_text||''''
42868: ||' WHERE message_id < ( SELECT max(message_id)'
42869: ||' FROM msc_st_co_products mcp2'
42870: ||' WHERE mcp2.co_product_name = mcp1.co_product_name'
42871: ||' AND mcp2.component_name = mcp1.component_name'
42872: ||' AND mcp2.sr_instance_code = mcp1.sr_instance_code'
42873: ||' AND NVL(mcp2.company_name,'||''''||NULL_CHAR||''''||') '

Line 42902: 'UPDATE msc_st_co_products mcp1 '

42898:
42899: v_sql_stmt := 37;
42900:
42901: lv_sql_stmt :=
42902: 'UPDATE msc_st_co_products mcp1 '
42903: ||' SET process_flag = '||G_ERROR_FLG||','
42904: ||' error_text = '||''''||lv_message_text||''''
42905: ||' WHERE EXISTS ( SELECT 1 FROM msc_st_co_products mcp2 '
42906: ||' WHERE mcp2.co_product_name = mcp1.co_product_name'

Line 42905: ||' WHERE EXISTS ( SELECT 1 FROM msc_st_co_products mcp2 '

42901: lv_sql_stmt :=
42902: 'UPDATE msc_st_co_products mcp1 '
42903: ||' SET process_flag = '||G_ERROR_FLG||','
42904: ||' error_text = '||''''||lv_message_text||''''
42905: ||' WHERE EXISTS ( SELECT 1 FROM msc_st_co_products mcp2 '
42906: ||' WHERE mcp2.co_product_name = mcp1.co_product_name'
42907: ||' AND mcp2.component_name = mcp1.component_name'
42908: ||' AND mcp2.sr_instance_code = mcp1.sr_instance_code'
42909: ||' AND NVL(mcp2.company_name,'||''''||NULL_CHAR||''''||') '

Line 42935: -- Processing the MSC_ST_CO_PRODUCTS table in batch --

42931: ||'COMPANY_NAME ||''~''||'
42932: ||'DELETED_FLAG ';
42933:
42934:
42935: -- Processing the MSC_ST_CO_PRODUCTS table in batch --
42936:
42937: LOOP
42938: v_sql_stmt := 38;
42939: lv_cursor_stmt :=

Line 42948: ' UPDATE msc_st_co_products '

42944: CLOSE c1;
42945:
42946: v_sql_stmt := 39;
42947: lv_sql_stmt :=
42948: ' UPDATE msc_st_co_products '
42949: ||' SET batch_id = :lv_batch_id '
42950: ||' WHERE process_flag IN ('||G_IN_PROCESS||','||G_ERROR_FLG||')'
42951: ||' AND sr_instance_code = :v_instance_code'
42952: ||' AND NVL(batch_id,'||NULL_VALUE||') = '||NULL_VALUE

Line 42971: UPDATE msc_st_co_products

42967: CLOSE c8;
42968:
42969: v_sql_stmt := 40;
42970: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
42971: UPDATE msc_st_co_products
42972: SET st_transaction_id = msc_st_co_products_s.NEXTVAL,
42973: refresh_id = v_refresh_id,
42974: last_update_date = v_current_date,
42975: last_updated_by = v_current_user,

Line 42972: SET st_transaction_id = msc_st_co_products_s.NEXTVAL,

42968:
42969: v_sql_stmt := 40;
42970: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
42971: UPDATE msc_st_co_products
42972: SET st_transaction_id = msc_st_co_products_s.NEXTVAL,
42973: refresh_id = v_refresh_id,
42974: last_update_date = v_current_date,
42975: last_updated_by = v_current_user,
42976: creation_date = v_current_date,

Line 42989: p_token_value1 => 'MSC_ST_CO_PRODUCTS');

42985: p_error_code => 'MSC_PP_NO_DELETION',
42986: p_message_text => lv_message_text,
42987: p_error_text => lv_error_text,
42988: p_token1 => 'TABLE_NAME',
42989: p_token_value1 => 'MSC_ST_CO_PRODUCTS');
42990:
42991: IF lv_return <> 0 THEN
42992: RAISE ex_logging_err;
42993: END IF;

Line 42998: ' UPDATE msc_st_co_products'

42994:
42995: --Deletion is not allowed on this table.
42996: v_sql_stmt := 41;
42997: lv_sql_stmt :=
42998: ' UPDATE msc_st_co_products'
42999: ||' SET process_flag = '||G_ERROR_FLG||','
43000: ||' error_text = '||''''||lv_message_text||''''
43001: ||' WHERE deleted_flag = '||SYS_YES
43002: ||' AND process_flag = '||G_IN_PROCESS

Line 43030: (p_table_name => 'MSC_ST_CO_PRODUCTS',

43026: lv_where_str :=
43027: ' AND NVL(deleted_flag,'||NULL_VALUE||')NOT IN (1,2)';
43028:
43029: lv_return := MSC_ST_UTIL.LOG_ERROR
43030: (p_table_name => 'MSC_ST_CO_PRODUCTS',
43031: p_instance_code => v_instance_code,
43032: p_row => lv_column_names,
43033: p_severity => G_SEV_WARNING,
43034: p_message_text => lv_message_text,

Line 43067: ' UPDATE msc_st_co_products '

43063:
43064: v_sql_stmt := 42;
43065:
43066: lv_sql_stmt :=
43067: ' UPDATE msc_st_co_products '
43068: ||' SET process_flag = '||G_ERROR_FLG||','
43069: ||' error_text = '||''''||lv_message_text||''''
43070: ||' WHERE NVL(split,'||NULL_VALUE||') = '||NULL_VALUE
43071: ||' AND batch_id = :lv_batch_id'

Line 43098: (p_table_name => 'MSC_ST_CO_PRODUCTS',

43094: END IF;
43095:
43096: -- Derive Component_id
43097: lv_return := MSC_ST_UTIL.DERIVE_ITEM_ID
43098: (p_table_name => 'MSC_ST_CO_PRODUCTS',
43099: p_item_col_name => 'COMPONENT_NAME',
43100: p_item_col_id => 'COMPONENT_ID',
43101: p_instance_id => v_instance_id,
43102: p_instance_code => v_instance_code,

Line 43129: (p_table_name => 'MSC_ST_CO_PRODUCTS',

43125: END IF;
43126:
43127: -- Derive Co_product_id
43128: lv_return := MSC_ST_UTIL.DERIVE_ITEM_ID
43129: (p_table_name => 'MSC_ST_CO_PRODUCTS',
43130: p_item_col_name => 'CO_PRODUCT_NAME',
43131: p_item_col_id => 'CO_PRODUCT_ID',
43132: p_instance_id => v_instance_id,
43133: p_instance_code => v_instance_code,

Line 43149: 'UPDATE MSC_ST_CO_PRODUCTS t1'

43145:
43146:
43147: -- Derive the CO_PRODUCT_GROUP_ID from LOCAL ID table
43148: lv_sql_stmt :=
43149: 'UPDATE MSC_ST_CO_PRODUCTS t1'
43150: ||' SET CO_PRODUCT_GROUP_ID '
43151: ||' = (SELECT local_id'
43152: ||' FROM msc_local_id_setup t2'
43153: ||' WHERE t2.char1 = t1.sr_instance_code'

Line 43186: ' UPDATE msc_st_co_products '

43182:
43183: v_sql_stmt := 43;
43184:
43185: lv_sql_stmt :=
43186: ' UPDATE msc_st_co_products '
43187: ||' SET process_flag = '||G_ERROR_FLG||','
43188: ||' error_text = '||''''||lv_message_text||''''
43189: ||' WHERE NVL(co_product_group_id,'||NULL_VALUE||') <> '||NULL_VALUE
43190: ||' AND batch_id = :lv_batch_id'

Line 43211: pEntityName => 'MSC_ST_CO_PRODUCTS',

43207: (ERRBUF => lv_error_text,
43208: RETCODE => lv_return,
43209: pBatchID => lv_batch_id,
43210: pInstanceCode => v_instance_code,
43211: pEntityName => 'MSC_ST_CO_PRODUCTS',
43212: pInstanceID => v_instance_id);
43213:
43214: IF NVL(lv_return,0) <> 0 THEN
43215: RAISE ex_logging_err;

Line 43237: 'UPDATE msc_st_co_products mcp1 '

43233: -- Note using the request id, so that it doesn't consider the old records.
43234: v_sql_stmt := 44;
43235:
43236: lv_sql_stmt :=
43237: 'UPDATE msc_st_co_products mcp1 '
43238: ||' SET process_flag = '||G_PROPAGATION||','
43239: ||' error_text = '||''''||lv_message_text||''''
43240: ||' WHERE EXISTS ( SELECT 1 FROM msc_st_co_products mcp2 '
43241: ||' WHERE mcp2.sr_instance_code = mcp1.sr_instance_code'

Line 43240: ||' WHERE EXISTS ( SELECT 1 FROM msc_st_co_products mcp2 '

43236: lv_sql_stmt :=
43237: 'UPDATE msc_st_co_products mcp1 '
43238: ||' SET process_flag = '||G_PROPAGATION||','
43239: ||' error_text = '||''''||lv_message_text||''''
43240: ||' WHERE EXISTS ( SELECT 1 FROM msc_st_co_products mcp2 '
43241: ||' WHERE mcp2.sr_instance_code = mcp1.sr_instance_code'
43242: ||' AND mcp2.component_id = mcp1.component_id'
43243: ||' AND mcp2.request_id = :v_request_id '
43244: ||' AND mcp2.process_flag = '||G_ERROR_FLG ||' )'

Line 43280: 'UPDATE msc_st_co_products mcp1'

43276: END IF;
43277:
43278: v_sql_stmt := 45;
43279: lv_sql_stmt :=
43280: 'UPDATE msc_st_co_products mcp1'
43281: ||' SET process_flag = '||G_ERROR_FLG||','
43282: ||' error_text = '||''''||lv_message_text||''''
43283: ||' WHERE 100 <> ( SELECT sum(split) '
43284: ||' FROM msc_st_co_products mcp2'

Line 43284: ||' FROM msc_st_co_products mcp2'

43280: 'UPDATE msc_st_co_products mcp1'
43281: ||' SET process_flag = '||G_ERROR_FLG||','
43282: ||' error_text = '||''''||lv_message_text||''''
43283: ||' WHERE 100 <> ( SELECT sum(split) '
43284: ||' FROM msc_st_co_products mcp2'
43285: ||' WHERE mcp2.component_name = mcp1.component_name'
43286: ||' AND mcp2.sr_instance_code = mcp1.sr_instance_code'
43287: ||' AND NVL(mcp2.company_name,'||''''||NULL_CHAR||''''||') '
43288: ||' = NVL(mcp1.company_name, '||''''||NULL_CHAR||''''||') '

Line 43315: 'UPDATE msc_st_co_products mcp1'

43311: END IF;
43312:
43313: v_sql_stmt := 46;
43314: lv_sql_stmt :=
43315: 'UPDATE msc_st_co_products mcp1'
43316: ||' SET process_flag = '||G_ERROR_FLG||','
43317: ||' error_text = '||''''||lv_message_text||''''
43318: ||' WHERE 1 <> ( SELECT COUNT(*) '
43319: ||' FROM msc_st_co_products mcp2'

Line 43319: ||' FROM msc_st_co_products mcp2'

43315: 'UPDATE msc_st_co_products mcp1'
43316: ||' SET process_flag = '||G_ERROR_FLG||','
43317: ||' error_text = '||''''||lv_message_text||''''
43318: ||' WHERE 1 <> ( SELECT COUNT(*) '
43319: ||' FROM msc_st_co_products mcp2'
43320: ||' WHERE mcp2.component_name = mcp1.component_name'
43321: ||' AND mcp2.sr_instance_code = mcp1.sr_instance_code'
43322: ||' AND NVL(mcp2.company_name,'||''''||NULL_CHAR||''''||') '
43323: ||' = NVL(mcp1.company_name, '||''''||NULL_CHAR||''''||') '

Line 43348: UPDATE msc_st_co_products

43344: IF c9%ROWCOUNT > 0 THEN
43345:
43346: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
43347:
43348: UPDATE msc_st_co_products
43349: SET co_product_group_id = msc_st_co_product_group_id_s.NEXTVAL
43350: WHERE rowid = lb_rowid(j);
43351:
43352:

Line 43390: FROM msc_st_co_products

43386: v_current_date,
43387: v_current_user,
43388: v_current_date,
43389: v_current_user
43390: FROM msc_st_co_products
43391: WHERE rowid = lb_rowid(j);
43392:
43393: END IF;
43394: CLOSE c9;

Line 43400: MSC_ST_UTIL.SET_PROCESS_FLAG(p_table_name => 'MSC_ST_CO_PRODUCTS',

43396:
43397:
43398: -- Set the process flag as Valid and derive sr_instance_id
43399: lv_return :=
43400: MSC_ST_UTIL.SET_PROCESS_FLAG(p_table_name => 'MSC_ST_CO_PRODUCTS',
43401: p_instance_id => v_instance_id,
43402: p_instance_code => v_instance_code,
43403: p_process_flag => G_VALID,
43404: p_error_text => lv_error_text,

Line 43415: MSC_ST_UTIL.LOG_ERROR(p_table_name => 'MSC_ST_CO_PRODUCTS',

43411:
43412: -- At the end calling the LOG_ERROR for logging all errored out records
43413:
43414: lv_return :=
43415: MSC_ST_UTIL.LOG_ERROR(p_table_name => 'MSC_ST_CO_PRODUCTS',
43416: p_instance_code => v_instance_code,
43417: p_row => lv_column_names,
43418: p_severity => G_SEV_ERROR,
43419: p_message_text => NULL,

Line 55844: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_CO_PRODUCTS');

55840: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_BOMS');
55841: IF lv_count > 0 Then
55842: prec.bom_flag:= SYS_YES;
55843: End IF;
55844: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_CO_PRODUCTS');
55845: IF lv_count > 0 Then
55846: prec.bom_flag:= SYS_YES;
55847: End IF;
55848: END IF;