APPS.HZ_WORD_RPL_CONDS_PKG dependencies on HZ_WORD_RPL_CONDS_B

Line 28: INSERT INTO HZ_WORD_RPL_CONDS_B(

24: FETCH C2 INTO X_CONDITION_ID;
25: CLOSE C2;
26: END IF;
27:
28: INSERT INTO HZ_WORD_RPL_CONDS_B(
29: condition_id,
30: entity,
31: condition_function,
32: condition_val_fmt_flag,

Line 115: UPDATE HZ_WORD_RPL_CONDS_B set

111: p_object_version_number NUMBER ;
112: BEGIN
113: p_object_version_number := NVL(x_object_version_number, 1) + 1;
114:
115: UPDATE HZ_WORD_RPL_CONDS_B set
116: entity = x_entity,
117: condition_function = x_condition_function,
118: condition_val_fmt_flag = x_condition_val_fmt_flag,
119: object_version_number = p_object_version_number,

Line 154: delete from HZ_WORD_RPL_CONDS_B

150: x_condition_id in NUMBER
151: )
152: IS
153: BEGIN
154: delete from HZ_WORD_RPL_CONDS_B
155: where condition_id = x_condition_id ;
156:
157: if (sql%notfound) then
158: raise no_data_found;

Line 176: from HZ_WORD_RPL_CONDS_B

172: )
173: IS
174: cursor c is select
175: object_version_number
176: from HZ_WORD_RPL_CONDS_B
177: where condition_id = x_condition_id
178: for update of condition_id nowait;
179:
180: recinfo c%rowtype;

Line 216: from HZ_WORD_RPL_CONDS_B B

212: BEGIN
213: delete from HZ_WORD_RPL_CONDS_TL T
214: where not exists
215: (select NULL
216: from HZ_WORD_RPL_CONDS_B B
217: where B.condition_id = T.condition_id
218: );
219:
220: update HZ_WORD_RPL_CONDS_TL T set (

Line 320: from HZ_WORD_RPL_CONDS_B

316:
317: BEGIN
318: select LAST_UPDATED_BY, LAST_UPDATE_DATE
319: into l_db_luby, l_db_ludate
320: from HZ_WORD_RPL_CONDS_B
321: where condition_id = x_condition_id ;
322:
323: -- Update record, honoring customization mode.
324: -- Record should be updated only if: