eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JL_BR_AR_LOG_VALIDATION dependencies on JL_BR_AR_RET_INTERFACE_ALL

Line 5: p_file_control IN jl_br_ar_ret_interface_all.file_control%TYPE,

1: PACKAGE BODY JL_BR_AR_LOG_VALIDATION as
2: /* $Header: jlbrrvlb.pls 120.18.12020000.2 2012/07/20 11:12:30 rshergil 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,

Line 6: p_ent_seq_num IN jl_br_ar_ret_interface_all.ENTRY_SEQUENTIAL_NUMBER%TYPE, -- Bug#8331293

2: /* $Header: jlbrrvlb.pls 120.18.12020000.2 2012/07/20 11:12:30 rshergil 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,

Line 8: p_bank_number IN jl_br_ar_ret_interface_all.bank_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,

Line 9: p_company_code IN jl_br_ar_ret_interface_all.company_code%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,

Line 10: p_inscription_number IN jl_br_ar_ret_interface_all.inscription_number%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,

Line 11: p_bank_occurrence_code IN jl_br_ar_ret_interface_all.bank_occurrence_code%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,

Line 12: p_occurrence_date IN jl_br_ar_ret_interface_all.occurrence_date%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,

Line 13: p_company_use IN jl_br_ar_ret_interface_all.company_use%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,

Line 14: p_your_number IN jl_br_ar_ret_interface_all.your_number%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,

Line 15: p_customer_name IN jl_br_ar_ret_interface_all.customer_name%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,

Line 16: p_trade_note_amount IN jl_br_ar_ret_interface_all.trade_note_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,

Line 17: p_credit_amount IN jl_br_ar_ret_interface_all.credit_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,

Line 18: p_interest_amount_received IN jl_br_ar_ret_interface_all.interest_amount_received%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,
22: p_error_code IN OUT NOCOPY varchar2)

Line 19: p_discount_amount IN jl_br_ar_ret_interface_all.discount_amount%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)
23: IS

Line 20: p_abatement_amount IN jl_br_ar_ret_interface_all.abatement_amount%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: IS
24: X_bank_number jl_br_ar_ret_interface_all.bank_number%TYPE;

Line 24: X_bank_number jl_br_ar_ret_interface_all.bank_number%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: IS
24: X_bank_number jl_br_ar_ret_interface_all.bank_number%TYPE;
25: X_jlbr_bank_number jl_br_ar_ret_interface_all.bank_number%TYPE;
26: X_remittance_bank jl_br_ar_ret_interface_all.bank_number%TYPE;
27: X_company_code jl_br_ar_ret_interface_all.company_code%TYPE;
28: X_inscription_number jl_br_ar_ret_interface_all.inscription_number%TYPE;

Line 25: X_jlbr_bank_number jl_br_ar_ret_interface_all.bank_number%TYPE;

21: p_bank_party_id OUT NOCOPY NUMBER,
22: p_error_code IN OUT NOCOPY varchar2)
23: IS
24: X_bank_number jl_br_ar_ret_interface_all.bank_number%TYPE;
25: X_jlbr_bank_number jl_br_ar_ret_interface_all.bank_number%TYPE;
26: X_remittance_bank jl_br_ar_ret_interface_all.bank_number%TYPE;
27: X_company_code jl_br_ar_ret_interface_all.company_code%TYPE;
28: X_inscription_number jl_br_ar_ret_interface_all.inscription_number%TYPE;
29: X_cgc jl_br_ar_ret_interface_all.inscription_number%TYPE;

Line 26: X_remittance_bank jl_br_ar_ret_interface_all.bank_number%TYPE;

22: p_error_code IN OUT NOCOPY varchar2)
23: IS
24: X_bank_number jl_br_ar_ret_interface_all.bank_number%TYPE;
25: X_jlbr_bank_number jl_br_ar_ret_interface_all.bank_number%TYPE;
26: X_remittance_bank jl_br_ar_ret_interface_all.bank_number%TYPE;
27: X_company_code jl_br_ar_ret_interface_all.company_code%TYPE;
28: X_inscription_number jl_br_ar_ret_interface_all.inscription_number%TYPE;
29: X_cgc jl_br_ar_ret_interface_all.inscription_number%TYPE;
30: X_bank_occurrence_code jl_br_ar_ret_interface_all.bank_occurrence_code%TYPE;

Line 27: X_company_code jl_br_ar_ret_interface_all.company_code%TYPE;

23: IS
24: X_bank_number jl_br_ar_ret_interface_all.bank_number%TYPE;
25: X_jlbr_bank_number jl_br_ar_ret_interface_all.bank_number%TYPE;
26: X_remittance_bank jl_br_ar_ret_interface_all.bank_number%TYPE;
27: X_company_code jl_br_ar_ret_interface_all.company_code%TYPE;
28: X_inscription_number jl_br_ar_ret_interface_all.inscription_number%TYPE;
29: X_cgc jl_br_ar_ret_interface_all.inscription_number%TYPE;
30: X_bank_occurrence_code jl_br_ar_ret_interface_all.bank_occurrence_code%TYPE;
31: X_company_use jl_br_ar_ret_interface_all.company_use%TYPE;

Line 28: X_inscription_number jl_br_ar_ret_interface_all.inscription_number%TYPE;

24: X_bank_number jl_br_ar_ret_interface_all.bank_number%TYPE;
25: X_jlbr_bank_number jl_br_ar_ret_interface_all.bank_number%TYPE;
26: X_remittance_bank jl_br_ar_ret_interface_all.bank_number%TYPE;
27: X_company_code jl_br_ar_ret_interface_all.company_code%TYPE;
28: X_inscription_number jl_br_ar_ret_interface_all.inscription_number%TYPE;
29: X_cgc jl_br_ar_ret_interface_all.inscription_number%TYPE;
30: X_bank_occurrence_code jl_br_ar_ret_interface_all.bank_occurrence_code%TYPE;
31: X_company_use jl_br_ar_ret_interface_all.company_use%TYPE;
32: X_your_number jl_br_ar_ret_interface_all.your_number%TYPE;

Line 29: X_cgc jl_br_ar_ret_interface_all.inscription_number%TYPE;

25: X_jlbr_bank_number jl_br_ar_ret_interface_all.bank_number%TYPE;
26: X_remittance_bank jl_br_ar_ret_interface_all.bank_number%TYPE;
27: X_company_code jl_br_ar_ret_interface_all.company_code%TYPE;
28: X_inscription_number jl_br_ar_ret_interface_all.inscription_number%TYPE;
29: X_cgc jl_br_ar_ret_interface_all.inscription_number%TYPE;
30: X_bank_occurrence_code jl_br_ar_ret_interface_all.bank_occurrence_code%TYPE;
31: X_company_use jl_br_ar_ret_interface_all.company_use%TYPE;
32: X_your_number jl_br_ar_ret_interface_all.your_number%TYPE;
33: X_bank_occurrence_code_std jl_br_ar_bank_occurrences.std_occurrence_code%TYPE;

Line 30: X_bank_occurrence_code jl_br_ar_ret_interface_all.bank_occurrence_code%TYPE;

26: X_remittance_bank jl_br_ar_ret_interface_all.bank_number%TYPE;
27: X_company_code jl_br_ar_ret_interface_all.company_code%TYPE;
28: X_inscription_number jl_br_ar_ret_interface_all.inscription_number%TYPE;
29: X_cgc jl_br_ar_ret_interface_all.inscription_number%TYPE;
30: X_bank_occurrence_code jl_br_ar_ret_interface_all.bank_occurrence_code%TYPE;
31: X_company_use jl_br_ar_ret_interface_all.company_use%TYPE;
32: X_your_number jl_br_ar_ret_interface_all.your_number%TYPE;
33: X_bank_occurrence_code_std jl_br_ar_bank_occurrences.std_occurrence_code%TYPE;
34: X_document_status jl_br_ar_collection_docs_all.document_status%TYPE;

Line 31: X_company_use jl_br_ar_ret_interface_all.company_use%TYPE;

27: X_company_code jl_br_ar_ret_interface_all.company_code%TYPE;
28: X_inscription_number jl_br_ar_ret_interface_all.inscription_number%TYPE;
29: X_cgc jl_br_ar_ret_interface_all.inscription_number%TYPE;
30: X_bank_occurrence_code jl_br_ar_ret_interface_all.bank_occurrence_code%TYPE;
31: X_company_use jl_br_ar_ret_interface_all.company_use%TYPE;
32: X_your_number jl_br_ar_ret_interface_all.your_number%TYPE;
33: X_bank_occurrence_code_std jl_br_ar_bank_occurrences.std_occurrence_code%TYPE;
34: X_document_status jl_br_ar_collection_docs_all.document_status%TYPE;
35: X_customer_name jl_br_ar_ret_interface_all.customer_name%TYPE;

Line 32: X_your_number jl_br_ar_ret_interface_all.your_number%TYPE;

28: X_inscription_number jl_br_ar_ret_interface_all.inscription_number%TYPE;
29: X_cgc jl_br_ar_ret_interface_all.inscription_number%TYPE;
30: X_bank_occurrence_code jl_br_ar_ret_interface_all.bank_occurrence_code%TYPE;
31: X_company_use jl_br_ar_ret_interface_all.company_use%TYPE;
32: X_your_number jl_br_ar_ret_interface_all.your_number%TYPE;
33: X_bank_occurrence_code_std jl_br_ar_bank_occurrences.std_occurrence_code%TYPE;
34: X_document_status jl_br_ar_collection_docs_all.document_status%TYPE;
35: X_customer_name jl_br_ar_ret_interface_all.customer_name%TYPE;
36: X_payment_schedule_id jl_br_ar_collection_docs_all.payment_schedule_id%TYPE;

Line 35: X_customer_name jl_br_ar_ret_interface_all.customer_name%TYPE;

31: X_company_use jl_br_ar_ret_interface_all.company_use%TYPE;
32: X_your_number jl_br_ar_ret_interface_all.your_number%TYPE;
33: X_bank_occurrence_code_std jl_br_ar_bank_occurrences.std_occurrence_code%TYPE;
34: X_document_status jl_br_ar_collection_docs_all.document_status%TYPE;
35: X_customer_name jl_br_ar_ret_interface_all.customer_name%TYPE;
36: X_payment_schedule_id jl_br_ar_collection_docs_all.payment_schedule_id%TYPE;
37: X_trade_note_amount jl_br_ar_ret_interface_all.trade_note_amount%TYPE;
38: X_document_amount jl_br_ar_ret_interface_all.trade_note_amount%TYPE;
39: X_credit_amount jl_br_ar_ret_interface_all.credit_amount%TYPE;

Line 37: X_trade_note_amount jl_br_ar_ret_interface_all.trade_note_amount%TYPE;

33: X_bank_occurrence_code_std jl_br_ar_bank_occurrences.std_occurrence_code%TYPE;
34: X_document_status jl_br_ar_collection_docs_all.document_status%TYPE;
35: X_customer_name jl_br_ar_ret_interface_all.customer_name%TYPE;
36: X_payment_schedule_id jl_br_ar_collection_docs_all.payment_schedule_id%TYPE;
37: X_trade_note_amount jl_br_ar_ret_interface_all.trade_note_amount%TYPE;
38: X_document_amount jl_br_ar_ret_interface_all.trade_note_amount%TYPE;
39: X_credit_amount jl_br_ar_ret_interface_all.credit_amount%TYPE;
40: X_interest_amount_received jl_br_ar_ret_interface_all.interest_amount_received%TYPE;
41: X_discount_amount jl_br_ar_ret_interface_all.discount_amount%TYPE;

Line 38: X_document_amount jl_br_ar_ret_interface_all.trade_note_amount%TYPE;

34: X_document_status jl_br_ar_collection_docs_all.document_status%TYPE;
35: X_customer_name jl_br_ar_ret_interface_all.customer_name%TYPE;
36: X_payment_schedule_id jl_br_ar_collection_docs_all.payment_schedule_id%TYPE;
37: X_trade_note_amount jl_br_ar_ret_interface_all.trade_note_amount%TYPE;
38: X_document_amount jl_br_ar_ret_interface_all.trade_note_amount%TYPE;
39: X_credit_amount jl_br_ar_ret_interface_all.credit_amount%TYPE;
40: X_interest_amount_received jl_br_ar_ret_interface_all.interest_amount_received%TYPE;
41: X_discount_amount jl_br_ar_ret_interface_all.discount_amount%TYPE;
42: X_abatement_amount jl_br_ar_ret_interface_all.abatement_amount%TYPE;

Line 39: X_credit_amount jl_br_ar_ret_interface_all.credit_amount%TYPE;

35: X_customer_name jl_br_ar_ret_interface_all.customer_name%TYPE;
36: X_payment_schedule_id jl_br_ar_collection_docs_all.payment_schedule_id%TYPE;
37: X_trade_note_amount jl_br_ar_ret_interface_all.trade_note_amount%TYPE;
38: X_document_amount jl_br_ar_ret_interface_all.trade_note_amount%TYPE;
39: X_credit_amount jl_br_ar_ret_interface_all.credit_amount%TYPE;
40: X_interest_amount_received jl_br_ar_ret_interface_all.interest_amount_received%TYPE;
41: X_discount_amount jl_br_ar_ret_interface_all.discount_amount%TYPE;
42: X_abatement_amount jl_br_ar_ret_interface_all.abatement_amount%TYPE;
43: X_customer_name1 jl_br_ar_ret_interface_all.customer_name%TYPE;

Line 40: X_interest_amount_received jl_br_ar_ret_interface_all.interest_amount_received%TYPE;

36: X_payment_schedule_id jl_br_ar_collection_docs_all.payment_schedule_id%TYPE;
37: X_trade_note_amount jl_br_ar_ret_interface_all.trade_note_amount%TYPE;
38: X_document_amount jl_br_ar_ret_interface_all.trade_note_amount%TYPE;
39: X_credit_amount jl_br_ar_ret_interface_all.credit_amount%TYPE;
40: X_interest_amount_received jl_br_ar_ret_interface_all.interest_amount_received%TYPE;
41: X_discount_amount jl_br_ar_ret_interface_all.discount_amount%TYPE;
42: X_abatement_amount jl_br_ar_ret_interface_all.abatement_amount%TYPE;
43: X_customer_name1 jl_br_ar_ret_interface_all.customer_name%TYPE;
44: X_dual_num number;

Line 41: X_discount_amount jl_br_ar_ret_interface_all.discount_amount%TYPE;

37: X_trade_note_amount jl_br_ar_ret_interface_all.trade_note_amount%TYPE;
38: X_document_amount jl_br_ar_ret_interface_all.trade_note_amount%TYPE;
39: X_credit_amount jl_br_ar_ret_interface_all.credit_amount%TYPE;
40: X_interest_amount_received jl_br_ar_ret_interface_all.interest_amount_received%TYPE;
41: X_discount_amount jl_br_ar_ret_interface_all.discount_amount%TYPE;
42: X_abatement_amount jl_br_ar_ret_interface_all.abatement_amount%TYPE;
43: X_customer_name1 jl_br_ar_ret_interface_all.customer_name%TYPE;
44: X_dual_num number;
45: X_remittance_bank_id NUMBER;

Line 42: X_abatement_amount jl_br_ar_ret_interface_all.abatement_amount%TYPE;

38: X_document_amount jl_br_ar_ret_interface_all.trade_note_amount%TYPE;
39: X_credit_amount jl_br_ar_ret_interface_all.credit_amount%TYPE;
40: X_interest_amount_received jl_br_ar_ret_interface_all.interest_amount_received%TYPE;
41: X_discount_amount jl_br_ar_ret_interface_all.discount_amount%TYPE;
42: X_abatement_amount jl_br_ar_ret_interface_all.abatement_amount%TYPE;
43: X_customer_name1 jl_br_ar_ret_interface_all.customer_name%TYPE;
44: X_dual_num number;
45: X_remittance_bank_id NUMBER;
46: error_validation EXCEPTION;

Line 43: X_customer_name1 jl_br_ar_ret_interface_all.customer_name%TYPE;

39: X_credit_amount jl_br_ar_ret_interface_all.credit_amount%TYPE;
40: X_interest_amount_received jl_br_ar_ret_interface_all.interest_amount_received%TYPE;
41: X_discount_amount jl_br_ar_ret_interface_all.discount_amount%TYPE;
42: X_abatement_amount jl_br_ar_ret_interface_all.abatement_amount%TYPE;
43: X_customer_name1 jl_br_ar_ret_interface_all.customer_name%TYPE;
44: X_dual_num number;
45: X_remittance_bank_id NUMBER;
46: error_validation EXCEPTION;
47: valid_date BOOLEAN;

Line 71: ,cp_file_control jl_br_ar_ret_interface_all.file_control%TYPE

67:
68: -- Bug#8331293 Replaced SQL query with cursor
69: Cursor Comp_JLBRRVFD ( cp_ledger_id ar_system_parameters.set_of_books_id%TYPE
70: ,cp_lacct_balancing_segment ar_system_parameters.global_attribute1%TYPE
71: ,cp_file_control jl_br_ar_ret_interface_all.file_control%TYPE
72: ,cp_ent_seq_num jl_br_ar_ret_interface_all.ENTRY_SEQUENTIAL_NUMBER%TYPE)
73: IS
74: Select etb.registration_number
75: From

Line 72: ,cp_ent_seq_num jl_br_ar_ret_interface_all.ENTRY_SEQUENTIAL_NUMBER%TYPE)

68: -- Bug#8331293 Replaced SQL query with cursor
69: Cursor Comp_JLBRRVFD ( cp_ledger_id ar_system_parameters.set_of_books_id%TYPE
70: ,cp_lacct_balancing_segment ar_system_parameters.global_attribute1%TYPE
71: ,cp_file_control jl_br_ar_ret_interface_all.file_control%TYPE
72: ,cp_ent_seq_num jl_br_ar_ret_interface_all.ENTRY_SEQUENTIAL_NUMBER%TYPE)
73: IS
74: Select etb.registration_number
75: From
76: xle_establishment_v etb

Line 103: ,cp_file_control jl_br_ar_ret_interface_all.file_control%TYPE

99: and trunc(nvl(bsv.effective_to,SYSDATE)); --bug 9239401
100:
101: Cursor Comp_JLBRRCDB ( cp_ledger_id ar_system_parameters.set_of_books_id%TYPE
102: ,cp_lacct_balancing_segment ar_system_parameters.global_attribute1%TYPE
103: ,cp_file_control jl_br_ar_ret_interface_all.file_control%TYPE
104: ,cp_ent_seq_num jl_br_ar_ret_interface_all.ENTRY_SEQUENTIAL_NUMBER%TYPE)
105: IS
106: Select etb.registration_number
107: From

Line 104: ,cp_ent_seq_num jl_br_ar_ret_interface_all.ENTRY_SEQUENTIAL_NUMBER%TYPE)

100:
101: Cursor Comp_JLBRRCDB ( cp_ledger_id ar_system_parameters.set_of_books_id%TYPE
102: ,cp_lacct_balancing_segment ar_system_parameters.global_attribute1%TYPE
103: ,cp_file_control jl_br_ar_ret_interface_all.file_control%TYPE
104: ,cp_ent_seq_num jl_br_ar_ret_interface_all.ENTRY_SEQUENTIAL_NUMBER%TYPE)
105: IS
106: Select etb.registration_number
107: From
108: xle_establishment_v etb