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 4810: Insert into BOM_REFERENCE_DESIGNATORS table

4806:
4807:
4808:
4809: /* -------------------------------------------------------------------------+
4810: Insert into BOM_REFERENCE_DESIGNATORS table
4811: +--------------------------------------------------------------------------*/
4812: IF PG_DEBUG <> 0 THEN
4813: WriteToLog('create_bom_data_ml: ' || 'Before third insert into bom_reference_designators. ', 2);
4814: END IF;

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

4809: /* -------------------------------------------------------------------------+
4810: Insert into BOM_REFERENCE_DESIGNATORS table
4811: +--------------------------------------------------------------------------*/
4812: IF PG_DEBUG <> 0 THEN
4813: WriteToLog('create_bom_data_ml: ' || 'Before third insert into bom_reference_designators. ', 2);
4814: END IF;
4815: lStmtNum := 320;
4816: xTableName := 'BOM_REFERENCE_DESIGNATORS';
4817: insert into BOM_REFERENCE_DESIGNATORS

Line 4816: xTableName := 'BOM_REFERENCE_DESIGNATORS';

4812: IF PG_DEBUG <> 0 THEN
4813: WriteToLog('create_bom_data_ml: ' || 'Before third insert into bom_reference_designators. ', 2);
4814: END IF;
4815: lStmtNum := 320;
4816: xTableName := 'BOM_REFERENCE_DESIGNATORS';
4817: insert into BOM_REFERENCE_DESIGNATORS
4818: (
4819: component_reference_designator,
4820: last_update_date,

Line 4817: insert into BOM_REFERENCE_DESIGNATORS

4813: WriteToLog('create_bom_data_ml: ' || 'Before third insert into bom_reference_designators. ', 2);
4814: END IF;
4815: lStmtNum := 320;
4816: xTableName := 'BOM_REFERENCE_DESIGNATORS';
4817: insert into BOM_REFERENCE_DESIGNATORS
4818: (
4819: component_reference_designator,
4820: last_update_date,
4821: last_updated_by,

Line 4891: bom_reference_designators r,

4887: r.ATTRIBUTE14,
4888: r.ATTRIBUTE15
4889: from
4890: bom_inventory_components ic,
4891: bom_reference_designators r,
4892: bom_bill_of_materials b
4893: where b.assembly_item_id = pConfigId
4894: and b.organization_id = pOrgId
4895: and ic.bill_sequence_id = b.bill_sequence_id

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

4947:
4948: club_component_sequence_id := a1.comp_seq_id;
4949:
4950:
4951: -- insert into BOM_REFERENCE_DESIGNATORS for the corresponding model_comp_seq_id
4952: -- if it has not already been inserted.
4953: IF PG_DEBUG <> 0 THEN
4954: WriteToLog('club_component_sequence_id is '||club_component_sequence_id, 1);
4955: END if;

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

4953: IF PG_DEBUG <> 0 THEN
4954: WriteToLog('club_component_sequence_id is '||club_component_sequence_id, 1);
4955: END if;
4956: IF PG_DEBUG <> 0 THEN
4957: WriteToLog('Trying to insert into BOM_REFERENCE_DESIGNATORS', 1);
4958: END if;
4959: begin
4960: insert into BOM_REFERENCE_DESIGNATORS
4961: (

Line 4960: insert into BOM_REFERENCE_DESIGNATORS

4956: IF PG_DEBUG <> 0 THEN
4957: WriteToLog('Trying to insert into BOM_REFERENCE_DESIGNATORS', 1);
4958: END if;
4959: begin
4960: insert into BOM_REFERENCE_DESIGNATORS
4961: (
4962: component_reference_designator,
4963: last_update_date,
4964: last_updated_by,

Line 5033: bom_reference_designators r

5029: r.ATTRIBUTE13,
5030: r.ATTRIBUTE14,
5031: r.ATTRIBUTE15
5032: from
5033: bom_reference_designators r
5034: where r.component_sequence_id = abs(model_comp_seq_id_arr(x1))
5035: and nvl(r.acd_type,0) <> 3;
5036:
5037: --moved here for 4492875

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

5035: and nvl(r.acd_type,0) <> 3;
5036:
5037: --moved here for 4492875
5038: IF PG_DEBUG <> 0 THEN
5039: WriteToLog('For this record '||sql%rowcount||' records are inserted in bom_reference_designators', 1);
5040: END if;
5041: exception
5042: when others then
5043: IF PG_DEBUG <> 0 THEN

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

5040: END if;
5041: exception
5042: when others then
5043: IF PG_DEBUG <> 0 THEN
5044: WriteToLog('The record for this designator and component sequence already exists in BOM_REFERENCE_DESIGNATORS', 1);
5045: END IF;
5046: end;
5047:
5048: end loop; -- 3985173 : end of club_comp_seq cursor loop

Line 5764: Insert into BOM_REFERENCE_DESIGNATORS table

5760: WriteToLog('Inserted rows into bom_operation_networks::'||sql%rowcount, 3);
5761:
5762:
5763: /* -------------------------------------------------------------------------+
5764: Insert into BOM_REFERENCE_DESIGNATORS table
5765: HAS BEEN REMOVED AS PART OF BUGFIX 3793286
5766: as there is already a insert in this table in api update_bom_rtg_loop.
5767: For additional details look at update *** KKONADA 11/05/04 03:43 pm ***
5768: of bug 3793286