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_REVERSE_RECEIPT dependencies on AR_CASH_RECEIPTS

Line 15: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,

11: --
12: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
13:
14: PROCEDURE validate_args(
15: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
16: p_reversal_category IN VARCHAR2,
17: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE,
18: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE,
19: p_reversal_reason_code IN VARCHAR2 );

Line 18: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE,

14: PROCEDURE validate_args(
15: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
16: p_reversal_category IN VARCHAR2,
17: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE,
18: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE,
19: p_reversal_reason_code IN VARCHAR2 );
20: --
21: PROCEDURE update_current_cr_rec(
22: p_cr_rec IN OUT NOCOPY ar_cash_receipts%ROWTYPE,

Line 22: p_cr_rec IN OUT NOCOPY ar_cash_receipts%ROWTYPE,

18: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE,
19: p_reversal_reason_code IN VARCHAR2 );
20: --
21: PROCEDURE update_current_cr_rec(
22: p_cr_rec IN OUT NOCOPY ar_cash_receipts%ROWTYPE,
23: p_reversal_category IN ar_cash_receipts.reversal_category%TYPE,
24: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE,
25: p_reversal_reason_code IN ar_cash_receipts.reversal_reason_code%TYPE,
26: p_reversal_comments IN ar_cash_receipts.reversal_comments%TYPE,

Line 23: p_reversal_category IN ar_cash_receipts.reversal_category%TYPE,

19: p_reversal_reason_code IN VARCHAR2 );
20: --
21: PROCEDURE update_current_cr_rec(
22: p_cr_rec IN OUT NOCOPY ar_cash_receipts%ROWTYPE,
23: p_reversal_category IN ar_cash_receipts.reversal_category%TYPE,
24: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE,
25: p_reversal_reason_code IN ar_cash_receipts.reversal_reason_code%TYPE,
26: p_reversal_comments IN ar_cash_receipts.reversal_comments%TYPE,
27: p_attribute_category IN ar_cash_receipts.attribute_category%TYPE,

Line 24: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE,

20: --
21: PROCEDURE update_current_cr_rec(
22: p_cr_rec IN OUT NOCOPY ar_cash_receipts%ROWTYPE,
23: p_reversal_category IN ar_cash_receipts.reversal_category%TYPE,
24: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE,
25: p_reversal_reason_code IN ar_cash_receipts.reversal_reason_code%TYPE,
26: p_reversal_comments IN ar_cash_receipts.reversal_comments%TYPE,
27: p_attribute_category IN ar_cash_receipts.attribute_category%TYPE,
28: p_attribute1 IN ar_cash_receipts.attribute1%TYPE,

Line 25: p_reversal_reason_code IN ar_cash_receipts.reversal_reason_code%TYPE,

21: PROCEDURE update_current_cr_rec(
22: p_cr_rec IN OUT NOCOPY ar_cash_receipts%ROWTYPE,
23: p_reversal_category IN ar_cash_receipts.reversal_category%TYPE,
24: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE,
25: p_reversal_reason_code IN ar_cash_receipts.reversal_reason_code%TYPE,
26: p_reversal_comments IN ar_cash_receipts.reversal_comments%TYPE,
27: p_attribute_category IN ar_cash_receipts.attribute_category%TYPE,
28: p_attribute1 IN ar_cash_receipts.attribute1%TYPE,
29: p_attribute2 IN ar_cash_receipts.attribute2%TYPE,

Line 26: p_reversal_comments IN ar_cash_receipts.reversal_comments%TYPE,

22: p_cr_rec IN OUT NOCOPY ar_cash_receipts%ROWTYPE,
23: p_reversal_category IN ar_cash_receipts.reversal_category%TYPE,
24: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE,
25: p_reversal_reason_code IN ar_cash_receipts.reversal_reason_code%TYPE,
26: p_reversal_comments IN ar_cash_receipts.reversal_comments%TYPE,
27: p_attribute_category IN ar_cash_receipts.attribute_category%TYPE,
28: p_attribute1 IN ar_cash_receipts.attribute1%TYPE,
29: p_attribute2 IN ar_cash_receipts.attribute2%TYPE,
30: p_attribute3 IN ar_cash_receipts.attribute3%TYPE,

Line 27: p_attribute_category IN ar_cash_receipts.attribute_category%TYPE,

23: p_reversal_category IN ar_cash_receipts.reversal_category%TYPE,
24: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE,
25: p_reversal_reason_code IN ar_cash_receipts.reversal_reason_code%TYPE,
26: p_reversal_comments IN ar_cash_receipts.reversal_comments%TYPE,
27: p_attribute_category IN ar_cash_receipts.attribute_category%TYPE,
28: p_attribute1 IN ar_cash_receipts.attribute1%TYPE,
29: p_attribute2 IN ar_cash_receipts.attribute2%TYPE,
30: p_attribute3 IN ar_cash_receipts.attribute3%TYPE,
31: p_attribute4 IN ar_cash_receipts.attribute4%TYPE,

Line 28: p_attribute1 IN ar_cash_receipts.attribute1%TYPE,

24: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE,
25: p_reversal_reason_code IN ar_cash_receipts.reversal_reason_code%TYPE,
26: p_reversal_comments IN ar_cash_receipts.reversal_comments%TYPE,
27: p_attribute_category IN ar_cash_receipts.attribute_category%TYPE,
28: p_attribute1 IN ar_cash_receipts.attribute1%TYPE,
29: p_attribute2 IN ar_cash_receipts.attribute2%TYPE,
30: p_attribute3 IN ar_cash_receipts.attribute3%TYPE,
31: p_attribute4 IN ar_cash_receipts.attribute4%TYPE,
32: p_attribute5 IN ar_cash_receipts.attribute5%TYPE,

Line 29: p_attribute2 IN ar_cash_receipts.attribute2%TYPE,

25: p_reversal_reason_code IN ar_cash_receipts.reversal_reason_code%TYPE,
26: p_reversal_comments IN ar_cash_receipts.reversal_comments%TYPE,
27: p_attribute_category IN ar_cash_receipts.attribute_category%TYPE,
28: p_attribute1 IN ar_cash_receipts.attribute1%TYPE,
29: p_attribute2 IN ar_cash_receipts.attribute2%TYPE,
30: p_attribute3 IN ar_cash_receipts.attribute3%TYPE,
31: p_attribute4 IN ar_cash_receipts.attribute4%TYPE,
32: p_attribute5 IN ar_cash_receipts.attribute5%TYPE,
33: p_attribute6 IN ar_cash_receipts.attribute6%TYPE,

Line 30: p_attribute3 IN ar_cash_receipts.attribute3%TYPE,

26: p_reversal_comments IN ar_cash_receipts.reversal_comments%TYPE,
27: p_attribute_category IN ar_cash_receipts.attribute_category%TYPE,
28: p_attribute1 IN ar_cash_receipts.attribute1%TYPE,
29: p_attribute2 IN ar_cash_receipts.attribute2%TYPE,
30: p_attribute3 IN ar_cash_receipts.attribute3%TYPE,
31: p_attribute4 IN ar_cash_receipts.attribute4%TYPE,
32: p_attribute5 IN ar_cash_receipts.attribute5%TYPE,
33: p_attribute6 IN ar_cash_receipts.attribute6%TYPE,
34: p_attribute7 IN ar_cash_receipts.attribute7%TYPE,

Line 31: p_attribute4 IN ar_cash_receipts.attribute4%TYPE,

27: p_attribute_category IN ar_cash_receipts.attribute_category%TYPE,
28: p_attribute1 IN ar_cash_receipts.attribute1%TYPE,
29: p_attribute2 IN ar_cash_receipts.attribute2%TYPE,
30: p_attribute3 IN ar_cash_receipts.attribute3%TYPE,
31: p_attribute4 IN ar_cash_receipts.attribute4%TYPE,
32: p_attribute5 IN ar_cash_receipts.attribute5%TYPE,
33: p_attribute6 IN ar_cash_receipts.attribute6%TYPE,
34: p_attribute7 IN ar_cash_receipts.attribute7%TYPE,
35: p_attribute8 IN ar_cash_receipts.attribute8%TYPE,

Line 32: p_attribute5 IN ar_cash_receipts.attribute5%TYPE,

28: p_attribute1 IN ar_cash_receipts.attribute1%TYPE,
29: p_attribute2 IN ar_cash_receipts.attribute2%TYPE,
30: p_attribute3 IN ar_cash_receipts.attribute3%TYPE,
31: p_attribute4 IN ar_cash_receipts.attribute4%TYPE,
32: p_attribute5 IN ar_cash_receipts.attribute5%TYPE,
33: p_attribute6 IN ar_cash_receipts.attribute6%TYPE,
34: p_attribute7 IN ar_cash_receipts.attribute7%TYPE,
35: p_attribute8 IN ar_cash_receipts.attribute8%TYPE,
36: p_attribute9 IN ar_cash_receipts.attribute9%TYPE,

Line 33: p_attribute6 IN ar_cash_receipts.attribute6%TYPE,

29: p_attribute2 IN ar_cash_receipts.attribute2%TYPE,
30: p_attribute3 IN ar_cash_receipts.attribute3%TYPE,
31: p_attribute4 IN ar_cash_receipts.attribute4%TYPE,
32: p_attribute5 IN ar_cash_receipts.attribute5%TYPE,
33: p_attribute6 IN ar_cash_receipts.attribute6%TYPE,
34: p_attribute7 IN ar_cash_receipts.attribute7%TYPE,
35: p_attribute8 IN ar_cash_receipts.attribute8%TYPE,
36: p_attribute9 IN ar_cash_receipts.attribute9%TYPE,
37: p_attribute10 IN ar_cash_receipts.attribute10%TYPE,

Line 34: p_attribute7 IN ar_cash_receipts.attribute7%TYPE,

30: p_attribute3 IN ar_cash_receipts.attribute3%TYPE,
31: p_attribute4 IN ar_cash_receipts.attribute4%TYPE,
32: p_attribute5 IN ar_cash_receipts.attribute5%TYPE,
33: p_attribute6 IN ar_cash_receipts.attribute6%TYPE,
34: p_attribute7 IN ar_cash_receipts.attribute7%TYPE,
35: p_attribute8 IN ar_cash_receipts.attribute8%TYPE,
36: p_attribute9 IN ar_cash_receipts.attribute9%TYPE,
37: p_attribute10 IN ar_cash_receipts.attribute10%TYPE,
38: p_attribute11 IN ar_cash_receipts.attribute11%TYPE,

Line 35: p_attribute8 IN ar_cash_receipts.attribute8%TYPE,

31: p_attribute4 IN ar_cash_receipts.attribute4%TYPE,
32: p_attribute5 IN ar_cash_receipts.attribute5%TYPE,
33: p_attribute6 IN ar_cash_receipts.attribute6%TYPE,
34: p_attribute7 IN ar_cash_receipts.attribute7%TYPE,
35: p_attribute8 IN ar_cash_receipts.attribute8%TYPE,
36: p_attribute9 IN ar_cash_receipts.attribute9%TYPE,
37: p_attribute10 IN ar_cash_receipts.attribute10%TYPE,
38: p_attribute11 IN ar_cash_receipts.attribute11%TYPE,
39: p_attribute12 IN ar_cash_receipts.attribute12%TYPE,

Line 36: p_attribute9 IN ar_cash_receipts.attribute9%TYPE,

32: p_attribute5 IN ar_cash_receipts.attribute5%TYPE,
33: p_attribute6 IN ar_cash_receipts.attribute6%TYPE,
34: p_attribute7 IN ar_cash_receipts.attribute7%TYPE,
35: p_attribute8 IN ar_cash_receipts.attribute8%TYPE,
36: p_attribute9 IN ar_cash_receipts.attribute9%TYPE,
37: p_attribute10 IN ar_cash_receipts.attribute10%TYPE,
38: p_attribute11 IN ar_cash_receipts.attribute11%TYPE,
39: p_attribute12 IN ar_cash_receipts.attribute12%TYPE,
40: p_attribute13 IN ar_cash_receipts.attribute13%TYPE,

Line 37: p_attribute10 IN ar_cash_receipts.attribute10%TYPE,

33: p_attribute6 IN ar_cash_receipts.attribute6%TYPE,
34: p_attribute7 IN ar_cash_receipts.attribute7%TYPE,
35: p_attribute8 IN ar_cash_receipts.attribute8%TYPE,
36: p_attribute9 IN ar_cash_receipts.attribute9%TYPE,
37: p_attribute10 IN ar_cash_receipts.attribute10%TYPE,
38: p_attribute11 IN ar_cash_receipts.attribute11%TYPE,
39: p_attribute12 IN ar_cash_receipts.attribute12%TYPE,
40: p_attribute13 IN ar_cash_receipts.attribute13%TYPE,
41: p_attribute14 IN ar_cash_receipts.attribute14%TYPE,

Line 38: p_attribute11 IN ar_cash_receipts.attribute11%TYPE,

34: p_attribute7 IN ar_cash_receipts.attribute7%TYPE,
35: p_attribute8 IN ar_cash_receipts.attribute8%TYPE,
36: p_attribute9 IN ar_cash_receipts.attribute9%TYPE,
37: p_attribute10 IN ar_cash_receipts.attribute10%TYPE,
38: p_attribute11 IN ar_cash_receipts.attribute11%TYPE,
39: p_attribute12 IN ar_cash_receipts.attribute12%TYPE,
40: p_attribute13 IN ar_cash_receipts.attribute13%TYPE,
41: p_attribute14 IN ar_cash_receipts.attribute14%TYPE,
42: p_attribute15 IN ar_cash_receipts.attribute15%TYPE );

Line 39: p_attribute12 IN ar_cash_receipts.attribute12%TYPE,

35: p_attribute8 IN ar_cash_receipts.attribute8%TYPE,
36: p_attribute9 IN ar_cash_receipts.attribute9%TYPE,
37: p_attribute10 IN ar_cash_receipts.attribute10%TYPE,
38: p_attribute11 IN ar_cash_receipts.attribute11%TYPE,
39: p_attribute12 IN ar_cash_receipts.attribute12%TYPE,
40: p_attribute13 IN ar_cash_receipts.attribute13%TYPE,
41: p_attribute14 IN ar_cash_receipts.attribute14%TYPE,
42: p_attribute15 IN ar_cash_receipts.attribute15%TYPE );
43: --

Line 40: p_attribute13 IN ar_cash_receipts.attribute13%TYPE,

36: p_attribute9 IN ar_cash_receipts.attribute9%TYPE,
37: p_attribute10 IN ar_cash_receipts.attribute10%TYPE,
38: p_attribute11 IN ar_cash_receipts.attribute11%TYPE,
39: p_attribute12 IN ar_cash_receipts.attribute12%TYPE,
40: p_attribute13 IN ar_cash_receipts.attribute13%TYPE,
41: p_attribute14 IN ar_cash_receipts.attribute14%TYPE,
42: p_attribute15 IN ar_cash_receipts.attribute15%TYPE );
43: --
44: PROCEDURE update_current_crh_record(

Line 41: p_attribute14 IN ar_cash_receipts.attribute14%TYPE,

37: p_attribute10 IN ar_cash_receipts.attribute10%TYPE,
38: p_attribute11 IN ar_cash_receipts.attribute11%TYPE,
39: p_attribute12 IN ar_cash_receipts.attribute12%TYPE,
40: p_attribute13 IN ar_cash_receipts.attribute13%TYPE,
41: p_attribute14 IN ar_cash_receipts.attribute14%TYPE,
42: p_attribute15 IN ar_cash_receipts.attribute15%TYPE );
43: --
44: PROCEDURE update_current_crh_record(
45: p_crh_rec IN OUT NOCOPY ar_cash_receipt_history%ROWTYPE,

Line 42: p_attribute15 IN ar_cash_receipts.attribute15%TYPE );

38: p_attribute11 IN ar_cash_receipts.attribute11%TYPE,
39: p_attribute12 IN ar_cash_receipts.attribute12%TYPE,
40: p_attribute13 IN ar_cash_receipts.attribute13%TYPE,
41: p_attribute14 IN ar_cash_receipts.attribute14%TYPE,
42: p_attribute15 IN ar_cash_receipts.attribute15%TYPE );
43: --
44: PROCEDURE update_current_crh_record(
45: p_crh_rec IN OUT NOCOPY ar_cash_receipt_history%ROWTYPE,
46: p_reversal_gl_date IN ar_misc_cash_distributions.gl_date%TYPE,

Line 64: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,

60: p_reversal_gl_date IN ar_misc_cash_distributions.gl_date%TYPE,
61: p_reversal_date IN ar_misc_cash_distributions.apply_date%TYPE );
62: --
63: PROCEDURE insert_reversal_dist_rec(
64: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
65: p_crh_id IN ar_cash_receipt_history.cash_receipt_history_id%TYPE );
66: --
67: FUNCTION check_cb( p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE )
68: RETURN BOOLEAN;

Line 67: FUNCTION check_cb( p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE )

63: PROCEDURE insert_reversal_dist_rec(
64: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
65: p_crh_id IN ar_cash_receipt_history.cash_receipt_history_id%TYPE );
66: --
67: FUNCTION check_cb( p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE )
68: RETURN BOOLEAN;
69: --
70: PROCEDURE modify_update_ps_rec(
71: p_cr_id IN ar_payment_schedules.cash_receipt_id%TYPE,

Line 76: p_cr_amount IN ar_cash_receipts.amount%TYPE,

72: p_reversal_gl_date IN DATE,
73: p_reversal_date IN DATE );
74: --
75: PROCEDURE modify_update_bat_rec( p_bat_id IN ar_batches.batch_id%TYPE,
76: p_cr_amount IN ar_cash_receipts.amount%TYPE,
77: p_status IN VARCHAR2 );
78: --
79: PROCEDURE validate_dm_reversal_args(
80: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,

Line 80: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,

76: p_cr_amount IN ar_cash_receipts.amount%TYPE,
77: p_status IN VARCHAR2 );
78: --
79: PROCEDURE validate_dm_reversal_args(
80: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
81: p_cc_id IN ra_cust_trx_line_gl_dist.code_combination_id%TYPE,
82: p_cust_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
83: p_reversal_gl_date IN
84: ar_cash_receipt_history.reversal_gl_date%TYPE,

Line 86: ar_cash_receipts.reversal_date%TYPE,

82: p_cust_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
83: p_reversal_gl_date IN
84: ar_cash_receipt_history.reversal_gl_date%TYPE,
85: p_reversal_date IN
86: ar_cash_receipts.reversal_date%TYPE,
87: p_reversal_reason_code IN VARCHAR2);
88: --
89: --
90: -- Externally visible procedure

Line 103: | arp_cash_receipts_pkg.fetch_p - Fetch a record from ar_cash_receipts |

99: | SCOPE - PUBLIC |
100: | |
101: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |
102: | arp_process_application.reverse - Reverse an application |
103: | arp_cash_receipts_pkg.fetch_p - Fetch a record from ar_cash_receipts |
104: | arp_app_pkg.lock_p - lock a record in |
105: | AR_RECEIVABLE_APPLICATIONS table |
106: | |
107: | ARGUMENTS : IN: |

Line 129: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,

125: | MODIFICATION HISTORY - Created by Ganesh Vaidee - 04/25/95 |
126: | |
127: +===========================================================================*/
128: PROCEDURE reverse (
129: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
130: p_reversal_category IN ar_cash_receipts.reversal_category%TYPE,
131: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE,
132: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE,
133: p_reversal_reason_code IN ar_cash_receipts.reversal_reason_code%TYPE,

Line 130: p_reversal_category IN ar_cash_receipts.reversal_category%TYPE,

126: | |
127: +===========================================================================*/
128: PROCEDURE reverse (
129: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
130: p_reversal_category IN ar_cash_receipts.reversal_category%TYPE,
131: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE,
132: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE,
133: p_reversal_reason_code IN ar_cash_receipts.reversal_reason_code%TYPE,
134: p_reversal_comments IN ar_cash_receipts.reversal_comments%TYPE,

Line 132: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE,

128: PROCEDURE reverse (
129: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
130: p_reversal_category IN ar_cash_receipts.reversal_category%TYPE,
131: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE,
132: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE,
133: p_reversal_reason_code IN ar_cash_receipts.reversal_reason_code%TYPE,
134: p_reversal_comments IN ar_cash_receipts.reversal_comments%TYPE,
135: p_clear_batch_id IN ar_cash_receipt_history.batch_id%TYPE,
136: p_attribute_category IN ar_cash_receipts.attribute_category%TYPE,

Line 133: p_reversal_reason_code IN ar_cash_receipts.reversal_reason_code%TYPE,

129: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
130: p_reversal_category IN ar_cash_receipts.reversal_category%TYPE,
131: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE,
132: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE,
133: p_reversal_reason_code IN ar_cash_receipts.reversal_reason_code%TYPE,
134: p_reversal_comments IN ar_cash_receipts.reversal_comments%TYPE,
135: p_clear_batch_id IN ar_cash_receipt_history.batch_id%TYPE,
136: p_attribute_category IN ar_cash_receipts.attribute_category%TYPE,
137: p_attribute1 IN ar_cash_receipts.attribute1%TYPE,

Line 134: p_reversal_comments IN ar_cash_receipts.reversal_comments%TYPE,

130: p_reversal_category IN ar_cash_receipts.reversal_category%TYPE,
131: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE,
132: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE,
133: p_reversal_reason_code IN ar_cash_receipts.reversal_reason_code%TYPE,
134: p_reversal_comments IN ar_cash_receipts.reversal_comments%TYPE,
135: p_clear_batch_id IN ar_cash_receipt_history.batch_id%TYPE,
136: p_attribute_category IN ar_cash_receipts.attribute_category%TYPE,
137: p_attribute1 IN ar_cash_receipts.attribute1%TYPE,
138: p_attribute2 IN ar_cash_receipts.attribute2%TYPE,

Line 136: p_attribute_category IN ar_cash_receipts.attribute_category%TYPE,

132: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE,
133: p_reversal_reason_code IN ar_cash_receipts.reversal_reason_code%TYPE,
134: p_reversal_comments IN ar_cash_receipts.reversal_comments%TYPE,
135: p_clear_batch_id IN ar_cash_receipt_history.batch_id%TYPE,
136: p_attribute_category IN ar_cash_receipts.attribute_category%TYPE,
137: p_attribute1 IN ar_cash_receipts.attribute1%TYPE,
138: p_attribute2 IN ar_cash_receipts.attribute2%TYPE,
139: p_attribute3 IN ar_cash_receipts.attribute3%TYPE,
140: p_attribute4 IN ar_cash_receipts.attribute4%TYPE,

Line 137: p_attribute1 IN ar_cash_receipts.attribute1%TYPE,

133: p_reversal_reason_code IN ar_cash_receipts.reversal_reason_code%TYPE,
134: p_reversal_comments IN ar_cash_receipts.reversal_comments%TYPE,
135: p_clear_batch_id IN ar_cash_receipt_history.batch_id%TYPE,
136: p_attribute_category IN ar_cash_receipts.attribute_category%TYPE,
137: p_attribute1 IN ar_cash_receipts.attribute1%TYPE,
138: p_attribute2 IN ar_cash_receipts.attribute2%TYPE,
139: p_attribute3 IN ar_cash_receipts.attribute3%TYPE,
140: p_attribute4 IN ar_cash_receipts.attribute4%TYPE,
141: p_attribute5 IN ar_cash_receipts.attribute5%TYPE,

Line 138: p_attribute2 IN ar_cash_receipts.attribute2%TYPE,

134: p_reversal_comments IN ar_cash_receipts.reversal_comments%TYPE,
135: p_clear_batch_id IN ar_cash_receipt_history.batch_id%TYPE,
136: p_attribute_category IN ar_cash_receipts.attribute_category%TYPE,
137: p_attribute1 IN ar_cash_receipts.attribute1%TYPE,
138: p_attribute2 IN ar_cash_receipts.attribute2%TYPE,
139: p_attribute3 IN ar_cash_receipts.attribute3%TYPE,
140: p_attribute4 IN ar_cash_receipts.attribute4%TYPE,
141: p_attribute5 IN ar_cash_receipts.attribute5%TYPE,
142: p_attribute6 IN ar_cash_receipts.attribute6%TYPE,

Line 139: p_attribute3 IN ar_cash_receipts.attribute3%TYPE,

135: p_clear_batch_id IN ar_cash_receipt_history.batch_id%TYPE,
136: p_attribute_category IN ar_cash_receipts.attribute_category%TYPE,
137: p_attribute1 IN ar_cash_receipts.attribute1%TYPE,
138: p_attribute2 IN ar_cash_receipts.attribute2%TYPE,
139: p_attribute3 IN ar_cash_receipts.attribute3%TYPE,
140: p_attribute4 IN ar_cash_receipts.attribute4%TYPE,
141: p_attribute5 IN ar_cash_receipts.attribute5%TYPE,
142: p_attribute6 IN ar_cash_receipts.attribute6%TYPE,
143: p_attribute7 IN ar_cash_receipts.attribute7%TYPE,

Line 140: p_attribute4 IN ar_cash_receipts.attribute4%TYPE,

136: p_attribute_category IN ar_cash_receipts.attribute_category%TYPE,
137: p_attribute1 IN ar_cash_receipts.attribute1%TYPE,
138: p_attribute2 IN ar_cash_receipts.attribute2%TYPE,
139: p_attribute3 IN ar_cash_receipts.attribute3%TYPE,
140: p_attribute4 IN ar_cash_receipts.attribute4%TYPE,
141: p_attribute5 IN ar_cash_receipts.attribute5%TYPE,
142: p_attribute6 IN ar_cash_receipts.attribute6%TYPE,
143: p_attribute7 IN ar_cash_receipts.attribute7%TYPE,
144: p_attribute8 IN ar_cash_receipts.attribute8%TYPE,

Line 141: p_attribute5 IN ar_cash_receipts.attribute5%TYPE,

137: p_attribute1 IN ar_cash_receipts.attribute1%TYPE,
138: p_attribute2 IN ar_cash_receipts.attribute2%TYPE,
139: p_attribute3 IN ar_cash_receipts.attribute3%TYPE,
140: p_attribute4 IN ar_cash_receipts.attribute4%TYPE,
141: p_attribute5 IN ar_cash_receipts.attribute5%TYPE,
142: p_attribute6 IN ar_cash_receipts.attribute6%TYPE,
143: p_attribute7 IN ar_cash_receipts.attribute7%TYPE,
144: p_attribute8 IN ar_cash_receipts.attribute8%TYPE,
145: p_attribute9 IN ar_cash_receipts.attribute9%TYPE,

Line 142: p_attribute6 IN ar_cash_receipts.attribute6%TYPE,

138: p_attribute2 IN ar_cash_receipts.attribute2%TYPE,
139: p_attribute3 IN ar_cash_receipts.attribute3%TYPE,
140: p_attribute4 IN ar_cash_receipts.attribute4%TYPE,
141: p_attribute5 IN ar_cash_receipts.attribute5%TYPE,
142: p_attribute6 IN ar_cash_receipts.attribute6%TYPE,
143: p_attribute7 IN ar_cash_receipts.attribute7%TYPE,
144: p_attribute8 IN ar_cash_receipts.attribute8%TYPE,
145: p_attribute9 IN ar_cash_receipts.attribute9%TYPE,
146: p_attribute10 IN ar_cash_receipts.attribute10%TYPE,

Line 143: p_attribute7 IN ar_cash_receipts.attribute7%TYPE,

139: p_attribute3 IN ar_cash_receipts.attribute3%TYPE,
140: p_attribute4 IN ar_cash_receipts.attribute4%TYPE,
141: p_attribute5 IN ar_cash_receipts.attribute5%TYPE,
142: p_attribute6 IN ar_cash_receipts.attribute6%TYPE,
143: p_attribute7 IN ar_cash_receipts.attribute7%TYPE,
144: p_attribute8 IN ar_cash_receipts.attribute8%TYPE,
145: p_attribute9 IN ar_cash_receipts.attribute9%TYPE,
146: p_attribute10 IN ar_cash_receipts.attribute10%TYPE,
147: p_attribute11 IN ar_cash_receipts.attribute11%TYPE,

Line 144: p_attribute8 IN ar_cash_receipts.attribute8%TYPE,

140: p_attribute4 IN ar_cash_receipts.attribute4%TYPE,
141: p_attribute5 IN ar_cash_receipts.attribute5%TYPE,
142: p_attribute6 IN ar_cash_receipts.attribute6%TYPE,
143: p_attribute7 IN ar_cash_receipts.attribute7%TYPE,
144: p_attribute8 IN ar_cash_receipts.attribute8%TYPE,
145: p_attribute9 IN ar_cash_receipts.attribute9%TYPE,
146: p_attribute10 IN ar_cash_receipts.attribute10%TYPE,
147: p_attribute11 IN ar_cash_receipts.attribute11%TYPE,
148: p_attribute12 IN ar_cash_receipts.attribute12%TYPE,

Line 145: p_attribute9 IN ar_cash_receipts.attribute9%TYPE,

141: p_attribute5 IN ar_cash_receipts.attribute5%TYPE,
142: p_attribute6 IN ar_cash_receipts.attribute6%TYPE,
143: p_attribute7 IN ar_cash_receipts.attribute7%TYPE,
144: p_attribute8 IN ar_cash_receipts.attribute8%TYPE,
145: p_attribute9 IN ar_cash_receipts.attribute9%TYPE,
146: p_attribute10 IN ar_cash_receipts.attribute10%TYPE,
147: p_attribute11 IN ar_cash_receipts.attribute11%TYPE,
148: p_attribute12 IN ar_cash_receipts.attribute12%TYPE,
149: p_attribute13 IN ar_cash_receipts.attribute13%TYPE,

Line 146: p_attribute10 IN ar_cash_receipts.attribute10%TYPE,

142: p_attribute6 IN ar_cash_receipts.attribute6%TYPE,
143: p_attribute7 IN ar_cash_receipts.attribute7%TYPE,
144: p_attribute8 IN ar_cash_receipts.attribute8%TYPE,
145: p_attribute9 IN ar_cash_receipts.attribute9%TYPE,
146: p_attribute10 IN ar_cash_receipts.attribute10%TYPE,
147: p_attribute11 IN ar_cash_receipts.attribute11%TYPE,
148: p_attribute12 IN ar_cash_receipts.attribute12%TYPE,
149: p_attribute13 IN ar_cash_receipts.attribute13%TYPE,
150: p_attribute14 IN ar_cash_receipts.attribute14%TYPE,

Line 147: p_attribute11 IN ar_cash_receipts.attribute11%TYPE,

143: p_attribute7 IN ar_cash_receipts.attribute7%TYPE,
144: p_attribute8 IN ar_cash_receipts.attribute8%TYPE,
145: p_attribute9 IN ar_cash_receipts.attribute9%TYPE,
146: p_attribute10 IN ar_cash_receipts.attribute10%TYPE,
147: p_attribute11 IN ar_cash_receipts.attribute11%TYPE,
148: p_attribute12 IN ar_cash_receipts.attribute12%TYPE,
149: p_attribute13 IN ar_cash_receipts.attribute13%TYPE,
150: p_attribute14 IN ar_cash_receipts.attribute14%TYPE,
151: p_attribute15 IN ar_cash_receipts.attribute15%TYPE,

Line 148: p_attribute12 IN ar_cash_receipts.attribute12%TYPE,

144: p_attribute8 IN ar_cash_receipts.attribute8%TYPE,
145: p_attribute9 IN ar_cash_receipts.attribute9%TYPE,
146: p_attribute10 IN ar_cash_receipts.attribute10%TYPE,
147: p_attribute11 IN ar_cash_receipts.attribute11%TYPE,
148: p_attribute12 IN ar_cash_receipts.attribute12%TYPE,
149: p_attribute13 IN ar_cash_receipts.attribute13%TYPE,
150: p_attribute14 IN ar_cash_receipts.attribute14%TYPE,
151: p_attribute15 IN ar_cash_receipts.attribute15%TYPE,
152: p_module_name IN VARCHAR2,

Line 149: p_attribute13 IN ar_cash_receipts.attribute13%TYPE,

145: p_attribute9 IN ar_cash_receipts.attribute9%TYPE,
146: p_attribute10 IN ar_cash_receipts.attribute10%TYPE,
147: p_attribute11 IN ar_cash_receipts.attribute11%TYPE,
148: p_attribute12 IN ar_cash_receipts.attribute12%TYPE,
149: p_attribute13 IN ar_cash_receipts.attribute13%TYPE,
150: p_attribute14 IN ar_cash_receipts.attribute14%TYPE,
151: p_attribute15 IN ar_cash_receipts.attribute15%TYPE,
152: p_module_name IN VARCHAR2,
153: p_module_version IN VARCHAR2,

Line 150: p_attribute14 IN ar_cash_receipts.attribute14%TYPE,

146: p_attribute10 IN ar_cash_receipts.attribute10%TYPE,
147: p_attribute11 IN ar_cash_receipts.attribute11%TYPE,
148: p_attribute12 IN ar_cash_receipts.attribute12%TYPE,
149: p_attribute13 IN ar_cash_receipts.attribute13%TYPE,
150: p_attribute14 IN ar_cash_receipts.attribute14%TYPE,
151: p_attribute15 IN ar_cash_receipts.attribute15%TYPE,
152: p_module_name IN VARCHAR2,
153: p_module_version IN VARCHAR2,
154: p_crh_id OUT NOCOPY ar_cash_receipt_history.cash_receipt_history_id%TYPE,

Line 151: p_attribute15 IN ar_cash_receipts.attribute15%TYPE,

147: p_attribute11 IN ar_cash_receipts.attribute11%TYPE,
148: p_attribute12 IN ar_cash_receipts.attribute12%TYPE,
149: p_attribute13 IN ar_cash_receipts.attribute13%TYPE,
150: p_attribute14 IN ar_cash_receipts.attribute14%TYPE,
151: p_attribute15 IN ar_cash_receipts.attribute15%TYPE,
152: p_module_name IN VARCHAR2,
153: p_module_version IN VARCHAR2,
154: p_crh_id OUT NOCOPY ar_cash_receipt_history.cash_receipt_history_id%TYPE,
155: p_called_from IN VARCHAR2 DEFAULT NULL) IS /* jrautiai BR implementation */

Line 157: l_cr_rec ar_cash_receipts%ROWTYPE;

153: p_module_version IN VARCHAR2,
154: p_crh_id OUT NOCOPY ar_cash_receipt_history.cash_receipt_history_id%TYPE,
155: p_called_from IN VARCHAR2 DEFAULT NULL) IS /* jrautiai BR implementation */
156: --
157: l_cr_rec ar_cash_receipts%ROWTYPE;
158: l_crh_rec_old ar_cash_receipt_history%ROWTYPE;
159: l_crh_rec ar_cash_receipt_history%ROWTYPE;
160: l_batches_rec ar_batches%ROWTYPE;
161: l_mcd_rec ar_misc_cash_distributions%ROWTYPE;

Line 206: CURSOR ar_ra_C( p_cr_id ar_cash_receipts.cash_receipt_id%TYPE ) IS

202: receivables_charges_applied NUMBER
203: );
204: --
205: /* 08-AUG-2000 J Rautiainen BR Implementation */
206: CURSOR ar_ra_C( p_cr_id ar_cash_receipts.cash_receipt_id%TYPE ) IS
207: SELECT receivable_application_id
208: , receivables_trx_id
209: , applied_payment_schedule_id
210: , application_ref_id

Line 225: CURSOR ar_mcd_C( p_cr_id ar_cash_receipts.cash_receipt_id%TYPE ) IS

221: )
222: AND reversal_gl_date is NULL
223: ORDER BY decode(status,'APP',1,'ACTIVITY',2,'ACC',3,'OTHER ACC',4,'UNID',5,'UNAPP',6); --VAT 11.5 for pairing UNAPP records
224: --
225: CURSOR ar_mcd_C( p_cr_id ar_cash_receipts.cash_receipt_id%TYPE ) IS
226: SELECT *
227: FROM ar_misc_cash_distributions
228: WHERE cash_receipt_id = p_cr_id
229: AND reversal_gl_date is null;

Line 232: /* bug3635777 : Added table ar_cash_receipts to avoid FTS on ra table */

228: WHERE cash_receipt_id = p_cr_id
229: AND reversal_gl_date is null;
230: --
231: /*CCRR- need to find the application id associated with the Negative Misc receipt pkt*/
232: /* bug3635777 : Added table ar_cash_receipts to avoid FTS on ra table */
233:
234: CURSOR ar_rc_rec( p_cr_id ar_cash_receipts.cash_receipt_id%TYPE ) IS
235: SELECT ra.receivable_application_id
236: FROM ar_receivable_applications ra ,ar_cash_receipts cr

Line 234: CURSOR ar_rc_rec( p_cr_id ar_cash_receipts.cash_receipt_id%TYPE ) IS

230: --
231: /*CCRR- need to find the application id associated with the Negative Misc receipt pkt*/
232: /* bug3635777 : Added table ar_cash_receipts to avoid FTS on ra table */
233:
234: CURSOR ar_rc_rec( p_cr_id ar_cash_receipts.cash_receipt_id%TYPE ) IS
235: SELECT ra.receivable_application_id
236: FROM ar_receivable_applications ra ,ar_cash_receipts cr
237: WHERE cr.reference_id = ra.cash_receipt_id
238: AND cr.cash_receipt_id = p_cr_id

Line 236: FROM ar_receivable_applications ra ,ar_cash_receipts cr

232: /* bug3635777 : Added table ar_cash_receipts to avoid FTS on ra table */
233:
234: CURSOR ar_rc_rec( p_cr_id ar_cash_receipts.cash_receipt_id%TYPE ) IS
235: SELECT ra.receivable_application_id
236: FROM ar_receivable_applications ra ,ar_cash_receipts cr
237: WHERE cr.reference_id = ra.cash_receipt_id
238: AND cr.cash_receipt_id = p_cr_id
239: AND ra.application_ref_id = p_cr_id
240: AND ra.application_ref_type = 'MISC_RECEIPT';

Line 261: -- Populate the ar_cash_receipts record from

257: p_reversal_gl_date, p_reversal_date,
258: p_reversal_reason_code );
259: END IF;
260: --
261: -- Populate the ar_cash_receipts record from
262: -- ar_cash_receipts table. Use cash_receipt_id for selection.
263: --
264: l_cr_rec.cash_receipt_id := p_cr_id;
265: arp_cash_receipts_pkg.fetch_p( l_cr_rec );

Line 262: -- ar_cash_receipts table. Use cash_receipt_id for selection.

258: p_reversal_reason_code );
259: END IF;
260: --
261: -- Populate the ar_cash_receipts record from
262: -- ar_cash_receipts table. Use cash_receipt_id for selection.
263: --
264: l_cr_rec.cash_receipt_id := p_cr_id;
265: arp_cash_receipts_pkg.fetch_p( l_cr_rec );
266: --

Line 516: -- Update ar_cash_receipts, set status to reversal_category,

512: -- Update ar_payment_schedule record with amount_due_remaining = 0,
513: -- acctd_amount_due_remaining = 0, amount_applied = 0,
514: -- actual_date_closed,last_update_date, last_updated_by, gl_date_closed,
515: -- status = 'CL'
516: -- Update ar_cash_receipts, set status to reversal_category,
517: -- last_update_date = sysdate, last_updated_by = user_id,
518: -- reversal_comments and attributes.
519: --
520:

Line 667: PROCEDURE validate_args( p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,

663: | |
664: | MODIFICATION HISTORY - Created by Ganesh Vaidee - 04/25/95 |
665: | |
666: +===========================================================================*/
667: PROCEDURE validate_args( p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
668: p_reversal_category IN VARCHAR2,
669: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE,
670: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE,
671: p_reversal_reason_code IN VARCHAR2 ) IS

Line 670: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE,

666: +===========================================================================*/
667: PROCEDURE validate_args( p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
668: p_reversal_category IN VARCHAR2,
669: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE,
670: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE,
671: p_reversal_reason_code IN VARCHAR2 ) IS
672: BEGIN
673: IF PG_DEBUG in ('Y', 'C') THEN
674: arp_standard.debug( 'arp_reverse_receipt.validate_args() +');

Line 741: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,

737: | added call to ar_mrc_engine2 for processing|
738: | ar_distributions inserts. |
739: +===========================================================================*/
740: PROCEDURE insert_reversal_dist_rec(
741: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
742: p_crh_id IN ar_cash_receipt_history.cash_receipt_history_id%TYPE ) IS
743: --
744: l_dist_rec ar_distributions%ROWTYPE;
745: l_cr_rec ar_cash_receipts%ROWTYPE; /* added for VAT */

Line 745: l_cr_rec ar_cash_receipts%ROWTYPE; /* added for VAT */

741: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
742: p_crh_id IN ar_cash_receipt_history.cash_receipt_history_id%TYPE ) IS
743: --
744: l_dist_rec ar_distributions%ROWTYPE;
745: l_cr_rec ar_cash_receipts%ROWTYPE; /* added for VAT */
746: l_crh_rec ar_cash_receipt_history%ROWTYPE; /* added for VAT */
747: --
748: CURSOR ar_dist_C(
749: p_cr_id ar_cash_receipt_history.cash_receipt_history_id%TYPE ) IS

Line 868: | AR_CASH_RECEIPTS_HISTORY table |

864: | SCOPE - PRIVATE |
865: | |
866: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |
867: | arp_cr_history_pkg.insert_p -Insertion table handler for |
868: | AR_CASH_RECEIPTS_HISTORY table |
869: | |
870: | ARGUMENTS : IN: |
871: | p_crh_rec - Cash receipt history record structure |
872: | p_reversal_gl_date - Reversal GL date |

Line 1163: FUNCTION check_cb( p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE )

1159: | should have been adj.receivables_trx_id |
1160: | <> arp_global.... instead of = arp_gl...|
1161: | |
1162: +===========================================================================*/
1163: FUNCTION check_cb( p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE )
1164: RETURN BOOLEAN IS
1165: l_count NUMBER DEFAULT 0;
1166: BEGIN
1167: IF PG_DEBUG in ('Y', 'C') THEN

Line 1308: p_cr_rec IN OUT NOCOPY ar_cash_receipts%ROWTYPE,

1304: | column |
1305: | |
1306: +===========================================================================*/
1307: PROCEDURE update_current_cr_rec(
1308: p_cr_rec IN OUT NOCOPY ar_cash_receipts%ROWTYPE,
1309: p_reversal_category IN ar_cash_receipts.reversal_category%TYPE,
1310: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE,
1311: p_reversal_reason_code IN ar_cash_receipts.reversal_reason_code%TYPE,
1312: p_reversal_comments IN ar_cash_receipts.reversal_comments%TYPE,

Line 1309: p_reversal_category IN ar_cash_receipts.reversal_category%TYPE,

1305: | |
1306: +===========================================================================*/
1307: PROCEDURE update_current_cr_rec(
1308: p_cr_rec IN OUT NOCOPY ar_cash_receipts%ROWTYPE,
1309: p_reversal_category IN ar_cash_receipts.reversal_category%TYPE,
1310: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE,
1311: p_reversal_reason_code IN ar_cash_receipts.reversal_reason_code%TYPE,
1312: p_reversal_comments IN ar_cash_receipts.reversal_comments%TYPE,
1313: p_attribute_category IN ar_cash_receipts.attribute_category%TYPE,

Line 1310: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE,

1306: +===========================================================================*/
1307: PROCEDURE update_current_cr_rec(
1308: p_cr_rec IN OUT NOCOPY ar_cash_receipts%ROWTYPE,
1309: p_reversal_category IN ar_cash_receipts.reversal_category%TYPE,
1310: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE,
1311: p_reversal_reason_code IN ar_cash_receipts.reversal_reason_code%TYPE,
1312: p_reversal_comments IN ar_cash_receipts.reversal_comments%TYPE,
1313: p_attribute_category IN ar_cash_receipts.attribute_category%TYPE,
1314: p_attribute1 IN ar_cash_receipts.attribute1%TYPE,

Line 1311: p_reversal_reason_code IN ar_cash_receipts.reversal_reason_code%TYPE,

1307: PROCEDURE update_current_cr_rec(
1308: p_cr_rec IN OUT NOCOPY ar_cash_receipts%ROWTYPE,
1309: p_reversal_category IN ar_cash_receipts.reversal_category%TYPE,
1310: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE,
1311: p_reversal_reason_code IN ar_cash_receipts.reversal_reason_code%TYPE,
1312: p_reversal_comments IN ar_cash_receipts.reversal_comments%TYPE,
1313: p_attribute_category IN ar_cash_receipts.attribute_category%TYPE,
1314: p_attribute1 IN ar_cash_receipts.attribute1%TYPE,
1315: p_attribute2 IN ar_cash_receipts.attribute2%TYPE,

Line 1312: p_reversal_comments IN ar_cash_receipts.reversal_comments%TYPE,

1308: p_cr_rec IN OUT NOCOPY ar_cash_receipts%ROWTYPE,
1309: p_reversal_category IN ar_cash_receipts.reversal_category%TYPE,
1310: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE,
1311: p_reversal_reason_code IN ar_cash_receipts.reversal_reason_code%TYPE,
1312: p_reversal_comments IN ar_cash_receipts.reversal_comments%TYPE,
1313: p_attribute_category IN ar_cash_receipts.attribute_category%TYPE,
1314: p_attribute1 IN ar_cash_receipts.attribute1%TYPE,
1315: p_attribute2 IN ar_cash_receipts.attribute2%TYPE,
1316: p_attribute3 IN ar_cash_receipts.attribute3%TYPE,

Line 1313: p_attribute_category IN ar_cash_receipts.attribute_category%TYPE,

1309: p_reversal_category IN ar_cash_receipts.reversal_category%TYPE,
1310: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE,
1311: p_reversal_reason_code IN ar_cash_receipts.reversal_reason_code%TYPE,
1312: p_reversal_comments IN ar_cash_receipts.reversal_comments%TYPE,
1313: p_attribute_category IN ar_cash_receipts.attribute_category%TYPE,
1314: p_attribute1 IN ar_cash_receipts.attribute1%TYPE,
1315: p_attribute2 IN ar_cash_receipts.attribute2%TYPE,
1316: p_attribute3 IN ar_cash_receipts.attribute3%TYPE,
1317: p_attribute4 IN ar_cash_receipts.attribute4%TYPE,

Line 1314: p_attribute1 IN ar_cash_receipts.attribute1%TYPE,

1310: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE,
1311: p_reversal_reason_code IN ar_cash_receipts.reversal_reason_code%TYPE,
1312: p_reversal_comments IN ar_cash_receipts.reversal_comments%TYPE,
1313: p_attribute_category IN ar_cash_receipts.attribute_category%TYPE,
1314: p_attribute1 IN ar_cash_receipts.attribute1%TYPE,
1315: p_attribute2 IN ar_cash_receipts.attribute2%TYPE,
1316: p_attribute3 IN ar_cash_receipts.attribute3%TYPE,
1317: p_attribute4 IN ar_cash_receipts.attribute4%TYPE,
1318: p_attribute5 IN ar_cash_receipts.attribute5%TYPE,

Line 1315: p_attribute2 IN ar_cash_receipts.attribute2%TYPE,

1311: p_reversal_reason_code IN ar_cash_receipts.reversal_reason_code%TYPE,
1312: p_reversal_comments IN ar_cash_receipts.reversal_comments%TYPE,
1313: p_attribute_category IN ar_cash_receipts.attribute_category%TYPE,
1314: p_attribute1 IN ar_cash_receipts.attribute1%TYPE,
1315: p_attribute2 IN ar_cash_receipts.attribute2%TYPE,
1316: p_attribute3 IN ar_cash_receipts.attribute3%TYPE,
1317: p_attribute4 IN ar_cash_receipts.attribute4%TYPE,
1318: p_attribute5 IN ar_cash_receipts.attribute5%TYPE,
1319: p_attribute6 IN ar_cash_receipts.attribute6%TYPE,

Line 1316: p_attribute3 IN ar_cash_receipts.attribute3%TYPE,

1312: p_reversal_comments IN ar_cash_receipts.reversal_comments%TYPE,
1313: p_attribute_category IN ar_cash_receipts.attribute_category%TYPE,
1314: p_attribute1 IN ar_cash_receipts.attribute1%TYPE,
1315: p_attribute2 IN ar_cash_receipts.attribute2%TYPE,
1316: p_attribute3 IN ar_cash_receipts.attribute3%TYPE,
1317: p_attribute4 IN ar_cash_receipts.attribute4%TYPE,
1318: p_attribute5 IN ar_cash_receipts.attribute5%TYPE,
1319: p_attribute6 IN ar_cash_receipts.attribute6%TYPE,
1320: p_attribute7 IN ar_cash_receipts.attribute7%TYPE,

Line 1317: p_attribute4 IN ar_cash_receipts.attribute4%TYPE,

1313: p_attribute_category IN ar_cash_receipts.attribute_category%TYPE,
1314: p_attribute1 IN ar_cash_receipts.attribute1%TYPE,
1315: p_attribute2 IN ar_cash_receipts.attribute2%TYPE,
1316: p_attribute3 IN ar_cash_receipts.attribute3%TYPE,
1317: p_attribute4 IN ar_cash_receipts.attribute4%TYPE,
1318: p_attribute5 IN ar_cash_receipts.attribute5%TYPE,
1319: p_attribute6 IN ar_cash_receipts.attribute6%TYPE,
1320: p_attribute7 IN ar_cash_receipts.attribute7%TYPE,
1321: p_attribute8 IN ar_cash_receipts.attribute8%TYPE,

Line 1318: p_attribute5 IN ar_cash_receipts.attribute5%TYPE,

1314: p_attribute1 IN ar_cash_receipts.attribute1%TYPE,
1315: p_attribute2 IN ar_cash_receipts.attribute2%TYPE,
1316: p_attribute3 IN ar_cash_receipts.attribute3%TYPE,
1317: p_attribute4 IN ar_cash_receipts.attribute4%TYPE,
1318: p_attribute5 IN ar_cash_receipts.attribute5%TYPE,
1319: p_attribute6 IN ar_cash_receipts.attribute6%TYPE,
1320: p_attribute7 IN ar_cash_receipts.attribute7%TYPE,
1321: p_attribute8 IN ar_cash_receipts.attribute8%TYPE,
1322: p_attribute9 IN ar_cash_receipts.attribute9%TYPE,

Line 1319: p_attribute6 IN ar_cash_receipts.attribute6%TYPE,

1315: p_attribute2 IN ar_cash_receipts.attribute2%TYPE,
1316: p_attribute3 IN ar_cash_receipts.attribute3%TYPE,
1317: p_attribute4 IN ar_cash_receipts.attribute4%TYPE,
1318: p_attribute5 IN ar_cash_receipts.attribute5%TYPE,
1319: p_attribute6 IN ar_cash_receipts.attribute6%TYPE,
1320: p_attribute7 IN ar_cash_receipts.attribute7%TYPE,
1321: p_attribute8 IN ar_cash_receipts.attribute8%TYPE,
1322: p_attribute9 IN ar_cash_receipts.attribute9%TYPE,
1323: p_attribute10 IN ar_cash_receipts.attribute10%TYPE,

Line 1320: p_attribute7 IN ar_cash_receipts.attribute7%TYPE,

1316: p_attribute3 IN ar_cash_receipts.attribute3%TYPE,
1317: p_attribute4 IN ar_cash_receipts.attribute4%TYPE,
1318: p_attribute5 IN ar_cash_receipts.attribute5%TYPE,
1319: p_attribute6 IN ar_cash_receipts.attribute6%TYPE,
1320: p_attribute7 IN ar_cash_receipts.attribute7%TYPE,
1321: p_attribute8 IN ar_cash_receipts.attribute8%TYPE,
1322: p_attribute9 IN ar_cash_receipts.attribute9%TYPE,
1323: p_attribute10 IN ar_cash_receipts.attribute10%TYPE,
1324: p_attribute11 IN ar_cash_receipts.attribute11%TYPE,

Line 1321: p_attribute8 IN ar_cash_receipts.attribute8%TYPE,

1317: p_attribute4 IN ar_cash_receipts.attribute4%TYPE,
1318: p_attribute5 IN ar_cash_receipts.attribute5%TYPE,
1319: p_attribute6 IN ar_cash_receipts.attribute6%TYPE,
1320: p_attribute7 IN ar_cash_receipts.attribute7%TYPE,
1321: p_attribute8 IN ar_cash_receipts.attribute8%TYPE,
1322: p_attribute9 IN ar_cash_receipts.attribute9%TYPE,
1323: p_attribute10 IN ar_cash_receipts.attribute10%TYPE,
1324: p_attribute11 IN ar_cash_receipts.attribute11%TYPE,
1325: p_attribute12 IN ar_cash_receipts.attribute12%TYPE,

Line 1322: p_attribute9 IN ar_cash_receipts.attribute9%TYPE,

1318: p_attribute5 IN ar_cash_receipts.attribute5%TYPE,
1319: p_attribute6 IN ar_cash_receipts.attribute6%TYPE,
1320: p_attribute7 IN ar_cash_receipts.attribute7%TYPE,
1321: p_attribute8 IN ar_cash_receipts.attribute8%TYPE,
1322: p_attribute9 IN ar_cash_receipts.attribute9%TYPE,
1323: p_attribute10 IN ar_cash_receipts.attribute10%TYPE,
1324: p_attribute11 IN ar_cash_receipts.attribute11%TYPE,
1325: p_attribute12 IN ar_cash_receipts.attribute12%TYPE,
1326: p_attribute13 IN ar_cash_receipts.attribute13%TYPE,

Line 1323: p_attribute10 IN ar_cash_receipts.attribute10%TYPE,

1319: p_attribute6 IN ar_cash_receipts.attribute6%TYPE,
1320: p_attribute7 IN ar_cash_receipts.attribute7%TYPE,
1321: p_attribute8 IN ar_cash_receipts.attribute8%TYPE,
1322: p_attribute9 IN ar_cash_receipts.attribute9%TYPE,
1323: p_attribute10 IN ar_cash_receipts.attribute10%TYPE,
1324: p_attribute11 IN ar_cash_receipts.attribute11%TYPE,
1325: p_attribute12 IN ar_cash_receipts.attribute12%TYPE,
1326: p_attribute13 IN ar_cash_receipts.attribute13%TYPE,
1327: p_attribute14 IN ar_cash_receipts.attribute14%TYPE,

Line 1324: p_attribute11 IN ar_cash_receipts.attribute11%TYPE,

1320: p_attribute7 IN ar_cash_receipts.attribute7%TYPE,
1321: p_attribute8 IN ar_cash_receipts.attribute8%TYPE,
1322: p_attribute9 IN ar_cash_receipts.attribute9%TYPE,
1323: p_attribute10 IN ar_cash_receipts.attribute10%TYPE,
1324: p_attribute11 IN ar_cash_receipts.attribute11%TYPE,
1325: p_attribute12 IN ar_cash_receipts.attribute12%TYPE,
1326: p_attribute13 IN ar_cash_receipts.attribute13%TYPE,
1327: p_attribute14 IN ar_cash_receipts.attribute14%TYPE,
1328: p_attribute15 IN ar_cash_receipts.attribute15%TYPE ) IS

Line 1325: p_attribute12 IN ar_cash_receipts.attribute12%TYPE,

1321: p_attribute8 IN ar_cash_receipts.attribute8%TYPE,
1322: p_attribute9 IN ar_cash_receipts.attribute9%TYPE,
1323: p_attribute10 IN ar_cash_receipts.attribute10%TYPE,
1324: p_attribute11 IN ar_cash_receipts.attribute11%TYPE,
1325: p_attribute12 IN ar_cash_receipts.attribute12%TYPE,
1326: p_attribute13 IN ar_cash_receipts.attribute13%TYPE,
1327: p_attribute14 IN ar_cash_receipts.attribute14%TYPE,
1328: p_attribute15 IN ar_cash_receipts.attribute15%TYPE ) IS
1329: BEGIN

Line 1326: p_attribute13 IN ar_cash_receipts.attribute13%TYPE,

1322: p_attribute9 IN ar_cash_receipts.attribute9%TYPE,
1323: p_attribute10 IN ar_cash_receipts.attribute10%TYPE,
1324: p_attribute11 IN ar_cash_receipts.attribute11%TYPE,
1325: p_attribute12 IN ar_cash_receipts.attribute12%TYPE,
1326: p_attribute13 IN ar_cash_receipts.attribute13%TYPE,
1327: p_attribute14 IN ar_cash_receipts.attribute14%TYPE,
1328: p_attribute15 IN ar_cash_receipts.attribute15%TYPE ) IS
1329: BEGIN
1330: IF PG_DEBUG in ('Y', 'C') THEN

Line 1327: p_attribute14 IN ar_cash_receipts.attribute14%TYPE,

1323: p_attribute10 IN ar_cash_receipts.attribute10%TYPE,
1324: p_attribute11 IN ar_cash_receipts.attribute11%TYPE,
1325: p_attribute12 IN ar_cash_receipts.attribute12%TYPE,
1326: p_attribute13 IN ar_cash_receipts.attribute13%TYPE,
1327: p_attribute14 IN ar_cash_receipts.attribute14%TYPE,
1328: p_attribute15 IN ar_cash_receipts.attribute15%TYPE ) IS
1329: BEGIN
1330: IF PG_DEBUG in ('Y', 'C') THEN
1331: arp_standard.debug( 'arp_reverse_receipt.update_current_cr_rec() +' );

Line 1328: p_attribute15 IN ar_cash_receipts.attribute15%TYPE ) IS

1324: p_attribute11 IN ar_cash_receipts.attribute11%TYPE,
1325: p_attribute12 IN ar_cash_receipts.attribute12%TYPE,
1326: p_attribute13 IN ar_cash_receipts.attribute13%TYPE,
1327: p_attribute14 IN ar_cash_receipts.attribute14%TYPE,
1328: p_attribute15 IN ar_cash_receipts.attribute15%TYPE ) IS
1329: BEGIN
1330: IF PG_DEBUG in ('Y', 'C') THEN
1331: arp_standard.debug( 'arp_reverse_receipt.update_current_cr_rec() +' );
1332: END IF;

Line 1405: p_cr_amount IN ar_cash_receipts.amount%TYPE,

1401: | By definition - These 2 columns will no |
1402: | longer will be updated. |
1403: +===========================================================================*/
1404: PROCEDURE modify_update_bat_rec( p_bat_id IN ar_batches.batch_id%TYPE,
1405: p_cr_amount IN ar_cash_receipts.amount%TYPE,
1406: p_status IN VARCHAR2 ) IS
1407: l_bat_rec ar_batches%ROWTYPE;
1408: l_status ar_batches.status%TYPE;
1409: BEGIN

Line 1562: p_cr_rec IN OUT NOCOPY ar_cash_receipts%ROWTYPE,

1558: | cursor bill_to_customer_C |
1559: +===========================================================================*/
1560:
1561: PROCEDURE debit_memo_reversal(
1562: p_cr_rec IN OUT NOCOPY ar_cash_receipts%ROWTYPE,
1563: p_cc_id IN ra_cust_trx_line_gl_dist.code_combination_id%TYPE,
1564: p_cust_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
1565: p_cust_trx_type IN ra_cust_trx_types.name%TYPE,
1566: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE,

Line 1567: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE,

1563: p_cc_id IN ra_cust_trx_line_gl_dist.code_combination_id%TYPE,
1564: p_cust_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
1565: p_cust_trx_type IN ra_cust_trx_types.name%TYPE,
1566: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE,
1567: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE,
1568: p_reversal_category IN ar_cash_receipts.reversal_category%TYPE,
1569: p_reversal_reason_code IN
1570: ar_cash_receipts.reversal_reason_code%TYPE,
1571: p_reversal_comments IN ar_cash_receipts.reversal_comments%TYPE,

Line 1568: p_reversal_category IN ar_cash_receipts.reversal_category%TYPE,

1564: p_cust_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
1565: p_cust_trx_type IN ra_cust_trx_types.name%TYPE,
1566: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE,
1567: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE,
1568: p_reversal_category IN ar_cash_receipts.reversal_category%TYPE,
1569: p_reversal_reason_code IN
1570: ar_cash_receipts.reversal_reason_code%TYPE,
1571: p_reversal_comments IN ar_cash_receipts.reversal_comments%TYPE,
1572: p_attribute_category IN ar_cash_receipts.attribute_category%TYPE,

Line 1570: ar_cash_receipts.reversal_reason_code%TYPE,

1566: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE,
1567: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE,
1568: p_reversal_category IN ar_cash_receipts.reversal_category%TYPE,
1569: p_reversal_reason_code IN
1570: ar_cash_receipts.reversal_reason_code%TYPE,
1571: p_reversal_comments IN ar_cash_receipts.reversal_comments%TYPE,
1572: p_attribute_category IN ar_cash_receipts.attribute_category%TYPE,
1573: p_attribute1 IN ar_cash_receipts.attribute1%TYPE,
1574: p_attribute2 IN ar_cash_receipts.attribute2%TYPE,

Line 1571: p_reversal_comments IN ar_cash_receipts.reversal_comments%TYPE,

1567: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE,
1568: p_reversal_category IN ar_cash_receipts.reversal_category%TYPE,
1569: p_reversal_reason_code IN
1570: ar_cash_receipts.reversal_reason_code%TYPE,
1571: p_reversal_comments IN ar_cash_receipts.reversal_comments%TYPE,
1572: p_attribute_category IN ar_cash_receipts.attribute_category%TYPE,
1573: p_attribute1 IN ar_cash_receipts.attribute1%TYPE,
1574: p_attribute2 IN ar_cash_receipts.attribute2%TYPE,
1575: p_attribute3 IN ar_cash_receipts.attribute3%TYPE,

Line 1572: p_attribute_category IN ar_cash_receipts.attribute_category%TYPE,

1568: p_reversal_category IN ar_cash_receipts.reversal_category%TYPE,
1569: p_reversal_reason_code IN
1570: ar_cash_receipts.reversal_reason_code%TYPE,
1571: p_reversal_comments IN ar_cash_receipts.reversal_comments%TYPE,
1572: p_attribute_category IN ar_cash_receipts.attribute_category%TYPE,
1573: p_attribute1 IN ar_cash_receipts.attribute1%TYPE,
1574: p_attribute2 IN ar_cash_receipts.attribute2%TYPE,
1575: p_attribute3 IN ar_cash_receipts.attribute3%TYPE,
1576: p_attribute4 IN ar_cash_receipts.attribute4%TYPE,

Line 1573: p_attribute1 IN ar_cash_receipts.attribute1%TYPE,

1569: p_reversal_reason_code IN
1570: ar_cash_receipts.reversal_reason_code%TYPE,
1571: p_reversal_comments IN ar_cash_receipts.reversal_comments%TYPE,
1572: p_attribute_category IN ar_cash_receipts.attribute_category%TYPE,
1573: p_attribute1 IN ar_cash_receipts.attribute1%TYPE,
1574: p_attribute2 IN ar_cash_receipts.attribute2%TYPE,
1575: p_attribute3 IN ar_cash_receipts.attribute3%TYPE,
1576: p_attribute4 IN ar_cash_receipts.attribute4%TYPE,
1577: p_attribute5 IN ar_cash_receipts.attribute5%TYPE,

Line 1574: p_attribute2 IN ar_cash_receipts.attribute2%TYPE,

1570: ar_cash_receipts.reversal_reason_code%TYPE,
1571: p_reversal_comments IN ar_cash_receipts.reversal_comments%TYPE,
1572: p_attribute_category IN ar_cash_receipts.attribute_category%TYPE,
1573: p_attribute1 IN ar_cash_receipts.attribute1%TYPE,
1574: p_attribute2 IN ar_cash_receipts.attribute2%TYPE,
1575: p_attribute3 IN ar_cash_receipts.attribute3%TYPE,
1576: p_attribute4 IN ar_cash_receipts.attribute4%TYPE,
1577: p_attribute5 IN ar_cash_receipts.attribute5%TYPE,
1578: p_attribute6 IN ar_cash_receipts.attribute6%TYPE,

Line 1575: p_attribute3 IN ar_cash_receipts.attribute3%TYPE,

1571: p_reversal_comments IN ar_cash_receipts.reversal_comments%TYPE,
1572: p_attribute_category IN ar_cash_receipts.attribute_category%TYPE,
1573: p_attribute1 IN ar_cash_receipts.attribute1%TYPE,
1574: p_attribute2 IN ar_cash_receipts.attribute2%TYPE,
1575: p_attribute3 IN ar_cash_receipts.attribute3%TYPE,
1576: p_attribute4 IN ar_cash_receipts.attribute4%TYPE,
1577: p_attribute5 IN ar_cash_receipts.attribute5%TYPE,
1578: p_attribute6 IN ar_cash_receipts.attribute6%TYPE,
1579: p_attribute7 IN ar_cash_receipts.attribute7%TYPE,

Line 1576: p_attribute4 IN ar_cash_receipts.attribute4%TYPE,

1572: p_attribute_category IN ar_cash_receipts.attribute_category%TYPE,
1573: p_attribute1 IN ar_cash_receipts.attribute1%TYPE,
1574: p_attribute2 IN ar_cash_receipts.attribute2%TYPE,
1575: p_attribute3 IN ar_cash_receipts.attribute3%TYPE,
1576: p_attribute4 IN ar_cash_receipts.attribute4%TYPE,
1577: p_attribute5 IN ar_cash_receipts.attribute5%TYPE,
1578: p_attribute6 IN ar_cash_receipts.attribute6%TYPE,
1579: p_attribute7 IN ar_cash_receipts.attribute7%TYPE,
1580: p_attribute8 IN ar_cash_receipts.attribute8%TYPE,

Line 1577: p_attribute5 IN ar_cash_receipts.attribute5%TYPE,

1573: p_attribute1 IN ar_cash_receipts.attribute1%TYPE,
1574: p_attribute2 IN ar_cash_receipts.attribute2%TYPE,
1575: p_attribute3 IN ar_cash_receipts.attribute3%TYPE,
1576: p_attribute4 IN ar_cash_receipts.attribute4%TYPE,
1577: p_attribute5 IN ar_cash_receipts.attribute5%TYPE,
1578: p_attribute6 IN ar_cash_receipts.attribute6%TYPE,
1579: p_attribute7 IN ar_cash_receipts.attribute7%TYPE,
1580: p_attribute8 IN ar_cash_receipts.attribute8%TYPE,
1581: p_attribute9 IN ar_cash_receipts.attribute9%TYPE,

Line 1578: p_attribute6 IN ar_cash_receipts.attribute6%TYPE,

1574: p_attribute2 IN ar_cash_receipts.attribute2%TYPE,
1575: p_attribute3 IN ar_cash_receipts.attribute3%TYPE,
1576: p_attribute4 IN ar_cash_receipts.attribute4%TYPE,
1577: p_attribute5 IN ar_cash_receipts.attribute5%TYPE,
1578: p_attribute6 IN ar_cash_receipts.attribute6%TYPE,
1579: p_attribute7 IN ar_cash_receipts.attribute7%TYPE,
1580: p_attribute8 IN ar_cash_receipts.attribute8%TYPE,
1581: p_attribute9 IN ar_cash_receipts.attribute9%TYPE,
1582: p_attribute10 IN ar_cash_receipts.attribute10%TYPE,

Line 1579: p_attribute7 IN ar_cash_receipts.attribute7%TYPE,

1575: p_attribute3 IN ar_cash_receipts.attribute3%TYPE,
1576: p_attribute4 IN ar_cash_receipts.attribute4%TYPE,
1577: p_attribute5 IN ar_cash_receipts.attribute5%TYPE,
1578: p_attribute6 IN ar_cash_receipts.attribute6%TYPE,
1579: p_attribute7 IN ar_cash_receipts.attribute7%TYPE,
1580: p_attribute8 IN ar_cash_receipts.attribute8%TYPE,
1581: p_attribute9 IN ar_cash_receipts.attribute9%TYPE,
1582: p_attribute10 IN ar_cash_receipts.attribute10%TYPE,
1583: p_attribute11 IN ar_cash_receipts.attribute11%TYPE,

Line 1580: p_attribute8 IN ar_cash_receipts.attribute8%TYPE,

1576: p_attribute4 IN ar_cash_receipts.attribute4%TYPE,
1577: p_attribute5 IN ar_cash_receipts.attribute5%TYPE,
1578: p_attribute6 IN ar_cash_receipts.attribute6%TYPE,
1579: p_attribute7 IN ar_cash_receipts.attribute7%TYPE,
1580: p_attribute8 IN ar_cash_receipts.attribute8%TYPE,
1581: p_attribute9 IN ar_cash_receipts.attribute9%TYPE,
1582: p_attribute10 IN ar_cash_receipts.attribute10%TYPE,
1583: p_attribute11 IN ar_cash_receipts.attribute11%TYPE,
1584: p_attribute12 IN ar_cash_receipts.attribute12%TYPE,

Line 1581: p_attribute9 IN ar_cash_receipts.attribute9%TYPE,

1577: p_attribute5 IN ar_cash_receipts.attribute5%TYPE,
1578: p_attribute6 IN ar_cash_receipts.attribute6%TYPE,
1579: p_attribute7 IN ar_cash_receipts.attribute7%TYPE,
1580: p_attribute8 IN ar_cash_receipts.attribute8%TYPE,
1581: p_attribute9 IN ar_cash_receipts.attribute9%TYPE,
1582: p_attribute10 IN ar_cash_receipts.attribute10%TYPE,
1583: p_attribute11 IN ar_cash_receipts.attribute11%TYPE,
1584: p_attribute12 IN ar_cash_receipts.attribute12%TYPE,
1585: p_attribute13 IN ar_cash_receipts.attribute13%TYPE,

Line 1582: p_attribute10 IN ar_cash_receipts.attribute10%TYPE,

1578: p_attribute6 IN ar_cash_receipts.attribute6%TYPE,
1579: p_attribute7 IN ar_cash_receipts.attribute7%TYPE,
1580: p_attribute8 IN ar_cash_receipts.attribute8%TYPE,
1581: p_attribute9 IN ar_cash_receipts.attribute9%TYPE,
1582: p_attribute10 IN ar_cash_receipts.attribute10%TYPE,
1583: p_attribute11 IN ar_cash_receipts.attribute11%TYPE,
1584: p_attribute12 IN ar_cash_receipts.attribute12%TYPE,
1585: p_attribute13 IN ar_cash_receipts.attribute13%TYPE,
1586: p_attribute14 IN ar_cash_receipts.attribute14%TYPE,

Line 1583: p_attribute11 IN ar_cash_receipts.attribute11%TYPE,

1579: p_attribute7 IN ar_cash_receipts.attribute7%TYPE,
1580: p_attribute8 IN ar_cash_receipts.attribute8%TYPE,
1581: p_attribute9 IN ar_cash_receipts.attribute9%TYPE,
1582: p_attribute10 IN ar_cash_receipts.attribute10%TYPE,
1583: p_attribute11 IN ar_cash_receipts.attribute11%TYPE,
1584: p_attribute12 IN ar_cash_receipts.attribute12%TYPE,
1585: p_attribute13 IN ar_cash_receipts.attribute13%TYPE,
1586: p_attribute14 IN ar_cash_receipts.attribute14%TYPE,
1587: p_attribute15 IN ar_cash_receipts.attribute15%TYPE,

Line 1584: p_attribute12 IN ar_cash_receipts.attribute12%TYPE,

1580: p_attribute8 IN ar_cash_receipts.attribute8%TYPE,
1581: p_attribute9 IN ar_cash_receipts.attribute9%TYPE,
1582: p_attribute10 IN ar_cash_receipts.attribute10%TYPE,
1583: p_attribute11 IN ar_cash_receipts.attribute11%TYPE,
1584: p_attribute12 IN ar_cash_receipts.attribute12%TYPE,
1585: p_attribute13 IN ar_cash_receipts.attribute13%TYPE,
1586: p_attribute14 IN ar_cash_receipts.attribute14%TYPE,
1587: p_attribute15 IN ar_cash_receipts.attribute15%TYPE,
1588: p_dm_number OUT NOCOPY ar_payment_schedules.trx_number%TYPE,

Line 1585: p_attribute13 IN ar_cash_receipts.attribute13%TYPE,

1581: p_attribute9 IN ar_cash_receipts.attribute9%TYPE,
1582: p_attribute10 IN ar_cash_receipts.attribute10%TYPE,
1583: p_attribute11 IN ar_cash_receipts.attribute11%TYPE,
1584: p_attribute12 IN ar_cash_receipts.attribute12%TYPE,
1585: p_attribute13 IN ar_cash_receipts.attribute13%TYPE,
1586: p_attribute14 IN ar_cash_receipts.attribute14%TYPE,
1587: p_attribute15 IN ar_cash_receipts.attribute15%TYPE,
1588: p_dm_number OUT NOCOPY ar_payment_schedules.trx_number%TYPE,
1589: p_dm_doc_sequence_value IN ra_customer_trx.doc_sequence_value%TYPE,

Line 1586: p_attribute14 IN ar_cash_receipts.attribute14%TYPE,

1582: p_attribute10 IN ar_cash_receipts.attribute10%TYPE,
1583: p_attribute11 IN ar_cash_receipts.attribute11%TYPE,
1584: p_attribute12 IN ar_cash_receipts.attribute12%TYPE,
1585: p_attribute13 IN ar_cash_receipts.attribute13%TYPE,
1586: p_attribute14 IN ar_cash_receipts.attribute14%TYPE,
1587: p_attribute15 IN ar_cash_receipts.attribute15%TYPE,
1588: p_dm_number OUT NOCOPY ar_payment_schedules.trx_number%TYPE,
1589: p_dm_doc_sequence_value IN ra_customer_trx.doc_sequence_value%TYPE,
1590: p_dm_doc_sequence_id IN ra_customer_trx.doc_sequence_id%TYPE,

Line 1587: p_attribute15 IN ar_cash_receipts.attribute15%TYPE,

1583: p_attribute11 IN ar_cash_receipts.attribute11%TYPE,
1584: p_attribute12 IN ar_cash_receipts.attribute12%TYPE,
1585: p_attribute13 IN ar_cash_receipts.attribute13%TYPE,
1586: p_attribute14 IN ar_cash_receipts.attribute14%TYPE,
1587: p_attribute15 IN ar_cash_receipts.attribute15%TYPE,
1588: p_dm_number OUT NOCOPY ar_payment_schedules.trx_number%TYPE,
1589: p_dm_doc_sequence_value IN ra_customer_trx.doc_sequence_value%TYPE,
1590: p_dm_doc_sequence_id IN ra_customer_trx.doc_sequence_id%TYPE,
1591: p_status IN OUT NOCOPY VARCHAR2,

Line 1596: l_receipt_number ar_cash_receipts.receipt_number%TYPE;

1592: p_module_name IN VARCHAR2,
1593: p_module_version IN VARCHAR2 ) IS
1594:
1595: l_receipt_method_name ar_receipt_methods.name%TYPE;
1596: l_receipt_number ar_cash_receipts.receipt_number%TYPE;
1597: l_customer_id ar_cash_receipts.pay_from_customer%TYPE;
1598:
1599: l_currency_code ar_cash_receipts.currency_code%TYPE;
1600: l_exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE;

Line 1597: l_customer_id ar_cash_receipts.pay_from_customer%TYPE;

1593: p_module_version IN VARCHAR2 ) IS
1594:
1595: l_receipt_method_name ar_receipt_methods.name%TYPE;
1596: l_receipt_number ar_cash_receipts.receipt_number%TYPE;
1597: l_customer_id ar_cash_receipts.pay_from_customer%TYPE;
1598:
1599: l_currency_code ar_cash_receipts.currency_code%TYPE;
1600: l_exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE;
1601: l_exchange_rate ar_cash_receipts.exchange_rate%TYPE;

Line 1599: l_currency_code ar_cash_receipts.currency_code%TYPE;

1595: l_receipt_method_name ar_receipt_methods.name%TYPE;
1596: l_receipt_number ar_cash_receipts.receipt_number%TYPE;
1597: l_customer_id ar_cash_receipts.pay_from_customer%TYPE;
1598:
1599: l_currency_code ar_cash_receipts.currency_code%TYPE;
1600: l_exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE;
1601: l_exchange_rate ar_cash_receipts.exchange_rate%TYPE;
1602: l_exchange_date ar_cash_receipts.exchange_date%TYPE;
1603:

Line 1600: l_exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE;

1596: l_receipt_number ar_cash_receipts.receipt_number%TYPE;
1597: l_customer_id ar_cash_receipts.pay_from_customer%TYPE;
1598:
1599: l_currency_code ar_cash_receipts.currency_code%TYPE;
1600: l_exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE;
1601: l_exchange_rate ar_cash_receipts.exchange_rate%TYPE;
1602: l_exchange_date ar_cash_receipts.exchange_date%TYPE;
1603:
1604: l_amount ar_cash_receipts.amount%TYPE;

Line 1601: l_exchange_rate ar_cash_receipts.exchange_rate%TYPE;

1597: l_customer_id ar_cash_receipts.pay_from_customer%TYPE;
1598:
1599: l_currency_code ar_cash_receipts.currency_code%TYPE;
1600: l_exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE;
1601: l_exchange_rate ar_cash_receipts.exchange_rate%TYPE;
1602: l_exchange_date ar_cash_receipts.exchange_date%TYPE;
1603:
1604: l_amount ar_cash_receipts.amount%TYPE;
1605:

Line 1602: l_exchange_date ar_cash_receipts.exchange_date%TYPE;

1598:
1599: l_currency_code ar_cash_receipts.currency_code%TYPE;
1600: l_exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE;
1601: l_exchange_rate ar_cash_receipts.exchange_rate%TYPE;
1602: l_exchange_date ar_cash_receipts.exchange_date%TYPE;
1603:
1604: l_amount ar_cash_receipts.amount%TYPE;
1605:
1606: l_description ra_customer_trx_lines.description%TYPE;

Line 1604: l_amount ar_cash_receipts.amount%TYPE;

1600: l_exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE;
1601: l_exchange_rate ar_cash_receipts.exchange_rate%TYPE;
1602: l_exchange_date ar_cash_receipts.exchange_date%TYPE;
1603:
1604: l_amount ar_cash_receipts.amount%TYPE;
1605:
1606: l_description ra_customer_trx_lines.description%TYPE;
1607:
1608: l_rev1_cc_id ar_cash_receipt_history.account_code_combination_id%TYPE;

Line 1658: l_site_use_id ar_cash_receipts.customer_site_use_id%TYPE ) IS

1654: * Cursor customer_C was split into two separate cursors for performance
1655: * reasons */
1656: -- Added 2nd i/p parameter to fix bug 1063133
1657: CURSOR bill_to_customer_C( l_customer_id hz_cust_accounts.cust_account_id%TYPE,
1658: l_site_use_id ar_cash_receipts.customer_site_use_id%TYPE ) IS
1659: SELECT su1.site_use_id site_use_id,
1660: su1.cust_acct_site_id address_id
1661: FROM hz_cust_site_uses su1,
1662: hz_cust_acct_sites add1

Line 1746: , ar_cash_receipts cr

1742: l_dm_inherit_rcpt_num_flag,
1743: l_legal_entity_id --5126184
1744: FROM
1745: ar_receipt_methods rm
1746: , ar_cash_receipts cr
1747: WHERE cr.cash_receipt_id = l_cr_id
1748: AND rm.receipt_method_id = cr.receipt_method_id;
1749: --
1750: -- Get description to be used during RA_CUSTOMER_TRX_LINES insertion

Line 2156: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,

2152: | MODIFICATION HISTORY - Created by Ganesh Vaidee - 04/25/95 |
2153: | |
2154: +===========================================================================*/
2155: PROCEDURE validate_dm_reversal_args(
2156: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
2157: p_cc_id IN ra_cust_trx_line_gl_dist.code_combination_id%TYPE,
2158: p_cust_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
2159: p_reversal_gl_date IN
2160: ar_cash_receipt_history.reversal_gl_date%TYPE,

Line 2162: ar_cash_receipts.reversal_date%TYPE,

2158: p_cust_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
2159: p_reversal_gl_date IN
2160: ar_cash_receipt_history.reversal_gl_date%TYPE,
2161: p_reversal_date IN
2162: ar_cash_receipts.reversal_date%TYPE,
2163: p_reversal_reason_code IN VARCHAR2) IS
2164: BEGIN
2165: IF PG_DEBUG in ('Y', 'C') THEN
2166: arp_standard.debug( 'arp_reverse_receipt.validate_dm_reversal_args() +');

Line 2216: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,

2212: | jbeckett 01-MAY-02 Bug 2353144 - use check_cancel_deduction function to |
2213: | determine if claim is cancellable |
2214: +===========================================================================*/
2215: FUNCTION receipt_has_non_cancel_claims(
2216: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
2217: p_include_trx_claims IN VARCHAR2 DEFAULT 'Y')
2218: RETURN BOOLEAN
2219: IS
2220: CURSOR c_claim_count IS

Line 2400: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE)

2396: | |
2397: | jbeckett 24-JUN-02 Created (bug 2420941) |
2398: +===========================================================================*/
2399: FUNCTION receipt_has_claims(
2400: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE)
2401: RETURN BOOLEAN
2402: IS
2403: CURSOR c_claim_count IS
2404: SELECT count(*)

Line 2461: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,

2457: | |
2458: | jbeckett 16-JUL-03 Created (bug 3048023) |
2459: +===========================================================================*/
2460: PROCEDURE check_netted_receipts(
2461: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
2462: x_return_status OUT NOCOPY VARCHAR2)
2463: IS
2464:
2465: CURSOR c_netted_receipts IS

Line 2534: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE)

2530: | |
2531: | jbeckett 23-DEC-05 Created (bug 4861233) |
2532: +===========================================================================*/
2533: FUNCTION receipt_has_processed_refunds(
2534: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE)
2535: RETURN BOOLEAN
2536: IS
2537:
2538: CURSOR c_refunds IS