APPS.WMS_TASK_FILTER_PKG dependencies on WMS_TASK_FILTER_B

Line 32: cursor C is select ROWID from WMS_TASK_FILTER_B

28: X_LAST_UPDATE_DATE in DATE,
29: X_LAST_UPDATED_BY in NUMBER,
30: X_LAST_UPDATE_LOGIN in NUMBER
31: ) is
32: cursor C is select ROWID from WMS_TASK_FILTER_B
33: where TASK_FILTER_ID = X_TASK_FILTER_ID
34: ;
35: begin
36: insert into WMS_TASK_FILTER_B (

Line 36: insert into WMS_TASK_FILTER_B (

32: cursor C is select ROWID from WMS_TASK_FILTER_B
33: where TASK_FILTER_ID = X_TASK_FILTER_ID
34: ;
35: begin
36: insert into WMS_TASK_FILTER_B (
37: TASK_FILTER_ID,
38: TASK_FILTER_NAME,
39: ATTRIBUTE_CATEGORY,
40: ATTRIBUTE1,

Line 166: from WMS_TASK_FILTER_B

162: ATTRIBUTE12,
163: ATTRIBUTE13,
164: ATTRIBUTE14,
165: ATTRIBUTE15
166: from WMS_TASK_FILTER_B
167: where TASK_FILTER_ID = X_TASK_FILTER_ID
168: for update of TASK_FILTER_ID nowait;
169: recinfo c%rowtype;
170:

Line 270: update WMS_TASK_FILTER_B set

266: X_LAST_UPDATED_BY in NUMBER,
267: X_LAST_UPDATE_LOGIN in NUMBER
268: ) is
269: begin
270: update WMS_TASK_FILTER_B set
271: TASK_FILTER_NAME = X_TASK_FILTER_NAME,
272: ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
273: ATTRIBUTE1 = X_ATTRIBUTE1,
274: ATTRIBUTE2 = X_ATTRIBUTE2,

Line 323: delete from WMS_TASK_FILTER_B

319: if (sql%notfound) then
320: raise no_data_found;
321: end if;
322:
323: delete from WMS_TASK_FILTER_B
324: where TASK_FILTER_ID = X_TASK_FILTER_ID;
325:
326: if (sql%notfound) then
327: raise no_data_found;

Line 337: from WMS_TASK_FILTER_B B

333: begin
334: delete from WMS_TASK_FILTER_TL T
335: where not exists
336: (select NULL
337: from WMS_TASK_FILTER_B B
338: where B.TASK_FILTER_ID = T.TASK_FILTER_ID
339: );
340:
341: update WMS_TASK_FILTER_TL T set (

Line 451: from WMS_TASK_FILTER_B

447: begin
448: -- translate values to IDs
449: select TASK_FILTER_ID, LAST_UPDATED_BY, LAST_UPDATE_DATE
450: into l_TASK_FILTER_ID, db_luby, db_ludate
451: from WMS_TASK_FILTER_B
452: where TASK_FILTER_NAME = X_TASK_FILTER_NAME;
453:
454: -- Test for customization and version
455: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

Line 552: from WMS_TASK_FILTER_B

548:
549: -- translate values to IDs
550: select TASK_FILTER_ID, LAST_UPDATED_BY, LAST_UPDATE_DATE
551: into l_TASK_FILTER_ID, db_luby, db_ludate
552: from WMS_TASK_FILTER_B
553: where TASK_FILTER_NAME = X_TASK_FILTER_NAME;
554:
555: -- Test for customization and version
556: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,