APPS.XDO_TEMPLATES_PKG dependencies on XDO_TEMPLATES_B

Line 48: cursor C is select ROWID from XDO_TEMPLATES_B

44: X_LAST_UPDATE_DATE in DATE,
45: X_LAST_UPDATED_BY in NUMBER,
46: X_LAST_UPDATE_LOGIN in NUMBER
47: ) is
48: cursor C is select ROWID from XDO_TEMPLATES_B
49: where APPLICATION_SHORT_NAME = X_APPLICATION_SHORT_NAME
50: and TEMPLATE_CODE = X_TEMPLATE_CODE
51: ;
52: begin

Line 53: insert into XDO_TEMPLATES_B (

49: where APPLICATION_SHORT_NAME = X_APPLICATION_SHORT_NAME
50: and TEMPLATE_CODE = X_TEMPLATE_CODE
51: ;
52: begin
53: insert into XDO_TEMPLATES_B (
54: ATTRIBUTE6,
55: ATTRIBUTE7,
56: ATTRIBUTE8,
57: ATTRIBUTE9,

Line 344: from XDO_TEMPLATES_B

340: ATTRIBUTE12,
341: ATTRIBUTE13,
342: ATTRIBUTE14,
343: ATTRIBUTE15
344: from XDO_TEMPLATES_B
345: where APPLICATION_SHORT_NAME = X_APPLICATION_SHORT_NAME
346: and TEMPLATE_CODE = X_TEMPLATE_CODE
347: for update of APPLICATION_SHORT_NAME nowait;
348: recinfo c%rowtype;

Line 488: update XDO_TEMPLATES_B set

484: X_LAST_UPDATED_BY in NUMBER,
485: X_LAST_UPDATE_LOGIN in NUMBER
486: ) is
487: begin
488: update XDO_TEMPLATES_B set
489: ATTRIBUTE6 = X_ATTRIBUTE6,
490: ATTRIBUTE7 = X_ATTRIBUTE7,
491: ATTRIBUTE8 = X_ATTRIBUTE8,
492: ATTRIBUTE9 = X_ATTRIBUTE9,

Line 560: delete from XDO_TEMPLATES_B

556: if (sql%notfound) then
557: raise no_data_found;
558: end if;
559:
560: delete from XDO_TEMPLATES_B
561: where APPLICATION_SHORT_NAME = X_APPLICATION_SHORT_NAME
562: and TEMPLATE_CODE = X_TEMPLATE_CODE;
563:
564: if (sql%notfound) then

Line 575: from XDO_TEMPLATES_B B

571: begin
572: delete from XDO_TEMPLATES_TL T
573: where not exists
574: (select NULL
575: from XDO_TEMPLATES_B B
576: where B.APPLICATION_SHORT_NAME = T.APPLICATION_SHORT_NAME
577: and B.TEMPLATE_CODE = T.TEMPLATE_CODE
578: );
579:

Line 773: from xdo_templates_b

769:
770: begin
771: select TEMPLATE_ID, LAST_UPDATED_BY, LAST_UPDATE_DATE
772: into tmpl_id, db_luby, db_ludate
773: from xdo_templates_b
774: where template_code=x_template_code
775: and application_short_name=x_application_short_name;
776:
777: -- Update record, honoring customization mode.