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 1270: | Action : restore the amounts in the ra_customer_trx_lines_gt |

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

Line 1335: ra_customer_trx_lines_gt c

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

Line 1382: UPDATE ra_customer_trx_lines_gt

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

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

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

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

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

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

2578: x_ra_rec.trans_to_receipt_rate := p_trans_to_receipt_rate;
2579: x_ra_rec.acctd_amount_applied_from := x_acctd_amount_applied_from;
2580: x_ra_rec.acctd_amount_applied_to := x_acctd_amount_applied_to; /* Bug 5189370 */
2581: --}
2582: DELETE FROM ra_customer_trx_lines_gt WHERE customer_trx_id = g_customer_trx.customer_trx_id;
2583: g_payschedule_trx := g_payschedule_clr;
2584: g_payschedule_rec := g_payschedule_clr;
2585:
2586: DELETE FROM ra_ar_gt WHERE gt_id = TO_CHAR(USERENV('SESSIONID'));

Line 2626: | Read the remaining amount on ra_customer_trx_lines_gt |

2622: | x_freight_rem The remaining freight amount for the level TRANSACTION only|
2623: | x_charges_rem The remaining charges amount for the level TRANSACTION only|
2624: +-----------------------------------------------------------------------------+
2625: | Action : |
2626: | Read the remaining amount on ra_customer_trx_lines_gt |
2627: +-----------------------------------------------------------------------------*/
2628: PROCEDURE get_latest_amount_remaining
2629: (p_app_level IN VARCHAR2 DEFAULT 'TRANSACTION',
2630: p_source_data_key1 IN VARCHAR2 DEFAULT NULL,

Line 2650: FROM ra_customer_trx_lines_gt

2646: SUM(DECODE(line_type,'TAX' ,NVL(AMOUNT_DUE_REMAINING,0))) tax_rem,
2647: SUM(DECODE(line_type,'LINE',NVL(CHRG_AMOUNT_REMAINING,0))) chrg_rem,
2648: SUM(DECODE(line_type,'LINE',NVL(FRT_ADJ_REMAINING,0))) +
2649: SUM(DECODE(line_type,'FREIGHT',NVL(AMOUNT_DUE_REMAINING,0))) frt_rem
2650: FROM ra_customer_trx_lines_gt
2651: WHERE CUSTOMER_TRX_ID = g_customer_trx.customer_trx_id;
2652:
2653: CURSOR c_line IS
2654: SELECT SUM(DECODE(line_type,'LINE',NVL(AMOUNT_DUE_REMAINING,0))) line_rem,

Line 2659: FROM ra_customer_trx_lines_gt

2655: SUM(DECODE(line_type,'TAX' ,NVL(AMOUNT_DUE_REMAINING,0))) tax_rem,
2656: SUM(DECODE(line_type,'LINE',NVL(CHRG_AMOUNT_REMAINING,0))) chrg_rem,
2657: SUM(DECODE(line_type,'LINE',NVL(FRT_ADJ_REMAINING,0))) +
2658: SUM(DECODE(line_type,'FREIGHT',NVL(AMOUNT_DUE_REMAINING,0))) frt_rem
2659: FROM ra_customer_trx_lines_gt
2660: WHERE CUSTOMER_TRX_ID = g_customer_trx.customer_trx_id
2661: AND DECODE(line_type,'LINE',customer_trx_line_id, LINK_TO_CUST_TRX_LINE_ID) = p_ctl_id;
2662:
2663: CURSOR c_gp IS

Line 2669: FROM ra_customer_trx_lines_gt

2665: SUM(DECODE(line_type,'TAX' ,NVL(AMOUNT_DUE_REMAINING,0))) tax_rem,
2666: SUM(DECODE(line_type,'LINE',NVL(CHRG_AMOUNT_REMAINING,0))) chrg_rem,
2667: SUM(DECODE(line_type,'LINE',NVL(FRT_ADJ_REMAINING,0))) +
2668: SUM(DECODE(line_type,'FREIGHT',NVL(AMOUNT_DUE_REMAINING,0))) frt_rem
2669: FROM ra_customer_trx_lines_gt
2670: WHERE CUSTOMER_TRX_ID = g_customer_trx.customer_trx_id
2671: AND source_data_key1 = NVL(p_source_data_key1,'00')
2672: AND source_data_key2 = NVL(p_source_data_key2,'00')
2673: AND source_data_key3 = NVL(p_source_data_key3,'00')

Line 2818: FROM ra_customer_trx_lines_gt

2814: WHERE CTL_ID = p_ctl_id;
2815:
2816: CURSOR cu_line IS
2817: SELECT DECODE(line_type,'LINE','OK',line_type)
2818: FROM ra_customer_trx_lines_gt
2819: WHERE customer_trx_line_id = p_ctl_id;
2820:
2821: l_line_app NUMBER := 0;
2822: l_tax_app NUMBER := 0;