DBA Data[Home] [Help]

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 2236: bld_ev_ent xla_events_pub_pkg.t_array_entity_event_info_s;

2232: empty_bld_ev_rec bld_ev_type ;
2233:
2234: --cache_ev_rec bld_ev_type ;
2235:
2236: bld_ev_ent xla_events_pub_pkg.t_array_entity_event_info_s;
2237: empty_bld_ev_ent xla_events_pub_pkg.t_array_entity_event_info_s;
2238:
2239: prev_distid VARCHAR2(50) := '';
2240:

Line 2237: empty_bld_ev_ent xla_events_pub_pkg.t_array_entity_event_info_s;

2233:
2234: --cache_ev_rec bld_ev_type ;
2235:
2236: bld_ev_ent xla_events_pub_pkg.t_array_entity_event_info_s;
2237: empty_bld_ev_ent xla_events_pub_pkg.t_array_entity_event_info_s;
2238:
2239: prev_distid VARCHAR2(50) := '';
2240:
2241: l_cached BOOLEAN;

Line 2275: l_event_source_info xla_events_pub_pkg.t_event_source_info;

2271: l_low INTEGER:=0;
2272: l_high INTEGER:=0;
2273: lnb NUMBER;
2274: --xla event api declarations
2275: l_event_source_info xla_events_pub_pkg.t_event_source_info;
2276: l_reference_info xla_events_pub_pkg.t_event_reference_info;
2277: l_security_context xla_events_pub_pkg.t_security;
2278: l_entity_event_info_tbl xla_events_pub_pkg.t_array_entity_event_info_s;
2279: keep_flag BOOLEAN;

Line 2276: l_reference_info xla_events_pub_pkg.t_event_reference_info;

2272: l_high INTEGER:=0;
2273: lnb NUMBER;
2274: --xla event api declarations
2275: l_event_source_info xla_events_pub_pkg.t_event_source_info;
2276: l_reference_info xla_events_pub_pkg.t_event_reference_info;
2277: l_security_context xla_events_pub_pkg.t_security;
2278: l_entity_event_info_tbl xla_events_pub_pkg.t_array_entity_event_info_s;
2279: keep_flag BOOLEAN;
2280: l_revrun VARCHAR2(5);

Line 2277: l_security_context xla_events_pub_pkg.t_security;

2273: lnb NUMBER;
2274: --xla event api declarations
2275: l_event_source_info xla_events_pub_pkg.t_event_source_info;
2276: l_reference_info xla_events_pub_pkg.t_event_reference_info;
2277: l_security_context xla_events_pub_pkg.t_security;
2278: l_entity_event_info_tbl xla_events_pub_pkg.t_array_entity_event_info_s;
2279: keep_flag BOOLEAN;
2280: l_revrun VARCHAR2(5);
2281: l_entity_code VARCHAR2(20);

Line 2278: l_entity_event_info_tbl xla_events_pub_pkg.t_array_entity_event_info_s;

2274: --xla event api declarations
2275: l_event_source_info xla_events_pub_pkg.t_event_source_info;
2276: l_reference_info xla_events_pub_pkg.t_event_reference_info;
2277: l_security_context xla_events_pub_pkg.t_security;
2278: l_entity_event_info_tbl xla_events_pub_pkg.t_array_entity_event_info_s;
2279: keep_flag BOOLEAN;
2280: l_revrun VARCHAR2(5);
2281: l_entity_code VARCHAR2(20);
2282: z NUMBER :=0;

Line 2889: xla_events_pub_pkg.delete_event

2885: -- Set security_context
2886: l_security_context.security_id_int_1 := ev_rec.org_id(i);
2887:
2888: -- Delete the event
2889: xla_events_pub_pkg.delete_event
2890: ( p_event_source_info => l_event_source_info,
2891: p_event_id => ev_rec.ev_match_event_id(i),
2892: p_valuation_method => NULL,
2893: p_security_context => l_security_context);

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

3124: +-------------------------------------------------------------*/
3125:
3126: IF p_xla_ev_rec.xla_mode IN ('U','B') AND test_flag = 'N' THEN
3127:
3128: log('xla_events_pub_pkg.create_bulk_events xla_mode IN (U,B)');
3129:
3130: /*
3131: bld_ev_ent := xla_events_pub_pkg.create_bulk_events(
3132: p_application_id => 222 ,

Line 3131: bld_ev_ent := xla_events_pub_pkg.create_bulk_events(

3127:
3128: log('xla_events_pub_pkg.create_bulk_events xla_mode IN (U,B)');
3129:
3130: /*
3131: bld_ev_ent := xla_events_pub_pkg.create_bulk_events(
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
3135: p_entity_type_code => l_entity_code ,-- to be set later

Line 3142: xla_events_pub_pkg.create_bulk_events(

3138: -- p_security_context => l_security_context);
3139: */
3140: /* As this call is not suitable to AR, the bug for XLA spi enhancement has been logged
3141: BUG#4448003 for now converting this call to single event call
3142: xla_events_pub_pkg.create_bulk_events(
3143: p_source_application_id => NULL ,
3144: p_application_id => 222 ,
3145: p_legal_entity_id => '1' ,-- to be set later
3146: p_ledger_id => arp_standard.sysparm.set_of_books_id ,-- to be set later

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

3221: --to be ascertained after events template is filled
3222:
3223: IF bld_ev_rec.bld_dml_flag(m) = 'I' AND test_flag = 'N' THEN
3224:
3225: log('XLA_EVENTS_PUB_PKG.create_event');
3226:
3227: z := z + 1;
3228: log('hyu calling create event for zth time :'||z);
3229:

Line 3230: lnb := XLA_EVENTS_PUB_PKG.create_event(

3226:
3227: z := z + 1;
3228: log('hyu calling create event for zth time :'||z);
3229:
3230: lnb := XLA_EVENTS_PUB_PKG.create_event(
3231: p_event_source_info => l_event_source_info ,
3232: p_event_type_code => bld_ev_ent(m).event_type_code ,
3233: p_event_date => bld_ev_ent(m).event_date ,
3234: p_event_status_code => bld_ev_ent(m).event_status_code ,

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

3241: p_security_context => l_security_context );
3242:
3243: ELSIF bld_ev_rec.bld_dml_flag(m) = 'U' AND test_flag = 'N' THEN
3244:
3245: log('XLA_EVENTS_PUB_PKG.update_event');
3246:
3247: log('bld_ev_ent(m).event_id :'||bld_ev_ent(m).event_id );
3248: log('bld_ev_ent(m).event_type_code :'||bld_ev_ent(m).event_type_code );
3249: log(' bld_ev_ent(m).event_date :'|| bld_ev_ent(m).event_date );

Line 3253: XLA_EVENTS_PUB_PKG.update_event(

3249: log(' bld_ev_ent(m).event_date :'|| bld_ev_ent(m).event_date );
3250: log(' bld_ev_ent(m).event_status_code :'|| bld_ev_ent(m).event_status_code);
3251: log(' p_security_context.security_id_int_1 :'|| l_security_context.security_id_int_1 );
3252:
3253: XLA_EVENTS_PUB_PKG.update_event(
3254: p_event_source_info => l_event_source_info ,
3255: p_event_id => bld_ev_ent(m).event_id ,
3256: p_event_type_code => bld_ev_ent(m).event_type_code ,
3257: p_event_date => bld_ev_ent(m).event_date ,

Line 3286: XLA_EVENTS_PUB_PKG.UPDATE_TRANSACTION_NUMBER(

3282: RAISE;
3283: END;
3284:
3285: IF NVL(trxn_number,-99) <> bld_ev_ent(m).transaction_number THEN
3286: XLA_EVENTS_PUB_PKG.UPDATE_TRANSACTION_NUMBER(
3287: p_event_source_info => l_event_source_info,
3288: p_transaction_number => bld_ev_ent(m).transaction_number,
3289: p_valuation_method => '',
3290: p_security_context => l_security_context ,

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

3320: IF p_xla_ev_rec.xla_mode = 'B' THEN
3321: OPEN for_batch;
3322: FETCH for_batch INTO l_test;
3323: IF for_batch%FOUND THEN
3324: log('Calling xla_events_pub_pkg.create_bulk_events +');
3325: xla_events_pub_pkg.create_bulk_events
3326: (p_application_id => 222,
3327: p_ledger_id => arp_standard.sysparm.set_of_books_id,
3328: p_entity_type_code => l_entity_code);

Line 3325: xla_events_pub_pkg.create_bulk_events

3321: OPEN for_batch;
3322: FETCH for_batch INTO l_test;
3323: IF for_batch%FOUND THEN
3324: log('Calling xla_events_pub_pkg.create_bulk_events +');
3325: xla_events_pub_pkg.create_bulk_events
3326: (p_application_id => 222,
3327: p_ledger_id => arp_standard.sysparm.set_of_books_id,
3328: p_entity_type_code => l_entity_code);
3329: --avoid recreation of successfully events

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

3327: p_ledger_id => arp_standard.sysparm.set_of_books_id,
3328: p_entity_type_code => l_entity_code);
3329: --avoid recreation of successfully events
3330: DELETE from xla_events_int_gt WHERE entity_id IS NOT NULL;
3331: log('Calling xla_events_pub_pkg.create_bulk_events -');
3332: END IF;
3333: CLOSE for_batch;
3334: END IF;
3335: --}

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

3779:
3780:
3781: --HYU
3782: PROCEDURE dump_event_source_info
3783: (x_ev_source_info IN OUT NOCOPY xla_events_pub_pkg.t_event_Source_info)
3784: IS
3785: BEGIN
3786:
3787: log(' ');

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

4218: | MODIFICATION HISTORY
4219: | Date Author Description of Changes
4220: *=======================================================================*/
4221: PROCEDURE dump_event_info
4222: (p_ev_info_tab IN OUT NOCOPY xla_events_pub_pkg.t_array_entity_event_info_s,
4223: p_i IN BINARY_INTEGER ,
4224: p_tag IN VARCHAR2 ) IS
4225: BEGIN
4226:

Line 4285: l_event_source_info xla_events_pub_pkg.t_event_source_info;

4281: *=======================================================================*/
4282: PROCEDURE delete_event( p_document_id IN NUMBER,
4283: p_doc_table IN VARCHAR2)
4284: IS
4285: l_event_source_info xla_events_pub_pkg.t_event_source_info;
4286: l_security xla_events_pub_pkg.t_security;
4287: l_event_id NUMBER;
4288: /*7229913 */
4289: l_invoicing_rule_id NUMBER;

Line 4286: l_security xla_events_pub_pkg.t_security;

4282: PROCEDURE delete_event( p_document_id IN NUMBER,
4283: p_doc_table IN VARCHAR2)
4284: IS
4285: l_event_source_info xla_events_pub_pkg.t_event_source_info;
4286: l_security xla_events_pub_pkg.t_security;
4287: l_event_id NUMBER;
4288: /*7229913 */
4289: l_invoicing_rule_id NUMBER;
4290: l_document_id NUMBER;

Line 4376: xla_events_pub_pkg.delete_event

4372: l_event_source_info.application_id := 222;
4373: l_event_source_info.ledger_id := arp_standard.sysparm.set_of_books_id; --to be set
4374: l_event_source_info.source_id_int_1 := NVL(l_document_id, p_document_id);
4375:
4376: xla_events_pub_pkg.delete_event
4377: ( p_event_source_info => l_event_source_info,
4378: p_event_id => l_event_id,
4379: p_valuation_method => NULL,
4380: p_security_context => l_security);

Line 4420: l_event_source_info xla_events_pub_pkg.t_event_source_info;

4416: PROCEDURE delete_reverse_revrec_event( p_document_id IN NUMBER,
4417: p_doc_table IN VARCHAR2)
4418: IS
4419:
4420: l_event_source_info xla_events_pub_pkg.t_event_source_info;
4421: l_security xla_events_pub_pkg.t_security;
4422: l_event_id NUMBER;
4423:
4424:

Line 4421: l_security xla_events_pub_pkg.t_security;

4417: p_doc_table IN VARCHAR2)
4418: IS
4419:
4420: l_event_source_info xla_events_pub_pkg.t_event_source_info;
4421: l_security xla_events_pub_pkg.t_security;
4422: l_event_id NUMBER;
4423:
4424:
4425: CURSOR c_ct IS

Line 4454: xla_events_pub_pkg.delete_event

4450: l_event_source_info.application_id := 222;
4451: l_event_source_info.ledger_id := arp_standard.sysparm.set_of_books_id; --to be set
4452: l_event_source_info.source_id_int_1 := p_document_id;
4453:
4454: xla_events_pub_pkg.delete_event
4455: ( p_event_source_info => l_event_source_info,
4456: p_event_id => l_event_id,
4457: p_valuation_method => NULL,
4458: p_security_context => l_security);