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.ARP_XLA_EVENTS dependencies on XLA_EVENTS_PUB_PKG

Line 63: (p_ev_info_tab IN OUT NOCOPY xla_events_pub_pkg.t_array_entity_event_info_s,

59: p_i IN BINARY_INTEGER,
60: p_tag IN VARCHAR2);
61:
62: PROCEDURE dump_event_info
63: (p_ev_info_tab IN OUT NOCOPY xla_events_pub_pkg.t_array_entity_event_info_s,
64: p_i IN BINARY_INTEGER ,
65: p_tag IN VARCHAR2 );
66:
67: PROCEDURE Upd_Dist(p_xla_ev_rec IN xla_events_type);

Line 74: (x_ev_source_info IN OUT NOCOPY xla_events_pub_pkg.t_event_Source_info);

70: ( p_xla_doc IN VARCHAR2,
71: p_event_id IN NUMBER );
72:
73: PROCEDURE dump_event_source_info
74: (x_ev_source_info IN OUT NOCOPY xla_events_pub_pkg.t_event_Source_info);
75:
76: FUNCTION entity_code( p_doc_table IN VARCHAR2)
77: RETURN VARCHAR2;
78:

Line 308: l_event_source_info xla_events_pub_pkg.t_event_source_info;

304:
305: /*-----------------------------------------------------------------------+
306: | Local Variable Declarations and initializations |
307: +-----------------------------------------------------------------------*/
308: l_event_source_info xla_events_pub_pkg.t_event_source_info;
309: l_event_id NUMBER;
310: l_security xla_events_pub_pkg.t_security;
311:
312: BEGIN

Line 310: l_security xla_events_pub_pkg.t_security;

306: | Local Variable Declarations and initializations |
307: +-----------------------------------------------------------------------*/
308: l_event_source_info xla_events_pub_pkg.t_event_source_info;
309: l_event_id NUMBER;
310: l_security xla_events_pub_pkg.t_security;
311:
312: BEGIN
313:
314: log('ARP_XLA_EVENTS.Create_Events()+');

Line 2226: bld_ev_ent xla_events_pub_pkg.t_array_entity_event_info_s;

2222: empty_bld_ev_rec bld_ev_type ;
2223:
2224: --cache_ev_rec bld_ev_type ;
2225:
2226: bld_ev_ent xla_events_pub_pkg.t_array_entity_event_info_s;
2227: empty_bld_ev_ent xla_events_pub_pkg.t_array_entity_event_info_s;
2228:
2229: prev_distid VARCHAR2(50) := '';
2230:

Line 2227: empty_bld_ev_ent xla_events_pub_pkg.t_array_entity_event_info_s;

2223:
2224: --cache_ev_rec bld_ev_type ;
2225:
2226: bld_ev_ent xla_events_pub_pkg.t_array_entity_event_info_s;
2227: empty_bld_ev_ent xla_events_pub_pkg.t_array_entity_event_info_s;
2228:
2229: prev_distid VARCHAR2(50) := '';
2230:
2231: l_cached BOOLEAN;

Line 2265: l_event_source_info xla_events_pub_pkg.t_event_source_info;

2261: l_low INTEGER:=0;
2262: l_high INTEGER:=0;
2263: lnb NUMBER;
2264: --xla event api declarations
2265: l_event_source_info xla_events_pub_pkg.t_event_source_info;
2266: l_reference_info xla_events_pub_pkg.t_event_reference_info;
2267: l_security_context xla_events_pub_pkg.t_security;
2268: l_entity_event_info_tbl xla_events_pub_pkg.t_array_entity_event_info_s;
2269: keep_flag BOOLEAN;

Line 2266: l_reference_info xla_events_pub_pkg.t_event_reference_info;

2262: l_high INTEGER:=0;
2263: lnb NUMBER;
2264: --xla event api declarations
2265: l_event_source_info xla_events_pub_pkg.t_event_source_info;
2266: l_reference_info xla_events_pub_pkg.t_event_reference_info;
2267: l_security_context xla_events_pub_pkg.t_security;
2268: l_entity_event_info_tbl xla_events_pub_pkg.t_array_entity_event_info_s;
2269: keep_flag BOOLEAN;
2270: l_revrun VARCHAR2(5);

Line 2267: l_security_context xla_events_pub_pkg.t_security;

2263: lnb NUMBER;
2264: --xla event api declarations
2265: l_event_source_info xla_events_pub_pkg.t_event_source_info;
2266: l_reference_info xla_events_pub_pkg.t_event_reference_info;
2267: l_security_context xla_events_pub_pkg.t_security;
2268: l_entity_event_info_tbl xla_events_pub_pkg.t_array_entity_event_info_s;
2269: keep_flag BOOLEAN;
2270: l_revrun VARCHAR2(5);
2271: l_entity_code VARCHAR2(20);

Line 2268: l_entity_event_info_tbl xla_events_pub_pkg.t_array_entity_event_info_s;

2264: --xla event api declarations
2265: l_event_source_info xla_events_pub_pkg.t_event_source_info;
2266: l_reference_info xla_events_pub_pkg.t_event_reference_info;
2267: l_security_context xla_events_pub_pkg.t_security;
2268: l_entity_event_info_tbl xla_events_pub_pkg.t_array_entity_event_info_s;
2269: keep_flag BOOLEAN;
2270: l_revrun VARCHAR2(5);
2271: l_entity_code VARCHAR2(20);
2272: z NUMBER :=0;

Line 2877: xla_events_pub_pkg.delete_event

2873: -- Set security_context
2874: l_security_context.security_id_int_1 := ev_rec.org_id(i);
2875:
2876: -- Delete the event
2877: xla_events_pub_pkg.delete_event
2878: ( p_event_source_info => l_event_source_info,
2879: p_event_id => ev_rec.ev_match_event_id(i),
2880: p_valuation_method => NULL,
2881: p_security_context => l_security_context);

Line 3116: log('xla_events_pub_pkg.create_bulk_events xla_mode IN (U,B)');

3112: +-------------------------------------------------------------*/
3113:
3114: IF p_xla_ev_rec.xla_mode IN ('U','B') AND test_flag = 'N' THEN
3115:
3116: log('xla_events_pub_pkg.create_bulk_events xla_mode IN (U,B)');
3117:
3118: /*
3119: bld_ev_ent := xla_events_pub_pkg.create_bulk_events(
3120: p_application_id => 222 ,

Line 3119: bld_ev_ent := xla_events_pub_pkg.create_bulk_events(

3115:
3116: log('xla_events_pub_pkg.create_bulk_events xla_mode IN (U,B)');
3117:
3118: /*
3119: bld_ev_ent := xla_events_pub_pkg.create_bulk_events(
3120: p_application_id => 222 ,
3121: p_legal_entity_id => '1' ,-- to be set later
3122: p_ledger_id => arp_standard.sysparm.set_of_books_id ,-- to be set later
3123: p_entity_type_code => l_entity_code ,-- to be set later

Line 3130: xla_events_pub_pkg.create_bulk_events(

3126: -- p_security_context => l_security_context);
3127: */
3128: /* As this call is not suitable to AR, the bug for XLA spi enhancement has been logged
3129: BUG#4448003 for now converting this call to single event call
3130: xla_events_pub_pkg.create_bulk_events(
3131: p_source_application_id => NULL ,
3132: p_application_id => 222 ,
3133: p_legal_entity_id => '1' ,-- to be set later
3134: p_ledger_id => arp_standard.sysparm.set_of_books_id ,-- to be set later

Line 3213: log('XLA_EVENTS_PUB_PKG.create_event');

3209: --to be ascertained after events template is filled
3210:
3211: IF bld_ev_rec.bld_dml_flag(m) = 'I' AND test_flag = 'N' THEN
3212:
3213: log('XLA_EVENTS_PUB_PKG.create_event');
3214:
3215: z := z + 1;
3216: log('hyu calling create event for zth time :'||z);
3217:

Line 3218: lnb := XLA_EVENTS_PUB_PKG.create_event(

3214:
3215: z := z + 1;
3216: log('hyu calling create event for zth time :'||z);
3217:
3218: lnb := XLA_EVENTS_PUB_PKG.create_event(
3219: p_event_source_info => l_event_source_info ,
3220: p_event_type_code => bld_ev_ent(m).event_type_code ,
3221: p_event_date => bld_ev_ent(m).event_date ,
3222: p_event_status_code => bld_ev_ent(m).event_status_code ,

Line 3233: log('XLA_EVENTS_PUB_PKG.update_event');

3229: p_security_context => l_security_context );
3230:
3231: ELSIF bld_ev_rec.bld_dml_flag(m) = 'U' AND test_flag = 'N' THEN
3232:
3233: log('XLA_EVENTS_PUB_PKG.update_event');
3234:
3235: log('bld_ev_ent(m).event_id :'||bld_ev_ent(m).event_id );
3236: log('bld_ev_ent(m).event_type_code :'||bld_ev_ent(m).event_type_code );
3237: log(' bld_ev_ent(m).event_date :'|| bld_ev_ent(m).event_date );

Line 3241: XLA_EVENTS_PUB_PKG.update_event(

3237: log(' bld_ev_ent(m).event_date :'|| bld_ev_ent(m).event_date );
3238: log(' bld_ev_ent(m).event_status_code :'|| bld_ev_ent(m).event_status_code);
3239: log(' p_security_context.security_id_int_1 :'|| l_security_context.security_id_int_1 );
3240:
3241: XLA_EVENTS_PUB_PKG.update_event(
3242: p_event_source_info => l_event_source_info ,
3243: p_event_id => bld_ev_ent(m).event_id ,
3244: p_event_type_code => bld_ev_ent(m).event_type_code ,
3245: p_event_date => bld_ev_ent(m).event_date ,

Line 3274: XLA_EVENTS_PUB_PKG.UPDATE_TRANSACTION_NUMBER(

3270: RAISE;
3271: END;
3272:
3273: IF NVL(trxn_number,-99) <> bld_ev_ent(m).transaction_number THEN
3274: XLA_EVENTS_PUB_PKG.UPDATE_TRANSACTION_NUMBER(
3275: p_event_source_info => l_event_source_info,
3276: p_transaction_number => bld_ev_ent(m).transaction_number,
3277: p_valuation_method => '',
3278: p_security_context => l_security_context ,

Line 3312: log('Calling xla_events_pub_pkg.create_bulk_events +');

3308: IF p_xla_ev_rec.xla_mode = 'B' THEN
3309: OPEN for_batch;
3310: FETCH for_batch INTO l_test;
3311: IF for_batch%FOUND THEN
3312: log('Calling xla_events_pub_pkg.create_bulk_events +');
3313: xla_events_pub_pkg.create_bulk_events
3314: (p_application_id => 222,
3315: p_ledger_id => arp_standard.sysparm.set_of_books_id,
3316: p_entity_type_code => l_entity_code);

Line 3313: xla_events_pub_pkg.create_bulk_events

3309: OPEN for_batch;
3310: FETCH for_batch INTO l_test;
3311: IF for_batch%FOUND THEN
3312: log('Calling xla_events_pub_pkg.create_bulk_events +');
3313: xla_events_pub_pkg.create_bulk_events
3314: (p_application_id => 222,
3315: p_ledger_id => arp_standard.sysparm.set_of_books_id,
3316: p_entity_type_code => l_entity_code);
3317: --avoid recreation of successfully events

Line 3319: log('Calling xla_events_pub_pkg.create_bulk_events -');

3315: p_ledger_id => arp_standard.sysparm.set_of_books_id,
3316: p_entity_type_code => l_entity_code);
3317: --avoid recreation of successfully events
3318: DELETE from xla_events_int_gt WHERE entity_id IS NOT NULL;
3319: log('Calling xla_events_pub_pkg.create_bulk_events -');
3320: END IF;
3321: CLOSE for_batch;
3322: END IF;
3323: --}

Line 3771: (x_ev_source_info IN OUT NOCOPY xla_events_pub_pkg.t_event_Source_info)

3767:
3768:
3769: --HYU
3770: PROCEDURE dump_event_source_info
3771: (x_ev_source_info IN OUT NOCOPY xla_events_pub_pkg.t_event_Source_info)
3772: IS
3773: BEGIN
3774:
3775: log(' ');

Line 4210: (p_ev_info_tab IN OUT NOCOPY xla_events_pub_pkg.t_array_entity_event_info_s,

4206: | MODIFICATION HISTORY
4207: | Date Author Description of Changes
4208: *=======================================================================*/
4209: PROCEDURE dump_event_info
4210: (p_ev_info_tab IN OUT NOCOPY xla_events_pub_pkg.t_array_entity_event_info_s,
4211: p_i IN BINARY_INTEGER ,
4212: p_tag IN VARCHAR2 ) IS
4213: BEGIN
4214:

Line 4273: l_event_source_info xla_events_pub_pkg.t_event_source_info;

4269: *=======================================================================*/
4270: PROCEDURE delete_event( p_document_id IN NUMBER,
4271: p_doc_table IN VARCHAR2)
4272: IS
4273: l_event_source_info xla_events_pub_pkg.t_event_source_info;
4274: l_security xla_events_pub_pkg.t_security;
4275: l_event_id NUMBER;
4276: /*7229913 */
4277: l_invoicing_rule_id NUMBER;

Line 4274: l_security xla_events_pub_pkg.t_security;

4270: PROCEDURE delete_event( p_document_id IN NUMBER,
4271: p_doc_table IN VARCHAR2)
4272: IS
4273: l_event_source_info xla_events_pub_pkg.t_event_source_info;
4274: l_security xla_events_pub_pkg.t_security;
4275: l_event_id NUMBER;
4276: /*7229913 */
4277: l_invoicing_rule_id NUMBER;
4278: l_document_id NUMBER;

Line 4364: xla_events_pub_pkg.delete_event

4360: l_event_source_info.application_id := 222;
4361: l_event_source_info.ledger_id := arp_standard.sysparm.set_of_books_id; --to be set
4362: l_event_source_info.source_id_int_1 := NVL(l_document_id, p_document_id);
4363:
4364: xla_events_pub_pkg.delete_event
4365: ( p_event_source_info => l_event_source_info,
4366: p_event_id => l_event_id,
4367: p_valuation_method => NULL,
4368: p_security_context => l_security);

Line 4408: l_event_source_info xla_events_pub_pkg.t_event_source_info;

4404: PROCEDURE delete_reverse_revrec_event( p_document_id IN NUMBER,
4405: p_doc_table IN VARCHAR2)
4406: IS
4407:
4408: l_event_source_info xla_events_pub_pkg.t_event_source_info;
4409: l_security xla_events_pub_pkg.t_security;
4410: l_event_id NUMBER;
4411:
4412:

Line 4409: l_security xla_events_pub_pkg.t_security;

4405: p_doc_table IN VARCHAR2)
4406: IS
4407:
4408: l_event_source_info xla_events_pub_pkg.t_event_source_info;
4409: l_security xla_events_pub_pkg.t_security;
4410: l_event_id NUMBER;
4411:
4412:
4413: CURSOR c_ct IS

Line 4442: xla_events_pub_pkg.delete_event

4438: l_event_source_info.application_id := 222;
4439: l_event_source_info.ledger_id := arp_standard.sysparm.set_of_books_id; --to be set
4440: l_event_source_info.source_id_int_1 := p_document_id;
4441:
4442: xla_events_pub_pkg.delete_event
4443: ( p_event_source_info => l_event_source_info,
4444: p_event_id => l_event_id,
4445: p_valuation_method => NULL,
4446: p_security_context => l_security);