DBA Data[Home] [Help]

APPS.MSC_CL_GMP_UTILITY dependencies on MSC_ST_BOM_COMPONENTS

Line 4790: msc_st_bom_components is a primary key. So the max value from gmd formula line sequence

4786: ELSE
4787: gmd_formline_cnt := gmd_formline_cnt + 1;
4788: bomc_component_sequence_id(bomc_index) := (( v_gmd_formula_lineid + gmd_formline_cnt ) * 2) + 1;
4789: /*For sustitutes the formula line id will be null. component sequence id in
4790: msc_st_bom_components is a primary key. So the max value from gmd formula line sequence
4791: is fetched and global counter value is added to it.Then odd value is passed on to APS. */
4792: END IF;
4793: -- Bug:6030499 Vpedarla end of item sybstitution
4794: -- bomc_component_sequence_id(bomc_index) := formula_detail_tab(loop_index).x_formulaline_id;

Line 4880: log_message('Error writing to msc_st_bom_components: '||sqlerrm);

4876: return_status := TRUE;
4877:
4878: EXCEPTION
4879: WHEN OTHERS THEN
4880: log_message('Error writing to msc_st_bom_components: '||sqlerrm);
4881: return_status := FALSE;
4882: END write_bom_components;
4883:
4884: /*

Line 6923: INSERT INTO msc_st_bom_components

6919: stmt_no := 903 ;
6920: i := 1 ;
6921: IF bomc_organization_id.FIRST > 0 THEN
6922: FORALL i IN bomc_organization_id.FIRST..bomc_organization_id.LAST
6923: INSERT INTO msc_st_bom_components
6924: (
6925: component_sequence_id,
6926: sr_instance_id,
6927: organization_id,