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.

[Home] [Help]

APPS.ARP_PROCESS_LOCKBOX dependencies on AR_PMTS_INTERFACE_HEADER_GT

Line 2112: FROM ar_pmts_interface_header_gt

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

Line 2271: INSERT INTO ar_pmts_interface_header_gt

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

Line 2308: INSERT INTO ar_pmts_interface_header_gt

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

Line 2345: INSERT INTO ar_pmts_interface_header_gt

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

Line 2382: INSERT INTO ar_pmts_interface_header_gt

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

Line 2419: INSERT INTO ar_pmts_interface_header_gt

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

Line 2456: INSERT INTO ar_pmts_interface_header_gt

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

Line 2493: INSERT INTO ar_pmts_interface_header_gt

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

Line 2530: INSERT INTO ar_pmts_interface_header_gt

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

Line 2570: FROM ar_pmts_interface_header_gt

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

Line 2611: UPDATE ar_pmts_interface_header_gt gt

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

Line 2618: FROM ar_pmts_interface_header_gt

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

Line 2624: /*UPDATE ar_pmts_interface_header_gt gt

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

Line 2633: FROM ar_pmts_interface_header_gt header

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

Line 2665: FROM ar_pmts_interface_header_gt

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

Line 2690: ar_pmts_interface_header_gt header

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

Line 2705: ar_pmts_interface_header_gt header

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

Line 2721: FROM ar_pmts_interface_header_gt

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

Line 2816: UPDATE ar_pmts_interface_header_gt header

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

Line 2836: FROM ar_pmts_interface_header_gt

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

Line 2845: FROM ar_pmts_interface_header_gt

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

Line 2869: UPDATE ar_pmts_interface_header_gt

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

Line 2977: UPDATE ar_pmts_interface_header_gt

2973: AND transmission_record_id = cur_var.transmission_record_id
2974: AND invoice_number = l_invoice_number;
2975:
2976: IF SQL%ROWCOUNT = tot_app_count THEN
2977: UPDATE ar_pmts_interface_header_gt
2978: SET default_by = 'AMT_APP'
2979: WHERE transmission_record_id = cur_var.transmission_record_id
2980: AND invoice_number = l_invoice_number
2981: AND default_by <> 'LINE_AMT';

Line 3087: from ar_pmts_interface_header_gt header,

3083: SET status = 'AR_PLB_AMT_APP_INVALID'
3084: WHERE transmission_request_id = p_trans_req_id
3085: AND (transmission_record_id, customer_trx_id) IN
3086: (select header.transmission_record_id, header.customer_trx_id
3087: from ar_pmts_interface_header_gt header,
3088: (select transmission_record_id,
3089: customer_trx_id,
3090: sum(amount_applied) aa
3091: from ar_pmts_interface_line_details ld

Line 3105: from ar_pmts_interface_header_gt header,

3101: SET status = 'AR_PLB_AMT_APP_FRM_INVALID'
3102: WHERE transmission_request_id = p_trans_req_id
3103: AND (transmission_record_id, customer_trx_id) IN
3104: (select header.transmission_record_id, header.customer_trx_id
3105: from ar_pmts_interface_header_gt header,
3106: (select transmission_record_id,
3107: customer_trx_id,
3108: sum(allocated_receipt_amount) aa
3109: from ar_pmts_interface_line_details ld

Line 3581: FROM ar_pmts_interface_header_gt

3577: SELECT invoice_currency_code,
3578: trans_to_receipt_rate
3579: INTO l_inv_currency_code,
3580: l_trans_to_receipt_rate
3581: FROM ar_pmts_interface_header_gt
3582: WHERE customer_trx_id = p_customer_trx_id
3583: AND transmission_request_id = p_trans_req_id
3584: AND rownum = 1;
3585: