76:
77: PROCEDURE receipt_application(
78: p_receipt_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
79: p_invoice_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
80: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
81: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE,
82: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE,
83: p_invoice_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,
84: p_receipt_currency_code IN ar_cash_receipts.currency_code%TYPE,
77: PROCEDURE receipt_application(
78: p_receipt_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
79: p_invoice_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
80: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
81: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE,
82: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE,
83: p_invoice_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,
84: p_receipt_currency_code IN ar_cash_receipts.currency_code%TYPE,
85: p_earned_discount_taken IN ar_receivable_applications.earned_discount_taken%TYPE,
78: p_receipt_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
79: p_invoice_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
80: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
81: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE,
82: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE,
83: p_invoice_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,
84: p_receipt_currency_code IN ar_cash_receipts.currency_code%TYPE,
85: p_earned_discount_taken IN ar_receivable_applications.earned_discount_taken%TYPE,
86: p_unearned_discount_taken IN ar_receivable_applications.unearned_discount_taken%TYPE,
81: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE,
82: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE,
83: p_invoice_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,
84: p_receipt_currency_code IN ar_cash_receipts.currency_code%TYPE,
85: p_earned_discount_taken IN ar_receivable_applications.earned_discount_taken%TYPE,
86: p_unearned_discount_taken IN ar_receivable_applications.unearned_discount_taken%TYPE,
87: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
88: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
89: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE,
82: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE,
83: p_invoice_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,
84: p_receipt_currency_code IN ar_cash_receipts.currency_code%TYPE,
85: p_earned_discount_taken IN ar_receivable_applications.earned_discount_taken%TYPE,
86: p_unearned_discount_taken IN ar_receivable_applications.unearned_discount_taken%TYPE,
87: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
88: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
89: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE,
90: p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%TYPE,
83: p_invoice_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,
84: p_receipt_currency_code IN ar_cash_receipts.currency_code%TYPE,
85: p_earned_discount_taken IN ar_receivable_applications.earned_discount_taken%TYPE,
86: p_unearned_discount_taken IN ar_receivable_applications.unearned_discount_taken%TYPE,
87: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
88: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
89: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE,
90: p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%TYPE,
91: p_application_ref_type IN
84: p_receipt_currency_code IN ar_cash_receipts.currency_code%TYPE,
85: p_earned_discount_taken IN ar_receivable_applications.earned_discount_taken%TYPE,
86: p_unearned_discount_taken IN ar_receivable_applications.unearned_discount_taken%TYPE,
87: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
88: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
89: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE,
90: p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%TYPE,
91: p_application_ref_type IN
92: ar_receivable_applications.application_ref_type%TYPE,
85: p_earned_discount_taken IN ar_receivable_applications.earned_discount_taken%TYPE,
86: p_unearned_discount_taken IN ar_receivable_applications.unearned_discount_taken%TYPE,
87: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
88: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
89: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE,
90: p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%TYPE,
91: p_application_ref_type IN
92: ar_receivable_applications.application_ref_type%TYPE,
93: p_application_ref_id IN
86: p_unearned_discount_taken IN ar_receivable_applications.unearned_discount_taken%TYPE,
87: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
88: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
89: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE,
90: p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%TYPE,
91: p_application_ref_type IN
92: ar_receivable_applications.application_ref_type%TYPE,
93: p_application_ref_id IN
94: ar_receivable_applications.application_ref_id%TYPE,
88: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
89: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE,
90: p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%TYPE,
91: p_application_ref_type IN
92: ar_receivable_applications.application_ref_type%TYPE,
93: p_application_ref_id IN
94: ar_receivable_applications.application_ref_id%TYPE,
95: p_application_ref_num IN
96: ar_receivable_applications.application_ref_num%TYPE,
90: p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%TYPE,
91: p_application_ref_type IN
92: ar_receivable_applications.application_ref_type%TYPE,
93: p_application_ref_id IN
94: ar_receivable_applications.application_ref_id%TYPE,
95: p_application_ref_num IN
96: ar_receivable_applications.application_ref_num%TYPE,
97: p_secondary_application_ref_id IN
98: ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
92: ar_receivable_applications.application_ref_type%TYPE,
93: p_application_ref_id IN
94: ar_receivable_applications.application_ref_id%TYPE,
95: p_application_ref_num IN
96: ar_receivable_applications.application_ref_num%TYPE,
97: p_secondary_application_ref_id IN
98: ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
99: p_attribute_category IN ar_receivable_applications.attribute_category%TYPE,
100: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
94: ar_receivable_applications.application_ref_id%TYPE,
95: p_application_ref_num IN
96: ar_receivable_applications.application_ref_num%TYPE,
97: p_secondary_application_ref_id IN
98: ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
99: p_attribute_category IN ar_receivable_applications.attribute_category%TYPE,
100: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
101: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
102: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
95: p_application_ref_num IN
96: ar_receivable_applications.application_ref_num%TYPE,
97: p_secondary_application_ref_id IN
98: ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
99: p_attribute_category IN ar_receivable_applications.attribute_category%TYPE,
100: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
101: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
102: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
103: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
96: ar_receivable_applications.application_ref_num%TYPE,
97: p_secondary_application_ref_id IN
98: ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
99: p_attribute_category IN ar_receivable_applications.attribute_category%TYPE,
100: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
101: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
102: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
103: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
104: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
97: p_secondary_application_ref_id IN
98: ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
99: p_attribute_category IN ar_receivable_applications.attribute_category%TYPE,
100: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
101: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
102: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
103: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
104: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
105: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
98: ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
99: p_attribute_category IN ar_receivable_applications.attribute_category%TYPE,
100: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
101: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
102: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
103: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
104: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
105: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
106: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
99: p_attribute_category IN ar_receivable_applications.attribute_category%TYPE,
100: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
101: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
102: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
103: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
104: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
105: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
106: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
107: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
100: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
101: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
102: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
103: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
104: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
105: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
106: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
107: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
108: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
101: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
102: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
103: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
104: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
105: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
106: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
107: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
108: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
109: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
102: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
103: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
104: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
105: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
106: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
107: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
108: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
109: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
110: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
103: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
104: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
105: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
106: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
107: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
108: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
109: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
110: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
111: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
104: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
105: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
106: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
107: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
108: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
109: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
110: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
111: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
112: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
105: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
106: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
107: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
108: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
109: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
110: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
111: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
112: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
113: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
106: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
107: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
108: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
109: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
110: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
111: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
112: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
113: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
114: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
107: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
108: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
109: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
110: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
111: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
112: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
113: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
114: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
115: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
108: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
109: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
110: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
111: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
112: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
113: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
114: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
115: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
116: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
109: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
110: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
111: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
112: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
113: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
114: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
115: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
116: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
117: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
110: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
111: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
112: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
113: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
114: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
115: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
116: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
117: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
118: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
111: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
112: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
113: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
114: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
115: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
116: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
117: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
118: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
119: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
112: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
113: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
114: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
115: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
116: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
117: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
118: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
119: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
120: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
113: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
114: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
115: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
116: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
117: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
118: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
119: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
120: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
121: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
114: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
115: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
116: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
117: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
118: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
119: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
120: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
121: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
122: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
115: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
116: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
117: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
118: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
119: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
120: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
121: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
122: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
123: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
116: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
117: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
118: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
119: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
120: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
121: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
122: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
123: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
124: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
117: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
118: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
119: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
120: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
121: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
122: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
123: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
124: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
125: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
118: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
119: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
120: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
121: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
122: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
123: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
124: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
125: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
126: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
119: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
120: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
121: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
122: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
123: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
124: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
125: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
126: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
127: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
120: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
121: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
122: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
123: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
124: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
125: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
126: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
127: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
128: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
121: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
122: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
123: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
124: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
125: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
126: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
127: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
128: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
129: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
122: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
123: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
124: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
125: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
126: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
127: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
128: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
129: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
130: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
123: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
124: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
125: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
126: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
127: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
128: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
129: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
130: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
131: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
124: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
125: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
126: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
127: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
128: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
129: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
130: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
131: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
132: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
125: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
126: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
127: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
128: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
129: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
130: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
131: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
132: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
133: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
126: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
127: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
128: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
129: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
130: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
131: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
132: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
133: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
134: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
127: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
128: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
129: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
130: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
131: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
132: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
133: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
134: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
135: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,
128: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
129: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
130: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
131: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
132: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
133: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
134: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
135: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,
136: p_comments IN ar_receivable_applications.comments%TYPE,
129: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
130: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
131: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
132: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
133: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
134: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
135: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,
136: p_comments IN ar_receivable_applications.comments%TYPE,
137: p_module_name IN VARCHAR2,
130: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
131: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
132: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
133: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
134: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
135: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,
136: p_comments IN ar_receivable_applications.comments%TYPE,
137: p_module_name IN VARCHAR2,
138: p_module_version IN VARCHAR2,
131: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
132: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
133: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
134: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
135: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,
136: p_comments IN ar_receivable_applications.comments%TYPE,
137: p_module_name IN VARCHAR2,
138: p_module_version IN VARCHAR2,
139: -- OUT NOCOPY
132: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
133: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
134: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
135: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,
136: p_comments IN ar_receivable_applications.comments%TYPE,
137: p_module_name IN VARCHAR2,
138: p_module_version IN VARCHAR2,
139: -- OUT NOCOPY
140: x_application_ref_id OUT NOCOPY
137: p_module_name IN VARCHAR2,
138: p_module_version IN VARCHAR2,
139: -- OUT NOCOPY
140: x_application_ref_id OUT NOCOPY
141: ar_receivable_applications.application_ref_id%TYPE,
142: x_application_ref_num OUT NOCOPY
143: ar_receivable_applications.application_ref_num%TYPE,
144: x_return_status OUT NOCOPY VARCHAR2,
145: x_msg_count OUT NOCOPY NUMBER,
139: -- OUT NOCOPY
140: x_application_ref_id OUT NOCOPY
141: ar_receivable_applications.application_ref_id%TYPE,
142: x_application_ref_num OUT NOCOPY
143: ar_receivable_applications.application_ref_num%TYPE,
144: x_return_status OUT NOCOPY VARCHAR2,
145: x_msg_count OUT NOCOPY NUMBER,
146: x_msg_data OUT NOCOPY VARCHAR2,
147: p_out_rec_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
143: ar_receivable_applications.application_ref_num%TYPE,
144: x_return_status OUT NOCOPY VARCHAR2,
145: x_msg_count OUT NOCOPY NUMBER,
146: x_msg_data OUT NOCOPY VARCHAR2,
147: p_out_rec_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
148: p_acctd_amount_applied_from OUT NOCOPY ar_receivable_applications.acctd_amount_applied_from%TYPE,
149: p_acctd_amount_applied_to OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,
150: x_claim_reason_name OUT NOCOPY VARCHAR2,
151: p_called_from IN VARCHAR2 DEFAULT NULL, /* jrautiai BR implementation */
144: x_return_status OUT NOCOPY VARCHAR2,
145: x_msg_count OUT NOCOPY NUMBER,
146: x_msg_data OUT NOCOPY VARCHAR2,
147: p_out_rec_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
148: p_acctd_amount_applied_from OUT NOCOPY ar_receivable_applications.acctd_amount_applied_from%TYPE,
149: p_acctd_amount_applied_to OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,
150: x_claim_reason_name OUT NOCOPY VARCHAR2,
151: p_called_from IN VARCHAR2 DEFAULT NULL, /* jrautiai BR implementation */
152: p_move_deferred_tax IN VARCHAR2 DEFAULT 'Y', /* jrautiai BR implementation */
145: x_msg_count OUT NOCOPY NUMBER,
146: x_msg_data OUT NOCOPY VARCHAR2,
147: p_out_rec_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
148: p_acctd_amount_applied_from OUT NOCOPY ar_receivable_applications.acctd_amount_applied_from%TYPE,
149: p_acctd_amount_applied_to OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,
150: x_claim_reason_name OUT NOCOPY VARCHAR2,
151: p_called_from IN VARCHAR2 DEFAULT NULL, /* jrautiai BR implementation */
152: p_move_deferred_tax IN VARCHAR2 DEFAULT 'Y', /* jrautiai BR implementation */
153: p_link_to_trx_hist_id IN ar_receivable_applications.link_to_trx_hist_id%TYPE DEFAULT NULL, /* jrautiai BR implementation */
149: p_acctd_amount_applied_to OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,
150: x_claim_reason_name OUT NOCOPY VARCHAR2,
151: p_called_from IN VARCHAR2 DEFAULT NULL, /* jrautiai BR implementation */
152: p_move_deferred_tax IN VARCHAR2 DEFAULT 'Y', /* jrautiai BR implementation */
153: p_link_to_trx_hist_id IN ar_receivable_applications.link_to_trx_hist_id%TYPE DEFAULT NULL, /* jrautiai BR implementation */
154: p_amount_due_remaining IN
155: ar_payment_schedules.amount_due_remaining%TYPE DEFAULT NULL,
156: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
157: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL,
152: p_move_deferred_tax IN VARCHAR2 DEFAULT 'Y', /* jrautiai BR implementation */
153: p_link_to_trx_hist_id IN ar_receivable_applications.link_to_trx_hist_id%TYPE DEFAULT NULL, /* jrautiai BR implementation */
154: p_amount_due_remaining IN
155: ar_payment_schedules.amount_due_remaining%TYPE DEFAULT NULL,
156: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
157: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL,
158: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
159: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
160: --{HYUDETUPT
153: p_link_to_trx_hist_id IN ar_receivable_applications.link_to_trx_hist_id%TYPE DEFAULT NULL, /* jrautiai BR implementation */
154: p_amount_due_remaining IN
155: ar_payment_schedules.amount_due_remaining%TYPE DEFAULT NULL,
156: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
157: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL,
158: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
159: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
160: --{HYUDETUPT
161: from_llca_call IN VARCHAR2 DEFAULT 'N',
154: p_amount_due_remaining IN
155: ar_payment_schedules.amount_due_remaining%TYPE DEFAULT NULL,
156: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
157: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL,
158: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
159: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
160: --{HYUDETUPT
161: from_llca_call IN VARCHAR2 DEFAULT 'N',
162: p_gt_id IN NUMBER DEFAULT NULL
155: ar_payment_schedules.amount_due_remaining%TYPE DEFAULT NULL,
156: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
157: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL,
158: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
159: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
160: --{HYUDETUPT
161: from_llca_call IN VARCHAR2 DEFAULT 'N',
162: p_gt_id IN NUMBER DEFAULT NULL
163: --}
165:
166: PROCEDURE cm_application(
167: p_cm_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
168: p_invoice_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
169: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
170: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
171: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
172: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE,
173: p_attribute_category IN ar_receivable_applications.attribute_category%TYPE,
166: PROCEDURE cm_application(
167: p_cm_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
168: p_invoice_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
169: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
170: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
171: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
172: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE,
173: p_attribute_category IN ar_receivable_applications.attribute_category%TYPE,
174: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
167: p_cm_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
168: p_invoice_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
169: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
170: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
171: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
172: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE,
173: p_attribute_category IN ar_receivable_applications.attribute_category%TYPE,
174: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
175: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
168: p_invoice_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
169: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
170: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
171: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
172: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE,
173: p_attribute_category IN ar_receivable_applications.attribute_category%TYPE,
174: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
175: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
176: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
169: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
170: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
171: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
172: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE,
173: p_attribute_category IN ar_receivable_applications.attribute_category%TYPE,
174: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
175: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
176: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
177: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
170: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
171: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
172: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE,
173: p_attribute_category IN ar_receivable_applications.attribute_category%TYPE,
174: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
175: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
176: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
177: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
178: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
171: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
172: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE,
173: p_attribute_category IN ar_receivable_applications.attribute_category%TYPE,
174: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
175: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
176: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
177: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
178: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
179: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
172: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE,
173: p_attribute_category IN ar_receivable_applications.attribute_category%TYPE,
174: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
175: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
176: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
177: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
178: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
179: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
180: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
173: p_attribute_category IN ar_receivable_applications.attribute_category%TYPE,
174: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
175: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
176: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
177: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
178: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
179: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
180: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
181: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
174: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
175: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
176: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
177: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
178: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
179: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
180: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
181: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
182: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
175: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
176: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
177: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
178: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
179: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
180: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
181: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
182: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
183: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
176: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
177: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
178: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
179: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
180: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
181: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
182: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
183: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
184: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
177: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
178: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
179: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
180: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
181: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
182: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
183: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
184: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
185: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
178: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
179: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
180: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
181: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
182: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
183: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
184: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
185: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
186: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
179: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
180: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
181: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
182: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
183: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
184: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
185: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
186: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
187: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
180: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
181: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
182: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
183: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
184: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
185: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
186: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
187: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
188: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
181: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
182: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
183: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
184: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
185: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
186: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
187: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
188: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
189: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
182: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
183: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
184: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
185: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
186: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
187: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
188: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
189: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
190: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
183: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
184: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
185: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
186: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
187: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
188: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
189: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
190: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
191: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
184: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
185: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
186: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
187: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
188: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
189: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
190: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
191: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
192: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
185: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
186: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
187: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
188: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
189: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
190: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
191: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
192: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
193: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
186: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
187: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
188: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
189: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
190: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
191: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
192: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
193: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
194: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
187: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
188: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
189: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
190: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
191: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
192: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
193: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
194: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
195: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
188: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
189: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
190: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
191: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
192: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
193: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
194: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
195: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
196: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
189: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
190: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
191: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
192: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
193: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
194: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
195: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
196: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
197: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
190: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
191: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
192: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
193: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
194: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
195: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
196: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
197: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
198: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
191: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
192: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
193: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
194: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
195: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
196: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
197: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
198: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
199: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
192: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
193: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
194: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
195: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
196: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
197: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
198: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
199: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
200: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
193: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
194: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
195: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
196: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
197: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
198: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
199: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
200: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
201: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
194: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
195: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
196: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
197: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
198: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
199: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
200: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
201: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
202: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
195: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
196: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
197: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
198: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
199: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
200: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
201: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
202: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
203: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
196: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
197: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
198: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
199: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
200: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
201: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
202: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
203: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
204: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
197: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
198: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
199: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
200: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
201: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
202: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
203: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
204: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
205: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
198: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
199: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
200: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
201: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
202: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
203: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
204: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
205: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
206: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
199: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
200: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
201: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
202: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
203: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
204: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
205: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
206: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
207: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
200: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
201: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
202: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
203: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
204: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
205: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
206: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
207: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
208: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
201: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
202: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
203: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
204: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
205: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
206: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
207: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
208: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
209: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,
202: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
203: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
204: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
205: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
206: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
207: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
208: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
209: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,
210: p_customer_trx_line_id IN NUMBER,
203: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
204: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
205: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
206: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
207: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
208: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
209: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,
210: p_customer_trx_line_id IN NUMBER,
211: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL, --Bug 2662270
204: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
205: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
206: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
207: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
208: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
209: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,
210: p_customer_trx_line_id IN NUMBER,
211: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL, --Bug 2662270
212: p_module_name IN VARCHAR2,
205: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
206: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
207: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
208: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
209: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,
210: p_customer_trx_line_id IN NUMBER,
211: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL, --Bug 2662270
212: p_module_name IN VARCHAR2,
213: p_module_version IN VARCHAR2,
207: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
208: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
209: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,
210: p_customer_trx_line_id IN NUMBER,
211: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL, --Bug 2662270
212: p_module_name IN VARCHAR2,
213: p_module_version IN VARCHAR2,
214: -- OUT NOCOPY
215: p_out_rec_application_id OUT NOCOPY NUMBER,
212: p_module_name IN VARCHAR2,
213: p_module_version IN VARCHAR2,
214: -- OUT NOCOPY
215: p_out_rec_application_id OUT NOCOPY NUMBER,
216: p_acctd_amount_applied_from OUT NOCOPY ar_receivable_applications.acctd_amount_applied_from%TYPE,
217: p_acctd_amount_applied_to OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE
218: );
219:
220: PROCEDURE cm_activity_application(
213: p_module_version IN VARCHAR2,
214: -- OUT NOCOPY
215: p_out_rec_application_id OUT NOCOPY NUMBER,
216: p_acctd_amount_applied_from OUT NOCOPY ar_receivable_applications.acctd_amount_applied_from%TYPE,
217: p_acctd_amount_applied_to OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE
218: );
219:
220: PROCEDURE cm_activity_application(
221: p_cm_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
219:
220: PROCEDURE cm_activity_application(
221: p_cm_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
222: p_application_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
223: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
224: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
225: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
226: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE,
227: p_attribute_category IN ar_receivable_applications.attribute_category%TYPE,
220: PROCEDURE cm_activity_application(
221: p_cm_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
222: p_application_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
223: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
224: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
225: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
226: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE,
227: p_attribute_category IN ar_receivable_applications.attribute_category%TYPE,
228: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
221: p_cm_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
222: p_application_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
223: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
224: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
225: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
226: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE,
227: p_attribute_category IN ar_receivable_applications.attribute_category%TYPE,
228: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
229: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
222: p_application_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
223: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
224: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
225: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
226: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE,
227: p_attribute_category IN ar_receivable_applications.attribute_category%TYPE,
228: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
229: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
230: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
223: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
224: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
225: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
226: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE,
227: p_attribute_category IN ar_receivable_applications.attribute_category%TYPE,
228: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
229: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
230: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
231: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
224: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
225: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
226: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE,
227: p_attribute_category IN ar_receivable_applications.attribute_category%TYPE,
228: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
229: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
230: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
231: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
232: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
225: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
226: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE,
227: p_attribute_category IN ar_receivable_applications.attribute_category%TYPE,
228: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
229: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
230: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
231: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
232: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
233: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
226: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE,
227: p_attribute_category IN ar_receivable_applications.attribute_category%TYPE,
228: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
229: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
230: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
231: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
232: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
233: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
234: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
227: p_attribute_category IN ar_receivable_applications.attribute_category%TYPE,
228: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
229: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
230: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
231: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
232: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
233: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
234: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
235: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
228: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
229: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
230: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
231: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
232: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
233: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
234: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
235: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
236: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
229: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
230: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
231: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
232: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
233: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
234: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
235: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
236: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
237: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
230: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
231: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
232: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
233: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
234: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
235: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
236: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
237: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
238: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
231: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
232: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
233: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
234: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
235: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
236: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
237: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
238: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
239: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
232: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
233: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
234: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
235: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
236: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
237: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
238: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
239: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
240: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
233: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
234: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
235: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
236: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
237: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
238: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
239: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
240: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
241: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
234: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
235: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
236: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
237: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
238: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
239: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
240: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
241: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
242: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
235: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
236: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
237: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
238: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
239: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
240: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
241: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
242: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
243: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
236: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
237: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
238: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
239: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
240: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
241: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
242: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
243: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
244: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
237: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
238: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
239: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
240: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
241: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
242: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
243: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
244: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
245: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
238: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
239: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
240: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
241: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
242: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
243: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
244: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
245: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
246: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
239: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
240: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
241: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
242: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
243: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
244: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
245: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
246: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
247: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
240: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
241: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
242: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
243: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
244: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
245: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
246: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
247: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
248: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
241: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
242: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
243: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
244: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
245: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
246: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
247: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
248: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
249: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
242: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
243: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
244: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
245: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
246: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
247: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
248: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
249: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
250: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
243: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
244: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
245: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
246: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
247: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
248: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
249: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
250: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
251: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
244: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
245: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
246: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
247: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
248: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
249: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
250: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
251: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
252: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
245: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
246: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
247: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
248: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
249: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
250: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
251: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
252: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
253: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
246: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
247: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
248: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
249: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
250: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
251: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
252: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
253: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
254: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
247: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
248: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
249: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
250: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
251: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
252: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
253: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
254: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
255: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
248: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
249: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
250: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
251: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
252: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
253: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
254: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
255: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
256: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
249: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
250: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
251: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
252: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
253: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
254: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
255: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
256: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
257: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
250: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
251: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
252: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
253: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
254: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
255: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
256: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
257: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
258: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
251: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
252: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
253: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
254: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
255: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
256: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
257: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
258: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
259: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
252: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
253: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
254: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
255: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
256: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
257: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
258: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
259: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
260: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
253: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
254: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
255: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
256: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
257: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
258: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
259: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
260: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
261: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
254: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
255: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
256: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
257: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
258: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
259: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
260: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
261: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
262: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
255: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
256: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
257: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
258: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
259: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
260: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
261: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
262: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
263: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,
256: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
257: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
258: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
259: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
260: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
261: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
262: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
263: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,
264: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE,
257: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
258: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
259: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
260: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
261: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
262: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
263: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,
264: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE,
265: p_receipt_method_id IN ar_receipt_methods.receipt_method_id%TYPE,
258: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
259: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
260: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
261: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
262: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
263: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,
264: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE,
265: p_receipt_method_id IN ar_receipt_methods.receipt_method_id%TYPE,
266: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
259: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
260: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
261: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
262: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
263: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,
264: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE,
265: p_receipt_method_id IN ar_receipt_methods.receipt_method_id%TYPE,
266: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
267: p_module_name IN VARCHAR2,
260: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
261: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
262: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
263: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,
264: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE,
265: p_receipt_method_id IN ar_receipt_methods.receipt_method_id%TYPE,
266: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
267: p_module_name IN VARCHAR2,
268: p_module_version IN VARCHAR2,
262: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
263: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,
264: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE,
265: p_receipt_method_id IN ar_receipt_methods.receipt_method_id%TYPE,
266: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
267: p_module_name IN VARCHAR2,
268: p_module_version IN VARCHAR2,
269: -- OUT NOCOPY
270: p_application_ref_id IN OUT NOCOPY ar_receivable_applications.application_ref_id%TYPE,
266: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
267: p_module_name IN VARCHAR2,
268: p_module_version IN VARCHAR2,
269: -- OUT NOCOPY
270: p_application_ref_id IN OUT NOCOPY ar_receivable_applications.application_ref_id%TYPE,
271: p_application_ref_num IN OUT NOCOPY ar_receivable_applications.application_ref_num%TYPE,
272: p_out_rec_application_id OUT NOCOPY NUMBER,
273: p_acctd_amount_applied_from OUT NOCOPY ar_receivable_applications.acctd_amount_applied_from%TYPE,
274: p_acctd_amount_applied_to OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,
267: p_module_name IN VARCHAR2,
268: p_module_version IN VARCHAR2,
269: -- OUT NOCOPY
270: p_application_ref_id IN OUT NOCOPY ar_receivable_applications.application_ref_id%TYPE,
271: p_application_ref_num IN OUT NOCOPY ar_receivable_applications.application_ref_num%TYPE,
272: p_out_rec_application_id OUT NOCOPY NUMBER,
273: p_acctd_amount_applied_from OUT NOCOPY ar_receivable_applications.acctd_amount_applied_from%TYPE,
274: p_acctd_amount_applied_to OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,
275: x_return_status OUT NOCOPY VARCHAR2,
269: -- OUT NOCOPY
270: p_application_ref_id IN OUT NOCOPY ar_receivable_applications.application_ref_id%TYPE,
271: p_application_ref_num IN OUT NOCOPY ar_receivable_applications.application_ref_num%TYPE,
272: p_out_rec_application_id OUT NOCOPY NUMBER,
273: p_acctd_amount_applied_from OUT NOCOPY ar_receivable_applications.acctd_amount_applied_from%TYPE,
274: p_acctd_amount_applied_to OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,
275: x_return_status OUT NOCOPY VARCHAR2,
276: x_msg_count OUT NOCOPY NUMBER,
277: x_msg_data OUT NOCOPY VARCHAR2);
270: p_application_ref_id IN OUT NOCOPY ar_receivable_applications.application_ref_id%TYPE,
271: p_application_ref_num IN OUT NOCOPY ar_receivable_applications.application_ref_num%TYPE,
272: p_out_rec_application_id OUT NOCOPY NUMBER,
273: p_acctd_amount_applied_from OUT NOCOPY ar_receivable_applications.acctd_amount_applied_from%TYPE,
274: p_acctd_amount_applied_to OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,
275: x_return_status OUT NOCOPY VARCHAR2,
276: x_msg_count OUT NOCOPY NUMBER,
277: x_msg_data OUT NOCOPY VARCHAR2);
278:
278:
279: PROCEDURE on_account_receipts(
280: p_receipt_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
281: p_amount_applied IN
282: ar_receivable_applications.amount_applied%TYPE,
283: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
284: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
285: p_ussgl_transaction_code IN
286: ar_receivable_applications.ussgl_transaction_code%TYPE,
279: PROCEDURE on_account_receipts(
280: p_receipt_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
281: p_amount_applied IN
282: ar_receivable_applications.amount_applied%TYPE,
283: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
284: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
285: p_ussgl_transaction_code IN
286: ar_receivable_applications.ussgl_transaction_code%TYPE,
287: p_attribute_category IN
280: p_receipt_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
281: p_amount_applied IN
282: ar_receivable_applications.amount_applied%TYPE,
283: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
284: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
285: p_ussgl_transaction_code IN
286: ar_receivable_applications.ussgl_transaction_code%TYPE,
287: p_attribute_category IN
288: ar_receivable_applications.attribute_category%TYPE,
282: ar_receivable_applications.amount_applied%TYPE,
283: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
284: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
285: p_ussgl_transaction_code IN
286: ar_receivable_applications.ussgl_transaction_code%TYPE,
287: p_attribute_category IN
288: ar_receivable_applications.attribute_category%TYPE,
289: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
290: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
284: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
285: p_ussgl_transaction_code IN
286: ar_receivable_applications.ussgl_transaction_code%TYPE,
287: p_attribute_category IN
288: ar_receivable_applications.attribute_category%TYPE,
289: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
290: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
291: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
292: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
285: p_ussgl_transaction_code IN
286: ar_receivable_applications.ussgl_transaction_code%TYPE,
287: p_attribute_category IN
288: ar_receivable_applications.attribute_category%TYPE,
289: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
290: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
291: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
292: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
293: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
286: ar_receivable_applications.ussgl_transaction_code%TYPE,
287: p_attribute_category IN
288: ar_receivable_applications.attribute_category%TYPE,
289: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
290: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
291: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
292: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
293: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
294: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
287: p_attribute_category IN
288: ar_receivable_applications.attribute_category%TYPE,
289: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
290: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
291: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
292: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
293: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
294: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
295: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
288: ar_receivable_applications.attribute_category%TYPE,
289: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
290: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
291: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
292: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
293: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
294: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
295: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
296: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
289: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
290: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
291: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
292: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
293: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
294: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
295: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
296: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
297: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
290: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
291: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
292: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
293: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
294: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
295: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
296: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
297: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
298: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
291: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
292: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
293: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
294: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
295: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
296: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
297: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
298: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
299: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
292: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
293: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
294: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
295: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
296: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
297: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
298: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
299: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
300: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
293: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
294: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
295: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
296: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
297: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
298: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
299: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
300: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
301: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
294: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
295: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
296: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
297: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
298: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
299: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
300: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
301: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
302: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
295: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
296: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
297: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
298: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
299: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
300: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
301: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
302: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
303: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
296: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
297: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
298: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
299: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
300: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
301: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
302: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
303: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
304: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
297: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
298: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
299: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
300: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
301: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
302: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
303: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
304: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
305: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
298: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
299: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
300: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
301: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
302: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
303: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
304: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
305: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
306: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
299: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
300: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
301: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
302: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
303: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
304: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
305: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
306: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
307: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
300: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
301: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
302: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
303: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
304: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
305: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
306: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
307: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
308: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
301: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
302: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
303: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
304: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
305: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
306: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
307: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
308: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
309: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
302: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
303: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
304: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
305: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
306: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
307: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
308: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
309: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
310: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
303: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
304: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
305: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
306: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
307: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
308: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
309: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
310: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
311: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
304: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
305: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
306: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
307: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
308: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
309: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
310: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
311: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
312: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
305: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
306: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
307: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
308: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
309: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
310: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
311: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
312: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
313: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
306: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
307: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
308: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
309: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
310: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
311: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
312: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
313: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
314: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
307: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
308: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
309: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
310: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
311: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
312: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
313: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
314: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
315: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
308: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
309: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
310: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
311: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
312: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
313: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
314: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
315: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
316: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
309: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
310: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
311: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
312: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
313: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
314: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
315: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
316: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
317: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
310: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
311: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
312: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
313: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
314: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
315: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
316: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
317: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
318: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
311: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
312: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
313: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
314: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
315: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
316: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
317: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
318: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
319: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
312: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
313: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
314: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
315: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
316: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
317: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
318: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
319: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
320: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
313: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
314: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
315: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
316: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
317: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
318: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
319: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
320: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
321: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
314: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
315: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
316: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
317: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
318: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
319: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
320: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
321: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
322: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
315: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
316: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
317: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
318: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
319: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
320: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
321: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
322: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
323: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
316: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
317: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
318: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
319: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
320: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
321: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
322: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
323: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
324: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,
317: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
318: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
319: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
320: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
321: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
322: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
323: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
324: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,
325: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL, --Bug 2047229
318: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
319: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
320: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
321: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
322: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
323: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
324: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,
325: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL, --Bug 2047229
326: p_module_name IN VARCHAR2,
319: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
320: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
321: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
322: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
323: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
324: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,
325: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL, --Bug 2047229
326: p_module_name IN VARCHAR2,
327: p_module_version IN VARCHAR2
320: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
321: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
322: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
323: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
324: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,
325: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL, --Bug 2047229
326: p_module_name IN VARCHAR2,
327: p_module_version IN VARCHAR2
328: , p_out_rec_application_id OUT NOCOPY NUMBER
321: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
322: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
323: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
324: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,
325: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL, --Bug 2047229
326: p_module_name IN VARCHAR2,
327: p_module_version IN VARCHAR2
328: , p_out_rec_application_id OUT NOCOPY NUMBER
329: , p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL
325: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL, --Bug 2047229
326: p_module_name IN VARCHAR2,
327: p_module_version IN VARCHAR2
328: , p_out_rec_application_id OUT NOCOPY NUMBER
329: , p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL
330: , p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL
331: , p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL
332: , p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL
333: , p_secondary_app_ref_type IN
326: p_module_name IN VARCHAR2,
327: p_module_version IN VARCHAR2
328: , p_out_rec_application_id OUT NOCOPY NUMBER
329: , p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL
330: , p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL
331: , p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL
332: , p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL
333: , p_secondary_app_ref_type IN
334: ar_receivable_applications.secondary_application_ref_type%TYPE := null
327: p_module_version IN VARCHAR2
328: , p_out_rec_application_id OUT NOCOPY NUMBER
329: , p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL
330: , p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL
331: , p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL
332: , p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL
333: , p_secondary_app_ref_type IN
334: ar_receivable_applications.secondary_application_ref_type%TYPE := null
335: , p_secondary_app_ref_num IN
328: , p_out_rec_application_id OUT NOCOPY NUMBER
329: , p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL
330: , p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL
331: , p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL
332: , p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL
333: , p_secondary_app_ref_type IN
334: ar_receivable_applications.secondary_application_ref_type%TYPE := null
335: , p_secondary_app_ref_num IN
336: ar_receivable_applications.secondary_application_ref_num%TYPE := null
330: , p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL
331: , p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL
332: , p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL
333: , p_secondary_app_ref_type IN
334: ar_receivable_applications.secondary_application_ref_type%TYPE := null
335: , p_secondary_app_ref_num IN
336: ar_receivable_applications.secondary_application_ref_num%TYPE := null
337: , p_on_acct_cust_id IN ar_receivable_applications.on_acct_cust_id%TYPE DEFAULT NULL
338: , p_on_acct_cust_site_use_id IN ar_receivable_applications.on_acct_cust_site_use_id%TYPE DEFAULT NULL
332: , p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL
333: , p_secondary_app_ref_type IN
334: ar_receivable_applications.secondary_application_ref_type%TYPE := null
335: , p_secondary_app_ref_num IN
336: ar_receivable_applications.secondary_application_ref_num%TYPE := null
337: , p_on_acct_cust_id IN ar_receivable_applications.on_acct_cust_id%TYPE DEFAULT NULL
338: , p_on_acct_cust_site_use_id IN ar_receivable_applications.on_acct_cust_site_use_id%TYPE DEFAULT NULL
339: , p_on_acct_po_num IN ar_receivable_applications.on_acct_po_num%TYPE DEFAULT NULL
340: );
333: , p_secondary_app_ref_type IN
334: ar_receivable_applications.secondary_application_ref_type%TYPE := null
335: , p_secondary_app_ref_num IN
336: ar_receivable_applications.secondary_application_ref_num%TYPE := null
337: , p_on_acct_cust_id IN ar_receivable_applications.on_acct_cust_id%TYPE DEFAULT NULL
338: , p_on_acct_cust_site_use_id IN ar_receivable_applications.on_acct_cust_site_use_id%TYPE DEFAULT NULL
339: , p_on_acct_po_num IN ar_receivable_applications.on_acct_po_num%TYPE DEFAULT NULL
340: );
341:
334: ar_receivable_applications.secondary_application_ref_type%TYPE := null
335: , p_secondary_app_ref_num IN
336: ar_receivable_applications.secondary_application_ref_num%TYPE := null
337: , p_on_acct_cust_id IN ar_receivable_applications.on_acct_cust_id%TYPE DEFAULT NULL
338: , p_on_acct_cust_site_use_id IN ar_receivable_applications.on_acct_cust_site_use_id%TYPE DEFAULT NULL
339: , p_on_acct_po_num IN ar_receivable_applications.on_acct_po_num%TYPE DEFAULT NULL
340: );
341:
342: /* jrautiai BR implementation */
335: , p_secondary_app_ref_num IN
336: ar_receivable_applications.secondary_application_ref_num%TYPE := null
337: , p_on_acct_cust_id IN ar_receivable_applications.on_acct_cust_id%TYPE DEFAULT NULL
338: , p_on_acct_cust_site_use_id IN ar_receivable_applications.on_acct_cust_site_use_id%TYPE DEFAULT NULL
339: , p_on_acct_po_num IN ar_receivable_applications.on_acct_po_num%TYPE DEFAULT NULL
340: );
341:
342: /* jrautiai BR implementation */
343: PROCEDURE activity_application(
341:
342: /* jrautiai BR implementation */
343: PROCEDURE activity_application(
344: p_receipt_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
345: p_application_ps_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE,
346: p_link_to_customer_trx_id IN ar_receivable_applications.link_to_customer_trx_id%TYPE,
347: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
348: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
349: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
342: /* jrautiai BR implementation */
343: PROCEDURE activity_application(
344: p_receipt_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
345: p_application_ps_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE,
346: p_link_to_customer_trx_id IN ar_receivable_applications.link_to_customer_trx_id%TYPE,
347: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
348: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
349: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
350: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE,
343: PROCEDURE activity_application(
344: p_receipt_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
345: p_application_ps_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE,
346: p_link_to_customer_trx_id IN ar_receivable_applications.link_to_customer_trx_id%TYPE,
347: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
348: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
349: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
350: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE,
351: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE,
344: p_receipt_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
345: p_application_ps_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE,
346: p_link_to_customer_trx_id IN ar_receivable_applications.link_to_customer_trx_id%TYPE,
347: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
348: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
349: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
350: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE,
351: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE,
352: p_attribute_category IN ar_receivable_applications.attribute_category%TYPE,
345: p_application_ps_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE,
346: p_link_to_customer_trx_id IN ar_receivable_applications.link_to_customer_trx_id%TYPE,
347: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
348: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
349: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
350: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE,
351: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE,
352: p_attribute_category IN ar_receivable_applications.attribute_category%TYPE,
353: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
346: p_link_to_customer_trx_id IN ar_receivable_applications.link_to_customer_trx_id%TYPE,
347: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
348: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
349: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
350: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE,
351: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE,
352: p_attribute_category IN ar_receivable_applications.attribute_category%TYPE,
353: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
354: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
347: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
348: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
349: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
350: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE,
351: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE,
352: p_attribute_category IN ar_receivable_applications.attribute_category%TYPE,
353: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
354: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
355: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
348: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
349: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
350: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE,
351: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE,
352: p_attribute_category IN ar_receivable_applications.attribute_category%TYPE,
353: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
354: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
355: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
356: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
349: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
350: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE,
351: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE,
352: p_attribute_category IN ar_receivable_applications.attribute_category%TYPE,
353: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
354: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
355: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
356: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
357: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
350: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE,
351: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE,
352: p_attribute_category IN ar_receivable_applications.attribute_category%TYPE,
353: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
354: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
355: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
356: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
357: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
358: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
351: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE,
352: p_attribute_category IN ar_receivable_applications.attribute_category%TYPE,
353: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
354: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
355: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
356: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
357: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
358: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
359: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
352: p_attribute_category IN ar_receivable_applications.attribute_category%TYPE,
353: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
354: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
355: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
356: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
357: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
358: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
359: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
360: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
353: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
354: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
355: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
356: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
357: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
358: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
359: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
360: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
361: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
354: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
355: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
356: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
357: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
358: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
359: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
360: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
361: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
362: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
355: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
356: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
357: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
358: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
359: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
360: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
361: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
362: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
363: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
356: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
357: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
358: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
359: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
360: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
361: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
362: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
363: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
364: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
357: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
358: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
359: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
360: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
361: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
362: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
363: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
364: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
365: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
358: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
359: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
360: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
361: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
362: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
363: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
364: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
365: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
366: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
359: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
360: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
361: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
362: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
363: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
364: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
365: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
366: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
367: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
360: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
361: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
362: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
363: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
364: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
365: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
366: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
367: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
368: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
361: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
362: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
363: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
364: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
365: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
366: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
367: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
368: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
369: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
362: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
363: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
364: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
365: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
366: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
367: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
368: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
369: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
370: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
363: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
364: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
365: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
366: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
367: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
368: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
369: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
370: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
371: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
364: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
365: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
366: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
367: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
368: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
369: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
370: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
371: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
372: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
365: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
366: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
367: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
368: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
369: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
370: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
371: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
372: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
373: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
366: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
367: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
368: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
369: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
370: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
371: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
372: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
373: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
374: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
367: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
368: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
369: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
370: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
371: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
372: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
373: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
374: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
375: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
368: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
369: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
370: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
371: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
372: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
373: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
374: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
375: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
376: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
369: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
370: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
371: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
372: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
373: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
374: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
375: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
376: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
377: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
370: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
371: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
372: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
373: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
374: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
375: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
376: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
377: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
378: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
371: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
372: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
373: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
374: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
375: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
376: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
377: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
378: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
379: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
372: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
373: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
374: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
375: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
376: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
377: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
378: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
379: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
380: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
373: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
374: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
375: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
376: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
377: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
378: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
379: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
380: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
381: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
374: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
375: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
376: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
377: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
378: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
379: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
380: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
381: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
382: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
375: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
376: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
377: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
378: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
379: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
380: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
381: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
382: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
383: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
376: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
377: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
378: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
379: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
380: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
381: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
382: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
383: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
384: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
377: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
378: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
379: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
380: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
381: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
382: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
383: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
384: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
385: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
378: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
379: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
380: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
381: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
382: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
383: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
384: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
385: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
386: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
379: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
380: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
381: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
382: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
383: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
384: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
385: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
386: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
387: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
380: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
381: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
382: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
383: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
384: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
385: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
386: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
387: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
388: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,
381: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
382: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
383: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
384: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
385: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
386: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
387: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
388: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,
389: p_comments IN
382: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
383: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
384: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
385: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
386: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
387: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
388: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,
389: p_comments IN
390: ar_receivable_applications.comments%TYPE DEFAULT NULL,
383: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
384: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
385: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
386: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
387: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
388: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,
389: p_comments IN
390: ar_receivable_applications.comments%TYPE DEFAULT NULL,
391: p_module_name IN VARCHAR2,
384: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
385: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
386: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
387: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
388: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,
389: p_comments IN
390: ar_receivable_applications.comments%TYPE DEFAULT NULL,
391: p_module_name IN VARCHAR2,
392: p_module_version IN VARCHAR2,
386: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
387: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
388: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,
389: p_comments IN
390: ar_receivable_applications.comments%TYPE DEFAULT NULL,
391: p_module_name IN VARCHAR2,
392: p_module_version IN VARCHAR2,
393: p_application_ref_type IN OUT NOCOPY
394: ar_receivable_applications.application_ref_type%TYPE,
390: ar_receivable_applications.comments%TYPE DEFAULT NULL,
391: p_module_name IN VARCHAR2,
392: p_module_version IN VARCHAR2,
393: p_application_ref_type IN OUT NOCOPY
394: ar_receivable_applications.application_ref_type%TYPE,
395: p_application_ref_id IN OUT NOCOPY
396: ar_receivable_applications.application_ref_id%TYPE,
397: p_application_ref_num IN OUT NOCOPY
398: ar_receivable_applications.application_ref_num%TYPE,
392: p_module_version IN VARCHAR2,
393: p_application_ref_type IN OUT NOCOPY
394: ar_receivable_applications.application_ref_type%TYPE,
395: p_application_ref_id IN OUT NOCOPY
396: ar_receivable_applications.application_ref_id%TYPE,
397: p_application_ref_num IN OUT NOCOPY
398: ar_receivable_applications.application_ref_num%TYPE,
399: p_secondary_application_ref_id IN OUT NOCOPY NUMBER,
400: p_payment_set_id IN NUMBER DEFAULT NULL,
394: ar_receivable_applications.application_ref_type%TYPE,
395: p_application_ref_id IN OUT NOCOPY
396: ar_receivable_applications.application_ref_id%TYPE,
397: p_application_ref_num IN OUT NOCOPY
398: ar_receivable_applications.application_ref_num%TYPE,
399: p_secondary_application_ref_id IN OUT NOCOPY NUMBER,
400: p_payment_set_id IN NUMBER DEFAULT NULL,
401: p_called_from IN VARCHAR2 DEFAULT NULL , /*5444407*/
402: p_out_rec_application_id OUT NOCOPY NUMBER,
400: p_payment_set_id IN NUMBER DEFAULT NULL,
401: p_called_from IN VARCHAR2 DEFAULT NULL , /*5444407*/
402: p_out_rec_application_id OUT NOCOPY NUMBER,
403: p_applied_rec_app_id IN NUMBER DEFAULT NULL,
404: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
405: p_netted_receipt_flag IN VARCHAR2 DEFAULT NULL,
406: p_netted_cash_receipt_id IN
407: ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL ,
408: p_secondary_app_ref_type IN
405: p_netted_receipt_flag IN VARCHAR2 DEFAULT NULL,
406: p_netted_cash_receipt_id IN
407: ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL ,
408: p_secondary_app_ref_type IN
409: ar_receivable_applications.secondary_application_ref_type%TYPE := null,
410: p_secondary_app_ref_num IN
411: ar_receivable_applications.secondary_application_ref_num%TYPE := null,
412: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
413: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE Default NULL --Bug5450371
407: ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL ,
408: p_secondary_app_ref_type IN
409: ar_receivable_applications.secondary_application_ref_type%TYPE := null,
410: p_secondary_app_ref_num IN
411: ar_receivable_applications.secondary_application_ref_num%TYPE := null,
412: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
413: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE Default NULL --Bug5450371
414:
415: );
408: p_secondary_app_ref_type IN
409: ar_receivable_applications.secondary_application_ref_type%TYPE := null,
410: p_secondary_app_ref_num IN
411: ar_receivable_applications.secondary_application_ref_num%TYPE := null,
412: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
413: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE Default NULL --Bug5450371
414:
415: );
416:
409: ar_receivable_applications.secondary_application_ref_type%TYPE := null,
410: p_secondary_app_ref_num IN
411: ar_receivable_applications.secondary_application_ref_num%TYPE := null,
412: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
413: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE Default NULL --Bug5450371
414:
415: );
416:
417: --Other_account_application procedure is introduced for Claim application
417: --Other_account_application procedure is introduced for Claim application
418: PROCEDURE other_account_application(
419: p_receipt_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
420: p_amount_applied IN
421: ar_receivable_applications.amount_applied%TYPE,
422: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
423: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
424: p_receivables_trx_id ar_receivable_applications.receivables_trx_id%TYPE,
425: p_applied_ps_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE,
418: PROCEDURE other_account_application(
419: p_receipt_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
420: p_amount_applied IN
421: ar_receivable_applications.amount_applied%TYPE,
422: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
423: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
424: p_receivables_trx_id ar_receivable_applications.receivables_trx_id%TYPE,
425: p_applied_ps_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE,
426: p_ussgl_transaction_code IN
419: p_receipt_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
420: p_amount_applied IN
421: ar_receivable_applications.amount_applied%TYPE,
422: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
423: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
424: p_receivables_trx_id ar_receivable_applications.receivables_trx_id%TYPE,
425: p_applied_ps_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE,
426: p_ussgl_transaction_code IN
427: ar_receivable_applications.ussgl_transaction_code%TYPE,
420: p_amount_applied IN
421: ar_receivable_applications.amount_applied%TYPE,
422: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
423: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
424: p_receivables_trx_id ar_receivable_applications.receivables_trx_id%TYPE,
425: p_applied_ps_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE,
426: p_ussgl_transaction_code IN
427: ar_receivable_applications.ussgl_transaction_code%TYPE,
428: p_application_ref_type IN
421: ar_receivable_applications.amount_applied%TYPE,
422: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
423: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
424: p_receivables_trx_id ar_receivable_applications.receivables_trx_id%TYPE,
425: p_applied_ps_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE,
426: p_ussgl_transaction_code IN
427: ar_receivable_applications.ussgl_transaction_code%TYPE,
428: p_application_ref_type IN
429: ar_receivable_applications.application_ref_type%TYPE,
423: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
424: p_receivables_trx_id ar_receivable_applications.receivables_trx_id%TYPE,
425: p_applied_ps_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE,
426: p_ussgl_transaction_code IN
427: ar_receivable_applications.ussgl_transaction_code%TYPE,
428: p_application_ref_type IN
429: ar_receivable_applications.application_ref_type%TYPE,
430: p_application_ref_id IN
431: ar_receivable_applications.application_ref_id%TYPE,
425: p_applied_ps_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE,
426: p_ussgl_transaction_code IN
427: ar_receivable_applications.ussgl_transaction_code%TYPE,
428: p_application_ref_type IN
429: ar_receivable_applications.application_ref_type%TYPE,
430: p_application_ref_id IN
431: ar_receivable_applications.application_ref_id%TYPE,
432: p_application_ref_num IN
433: ar_receivable_applications.application_ref_num%TYPE,
427: ar_receivable_applications.ussgl_transaction_code%TYPE,
428: p_application_ref_type IN
429: ar_receivable_applications.application_ref_type%TYPE,
430: p_application_ref_id IN
431: ar_receivable_applications.application_ref_id%TYPE,
432: p_application_ref_num IN
433: ar_receivable_applications.application_ref_num%TYPE,
434: p_secondary_application_ref_id IN NUMBER DEFAULT NULL,
435: p_comments IN
429: ar_receivable_applications.application_ref_type%TYPE,
430: p_application_ref_id IN
431: ar_receivable_applications.application_ref_id%TYPE,
432: p_application_ref_num IN
433: ar_receivable_applications.application_ref_num%TYPE,
434: p_secondary_application_ref_id IN NUMBER DEFAULT NULL,
435: p_comments IN
436: ar_receivable_applications.comments%TYPE,
437: p_attribute_category IN
432: p_application_ref_num IN
433: ar_receivable_applications.application_ref_num%TYPE,
434: p_secondary_application_ref_id IN NUMBER DEFAULT NULL,
435: p_comments IN
436: ar_receivable_applications.comments%TYPE,
437: p_attribute_category IN
438: ar_receivable_applications.attribute_category%TYPE,
439: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
440: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
434: p_secondary_application_ref_id IN NUMBER DEFAULT NULL,
435: p_comments IN
436: ar_receivable_applications.comments%TYPE,
437: p_attribute_category IN
438: ar_receivable_applications.attribute_category%TYPE,
439: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
440: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
441: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
442: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
435: p_comments IN
436: ar_receivable_applications.comments%TYPE,
437: p_attribute_category IN
438: ar_receivable_applications.attribute_category%TYPE,
439: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
440: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
441: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
442: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
443: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
436: ar_receivable_applications.comments%TYPE,
437: p_attribute_category IN
438: ar_receivable_applications.attribute_category%TYPE,
439: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
440: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
441: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
442: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
443: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
444: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
437: p_attribute_category IN
438: ar_receivable_applications.attribute_category%TYPE,
439: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
440: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
441: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
442: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
443: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
444: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
445: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
438: ar_receivable_applications.attribute_category%TYPE,
439: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
440: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
441: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
442: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
443: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
444: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
445: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
446: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
439: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
440: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
441: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
442: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
443: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
444: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
445: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
446: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
447: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
440: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
441: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
442: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
443: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
444: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
445: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
446: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
447: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
448: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
441: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
442: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
443: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
444: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
445: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
446: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
447: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
448: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
449: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
442: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
443: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
444: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
445: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
446: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
447: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
448: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
449: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
450: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
443: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
444: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
445: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
446: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
447: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
448: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
449: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
450: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
451: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
444: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
445: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
446: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
447: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
448: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
449: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
450: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
451: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
452: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
445: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
446: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
447: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
448: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
449: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
450: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
451: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
452: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
453: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
446: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
447: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
448: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
449: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
450: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
451: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
452: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
453: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
454: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
447: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
448: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
449: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
450: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
451: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
452: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
453: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
454: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
455: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
448: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
449: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
450: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
451: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
452: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
453: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
454: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
455: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
456: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
449: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
450: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
451: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
452: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
453: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
454: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
455: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
456: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
457: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
450: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
451: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
452: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
453: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
454: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
455: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
456: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
457: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
458: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
451: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
452: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
453: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
454: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
455: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
456: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
457: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
458: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
459: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
452: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
453: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
454: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
455: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
456: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
457: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
458: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
459: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
460: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
453: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
454: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
455: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
456: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
457: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
458: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
459: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
460: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
461: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
454: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
455: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
456: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
457: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
458: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
459: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
460: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
461: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
462: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
455: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
456: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
457: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
458: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
459: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
460: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
461: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
462: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
463: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
456: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
457: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
458: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
459: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
460: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
461: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
462: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
463: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
464: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
457: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
458: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
459: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
460: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
461: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
462: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
463: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
464: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
465: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
458: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
459: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
460: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
461: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
462: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
463: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
464: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
465: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
466: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
459: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
460: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
461: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
462: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
463: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
464: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
465: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
466: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
467: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
460: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
461: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
462: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
463: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
464: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
465: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
466: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
467: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
468: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
461: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
462: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
463: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
464: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
465: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
466: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
467: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
468: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
469: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
462: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
463: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
464: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
465: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
466: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
467: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
468: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
469: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
470: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
463: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
464: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
465: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
466: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
467: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
468: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
469: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
470: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
471: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
464: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
465: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
466: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
467: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
468: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
469: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
470: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
471: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
472: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
465: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
466: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
467: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
468: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
469: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
470: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
471: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
472: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
473: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
466: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
467: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
468: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
469: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
470: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
471: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
472: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
473: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
474: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,
467: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
468: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
469: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
470: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
471: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
472: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
473: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
474: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,
475: p_module_name IN VARCHAR2,
468: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
469: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
470: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
471: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
472: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
473: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
474: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,
475: p_module_name IN VARCHAR2,
476: p_module_version IN VARCHAR2,
469: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
470: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
471: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
472: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
473: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
474: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,
475: p_module_name IN VARCHAR2,
476: p_module_version IN VARCHAR2,
477: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE,
470: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
471: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
472: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
473: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
474: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,
475: p_module_name IN VARCHAR2,
476: p_module_version IN VARCHAR2,
477: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE,
478: x_application_ref_id OUT NOCOPY
473: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
474: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,
475: p_module_name IN VARCHAR2,
476: p_module_version IN VARCHAR2,
477: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE,
478: x_application_ref_id OUT NOCOPY
479: ar_receivable_applications.application_ref_id%TYPE,
480: x_application_ref_num OUT NOCOPY
481: ar_receivable_applications.application_ref_num%TYPE
475: p_module_name IN VARCHAR2,
476: p_module_version IN VARCHAR2,
477: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE,
478: x_application_ref_id OUT NOCOPY
479: ar_receivable_applications.application_ref_id%TYPE,
480: x_application_ref_num OUT NOCOPY
481: ar_receivable_applications.application_ref_num%TYPE
482: , x_return_status OUT NOCOPY VARCHAR2
483: , x_msg_count OUT NOCOPY NUMBER
477: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE,
478: x_application_ref_id OUT NOCOPY
479: ar_receivable_applications.application_ref_id%TYPE,
480: x_application_ref_num OUT NOCOPY
481: ar_receivable_applications.application_ref_num%TYPE
482: , x_return_status OUT NOCOPY VARCHAR2
483: , x_msg_count OUT NOCOPY NUMBER
484: , x_msg_data OUT NOCOPY VARCHAR2
485: , p_out_rec_application_id OUT NOCOPY NUMBER
482: , x_return_status OUT NOCOPY VARCHAR2
483: , x_msg_count OUT NOCOPY NUMBER
484: , x_msg_data OUT NOCOPY VARCHAR2
485: , p_out_rec_application_id OUT NOCOPY NUMBER
486: , p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL
487: , p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL
488: , p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL
489: , x_claim_reason_name OUT NOCOPY VARCHAR2
490: , p_called_from IN VARCHAR2 DEFAULT NULL
483: , x_msg_count OUT NOCOPY NUMBER
484: , x_msg_data OUT NOCOPY VARCHAR2
485: , p_out_rec_application_id OUT NOCOPY NUMBER
486: , p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL
487: , p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL
488: , p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL
489: , x_claim_reason_name OUT NOCOPY VARCHAR2
490: , p_called_from IN VARCHAR2 DEFAULT NULL
491: );
484: , x_msg_data OUT NOCOPY VARCHAR2
485: , p_out_rec_application_id OUT NOCOPY NUMBER
486: , p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL
487: , p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL
488: , p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL
489: , x_claim_reason_name OUT NOCOPY VARCHAR2
490: , p_called_from IN VARCHAR2 DEFAULT NULL
491: );
492: PROCEDURE create_claim(
571: PROCEDURE fetch_app_ccid(
572: p_invoice_ps_id IN
573: ar_payment_schedules.payment_schedule_id%TYPE,
574: p_applied_customer_trx_id OUT NOCOPY
575: ar_receivable_applications.applied_customer_trx_id%TYPE, p_code_combination_id OUT NOCOPY
576: ar_receivable_applications.code_combination_id%TYPE,
577: p_source_type OUT NOCOPY
578: ar_distributions.source_type%TYPE);
579:
572: p_invoice_ps_id IN
573: ar_payment_schedules.payment_schedule_id%TYPE,
574: p_applied_customer_trx_id OUT NOCOPY
575: ar_receivable_applications.applied_customer_trx_id%TYPE, p_code_combination_id OUT NOCOPY
576: ar_receivable_applications.code_combination_id%TYPE,
577: p_source_type OUT NOCOPY
578: ar_distributions.source_type%TYPE);
579:
580: PROCEDURE Unassociate_Regular_CM ( p_cust_Trx_id IN NUMBER,