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_PAYMENTS_INTERFACE

Line 8: p_item_num IN ar_payments_interface.item_number%type,

4: PROCEDURE auto_associate(
5: p_transmission_id IN VARCHAR2,
6: p_payment_rec_type IN VARCHAR2,
7: p_overflow_rec_type IN VARCHAR2,
8: p_item_num IN ar_payments_interface.item_number%type,
9: p_batch_name IN ar_payments_interface.batch_name%type,
10: p_lockbox_number IN ar_payments_interface.lockbox_number%type,
11: p_batches IN VARCHAR2,
12: p_only_one_lb IN VARCHAR2,

Line 9: p_batch_name IN ar_payments_interface.batch_name%type,

5: p_transmission_id IN VARCHAR2,
6: p_payment_rec_type IN VARCHAR2,
7: p_overflow_rec_type IN VARCHAR2,
8: p_item_num IN ar_payments_interface.item_number%type,
9: p_batch_name IN ar_payments_interface.batch_name%type,
10: p_lockbox_number IN ar_payments_interface.lockbox_number%type,
11: p_batches IN VARCHAR2,
12: p_only_one_lb IN VARCHAR2,
13: p_use_matching_date IN ar_lockboxes.use_matching_date%type,

Line 10: p_lockbox_number IN ar_payments_interface.lockbox_number%type,

6: p_payment_rec_type IN VARCHAR2,
7: p_overflow_rec_type IN VARCHAR2,
8: p_item_num IN ar_payments_interface.item_number%type,
9: p_batch_name IN ar_payments_interface.batch_name%type,
10: p_lockbox_number IN ar_payments_interface.lockbox_number%type,
11: p_batches IN VARCHAR2,
12: p_only_one_lb IN VARCHAR2,
13: p_use_matching_date IN ar_lockboxes.use_matching_date%type,
14: p_lockbox_matching_option IN ar_lockboxes.lockbox_matching_option%type,

Line 24: p_item_num IN ar_payments_interface.item_number%type,

20: PROCEDURE populate_resolved_columns(
21: p_transmission_id IN VARCHAR2,
22: p_payment_rec_type IN VARCHAR2,
23: p_overflow_rec_type IN VARCHAR2,
24: p_item_num IN ar_payments_interface.item_number%type,
25: p_batch_name IN ar_payments_interface.batch_name%type,
26: p_lockbox_number IN ar_payments_interface.lockbox_number%type,
27: p_batches IN VARCHAR2,
28: p_only_one_lb IN VARCHAR2,

Line 25: p_batch_name IN ar_payments_interface.batch_name%type,

21: p_transmission_id IN VARCHAR2,
22: p_payment_rec_type IN VARCHAR2,
23: p_overflow_rec_type IN VARCHAR2,
24: p_item_num IN ar_payments_interface.item_number%type,
25: p_batch_name IN ar_payments_interface.batch_name%type,
26: p_lockbox_number IN ar_payments_interface.lockbox_number%type,
27: p_batches IN VARCHAR2,
28: p_only_one_lb IN VARCHAR2,
29: p_use_matching_date IN ar_lockboxes.use_matching_date%type,

Line 26: p_lockbox_number IN ar_payments_interface.lockbox_number%type,

22: p_payment_rec_type IN VARCHAR2,
23: p_overflow_rec_type IN VARCHAR2,
24: p_item_num IN ar_payments_interface.item_number%type,
25: p_batch_name IN ar_payments_interface.batch_name%type,
26: p_lockbox_number IN ar_payments_interface.lockbox_number%type,
27: p_batches IN VARCHAR2,
28: p_only_one_lb IN VARCHAR2,
29: p_use_matching_date IN ar_lockboxes.use_matching_date%type,
30: p_lockbox_matching_option IN ar_lockboxes.lockbox_matching_option%type,

Line 39: p_item_num IN ar_payments_interface.item_number%type,

35: find_cust_and_trx_num(
36: p_transmission_id IN VARCHAR2,
37: p_payment_rec_type IN VARCHAR2,
38: p_overflow_rec_type IN VARCHAR2,
39: p_item_num IN ar_payments_interface.item_number%type,
40: p_batch_name IN ar_payments_interface.batch_name%type,
41: p_lockbox_number IN ar_payments_interface.lockbox_number%type,
42: p_receipt_date IN ar_payments_interface.receipt_date%type,
43: p_batches IN VARCHAR2,

Line 40: p_batch_name IN ar_payments_interface.batch_name%type,

36: p_transmission_id IN VARCHAR2,
37: p_payment_rec_type IN VARCHAR2,
38: p_overflow_rec_type IN VARCHAR2,
39: p_item_num IN ar_payments_interface.item_number%type,
40: p_batch_name IN ar_payments_interface.batch_name%type,
41: p_lockbox_number IN ar_payments_interface.lockbox_number%type,
42: p_receipt_date IN ar_payments_interface.receipt_date%type,
43: p_batches IN VARCHAR2,
44: p_only_one_lb IN VARCHAR2,

Line 41: p_lockbox_number IN ar_payments_interface.lockbox_number%type,

37: p_payment_rec_type IN VARCHAR2,
38: p_overflow_rec_type IN VARCHAR2,
39: p_item_num IN ar_payments_interface.item_number%type,
40: p_batch_name IN ar_payments_interface.batch_name%type,
41: p_lockbox_number IN ar_payments_interface.lockbox_number%type,
42: p_receipt_date IN ar_payments_interface.receipt_date%type,
43: p_batches IN VARCHAR2,
44: p_only_one_lb IN VARCHAR2,
45: p_use_matching_date IN ar_lockboxes.use_matching_date%type,

Line 42: p_receipt_date IN ar_payments_interface.receipt_date%type,

38: p_overflow_rec_type IN VARCHAR2,
39: p_item_num IN ar_payments_interface.item_number%type,
40: p_batch_name IN ar_payments_interface.batch_name%type,
41: p_lockbox_number IN ar_payments_interface.lockbox_number%type,
42: p_receipt_date IN ar_payments_interface.receipt_date%type,
43: p_batches IN VARCHAR2,
44: p_only_one_lb IN VARCHAR2,
45: p_use_matching_date IN ar_lockboxes.use_matching_date%type,
46: p_lockbox_matching_option IN ar_lockboxes.lockbox_matching_option%type,

Line 48: p_matching_number1 IN OUT NOCOPY ar_payments_interface.invoice1%type,

44: p_only_one_lb IN VARCHAR2,
45: p_use_matching_date IN ar_lockboxes.use_matching_date%type,
46: p_lockbox_matching_option IN ar_lockboxes.lockbox_matching_option%type,
47: p_pay_unrelated_invoices IN VARCHAR2,
48: p_matching_number1 IN OUT NOCOPY ar_payments_interface.invoice1%type,
49: p_matching1_date IN OUT NOCOPY ar_payments_interface.matching1_date%type,
50: p_matching1_installment IN OUT NOCOPY ar_payments_interface.invoice1_installment%type,
51: p_matching_number2 IN OUT NOCOPY ar_payments_interface.invoice2%type,
52: p_matching2_date IN OUT NOCOPY ar_payments_interface.matching2_date%type,

Line 49: p_matching1_date IN OUT NOCOPY ar_payments_interface.matching1_date%type,

45: p_use_matching_date IN ar_lockboxes.use_matching_date%type,
46: p_lockbox_matching_option IN ar_lockboxes.lockbox_matching_option%type,
47: p_pay_unrelated_invoices IN VARCHAR2,
48: p_matching_number1 IN OUT NOCOPY ar_payments_interface.invoice1%type,
49: p_matching1_date IN OUT NOCOPY ar_payments_interface.matching1_date%type,
50: p_matching1_installment IN OUT NOCOPY ar_payments_interface.invoice1_installment%type,
51: p_matching_number2 IN OUT NOCOPY ar_payments_interface.invoice2%type,
52: p_matching2_date IN OUT NOCOPY ar_payments_interface.matching2_date%type,
53: p_matching2_installment IN OUT NOCOPY ar_payments_interface.invoice2_installment%type,

Line 50: p_matching1_installment IN OUT NOCOPY ar_payments_interface.invoice1_installment%type,

46: p_lockbox_matching_option IN ar_lockboxes.lockbox_matching_option%type,
47: p_pay_unrelated_invoices IN VARCHAR2,
48: p_matching_number1 IN OUT NOCOPY ar_payments_interface.invoice1%type,
49: p_matching1_date IN OUT NOCOPY ar_payments_interface.matching1_date%type,
50: p_matching1_installment IN OUT NOCOPY ar_payments_interface.invoice1_installment%type,
51: p_matching_number2 IN OUT NOCOPY ar_payments_interface.invoice2%type,
52: p_matching2_date IN OUT NOCOPY ar_payments_interface.matching2_date%type,
53: p_matching2_installment IN OUT NOCOPY ar_payments_interface.invoice2_installment%type,
54: p_matching_number3 IN OUT NOCOPY ar_payments_interface.invoice3%type,

Line 51: p_matching_number2 IN OUT NOCOPY ar_payments_interface.invoice2%type,

47: p_pay_unrelated_invoices IN VARCHAR2,
48: p_matching_number1 IN OUT NOCOPY ar_payments_interface.invoice1%type,
49: p_matching1_date IN OUT NOCOPY ar_payments_interface.matching1_date%type,
50: p_matching1_installment IN OUT NOCOPY ar_payments_interface.invoice1_installment%type,
51: p_matching_number2 IN OUT NOCOPY ar_payments_interface.invoice2%type,
52: p_matching2_date IN OUT NOCOPY ar_payments_interface.matching2_date%type,
53: p_matching2_installment IN OUT NOCOPY ar_payments_interface.invoice2_installment%type,
54: p_matching_number3 IN OUT NOCOPY ar_payments_interface.invoice3%type,
55: p_matching3_date IN OUT NOCOPY ar_payments_interface.matching3_date%type,

Line 52: p_matching2_date IN OUT NOCOPY ar_payments_interface.matching2_date%type,

48: p_matching_number1 IN OUT NOCOPY ar_payments_interface.invoice1%type,
49: p_matching1_date IN OUT NOCOPY ar_payments_interface.matching1_date%type,
50: p_matching1_installment IN OUT NOCOPY ar_payments_interface.invoice1_installment%type,
51: p_matching_number2 IN OUT NOCOPY ar_payments_interface.invoice2%type,
52: p_matching2_date IN OUT NOCOPY ar_payments_interface.matching2_date%type,
53: p_matching2_installment IN OUT NOCOPY ar_payments_interface.invoice2_installment%type,
54: p_matching_number3 IN OUT NOCOPY ar_payments_interface.invoice3%type,
55: p_matching3_date IN OUT NOCOPY ar_payments_interface.matching3_date%type,
56: p_matching3_installment IN OUT NOCOPY ar_payments_interface.invoice3_installment%type,

Line 53: p_matching2_installment IN OUT NOCOPY ar_payments_interface.invoice2_installment%type,

49: p_matching1_date IN OUT NOCOPY ar_payments_interface.matching1_date%type,
50: p_matching1_installment IN OUT NOCOPY ar_payments_interface.invoice1_installment%type,
51: p_matching_number2 IN OUT NOCOPY ar_payments_interface.invoice2%type,
52: p_matching2_date IN OUT NOCOPY ar_payments_interface.matching2_date%type,
53: p_matching2_installment IN OUT NOCOPY ar_payments_interface.invoice2_installment%type,
54: p_matching_number3 IN OUT NOCOPY ar_payments_interface.invoice3%type,
55: p_matching3_date IN OUT NOCOPY ar_payments_interface.matching3_date%type,
56: p_matching3_installment IN OUT NOCOPY ar_payments_interface.invoice3_installment%type,
57: p_matching_number4 IN OUT NOCOPY ar_payments_interface.invoice4%type,

Line 54: p_matching_number3 IN OUT NOCOPY ar_payments_interface.invoice3%type,

50: p_matching1_installment IN OUT NOCOPY ar_payments_interface.invoice1_installment%type,
51: p_matching_number2 IN OUT NOCOPY ar_payments_interface.invoice2%type,
52: p_matching2_date IN OUT NOCOPY ar_payments_interface.matching2_date%type,
53: p_matching2_installment IN OUT NOCOPY ar_payments_interface.invoice2_installment%type,
54: p_matching_number3 IN OUT NOCOPY ar_payments_interface.invoice3%type,
55: p_matching3_date IN OUT NOCOPY ar_payments_interface.matching3_date%type,
56: p_matching3_installment IN OUT NOCOPY ar_payments_interface.invoice3_installment%type,
57: p_matching_number4 IN OUT NOCOPY ar_payments_interface.invoice4%type,
58: p_matching4_date IN OUT NOCOPY ar_payments_interface.matching4_date%type,

Line 55: p_matching3_date IN OUT NOCOPY ar_payments_interface.matching3_date%type,

51: p_matching_number2 IN OUT NOCOPY ar_payments_interface.invoice2%type,
52: p_matching2_date IN OUT NOCOPY ar_payments_interface.matching2_date%type,
53: p_matching2_installment IN OUT NOCOPY ar_payments_interface.invoice2_installment%type,
54: p_matching_number3 IN OUT NOCOPY ar_payments_interface.invoice3%type,
55: p_matching3_date IN OUT NOCOPY ar_payments_interface.matching3_date%type,
56: p_matching3_installment IN OUT NOCOPY ar_payments_interface.invoice3_installment%type,
57: p_matching_number4 IN OUT NOCOPY ar_payments_interface.invoice4%type,
58: p_matching4_date IN OUT NOCOPY ar_payments_interface.matching4_date%type,
59: p_matching4_installment IN OUT NOCOPY ar_payments_interface.invoice4_installment%type,

Line 56: p_matching3_installment IN OUT NOCOPY ar_payments_interface.invoice3_installment%type,

52: p_matching2_date IN OUT NOCOPY ar_payments_interface.matching2_date%type,
53: p_matching2_installment IN OUT NOCOPY ar_payments_interface.invoice2_installment%type,
54: p_matching_number3 IN OUT NOCOPY ar_payments_interface.invoice3%type,
55: p_matching3_date IN OUT NOCOPY ar_payments_interface.matching3_date%type,
56: p_matching3_installment IN OUT NOCOPY ar_payments_interface.invoice3_installment%type,
57: p_matching_number4 IN OUT NOCOPY ar_payments_interface.invoice4%type,
58: p_matching4_date IN OUT NOCOPY ar_payments_interface.matching4_date%type,
59: p_matching4_installment IN OUT NOCOPY ar_payments_interface.invoice4_installment%type,
60: p_matching_number5 IN OUT NOCOPY ar_payments_interface.invoice5%type,

Line 57: p_matching_number4 IN OUT NOCOPY ar_payments_interface.invoice4%type,

53: p_matching2_installment IN OUT NOCOPY ar_payments_interface.invoice2_installment%type,
54: p_matching_number3 IN OUT NOCOPY ar_payments_interface.invoice3%type,
55: p_matching3_date IN OUT NOCOPY ar_payments_interface.matching3_date%type,
56: p_matching3_installment IN OUT NOCOPY ar_payments_interface.invoice3_installment%type,
57: p_matching_number4 IN OUT NOCOPY ar_payments_interface.invoice4%type,
58: p_matching4_date IN OUT NOCOPY ar_payments_interface.matching4_date%type,
59: p_matching4_installment IN OUT NOCOPY ar_payments_interface.invoice4_installment%type,
60: p_matching_number5 IN OUT NOCOPY ar_payments_interface.invoice5%type,
61: p_matching5_date IN OUT NOCOPY ar_payments_interface.matching5_date%type,

Line 58: p_matching4_date IN OUT NOCOPY ar_payments_interface.matching4_date%type,

54: p_matching_number3 IN OUT NOCOPY ar_payments_interface.invoice3%type,
55: p_matching3_date IN OUT NOCOPY ar_payments_interface.matching3_date%type,
56: p_matching3_installment IN OUT NOCOPY ar_payments_interface.invoice3_installment%type,
57: p_matching_number4 IN OUT NOCOPY ar_payments_interface.invoice4%type,
58: p_matching4_date IN OUT NOCOPY ar_payments_interface.matching4_date%type,
59: p_matching4_installment IN OUT NOCOPY ar_payments_interface.invoice4_installment%type,
60: p_matching_number5 IN OUT NOCOPY ar_payments_interface.invoice5%type,
61: p_matching5_date IN OUT NOCOPY ar_payments_interface.matching5_date%type,
62: p_matching5_installment IN OUT NOCOPY ar_payments_interface.invoice5_installment%type,

Line 59: p_matching4_installment IN OUT NOCOPY ar_payments_interface.invoice4_installment%type,

55: p_matching3_date IN OUT NOCOPY ar_payments_interface.matching3_date%type,
56: p_matching3_installment IN OUT NOCOPY ar_payments_interface.invoice3_installment%type,
57: p_matching_number4 IN OUT NOCOPY ar_payments_interface.invoice4%type,
58: p_matching4_date IN OUT NOCOPY ar_payments_interface.matching4_date%type,
59: p_matching4_installment IN OUT NOCOPY ar_payments_interface.invoice4_installment%type,
60: p_matching_number5 IN OUT NOCOPY ar_payments_interface.invoice5%type,
61: p_matching5_date IN OUT NOCOPY ar_payments_interface.matching5_date%type,
62: p_matching5_installment IN OUT NOCOPY ar_payments_interface.invoice5_installment%type,
63: p_matching_number6 IN OUT NOCOPY ar_payments_interface.invoice6%type,

Line 60: p_matching_number5 IN OUT NOCOPY ar_payments_interface.invoice5%type,

56: p_matching3_installment IN OUT NOCOPY ar_payments_interface.invoice3_installment%type,
57: p_matching_number4 IN OUT NOCOPY ar_payments_interface.invoice4%type,
58: p_matching4_date IN OUT NOCOPY ar_payments_interface.matching4_date%type,
59: p_matching4_installment IN OUT NOCOPY ar_payments_interface.invoice4_installment%type,
60: p_matching_number5 IN OUT NOCOPY ar_payments_interface.invoice5%type,
61: p_matching5_date IN OUT NOCOPY ar_payments_interface.matching5_date%type,
62: p_matching5_installment IN OUT NOCOPY ar_payments_interface.invoice5_installment%type,
63: p_matching_number6 IN OUT NOCOPY ar_payments_interface.invoice6%type,
64: p_matching6_date IN OUT NOCOPY ar_payments_interface.matching6_date%type,

Line 61: p_matching5_date IN OUT NOCOPY ar_payments_interface.matching5_date%type,

57: p_matching_number4 IN OUT NOCOPY ar_payments_interface.invoice4%type,
58: p_matching4_date IN OUT NOCOPY ar_payments_interface.matching4_date%type,
59: p_matching4_installment IN OUT NOCOPY ar_payments_interface.invoice4_installment%type,
60: p_matching_number5 IN OUT NOCOPY ar_payments_interface.invoice5%type,
61: p_matching5_date IN OUT NOCOPY ar_payments_interface.matching5_date%type,
62: p_matching5_installment IN OUT NOCOPY ar_payments_interface.invoice5_installment%type,
63: p_matching_number6 IN OUT NOCOPY ar_payments_interface.invoice6%type,
64: p_matching6_date IN OUT NOCOPY ar_payments_interface.matching6_date%type,
65: p_matching6_installment IN OUT NOCOPY ar_payments_interface.invoice6_installment%type,

Line 62: p_matching5_installment IN OUT NOCOPY ar_payments_interface.invoice5_installment%type,

58: p_matching4_date IN OUT NOCOPY ar_payments_interface.matching4_date%type,
59: p_matching4_installment IN OUT NOCOPY ar_payments_interface.invoice4_installment%type,
60: p_matching_number5 IN OUT NOCOPY ar_payments_interface.invoice5%type,
61: p_matching5_date IN OUT NOCOPY ar_payments_interface.matching5_date%type,
62: p_matching5_installment IN OUT NOCOPY ar_payments_interface.invoice5_installment%type,
63: p_matching_number6 IN OUT NOCOPY ar_payments_interface.invoice6%type,
64: p_matching6_date IN OUT NOCOPY ar_payments_interface.matching6_date%type,
65: p_matching6_installment IN OUT NOCOPY ar_payments_interface.invoice6_installment%type,
66: p_matching_number7 IN OUT NOCOPY ar_payments_interface.invoice7%type,

Line 63: p_matching_number6 IN OUT NOCOPY ar_payments_interface.invoice6%type,

59: p_matching4_installment IN OUT NOCOPY ar_payments_interface.invoice4_installment%type,
60: p_matching_number5 IN OUT NOCOPY ar_payments_interface.invoice5%type,
61: p_matching5_date IN OUT NOCOPY ar_payments_interface.matching5_date%type,
62: p_matching5_installment IN OUT NOCOPY ar_payments_interface.invoice5_installment%type,
63: p_matching_number6 IN OUT NOCOPY ar_payments_interface.invoice6%type,
64: p_matching6_date IN OUT NOCOPY ar_payments_interface.matching6_date%type,
65: p_matching6_installment IN OUT NOCOPY ar_payments_interface.invoice6_installment%type,
66: p_matching_number7 IN OUT NOCOPY ar_payments_interface.invoice7%type,
67: p_matching7_date IN OUT NOCOPY ar_payments_interface.matching7_date%type,

Line 64: p_matching6_date IN OUT NOCOPY ar_payments_interface.matching6_date%type,

60: p_matching_number5 IN OUT NOCOPY ar_payments_interface.invoice5%type,
61: p_matching5_date IN OUT NOCOPY ar_payments_interface.matching5_date%type,
62: p_matching5_installment IN OUT NOCOPY ar_payments_interface.invoice5_installment%type,
63: p_matching_number6 IN OUT NOCOPY ar_payments_interface.invoice6%type,
64: p_matching6_date IN OUT NOCOPY ar_payments_interface.matching6_date%type,
65: p_matching6_installment IN OUT NOCOPY ar_payments_interface.invoice6_installment%type,
66: p_matching_number7 IN OUT NOCOPY ar_payments_interface.invoice7%type,
67: p_matching7_date IN OUT NOCOPY ar_payments_interface.matching7_date%type,
68: p_matching7_installment IN OUT NOCOPY ar_payments_interface.invoice7_installment%type,

Line 65: p_matching6_installment IN OUT NOCOPY ar_payments_interface.invoice6_installment%type,

61: p_matching5_date IN OUT NOCOPY ar_payments_interface.matching5_date%type,
62: p_matching5_installment IN OUT NOCOPY ar_payments_interface.invoice5_installment%type,
63: p_matching_number6 IN OUT NOCOPY ar_payments_interface.invoice6%type,
64: p_matching6_date IN OUT NOCOPY ar_payments_interface.matching6_date%type,
65: p_matching6_installment IN OUT NOCOPY ar_payments_interface.invoice6_installment%type,
66: p_matching_number7 IN OUT NOCOPY ar_payments_interface.invoice7%type,
67: p_matching7_date IN OUT NOCOPY ar_payments_interface.matching7_date%type,
68: p_matching7_installment IN OUT NOCOPY ar_payments_interface.invoice7_installment%type,
69: p_matching_number8 IN OUT NOCOPY ar_payments_interface.invoice8%type,

Line 66: p_matching_number7 IN OUT NOCOPY ar_payments_interface.invoice7%type,

62: p_matching5_installment IN OUT NOCOPY ar_payments_interface.invoice5_installment%type,
63: p_matching_number6 IN OUT NOCOPY ar_payments_interface.invoice6%type,
64: p_matching6_date IN OUT NOCOPY ar_payments_interface.matching6_date%type,
65: p_matching6_installment IN OUT NOCOPY ar_payments_interface.invoice6_installment%type,
66: p_matching_number7 IN OUT NOCOPY ar_payments_interface.invoice7%type,
67: p_matching7_date IN OUT NOCOPY ar_payments_interface.matching7_date%type,
68: p_matching7_installment IN OUT NOCOPY ar_payments_interface.invoice7_installment%type,
69: p_matching_number8 IN OUT NOCOPY ar_payments_interface.invoice8%type,
70: p_matching8_date IN OUT NOCOPY ar_payments_interface.matching8_date%type,

Line 67: p_matching7_date IN OUT NOCOPY ar_payments_interface.matching7_date%type,

63: p_matching_number6 IN OUT NOCOPY ar_payments_interface.invoice6%type,
64: p_matching6_date IN OUT NOCOPY ar_payments_interface.matching6_date%type,
65: p_matching6_installment IN OUT NOCOPY ar_payments_interface.invoice6_installment%type,
66: p_matching_number7 IN OUT NOCOPY ar_payments_interface.invoice7%type,
67: p_matching7_date IN OUT NOCOPY ar_payments_interface.matching7_date%type,
68: p_matching7_installment IN OUT NOCOPY ar_payments_interface.invoice7_installment%type,
69: p_matching_number8 IN OUT NOCOPY ar_payments_interface.invoice8%type,
70: p_matching8_date IN OUT NOCOPY ar_payments_interface.matching8_date%type,
71: p_matching8_installment IN OUT NOCOPY ar_payments_interface.invoice8_installment%type,

Line 68: p_matching7_installment IN OUT NOCOPY ar_payments_interface.invoice7_installment%type,

64: p_matching6_date IN OUT NOCOPY ar_payments_interface.matching6_date%type,
65: p_matching6_installment IN OUT NOCOPY ar_payments_interface.invoice6_installment%type,
66: p_matching_number7 IN OUT NOCOPY ar_payments_interface.invoice7%type,
67: p_matching7_date IN OUT NOCOPY ar_payments_interface.matching7_date%type,
68: p_matching7_installment IN OUT NOCOPY ar_payments_interface.invoice7_installment%type,
69: p_matching_number8 IN OUT NOCOPY ar_payments_interface.invoice8%type,
70: p_matching8_date IN OUT NOCOPY ar_payments_interface.matching8_date%type,
71: p_matching8_installment IN OUT NOCOPY ar_payments_interface.invoice8_installment%type,
72: p_matched_flag OUT NOCOPY VARCHAR2,

Line 69: p_matching_number8 IN OUT NOCOPY ar_payments_interface.invoice8%type,

65: p_matching6_installment IN OUT NOCOPY ar_payments_interface.invoice6_installment%type,
66: p_matching_number7 IN OUT NOCOPY ar_payments_interface.invoice7%type,
67: p_matching7_date IN OUT NOCOPY ar_payments_interface.matching7_date%type,
68: p_matching7_installment IN OUT NOCOPY ar_payments_interface.invoice7_installment%type,
69: p_matching_number8 IN OUT NOCOPY ar_payments_interface.invoice8%type,
70: p_matching8_date IN OUT NOCOPY ar_payments_interface.matching8_date%type,
71: p_matching8_installment IN OUT NOCOPY ar_payments_interface.invoice8_installment%type,
72: p_matched_flag OUT NOCOPY VARCHAR2,
73: p_customer_id IN OUT NOCOPY NUMBER,

Line 70: p_matching8_date IN OUT NOCOPY ar_payments_interface.matching8_date%type,

66: p_matching_number7 IN OUT NOCOPY ar_payments_interface.invoice7%type,
67: p_matching7_date IN OUT NOCOPY ar_payments_interface.matching7_date%type,
68: p_matching7_installment IN OUT NOCOPY ar_payments_interface.invoice7_installment%type,
69: p_matching_number8 IN OUT NOCOPY ar_payments_interface.invoice8%type,
70: p_matching8_date IN OUT NOCOPY ar_payments_interface.matching8_date%type,
71: p_matching8_installment IN OUT NOCOPY ar_payments_interface.invoice8_installment%type,
72: p_matched_flag OUT NOCOPY VARCHAR2,
73: p_customer_id IN OUT NOCOPY NUMBER,
74: p_matching_option IN OUT NOCOPY ar_lookups.lookup_code%type,

Line 71: p_matching8_installment IN OUT NOCOPY ar_payments_interface.invoice8_installment%type,

67: p_matching7_date IN OUT NOCOPY ar_payments_interface.matching7_date%type,
68: p_matching7_installment IN OUT NOCOPY ar_payments_interface.invoice7_installment%type,
69: p_matching_number8 IN OUT NOCOPY ar_payments_interface.invoice8%type,
70: p_matching8_date IN OUT NOCOPY ar_payments_interface.matching8_date%type,
71: p_matching8_installment IN OUT NOCOPY ar_payments_interface.invoice8_installment%type,
72: p_matched_flag OUT NOCOPY VARCHAR2,
73: p_customer_id IN OUT NOCOPY NUMBER,
74: p_matching_option IN OUT NOCOPY ar_lookups.lookup_code%type,
75: p_match1_status OUT NOCOPY ar_payments_interface.invoice1_status%type,

Line 75: p_match1_status OUT NOCOPY ar_payments_interface.invoice1_status%type,

71: p_matching8_installment IN OUT NOCOPY ar_payments_interface.invoice8_installment%type,
72: p_matched_flag OUT NOCOPY VARCHAR2,
73: p_customer_id IN OUT NOCOPY NUMBER,
74: p_matching_option IN OUT NOCOPY ar_lookups.lookup_code%type,
75: p_match1_status OUT NOCOPY ar_payments_interface.invoice1_status%type,
76: p_match2_status OUT NOCOPY ar_payments_interface.invoice2_status%type,
77: p_match3_status OUT NOCOPY ar_payments_interface.invoice3_status%type,
78: p_match4_status OUT NOCOPY ar_payments_interface.invoice4_status%type,
79: p_match5_status OUT NOCOPY ar_payments_interface.invoice5_status%type,

Line 76: p_match2_status OUT NOCOPY ar_payments_interface.invoice2_status%type,

72: p_matched_flag OUT NOCOPY VARCHAR2,
73: p_customer_id IN OUT NOCOPY NUMBER,
74: p_matching_option IN OUT NOCOPY ar_lookups.lookup_code%type,
75: p_match1_status OUT NOCOPY ar_payments_interface.invoice1_status%type,
76: p_match2_status OUT NOCOPY ar_payments_interface.invoice2_status%type,
77: p_match3_status OUT NOCOPY ar_payments_interface.invoice3_status%type,
78: p_match4_status OUT NOCOPY ar_payments_interface.invoice4_status%type,
79: p_match5_status OUT NOCOPY ar_payments_interface.invoice5_status%type,
80: p_match6_status OUT NOCOPY ar_payments_interface.invoice6_status%type,

Line 77: p_match3_status OUT NOCOPY ar_payments_interface.invoice3_status%type,

73: p_customer_id IN OUT NOCOPY NUMBER,
74: p_matching_option IN OUT NOCOPY ar_lookups.lookup_code%type,
75: p_match1_status OUT NOCOPY ar_payments_interface.invoice1_status%type,
76: p_match2_status OUT NOCOPY ar_payments_interface.invoice2_status%type,
77: p_match3_status OUT NOCOPY ar_payments_interface.invoice3_status%type,
78: p_match4_status OUT NOCOPY ar_payments_interface.invoice4_status%type,
79: p_match5_status OUT NOCOPY ar_payments_interface.invoice5_status%type,
80: p_match6_status OUT NOCOPY ar_payments_interface.invoice6_status%type,
81: p_match7_status OUT NOCOPY ar_payments_interface.invoice7_status%type,

Line 78: p_match4_status OUT NOCOPY ar_payments_interface.invoice4_status%type,

74: p_matching_option IN OUT NOCOPY ar_lookups.lookup_code%type,
75: p_match1_status OUT NOCOPY ar_payments_interface.invoice1_status%type,
76: p_match2_status OUT NOCOPY ar_payments_interface.invoice2_status%type,
77: p_match3_status OUT NOCOPY ar_payments_interface.invoice3_status%type,
78: p_match4_status OUT NOCOPY ar_payments_interface.invoice4_status%type,
79: p_match5_status OUT NOCOPY ar_payments_interface.invoice5_status%type,
80: p_match6_status OUT NOCOPY ar_payments_interface.invoice6_status%type,
81: p_match7_status OUT NOCOPY ar_payments_interface.invoice7_status%type,
82: p_match8_status OUT NOCOPY ar_payments_interface.invoice8_status%type

Line 79: p_match5_status OUT NOCOPY ar_payments_interface.invoice5_status%type,

75: p_match1_status OUT NOCOPY ar_payments_interface.invoice1_status%type,
76: p_match2_status OUT NOCOPY ar_payments_interface.invoice2_status%type,
77: p_match3_status OUT NOCOPY ar_payments_interface.invoice3_status%type,
78: p_match4_status OUT NOCOPY ar_payments_interface.invoice4_status%type,
79: p_match5_status OUT NOCOPY ar_payments_interface.invoice5_status%type,
80: p_match6_status OUT NOCOPY ar_payments_interface.invoice6_status%type,
81: p_match7_status OUT NOCOPY ar_payments_interface.invoice7_status%type,
82: p_match8_status OUT NOCOPY ar_payments_interface.invoice8_status%type
83: );

Line 80: p_match6_status OUT NOCOPY ar_payments_interface.invoice6_status%type,

76: p_match2_status OUT NOCOPY ar_payments_interface.invoice2_status%type,
77: p_match3_status OUT NOCOPY ar_payments_interface.invoice3_status%type,
78: p_match4_status OUT NOCOPY ar_payments_interface.invoice4_status%type,
79: p_match5_status OUT NOCOPY ar_payments_interface.invoice5_status%type,
80: p_match6_status OUT NOCOPY ar_payments_interface.invoice6_status%type,
81: p_match7_status OUT NOCOPY ar_payments_interface.invoice7_status%type,
82: p_match8_status OUT NOCOPY ar_payments_interface.invoice8_status%type
83: );
84: --

Line 81: p_match7_status OUT NOCOPY ar_payments_interface.invoice7_status%type,

77: p_match3_status OUT NOCOPY ar_payments_interface.invoice3_status%type,
78: p_match4_status OUT NOCOPY ar_payments_interface.invoice4_status%type,
79: p_match5_status OUT NOCOPY ar_payments_interface.invoice5_status%type,
80: p_match6_status OUT NOCOPY ar_payments_interface.invoice6_status%type,
81: p_match7_status OUT NOCOPY ar_payments_interface.invoice7_status%type,
82: p_match8_status OUT NOCOPY ar_payments_interface.invoice8_status%type
83: );
84: --
85: PROCEDURE

Line 82: p_match8_status OUT NOCOPY ar_payments_interface.invoice8_status%type

78: p_match4_status OUT NOCOPY ar_payments_interface.invoice4_status%type,
79: p_match5_status OUT NOCOPY ar_payments_interface.invoice5_status%type,
80: p_match6_status OUT NOCOPY ar_payments_interface.invoice6_status%type,
81: p_match7_status OUT NOCOPY ar_payments_interface.invoice7_status%type,
82: p_match8_status OUT NOCOPY ar_payments_interface.invoice8_status%type
83: );
84: --
85: PROCEDURE
86: get_cursor_name(

Line 105: p_trans_req_id IN ar_payments_interface.transmission_request_id%type,

101: insert_interim_line_details(
102: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
103: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%type,
104: p_cash_receipt_line_id IN NUMBER,
105: p_trans_req_id IN ar_payments_interface.transmission_request_id%type,
106: p_batch_name IN ar_payments_interface.batch_name%type,
107: p_item_num IN ar_payments_interface.item_number%type,
108: p_return_status OUT NOCOPY varchar2
109: );

Line 106: p_batch_name IN ar_payments_interface.batch_name%type,

102: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
103: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%type,
104: p_cash_receipt_line_id IN NUMBER,
105: p_trans_req_id IN ar_payments_interface.transmission_request_id%type,
106: p_batch_name IN ar_payments_interface.batch_name%type,
107: p_item_num IN ar_payments_interface.item_number%type,
108: p_return_status OUT NOCOPY varchar2
109: );
110: --

Line 107: p_item_num IN ar_payments_interface.item_number%type,

103: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%type,
104: p_cash_receipt_line_id IN NUMBER,
105: p_trans_req_id IN ar_payments_interface.transmission_request_id%type,
106: p_batch_name IN ar_payments_interface.batch_name%type,
107: p_item_num IN ar_payments_interface.item_number%type,
108: p_return_status OUT NOCOPY varchar2
109: );
110: --
111: PROCEDURE