DBA Data[Home] [Help]

APPS.XDO_TRANS_UNITS_PKG dependencies on XDO_TRANS_UNIT_VALUES

Line 41: insert into XDO_TRANS_UNIT_VALUES (

37: X_LAST_UPDATED_BY,
38: X_LAST_UPDATE_LOGIN
39: );
40:
41: insert into XDO_TRANS_UNIT_VALUES (
42: APPLICATION_SHORT_NAME,
43: TEMPLATE_CODE,
44: UNIT_ID,
45: LANGUAGE,

Line 98: update XDO_TRANS_UNIT_VALUES

94: if (sql%notfound) then
95: raise no_data_found;
96: end if;
97:
98: update XDO_TRANS_UNIT_VALUES
99: set VALUE = X_VALUE,
100: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
101: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
102: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN

Line 120: delete from XDO_TRANS_UNIT_VALUES

116: X_TEMPLATE_CODE in VARCHAR2,
117: X_UNIT_ID in VARCHAR2
118: ) is
119: begin
120: delete from XDO_TRANS_UNIT_VALUES
121: where APPLICATION_SHORT_NAME = X_APPLICATION_SHORT_NAME
122: and TEMPLATE_CODE = X_TEMPLATE_CODE
123: and UNIT_ID = X_UNIT_ID;
124:

Line 194: from XDO_TRANS_UNIT_VALUES

190:
191: begin
192: select LAST_UPDATED_BY, LAST_UPDATE_DATE
193: into db_luby, db_ludate
194: from XDO_TRANS_UNIT_VALUES
195: where APPLICATION_SHORT_NAME = X_APPLICATION_SHORT_NAME
196: and TEMPLATE_CODE = X_TEMPLATE_CODE
197: and UNIT_ID = X_UNIT_ID
198: and language = X_LANGUAGE

Line 213: update XDO_TRANS_UNIT_VALUES

209: p_db_id => db_luby,
210: p_db_lud => db_ludate,
211: p_custom_mode => x_custom_mode))
212: then
213: update XDO_TRANS_UNIT_VALUES
214: set VALUE = X_VALUE,
215: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
216: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
217: LAST_UPDATE_LOGIN = 0

Line 244: insert into XDO_TRANS_UNIT_VALUES (

240: when no_data_found then
241: return;
242: end;
243:
244: insert into XDO_TRANS_UNIT_VALUES (
245: APPLICATION_SHORT_NAME,
246: TEMPLATE_CODE,
247: UNIT_ID,
248: LANGUAGE,