APPS.WMS_ELS_INDIVIDUAL_TASKS_PKG dependencies on WMS_ELS_INDIVIDUAL_TASKS_B

Line 60: cursor C is select ROWID from WMS_ELS_INDIVIDUAL_TASKS_B

56: X_LAST_UPDATE_DATE in DATE,
57: X_LAST_UPDATED_BY in NUMBER,
58: X_LAST_UPDATE_LOGIN in NUMBER
59: ) is
60: cursor C is select ROWID from WMS_ELS_INDIVIDUAL_TASKS_B
61: where ELS_DATA_ID = X_ELS_DATA_ID
62: ;
63: begin
64: insert into WMS_ELS_INDIVIDUAL_TASKS_B (

Line 64: insert into WMS_ELS_INDIVIDUAL_TASKS_B (

60: cursor C is select ROWID from WMS_ELS_INDIVIDUAL_TASKS_B
61: where ELS_DATA_ID = X_ELS_DATA_ID
62: ;
63: begin
64: insert into WMS_ELS_INDIVIDUAL_TASKS_B (
65: ATTRIBUTE_CATEGORY,
66: ATTRIBUTE1,
67: ATTRIBUTE2,
68: ATTRIBUTE3,

Line 310: from WMS_ELS_INDIVIDUAL_TASKS_B

306: TRAVEL_TIME_THRESHOLD,
307: HISTORY_FLAG,
308: ARCHIVE_DATE,
309: NUM_TRX_MATCHED
310: from WMS_ELS_INDIVIDUAL_TASKS_B
311: where ELS_DATA_ID = X_ELS_DATA_ID
312: for update of ELS_DATA_ID nowait;
313: recinfo c%rowtype;
314:

Line 498: update WMS_ELS_INDIVIDUAL_TASKS_B set

494: X_LAST_UPDATED_BY in NUMBER,
495: X_LAST_UPDATE_LOGIN in NUMBER
496: ) is
497: begin
498: update WMS_ELS_INDIVIDUAL_TASKS_B set
499: ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
500: ATTRIBUTE1 = X_ATTRIBUTE1,
501: ATTRIBUTE2 = X_ATTRIBUTE2,
502: ATTRIBUTE3 = X_ATTRIBUTE3,

Line 582: delete from WMS_ELS_INDIVIDUAL_TASKS_B

578: if (sql%notfound) then
579: raise no_data_found;
580: end if;
581:
582: delete from WMS_ELS_INDIVIDUAL_TASKS_B
583: where ELS_DATA_ID = X_ELS_DATA_ID;
584:
585: if (sql%notfound) then
586: raise no_data_found;

Line 599: from WMS_ELS_INDIVIDUAL_TASKS_B B

595: begin
596: delete from WMS_ELS_INDIVIDUAL_TASKS_TL T
597: where not exists
598: (select NULL
599: from WMS_ELS_INDIVIDUAL_TASKS_B B
600: where B.ELS_DATA_ID = T.ELS_DATA_ID
601: );
602:
603: update WMS_ELS_INDIVIDUAL_TASKS_TL T set (