APPS.PAY_PMA_BUS dependencies on PAY_CA_PMED_ACCOUNTS

Line 56: pay_pma_shd.constraint_error('PAY_CA_PMED_ACCOUNTS_PK');

52: <> pay_pma_shd.g_old_rec.source_id) then
53: --
54: -- raise error as PK has changed
55: --
56: pay_pma_shd.constraint_error('PAY_CA_PMED_ACCOUNTS_PK');
57: --
58: elsif not l_api_updating then
59: --
60: -- check if PK is null

Line 66: pay_pma_shd.constraint_error('PAY_CA_PMED_ACCOUNTS_PK');

62: if p_source_id is not null then
63: --
64: -- raise error as PK is not null
65: --
66: pay_pma_shd.constraint_error('PAY_CA_PMED_ACCOUNTS_PK');
67: --
68: end if;
69: --
70: end if;

Line 148: pay_pma_shd.constraint_error('PAY_CA_PMED_ACCOUNTS_FK1');

144: --
145: -- raise error as FK does not relate to PK in hr_all_organization_units
146: -- table.
147: --
148: pay_pma_shd.constraint_error('PAY_CA_PMED_ACCOUNTS_FK1');
149: --
150: end if;
151: --
152: close c1;

Line 199: (p_source_id in pay_ca_pmed_accounts.source_id%TYPE

195: -- {End of Comments}
196: --
197: -- ---------------------------------------------------------------------------
198: procedure chk_account_number
199: (p_source_id in pay_ca_pmed_accounts.source_id%TYPE
200: ,p_object_version_number in pay_ca_pmed_accounts.object_version_number%TYPE
201: ,p_organization_id in pay_ca_pmed_accounts.organization_id%TYPE
202: ,p_account_number in pay_ca_pmed_accounts.account_number%TYPE
203: ) is

Line 200: ,p_object_version_number in pay_ca_pmed_accounts.object_version_number%TYPE

196: --
197: -- ---------------------------------------------------------------------------
198: procedure chk_account_number
199: (p_source_id in pay_ca_pmed_accounts.source_id%TYPE
200: ,p_object_version_number in pay_ca_pmed_accounts.object_version_number%TYPE
201: ,p_organization_id in pay_ca_pmed_accounts.organization_id%TYPE
202: ,p_account_number in pay_ca_pmed_accounts.account_number%TYPE
203: ) is
204: --

Line 201: ,p_organization_id in pay_ca_pmed_accounts.organization_id%TYPE

197: -- ---------------------------------------------------------------------------
198: procedure chk_account_number
199: (p_source_id in pay_ca_pmed_accounts.source_id%TYPE
200: ,p_object_version_number in pay_ca_pmed_accounts.object_version_number%TYPE
201: ,p_organization_id in pay_ca_pmed_accounts.organization_id%TYPE
202: ,p_account_number in pay_ca_pmed_accounts.account_number%TYPE
203: ) is
204: --
205: l_proc varchar2(72) := g_package||'chk_account_number';

Line 202: ,p_account_number in pay_ca_pmed_accounts.account_number%TYPE

198: procedure chk_account_number
199: (p_source_id in pay_ca_pmed_accounts.source_id%TYPE
200: ,p_object_version_number in pay_ca_pmed_accounts.object_version_number%TYPE
201: ,p_organization_id in pay_ca_pmed_accounts.organization_id%TYPE
202: ,p_account_number in pay_ca_pmed_accounts.account_number%TYPE
203: ) is
204: --
205: l_proc varchar2(72) := g_package||'chk_account_number';
206: l_api_updating boolean;

Line 212: FROM pay_ca_pmed_accounts pma

208: --
209: CURSOR csr_get_ac_num (p_org_id NUMBER,
210: p_ac_num VARCHAR2) IS
211: SELECT 1
212: FROM pay_ca_pmed_accounts pma
213: WHERE pma.organization_id = p_org_id
214: AND pma.account_number = p_ac_num;
215: --
216: begin

Line 265: (p_enabled in pay_ca_pmed_accounts.enabled%TYPE

261: -- {End of Comments}
262: --
263: -- ---------------------------------------------------------------------------
264: procedure chk_enabled
265: (p_enabled in pay_ca_pmed_accounts.enabled%TYPE
266: ) is
267: --
268: l_proc varchar2(72) := g_package||'chk_enabled';
269: --

Line 381: pay_ca_pmed_accounts b

377: --
378: cursor csr_leg_code is
379: select a.legislation_code
380: from per_business_groups a,
381: pay_ca_pmed_accounts b
382: where b.source_id = p_source_id
383: and a.business_group_id = b.business_group_id;
384: --
385: -- Declare local variables