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 HR_API

Line 87: hr_api.mandatory_arg_error

83: hr_utility.set_location('Entering:'|| l_proc, 10);
84: --
85: -- Ensure that all the mandatory parameter are not null
86: --
87: hr_api.mandatory_arg_error
88: (p_api_name => l_proc
89: ,p_argument => 'ext_where_clause_id'
90: ,p_argument_value => p_ext_where_clause_id
91: );

Line 110: hr_api.set_security_group_id

106: close csr_sec_grp;
107: --
108: -- Set the security_group_id in CLIENT_INFO
109: --
110: hr_api.set_security_group_id
111: (p_security_group_id => l_security_group_id
112: );
113: --
114: hr_utility.set_location(' Leaving:'|| l_proc, 20);

Line 160: and nvl(p_ext_where_clause_id,hr_api.g_number)

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
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: --

Line 232: and nvl(p_cond_ext_data_elmt_in_rcd_id,hr_api.g_number)

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
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: --

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 308: and nvl(p_ext_rcd_in_file_id,hr_api.g_number)

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
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: --

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 384: and nvl(p_ext_data_elmt_in_rcd_id,hr_api.g_number)

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
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: --

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 460: and nvl(p_cond_ext_data_elmt_id,hr_api.g_number)

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
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: --

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 536: and nvl(p_ext_data_elmt_id,hr_api.g_number)

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
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: --

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 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 618: if hr_api.not_exists_in_hr_lookups

614: -- check if value of lookup falls within lookup type.
615: --
616: if p_business_group_id is not null then
617: /* BG is set, so use the existing call, with no modifications*/
618: if hr_api.not_exists_in_hr_lookups
619: (p_lookup_type => 'BEN_EXT_OPER',
620: p_lookup_code => p_oper_cd,
621: p_effective_date => p_effective_date) then
622: --

Line 633: if hr_api.not_exists_in_hrstanlookups

629: --
630: end if;
631: else
632: /* BG is null, so alternative call is required */
633: if hr_api.not_exists_in_hrstanlookups
634: (p_lookup_type => 'BEN_EXT_OPER',
635: p_lookup_code => p_oper_cd,
636: p_effective_date => p_effective_date) then
637: --

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 707: if hr_api.not_exists_in_hr_lookups

703: -- check if value of lookup falls within lookup type.
704: --
705: if p_business_group_id is not null then
706: /* BG is set, so use the existing call, with no modifications*/
707: if hr_api.not_exists_in_hr_lookups
708: (p_lookup_type => 'BEN_EXT_AND_OR',
709: p_lookup_code => p_and_or_cd,
710: p_effective_date => p_effective_date) then
711: --

Line 722: if hr_api.not_exists_in_hrstanlookups

718: --
719: end if;
720: else
721: /* BG is null, so alternative call is required */
722: if hr_api.not_exists_in_hrstanlookups
723: (p_lookup_type => 'BEN_EXT_AND_OR',
724: p_lookup_code => p_and_or_cd,
725: p_effective_date => p_effective_date) then
726: --

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 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 964: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate bus_grp

960: chk_startup_action(True
961: ,p_rec.business_group_id
962: ,p_rec.legislation_code);
963: IF hr_startup_data_api_support.g_startup_mode NOT IN ('GENERIC','STARTUP') THEN
964: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate bus_grp
965: END IF;
966: --
967: chk_ext_where_clause_id
968: (p_ext_where_clause_id => p_rec.ext_where_clause_id,

Line 1048: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate bus_grp

1044: chk_startup_action(False
1045: ,p_rec.business_group_id
1046: ,p_rec.legislation_code);
1047: IF hr_startup_data_api_support.g_startup_mode NOT IN ('GENERIC','STARTUP') THEN
1048: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate bus_grp
1049: END IF;
1050: --
1051: chk_ext_where_clause_id
1052: (p_ext_where_clause_id => p_rec.ext_where_clause_id,

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

1158: hr_utility.set_location('Entering:'|| l_proc, 10);
1159: --
1160: -- Ensure that all the mandatory parameter are not null
1161: --
1162: hr_api.mandatory_arg_error(p_api_name => l_proc,
1163: p_argument => 'ext_where_clause_id',
1164: p_argument_value => p_ext_where_clause_id);
1165: --
1166: open csr_leg_code;