DBA Data[Home] [Help]

APPS.BOM_REF_DESIG_PKG dependencies on BOM_REFERENCE_DESIGNATORS

Line 20: (SELECT 1 from bom_reference_designators

16: dummy NUMBER;
17: BEGIN
18: SELECT 1 into dummy from dual
19: WHERE NOT EXISTS
20: (SELECT 1 from bom_reference_designators
21: WHERE component_sequence_id = X_component_sequence_id
22: AND component_reference_designator = X_designator
23: AND ((acd_type is null) OR (acd_type <> 3))
24: AND ((X_rowid is NULL) OR (rowid <> X_rowid))

Line 47: bom_reference_designators brd

43: --* or unimplemented status. If the reference designator is being added
44: --* for the first time, furthur validations will be ignored.
45: SELECT Count(1) INTO rec_exist
46: FROM Bom_Inventory_Components bic,
47: bom_reference_designators brd
48: WHERE Nvl(bic.Old_Component_Sequence_Id,bic.Component_Sequence_Id) = X_Old_Component_Sequence_Id
49: AND Nvl(bic.Change_Notice,'*') <> X_Change_Notice
50: AND brd.component_sequence_id = bic.component_sequence_id
51: AND brd.component_reference_designator = X_Designator

Line 69: FROM Bom_Reference_Designators

65: --* to fetch only ADD record's acd type (1). So added rownum condition and
66: --* included order by clause.
67:
68: SELECT Acd_Type INTO rec_exist
69: FROM Bom_Reference_Designators
70: WHERE Component_Sequence_Id = ( SELECT Max(bic.Component_Sequence_Id)
71: FROM Bom_Inventory_Components bic,
72: bom_reference_designators brd
73: WHERE bic.Old_Component_Sequence_Id = X_Old_Component_Sequence_Id

Line 72: bom_reference_designators brd

68: SELECT Acd_Type INTO rec_exist
69: FROM Bom_Reference_Designators
70: WHERE Component_Sequence_Id = ( SELECT Max(bic.Component_Sequence_Id)
71: FROM Bom_Inventory_Components bic,
72: bom_reference_designators brd
73: WHERE bic.Old_Component_Sequence_Id = X_Old_Component_Sequence_Id
74: AND bic.Change_Notice <> X_Change_Notice
75: AND bic.Implementation_Date IS NULL
76: AND brd.component_sequence_id = bic.component_sequence_id

Line 92: (SELECT 1 FROM bom_reference_designators

88: --* DISABLE record exists in the current block
89: SELECT 0 INTO disable_exist
90: FROM dual
91: WHERE NOT EXISTS
92: (SELECT 1 FROM bom_reference_designators
93: WHERE component_sequence_id = X_Component_Sequence_Id
94: AND component_reference_designator = X_Designator
95: AND acd_type = 3);
96:

Line 155: CURSOR C IS SELECT rowid FROM BOM_REFERENCE_DESIGNATORS

151: X_Attribute13 VARCHAR2,
152: X_Attribute14 VARCHAR2,
153: X_Attribute15 VARCHAR2
154: ) IS
155: CURSOR C IS SELECT rowid FROM BOM_REFERENCE_DESIGNATORS
156: WHERE component_sequence_id = X_Component_Sequence_Id
157: AND ( (acd_type = X_Acd_Type)
158: or (acd_type is NULL and X_Acd_Type is NULL));
159: l_err_tbl Error_Handler.Mesg_Token_Tbl_Type;

Line 165: INSERT INTO BOM_REFERENCE_DESIGNATORS(

161:
162: BEGIN
163:
164:
165: INSERT INTO BOM_REFERENCE_DESIGNATORS(
166: component_reference_designator,
167: last_update_date,
168: last_updated_by,
169: creation_date,

Line 270: FROM BOM_REFERENCE_DESIGNATORS

266: X_Attribute15 VARCHAR2
267: ) IS
268: CURSOR C IS
269: SELECT *
270: FROM BOM_REFERENCE_DESIGNATORS
271: WHERE rowid = X_Rowid
272: FOR UPDATE of Component_Sequence_Id NOWAIT;
273: Recinfo C%ROWTYPE;
274:

Line 390: FROM BOM_REFERENCE_DESIGNATORS

386: BEGIN
387:
388: SELECT COMPONENT_REFERENCE_DESIGNATOR, ACD_TYPE
389: INTO l_old_ref_desg, l_acd_type
390: FROM BOM_REFERENCE_DESIGNATORS
391: WHERE rowid = X_Rowid;
392:
393: UPDATE BOM_REFERENCE_DESIGNATORS
394: SET

Line 393: UPDATE BOM_REFERENCE_DESIGNATORS

389: INTO l_old_ref_desg, l_acd_type
390: FROM BOM_REFERENCE_DESIGNATORS
391: WHERE rowid = X_Rowid;
392:
393: UPDATE BOM_REFERENCE_DESIGNATORS
394: SET
395: component_reference_designator = X_Component_Ref_Desig,
396: last_update_date = X_Last_Update_Date,
397: last_updated_by = X_Last_Updated_By,

Line 451: From BOM_REFERENCE_DESIGNATORS

447: BEGIN
448:
449: Select component_sequence_id, component_reference_designator
450: into l_common_component_sequence_id, l_ref_desg
451: From BOM_REFERENCE_DESIGNATORS
452: WHERE rowid = X_Rowid;
453:
454:
455: DELETE FROM BOM_REFERENCE_DESIGNATORS

Line 455: DELETE FROM BOM_REFERENCE_DESIGNATORS

451: From BOM_REFERENCE_DESIGNATORS
452: WHERE rowid = X_Rowid;
453:
454:
455: DELETE FROM BOM_REFERENCE_DESIGNATORS
456: WHERE rowid = X_Rowid;
457:
458: if (SQL%NOTFOUND) then
459: Raise NO_DATA_FOUND;