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