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:
1380: ra_cust_trx_line_gl_dist.account_set_flag%type,
1381: p_account_class IN
1382: ra_cust_trx_line_gl_dist.account_class%type,
1383: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
1384: p_currency_code IN fnd_currencies.currency_code%type,
1385: p_precision IN fnd_currencies.precision%type,
1386: p_mau IN
1387: fnd_currencies.minimum_accountable_unit%type,
1388: p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype)
1381: p_account_class IN
1382: ra_cust_trx_line_gl_dist.account_class%type,
1383: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
1384: p_currency_code IN fnd_currencies.currency_code%type,
1385: p_precision IN fnd_currencies.precision%type,
1386: p_mau IN
1387: fnd_currencies.minimum_accountable_unit%type,
1388: p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype)
1389: IS
1383: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
1384: p_currency_code IN fnd_currencies.currency_code%type,
1385: p_precision IN fnd_currencies.precision%type,
1386: p_mau IN
1387: fnd_currencies.minimum_accountable_unit%type,
1388: p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype)
1389: IS
1390:
1391: l_count number;
3159: p_cust_trx_line_gl_dist_id IN
3160: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type,
3161: p_exchange_rate IN ra_customer_trx.exchange_rate%type
3162: DEFAULT 1,
3163: p_currency_code IN fnd_currencies.currency_code%type
3164: DEFAULT null,
3165: p_precision IN fnd_currencies.precision%type
3166: DEFAULT null,
3167: p_mau IN
3161: p_exchange_rate IN ra_customer_trx.exchange_rate%type
3162: DEFAULT 1,
3163: p_currency_code IN fnd_currencies.currency_code%type
3164: DEFAULT null,
3165: p_precision IN fnd_currencies.precision%type
3166: DEFAULT null,
3167: p_mau IN
3168: fnd_currencies.minimum_accountable_unit%type
3169: DEFAULT null)
3164: DEFAULT null,
3165: p_precision IN fnd_currencies.precision%type
3166: DEFAULT null,
3167: p_mau IN
3168: fnd_currencies.minimum_accountable_unit%type
3169: DEFAULT null)
3170: IS
3171:
3172: l_where varchar2(500);
3247: p_account_class
3248: IN ra_cust_trx_line_gl_dist.account_class%type,
3249: p_exchange_rate IN ra_customer_trx.exchange_rate%type
3250: DEFAULT 1,
3251: p_currency_code IN fnd_currencies.currency_code%type
3252: DEFAULT null,
3253: p_precision IN fnd_currencies.precision%type
3254: DEFAULT null,
3255: p_mau IN
3249: p_exchange_rate IN ra_customer_trx.exchange_rate%type
3250: DEFAULT 1,
3251: p_currency_code IN fnd_currencies.currency_code%type
3252: DEFAULT null,
3253: p_precision IN fnd_currencies.precision%type
3254: DEFAULT null,
3255: p_mau IN
3256: fnd_currencies.minimum_accountable_unit%type
3257: DEFAULT null)
3252: DEFAULT null,
3253: p_precision IN fnd_currencies.precision%type
3254: DEFAULT null,
3255: p_mau IN
3256: fnd_currencies.minimum_accountable_unit%type
3257: DEFAULT null)
3258: IS
3259:
3260: l_where varchar2(500);
3335: p_account_class
3336: IN ra_cust_trx_line_gl_dist.account_class%type,
3337: p_exchange_rate IN ra_customer_trx.exchange_rate%type
3338: DEFAULT 1,
3339: p_currency_code IN fnd_currencies.currency_code%type
3340: DEFAULT null,
3341: p_precision IN fnd_currencies.precision%type
3342: DEFAULT null,
3343: p_mau IN
3337: p_exchange_rate IN ra_customer_trx.exchange_rate%type
3338: DEFAULT 1,
3339: p_currency_code IN fnd_currencies.currency_code%type
3340: DEFAULT null,
3341: p_precision IN fnd_currencies.precision%type
3342: DEFAULT null,
3343: p_mau IN
3344: fnd_currencies.minimum_accountable_unit%type
3345: DEFAULT null)
3340: DEFAULT null,
3341: p_precision IN fnd_currencies.precision%type
3342: DEFAULT null,
3343: p_mau IN
3344: fnd_currencies.minimum_accountable_unit%type
3345: DEFAULT null)
3346: IS
3347:
3348: l_where varchar2(500);
3423: p_account_class
3424: IN ra_cust_trx_line_gl_dist.account_class%type,
3425: p_exchange_rate IN ra_customer_trx.exchange_rate%type
3426: DEFAULT 1,
3427: p_currency_code IN fnd_currencies.currency_code%type
3428: DEFAULT null,
3429: p_precision IN fnd_currencies.precision%type
3430: DEFAULT null,
3431: p_mau IN
3425: p_exchange_rate IN ra_customer_trx.exchange_rate%type
3426: DEFAULT 1,
3427: p_currency_code IN fnd_currencies.currency_code%type
3428: DEFAULT null,
3429: p_precision IN fnd_currencies.precision%type
3430: DEFAULT null,
3431: p_mau IN
3432: fnd_currencies.minimum_accountable_unit%type
3433: DEFAULT null)
3428: DEFAULT null,
3429: p_precision IN fnd_currencies.precision%type
3430: DEFAULT null,
3431: p_mau IN
3432: fnd_currencies.minimum_accountable_unit%type
3433: DEFAULT null)
3434: IS
3435:
3436: l_where varchar2(500);
3504: +===========================================================================*/
3505:
3506: PROCEDURE update_acctd_amount(p_customer_trx_id IN number,
3507: p_base_curr_code IN
3508: fnd_currencies.currency_code%type,
3509: p_exchange_rate IN
3510: ra_customer_trx.exchange_rate%type,
3511: p_base_precision IN
3512: fnd_currencies.precision%type
3508: fnd_currencies.currency_code%type,
3509: p_exchange_rate IN
3510: ra_customer_trx.exchange_rate%type,
3511: p_base_precision IN
3512: fnd_currencies.precision%type
3513: default null,
3514: p_base_min_acc_unit IN
3515: fnd_currencies.minimum_accountable_unit%type
3516: default null)
3511: p_base_precision IN
3512: fnd_currencies.precision%type
3513: default null,
3514: p_base_min_acc_unit IN
3515: fnd_currencies.minimum_accountable_unit%type
3516: default null)
3517: IS
3518: l_gl_dist_key_value_list gl_ca_utility_pkg.r_key_value_arr;
3519:
3600: ra_customer_trx_lines.customer_trx_line_id%type,
3601: p_line_amount IN
3602: ra_customer_trx_lines.extended_amount%type,
3603: p_foreign_currency_code IN
3604: fnd_currencies.currency_code%type,
3605: p_base_curr_code IN
3606: fnd_currencies.currency_code%type,
3607: p_exchange_rate IN
3608: ra_customer_trx.exchange_rate%type,
3602: ra_customer_trx_lines.extended_amount%type,
3603: p_foreign_currency_code IN
3604: fnd_currencies.currency_code%type,
3605: p_base_curr_code IN
3606: fnd_currencies.currency_code%type,
3607: p_exchange_rate IN
3608: ra_customer_trx.exchange_rate%type,
3609: p_base_precision IN
3610: fnd_currencies.precision%type
3606: fnd_currencies.currency_code%type,
3607: p_exchange_rate IN
3608: ra_customer_trx.exchange_rate%type,
3609: p_base_precision IN
3610: fnd_currencies.precision%type
3611: default null,
3612: p_base_min_acc_unit IN
3613: fnd_currencies.minimum_accountable_unit%type
3614: default null)
3609: p_base_precision IN
3610: fnd_currencies.precision%type
3611: default null,
3612: p_base_min_acc_unit IN
3613: fnd_currencies.minimum_accountable_unit%type
3614: default null)
3615: IS
3616: l_gl_dist_key_value_list gl_ca_utility_pkg.r_key_value_arr;
3617:
3710: p_cust_trx_line_gl_dist_id
3711: OUT NOCOPY ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type,
3712: p_exchange_rate IN ra_customer_trx.exchange_rate%type
3713: DEFAULT 1,
3714: p_currency_code IN fnd_currencies.currency_code%type
3715: DEFAULT null,
3716: p_precision IN fnd_currencies.precision%type
3717: DEFAULT null,
3718: p_mau IN fnd_currencies.minimum_accountable_unit%type
3712: p_exchange_rate IN ra_customer_trx.exchange_rate%type
3713: DEFAULT 1,
3714: p_currency_code IN fnd_currencies.currency_code%type
3715: DEFAULT null,
3716: p_precision IN fnd_currencies.precision%type
3717: DEFAULT null,
3718: p_mau IN fnd_currencies.minimum_accountable_unit%type
3719: DEFAULT null
3720: ) IS
3714: p_currency_code IN fnd_currencies.currency_code%type
3715: DEFAULT null,
3716: p_precision IN fnd_currencies.precision%type
3717: DEFAULT null,
3718: p_mau IN fnd_currencies.minimum_accountable_unit%type
3719: DEFAULT null
3720: ) IS
3721:
3722: