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_CQR_BUS dependencies on HR_API

Line 54: and nvl(p_cbr_quald_bnf_rt_id,hr_api.g_number)

50: p_cbr_quald_bnf_rt_id => p_cbr_quald_bnf_rt_id,
51: p_object_version_number => p_object_version_number);
52: --
53: if (l_api_updating
54: and nvl(p_cbr_quald_bnf_rt_id,hr_api.g_number)
55: <> ben_cqr_shd.g_old_rec.cbr_quald_bnf_rt_id) then
56: --
57: -- raise error as PK has changed
58: --

Line 131: and (pgm_id = nvl(p_pgm_id,hr_api.g_number)

127: cursor c_dup is
128: select null
129: from ben_cbr_quald_bnf_rt_f
130: where quald_bnf_flag = p_quald_bnf_flag
131: and (pgm_id = nvl(p_pgm_id,hr_api.g_number)
132: or
133: ptip_id = nvl(p_ptip_id,hr_api.g_number)
134: )
135: and vrbl_rt_prfl_id = p_vrbl_rt_prfl_id

Line 133: ptip_id = nvl(p_ptip_id,hr_api.g_number)

129: from ben_cbr_quald_bnf_rt_f
130: where quald_bnf_flag = p_quald_bnf_flag
131: and (pgm_id = nvl(p_pgm_id,hr_api.g_number)
132: or
133: ptip_id = nvl(p_ptip_id,hr_api.g_number)
134: )
135: and vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
136: and cbr_quald_bnf_rt_id <> nvl(p_cbr_quald_bnf_rt_id,hr_api.g_number)
137: and business_group_id + 0 = p_business_group_id

Line 136: and cbr_quald_bnf_rt_id <> nvl(p_cbr_quald_bnf_rt_id,hr_api.g_number)

132: or
133: ptip_id = nvl(p_ptip_id,hr_api.g_number)
134: )
135: and vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
136: and cbr_quald_bnf_rt_id <> nvl(p_cbr_quald_bnf_rt_id,hr_api.g_number)
137: and business_group_id + 0 = p_business_group_id
138: and p_validation_start_date <= effective_end_date
139: and p_validation_end_date >= effective_start_date;
140: --

Line 152: (p_quald_bnf_flag <> nvl(ben_cqr_shd.g_old_rec.quald_bnf_flag,hr_api.g_varchar2) or

148: p_object_version_number => p_object_version_number);
149: --
150: if (l_api_updating
151: and
152: (p_quald_bnf_flag <> nvl(ben_cqr_shd.g_old_rec.quald_bnf_flag,hr_api.g_varchar2) or
153: (nvl(p_pgm_id,hr_api.g_number) <> nvl(ben_cqr_shd.g_old_rec.pgm_id,hr_api.g_number)
154: or
155: nvl(p_ptip_id,hr_api.g_number) <> nvl(ben_cqr_shd.g_old_rec.ptip_id,hr_api.g_number)
156: )

Line 153: (nvl(p_pgm_id,hr_api.g_number) <> nvl(ben_cqr_shd.g_old_rec.pgm_id,hr_api.g_number)

149: --
150: if (l_api_updating
151: and
152: (p_quald_bnf_flag <> nvl(ben_cqr_shd.g_old_rec.quald_bnf_flag,hr_api.g_varchar2) or
153: (nvl(p_pgm_id,hr_api.g_number) <> nvl(ben_cqr_shd.g_old_rec.pgm_id,hr_api.g_number)
154: or
155: nvl(p_ptip_id,hr_api.g_number) <> nvl(ben_cqr_shd.g_old_rec.ptip_id,hr_api.g_number)
156: )
157: )

Line 155: nvl(p_ptip_id,hr_api.g_number) <> nvl(ben_cqr_shd.g_old_rec.ptip_id,hr_api.g_number)

151: and
152: (p_quald_bnf_flag <> nvl(ben_cqr_shd.g_old_rec.quald_bnf_flag,hr_api.g_varchar2) or
153: (nvl(p_pgm_id,hr_api.g_number) <> nvl(ben_cqr_shd.g_old_rec.pgm_id,hr_api.g_number)
154: or
155: nvl(p_ptip_id,hr_api.g_number) <> nvl(ben_cqr_shd.g_old_rec.ptip_id,hr_api.g_number)
156: )
157: )
158: or not l_api_updating) then
159:

Line 231: and nvl(p_pgm_id,hr_api.g_number)

227: p_cbr_quald_bnf_rt_id => p_cbr_quald_bnf_rt_id,
228: p_object_version_number => p_object_version_number);
229: --
230: if (l_api_updating
231: and nvl(p_pgm_id,hr_api.g_number)
232: <> nvl(ben_cqr_shd.g_old_rec.pgm_id,hr_api.g_number)
233: or not l_api_updating) and p_pgm_id is not null then
234: --
235: -- check if pgm_id value exists in ben_pgm_f table

Line 232: <> nvl(ben_cqr_shd.g_old_rec.pgm_id,hr_api.g_number)

228: p_object_version_number => p_object_version_number);
229: --
230: if (l_api_updating
231: and nvl(p_pgm_id,hr_api.g_number)
232: <> nvl(ben_cqr_shd.g_old_rec.pgm_id,hr_api.g_number)
233: or not l_api_updating) and p_pgm_id is not null then
234: --
235: -- check if pgm_id value exists in ben_pgm_f table
236: --

Line 308: and nvl(p_ptip_id,hr_api.g_number)

304: p_cbr_quald_bnf_rt_id => p_cbr_quald_bnf_rt_id,
305: p_object_version_number => p_object_version_number);
306: --
307: if (l_api_updating
308: and nvl(p_ptip_id,hr_api.g_number)
309: <> nvl(ben_cqr_shd.g_old_rec.ptip_id,hr_api.g_number)
310: or not l_api_updating) and p_ptip_id is not null then
311: --
312: -- check if ptip_id value exists in ben_ptip_f table

Line 309: <> nvl(ben_cqr_shd.g_old_rec.ptip_id,hr_api.g_number)

305: p_object_version_number => p_object_version_number);
306: --
307: if (l_api_updating
308: and nvl(p_ptip_id,hr_api.g_number)
309: <> nvl(ben_cqr_shd.g_old_rec.ptip_id,hr_api.g_number)
310: or not l_api_updating) and p_ptip_id is not null then
311: --
312: -- check if ptip_id value exists in ben_ptip_f table
313: --

Line 381: <> nvl(ben_cqr_shd.g_old_rec.quald_bnf_flag,hr_api.g_varchar2)

377: p_object_version_number => p_object_version_number);
378: --
379: if (l_api_updating
380: and p_quald_bnf_flag
381: <> nvl(ben_cqr_shd.g_old_rec.quald_bnf_flag,hr_api.g_varchar2)
382: or not l_api_updating) then
383: --
384: -- check if value of lookup falls within lookup type.
385: --

Line 387: if hr_api.not_exists_in_hr_lookups

383: --
384: -- check if value of lookup falls within lookup type.
385: --
386: --
387: if hr_api.not_exists_in_hr_lookups
388: (p_lookup_type => 'YES_NO',
389: p_lookup_code => p_quald_bnf_flag,
390: p_effective_date => p_effective_date) then
391: --

