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_LOCKBOX_HOOK_PVT dependencies on AR_PAYMENTS_INTERFACE_ALL

Line 430: from ar_payments_interface_all

426: l_customer_id ar_payments_interface.customer_id%type;
427:
428: cursor distinct_item_num( req_id in number ) is
429: select distinct item_number
430: from ar_payments_interface_all
431: where transmission_request_id = req_id;
432:
433: cursor overflow_records( request_id in number,
434: itm_num in number,

Line 437: from ar_payments_interface_all

433: cursor overflow_records( request_id in number,
434: itm_num in number,
435: rec_type in varchar) is
436: select transmission_record_id
437: from ar_payments_interface_all
438: where transmission_request_id = request_id
439: and item_number = itm_num
440: and record_type = rec_type
441: order by transmission_record_id;

Line 464: FROM ar_payments_interface_all

460: amount_applied6,
461: amount_applied7,
462: amount_applied8,
463: batch_name
464: FROM ar_payments_interface_all
465: WHERE transmission_request_id = req_id
466: AND record_type in ( select a.record_identifier from ar_trans_record_formats a, ar_transmissions_all b
467: where b.transmission_request_id = req_id
468: and b.requested_trans_format_id = a.transmission_format_id

Line 778: FROM ar_payments_interface_all

774: invoice5, 5,
775: invoice6, 6,
776: invoice7, 7,
777: invoice8, 8) a
778: FROM ar_payments_interface_all
779: WHERE transmission_request_id = in_trans_req_id
780: AND item_number = l_unres_inv_array(i).item_number
781: AND record_type = l_unres_inv_array(i).record_type
782: AND NVL(batch_name, -1)= NVL(l_unres_inv_array(i).batch_name, -1))

Line 788: ||' FROM ar_payments_interface_all WHERE transmission_request_id = :1'

784:
785: l_sql_stmt := 'SELECT amount_applied_from'||l_resolved_number||', trans_to_receipt_rate'
786: ||l_resolved_number||', invoice_currency_code'||l_resolved_number||', customer_id'
787: ||', amount_applied'||l_resolved_number||', matching'||l_resolved_number||'_date'
788: ||' FROM ar_payments_interface_all WHERE transmission_request_id = :1'
789: ||' AND item_number = :2'
790: ||' AND record_type = :3'
791: ||' AND invoice'||l_resolved_number ||'= :4'
792: ||' AND NVL(batch_name, -1) = :5';

Line 995: l_upd_stmt := 'UPDATE ar_payments_interface_all'

991: with the details provided at the resolved invoice level. So insert the Custom
992: number into the interface tables instead of resolved numbers as an invalid
993: application. */
994:
995: l_upd_stmt := 'UPDATE ar_payments_interface_all'
996: ||' SET invoice'||l_resolved_number||'status = ''AR_PLB_INVALID_MATCH'''
997: ||' WHERE transmission_request_id = :1 AND item_number = :2'
998: ||' AND record_type = :3'
999: ||' AND invoice'||l_resolved_number ||'= :4'

Line 1010: l_upd_stmt := 'UPDATE ar_payments_interface_all'

1006: l_unres_inv_array(i).matching_number,
1007: nvl(l_unres_inv_array(i).batch_name, -1);
1008:
1009: ELSE
1010: l_upd_stmt := 'UPDATE ar_payments_interface_all'
1011: ||' SET invoice'||l_resolved_number||' = NULL'
1012: ||', amount_applied'||l_resolved_number||' = NULL'
1013: ||' WHERE transmission_request_id = :1 AND item_number = :2'
1014: ||' AND record_type = :3'

Line 1031: FROM ar_payments_interface_all a,

1027: a.batch_name,
1028: a.currency_code,
1029: decode(format_amount1,'Y',d.precision,0)
1030: INTO l_org_id, l_lockbox_number, l_batch_name, l_currency_code, l_precision
1031: FROM ar_payments_interface_all a,
1032: ar_transmissions_all b,
1033: ar_trans_record_formats c,
1034: fnd_currencies d
1035: WHERE a.transmission_request_id = b.transmission_request_id

Line 1055: INSERT INTO ar_payments_interface_all(

1051: INTO l_transmission_rec_id_of
1052: FROM dual;
1053:
1054: /* Insert a new overflow record for the new invoice number resolved. */
1055: INSERT INTO ar_payments_interface_all(
1056: transmission_record_id,
1057: item_number,
1058: record_type,
1059: status,

Line 1139: delete from ar_payments_interface_all

1135: /* Delete the old overflow records for all the receipts, where all the matching numbers in
1136: the overflow record are resolved in custom code i.e, no use in having overflow
1137: records with all invoice1 to invoice8 columns null. */
1138:
1139: delete from ar_payments_interface_all
1140: where transmission_request_id = in_trans_req_id
1141: and invoice1 is null
1142: and invoice2 is null
1143: and invoice3 is null

Line 1157: update ar_payments_interface_all

1153:
1154: FOR item_num IN distinct_item_num( in_trans_req_id ) LOOP
1155: l_overflow_seq := 1;
1156: FOR record_id IN overflow_records(in_trans_req_id, item_num.item_number, l_overflow_rec ) LOOP
1157: update ar_payments_interface_all
1158: set overflow_sequence = l_overflow_seq,
1159: overflow_indicator = l_overflow_indicator
1160: where transmission_record_id = record_id.transmission_record_id;
1161:

Line 1168: update ar_payments_interface_all

1164:
1165: /* Overflow the last overflow record's overflow indicator to indicate
1166: there are no more further overflow records for the receipt. */
1167:
1168: update ar_payments_interface_all
1169: set overflow_indicator = l_final_rec_overflow_ind
1170: where transmission_record_id = (
1171: select max(transmission_record_id)
1172: from ar_payments_interface_all

Line 1172: from ar_payments_interface_all

1168: update ar_payments_interface_all
1169: set overflow_indicator = l_final_rec_overflow_ind
1170: where transmission_record_id = (
1171: select max(transmission_record_id)
1172: from ar_payments_interface_all
1173: where transmission_request_id = in_trans_req_id
1174: and item_number = item_num.item_number
1175: and record_type = l_overflow_rec );
1176: END LOOP;

Line 1181: update ar_payments_interface_all

1177:
1178: /* Update the transmission record count with correct value if there are
1179: transmission header or trailer records in the transmission. */
1180:
1181: update ar_payments_interface_all
1182: set transmission_record_count = (
1183: select count(*) from ar_payments_interface_all
1184: where transmission_request_id = in_trans_req_id )
1185: where transmission_request_id = in_trans_req_id

Line 1183: select count(*) from ar_payments_interface_all

1179: transmission header or trailer records in the transmission. */
1180:
1181: update ar_payments_interface_all
1182: set transmission_record_count = (
1183: select count(*) from ar_payments_interface_all
1184: where transmission_request_id = in_trans_req_id )
1185: where transmission_request_id = in_trans_req_id
1186: and record_type in ( select a.record_identifier
1187: from ar_trans_record_formats a, ar_transmissions_all b