287: null,
288: 'N',
289: null,
290: null,
291: nvl(fnd_global.user_id, -1),
292: sysdate,
293: nvl(fnd_global.user_id, -1),
294: sysdate,
295: nvl(fnd_global.user_id, -1));
289: null,
290: null,
291: nvl(fnd_global.user_id, -1),
292: sysdate,
293: nvl(fnd_global.user_id, -1),
294: sysdate,
295: nvl(fnd_global.user_id, -1));
296:
297: -- l_event_source_info.source_id_char_1 := l_rowid;
291: nvl(fnd_global.user_id, -1),
292: sysdate,
293: nvl(fnd_global.user_id, -1),
294: sysdate,
295: nvl(fnd_global.user_id, -1));
296:
297: -- l_event_source_info.source_id_char_1 := l_rowid;
298: log('Row ID: '||l_rowid);
299: -- Raise Create AE in SLA with unprocessed status
333: l_clearing_error_amount,
334: 'N',
335: null,
336: null,
337: nvl(fnd_global.user_id, -1),
338: sysdate,
339: nvl(fnd_global.user_id, -1),
340: sysdate,
341: nvl(fnd_global.user_id, -1));
335: null,
336: null,
337: nvl(fnd_global.user_id, -1),
338: sysdate,
339: nvl(fnd_global.user_id, -1),
340: sysdate,
341: nvl(fnd_global.user_id, -1));
342:
343: -- l_event_source_info.source_id_char_1 := l_rowid;
337: nvl(fnd_global.user_id, -1),
338: sysdate,
339: nvl(fnd_global.user_id, -1),
340: sysdate,
341: nvl(fnd_global.user_id, -1));
342:
343: -- l_event_source_info.source_id_char_1 := l_rowid;
344: log('Row ID: '||l_rowid);
345: -- Raise Clearing AE in SLA with unprocessed status
390: null,
391: 'Y',
392: X_trx_id,
393: rowidtochar(l_previous_row_id),
394: nvl(fnd_global.user_id, -1),
395: sysdate,
396: nvl(fnd_global.user_id, -1),
397: sysdate,
398: nvl(fnd_global.user_id, -1));
392: X_trx_id,
393: rowidtochar(l_previous_row_id),
394: nvl(fnd_global.user_id, -1),
395: sysdate,
396: nvl(fnd_global.user_id, -1),
397: sysdate,
398: nvl(fnd_global.user_id, -1));
399:
400: -- l_event_source_info.source_id_char_1 := l_rowid;
394: nvl(fnd_global.user_id, -1),
395: sysdate,
396: nvl(fnd_global.user_id, -1),
397: sysdate,
398: nvl(fnd_global.user_id, -1));
399:
400: -- l_event_source_info.source_id_char_1 := l_rowid;
401: log('Row ID: '||l_rowid);
402:
428: null,
429: 'Y',
430: X_trx_id,
431: rowidtochar(l_previous_row_id),
432: nvl(fnd_global.user_id, -1),
433: sysdate,
434: nvl(fnd_global.user_id, -1),
435: sysdate,
436: nvl(fnd_global.user_id, -1));
430: X_trx_id,
431: rowidtochar(l_previous_row_id),
432: nvl(fnd_global.user_id, -1),
433: sysdate,
434: nvl(fnd_global.user_id, -1),
435: sysdate,
436: nvl(fnd_global.user_id, -1));
437:
438: -- l_event_source_info.source_id_char_1 := l_rowid;
432: nvl(fnd_global.user_id, -1),
433: sysdate,
434: nvl(fnd_global.user_id, -1),
435: sysdate,
436: nvl(fnd_global.user_id, -1));
437:
438: -- l_event_source_info.source_id_char_1 := l_rowid;
439: log('Row ID: '||l_rowid);
440:
506: null,
507: 'Y',
508: X_trx_id,
509: rowidtochar(l_creation_row_id),
510: nvl(fnd_global.user_id, -1),
511: sysdate,
512: nvl(fnd_global.user_id, -1),
513: sysdate,
514: nvl(fnd_global.user_id, -1));
508: X_trx_id,
509: rowidtochar(l_creation_row_id),
510: nvl(fnd_global.user_id, -1),
511: sysdate,
512: nvl(fnd_global.user_id, -1),
513: sysdate,
514: nvl(fnd_global.user_id, -1));
515:
516: -- l_event_source_info.source_id_char_1 := l_rowid;
510: nvl(fnd_global.user_id, -1),
511: sysdate,
512: nvl(fnd_global.user_id, -1),
513: sysdate,
514: nvl(fnd_global.user_id, -1));
515:
516: -- l_event_source_info.source_id_char_1 := l_rowid;
517: log('Row ID: '||l_rowid);
518: