APPS.WMS_ELS_GROUPED_TASKS_PKG dependencies on WMS_ELS_GROUPED_TASKS_B

Line 46: cursor C is select ROWID from WMS_ELS_GROUPED_TASKS_B

42: X_LAST_UPDATE_DATE in DATE,
43: X_LAST_UPDATED_BY in NUMBER,
44: X_LAST_UPDATE_LOGIN in NUMBER
45: ) is
46: cursor C is select ROWID from WMS_ELS_GROUPED_TASKS_B
47: where ELS_GROUP_ID = X_ELS_GROUP_ID
48: ;
49: begin
50: insert into WMS_ELS_GROUPED_TASKS_B (

Line 50: insert into WMS_ELS_GROUPED_TASKS_B (

46: cursor C is select ROWID from WMS_ELS_GROUPED_TASKS_B
47: where ELS_GROUP_ID = X_ELS_GROUP_ID
48: ;
49: begin
50: insert into WMS_ELS_GROUPED_TASKS_B (
51: ATTRIBUTE13,
52: ATTRIBUTE14,
53: ATTRIBUTE15,
54: ELS_GROUP_ID,

Line 240: from WMS_ELS_GROUPED_TASKS_B

236: ATTRIBUTE9,
237: ATTRIBUTE10,
238: ATTRIBUTE11,
239: ATTRIBUTE12
240: from WMS_ELS_GROUPED_TASKS_B
241: where ELS_GROUP_ID = X_ELS_GROUP_ID
242: for update of ELS_GROUP_ID nowait;
243: recinfo c%rowtype;
244:

Line 388: update WMS_ELS_GROUPED_TASKS_B set

384: X_LAST_UPDATED_BY in NUMBER,
385: X_LAST_UPDATE_LOGIN in NUMBER
386: ) is
387: begin
388: update WMS_ELS_GROUPED_TASKS_B set
389: ATTRIBUTE13 = X_ATTRIBUTE13,
390: ATTRIBUTE14 = X_ATTRIBUTE14,
391: ATTRIBUTE15 = X_ATTRIBUTE15,
392: ORGANIZATION_ID = X_ORGANIZATION_ID,

Line 457: delete from WMS_ELS_GROUPED_TASKS_B

453: if (sql%notfound) then
454: raise no_data_found;
455: end if;
456:
457: delete from WMS_ELS_GROUPED_TASKS_B
458: where ELS_GROUP_ID = X_ELS_GROUP_ID;
459:
460: if (sql%notfound) then
461: raise no_data_found;

Line 474: from WMS_ELS_GROUPED_TASKS_B B

470: begin
471: delete from WMS_ELS_GROUPED_TASKS_TL T
472: where not exists
473: (select NULL
474: from WMS_ELS_GROUPED_TASKS_B B
475: where B.ELS_GROUP_ID = T.ELS_GROUP_ID
476: );
477:
478: update WMS_ELS_GROUPED_TASKS_TL T set (