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_RECEIVABLE_APPLICATIONS

Line 158: p_app_rec IN ar_receivable_applications%ROWTYPE,

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
162: (p_pay_adj IN VARCHAR2,

Line 164: p_app_rec IN ar_receivable_applications%ROWTYPE,

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
168: (p_gt_id IN VARCHAR2,

Line 174: ( p_inv_ra_rec IN ar_receivable_applications%ROWTYPE,

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,
175: p_cm_trx_id IN NUMBER,
176: x_cm_ra_rec IN OUT NOCOPY ar_receivable_applications%ROWTYPE,
177: p_mode IN VARCHAR2 DEFAULT 'OLTP',
178: p_gt_id IN VARCHAR2 DEFAULT NULL,

Line 176: x_cm_ra_rec IN OUT NOCOPY ar_receivable_applications%ROWTYPE,

172:
173: PROCEDURE convert_ra_inv_to_cm
174: ( p_inv_ra_rec IN ar_receivable_applications%ROWTYPE,
175: p_cm_trx_id IN NUMBER,
176: x_cm_ra_rec IN OUT NOCOPY ar_receivable_applications%ROWTYPE,
177: p_mode IN VARCHAR2 DEFAULT 'OLTP',
178: p_gt_id IN VARCHAR2 DEFAULT NULL,
179: p_from_llca IN VARCHAR2 DEFAULT 'N',
180: p_upg_cm IN VARCHAR2 DEFAULT 'N');

Line 187: app_rec ar_receivable_applications%ROWTYPE);

183: | Routine elementary and data structure |
184: +-------------------------------------------------------------------------*/
185: TYPE gt_record IS RECORD (gt_id NUMBER,
186: app_level VARCHAR2(30),
187: app_rec ar_receivable_applications%ROWTYPE);
188:
189: TYPE gt_tab_type IS TABLE of gt_record INDEX BY BINARY_INTEGER;
190: g_gt_tab gt_tab_type;
191: clear_gt_tab gt_tab_type;

Line 508: UPDATE ar_receivable_applications

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
509: SET upgrade_method = 'R12_11IMFAR'
510: WHERE receivable_application_id = p_app_id;
511:
512: --

Line 518: UPDATE ar_receivable_applications

514: -- Note all 11i transactions without applications will be stamped as R12
515: --
516: ELSIF g_mode_process IN ('R12','R12_NLB') THEN
517:
518: UPDATE ar_receivable_applications
519: SET upgrade_method = 'R12'
520: WHERE receivable_application_id = p_app_id;
521:
522: --

Line 527: UPDATE ar_receivable_applications

523: -- application on a 11i transaction with 11i adjustments (no Mfar)
524: --
525: ELSIF g_mode_process = 'R12_11ICASH' THEN
526:
527: UPDATE ar_receivable_applications
528: SET upgrade_method = 'R12_11ICASH'
529: WHERE receivable_application_id = p_app_id;
530:
531: --application on invoice having activity/application with summarized distributions

Line 534: UPDATE ar_receivable_applications

530:
531: --application on invoice having activity/application with summarized distributions
532: ELSIF g_mode_process = 'R12_MERGE' THEN
533:
534: UPDATE ar_receivable_applications
535: SET upgrade_method = 'R12_MERGE'
536: WHERE receivable_application_id = p_app_id;
537:
538: END IF;

Line 743: p_app_rec IN ar_receivable_applications%ROWTYPE,

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: /*-------------------------------------------------------------------------+
747: | prepare_group_for_proration |

Line 767: p_app_rec IN ar_receivable_applications%ROWTYPE,

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: /*-------------------------------------------------------------------------+
771: | update_ctl_rem_orig |

Line 819: p_app_rec IN ar_receivable_applications%ROWTYPE,

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:
823: /*-------------------------------------------------------------------------+

Line 897: p_app_rec IN ar_receivable_applications%ROWTYPE,

893: PROCEDURE proration_app_dist_trx
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,

Line 4160: p_app_rec IN ar_receivable_applications%ROWTYPE,

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;
4164: BEGIN

Line 4983: p_app_rec IN ar_receivable_applications%ROWTYPE,

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;
4987: BEGIN

Line 5160: p_app_rec IN ar_receivable_applications%ROWTYPE,

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;
5164: BEGIN

Line 5494: p_app_rec IN ar_receivable_applications%ROWTYPE,

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
5498: IF PG_DEBUG = 'Y' THEN

Line 6678: p_app_rec IN ar_receivable_applications%ROWTYPE,

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:
6682: l_rows NUMBER;

Line 7974: ar_receivable_applications ra,

7970: 'REV','Y', -- BUG 7597090
7971: 'N') -- tax_inc_flag
7972: FROM ra_ar_gt rar,
7973: ar_distributions rrc,
7974: ar_receivable_applications ra,
7975: ra_customer_trx_lines ctl
7976: WHERE rar.gt_id = p_gt_id
7977: AND rar.ref_customer_trx_id = p_customer_trx_id
7978: AND rar.gp_level = 'L'

Line 9843: FROM ar_receivable_applications ar

9839: AND ctt.CUST_TRX_TYPE_ID = inv.CUST_TRX_TYPE_ID
9840: AND ctt.TYPE in ('INV','DM')
9841: AND EXISTS
9842: (SELECT 1
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

Line 12418: p_app_rec IN ar_receivable_applications%ROWTYPE,

12414: PROCEDURE proration_app_dist_trx
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

Line 12466: l_app_rec ar_receivable_applications%ROWTYPE;

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
12469: localdebug('arp_det_dist_pkg.proration_adj_dist_trx()+');
12470: localdebug(' p_gt_id :'||p_gt_id );

Line 12535: p_app_rec IN ar_receivable_applications%ROWTYPE,

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

Line 12540: l_app_rec 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);
12544: l_msg_count NUMBER;

Line 12719: p_app_rec IN ar_receivable_applications%ROWTYPE,

12715: p_source_data_key3 IN VARCHAR2,
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;

Line 12724: l_app_rec 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);
12728: l_msg_count NUMBER;

Line 12926: p_app_rec IN ar_receivable_applications%ROWTYPE,

12922: PROCEDURE Trx_line_level_cash_apply
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;

Line 12931: l_app_rec 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);
12935: l_msg_count NUMBER;

Line 13256: FROM ar_receivable_applications ra,

13252: SELECT SUM( NVL(ard.amount_cr,0) - NVL(ard.amount_dr,0) ) amt,
13253: SUM( NVL(ard.acctd_amount_cr,0) - NVL(ard.acctd_amount_dr,0)) acctd_amt,
13254: ard.ref_customer_trx_line_id,
13255: ard.activity_bucket
13256: FROM ar_receivable_applications ra,
13257: ar_distributions ard,
13258: ra_customer_trx_lines ctl
13259: WHERE ctl.customer_trx_id = p_customer_trx_id
13260: AND ctl.line_type = 'LINE'

Line 13596: p_app_rec IN ar_receivable_applications%ROWTYPE,

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

Line 13666: l_app_rec ar_receivable_applications%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;
13668: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
13669: l_msg_count NUMBER := 0;
13670: l_msg_data VARCHAR2(2000);

Line 13821: p_app_rec IN ar_receivable_applications%ROWTYPE,

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

Line 13827: l_app_rec ar_receivable_applications%ROWTYPE;

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;
13831: l_msg_count NUMBER := 0;

Line 14515: p_app_rec IN ar_receivable_applications%rowtype,

14511: | Created 26-OCT-03 Herve Yu |
14512: +------------------------------------------------------*/
14513: FUNCTION ed_uned_type
14514: ( p_source_exec IN VARCHAR2,
14515: p_app_rec IN ar_receivable_applications%rowtype,
14516: p_bucket IN VARCHAR2)
14517: RETURN VARCHAR2
14518: IS
14519: l_res VARCHAR2(1) := 'N';

Line 14578: p_app_rec IN ar_receivable_applications%rowtype,

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)
14580: RETURN VARCHAR2
14581: IS
14582: l_type VARCHAR2(30);

Line 14693: p_app_rec IN ar_receivable_applications%rowtype,

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)
14695: RETURN VARCHAR2
14696: IS
14697: l_res VARCHAR2(30);

Line 14777: p_app_rec IN ar_receivable_applications%rowtype,

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)
14779: RETURN VARCHAR2
14780: IS
14781: l_res VARCHAR2(30);

Line 14874: p_app_rec IN ar_receivable_applications%rowtype,

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)
14876: RETURN VARCHAR2
14877: IS
14878: l_res VARCHAR2(30);

Line 14957: p_app_rec IN ar_receivable_applications%rowtype

14953: x_line_adj OUT NOCOPY VARCHAR2,
14954: x_tax_adj OUT NOCOPY VARCHAR2,
14955: x_frt_adj OUT NOCOPY VARCHAR2,
14956: x_chrg_adj OUT NOCOPY VARCHAR2,
14957: p_app_rec IN ar_receivable_applications%rowtype
14958: )
14959: IS
14960: l_source_exec VARCHAR2(30);
14961: l_amt_rem g_amt_rem_type;

Line 15073: (p_app_rec IN ar_receivable_applications%ROWTYPE,

15069: END;
15070:
15071:
15072: PROCEDURE get_from_currency
15073: (p_app_rec IN ar_receivable_applications%ROWTYPE,
15074: x_from_curr_code OUT NOCOPY VARCHAR2)
15075: IS
15076: CURSOR c_rec_curr(p_cr_id IN NUMBER) IS
15077: SELECT CURRENCY_CODE

Line 15249: p_app_rec IN ar_receivable_applications%ROWTYPE,

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
15253: CURSOR cu1(p_gt_id IN NUMBER) IS

Line 15306: from ar_receivable_applications_all ra,

15302: AND source_table ='RA';
15303:
15304: select count(*)
15305: into l_br_count
15306: from ar_receivable_applications_all ra,
15307: ar_payment_schedules_all pay
15308: where ra.receivable_application_id = l_source_id and
15309: ra.applied_payment_schedule_id = pay.payment_schedule_id and
15310: pay.class ='BR';

Line 15381: from ar_receivable_applications_all

15377:
15378:
15379: SELECT amount_applied,acctd_amount_applied_to
15380: INTO l_pro_base, l_pro_acctd_base
15381: from ar_receivable_applications_all
15382: where receivable_application_id = l_source_id;
15383:
15384: END IF;
15385: /* End bug7343649 - vavenugo */

Line 15411: ar_receivable_applications ra

15407: INTO l_app_date, l_app_exch_rate,
15408: l_trx_date, l_trx_exch_rate
15409: FROM ar_payment_schedules ps,
15410: ar_payment_schedules ps1,
15411: ar_receivable_applications ra
15412: WHERE ra.receivable_application_id = p_app_rec.receivable_application_id
15413: and ps.payment_schedule_id = ra.payment_schedule_id
15414: AND ps1.payment_schedule_id = ra.applied_payment_schedule_id;
15415:

Line 15522: p_app_rec IN ar_receivable_applications%ROWTYPE,

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

Line 15675: p_app_rec IN ar_receivable_applications%ROWTYPE,

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

Line 16397: p_app_rec IN ar_receivable_applications%ROWTYPE,

16393:
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,

Line 17164: p_app_rec IN ar_receivable_applications%ROWTYPE,

17160: --{Lazy upgrade at posting
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

Line 17175: l_app_rec ar_receivable_applications%ROWTYPE;

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: --
17179: PG_DEBUG := 'N';

Line 17478: -- UPDATE ar_receivable_applications_all

17474: insert_ard_gt(p_gt_id => p_gt_id,
17475: x_exec_status =>l_exec_status );
17476:
17477: --IF l_exec_status = 'Y' THEN
17478: -- UPDATE ar_receivable_applications_all
17479: -- SET upgrade_method = 'R12_11ICASH_POST'
17480: -- WHERE receivable_application_id = p_app_rec.receivable_application_id;
17481: --END IF;
17482:

Line 17514: FROM ar_receivable_applications app

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
17514: FROM ar_receivable_applications app
17515: WHERE app.applied_customer_trx_id = trx.customer_trx_id
17516: AND NVL(app.upgrade_method,'NULL') IN ('11I_MFAR_UPG','NULL')
17517: AND NVL(p_app_id,-9) <> app.receivable_application_id -- excluded the current app record
17518: AND rownum = 1) app11i,

Line 17520: FROM ar_receivable_applications app

17516: AND NVL(app.upgrade_method,'NULL') IN ('11I_MFAR_UPG','NULL')
17517: AND NVL(p_app_id,-9) <> app.receivable_application_id -- excluded the current app record
17518: AND rownum = 1) app11i,
17519: (SELECT receivable_application_id
17520: FROM ar_receivable_applications app
17521: WHERE app.customer_trx_id = trx.customer_trx_id
17522: AND NVL(app.upgrade_method,'NULL') IN ('11I_MFAR_UPG','NULL')
17523: AND NVL(p_app_id,-9) <> app.receivable_application_id -- excluded the current app record
17524: AND rownum = 1) cmapp11i

Line 17646: p_app_rec IN ar_receivable_applications%ROWTYPE,

17642:
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')

Line 17653: l_app_rec ar_receivable_applications%ROWTYPE;

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()+');
17657: localdebug(' p_app_rec.applied_customer_trx_id : '||p_app_rec.applied_customer_trx_id);

Line 17834: UPDATE ar_receivable_applications_all

17830: --delete from hy_line_application_detail;
17831: --insert into hy_line_application_detail select * from AR_LINE_APP_DETAIL_GT;
17832:
17833: IF g_mode_process = 'R12_MERGE' THEN
17834: UPDATE ar_receivable_applications_all
17835: SET upgrade_method = 'R12_MERGE'
17836: WHERE receivable_application_id = l_app_rec.receivable_application_id;
17837: ELSE
17838: UPDATE ar_receivable_applications_all

Line 17838: UPDATE ar_receivable_applications_all

17834: UPDATE ar_receivable_applications_all
17835: SET upgrade_method = 'R12_MERGE'
17836: WHERE receivable_application_id = l_app_rec.receivable_application_id;
17837: ELSE
17838: UPDATE ar_receivable_applications_all
17839: SET upgrade_method = 'R12_11ICASH'
17840: WHERE receivable_application_id = l_app_rec.receivable_application_id;
17841: END IF;
17842:

Line 17999: ( p_inv_ra_rec IN ar_receivable_applications%ROWTYPE,

17995:
17996:
17997:
17998: PROCEDURE convert_ra_inv_to_cm
17999: ( p_inv_ra_rec IN ar_receivable_applications%ROWTYPE,
18000: p_cm_trx_id IN NUMBER,
18001: x_cm_ra_rec IN OUT NOCOPY ar_receivable_applications%ROWTYPE,
18002: p_mode IN VARCHAR2 DEFAULT 'OLTP',
18003: p_gt_id IN VARCHAR2 DEFAULT NULL,

Line 18001: x_cm_ra_rec IN OUT NOCOPY ar_receivable_applications%ROWTYPE,

17997:
17998: PROCEDURE convert_ra_inv_to_cm
17999: ( p_inv_ra_rec IN ar_receivable_applications%ROWTYPE,
18000: p_cm_trx_id IN NUMBER,
18001: x_cm_ra_rec IN OUT NOCOPY ar_receivable_applications%ROWTYPE,
18002: p_mode IN VARCHAR2 DEFAULT 'OLTP',
18003: p_gt_id IN VARCHAR2 DEFAULT NULL,
18004: p_from_llca IN VARCHAR2 DEFAULT 'N',
18005: p_upg_cm IN VARCHAR2 DEFAULT 'N')

Line 18086: l_cm_ra_rec ar_receivable_applications%ROWTYPE;

18082: l_rem_charges_balance NUMBER;
18083: l_rem_invoice_currency_code VARCHAR2(30);
18084: --
18085:
18086: l_cm_ra_rec ar_receivable_applications%ROWTYPE;
18087: l_line_applied NUMBER;
18088: l_tax_applied NUMBER;
18089: l_freight_applied NUMBER;
18090: l_charges_applied NUMBER;

Line 18422: l_app_rec ar_receivable_applications%ROWTYPE;

18418: x_msg_data IN OUT NOCOPY VARCHAR2,
18419: p_llca_from_call IN VARCHAR2 DEFAULT NULL,
18420: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%TYPE DEFAULT NULL)
18421: IS
18422: l_app_rec ar_receivable_applications%ROWTYPE;
18423: BEGIN
18424: IF PG_DEBUG = 'Y' THEN
18425: localdebug('arp_det_dist_pkg.adjustment_with_interface()+');
18426: localdebug(' p_gt_id :'||p_gt_id);

Line 18561: p_app_rec IN ar_receivable_applications%ROWTYPE,

18557:
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',

Line 18728: (p_app_rec IN ar_receivable_applications%ROWTYPE,

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