APPS.IBC_LABELS_PKG dependencies on IBC_LABELS_B

Line 27: CURSOR C IS SELECT ROWID FROM IBC_LABELS_B

23: p_LAST_UPDATE_DATE IN DATE,
24: p_LAST_UPDATED_BY IN NUMBER,
25: p_LAST_UPDATE_LOGIN IN NUMBER
26: ) IS
27: CURSOR C IS SELECT ROWID FROM IBC_LABELS_B
28: WHERE LABEL_CODE = p_LABEL_CODE
29: ;
30: BEGIN
31: INSERT INTO IBC_LABELS_B (

Line 31: INSERT INTO IBC_LABELS_B (

27: CURSOR C IS SELECT ROWID FROM IBC_LABELS_B
28: WHERE LABEL_CODE = p_LABEL_CODE
29: ;
30: BEGIN
31: INSERT INTO IBC_LABELS_B (
32: LABEL_CODE,
33: OBJECT_VERSION_NUMBER,
34: CREATION_DATE,
35: CREATED_BY,

Line 107: FROM IBC_LABELS_B

103: p_DESCRIPTION IN VARCHAR2
104: ) IS
105: CURSOR c IS SELECT
106: OBJECT_VERSION_NUMBER
107: FROM IBC_LABELS_B
108: WHERE LABEL_CODE = p_LABEL_CODE
109: FOR UPDATE OF LABEL_CODE NOWAIT;
110: recinfo c%ROWTYPE;
111:

Line 163: UPDATE IBC_LABELS_B SET

159: p_LAST_UPDATE_LOGIN IN NUMBER,
160: p_OBJECT_VERSION_NUMBER IN NUMBER
161: ) IS
162: BEGIN
163: UPDATE IBC_LABELS_B SET
164: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
165: last_update_date = DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE,
166: NULL, SYSDATE, p_last_update_date),
167: last_updated_by = DECODE(p_last_updated_by, FND_API.G_MISS_NUM,

Line 214: DELETE FROM IBC_LABELS_B

210: IF (SQL%NOTFOUND) THEN
211: RAISE NO_DATA_FOUND;
212: END IF;
213:
214: DELETE FROM IBC_LABELS_B
215: WHERE LABEL_CODE = p_LABEL_CODE;
216:
217: IF (SQL%NOTFOUND) THEN
218: RAISE NO_DATA_FOUND;

Line 228: FROM IBC_LABELS_B B

224: BEGIN
225: DELETE FROM IBC_LABELS_TL T
226: WHERE NOT EXISTS
227: (SELECT NULL
228: FROM IBC_LABELS_B B
229: WHERE B.LABEL_CODE = T.LABEL_CODE
230: );
231:
232: UPDATE IBC_LABELS_TL T SET (