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.

APPS.PAY_OPM_BUS dependencies on PAY_ORG_PAYMENT_METHODS_F

Line 29: , pay_org_payment_methods_f opm

25: --
26: cursor csr_sec_grp is
27: select pbg.security_group_id
28: from per_business_groups pbg
29: , pay_org_payment_methods_f opm
30: where opm.org_payment_method_id = p_org_payment_method_id
31: and pbg.business_group_id = opm.business_group_id;
32: --
33: -- Declare local variables

Line 89: , pay_org_payment_methods_f opm

85: --
86: cursor csr_leg_code is
87: select pbg.legislation_code
88: from per_business_groups pbg
89: , pay_org_payment_methods_f opm
90: where opm.org_payment_method_id = p_org_payment_method_id
91: and pbg.business_group_id = opm.business_group_id;
92: --
93: -- Declare local variables

Line 787: (p_external_account_id in pay_org_payment_methods_f.external_account_id%TYPE

783: -- Access Status:
784: -- Internal Row Handler Use Only.
785: --
786: Procedure chk_external_account_id
787: (p_external_account_id in pay_org_payment_methods_f.external_account_id%TYPE
788: ,p_payment_type_id in pay_org_payment_methods_f.payment_type_id%TYPE
789: ,p_business_group_id in pay_org_payment_methods_f.business_group_id%TYPE
790: ,p_effective_date in date
791: ,p_org_payment_method_id in pay_org_payment_methods_f.org_payment_method_id%TYPE

Line 788: ,p_payment_type_id in pay_org_payment_methods_f.payment_type_id%TYPE

784: -- Internal Row Handler Use Only.
785: --
786: Procedure chk_external_account_id
787: (p_external_account_id in pay_org_payment_methods_f.external_account_id%TYPE
788: ,p_payment_type_id in pay_org_payment_methods_f.payment_type_id%TYPE
789: ,p_business_group_id in pay_org_payment_methods_f.business_group_id%TYPE
790: ,p_effective_date in date
791: ,p_org_payment_method_id in pay_org_payment_methods_f.org_payment_method_id%TYPE
792: ,p_object_version_number in pay_org_payment_methods_f.object_version_number%TYPE

Line 789: ,p_business_group_id in pay_org_payment_methods_f.business_group_id%TYPE

785: --
786: Procedure chk_external_account_id
787: (p_external_account_id in pay_org_payment_methods_f.external_account_id%TYPE
788: ,p_payment_type_id in pay_org_payment_methods_f.payment_type_id%TYPE
789: ,p_business_group_id in pay_org_payment_methods_f.business_group_id%TYPE
790: ,p_effective_date in date
791: ,p_org_payment_method_id in pay_org_payment_methods_f.org_payment_method_id%TYPE
792: ,p_object_version_number in pay_org_payment_methods_f.object_version_number%TYPE
793: ) is

Line 791: ,p_org_payment_method_id in pay_org_payment_methods_f.org_payment_method_id%TYPE

787: (p_external_account_id in pay_org_payment_methods_f.external_account_id%TYPE
788: ,p_payment_type_id in pay_org_payment_methods_f.payment_type_id%TYPE
789: ,p_business_group_id in pay_org_payment_methods_f.business_group_id%TYPE
790: ,p_effective_date in date
791: ,p_org_payment_method_id in pay_org_payment_methods_f.org_payment_method_id%TYPE
792: ,p_object_version_number in pay_org_payment_methods_f.object_version_number%TYPE
793: ) is
794: --
795: l_proc varchar2(72) := g_package||'chk_external_account_id';

Line 792: ,p_object_version_number in pay_org_payment_methods_f.object_version_number%TYPE

788: ,p_payment_type_id in pay_org_payment_methods_f.payment_type_id%TYPE
789: ,p_business_group_id in pay_org_payment_methods_f.business_group_id%TYPE
790: ,p_effective_date in date
791: ,p_org_payment_method_id in pay_org_payment_methods_f.org_payment_method_id%TYPE
792: ,p_object_version_number in pay_org_payment_methods_f.object_version_number%TYPE
793: ) is
794: --
795: l_proc varchar2(72) := g_package||'chk_external_account_id';
796: l_api_updating boolean;

Line 818: from pay_org_payment_methods_f pop,

814: and pbg.legislation_code = exa.territory_code))));
815: --
816: cursor csr_ext_chk is
817: select count (*)
818: from pay_org_payment_methods_f pop,
819: pay_payment_types pyt
820: where pop.payment_type_id = pyt.payment_type_id
821: and pyt.category =
822: ( select pyt.category

Line 893: pay_opm_shd.constraint_error('PAY_ORG_PAYMENT_METHODS_F_FK2');

889: open csr_ext_acc_id_exists;
890: fetch csr_ext_acc_id_exists into l_dummy;
891: if csr_ext_acc_id_exists%notfound then
892: close csr_ext_acc_id_exists;
893: pay_opm_shd.constraint_error('PAY_ORG_PAYMENT_METHODS_F_FK2');
894: end if;
895: close csr_ext_acc_id_exists;
896: --
897: hr_utility.set_location(l_proc,30);

Line 935: (p_currency_code in pay_org_payment_methods_f.currency_code%TYPE

931: -- Access Status:
932: -- Internal Row Handler Use Only.
933: --
934: Procedure chk_currency_code
935: (p_currency_code in pay_org_payment_methods_f.currency_code%TYPE
936: ,p_payment_type_id in pay_org_payment_methods_f.payment_type_id%TYPE
937: ,p_effective_date in date
938: ,p_org_payment_method_id in pay_org_payment_methods_f.org_payment_method_id%TYPE
939: ,p_object_version_number in pay_org_payment_methods_f.object_version_number%TYPE

Line 936: ,p_payment_type_id in pay_org_payment_methods_f.payment_type_id%TYPE

932: -- Internal Row Handler Use Only.
933: --
934: Procedure chk_currency_code
935: (p_currency_code in pay_org_payment_methods_f.currency_code%TYPE
936: ,p_payment_type_id in pay_org_payment_methods_f.payment_type_id%TYPE
937: ,p_effective_date in date
938: ,p_org_payment_method_id in pay_org_payment_methods_f.org_payment_method_id%TYPE
939: ,p_object_version_number in pay_org_payment_methods_f.object_version_number%TYPE
940: ) is

Line 938: ,p_org_payment_method_id in pay_org_payment_methods_f.org_payment_method_id%TYPE

934: Procedure chk_currency_code
935: (p_currency_code in pay_org_payment_methods_f.currency_code%TYPE
936: ,p_payment_type_id in pay_org_payment_methods_f.payment_type_id%TYPE
937: ,p_effective_date in date
938: ,p_org_payment_method_id in pay_org_payment_methods_f.org_payment_method_id%TYPE
939: ,p_object_version_number in pay_org_payment_methods_f.object_version_number%TYPE
940: ) is
941: --
942: l_proc varchar2(72) := g_package||'chk_currency_code';

Line 939: ,p_object_version_number in pay_org_payment_methods_f.object_version_number%TYPE

935: (p_currency_code in pay_org_payment_methods_f.currency_code%TYPE
936: ,p_payment_type_id in pay_org_payment_methods_f.payment_type_id%TYPE
937: ,p_effective_date in date
938: ,p_org_payment_method_id in pay_org_payment_methods_f.org_payment_method_id%TYPE
939: ,p_object_version_number in pay_org_payment_methods_f.object_version_number%TYPE
940: ) is
941: --
942: l_proc varchar2(72) := g_package||'chk_currency_code';
943: l_api_updating boolean;

Line 1053: (p_payment_type_id in pay_org_payment_methods_f.payment_type_id%TYPE

1049: -- Access Status:
1050: -- Internal Row Handler Use Only.
1051: --
1052: Procedure chk_payment_type_id
1053: (p_payment_type_id in pay_org_payment_methods_f.payment_type_id%TYPE
1054: ,p_business_group_id in pay_org_payment_methods_f.business_group_id%TYPE
1055: ,p_org_payment_method_id in pay_org_payment_methods_f.org_payment_method_id%TYPE
1056: ) is
1057: --

Line 1054: ,p_business_group_id in pay_org_payment_methods_f.business_group_id%TYPE

1050: -- Internal Row Handler Use Only.
1051: --
1052: Procedure chk_payment_type_id
1053: (p_payment_type_id in pay_org_payment_methods_f.payment_type_id%TYPE
1054: ,p_business_group_id in pay_org_payment_methods_f.business_group_id%TYPE
1055: ,p_org_payment_method_id in pay_org_payment_methods_f.org_payment_method_id%TYPE
1056: ) is
1057: --
1058: l_proc varchar2(72) := g_package||'chk_payment_type_id';

Line 1055: ,p_org_payment_method_id in pay_org_payment_methods_f.org_payment_method_id%TYPE

1051: --
1052: Procedure chk_payment_type_id
1053: (p_payment_type_id in pay_org_payment_methods_f.payment_type_id%TYPE
1054: ,p_business_group_id in pay_org_payment_methods_f.business_group_id%TYPE
1055: ,p_org_payment_method_id in pay_org_payment_methods_f.org_payment_method_id%TYPE
1056: ) is
1057: --
1058: l_proc varchar2(72) := g_package||'chk_payment_type_id';
1059: l_dummy number;

Line 1156: (p_defined_balance_id in pay_org_payment_methods_f.defined_balance_id%TYPE

1152: -- Access Status:
1153: -- Internal Row Handler Use Only.
1154: --
1155: Procedure chk_defined_balance_id
1156: (p_defined_balance_id in pay_org_payment_methods_f.defined_balance_id%TYPE
1157: ,p_business_group_id in pay_org_payment_methods_f.business_group_id%TYPE
1158: ,p_org_payment_method_id in pay_org_payment_methods_f.org_payment_method_id%TYPE
1159: ) is
1160: --

Line 1157: ,p_business_group_id in pay_org_payment_methods_f.business_group_id%TYPE

1153: -- Internal Row Handler Use Only.
1154: --
1155: Procedure chk_defined_balance_id
1156: (p_defined_balance_id in pay_org_payment_methods_f.defined_balance_id%TYPE
1157: ,p_business_group_id in pay_org_payment_methods_f.business_group_id%TYPE
1158: ,p_org_payment_method_id in pay_org_payment_methods_f.org_payment_method_id%TYPE
1159: ) is
1160: --
1161: l_proc varchar2(72) := g_package||'chk_defined_balance_id';

Line 1158: ,p_org_payment_method_id in pay_org_payment_methods_f.org_payment_method_id%TYPE

1154: --
1155: Procedure chk_defined_balance_id
1156: (p_defined_balance_id in pay_org_payment_methods_f.defined_balance_id%TYPE
1157: ,p_business_group_id in pay_org_payment_methods_f.business_group_id%TYPE
1158: ,p_org_payment_method_id in pay_org_payment_methods_f.org_payment_method_id%TYPE
1159: ) is
1160: --
1161: l_proc varchar2(72) := g_package||'chk_defined_balance_id';
1162: l_dummy number;

Line 1256: (p_org_payment_method_name in pay_org_payment_methods_f.org_payment_method_name%TYPE

1252: -- Access Status:
1253: -- Internal Row Handler Use Only.
1254: --
1255: Procedure chk_org_payment_method_name
1256: (p_org_payment_method_name in pay_org_payment_methods_f.org_payment_method_name%TYPE
1257: ,p_business_group_id in pay_org_payment_methods_f.business_group_id%TYPE
1258: ,p_org_payment_method_id in pay_org_payment_methods_f.org_payment_method_id%TYPE
1259: ) is
1260: --

Line 1257: ,p_business_group_id in pay_org_payment_methods_f.business_group_id%TYPE

1253: -- Internal Row Handler Use Only.
1254: --
1255: Procedure chk_org_payment_method_name
1256: (p_org_payment_method_name in pay_org_payment_methods_f.org_payment_method_name%TYPE
1257: ,p_business_group_id in pay_org_payment_methods_f.business_group_id%TYPE
1258: ,p_org_payment_method_id in pay_org_payment_methods_f.org_payment_method_id%TYPE
1259: ) is
1260: --
1261: l_proc varchar2(72) := g_package||'chk_org_payment_method_name';

Line 1258: ,p_org_payment_method_id in pay_org_payment_methods_f.org_payment_method_id%TYPE

1254: --
1255: Procedure chk_org_payment_method_name
1256: (p_org_payment_method_name in pay_org_payment_methods_f.org_payment_method_name%TYPE
1257: ,p_business_group_id in pay_org_payment_methods_f.business_group_id%TYPE
1258: ,p_org_payment_method_id in pay_org_payment_methods_f.org_payment_method_id%TYPE
1259: ) is
1260: --
1261: l_proc varchar2(72) := g_package||'chk_org_payment_method_name';
1262: l_api_updating boolean;

Line 1267: from pay_org_payment_methods_f opm

1263: l_dummy number;
1264: --
1265: cursor csr_org_pay_meth_name_exists is
1266: select null
1267: from pay_org_payment_methods_f opm
1268: where upper(opm.org_payment_method_name) = upper(p_org_payment_method_name)
1269: and (p_org_payment_method_id is null
1270: or p_org_payment_method_id <> opm.org_payment_method_id)
1271: and opm.business_group_id = p_business_group_id;

Line 1346: ,p_org_payment_method_id in pay_org_payment_methods_f.org_payment_method_id%TYPE

1342: -- Internal Row Handler Use Only.
1343: --
1344: Procedure chk_pre_payment
1345: (p_validation_start_date in date
1346: ,p_org_payment_method_id in pay_org_payment_methods_f.org_payment_method_id%TYPE
1347: ) is
1348: --
1349: l_proc varchar2(72) := g_package||'chk_pre_payment';
1350: l_api_updating boolean;

Line 1709: (p_org_payment_method_id in pay_org_payment_methods_f.org_payment_method_id%TYPE

1705: -- {End of Comments}
1706: --
1707: -- ---------------------------------------------------------------------------
1708: procedure chk_delete
1709: (p_org_payment_method_id in pay_org_payment_methods_f.org_payment_method_id%TYPE
1710: ,p_business_group_id in pay_org_payment_methods_f.business_group_id%TYPE
1711: ,p_datetrack_mode in varchar2
1712: ,p_effective_date in date
1713: ,p_validation_start_date in date

Line 1710: ,p_business_group_id in pay_org_payment_methods_f.business_group_id%TYPE

1706: --
1707: -- ---------------------------------------------------------------------------
1708: procedure chk_delete
1709: (p_org_payment_method_id in pay_org_payment_methods_f.org_payment_method_id%TYPE
1710: ,p_business_group_id in pay_org_payment_methods_f.business_group_id%TYPE
1711: ,p_datetrack_mode in varchar2
1712: ,p_effective_date in date
1713: ,p_validation_start_date in date
1714: ,p_validation_end_date in date

Line 1734: from pay_org_payment_methods_f_tl opt

1730: and p_effective_date < ppa.effective_date));
1731: --
1732: cursor csr_org_pay_methods_tl_exists is
1733: select null
1734: from pay_org_payment_methods_f_tl opt
1735: where opt.org_payment_method_id = p_org_payment_method_id
1736: and p_datetrack_mode = hr_api.g_zap;
1737: --
1738: cursor csr_payroll_actions_exists is

Line 1812: fnd_message.set_token('TABLE_NAME', 'PAY_ORG_PAYMENT_METHODS_F_TL');

1808: --
1809: close csr_org_pay_methods_tl_exists;
1810: --
1811: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
1812: fnd_message.set_token('TABLE_NAME', 'PAY_ORG_PAYMENT_METHODS_F_TL');
1813: fnd_message.raise_error;
1814: --
1815: End If;
1816: --