DBA Data[Home] [Help]

APPS.ARP_PROCESS_DIST dependencies on RA_CUSTOMER_TRX

Line 167: ra_customer_trx.invoicing_rule_id%type,

163: PROCEDURE validate_and_default_gl_date(
164: p_gl_date IN date,
165: p_trx_date IN date,
166: p_invoicing_rule_id IN
167: ra_customer_trx.invoicing_rule_id%type,
168: p_default_gl_date IN OUT NOCOPY date)
169: IS
170:
171: l_result boolean;

Line 311: p_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,

307: p_old_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,
308: p_new_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,
309: p_header_gl_date IN date,
310: p_trx_date IN date,
311: p_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,
312: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
313: p_currency_code IN fnd_currencies.currency_code%type,
314: p_precision IN fnd_currencies.precision%type,
315: p_mau IN

Line 312: p_exchange_rate IN ra_customer_trx.exchange_rate%type,

308: p_new_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,
309: p_header_gl_date IN date,
310: p_trx_date IN date,
311: p_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,
312: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
313: p_currency_code IN fnd_currencies.currency_code%type,
314: p_precision IN fnd_currencies.precision%type,
315: p_mau IN
316: fnd_currencies.minimum_accountable_unit%type

Line 502: p_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,

498: p_old_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,
499: p_new_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,
500: p_header_gl_date IN date,
501: p_trx_date IN date,
502: p_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,
503: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
504: p_currency_code IN fnd_currencies.currency_code%type,
505: p_precision IN fnd_currencies.precision%type,
506: p_mau IN

Line 503: p_exchange_rate IN ra_customer_trx.exchange_rate%type,

499: p_new_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,
500: p_header_gl_date IN date,
501: p_trx_date IN date,
502: p_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,
503: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
504: p_currency_code IN fnd_currencies.currency_code%type,
505: p_precision IN fnd_currencies.precision%type,
506: p_mau IN
507: fnd_currencies.minimum_accountable_unit%type

Line 878: p_exchange_rate IN ra_customer_trx.exchange_rate%type DEFAULT 1,

874: PROCEDURE insert_dist(
875: p_form_name IN varchar2,
876: p_form_version IN number,
877: p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,
878: p_exchange_rate IN ra_customer_trx.exchange_rate%type DEFAULT 1,
879: p_currency_code IN fnd_currencies.currency_code%type DEFAULT null,
880: p_precision IN fnd_currencies.precision%type DEFAULT null,
881: p_mau IN fnd_currencies.minimum_accountable_unit%type
882: DEFAULT null,

Line 1028: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,

1024: p_form_version IN number,
1025: p_backout_flag IN boolean,
1026: p_cust_trx_line_gl_dist_id IN
1027: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type,
1028: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
1029: p_dist_rec IN OUT NOCOPY ra_cust_trx_line_gl_dist%rowtype,
1030: p_header_gl_date IN date,
1031: p_trx_date IN date,
1032: p_invoicing_rule_id IN

Line 1033: ra_customer_trx.invoicing_rule_id%type,

1029: p_dist_rec IN OUT NOCOPY ra_cust_trx_line_gl_dist%rowtype,
1030: p_header_gl_date IN date,
1031: p_trx_date IN date,
1032: p_invoicing_rule_id IN
1033: ra_customer_trx.invoicing_rule_id%type,
1034: p_backout_done_flag OUT NOCOPY boolean,
1035: p_exchange_rate IN ra_customer_trx.exchange_rate%type
1036: DEFAULT 1,
1037: p_currency_code IN fnd_currencies.currency_code%type

Line 1035: p_exchange_rate IN ra_customer_trx.exchange_rate%type

1031: p_trx_date IN date,
1032: p_invoicing_rule_id IN
1033: ra_customer_trx.invoicing_rule_id%type,
1034: p_backout_done_flag OUT NOCOPY boolean,
1035: p_exchange_rate IN ra_customer_trx.exchange_rate%type
1036: DEFAULT 1,
1037: p_currency_code IN fnd_currencies.currency_code%type
1038: DEFAULT null,
1039: p_precision IN fnd_currencies.precision%type

Line 1176: ra_customer_trx ct

1172: l_open_rec,
1173: l_ctt_type,
1174: l_previous_customer_trx_id
1175: FROM ra_cust_trx_types ctt,
1176: ra_customer_trx ct
1177: WHERE ct.customer_trx_id = p_customer_trx_id
1178: AND ct.cust_trx_type_id = ctt.cust_trx_type_id;
1179: EXCEPTION
1180: WHEN OTHERS THEN

Line 1390: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,

1386: p_form_name IN varchar2,
1387: p_form_version IN number,
1388: p_cust_trx_line_gl_dist_id IN
1389: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type,
1390: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
1391: p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype)
1392: IS
1393:
1394: