APPS.BEN_XEL_BUS dependencies on BEN_XEL_SHD

Line 106: l_api_updating := ben_xel_shd.api_updating

102: Begin
103: --
104: hr_utility.set_location('Entering:'||l_proc, 5);
105: --
106: l_api_updating := ben_xel_shd.api_updating
107: (p_ext_data_elmt_id => p_ext_data_elmt_id,
108: p_object_version_number => p_object_version_number);
109: --
110: if (l_api_updating

Line 112: <> ben_xel_shd.g_old_rec.ext_data_elmt_id) then

108: p_object_version_number => p_object_version_number);
109: --
110: if (l_api_updating
111: and nvl(p_ext_data_elmt_id,hr_api.g_number)
112: <> ben_xel_shd.g_old_rec.ext_data_elmt_id) then
113: --
114: -- raise error as PK has changed
115: --
116: ben_xel_shd.constraint_error('BEN_EXT_DATA_ELMT_PK');

Line 116: ben_xel_shd.constraint_error('BEN_EXT_DATA_ELMT_PK');

112: <> ben_xel_shd.g_old_rec.ext_data_elmt_id) then
113: --
114: -- raise error as PK has changed
115: --
116: ben_xel_shd.constraint_error('BEN_EXT_DATA_ELMT_PK');
117: --
118: elsif not l_api_updating then
119: --
120: -- check if PK is null

Line 126: ben_xel_shd.constraint_error('BEN_EXT_DATA_ELMT_PK');

122: if p_ext_data_elmt_id is not null then
123: --
124: -- raise error as PK is not null
125: --
126: ben_xel_shd.constraint_error('BEN_EXT_DATA_ELMT_PK');
127: --
128: end if;
129: --
130: end if;

Line 183: l_api_updating := ben_xel_shd.api_updating

179: Begin
180: --
181: hr_utility.set_location('Entering:'||l_proc, 5);
182: --
183: l_api_updating := ben_xel_shd.api_updating
184: (p_ext_data_elmt_id => p_ext_data_elmt_id,
185: p_object_version_number => p_object_version_number);
186: --
187: if (l_api_updating

Line 189: <> nvl(ben_xel_shd.g_old_rec.frmt_mask_cd,hr_api.g_varchar2)

185: p_object_version_number => p_object_version_number);
186: --
187: if (l_api_updating
188: and p_frmt_mask_cd
189: <> nvl(ben_xel_shd.g_old_rec.frmt_mask_cd,hr_api.g_varchar2)
190: or not l_api_updating)
191: and p_frmt_mask_cd is not null then
192: --
193: -- check if value of lookup falls within lookup type.

Line 331: l_api_updating := ben_xel_shd.api_updating

327: Begin
328: --
329: hr_utility.set_location('Entering:'||l_proc, 5);
330: --
331: l_api_updating := ben_xel_shd.api_updating
332: (p_ext_data_elmt_id => p_ext_data_elmt_id,
333: p_object_version_number => p_object_version_number);
334: --
335: if (l_api_updating

Line 337: <> ben_xel_shd.g_old_rec.data_elmt_rl

333: p_object_version_number => p_object_version_number);
334: --
335: if (l_api_updating
336: and nvl(p_data_elmt_rl,hr_api.g_number)
337: <> ben_xel_shd.g_old_rec.data_elmt_rl
338: or not l_api_updating)
339: and p_data_elmt_rl is not null then
340: --
341: -- check if value of formula rule is valid.

Line 519: l_api_updating := ben_xel_shd.api_updating

515: Begin
516: --
517: hr_utility.set_location('Entering:'||l_proc, 5);
518: --
519: l_api_updating := ben_xel_shd.api_updating
520: (p_ext_data_elmt_id => p_ext_data_elmt_id,
521: p_object_version_number => p_object_version_number);
522: --
523: if (l_api_updating

Line 524: and ( ( p_data_elmt_typ_cd <> nvl(ben_xel_shd.g_old_rec.data_elmt_typ_cd,hr_api.g_varchar2))

520: (p_ext_data_elmt_id => p_ext_data_elmt_id,
521: p_object_version_number => p_object_version_number);
522: --
523: if (l_api_updating
524: and ( ( p_data_elmt_typ_cd <> nvl(ben_xel_shd.g_old_rec.data_elmt_typ_cd,hr_api.g_varchar2))
525: or( nvl(p_string_val,hr_api.g_varchar2) <> nvl(ben_xel_shd.g_old_rec.string_val,hr_api.g_varchar2))
526: or( nvl(p_max_length_num,hr_api.g_number) <> nvl(ben_xel_shd.g_old_rec.max_length_num,hr_api.g_number))
527: or( nvl(p_data_elmt_rl,hr_api.g_number) <> nvl(ben_xel_shd.g_old_rec.data_elmt_rl,hr_api.g_number))
528: or( nvl(p_ttl_fnctn_cd,hr_api.g_varchar2) <> nvl(ben_xel_shd.g_old_rec.ttl_fnctn_cd,hr_api.g_varchar2))

Line 525: or( nvl(p_string_val,hr_api.g_varchar2) <> nvl(ben_xel_shd.g_old_rec.string_val,hr_api.g_varchar2))

521: p_object_version_number => p_object_version_number);
522: --
523: if (l_api_updating
524: and ( ( p_data_elmt_typ_cd <> nvl(ben_xel_shd.g_old_rec.data_elmt_typ_cd,hr_api.g_varchar2))
525: or( nvl(p_string_val,hr_api.g_varchar2) <> nvl(ben_xel_shd.g_old_rec.string_val,hr_api.g_varchar2))
526: or( nvl(p_max_length_num,hr_api.g_number) <> nvl(ben_xel_shd.g_old_rec.max_length_num,hr_api.g_number))
527: or( nvl(p_data_elmt_rl,hr_api.g_number) <> nvl(ben_xel_shd.g_old_rec.data_elmt_rl,hr_api.g_number))
528: or( nvl(p_ttl_fnctn_cd,hr_api.g_varchar2) <> nvl(ben_xel_shd.g_old_rec.ttl_fnctn_cd,hr_api.g_varchar2))
529: or( nvl(p_defined_balance_id,hr_api.g_number) <> nvl(ben_xel_shd.g_old_rec.defined_balance_id,hr_api.g_number))

Line 526: or( nvl(p_max_length_num,hr_api.g_number) <> nvl(ben_xel_shd.g_old_rec.max_length_num,hr_api.g_number))

522: --
523: if (l_api_updating
524: and ( ( p_data_elmt_typ_cd <> nvl(ben_xel_shd.g_old_rec.data_elmt_typ_cd,hr_api.g_varchar2))
525: or( nvl(p_string_val,hr_api.g_varchar2) <> nvl(ben_xel_shd.g_old_rec.string_val,hr_api.g_varchar2))
526: or( nvl(p_max_length_num,hr_api.g_number) <> nvl(ben_xel_shd.g_old_rec.max_length_num,hr_api.g_number))
527: or( nvl(p_data_elmt_rl,hr_api.g_number) <> nvl(ben_xel_shd.g_old_rec.data_elmt_rl,hr_api.g_number))
528: or( nvl(p_ttl_fnctn_cd,hr_api.g_varchar2) <> nvl(ben_xel_shd.g_old_rec.ttl_fnctn_cd,hr_api.g_varchar2))
529: or( nvl(p_defined_balance_id,hr_api.g_number) <> nvl(ben_xel_shd.g_old_rec.defined_balance_id,hr_api.g_number))
530: )

Line 527: or( nvl(p_data_elmt_rl,hr_api.g_number) <> nvl(ben_xel_shd.g_old_rec.data_elmt_rl,hr_api.g_number))

523: if (l_api_updating
524: and ( ( p_data_elmt_typ_cd <> nvl(ben_xel_shd.g_old_rec.data_elmt_typ_cd,hr_api.g_varchar2))
525: or( nvl(p_string_val,hr_api.g_varchar2) <> nvl(ben_xel_shd.g_old_rec.string_val,hr_api.g_varchar2))
526: or( nvl(p_max_length_num,hr_api.g_number) <> nvl(ben_xel_shd.g_old_rec.max_length_num,hr_api.g_number))
527: or( nvl(p_data_elmt_rl,hr_api.g_number) <> nvl(ben_xel_shd.g_old_rec.data_elmt_rl,hr_api.g_number))
528: or( nvl(p_ttl_fnctn_cd,hr_api.g_varchar2) <> nvl(ben_xel_shd.g_old_rec.ttl_fnctn_cd,hr_api.g_varchar2))
529: or( nvl(p_defined_balance_id,hr_api.g_number) <> nvl(ben_xel_shd.g_old_rec.defined_balance_id,hr_api.g_number))
530: )
531: or not l_api_updating)

Line 528: or( nvl(p_ttl_fnctn_cd,hr_api.g_varchar2) <> nvl(ben_xel_shd.g_old_rec.ttl_fnctn_cd,hr_api.g_varchar2))

524: and ( ( p_data_elmt_typ_cd <> nvl(ben_xel_shd.g_old_rec.data_elmt_typ_cd,hr_api.g_varchar2))
525: or( nvl(p_string_val,hr_api.g_varchar2) <> nvl(ben_xel_shd.g_old_rec.string_val,hr_api.g_varchar2))
526: or( nvl(p_max_length_num,hr_api.g_number) <> nvl(ben_xel_shd.g_old_rec.max_length_num,hr_api.g_number))
527: or( nvl(p_data_elmt_rl,hr_api.g_number) <> nvl(ben_xel_shd.g_old_rec.data_elmt_rl,hr_api.g_number))
528: or( nvl(p_ttl_fnctn_cd,hr_api.g_varchar2) <> nvl(ben_xel_shd.g_old_rec.ttl_fnctn_cd,hr_api.g_varchar2))
529: or( nvl(p_defined_balance_id,hr_api.g_number) <> nvl(ben_xel_shd.g_old_rec.defined_balance_id,hr_api.g_number))
530: )
531: or not l_api_updating)
532: and p_data_elmt_typ_cd is not null then

Line 529: or( nvl(p_defined_balance_id,hr_api.g_number) <> nvl(ben_xel_shd.g_old_rec.defined_balance_id,hr_api.g_number))

525: or( nvl(p_string_val,hr_api.g_varchar2) <> nvl(ben_xel_shd.g_old_rec.string_val,hr_api.g_varchar2))
526: or( nvl(p_max_length_num,hr_api.g_number) <> nvl(ben_xel_shd.g_old_rec.max_length_num,hr_api.g_number))
527: or( nvl(p_data_elmt_rl,hr_api.g_number) <> nvl(ben_xel_shd.g_old_rec.data_elmt_rl,hr_api.g_number))
528: or( nvl(p_ttl_fnctn_cd,hr_api.g_varchar2) <> nvl(ben_xel_shd.g_old_rec.ttl_fnctn_cd,hr_api.g_varchar2))
529: or( nvl(p_defined_balance_id,hr_api.g_number) <> nvl(ben_xel_shd.g_old_rec.defined_balance_id,hr_api.g_number))
530: )
531: or not l_api_updating)
532: and p_data_elmt_typ_cd is not null then
533: --

Line 536: hr_utility.set_location('update mode :' || p_string_val ||' '|| ben_xel_shd.g_old_rec.string_val, 5);

532: and p_data_elmt_typ_cd is not null then
533: --
534: -- check if value of lookup falls within lookup type.
535: --
536: hr_utility.set_location('update mode :' || p_string_val ||' '|| ben_xel_shd.g_old_rec.string_val, 5);
537: if p_business_group_id is not null then
538: if hr_api.not_exists_in_hr_lookups
539: (p_lookup_type => 'BEN_EXT_DATA_ELMT_TYP',
540: p_lookup_code => p_data_elmt_typ_cd,

Line 651: l_api_updating := ben_xel_shd.api_updating

647: Begin
648: --
649: hr_utility.set_location('Entering:'||l_proc, 5);
650: --
651: l_api_updating := ben_xel_shd.api_updating
652: (p_ext_data_elmt_id => p_ext_data_elmt_id,
653: p_object_version_number => p_object_version_number);
654: --
655: if (l_api_updating

Line 657: <> nvl(ben_xel_shd.g_old_rec.just_cd,hr_api.g_varchar2)

653: p_object_version_number => p_object_version_number);
654: --
655: if (l_api_updating
656: and p_just_cd
657: <> nvl(ben_xel_shd.g_old_rec.just_cd,hr_api.g_varchar2)
658: or not l_api_updating)
659: and p_just_cd is not null then
660: --
661: -- check if value of lookup falls within lookup type.

Line 748: l_api_updating := ben_xel_shd.api_updating

744: Begin
745: --
746: hr_utility.set_location('Entering:'||l_proc, 5);
747: --
748: l_api_updating := ben_xel_shd.api_updating
749: (p_ext_data_elmt_id => p_ext_data_elmt_id,
750: p_object_version_number => p_object_version_number);
751: --
752: if (l_api_updating

Line 754: <> nvl(ben_xel_shd.g_old_rec.defined_balance_id,hr_api.g_number)

750: p_object_version_number => p_object_version_number);
751: --
752: if (l_api_updating
753: and p_defined_balance_id
754: <> nvl(ben_xel_shd.g_old_rec.defined_balance_id,hr_api.g_number)
755: or not l_api_updating)
756: and p_defined_balance_id is not null then
757: --
758: -- check if value of lookup falls within lookup type.

Line 919: l_api_updating := ben_xel_shd.api_updating

915: --
916: Begin
917: hr_utility.set_location('Entering:'||l_proc, 5);
918: --
919: l_api_updating := ben_xel_shd.api_updating
920: (p_ext_data_elmt_id => p_ext_data_elmt_id,
921: p_object_version_number => p_object_version_number);
922: --
923: hr_utility.set_location('p_ttl_fnctn_cd:'||p_ttl_fnctn_cd, 15);

Line 926: <> nvl(ben_xel_shd.g_old_rec.ttl_fnctn_cd,hr_api.g_varchar2)

922: --
923: hr_utility.set_location('p_ttl_fnctn_cd:'||p_ttl_fnctn_cd, 15);
924: if (l_api_updating
925: and nvl(p_ttl_fnctn_cd,hr_api.g_varchar2)
926: <> nvl(ben_xel_shd.g_old_rec.ttl_fnctn_cd,hr_api.g_varchar2)
927: or not l_api_updating) then
928: --
929: if p_ttl_fnctn_cd = 'CNT' then
930: if p_ttl_sum_ext_data_elmt_id is not null then

Line 975: <> nvl(ben_xel_shd.g_old_rec.ttl_sum_ext_data_elmt_id,hr_api.g_number)

971: end if;
972: --
973: if (l_api_updating
974: and nvl(p_ttl_sum_ext_data_elmt_id,hr_api.g_number)
975: <> nvl(ben_xel_shd.g_old_rec.ttl_sum_ext_data_elmt_id,hr_api.g_number)
976: or not l_api_updating) then
977: if p_ttl_sum_ext_data_elmt_id is not null and p_ttl_fnctn_cd <> 'SUM' then
978: fnd_message.set_name('BEN','BEN_92200_CHK_SUM_DATA_ELMT');
979: fnd_message.raise_error;

Line 990: <> nvl(ben_xel_shd.g_old_rec.ttl_cond_ext_data_elmt_id,hr_api.g_number)

986: hr_utility.set_location('p_ttl_fnctn_cd:'||p_ttl_fnctn_cd, 15);
987: hr_utility.set_location('p_ttl_cond_ext_data_elmt_id:'||p_ttl_cond_ext_data_elmt_id, 15);
988: if (l_api_updating
989: and nvl(p_ttl_cond_ext_data_elmt_id,hr_api.g_number)
990: <> nvl(ben_xel_shd.g_old_rec.ttl_cond_ext_data_elmt_id,hr_api.g_number)
991: or not l_api_updating) then
992: --
993: if p_ttl_cond_ext_data_elmt_id is not null then
994: if p_ttl_fnctn_cd is null then

Line 1054: Procedure insert_validate(p_rec in ben_xel_shd.g_rec_type

1050: --
1051: -- ----------------------------------------------------------------------------
1052: -- |---------------------------< insert_validate >----------------------------|
1053: -- ----------------------------------------------------------------------------
1054: Procedure insert_validate(p_rec in ben_xel_shd.g_rec_type
1055: ,p_effective_date in date) is
1056: --
1057: l_proc varchar2(72) := g_package||'insert_validate';
1058:

Line 1163: Procedure update_validate(p_rec in ben_xel_shd.g_rec_type

1159: --
1160: -- ----------------------------------------------------------------------------
1161: -- |---------------------------< update_validate >----------------------------|
1162: -- ----------------------------------------------------------------------------
1163: Procedure update_validate(p_rec in ben_xel_shd.g_rec_type
1164: ,p_effective_date in date) is
1165: --
1166: l_proc varchar2(72) := g_package||'update_validate';
1167:

Line 1273: Procedure delete_validate(p_rec in ben_xel_shd.g_rec_type

1269: --
1270: -- ----------------------------------------------------------------------------
1271: -- |---------------------------< delete_validate >----------------------------|
1272: -- ----------------------------------------------------------------------------
1273: Procedure delete_validate(p_rec in ben_xel_shd.g_rec_type
1274: ,p_effective_date in date) is
1275: --
1276: l_proc varchar2(72) := g_package||'delete_validate';
1277:

Line 1294: IF ben_xel_shd.g_old_rec.business_group_id IS NOT NULL THEN

1290: -- from p_rec always instead get it for the business group
1291: --
1292: -- Get the legislation code for this business group
1293:
1294: IF ben_xel_shd.g_old_rec.business_group_id IS NOT NULL THEN
1295: l_legislation_code := hr_api.return_legislation_code (
1296: p_business_group_id=> ben_xel_shd.g_old_rec.business_group_id
1297: );
1298: ELSE

Line 1296: p_business_group_id=> ben_xel_shd.g_old_rec.business_group_id

1292: -- Get the legislation code for this business group
1293:
1294: IF ben_xel_shd.g_old_rec.business_group_id IS NOT NULL THEN
1295: l_legislation_code := hr_api.return_legislation_code (
1296: p_business_group_id=> ben_xel_shd.g_old_rec.business_group_id
1297: );
1298: ELSE
1299: l_legislation_code := ben_xel_shd.g_old_rec.legislation_code;
1300: END IF; -- End if of bg not null check ...

Line 1299: l_legislation_code := ben_xel_shd.g_old_rec.legislation_code;

1295: l_legislation_code := hr_api.return_legislation_code (
1296: p_business_group_id=> ben_xel_shd.g_old_rec.business_group_id
1297: );
1298: ELSE
1299: l_legislation_code := ben_xel_shd.g_old_rec.legislation_code;
1300: END IF; -- End if of bg not null check ...
1301:
1302: chk_startup_action(False
1303: ,ben_xel_shd.g_old_rec.business_group_id

Line 1303: ,ben_xel_shd.g_old_rec.business_group_id

1299: l_legislation_code := ben_xel_shd.g_old_rec.legislation_code;
1300: END IF; -- End if of bg not null check ...
1301:
1302: chk_startup_action(False
1303: ,ben_xel_shd.g_old_rec.business_group_id
1304: ,l_legislation_code);
1305: -- ,ben_xel_shd.g_old_rec.legislation_code);
1306: --
1307: chk_delete_allowed(p_ext_data_elmt_id => p_rec.ext_data_elmt_id);

Line 1305: -- ,ben_xel_shd.g_old_rec.legislation_code);

1301:
1302: chk_startup_action(False
1303: ,ben_xel_shd.g_old_rec.business_group_id
1304: ,l_legislation_code);
1305: -- ,ben_xel_shd.g_old_rec.legislation_code);
1306: --
1307: chk_delete_allowed(p_ext_data_elmt_id => p_rec.ext_data_elmt_id);
1308: --
1309: hr_utility.set_location(' Leaving:'||l_proc, 10);