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_PROCESS_DET_PKG dependencies on RA_CUSTOMER_TRX_LINES

Line 124: | Action : restore the amounts in the ra_customer_trx_lines_gt |

120: +-----------------------------------------------------------------------------+
121: | Parameter : |
122: | p_app_rec variable of type ar_receivable_apps_gt |
123: +-----------------------------------------------------------------------------+
124: | Action : restore the amounts in the ra_customer_trx_lines_gt |
125: +-----------------------------------------------------------------------------*/
126: PROCEDURE res_ctl_rem_amt_for_app
127: (p_app_rec IN ar_receivable_apps_gt%ROWTYPE,
128: x_return_status IN OUT NOCOPY VARCHAR2);

Line 150: | 2) Call res_ctl_rem_amt_for_app to restore the ra_customer_trx_lines_gt |

146: | p_app_rec variable of type ar_receivable_apps_gt |
147: +-----------------------------------------------------------------------------+
148: | Action : |
149: | 1) Call res_inv_ps to restore payment schedule |
150: | 2) Call res_ctl_rem_amt_for_app to restore the ra_customer_trx_lines_gt |
151: | amounts |
152: | 3) Delete the record from ar_receivable_apps_gt |
153: +-----------------------------------------------------------------------------*/
154: PROCEDURE delete_application

Line 301: FROM ra_customer_trx_lines_all ctl,

297: NVL(ctl.link_to_cust_trx_line_id,ctl.customer_trx_line_id),
298: amt_tab.amt,
299: amt_tab.activity_bucket,
300: amt_tab.ref_account_class
301: FROM ra_customer_trx_lines_all ctl,
302: (select SUM(NVL(ard.amount_cr,0) - NVL(ard.amount_dr,0)) amt,
303: ard.activity_bucket activity_bucket,
304: ard.ref_account_class ref_account_class,
305: ard.ref_customer_trx_line_id ref_customer_trx_line_id

Line 401: FROM ra_customer_trx_lines_gt ctl,

397: ctl.source_data_key2,
398: ctl.source_data_key3,
399: ctl.source_data_key4,
400: ctl.source_data_key5
401: FROM ra_customer_trx_lines_gt ctl,
402: (select SUM(NVL(ard.amount_cr,0) - NVL(ard.amount_dr,0)) amt,
403: ard.activity_bucket activity_bucket,
404: ard.ref_account_class ref_account_class,
405: ard.ref_customer_trx_line_id ref_customer_trx_line_id

Line 495: FROM ra_customer_trx_lines_gt ctl,

491: ctl.source_data_key2,
492: ctl.source_data_key3,
493: ctl.source_data_key4,
494: ctl.source_data_key5
495: FROM ra_customer_trx_lines_gt ctl,
496: (select SUM(NVL(ard.amount_cr,0) - NVL(ard.amount_dr,0)) amt,
497: ard.activity_bucket activity_bucket,
498: ard.ref_account_class ref_account_class,
499: ard.ref_customer_trx_line_id ref_customer_trx_line_id

Line 834: FROM ra_customer_trx_lines

830: due_remaining as negative,to let the LLCA go threw for these lines we will
831: make use of AMOUNT_DUE_REMAINING sign.Ref bug 7307197 */
832: SELECT nvl(AMOUNT_DUE_REMAINING,AMOUNT_DUE_ORIGINAL)
833: INTO l_amount_due_original
834: FROM ra_customer_trx_lines
835: WHERE customer_trx_line_id = p_ctl_id;
836:
837: IF (sign(l_line_applied) <> sign(l_amount_due_original)
838: AND l_line_applied <> 0)

Line 1272: | Action : restore the amounts in the ra_customer_trx_lines_gt |

1268: +-----------------------------------------------------------------------------+
1269: | Parameter : |
1270: | p_app_rec variable of type ar_receivable_apps_gt |
1271: +-----------------------------------------------------------------------------+
1272: | Action : restore the amounts in the ra_customer_trx_lines_gt |
1273: +-----------------------------------------------------------------------------*/
1274: PROCEDURE res_ctl_rem_amt_for_app
1275: (p_app_rec IN ar_receivable_apps_gt%ROWTYPE,
1276: x_return_status IN OUT NOCOPY VARCHAR2)

Line 1337: ra_customer_trx_lines_gt c

1333: OVER (PARTITION BY b.ref_customer_trx_line_id), -- FOR ACCTD FREIGHT
1334: b.REF_CUSTOMER_TRX_LINE_ID,
1335: c.line_type
1336: FROM AR_LINE_APP_DETAIL_GT b,
1337: ra_customer_trx_lines_gt c
1338: WHERE b.gt_id = p_app_rec.gt_id
1339: AND b.app_level = p_app_rec.app_level
1340: AND b.REF_CUSTOMER_TRX_LINE_ID = c.customer_trx_line_id;
1341:

Line 1384: UPDATE ra_customer_trx_lines_gt

1380: EXIT;
1381: END IF;
1382:
1383: FORALL i IN l_ctl_id_tab.FIRST .. l_ctl_id_tab.LAST
1384: UPDATE ra_customer_trx_lines_gt
1385: SET AMOUNT_DUE_REMAINING =
1386: DECODE(l_line_type_tab(i),
1387: 'LINE', AMOUNT_DUE_REMAINING + l_rev_amt_rem_tab(i),
1388: 'FREIGHT',AMOUNT_DUE_REMAINING + l_frt_amt_rem_tab(i),

Line 1494: | 2) Call res_ctl_rem_amt_for_app to restore the ra_customer_trx_lines_gt |

1490: | p_app_rec variable of type ar_receivable_apps_gt |
1491: +-----------------------------------------------------------------------------+
1492: | Action : |
1493: | 1) Call res_inv_ps to restore payment schedule |
1494: | 2) Call res_ctl_rem_amt_for_app to restore the ra_customer_trx_lines_gt |
1495: | amounts |
1496: | 3) Delete the record from ar_receivable_apps_gt |
1497: +-----------------------------------------------------------------------------*/
1498: PROCEDURE delete_application

Line 1799: | 1) Call arp_det_dist_pkg to copy trx line into ra_customer_trx_lines_gt |

1795: | p_customer_trx_id invoice ID |
1796: | p_cash_receipt_id receipt ID |
1797: +-----------------------------------------------------------------------------+
1798: | Action : |
1799: | 1) Call arp_det_dist_pkg to copy trx line into ra_customer_trx_lines_gt |
1800: | 2) Call get_inv_ps to cache the invoice payment schedule |
1801: +-----------------------------------------------------------------------------*/
1802: PROCEDURE initialization
1803: (p_customer_trx_id IN NUMBER,

Line 1868: FROM ra_customer_trx_lines ctl

1864: AND ctlgd.account_class = 'REC';
1865:
1866: CURSOR c1 IS
1867: SELECT ctl.customer_trx_id
1868: FROM ra_customer_trx_lines ctl
1869: WHERE ctl.customer_trx_id = p_customer_trx_id
1870: AND ctl.autorule_complete_flag||'' = 'N'
1871: GROUP BY ctl.customer_trx_id;
1872:

Line 2644: DELETE FROM ra_customer_trx_lines_gt WHERE customer_trx_id = g_customer_trx.customer_trx_id;

2640: x_ra_rec.trans_to_receipt_rate := p_trans_to_receipt_rate;
2641: x_ra_rec.acctd_amount_applied_from := x_acctd_amount_applied_from;
2642: x_ra_rec.acctd_amount_applied_to := x_acctd_amount_applied_to; /* Bug 5189370 */
2643: --}
2644: DELETE FROM ra_customer_trx_lines_gt WHERE customer_trx_id = g_customer_trx.customer_trx_id;
2645: g_payschedule_trx := g_payschedule_clr;
2646: g_payschedule_rec := g_payschedule_clr;
2647:
2648: DELETE FROM ra_ar_gt WHERE gt_id = TO_CHAR(USERENV('SESSIONID'));

Line 2688: | Read the remaining amount on ra_customer_trx_lines_gt |

2684: | x_freight_rem The remaining freight amount for the level TRANSACTION only|
2685: | x_charges_rem The remaining charges amount for the level TRANSACTION only|
2686: +-----------------------------------------------------------------------------+
2687: | Action : |
2688: | Read the remaining amount on ra_customer_trx_lines_gt |
2689: +-----------------------------------------------------------------------------*/
2690: PROCEDURE get_latest_amount_remaining
2691: (p_app_level IN VARCHAR2 DEFAULT 'TRANSACTION',
2692: p_source_data_key1 IN VARCHAR2 DEFAULT NULL,

Line 2712: FROM ra_customer_trx_lines_gt

2708: SUM(DECODE(line_type,'TAX' ,NVL(AMOUNT_DUE_REMAINING,0))) tax_rem,
2709: SUM(DECODE(line_type,'LINE',NVL(CHRG_AMOUNT_REMAINING,0))) chrg_rem,
2710: SUM(DECODE(line_type,'LINE',NVL(FRT_ADJ_REMAINING,0))) +
2711: SUM(DECODE(line_type,'FREIGHT',NVL(AMOUNT_DUE_REMAINING,0))) frt_rem
2712: FROM ra_customer_trx_lines_gt
2713: WHERE CUSTOMER_TRX_ID = g_customer_trx.customer_trx_id;
2714:
2715: CURSOR c_line IS
2716: SELECT SUM(DECODE(line_type,'LINE',NVL(AMOUNT_DUE_REMAINING,0))) line_rem,

Line 2721: FROM ra_customer_trx_lines_gt

2717: SUM(DECODE(line_type,'TAX' ,NVL(AMOUNT_DUE_REMAINING,0))) tax_rem,
2718: SUM(DECODE(line_type,'LINE',NVL(CHRG_AMOUNT_REMAINING,0))) chrg_rem,
2719: SUM(DECODE(line_type,'LINE',NVL(FRT_ADJ_REMAINING,0))) +
2720: SUM(DECODE(line_type,'FREIGHT',NVL(AMOUNT_DUE_REMAINING,0))) frt_rem
2721: FROM ra_customer_trx_lines_gt
2722: WHERE CUSTOMER_TRX_ID = g_customer_trx.customer_trx_id
2723: AND DECODE(line_type,'LINE',customer_trx_line_id, LINK_TO_CUST_TRX_LINE_ID) = p_ctl_id;
2724:
2725: CURSOR c_gp IS

Line 2731: FROM ra_customer_trx_lines_gt

2727: SUM(DECODE(line_type,'TAX' ,NVL(AMOUNT_DUE_REMAINING,0))) tax_rem,
2728: SUM(DECODE(line_type,'LINE',NVL(CHRG_AMOUNT_REMAINING,0))) chrg_rem,
2729: SUM(DECODE(line_type,'LINE',NVL(FRT_ADJ_REMAINING,0))) +
2730: SUM(DECODE(line_type,'FREIGHT',NVL(AMOUNT_DUE_REMAINING,0))) frt_rem
2731: FROM ra_customer_trx_lines_gt
2732: WHERE CUSTOMER_TRX_ID = g_customer_trx.customer_trx_id
2733: AND source_data_key1 = NVL(p_source_data_key1,'00')
2734: AND source_data_key2 = NVL(p_source_data_key2,'00')
2735: AND source_data_key3 = NVL(p_source_data_key3,'00')

Line 2880: FROM ra_customer_trx_lines_gt

2876: WHERE CTL_ID = p_ctl_id;
2877:
2878: CURSOR cu_line IS
2879: SELECT DECODE(line_type,'LINE','OK',line_type)
2880: FROM ra_customer_trx_lines_gt
2881: WHERE customer_trx_line_id = p_ctl_id;
2882:
2883: l_line_app NUMBER := 0;
2884: l_tax_app NUMBER := 0;