APPS.CTO_CONFIG_BOM_PK dependencies on BOM_REFERENCE_DESIGNATORS

Line 3234: Insert into BOM_REFERENCE_DESIGNATORS table

3230:
3231:
3232:
3233: /* -------------------------------------------------------------------------+
3234: Insert into BOM_REFERENCE_DESIGNATORS table
3235: +--------------------------------------------------------------------------*/
3236: IF PG_DEBUG <> 0 THEN
3237: oe_debug_pub.add('create_bom_data_ml: ' || 'Before third insert into bom_reference_designators. ', 2);
3238: END IF;

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

3233: /* -------------------------------------------------------------------------+
3234: Insert into BOM_REFERENCE_DESIGNATORS table
3235: +--------------------------------------------------------------------------*/
3236: IF PG_DEBUG <> 0 THEN
3237: oe_debug_pub.add('create_bom_data_ml: ' || 'Before third insert into bom_reference_designators. ', 2);
3238: END IF;
3239: lStmtNum := 320;
3240: xTableName := 'BOM_REFERENCE_DESIGNATORS';
3241: insert into BOM_REFERENCE_DESIGNATORS

Line 3240: xTableName := 'BOM_REFERENCE_DESIGNATORS';

3236: IF PG_DEBUG <> 0 THEN
3237: oe_debug_pub.add('create_bom_data_ml: ' || 'Before third insert into bom_reference_designators. ', 2);
3238: END IF;
3239: lStmtNum := 320;
3240: xTableName := 'BOM_REFERENCE_DESIGNATORS';
3241: insert into BOM_REFERENCE_DESIGNATORS
3242: (
3243: component_reference_designator,
3244: last_update_date,

Line 3241: insert into BOM_REFERENCE_DESIGNATORS

3237: oe_debug_pub.add('create_bom_data_ml: ' || 'Before third insert into bom_reference_designators. ', 2);
3238: END IF;
3239: lStmtNum := 320;
3240: xTableName := 'BOM_REFERENCE_DESIGNATORS';
3241: insert into BOM_REFERENCE_DESIGNATORS
3242: (
3243: component_reference_designator,
3244: last_update_date,
3245: last_updated_by,

Line 3307: bom_reference_designators r,

3303: r.ATTRIBUTE14,
3304: r.ATTRIBUTE15
3305: from
3306: bom_inventory_components ic,
3307: bom_reference_designators r,
3308: bom_bill_of_materials b
3309: where b.assembly_item_id = pConfigId
3310: and b.organization_id = pOrgId
3311: and ic.bill_sequence_id = b.bill_sequence_id

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

3359:
3360: club_component_sequence_id := a1.comp_seq_id;
3361:
3362:
3363: -- insert into BOM_REFERENCE_DESIGNATORS for the corresponding model_comp_seq_id
3364: -- if it has not already been inserted.
3365: IF PG_DEBUG <> 0 THEN
3366: oe_debug_pub.add ('club_component_sequence_id is '||club_component_sequence_id, 1);
3367: END if;

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

3365: IF PG_DEBUG <> 0 THEN
3366: oe_debug_pub.add ('club_component_sequence_id is '||club_component_sequence_id, 1);
3367: END if;
3368: IF PG_DEBUG <> 0 THEN
3369: oe_debug_pub.add ('Trying to insert into BOM_REFERENCE_DESIGNATORS', 1);
3370: END if;
3371: begin
3372: insert into BOM_REFERENCE_DESIGNATORS
3373: (

Line 3372: insert into BOM_REFERENCE_DESIGNATORS

3368: IF PG_DEBUG <> 0 THEN
3369: oe_debug_pub.add ('Trying to insert into BOM_REFERENCE_DESIGNATORS', 1);
3370: END if;
3371: begin
3372: insert into BOM_REFERENCE_DESIGNATORS
3373: (
3374: component_reference_designator,
3375: last_update_date,
3376: last_updated_by,

Line 3437: bom_reference_designators r

3433: r.ATTRIBUTE13,
3434: r.ATTRIBUTE14,
3435: r.ATTRIBUTE15
3436: from
3437: bom_reference_designators r
3438: --added abs() was model_comp_seq would be -ve value
3439: where r.component_sequence_id = abs(model_comp_seq_id_arr(x1))
3440: and nvl(r.acd_type,0) <> 3;
3441: exception

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

3440: and nvl(r.acd_type,0) <> 3;
3441: exception
3442: when others then
3443: IF PG_DEBUG <> 0 THEN
3444: oe_debug_pub.add ('The record for this designator and component sequence already exists in BOM_REFERENCE_DESIGNATORS', 1);
3445: END IF;
3446: end;
3447: IF PG_DEBUG <> 0 THEN
3448: oe_debug_pub.add ('For this record '||sql%rowcount||' records are inserted in bom_reference_designators', 1);

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

3444: oe_debug_pub.add ('The record for this designator and component sequence already exists in BOM_REFERENCE_DESIGNATORS', 1);
3445: END IF;
3446: end;
3447: IF PG_DEBUG <> 0 THEN
3448: oe_debug_pub.add ('For this record '||sql%rowcount||' records are inserted in bom_reference_designators', 1);
3449: END if;
3450: end loop; -- 3985173 : end of club_comp_seq cursor loop
3451: prev_comp_item_id := component_item_id_arr(x1); -- 3985173
3452: