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_LOCKBOX dependencies on AR_PMTS_INTERFACE_HEADER_GT

Line 2115: FROM ar_pmts_interface_header_gt

2111: p_return_status OUT NOCOPY varchar2
2112: ) IS
2113: CURSOR customer_trx_cursor(p_trans_request_id IN NUMBER) IS
2114: SELECT DISTINCT customer_trx_id
2115: FROM ar_pmts_interface_header_gt
2116: WHERE transmission_request_id = p_trans_request_id;
2117:
2118: CURSOR apply_to_rec(p_trans_request_id IN NUMBER,
2119: p_customer_trx_id IN NUMBER) IS

Line 2273: INSERT INTO ar_pmts_interface_header_gt

2269: l_trans_record_id,'AMT APP FROM 7');
2270: format_amount_app8 := ARP_PROCESS_LOCKBOX.get_format_amount(p_trans_req_id,
2271: l_trans_record_id,'AMT APP FROM 8');
2272:
2273: INSERT INTO ar_pmts_interface_header_gt
2274: (transmission_request_id,
2275: transmission_record_id,
2276: currency_code,
2277: invoice_number,

Line 2310: INSERT INTO ar_pmts_interface_header_gt

2306: FROM ar_pmts_interface_line_details line_details
2307: WHERE line_details.transmission_record_id = interface.transmission_record_id
2308: AND line_details.invoice_number = interface.invoice1);
2309:
2310: INSERT INTO ar_pmts_interface_header_gt
2311: (transmission_request_id,
2312: transmission_record_id,
2313: currency_code,
2314: invoice_number,

Line 2347: INSERT INTO ar_pmts_interface_header_gt

2343: FROM ar_pmts_interface_line_details line_details
2344: WHERE line_details.transmission_record_id = interface.transmission_record_id
2345: AND line_details.invoice_number = interface.invoice2);
2346:
2347: INSERT INTO ar_pmts_interface_header_gt
2348: (transmission_request_id,
2349: transmission_record_id,
2350: currency_code,
2351: invoice_number,

Line 2384: INSERT INTO ar_pmts_interface_header_gt

2380: FROM ar_pmts_interface_line_details line_details
2381: WHERE line_details.transmission_record_id = interface.transmission_record_id
2382: AND line_details.invoice_number = interface.invoice3);
2383:
2384: INSERT INTO ar_pmts_interface_header_gt
2385: (transmission_request_id,
2386: transmission_record_id,
2387: currency_code,
2388: invoice_number,

Line 2421: INSERT INTO ar_pmts_interface_header_gt

2417: FROM ar_pmts_interface_line_details line_details
2418: WHERE line_details.transmission_record_id = interface.transmission_record_id
2419: AND line_details.invoice_number = interface.invoice4);
2420:
2421: INSERT INTO ar_pmts_interface_header_gt
2422: (transmission_request_id,
2423: transmission_record_id,
2424: currency_code,
2425: invoice_number,

Line 2458: INSERT INTO ar_pmts_interface_header_gt

2454: FROM ar_pmts_interface_line_details line_details
2455: WHERE line_details.transmission_record_id = interface.transmission_record_id
2456: AND line_details.invoice_number = interface.invoice5);
2457:
2458: INSERT INTO ar_pmts_interface_header_gt
2459: (transmission_request_id,
2460: transmission_record_id,
2461: currency_code,
2462: invoice_number,

Line 2495: INSERT INTO ar_pmts_interface_header_gt

2491: FROM ar_pmts_interface_line_details line_details
2492: WHERE line_details.transmission_record_id = interface.transmission_record_id
2493: AND line_details.invoice_number = interface.invoice6);
2494:
2495: INSERT INTO ar_pmts_interface_header_gt
2496: (transmission_request_id,
2497: transmission_record_id,
2498: currency_code,
2499: invoice_number,

Line 2532: INSERT INTO ar_pmts_interface_header_gt

2528: FROM ar_pmts_interface_line_details line_details
2529: WHERE line_details.transmission_record_id = interface.transmission_record_id
2530: AND line_details.invoice_number = interface.invoice7);
2531:
2532: INSERT INTO ar_pmts_interface_header_gt
2533: (transmission_request_id,
2534: transmission_record_id,
2535: currency_code,
2536: invoice_number,

Line 2572: FROM ar_pmts_interface_header_gt

2568:
2569: UPDATE ar_pmts_interface_line_details line_details
2570: SET status = 'AR_PLB_DUP_INVOICE'
2571: WHERE invoice_number IN ( SELECT invoice_number
2572: FROM ar_pmts_interface_header_gt
2573: WHERE transmission_record_id = line_details.transmission_record_id
2574: GROUP BY invoice_number
2575: HAVING count(invoice_number) > 1 )
2576: AND transmission_request_id = p_trans_req_id

Line 2613: UPDATE ar_pmts_interface_header_gt gt

2609: AND amount_applied <> line_amount + tax_amount
2610: AND status = 'AR_PLB_NEW_RECORD'; */
2611:
2612: /* We may need to handle duplicate invoices in future, here */
2613: UPDATE ar_pmts_interface_header_gt gt
2614: SET (customer_trx_id) = ( SELECT customer_trx_id
2615: FROM ra_customer_trx
2616: WHERE trx_number = gt.invoice_number ) ;
2617:

Line 2620: FROM ar_pmts_interface_header_gt

2616: WHERE trx_number = gt.invoice_number ) ;
2617:
2618: UPDATE ar_pmts_interface_line_details ld
2619: SET customer_trx_id = (SELECT customer_trx_id
2620: FROM ar_pmts_interface_header_gt
2621: WHERE invoice_number = ld.invoice_number
2622: AND transmission_record_id = ld.transmission_record_id
2623: )
2624: WHERE transmission_request_id = p_trans_req_id;

