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

Line 1: Package Body HR_Api As

1: Package Body HR_Api As
2: /* $Header: hrapiapi.pkb 120.4.12010000.5 2009/03/26 12:32:26 nerao ship $ */
3: --
4: -- The following global variable is used by the return_commit_unit function.
5: --

Line 167: l_proc varchar2(72) := hr_api.g_package||'return_business_group_id';

163: (p_name in per_organization_units.name%TYPE)
164: Return per_organization_units.business_group_id%TYPE Is
165: --
166: l_business_group_id per_organization_units.business_group_id%TYPE;
167: l_proc varchar2(72) := hr_api.g_package||'return_business_group_id';
168: --
169: -- Note: This cursor statement should not require a distinct, as
170: -- business group names should be unique. It has been
171: -- included to allow use with development databases.

Line 210: l_proc varchar2(72) := hr_api.g_package||'return_lookup_code';

206: p_lookup_type in fnd_common_lookups.lookup_type%TYPE)
207: Return fnd_common_lookups.lookup_code%TYPE Is
208: --
209: l_lookup_code fnd_common_lookups.lookup_code%TYPE := null;
210: l_proc varchar2(72) := hr_api.g_package||'return_lookup_code';
211: l_argument varchar2(30);
212: --
213: Cursor Sel_Id Is
214: select hl.lookup_code

Line 283: l_proc varchar2(72) := hr_api.g_package||'validate_bus_grp_id';

279: l_column varchar2(70);
280: l_org_id number;
281: l_security_group_id number;
282: l_legislation_code varchar2(30);
283: l_proc varchar2(72) := hr_api.g_package||'validate_bus_grp_id';
284: --
285: Cursor Sel_Bus Is
286: select inf.org_information9
287: , inf.org_information14

Line 333: hr_api.g_business_group_id := p_business_group_id;

329: -- business group. Setting the values here will save
330: -- another select when return_legislation_code is called
331: -- later on for the same business group.)
332: --
333: hr_api.g_business_group_id := p_business_group_id;
334: hr_api.g_legislation_code := l_legislation_code;
335: --
336: -- Call set_legislation_context to store the legislation_code
337: -- for the session in the 'LEG_CODE' namespace of the 'HR_SESSION_DATA'

Line 334: hr_api.g_legislation_code := l_legislation_code;

330: -- another select when return_legislation_code is called
331: -- later on for the same business group.)
332: --
333: hr_api.g_business_group_id := p_business_group_id;
334: hr_api.g_legislation_code := l_legislation_code;
335: --
336: -- Call set_legislation_context to store the legislation_code
337: -- for the session in the 'LEG_CODE' namespace of the 'HR_SESSION_DATA'
338: -- application context, for reference by HR_LOOKUPS.

Line 340: hr_api.set_legislation_context(l_legislation_code);

336: -- Call set_legislation_context to store the legislation_code
337: -- for the session in the 'LEG_CODE' namespace of the 'HR_SESSION_DATA'
338: -- application context, for reference by HR_LOOKUPS.
339: --
340: hr_api.set_legislation_context(l_legislation_code);
341: -- Initialize the session context for bug 8250782.
342: g_session_context := FND_GLOBAL.Get_Session_Context;
343: --
344: end if;

Line 354: l_proc varchar2(72) := hr_api.g_package||'strip_constraint_name';

350: --
351: Function strip_constraint_name(p_errmsg in varchar2)
352: Return varchar2 Is
353: --
354: l_proc varchar2(72) := hr_api.g_package||'strip_constraint_name';
355: l_pos1 number;
356: l_pos2 number;
357: l_pos3 number;
358: l_return_str varchar2(61);

Line 450: l_proc varchar2(72) := hr_api.g_package||'return_concat_kf_segments';

446: p_segment29 in varchar2 default null,
447: p_segment30 in varchar2 default null)
448: return varchar2 is
449: --
450: l_proc varchar2(72) := hr_api.g_package||'return_concat_kf_segments';
451: l_cat_str varchar2(1800);
452: l_error exception;
453: l_argn varchar2(30);
454: l_argv varchar2(60);

Line 547: hr_api.mandatory_arg_error

543: end rtn_del_str;
544: --
545: begin
546: --
547: hr_api.mandatory_arg_error
548: (p_api_name => l_proc,
549: p_argument => 'id_flex_num',
550: p_argument_value => p_id_flex_num);
551: --

Line 552: hr_api.mandatory_arg_error

548: (p_api_name => l_proc,
549: p_argument => 'id_flex_num',
550: p_argument_value => p_id_flex_num);
551: --
552: hr_api.mandatory_arg_error
553: (p_api_name => l_proc,
554: p_argument => 'application_id',
555: p_argument_value => p_application_id);
556: --

Line 557: hr_api.mandatory_arg_error

553: (p_api_name => l_proc,
554: p_argument => 'application_id',
555: p_argument_value => p_application_id);
556: --
557: hr_api.mandatory_arg_error
558: (p_api_name => l_proc,
559: p_argument => 'id_flex_code',
560: p_argument_value => p_id_flex_code);
561: --

Line 849: --hr_utility.set_location(hr_api.g_package||'not_exists_in_hr_lookups', 10);

845: end if;
846:
847:
848: -- DK 2002-11-08 PLSQLSTD
849: --hr_utility.set_location(hr_api.g_package||'not_exists_in_hr_lookups', 10);
850:
851:
852: --
853: open csr_hr_look;

Line 904: hr_utility.set_location(hr_api.g_package||'not_exists_in_leg_lookups', 10);

900: -- If the value is not known then go onto check against the
901: -- hr_lookups view. Just in case there has been a change to
902: -- the system defined lookup.
903: end if;
904: hr_utility.set_location(hr_api.g_package||'not_exists_in_leg_lookups', 10);
905: --
906: open csr_hr_leg_look;
907: fetch csr_hr_leg_look into l_exists;
908: if csr_hr_leg_look%notfound then

Line 957: hr_utility.set_location(hr_api.g_package||'not_exists_in_hrstanlookups', 10);

953: -- If the value is not known then go onto check against the
954: -- hr_lookups view. Just in case there has been a change to
955: -- the system defined lookup.
956: end if;
957: hr_utility.set_location(hr_api.g_package||'not_exists_in_hrstanlookups', 10);
958: --
959: open csr_hr_look;
960: fetch csr_hr_look into l_exists;
961: if csr_hr_look%notfound then

Line 1010: hr_utility.set_location(hr_api.g_package||'not_exists_in_fnd_lookups', 10);

1006: -- If the value is not known then go onto check against the
1007: -- hr_lookups view. Just in case there has been a change to
1008: -- the system defined lookup.
1009: end if;
1010: hr_utility.set_location(hr_api.g_package||'not_exists_in_fnd_lookups', 10);
1011: --
1012: open csr_fnd_look;
1013: fetch csr_fnd_look into l_exists;
1014: if csr_fnd_look%notfound then

Line 1163: l_proc varchar2(72) := hr_api.g_package||'cannot_find_prog_unit_error';

1159: --
1160: -- Local variables
1161: --
1162: l_hook_type varchar2(80);
1163: l_proc varchar2(72) := hr_api.g_package||'cannot_find_prog_unit_error';
1164: begin
1165: hr_utility.set_location(l_proc, 10);
1166: --
1167: -- Attempt to find the user description for the hook type.

Line 1209: hr_api.g_commit_unit_number := hr_api.g_commit_unit_number + 1;

1205: -- or the lock was obtained on a previous call to this function (4). If
1206: -- the lock has already been obtained, the commit unit cannot have
1207: -- changed, so number is not incremented.
1208: --
1209: hr_api.g_commit_unit_number := hr_api.g_commit_unit_number + 1;
1210: end if;
1211: --
1212: return hr_api.g_commit_unit_number;
1213: end return_commit_unit;

Line 1212: return hr_api.g_commit_unit_number;

1208: --
1209: hr_api.g_commit_unit_number := hr_api.g_commit_unit_number + 1;
1210: end if;
1211: --
1212: return hr_api.g_commit_unit_number;
1213: end return_commit_unit;
1214: --
1215: -- ----------------------------------------------------------------------------
1216: -- |--------------------------< validate_commit_unit >------------------------|

Line 1237: l_proc varchar2(72) := hr_api.g_package||'validate_commit_unit';

1233: --
1234: -- Local variables
1235: --
1236: l_hook_type varchar2(80);
1237: l_proc varchar2(72) := hr_api.g_package||'validate_commit_unit';
1238: begin
1239: hr_utility.set_location(l_proc, 10);
1240: --
1241: -- Attempt to find the user description for the hook type.

Line 1288: hr_api.g_call_cus_api_hooks := false;

1284: (p_mode in varchar2
1285: ) is
1286: begin
1287: if p_mode = 'DISABLE' then
1288: hr_api.g_call_cus_api_hooks := false;
1289: elsif p_mode = 'ENABLE' then
1290: hr_api.g_call_cus_api_hooks := true;
1291: else
1292: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

Line 1290: hr_api.g_call_cus_api_hooks := true;

