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_BF_BILL dependencies on RA_CUSTOMER_TRX

Line 5: TYPE tab_trx_id IS TABLE OF ra_customer_trx.customer_trx_id%TYPE

1: PACKAGE BODY arp_bf_bill AS
2: /* $Header: ARPBFBIB.pls 120.22.12010000.2 2008/10/01 07:04:13 rmanikan ship $ */
3:
4: -- define structure to store data that needs to be overridden
5: TYPE tab_trx_id IS TABLE OF ra_customer_trx.customer_trx_id%TYPE
6: INDEX BY BINARY_INTEGER;
7: TYPE tab_term_id IS TABLE OF ra_customer_trx.term_id%TYPE
8: INDEX BY BINARY_INTEGER;
9: TYPE tab_billing_date IS TABLE OF ra_customer_trx.billing_date%TYPE

Line 7: TYPE tab_term_id IS TABLE OF ra_customer_trx.term_id%TYPE

3:
4: -- define structure to store data that needs to be overridden
5: TYPE tab_trx_id IS TABLE OF ra_customer_trx.customer_trx_id%TYPE
6: INDEX BY BINARY_INTEGER;
7: TYPE tab_term_id IS TABLE OF ra_customer_trx.term_id%TYPE
8: INDEX BY BINARY_INTEGER;
9: TYPE tab_billing_date IS TABLE OF ra_customer_trx.billing_date%TYPE
10: INDEX BY BINARY_INTEGER;
11: TYPE tab_due_date IS TABLE OF ra_customer_trx.term_due_date%TYPE

Line 9: TYPE tab_billing_date IS TABLE OF ra_customer_trx.billing_date%TYPE

5: TYPE tab_trx_id IS TABLE OF ra_customer_trx.customer_trx_id%TYPE
6: INDEX BY BINARY_INTEGER;
7: TYPE tab_term_id IS TABLE OF ra_customer_trx.term_id%TYPE
8: INDEX BY BINARY_INTEGER;
9: TYPE tab_billing_date IS TABLE OF ra_customer_trx.billing_date%TYPE
10: INDEX BY BINARY_INTEGER;
11: TYPE tab_due_date IS TABLE OF ra_customer_trx.term_due_date%TYPE
12: INDEX BY BINARY_INTEGER;
13:

Line 11: TYPE tab_due_date IS TABLE OF ra_customer_trx.term_due_date%TYPE

7: TYPE tab_term_id IS TABLE OF ra_customer_trx.term_id%TYPE
8: INDEX BY BINARY_INTEGER;
9: TYPE tab_billing_date IS TABLE OF ra_customer_trx.billing_date%TYPE
10: INDEX BY BINARY_INTEGER;
11: TYPE tab_due_date IS TABLE OF ra_customer_trx.term_due_date%TYPE
12: INDEX BY BINARY_INTEGER;
13:
14:
15: l_tab_trx_id tab_trx_id;

Line 271: UPDATE ra_customer_trx

267: nvl(P_consinv_num_high, cons_billing_number)
268: AND concurrent_request_id = nvl(P_request_id, concurrent_request_id)
269: AND status = 'DRAFT';
270:
271: UPDATE ra_customer_trx
272: SET printing_original_date =
273: DECODE(printing_count,
274: 1, NULL,
275: printing_original_date),

Line 497: -- update the RA_CUSTOMER_TRX with the new term id, billing date and due date

493: l_tab_due_date(l_tab_idx) := new_due_date;
494:
495: -- Following update statements are moved from generate procedure to here
496: -- for the bug 6488683
497: -- update the RA_CUSTOMER_TRX with the new term id, billing date and due date
498: UPDATE RA_CUSTOMER_TRX
499: SET term_id = new_term_id,
500: billing_date = new_bill_date,
501: term_due_date = new_due_date

Line 498: UPDATE RA_CUSTOMER_TRX

494:
495: -- Following update statements are moved from generate procedure to here
496: -- for the bug 6488683
497: -- update the RA_CUSTOMER_TRX with the new term id, billing date and due date
498: UPDATE RA_CUSTOMER_TRX
499: SET term_id = new_term_id,
500: billing_date = new_bill_date,
501: term_due_date = new_due_date
502: WHERE customer_trx_id = P_trx_id;

Line 670: FROM ra_customer_trx CT,

666: CT.previous_customer_trx_id prev_trx_id,
667: CT.interface_header_attribute1 trx_desc,
668: CT.ship_to_site_use_id ship_id,
669: CT.term_due_date due_date
670: FROM ra_customer_trx CT,
671: ar_payment_schedules PS
672: WHERE PS.customer_site_use_id = C_site_use_id
673: AND PS.cons_inv_id IS NULL
674: AND PS.invoice_currency_code = nvl(C_use_currency, PS.invoice_currency_code)

Line 714: TYPE tab_line_id IS TABLE OF ra_customer_trx_lines_all.link_to_cust_trx_line_id%TYPE;

710:
711: /* Bug 5203710 remove detail_option as limiting criteria */
712: --C_detail_option hz_customer_profiles.cons_inv_type%TYPE;
713:
714: TYPE tab_line_id IS TABLE OF ra_customer_trx_lines_all.link_to_cust_trx_line_id%TYPE;
715: TYPE tab_num IS TABLE OF NUMBER ;
716:
717: l_line_id tab_line_id ;
718: l_tax_sum tab_num ;

Line 727: FROM ra_customer_trx_lines CTL

723: CURSOR c_tax (l_trx_id NUMBER) IS
724: SELECT link_to_cust_trx_line_id,
725: sum(nvl(CTL.extended_amount,0)),
726: sum(decode(amount_includes_tax_flag, 'Y', nvl(CTL.extended_amount,0),0))
727: FROM ra_customer_trx_lines CTL
728: WHERE CTL.customer_trx_id = l_trx_id
729: AND CTL.line_type = 'TAX'
730: GROUP BY link_to_cust_trx_line_id;
731:

Line 1554: FROM ra_customer_trx_lines

1550: nvl (gross_unit_selling_price, unit_selling_price),
1551: nvl (gross_extended_amount, extended_amount),
1552: 0,
1553: org_id
1554: FROM ra_customer_trx_lines
1555: WHERE customer_trx_id = L_inv_trx.trx_id
1556: AND line_type NOT IN ('TAX', 'FREIGHT');
1557:
1558: /** now update lines with associated tax line **/

Line 1609: ra_customer_trx_lines

1605: sum (nvl (gross_extended_amount, extended_amount)),
1606: 0,
1607: org_id
1608: FROM
1609: ra_customer_trx_lines
1610: WHERE
1611: customer_trx_id = L_inv_trx.trx_id
1612: AND line_type = 'FREIGHT'
1613: GROUP BY line_type,org_id;

Line 2314: -- update ra_customer_trx_all with the printing dates for all the transactions included.

2310:
2311: write_debug_and_log('Updating AR_CONS_INV');
2312:
2313: -- 6955957
2314: -- update ra_customer_trx_all with the printing dates for all the transactions included.
2315: UPDATE ra_customer_trx trx
2316: SET printing_original_date = nvl(printing_original_date, SYSDATE),
2317: printing_last_printed = nvl(printing_last_printed, SYSDATE)
2318: WHERE trx.trx_number IN

Line 2315: UPDATE ra_customer_trx trx

2311: write_debug_and_log('Updating AR_CONS_INV');
2312:
2313: -- 6955957
2314: -- update ra_customer_trx_all with the printing dates for all the transactions included.
2315: UPDATE ra_customer_trx trx
2316: SET printing_original_date = nvl(printing_original_date, SYSDATE),
2317: printing_last_printed = nvl(printing_last_printed, SYSDATE)
2318: WHERE trx.trx_number IN
2319: (SELECT trx_number

Line 2383: write_debug_and_log('Override : Updating RA_CUSTOMER_TRX');

2379: -- into ar_cons_inv_trx.
2380: /*
2381: -- Following is the update for all data overridden in TRX table
2382: IF l_tab_idx > 0 THEN
2383: write_debug_and_log('Override : Updating RA_CUSTOMER_TRX');
2384: FORALL i IN 1..l_tab_idx
2385: UPDATE RA_CUSTOMER_TRX
2386: SET term_id = l_tab_term_id(i),
2387: billing_date = l_tab_billing_date(i),

Line 2385: UPDATE RA_CUSTOMER_TRX

2381: -- Following is the update for all data overridden in TRX table
2382: IF l_tab_idx > 0 THEN
2383: write_debug_and_log('Override : Updating RA_CUSTOMER_TRX');
2384: FORALL i IN 1..l_tab_idx
2385: UPDATE RA_CUSTOMER_TRX
2386: SET term_id = l_tab_term_id(i),
2387: billing_date = l_tab_billing_date(i),
2388: term_due_date = l_tab_due_date(i)
2389: WHERE customer_trx_id = l_tab_trx_id(i);

Line 2483: Because ra_customer_trx was not updated after

2479:
2480: BEGIN
2481:
2482: /* bug3604391 Changed the sequence of following update stmts.
2483: Because ra_customer_trx was not updated after
2484: ar_cons_inv.print_status was changed.
2485: */
2486: UPDATE ra_customer_trx CT
2487: SET CT.printing_original_date =

Line 2486: UPDATE ra_customer_trx CT

2482: /* bug3604391 Changed the sequence of following update stmts.
2483: Because ra_customer_trx was not updated after
2484: ar_cons_inv.print_status was changed.
2485: */
2486: UPDATE ra_customer_trx CT
2487: SET CT.printing_original_date =
2488: nvl(CT.printing_original_date,sysdate),
2489: CT.printing_last_printed = sysdate,
2490: CT.printing_count = nvl(CT.printing_count,0) +