eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ARP_DET_DIST_PKG dependencies on AR_ADJUSTMENTS

Line 157: p_adj_rec IN ar_adjustments%ROWTYPE,

153:
154:
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

Line 163: p_adj_rec IN ar_adjustments%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,
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

Line 504: -- application on a 11i Mfar transaction with Mfar adjustments

500: (p_app_id IN NUMBER)
501: IS
502: BEGIN
503: --
504: -- application on a 11i Mfar transaction with Mfar adjustments
505: --
506: IF g_mode_process = 'R12_11IMFAR' THEN
507:
508: UPDATE ar_receivable_applications

Line 556: UPDATE ar_adjustments

552: -- Note this process is needed when application is getting posted
553: -- R12 -- At the end of nornal process
554: IF g_mode_process IN ('R12','R12_NLB','R12_11ICASH','R12_11IMFAR') THEN
555:
556: UPDATE ar_adjustments
557: SET upgrade_method = 'R12'
558: WHERE adjustment_id = p_adj_id;
559:
560: ELSIF g_mode_process IN ('R12_MERGE') THEN

Line 561: UPDATE ar_adjustments

557: SET upgrade_method = 'R12'
558: WHERE adjustment_id = p_adj_id;
559:
560: ELSIF g_mode_process IN ('R12_MERGE') THEN
561: UPDATE ar_adjustments
562: SET upgrade_method = 'R12_MERGE'
563: WHERE adjustment_id = p_adj_id;
564: END IF;
565: END;

Line 742: p_adj_rec IN ar_adjustments%ROWTYPE,

738: PROCEDURE prepare_trx_line_proration
739: (p_gt_id IN VARCHAR2,
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: /*-------------------------------------------------------------------------+

Line 766: p_adj_rec IN ar_adjustments%ROWTYPE,

762: PROCEDURE prepare_group_for_proration
763: (p_gt_id IN VARCHAR2,
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: /*-------------------------------------------------------------------------+

Line 818: p_adj_rec IN ar_adjustments%ROWTYPE,

814: PROCEDURE get_inv_dist
815: (p_pay_adj IN VARCHAR2,
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:

Line 878: p_adj_rec IN ar_adjustments%ROWTYPE);

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 |
882: +-------------------------------------------------------------------------+

Line 904: p_adj_rec IN ar_adjustments%ROWTYPE,

900: PROCEDURE proration_adj_dist_trx
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: -------------

Line 4159: p_adj_rec IN ar_adjustments%ROWTYPE,

4155: PROCEDURE prepare_group_for_proration
4156: (p_gt_id IN VARCHAR2,
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;

Line 4982: p_adj_rec IN ar_adjustments%ROWTYPE,

4978: END;
4979:
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;

Line 5159: p_adj_rec IN ar_adjustments%ROWTYPE,

5155: -- org context so that it is usable in Down time upgrade
5156: --
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;

Line 5493: p_adj_rec IN ar_adjustments%ROWTYPE,

5489: PROCEDURE prepare_trx_line_proration
5490: (p_gt_id IN VARCHAR2,
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

Line 6677: p_adj_rec IN ar_adjustments%ROWTYPE,

6673: PROCEDURE get_inv_dist
6674: (p_pay_adj IN VARCHAR2,
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:

Line 7581: ar_adjustments adj

7577: 'REV','Y', -- BUG 7597090
7578: 'N') -- tax_inc_flag
7579: FROM ra_ar_gt rar,
7580: ar_distributions rrc,
7581: ar_adjustments adj
7582: WHERE rar.gt_id = p_gt_id
7583: AND rar.ref_customer_trx_id = p_customer_trx_id
7584: AND rar.gp_level = 'L'
7585: AND adj.customer_trx_id = p_customer_trx_id

Line 8217: ar_adjustments adj,

8213: FROM ra_ar_gt
8214: WHERE gt_id = p_gt_id
8215: AND ref_customer_trx_id = p_customer_trx_id
8216: AND gp_level = 'L') g,
8217: ar_adjustments adj,
8218: ra_customer_trx trx
8219: --{Line Charge and Freight boundary
8220: -- Insert freight dist or the charge dist only in the no CHARGES or FREIGHT line exist
8221: -- As by default the boundary on those 2 lines exist only if there are no REV line on the invoice

Line 8449: ar_adjustments adj

8445: FROM ra_ar_gt rar,
8446: psa_mf_adj_dist_all rrc,
8447: ra_cust_trx_line_gl_dist ctlgd,
8448: ra_customer_trx_lines ctl,
8449: ar_adjustments adj
8450: WHERE rar.gt_id = p_gt_id
8451: AND rar.ref_customer_trx_id = p_customer_trx_id
8452: AND rar.gp_level = 'L'
8453: AND rar.ref_customer_trx_line_id = ctl.customer_trx_line_id

Line 9847: FROM ar_adjustments ad

9843: FROM ar_receivable_applications ar
9844: WHERE ar.applied_customer_trx_id = inv.customer_trx_id
9845: UNION
9846: SELECT 1
9847: FROM ar_adjustments ad
9848: WHERE ad.customer_trx_id = inv.customer_trx_id
9849: );
9850:
9851:

Line 10832: p_adj_rec IN ar_adjustments%ROWTYPE)

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)*/
10836: MAX(sum_line_rem_amt),

Line 10893: (p_adj_rec IN ar_adjustments%ROWTYPE,

10889: l_line_boundary_done VARCHAR2(1) := 'N';
10890: l_tax_boundary_done VARCHAR2(1) := 'N';
10891: l_chrg_boundary_done VARCHAR2(1) := 'N';
10892: PROCEDURE line_boundary
10893: (p_adj_rec IN ar_adjustments%ROWTYPE,
10894: p_sum_line_orig_amt IN NUMBER,
10895: p_sum_line_rem_amt IN NUMBER,
10896: p_inv_currency IN VARCHAR2,
10897: p_customer_trx_id IN NUMBER,

Line 11076: (p_adj_rec IN ar_adjustments%ROWTYPE,

11072: END IF;
11073: END line_boundary;
11074:
11075: PROCEDURE tax_boundary
11076: (p_adj_rec IN ar_adjustments%ROWTYPE,
11077: p_sum_line_tax_orig_amt IN NUMBER,
11078: p_sum_line_tax_rem_amt IN NUMBER,
11079: p_inv_currency IN VARCHAR2,
11080: p_customer_trx_id IN NUMBER,

Line 11163: (p_adj_rec IN ar_adjustments%ROWTYPE,

11159: is over revenue line and not freight lines
11160: Keep this procedure for future
11161:
11162: PROCEDURE freight_boundary
11163: (p_adj_rec IN ar_adjustments%ROWTYPE,
11164: p_sum_line_frt_orig_amt IN NUMBER,
11165: p_sum_line_frt_rem_amt IN NUMBER,
11166: p_inv_currency IN VARCHAR2,
11167: p_customer_trx_id IN NUMBER,

Line 12421: l_adj_rec ar_adjustments%ROWTYPE;

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
12424: localdebug('arp_det_dist_pkg.proration_app_dist_trx()+');
12425: localdebug(' p_gt_id :'||p_gt_id );

Line 12463: p_adj_rec IN ar_adjustments%ROWTYPE,

12459: PROCEDURE proration_adj_dist_trx
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

Line 12539: l_adj_rec ar_adjustments%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;
12541: l_gt_id VARCHAR2(30);
12542: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
12543: l_msg_data VARCHAR2(2000);

Line 12723: l_adj_rec ar_adjustments%ROWTYPE;

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;
12725: l_gt_id VARCHAR2(30);
12726: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
12727: l_msg_data VARCHAR2(2000);

Line 12930: l_adj_rec ar_adjustments%ROWTYPE;

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;
12932: l_gt_id VARCHAR2(30);
12933: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
12934: l_msg_data VARCHAR2(2000);

Line 13239: FROM ar_adjustments adj,

13235: (SELECT SUM( NVL(ard.amount_cr,0) - NVL(ard.amount_dr,0) ) amt,
13236: SUM( NVL(ard.acctd_amount_cr,0) - NVL(ard.acctd_amount_dr,0)) acctd_amt,
13237: ard.ref_customer_trx_line_id,
13238: ard.activity_bucket
13239: FROM ar_adjustments adj,
13240: ar_distributions ard,
13241: ra_customer_trx_lines ctl
13242: WHERE ctl.customer_trx_id = p_customer_trx_id
13243: AND ctl.line_type = 'LINE'

Line 13597: p_adj_rec IN ar_adjustments%ROWTYPE,

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

Line 13662: p_adj_rec IN ar_adjustments%ROWTYPE,

13658: | p_ae_sys_rec ar system parameter
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;

Line 13777: UPDATE ar_adjustments

13773: p_adj_rec => p_adj_rec,
13774: p_ae_sys_rec => p_ae_sys_rec);
13775:
13776: IF g_mode_process IN ('R12_MERGE') THEN
13777: UPDATE ar_adjustments
13778: SET upgrade_method = 'R12_MERGE'
13779: WHERE adjustment_id = p_adj_rec.adjustment_id;
13780: ELSE
13781: UPDATE ar_adjustments

Line 13781: UPDATE ar_adjustments

13777: UPDATE ar_adjustments
13778: SET upgrade_method = 'R12_MERGE'
13779: WHERE adjustment_id = p_adj_rec.adjustment_id;
13780: ELSE
13781: UPDATE ar_adjustments
13782: SET upgrade_method = 'R12'
13783: WHERE adjustment_id = p_adj_rec.adjustment_id;
13784: END IF;
13785:

Line 13826: l_adj_rec ar_adjustments%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;
13827: l_app_rec ar_receivable_applications%ROWTYPE;
13828: l_gt_id NUMBER;
13829: l_out_res VARCHAR2(1);
13830: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

Line 13874: from ar_adjustments adj

13870: IF g_mode_process IN ('R12_11ICASH') THEN
13871: Begin
13872: select 'Y'
13873: into l_adj_exists
13874: from ar_adjustments adj
13875: where customer_trx_id = p_customer_trx.customer_trx_id
13876: and nvl(upgrade_method,'11I') <> 'R12' -- non R12 adjustments
13877: and exists (select 'x' -- non detailed distributions
13878: from ar_distributions

Line 14575: FUNCTION tax_adj_type(p_adj_rec IN ar_adjustments%rowtype,

14571: | the buckets Rev is <> 0 |
14572: +------------------------------------------------------+
14573: | Created 26-OCT-03 Herve Yu |
14574: +------------------------------------------------------*/
14575: FUNCTION tax_adj_type(p_adj_rec IN ar_adjustments%rowtype,
14576: p_ae_rule_rec IN ae_rule_rec_type,
14577: p_amt_rem IN g_amt_rem_type,
14578: p_app_rec IN ar_receivable_applications%rowtype,
14579: p_source_exec IN VARCHAR2)

Line 14690: FUNCTION line_adj_type(p_adj_rec IN ar_adjustments%rowtype,

14686: | the buckets Rev is <> 0 |
14687: +------------------------------------------------------+
14688: | Created 26-OCT-03 Herve Yu |
14689: +------------------------------------------------------*/
14690: FUNCTION line_adj_type(p_adj_rec IN ar_adjustments%rowtype,
14691: p_ae_rule_rec IN ae_rule_rec_type,
14692: p_amt_rem IN g_amt_rem_type,
14693: p_app_rec IN ar_receivable_applications%rowtype,
14694: p_source_exec IN VARCHAR2)

Line 14774: FUNCTION frt_adj_type(p_adj_rec IN ar_adjustments%rowtype,

14770: | the buckets Rev and Freight at header are <> 0 |
14771: +------------------------------------------------------+
14772: | Created 26-OCT-03 Herve Yu |
14773: +------------------------------------------------------*/
14774: FUNCTION frt_adj_type(p_adj_rec IN ar_adjustments%rowtype,
14775: p_ae_rule_rec IN ae_rule_rec_type,
14776: p_amt_rem IN g_amt_rem_type,
14777: p_app_rec IN ar_receivable_applications%rowtype,
14778: p_source_exec IN VARCHAR2)

Line 14871: FUNCTION chrg_adj_type(p_adj_rec IN ar_adjustments%rowtype,

14867: | the buckets Rev and Freight at header are <> 0 |
14868: +------------------------------------------------------+
14869: | Created 26-OCT-03 Herve Yu |
14870: +------------------------------------------------------*/
14871: FUNCTION chrg_adj_type(p_adj_rec IN ar_adjustments%rowtype,
14872: p_ae_rule_rec IN ae_rule_rec_type,
14873: p_amt_rem IN g_amt_rem_type,
14874: p_app_rec IN ar_receivable_applications%rowtype,
14875: p_source_exec IN VARCHAR2)

Line 14949: PROCEDURE possible_adjust(p_adj_rec IN ar_adjustments%rowtype,

14945: | x_chrg_adj codification for charge adjustment |
14946: +-----------------------------------------------------------+
14947: | Created 26-OCT-03 Herve Yu |
14948: +-----------------------------------------------------------*/
14949: PROCEDURE possible_adjust(p_adj_rec IN ar_adjustments%rowtype,
14950: p_ae_rule_rec IN ae_rule_rec_type,
14951: p_customer_trx_id IN NUMBER,
14952: x_return_status OUT NOCOPY VARCHAR2,
14953: x_line_adj OUT NOCOPY VARCHAR2,

Line 15521: (p_adj_rec IN ar_adjustments%ROWTYPE,

15517:
15518:
15519:
15520: PROCEDURE exec_adj_api_if_required
15521: (p_adj_rec IN ar_adjustments%ROWTYPE,
15522: p_app_rec IN ar_receivable_applications%ROWTYPE,
15523: p_ae_rule_rec IN ae_rule_rec_type,
15524: p_cust_inv_rec IN ra_customer_trx%ROWTYPE)
15525: IS

Line 15545: l_adj_number ar_adjustments.adjustment_number%TYPE;

15541:
15542: l_rev_adj_rec AR_Revenue_Adjustment_PVT.Rev_Adj_Rec_Type;
15543: l_adj_id NUMBER;
15544: l_dist_count NUMBER;
15545: l_adj_number ar_adjustments.adjustment_number%TYPE;
15546: l_ra_dist_tbl AR_Revenue_Adjustment_PVT.RA_Dist_Tbl_Type;
15547:
15548: l_return_status VARCHAR2(1);
15549: l_msg_count NUMBER;

Line 15676: p_adj_rec IN ar_adjustments%ROWTYPE)

15672:
15673: PROCEDURE exec_revrec_if_required
15674: ( p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE,
15675: p_app_rec IN ar_receivable_applications%ROWTYPE,
15676: p_adj_rec IN ar_adjustments%ROWTYPE)
15677: IS
15678: CURSOR c1 IS
15679: SELECT ctl.customer_trx_id
15680: FROM ra_customer_trx_lines ctl

Line 16398: p_adj_rec IN ar_adjustments%ROWTYPE,

16394: PROCEDURE update_for_mrc_dist
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,

Line 17174: l_adj_rec ar_adjustments%ROWTYPE;

17170: SELECT * FROM ra_customer_trx_all
17171: WHERE customer_trx_id = p_trx_id;
17172: l_trx_rec ra_customer_trx_all%ROWTYPE;
17173: l_exec_status VARCHAR2(10) := 'N';
17174: l_adj_rec ar_adjustments%ROWTYPE;
17175: l_app_rec ar_receivable_applications%ROWTYPE;
17176: next_app EXCEPTION;
17177: BEGIN
17178: --

Line 17504: FROM ar_adjustments adj

17500: IS
17501: CURSOR c IS
17502: SELECT tt.psa_trx_type_id psa_tt_id,
17503: (SELECT adjustment_id
17504: FROM ar_adjustments adj
17505: WHERE customer_trx_id = trx.customer_trx_id
17506: AND upgrade_method = '11I'
17507: AND rownum = 1) c11iadj,
17508: (SELECT adjustment_id

Line 17509: FROM ar_adjustments adj

17505: WHERE customer_trx_id = trx.customer_trx_id
17506: AND upgrade_method = '11I'
17507: AND rownum = 1) c11iadj,
17508: (SELECT adjustment_id
17509: FROM ar_adjustments adj
17510: WHERE customer_trx_id = trx.customer_trx_id
17511: AND upgrade_method = '11IMFAR'
17512: AND rownum = 1) mfadj,
17513: (SELECT app.receivable_application_id

Line 17598: FROM ar_adjustments adj

17594: x_out_res OUT NOCOPY VARCHAR2)
17595: IS
17596: CURSOR c11I IS
17597: SELECT 'Y'
17598: FROM ar_adjustments adj
17599: WHERE adj.customer_trx_id = p_trx_id
17600: AND adj.status = 'A'
17601: AND adj.postable = 'Y'
17602: AND adj.upgrade_method IN ('11I','11IMFAR') ;

Line 17652: l_adj_rec ar_adjustments%ROWTYPE;

17648: p_gt_id IN NUMBER,
17649: --Add the p_inv_cm flag
17650: p_inv_cm IN VARCHAR2 DEFAULT 'I')
17651: IS
17652: l_adj_rec ar_adjustments%ROWTYPE;
17653: l_app_rec ar_receivable_applications%ROWTYPE;
17654: BEGIN
17655: IF PG_DEBUG = 'Y' THEN
17656: localdebug('arp_det_dist_pkg.Online_lazy_apply()+');

Line 18410: p_adj_rec IN ar_adjustments%ROWTYPE,

18406: END set_interface_flag;
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',

Line 18528: UPDATE ar_adjustments

18524: final_update_inv_ctl_rem_orig(p_customer_trx => p_customer_trx);
18525: END IF;
18526:
18527: IF g_mode_process IN ('R12_MERGE') THEN
18528: UPDATE ar_adjustments
18529: SET upgrade_method = 'R12_MERGE'
18530: WHERE adjustment_id = p_adj_rec.adjustment_id;
18531: ELSE
18532: UPDATE ar_adjustments

Line 18532: UPDATE ar_adjustments

18528: UPDATE ar_adjustments
18529: SET upgrade_method = 'R12_MERGE'
18530: WHERE adjustment_id = p_adj_rec.adjustment_id;
18531: ELSE
18532: UPDATE ar_adjustments
18533: SET upgrade_method = 'R12'
18534: WHERE adjustment_id = p_adj_rec.adjustment_id;
18535: END IF;
18536:

Line 18575: l_adj_rec ar_adjustments%ROWTYPE;

18571: x_return_status IN OUT NOCOPY VARCHAR2,
18572: x_msg_count IN OUT NOCOPY NUMBER,
18573: x_msg_data IN OUT NOCOPY VARCHAR2)
18574: IS
18575: l_adj_rec ar_adjustments%ROWTYPE;
18576: BEGIN
18577: IF PG_DEBUG = 'Y' THEN
18578: localdebug('arp_det_dist_pkg.application_with_interface()+');
18579: localdebug(' p_customer_trx_id :'||p_customer_trx.customer_trx_id);

Line 18729: p_adj_rec IN ar_adjustments%ROWTYPE,

18725:
18726:
18727: PROCEDURE Reconciliation
18728: (p_app_rec IN ar_receivable_applications%ROWTYPE,
18729: p_adj_rec IN ar_adjustments%ROWTYPE,
18730: p_activity_type IN VARCHAR2,
18731: p_gt_id IN VARCHAR2 DEFAULT NULL)
18732: IS
18733: CURSOR cu1(p_gt_id IN NUMBER) IS