1286: begin
1287: if p_mode = 'DISABLE' then
1288: hr_api.g_call_cus_api_hooks := false;
1289: elsif p_mode = 'ENABLE' then
1290: hr_api.g_call_cus_api_hooks := true;
1291: else
1292: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1293: hr_utility.set_message_token('PROCEDURE'
1294: ,hr_api.g_package||'customer_hooks'

Line 1294: ,hr_api.g_package||'customer_hooks'

1290: hr_api.g_call_cus_api_hooks := true;
1291: else
1292: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1293: hr_utility.set_message_token('PROCEDURE'
1294: ,hr_api.g_package||'customer_hooks'
1295: );
1296: hr_utility.set_message_token('STEP', '20');
1297: hr_utility.raise_error;
1298: end if;

Line 1310: hr_api.g_call_leg_api_hooks := false;

1306: (p_mode in varchar2
1307: ) is
1308: begin
1309: if p_mode = 'DISABLE' then
1310: hr_api.g_call_leg_api_hooks := false;
1311: elsif p_mode = 'ENABLE' then
1312: hr_api.g_call_leg_api_hooks := true;
1313: else
1314: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

Line 1312: hr_api.g_call_leg_api_hooks := true;

1308: begin
1309: if p_mode = 'DISABLE' then
1310: hr_api.g_call_leg_api_hooks := false;
1311: elsif p_mode = 'ENABLE' then
1312: hr_api.g_call_leg_api_hooks := true;
1313: else
1314: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1315: hr_utility.set_message_token('PROCEDURE', hr_api.g_package||'leg_hooks');
1316: hr_utility.set_message_token('STEP', '20');

Line 1315: hr_utility.set_message_token('PROCEDURE', hr_api.g_package||'leg_hooks');

1311: elsif p_mode = 'ENABLE' then
1312: hr_api.g_call_leg_api_hooks := true;
1313: else
1314: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1315: hr_utility.set_message_token('PROCEDURE', hr_api.g_package||'leg_hooks');
1316: hr_utility.set_message_token('STEP', '20');
1317: hr_utility.raise_error;
1318: end if;
1319: end legislation_hooks;

Line 1330: hr_api.g_call_app_api_hooks := false;

1326: (p_mode in varchar2
1327: ) is
1328: begin
1329: if p_mode = 'DISABLE' then
1330: hr_api.g_call_app_api_hooks := false;
1331: elsif p_mode = 'ENABLE' then
1332: hr_api.g_call_app_api_hooks := true;
1333: else
1334: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

Line 1332: hr_api.g_call_app_api_hooks := true;

1328: begin
1329: if p_mode = 'DISABLE' then
1330: hr_api.g_call_app_api_hooks := false;
1331: elsif p_mode = 'ENABLE' then
1332: hr_api.g_call_app_api_hooks := true;
1333: else
1334: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1335: hr_utility.set_message_token('PROCEDURE', hr_api.g_package||'app_hooks');
1336: hr_utility.set_message_token('STEP', '20');

Line 1335: hr_utility.set_message_token('PROCEDURE', hr_api.g_package||'app_hooks');

1331: elsif p_mode = 'ENABLE' then
1332: hr_api.g_call_app_api_hooks := true;
1333: else
1334: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1335: hr_utility.set_message_token('PROCEDURE', hr_api.g_package||'app_hooks');
1336: hr_utility.set_message_token('STEP', '20');
1337: hr_utility.raise_error;
1338: end if;
1339: end application_hooks;

Line 1347: return hr_api.g_call_cus_api_hooks;

1343: -- ----------------------------------------------------------------------------
1344: --
1345: function call_cus_hooks return boolean is
1346: begin
1347: return hr_api.g_call_cus_api_hooks;
1348: end call_cus_hooks;
1349: --
1350: -- ----------------------------------------------------------------------------
1351: -- |----------------------------< call_leg_hooks >----------------------------|

Line 1356: return hr_api.g_call_leg_api_hooks;

1352: -- ----------------------------------------------------------------------------
1353: --
1354: function call_leg_hooks return boolean is
1355: begin
1356: return hr_api.g_call_leg_api_hooks;
1357: end call_leg_hooks;
1358: --
1359: -- ----------------------------------------------------------------------------
1360: -- |----------------------------< call_app_hooks >----------------------------|

Line 1364: return hr_api.g_call_app_api_hooks;

1360: -- |----------------------------< call_app_hooks >----------------------------|
1361: -- ----------------------------------------------------------------------------
1362: function call_app_hooks return boolean is
1363: begin
1364: return hr_api.g_call_app_api_hooks;
1365: end call_app_hooks;
1366: --
1367: -- ----------------------------------------------------------------------------
1368: -- |-------------------------< return_legislation_code >----------------------|

Line 1391: if nvl(hr_api.g_business_group_id, hr_api.g_number) = p_business_group_id

1387: -- so return a null legislation_code
1388: --
1389: l_legislation_code := null;
1390: else
1391: if nvl(hr_api.g_business_group_id, hr_api.g_number) = p_business_group_id
1392: then
1393: --
1394: -- The legislation code for the business group has already
1395: -- been found with a previous call to this function or to

Line 1399: l_legislation_code := hr_api.g_legislation_code;

1395: -- been found with a previous call to this function or to
1396: -- validate_bus_grp_id. Just return the value in the global
1397: -- variable to avoid the overhead of executing the cursor statement.
1398: --
1399: l_legislation_code := hr_api.g_legislation_code;
1400: else
1401: hr_utility.set_location(hr_api.g_package||'return_legislation_code', 10);
1402: --
1403: -- The business_group_id is different to the last call to this

Line 1401: hr_utility.set_location(hr_api.g_package||'return_legislation_code', 10);

1397: -- variable to avoid the overhead of executing the cursor statement.
1398: --
1399: l_legislation_code := hr_api.g_legislation_code;
1400: else
1401: hr_utility.set_location(hr_api.g_package||'return_legislation_code', 10);
1402: --
1403: -- The business_group_id is different to the last call to this
1404: -- function or this is the first call to this function.
1405: --

Line 1417: hr_api.g_business_group_id := p_business_group_id;

1413: close csr_leg_code;
1414: --
1415: -- Set the global variables for the next call
1416: --
1417: hr_api.g_business_group_id := p_business_group_id;
1418: hr_api.g_legislation_code := l_legislation_code;
1419: end if;
1420: end if;
1421: return l_legislation_code;

Line 1418: hr_api.g_legislation_code := l_legislation_code;

1414: --
1415: -- Set the global variables for the next call
1416: --
1417: hr_api.g_business_group_id := p_business_group_id;
1418: hr_api.g_legislation_code := l_legislation_code;
1419: end if;
1420: end if;
1421: return l_legislation_code;
1422: end return_legislation_code;

Line 1457: -- When a null or hr_api.g_varchar2 value is

1453: l_language_code varchar2(30);
1454: l_exists varchar2(1);
1455: begin
1456: --
1457: -- When a null or hr_api.g_varchar2 value is
1458: -- provided use userenv('LANG') instead.
1459: --
1460: if (p_language_code is null) or
1461: (p_language_code = hr_api.g_varchar2) then

Line 1461: (p_language_code = hr_api.g_varchar2) then

1457: -- When a null or hr_api.g_varchar2 value is
1458: -- provided use userenv('LANG') instead.
1459: --
1460: if (p_language_code is null) or
1461: (p_language_code = hr_api.g_varchar2) then
1462: l_language_code := userenv_lang;
1463: else
1464: l_language_code := p_language_code;
1465: end if;

Line 1466: hr_utility.set_location(hr_api.g_package||'validate_language_code', 10);

1462: l_language_code := userenv_lang;
1463: else
1464: l_language_code := p_language_code;
1465: end if;
1466: hr_utility.set_location(hr_api.g_package||'validate_language_code', 10);
1467: --
1468: -- Validate that the language to be used is the application
1469: -- base language or an installed language.
1470: --

Line 1522: l_leg_code := hr_api.return_legislation_code(fnd_profile.value('PER_BUSINESS_GROUP_ID'));

1518: -- Initialize the session context
1519: g_session_context := FND_GLOBAL.Get_Session_Context;
1520:
1521: -- Get the legislation code from BG
1522: l_leg_code := hr_api.return_legislation_code(fnd_profile.value('PER_BUSINESS_GROUP_ID'));
1523:
1524: -- Set application context HR_SESSION_DATA/LEG_CODE
1525: set_legislation_context(l_leg_code);
1526: --

Line 1543: IF p_constant_value = hr_api.g_false_num THEN

1539: --
1540: -- ----------------------------------------------------------------------------
1541: FUNCTION constant_to_boolean(p_constant_value IN number) RETURN boolean IS
1542: BEGIN
1543: IF p_constant_value = hr_api.g_false_num THEN
1544: RETURN false;
1545: ELSE
1546: RETURN true;
1547: END IF;

Line 1562: RETURN hr_api.g_true_num;

1558: -- ----------------------------------------------------------------------------
1559: FUNCTION boolean_to_constant(p_boolean_value IN boolean) RETURN number IS
1560: BEGIN
1561: IF p_boolean_value THEN
1562: RETURN hr_api.g_true_num;
1563: ELSE
1564: RETURN hr_api.g_false_num;
1565: END IF;
1566: END boolean_to_constant;

Line 1564: RETURN hr_api.g_false_num;

1560: BEGIN
1561: IF p_boolean_value THEN
1562: RETURN hr_api.g_true_num;
1563: ELSE
1564: RETURN hr_api.g_false_num;
1565: END IF;
1566: END boolean_to_constant;
1567: --
1568: End HR_Api;

Line 1568: End HR_Api;

1564: RETURN hr_api.g_false_num;
1565: END IF;
1566: END boolean_to_constant;
1567: --
1568: End HR_Api;