822: PROCEDURE bind_dist_variables(
823: p_update_cursor IN integer,
824: p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,
825: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
826: p_currency_code IN fnd_currencies.currency_code%type,
827: p_precision IN fnd_currencies.precision%type,
828: p_mau IN
829: fnd_currencies.minimum_accountable_unit%type)
830: IS
823: p_update_cursor IN integer,
824: p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,
825: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
826: p_currency_code IN fnd_currencies.currency_code%type,
827: p_precision IN fnd_currencies.precision%type,
828: p_mau IN
829: fnd_currencies.minimum_accountable_unit%type)
830: IS
831:
825: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
826: p_currency_code IN fnd_currencies.currency_code%type,
827: p_precision IN fnd_currencies.precision%type,
828: p_mau IN
829: fnd_currencies.minimum_accountable_unit%type)
830: IS
831:
832: BEGIN
833:
1385: ra_cust_trx_line_gl_dist.account_set_flag%type,
1386: p_account_class IN
1387: ra_cust_trx_line_gl_dist.account_class%type,
1388: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
1389: p_currency_code IN fnd_currencies.currency_code%type,
1390: p_precision IN fnd_currencies.precision%type,
1391: p_mau IN
1392: fnd_currencies.minimum_accountable_unit%type,
1393: p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype)
1386: p_account_class IN
1387: ra_cust_trx_line_gl_dist.account_class%type,
1388: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
1389: p_currency_code IN fnd_currencies.currency_code%type,
1390: p_precision IN fnd_currencies.precision%type,
1391: p_mau IN
1392: fnd_currencies.minimum_accountable_unit%type,
1393: p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype)
1394: IS
1388: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
1389: p_currency_code IN fnd_currencies.currency_code%type,
1390: p_precision IN fnd_currencies.precision%type,
1391: p_mau IN
1392: fnd_currencies.minimum_accountable_unit%type,
1393: p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype)
1394: IS
1395:
1396: l_count number;
3215: p_cust_trx_line_gl_dist_id IN
3216: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type,
3217: p_exchange_rate IN ra_customer_trx.exchange_rate%type
3218: DEFAULT 1,
3219: p_currency_code IN fnd_currencies.currency_code%type
3220: DEFAULT null,
3221: p_precision IN fnd_currencies.precision%type
3222: DEFAULT null,
3223: p_mau IN
3217: p_exchange_rate IN ra_customer_trx.exchange_rate%type
3218: DEFAULT 1,
3219: p_currency_code IN fnd_currencies.currency_code%type
3220: DEFAULT null,
3221: p_precision IN fnd_currencies.precision%type
3222: DEFAULT null,
3223: p_mau IN
3224: fnd_currencies.minimum_accountable_unit%type
3225: DEFAULT null)
3220: DEFAULT null,
3221: p_precision IN fnd_currencies.precision%type
3222: DEFAULT null,
3223: p_mau IN
3224: fnd_currencies.minimum_accountable_unit%type
3225: DEFAULT null)
3226: IS
3227:
3228: l_where varchar2(500);
3303: p_account_class
3304: IN ra_cust_trx_line_gl_dist.account_class%type,
3305: p_exchange_rate IN ra_customer_trx.exchange_rate%type
3306: DEFAULT 1,
3307: p_currency_code IN fnd_currencies.currency_code%type
3308: DEFAULT null,
3309: p_precision IN fnd_currencies.precision%type
3310: DEFAULT null,
3311: p_mau IN
3305: p_exchange_rate IN ra_customer_trx.exchange_rate%type
3306: DEFAULT 1,
3307: p_currency_code IN fnd_currencies.currency_code%type
3308: DEFAULT null,
3309: p_precision IN fnd_currencies.precision%type
3310: DEFAULT null,
3311: p_mau IN
3312: fnd_currencies.minimum_accountable_unit%type
3313: DEFAULT null)
3308: DEFAULT null,
3309: p_precision IN fnd_currencies.precision%type
3310: DEFAULT null,
3311: p_mau IN
3312: fnd_currencies.minimum_accountable_unit%type
3313: DEFAULT null)
3314: IS
3315:
3316: l_where varchar2(500);
3391: p_account_class
3392: IN ra_cust_trx_line_gl_dist.account_class%type,
3393: p_exchange_rate IN ra_customer_trx.exchange_rate%type
3394: DEFAULT 1,
3395: p_currency_code IN fnd_currencies.currency_code%type
3396: DEFAULT null,
3397: p_precision IN fnd_currencies.precision%type
3398: DEFAULT null,
3399: p_mau IN
3393: p_exchange_rate IN ra_customer_trx.exchange_rate%type
3394: DEFAULT 1,
3395: p_currency_code IN fnd_currencies.currency_code%type
3396: DEFAULT null,
3397: p_precision IN fnd_currencies.precision%type
3398: DEFAULT null,
3399: p_mau IN
3400: fnd_currencies.minimum_accountable_unit%type
3401: DEFAULT null)
3396: DEFAULT null,
3397: p_precision IN fnd_currencies.precision%type
3398: DEFAULT null,
3399: p_mau IN
3400: fnd_currencies.minimum_accountable_unit%type
3401: DEFAULT null)
3402: IS
3403:
3404: l_where varchar2(500);
3479: p_account_class
3480: IN ra_cust_trx_line_gl_dist.account_class%type,
3481: p_exchange_rate IN ra_customer_trx.exchange_rate%type
3482: DEFAULT 1,
3483: p_currency_code IN fnd_currencies.currency_code%type
3484: DEFAULT null,
3485: p_precision IN fnd_currencies.precision%type
3486: DEFAULT null,
3487: p_mau IN
3481: p_exchange_rate IN ra_customer_trx.exchange_rate%type
3482: DEFAULT 1,
3483: p_currency_code IN fnd_currencies.currency_code%type
3484: DEFAULT null,
3485: p_precision IN fnd_currencies.precision%type
3486: DEFAULT null,
3487: p_mau IN
3488: fnd_currencies.minimum_accountable_unit%type
3489: DEFAULT null)
3484: DEFAULT null,
3485: p_precision IN fnd_currencies.precision%type
3486: DEFAULT null,
3487: p_mau IN
3488: fnd_currencies.minimum_accountable_unit%type
3489: DEFAULT null)
3490: IS
3491:
3492: l_where varchar2(500);
3560: +===========================================================================*/
3561:
3562: PROCEDURE update_acctd_amount(p_customer_trx_id IN number,
3563: p_base_curr_code IN
3564: fnd_currencies.currency_code%type,
3565: p_exchange_rate IN
3566: ra_customer_trx.exchange_rate%type,
3567: p_base_precision IN
3568: fnd_currencies.precision%type
3564: fnd_currencies.currency_code%type,
3565: p_exchange_rate IN
3566: ra_customer_trx.exchange_rate%type,
3567: p_base_precision IN
3568: fnd_currencies.precision%type
3569: default null,
3570: p_base_min_acc_unit IN
3571: fnd_currencies.minimum_accountable_unit%type
3572: default null)
3567: p_base_precision IN
3568: fnd_currencies.precision%type
3569: default null,
3570: p_base_min_acc_unit IN
3571: fnd_currencies.minimum_accountable_unit%type
3572: default null)
3573: IS
3574: l_gl_dist_key_value_list gl_ca_utility_pkg.r_key_value_arr;
3575:
3654: ra_customer_trx_lines.customer_trx_line_id%type,
3655: p_line_amount IN
3656: ra_customer_trx_lines.extended_amount%type,
3657: p_foreign_currency_code IN
3658: fnd_currencies.currency_code%type,
3659: p_base_curr_code IN
3660: fnd_currencies.currency_code%type,
3661: p_exchange_rate IN
3662: ra_customer_trx.exchange_rate%type,
3656: ra_customer_trx_lines.extended_amount%type,
3657: p_foreign_currency_code IN
3658: fnd_currencies.currency_code%type,
3659: p_base_curr_code IN
3660: fnd_currencies.currency_code%type,
3661: p_exchange_rate IN
3662: ra_customer_trx.exchange_rate%type,
3663: p_base_precision IN
3664: fnd_currencies.precision%type
3660: fnd_currencies.currency_code%type,
3661: p_exchange_rate IN
3662: ra_customer_trx.exchange_rate%type,
3663: p_base_precision IN
3664: fnd_currencies.precision%type
3665: default null,
3666: p_base_min_acc_unit IN
3667: fnd_currencies.minimum_accountable_unit%type
3668: default null)
3663: p_base_precision IN
3664: fnd_currencies.precision%type
3665: default null,
3666: p_base_min_acc_unit IN
3667: fnd_currencies.minimum_accountable_unit%type
3668: default null)
3669: IS
3670: l_gl_dist_key_value_list gl_ca_utility_pkg.r_key_value_arr;
3671:
3764: p_cust_trx_line_gl_dist_id
3765: OUT NOCOPY ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type,
3766: p_exchange_rate IN ra_customer_trx.exchange_rate%type
3767: DEFAULT 1,
3768: p_currency_code IN fnd_currencies.currency_code%type
3769: DEFAULT null,
3770: p_precision IN fnd_currencies.precision%type
3771: DEFAULT null,
3772: p_mau IN fnd_currencies.minimum_accountable_unit%type
3766: p_exchange_rate IN ra_customer_trx.exchange_rate%type
3767: DEFAULT 1,
3768: p_currency_code IN fnd_currencies.currency_code%type
3769: DEFAULT null,
3770: p_precision IN fnd_currencies.precision%type
3771: DEFAULT null,
3772: p_mau IN fnd_currencies.minimum_accountable_unit%type
3773: DEFAULT null
3774: ) IS
3768: p_currency_code IN fnd_currencies.currency_code%type
3769: DEFAULT null,
3770: p_precision IN fnd_currencies.precision%type
3771: DEFAULT null,
3772: p_mau IN fnd_currencies.minimum_accountable_unit%type
3773: DEFAULT null
3774: ) IS
3775:
3776: