250: l_key_flex_id number;
251: l_defined_balance_id pay_org_payment_methods_f.defined_balance_id%TYPE;
252: l_currency_code pay_org_payment_methods_f.currency_code%TYPE;
253: l_PMETH_INFORMATION_CATEGORY pay_org_payment_methods_f.PMETH_INFORMATION_CATEGORY%TYPE;
254: l_pay_gl_account_id pay_payment_gl_accounts_f.pay_gl_account_id%TYPE;
255:
256: l_gl_cash_ac_id PAY_PAYMENT_GL_ACCOUNTS_F.GL_CASH_AC_ID%TYPE;
257: l_gl_cash_clearing_ac_id PAY_PAYMENT_GL_ACCOUNTS_F.GL_CASH_CLEARING_AC_ID%TYPE;
258: l_gl_control_ac_id PAY_PAYMENT_GL_ACCOUNTS_F.GL_CONTROL_AC_ID%TYPE;
252: l_currency_code pay_org_payment_methods_f.currency_code%TYPE;
253: l_PMETH_INFORMATION_CATEGORY pay_org_payment_methods_f.PMETH_INFORMATION_CATEGORY%TYPE;
254: l_pay_gl_account_id pay_payment_gl_accounts_f.pay_gl_account_id%TYPE;
255:
256: l_gl_cash_ac_id PAY_PAYMENT_GL_ACCOUNTS_F.GL_CASH_AC_ID%TYPE;
257: l_gl_cash_clearing_ac_id PAY_PAYMENT_GL_ACCOUNTS_F.GL_CASH_CLEARING_AC_ID%TYPE;
258: l_gl_control_ac_id PAY_PAYMENT_GL_ACCOUNTS_F.GL_CONTROL_AC_ID%TYPE;
259: l_gl_error_ac_id PAY_PAYMENT_GL_ACCOUNTS_F.GL_ERROR_AC_ID%TYPE;
260: l_set_of_books_id PAY_PAYMENT_GL_ACCOUNTS_F.SET_OF_BOOKS_ID%TYPE;
253: l_PMETH_INFORMATION_CATEGORY pay_org_payment_methods_f.PMETH_INFORMATION_CATEGORY%TYPE;
254: l_pay_gl_account_id pay_payment_gl_accounts_f.pay_gl_account_id%TYPE;
255:
256: l_gl_cash_ac_id PAY_PAYMENT_GL_ACCOUNTS_F.GL_CASH_AC_ID%TYPE;
257: l_gl_cash_clearing_ac_id PAY_PAYMENT_GL_ACCOUNTS_F.GL_CASH_CLEARING_AC_ID%TYPE;
258: l_gl_control_ac_id PAY_PAYMENT_GL_ACCOUNTS_F.GL_CONTROL_AC_ID%TYPE;
259: l_gl_error_ac_id PAY_PAYMENT_GL_ACCOUNTS_F.GL_ERROR_AC_ID%TYPE;
260: l_set_of_books_id PAY_PAYMENT_GL_ACCOUNTS_F.SET_OF_BOOKS_ID%TYPE;
261:
254: l_pay_gl_account_id pay_payment_gl_accounts_f.pay_gl_account_id%TYPE;
255:
256: l_gl_cash_ac_id PAY_PAYMENT_GL_ACCOUNTS_F.GL_CASH_AC_ID%TYPE;
257: l_gl_cash_clearing_ac_id PAY_PAYMENT_GL_ACCOUNTS_F.GL_CASH_CLEARING_AC_ID%TYPE;
258: l_gl_control_ac_id PAY_PAYMENT_GL_ACCOUNTS_F.GL_CONTROL_AC_ID%TYPE;
259: l_gl_error_ac_id PAY_PAYMENT_GL_ACCOUNTS_F.GL_ERROR_AC_ID%TYPE;
260: l_set_of_books_id PAY_PAYMENT_GL_ACCOUNTS_F.SET_OF_BOOKS_ID%TYPE;
261:
262: l_def_gl_cash_ac_id PAY_PAYMENT_GL_ACCOUNTS_F.GL_CASH_AC_ID%TYPE;
255:
256: l_gl_cash_ac_id PAY_PAYMENT_GL_ACCOUNTS_F.GL_CASH_AC_ID%TYPE;
257: l_gl_cash_clearing_ac_id PAY_PAYMENT_GL_ACCOUNTS_F.GL_CASH_CLEARING_AC_ID%TYPE;
258: l_gl_control_ac_id PAY_PAYMENT_GL_ACCOUNTS_F.GL_CONTROL_AC_ID%TYPE;
259: l_gl_error_ac_id PAY_PAYMENT_GL_ACCOUNTS_F.GL_ERROR_AC_ID%TYPE;
260: l_set_of_books_id PAY_PAYMENT_GL_ACCOUNTS_F.SET_OF_BOOKS_ID%TYPE;
261:
262: l_def_gl_cash_ac_id PAY_PAYMENT_GL_ACCOUNTS_F.GL_CASH_AC_ID%TYPE;
263: l_def_gl_cash_clearing_ac_id PAY_PAYMENT_GL_ACCOUNTS_F.GL_CASH_CLEARING_AC_ID%TYPE;
256: l_gl_cash_ac_id PAY_PAYMENT_GL_ACCOUNTS_F.GL_CASH_AC_ID%TYPE;
257: l_gl_cash_clearing_ac_id PAY_PAYMENT_GL_ACCOUNTS_F.GL_CASH_CLEARING_AC_ID%TYPE;
258: l_gl_control_ac_id PAY_PAYMENT_GL_ACCOUNTS_F.GL_CONTROL_AC_ID%TYPE;
259: l_gl_error_ac_id PAY_PAYMENT_GL_ACCOUNTS_F.GL_ERROR_AC_ID%TYPE;
260: l_set_of_books_id PAY_PAYMENT_GL_ACCOUNTS_F.SET_OF_BOOKS_ID%TYPE;
261:
262: l_def_gl_cash_ac_id PAY_PAYMENT_GL_ACCOUNTS_F.GL_CASH_AC_ID%TYPE;
263: l_def_gl_cash_clearing_ac_id PAY_PAYMENT_GL_ACCOUNTS_F.GL_CASH_CLEARING_AC_ID%TYPE;
264: l_def_gl_control_ac_id PAY_PAYMENT_GL_ACCOUNTS_F.GL_CONTROL_AC_ID%TYPE;
258: l_gl_control_ac_id PAY_PAYMENT_GL_ACCOUNTS_F.GL_CONTROL_AC_ID%TYPE;
259: l_gl_error_ac_id PAY_PAYMENT_GL_ACCOUNTS_F.GL_ERROR_AC_ID%TYPE;
260: l_set_of_books_id PAY_PAYMENT_GL_ACCOUNTS_F.SET_OF_BOOKS_ID%TYPE;
261:
262: l_def_gl_cash_ac_id PAY_PAYMENT_GL_ACCOUNTS_F.GL_CASH_AC_ID%TYPE;
263: l_def_gl_cash_clearing_ac_id PAY_PAYMENT_GL_ACCOUNTS_F.GL_CASH_CLEARING_AC_ID%TYPE;
264: l_def_gl_control_ac_id PAY_PAYMENT_GL_ACCOUNTS_F.GL_CONTROL_AC_ID%TYPE;
265: l_def_gl_error_ac_id PAY_PAYMENT_GL_ACCOUNTS_F.GL_ERROR_AC_ID%TYPE;
266: l_def_set_of_books_id PAY_PAYMENT_GL_ACCOUNTS_F.SET_OF_BOOKS_ID%TYPE;
259: l_gl_error_ac_id PAY_PAYMENT_GL_ACCOUNTS_F.GL_ERROR_AC_ID%TYPE;
260: l_set_of_books_id PAY_PAYMENT_GL_ACCOUNTS_F.SET_OF_BOOKS_ID%TYPE;
261:
262: l_def_gl_cash_ac_id PAY_PAYMENT_GL_ACCOUNTS_F.GL_CASH_AC_ID%TYPE;
263: l_def_gl_cash_clearing_ac_id PAY_PAYMENT_GL_ACCOUNTS_F.GL_CASH_CLEARING_AC_ID%TYPE;
264: l_def_gl_control_ac_id PAY_PAYMENT_GL_ACCOUNTS_F.GL_CONTROL_AC_ID%TYPE;
265: l_def_gl_error_ac_id PAY_PAYMENT_GL_ACCOUNTS_F.GL_ERROR_AC_ID%TYPE;
266: l_def_set_of_books_id PAY_PAYMENT_GL_ACCOUNTS_F.SET_OF_BOOKS_ID%TYPE;
267:
260: l_set_of_books_id PAY_PAYMENT_GL_ACCOUNTS_F.SET_OF_BOOKS_ID%TYPE;
261:
262: l_def_gl_cash_ac_id PAY_PAYMENT_GL_ACCOUNTS_F.GL_CASH_AC_ID%TYPE;
263: l_def_gl_cash_clearing_ac_id PAY_PAYMENT_GL_ACCOUNTS_F.GL_CASH_CLEARING_AC_ID%TYPE;
264: l_def_gl_control_ac_id PAY_PAYMENT_GL_ACCOUNTS_F.GL_CONTROL_AC_ID%TYPE;
265: l_def_gl_error_ac_id PAY_PAYMENT_GL_ACCOUNTS_F.GL_ERROR_AC_ID%TYPE;
266: l_def_set_of_books_id PAY_PAYMENT_GL_ACCOUNTS_F.SET_OF_BOOKS_ID%TYPE;
267:
268:
261:
262: l_def_gl_cash_ac_id PAY_PAYMENT_GL_ACCOUNTS_F.GL_CASH_AC_ID%TYPE;
263: l_def_gl_cash_clearing_ac_id PAY_PAYMENT_GL_ACCOUNTS_F.GL_CASH_CLEARING_AC_ID%TYPE;
264: l_def_gl_control_ac_id PAY_PAYMENT_GL_ACCOUNTS_F.GL_CONTROL_AC_ID%TYPE;
265: l_def_gl_error_ac_id PAY_PAYMENT_GL_ACCOUNTS_F.GL_ERROR_AC_ID%TYPE;
266: l_def_set_of_books_id PAY_PAYMENT_GL_ACCOUNTS_F.SET_OF_BOOKS_ID%TYPE;
267:
268:
269: l_gl_concat_segments varchar2(2000);
262: l_def_gl_cash_ac_id PAY_PAYMENT_GL_ACCOUNTS_F.GL_CASH_AC_ID%TYPE;
263: l_def_gl_cash_clearing_ac_id PAY_PAYMENT_GL_ACCOUNTS_F.GL_CASH_CLEARING_AC_ID%TYPE;
264: l_def_gl_control_ac_id PAY_PAYMENT_GL_ACCOUNTS_F.GL_CONTROL_AC_ID%TYPE;
265: l_def_gl_error_ac_id PAY_PAYMENT_GL_ACCOUNTS_F.GL_ERROR_AC_ID%TYPE;
266: l_def_set_of_books_id PAY_PAYMENT_GL_ACCOUNTS_F.SET_OF_BOOKS_ID%TYPE;
267:
268:
269: l_gl_concat_segments varchar2(2000);
270: l_gl_csh_clr_concat_segment varchar2(2000);
321: gl_cash_clearing_ac_id,
322: gl_control_ac_id,
323: gl_error_ac_id,
324: set_of_books_id
325: from pay_payment_gl_accounts_f
326: where external_account_id = v_external_account_id;
327: --
328: begin
329: --
1763: l_currency_code pay_org_payment_methods_f.currency_code%TYPE;
1764: l_PMETH_INFORMATION_CATEGORY pay_org_payment_methods_f.PMETH_INFORMATION_CATEGORY%TYPE;
1765: l_copy_ov_number number;
1766:
1767: l_gl_cash_ac_id PAY_PAYMENT_GL_ACCOUNTS_F.GL_CASH_AC_ID%TYPE;
1768: l_gl_cash_clearing_ac_id PAY_PAYMENT_GL_ACCOUNTS_F.GL_CASH_CLEARING_AC_ID%TYPE;
1769: l_gl_control_ac_id PAY_PAYMENT_GL_ACCOUNTS_F.GL_CONTROL_AC_ID%TYPE;
1770: l_gl_error_ac_id PAY_PAYMENT_GL_ACCOUNTS_F.GL_ERROR_AC_ID%TYPE;
1771: l_old_external_account_id PAY_PAYMENT_GL_ACCOUNTS_F.EXTERNAL_ACCOUNT_ID%TYPE;
1764: l_PMETH_INFORMATION_CATEGORY pay_org_payment_methods_f.PMETH_INFORMATION_CATEGORY%TYPE;
1765: l_copy_ov_number number;
1766:
1767: l_gl_cash_ac_id PAY_PAYMENT_GL_ACCOUNTS_F.GL_CASH_AC_ID%TYPE;
1768: l_gl_cash_clearing_ac_id PAY_PAYMENT_GL_ACCOUNTS_F.GL_CASH_CLEARING_AC_ID%TYPE;
1769: l_gl_control_ac_id PAY_PAYMENT_GL_ACCOUNTS_F.GL_CONTROL_AC_ID%TYPE;
1770: l_gl_error_ac_id PAY_PAYMENT_GL_ACCOUNTS_F.GL_ERROR_AC_ID%TYPE;
1771: l_old_external_account_id PAY_PAYMENT_GL_ACCOUNTS_F.EXTERNAL_ACCOUNT_ID%TYPE;
1772: l_old_set_of_books_id PAY_PAYMENT_GL_ACCOUNTS_F.SET_OF_BOOKS_ID%TYPE;
1765: l_copy_ov_number number;
1766:
1767: l_gl_cash_ac_id PAY_PAYMENT_GL_ACCOUNTS_F.GL_CASH_AC_ID%TYPE;
1768: l_gl_cash_clearing_ac_id PAY_PAYMENT_GL_ACCOUNTS_F.GL_CASH_CLEARING_AC_ID%TYPE;
1769: l_gl_control_ac_id PAY_PAYMENT_GL_ACCOUNTS_F.GL_CONTROL_AC_ID%TYPE;
1770: l_gl_error_ac_id PAY_PAYMENT_GL_ACCOUNTS_F.GL_ERROR_AC_ID%TYPE;
1771: l_old_external_account_id PAY_PAYMENT_GL_ACCOUNTS_F.EXTERNAL_ACCOUNT_ID%TYPE;
1772: l_old_set_of_books_id PAY_PAYMENT_GL_ACCOUNTS_F.SET_OF_BOOKS_ID%TYPE;
1773:
1766:
1767: l_gl_cash_ac_id PAY_PAYMENT_GL_ACCOUNTS_F.GL_CASH_AC_ID%TYPE;
1768: l_gl_cash_clearing_ac_id PAY_PAYMENT_GL_ACCOUNTS_F.GL_CASH_CLEARING_AC_ID%TYPE;
1769: l_gl_control_ac_id PAY_PAYMENT_GL_ACCOUNTS_F.GL_CONTROL_AC_ID%TYPE;
1770: l_gl_error_ac_id PAY_PAYMENT_GL_ACCOUNTS_F.GL_ERROR_AC_ID%TYPE;
1771: l_old_external_account_id PAY_PAYMENT_GL_ACCOUNTS_F.EXTERNAL_ACCOUNT_ID%TYPE;
1772: l_old_set_of_books_id PAY_PAYMENT_GL_ACCOUNTS_F.SET_OF_BOOKS_ID%TYPE;
1773:
1774: l_old_gl_cash_ac_id PAY_PAYMENT_GL_ACCOUNTS_F.GL_CASH_AC_ID%TYPE;
1767: l_gl_cash_ac_id PAY_PAYMENT_GL_ACCOUNTS_F.GL_CASH_AC_ID%TYPE;
1768: l_gl_cash_clearing_ac_id PAY_PAYMENT_GL_ACCOUNTS_F.GL_CASH_CLEARING_AC_ID%TYPE;
1769: l_gl_control_ac_id PAY_PAYMENT_GL_ACCOUNTS_F.GL_CONTROL_AC_ID%TYPE;
1770: l_gl_error_ac_id PAY_PAYMENT_GL_ACCOUNTS_F.GL_ERROR_AC_ID%TYPE;
1771: l_old_external_account_id PAY_PAYMENT_GL_ACCOUNTS_F.EXTERNAL_ACCOUNT_ID%TYPE;
1772: l_old_set_of_books_id PAY_PAYMENT_GL_ACCOUNTS_F.SET_OF_BOOKS_ID%TYPE;
1773:
1774: l_old_gl_cash_ac_id PAY_PAYMENT_GL_ACCOUNTS_F.GL_CASH_AC_ID%TYPE;
1775: l_old_gl_cash_clearing_ac_id PAY_PAYMENT_GL_ACCOUNTS_F.GL_CASH_CLEARING_AC_ID%TYPE;
1768: l_gl_cash_clearing_ac_id PAY_PAYMENT_GL_ACCOUNTS_F.GL_CASH_CLEARING_AC_ID%TYPE;
1769: l_gl_control_ac_id PAY_PAYMENT_GL_ACCOUNTS_F.GL_CONTROL_AC_ID%TYPE;
1770: l_gl_error_ac_id PAY_PAYMENT_GL_ACCOUNTS_F.GL_ERROR_AC_ID%TYPE;
1771: l_old_external_account_id PAY_PAYMENT_GL_ACCOUNTS_F.EXTERNAL_ACCOUNT_ID%TYPE;
1772: l_old_set_of_books_id PAY_PAYMENT_GL_ACCOUNTS_F.SET_OF_BOOKS_ID%TYPE;
1773:
1774: l_old_gl_cash_ac_id PAY_PAYMENT_GL_ACCOUNTS_F.GL_CASH_AC_ID%TYPE;
1775: l_old_gl_cash_clearing_ac_id PAY_PAYMENT_GL_ACCOUNTS_F.GL_CASH_CLEARING_AC_ID%TYPE;
1776: l_old_gl_control_ac_id PAY_PAYMENT_GL_ACCOUNTS_F.GL_CONTROL_AC_ID%TYPE;
1770: l_gl_error_ac_id PAY_PAYMENT_GL_ACCOUNTS_F.GL_ERROR_AC_ID%TYPE;
1771: l_old_external_account_id PAY_PAYMENT_GL_ACCOUNTS_F.EXTERNAL_ACCOUNT_ID%TYPE;
1772: l_old_set_of_books_id PAY_PAYMENT_GL_ACCOUNTS_F.SET_OF_BOOKS_ID%TYPE;
1773:
1774: l_old_gl_cash_ac_id PAY_PAYMENT_GL_ACCOUNTS_F.GL_CASH_AC_ID%TYPE;
1775: l_old_gl_cash_clearing_ac_id PAY_PAYMENT_GL_ACCOUNTS_F.GL_CASH_CLEARING_AC_ID%TYPE;
1776: l_old_gl_control_ac_id PAY_PAYMENT_GL_ACCOUNTS_F.GL_CONTROL_AC_ID%TYPE;
1777: l_old_gl_error_ac_id PAY_PAYMENT_GL_ACCOUNTS_F.GL_ERROR_AC_ID%TYPE;
1778:
1771: l_old_external_account_id PAY_PAYMENT_GL_ACCOUNTS_F.EXTERNAL_ACCOUNT_ID%TYPE;
1772: l_old_set_of_books_id PAY_PAYMENT_GL_ACCOUNTS_F.SET_OF_BOOKS_ID%TYPE;
1773:
1774: l_old_gl_cash_ac_id PAY_PAYMENT_GL_ACCOUNTS_F.GL_CASH_AC_ID%TYPE;
1775: l_old_gl_cash_clearing_ac_id PAY_PAYMENT_GL_ACCOUNTS_F.GL_CASH_CLEARING_AC_ID%TYPE;
1776: l_old_gl_control_ac_id PAY_PAYMENT_GL_ACCOUNTS_F.GL_CONTROL_AC_ID%TYPE;
1777: l_old_gl_error_ac_id PAY_PAYMENT_GL_ACCOUNTS_F.GL_ERROR_AC_ID%TYPE;
1778:
1779: l_gl_concat_segments varchar2(2000);
1772: l_old_set_of_books_id PAY_PAYMENT_GL_ACCOUNTS_F.SET_OF_BOOKS_ID%TYPE;
1773:
1774: l_old_gl_cash_ac_id PAY_PAYMENT_GL_ACCOUNTS_F.GL_CASH_AC_ID%TYPE;
1775: l_old_gl_cash_clearing_ac_id PAY_PAYMENT_GL_ACCOUNTS_F.GL_CASH_CLEARING_AC_ID%TYPE;
1776: l_old_gl_control_ac_id PAY_PAYMENT_GL_ACCOUNTS_F.GL_CONTROL_AC_ID%TYPE;
1777: l_old_gl_error_ac_id PAY_PAYMENT_GL_ACCOUNTS_F.GL_ERROR_AC_ID%TYPE;
1778:
1779: l_gl_concat_segments varchar2(2000);
1780: l_gl_csh_clr_concat_segment varchar2(2000);
1773:
1774: l_old_gl_cash_ac_id PAY_PAYMENT_GL_ACCOUNTS_F.GL_CASH_AC_ID%TYPE;
1775: l_old_gl_cash_clearing_ac_id PAY_PAYMENT_GL_ACCOUNTS_F.GL_CASH_CLEARING_AC_ID%TYPE;
1776: l_old_gl_control_ac_id PAY_PAYMENT_GL_ACCOUNTS_F.GL_CONTROL_AC_ID%TYPE;
1777: l_old_gl_error_ac_id PAY_PAYMENT_GL_ACCOUNTS_F.GL_ERROR_AC_ID%TYPE;
1778:
1779: l_gl_concat_segments varchar2(2000);
1780: l_gl_csh_clr_concat_segment varchar2(2000);
1781: l_gl_control_concat_segment varchar2(2000);
1780: l_gl_csh_clr_concat_segment varchar2(2000);
1781: l_gl_control_concat_segment varchar2(2000);
1782: l_gl_error_concat_segment varchar2(2000);
1783:
1784: l_gl_account_id PAY_PAYMENT_GL_ACCOUNTS_F.PAY_GL_ACCOUNT_ID%TYPE;
1785: l_extr_changed boolean;
1786: l_ccrl_changed boolean;
1787: l_ctrl_changed boolean;
1788: l_err_changed boolean;
1790: l_dummy_name varchar(100);
1791:
1792: l_cstclr_flag varchar2(2);
1793: l_cst_flag varchar2(2);
1794: l_pay_gl_account_id_out PAY_PAYMENT_GL_ACCOUNTS_F.PAY_GL_ACCOUNT_ID%TYPE;
1795: --
1796: cursor csr_territory_code (v_org_payment_method_id number) is
1797: select nvl(pty.territory_code,pbg.legislation_code)
1798: from pay_payment_types pty