APPS.WMS_TASK_RELEASE_PKG dependencies on WMS_TASK_RELEASE_B

Line 40: cursor C is select ROWID from WMS_TASK_RELEASE_B

36: X_LAST_UPDATE_DATE in DATE,
37: X_LAST_UPDATED_BY in NUMBER,
38: X_LAST_UPDATE_LOGIN in NUMBER
39: ) is
40: cursor C is select ROWID from WMS_TASK_RELEASE_B
41: where CRITERIA_ID = X_CRITERIA_ID
42: ;
43:
44: l_ctype c%ROWTYPE;

Line 46: insert into WMS_TASK_RELEASE_B (

42: ;
43:
44: l_ctype c%ROWTYPE;
45: begin
46: insert into WMS_TASK_RELEASE_B (
47: CONS_LOCATOR_TOLERANCE,
48: MIN_EQUIP_CAPACITY_FLAG,
49: CUSTOM_TASK_PLAN_FLAG,
50: CUSTOM_PLAN_TOLERANCE,

Line 213: from WMS_TASK_RELEASE_B

209: REPLEN_TOLERANCE,
210: REV_TRIP_STOP_FLAG,
211: TRIP_STOP_TOLERANCE,
212: CONS_LOCATOR_FLAG
213: from WMS_TASK_RELEASE_B
214: where CRITERIA_ID = X_CRITERIA_ID
215: for update of CRITERIA_ID nowait;
216: recinfo c%rowtype;
217:

Line 344: update WMS_TASK_RELEASE_B set

340: X_LAST_UPDATED_BY in NUMBER,
341: X_LAST_UPDATE_LOGIN in NUMBER
342: ) is
343: begin
344: update WMS_TASK_RELEASE_B set
345: CONS_LOCATOR_TOLERANCE = X_CONS_LOCATOR_TOLERANCE,
346: MIN_EQUIP_CAPACITY_FLAG = X_MIN_EQUIP_CAPACITY_FLAG,
347: CUSTOM_TASK_PLAN_FLAG = X_CUSTOM_TASK_PLAN_FLAG,
348: CUSTOM_PLAN_TOLERANCE = X_CUSTOM_PLAN_TOLERANCE,

Line 406: delete from WMS_TASK_RELEASE_B

402: if (sql%notfound) then
403: raise no_data_found;
404: end if;
405:
406: delete from WMS_TASK_RELEASE_B
407: where CRITERIA_ID = X_CRITERIA_ID;
408:
409: if (sql%notfound) then
410: raise no_data_found;

Line 420: from WMS_TASK_RELEASE_B B

416: begin
417: delete from WMS_TASK_RELEASE_TL T
418: where not exists
419: (select NULL
420: from WMS_TASK_RELEASE_B B
421: where B.CRITERIA_ID = T.CRITERIA_ID
422: );
423:
424: update WMS_TASK_RELEASE_TL T set (