54: ---- Chuan Ling 23-Sep-11 Bug 12981398 - added currency.
55:
56: TYPE Receipt_Method_Rec IS RECORD
57: (method_id ar_receipt_methods.receipt_method_id%TYPE,
58: bank_account_id ar_cash_receipts.remit_bank_acct_use_id%type,
59: state ar_receipt_classes.creation_status%TYPE,
60: remit_flag ar_receipt_classes.remit_flag%TYPE,
61: currency ce_bank_accounts.currency_code%TYPE --bug12981398
62: );
60: remit_flag ar_receipt_classes.remit_flag%TYPE,
61: currency ce_bank_accounts.currency_code%TYPE --bug12981398
62: );
63: TYPE Customer_Rec IS RECORD
64: (customer_id ar_cash_receipts.pay_from_customer%TYPE,
65: /* 6612301 */
66: bank_account_id ar_cash_receipts.customer_bank_account_id%TYPE,
67: bank_branch_id ar_cash_receipts.customer_bank_branch_id%TYPE,
68: site_use_id ar_cash_receipts.customer_site_use_id%TYPE
62: );
63: TYPE Customer_Rec IS RECORD
64: (customer_id ar_cash_receipts.pay_from_customer%TYPE,
65: /* 6612301 */
66: bank_account_id ar_cash_receipts.customer_bank_account_id%TYPE,
67: bank_branch_id ar_cash_receipts.customer_bank_branch_id%TYPE,
68: site_use_id ar_cash_receipts.customer_site_use_id%TYPE
69: );
70:
63: TYPE Customer_Rec IS RECORD
64: (customer_id ar_cash_receipts.pay_from_customer%TYPE,
65: /* 6612301 */
66: bank_account_id ar_cash_receipts.customer_bank_account_id%TYPE,
67: bank_branch_id ar_cash_receipts.customer_bank_branch_id%TYPE,
68: site_use_id ar_cash_receipts.customer_site_use_id%TYPE
69: );
70:
71: TYPE Rec_Method_Info_Tbl_Type IS TABLE OF Receipt_Method_Rec
64: (customer_id ar_cash_receipts.pay_from_customer%TYPE,
65: /* 6612301 */
66: bank_account_id ar_cash_receipts.customer_bank_account_id%TYPE,
67: bank_branch_id ar_cash_receipts.customer_bank_branch_id%TYPE,
68: site_use_id ar_cash_receipts.customer_site_use_id%TYPE
69: );
70:
71: TYPE Rec_Method_Info_Tbl_Type IS TABLE OF Receipt_Method_Rec
72: INDEX BY BINARY_INTEGER;
77:
78: Customer_Cache_Tbl Rec_Customer_Tbl_Type;
79:
80: PROCEDURE Validate_Cash_Receipt(
81: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE,
82: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE,
83: p_state IN ar_receipt_classes.creation_status%TYPE,
84: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,
85: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
78: Customer_Cache_Tbl Rec_Customer_Tbl_Type;
79:
80: PROCEDURE Validate_Cash_Receipt(
81: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE,
82: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE,
83: p_state IN ar_receipt_classes.creation_status%TYPE,
84: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,
85: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
86: p_maturity_date IN DATE,
80: PROCEDURE Validate_Cash_Receipt(
81: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE,
82: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE,
83: p_state IN ar_receipt_classes.creation_status%TYPE,
84: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,
85: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
86: p_maturity_date IN DATE,
87: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE,
88: p_amount IN OUT NOCOPY ar_cash_receipts.amount%TYPE,
83: p_state IN ar_receipt_classes.creation_status%TYPE,
84: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,
85: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
86: p_maturity_date IN DATE,
87: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE,
88: p_amount IN OUT NOCOPY ar_cash_receipts.amount%TYPE,
89: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE,
90: p_customer_id IN ar_cash_receipts.pay_from_customer%TYPE,
91: /* 6612301 */
84: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,
85: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
86: p_maturity_date IN DATE,
87: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE,
88: p_amount IN OUT NOCOPY ar_cash_receipts.amount%TYPE,
89: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE,
90: p_customer_id IN ar_cash_receipts.pay_from_customer%TYPE,
91: /* 6612301 */
92: p_customer_bank_account_id IN OUT NOCOPY ar_cash_receipts.customer_bank_account_id%TYPE,
85: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
86: p_maturity_date IN DATE,
87: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE,
88: p_amount IN OUT NOCOPY ar_cash_receipts.amount%TYPE,
89: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE,
90: p_customer_id IN ar_cash_receipts.pay_from_customer%TYPE,
91: /* 6612301 */
92: p_customer_bank_account_id IN OUT NOCOPY ar_cash_receipts.customer_bank_account_id%TYPE,
93: p_location IN hz_cust_site_uses.location%TYPE,
86: p_maturity_date IN DATE,
87: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE,
88: p_amount IN OUT NOCOPY ar_cash_receipts.amount%TYPE,
89: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE,
90: p_customer_id IN ar_cash_receipts.pay_from_customer%TYPE,
91: /* 6612301 */
92: p_customer_bank_account_id IN OUT NOCOPY ar_cash_receipts.customer_bank_account_id%TYPE,
93: p_location IN hz_cust_site_uses.location%TYPE,
94: p_customer_site_use_id IN OUT NOCOPY ar_cash_receipts.customer_site_use_id%TYPE,
88: p_amount IN OUT NOCOPY ar_cash_receipts.amount%TYPE,
89: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE,
90: p_customer_id IN ar_cash_receipts.pay_from_customer%TYPE,
91: /* 6612301 */
92: p_customer_bank_account_id IN OUT NOCOPY ar_cash_receipts.customer_bank_account_id%TYPE,
93: p_location IN hz_cust_site_uses.location%TYPE,
94: p_customer_site_use_id IN OUT NOCOPY ar_cash_receipts.customer_site_use_id%TYPE,
95: p_remittance_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%type,
96: p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE,
90: p_customer_id IN ar_cash_receipts.pay_from_customer%TYPE,
91: /* 6612301 */
92: p_customer_bank_account_id IN OUT NOCOPY ar_cash_receipts.customer_bank_account_id%TYPE,
93: p_location IN hz_cust_site_uses.location%TYPE,
94: p_customer_site_use_id IN OUT NOCOPY ar_cash_receipts.customer_site_use_id%TYPE,
95: p_remittance_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%type,
96: p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE,
97: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE,
98: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
91: /* 6612301 */
92: p_customer_bank_account_id IN OUT NOCOPY ar_cash_receipts.customer_bank_account_id%TYPE,
93: p_location IN hz_cust_site_uses.location%TYPE,
94: p_customer_site_use_id IN OUT NOCOPY ar_cash_receipts.customer_site_use_id%TYPE,
95: p_remittance_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%type,
96: p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE,
97: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE,
98: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
99: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE,
92: p_customer_bank_account_id IN OUT NOCOPY ar_cash_receipts.customer_bank_account_id%TYPE,
93: p_location IN hz_cust_site_uses.location%TYPE,
94: p_customer_site_use_id IN OUT NOCOPY ar_cash_receipts.customer_site_use_id%TYPE,
95: p_remittance_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%type,
96: p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE,
97: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE,
98: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
99: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE,
100: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
93: p_location IN hz_cust_site_uses.location%TYPE,
94: p_customer_site_use_id IN OUT NOCOPY ar_cash_receipts.customer_site_use_id%TYPE,
95: p_remittance_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%type,
96: p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE,
97: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE,
98: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
99: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE,
100: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
101: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE,
94: p_customer_site_use_id IN OUT NOCOPY ar_cash_receipts.customer_site_use_id%TYPE,
95: p_remittance_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%type,
96: p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE,
97: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE,
98: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
99: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE,
100: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
101: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE,
102: p_doc_sequence_value IN NUMBER,
95: p_remittance_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%type,
96: p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE,
97: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE,
98: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
99: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE,
100: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
101: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE,
102: p_doc_sequence_value IN NUMBER,
103: p_called_from IN VARCHAR2,
96: p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE,
97: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE,
98: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
99: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE,
100: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
101: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE,
102: p_doc_sequence_value IN NUMBER,
103: p_called_from IN VARCHAR2,
104: p_return_status OUT NOCOPY VARCHAR2);
97: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE,
98: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
99: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE,
100: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
101: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE,
102: p_doc_sequence_value IN NUMBER,
103: p_called_from IN VARCHAR2,
104: p_return_status OUT NOCOPY VARCHAR2);
105: