eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AR_UNACCOUNTED_TRX_SWEEP dependencies on XLA_EVENTS

Line 339: | PROCEDURE - UPDATE_XLA_EVENTS

335: END;
336:
337:
338: /*============================================================================
339: | PROCEDURE - UPDATE_XLA_EVENTS
340: |
341: | DESCRIPTION
342: | This procedure is used to sweep accounting events from one accounting period
343: | to another.

Line 356: FUNCTION update_xla_events RETURN BOOLEAN IS

352: | MODIFICATION HISTORY
353: | Date Author Description of Change
354: *===========================================================================*/
355:
356: FUNCTION update_xla_events RETURN BOOLEAN IS
357:
358: TYPE t_event_ids IS TABLE OF NUMBER INDEX BY PLS_INTEGER;
359: TYPE t_trans_ids IS TABLE OF NUMBER(18) INDEX BY PLS_INTEGER;
360: TYPE t_trans_nums IS TABLE OF VARCHAR2(50) INDEX BY PLS_INTEGER;

Line 373: l_event_security_context XLA_EVENTS_PUB_PKG.T_SECURITY;

369: l_trans_nums t_trans_nums;
370: l_entity_codes t_entity_codes;
371: l_org_ids t_org_ids;
372: l_legal_entity_ids t_legal_entity_ids;
373: l_event_security_context XLA_EVENTS_PUB_PKG.T_SECURITY;
374: l_event_source_info XLA_EVENTS_PUB_PKG.T_EVENT_SOURCE_INFO;
375:
376: l_xla_event XLA_EVENTS.EVENT_ID%TYPE;
377: l_xla_event_status XLA_EVENTS.EVENT_STATUS_CODE%TYPE;

Line 374: l_event_source_info XLA_EVENTS_PUB_PKG.T_EVENT_SOURCE_INFO;

370: l_entity_codes t_entity_codes;
371: l_org_ids t_org_ids;
372: l_legal_entity_ids t_legal_entity_ids;
373: l_event_security_context XLA_EVENTS_PUB_PKG.T_SECURITY;
374: l_event_source_info XLA_EVENTS_PUB_PKG.T_EVENT_SOURCE_INFO;
375:
376: l_xla_event XLA_EVENTS.EVENT_ID%TYPE;
377: l_xla_event_status XLA_EVENTS.EVENT_STATUS_CODE%TYPE;
378: l_call_xla_api VARCHAR2(1);

Line 376: l_xla_event XLA_EVENTS.EVENT_ID%TYPE;

372: l_legal_entity_ids t_legal_entity_ids;
373: l_event_security_context XLA_EVENTS_PUB_PKG.T_SECURITY;
374: l_event_source_info XLA_EVENTS_PUB_PKG.T_EVENT_SOURCE_INFO;
375:
376: l_xla_event XLA_EVENTS.EVENT_ID%TYPE;
377: l_xla_event_status XLA_EVENTS.EVENT_STATUS_CODE%TYPE;
378: l_call_xla_api VARCHAR2(1);
379:
380: CURSOR c_events IS

Line 377: l_xla_event_status XLA_EVENTS.EVENT_STATUS_CODE%TYPE;

373: l_event_security_context XLA_EVENTS_PUB_PKG.T_SECURITY;
374: l_event_source_info XLA_EVENTS_PUB_PKG.T_EVENT_SOURCE_INFO;
375:
376: l_xla_event XLA_EVENTS.EVENT_ID%TYPE;
377: l_xla_event_status XLA_EVENTS.EVENT_STATUS_CODE%TYPE;
378: l_call_xla_api VARCHAR2(1);
379:
380: CURSOR c_events IS
381: SELECT gt.event_id,

Line 410: arp_standard.debug ('begin update_xla_events: Bulk fetch cursor c_events');

406: ( SELECT 'X' FROM AR_SYSTEM_PARAMETERS where org_id = gt.org_id);
407:
408: begin
409:
410: arp_standard.debug ('begin update_xla_events: Bulk fetch cursor c_events');
411:
412: OPEN c_events;
413: LOOP
414: FETCH c_events

Line 424: arp_standard.debug ('update_xla_events: l_event_ids.count='||l_event_ids.count );

420: l_trans_nums,
421: l_entity_codes
422: LIMIT g_fetch_limit;
423:
424: arp_standard.debug ('update_xla_events: l_event_ids.count='||l_event_ids.count );
425:
426: EXIT WHEN
427: l_event_ids.count = 0;
428:

Line 435: FROM xla_events

431: BEGIN
432:
433: SELECT event_id, event_status_code
434: INTO l_xla_event, l_xla_event_status
435: FROM xla_events
436: WHERE event_id = l_event_ids(i)
437: AND application_id = 222;
438:
439: IF l_xla_event_status = 'P' THEN

Line 463: XLA_EVENTS_PUB_PKG.UPDATE_EVENT

459: l_event_source_info.source_id_int_1 := l_trans_ids(i);
460:
461: l_event_security_context.security_id_int_1 := l_org_ids(i);
462:
463: XLA_EVENTS_PUB_PKG.UPDATE_EVENT
464: ( p_event_source_info => l_event_source_info,
465: p_event_id => l_event_ids(i),
466: p_event_type_code => NULL,
467: p_event_date => g_sweep_to_date,

Line 504: arp_standard.debug ('end update_xla_events');

500:
501: END LOOP;
502: CLOSE c_events;
503:
504: arp_standard.debug ('end update_xla_events');
505:
506: return TRUE;
507:
508: EXCEPTION

Line 514: arp_standard.debug ('EXCEPTION: update_xla_events: '|| sqlerrm);

510:
511: IF (c_events%ISOPEN) THEN
512: CLOSE c_events;
513: END IF;
514: arp_standard.debug ('EXCEPTION: update_xla_events: '|| sqlerrm);
515: return FALSE;
516:
517: END;
518:

Line 545: l_success := update_xla_events;

541:
542: l_success BOOLEAN;
543: BEGIN
544:
545: l_success := update_xla_events;
546:
547: if (l_success <> TRUE) then
548: arp_standard.debug ('Failure in update_xla_events while updating XLA unaccounted events');
549: return FALSE;

Line 548: arp_standard.debug ('Failure in update_xla_events while updating XLA unaccounted events');

544:
545: l_success := update_xla_events;
546:
547: if (l_success <> TRUE) then
548: arp_standard.debug ('Failure in update_xla_events while updating XLA unaccounted events');
549: return FALSE;
550: end if;
551:
552: l_success := FALSE;

Line 655: ,xla_events xle

651: , NULL
652: from
653: ra_customer_trx_all ct
654: ,ra_cust_trx_line_gl_dist_all gld
655: ,xla_events xle
656: ,ar_payment_schedules_all ps
657: WHERE ct.complete_flag = 'Y'
658: and ct.customer_trx_id = gld.customer_trx_id
659: and gld.account_set_flag = 'N'

Line 735: , xla_events xle

731: , ps.payment_schedule_id
732: , ra.applied_payment_schedule_id
733: from ra_customer_trx_all ct
734: , ar_receivable_applications_all ra
735: , xla_events xle
736: , ar_distributions_all ard
737: , ar_payment_schedules_all ps
738: WHERE ct.complete_flag = 'Y'
739: and ct.customer_trx_id = ra.customer_trx_id

Line 818: , xla_events xle

814: , ps.payment_schedule_id
815: , null
816: FROM ar_cash_receipts_all cr
817: , ar_cash_receipt_history_all crh
818: , xla_events xle
819: , ar_distributions_all ard
820: , ar_payment_schedules_all ps
821: WHERE cr.cash_receipt_id = crh.cash_receipt_id
822: and cr.set_of_books_id = g_ledger_id

Line 896: , xla_events xle

892: , null
893: , null
894: FROM ar_cash_receipts_all cr
895: , ar_cash_receipt_history_all crh
896: , xla_events xle
897: , ar_distributions_all ard
898: WHERE cr.type = 'MISC'
899: and cr.cash_receipt_id = crh.cash_receipt_id
900: and cr.set_of_books_id = g_ledger_id

Line 973: , xla_events xle

969: , ps.payment_schedule_id
970: , ra.applied_payment_schedule_id
971: FROM ar_cash_receipts_all cr
972: , ar_receivable_applications_all ra
973: , xla_events xle
974: , ar_distributions_all ard
975: , ar_payment_schedules_all ps
976: WHERE cr.cash_receipt_id = ra.cash_receipt_id
977: and cr.set_of_books_id = g_ledger_id

Line 1052: , xla_events xle

1048: , null
1049: , null
1050: FROM ar_cash_receipts_all cr
1051: , ar_misc_cash_distributions_all mcd
1052: , xla_events xle
1053: , ar_distributions_all ard
1054: WHERE cr.cash_receipt_id = mcd.cash_receipt_id
1055: and cr.set_of_books_id = g_ledger_id
1056: and mcd.gl_date between g_period_start_date and g_period_end_date

Line 1132: , xla_events xle

1128: , ps.payment_schedule_id
1129: , null
1130: FROM ar_adjustments_all adj
1131: , ar_distributions_all ard
1132: , xla_events xle
1133: , ra_customer_trx_all ct
1134: , ar_payment_schedules_all ps
1135: WHERE adj.set_of_books_id = g_ledger_id
1136: and adj.gl_date between g_period_start_date and g_period_end_date

Line 1214: , xla_events xle

1210: , ct.drawee_id
1211: , ps.payment_schedule_id
1212: , null
1213: FROM ar_transaction_history_all th
1214: , xla_events xle
1215: , ar_distributions_all ard
1216: , ra_customer_trx_all ct
1217: , ar_payment_schedules_all ps
1218: WHERE th.gl_date between g_period_start_date and g_period_end_date