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 157: p_app_rec IN ar_receivable_applications%ROWTYPE,

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

Line 163: p_app_rec IN ar_receivable_applications%ROWTYPE,

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

Line 173: ( p_inv_ra_rec IN ar_receivable_applications%ROWTYPE,

169: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type);
170:
171:
172: PROCEDURE convert_ra_inv_to_cm
173: ( p_inv_ra_rec IN ar_receivable_applications%ROWTYPE,
174: p_cm_trx_id IN NUMBER,
175: x_cm_ra_rec IN OUT NOCOPY ar_receivable_applications%ROWTYPE,
176: p_mode IN VARCHAR2 DEFAULT 'OLTP',
177: p_gt_id IN VARCHAR2 DEFAULT NULL,

Line 175: x_cm_ra_rec IN OUT NOCOPY ar_receivable_applications%ROWTYPE,

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

Line 186: app_rec ar_receivable_applications%ROWTYPE);

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

Line 504: UPDATE ar_receivable_applications

500: -- application on a 11i Mfar transaction with Mfar adjustments
501: --
502: IF g_mode_process = 'R12_11IMFAR' THEN
503:
504: UPDATE ar_receivable_applications
505: SET upgrade_method = 'R12_11IMFAR'
506: WHERE receivable_application_id = p_app_id;
507:
508: --

Line 514: UPDATE ar_receivable_applications

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

Line 523: UPDATE ar_receivable_applications

519: -- application on a 11i transaction with 11i adjustments (no Mfar)
520: --
521: ELSIF g_mode_process = 'R12_11ICASH' THEN
522:
523: UPDATE ar_receivable_applications
524: SET upgrade_method = 'R12_11ICASH'
525: WHERE receivable_application_id = p_app_id;
526:
527: END IF;

Line 711: p_app_rec IN ar_receivable_applications%ROWTYPE,

