APPS.WMS_PAGE_TEMPLATES_PKG dependencies on WMS_PAGE_TEMPLATES_B

Line 39: cursor C is select ROWID from WMS_PAGE_TEMPLATES_B

35: X_LAST_UPDATED_BY in NUMBER,
36: X_LAST_UPDATE_LOGIN in NUMBER
37: ) is
38:
39: cursor C is select ROWID from WMS_PAGE_TEMPLATES_B
40: where TEMPLATE_ID = X_TEMPLATE_ID;
41:
42: begin
43:

Line 44: insert into WMS_PAGE_TEMPLATES_B (

40: where TEMPLATE_ID = X_TEMPLATE_ID;
41:
42: begin
43:
44: insert into WMS_PAGE_TEMPLATES_B (
45: ATTRIBUTE_CATEGORY,
46: ATTRIBUTE1,
47: ATTRIBUTE2,
48: ATTRIBUTE3,

Line 200: from WMS_PAGE_TEMPLATES_B

196: CREATING_ORGANIZATION_CODE,
197: COMMON_TO_ALL_ORGS,
198: ENABLED,
199: DEFAULT_FLAG
200: from WMS_PAGE_TEMPLATES_B
201: where TEMPLATE_ID = X_TEMPLATE_ID
202: for update of TEMPLATE_ID nowait;
203: recinfo c%rowtype;
204:

Line 320: update WMS_PAGE_TEMPLATES_B set

316: X_LAST_UPDATED_BY in NUMBER,
317: X_LAST_UPDATE_LOGIN in NUMBER
318: ) is
319: begin
320: update WMS_PAGE_TEMPLATES_B set
321: ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
322: ATTRIBUTE1 = X_ATTRIBUTE1,
323: ATTRIBUTE2 = X_ATTRIBUTE2,
324: ATTRIBUTE3 = X_ATTRIBUTE3,

Line 397: from WMS_PAGE_TEMPLATES_B

393:
394: -- translate values to IDs
395: select TEMPLATE_ID, LAST_UPDATED_BY, LAST_UPDATE_DATE
396: into l_template_id, db_luby, db_ludate
397: from WMS_PAGE_TEMPLATES_B
398: where PAGE_ID = X_PAGE_ID
399: and TEMPLATE_NAME = X_TEMPLATE_NAME;
400:
401: -- Test for customization and version

Line 481: from WMS_PAGE_TEMPLATES_B

477: begin
478: -- translate values to IDs
479: select TEMPLATE_ID, LAST_UPDATED_BY, LAST_UPDATE_DATE
480: into l_template_id, db_luby, db_ludate
481: from WMS_PAGE_TEMPLATES_B
482: where PAGE_ID = X_PAGE_ID
483: and TEMPLATE_NAME = X_TEMPLATE_NAME;
484:
485: -- Test for customization and version

Line 580: delete from WMS_PAGE_TEMPLATES_B

576: if (sql%notfound) then
577: raise no_data_found;
578: end if;
579:
580: delete from WMS_PAGE_TEMPLATES_B
581: where TEMPLATE_ID = X_TEMPLATE_ID;
582:
583: if (sql%notfound) then
584: raise no_data_found;

Line 594: from WMS_PAGE_TEMPLATES_B B

590: begin
591: delete from WMS_PAGE_TEMPLATES_TL T
592: where not exists
593: (select NULL
594: from WMS_PAGE_TEMPLATES_B B
595: where B.TEMPLATE_ID = T.TEMPLATE_ID
596: );
597:
598: update WMS_PAGE_TEMPLATES_TL T set (