APPS.XLE_HISTORY_PUB dependencies on XLE_HISTORIES

Line 151: from xle_histories

147: l_start_date Date;
148:
149: cursor eff_from is
150: select effective_from
151: from xle_histories
152: where source_id=G_PRIMARY_KEY_ID
153: and source_table=G_TABLE_NAME
154: and source_column_name=l_column_name
155: and effective_to is null;

Line 196: from xle_histories

192:
193:
194: begin
195: select '1' into v_chk
196: from xle_histories
197: where source_id =G_PRIMARY_KEY_ID
198: and source_table=G_TABLE_NAME
199: and source_column_name=G_VALUE_LIST(i).column_name
200: and rownum <2;

Line 204: XLE_Histories_PKG.Insert_Row(

200: and rownum <2;
201: exception
202: when NO_DATA_FOUND THEN
203:
204: XLE_Histories_PKG.Insert_Row(
205: x_history_id => l_hist_id,
206: p_source_table => G_TABLE_NAME,
207: p_source_id => G_PRIMARY_KEY_ID,
208: p_source_column_name => G_VALUE_LIST(i).column_name,

Line 218: delete from xle_histories

214:
215: end;
216:
217:
218: delete from xle_histories
219: where source_id=G_PRIMARY_KEY_ID
220: and source_table=G_TABLE_NAME
221: and source_column_name=G_VALUE_LIST(i).column_name
222: and effective_from > nvl(p_effective_from,sysdate);

Line 225: /* XLE_Histories_PKG.Insert_Row(

221: and source_column_name=G_VALUE_LIST(i).column_name
222: and effective_from > nvl(p_effective_from,sysdate);
223:
224: if sql%rowcount > 0 then
225: /* XLE_Histories_PKG.Insert_Row(
226: x_history_id => l_history_id,
227: p_source_table => G_TABLE_NAME,
228: p_source_id => G_PRIMARY_KEY_ID,
229: p_source_column_name => G_VALUE_LIST(i).column_name,

Line 241: update XLE_Histories

237: end if;
238:
239: if (v_chk2='0') then
240:
241: update XLE_Histories
242: set effective_to=decode(trunc(effective_from),trunc(nvl(p_effective_from,sysdate)),(nvl2(p_effective_from,p_effective_from-(1/86400),sysdate-(1/86400))),nvl(p_effective_from,sysdate)-1)
243: where source_id=G_PRIMARY_KEY_ID
244: and source_table=G_TABLE_NAME
245: and source_column_name=G_VALUE_LIST(i).column_name

Line 250: XLE_Histories_PKG.Insert_Row(

246: and effective_to is null;
247:
248: end if;
249:
250: XLE_Histories_PKG.Insert_Row(
251: x_history_id => l_history_id,
252: p_source_table => G_TABLE_NAME,
253: p_source_id => G_PRIMARY_KEY_ID,
254: p_source_column_name => G_VALUE_LIST(i).column_name,

Line 267: update xle_histories

263: END IF;
264: END LOOP;
265:
266: If l_flag='Y' then
267: update xle_histories
268: SET effective_to =to_date(to_char(to_date(l_eff, 'DD-MON-YYYY HH24:MI:SS'), 'DD-MM-YYYY'), 'DD-MM-YYYY')
269: where source_id=G_PRIMARY_KEY_ID
270: and source_table=G_TABLE_NAME
271: and effective_to is null;

Line 282: Delete from xle_histories

278: If l_count>1 and l_eff_flag='Y' then
279: p_return_status:='E';
280: p_error_type := 'DataError';
281: ElsIf l_count=1 and l_eff_flag='Y' and v_chk2='0' then
282: Delete from xle_histories
283: where source_id=G_PRIMARY_KEY_ID
284: and source_table=G_TABLE_NAME
285: and source_column_name=l_column_name
286: and effective_from > p_effective_from ;

Line 466: XLE_Histories_PKG.Insert_Row(

462: IF G_VALUE_LIST(i).new_value IS NOT NULL THEN
463: l_count:=l_count+1;
464: l_column_name:=G_VALUE_LIST(i).column_name;
465:
466: XLE_Histories_PKG.Insert_Row(
467: x_history_id => l_history_id,
468: p_source_table => G_TABLE_NAME,
469: p_source_id => G_PRIMARY_KEY_ID,
470: p_source_column_name => G_VALUE_LIST(i).column_name,