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