DBA Data[Home] [Help]

APPS.ARP_PROCESS_DIST dependencies on RA_CUST_TRX_LINE_GL_DIST

Line 43: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type,

39: | |
40: +===========================================================================*/
41:
42: PROCEDURE set_flags(p_cust_trx_line_gl_dist_id IN
43: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type,
44: p_new_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,
45: p_posted_flag OUT NOCOPY boolean,
46: p_ccid_changed_flag OUT NOCOPY boolean,
47: p_amount_percent_changed_flag OUT NOCOPY boolean) IS

Line 44: p_new_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,

40: +===========================================================================*/
41:
42: PROCEDURE set_flags(p_cust_trx_line_gl_dist_id IN
43: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type,
44: p_new_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,
45: p_posted_flag OUT NOCOPY boolean,
46: p_ccid_changed_flag OUT NOCOPY boolean,
47: p_amount_percent_changed_flag OUT NOCOPY boolean) IS
48:

Line 49: l_old_dist_rec ra_cust_trx_line_gl_dist%rowtype;

45: p_posted_flag OUT NOCOPY boolean,
46: p_ccid_changed_flag OUT NOCOPY boolean,
47: p_amount_percent_changed_flag OUT NOCOPY boolean) IS
48:
49: l_old_dist_rec ra_cust_trx_line_gl_dist%rowtype;
50: l_posted_flag boolean;
51: l_ccid_changed_flag boolean;
52: l_amount_percent_changed_flag boolean;
53:

Line 307: p_old_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,

303: | |
304: +===========================================================================*/
305:
306: PROCEDURE backout_ccid(
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,

Line 308: p_new_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,

304: +===========================================================================*/
305:
306: PROCEDURE backout_ccid(
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,

Line 320: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type;

316: fnd_currencies.minimum_accountable_unit%type
317: ) IS
318:
319: l_cust_trx_line_gl_dist_id
320: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type;
321:
322: l_old_dist_rec ra_cust_trx_line_gl_dist%rowtype;
323: l_new_dist_rec ra_cust_trx_line_gl_dist%rowtype;
324:

Line 322: l_old_dist_rec ra_cust_trx_line_gl_dist%rowtype;

318:
319: l_cust_trx_line_gl_dist_id
320: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type;
321:
322: l_old_dist_rec ra_cust_trx_line_gl_dist%rowtype;
323: l_new_dist_rec ra_cust_trx_line_gl_dist%rowtype;
324:
325: /* Bug 3598021 - 3630436 */
326: l_orig_dist_rec ra_cust_trx_line_gl_dist%rowtype;

Line 323: l_new_dist_rec ra_cust_trx_line_gl_dist%rowtype;

319: l_cust_trx_line_gl_dist_id
320: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type;
321:
322: l_old_dist_rec ra_cust_trx_line_gl_dist%rowtype;
323: l_new_dist_rec ra_cust_trx_line_gl_dist%rowtype;
324:
325: /* Bug 3598021 - 3630436 */
326: l_orig_dist_rec ra_cust_trx_line_gl_dist%rowtype;
327:

Line 326: l_orig_dist_rec ra_cust_trx_line_gl_dist%rowtype;

322: l_old_dist_rec ra_cust_trx_line_gl_dist%rowtype;
323: l_new_dist_rec ra_cust_trx_line_gl_dist%rowtype;
324:
325: /* Bug 3598021 - 3630436 */
326: l_orig_dist_rec ra_cust_trx_line_gl_dist%rowtype;
327:
328: l_default_gl_date date;
329:
330: BEGIN

Line 498: p_old_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,

494: +===========================================================================*/
495:
496:
497: PROCEDURE backout_amount(
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,

Line 499: p_new_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,

495:
496:
497: PROCEDURE backout_amount(
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,

Line 512: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type;

508: ) IS
509:
510:
511: l_cust_trx_line_gl_dist_id
512: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type;
513:
514: l_old_dist_rec ra_cust_trx_line_gl_dist%rowtype;
515: l_new_dist_rec ra_cust_trx_line_gl_dist%rowtype;
516:

Line 514: l_old_dist_rec ra_cust_trx_line_gl_dist%rowtype;

510:
511: l_cust_trx_line_gl_dist_id
512: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type;
513:
514: l_old_dist_rec ra_cust_trx_line_gl_dist%rowtype;
515: l_new_dist_rec ra_cust_trx_line_gl_dist%rowtype;
516:
517: l_default_gl_date date;
518:

Line 515: l_new_dist_rec ra_cust_trx_line_gl_dist%rowtype;

511: l_cust_trx_line_gl_dist_id
512: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type;
513:
514: l_old_dist_rec ra_cust_trx_line_gl_dist%rowtype;
515: l_new_dist_rec ra_cust_trx_line_gl_dist%rowtype;
516:
517: l_default_gl_date date;
518:
519: BEGIN

Line 641: p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype ) IS

637: +===========================================================================*/
638:
639:
640: PROCEDURE val_tax_from_revenue (
641: p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype ) IS
642:
643: BEGIN
644:
645: IF PG_DEBUG in ('Y', 'C') THEN

Line 702: PROCEDURE val_insert_dist ( p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype ) IS

698: | |
699: +===========================================================================*/
700:
701:
702: PROCEDURE val_insert_dist ( p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype ) IS
703:
704:
705: BEGIN
706:

Line 755: PROCEDURE val_update_dist ( p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype )

751: | 19-JUL-95 Charlie Tomberg Created |
752: | |
753: +===========================================================================*/
754:
755: PROCEDURE val_update_dist ( p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype )
756: IS
757:
758:
759: BEGIN

Line 810: PROCEDURE val_delete_dist ( p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype ) IS

806: | 19-JUL-95 Charlie Tomberg Created |
807: | |
808: +===========================================================================*/
809:
810: PROCEDURE val_delete_dist ( p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype ) IS
811:
812:
813: BEGIN
814:

Line 843: | Inserts a record into ra_cust_trx_line_gl_dist |

839: | PROCEDURE |
840: | insert_dist |
841: | |
842: | DESCRIPTION |
843: | Inserts a record into ra_cust_trx_line_gl_dist |
844: | |
845: | SCOPE - PUBLIC |
846: | |
847: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |

Line 877: p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,

873:
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

Line 884: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type)

880: p_precision IN fnd_currencies.precision%type DEFAULT null,
881: p_mau IN fnd_currencies.minimum_accountable_unit%type
882: DEFAULT null,
883: p_cust_trx_line_gl_dist_id OUT NOCOPY
884: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type)
885: IS
886:
887:
888: l_cust_trx_line_gl_dist_id

Line 889: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type;

885: IS
886:
887:
888: l_cust_trx_line_gl_dist_id
889: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type;
890:
891: --bug#2750340
892: l_ev_rec arp_xla_events.xla_events_type;
893: BEGIN

Line 983: | Updates a record in ra_cust_trx_line_gl_dist |

979: | PROCEDURE |
980: | update_dist |
981: | |
982: | DESCRIPTION |
983: | Updates a record in ra_cust_trx_line_gl_dist |
984: | |
985: | SCOPE - PUBLIC |
986: | |
987: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |

Line 1027: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type,

1023: p_form_name IN varchar2,
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,

Line 1029: p_dist_rec IN OUT NOCOPY ra_cust_trx_line_gl_dist%rowtype,

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
1033: ra_customer_trx.invoicing_rule_id%type,

Line 1048: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type;

1044: IS
1045:
1046:
1047: l_cust_trx_line_gl_dist_id
1048: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type;
1049:
1050: l_old_dist_rec ra_cust_trx_line_gl_dist%rowtype;
1051:
1052: l_backout_flag boolean;

Line 1050: l_old_dist_rec ra_cust_trx_line_gl_dist%rowtype;

1046:
1047: l_cust_trx_line_gl_dist_id
1048: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type;
1049:
1050: l_old_dist_rec ra_cust_trx_line_gl_dist%rowtype;
1051:
1052: l_backout_flag boolean;
1053: l_posted_flag boolean;
1054: l_ccid_changed_flag boolean;

Line 1228: | Insert 2 rows into ra_cust_trx_line_gl_dist |

1224: IF ( l_ccid_changed_flag = TRUE )
1225: THEN
1226:
1227: /*------------------------------------------------+
1228: | Insert 2 rows into ra_cust_trx_line_gl_dist |
1229: | 1. amount = -, |
1230: | ccid = |
1231: | 2. amount = , |
1232: | ccid = |

Line 1357: | Deletes a record fromra_cust_trx_line_gl_dist. |

1353: | PROCEDURE |
1354: | delete_dist |
1355: | |
1356: | DESCRIPTION |
1357: | Deletes a record fromra_cust_trx_line_gl_dist. |
1358: | |
1359: | SCOPE - PUBLIC |
1360: | |
1361: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |

Line 1389: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type,

1385: PROCEDURE delete_dist(
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:

Line 1391: p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype)

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:
1395: BEGIN