DBA Data[Home] [Help]

APPS.AR_PURGE dependencies on GL_CA_UTILITY_PKG

Line 3409: l_adj_key_value_list gl_ca_utility_pkg.r_key_value_arr;

3405: END;
3406: --
3407: DECLARE
3408: l_batch_id NUMBER(15) ;
3409: l_adj_key_value_list gl_ca_utility_pkg.r_key_value_arr;
3410: l_ra_batch_key_value_list gl_ca_utility_pkg.r_key_value_arr;
3411: l_ar_ps_key_value_list gl_ca_utility_pkg.r_key_value_arr;
3412: l_ar_dist_key_value_list gl_ca_utility_pkg.r_key_value_arr;
3413: l_gl_dist_key_value_list gl_ca_utility_pkg.r_key_value_arr;

Line 3410: l_ra_batch_key_value_list gl_ca_utility_pkg.r_key_value_arr;

3406: --
3407: DECLARE
3408: l_batch_id NUMBER(15) ;
3409: l_adj_key_value_list gl_ca_utility_pkg.r_key_value_arr;
3410: l_ra_batch_key_value_list gl_ca_utility_pkg.r_key_value_arr;
3411: l_ar_ps_key_value_list gl_ca_utility_pkg.r_key_value_arr;
3412: l_ar_dist_key_value_list gl_ca_utility_pkg.r_key_value_arr;
3413: l_gl_dist_key_value_list gl_ca_utility_pkg.r_key_value_arr;
3414:

Line 3411: l_ar_ps_key_value_list gl_ca_utility_pkg.r_key_value_arr;

3407: DECLARE
3408: l_batch_id NUMBER(15) ;
3409: l_adj_key_value_list gl_ca_utility_pkg.r_key_value_arr;
3410: l_ra_batch_key_value_list gl_ca_utility_pkg.r_key_value_arr;
3411: l_ar_ps_key_value_list gl_ca_utility_pkg.r_key_value_arr;
3412: l_ar_dist_key_value_list gl_ca_utility_pkg.r_key_value_arr;
3413: l_gl_dist_key_value_list gl_ca_utility_pkg.r_key_value_arr;
3414:
3415: /* bug2021662 : added for getting deleted correspondence_id */

Line 3412: l_ar_dist_key_value_list gl_ca_utility_pkg.r_key_value_arr;

3408: l_batch_id NUMBER(15) ;
3409: l_adj_key_value_list gl_ca_utility_pkg.r_key_value_arr;
3410: l_ra_batch_key_value_list gl_ca_utility_pkg.r_key_value_arr;
3411: l_ar_ps_key_value_list gl_ca_utility_pkg.r_key_value_arr;
3412: l_ar_dist_key_value_list gl_ca_utility_pkg.r_key_value_arr;
3413: l_gl_dist_key_value_list gl_ca_utility_pkg.r_key_value_arr;
3414:
3415: /* bug2021662 : added for getting deleted correspondence_id */
3416: TYPE Del_Cid_Tab IS TABLE OF ar_correspondences.correspondence_id%TYPE INDEX BY BINARY_INTEGER;

Line 3413: l_gl_dist_key_value_list gl_ca_utility_pkg.r_key_value_arr;

3409: l_adj_key_value_list gl_ca_utility_pkg.r_key_value_arr;
3410: l_ra_batch_key_value_list gl_ca_utility_pkg.r_key_value_arr;
3411: l_ar_ps_key_value_list gl_ca_utility_pkg.r_key_value_arr;
3412: l_ar_dist_key_value_list gl_ca_utility_pkg.r_key_value_arr;
3413: l_gl_dist_key_value_list gl_ca_utility_pkg.r_key_value_arr;
3414:
3415: /* bug2021662 : added for getting deleted correspondence_id */
3416: TYPE Del_Cid_Tab IS TABLE OF ar_correspondences.correspondence_id%TYPE INDEX BY BINARY_INTEGER;
3417: del_cid Del_Cid_Tab;

Line 3710: l_ar_dist_key_value_list gl_ca_utility_pkg.r_key_value_arr;

3706: l_applied_customer_trx_id NUMBER;
3707: l_application_type ar_receivable_applications.application_type%TYPE;
3708: l_receipt_amount NUMBER;
3709: l_discount_amount NUMBER;
3710: l_ar_dist_key_value_list gl_ca_utility_pkg.r_key_value_arr;
3711: l_rec_app_key_value_list gl_ca_utility_pkg.r_key_value_arr;
3712: BEGIN
3713: OPEN app_to_invoice( p_entity_id );
3714: --

Line 3711: l_rec_app_key_value_list gl_ca_utility_pkg.r_key_value_arr;

3707: l_application_type ar_receivable_applications.application_type%TYPE;
3708: l_receipt_amount NUMBER;
3709: l_discount_amount NUMBER;
3710: l_ar_dist_key_value_list gl_ca_utility_pkg.r_key_value_arr;
3711: l_rec_app_key_value_list gl_ca_utility_pkg.r_key_value_arr;
3712: BEGIN
3713: OPEN app_to_invoice( p_entity_id );
3714: --
3715: DELETE FROM ar_distributions

Line 4096: l_rate_adj_key_value_list gl_ca_utility_pkg.r_key_value_arr;

4092: l_batch_id BatchTyp ;
4093: l_batch_id_null BatchTyp ;
4094: l_trans_id NUMBER(15) ;
4095:
4096: l_rate_adj_key_value_list gl_ca_utility_pkg.r_key_value_arr;
4097: l_ar_batch_key_value_list gl_ca_utility_pkg.r_key_value_arr;
4098: l_ar_ps_key_value_list gl_ca_utility_pkg.r_key_value_arr;
4099: l_ar_dist_key_value_list gl_ca_utility_pkg.r_key_value_arr;
4100:

Line 4097: l_ar_batch_key_value_list gl_ca_utility_pkg.r_key_value_arr;

4093: l_batch_id_null BatchTyp ;
4094: l_trans_id NUMBER(15) ;
4095:
4096: l_rate_adj_key_value_list gl_ca_utility_pkg.r_key_value_arr;
4097: l_ar_batch_key_value_list gl_ca_utility_pkg.r_key_value_arr;
4098: l_ar_ps_key_value_list gl_ca_utility_pkg.r_key_value_arr;
4099: l_ar_dist_key_value_list gl_ca_utility_pkg.r_key_value_arr;
4100:
4101: --

Line 4098: l_ar_ps_key_value_list gl_ca_utility_pkg.r_key_value_arr;

4094: l_trans_id NUMBER(15) ;
4095:
4096: l_rate_adj_key_value_list gl_ca_utility_pkg.r_key_value_arr;
4097: l_ar_batch_key_value_list gl_ca_utility_pkg.r_key_value_arr;
4098: l_ar_ps_key_value_list gl_ca_utility_pkg.r_key_value_arr;
4099: l_ar_dist_key_value_list gl_ca_utility_pkg.r_key_value_arr;
4100:
4101: --
4102: -- lock ar_batches row before deleting

Line 4099: l_ar_dist_key_value_list gl_ca_utility_pkg.r_key_value_arr;

4095:
4096: l_rate_adj_key_value_list gl_ca_utility_pkg.r_key_value_arr;
4097: l_ar_batch_key_value_list gl_ca_utility_pkg.r_key_value_arr;
4098: l_ar_ps_key_value_list gl_ca_utility_pkg.r_key_value_arr;
4099: l_ar_dist_key_value_list gl_ca_utility_pkg.r_key_value_arr;
4100:
4101: --
4102: -- lock ar_batches row before deleting
4103: --

Line 4306: l_ar_dist_key_value_list gl_ca_utility_pkg.r_key_value_arr;

4302: l_gl_date DATE;
4303: l_period_name VARCHAR2(15) ;
4304: l_status BOOLEAN;
4305: l_cnt_unapp_rows NUMBER;
4306: l_ar_dist_key_value_list gl_ca_utility_pkg.r_key_value_arr;
4307: l_rec_app_key_value_list gl_ca_utility_pkg.r_key_value_arr;
4308:
4309:
4310: BEGIN

Line 4307: l_rec_app_key_value_list gl_ca_utility_pkg.r_key_value_arr;

4303: l_period_name VARCHAR2(15) ;
4304: l_status BOOLEAN;
4305: l_cnt_unapp_rows NUMBER;
4306: l_ar_dist_key_value_list gl_ca_utility_pkg.r_key_value_arr;
4307: l_rec_app_key_value_list gl_ca_utility_pkg.r_key_value_arr;
4308:
4309:
4310: BEGIN
4311: OPEN app_from_receipt( p_entity_id );