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_XWC_BUS dependencies on BEN_XWC_SHD

Line 155: l_api_updating := ben_xwc_shd.api_updating

151: Begin
152: --
153: hr_utility.set_location('Entering:'||l_proc, 5);
154: --
155: l_api_updating := ben_xwc_shd.api_updating
156: (p_ext_where_clause_id => p_ext_where_clause_id,
157: p_object_version_number => p_object_version_number);
158: --
159: if (l_api_updating

Line 161: <> ben_xwc_shd.g_old_rec.ext_where_clause_id) then

157: p_object_version_number => p_object_version_number);
158: --
159: if (l_api_updating
160: and nvl(p_ext_where_clause_id,hr_api.g_number)
161: <> ben_xwc_shd.g_old_rec.ext_where_clause_id) then
162: --
163: -- raise error as PK has changed
164: --
165: ben_xwc_shd.constraint_error('BEN_EXT_WHERE_CLAUSE_PK');

Line 165: ben_xwc_shd.constraint_error('BEN_EXT_WHERE_CLAUSE_PK');

161: <> ben_xwc_shd.g_old_rec.ext_where_clause_id) then
162: --
163: -- raise error as PK has changed
164: --
165: ben_xwc_shd.constraint_error('BEN_EXT_WHERE_CLAUSE_PK');
166: --
167: elsif not l_api_updating then
168: --
169: -- check if PK is null

Line 175: ben_xwc_shd.constraint_error('BEN_EXT_WHERE_CLAUSE_PK');

171: if p_ext_where_clause_id is not null then
172: --
173: -- raise error as PK is not null
174: --
175: ben_xwc_shd.constraint_error('BEN_EXT_WHERE_CLAUSE_PK');
176: --
177: end if;
178: --
179: end if;

Line 227: l_api_updating := ben_xwc_shd.api_updating

223: Begin
224: --
225: hr_utility.set_location('Entering:'||l_proc,5);
226: --
227: l_api_updating := ben_xwc_shd.api_updating
228: (p_ext_where_clause_id => p_ext_where_clause_id,
229: p_object_version_number => p_object_version_number);
230: --
231: if (l_api_updating

Line 233: <> nvl(ben_xwc_shd.g_old_rec.cond_ext_data_elmt_in_rcd_id,hr_api.g_number)

229: p_object_version_number => p_object_version_number);
230: --
231: if (l_api_updating
232: and nvl(p_cond_ext_data_elmt_in_rcd_id,hr_api.g_number)
233: <> nvl(ben_xwc_shd.g_old_rec.cond_ext_data_elmt_in_rcd_id,hr_api.g_number)
234: or not l_api_updating) and
235: p_cond_ext_data_elmt_in_rcd_id is not null then
236: --
237: -- check if cond_ext_data_elmt_in_rcd_id value exists in ben_ext_data_elmt_in_rcd table

Line 249: ben_xwc_shd.constraint_error('BEN_EXT_WHERE_CLAUSE_FK6');

245: --
246: -- raise error as FK does not relate to PK in ben_ext_data_elmt_in_rcd
247: -- table.
248: --
249: ben_xwc_shd.constraint_error('BEN_EXT_WHERE_CLAUSE_FK6');
250: --
251: end if;
252: --
253: close c1;

Line 303: l_api_updating := ben_xwc_shd.api_updating

299: Begin
300: --
301: hr_utility.set_location('Entering:'||l_proc,5);
302: --
303: l_api_updating := ben_xwc_shd.api_updating
304: (p_ext_where_clause_id => p_ext_where_clause_id,
305: p_object_version_number => p_object_version_number);
306: --
307: if (l_api_updating

Line 309: <> nvl(ben_xwc_shd.g_old_rec.ext_rcd_in_file_id,hr_api.g_number)

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

Line 325: ben_xwc_shd.constraint_error('BEN_EXT_WHERE_CLAUSE_FK4');

321: --
322: -- raise error as FK does not relate to PK in ben_ext_rcd_in_file
323: -- table.
324: --
325: ben_xwc_shd.constraint_error('BEN_EXT_WHERE_CLAUSE_FK4');
326: --
327: end if;
328: --
329: close c1;

Line 379: l_api_updating := ben_xwc_shd.api_updating

375: Begin
376: --
377: hr_utility.set_location('Entering:'||l_proc,5);
378: --
379: l_api_updating := ben_xwc_shd.api_updating
380: (p_ext_where_clause_id => p_ext_where_clause_id,
381: p_object_version_number => p_object_version_number);
382: --
383: if (l_api_updating

Line 385: <> nvl(ben_xwc_shd.g_old_rec.ext_data_elmt_in_rcd_id,hr_api.g_number)

381: p_object_version_number => p_object_version_number);
382: --
383: if (l_api_updating
384: and nvl(p_ext_data_elmt_in_rcd_id,hr_api.g_number)
385: <> nvl(ben_xwc_shd.g_old_rec.ext_data_elmt_in_rcd_id,hr_api.g_number)
386: or not l_api_updating) and
387: p_ext_data_elmt_in_rcd_id is not null then
388: --
389: -- check if ext_data_elmt_in_rcd_id value exists in ben_ext_data_elmt_in_rcd table

Line 401: ben_xwc_shd.constraint_error('BEN_EXT_WHERE_CLAUSE_FK3');

397: --
398: -- raise error as FK does not relate to PK in ben_ext_data_elmt_in_rcd
399: -- table.
400: --
401: ben_xwc_shd.constraint_error('BEN_EXT_WHERE_CLAUSE_FK3');
402: --
403: end if;
404: --
405: close c1;

Line 455: l_api_updating := ben_xwc_shd.api_updating

451: Begin
452: --
453: hr_utility.set_location('Entering:'||l_proc,5);
454: --
455: l_api_updating := ben_xwc_shd.api_updating
456: (p_ext_where_clause_id => p_ext_where_clause_id,
457: p_object_version_number => p_object_version_number);
458: --
459: if (l_api_updating

Line 461: <> nvl(ben_xwc_shd.g_old_rec.cond_ext_data_elmt_id,hr_api.g_number)

457: p_object_version_number => p_object_version_number);
458: --
459: if (l_api_updating
460: and nvl(p_cond_ext_data_elmt_id,hr_api.g_number)
461: <> nvl(ben_xwc_shd.g_old_rec.cond_ext_data_elmt_id,hr_api.g_number)
462: or not l_api_updating) and
463: p_cond_ext_data_elmt_id is not null then
464: --
465: -- check if cond_ext_data_elmt_id value exists in ben_ext_data_elmt table

Line 477: ben_xwc_shd.constraint_error('BEN_EXT_WHERE_CLAUSE_FK2');

473: --
474: -- raise error as FK does not relate to PK in ben_ext_data_elmt
475: -- table.
476: --
477: ben_xwc_shd.constraint_error('BEN_EXT_WHERE_CLAUSE_FK2');
478: --
479: end if;
480: --
481: close c1;

Line 531: l_api_updating := ben_xwc_shd.api_updating

527: Begin
528: --
529: hr_utility.set_location('Entering:'||l_proc,5);
530: --
531: l_api_updating := ben_xwc_shd.api_updating
532: (p_ext_where_clause_id => p_ext_where_clause_id,
533: p_object_version_number => p_object_version_number);
534: --
535: if (l_api_updating

Line 537: <> nvl(ben_xwc_shd.g_old_rec.ext_data_elmt_id,hr_api.g_number)

533: p_object_version_number => p_object_version_number);
534: --
535: if (l_api_updating
536: and nvl(p_ext_data_elmt_id,hr_api.g_number)
537: <> nvl(ben_xwc_shd.g_old_rec.ext_data_elmt_id,hr_api.g_number)
538: or not l_api_updating) and
539: p_ext_data_elmt_id is not null then
540: --
541: -- check if ext_data_elmt_id value exists in ben_ext_data_elmt table

Line 553: ben_xwc_shd.constraint_error('BEN_EXT_WHERE_CLAUSE_FK1');

549: --
550: -- raise error as FK does not relate to PK in ben_ext_data_elmt
551: -- table.
552: --
553: ben_xwc_shd.constraint_error('BEN_EXT_WHERE_CLAUSE_FK1');
554: --
555: end if;
556: --
557: close c1;

Line 604: l_api_updating := ben_xwc_shd.api_updating

600: Begin
601: --
602: hr_utility.set_location('Entering:'||l_proc, 5);
603: --
604: l_api_updating := ben_xwc_shd.api_updating
605: (p_ext_where_clause_id => p_ext_where_clause_id,
606: p_object_version_number => p_object_version_number);
607: --
608: if (l_api_updating

Line 610: <> nvl(ben_xwc_shd.g_old_rec.oper_cd,hr_api.g_varchar2)

606: p_object_version_number => p_object_version_number);
607: --
608: if (l_api_updating
609: and p_oper_cd
610: <> nvl(ben_xwc_shd.g_old_rec.oper_cd,hr_api.g_varchar2)
611: or not l_api_updating)
612: and p_oper_cd is not null then
613: --
614: -- check if value of lookup falls within lookup type.

Line 693: l_api_updating := ben_xwc_shd.api_updating

689: Begin
690: --
691: hr_utility.set_location('Entering:'||l_proc, 5);
692: --
693: l_api_updating := ben_xwc_shd.api_updating
694: (p_ext_where_clause_id => p_ext_where_clause_id,
695: p_object_version_number => p_object_version_number);
696: --
697: if (l_api_updating

Line 699: <> nvl(ben_xwc_shd.g_old_rec.and_or_cd,hr_api.g_varchar2)

695: p_object_version_number => p_object_version_number);
696: --
697: if (l_api_updating
698: and p_and_or_cd
699: <> nvl(ben_xwc_shd.g_old_rec.and_or_cd,hr_api.g_varchar2)
700: or not l_api_updating)
701: and p_and_or_cd is not null then
702: --
703: -- check if value of lookup falls within lookup type.

Line 785: l_api_updating := ben_xwc_shd.api_updating

781: Begin
782: --
783: hr_utility.set_location('Entering:'||l_proc, 5);
784: --
785: l_api_updating := ben_xwc_shd.api_updating
786: (p_ext_where_clause_id => p_ext_where_clause_id,
787: p_object_version_number => p_object_version_number);
788: --
789: if (

Line 790: (l_api_updating and (p_val <> nvl(ben_xwc_shd.g_old_rec.val,hr_api.g_varchar2))) or

786: (p_ext_where_clause_id => p_ext_where_clause_id,
787: p_object_version_number => p_object_version_number);
788: --
789: if (
790: (l_api_updating and (p_val <> nvl(ben_xwc_shd.g_old_rec.val,hr_api.g_varchar2))) or
791: (l_api_updating and (p_oper_cd <> nvl(ben_xwc_shd.g_old_rec.oper_cd,hr_api.g_varchar2))) or
792: not l_api_updating
793: ) then
794:

Line 791: (l_api_updating and (p_oper_cd <> nvl(ben_xwc_shd.g_old_rec.oper_cd,hr_api.g_varchar2))) or

787: p_object_version_number => p_object_version_number);
788: --
789: if (
790: (l_api_updating and (p_val <> nvl(ben_xwc_shd.g_old_rec.val,hr_api.g_varchar2))) or
791: (l_api_updating and (p_oper_cd <> nvl(ben_xwc_shd.g_old_rec.oper_cd,hr_api.g_varchar2))) or
792: not l_api_updating
793: ) then
794:
795:

Line 923: l_api_updating := ben_xwc_shd.api_updating

919: l_dummy number ;
920: Begin
921: --
922: -- bug 4658335, check only when seq num is changed. or inserting
923: l_api_updating := ben_xwc_shd.api_updating
924: (p_ext_where_clause_id => p_ext_where_clause_id,
925: p_object_version_number => p_object_version_number);
926: --
927: If (

Line 928: (l_api_updating and (p_seq_num <> nvl(ben_xwc_shd.g_old_rec.seq_num,hr_api.g_number))) or

924: (p_ext_where_clause_id => p_ext_where_clause_id,
925: p_object_version_number => p_object_version_number);
926: --
927: If (
928: (l_api_updating and (p_seq_num <> nvl(ben_xwc_shd.g_old_rec.seq_num,hr_api.g_number))) or
929: not l_api_updating
930: ) then
931: Open c_xwc;
932: --

Line 949: Procedure insert_validate(p_rec in ben_xwc_shd.g_rec_type

945:
946: -- ----------------------------------------------------------------------------
947: -- |---------------------------< insert_validate >----------------------------|
948: -- ----------------------------------------------------------------------------
949: Procedure insert_validate(p_rec in ben_xwc_shd.g_rec_type
950: ,p_effective_date in date) is
951: --
952: l_proc varchar2(72) := g_package||'insert_validate';
953: --

Line 1033: Procedure update_validate(p_rec in ben_xwc_shd.g_rec_type

1029: --
1030: -- ----------------------------------------------------------------------------
1031: -- |---------------------------< update_validate >----------------------------|
1032: -- ----------------------------------------------------------------------------
1033: Procedure update_validate(p_rec in ben_xwc_shd.g_rec_type
1034: ,p_effective_date in date) is
1035: --
1036: l_proc varchar2(72) := g_package||'update_validate';
1037: --

Line 1117: Procedure delete_validate(p_rec in ben_xwc_shd.g_rec_type

1113: --
1114: -- ----------------------------------------------------------------------------
1115: -- |---------------------------< delete_validate >----------------------------|
1116: -- ----------------------------------------------------------------------------
1117: Procedure delete_validate(p_rec in ben_xwc_shd.g_rec_type
1118: ,p_effective_date in date) is
1119: --
1120: l_proc varchar2(72) := g_package||'delete_validate';
1121: --

Line 1128: ,ben_xwc_shd.g_old_rec.business_group_id

1124: --
1125: -- Call all supporting business operations
1126: --
1127: chk_startup_action(False
1128: ,ben_xwc_shd.g_old_rec.business_group_id
1129: ,ben_xwc_shd.g_old_rec.legislation_code);
1130: --
1131: hr_utility.set_location(' Leaving:'||l_proc, 10);
1132: End delete_validate;

Line 1129: ,ben_xwc_shd.g_old_rec.legislation_code);

1125: -- Call all supporting business operations
1126: --
1127: chk_startup_action(False
1128: ,ben_xwc_shd.g_old_rec.business_group_id
1129: ,ben_xwc_shd.g_old_rec.legislation_code);
1130: --
1131: hr_utility.set_location(' Leaving:'||l_proc, 10);
1132: End delete_validate;
1133: --