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_MANAGEMENT_PVT dependencies on AR_DEFERRED_LINES

Line 517: FROM ar_deferred_lines dl,

513: max(dl.acctd_amount_pending),
514: 'PARENT',
515: max(interface_line_attribute6),
516: l_request_id
517: FROM ar_deferred_lines dl,
518: ar_line_conts lc,
519: ar_deferral_reasons dr,
520: ra_customer_trx_lines ctl
521: WHERE dl.customer_trx_line_id = lc.customer_trx_line_id

Line 565: FROM ar_deferred_lines dl,

561: max(dl.acctd_amount_pending),
562: 'PARENT',
563: max(interface_line_attribute6),
564: l_request_id
565: FROM ar_deferred_lines dl,
566: ar_line_conts lc,
567: ar_deferral_reasons dr,
568: ra_customer_trx_lines ctl
569: WHERE dl.customer_trx_line_id = lc.customer_trx_line_id

Line 645: FROM ar_deferred_lines dl,

641: dl.acctd_amount_pending,
642: 'PARENT',
643: interface_line_attribute6,
644: l_request_id
645: FROM ar_deferred_lines dl,
646: ra_customer_trx_lines ctl
647: WHERE dl.customer_trx_line_id = ctl.customer_trx_line_id
648: AND dl.customer_trx_id = nvl(p_customer_trx_id, dl.customer_trx_id)
649: AND dl.customer_trx_line_id = nvl(p_customer_trx_line_id,

Line 736: ar_deferred_lines child,

732: child_line.interface_line_attribute6,
733: max(lc.expiration_date)
734: FROM ar_reviewed_lines_gt parent,
735: ra_customer_trx_lines parent_line,
736: ar_deferred_lines child,
737: ra_customer_trx_lines child_line,
738: ar_line_conts lc,
739: ar_deferral_reasons dr
740: WHERE parent.customer_trx_id = parent_line.customer_trx_id

Line 823: FROM ar_deferred_lines dl,

819: max(acctd_amount_pending),
820: 'OTHERS',
821: l_request_id,
822: max(lc.expiration_date)
823: FROM ar_deferred_lines dl,
824: ar_line_conts lc,
825: ar_deferral_reasons dr
826: WHERE dl.customer_trx_line_id = lc.customer_trx_line_id
827: AND lc.contingency_id = dr.contingency_id

Line 869: FROM ar_deferred_lines dl,

865: max(amount_pending),
866: max(acctd_amount_pending),
867: 'UPDATE',
868: l_request_id
869: FROM ar_deferred_lines dl,
870: ar_line_conts lc,
871: ar_deferral_reasons dr
872: WHERE dl.customer_trx_line_id = lc.customer_trx_line_id
873: AND lc.contingency_id = dr.contingency_id

Line 2023: INSERT INTO ar_deferred_lines

2019: -- there exists a row in the child table.
2020:
2021: IF (g_source = 'AR_INVOICE_API') THEN
2022:
2023: INSERT INTO ar_deferred_lines
2024: (
2025: customer_trx_line_id,
2026: customer_trx_id,
2027: original_collectibility_flag,

Line 2115: INSERT INTO ar_deferred_lines

2111: -- not passed through the GT. The reason we can't do this with one SQL
2112: -- is because we would like to copy the values passed in the attributes
2113: -- columns.
2114:
2115: INSERT INTO ar_deferred_lines
2116: (
2117: customer_trx_line_id,
2118: customer_trx_id,
2119: original_collectibility_flag,

Line 2167: FROM ar_deferred_lines dl

2163: AND tlg.customer_trx_id = thg.customer_trx_id
2164: AND tlg.customer_trx_line_id = lrc.customer_trx_line_id
2165: AND NOT EXISTS
2166: (SELECT 'line already inserted'
2167: FROM ar_deferred_lines dl
2168: WHERE dl.customer_trx_line_id = lrc.customer_trx_line_id)
2169: GROUP BY tlg.customer_trx_line_id, thg.org_id;
2170:
2171: ELSE

Line 2173: INSERT INTO ar_deferred_lines

2169: GROUP BY tlg.customer_trx_line_id, thg.org_id;
2170:
2171: ELSE
2172: IF p_request_id IS NOT NULL THEN
2173: INSERT INTO ar_deferred_lines
2174: (
2175: customer_trx_line_id,
2176: customer_trx_id,
2177: original_collectibility_flag,

Line 2272: INSERT INTO ar_deferred_lines

2268: /* 5279702 - Populate parent_line_id when possible. This
2269: is important for contingencies defaulted to child lines
2270: from parents. */
2271:
2272: INSERT INTO ar_deferred_lines
2273: (
2274: customer_trx_line_id,
2275: customer_trx_id,
2276: original_collectibility_flag,

Line 2328: FROM ar_deferred_lines dl

2324: AND ctl.customer_trx_line_id = lrc.customer_trx_line_id
2325: AND ctl.customer_trx_line_id = il.interface_line_id (+)
2326: AND NOT EXISTS
2327: (SELECT 'line already inserted'
2328: FROM ar_deferred_lines dl
2329: WHERE dl.customer_trx_line_id = lrc.customer_trx_line_id)
2330: GROUP BY ctl.customer_trx_line_id, ct.org_id;
2331:
2332: END IF;

Line 2338: -- the a row in the ar_deferred_lines_all, however, we need to mark

2334: debug('deferred lines inserted: ' || SQL%ROWCOUNT);
2335:
2336: -- it is possible that the line gets imported with one pre-billing
2337: -- acceptance contingency. In that case, we would like to insert
2338: -- the a row in the ar_deferred_lines_all, however, we need to mark
2339: -- it as collectible now.
2340:
2341: IF p_request_id IS NOT NULL THEN
2342: UPDATE ar_deferred_lines dl

Line 2342: UPDATE ar_deferred_lines dl

2338: -- the a row in the ar_deferred_lines_all, however, we need to mark
2339: -- it as collectible now.
2340:
2341: IF p_request_id IS NOT NULL THEN
2342: UPDATE ar_deferred_lines dl
2343: SET line_collectible_flag = 'Y'
2344: WHERE dl.request_id = p_request_id
2345: AND NOT EXISTS
2346: (SELECT 'incomplete contingency'

Line 2352: UPDATE ar_deferred_lines dl

2348: WHERE request_id = p_request_id
2349: AND lc.customer_trx_line_id = dl.customer_trx_line_id
2350: AND lc.completed_flag = 'N');
2351: ELSIF p_customer_trx_line_id IS NOT NULL THEN
2352: UPDATE ar_deferred_lines dl
2353: SET line_collectible_flag = 'Y'
2354: WHERE dl.customer_trx_line_id = p_customer_trx_line_id
2355: AND NOT EXISTS
2356: (SELECT 'incomplete contingency'

Line 2678: -- ar_deferred_lines table. It will only update columns

2674:
2675: BEGIN
2676:
2677: -- This procedure simply updates a row of data in the
2678: -- ar_deferred_lines table. It will only update columns
2679: -- for which data is provided, the rest will retain their
2680: -- original values.
2681:
2682: IF pg_debug IN ('Y', 'C') THEN

Line 2704: UPDATE ar_deferred_lines

2700: IF pg_debug IN ('Y', 'C') THEN
2701: arp_standard.debug('p_customer_trx_line_id IS NULL');
2702: END IF;
2703:
2704: UPDATE ar_deferred_lines
2705: SET line_collectible_flag = nvl(l_line_collectible,
2706: line_collectible_flag),
2707: manual_override_flag = nvl(p_manual_override,
2708: manual_override_flag),

Line 2720: UPDATE ar_deferred_lines

2716: IF pg_debug IN ('Y', 'C') THEN
2717: arp_standard.debug('p_customer_trx_line_id IS NOT NULL');
2718: END IF;
2719:
2720: UPDATE ar_deferred_lines
2721: SET line_collectible_flag = nvl(l_line_collectible,
2722: line_collectible_flag),
2723: manual_override_flag = nvl(p_manual_override,
2724: manual_override_flag),

Line 2883: FROM ar_deferred_lines

2879: -- was analyzed by the revenue management engine.
2880:
2881: CURSOR monitored_txn IS
2882: SELECT 1
2883: FROM ar_deferred_lines
2884: WHERE customer_trx_id = p_customer_trx_id
2885: AND manual_override_flag = 'N'
2886: AND line_collectible_flag = 'N';
2887:

Line 2951: -- ar_deferred_lines table to indicate that this line or transction

2947: BEGIN
2948:
2949: --------------------------------------------------------------------------
2950: -- This procedure updates the manual_oveeride column in the
2951: -- ar_deferred_lines table to indicate that this line or transction
2952: -- has been manually manipulated by user in the RAM screens. As a result
2953: -- of this update, the revenue management engine will not keep track of
2954: -- this line anymore.
2955: ---------------------------------------------------------------------------

Line 3288: -- Hence update ar_deferred_lines table by taking out the

3284: ------------------------------------------------------------------------
3285: -- There must have been some credit memos that were applied
3286: -- to this invoice. So, we can not recognize the computed
3287: -- amount, instead we should recognize only adjustable amount.
3288: -- Hence update ar_deferred_lines table by taking out the
3289: -- initial amount and then adding the adjustable amount.
3290: -----------------------------------------------------------------------
3291:
3292: IF pg_debug IN ('Y', 'C') THEN

Line 3306: UPDATE ar_deferred_lines

3302: /* 6008164 - This code actually causes amount_recognized to
3303: be incorrect for inv+adj+rec case. In my case, the amounts
3304: were 100 - 102.61 + 100 = 97.39 when the rev_adj should have been
3305: for $100. So I think l_rev_adj_rec.amount is wrong */
3306: UPDATE ar_deferred_lines
3307: SET amount_recognized = amount_recognized -
3308: l_rev_adj_rec.amount +
3309: l_adjustable_amount,
3310: acctd_amount_recognized = acctd_amount_recognized -

Line 3651: FROM ar_deferred_lines

3647: -- to an invoice.
3648:
3649: CURSOR total_app IS
3650: SELECT sum(amount_recognized) + sum(amount_pending)
3651: FROM ar_deferred_lines
3652: WHERE customer_trx_id = p_customer_trx_id;
3653:
3654: l_total_application ar_deferred_lines.amount_recognized%TYPE;
3655:

Line 3654: l_total_application ar_deferred_lines.amount_recognized%TYPE;

3650: SELECT sum(amount_recognized) + sum(amount_pending)
3651: FROM ar_deferred_lines
3652: WHERE customer_trx_id = p_customer_trx_id;
3653:
3654: l_total_application ar_deferred_lines.amount_recognized%TYPE;
3655:
3656: BEGIN
3657:
3658: -- This functions gets total receipt amount applied against

Line 3705: FROM ar_deferred_lines

3701: -- to an invoice in functional currency.
3702:
3703: CURSOR acctd_total_app IS
3704: SELECT sum(acctd_amount_recognized) + sum(acctd_amount_pending)
3705: FROM ar_deferred_lines
3706: WHERE customer_trx_id = p_customer_trx_id;
3707:
3708: l_acctd_total_application ar_deferred_lines.amount_recognized%TYPE;
3709:

Line 3708: l_acctd_total_application ar_deferred_lines.amount_recognized%TYPE;

3704: SELECT sum(acctd_amount_recognized) + sum(acctd_amount_pending)
3705: FROM ar_deferred_lines
3706: WHERE customer_trx_id = p_customer_trx_id;
3707:
3708: l_acctd_total_application ar_deferred_lines.amount_recognized%TYPE;
3709:
3710: BEGIN
3711:
3712: -- This functions gets total accounted amount receipt amount applied against

Line 3762: l_total_amount ar_deferred_lines.amount_recognized%TYPE;

3758: p_running_lines_balance IN OUT NOCOPY NUMBER,
3759: p_running_allocated_balance IN OUT NOCOPY NUMBER)
3760: RETURN NUMBER IS
3761:
3762: l_total_amount ar_deferred_lines.amount_recognized%TYPE;
3763: l_computed_line_amount ra_customer_trx_lines.extended_amount%TYPE;
3764:
3765: BEGIN
3766:

Line 4279: -- ar_deferred_lines table. It will only update columns

4275:
4276: BEGIN
4277:
4278: -- This procedure simply updates a row of data in the
4279: -- ar_deferred_lines table. It will only update columns
4280: -- for which data is provided, the rest will retain their
4281: -- original values.
4282:
4283: IF pg_debug IN ('Y', 'C') THEN

Line 4362: -- ar_deferred_lines table. It will only delete columns

4358:
4359: BEGIN
4360:
4361: -- This procedure simply deletes a row of data in the
4362: -- ar_deferred_lines table. It will only delete columns
4363: -- for which data is provided, the rest will retain their
4364: -- original values.
4365:
4366: IF pg_debug IN ('Y', 'C') THEN

Line 4508: FROM ar_deferred_lines

4504: -- It does not recompute, but simply looks it up.
4505:
4506: CURSOR c IS
4507: SELECT line_collectible_flag
4508: FROM ar_deferred_lines
4509: WHERE customer_trx_id = p_customer_trx_id
4510: AND customer_trx_line_id = p_customer_trx_line_id;
4511:
4512: l_flag ar_deferred_lines.line_collectible_flag%TYPE;

Line 4512: l_flag ar_deferred_lines.line_collectible_flag%TYPE;

4508: FROM ar_deferred_lines
4509: WHERE customer_trx_id = p_customer_trx_id
4510: AND customer_trx_line_id = p_customer_trx_line_id;
4511:
4512: l_flag ar_deferred_lines.line_collectible_flag%TYPE;
4513: l_return_value NUMBER;
4514:
4515: BEGIN
4516:

Line 4598: FROM ar_deferred_lines

4594: -- It does not recompute, but simply looks it up.
4595:
4596: CURSOR c IS
4597: SELECT 1
4598: FROM ar_deferred_lines
4599: WHERE customer_trx_id = p_customer_trx_id
4600: AND original_collectibility_flag = 'N'
4601: AND manual_override_flag = 'N'
4602: AND rownum = 1;

Line 4681: DELETE FROM ar_deferred_lines

4677: arp_standard.debug('** delete_failed_rows parameters **');
4678: arp_standard.debug(' p_request_id : ' || p_request_id);
4679: END IF;
4680:
4681: DELETE FROM ar_deferred_lines
4682: WHERE request_id = p_request_id;
4683:
4684: DELETE FROM ar_line_conts
4685: WHERE request_id = p_request_id;

Line 4762: FROM ar_deferred_lines

4758: FROM ar_line_conts
4759: WHERE customer_trx_line_id IN
4760: (
4761: SELECT customer_trx_line_id
4762: FROM ar_deferred_lines
4763: WHERE customer_trx_id IN
4764: (
4765: SELECT DISTINCT il.customer_trx_id
4766: FROM ra_interface_errors ie,

Line 4778: FROM ar_deferred_lines

4774:
4775: -- Now delete from the parent rows
4776:
4777: DELETE
4778: FROM ar_deferred_lines
4779: WHERE customer_trx_id IN
4780: (
4781: SELECT DISTINCT il.customer_trx_id
4782: FROM ra_interface_errors ie,

Line 4846: FROM ar_deferred_lines dl,

4842: -- for this transaction or line
4843:
4844: CURSOR contingencies IS
4845: SELECT 1
4846: FROM ar_deferred_lines dl,
4847: ar_line_conts lc,
4848: ar_deferral_reasons dl
4849: WHERE dl.customer_trx_line_id = lc.customer_trx_line_id
4850: AND lc.contingency_id = dl.contingency_id

Line 4959: FROM ar_deferred_lines dl,

4955: RETURN NUMBER IS
4956:
4957: CURSOR contingencies IS
4958: SELECT 1
4959: FROM ar_deferred_lines dl,
4960: ar_line_conts lc,
4961: ar_deferral_reasons dr
4962: WHERE dl.customer_trx_line_id = lc.customer_trx_line_id
4963: AND lc.contingency_id = dr.contingency_id

Line 5067: FROM ar_deferred_lines

5063: amount_recognized,
5064: acctd_amount_recognized,
5065: amount_pending,
5066: acctd_amount_pending
5067: FROM ar_deferred_lines
5068: WHERE customer_trx_line_id = p_cust_trx_line_id;
5069:
5070: BEGIN
5071:

Line 6128: FROM ar_deferred_lines

6124: amount_recognized,
6125: acctd_amount_recognized,
6126: amount_pending,
6127: acctd_amount_pending
6128: FROM ar_deferred_lines
6129: WHERE customer_trx_id = p_trx_id;
6130:
6131:
6132: -- This cursor computes the total balance across lines.

Line 6137: FROM ar_deferred_lines

6133:
6134: CURSOR amounts (p_trx_id NUMBER) IS
6135: SELECT sum(amount_due_original),
6136: sum(acctd_amount_due_original)
6137: FROM ar_deferred_lines
6138: WHERE customer_trx_id = p_trx_id;
6139:
6140: /*-----------------------------------------------------------------------+
6141: | Local Variable Declarations and initializations |

Line 7057: ar_deferred_lines lrs

7053: CURSOR verdicts IS
7054: SELECT ctl.customer_trx_line_id,
7055: decode(lrs.line_collectible_flag, NULL, 1, 'Y', 1, 'N', 0) verdict
7056: FROM ra_customer_trx_lines ctl,
7057: ar_deferred_lines lrs
7058: WHERE ((p_request_id IS NULL AND
7059: p_customer_trx_line_id IS NOT NULL AND
7060: ctl.customer_trx_line_id = p_customer_trx_line_id) OR
7061: (p_request_id IS NOT NULL AND

Line 7110: -- the deferred lines (parent) into ar_deferred_lines_all table.

7106: delete_unwanted_contingencies (p_request_id => p_request_id
7107: ,p_customer_trx_line_id => p_customer_trx_line_id);
7108:
7109: -- now all the contingencies have been inserted we can insert
7110: -- the deferred lines (parent) into ar_deferred_lines_all table.
7111:
7112: insert_deferred_lines (p_request_id => p_request_id
7113: ,p_customer_trx_line_id => p_customer_trx_line_id);
7114: