APPS.JL_BR_AP_PAY_SCHED_GDF_PKG dependencies on IBY_DOCS_PAYABLE_ALL

Line 405: (P_Doc_Payable_ID IN IBY_Docs_Payable_All.document_payable_id%TYPE,

401: to ipayments extract. This field is display in
402: Bordero as Bank Reference.
403: *************************************************************** */
404: FUNCTION Get_Bordero_Bank_Ref
405: (P_Doc_Payable_ID IN IBY_Docs_Payable_All.document_payable_id%TYPE,
406: P_RETURN_STATUS OUT NOCOPY Varchar2)
407: RETURN Varchar2
408: IS
409: Cursor Bank_Ref IS

Line 413: ,iby_docs_payable_all iby

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
416: And iby.calling_app_doc_unique_ref3 = ap.payment_num
417: And jl.bank_collection_id = ap.global_attribute11;

Line 443: (P_Doc_Payable_ID IN IBY_Docs_Payable_All.document_payable_id%TYPE,

439: Type : Number
440: Objective: Return Invoice Interest Amount
441: *************************************************************** */
442: FUNCTION Get_Bordero_Int_Amt
443: (P_Doc_Payable_ID IN IBY_Docs_Payable_All.document_payable_id%TYPE,
444: P_Process_Type IN VARCHAR2,
445: P_RETURN_STATUS OUT NOCOPY Varchar2)
446: RETURN Number
447: IS

Line 451: ,iby_docs_payable_all docs

447: IS
448: CURSOR Process_Type IS
449: SELECT pays.process_type
450: FROM iby_payments_all pays
451: ,iby_docs_payable_all docs
452: WHERE pays.payment_id = docs.payment_id
453: AND docs.document_payable_id = P_Doc_Payable_ID;
454:
455: int_amt number;

Line 475: iby_docs_payable_all iby

471: select sum(nvl(int.invoice_amount,0))
472: into int_amt
473: from ap_invoices_all int,
474: ap_invoice_relationships rel,
475: iby_docs_payable_all iby
476: where rel.original_invoice_id = iby.calling_app_doc_unique_ref2 -- ap.invoice_id
477: and rel.original_payment_num = iby.calling_app_doc_unique_ref3 -- ap.payment_num
478: and int.invoice_id = rel.related_invoice_id
479: and iby.document_payable_id = P_Doc_Payable_ID;

Line 491: iby_docs_payable_all iby

487: IF (l_process_type <> 'IMMEDIATE' or P_Process_Type IS NULL) THEN
488: SELECT sum(nvl(invoice_amount,0))
489: INTO int_amt
490: FROM ap_selected_invoices_all ap,
491: iby_docs_payable_all iby
492: WHERE original_invoice_id = iby.calling_app_doc_unique_ref2 -- :invoice_id
493: AND original_payment_num = iby.calling_app_doc_unique_ref3 -- :payment_num
494: AND iby.document_payable_id = P_Doc_Payable_ID;
495: return(int_amt);

Line 512: (P_Doc_Payable_ID IN IBY_Docs_Payable_All.document_payable_id%TYPE,

508: Type : Number
509: Objective: Return Invoice Abatement Amount
510: *************************************************************** */
511: FUNCTION Get_Bordero_Abatement
512: (P_Doc_Payable_ID IN IBY_Docs_Payable_All.document_payable_id%TYPE,
513: P_Process_Type IN VARCHAR2,
514: P_RETURN_STATUS OUT NOCOPY Varchar2)
515: RETURN Number
516: IS

Line 520: ,iby_docs_payable_all docs

516: IS
517: CURSOR Process_Type IS
518: SELECT pays.process_type
519: FROM iby_payments_all pays
520: ,iby_docs_payable_all docs
521: WHERE pays.payment_id = docs.payment_id
522: AND docs.document_payable_id = P_Doc_Payable_ID;
523:
524: abate number;

Line 546: iby_docs_payable_all iby

542: INTO abate
543: FROM ap_invoice_distributions_all aid,
544: ap_invoice_payments_all aip,
545: ap_checks_all ac,
546: iby_docs_payable_all iby
547: WHERE aid.invoice_id = aip.invoice_id
548: AND ac.check_number = iby.payment_id -- :check_number
549: AND ac.check_id = aip.check_id
550: AND aid.parent_invoice_id = iby.calling_app_doc_unique_ref2 -- :invoice_id

Line 557: iby_docs_payable_all iby,

553: SELECT abs(sum(nvl(aid.amount,0)))
554: INTO abate
555: FROM ap_invoice_distributions_all aid,
556: ap_selected_invoices_all asi,
557: iby_docs_payable_all iby,
558: iby_pay_service_requests proc,
559: iby_payments_all paym
560: WHERE aid.invoice_id = asi.invoice_id
561: AND asi.checkrun_name = proc.call_app_pay_service_req_code -- :p_payment_batch

Line 591: (P_Doc_Payable_ID IN IBY_Docs_Payable_All.document_payable_id%TYPE,

587: Type : Number
588: Objective: Verify if invoice country is brazil
589: *************************************************************** */
590: Function Check_Brazil
591: (P_Doc_Payable_ID IN IBY_Docs_Payable_All.document_payable_id%TYPE,
592: P_RETURN_STATUS OUT NOCOPY Varchar2)
593: RETURN Number
594: IS
595: Cursor ap_inv IS

Line 598: iby_docs_payable_all iby

594: IS
595: Cursor ap_inv IS
596: SELECT 1 br_c
597: FROM ap_invoices_all ap,
598: iby_docs_payable_all iby
599: WHERE ap.invoice_id = iby.calling_app_doc_unique_ref2
600: AND ap.global_attribute_category = 'JL.BR.APXINWKB.AP_INVOICES'
601: AND iby.document_payable_id = P_Doc_Payable_ID;
602: BEGIN