Line 503: (p_vrbl_rt_prfl_id in number default hr_api.g_number,

499: --
500: -- {End Of Comments}
501: -- ----------------------------------------------------------------------------
502: Procedure dt_update_validate
503: (p_vrbl_rt_prfl_id in number default hr_api.g_number,
504: p_pgm_id in number default hr_api.g_number,
505: p_ptip_id in number default hr_api.g_number,
506: p_datetrack_mode in varchar2,
507: p_validation_start_date in date,

Line 504: p_pgm_id in number default hr_api.g_number,

500: -- {End Of Comments}
501: -- ----------------------------------------------------------------------------
502: Procedure dt_update_validate
503: (p_vrbl_rt_prfl_id in number default hr_api.g_number,
504: p_pgm_id in number default hr_api.g_number,
505: p_ptip_id in number default hr_api.g_number,
506: p_datetrack_mode in varchar2,
507: p_validation_start_date in date,
508: p_validation_end_date in date) Is

Line 505: p_ptip_id in number default hr_api.g_number,

501: -- ----------------------------------------------------------------------------
502: Procedure dt_update_validate
503: (p_vrbl_rt_prfl_id in number default hr_api.g_number,
504: p_pgm_id in number default hr_api.g_number,
505: p_ptip_id in number default hr_api.g_number,
506: p_datetrack_mode in varchar2,
507: p_validation_start_date in date,
508: p_validation_end_date in date) Is
509: --

Line 519: hr_api.mandatory_arg_error

515: hr_utility.set_location('Entering:'||l_proc, 5);
516: --
517: -- Ensure that the p_datetrack_mode argument is not null
518: --
519: hr_api.mandatory_arg_error
520: (p_api_name => l_proc,
521: p_argument => 'datetrack_mode',
522: p_argument_value => p_datetrack_mode);
523: --

Line 531: hr_api.mandatory_arg_error

527: --
528: --
529: -- Ensure the arguments are not null
530: --
531: hr_api.mandatory_arg_error
532: (p_api_name => l_proc,
533: p_argument => 'validation_start_date',
534: p_argument_value => p_validation_start_date);
535: --

Line 536: hr_api.mandatory_arg_error

532: (p_api_name => l_proc,
533: p_argument => 'validation_start_date',
534: p_argument_value => p_validation_start_date);
535: --
536: hr_api.mandatory_arg_error
537: (p_api_name => l_proc,
538: p_argument => 'validation_end_date',
539: p_argument_value => p_validation_end_date);
540: --

Line 541: If ((nvl(p_vrbl_rt_prfl_id, hr_api.g_number) <> hr_api.g_number) and

537: (p_api_name => l_proc,
538: p_argument => 'validation_end_date',
539: p_argument_value => p_validation_end_date);
540: --
541: If ((nvl(p_vrbl_rt_prfl_id, hr_api.g_number) <> hr_api.g_number) and
542: NOT (dt_api.check_min_max_dates
543: (p_base_table_name => 'ben_vrbl_rt_prfl_f',
544: p_base_key_column => 'vrbl_rt_prfl_id',
545: p_base_key_value => p_vrbl_rt_prfl_id,

Line 551: If ((nvl(p_pgm_id, hr_api.g_number) <> hr_api.g_number) and

547: p_to_date => p_validation_end_date))) Then
548: l_table_name := 'ben_vrbl_rt_prfl_f';
549: Raise l_integrity_error;
550: End If;
551: If ((nvl(p_pgm_id, hr_api.g_number) <> hr_api.g_number) and
552: NOT (dt_api.check_min_max_dates
553: (p_base_table_name => 'ben_pgm_f',
554: p_base_key_column => 'pgm_id',
555: p_base_key_value => p_pgm_id,

Line 561: If ((nvl(p_ptip_id, hr_api.g_number) <> hr_api.g_number) and

557: p_to_date => p_validation_end_date))) Then
558: l_table_name := 'ben_pgm_f';
559: Raise l_integrity_error;
560: End If;
561: If ((nvl(p_ptip_id, hr_api.g_number) <> hr_api.g_number) and
562: NOT (dt_api.check_min_max_dates
563: (p_base_table_name => 'ben_ptip_f',
564: p_base_key_column => 'ptip_id',
565: p_base_key_value => p_ptip_id,

Line 644: hr_api.mandatory_arg_error

640: hr_utility.set_location('Entering:'||l_proc, 5);
641: --
642: -- Ensure that the p_datetrack_mode argument is not null
643: --
644: hr_api.mandatory_arg_error
645: (p_api_name => l_proc,
646: p_argument => 'datetrack_mode',
647: p_argument_value => p_datetrack_mode);
648: --

Line 658: hr_api.mandatory_arg_error

654: --
655: --
656: -- Ensure the arguments are not null
657: --
658: hr_api.mandatory_arg_error
659: (p_api_name => l_proc,
660: p_argument => 'validation_start_date',
661: p_argument_value => p_validation_start_date);
662: --

Line 663: hr_api.mandatory_arg_error

659: (p_api_name => l_proc,
660: p_argument => 'validation_start_date',
661: p_argument_value => p_validation_start_date);
662: --
663: hr_api.mandatory_arg_error
664: (p_api_name => l_proc,
665: p_argument => 'validation_end_date',
666: p_argument_value => p_validation_end_date);
667: --

Line 668: hr_api.mandatory_arg_error

664: (p_api_name => l_proc,
665: p_argument => 'validation_end_date',
666: p_argument_value => p_validation_end_date);
667: --
668: hr_api.mandatory_arg_error
669: (p_api_name => l_proc,
670: p_argument => 'cbr_quald_bnf_rt_id',
671: p_argument_value => p_cbr_quald_bnf_rt_id);
672: --

Line 716: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

712: --
713: -- Call all supporting business operations
714: --
715: --
716: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
717: --
718: chk_cbr_quald_bnf_rt_id
719: (p_cbr_quald_bnf_rt_id => p_rec.cbr_quald_bnf_rt_id,
720: p_effective_date => p_effective_date,

Line 784: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

780: --
781: -- Call all supporting business operations
782: --
783: --
784: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
785: --
786: chk_cbr_quald_bnf_rt_id
787: (p_cbr_quald_bnf_rt_id => p_rec.cbr_quald_bnf_rt_id,
788: p_effective_date => p_effective_date,

Line 897: hr_api.mandatory_arg_error(p_api_name => l_proc,

893: hr_utility.set_location('Entering:'|| l_proc, 10);
894: --
895: -- Ensure that all the mandatory parameter are not null
896: --
897: hr_api.mandatory_arg_error(p_api_name => l_proc,
898: p_argument => 'cbr_quald_bnf_rt_id',
899: p_argument_value => p_cbr_quald_bnf_rt_id);
900: --
901: open csr_leg_code;