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.CTO_UPDATE_BOM_RTG_PK dependencies on BOM_REFERENCE_DESIGNATORS

Line 23: | table bom_reference_designators should |

19: | |
20: | |
21: | |
22: | 04/19/04 Sushant fixed bug 3529592. Insert query for |
23: | table bom_reference_designators should |
24: | check for null values for column acd_type. |
25: | |
26: |
27: | Modified : 14-MAY-2004 Sushant Sawant

Line 4627: Insert into BOM_REFERENCE_DESIGNATORS table

4623:
4624:
4625:
4626: /* -------------------------------------------------------------------------+
4627: Insert into BOM_REFERENCE_DESIGNATORS table
4628: +--------------------------------------------------------------------------*/
4629: IF PG_DEBUG <> 0 THEN
4630: WriteToLog('create_bom_data_ml: ' || 'Before third insert into bom_reference_designators. ', 2);
4631: END IF;

Line 4630: WriteToLog('create_bom_data_ml: ' || 'Before third insert into bom_reference_designators. ', 2);

4626: /* -------------------------------------------------------------------------+
4627: Insert into BOM_REFERENCE_DESIGNATORS table
4628: +--------------------------------------------------------------------------*/
4629: IF PG_DEBUG <> 0 THEN
4630: WriteToLog('create_bom_data_ml: ' || 'Before third insert into bom_reference_designators. ', 2);
4631: END IF;
4632: lStmtNum := 320;
4633: xTableName := 'BOM_REFERENCE_DESIGNATORS';
4634: insert into BOM_REFERENCE_DESIGNATORS

Line 4633: xTableName := 'BOM_REFERENCE_DESIGNATORS';

4629: IF PG_DEBUG <> 0 THEN
4630: WriteToLog('create_bom_data_ml: ' || 'Before third insert into bom_reference_designators. ', 2);
4631: END IF;
4632: lStmtNum := 320;
4633: xTableName := 'BOM_REFERENCE_DESIGNATORS';
4634: insert into BOM_REFERENCE_DESIGNATORS
4635: (
4636: component_reference_designator,
4637: last_update_date,

Line 4634: insert into BOM_REFERENCE_DESIGNATORS

4630: WriteToLog('create_bom_data_ml: ' || 'Before third insert into bom_reference_designators. ', 2);
4631: END IF;
4632: lStmtNum := 320;
4633: xTableName := 'BOM_REFERENCE_DESIGNATORS';
4634: insert into BOM_REFERENCE_DESIGNATORS
4635: (
4636: component_reference_designator,
4637: last_update_date,
4638: last_updated_by,

Line 4700: bom_reference_designators r,

4696: r.ATTRIBUTE14,
4697: r.ATTRIBUTE15
4698: from
4699: bom_inventory_components ic,
4700: bom_reference_designators r,
4701: bom_bill_of_materials b
4702: where b.assembly_item_id = pConfigId
4703: and b.organization_id = pOrgId
4704: and ic.bill_sequence_id = b.bill_sequence_id

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

4756:
4757: club_component_sequence_id := a1.comp_seq_id;
4758:
4759:
4760: -- insert into BOM_REFERENCE_DESIGNATORS for the corresponding model_comp_seq_id
4761: -- if it has not already been inserted.
4762: IF PG_DEBUG <> 0 THEN
4763: WriteToLog('club_component_sequence_id is '||club_component_sequence_id, 1);
4764: END if;

Line 4766: WriteToLog('Trying to insert into BOM_REFERENCE_DESIGNATORS', 1);

4762: IF PG_DEBUG <> 0 THEN
4763: WriteToLog('club_component_sequence_id is '||club_component_sequence_id, 1);
4764: END if;
4765: IF PG_DEBUG <> 0 THEN
4766: WriteToLog('Trying to insert into BOM_REFERENCE_DESIGNATORS', 1);
4767: END if;
4768: begin
4769: insert into BOM_REFERENCE_DESIGNATORS
4770: (

Line 4769: insert into BOM_REFERENCE_DESIGNATORS

4765: IF PG_DEBUG <> 0 THEN
4766: WriteToLog('Trying to insert into BOM_REFERENCE_DESIGNATORS', 1);
4767: END if;
4768: begin
4769: insert into BOM_REFERENCE_DESIGNATORS
4770: (
4771: component_reference_designator,
4772: last_update_date,
4773: last_updated_by,

Line 4834: bom_reference_designators r

4830: r.ATTRIBUTE13,
4831: r.ATTRIBUTE14,
4832: r.ATTRIBUTE15
4833: from
4834: bom_reference_designators r
4835: where r.component_sequence_id = abs(model_comp_seq_id_arr(x1))
4836: and nvl(r.acd_type,0) <> 3;
4837:
4838: --moved here for 4492875

Line 4840: WriteToLog('For this record '||sql%rowcount||' records are inserted in bom_reference_designators', 1);

4836: and nvl(r.acd_type,0) <> 3;
4837:
4838: --moved here for 4492875
4839: IF PG_DEBUG <> 0 THEN
4840: WriteToLog('For this record '||sql%rowcount||' records are inserted in bom_reference_designators', 1);
4841: END if;
4842: exception
4843: when others then
4844: IF PG_DEBUG <> 0 THEN

Line 4845: WriteToLog('The record for this designator and component sequence already exists in BOM_REFERENCE_DESIGNATORS', 1);

4841: END if;
4842: exception
4843: when others then
4844: IF PG_DEBUG <> 0 THEN
4845: WriteToLog('The record for this designator and component sequence already exists in BOM_REFERENCE_DESIGNATORS', 1);
4846: END IF;
4847: end;
4848:
4849: end loop; -- 3985173 : end of club_comp_seq cursor loop

Line 5555: Insert into BOM_REFERENCE_DESIGNATORS table

5551: WriteToLog('Inserted rows into bom_operation_networks::'||sql%rowcount, 3);
5552:
5553:
5554: /* -------------------------------------------------------------------------+
5555: Insert into BOM_REFERENCE_DESIGNATORS table
5556: HAS BEEN REMOVED AS PART OF BUGFIX 3793286
5557: as there is already a insert in this table in api update_bom_rtg_loop.
5558: For additional details look at update *** KKONADA 11/05/04 03:43 pm ***
5559: of bug 3793286