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 538: p_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,

534: p_old_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,
535: p_new_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,
536: p_header_gl_date IN date,
537: p_trx_date IN date,
538: p_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,
539: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
540: p_currency_code IN fnd_currencies.currency_code%type,
541: p_precision IN fnd_currencies.precision%type,
542: p_mau IN

Line 539: p_exchange_rate IN ra_customer_trx.exchange_rate%type,

535: p_new_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,
536: p_header_gl_date IN date,
537: p_trx_date IN date,
538: p_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,
539: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
540: p_currency_code IN fnd_currencies.currency_code%type,
541: p_precision IN fnd_currencies.precision%type,
542: p_mau IN
543: fnd_currencies.minimum_accountable_unit%type

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

910: PROCEDURE insert_dist(
911: p_form_name IN varchar2,
912: p_form_version IN number,
913: p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,
914: p_exchange_rate IN ra_customer_trx.exchange_rate%type DEFAULT 1,
915: p_currency_code IN fnd_currencies.currency_code%type DEFAULT null,
916: p_precision IN fnd_currencies.precision%type DEFAULT null,
917: p_mau IN fnd_currencies.minimum_accountable_unit%type
918: DEFAULT null,

Line 1064: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,

1060: p_form_version IN number,
1061: p_backout_flag IN boolean,
1062: p_cust_trx_line_gl_dist_id IN
1063: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type,
1064: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
1065: p_dist_rec IN OUT NOCOPY ra_cust_trx_line_gl_dist%rowtype,
1066: p_header_gl_date IN date,
1067: p_trx_date IN date,
1068: p_invoicing_rule_id IN

Line 1069: ra_customer_trx.invoicing_rule_id%type,

1065: p_dist_rec IN OUT NOCOPY ra_cust_trx_line_gl_dist%rowtype,
1066: p_header_gl_date IN date,
1067: p_trx_date IN date,
1068: p_invoicing_rule_id IN
1069: ra_customer_trx.invoicing_rule_id%type,
1070: p_backout_done_flag OUT NOCOPY boolean,
1071: p_exchange_rate IN ra_customer_trx.exchange_rate%type
1072: DEFAULT 1,
1073: p_currency_code IN fnd_currencies.currency_code%type

Line 1071: p_exchange_rate IN ra_customer_trx.exchange_rate%type

1067: p_trx_date IN date,
1068: p_invoicing_rule_id IN
1069: ra_customer_trx.invoicing_rule_id%type,
1070: p_backout_done_flag OUT NOCOPY boolean,
1071: p_exchange_rate IN ra_customer_trx.exchange_rate%type
1072: DEFAULT 1,
1073: p_currency_code IN fnd_currencies.currency_code%type
1074: DEFAULT null,
1075: p_precision IN fnd_currencies.precision%type

Line 1261: ra_customer_trx ct

1257: l_open_rec,
1258: l_ctt_type,
1259: l_previous_customer_trx_id
1260: FROM ra_cust_trx_types ctt,
1261: ra_customer_trx ct
1262: WHERE ct.customer_trx_id = p_customer_trx_id
1263: AND ct.cust_trx_type_id = ctt.cust_trx_type_id;
1264: EXCEPTION
1265: WHEN OTHERS THEN

Line 1475: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,

1471: p_form_name IN varchar2,
1472: p_form_version IN number,
1473: p_cust_trx_line_gl_dist_id IN
1474: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type,
1475: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
1476: p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype)
1477: IS
1478:
1479: