eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.PAY_ORG_PAYMENT_METHOD_API dependencies on PAY_ORG_PAYMENT_METHODS_F

Line 239: l_object_version_number pay_org_payment_methods_f.object_version_number%TYPE;

235: --
236: -- Declare cursors and local variables
237: --
238: l_proc varchar2(72) := g_package||'create_org_payment_method';
239: l_object_version_number pay_org_payment_methods_f.object_version_number%TYPE;
240: l_effective_date date;
241: l_org_payment_method_id pay_org_payment_methods_f.org_payment_method_id%TYPE;
242: l_effective_start_date pay_org_payment_methods_f.effective_start_date%TYPE;
243: l_effective_end_date pay_org_payment_methods_f.effective_end_date%TYPE;

Line 241: l_org_payment_method_id pay_org_payment_methods_f.org_payment_method_id%TYPE;

237: --
238: l_proc varchar2(72) := g_package||'create_org_payment_method';
239: l_object_version_number pay_org_payment_methods_f.object_version_number%TYPE;
240: l_effective_date date;
241: l_org_payment_method_id pay_org_payment_methods_f.org_payment_method_id%TYPE;
242: l_effective_start_date pay_org_payment_methods_f.effective_start_date%TYPE;
243: l_effective_end_date pay_org_payment_methods_f.effective_end_date%TYPE;
244: l_comment_id pay_org_payment_methods_f.comment_id%TYPE;
245: l_external_account_id pay_org_payment_methods_f.external_account_id%TYPE;

Line 242: l_effective_start_date pay_org_payment_methods_f.effective_start_date%TYPE;

238: l_proc varchar2(72) := g_package||'create_org_payment_method';
239: l_object_version_number pay_org_payment_methods_f.object_version_number%TYPE;
240: l_effective_date date;
241: l_org_payment_method_id pay_org_payment_methods_f.org_payment_method_id%TYPE;
242: l_effective_start_date pay_org_payment_methods_f.effective_start_date%TYPE;
243: l_effective_end_date pay_org_payment_methods_f.effective_end_date%TYPE;
244: l_comment_id pay_org_payment_methods_f.comment_id%TYPE;
245: l_external_account_id pay_org_payment_methods_f.external_account_id%TYPE;
246: l_asset_code_combination_id number;

Line 243: l_effective_end_date pay_org_payment_methods_f.effective_end_date%TYPE;

239: l_object_version_number pay_org_payment_methods_f.object_version_number%TYPE;
240: l_effective_date date;
241: l_org_payment_method_id pay_org_payment_methods_f.org_payment_method_id%TYPE;
242: l_effective_start_date pay_org_payment_methods_f.effective_start_date%TYPE;
243: l_effective_end_date pay_org_payment_methods_f.effective_end_date%TYPE;
244: l_comment_id pay_org_payment_methods_f.comment_id%TYPE;
245: l_external_account_id pay_org_payment_methods_f.external_account_id%TYPE;
246: l_asset_code_combination_id number;
247: l_language_code pay_org_payment_methods_f_tl.language%TYPE;

Line 244: l_comment_id pay_org_payment_methods_f.comment_id%TYPE;

240: l_effective_date date;
241: l_org_payment_method_id pay_org_payment_methods_f.org_payment_method_id%TYPE;
242: l_effective_start_date pay_org_payment_methods_f.effective_start_date%TYPE;
243: l_effective_end_date pay_org_payment_methods_f.effective_end_date%TYPE;
244: l_comment_id pay_org_payment_methods_f.comment_id%TYPE;
245: l_external_account_id pay_org_payment_methods_f.external_account_id%TYPE;
246: l_asset_code_combination_id number;
247: l_language_code pay_org_payment_methods_f_tl.language%TYPE;
248: l_discard number;

Line 245: l_external_account_id pay_org_payment_methods_f.external_account_id%TYPE;

241: l_org_payment_method_id pay_org_payment_methods_f.org_payment_method_id%TYPE;
242: l_effective_start_date pay_org_payment_methods_f.effective_start_date%TYPE;
243: l_effective_end_date pay_org_payment_methods_f.effective_end_date%TYPE;
244: l_comment_id pay_org_payment_methods_f.comment_id%TYPE;
245: l_external_account_id pay_org_payment_methods_f.external_account_id%TYPE;
246: l_asset_code_combination_id number;
247: l_language_code pay_org_payment_methods_f_tl.language%TYPE;
248: l_discard number;
249: l_territory_code pay_payment_types.territory_code%TYPE;

Line 247: l_language_code pay_org_payment_methods_f_tl.language%TYPE;

243: l_effective_end_date pay_org_payment_methods_f.effective_end_date%TYPE;
244: l_comment_id pay_org_payment_methods_f.comment_id%TYPE;
245: l_external_account_id pay_org_payment_methods_f.external_account_id%TYPE;
246: l_asset_code_combination_id number;
247: l_language_code pay_org_payment_methods_f_tl.language%TYPE;
248: l_discard number;
249: l_territory_code pay_payment_types.territory_code%TYPE;
250: l_key_flex_id number;
251: l_defined_balance_id pay_org_payment_methods_f.defined_balance_id%TYPE;

Line 251: l_defined_balance_id pay_org_payment_methods_f.defined_balance_id%TYPE;

247: l_language_code pay_org_payment_methods_f_tl.language%TYPE;
248: l_discard number;
249: l_territory_code pay_payment_types.territory_code%TYPE;
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:

Line 252: l_currency_code pay_org_payment_methods_f.currency_code%TYPE;

248: l_discard number;
249: l_territory_code pay_payment_types.territory_code%TYPE;
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;

Line 253: l_PMETH_INFORMATION_CATEGORY pay_org_payment_methods_f.PMETH_INFORMATION_CATEGORY%TYPE;

249: l_territory_code pay_payment_types.territory_code%TYPE;
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;

Line 1749: l_object_version_number pay_org_payment_methods_f.object_version_number%TYPE;

1745: --
1746: -- Declare cursors and local variables
1747: --
1748: l_proc varchar2(72) := g_package||'update_org_payment_method';
1749: l_object_version_number pay_org_payment_methods_f.object_version_number%TYPE;
1750: l_effective_date date;
1751: l_effective_start_date pay_org_payment_methods_f.effective_start_date%TYPE;
1752: l_effective_end_date pay_org_payment_methods_f.effective_end_date%TYPE;
1753: l_comment_id pay_org_payment_methods_f.comment_id%TYPE;

Line 1751: l_effective_start_date pay_org_payment_methods_f.effective_start_date%TYPE;

1747: --
1748: l_proc varchar2(72) := g_package||'update_org_payment_method';
1749: l_object_version_number pay_org_payment_methods_f.object_version_number%TYPE;
1750: l_effective_date date;
1751: l_effective_start_date pay_org_payment_methods_f.effective_start_date%TYPE;
1752: l_effective_end_date pay_org_payment_methods_f.effective_end_date%TYPE;
1753: l_comment_id pay_org_payment_methods_f.comment_id%TYPE;
1754: l_external_account_id pay_org_payment_methods_f.external_account_id%TYPE;
1755: l_asset_code_combination_id number;

Line 1752: l_effective_end_date pay_org_payment_methods_f.effective_end_date%TYPE;

1748: l_proc varchar2(72) := g_package||'update_org_payment_method';
1749: l_object_version_number pay_org_payment_methods_f.object_version_number%TYPE;
1750: l_effective_date date;
1751: l_effective_start_date pay_org_payment_methods_f.effective_start_date%TYPE;
1752: l_effective_end_date pay_org_payment_methods_f.effective_end_date%TYPE;
1753: l_comment_id pay_org_payment_methods_f.comment_id%TYPE;
1754: l_external_account_id pay_org_payment_methods_f.external_account_id%TYPE;
1755: l_asset_code_combination_id number;
1756: l_language_code pay_org_payment_methods_f_tl.language%TYPE;

Line 1753: l_comment_id pay_org_payment_methods_f.comment_id%TYPE;

1749: l_object_version_number pay_org_payment_methods_f.object_version_number%TYPE;
1750: l_effective_date date;
1751: l_effective_start_date pay_org_payment_methods_f.effective_start_date%TYPE;
1752: l_effective_end_date pay_org_payment_methods_f.effective_end_date%TYPE;
1753: l_comment_id pay_org_payment_methods_f.comment_id%TYPE;
1754: l_external_account_id pay_org_payment_methods_f.external_account_id%TYPE;
1755: l_asset_code_combination_id number;
1756: l_language_code pay_org_payment_methods_f_tl.language%TYPE;
1757: l_discard number;

Line 1754: l_external_account_id pay_org_payment_methods_f.external_account_id%TYPE;

1750: l_effective_date date;
1751: l_effective_start_date pay_org_payment_methods_f.effective_start_date%TYPE;
1752: l_effective_end_date pay_org_payment_methods_f.effective_end_date%TYPE;
1753: l_comment_id pay_org_payment_methods_f.comment_id%TYPE;
1754: l_external_account_id pay_org_payment_methods_f.external_account_id%TYPE;
1755: l_asset_code_combination_id number;
1756: l_language_code pay_org_payment_methods_f_tl.language%TYPE;
1757: l_discard number;
1758: l_territory_code pay_payment_types.territory_code%TYPE;

Line 1756: l_language_code pay_org_payment_methods_f_tl.language%TYPE;

1752: l_effective_end_date pay_org_payment_methods_f.effective_end_date%TYPE;
1753: l_comment_id pay_org_payment_methods_f.comment_id%TYPE;
1754: l_external_account_id pay_org_payment_methods_f.external_account_id%TYPE;
1755: l_asset_code_combination_id number;
1756: l_language_code pay_org_payment_methods_f_tl.language%TYPE;
1757: l_discard number;
1758: l_territory_code pay_payment_types.territory_code%TYPE;
1759: l_business_group_id pay_org_payment_methods_f.business_group_id%TYPE;
1760: l_key_flex_id number;

Line 1759: l_business_group_id pay_org_payment_methods_f.business_group_id%TYPE;

1755: l_asset_code_combination_id number;
1756: l_language_code pay_org_payment_methods_f_tl.language%TYPE;
1757: l_discard number;
1758: l_territory_code pay_payment_types.territory_code%TYPE;
1759: l_business_group_id pay_org_payment_methods_f.business_group_id%TYPE;
1760: l_key_flex_id number;
1761: l_set_of_books_id number;
1762: l_asset_code_changed boolean;
1763: l_currency_code pay_org_payment_methods_f.currency_code%TYPE;

Line 1763: l_currency_code pay_org_payment_methods_f.currency_code%TYPE;

1759: l_business_group_id pay_org_payment_methods_f.business_group_id%TYPE;
1760: l_key_flex_id number;
1761: l_set_of_books_id number;
1762: l_asset_code_changed boolean;
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;

Line 1764: l_PMETH_INFORMATION_CATEGORY pay_org_payment_methods_f.PMETH_INFORMATION_CATEGORY%TYPE;

1760: l_key_flex_id number;
1761: l_set_of_books_id number;
1762: l_asset_code_changed boolean;
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;

Line 1799: , pay_org_payment_methods_f opm

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
1799: , pay_org_payment_methods_f opm
1800: , per_business_groups pbg
1801: where opm.org_payment_method_id = v_org_payment_method_id
1802: and pty.payment_type_id = opm.payment_type_id
1803: and pbg.business_group_id = opm.business_group_id;

Line 1807: from pay_org_payment_methods_f opm,

