13569: |
13570: *---------------------------------------------------------------------*/
13571: PROCEDURE get_default_bank_acct(
13572: currency_code iby_ext_bank_accounts.currency_code%TYPE,
13573: Payee_Party_Id IBY_EXTERNAL_PAYEES_ALL.payee_party_id%TYPE,
13574: Payee_Party_Site_Id IBY_EXTERNAL_PAYEES_ALL.party_site_id%TYPE,
13575: Supplier_Site_Id IBY_EXTERNAL_PAYEES_ALL.supplier_site_id%TYPE,
13576: Payer_Org_Id IBY_EXTERNAL_PAYEES_ALL.org_id%TYPE,
13577: Payer_Org_Type IBY_EXTERNAL_PAYEES_ALL.org_type%TYPE,
13570: *---------------------------------------------------------------------*/
13571: PROCEDURE get_default_bank_acct(
13572: currency_code iby_ext_bank_accounts.currency_code%TYPE,
13573: Payee_Party_Id IBY_EXTERNAL_PAYEES_ALL.payee_party_id%TYPE,
13574: Payee_Party_Site_Id IBY_EXTERNAL_PAYEES_ALL.party_site_id%TYPE,
13575: Supplier_Site_Id IBY_EXTERNAL_PAYEES_ALL.supplier_site_id%TYPE,
13576: Payer_Org_Id IBY_EXTERNAL_PAYEES_ALL.org_id%TYPE,
13577: Payer_Org_Type IBY_EXTERNAL_PAYEES_ALL.org_type%TYPE,
13578: Payment_Function IBY_EXTERNAL_PAYEES_ALL.payment_function%TYPE,
13571: PROCEDURE get_default_bank_acct(
13572: currency_code iby_ext_bank_accounts.currency_code%TYPE,
13573: Payee_Party_Id IBY_EXTERNAL_PAYEES_ALL.payee_party_id%TYPE,
13574: Payee_Party_Site_Id IBY_EXTERNAL_PAYEES_ALL.party_site_id%TYPE,
13575: Supplier_Site_Id IBY_EXTERNAL_PAYEES_ALL.supplier_site_id%TYPE,
13576: Payer_Org_Id IBY_EXTERNAL_PAYEES_ALL.org_id%TYPE,
13577: Payer_Org_Type IBY_EXTERNAL_PAYEES_ALL.org_type%TYPE,
13578: Payment_Function IBY_EXTERNAL_PAYEES_ALL.payment_function%TYPE,
13579: old_ext_bank_acct_id IBY_EXT_BANK_ACCOUNTS.ext_bank_account_id%TYPE,
13572: currency_code iby_ext_bank_accounts.currency_code%TYPE,
13573: Payee_Party_Id IBY_EXTERNAL_PAYEES_ALL.payee_party_id%TYPE,
13574: Payee_Party_Site_Id IBY_EXTERNAL_PAYEES_ALL.party_site_id%TYPE,
13575: Supplier_Site_Id IBY_EXTERNAL_PAYEES_ALL.supplier_site_id%TYPE,
13576: Payer_Org_Id IBY_EXTERNAL_PAYEES_ALL.org_id%TYPE,
13577: Payer_Org_Type IBY_EXTERNAL_PAYEES_ALL.org_type%TYPE,
13578: Payment_Function IBY_EXTERNAL_PAYEES_ALL.payment_function%TYPE,
13579: old_ext_bank_acct_id IBY_EXT_BANK_ACCOUNTS.ext_bank_account_id%TYPE,
13580: x_default_bank_acct_id OUT NOCOPY iby_ext_bank_accounts.ext_bank_account_id%TYPE)
13573: Payee_Party_Id IBY_EXTERNAL_PAYEES_ALL.payee_party_id%TYPE,
13574: Payee_Party_Site_Id IBY_EXTERNAL_PAYEES_ALL.party_site_id%TYPE,
13575: Supplier_Site_Id IBY_EXTERNAL_PAYEES_ALL.supplier_site_id%TYPE,
13576: Payer_Org_Id IBY_EXTERNAL_PAYEES_ALL.org_id%TYPE,
13577: Payer_Org_Type IBY_EXTERNAL_PAYEES_ALL.org_type%TYPE,
13578: Payment_Function IBY_EXTERNAL_PAYEES_ALL.payment_function%TYPE,
13579: old_ext_bank_acct_id IBY_EXT_BANK_ACCOUNTS.ext_bank_account_id%TYPE,
13580: x_default_bank_acct_id OUT NOCOPY iby_ext_bank_accounts.ext_bank_account_id%TYPE)
13581: IS
13574: Payee_Party_Site_Id IBY_EXTERNAL_PAYEES_ALL.party_site_id%TYPE,
13575: Supplier_Site_Id IBY_EXTERNAL_PAYEES_ALL.supplier_site_id%TYPE,
13576: Payer_Org_Id IBY_EXTERNAL_PAYEES_ALL.org_id%TYPE,
13577: Payer_Org_Type IBY_EXTERNAL_PAYEES_ALL.org_type%TYPE,
13578: Payment_Function IBY_EXTERNAL_PAYEES_ALL.payment_function%TYPE,
13579: old_ext_bank_acct_id IBY_EXT_BANK_ACCOUNTS.ext_bank_account_id%TYPE,
13580: x_default_bank_acct_id OUT NOCOPY iby_ext_bank_accounts.ext_bank_account_id%TYPE)
13581: IS
13582: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME