APPS.CTO_CONFIG_BOM_PK dependencies on BOM_REFERENCE_DESIGNATORS

Line 3310: Insert into BOM_REFERENCE_DESIGNATORS table

3306:
3307:
3308:
3309: /* -------------------------------------------------------------------------+
3310: Insert into BOM_REFERENCE_DESIGNATORS table
3311: +--------------------------------------------------------------------------*/
3312: IF PG_DEBUG <> 0 THEN
3313: oe_debug_pub.add('create_bom_data_ml: ' || 'Before third insert into bom_reference_designators. ', 2);
3314: END IF;

Line 3313: oe_debug_pub.add('create_bom_data_ml: ' || 'Before third insert into bom_reference_designators. ', 2);

3309: /* -------------------------------------------------------------------------+
3310: Insert into BOM_REFERENCE_DESIGNATORS table
3311: +--------------------------------------------------------------------------*/
3312: IF PG_DEBUG <> 0 THEN
3313: oe_debug_pub.add('create_bom_data_ml: ' || 'Before third insert into bom_reference_designators. ', 2);
3314: END IF;
3315: lStmtNum := 320;
3316: xTableName := 'BOM_REFERENCE_DESIGNATORS';
3317: insert into BOM_REFERENCE_DESIGNATORS

Line 3316: xTableName := 'BOM_REFERENCE_DESIGNATORS';

3312: IF PG_DEBUG <> 0 THEN
3313: oe_debug_pub.add('create_bom_data_ml: ' || 'Before third insert into bom_reference_designators. ', 2);
3314: END IF;
3315: lStmtNum := 320;
3316: xTableName := 'BOM_REFERENCE_DESIGNATORS';
3317: insert into BOM_REFERENCE_DESIGNATORS
3318: (
3319: component_reference_designator,
3320: last_update_date,

Line 3317: insert into BOM_REFERENCE_DESIGNATORS

3313: oe_debug_pub.add('create_bom_data_ml: ' || 'Before third insert into bom_reference_designators. ', 2);
3314: END IF;
3315: lStmtNum := 320;
3316: xTableName := 'BOM_REFERENCE_DESIGNATORS';
3317: insert into BOM_REFERENCE_DESIGNATORS
3318: (
3319: component_reference_designator,
3320: last_update_date,
3321: last_updated_by,

Line 3391: bom_reference_designators r,

3387: r.ATTRIBUTE14,
3388: r.ATTRIBUTE15
3389: from
3390: bom_inventory_components ic,
3391: bom_reference_designators r,
3392: bom_bill_of_materials b
3393: where b.assembly_item_id = pConfigId
3394: and b.organization_id = pOrgId
3395: and ic.bill_sequence_id = b.bill_sequence_id

Line 3447: -- insert into BOM_REFERENCE_DESIGNATORS for the corresponding model_comp_seq_id

3443:
3444: club_component_sequence_id := a1.comp_seq_id;
3445:
3446:
3447: -- insert into BOM_REFERENCE_DESIGNATORS for the corresponding model_comp_seq_id
3448: -- if it has not already been inserted.
3449: IF PG_DEBUG <> 0 THEN
3450: oe_debug_pub.add ('club_component_sequence_id is '||club_component_sequence_id, 1);
3451: END if;

Line 3453: oe_debug_pub.add ('Trying to insert into BOM_REFERENCE_DESIGNATORS', 1);

3449: IF PG_DEBUG <> 0 THEN
3450: oe_debug_pub.add ('club_component_sequence_id is '||club_component_sequence_id, 1);
3451: END if;
3452: IF PG_DEBUG <> 0 THEN
3453: oe_debug_pub.add ('Trying to insert into BOM_REFERENCE_DESIGNATORS', 1);
3454: END if;
3455: begin
3456: insert into BOM_REFERENCE_DESIGNATORS
3457: (

Line 3456: insert into BOM_REFERENCE_DESIGNATORS

3452: IF PG_DEBUG <> 0 THEN
3453: oe_debug_pub.add ('Trying to insert into BOM_REFERENCE_DESIGNATORS', 1);
3454: END if;
3455: begin
3456: insert into BOM_REFERENCE_DESIGNATORS
3457: (
3458: component_reference_designator,
3459: last_update_date,
3460: last_updated_by,

Line 3529: bom_reference_designators r

3525: r.ATTRIBUTE13,
3526: r.ATTRIBUTE14,
3527: r.ATTRIBUTE15
3528: from
3529: bom_reference_designators r
3530: --added abs() was model_comp_seq would be -ve value
3531: where r.component_sequence_id = abs(model_comp_seq_id_arr(x1))
3532: and nvl(r.acd_type,0) <> 3;
3533: exception

Line 3536: oe_debug_pub.add ('The record for this designator and component sequence already exists in BOM_REFERENCE_DESIGNATORS', 1);

3532: and nvl(r.acd_type,0) <> 3;
3533: exception
3534: when others then
3535: IF PG_DEBUG <> 0 THEN
3536: oe_debug_pub.add ('The record for this designator and component sequence already exists in BOM_REFERENCE_DESIGNATORS', 1);
3537: END IF;
3538: end;
3539: IF PG_DEBUG <> 0 THEN
3540: oe_debug_pub.add ('For this record '||sql%rowcount||' records are inserted in bom_reference_designators', 1);

Line 3540: oe_debug_pub.add ('For this record '||sql%rowcount||' records are inserted in bom_reference_designators', 1);

3536: oe_debug_pub.add ('The record for this designator and component sequence already exists in BOM_REFERENCE_DESIGNATORS', 1);
3537: END IF;
3538: end;
3539: IF PG_DEBUG <> 0 THEN
3540: oe_debug_pub.add ('For this record '||sql%rowcount||' records are inserted in bom_reference_designators', 1);
3541: END if;
3542: end loop; -- 3985173 : end of club_comp_seq cursor loop
3543: prev_comp_item_id := component_item_id_arr(x1); -- 3985173
3544: