[Home] [Help]
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;
37: X_trade_note_amount jl_br_ar_ret_interface_all.trade_note_amount%TYPE;
167: BEGIN
168: /* CE uptake - Bug#2932986
169: SELECT distinct bank_number
170: INTO X_jlbr_bank_number
171: FROM jl_br_ar_bank_occurrences
172: WHERE bank_number = X_bank_number
173: AND ROWNUM < 2;
174: */
175:
176: SELECT prof.bank_or_branch_number,
177: nvl(occ.bank_party_id,0) --bug 8527766 - can be NULL in occ table
178: INTO X_jlbr_bank_number,
179: p_bank_party_id
180: FROM jl_br_ar_bank_occurrences occ,
181: hz_organization_profiles prof
182: WHERE prof.bank_or_branch_number = X_bank_number
183: AND occ.bank_party_id = prof.party_id
184: AND prof.home_country ='BR'
203: BEGIN
204: -- CE uptake - Bug#2932986
205: SELECT occ.std_occurrence_code
206: INTO X_bank_occurrence_code_std
207: FROM jl_br_ar_bank_occurrences occ,
208: hz_organization_profiles prof
209: WHERE occ.bank_occurrence_code = X_bank_occurrence_code
210: AND prof.bank_or_branch_number = X_bank_number
211: AND occ.bank_party_id = prof.party_id
723:
724: BEGIN
725: SELECT nvl(doc.document_amount,0)
726: INTO X_document_amount
727: FROM jl_br_ar_bank_occurrences ban,
728: jl_br_ar_occurrence_docs_all doc,
729: jl_br_ar_collection_docs cob
730: WHERE ban.std_occurrence_code = 'REMITTANCE'
731: AND ban.bank_occurrence_type = 'REMITTANCE_OCCURRENCE'