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.AR_REVENUE_ADJUSTMENT_PVT dependencies on RA_CUST_TRX_LINE_GL_DIST

Line 342: -- rather than writing them to ra_cust_trx_line_gl_dist

338: -- Function : Transfers a specified amount of revenue from
339: -- unearned to earned revenue account. This is an
340: -- overlaid version of the previous procedure that
341: -- returns the new distributions in a pl/sql table
342: -- rather than writing them to ra_cust_trx_line_gl_dist
343: -- Pre-reqs : Sufficient unearned revenue must exist.
344: -- Parameters :
345: -- IN : p_api_version NUMBER Required
346: -- p_init_msg_list VARCHAR2 Optional

Line 367: -- entries into ra_cust_trx_line_gl_dist. Instead it outputs

363: --
364: -- Notes : AutoAccounting used for both debits and credits
365: -- This procedure is an overlay of the standard Unearn_Revenue
366: -- API which does not write out NOCOPY a revenue adjustment record or
367: -- entries into ra_cust_trx_line_gl_dist. Instead it outputs
368: -- the distributions to a pl/sql table which is passed out NOCOPY to
369: -- the calling routine
370: -----------------------------------------------------------------------
371: PROCEDURE Earn_Revenue

Line 644: /* Bug 4304865: set flag for later storage on ra_cust_trx_line_gl_dist

640: THEN
641: l_revenue_amount := l_revenue_amount * -1;
642: END IF;
643:
644: /* Bug 4304865: set flag for later storage on ra_cust_trx_line_gl_dist
645: if earn/unearn not called from revenue management package */
646: IF NVL(p_rev_adj_rec.source, -99999) <>
647: ar_revenue_management_pvt.c_revenue_management_source
648: THEN

Line 1074: FROM ra_cust_trx_line_gl_dist d

1070: SUM(NVL(s1.revenue_percent_split,0))) <> 0);
1071:
1072: CURSOR c_rev_total IS
1073: SELECT NVL(SUM(d.amount),0)
1074: FROM ra_cust_trx_line_gl_dist d
1075: ,mtl_item_categories mic
1076: ,ra_customer_trx_lines l
1077: WHERE d.customer_trx_line_id = l.customer_trx_line_id
1078: AND d.account_class = 'REV'

Line 1211: FROM ra_cust_trx_line_gl_dist d

1207: -- complete flag for credit memos
1208:
1209: CURSOR c_line_revenue_total IS
1210: SELECT NVL(SUM(d.amount),0)
1211: FROM ra_cust_trx_line_gl_dist d
1212: WHERE d.customer_trx_line_id = l_cust_trx_line_id
1213: AND d.customer_trx_id = AR_RAAPI_UTIL.g_customer_trx_id
1214: AND d.account_set_flag = 'N'
1215: AND d.account_class = 'REV';

Line 1219: FROM ra_cust_trx_line_gl_dist d,

1215: AND d.account_class = 'REV';
1216:
1217: CURSOR c_cm_line_revenue_total IS
1218: SELECT NVL(SUM(d.amount),0)
1219: FROM ra_cust_trx_line_gl_dist d,
1220: ra_customer_trx_lines l
1221: WHERE d.customer_trx_line_id = l.customer_trx_line_id
1222: AND d.customer_trx_id = l.customer_trx_id
1223: AND l.previous_customer_trx_line_id = l_cust_trx_line_id

Line 2509: l_cr_account_class ra_cust_trx_line_gl_dist.account_class%TYPE;

2505: l_deferred_revenue_flag VARCHAR2(1);
2506: l_deferred_days NUMBER := 0;
2507: l_gl_date DATE;
2508: l_gl_date_valid DATE; -- Bug 2146970
2509: l_cr_account_class ra_cust_trx_line_gl_dist.account_class%TYPE;
2510: l_revenue_type VARCHAR2(10);
2511: l_gl_date_total NUMBER; -- Bug 2477881
2512: l_gl_date_acctd_total NUMBER; -- Bug 2477881
2513: l_gl_date_pct_total NUMBER; -- Bug 2477881

Line 2796: SELECT /+ ORDERED push_pred(ra.lgd) index(dist ra_cust_trx_line_gl_dist_n1)/

2792: AND fc.currency_code = gsb.currency_code;
2793:
2794: /*Bug 13924828 */
2795: CURSOR c1 is
2796: SELECT /*+ ORDERED push_pred(ra.lgd) index(dist ra_cust_trx_line_gl_dist_n1)*/
2797: ra.customer_trx_line_id, /* customer_trx_line_id */
2798: l.customer_trx_id, /* customer_trx_id */
2799: dist.code_combination_id, /* code_combination_id */
2800: ra.account_class, /* account_class */

Line 2845: ra_cust_trx_line_gl_dist dist,

2841: FROM
2842: ra_customer_trx_lines l,
2843: ra_customer_trx h,
2844: fnd_currencies fc,
2845: ra_cust_trx_line_gl_dist dist,
2846: ra_cust_trx_line_salesreps srep,
2847: ar_revenue_assignments ra
2848: WHERE
2849: l.customer_trx_line_id = p_customer_trx_line_id

Line 2954: INSERT INTO ra_cust_trx_line_gl_dist

2950: arp_util.debug('AR_Revenue_Adjustment_PVT.dists_by_model() ra.ccid' || rec.code_combination_id);
2951: arp_util.debug('AR_Revenue_Adjustment_PVT.dists_by_model() final ccid' || l_ccid);
2952: END IF;
2953:
2954: INSERT INTO ra_cust_trx_line_gl_dist
2955: (
2956: customer_trx_line_id,
2957: customer_trx_id,
2958: code_combination_id,

Line 3004: ra_cust_trx_line_gl_dist_s.NEXTVAL, /* cust_trx_line_gl_dist_id */

3000: sysdate,
3001: arp_standard.profile.user_id,
3002: -3,
3003: rec.gl_date, /* original_gl_date */
3004: ra_cust_trx_line_gl_dist_s.NEXTVAL, /* cust_trx_line_gl_dist_id */
3005: p_adjustment_id,
3006: p_user_generated_flag,
3007: arp_standard.sysparm.org_id);
3008:

Line 3085: l_cr_account_class ra_cust_trx_line_gl_dist.account_class%TYPE;

3081: l_rule_start_date DATE;
3082: l_deferred_revenue_flag VARCHAR2(1);
3083: l_gl_date DATE;
3084: l_gl_date_valid DATE;
3085: l_cr_account_class ra_cust_trx_line_gl_dist.account_class%TYPE;
3086: l_revenue_type VARCHAR2(10);
3087: l_default_rule VARCHAR2(80);
3088: l_err_mesg VARCHAR2(2000);
3089:

Line 3539: l_cr_account_class ra_cust_trx_line_gl_dist.account_class%TYPE;

3535: l_fail_count NUMBER := 0;
3536: l_ext_amount NUMBER := 0;
3537: l_acc_rule_duration NUMBER := 0;
3538: l_gl_date DATE;
3539: l_cr_account_class ra_cust_trx_line_gl_dist.account_class%TYPE;
3540: l_revenue_type VARCHAR2(10);
3541:
3542: l_warehouse_id NUMBER; -- Bug 1930302.
3543:

Line 3906: ra_cust_trx_line_gl_dist gl

3902: NVL(sum(gl.amount),0) amount,
3903: NVL(sum(gl.acctd_amount),0) acctd_amount,
3904: NVL(sum(gl.percent),0) percent
3905: FROM ra_customer_trx_lines l,
3906: ra_cust_trx_line_gl_dist gl
3907: WHERE l.customer_trx_line_id = p_customer_trx_line_id
3908: AND l.customer_trx_id = p_customer_trx_id
3909: AND l.line_type = 'LINE'
3910: AND l.customer_trx_line_id = gl.customer_trx_line_id (+)

Line 4204: FROM ra_cust_trx_line_gl_dist d

4200: invalid_lines EXCEPTION;
4201:
4202: CURSOR c_lines_from_total IS
4203: SELECT NVL(SUM(d.amount),0)
4204: FROM ra_cust_trx_line_gl_dist d
4205: ,mtl_item_categories mic
4206: ,ra_customer_trx_lines l
4207: WHERE d.customer_trx_line_id = l.customer_trx_line_id
4208: AND d.account_class = 'REV'

Line 4233: FROM ra_cust_trx_line_gl_dist d

4229: ,l.memo_line_id
4230: ,l.inventory_item_id
4231: ,l.accounting_rule_id
4232: ,NVL(SUM(d.amount),0) amount
4233: FROM ra_cust_trx_line_gl_dist d
4234: ,mtl_item_categories mic
4235: ,ra_customer_trx_lines l
4236: WHERE d.customer_trx_line_id = l.customer_trx_line_id
4237: AND d.account_class = 'REV'

Line 4293: FROM ra_cust_trx_line_gl_dist d

4289: AND mic.category_set_id(+) = AR_RAAPI_UTIL.g_category_set_id;
4290:
4291: CURSOR c_lines_to_total IS
4292: SELECT NVL(SUM(d.amount),0) amount
4293: FROM ra_cust_trx_line_gl_dist d
4294: ,mtl_item_categories mic
4295: ,ra_customer_trx_lines l
4296: WHERE d.customer_trx_line_id = l.customer_trx_line_id
4297: AND d.account_class = 'REV'

Line 4342: FROM ra_cust_trx_line_gl_dist d

4338: ,l.inventory_item_id
4339: ,l.accounting_rule_id
4340: ,l.accounting_rule_duration
4341: ,SUM(d.amount) amount
4342: FROM ra_cust_trx_line_gl_dist d
4343: ,mtl_item_categories mic
4344: ,ra_customer_trx_lines l
4345: WHERE d.customer_trx_line_id = l.customer_trx_line_id
4346: AND d.account_class = 'REV'

Line 4738: FROM ra_cust_trx_line_gl_dist

4734: l_percent_total NUMBER;
4735:
4736: CURSOR c_total IS
4737: SELECT NVL(SUM(amount),0)
4738: FROM ra_cust_trx_line_gl_dist
4739: WHERE customer_trx_line_id = p_customer_trx_line_id
4740: AND account_set_flag = 'N'
4741: AND account_class IN ('REV','UNEARN')
4742: AND NVL(amount,0) <> 0;

Line 4746: FROM ra_cust_trx_line_gl_dist

4742: AND NVL(amount,0) <> 0;
4743:
4744: CURSOR c_count IS
4745: SELECT COUNT(*)
4746: FROM ra_cust_trx_line_gl_dist
4747: WHERE customer_trx_line_id = p_customer_trx_line_id
4748: AND account_set_flag = 'N'
4749: AND NVL(amount,0) <> 0;
4750:

Line 4753: FROM ra_cust_trx_line_gl_dist

4749: AND NVL(amount,0) <> 0;
4750:
4751: CURSOR c_dist_lines IS
4752: SELECT rowid, amount
4753: FROM ra_cust_trx_line_gl_dist
4754: WHERE customer_trx_line_id = p_customer_trx_line_id
4755: AND account_set_flag = 'N'
4756: AND NVL(amount,0) <> 0;
4757:

Line 4779: UPDATE ra_cust_trx_line_gl_dist

4775: ELSE
4776: l_percent := ROUND(c1.amount / l_total * 100,4);
4777: l_percent_total := l_percent_total + l_percent;
4778: END IF;
4779: UPDATE ra_cust_trx_line_gl_dist
4780: SET percent = l_percent
4781: WHERE rowid = c1.rowid;
4782: END LOOP;
4783: IF PG_DEBUG in ('Y', 'C') THEN

Line 5206: SELECT ra_cust_trx_line_gl_dist_s.NEXTVAL

5202: END IF;
5203:
5204: IF g_update_db_flag = 'Y'
5205: THEN
5206: SELECT ra_cust_trx_line_gl_dist_s.NEXTVAL
5207: INTO l_dist_id
5208: FROM dual;
5209:
5210: INSERT INTO ra_cust_trx_line_gl_dist

