DBA Data[Home] [Help]

APPS.ARP_DET_DIST_PKG dependencies on ARP_ACCT_MAIN

Line 159: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type);

155: PROCEDURE conv_acctd_amt
156: (p_pay_adj IN VARCHAR2,
157: p_adj_rec IN ar_adjustments%ROWTYPE,
158: p_app_rec IN ar_receivable_applications%ROWTYPE,
159: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type);
160:
161: PROCEDURE conv_acctd_amt_upg
162: (p_pay_adj IN VARCHAR2,
163: p_adj_rec IN ar_adjustments%ROWTYPE,

Line 165: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type);

161: PROCEDURE conv_acctd_amt_upg
162: (p_pay_adj IN VARCHAR2,
163: p_adj_rec IN ar_adjustments%ROWTYPE,
164: p_app_rec IN ar_receivable_applications%ROWTYPE,
165: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type);
166:
167: PROCEDURE update_taxable
168: (p_gt_id IN VARCHAR2,
169: p_customer_trx_id IN NUMBER,

Line 170: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type);

166:
167: PROCEDURE update_taxable
168: (p_gt_id IN VARCHAR2,
169: p_customer_trx_id IN NUMBER,
170: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type);
171:
172:
173: PROCEDURE convert_ra_inv_to_cm
174: ( p_inv_ra_rec IN ar_receivable_applications%ROWTYPE,

Line 650: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type);

646: +-----------------------------------------------------------------------*/
647: PROCEDURE update_line
648: (p_gt_id IN VARCHAR2,
649: p_customer_trx_id IN NUMBER,
650: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type);
651:
652: /*-------------------------------------------------------------------------+
653: | get_invoice_line_info |
654: +-------------------------------------------------------------------------+

Line 664: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type,

660: +-------------------------------------------------------------------------*/
661: PROCEDURE get_invoice_line_info
662: (p_gt_id IN VARCHAR2,
663: p_customer_trx_id IN NUMBER,
664: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type,
665: p_mode IN VARCHAR2);
666:
667: /*-------------------------------------------------------------------------+
668: | get_invoice_line_info_cm |

Line 679: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type,

675: +-------------------------------------------------------------------------*/
676: PROCEDURE get_invoice_line_info_cm
677: (p_gt_id IN VARCHAR2,
678: p_customer_trx_id IN NUMBER,
679: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type,
680: p_mode IN VARCHAR2);
681:
682:
683: /*-------------------------------------------------------------------------+

Line 703: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type);

699: p_source_data_key3 IN VARCHAR2,
700: p_source_data_key4 IN VARCHAR2,
701: p_source_data_key5 IN VARCHAR2,
702: --}
703: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type);
704:
705: /*-------------------------------------------------------------------------+
706: | get_invoice_line_info_per_line |
707: +-------------------------------------------------------------------------+

Line 719: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type);

715: (p_gt_id IN VARCHAR2,
716: p_customer_trx_id IN NUMBER,
717: p_customer_trx_line_id IN NUMBER,
718: p_log_inv_line IN VARCHAR2 DEFAULT 'N',
719: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type);
720:
721: /*-------------------------------------------------------------------------+
722: | prepare_trx_line_proration |
723: +-------------------------------------------------------------------------+

Line 744: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type);

740: p_customer_trx_id IN NUMBER,
741: p_pay_adj IN VARCHAR2,
742: p_adj_rec IN ar_adjustments%ROWTYPE,
743: p_app_rec IN ar_receivable_applications%ROWTYPE,
744: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type);
745:
746: /*-------------------------------------------------------------------------+
747: | prepare_group_for_proration |
748: +-------------------------------------------------------------------------+

Line 768: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type);

764: p_customer_trx_id IN NUMBER,
765: p_pay_adj IN VARCHAR2,
766: p_adj_rec IN ar_adjustments%ROWTYPE,
767: p_app_rec IN ar_receivable_applications%ROWTYPE,
768: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type);
769:
770: /*-------------------------------------------------------------------------+
771: | update_ctl_rem_orig |
772: +-------------------------------------------------------------------------+

Line 800: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type);

796: p_source_data_key4 IN VARCHAR2 DEFAULT NULL,
797: p_source_data_key5 IN VARCHAR2 DEFAULT NULL,
798: --}
799: p_log_inv_line IN VARCHAR2 DEFAULT 'N',
800: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type);
801:
802:
803: /*-------------------------------------------------------------------------+
804: | get_inv_dist |

Line 820: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type);

816: p_customer_trx_id IN NUMBER,
817: p_gt_id IN VARCHAR2,
818: p_adj_rec IN ar_adjustments%ROWTYPE,
819: p_app_rec IN ar_receivable_applications%ROWTYPE,
820: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type);
821:
822:
823: /*-------------------------------------------------------------------------+
824: | update_group_line |

Line 839: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type);

835: +-------------------------------------------------------------------------*/
836: PROCEDURE update_group_line
837: (p_gt_id IN VARCHAR2,
838: p_customer_trx_id IN NUMBER,
839: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type);
840:
841: /*-------------------------------------------------------------------------+
842: | create_split_distribution |
843: +-------------------------------------------------------------------------+

Line 859: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type);

855: (p_pay_adj IN VARCHAR2,
856: p_customer_trx_id IN NUMBER,
857: p_gt_id IN VARCHAR2,
858: p_app_level IN VARCHAR2,
859: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type);
860:
861: /*-------------------------------------------------------------------------+
862: | adjustment_detemination |
863: +-------------------------------------------------------------------------+

Line 877: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type,

873: PROCEDURE adjustment_detemination
874: (p_customer_trx_id IN NUMBER,
875: p_gt_id IN VARCHAR2,
876: p_pay_adj IN VARCHAR2,
877: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type,
878: p_adj_rec IN ar_adjustments%ROWTYPE);
879:
880: /*-------------------------------------------------------------------------+
881: | proration_app_dist_trx |

Line 898: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type);

894: (p_gt_id IN VARCHAR2,
895: p_app_level IN VARCHAR2,
896: p_customer_trx_id IN NUMBER,
897: p_app_rec IN ar_receivable_applications%ROWTYPE,
898: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type);
899:
900: PROCEDURE proration_adj_dist_trx
901: (p_gt_id IN VARCHAR2,
902: p_app_level IN VARCHAR2,

Line 905: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type);

901: (p_gt_id IN VARCHAR2,
902: p_app_level IN VARCHAR2,
903: p_customer_trx_id IN NUMBER,
904: p_adj_rec IN ar_adjustments%ROWTYPE,
905: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type);
906:
907:
908: -------------
909: -- Body of the package

Line 2912: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type)

2908:
2909: PROCEDURE update_line
2910: (p_gt_id IN VARCHAR2,
2911: p_customer_trx_id IN NUMBER,
2912: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type)
2913: IS
2914: CURSOR c_read_for_line IS
2915: SELECT /*+ leading(b) INDEX (b ra_ar_n1) INDEX( d RA_AR_AMOUNTS_GT_N1 )
2916: use_nl(D) */

Line 3338: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type,

3334:
3335: PROCEDURE get_invoice_line_info
3336: (p_gt_id IN VARCHAR2,
3337: p_customer_trx_id IN NUMBER,
3338: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type,
3339: p_mode IN VARCHAR2)
3340: IS
3341:
3342: l_rows NUMBER;

Line 3943: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type,

3939:
3940: PROCEDURE get_invoice_line_info_cm
3941: (p_gt_id IN VARCHAR2,
3942: p_customer_trx_id IN NUMBER,
3943: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type,
3944: p_mode IN VARCHAR2)
3945: IS
3946:
3947: l_rows NUMBER;

Line 4161: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type)

4157: p_customer_trx_id IN NUMBER,
4158: p_pay_adj IN VARCHAR2,
4159: p_adj_rec IN ar_adjustments%ROWTYPE,
4160: p_app_rec IN ar_receivable_applications%ROWTYPE,
4161: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type)
4162: IS
4163: l_rows NUMBER;
4164: BEGIN
4165: IF PG_DEBUG = 'Y' THEN

Line 4984: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type)

4980: PROCEDURE conv_acctd_amt
4981: (p_pay_adj IN VARCHAR2,
4982: p_adj_rec IN ar_adjustments%ROWTYPE,
4983: p_app_rec IN ar_receivable_applications%ROWTYPE,
4984: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type)
4985: IS
4986: l_acctd_amt NUMBER;
4987: BEGIN
4988: IF PG_DEBUG = 'Y' THEN

Line 5161: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type)

5157: PROCEDURE conv_acctd_amt_upg
5158: (p_pay_adj IN VARCHAR2,
5159: p_adj_rec IN ar_adjustments%ROWTYPE,
5160: p_app_rec IN ar_receivable_applications%ROWTYPE,
5161: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type)
5162: IS
5163: l_acctd_amt NUMBER;
5164: BEGIN
5165: g_acctd_line_adj := 0;

Line 5495: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type)

5491: p_customer_trx_id IN NUMBER,
5492: p_pay_adj IN VARCHAR2,
5493: p_adj_rec IN ar_adjustments%ROWTYPE,
5494: p_app_rec IN ar_receivable_applications%ROWTYPE,
5495: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type)
5496: IS
5497: BEGIN
5498: IF PG_DEBUG = 'Y' THEN
5499: localdebug('arp_det_dist_pkg.prepare_trx_line_proration()+');

Line 5950: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type)

5946: p_source_data_key4 IN VARCHAR2 DEFAULT NULL,
5947: p_source_data_key5 IN VARCHAR2 DEFAULT NULL,
5948: --}
5949: p_log_inv_line IN VARCHAR2 DEFAULT 'N',
5950: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type)
5951: IS
5952: BEGIN
5953: IF PG_DEBUG = 'Y' THEN
5954: localdebug('arp_det_dist_pkg.update_ctl_rem_orig()+');

Line 6679: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type)

6675: p_customer_trx_id IN NUMBER,
6676: p_gt_id IN VARCHAR2,
6677: p_adj_rec IN ar_adjustments%ROWTYPE,
6678: p_app_rec IN ar_receivable_applications%ROWTYPE,
6679: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type)
6680: IS
6681:
6682: l_rows NUMBER;
6683: BEGIN

Line 8564: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type)

8560:
8561: PROCEDURE update_dist
8562: (p_gt_id IN VARCHAR2,
8563: p_customer_trx_id IN NUMBER,
8564: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type)
8565: IS
8566: l_rows NUMBER;
8567:
8568: CURSOR c_read_for_line IS

Line 9004: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type)

9000: (p_pay_adj IN VARCHAR2,
9001: p_customer_trx_id IN NUMBER,
9002: p_gt_id IN VARCHAR2,
9003: p_app_level IN VARCHAR2,
9004: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type)
9005: IS
9006: l_amt NUMBER;
9007: l_ind VARCHAR2(10);
9008: l_org_id NUMBER;

Line 10831: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type,

10827: PROCEDURE adjustment_detemination
10828: (p_customer_trx_id IN NUMBER,
10829: p_gt_id IN VARCHAR2,
10830: p_pay_adj IN VARCHAR2,
10831: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type,
10832: p_adj_rec IN ar_adjustments%ROWTYPE)
10833: IS
10834: CURSOR get_sum_per_line_type IS
10835: SELECT /*+INDEX (RA_AR_GT ra_ar_n1)*/

Line 10899: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type,

10895: p_sum_line_rem_amt IN NUMBER,
10896: p_inv_currency IN VARCHAR2,
10897: p_customer_trx_id IN NUMBER,
10898: p_gt_id IN VARCHAR2,
10899: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type,
10900: P_exchange_rate IN ra_customer_trx.exchange_rate%type)
10901: IS
10902: l_ra_ar_gt ra_ar_gt%ROWTYPE;
10903: l_ar_base_dist_amts_gt ar_base_dist_amts_gt%ROWTYPE;

Line 11082: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type,

11078: p_sum_line_tax_rem_amt IN NUMBER,
11079: p_inv_currency IN VARCHAR2,
11080: p_customer_trx_id IN NUMBER,
11081: p_gt_id IN VARCHAR2,
11082: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type,
11083: P_exchange_rate IN ra_customer_trx.exchange_rate%type)
11084: IS
11085: l_ra_ar_gt ra_ar_gt%ROWTYPE;
11086: l_ar_base_dist_amts_gt ar_base_dist_amts_gt%ROWTYPE;

Line 11169: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type)

11165: p_sum_line_frt_rem_amt IN NUMBER,
11166: p_inv_currency IN VARCHAR2,
11167: p_customer_trx_id IN NUMBER,
11168: p_gt_id IN NUMBER,
11169: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type)
11170: IS
11171: l_ra_ar_gt ra_ar_gt%ROWTYPE;
11172: BEGIN
11173: IF NVL(p_adj_rec.freight_adjusted,0) <> 0 AND

Line 11384: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type)

11380:
11381: PROCEDURE update_group_line
11382: (p_gt_id IN VARCHAR2,
11383: p_customer_trx_id IN NUMBER,
11384: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type)
11385: IS
11386: CURSOR c_read_for_gline IS
11387: SELECT /*+ leading(B) INDEX(B ra_ar_n1) INDEX(D RA_AR_AMOUNTS_GT_N1)*/
11388: b.group_id groupe,

Line 11811: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type)

11807: p_source_data_key3 IN VARCHAR2,
11808: p_source_data_key4 IN VARCHAR2,
11809: p_source_data_key5 IN VARCHAR2,
11810: --}
11811: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type)
11812: IS
11813: l_rows NUMBER;
11814: BEGIN
11815: IF PG_DEBUG = 'Y' THEN

Line 12162: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type)

12158: (p_gt_id IN VARCHAR2,
12159: p_customer_trx_id IN NUMBER,
12160: p_customer_trx_line_id IN NUMBER,
12161: p_log_inv_line IN VARCHAR2 DEFAULT 'N',
12162: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type)
12163: IS
12164: l_rows NUMBER;
12165: BEGIN
12166: IF PG_DEBUG = 'Y' THEN

Line 12419: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type)

12415: (p_gt_id IN VARCHAR2,
12416: p_app_level IN VARCHAR2,
12417: p_customer_trx_id IN NUMBER,
12418: p_app_rec IN ar_receivable_applications%ROWTYPE,
12419: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type)
12420: IS
12421: l_adj_rec ar_adjustments%ROWTYPE;
12422: BEGIN
12423: IF PG_DEBUG = 'Y' THEN

Line 12464: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type)

12460: (p_gt_id IN VARCHAR2,
12461: p_app_level IN VARCHAR2,
12462: p_customer_trx_id IN NUMBER,
12463: p_adj_rec IN ar_adjustments%ROWTYPE,
12464: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type)
12465: IS
12466: l_app_rec ar_receivable_applications%ROWTYPE;
12467: BEGIN
12468: IF PG_DEBUG = 'Y' THEN

Line 12536: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type,

12532: +-------------------------------------------------------------------------*/
12533: PROCEDURE Trx_level_cash_apply
12534: (p_customer_trx IN ra_customer_trx%ROWTYPE,
12535: p_app_rec IN ar_receivable_applications%ROWTYPE,
12536: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type,
12537: p_gt_id IN VARCHAR2 DEFAULT NULL)
12538: IS
12539: l_adj_rec ar_adjustments%ROWTYPE;
12540: l_app_rec ar_receivable_applications%ROWTYPE;

Line 12720: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type,

12716: p_source_data_key4 IN VARCHAR2,
12717: p_source_data_key5 IN VARCHAR2,
12718: --}
12719: p_app_rec IN ar_receivable_applications%ROWTYPE,
12720: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type,
12721: p_gt_id IN VARCHAR2 DEFAULT NULL)
12722: IS
12723: l_adj_rec ar_adjustments%ROWTYPE;
12724: l_app_rec ar_receivable_applications%ROWTYPE;

Line 12927: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type,

12923: (p_customer_trx IN ra_customer_trx%ROWTYPE,
12924: p_customer_trx_line_id IN VARCHAR2,
12925: p_log_inv_line IN VARCHAR2 DEFAULT 'N',
12926: p_app_rec IN ar_receivable_applications%ROWTYPE,
12927: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type,
12928: p_gt_id IN VARCHAR2 DEFAULT NULL)
12929: IS
12930: l_adj_rec ar_adjustments%ROWTYPE;
12931: l_app_rec ar_receivable_applications%ROWTYPE;

Line 13105: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type,

13101: | Modified 02-Feb-2005 BR Enhancement
13102: +------------------------------------------------*/
13103: PROCEDURE copy_trx_lines
13104: (p_customer_trx_id IN NUMBER,
13105: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type,
13106: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%TYPE DEFAULT NULL)
13107: IS
13108: CURSOR cu_line_loaded (p_customer_trx_id IN NUMBER,
13109: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%TYPE ) IS

Line 13598: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type)

13594: PROCEDURE create_final_split
13595: (p_customer_trx IN ra_customer_trx%ROWTYPE,
13596: p_app_rec IN ar_receivable_applications%ROWTYPE,
13597: p_adj_rec IN ar_adjustments%ROWTYPE,
13598: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type)
13599: IS
13600: BEGIN
13601: IF PG_DEBUG = 'Y' THEN
13602: localdebug('arp_det_dist_pkg.create_final_split()+');

Line 13663: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type,

13659: +-------------------------------------------------------------------------*/
13660: PROCEDURE Trx_level_direct_adjust
13661: (p_customer_trx IN ra_customer_trx%ROWTYPE,
13662: p_adj_rec IN ar_adjustments%ROWTYPE,
13663: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type,
13664: p_gt_id IN NUMBER DEFAULT NULL)
13665: IS
13666: l_app_rec ar_receivable_applications%ROWTYPE;
13667: l_gt_id NUMBER;

Line 13822: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type,

13818: +-------------------------------------------------------------------------*/
13819: PROCEDURE Trx_level_direct_cash_apply
13820: (p_customer_trx IN ra_customer_trx%ROWTYPE,
13821: p_app_rec IN ar_receivable_applications%ROWTYPE,
13822: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type,
13823: p_gt_id IN NUMBER DEFAULT NULL,
13824: p_inv_cm IN VARCHAR2 DEFAULT 'I')
13825: IS
13826: l_adj_rec ar_adjustments%ROWTYPE;

Line 15248: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type,

15244: +----------------------------------------------------------------------*/
15245: PROCEDURE update_from_gt
15246: (p_from_amt IN NUMBER,
15247: p_from_acctd_amt IN NUMBER,
15248: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type,
15249: p_app_rec IN ar_receivable_applications%ROWTYPE,
15250: p_gt_id IN VARCHAR2 DEFAULT NULL,
15251: p_inv_currency IN VARCHAr2 DEFAULT NULL)
15252: IS

Line 15862: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type)

15858:
15859: PROCEDURE update_taxable
15860: (p_gt_id IN VARCHAR2,
15861: p_customer_trx_id IN NUMBER,
15862: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type)
15863: IS
15864: CURSOR c_read_for_taxable IS
15865: select
15866: GROUPE ,

Line 16399: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type)

16395: (p_gt_id IN VARCHAR2,
16396: p_customer_trx_id IN NUMBER,
16397: p_app_rec IN ar_receivable_applications%ROWTYPE,
16398: p_adj_rec IN ar_adjustments%ROWTYPE,
16399: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type)
16400: IS
16401: CURSOR c_mrc(p_acctd_adj_app_to IN NUMBER,
16402: p_acctd_app_from IN NUMBER,
16403: p_acctd_ed IN NUMBER,

Line 17165: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type,

17161: -- Modification, this is procedure will be called in downtime
17162: PROCEDURE prepare_for_ra
17163: ( p_gt_id IN NUMBER,
17164: p_app_rec IN ar_receivable_applications%ROWTYPE,
17165: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type,
17166: p_inv_cm IN VARCHAR2 DEFAULT 'I',
17167: p_cash_mfar IN VARCHAR2 DEFAULT 'CASH')
17168: IS
17169: CURSOR cu_trx(p_trx_id IN NUMBER) IS

Line 17647: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type,

17643:
17644: PROCEDURE online_lazy_apply
17645: (p_customer_trx IN ra_customer_trx%ROWTYPE,
17646: p_app_rec IN ar_receivable_applications%ROWTYPE,
17647: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type,
17648: p_gt_id IN NUMBER,
17649: --Add the p_inv_cm flag
17650: p_inv_cm IN VARCHAR2 DEFAULT 'I')
17651: IS

Line 18411: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type,

18407:
18408: PROCEDURE adjustment_with_interface
18409: (p_customer_trx IN ra_customer_trx%ROWTYPE,
18410: p_adj_rec IN ar_adjustments%ROWTYPE,
18411: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type,
18412: p_gt_id IN NUMBER,
18413: p_line_flag IN VARCHAR2 DEFAULT 'INTERFACE',
18414: p_tax_flag IN VARCHAR2 DEFAULT 'INTERFACE',
18415: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

Line 18562: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type,

18558:
18559: PROCEDURE application_with_interface
18560: (p_customer_trx IN ra_customer_trx%ROWTYPE,
18561: p_app_rec IN ar_receivable_applications%ROWTYPE,
18562: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type,
18563: p_gt_id IN NUMBER,
18564: p_line_flag IN VARCHAR2 DEFAULT 'INTERFACE',
18565: p_tax_flag IN VARCHAR2 DEFAULT 'INTERFACE',
18566: p_ed_line_flag IN VARCHAR2 DEFAULT 'NORMAL',