1803: and pbg.business_group_id = opm.business_group_id;
1804: --
1805: cursor csr_currency_code (v_org_payment_method_id number) is
1806: select ppt.currency_code
1807: from pay_org_payment_methods_f opm,
1808: pay_payment_types ppt
1809: where opm.org_payment_method_id = v_org_payment_method_id
1810: and ppt.payment_type_id = opm.payment_type_id;
1811: --

Line 1814: from pay_org_payment_methods_f opm

1810: and ppt.payment_type_id = opm.payment_type_id;
1811: --
1812: cursor csr_business_group_id (v_org_payment_method_id number) is
1813: select opm.business_group_id
1814: from pay_org_payment_methods_f opm
1815: where opm.org_payment_method_id = v_org_payment_method_id;
1816: --
1817: cursor csr_chart_of_accounts_id (v_sets_of_book_id number) is
1818: select CHART_OF_ACCOUNTS_ID

Line 1825: from pay_org_payment_methods_f opm

1821: --
1822: --
1823: cursor csr_external_account_id (v_org_payment_method_id number, v_effective_date date) is
1824: select opm.external_account_id
1825: from pay_org_payment_methods_f opm
1826: where opm.org_payment_method_id = v_org_payment_method_id
1827: and v_effective_date between effective_start_date and effective_end_date;
1828: --
1829: cursor csr_pmeth_category (v_org_payment_method_id number) is

Line 1832: pay_org_payment_methods_f opm

1828: --
1829: cursor csr_pmeth_category (v_org_payment_method_id number) is
1830: select ppt.payment_type_name
1831: from pay_payment_types ppt,
1832: pay_org_payment_methods_f opm
1833: where opm.org_payment_method_id = v_org_payment_method_id
1834: and ppt.payment_type_id = opm.payment_type_id;
1835: --
1836: cursor csr_get_cst_cstclr_flags(v_org_payment_method_id number, v_effective_date date) is

Line 1838: from pay_org_payment_methods_f

1834: and ppt.payment_type_id = opm.payment_type_id;
1835: --
1836: cursor csr_get_cst_cstclr_flags(v_org_payment_method_id number, v_effective_date date) is
1837: select cost_payment, cost_cleared_payment
1838: from pay_org_payment_methods_f
1839: where org_payment_method_id = v_org_payment_method_id
1840: and v_effective_date between effective_start_date and effective_end_date;
1841: --
1842: begin

Line 3129: l_effective_start_date pay_org_payment_methods_f.effective_start_date%TYPE;

3125: --
3126: -- Declare cursors and local variables
3127: --
3128: l_proc varchar2(72) := g_package||'delete_org_payment_method';
3129: l_effective_start_date pay_org_payment_methods_f.effective_start_date%TYPE;
3130: l_effective_end_date pay_org_payment_methods_f.effective_end_date%TYPE;
3131: l_object_version_number pay_org_payment_methods_f.object_version_number%TYPE;
3132: l_effective_date date;
3133: l_copy_ov_number number;

Line 3130: l_effective_end_date pay_org_payment_methods_f.effective_end_date%TYPE;

3126: -- Declare cursors and local variables
3127: --
3128: l_proc varchar2(72) := g_package||'delete_org_payment_method';
3129: l_effective_start_date pay_org_payment_methods_f.effective_start_date%TYPE;
3130: l_effective_end_date pay_org_payment_methods_f.effective_end_date%TYPE;
3131: l_object_version_number pay_org_payment_methods_f.object_version_number%TYPE;
3132: l_effective_date date;
3133: l_copy_ov_number number;
3134: --

Line 3131: l_object_version_number pay_org_payment_methods_f.object_version_number%TYPE;

3127: --
3128: l_proc varchar2(72) := g_package||'delete_org_payment_method';
3129: l_effective_start_date pay_org_payment_methods_f.effective_start_date%TYPE;
3130: l_effective_end_date pay_org_payment_methods_f.effective_end_date%TYPE;
3131: l_object_version_number pay_org_payment_methods_f.object_version_number%TYPE;
3132: l_effective_date date;
3133: l_copy_ov_number number;
3134: --
3135: --