APPS.JL_BR_AP_PAY_SCHED_GDF_PKG dependencies on JL_BR_AP_COLLECTION_DOCS

Line 211: s_bank_collection_id jl_br_ap_collection_docs.bank_collection_id%Type;

207: p_colldoc_assoc Varchar2,
208: P_Vendor_Site_Id Number
209: ) IS
210: X_association_method Varchar2(25);
211: s_bank_collection_id jl_br_ap_collection_docs.bank_collection_id%Type;
212: s_associate_flag Varchar2(1);
213: l_rec_count Number;
214: l_new_date_char Varchar2(30);
215: errcode1 Number;

Line 398: Return : jl_br_ap_collection_docs.OUR_NUMBER

394: END VALIDATE_DATE;
395:
396: /* ***************************************************************
397: Function : GET_BORDERO_BANK_REF
398: Return : jl_br_ap_collection_docs.OUR_NUMBER
399: Type : Varchar2
400: Objective: Return Bank references stored in 'our_number'
401: to ipayments extract. This field is display in
402: Bordero as Bank Reference.

Line 411: From jl_br_ap_collection_docs jl

407: RETURN Varchar2
408: IS
409: Cursor Bank_Ref IS
410: Select jl.our_number
411: From jl_br_ap_collection_docs jl
412: ,ap_payment_schedules_all ap
413: ,iby_docs_payable_all iby
414: Where iby.document_payable_id = P_Doc_Payable_ID
415: And iby.calling_app_doc_unique_ref2 = ap.invoice_id

Line 419: Bank_Reference jl_br_ap_collection_docs.our_number%TYPE;

415: And iby.calling_app_doc_unique_ref2 = ap.invoice_id
416: And iby.calling_app_doc_unique_ref3 = ap.payment_num
417: And jl.bank_collection_id = ap.global_attribute11;
418:
419: Bank_Reference jl_br_ap_collection_docs.our_number%TYPE;
420:
421: Begin
422: P_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
423: Bank_Reference := NULL;