14: In this case, it assumes the following has been
15: validated before calling this procedure:
16:
17: p_amount_cleared+p_amount_factored =
18: p_exchange_rate * ar_cash_receipts.amount
19:
20: 3. If p_bank_currency = the currency of the receipt,
21: In this case, it assumes the following has been validated
22: before calling this procedure:
21: In this case, it assumes the following has been validated
22: before calling this procedure:
23:
24: p_amount_cleared+p_amount_factored =
25: ar_cash_receipts.amount
26:
27: ------------------------------------*/
28:
29: --bug14553712, created these attributes for clearing the PERF issue
38:
39:
40:
41: PROCEDURE clear(
42: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
43: p_trx_date IN ar_cash_receipt_history.trx_date%TYPE,
44: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
45: p_actual_value_date IN DATE,
46: p_exchange_date IN ar_cash_receipt_history.exchange_date%TYPE,
53: p_module_version IN VARCHAR2,
54: p_crh_id OUT NOCOPY ar_cash_receipt_history.cash_receipt_history_id%TYPE );
55:
56: PROCEDURE unclear(
57: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
58: p_trx_date IN ar_cash_receipt_history.trx_date%TYPE,
59: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
60: p_actual_value_date IN ar_cash_receipts.actual_value_date%TYPE,
61: p_module_name IN VARCHAR2,
56: PROCEDURE unclear(
57: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
58: p_trx_date IN ar_cash_receipt_history.trx_date%TYPE,
59: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
60: p_actual_value_date IN ar_cash_receipts.actual_value_date%TYPE,
61: p_module_name IN VARCHAR2,
62: p_module_version IN VARCHAR2,
63: p_crh_id OUT NOCOPY ar_cash_receipt_history.cash_receipt_history_id%TYPE );
64:
62: p_module_version IN VARCHAR2,
63: p_crh_id OUT NOCOPY ar_cash_receipt_history.cash_receipt_history_id%TYPE );
64:
65: PROCEDURE risk_eliminate(
66: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
67: p_trx_date IN ar_cash_receipt_history.trx_date%TYPE,
68: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
69: p_module_name IN VARCHAR2,
70: p_module_version IN VARCHAR2,
70: p_module_version IN VARCHAR2,
71: p_crh_id OUT NOCOPY ar_cash_receipt_history.cash_receipt_history_id%TYPE );
72:
73: PROCEDURE undo_risk_eliminate(
74: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
75: p_trx_date IN ar_cash_receipt_history.trx_date%TYPE,
76: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
77: p_module_name IN VARCHAR2,
78: p_module_version IN VARCHAR2,
78: p_module_version IN VARCHAR2,
79: p_crh_id OUT NOCOPY ar_cash_receipt_history.cash_receipt_history_id%TYPE );
80:
81: PROCEDURE ins_misc_txn(
82: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE,
83: p_document_number IN ar_cash_receipts.doc_sequence_value%TYPE,
84: p_doc_sequence_id IN ar_cash_receipts.doc_sequence_id%TYPE,
85: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
86: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,
79: p_crh_id OUT NOCOPY ar_cash_receipt_history.cash_receipt_history_id%TYPE );
80:
81: PROCEDURE ins_misc_txn(
82: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE,
83: p_document_number IN ar_cash_receipts.doc_sequence_value%TYPE,
84: p_doc_sequence_id IN ar_cash_receipts.doc_sequence_id%TYPE,
85: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
86: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,
87: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE,
80:
81: PROCEDURE ins_misc_txn(
82: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE,
83: p_document_number IN ar_cash_receipts.doc_sequence_value%TYPE,
84: p_doc_sequence_id IN ar_cash_receipts.doc_sequence_id%TYPE,
85: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
86: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,
87: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE,
88: p_receipt_amount IN ar_cash_receipts.amount%TYPE,
82: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE,
83: p_document_number IN ar_cash_receipts.doc_sequence_value%TYPE,
84: p_doc_sequence_id IN ar_cash_receipts.doc_sequence_id%TYPE,
85: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
86: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,
87: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE,
88: p_receipt_amount IN ar_cash_receipts.amount%TYPE,
89: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
90: p_exchange_date IN ar_cash_receipt_history.exchange_date%TYPE,
83: p_document_number IN ar_cash_receipts.doc_sequence_value%TYPE,
84: p_doc_sequence_id IN ar_cash_receipts.doc_sequence_id%TYPE,
85: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
86: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,
87: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE,
88: p_receipt_amount IN ar_cash_receipts.amount%TYPE,
89: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
90: p_exchange_date IN ar_cash_receipt_history.exchange_date%TYPE,
91: p_exchange_rate_type IN ar_cash_receipt_history.exchange_rate_type%TYPE,
84: p_doc_sequence_id IN ar_cash_receipts.doc_sequence_id%TYPE,
85: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
86: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,
87: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE,
88: p_receipt_amount IN ar_cash_receipts.amount%TYPE,
89: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
90: p_exchange_date IN ar_cash_receipt_history.exchange_date%TYPE,
91: p_exchange_rate_type IN ar_cash_receipt_history.exchange_rate_type%TYPE,
92: p_exchange_rate IN ar_cash_receipt_history.exchange_rate%TYPE,
85: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
86: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,
87: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE,
88: p_receipt_amount IN ar_cash_receipts.amount%TYPE,
89: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
90: p_exchange_date IN ar_cash_receipt_history.exchange_date%TYPE,
91: p_exchange_rate_type IN ar_cash_receipt_history.exchange_rate_type%TYPE,
92: p_exchange_rate IN ar_cash_receipt_history.exchange_rate%TYPE,
93: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE,
89: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
90: p_exchange_date IN ar_cash_receipt_history.exchange_date%TYPE,
91: p_exchange_rate_type IN ar_cash_receipt_history.exchange_rate_type%TYPE,
92: p_exchange_rate IN ar_cash_receipt_history.exchange_rate%TYPE,
93: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE,
94: p_remit_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%TYPE,
95: p_receivables_trx_id IN ar_cash_receipts.receivables_trx_id%TYPE,
96: p_comments IN ar_cash_receipts.comments%TYPE,
97: p_vat_tax_id IN ar_cash_receipts.vat_tax_id%TYPE,
90: p_exchange_date IN ar_cash_receipt_history.exchange_date%TYPE,
91: p_exchange_rate_type IN ar_cash_receipt_history.exchange_rate_type%TYPE,
92: p_exchange_rate IN ar_cash_receipt_history.exchange_rate%TYPE,
93: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE,
94: p_remit_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%TYPE,
95: p_receivables_trx_id IN ar_cash_receipts.receivables_trx_id%TYPE,
96: p_comments IN ar_cash_receipts.comments%TYPE,
97: p_vat_tax_id IN ar_cash_receipts.vat_tax_id%TYPE,
98: p_reference_type IN ar_cash_receipts.reference_type%TYPE,
91: p_exchange_rate_type IN ar_cash_receipt_history.exchange_rate_type%TYPE,
92: p_exchange_rate IN ar_cash_receipt_history.exchange_rate%TYPE,
93: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE,
94: p_remit_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%TYPE,
95: p_receivables_trx_id IN ar_cash_receipts.receivables_trx_id%TYPE,
96: p_comments IN ar_cash_receipts.comments%TYPE,
97: p_vat_tax_id IN ar_cash_receipts.vat_tax_id%TYPE,
98: p_reference_type IN ar_cash_receipts.reference_type%TYPE,
99: p_reference_id IN ar_cash_receipts.reference_id%TYPE,
92: p_exchange_rate IN ar_cash_receipt_history.exchange_rate%TYPE,
93: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE,
94: p_remit_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%TYPE,
95: p_receivables_trx_id IN ar_cash_receipts.receivables_trx_id%TYPE,
96: p_comments IN ar_cash_receipts.comments%TYPE,
97: p_vat_tax_id IN ar_cash_receipts.vat_tax_id%TYPE,
98: p_reference_type IN ar_cash_receipts.reference_type%TYPE,
99: p_reference_id IN ar_cash_receipts.reference_id%TYPE,
100: p_misc_payment_source IN ar_cash_receipts.misc_payment_source%TYPE,
93: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE,
94: p_remit_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%TYPE,
95: p_receivables_trx_id IN ar_cash_receipts.receivables_trx_id%TYPE,
96: p_comments IN ar_cash_receipts.comments%TYPE,
97: p_vat_tax_id IN ar_cash_receipts.vat_tax_id%TYPE,
98: p_reference_type IN ar_cash_receipts.reference_type%TYPE,
99: p_reference_id IN ar_cash_receipts.reference_id%TYPE,
100: p_misc_payment_source IN ar_cash_receipts.misc_payment_source%TYPE,
101: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE,
94: p_remit_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%TYPE,
95: p_receivables_trx_id IN ar_cash_receipts.receivables_trx_id%TYPE,
96: p_comments IN ar_cash_receipts.comments%TYPE,
97: p_vat_tax_id IN ar_cash_receipts.vat_tax_id%TYPE,
98: p_reference_type IN ar_cash_receipts.reference_type%TYPE,
99: p_reference_id IN ar_cash_receipts.reference_id%TYPE,
100: p_misc_payment_source IN ar_cash_receipts.misc_payment_source%TYPE,
101: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE,
102: p_module_name IN VARCHAR2,
95: p_receivables_trx_id IN ar_cash_receipts.receivables_trx_id%TYPE,
96: p_comments IN ar_cash_receipts.comments%TYPE,
97: p_vat_tax_id IN ar_cash_receipts.vat_tax_id%TYPE,
98: p_reference_type IN ar_cash_receipts.reference_type%TYPE,
99: p_reference_id IN ar_cash_receipts.reference_id%TYPE,
100: p_misc_payment_source IN ar_cash_receipts.misc_payment_source%TYPE,
101: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE,
102: p_module_name IN VARCHAR2,
103: p_module_version IN VARCHAR2,
96: p_comments IN ar_cash_receipts.comments%TYPE,
97: p_vat_tax_id IN ar_cash_receipts.vat_tax_id%TYPE,
98: p_reference_type IN ar_cash_receipts.reference_type%TYPE,
99: p_reference_id IN ar_cash_receipts.reference_id%TYPE,
100: p_misc_payment_source IN ar_cash_receipts.misc_payment_source%TYPE,
101: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE,
102: p_module_name IN VARCHAR2,
103: p_module_version IN VARCHAR2,
104: p_cr_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
97: p_vat_tax_id IN ar_cash_receipts.vat_tax_id%TYPE,
98: p_reference_type IN ar_cash_receipts.reference_type%TYPE,
99: p_reference_id IN ar_cash_receipts.reference_id%TYPE,
100: p_misc_payment_source IN ar_cash_receipts.misc_payment_source%TYPE,
101: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE,
102: p_module_name IN VARCHAR2,
103: p_module_version IN VARCHAR2,
104: p_cr_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
105: p_tax_rate IN NUMBER );
100: p_misc_payment_source IN ar_cash_receipts.misc_payment_source%TYPE,
101: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE,
102: p_module_name IN VARCHAR2,
103: p_module_version IN VARCHAR2,
104: p_cr_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
105: p_tax_rate IN NUMBER );
106:
107: PROCEDURE reverse(
108: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
104: p_cr_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
105: p_tax_rate IN NUMBER );
106:
107: PROCEDURE reverse(
108: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
109: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE,
110: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE,
111: p_reversal_comments IN ar_cash_receipts.reversal_comments%TYPE,
112: p_reversal_reason_code IN ar_cash_receipts.reversal_reason_code%TYPE,
106:
107: PROCEDURE reverse(
108: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
109: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE,
110: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE,
111: p_reversal_comments IN ar_cash_receipts.reversal_comments%TYPE,
112: p_reversal_reason_code IN ar_cash_receipts.reversal_reason_code%TYPE,
113: p_reversal_category IN ar_cash_receipts.reversal_category%TYPE,
114: p_module_name IN VARCHAR2,
107: PROCEDURE reverse(
108: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
109: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE,
110: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE,
111: p_reversal_comments IN ar_cash_receipts.reversal_comments%TYPE,
112: p_reversal_reason_code IN ar_cash_receipts.reversal_reason_code%TYPE,
113: p_reversal_category IN ar_cash_receipts.reversal_category%TYPE,
114: p_module_name IN VARCHAR2,
115: p_module_version IN VARCHAR2,
108: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
109: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE,
110: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE,
111: p_reversal_comments IN ar_cash_receipts.reversal_comments%TYPE,
112: p_reversal_reason_code IN ar_cash_receipts.reversal_reason_code%TYPE,
113: p_reversal_category IN ar_cash_receipts.reversal_category%TYPE,
114: p_module_name IN VARCHAR2,
115: p_module_version IN VARCHAR2,
116: p_crh_id OUT NOCOPY ar_cash_receipt_history.cash_receipt_history_id%TYPE);
109: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE,
110: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE,
111: p_reversal_comments IN ar_cash_receipts.reversal_comments%TYPE,
112: p_reversal_reason_code IN ar_cash_receipts.reversal_reason_code%TYPE,
113: p_reversal_category IN ar_cash_receipts.reversal_category%TYPE,
114: p_module_name IN VARCHAR2,
115: p_module_version IN VARCHAR2,
116: p_crh_id OUT NOCOPY ar_cash_receipt_history.cash_receipt_history_id%TYPE);
117:
115: p_module_version IN VARCHAR2,
116: p_crh_id OUT NOCOPY ar_cash_receipt_history.cash_receipt_history_id%TYPE);
117:
118: PROCEDURE debit_memo_reversal(
119: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
120: p_cc_id IN ra_cust_trx_line_gl_dist.code_combination_id%TYPE,
121: p_dm_cust_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
122: p_dm_cust_trx_type IN ra_cust_trx_types.name%TYPE,
123: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE,
120: p_cc_id IN ra_cust_trx_line_gl_dist.code_combination_id%TYPE,
121: p_dm_cust_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
122: p_dm_cust_trx_type IN ra_cust_trx_types.name%TYPE,
123: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE,
124: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE,
125: p_reversal_category IN ar_cash_receipts.reversal_category%TYPE,
126: p_reversal_reason_code IN ar_cash_receipts.reversal_reason_code%TYPE,
127: p_reversal_comments IN ar_cash_receipts.reversal_comments%TYPE,
128: p_dm_number OUT NOCOPY ar_payment_schedules.trx_number%TYPE,
121: p_dm_cust_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
122: p_dm_cust_trx_type IN ra_cust_trx_types.name%TYPE,
123: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE,
124: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE,
125: p_reversal_category IN ar_cash_receipts.reversal_category%TYPE,
126: p_reversal_reason_code IN ar_cash_receipts.reversal_reason_code%TYPE,
127: p_reversal_comments IN ar_cash_receipts.reversal_comments%TYPE,
128: p_dm_number OUT NOCOPY ar_payment_schedules.trx_number%TYPE,
129: p_dm_doc_sequence_value IN ra_customer_trx.doc_sequence_value%TYPE,
122: p_dm_cust_trx_type IN ra_cust_trx_types.name%TYPE,
123: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE,
124: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE,
125: p_reversal_category IN ar_cash_receipts.reversal_category%TYPE,
126: p_reversal_reason_code IN ar_cash_receipts.reversal_reason_code%TYPE,
127: p_reversal_comments IN ar_cash_receipts.reversal_comments%TYPE,
128: p_dm_number OUT NOCOPY ar_payment_schedules.trx_number%TYPE,
129: p_dm_doc_sequence_value IN ra_customer_trx.doc_sequence_value%TYPE,
130: p_dm_doc_sequence_id IN ra_customer_trx.doc_sequence_id%TYPE,
123: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE,
124: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE,
125: p_reversal_category IN ar_cash_receipts.reversal_category%TYPE,
126: p_reversal_reason_code IN ar_cash_receipts.reversal_reason_code%TYPE,
127: p_reversal_comments IN ar_cash_receipts.reversal_comments%TYPE,
128: p_dm_number OUT NOCOPY ar_payment_schedules.trx_number%TYPE,
129: p_dm_doc_sequence_value IN ra_customer_trx.doc_sequence_value%TYPE,
130: p_dm_doc_sequence_id IN ra_customer_trx.doc_sequence_id%TYPE,
131: p_tw_status IN OUT NOCOPY VARCHAR2,