1875: --BUG#2750340
1876: l_xla_ev_rec arp_xla_events.xla_events_type;
1877:
1878: /* 6888581 */
1879: l_event_source_info xla_events_pub_pkg.t_event_source_info;
1880: l_event_id NUMBER;
1881: l_security xla_events_pub_pkg.t_security;
1882: l_adj_post_to_gl ra_cust_trx_types.adj_post_to_gl%TYPE := 'Y' ;
1883: /* Added local variables to be used in Update_Adjustment procedure, manishri, Bug 9708599 */
1877:
1878: /* 6888581 */
1879: l_event_source_info xla_events_pub_pkg.t_event_source_info;
1880: l_event_id NUMBER;
1881: l_security xla_events_pub_pkg.t_security;
1882: l_adj_post_to_gl ra_cust_trx_types.adj_post_to_gl%TYPE := 'Y' ;
1883: /* Added local variables to be used in Update_Adjustment procedure, manishri, Bug 9708599 */
1884: l_mode VARCHAR2(20);
1885: l_gt_id NUMBER := 0;
2224: and xet.entity_code ='ADJUSTMENTS'
2225: AND xet.application_id = 222
2226: AND adj.SET_OF_BOOKS_ID = xet.LEDGER_ID;
2227:
2228: xla_events_pub_pkg.update_event
2229: (p_event_source_info => l_event_source_info,
2230: p_event_id => l_event_id,
2231: p_event_status_code => 'N',
2232: p_valuation_method => null,
3050: --BUG#2750340
3051: l_xla_ev_rec arp_xla_events.xla_events_type;
3052:
3053: /* 7699796 */
3054: l_event_source_info xla_events_pub_pkg.t_event_source_info;
3055: l_event_id NUMBER;
3056: l_security xla_events_pub_pkg.t_security;
3057: l_adj_post_to_gl ra_cust_trx_types.adj_post_to_gl%TYPE := 'Y' ;
3058:
3052:
3053: /* 7699796 */
3054: l_event_source_info xla_events_pub_pkg.t_event_source_info;
3055: l_event_id NUMBER;
3056: l_security xla_events_pub_pkg.t_security;
3057: l_adj_post_to_gl ra_cust_trx_types.adj_post_to_gl%TYPE := 'Y' ;
3058:
3059: BEGIN
3060: IF PG_DEBUG in ('Y', 'C') THEN
3144: and xet.entity_code ='ADJUSTMENTS'
3145: AND xet.application_id = 222
3146: AND adj.SET_OF_BOOKS_ID = xet.LEDGER_ID;
3147:
3148: xla_events_pub_pkg.update_event
3149: (p_event_source_info => l_event_source_info,
3150: p_event_id => l_event_id,
3151: p_event_status_code => 'N',
3152: p_valuation_method => null,
3443: l_ae_doc_rec ae_doc_rec_type;
3444: --BUG#2750340
3445: l_xla_ev_rec arp_xla_events.xla_events_type;
3446: /* 7699796 */
3447: l_event_source_info xla_events_pub_pkg.t_event_source_info;
3448: l_event_id NUMBER;
3449: l_security xla_events_pub_pkg.t_security;
3450: l_adj_post_to_gl ra_cust_trx_types.adj_post_to_gl%TYPE := 'Y' ;
3451: l_adj_status VARCHAR2(1);
3445: l_xla_ev_rec arp_xla_events.xla_events_type;
3446: /* 7699796 */
3447: l_event_source_info xla_events_pub_pkg.t_event_source_info;
3448: l_event_id NUMBER;
3449: l_security xla_events_pub_pkg.t_security;
3450: l_adj_post_to_gl ra_cust_trx_types.adj_post_to_gl%TYPE := 'Y' ;
3451: l_adj_status VARCHAR2(1);
3452:
3453:
3664: and xet.entity_code ='ADJUSTMENTS'
3665: AND xet.application_id = 222
3666: AND adj.SET_OF_BOOKS_ID = xet.LEDGER_ID;
3667:
3668: xla_events_pub_pkg.update_event
3669: (p_event_source_info => l_event_source_info,
3670: p_event_id => l_event_id,
3671: p_event_status_code => 'N',
3672: p_valuation_method => null,