707: (p_gt_id IN VARCHAR2,
708: p_customer_trx_id IN NUMBER,
709: p_pay_adj IN VARCHAR2,
710: p_adj_rec IN ar_adjustments%ROWTYPE,
711: p_app_rec IN ar_receivable_applications%ROWTYPE,
712: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type);
713:
714: /*-------------------------------------------------------------------------+
715: | prepare_group_for_proration |

Line 735: p_app_rec IN ar_receivable_applications%ROWTYPE,

731: (p_gt_id IN VARCHAR2,
732: p_customer_trx_id IN NUMBER,
733: p_pay_adj IN VARCHAR2,
734: p_adj_rec IN ar_adjustments%ROWTYPE,
735: p_app_rec IN ar_receivable_applications%ROWTYPE,
736: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type);
737:
738: /*-------------------------------------------------------------------------+
739: | update_ctl_rem_orig |

Line 787: p_app_rec IN ar_receivable_applications%ROWTYPE,

783: (p_pay_adj IN VARCHAR2,
784: p_customer_trx_id IN NUMBER,
785: p_gt_id IN VARCHAR2,
786: p_adj_rec IN ar_adjustments%ROWTYPE,
787: p_app_rec IN ar_receivable_applications%ROWTYPE,
788: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type);
789:
790:
791: /*-------------------------------------------------------------------------+

Line 865: p_app_rec IN ar_receivable_applications%ROWTYPE,

861: PROCEDURE proration_app_dist_trx
862: (p_gt_id IN VARCHAR2,
863: p_app_level IN VARCHAR2,
864: p_customer_trx_id IN NUMBER,
865: p_app_rec IN ar_receivable_applications%ROWTYPE,
866: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type);
867:
868: PROCEDURE proration_adj_dist_trx
869: (p_gt_id IN VARCHAR2,

Line 3236: p_app_rec IN ar_receivable_applications%ROWTYPE,

3232: (p_gt_id IN VARCHAR2,
3233: p_customer_trx_id IN NUMBER,
3234: p_pay_adj IN VARCHAR2,
3235: p_adj_rec IN ar_adjustments%ROWTYPE,
3236: p_app_rec IN ar_receivable_applications%ROWTYPE,
3237: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type)
3238: IS
3239: l_rows NUMBER;
3240: BEGIN

Line 4058: p_app_rec IN ar_receivable_applications%ROWTYPE,

4054:
4055: PROCEDURE conv_acctd_amt
4056: (p_pay_adj IN VARCHAR2,
4057: p_adj_rec IN ar_adjustments%ROWTYPE,
4058: p_app_rec IN ar_receivable_applications%ROWTYPE,
4059: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type)
4060: IS
4061: l_acctd_amt NUMBER;
4062: BEGIN

Line 4235: p_app_rec IN ar_receivable_applications%ROWTYPE,

4231: --
4232: PROCEDURE conv_acctd_amt_upg
4233: (p_pay_adj IN VARCHAR2,
4234: p_adj_rec IN ar_adjustments%ROWTYPE,
4235: p_app_rec IN ar_receivable_applications%ROWTYPE,
4236: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type)
4237: IS
4238: l_acctd_amt NUMBER;
4239: BEGIN

Line 4569: p_app_rec IN ar_receivable_applications%ROWTYPE,

4565: (p_gt_id IN VARCHAR2,
4566: p_customer_trx_id IN NUMBER,
4567: p_pay_adj IN VARCHAR2,
4568: p_adj_rec IN ar_adjustments%ROWTYPE,
4569: p_app_rec IN ar_receivable_applications%ROWTYPE,
4570: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type)
4571: IS
4572: BEGIN
4573: IF PG_DEBUG = 'Y' THEN

Line 5738: p_app_rec IN ar_receivable_applications%ROWTYPE,

5734: (p_pay_adj IN VARCHAR2,
5735: p_customer_trx_id IN NUMBER,
5736: p_gt_id IN VARCHAR2,
5737: p_adj_rec IN ar_adjustments%ROWTYPE,
5738: p_app_rec IN ar_receivable_applications%ROWTYPE,
5739: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type)
5740: IS
5741:
5742: l_rows NUMBER;

Line 8426: FROM ar_receivable_applications ar

8422: AND ctt.CUST_TRX_TYPE_ID = inv.CUST_TRX_TYPE_ID
8423: AND ctt.TYPE in ('INV','DM')
8424: AND EXISTS
8425: (SELECT 1
8426: FROM ar_receivable_applications ar
8427: WHERE ar.applied_customer_trx_id = inv.customer_trx_id
8428: UNION
8429: SELECT 1
8430: FROM ar_adjustments ad

Line 10961: p_app_rec IN ar_receivable_applications%ROWTYPE,

10957: PROCEDURE proration_app_dist_trx
10958: (p_gt_id IN VARCHAR2,
10959: p_app_level IN VARCHAR2,
10960: p_customer_trx_id IN NUMBER,
10961: p_app_rec IN ar_receivable_applications%ROWTYPE,
10962: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type)
10963: IS
10964: l_adj_rec ar_adjustments%ROWTYPE;
10965: BEGIN

Line 11009: l_app_rec ar_receivable_applications%ROWTYPE;

11005: p_customer_trx_id IN NUMBER,
11006: p_adj_rec IN ar_adjustments%ROWTYPE,
11007: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type)
11008: IS
11009: l_app_rec ar_receivable_applications%ROWTYPE;
11010: BEGIN
11011: IF PG_DEBUG = 'Y' THEN
11012: localdebug('arp_det_dist_pkg.proration_adj_dist_trx()+');
11013: localdebug(' p_gt_id :'||p_gt_id );

Line 11078: p_app_rec IN ar_receivable_applications%ROWTYPE,

11074: | p_ae_sys_rec ar system parameter |
11075: +-------------------------------------------------------------------------*/
11076: PROCEDURE Trx_level_cash_apply
11077: (p_customer_trx IN ra_customer_trx%ROWTYPE,
11078: p_app_rec IN ar_receivable_applications%ROWTYPE,
11079: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type,
11080: p_gt_id IN VARCHAR2 DEFAULT NULL)
11081: IS
11082: l_adj_rec ar_adjustments%ROWTYPE;

Line 11083: l_app_rec ar_receivable_applications%ROWTYPE;

11079: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type,
11080: p_gt_id IN VARCHAR2 DEFAULT NULL)
11081: IS
11082: l_adj_rec ar_adjustments%ROWTYPE;
11083: l_app_rec ar_receivable_applications%ROWTYPE;
11084: l_gt_id VARCHAR2(30);
11085: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
11086: l_msg_data VARCHAR2(2000);
11087: l_msg_count NUMBER;

Line 11255: p_app_rec IN ar_receivable_applications%ROWTYPE,

11251: p_source_data_key3 IN VARCHAR2,
11252: p_source_data_key4 IN VARCHAR2,
11253: p_source_data_key5 IN VARCHAR2,
11254: --}
11255: p_app_rec IN ar_receivable_applications%ROWTYPE,
11256: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type,
11257: p_gt_id IN VARCHAR2 DEFAULT NULL)
11258: IS
11259: l_adj_rec ar_adjustments%ROWTYPE;

Line 11260: l_app_rec ar_receivable_applications%ROWTYPE;

11256: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type,
11257: p_gt_id IN VARCHAR2 DEFAULT NULL)
11258: IS
11259: l_adj_rec ar_adjustments%ROWTYPE;
11260: l_app_rec ar_receivable_applications%ROWTYPE;
11261: l_gt_id VARCHAR2(30);
11262: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
11263: l_msg_data VARCHAR2(2000);
11264: l_msg_count NUMBER;

Line 11455: p_app_rec IN ar_receivable_applications%ROWTYPE,

11451: PROCEDURE Trx_line_level_cash_apply
11452: (p_customer_trx IN ra_customer_trx%ROWTYPE,
11453: p_customer_trx_line_id IN VARCHAR2,
11454: p_log_inv_line IN VARCHAR2 DEFAULT 'N',
11455: p_app_rec IN ar_receivable_applications%ROWTYPE,
11456: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type,
11457: p_gt_id IN VARCHAR2 DEFAULT NULL)
11458: IS
11459: l_adj_rec ar_adjustments%ROWTYPE;

Line 11460: l_app_rec ar_receivable_applications%ROWTYPE;

11456: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type,
11457: p_gt_id IN VARCHAR2 DEFAULT NULL)
11458: IS
11459: l_adj_rec ar_adjustments%ROWTYPE;
11460: l_app_rec ar_receivable_applications%ROWTYPE;
11461: l_gt_id VARCHAR2(30);
11462: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
11463: l_msg_data VARCHAR2(2000);
11464: l_msg_count NUMBER;

Line 12019: p_app_rec IN ar_receivable_applications%ROWTYPE,

12015:
12016:
12017: PROCEDURE create_final_split
12018: (p_customer_trx IN ra_customer_trx%ROWTYPE,
12019: p_app_rec IN ar_receivable_applications%ROWTYPE,
12020: p_adj_rec IN ar_adjustments%ROWTYPE,
12021: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type)
12022: IS
12023: BEGIN

Line 12089: l_app_rec ar_receivable_applications%ROWTYPE;

12085: p_adj_rec IN ar_adjustments%ROWTYPE,
12086: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type,
12087: p_gt_id IN NUMBER DEFAULT NULL)
12088: IS
12089: l_app_rec ar_receivable_applications%ROWTYPE;
12090: l_gt_id NUMBER;
12091: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
12092: l_msg_count NUMBER := 0;
12093: l_msg_data VARCHAR2(2000);

Line 12237: p_app_rec IN ar_receivable_applications%ROWTYPE,

12233: | p_ae_sys_rec ar system parameter |
12234: +-------------------------------------------------------------------------*/
12235: PROCEDURE Trx_level_direct_cash_apply
12236: (p_customer_trx IN ra_customer_trx%ROWTYPE,
12237: p_app_rec IN ar_receivable_applications%ROWTYPE,
12238: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type,
12239: p_gt_id IN NUMBER DEFAULT NULL,
12240: p_inv_cm IN VARCHAR2 DEFAULT 'I')
12241: IS

Line 12243: l_app_rec ar_receivable_applications%ROWTYPE;

12239: p_gt_id IN NUMBER DEFAULT NULL,
12240: p_inv_cm IN VARCHAR2 DEFAULT 'I')
12241: IS
12242: l_adj_rec ar_adjustments%ROWTYPE;
12243: l_app_rec ar_receivable_applications%ROWTYPE;
12244: l_gt_id NUMBER;
12245: l_out_res VARCHAR2(1);
12246: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
12247: l_msg_count NUMBER := 0;

Line 12871: p_app_rec IN ar_receivable_applications%rowtype,

12867: | Created 26-OCT-03 Herve Yu |
12868: +------------------------------------------------------*/
12869: FUNCTION ed_uned_type
12870: ( p_source_exec IN VARCHAR2,
12871: p_app_rec IN ar_receivable_applications%rowtype,
12872: p_bucket IN VARCHAR2)
12873: RETURN VARCHAR2
12874: IS
12875: l_res VARCHAR2(1) := 'N';

Line 12934: p_app_rec IN ar_receivable_applications%rowtype,

12930: +------------------------------------------------------*/
12931: FUNCTION tax_adj_type(p_adj_rec IN ar_adjustments%rowtype,
12932: p_ae_rule_rec IN ae_rule_rec_type,
12933: p_amt_rem IN g_amt_rem_type,
12934: p_app_rec IN ar_receivable_applications%rowtype,
12935: p_source_exec IN VARCHAR2)
12936: RETURN VARCHAR2
12937: IS
12938: l_type VARCHAR2(30);

Line 13049: p_app_rec IN ar_receivable_applications%rowtype,

13045: +------------------------------------------------------*/
13046: FUNCTION line_adj_type(p_adj_rec IN ar_adjustments%rowtype,
13047: p_ae_rule_rec IN ae_rule_rec_type,
13048: p_amt_rem IN g_amt_rem_type,
13049: p_app_rec IN ar_receivable_applications%rowtype,
13050: p_source_exec IN VARCHAR2)
13051: RETURN VARCHAR2
13052: IS
13053: l_res VARCHAR2(30);

Line 13133: p_app_rec IN ar_receivable_applications%rowtype,

13129: +------------------------------------------------------*/
13130: FUNCTION frt_adj_type(p_adj_rec IN ar_adjustments%rowtype,
13131: p_ae_rule_rec IN ae_rule_rec_type,
13132: p_amt_rem IN g_amt_rem_type,
13133: p_app_rec IN ar_receivable_applications%rowtype,
13134: p_source_exec IN VARCHAR2)
13135: RETURN VARCHAR2
13136: IS
13137: l_res VARCHAR2(30);

Line 13230: p_app_rec IN ar_receivable_applications%rowtype,

13226: +------------------------------------------------------*/
13227: FUNCTION chrg_adj_type(p_adj_rec IN ar_adjustments%rowtype,
13228: p_ae_rule_rec IN ae_rule_rec_type,
13229: p_amt_rem IN g_amt_rem_type,
13230: p_app_rec IN ar_receivable_applications%rowtype,
13231: p_source_exec IN VARCHAR2)
13232: RETURN VARCHAR2
13233: IS
13234: l_res VARCHAR2(30);

Line 13313: p_app_rec IN ar_receivable_applications%rowtype

13309: x_line_adj OUT NOCOPY VARCHAR2,
13310: x_tax_adj OUT NOCOPY VARCHAR2,
13311: x_frt_adj OUT NOCOPY VARCHAR2,
13312: x_chrg_adj OUT NOCOPY VARCHAR2,
13313: p_app_rec IN ar_receivable_applications%rowtype
13314: )
13315: IS
13316: l_source_exec VARCHAR2(30);
13317: l_amt_rem g_amt_rem_type;

Line 13429: (p_app_rec IN ar_receivable_applications%ROWTYPE,

13425: END;
13426:
13427:
13428: PROCEDURE get_from_currency
13429: (p_app_rec IN ar_receivable_applications%ROWTYPE,
13430: x_from_curr_code OUT NOCOPY VARCHAR2)
13431: IS
13432: CURSOR c_rec_curr(p_cr_id IN NUMBER) IS
13433: SELECT CURRENCY_CODE

Line 13601: p_app_rec IN ar_receivable_applications%ROWTYPE,

13597: PROCEDURE update_from_gt
13598: (p_from_amt IN NUMBER,
13599: p_from_acctd_amt IN NUMBER,
13600: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type,
13601: p_app_rec IN ar_receivable_applications%ROWTYPE,
13602: p_gt_id IN VARCHAR2 DEFAULT NULL,
13603: p_inv_currency IN VARCHAr2 DEFAULT NULL)
13604: IS
13605: CURSOR cu1(p_gt_id IN NUMBER) IS

Line 13652: from ar_receivable_applications_all ra,

13648: AND source_table ='RA';
13649:
13650: select count(*)
13651: into l_br_count
13652: from ar_receivable_applications_all ra,
13653: ar_payment_schedules_all pay
13654: where ra.receivable_application_id = l_source_id and
13655: ra.applied_payment_schedule_id = pay.payment_schedule_id and
13656: pay.class ='BR';

Line 13727: from ar_receivable_applications_all

13723:
13724:
13725: SELECT amount_applied,acctd_amount_applied_to
13726: INTO l_pro_base, l_pro_acctd_base
13727: from ar_receivable_applications_all
13728: where receivable_application_id = l_source_id;
13729:
13730: END IF;
13731: /* End bug7343649 - vavenugo */

Line 13810: p_app_rec IN ar_receivable_applications%ROWTYPE,

13806:
13807:
13808: PROCEDURE exec_adj_api_if_required
13809: (p_adj_rec IN ar_adjustments%ROWTYPE,
13810: p_app_rec IN ar_receivable_applications%ROWTYPE,
13811: p_ae_rule_rec IN ae_rule_rec_type,
13812: p_cust_inv_rec IN ra_customer_trx%ROWTYPE)
13813: IS
13814:

Line 13963: p_app_rec IN ar_receivable_applications%ROWTYPE,

13959:
13960:
13961: PROCEDURE exec_revrec_if_required
13962: ( p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE,
13963: p_app_rec IN ar_receivable_applications%ROWTYPE,
13964: p_adj_rec IN ar_adjustments%ROWTYPE)
13965: IS
13966: CURSOR c1 IS
13967: SELECT ctl.customer_trx_id

Line 14685: p_app_rec IN ar_receivable_applications%ROWTYPE,

14681:
14682: PROCEDURE update_for_mrc_dist
14683: (p_gt_id IN VARCHAR2,
14684: p_customer_trx_id IN NUMBER,
14685: p_app_rec IN ar_receivable_applications%ROWTYPE,
14686: p_adj_rec IN ar_adjustments%ROWTYPE,
14687: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type)
14688: IS
14689: CURSOR c_mrc(p_acctd_adj_app_to IN NUMBER,

Line 15452: p_app_rec IN ar_receivable_applications%ROWTYPE,

15448: --{Lazy upgrade at posting
15449: -- Modification, this is procedure will be called in downtime
15450: PROCEDURE prepare_for_ra
15451: ( p_gt_id IN NUMBER,
15452: p_app_rec IN ar_receivable_applications%ROWTYPE,
15453: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type,
15454: p_inv_cm IN VARCHAR2 DEFAULT 'I',
15455: p_cash_mfar IN VARCHAR2 DEFAULT 'CASH')
15456: IS

Line 15463: l_app_rec ar_receivable_applications%ROWTYPE;

15459: WHERE customer_trx_id = p_trx_id;
15460: l_trx_rec ra_customer_trx_all%ROWTYPE;
15461: l_exec_status VARCHAR2(10) := 'N';
15462: l_adj_rec ar_adjustments%ROWTYPE;
15463: l_app_rec ar_receivable_applications%ROWTYPE;
15464: next_app EXCEPTION;
15465: BEGIN
15466: --
15467: PG_DEBUG := 'N';

Line 15766: -- UPDATE ar_receivable_applications_all

15762: insert_ard_gt(p_gt_id => p_gt_id,
15763: x_exec_status =>l_exec_status );
15764:
15765: --IF l_exec_status = 'Y' THEN
15766: -- UPDATE ar_receivable_applications_all
15767: -- SET upgrade_method = 'R12_11ICASH_POST'
15768: -- WHERE receivable_application_id = p_app_rec.receivable_application_id;
15769: --END IF;
15770:

Line 15802: FROM ar_receivable_applications app

15798: WHERE customer_trx_id = trx.customer_trx_id
15799: AND upgrade_method = '11IMFAR'
15800: AND rownum = 1) mfadj,
15801: (SELECT app.receivable_application_id
15802: FROM ar_receivable_applications app
15803: WHERE app.applied_customer_trx_id = trx.customer_trx_id
15804: AND app.upgrade_method IS NULL
15805: AND NVL(p_app_id,-9) <> app.receivable_application_id -- excluded the current app record
15806: AND rownum = 1) app11i,

Line 15808: FROM ar_receivable_applications app

15804: AND app.upgrade_method IS NULL
15805: AND NVL(p_app_id,-9) <> app.receivable_application_id -- excluded the current app record
15806: AND rownum = 1) app11i,
15807: (SELECT receivable_application_id
15808: FROM ar_receivable_applications app
15809: WHERE app.customer_trx_id = trx.customer_trx_id
15810: AND app.upgrade_method IS NULL
15811: AND NVL(p_app_id,-9) <> app.receivable_application_id -- excluded the current app record
15812: AND rownum = 1) cmapp11i

Line 15934: p_app_rec IN ar_receivable_applications%ROWTYPE,

15930:
15931:
15932: PROCEDURE online_lazy_apply
15933: (p_customer_trx IN ra_customer_trx%ROWTYPE,
15934: p_app_rec IN ar_receivable_applications%ROWTYPE,
15935: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type,
15936: p_gt_id IN NUMBER,
15937: --Add the p_inv_cm flag
15938: p_inv_cm IN VARCHAR2 DEFAULT 'I')

Line 15941: l_app_rec ar_receivable_applications%ROWTYPE;

15937: --Add the p_inv_cm flag
15938: p_inv_cm IN VARCHAR2 DEFAULT 'I')
15939: IS
15940: l_adj_rec ar_adjustments%ROWTYPE;
15941: l_app_rec ar_receivable_applications%ROWTYPE;
15942: BEGIN
15943: IF PG_DEBUG = 'Y' THEN
15944: localdebug('arp_det_dist_pkg.Online_lazy_apply()+');
15945: localdebug(' p_app_rec.applied_customer_trx_id : '||p_app_rec.applied_customer_trx_id);

Line 16122: UPDATE ar_receivable_applications_all

16118: --delete from hy_line_application_detail;
16119: --insert into hy_line_application_detail select * from AR_LINE_APP_DETAIL_GT;
16120:
16121:
16122: UPDATE ar_receivable_applications_all
16123: SET upgrade_method = 'R12_11ICASH'
16124: WHERE receivable_application_id = l_app_rec.receivable_application_id;
16125:
16126: IF PG_DEBUG = 'Y' THEN

Line 16280: ( p_inv_ra_rec IN ar_receivable_applications%ROWTYPE,

16276:
16277:
16278:
16279: PROCEDURE convert_ra_inv_to_cm
16280: ( p_inv_ra_rec IN ar_receivable_applications%ROWTYPE,
16281: p_cm_trx_id IN NUMBER,
16282: x_cm_ra_rec IN OUT NOCOPY ar_receivable_applications%ROWTYPE,
16283: p_mode IN VARCHAR2 DEFAULT 'OLTP',
16284: p_gt_id IN VARCHAR2 DEFAULT NULL,

Line 16282: x_cm_ra_rec IN OUT NOCOPY ar_receivable_applications%ROWTYPE,

16278:
16279: PROCEDURE convert_ra_inv_to_cm
16280: ( p_inv_ra_rec IN ar_receivable_applications%ROWTYPE,
16281: p_cm_trx_id IN NUMBER,
16282: x_cm_ra_rec IN OUT NOCOPY ar_receivable_applications%ROWTYPE,
16283: p_mode IN VARCHAR2 DEFAULT 'OLTP',
16284: p_gt_id IN VARCHAR2 DEFAULT NULL,
16285: p_from_llca IN VARCHAR2 DEFAULT 'N',
16286: p_upg_cm IN VARCHAR2 DEFAULT 'N')

Line 16367: l_cm_ra_rec ar_receivable_applications%ROWTYPE;

16363: l_rem_charges_balance NUMBER;
16364: l_rem_invoice_currency_code VARCHAR2(30);
16365: --
16366:
16367: l_cm_ra_rec ar_receivable_applications%ROWTYPE;
16368: l_line_applied NUMBER;
16369: l_tax_applied NUMBER;
16370: l_freight_applied NUMBER;
16371: l_charges_applied NUMBER;

Line 16679: l_app_rec ar_receivable_applications%ROWTYPE;

16675: x_msg_data IN OUT NOCOPY VARCHAR2,
16676: p_llca_from_call IN VARCHAR2 DEFAULT NULL,
16677: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%TYPE DEFAULT NULL)
16678: IS
16679: l_app_rec ar_receivable_applications%ROWTYPE;
16680: BEGIN
16681: IF PG_DEBUG = 'Y' THEN
16682: localdebug('arp_det_dist_pkg.adjustment_with_interface()+');
16683: localdebug(' p_gt_id :'||p_gt_id);

Line 16811: p_app_rec IN ar_receivable_applications%ROWTYPE,

16807:
16808:
16809: PROCEDURE application_with_interface
16810: (p_customer_trx IN ra_customer_trx%ROWTYPE,
16811: p_app_rec IN ar_receivable_applications%ROWTYPE,
16812: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type,
16813: p_gt_id IN NUMBER,
16814: p_line_flag IN VARCHAR2 DEFAULT 'INTERFACE',
16815: p_tax_flag IN VARCHAR2 DEFAULT 'INTERFACE',

Line 16978: (p_app_rec IN ar_receivable_applications%ROWTYPE,

16974:
16975:
16976:
16977: PROCEDURE Reconciliation
16978: (p_app_rec IN ar_receivable_applications%ROWTYPE,
16979: p_adj_rec IN ar_adjustments%ROWTYPE,
16980: p_activity_type IN VARCHAR2,
16981: p_gt_id IN VARCHAR2 DEFAULT NULL)
16982: IS