Line 5210: INSERT INTO ra_cust_trx_line_gl_dist

5206: SELECT ra_cust_trx_line_gl_dist_s.NEXTVAL
5207: INTO l_dist_id
5208: FROM dual;
5209:
5210: INSERT INTO ra_cust_trx_line_gl_dist
5211: (cust_trx_line_gl_dist_id
5212: ,customer_trx_line_id
5213: ,code_combination_id
5214: ,set_of_books_id

Line 5340: SELECT ra_cust_trx_line_gl_dist_s.NEXTVAL

5336: SELECT ra_cust_trx_line_salesreps_s.NEXTVAL
5337: FROM dual;
5338:
5339: CURSOR get_gldist_line_id IS
5340: SELECT ra_cust_trx_line_gl_dist_s.NEXTVAL
5341: FROM dual;
5342:
5343: l_user_id NUMBER;
5344: l_account_class ra_cust_trx_line_gl_dist_all.account_class%TYPE;

Line 5344: l_account_class ra_cust_trx_line_gl_dist_all.account_class%TYPE;

5340: SELECT ra_cust_trx_line_gl_dist_s.NEXTVAL
5341: FROM dual;
5342:
5343: l_user_id NUMBER;
5344: l_account_class ra_cust_trx_line_gl_dist_all.account_class%TYPE;
5345: l_gl_dist_id ra_cust_trx_line_gl_dist_all.cust_trx_line_gl_dist_id%TYPE;
5346: l_ccid ra_cust_trx_line_gl_dist_all.code_combination_id%TYPE;
5347: l_concat_segments VARCHAR2(2000);
5348: l_fail_count NUMBER := 0;

Line 5345: l_gl_dist_id ra_cust_trx_line_gl_dist_all.cust_trx_line_gl_dist_id%TYPE;

5341: FROM dual;
5342:
5343: l_user_id NUMBER;
5344: l_account_class ra_cust_trx_line_gl_dist_all.account_class%TYPE;
5345: l_gl_dist_id ra_cust_trx_line_gl_dist_all.cust_trx_line_gl_dist_id%TYPE;
5346: l_ccid ra_cust_trx_line_gl_dist_all.code_combination_id%TYPE;
5347: l_concat_segments VARCHAR2(2000);
5348: l_fail_count NUMBER := 0;
5349:

Line 5346: l_ccid ra_cust_trx_line_gl_dist_all.code_combination_id%TYPE;

5342:
5343: l_user_id NUMBER;
5344: l_account_class ra_cust_trx_line_gl_dist_all.account_class%TYPE;
5345: l_gl_dist_id ra_cust_trx_line_gl_dist_all.cust_trx_line_gl_dist_id%TYPE;
5346: l_ccid ra_cust_trx_line_gl_dist_all.code_combination_id%TYPE;
5347: l_concat_segments VARCHAR2(2000);
5348: l_fail_count NUMBER := 0;
5349:
5350: invalid_ccid EXCEPTION;

Line 5493: INSERT INTO ra_cust_trx_line_gl_dist

5489: OPEN get_gldist_line_id;
5490: FETCH get_gldist_line_id INTO l_gl_dist_id;
5491: CLOSE get_gldist_line_id;
5492:
5493: INSERT INTO ra_cust_trx_line_gl_dist
5494: (
5495: customer_trx_line_id,
5496: customer_trx_id,
5497: code_combination_id,

Line 5616: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%TYPE,

5612: (p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE,
5613: p_category_id IN mtl_categories.category_id%TYPE,
5614: p_inventory_item_id IN mtl_system_items.inventory_item_id%TYPE,
5615: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%TYPE,
5616: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%TYPE,
5617: p_comments IN ar_revenue_adjustments.comments%TYPE,
5618: p_ram_desc_flexfield IN ar_revenue_management_pvt.desc_flexfield,
5619: x_scenario OUT NOCOPY NUMBER,
5620: x_first_rev_adj_id OUT NOCOPY ar_revenue_adjustments.revenue_adjustment_id%TYPE,