DBA Data[Home] [Help]

APPS.MSC_CL_GMP_UTILITY dependencies on MSC_ST_BOM_COMPONENTS

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

4447: ELSE
4448: gmd_formline_cnt := gmd_formline_cnt + 1;
4449: bomc_component_sequence_id(bomc_index) := (( v_gmd_formula_lineid + gmd_formline_cnt ) * 2) + 1;
4450: /*For sustitutes the formula line id will be null. component sequence id in
4451: msc_st_bom_components is a primary key. So the max value from gmd formula line sequence
4452: is fetched and global counter value is added to it.Then odd value is passed on to APS. */
4453: END IF;
4454: /*Sowmya - Item substitution - End*/
4455:

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

4519: return_status := TRUE;
4520:
4521: EXCEPTION
4522: WHEN OTHERS THEN
4523: log_message('Error writing to msc_st_bom_components: '||sqlerrm);
4524: return_status := FALSE;
4525: END write_bom_components;
4526:
4527: /*

Line 6503: INSERT INTO msc_st_bom_components

6499: stmt_no := 903 ;
6500: i := 1 ;
6501: IF bomc_organization_id.FIRST > 0 THEN
6502: FORALL i IN bomc_organization_id.FIRST..bomc_organization_id.LAST
6503: INSERT INTO msc_st_bom_components
6504: (
6505: component_sequence_id,
6506: sr_instance_id,
6507: organization_id,