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.3 2008/10/30 05:20:44 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 281: l_proc varchar2(72) := hr_api.g_package||'validate_bus_grp_id';

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

Line 331: hr_api.g_business_group_id := p_business_group_id;

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

Line 332: hr_api.g_legislation_code := l_legislation_code;

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

Line 338: hr_api.set_legislation_context(l_legislation_code);

334: -- Call set_legislation_context to store the legislation_code
335: -- for the session in the 'LEG_CODE' namespace of the 'HR_SESSION_DATA'
336: -- application context, for reference by HR_LOOKUPS.
337: --
338: hr_api.set_legislation_context(l_legislation_code);
339: --
340: end if;
341: End validate_bus_grp_id;
342: --

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

346: --
347: Function strip_constraint_name(p_errmsg in varchar2)
348: Return varchar2 Is
349: --
350: l_proc varchar2(72) := hr_api.g_package||'strip_constraint_name';
351: l_pos1 number;
352: l_pos2 number;
353: l_pos3 number;
354: l_return_str varchar2(61);

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

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

Line 543: hr_api.mandatory_arg_error

539: end rtn_del_str;
540: --
541: begin
542: --
543: hr_api.mandatory_arg_error
544: (p_api_name => l_proc,
545: p_argument => 'id_flex_num',
546: p_argument_value => p_id_flex_num);
547: --

Line 548: hr_api.mandatory_arg_error

544: (p_api_name => l_proc,
545: p_argument => 'id_flex_num',
546: p_argument_value => p_id_flex_num);
547: --
548: hr_api.mandatory_arg_error
549: (p_api_name => l_proc,
550: p_argument => 'application_id',
551: p_argument_value => p_application_id);
552: --

Line 553: hr_api.mandatory_arg_error

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

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

841: end if;
842:
843:
844: -- DK 2002-11-08 PLSQLSTD
845: --hr_utility.set_location(hr_api.g_package||'not_exists_in_hr_lookups', 10);
846:
847:
848: --
849: open csr_hr_look;

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

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

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

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

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

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

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

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

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

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

Line 1208: return hr_api.g_commit_unit_number;

1204: --
1205: hr_api.g_commit_unit_number := hr_api.g_commit_unit_number + 1;
1206: end if;
1207: --
1208: return hr_api.g_commit_unit_number;
1209: end return_commit_unit;
1210: --
1211: -- ----------------------------------------------------------------------------
1212: -- |--------------------------< validate_commit_unit >------------------------|

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

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

Line 1284: hr_api.g_call_cus_api_hooks := false;

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

Line 1286: hr_api.g_call_cus_api_hooks := true;

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

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

1286: hr_api.g_call_cus_api_hooks := true;
1287: else
1288: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1289: hr_utility.set_message_token('PROCEDURE'
1290: ,hr_api.g_package||'customer_hooks'
1291: );
1292: hr_utility.set_message_token('STEP', '20');
1293: hr_utility.raise_error;
1294: end if;

Line 1306: hr_api.g_call_leg_api_hooks := false;

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

Line 1308: hr_api.g_call_leg_api_hooks := true;

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

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

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

Line 1326: hr_api.g_call_app_api_hooks := false;

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

Line 1328: hr_api.g_call_app_api_hooks := true;

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

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

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

Line 1343: return hr_api.g_call_cus_api_hooks;

1339: -- ----------------------------------------------------------------------------
1340: --
1341: function call_cus_hooks return boolean is
1342: begin
1343: return hr_api.g_call_cus_api_hooks;
1344: end call_cus_hooks;
1345: --
1346: -- ----------------------------------------------------------------------------
1347: -- |----------------------------< call_leg_hooks >----------------------------|

Line 1352: return hr_api.g_call_leg_api_hooks;

1348: -- ----------------------------------------------------------------------------
1349: --
1350: function call_leg_hooks return boolean is
1351: begin
1352: return hr_api.g_call_leg_api_hooks;
1353: end call_leg_hooks;
1354: --
1355: -- ----------------------------------------------------------------------------
1356: -- |----------------------------< call_app_hooks >----------------------------|

Line 1360: return hr_api.g_call_app_api_hooks;

1356: -- |----------------------------< call_app_hooks >----------------------------|
1357: -- ----------------------------------------------------------------------------
1358: function call_app_hooks return boolean is
1359: begin
1360: return hr_api.g_call_app_api_hooks;
1361: end call_app_hooks;
1362: --
1363: -- ----------------------------------------------------------------------------
1364: -- |-------------------------< return_legislation_code >----------------------|

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

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

Line 1395: l_legislation_code := hr_api.g_legislation_code;

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

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

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

Line 1413: hr_api.g_business_group_id := p_business_group_id;

1409: close csr_leg_code;
1410: --
1411: -- Set the global variables for the next call
1412: --
1413: hr_api.g_business_group_id := p_business_group_id;
1414: hr_api.g_legislation_code := l_legislation_code;
1415: end if;
1416: end if;
1417: return l_legislation_code;

Line 1414: hr_api.g_legislation_code := l_legislation_code;

1410: --
1411: -- Set the global variables for the next call
1412: --
1413: hr_api.g_business_group_id := p_business_group_id;
1414: hr_api.g_legislation_code := l_legislation_code;
1415: end if;
1416: end if;
1417: return l_legislation_code;
1418: end return_legislation_code;

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

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

Line 1457: (p_language_code = hr_api.g_varchar2) then

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

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

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

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

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

Line 1539: IF p_constant_value = hr_api.g_false_num THEN

1535: --
1536: -- ----------------------------------------------------------------------------
1537: FUNCTION constant_to_boolean(p_constant_value IN number) RETURN boolean IS
1538: BEGIN
1539: IF p_constant_value = hr_api.g_false_num THEN
1540: RETURN false;
1541: ELSE
1542: RETURN true;
1543: END IF;

Line 1558: RETURN hr_api.g_true_num;

1554: -- ----------------------------------------------------------------------------
1555: FUNCTION boolean_to_constant(p_boolean_value IN boolean) RETURN number IS
1556: BEGIN
1557: IF p_boolean_value THEN
1558: RETURN hr_api.g_true_num;
1559: ELSE
1560: RETURN hr_api.g_false_num;
1561: END IF;
1562: END boolean_to_constant;

Line 1560: RETURN hr_api.g_false_num;

1556: BEGIN
1557: IF p_boolean_value THEN
1558: RETURN hr_api.g_true_num;
1559: ELSE
1560: RETURN hr_api.g_false_num;
1561: END IF;
1562: END boolean_to_constant;
1563: --
1564: End HR_Api;

Line 1564: End HR_Api;

1560: RETURN hr_api.g_false_num;
1561: END IF;
1562: END boolean_to_constant;
1563: --
1564: End HR_Api;