1: PACKAGE BODY JL_BR_AR_LOG_VALIDATION as
2: /* $Header: jlbrrvlb.pls 120.11 2006/05/05 21:21:12 appradha ship $ */
3:
4: PROCEDURE logical_validation(
5: p_file_control IN jl_br_ar_ret_interface_all.file_control%TYPE,
6: p_bank_number IN jl_br_ar_ret_interface_all.bank_number%TYPE,
7: p_company_code IN jl_br_ar_ret_interface_all.company_code%TYPE,
8: p_inscription_number IN jl_br_ar_ret_interface_all.inscription_number%TYPE,
9: p_bank_occurrence_code IN jl_br_ar_ret_interface_all.bank_occurrence_code%TYPE,
2: /* $Header: jlbrrvlb.pls 120.11 2006/05/05 21:21:12 appradha ship $ */
3:
4: PROCEDURE logical_validation(
5: p_file_control IN jl_br_ar_ret_interface_all.file_control%TYPE,
6: p_bank_number IN jl_br_ar_ret_interface_all.bank_number%TYPE,
7: p_company_code IN jl_br_ar_ret_interface_all.company_code%TYPE,
8: p_inscription_number IN jl_br_ar_ret_interface_all.inscription_number%TYPE,
9: p_bank_occurrence_code IN jl_br_ar_ret_interface_all.bank_occurrence_code%TYPE,
10: p_occurrence_date IN jl_br_ar_ret_interface_all.occurrence_date%TYPE,
3:
4: PROCEDURE logical_validation(
5: p_file_control IN jl_br_ar_ret_interface_all.file_control%TYPE,
6: p_bank_number IN jl_br_ar_ret_interface_all.bank_number%TYPE,
7: p_company_code IN jl_br_ar_ret_interface_all.company_code%TYPE,
8: p_inscription_number IN jl_br_ar_ret_interface_all.inscription_number%TYPE,
9: p_bank_occurrence_code IN jl_br_ar_ret_interface_all.bank_occurrence_code%TYPE,
10: p_occurrence_date IN jl_br_ar_ret_interface_all.occurrence_date%TYPE,
11: p_company_use IN jl_br_ar_ret_interface_all.company_use%TYPE,
4: PROCEDURE logical_validation(
5: p_file_control IN jl_br_ar_ret_interface_all.file_control%TYPE,
6: p_bank_number IN jl_br_ar_ret_interface_all.bank_number%TYPE,
7: p_company_code IN jl_br_ar_ret_interface_all.company_code%TYPE,
8: p_inscription_number IN jl_br_ar_ret_interface_all.inscription_number%TYPE,
9: p_bank_occurrence_code IN jl_br_ar_ret_interface_all.bank_occurrence_code%TYPE,
10: p_occurrence_date IN jl_br_ar_ret_interface_all.occurrence_date%TYPE,
11: p_company_use IN jl_br_ar_ret_interface_all.company_use%TYPE,
12: p_your_number IN jl_br_ar_ret_interface_all.your_number%TYPE,
5: p_file_control IN jl_br_ar_ret_interface_all.file_control%TYPE,
6: p_bank_number IN jl_br_ar_ret_interface_all.bank_number%TYPE,
7: p_company_code IN jl_br_ar_ret_interface_all.company_code%TYPE,
8: p_inscription_number IN jl_br_ar_ret_interface_all.inscription_number%TYPE,
9: p_bank_occurrence_code IN jl_br_ar_ret_interface_all.bank_occurrence_code%TYPE,
10: p_occurrence_date IN jl_br_ar_ret_interface_all.occurrence_date%TYPE,
11: p_company_use IN jl_br_ar_ret_interface_all.company_use%TYPE,
12: p_your_number IN jl_br_ar_ret_interface_all.your_number%TYPE,
13: p_customer_name IN jl_br_ar_ret_interface_all.customer_name%TYPE,
6: p_bank_number IN jl_br_ar_ret_interface_all.bank_number%TYPE,
7: p_company_code IN jl_br_ar_ret_interface_all.company_code%TYPE,
8: p_inscription_number IN jl_br_ar_ret_interface_all.inscription_number%TYPE,
9: p_bank_occurrence_code IN jl_br_ar_ret_interface_all.bank_occurrence_code%TYPE,
10: p_occurrence_date IN jl_br_ar_ret_interface_all.occurrence_date%TYPE,
11: p_company_use IN jl_br_ar_ret_interface_all.company_use%TYPE,
12: p_your_number IN jl_br_ar_ret_interface_all.your_number%TYPE,
13: p_customer_name IN jl_br_ar_ret_interface_all.customer_name%TYPE,
14: p_trade_note_amount IN jl_br_ar_ret_interface_all.trade_note_amount%TYPE,
7: p_company_code IN jl_br_ar_ret_interface_all.company_code%TYPE,
8: p_inscription_number IN jl_br_ar_ret_interface_all.inscription_number%TYPE,
9: p_bank_occurrence_code IN jl_br_ar_ret_interface_all.bank_occurrence_code%TYPE,
10: p_occurrence_date IN jl_br_ar_ret_interface_all.occurrence_date%TYPE,
11: p_company_use IN jl_br_ar_ret_interface_all.company_use%TYPE,
12: p_your_number IN jl_br_ar_ret_interface_all.your_number%TYPE,
13: p_customer_name IN jl_br_ar_ret_interface_all.customer_name%TYPE,
14: p_trade_note_amount IN jl_br_ar_ret_interface_all.trade_note_amount%TYPE,
15: p_credit_amount IN jl_br_ar_ret_interface_all.credit_amount%TYPE,
8: p_inscription_number IN jl_br_ar_ret_interface_all.inscription_number%TYPE,
9: p_bank_occurrence_code IN jl_br_ar_ret_interface_all.bank_occurrence_code%TYPE,
10: p_occurrence_date IN jl_br_ar_ret_interface_all.occurrence_date%TYPE,
11: p_company_use IN jl_br_ar_ret_interface_all.company_use%TYPE,
12: p_your_number IN jl_br_ar_ret_interface_all.your_number%TYPE,
13: p_customer_name IN jl_br_ar_ret_interface_all.customer_name%TYPE,
14: p_trade_note_amount IN jl_br_ar_ret_interface_all.trade_note_amount%TYPE,
15: p_credit_amount IN jl_br_ar_ret_interface_all.credit_amount%TYPE,
16: p_interest_amount_received IN jl_br_ar_ret_interface_all.interest_amount_received%TYPE,
9: p_bank_occurrence_code IN jl_br_ar_ret_interface_all.bank_occurrence_code%TYPE,
10: p_occurrence_date IN jl_br_ar_ret_interface_all.occurrence_date%TYPE,
11: p_company_use IN jl_br_ar_ret_interface_all.company_use%TYPE,
12: p_your_number IN jl_br_ar_ret_interface_all.your_number%TYPE,
13: p_customer_name IN jl_br_ar_ret_interface_all.customer_name%TYPE,
14: p_trade_note_amount IN jl_br_ar_ret_interface_all.trade_note_amount%TYPE,
15: p_credit_amount IN jl_br_ar_ret_interface_all.credit_amount%TYPE,
16: p_interest_amount_received IN jl_br_ar_ret_interface_all.interest_amount_received%TYPE,
17: p_discount_amount IN jl_br_ar_ret_interface_all.discount_amount%TYPE,
10: p_occurrence_date IN jl_br_ar_ret_interface_all.occurrence_date%TYPE,
11: p_company_use IN jl_br_ar_ret_interface_all.company_use%TYPE,
12: p_your_number IN jl_br_ar_ret_interface_all.your_number%TYPE,
13: p_customer_name IN jl_br_ar_ret_interface_all.customer_name%TYPE,
14: p_trade_note_amount IN jl_br_ar_ret_interface_all.trade_note_amount%TYPE,
15: p_credit_amount IN jl_br_ar_ret_interface_all.credit_amount%TYPE,
16: p_interest_amount_received IN jl_br_ar_ret_interface_all.interest_amount_received%TYPE,
17: p_discount_amount IN jl_br_ar_ret_interface_all.discount_amount%TYPE,
18: p_abatement_amount IN jl_br_ar_ret_interface_all.abatement_amount%TYPE,
11: p_company_use IN jl_br_ar_ret_interface_all.company_use%TYPE,
12: p_your_number IN jl_br_ar_ret_interface_all.your_number%TYPE,
13: p_customer_name IN jl_br_ar_ret_interface_all.customer_name%TYPE,
14: p_trade_note_amount IN jl_br_ar_ret_interface_all.trade_note_amount%TYPE,
15: p_credit_amount IN jl_br_ar_ret_interface_all.credit_amount%TYPE,
16: p_interest_amount_received IN jl_br_ar_ret_interface_all.interest_amount_received%TYPE,
17: p_discount_amount IN jl_br_ar_ret_interface_all.discount_amount%TYPE,
18: p_abatement_amount IN jl_br_ar_ret_interface_all.abatement_amount%TYPE,
19: p_bank_party_id OUT NOCOPY NUMBER,
12: p_your_number IN jl_br_ar_ret_interface_all.your_number%TYPE,
13: p_customer_name IN jl_br_ar_ret_interface_all.customer_name%TYPE,
14: p_trade_note_amount IN jl_br_ar_ret_interface_all.trade_note_amount%TYPE,
15: p_credit_amount IN jl_br_ar_ret_interface_all.credit_amount%TYPE,
16: p_interest_amount_received IN jl_br_ar_ret_interface_all.interest_amount_received%TYPE,
17: p_discount_amount IN jl_br_ar_ret_interface_all.discount_amount%TYPE,
18: p_abatement_amount IN jl_br_ar_ret_interface_all.abatement_amount%TYPE,
19: p_bank_party_id OUT NOCOPY NUMBER,
20: p_error_code IN OUT NOCOPY varchar2)
13: p_customer_name IN jl_br_ar_ret_interface_all.customer_name%TYPE,
14: p_trade_note_amount IN jl_br_ar_ret_interface_all.trade_note_amount%TYPE,
15: p_credit_amount IN jl_br_ar_ret_interface_all.credit_amount%TYPE,
16: p_interest_amount_received IN jl_br_ar_ret_interface_all.interest_amount_received%TYPE,
17: p_discount_amount IN jl_br_ar_ret_interface_all.discount_amount%TYPE,
18: p_abatement_amount IN jl_br_ar_ret_interface_all.abatement_amount%TYPE,
19: p_bank_party_id OUT NOCOPY NUMBER,
20: p_error_code IN OUT NOCOPY varchar2)
21: IS
14: p_trade_note_amount IN jl_br_ar_ret_interface_all.trade_note_amount%TYPE,
15: p_credit_amount IN jl_br_ar_ret_interface_all.credit_amount%TYPE,
16: p_interest_amount_received IN jl_br_ar_ret_interface_all.interest_amount_received%TYPE,
17: p_discount_amount IN jl_br_ar_ret_interface_all.discount_amount%TYPE,
18: p_abatement_amount IN jl_br_ar_ret_interface_all.abatement_amount%TYPE,
19: p_bank_party_id OUT NOCOPY NUMBER,
20: p_error_code IN OUT NOCOPY varchar2)
21: IS
22: X_bank_number jl_br_ar_ret_interface_all.bank_number%TYPE;
18: p_abatement_amount IN jl_br_ar_ret_interface_all.abatement_amount%TYPE,
19: p_bank_party_id OUT NOCOPY NUMBER,
20: p_error_code IN OUT NOCOPY varchar2)
21: IS
22: X_bank_number jl_br_ar_ret_interface_all.bank_number%TYPE;
23: X_jlbr_bank_number jl_br_ar_ret_interface_all.bank_number%TYPE;
24: X_remittance_bank jl_br_ar_ret_interface_all.bank_number%TYPE;
25: X_company_code jl_br_ar_ret_interface_all.company_code%TYPE;
26: X_inscription_number jl_br_ar_ret_interface_all.inscription_number%TYPE;
19: p_bank_party_id OUT NOCOPY NUMBER,
20: p_error_code IN OUT NOCOPY varchar2)
21: IS
22: X_bank_number jl_br_ar_ret_interface_all.bank_number%TYPE;
23: X_jlbr_bank_number jl_br_ar_ret_interface_all.bank_number%TYPE;
24: X_remittance_bank jl_br_ar_ret_interface_all.bank_number%TYPE;
25: X_company_code jl_br_ar_ret_interface_all.company_code%TYPE;
26: X_inscription_number jl_br_ar_ret_interface_all.inscription_number%TYPE;
27: X_cgc jl_br_ar_ret_interface_all.inscription_number%TYPE;
20: p_error_code IN OUT NOCOPY varchar2)
21: IS
22: X_bank_number jl_br_ar_ret_interface_all.bank_number%TYPE;
23: X_jlbr_bank_number jl_br_ar_ret_interface_all.bank_number%TYPE;
24: X_remittance_bank jl_br_ar_ret_interface_all.bank_number%TYPE;
25: X_company_code jl_br_ar_ret_interface_all.company_code%TYPE;
26: X_inscription_number jl_br_ar_ret_interface_all.inscription_number%TYPE;
27: X_cgc jl_br_ar_ret_interface_all.inscription_number%TYPE;
28: X_bank_occurrence_code jl_br_ar_ret_interface_all.bank_occurrence_code%TYPE;
21: IS
22: X_bank_number jl_br_ar_ret_interface_all.bank_number%TYPE;
23: X_jlbr_bank_number jl_br_ar_ret_interface_all.bank_number%TYPE;
24: X_remittance_bank jl_br_ar_ret_interface_all.bank_number%TYPE;
25: X_company_code jl_br_ar_ret_interface_all.company_code%TYPE;
26: X_inscription_number jl_br_ar_ret_interface_all.inscription_number%TYPE;
27: X_cgc jl_br_ar_ret_interface_all.inscription_number%TYPE;
28: X_bank_occurrence_code jl_br_ar_ret_interface_all.bank_occurrence_code%TYPE;
29: X_company_use jl_br_ar_ret_interface_all.company_use%TYPE;
22: X_bank_number jl_br_ar_ret_interface_all.bank_number%TYPE;
23: X_jlbr_bank_number jl_br_ar_ret_interface_all.bank_number%TYPE;
24: X_remittance_bank jl_br_ar_ret_interface_all.bank_number%TYPE;
25: X_company_code jl_br_ar_ret_interface_all.company_code%TYPE;
26: X_inscription_number jl_br_ar_ret_interface_all.inscription_number%TYPE;
27: X_cgc jl_br_ar_ret_interface_all.inscription_number%TYPE;
28: X_bank_occurrence_code jl_br_ar_ret_interface_all.bank_occurrence_code%TYPE;
29: X_company_use jl_br_ar_ret_interface_all.company_use%TYPE;
30: X_your_number jl_br_ar_ret_interface_all.your_number%TYPE;
23: X_jlbr_bank_number jl_br_ar_ret_interface_all.bank_number%TYPE;
24: X_remittance_bank jl_br_ar_ret_interface_all.bank_number%TYPE;
25: X_company_code jl_br_ar_ret_interface_all.company_code%TYPE;
26: X_inscription_number jl_br_ar_ret_interface_all.inscription_number%TYPE;
27: X_cgc jl_br_ar_ret_interface_all.inscription_number%TYPE;
28: X_bank_occurrence_code jl_br_ar_ret_interface_all.bank_occurrence_code%TYPE;
29: X_company_use jl_br_ar_ret_interface_all.company_use%TYPE;
30: X_your_number jl_br_ar_ret_interface_all.your_number%TYPE;
31: X_bank_occurrence_code_std jl_br_ar_bank_occurrences.std_occurrence_code%TYPE;
24: X_remittance_bank jl_br_ar_ret_interface_all.bank_number%TYPE;
25: X_company_code jl_br_ar_ret_interface_all.company_code%TYPE;
26: X_inscription_number jl_br_ar_ret_interface_all.inscription_number%TYPE;
27: X_cgc jl_br_ar_ret_interface_all.inscription_number%TYPE;
28: X_bank_occurrence_code jl_br_ar_ret_interface_all.bank_occurrence_code%TYPE;
29: X_company_use jl_br_ar_ret_interface_all.company_use%TYPE;
30: X_your_number jl_br_ar_ret_interface_all.your_number%TYPE;
31: X_bank_occurrence_code_std jl_br_ar_bank_occurrences.std_occurrence_code%TYPE;
32: X_document_status jl_br_ar_collection_docs_all.document_status%TYPE;
25: X_company_code jl_br_ar_ret_interface_all.company_code%TYPE;
26: X_inscription_number jl_br_ar_ret_interface_all.inscription_number%TYPE;
27: X_cgc jl_br_ar_ret_interface_all.inscription_number%TYPE;
28: X_bank_occurrence_code jl_br_ar_ret_interface_all.bank_occurrence_code%TYPE;
29: X_company_use jl_br_ar_ret_interface_all.company_use%TYPE;
30: X_your_number jl_br_ar_ret_interface_all.your_number%TYPE;
31: X_bank_occurrence_code_std jl_br_ar_bank_occurrences.std_occurrence_code%TYPE;
32: X_document_status jl_br_ar_collection_docs_all.document_status%TYPE;
33: X_customer_name jl_br_ar_ret_interface_all.customer_name%TYPE;
26: X_inscription_number jl_br_ar_ret_interface_all.inscription_number%TYPE;
27: X_cgc jl_br_ar_ret_interface_all.inscription_number%TYPE;
28: X_bank_occurrence_code jl_br_ar_ret_interface_all.bank_occurrence_code%TYPE;
29: X_company_use jl_br_ar_ret_interface_all.company_use%TYPE;
30: X_your_number jl_br_ar_ret_interface_all.your_number%TYPE;
31: X_bank_occurrence_code_std jl_br_ar_bank_occurrences.std_occurrence_code%TYPE;
32: X_document_status jl_br_ar_collection_docs_all.document_status%TYPE;
33: X_customer_name jl_br_ar_ret_interface_all.customer_name%TYPE;
34: X_payment_schedule_id jl_br_ar_collection_docs_all.payment_schedule_id%TYPE;
29: X_company_use jl_br_ar_ret_interface_all.company_use%TYPE;
30: X_your_number jl_br_ar_ret_interface_all.your_number%TYPE;
31: X_bank_occurrence_code_std jl_br_ar_bank_occurrences.std_occurrence_code%TYPE;
32: X_document_status jl_br_ar_collection_docs_all.document_status%TYPE;
33: X_customer_name jl_br_ar_ret_interface_all.customer_name%TYPE;
34: X_payment_schedule_id jl_br_ar_collection_docs_all.payment_schedule_id%TYPE;
35: X_trade_note_amount jl_br_ar_ret_interface_all.trade_note_amount%TYPE;
36: X_document_amount jl_br_ar_ret_interface_all.trade_note_amount%TYPE;
37: X_credit_amount jl_br_ar_ret_interface_all.credit_amount%TYPE;
31: X_bank_occurrence_code_std jl_br_ar_bank_occurrences.std_occurrence_code%TYPE;
32: X_document_status jl_br_ar_collection_docs_all.document_status%TYPE;
33: X_customer_name jl_br_ar_ret_interface_all.customer_name%TYPE;
34: X_payment_schedule_id jl_br_ar_collection_docs_all.payment_schedule_id%TYPE;
35: X_trade_note_amount jl_br_ar_ret_interface_all.trade_note_amount%TYPE;
36: X_document_amount jl_br_ar_ret_interface_all.trade_note_amount%TYPE;
37: X_credit_amount jl_br_ar_ret_interface_all.credit_amount%TYPE;
38: X_interest_amount_received jl_br_ar_ret_interface_all.interest_amount_received%TYPE;
39: X_discount_amount jl_br_ar_ret_interface_all.discount_amount%TYPE;
32: X_document_status jl_br_ar_collection_docs_all.document_status%TYPE;
33: X_customer_name jl_br_ar_ret_interface_all.customer_name%TYPE;
34: X_payment_schedule_id jl_br_ar_collection_docs_all.payment_schedule_id%TYPE;
35: X_trade_note_amount jl_br_ar_ret_interface_all.trade_note_amount%TYPE;
36: X_document_amount jl_br_ar_ret_interface_all.trade_note_amount%TYPE;
37: X_credit_amount jl_br_ar_ret_interface_all.credit_amount%TYPE;
38: X_interest_amount_received jl_br_ar_ret_interface_all.interest_amount_received%TYPE;
39: X_discount_amount jl_br_ar_ret_interface_all.discount_amount%TYPE;
40: X_abatement_amount jl_br_ar_ret_interface_all.abatement_amount%TYPE;
33: X_customer_name jl_br_ar_ret_interface_all.customer_name%TYPE;
34: X_payment_schedule_id jl_br_ar_collection_docs_all.payment_schedule_id%TYPE;
35: X_trade_note_amount jl_br_ar_ret_interface_all.trade_note_amount%TYPE;
36: X_document_amount jl_br_ar_ret_interface_all.trade_note_amount%TYPE;
37: X_credit_amount jl_br_ar_ret_interface_all.credit_amount%TYPE;
38: X_interest_amount_received jl_br_ar_ret_interface_all.interest_amount_received%TYPE;
39: X_discount_amount jl_br_ar_ret_interface_all.discount_amount%TYPE;
40: X_abatement_amount jl_br_ar_ret_interface_all.abatement_amount%TYPE;
41: X_customer_name1 jl_br_ar_ret_interface_all.customer_name%TYPE;
34: X_payment_schedule_id jl_br_ar_collection_docs_all.payment_schedule_id%TYPE;
35: X_trade_note_amount jl_br_ar_ret_interface_all.trade_note_amount%TYPE;
36: X_document_amount jl_br_ar_ret_interface_all.trade_note_amount%TYPE;
37: X_credit_amount jl_br_ar_ret_interface_all.credit_amount%TYPE;
38: X_interest_amount_received jl_br_ar_ret_interface_all.interest_amount_received%TYPE;
39: X_discount_amount jl_br_ar_ret_interface_all.discount_amount%TYPE;
40: X_abatement_amount jl_br_ar_ret_interface_all.abatement_amount%TYPE;
41: X_customer_name1 jl_br_ar_ret_interface_all.customer_name%TYPE;
42: X_dual_num number;
35: X_trade_note_amount jl_br_ar_ret_interface_all.trade_note_amount%TYPE;
36: X_document_amount jl_br_ar_ret_interface_all.trade_note_amount%TYPE;
37: X_credit_amount jl_br_ar_ret_interface_all.credit_amount%TYPE;
38: X_interest_amount_received jl_br_ar_ret_interface_all.interest_amount_received%TYPE;
39: X_discount_amount jl_br_ar_ret_interface_all.discount_amount%TYPE;
40: X_abatement_amount jl_br_ar_ret_interface_all.abatement_amount%TYPE;
41: X_customer_name1 jl_br_ar_ret_interface_all.customer_name%TYPE;
42: X_dual_num number;
43: X_remittance_bank_id NUMBER;
36: X_document_amount jl_br_ar_ret_interface_all.trade_note_amount%TYPE;
37: X_credit_amount jl_br_ar_ret_interface_all.credit_amount%TYPE;
38: X_interest_amount_received jl_br_ar_ret_interface_all.interest_amount_received%TYPE;
39: X_discount_amount jl_br_ar_ret_interface_all.discount_amount%TYPE;
40: X_abatement_amount jl_br_ar_ret_interface_all.abatement_amount%TYPE;
41: X_customer_name1 jl_br_ar_ret_interface_all.customer_name%TYPE;
42: X_dual_num number;
43: X_remittance_bank_id NUMBER;
44: error_validation EXCEPTION;
37: X_credit_amount jl_br_ar_ret_interface_all.credit_amount%TYPE;
38: X_interest_amount_received jl_br_ar_ret_interface_all.interest_amount_received%TYPE;
39: X_discount_amount jl_br_ar_ret_interface_all.discount_amount%TYPE;
40: X_abatement_amount jl_br_ar_ret_interface_all.abatement_amount%TYPE;
41: X_customer_name1 jl_br_ar_ret_interface_all.customer_name%TYPE;
42: X_dual_num number;
43: X_remittance_bank_id NUMBER;
44: error_validation EXCEPTION;
45: valid_date BOOLEAN;