APPS.PAY_PMA_BUS dependencies on PAY_PMA_SHD

Line 46: l_api_updating := pay_pma_shd.api_updating

42: Begin
43: --
44: hr_utility.set_location('Entering:'||l_proc, 5);
45: --
46: l_api_updating := pay_pma_shd.api_updating
47: (p_source_id => p_source_id,
48: p_object_version_number => p_object_version_number);
49: --
50: if (l_api_updating

Line 52: <> pay_pma_shd.g_old_rec.source_id) then

48: p_object_version_number => p_object_version_number);
49: --
50: if (l_api_updating
51: and nvl(p_source_id,hr_api.g_number)
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');

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 127: l_api_updating := pay_pma_shd.api_updating

123: Begin
124: --
125: hr_utility.set_location('Entering:'||l_proc,5);
126: --
127: l_api_updating := pay_pma_shd.api_updating
128: (p_source_id => p_source_id,
129: p_object_version_number => p_object_version_number);
130: --
131: if (l_api_updating

Line 133: <> nvl(pay_pma_shd.g_old_rec.organization_id,hr_api.g_number)

129: p_object_version_number => p_object_version_number);
130: --
131: if (l_api_updating
132: and nvl(p_organization_id,hr_api.g_number)
133: <> nvl(pay_pma_shd.g_old_rec.organization_id,hr_api.g_number)
134: or not l_api_updating) then
135: --
136: -- check if organization_id value exists in hr_all_organization_units table
137: --

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 219: l_api_updating := pay_pma_shd.api_updating

215: --
216: begin
217: hr_utility.set_location('Entering:'||l_proc, 10);
218:
219: l_api_updating := pay_pma_shd.api_updating
220: (p_source_id => p_source_id,
221: p_object_version_number => p_object_version_number);
222: --
223: if NOT l_api_updating THEN

Line 286: Procedure insert_validate(p_rec in pay_pma_shd.g_rec_type) is

282: --
283: -- ----------------------------------------------------------------------------
284: -- |---------------------------< insert_validate >----------------------------|
285: -- ----------------------------------------------------------------------------
286: Procedure insert_validate(p_rec in pay_pma_shd.g_rec_type) is
287: --
288: l_proc varchar2(72) := g_package||'insert_validate';
289: --
290: Begin

Line 321: Procedure update_validate(p_rec in pay_pma_shd.g_rec_type) is

317: --
318: -- ----------------------------------------------------------------------------
319: -- |---------------------------< update_validate >----------------------------|
320: -- ----------------------------------------------------------------------------
321: Procedure update_validate(p_rec in pay_pma_shd.g_rec_type) is
322: --
323: l_proc varchar2(72) := g_package||'update_validate';
324: --
325: Begin

Line 356: Procedure delete_validate(p_rec in pay_pma_shd.g_rec_type) is

352: --
353: -- ----------------------------------------------------------------------------
354: -- |---------------------------< delete_validate >----------------------------|
355: -- ----------------------------------------------------------------------------
356: Procedure delete_validate(p_rec in pay_pma_shd.g_rec_type) is
357: --
358: l_proc varchar2(72) := g_package||'delete_validate';
359: --
360: Begin