APPS.BOM_STRUCTURES_EXT_PKG dependencies on BOM_STRUCTURES_EXT_B

Line 151: CURSOR C IS SELECT ROWID FROM BOM_STRUCTURES_EXT_B

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

Line 155: INSERT INTO BOM_STRUCTURES_EXT_B (

151: CURSOR C IS SELECT ROWID FROM BOM_STRUCTURES_EXT_B
152: WHERE EXTENSION_ID = X_EXTENSION_ID
153: ;
154: BEGIN
155: INSERT INTO BOM_STRUCTURES_EXT_B (
156: N_EXT_ATTR3,
157: N_EXT_ATTR4,
158: N_EXT_ATTR5,
159: N_EXT_ATTR6,

Line 727: FROM BOM_STRUCTURES_EXT_B

723: C_EXT_ATTR17,
724: C_EXT_ATTR18,
725: C_EXT_ATTR19,
726: BILL_SEQUENCE_ID
727: FROM BOM_STRUCTURES_EXT_B
728: WHERE EXTENSION_ID = X_EXTENSION_ID
729: FOR UPDATE OF EXTENSION_ID NOWAIT;
730: recinfo c%ROWTYPE;
731:

Line 1219: UPDATE BOM_STRUCTURES_EXT_B SET

1215: X_LAST_UPDATED_BY IN NUMBER,
1216: X_LAST_UPDATE_LOGIN IN NUMBER
1217: ) IS
1218: BEGIN
1219: UPDATE BOM_STRUCTURES_EXT_B SET
1220: N_EXT_ATTR3 = X_N_EXT_ATTR3,
1221: N_EXT_ATTR4 = X_N_EXT_ATTR4,
1222: N_EXT_ATTR5 = X_N_EXT_ATTR5,
1223: N_EXT_ATTR6 = X_N_EXT_ATTR6,

Line 1389: DELETE FROM BOM_STRUCTURES_EXT_B

1385: IF (SQL%NOTFOUND) THEN
1386: RAISE NO_DATA_FOUND;
1387: END IF;
1388:
1389: DELETE FROM BOM_STRUCTURES_EXT_B
1390: WHERE EXTENSION_ID = X_EXTENSION_ID;
1391:
1392: IF (SQL%NOTFOUND) THEN
1393: RAISE NO_DATA_FOUND;

Line 1403: FROM BOM_STRUCTURES_EXT_B B

1399: BEGIN
1400: DELETE FROM BOM_STRUCTURES_EXT_TL T
1401: WHERE NOT EXISTS
1402: (SELECT NULL
1403: FROM BOM_STRUCTURES_EXT_B B
1404: WHERE B.EXTENSION_ID = T.EXTENSION_ID
1405: );
1406:
1407: UPDATE BOM_STRUCTURES_EXT_TL T SET (