Line 2626: /*UPDATE ar_pmts_interface_header_gt gt

2622: AND transmission_record_id = ld.transmission_record_id
2623: )
2624: WHERE transmission_request_id = p_trans_req_id;
2625:
2626: /*UPDATE ar_pmts_interface_header_gt gt
2627: SET precision = get_currency_precision(gt.currency_code),
2628: inv_precision = get_currency_precision(NVL(gt.inv_currency_code, gt.currency_code));*/
2629:
2630: UPDATE ar_pmts_interface_line_details line_details

Line 2635: FROM ar_pmts_interface_header_gt header

2631: SET amount_applied = allocated_receipt_amount
2632: WHERE amount_applied IS NULL
2633: AND allocated_receipt_amount IS NOT NULL
2634: AND invoice_number IN ( SELECT invoice_number
2635: FROM ar_pmts_interface_header_gt header
2636: WHERE header.transmission_record_id = line_details.transmission_record_id
2637: AND header.invoice_number = line_details.invoice_number
2638: AND header.currency_code = header.invoice_currency_code
2639: AND transmission_request_id = p_trans_req_id)

Line 2667: FROM ar_pmts_interface_header_gt

2663: UPDATE ar_pmts_interface_line_details
2664: SET status = 'AR_PLB_BAL_STAMP_FAILED'
2665: WHERE transmission_request_id = p_trans_req_id
2666: AND invoice_number = ( SELECT invoice_number
2667: FROM ar_pmts_interface_header_gt
2668: WHERE transmission_request_id = p_trans_req_id
2669: AND customer_trx_id = cur_var.customer_trx_id);
2670: else
2671: l_customer_trx.customer_trx_id := cur_var.customer_trx_id;

Line 2692: ar_pmts_interface_header_gt header

2688: AND apply_to NOT in ('FREIGHT','CHARGES')
2689: AND NOT EXISTS ( select 'x'
2690: FROM ra_customer_trx trx,
2691: ra_customer_trx_lines lines,
2692: ar_pmts_interface_header_gt header
2693: WHERE trx.customer_trx_id = lines.customer_trx_id
2694: AND header.invoice_number = line_details.invoice_number
2695: AND header.transmission_record_id = line_details.transmission_record_id
2696: AND trx.customer_trx_id = header.customer_trx_id

Line 2707: ar_pmts_interface_header_gt header

2703: AND apply_to IN ('FREIGHT', 'CHARGES')
2704: AND NOT EXISTS ( select 'x'
2705: FROM ra_customer_trx trx,
2706: ra_customer_trx_lines lines,
2707: ar_pmts_interface_header_gt header
2708: WHERE trx.customer_trx_id = lines.customer_trx_id
2709: AND header.invoice_number = line_details.invoice_number
2710: AND header.transmission_record_id = line_details.transmission_record_id
2711: AND trx.customer_trx_id = header.customer_trx_id

Line 2723: FROM ar_pmts_interface_header_gt

2719: INTO l_invoice_number,
2720: l_trans_to_receipt_rate,
2721: l_inv_currency_code,
2722: l_currency_code
2723: FROM ar_pmts_interface_header_gt
2724: WHERE transmission_request_id = p_trans_req_id
2725: AND customer_trx_id = cur_var.customer_trx_id
2726: AND rownum = 1;
2727:

Line 2818: UPDATE ar_pmts_interface_header_gt header

2814: FROM ar_pmts_interface_lines_gt
2815: WHERE charges_remaining = 0
2816: AND apply_to = 'CHARGES' );
2817:
2818: UPDATE ar_pmts_interface_header_gt header
2819: SET default_by = 'LINE_AMT'
2820: WHERE transmission_request_id = p_trans_req_id
2821: AND invoice_number IN (SELECT invoice_number
2822: FROM ar_pmts_interface_line_details

Line 2838: FROM ar_pmts_interface_header_gt

2834: INTO l_inv_currency_code,
2835: l_trans_to_receipt_rate,
2836: l_currency_code,
2837: l_invoice_number
2838: FROM ar_pmts_interface_header_gt
2839: WHERE customer_trx_id = cur_var1.customer_trx_id
2840: AND transmission_request_id = p_trans_req_id
2841: AND rownum = 1;
2842:

Line 2847: FROM ar_pmts_interface_header_gt

2843: l_default_by := NULL;
2844:
2845: SELECT amount_applied, amount_applied_from
2846: INTO hdr_amt_app, hdr_amt_app_frm
2847: FROM ar_pmts_interface_header_gt
2848: WHERE transmission_record_id = cur_var.transmission_record_id
2849: AND invoice_number = l_invoice_number
2850: AND transmission_request_id = p_trans_req_id;
2851:

Line 2871: UPDATE ar_pmts_interface_header_gt

2867: AND transmission_record_id = cur_var.transmission_record_id
2868: AND invoice_number = l_invoice_number;
2869:
2870: IF SQL%ROWCOUNT = tot_app_count THEN
2871: UPDATE ar_pmts_interface_header_gt
2872: SET default_by = 'AMT_APP_FRM'
2873: WHERE transmission_record_id = cur_var.transmission_record_id
2874: AND invoice_number = l_invoice_number;
2875:

Line 2987: UPDATE ar_pmts_interface_header_gt

2983: AND transmission_record_id = cur_var.transmission_record_id
2984: AND invoice_number = l_invoice_number;
2985:
2986: IF SQL%ROWCOUNT = tot_app_count THEN
2987: UPDATE ar_pmts_interface_header_gt
2988: SET default_by = 'AMT_APP'
2989: WHERE transmission_record_id = cur_var.transmission_record_id
2990: AND invoice_number = l_invoice_number
2991: AND default_by <> 'LINE_AMT';

Line 3097: from ar_pmts_interface_header_gt header,

3093: SET status = 'AR_PLB_AMT_APP_INVALID'
3094: WHERE transmission_request_id = p_trans_req_id
3095: AND (transmission_record_id, customer_trx_id) IN
3096: (select header.transmission_record_id, header.customer_trx_id
3097: from ar_pmts_interface_header_gt header,
3098: (select transmission_record_id,
3099: customer_trx_id,
3100: sum(amount_applied) aa
3101: from ar_pmts_interface_line_details ld

Line 3115: from ar_pmts_interface_header_gt header,

3111: SET status = 'AR_PLB_AMT_APP_FRM_INVALID'
3112: WHERE transmission_request_id = p_trans_req_id
3113: AND (transmission_record_id, customer_trx_id) IN
3114: (select header.transmission_record_id, header.customer_trx_id
3115: from ar_pmts_interface_header_gt header,
3116: (select transmission_record_id,
3117: customer_trx_id,
3118: sum(allocated_receipt_amount) aa
3119: from ar_pmts_interface_line_details ld

Line 3600: FROM ar_pmts_interface_header_gt

3596: SELECT invoice_currency_code,
3597: trans_to_receipt_rate
3598: INTO l_inv_currency_code,
3599: l_trans_to_receipt_rate
3600: FROM ar_pmts_interface_header_gt
3601: WHERE customer_trx_id = p_customer_trx_id
3602: AND transmission_request_id = p_trans_req_id
3603: AND rownum = 1;
3604: