APPS.BOM_SUB_COMPS_PKG dependencies on BOM_SUBSTITUTE_COMPONENTS

Line 38: (SELECT 'x' FROM bom_substitute_components

34: SELECT 1
35: INTO dummy
36: FROM dual
37: WHERE not exists
38: (SELECT 'x' FROM bom_substitute_components
39: WHERE nvl(acd_type, 1) = nvl(X_acd_type, 1)
40: AND substitute_component_id = X_sub_comp_id
41: AND component_sequence_id = X_comp_seq_id
42: AND ((X_row_id is NULL) OR (rowid <> X_row_id))

Line 113: CURSOR C IS SELECT rowid FROM BOM_SUBSTITUTE_COMPONENTS

109: X_Attribute14 VARCHAR2,
110: X_Attribute15 VARCHAR2,
111: X_Enforce_Int_Requirements NUMBER DEFAULT NULL
112: ) IS
113: CURSOR C IS SELECT rowid FROM BOM_SUBSTITUTE_COMPONENTS
114: WHERE component_sequence_id = X_Component_Sequence_Id
115: AND ( (acd_type = X_Acd_Type)
116: or (acd_type is NULL and X_Acd_Type is NULL));
117:

Line 124: INSERT INTO BOM_SUBSTITUTE_COMPONENTS(

120:
121: BEGIN
122:
123:
124: INSERT INTO BOM_SUBSTITUTE_COMPONENTS(
125: substitute_component_id,
126: last_update_date,
127: last_updated_by,
128: creation_date,

Line 231: FROM BOM_SUBSTITUTE_COMPONENTS

227: X_Enforce_Int_Requirements NUMBER DEFAULT NULL
228: ) IS
229: CURSOR C IS
230: SELECT *
231: FROM BOM_SUBSTITUTE_COMPONENTS
232: WHERE rowid = X_Rowid
233: FOR UPDATE of Component_Sequence_Id NOWAIT;
234: Recinfo C%ROWTYPE;
235:

Line 352: FROM BOM_SUBSTITUTE_COMPONENTS

348: l_acd_type NUMBER;
349: BEGIN
350: SELECT substitute_component_id, ACD_TYPE
351: INTO l_old_sub_comp_id, l_acd_type
352: FROM BOM_SUBSTITUTE_COMPONENTS
353: WHERE rowid = X_Rowid;
354:
355: UPDATE BOM_SUBSTITUTE_COMPONENTS
356: SET

Line 355: UPDATE BOM_SUBSTITUTE_COMPONENTS

351: INTO l_old_sub_comp_id, l_acd_type
352: FROM BOM_SUBSTITUTE_COMPONENTS
353: WHERE rowid = X_Rowid;
354:
355: UPDATE BOM_SUBSTITUTE_COMPONENTS
356: SET
357: substitute_component_id = X_Substitute_Component_Id,
358: last_update_date = X_Last_Update_Date,
359: last_updated_by = X_Last_Updated_By,

Line 413: From BOM_SUBSTITUTE_COMPONENTS

409: l_return_status VARCHAR2(1);
410: BEGIN
411: Select component_sequence_id, substitute_component_id
412: into l_common_component_sequence_id, l_sub_comp_id
413: From BOM_SUBSTITUTE_COMPONENTS
414: WHERE rowid = X_Rowid;
415:
416:
417: DELETE FROM BOM_SUBSTITUTE_COMPONENTS

Line 417: DELETE FROM BOM_SUBSTITUTE_COMPONENTS

413: From BOM_SUBSTITUTE_COMPONENTS
414: WHERE rowid = X_Rowid;
415:
416:
417: DELETE FROM BOM_SUBSTITUTE_COMPONENTS
418: WHERE rowid = X_Rowid;
419:
420: if (SQL%NOTFOUND) then
421: Raise NO_DATA_FOUND;