APPS.XDO_TEMPLATE_FIELDS_PKG dependencies on XDO_TEMPLATE_FIELDS

Line 1: package body XDO_TEMPLATE_FIELDS_PKG as

1: package body XDO_TEMPLATE_FIELDS_PKG as
2: /* $Header: XDOTMFDB.pls 120.1 2005/07/02 05:05:32 appldev noship $ */
3: procedure INSERT_ROW (
4: X_ROWID in out nocopy VARCHAR2,
5: X_APPLICATION_SHORT_NAME in VARCHAR2,

Line 17: from XDO_TEMPLATE_FIELDS

13: X_LAST_UPDATE_LOGIN in NUMBER
14: ) is
15: cursor C is
16: select ROWID
17: from XDO_TEMPLATE_FIELDS
18: where APPLICATION_SHORT_NAME = X_APPLICATION_SHORT_NAME
19: and TEMPLATE_CODE = X_TEMPLATE_CODE
20: and FIELD_NAME = X_FIELD_NAME;
21: begin

Line 22: insert into xdo_template_fields (

18: where APPLICATION_SHORT_NAME = X_APPLICATION_SHORT_NAME
19: and TEMPLATE_CODE = X_TEMPLATE_CODE
20: and FIELD_NAME = X_FIELD_NAME;
21: begin
22: insert into xdo_template_fields (
23: APPLICATION_SHORT_NAME,
24: TEMPLATE_CODE,
25: FIELD_NAME,
26: ALIAS_NAME,

Line 65: from XDO_TEMPLATE_FIELDS

61: APPLICATION_SHORT_NAME,
62: TEMPLATE_CODE,
63: FIELD_NAME,
64: ALIAS_NAME
65: from XDO_TEMPLATE_FIELDS
66: where APPLICATION_SHORT_NAME = X_APPLICATION_SHORT_NAME
67: and TEMPLATE_CODE = X_TEMPLATE_CODE
68: and FIELD_NAME = X_FIELD_NAME
69: for update of APPLICATION_SHORT_NAME, TEMPLATE_CODE, FIELD_NAME nowait;

Line 100: update XDO_TEMPLATE_FIELDS set

96: X_LAST_UPDATED_BY in NUMBER,
97: X_LAST_UPDATE_LOGIN in NUMBER
98: ) is
99: begin
100: update XDO_TEMPLATE_FIELDS set
101: ALIAS_NAME = X_ALIAS_NAME,
102: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
103: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
104: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN

Line 122: delete from XDO_TEMPLATE_FIELDS

118: X_FIELD_NAME in VARCHAR2
119: ) is
120: begin
121:
122: delete from XDO_TEMPLATE_FIELDS
123: where TEMPLATE_CODE=X_TEMPLATE_CODE
124: and APPLICATION_SHORT_NAME=X_APPLICATION_SHORT_NAME
125: and FIELD_NAME = X_FIELD_NAME;
126:

Line 164: from xdo_template_fields

160: begin
161:
162: select LAST_UPDATED_BY, LAST_UPDATE_DATE
163: into db_luby, db_ludate
164: from xdo_template_fields
165: where application_short_name = x_application_short_name
166: and template_code = x_template_code
167: and field_name = x_field_name;
168:

Line 181: XDO_TEMPLATE_FIELDS_PKG.UPDATE_ROW (

177: p_db_id => db_luby,
178: p_db_lud => db_ludate,
179: p_custom_mode => x_custom_mode))
180: then
181: XDO_TEMPLATE_FIELDS_PKG.UPDATE_ROW (
182: X_APPLICATION_SHORT_NAME => X_APPLICATION_SHORT_NAME,
183: X_TEMPLATE_CODE => X_TEMPLATE_CODE,
184: X_FIELD_NAME => x_field_name,
185: X_ALIAS_NAME => x_alias_name,

Line 192: XDO_TEMPLATE_FIELDS_PKG.INSERT_ROW (

188: X_LAST_UPDATE_LOGIN => 0
189: );
190: end if;
191: exception when no_data_found then
192: XDO_TEMPLATE_FIELDS_PKG.INSERT_ROW (
193: X_ROWID => row_id,
194: X_APPLICATION_SHORT_NAME => X_APPLICATION_SHORT_NAME,
195: X_TEMPLATE_CODE => X_TEMPLATE_CODE,
196: X_FIELD_NAME => x_field_name,

Line 207: end XDO_TEMPLATE_FIELDS_PKG;

203: );
204: end;
205: end LOAD_ROW;
206:
207: end XDO_TEMPLATE_FIELDS_PKG;