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;
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:
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 */
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;
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;
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: --
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
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:
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: --
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
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: --
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
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 );