APPS.BOM_COMPONENTS_EXT_PKG dependencies on BOM_COMPONENTS_EXT_B

Line 149: CURSOR C IS SELECT ROWID FROM BOM_COMPONENTS_EXT_B

145: X_LAST_UPDATE_DATE IN DATE,
146: X_LAST_UPDATED_BY IN NUMBER,
147: X_LAST_UPDATE_LOGIN IN NUMBER
148: ) IS
149: CURSOR C IS SELECT ROWID FROM BOM_COMPONENTS_EXT_B
150: WHERE EXTENSION_ID = X_EXTENSION_ID
151: ;
152: BEGIN
153: INSERT INTO BOM_COMPONENTS_EXT_B (

Line 153: INSERT INTO BOM_COMPONENTS_EXT_B (

149: CURSOR C IS SELECT ROWID FROM BOM_COMPONENTS_EXT_B
150: WHERE EXTENSION_ID = X_EXTENSION_ID
151: ;
152: BEGIN
153: INSERT INTO BOM_COMPONENTS_EXT_B (
154: N_EXT_ATTR14,
155: N_EXT_ATTR15,
156: N_EXT_ATTR16,
157: N_EXT_ATTR17,

Line 713: FROM BOM_COMPONENTS_EXT_B

709: N_EXT_ATTR10,
710: N_EXT_ATTR11,
711: N_EXT_ATTR12,
712: N_EXT_ATTR13
713: FROM BOM_COMPONENTS_EXT_B
714: WHERE EXTENSION_ID = X_EXTENSION_ID
715: FOR UPDATE OF EXTENSION_ID NOWAIT;
716: recinfo c%ROWTYPE;
717:

Line 1199: UPDATE BOM_COMPONENTS_EXT_B SET

1195: X_LAST_UPDATED_BY IN NUMBER,
1196: X_LAST_UPDATE_LOGIN IN NUMBER
1197: ) IS
1198: BEGIN
1199: UPDATE BOM_COMPONENTS_EXT_B SET
1200: N_EXT_ATTR14 = X_N_EXT_ATTR14,
1201: N_EXT_ATTR15 = X_N_EXT_ATTR15,
1202: N_EXT_ATTR16 = X_N_EXT_ATTR16,
1203: N_EXT_ATTR17 = X_N_EXT_ATTR17,

Line 1367: DELETE FROM BOM_COMPONENTS_EXT_B

1363: IF (SQL%NOTFOUND) THEN
1364: RAISE NO_DATA_FOUND;
1365: END IF;
1366:
1367: DELETE FROM BOM_COMPONENTS_EXT_B
1368: WHERE EXTENSION_ID = X_EXTENSION_ID;
1369:
1370: IF (SQL%NOTFOUND) THEN
1371: RAISE NO_DATA_FOUND;

Line 1381: FROM BOM_COMPONENTS_EXT_B B

1377: BEGIN
1378: DELETE FROM BOM_COMPONENTS_EXT_TL T
1379: WHERE NOT EXISTS
1380: (SELECT NULL
1381: FROM BOM_COMPONENTS_EXT_B B
1382: WHERE B.EXTENSION_ID = T.EXTENSION_ID
1383: );
1384:
1385: UPDATE BOM_COMPONENTS_EXT_TL T SET (