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.BEN_PCD_BUS dependencies on BEN_PCD_SHD

Line 48: l_api_updating := ben_pcd_shd.api_updating

44: Begin
45: --
46: hr_utility.set_location('Entering:'||l_proc, 5);
47: --
48: l_api_updating := ben_pcd_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_per_cm_prvdd_id => p_per_cm_prvdd_id,
51: p_object_version_number => p_object_version_number);
52: --

Line 55: <> ben_pcd_shd.g_old_rec.per_cm_prvdd_id) then

51: p_object_version_number => p_object_version_number);
52: --
53: if (l_api_updating
54: and nvl(p_per_cm_prvdd_id,hr_api.g_number)
55: <> ben_pcd_shd.g_old_rec.per_cm_prvdd_id) then
56: --
57: -- raise error as PK has changed
58: --
59: ben_pcd_shd.constraint_error('BEN_PER_CM_PRVDD_F_PK');

Line 59: ben_pcd_shd.constraint_error('BEN_PER_CM_PRVDD_F_PK');

55: <> ben_pcd_shd.g_old_rec.per_cm_prvdd_id) then
56: --
57: -- raise error as PK has changed
58: --
59: ben_pcd_shd.constraint_error('BEN_PER_CM_PRVDD_F_PK');
60: --
61: elsif not l_api_updating then
62: --
63: -- check if PK is null

Line 69: ben_pcd_shd.constraint_error('BEN_PER_CM_PRVDD_F_PK');

65: if p_per_cm_prvdd_id is not null then
66: --
67: -- raise error as PK is not null
68: --
69: ben_pcd_shd.constraint_error('BEN_PER_CM_PRVDD_F_PK');
70: --
71: end if;
72: --
73: end if;

Line 123: l_api_updating := ben_pcd_shd.api_updating

119: Begin
120: --
121: hr_utility.set_location('Entering:'||l_proc,5);
122: --
123: l_api_updating := ben_pcd_shd.api_updating
124: (p_per_cm_prvdd_id => p_per_cm_prvdd_id,
125: p_effective_date => p_effective_date,
126: p_object_version_number => p_object_version_number);
127: --

Line 130: <> nvl(ben_pcd_shd.g_old_rec.address_id,hr_api.g_number)

126: p_object_version_number => p_object_version_number);
127: --
128: if (l_api_updating
129: and nvl(p_address_id,hr_api.g_number)
130: <> nvl(ben_pcd_shd.g_old_rec.address_id,hr_api.g_number)
131: or not l_api_updating) and
132: p_address_id is not null then
133: --
134: -- check if address_id value exists in per_addresses table

Line 146: ben_pcd_shd.constraint_error('BEN_PER_CM_PRVDD_F_FK2');

142: --
143: -- raise error as FK does not relate to PK in per_addresses
144: -- table.
145: --
146: ben_pcd_shd.constraint_error('BEN_PER_CM_PRVDD_F_FK2');
147: --
148: end if;
149: --
150: close c1;

Line 198: l_api_updating := ben_pcd_shd.api_updating

194: Begin
195: --
196: hr_utility.set_location('Entering:'||l_proc, 5);
197: --
198: l_api_updating := ben_pcd_shd.api_updating
199: (p_per_cm_prvdd_id => p_per_cm_prvdd_id,
200: p_effective_date => p_effective_date,
201: p_object_version_number => p_object_version_number);
202: --

Line 205: <> nvl(ben_pcd_shd.g_old_rec.to_be_sent_dt,hr_api.g_varchar2)

201: p_object_version_number => p_object_version_number);
202: --
203: if (l_api_updating
204: and p_to_be_sent_dt
205: <> nvl(ben_pcd_shd.g_old_rec.to_be_sent_dt,hr_api.g_varchar2)
206: or not l_api_updating)
207: and p_to_be_sent_dt is not null then
208: --
209: if p_to_be_sent_dt < p_effective_date then

Line 260: l_api_updating := ben_pcd_shd.api_updating

256: Begin
257: --
258: hr_utility.set_location('Entering:'||l_proc, 5);
259: --
260: l_api_updating := ben_pcd_shd.api_updating
261: (p_per_cm_prvdd_id => p_per_cm_prvdd_id,
262: p_effective_date => p_effective_date,
263: p_object_version_number => p_object_version_number);
264: --

Line 267: <> nvl(ben_pcd_shd.g_old_rec.cm_dlvry_mthd_cd,hr_api.g_varchar2)

263: p_object_version_number => p_object_version_number);
264: --
265: if (l_api_updating
266: and p_cm_dlvry_mthd_cd
267: <> nvl(ben_pcd_shd.g_old_rec.cm_dlvry_mthd_cd,hr_api.g_varchar2)
268: or not l_api_updating)
269: and p_cm_dlvry_mthd_cd is not null then
270: --
271: -- check if value of lookup falls within lookup type.

Line 332: l_api_updating := ben_pcd_shd.api_updating

328: Begin
329: --
330: hr_utility.set_location('Entering:'||l_proc, 5);
331: --
332: l_api_updating := ben_pcd_shd.api_updating
333: (p_per_cm_prvdd_id => p_per_cm_prvdd_id,
334: p_effective_date => p_effective_date,
335: p_object_version_number => p_object_version_number);
336: --

Line 339: <> nvl(ben_pcd_shd.g_old_rec.cm_dlvry_med_cd,hr_api.g_varchar2)

335: p_object_version_number => p_object_version_number);
336: --
337: if (l_api_updating
338: and p_cm_dlvry_med_cd
339: <> nvl(ben_pcd_shd.g_old_rec.cm_dlvry_med_cd,hr_api.g_varchar2)
340: or not l_api_updating)
341: and p_cm_dlvry_med_cd is not null then
342: --
343: -- check if value of lookup falls within lookup type.

Line 403: l_api_updating := ben_pcd_shd.api_updating

399: Begin
400: --
401: hr_utility.set_location('Entering:'||l_proc, 5);
402: --
403: l_api_updating := ben_pcd_shd.api_updating
404: (p_per_cm_prvdd_id => p_per_cm_prvdd_id,
405: p_effective_date => p_effective_date,
406: p_object_version_number => p_object_version_number);
407: --

Line 410: <> nvl(ben_pcd_shd.g_old_rec.per_cm_prvdd_stat_cd,hr_api.g_varchar2)

406: p_object_version_number => p_object_version_number);
407: --
408: if (l_api_updating
409: and p_per_cm_prvdd_stat_cd
410: <> nvl(ben_pcd_shd.g_old_rec.per_cm_prvdd_stat_cd,hr_api.g_varchar2)
411: or not l_api_updating)
412: and p_per_cm_prvdd_stat_cd is not null then
413: --
414: -- check if value of lookup falls within lookup type.

Line 475: l_api_updating := ben_pcd_shd.api_updating

471: Begin
472: --
473: hr_utility.set_location('Entering:'||l_proc, 5);
474: --
475: l_api_updating := ben_pcd_shd.api_updating
476: (p_per_cm_prvdd_id => p_per_cm_prvdd_id,
477: p_effective_date => p_effective_date,
478: p_object_version_number => p_object_version_number);
479: --

Line 482: <> nvl(ben_pcd_shd.g_old_rec.resnd_rsn_cd,hr_api.g_varchar2)

478: p_object_version_number => p_object_version_number);
479: --
480: if (l_api_updating
481: and p_resnd_rsn_cd
482: <> nvl(ben_pcd_shd.g_old_rec.resnd_rsn_cd,hr_api.g_varchar2)
483: or not l_api_updating)
484: and p_resnd_rsn_cd is not null then
485: --
486: -- check if value of lookup falls within lookup type.

Line 545: l_api_updating := ben_pcd_shd.api_updating

541: Begin
542: --
543: hr_utility.set_location('Entering:'||l_proc, 5);
544: --
545: l_api_updating := ben_pcd_shd.api_updating
546: (p_per_cm_prvdd_id => p_per_cm_prvdd_id,
547: p_effective_date => p_effective_date,
548: p_object_version_number => p_object_version_number);
549: --

Line 552: <> nvl(ben_pcd_shd.g_old_rec.inspn_rqd_flag,hr_api.g_varchar2)

548: p_object_version_number => p_object_version_number);
549: --
550: if (l_api_updating
551: and p_inspn_rqd_flag
552: <> nvl(ben_pcd_shd.g_old_rec.inspn_rqd_flag,hr_api.g_varchar2)
553: or not l_api_updating) then
554: --
555: -- check if value of lookup falls within lookup type.
556: --

Line 616: l_api_updating := ben_pcd_shd.api_updating

612: Begin
613: --
614: hr_utility.set_location('Entering:'||l_proc, 5);
615: --
616: l_api_updating := ben_pcd_shd.api_updating
617: (p_per_cm_prvdd_id => p_per_cm_prvdd_id,
618: p_effective_date => p_effective_date,
619: p_object_version_number => p_object_version_number);
620: --

Line 623: <> nvl(ben_pcd_shd.g_old_rec.rqstd_flag,hr_api.g_varchar2)

619: p_object_version_number => p_object_version_number);
620: --
621: if (l_api_updating
622: and p_rqstd_flag
623: <> nvl(ben_pcd_shd.g_old_rec.rqstd_flag,hr_api.g_varchar2)
624: or not l_api_updating) then
625: --
626: -- check if value of lookup falls within lookup type.
627: --

Line 854: (p_rec in ben_pcd_shd.g_rec_type,

850: -- ----------------------------------------------------------------------------
851: -- |---------------------------< insert_validate >----------------------------|
852: -- ----------------------------------------------------------------------------
853: Procedure insert_validate
854: (p_rec in ben_pcd_shd.g_rec_type,
855: p_effective_date in date,
856: p_datetrack_mode in varchar2,
857: p_validation_start_date in date,
858: p_validation_end_date in date) is

Line 936: (p_rec in ben_pcd_shd.g_rec_type,

932: -- ----------------------------------------------------------------------------
933: -- |---------------------------< update_validate >----------------------------|
934: -- ----------------------------------------------------------------------------
935: Procedure update_validate
936: (p_rec in ben_pcd_shd.g_rec_type,
937: p_effective_date in date,
938: p_datetrack_mode in varchar2,
939: p_validation_start_date in date,
940: p_validation_end_date in date) is

Line 1015: (p_rec in ben_pcd_shd.g_rec_type,

1011: -- ----------------------------------------------------------------------------
1012: -- |---------------------------< delete_validate >----------------------------|
1013: -- ----------------------------------------------------------------------------
1014: Procedure delete_validate
1015: (p_rec in ben_pcd_shd.g_rec_type,
1016: p_effective_date in date,
1017: p_datetrack_mode in varchar2,
1018: p_validation_start_date in date,
1019: p_validation_end_date in date) is