DBA Data[Home] [Help]

APPS.BEN_PRD_BUS dependencies on HR_API

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

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

Line 124: <> nvl(ben_prd_shd.g_old_rec.no_cmbnd_mn_amt_dfnd_flag,hr_api.g_varchar2)

120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating
123: and p_no_cmbnd_mn_amt_dfnd_flag
124: <> nvl(ben_prd_shd.g_old_rec.no_cmbnd_mn_amt_dfnd_flag,hr_api.g_varchar2)
125: or not l_api_updating) then
126: --
127: -- check if value of lookup falls within lookup type.
128: --

Line 130: if hr_api.not_exists_in_hr_lookups

126: --
127: -- check if value of lookup falls within lookup type.
128: --
129: --
130: if hr_api.not_exists_in_hr_lookups
131: (p_lookup_type => 'YES_NO',
132: p_lookup_code => p_no_cmbnd_mn_amt_dfnd_flag,
133: p_effective_date => p_effective_date) then
134: --

Line 193: <> nvl(ben_prd_shd.g_old_rec.no_cmbnd_mx_amt_dfnd_flag,hr_api.g_varchar2)

189: p_object_version_number => p_object_version_number);
190: --
191: if (l_api_updating
192: and p_no_cmbnd_mx_amt_dfnd_flag
193: <> nvl(ben_prd_shd.g_old_rec.no_cmbnd_mx_amt_dfnd_flag,hr_api.g_varchar2)
194: or not l_api_updating) then
195: --
196: -- check if value of lookup falls within lookup type.
197: --

Line 199: if hr_api.not_exists_in_hr_lookups

195: --
196: -- check if value of lookup falls within lookup type.
197: --
198: --
199: if hr_api.not_exists_in_hr_lookups
200: (p_lookup_type => 'YES_NO',
201: p_lookup_code => p_no_cmbnd_mx_amt_dfnd_flag,
202: p_effective_date => p_effective_date) then
203: --

Line 262: <> nvl(ben_prd_shd.g_old_rec.use_parnt_pymt_sched_flag,hr_api.g_varchar2)

258: p_object_version_number => p_object_version_number);
259: --
260: if (l_api_updating
261: and p_use_parnt_pymt_sched_flag
262: <> nvl(ben_prd_shd.g_old_rec.use_parnt_pymt_sched_flag,hr_api.g_varchar2)
263: or not l_api_updating) then
264: --
265: -- check if value of lookup falls within lookup type.
266: --

Line 268: if hr_api.not_exists_in_hr_lookups

264: --
265: -- check if value of lookup falls within lookup type.
266: --
267: --
268: if hr_api.not_exists_in_hr_lookups
269: (p_lookup_type => 'YES_NO',
270: p_lookup_code => p_use_parnt_pymt_sched_flag,
271: p_effective_date => p_effective_date) then
272: --

Line 331: <> nvl(ben_prd_shd.g_old_rec.alloc_sme_as_parnt_flag,hr_api.g_varchar2)

327: p_object_version_number => p_object_version_number);
328: --
329: if (l_api_updating
330: and p_alloc_sme_as_parnt_flag
331: <> nvl(ben_prd_shd.g_old_rec.alloc_sme_as_parnt_flag,hr_api.g_varchar2)
332: or not l_api_updating) then
333: --
334: -- check if value of lookup falls within lookup type.
335: --

Line 337: if hr_api.not_exists_in_hr_lookups

333: --
334: -- check if value of lookup falls within lookup type.
335: --
336: --
337: if hr_api.not_exists_in_hr_lookups
338: (p_lookup_type => 'YES_NO',
339: p_lookup_code => p_alloc_sme_as_parnt_flag,
340: p_effective_date => p_effective_date) then
341: --

Line 400: <> nvl(ben_prd_shd.g_old_rec.use_parnt_prtl_mo_cd_flag,hr_api.g_varchar2)

396: p_object_version_number => p_object_version_number);
397: --
398: if (l_api_updating
399: and p_use_parnt_prtl_mo_cd_flag
400: <> nvl(ben_prd_shd.g_old_rec.use_parnt_prtl_mo_cd_flag,hr_api.g_varchar2)
401: or not l_api_updating) then
402: --
403: -- check if value of lookup falls within lookup type.
404: --

Line 406: if hr_api.not_exists_in_hr_lookups

402: --
403: -- check if value of lookup falls within lookup type.
404: --
405: --
406: if hr_api.not_exists_in_hr_lookups
407: (p_lookup_type => 'YES_NO',
408: p_lookup_code => p_use_parnt_prtl_mo_cd_flag,
409: p_effective_date => p_effective_date) then
410: --

Line 469: <> nvl(ben_prd_shd.g_old_rec.asn_on_chc_of_parnt_flag,hr_api.g_varchar2)

465: p_object_version_number => p_object_version_number);
466: --
467: if (l_api_updating
468: and p_asn_on_chc_of_parnt_flag
469: <> nvl(ben_prd_shd.g_old_rec.asn_on_chc_of_parnt_flag,hr_api.g_varchar2)
470: or not l_api_updating) then
471: --
472: -- check if value of lookup falls within lookup type.
473: --

Line 475: if hr_api.not_exists_in_hr_lookups

471: --
472: -- check if value of lookup falls within lookup type.
473: --
474: --
475: if hr_api.not_exists_in_hr_lookups
476: (p_lookup_type => 'YES_NO',
477: p_lookup_code => p_asn_on_chc_of_parnt_flag,
478: p_effective_date => p_effective_date) then
479: --

Line 538: <> nvl(ben_prd_shd.g_old_rec.use_parnt_ded_sched_flag,hr_api.g_varchar2)

534: p_object_version_number => p_object_version_number);
535: --
536: if (l_api_updating
537: and p_use_parnt_ded_sched_flag
538: <> nvl(ben_prd_shd.g_old_rec.use_parnt_ded_sched_flag,hr_api.g_varchar2)
539: or not l_api_updating) then
540: --
541: -- check if value of lookup falls within lookup type.
542: --

Line 544: if hr_api.not_exists_in_hr_lookups

540: --
541: -- check if value of lookup falls within lookup type.
542: --
543: --
544: if hr_api.not_exists_in_hr_lookups
545: (p_lookup_type => 'YES_NO',
546: p_lookup_code => p_use_parnt_ded_sched_flag,
547: p_effective_date => p_effective_date) then
548: --

Line 607: <> nvl(ben_prd_shd.g_old_rec.no_cmbnd_mx_pct_dfnd_flag,hr_api.g_varchar2)

603: p_object_version_number => p_object_version_number);
604: --
605: if (l_api_updating
606: and p_no_cmbnd_mx_pct_dfnd_flag
607: <> nvl(ben_prd_shd.g_old_rec.no_cmbnd_mx_pct_dfnd_flag,hr_api.g_varchar2)
608: or not l_api_updating) then
609: --
610: -- check if value of lookup falls within lookup type.
611: --

Line 613: if hr_api.not_exists_in_hr_lookups

609: --
610: -- check if value of lookup falls within lookup type.
611: --
612: --
613: if hr_api.not_exists_in_hr_lookups
614: (p_lookup_type => 'YES_NO',
615: p_lookup_code => p_no_cmbnd_mx_pct_dfnd_flag,
616: p_effective_date => p_effective_date) then
617: --

Line 676: <> nvl(ben_prd_shd.g_old_rec.no_cmbnd_mn_pct_dfnd_flag,hr_api.g_varchar2)

672: p_object_version_number => p_object_version_number);
673: --
674: if (l_api_updating
675: and p_no_cmbnd_mn_pct_dfnd_flag
676: <> nvl(ben_prd_shd.g_old_rec.no_cmbnd_mn_pct_dfnd_flag,hr_api.g_varchar2)
677: or not l_api_updating) then
678: --
679: -- check if value of lookup falls within lookup type.
680: --

Line 682: if hr_api.not_exists_in_hr_lookups

678: --
679: -- check if value of lookup falls within lookup type.
680: --
681: --
682: if hr_api.not_exists_in_hr_lookups
683: (p_lookup_type => 'YES_NO',
684: p_lookup_code => p_no_cmbnd_mn_pct_dfnd_flag,
685: p_effective_date => p_effective_date) then
686: --

Line 972: (p_parnt_acty_base_rt_id in number default hr_api.g_number,

968: --
969: -- {End Of Comments}
970: -- ----------------------------------------------------------------------------
971: Procedure dt_update_validate
972: (p_parnt_acty_base_rt_id in number default hr_api.g_number,
973: p_chld_acty_base_rt_id in number default hr_api.g_number,
974: p_datetrack_mode in varchar2,
975: p_validation_start_date in date,
976: p_validation_end_date in date) Is

Line 973: p_chld_acty_base_rt_id in number default hr_api.g_number,

969: -- {End Of Comments}
970: -- ----------------------------------------------------------------------------
971: Procedure dt_update_validate
972: (p_parnt_acty_base_rt_id in number default hr_api.g_number,
973: p_chld_acty_base_rt_id in number default hr_api.g_number,
974: p_datetrack_mode in varchar2,
975: p_validation_start_date in date,
976: p_validation_end_date in date) Is
977: --

Line 987: hr_api.mandatory_arg_error

983: hr_utility.set_location('Entering:'||l_proc, 5);
984: --
985: -- Ensure that the p_datetrack_mode argument is not null
986: --
987: hr_api.mandatory_arg_error
988: (p_api_name => l_proc,
989: p_argument => 'datetrack_mode',
990: p_argument_value => p_datetrack_mode);
991: --

Line 999: hr_api.mandatory_arg_error

995: --
996: --
997: -- Ensure the arguments are not null
998: --
999: hr_api.mandatory_arg_error
1000: (p_api_name => l_proc,
1001: p_argument => 'validation_start_date',
1002: p_argument_value => p_validation_start_date);
1003: --

Line 1004: hr_api.mandatory_arg_error

1000: (p_api_name => l_proc,
1001: p_argument => 'validation_start_date',
1002: p_argument_value => p_validation_start_date);
1003: --
1004: hr_api.mandatory_arg_error
1005: (p_api_name => l_proc,
1006: p_argument => 'validation_end_date',
1007: p_argument_value => p_validation_end_date);
1008: --

Line 1009: If ((nvl(p_parnt_acty_base_rt_id, hr_api.g_number) <> hr_api.g_number) and

1005: (p_api_name => l_proc,
1006: p_argument => 'validation_end_date',
1007: p_argument_value => p_validation_end_date);
1008: --
1009: If ((nvl(p_parnt_acty_base_rt_id, hr_api.g_number) <> hr_api.g_number) and
1010: NOT (dt_api.check_min_max_dates
1011: (p_base_table_name => 'ben_acty_base_rt_f',
1012: p_base_key_column => 'acty_base_rt_id',
1013: p_base_key_value => p_parnt_acty_base_rt_id,

Line 1019: If ((nvl(p_chld_acty_base_rt_id, hr_api.g_number) <> hr_api.g_number) and

1015: p_to_date => p_validation_end_date))) Then
1016: l_table_name := 'ben_acty_base_rt_f';
1017: Raise l_integrity_error;
1018: End If;
1019: If ((nvl(p_chld_acty_base_rt_id, hr_api.g_number) <> hr_api.g_number) and
1020: NOT (dt_api.check_min_max_dates
1021: (p_base_table_name => 'ben_acty_base_rt_f',
1022: p_base_key_column => 'acty_base_rt_id',
1023: p_base_key_value => p_chld_acty_base_rt_id,

Line 1103: hr_api.mandatory_arg_error

1099: hr_utility.set_location('Entering:'||l_proc, 5);
1100: --
1101: -- Ensure that the p_datetrack_mode argument is not null
1102: --
1103: hr_api.mandatory_arg_error
1104: (p_api_name => l_proc,
1105: p_argument => 'datetrack_mode',
1106: p_argument_value => p_datetrack_mode);
1107: --

Line 1117: hr_api.mandatory_arg_error

1113: --
1114: --
1115: -- Ensure the arguments are not null
1116: --
1117: hr_api.mandatory_arg_error
1118: (p_api_name => l_proc,
1119: p_argument => 'validation_start_date',
1120: p_argument_value => p_validation_start_date);
1121: --

Line 1122: hr_api.mandatory_arg_error

1118: (p_api_name => l_proc,
1119: p_argument => 'validation_start_date',
1120: p_argument_value => p_validation_start_date);
1121: --
1122: hr_api.mandatory_arg_error
1123: (p_api_name => l_proc,
1124: p_argument => 'validation_end_date',
1125: p_argument_value => p_validation_end_date);
1126: --

Line 1127: hr_api.mandatory_arg_error

1123: (p_api_name => l_proc,
1124: p_argument => 'validation_end_date',
1125: p_argument_value => p_validation_end_date);
1126: --
1127: hr_api.mandatory_arg_error
1128: (p_api_name => l_proc,
1129: p_argument => 'paird_rt_id',
1130: p_argument_value => p_paird_rt_id);
1131: --

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

1169: --
1170: -- Call all supporting business operations
1171: --
1172: --
1173: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1174: --
1175: chk_paird_rt_id
1176: (p_paird_rt_id => p_rec.paird_rt_id,
1177: p_effective_date => p_effective_date,

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

1267: --
1268: -- Call all supporting business operations
1269: --
1270: --
1271: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1272: --
1273: chk_paird_rt_id
1274: (p_paird_rt_id => p_rec.paird_rt_id,
1275: p_effective_date => p_effective_date,

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

1410: hr_utility.set_location('Entering:'|| l_proc, 10);
1411: --
1412: -- Ensure that all the mandatory parameter are not null
1413: --
1414: hr_api.mandatory_arg_error(p_api_name => l_proc,
1415: p_argument => 'paird_rt_id',
1416: p_argument_value => p_paird_rt_id);
1417: --
1418: open csr_leg_code;