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 534: p_old_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,

530: +===========================================================================*/
531:
532:
533: PROCEDURE backout_amount(
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,

Line 535: p_new_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,

531:
532:
533: PROCEDURE backout_amount(
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,

Line 548: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type;

544: ) IS
545:
546:
547: l_cust_trx_line_gl_dist_id
548: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type;
549:
550: l_old_dist_rec ra_cust_trx_line_gl_dist%rowtype;
551: l_new_dist_rec ra_cust_trx_line_gl_dist%rowtype;
552:

Line 550: l_old_dist_rec ra_cust_trx_line_gl_dist%rowtype;

546:
547: l_cust_trx_line_gl_dist_id
548: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type;
549:
550: l_old_dist_rec ra_cust_trx_line_gl_dist%rowtype;
551: l_new_dist_rec ra_cust_trx_line_gl_dist%rowtype;
552:
553: l_default_gl_date date;
554:

Line 551: l_new_dist_rec ra_cust_trx_line_gl_dist%rowtype;

547: l_cust_trx_line_gl_dist_id
548: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type;
549:
550: l_old_dist_rec ra_cust_trx_line_gl_dist%rowtype;
551: l_new_dist_rec ra_cust_trx_line_gl_dist%rowtype;
552:
553: l_default_gl_date date;
554:
555: BEGIN

Line 677: p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype ) IS

673: +===========================================================================*/
674:
675:
676: PROCEDURE val_tax_from_revenue (
677: p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype ) IS
678:
679: BEGIN
680:
681: IF PG_DEBUG in ('Y', 'C') THEN

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

734: | |
735: +===========================================================================*/
736:
737:
738: PROCEDURE val_insert_dist ( p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype ) IS
739:
740:
741: BEGIN
742:

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

787: | 19-JUL-95 Charlie Tomberg Created |
788: | |
789: +===========================================================================*/
790:
791: PROCEDURE val_update_dist ( p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype )
792: IS
793:
794:
795: BEGIN

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

842: | 19-JUL-95 Charlie Tomberg Created |
843: | |
844: +===========================================================================*/
845:
846: PROCEDURE val_delete_dist ( p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype ) IS
847:
848:
849: BEGIN
850:

Line 879: | Inserts a record into ra_cust_trx_line_gl_dist |

875: | PROCEDURE |
876: | insert_dist |
877: | |
878: | DESCRIPTION |
879: | Inserts a record into ra_cust_trx_line_gl_dist |
880: | |
881: | SCOPE - PUBLIC |
882: | |
883: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |

Line 913: p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,

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

Line 920: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type)

916: p_precision IN fnd_currencies.precision%type DEFAULT null,
917: p_mau IN fnd_currencies.minimum_accountable_unit%type
918: DEFAULT null,
919: p_cust_trx_line_gl_dist_id OUT NOCOPY
920: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type)
921: IS
922:
923:
924: l_cust_trx_line_gl_dist_id

Line 925: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type;

921: IS
922:
923:
924: l_cust_trx_line_gl_dist_id
925: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type;
926:
927: --bug#2750340
928: l_ev_rec arp_xla_events.xla_events_type;
929: BEGIN

Line 1019: | Updates a record in ra_cust_trx_line_gl_dist |

1015: | PROCEDURE |
1016: | update_dist |
1017: | |
1018: | DESCRIPTION |
1019: | Updates a record in ra_cust_trx_line_gl_dist |
1020: | |
1021: | SCOPE - PUBLIC |
1022: | |
1023: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |

Line 1063: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type,

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

Line 1065: p_dist_rec IN OUT NOCOPY ra_cust_trx_line_gl_dist%rowtype,

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

Line 1084: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type;

1080: IS
1081:
1082:
1083: l_cust_trx_line_gl_dist_id
1084: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type;
1085:
1086: l_old_dist_rec ra_cust_trx_line_gl_dist%rowtype;
1087:
1088: l_backout_flag boolean;

Line 1086: l_old_dist_rec ra_cust_trx_line_gl_dist%rowtype;

1082:
1083: l_cust_trx_line_gl_dist_id
1084: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type;
1085:
1086: l_old_dist_rec ra_cust_trx_line_gl_dist%rowtype;
1087:
1088: l_backout_flag boolean;
1089: l_posted_flag boolean;
1090: l_ccid_changed_flag boolean;

Line 1313: | Insert 2 rows into ra_cust_trx_line_gl_dist |

1309: IF ( l_ccid_changed_flag = TRUE )
1310: THEN
1311:
1312: /*------------------------------------------------+
1313: | Insert 2 rows into ra_cust_trx_line_gl_dist |
1314: | 1. amount = -, |
1315: | ccid = |
1316: | 2. amount = , |
1317: | ccid = |

Line 1442: | Deletes a record fromra_cust_trx_line_gl_dist. |

1438: | PROCEDURE |
1439: | delete_dist |
1440: | |
1441: | DESCRIPTION |
1442: | Deletes a record fromra_cust_trx_line_gl_dist. |
1443: | |
1444: | SCOPE - PUBLIC |
1445: | |
1446: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |

Line 1474: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type,

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

Line 1476: p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype)

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