DBA Data[Home] [Help]

APPS.ARP_CTLGD_PKG dependencies on RA_CUSTOMER_TRX

Line 300: ra_customer_trx.customer_trx_id%type)

296: +===========================================================================*/
297:
298:
299: PROCEDURE display_dist_f_ct_id( p_customer_trx_id IN
300: ra_customer_trx.customer_trx_id%type)
301: IS
302:
303: l_cust_trx_line_gl_dist_id
304: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type;

Line 376: ra_customer_trx_lines.customer_trx_line_id%type)

372: +===========================================================================*/
373:
374:
375: PROCEDURE display_dist_f_ctl_id( p_customer_trx_line_id IN
376: ra_customer_trx_lines.customer_trx_line_id%type)
377: IS
378:
379: l_cust_trx_line_gl_dist_id
380: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type;

Line 825: p_exchange_rate IN ra_customer_trx.exchange_rate%type,

821:
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)

Line 1383: p_exchange_rate IN ra_customer_trx.exchange_rate%type,

1379: p_account_set_flag IN
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,

Line 1688: IN ra_customer_trx.customer_trx_id%type,

1684: | |
1685: +===========================================================================*/
1686:
1687: PROCEDURE lock_f_ct_id( p_customer_trx_id
1688: IN ra_customer_trx.customer_trx_id%type,
1689: p_account_set_flag
1690: IN ra_cust_trx_line_gl_dist.account_set_flag%type,
1691: p_account_class
1692: IN ra_cust_trx_line_gl_dist.account_class%type)

Line 1749: IN ra_customer_trx_lines.customer_trx_line_id%type,

1745: | |
1746: +===========================================================================*/
1747:
1748: PROCEDURE lock_f_ctl_id( p_customer_trx_line_id
1749: IN ra_customer_trx_lines.customer_trx_line_id%type,
1750: p_account_set_flag
1751: IN ra_cust_trx_line_gl_dist.account_set_flag%type,
1752: p_account_class
1753: IN ra_cust_trx_line_gl_dist.account_class%type)

Line 2854: IN ra_customer_trx.customer_trx_id%type,

2850: | |
2851: +===========================================================================*/
2852:
2853: procedure delete_f_ct_id( p_customer_trx_id
2854: IN ra_customer_trx.customer_trx_id%type,
2855: p_account_set_flag
2856: IN ra_cust_trx_line_gl_dist.account_set_flag%type,
2857: p_account_class
2858: IN ra_cust_trx_line_gl_dist.account_class%type)

Line 2925: IN ra_customer_trx_lines.customer_trx_line_id%type,

2921: | |
2922: +===========================================================================*/
2923:
2924: procedure delete_f_ctl_id( p_customer_trx_line_id
2925: IN ra_customer_trx_lines.customer_trx_line_id%type,
2926: p_account_set_flag
2927: IN ra_cust_trx_line_gl_dist.account_set_flag%type,
2928: p_account_class
2929: IN ra_cust_trx_line_gl_dist.account_class%type)

Line 3071: ra_customer_trx.customer_trx_id%type,

3067: +===========================================================================*/
3068:
3069: PROCEDURE delete_f_ct_ltctl_id_type(
3070: p_customer_trx_id IN
3071: ra_customer_trx.customer_trx_id%type,
3072: p_link_to_cust_trx_line_id IN
3073: ra_customer_trx_lines.link_to_cust_trx_line_id%type,
3074: p_line_type IN
3075: ra_customer_trx_lines.line_type%type,

Line 3073: ra_customer_trx_lines.link_to_cust_trx_line_id%type,

3069: PROCEDURE delete_f_ct_ltctl_id_type(
3070: p_customer_trx_id IN
3071: ra_customer_trx.customer_trx_id%type,
3072: p_link_to_cust_trx_line_id IN
3073: ra_customer_trx_lines.link_to_cust_trx_line_id%type,
3074: p_line_type IN
3075: ra_customer_trx_lines.line_type%type,
3076: p_account_set_flag IN
3077: ra_cust_trx_line_gl_dist.account_set_flag%type,

Line 3075: ra_customer_trx_lines.line_type%type,

3071: ra_customer_trx.customer_trx_id%type,
3072: p_link_to_cust_trx_line_id IN
3073: ra_customer_trx_lines.link_to_cust_trx_line_id%type,
3074: p_line_type IN
3075: ra_customer_trx_lines.line_type%type,
3076: p_account_set_flag IN
3077: ra_cust_trx_line_gl_dist.account_set_flag%type,
3078: p_account_class IN
3079: ra_cust_trx_line_gl_dist.account_class%type)

Line 3092: FROM ra_customer_trx_lines

3088: DELETE FROM ra_cust_trx_line_gl_dist
3089: WHERE customer_trx_id = p_customer_trx_id
3090: AND customer_trx_line_id in
3091: ( SELECT customer_trx_line_id
3092: FROM ra_customer_trx_lines
3093: WHERE customer_trx_id = p_customer_trx_id
3094: AND decode(p_link_to_cust_trx_line_id,
3095: null, -99,
3096: link_to_cust_trx_line_id) =

Line 3161: p_exchange_rate IN ra_customer_trx.exchange_rate%type

3157:
3158: PROCEDURE update_p( p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,
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

Line 3244: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,

3240: | |
3241: +===========================================================================*/
3242:
3243: PROCEDURE update_f_ct_id( p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,
3244: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
3245: p_account_set_flag
3246: IN ra_cust_trx_line_gl_dist.account_set_flag%type,
3247: p_account_class
3248: IN ra_cust_trx_line_gl_dist.account_class%type,

Line 3249: p_exchange_rate IN ra_customer_trx.exchange_rate%type

3245: p_account_set_flag
3246: IN ra_cust_trx_line_gl_dist.account_set_flag%type,
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

Line 3332: ra_customer_trx_lines.customer_trx_line_id%type,

3328: +===========================================================================*/
3329:
3330: PROCEDURE update_f_ctl_id( p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,
3331: p_customer_trx_line_id IN
3332: ra_customer_trx_lines.customer_trx_line_id%type,
3333: p_account_set_flag
3334: IN ra_cust_trx_line_gl_dist.account_set_flag%type,
3335: p_account_class
3336: IN ra_cust_trx_line_gl_dist.account_class%type,

Line 3337: p_exchange_rate IN ra_customer_trx.exchange_rate%type

3333: p_account_set_flag
3334: IN ra_cust_trx_line_gl_dist.account_set_flag%type,
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

Line 3425: p_exchange_rate IN ra_customer_trx.exchange_rate%type

3421: p_account_set_flag
3422: IN ra_cust_trx_line_gl_dist.account_set_flag%type,
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

Line 3510: ra_customer_trx.exchange_rate%type,

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
3513: default null,
3514: p_base_min_acc_unit IN

Line 3600: ra_customer_trx_lines.customer_trx_line_id%type,

3596: | |
3597: +===========================================================================*/
3598:
3599: PROCEDURE update_amount_f_ctl_id(p_customer_trx_line_id IN
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,

Line 3602: ra_customer_trx_lines.extended_amount%type,

3598:
3599: PROCEDURE update_amount_f_ctl_id(p_customer_trx_line_id IN
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,

Line 3608: ra_customer_trx.exchange_rate%type,

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
3611: default null,
3612: p_base_min_acc_unit IN

Line 3712: p_exchange_rate IN ra_customer_trx.exchange_rate%type

3708: PROCEDURE insert_p(
3709: p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,
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