1: PACKAGE JL_BR_AR_LOG_VALIDATION AUTHID CURRENT_USER AS
2: /*$Header: jlbrrvls.pls 120.6.12020000.1 2012/06/27 09:50:44 appldev ship $*/
3:
4: PROCEDURE logical_validation (
5: p_file_control IN jl_br_ar_ret_interface_all.file_control%TYPE,
6: p_ent_seq_num IN jl_br_ar_ret_interface_all.ENTRY_SEQUENTIAL_NUMBER%TYPE, -- Bug#8331293
7: p_called_from IN VARCHAR2, -- Bug#8331293
8: p_bank_number IN jl_br_ar_ret_interface_all.bank_number%TYPE,
9: p_company_code IN jl_br_ar_ret_interface_all.company_code%TYPE,
2: /*$Header: jlbrrvls.pls 120.6.12020000.1 2012/06/27 09:50:44 appldev ship $*/
3:
4: PROCEDURE logical_validation (
5: p_file_control IN jl_br_ar_ret_interface_all.file_control%TYPE,
6: p_ent_seq_num IN jl_br_ar_ret_interface_all.ENTRY_SEQUENTIAL_NUMBER%TYPE, -- Bug#8331293
7: p_called_from IN VARCHAR2, -- Bug#8331293
8: p_bank_number IN jl_br_ar_ret_interface_all.bank_number%TYPE,
9: p_company_code IN jl_br_ar_ret_interface_all.company_code%TYPE,
10: p_inscription_number IN jl_br_ar_ret_interface_all.inscription_number%TYPE,
4: PROCEDURE logical_validation (
5: p_file_control IN jl_br_ar_ret_interface_all.file_control%TYPE,
6: p_ent_seq_num IN jl_br_ar_ret_interface_all.ENTRY_SEQUENTIAL_NUMBER%TYPE, -- Bug#8331293
7: p_called_from IN VARCHAR2, -- Bug#8331293
8: p_bank_number IN jl_br_ar_ret_interface_all.bank_number%TYPE,
9: p_company_code IN jl_br_ar_ret_interface_all.company_code%TYPE,
10: p_inscription_number IN jl_br_ar_ret_interface_all.inscription_number%TYPE,
11: p_bank_occurrence_code IN jl_br_ar_ret_interface_all.bank_occurrence_code%TYPE,
12: p_occurrence_date IN jl_br_ar_ret_interface_all.occurrence_date%TYPE,
5: p_file_control IN jl_br_ar_ret_interface_all.file_control%TYPE,
6: p_ent_seq_num IN jl_br_ar_ret_interface_all.ENTRY_SEQUENTIAL_NUMBER%TYPE, -- Bug#8331293
7: p_called_from IN VARCHAR2, -- Bug#8331293
8: p_bank_number IN jl_br_ar_ret_interface_all.bank_number%TYPE,
9: p_company_code IN jl_br_ar_ret_interface_all.company_code%TYPE,
10: p_inscription_number IN jl_br_ar_ret_interface_all.inscription_number%TYPE,
11: p_bank_occurrence_code IN jl_br_ar_ret_interface_all.bank_occurrence_code%TYPE,
12: p_occurrence_date IN jl_br_ar_ret_interface_all.occurrence_date%TYPE,
13: p_company_use IN jl_br_ar_ret_interface_all.company_use%TYPE,
6: p_ent_seq_num IN jl_br_ar_ret_interface_all.ENTRY_SEQUENTIAL_NUMBER%TYPE, -- Bug#8331293
7: p_called_from IN VARCHAR2, -- Bug#8331293
8: p_bank_number IN jl_br_ar_ret_interface_all.bank_number%TYPE,
9: p_company_code IN jl_br_ar_ret_interface_all.company_code%TYPE,
10: p_inscription_number IN jl_br_ar_ret_interface_all.inscription_number%TYPE,
11: p_bank_occurrence_code IN jl_br_ar_ret_interface_all.bank_occurrence_code%TYPE,
12: p_occurrence_date IN jl_br_ar_ret_interface_all.occurrence_date%TYPE,
13: p_company_use IN jl_br_ar_ret_interface_all.company_use%TYPE,
14: p_your_number IN jl_br_ar_ret_interface_all.your_number%TYPE,
7: p_called_from IN VARCHAR2, -- Bug#8331293
8: p_bank_number IN jl_br_ar_ret_interface_all.bank_number%TYPE,
9: p_company_code IN jl_br_ar_ret_interface_all.company_code%TYPE,
10: p_inscription_number IN jl_br_ar_ret_interface_all.inscription_number%TYPE,
11: p_bank_occurrence_code IN jl_br_ar_ret_interface_all.bank_occurrence_code%TYPE,
12: p_occurrence_date IN jl_br_ar_ret_interface_all.occurrence_date%TYPE,
13: p_company_use IN jl_br_ar_ret_interface_all.company_use%TYPE,
14: p_your_number IN jl_br_ar_ret_interface_all.your_number%TYPE,
15: p_customer_name IN jl_br_ar_ret_interface_all.customer_name%TYPE,
8: p_bank_number IN jl_br_ar_ret_interface_all.bank_number%TYPE,
9: p_company_code IN jl_br_ar_ret_interface_all.company_code%TYPE,
10: p_inscription_number IN jl_br_ar_ret_interface_all.inscription_number%TYPE,
11: p_bank_occurrence_code IN jl_br_ar_ret_interface_all.bank_occurrence_code%TYPE,
12: p_occurrence_date IN jl_br_ar_ret_interface_all.occurrence_date%TYPE,
13: p_company_use IN jl_br_ar_ret_interface_all.company_use%TYPE,
14: p_your_number IN jl_br_ar_ret_interface_all.your_number%TYPE,
15: p_customer_name IN jl_br_ar_ret_interface_all.customer_name%TYPE,
16: p_trade_note_amount IN jl_br_ar_ret_interface_all.trade_note_amount%TYPE,
9: p_company_code IN jl_br_ar_ret_interface_all.company_code%TYPE,
10: p_inscription_number IN jl_br_ar_ret_interface_all.inscription_number%TYPE,
11: p_bank_occurrence_code IN jl_br_ar_ret_interface_all.bank_occurrence_code%TYPE,
12: p_occurrence_date IN jl_br_ar_ret_interface_all.occurrence_date%TYPE,
13: p_company_use IN jl_br_ar_ret_interface_all.company_use%TYPE,
14: p_your_number IN jl_br_ar_ret_interface_all.your_number%TYPE,
15: p_customer_name IN jl_br_ar_ret_interface_all.customer_name%TYPE,
16: p_trade_note_amount IN jl_br_ar_ret_interface_all.trade_note_amount%TYPE,
17: p_credit_amount IN jl_br_ar_ret_interface_all.credit_amount%TYPE,
10: p_inscription_number IN jl_br_ar_ret_interface_all.inscription_number%TYPE,
11: p_bank_occurrence_code IN jl_br_ar_ret_interface_all.bank_occurrence_code%TYPE,
12: p_occurrence_date IN jl_br_ar_ret_interface_all.occurrence_date%TYPE,
13: p_company_use IN jl_br_ar_ret_interface_all.company_use%TYPE,
14: p_your_number IN jl_br_ar_ret_interface_all.your_number%TYPE,
15: p_customer_name IN jl_br_ar_ret_interface_all.customer_name%TYPE,
16: p_trade_note_amount IN jl_br_ar_ret_interface_all.trade_note_amount%TYPE,
17: p_credit_amount IN jl_br_ar_ret_interface_all.credit_amount%TYPE,
18: p_interest_amount_received IN jl_br_ar_ret_interface_all.interest_amount_received%TYPE,
11: p_bank_occurrence_code IN jl_br_ar_ret_interface_all.bank_occurrence_code%TYPE,
12: p_occurrence_date IN jl_br_ar_ret_interface_all.occurrence_date%TYPE,
13: p_company_use IN jl_br_ar_ret_interface_all.company_use%TYPE,
14: p_your_number IN jl_br_ar_ret_interface_all.your_number%TYPE,
15: p_customer_name IN jl_br_ar_ret_interface_all.customer_name%TYPE,
16: p_trade_note_amount IN jl_br_ar_ret_interface_all.trade_note_amount%TYPE,
17: p_credit_amount IN jl_br_ar_ret_interface_all.credit_amount%TYPE,
18: p_interest_amount_received IN jl_br_ar_ret_interface_all.interest_amount_received%TYPE,
19: p_discount_amount IN jl_br_ar_ret_interface_all.discount_amount%TYPE,
12: p_occurrence_date IN jl_br_ar_ret_interface_all.occurrence_date%TYPE,
13: p_company_use IN jl_br_ar_ret_interface_all.company_use%TYPE,
14: p_your_number IN jl_br_ar_ret_interface_all.your_number%TYPE,
15: p_customer_name IN jl_br_ar_ret_interface_all.customer_name%TYPE,
16: p_trade_note_amount IN jl_br_ar_ret_interface_all.trade_note_amount%TYPE,
17: p_credit_amount IN jl_br_ar_ret_interface_all.credit_amount%TYPE,
18: p_interest_amount_received IN jl_br_ar_ret_interface_all.interest_amount_received%TYPE,
19: p_discount_amount IN jl_br_ar_ret_interface_all.discount_amount%TYPE,
20: p_abatement_amount IN jl_br_ar_ret_interface_all.abatement_amount%TYPE,
13: p_company_use IN jl_br_ar_ret_interface_all.company_use%TYPE,
14: p_your_number IN jl_br_ar_ret_interface_all.your_number%TYPE,
15: p_customer_name IN jl_br_ar_ret_interface_all.customer_name%TYPE,
16: p_trade_note_amount IN jl_br_ar_ret_interface_all.trade_note_amount%TYPE,
17: p_credit_amount IN jl_br_ar_ret_interface_all.credit_amount%TYPE,
18: p_interest_amount_received IN jl_br_ar_ret_interface_all.interest_amount_received%TYPE,
19: p_discount_amount IN jl_br_ar_ret_interface_all.discount_amount%TYPE,
20: p_abatement_amount IN jl_br_ar_ret_interface_all.abatement_amount%TYPE,
21: p_bank_party_id OUT NOCOPY NUMBER,
14: p_your_number IN jl_br_ar_ret_interface_all.your_number%TYPE,
15: p_customer_name IN jl_br_ar_ret_interface_all.customer_name%TYPE,
16: p_trade_note_amount IN jl_br_ar_ret_interface_all.trade_note_amount%TYPE,
17: p_credit_amount IN jl_br_ar_ret_interface_all.credit_amount%TYPE,
18: p_interest_amount_received IN jl_br_ar_ret_interface_all.interest_amount_received%TYPE,
19: p_discount_amount IN jl_br_ar_ret_interface_all.discount_amount%TYPE,
20: p_abatement_amount IN jl_br_ar_ret_interface_all.abatement_amount%TYPE,
21: p_bank_party_id OUT NOCOPY NUMBER,
22: p_error_code IN OUT NOCOPY VARCHAR2 );
15: p_customer_name IN jl_br_ar_ret_interface_all.customer_name%TYPE,
16: p_trade_note_amount IN jl_br_ar_ret_interface_all.trade_note_amount%TYPE,
17: p_credit_amount IN jl_br_ar_ret_interface_all.credit_amount%TYPE,
18: p_interest_amount_received IN jl_br_ar_ret_interface_all.interest_amount_received%TYPE,
19: p_discount_amount IN jl_br_ar_ret_interface_all.discount_amount%TYPE,
20: p_abatement_amount IN jl_br_ar_ret_interface_all.abatement_amount%TYPE,
21: p_bank_party_id OUT NOCOPY NUMBER,
22: p_error_code IN OUT NOCOPY VARCHAR2 );
23:
16: p_trade_note_amount IN jl_br_ar_ret_interface_all.trade_note_amount%TYPE,
17: p_credit_amount IN jl_br_ar_ret_interface_all.credit_amount%TYPE,
18: p_interest_amount_received IN jl_br_ar_ret_interface_all.interest_amount_received%TYPE,
19: p_discount_amount IN jl_br_ar_ret_interface_all.discount_amount%TYPE,
20: p_abatement_amount IN jl_br_ar_ret_interface_all.abatement_amount%TYPE,
21: p_bank_party_id OUT NOCOPY NUMBER,
22: p_error_code IN OUT NOCOPY VARCHAR2 );
23:
24: END JL_BR_AR_LOG_VALIDATION;