DBA Data[Home] [Help]

APPS.AP_AUTOMATIC_PROPAGATION_PKG dependencies on IBY_EXT_BANK_ACCOUNTS

Line 5: P_external_bank_account_id iby_ext_bank_accounts.ext_bank_account_id%TYPE,

1: PACKAGE BODY AP_AUTOMATIC_PROPAGATION_PKG AS
2: /* $Header: apautprb.pls 120.6 2011/02/23 12:12:34 ankuprad noship $ */
3:
4: FUNCTION Get_Affected_Invoices_Count(
5: P_external_bank_account_id iby_ext_bank_accounts.ext_bank_account_id%TYPE,
6: P_vendor_id ap_suppliers.vendor_id%TYPE,
7: P_vendor_site_id ap_supplier_sites.vendor_site_id%TYPE DEFAULT NULL,
8: P_party_Site_Id ap_supplier_sites.party_site_id%TYPE DEFAULT NULL,
9: P_org_id ap_invoices.org_id%TYPE DEFAULT NULL

Line 93: P_external_bank_account_id iby_ext_bank_accounts.ext_bank_account_id%TYPE,

89: END Get_Affected_Invoices_Count;
90:
91: /* Bug 10634847 Added API to return selected invoices for payments count */
92: FUNCTION Get_Selected_Invoices_Count(
93: P_external_bank_account_id iby_ext_bank_accounts.ext_bank_account_id%TYPE,
94: P_vendor_id ap_suppliers.vendor_id%TYPE,
95: P_vendor_site_id ap_supplier_sites.vendor_site_id%TYPE DEFAULT NULL,
96: P_party_Site_Id ap_supplier_sites.party_site_id%TYPE DEFAULT NULL,
97: P_org_id ap_invoices.org_id%TYPE DEFAULT NULL

Line 210: p_from_bank_account_id iby_ext_bank_accounts.ext_bank_account_id%TYPE,

206: RETURN l_affected_invoices;
207: END Get_Selected_Invoices_Count;
208:
209: PROCEDURE Update_Payment_Schedules (
210: p_from_bank_account_id iby_ext_bank_accounts.ext_bank_account_id%TYPE,
211: p_to_bank_account_id iby_ext_bank_accounts.ext_bank_account_id%TYPE,
212: p_vendor_id ap_suppliers.vendor_id%TYPE,
213: P_vendor_site_id ap_supplier_sites.vendor_site_id%TYPE DEFAULT NULL,
214: P_party_Site_Id ap_supplier_sites.party_site_id%TYPE DEFAULT NULL,

Line 211: p_to_bank_account_id iby_ext_bank_accounts.ext_bank_account_id%TYPE,

207: END Get_Selected_Invoices_Count;
208:
209: PROCEDURE Update_Payment_Schedules (
210: p_from_bank_account_id iby_ext_bank_accounts.ext_bank_account_id%TYPE,
211: p_to_bank_account_id iby_ext_bank_accounts.ext_bank_account_id%TYPE,
212: p_vendor_id ap_suppliers.vendor_id%TYPE,
213: P_vendor_site_id ap_supplier_sites.vendor_site_id%TYPE DEFAULT NULL,
214: P_party_Site_Id ap_supplier_sites.party_site_id%TYPE DEFAULT NULL,
215: P_org_id ap_invoices.org_id%TYPE DEFAULT NULL,

Line 227: l_to_bank_account_id iby_ext_bank_accounts.ext_bank_account_id%TYPE;

223:
224: l_api_name VARCHAR2(100) := 'Update_Payment_Schedules';
225: l_debug_info varchar2(3000);
226:
227: l_to_bank_account_id iby_ext_bank_accounts.ext_bank_account_id%TYPE;
228: P_org_type IBY_EXTERNAL_PAYEES_ALL.org_type%TYPE := 'OPERATING_UNIT';
229: P_pmt_function IBY_EXTERNAL_PAYEES_ALL.payment_function%TYPE := 'PAYABLES_DISB';
230:
231: BEGIN