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

Line 13: HR_API_G_VARCHAR2 constant varchar2(128) := hr_api.g_varchar2;

9: /*----------------------- constant definitions ------------------------------*/
10: /*---------------------------------------------------------------------------*/
11: END_OF_TIME constant date := to_date('4712/12/31', 'YYYY/MM/DD');
12: START_OF_TIME constant date := to_date('0001/01/01', 'YYYY/MM/DD');
13: HR_API_G_VARCHAR2 constant varchar2(128) := hr_api.g_varchar2;
14: HR_API_G_NUMBER constant number := hr_api.g_number;
15: HR_API_G_DATE constant date := hr_api.g_date;
16:
17: /*---------------------------------------------------------------------------*/

Line 14: HR_API_G_NUMBER constant number := hr_api.g_number;

10: /*---------------------------------------------------------------------------*/
11: END_OF_TIME constant date := to_date('4712/12/31', 'YYYY/MM/DD');
12: START_OF_TIME constant date := to_date('0001/01/01', 'YYYY/MM/DD');
13: HR_API_G_VARCHAR2 constant varchar2(128) := hr_api.g_varchar2;
14: HR_API_G_NUMBER constant number := hr_api.g_number;
15: HR_API_G_DATE constant date := hr_api.g_date;
16:
17: /*---------------------------------------------------------------------------*/
18: /*------------- internal Get ID functions data structures -------------------*/

Line 15: HR_API_G_DATE constant date := hr_api.g_date;

11: END_OF_TIME constant date := to_date('4712/12/31', 'YYYY/MM/DD');
12: START_OF_TIME constant date := to_date('0001/01/01', 'YYYY/MM/DD');
13: HR_API_G_VARCHAR2 constant varchar2(128) := hr_api.g_varchar2;
14: HR_API_G_NUMBER constant number := hr_api.g_number;
15: HR_API_G_DATE constant date := hr_api.g_date;
16:
17: /*---------------------------------------------------------------------------*/
18: /*------------- internal Get ID functions data structures -------------------*/
19: /*---------------------------------------------------------------------------*/

Line 2139: if p_name_or_code is null or p_name_or_code = hr_api.g_varchar2

2135: begin
2136: --hr_data_pump.message('**bp** in hr_pump_get.get_cur_code: '|| p_name_or_code);
2137: --
2138: begin
2139: if p_name_or_code is null or p_name_or_code = hr_api.g_varchar2
2140: then
2141: --
2142: -- Defaulted values will be returned unchanged.
2143: --

Line 3165: -- Everything is HR_API-defaulted, so return HR_API default value.

3161: elsif p_payee_type is null and p_payee_person_user_key is null and
3162: p_payee_org is null then
3163: return null;
3164: --
3165: -- Everything is HR_API-defaulted, so return HR_API default value.
3166: -- User Keys are set to NULL, if defaulted, on UPDATE.
3167: --
3168: elsif p_payee_type = HR_API_G_VARCHAR2 and
3169: (p_payee_person_user_key is null or p_payee_person_user_key =

Line 3168: elsif p_payee_type = HR_API_G_VARCHAR2 and

3164: --
3165: -- Everything is HR_API-defaulted, so return HR_API default value.
3166: -- User Keys are set to NULL, if defaulted, on UPDATE.
3167: --
3168: elsif p_payee_type = HR_API_G_VARCHAR2 and
3169: (p_payee_person_user_key is null or p_payee_person_user_key =
3170: HR_API_G_VARCHAR2) and p_payee_org = HR_API_G_VARCHAR2 then
3171: return HR_API_G_NUMBER;
3172: --

Line 3170: HR_API_G_VARCHAR2) and p_payee_org = HR_API_G_VARCHAR2 then

3166: -- User Keys are set to NULL, if defaulted, on UPDATE.
3167: --
3168: elsif p_payee_type = HR_API_G_VARCHAR2 and
3169: (p_payee_person_user_key is null or p_payee_person_user_key =
3170: HR_API_G_VARCHAR2) and p_payee_org = HR_API_G_VARCHAR2 then
3171: return HR_API_G_NUMBER;
3172: --
3173: -- User has supplied an erroneous combination of arguments.
3174: --

Line 3171: return HR_API_G_NUMBER;

3167: --
3168: elsif p_payee_type = HR_API_G_VARCHAR2 and
3169: (p_payee_person_user_key is null or p_payee_person_user_key =
3170: HR_API_G_VARCHAR2) and p_payee_org = HR_API_G_VARCHAR2 then
3171: return HR_API_G_NUMBER;
3172: --
3173: -- User has supplied an erroneous combination of arguments.
3174: --
3175: else

Line 4723: if p_language_code = hr_api.g_varchar2 then

4719: end if;
4720: --
4721: -- Set language code (handling possible defaults).
4722: --
4723: if p_language_code = hr_api.g_varchar2 then
4724: --
4725: -- nvl() in the query will take care of defaulting.
4726: --
4727: l_language_code := null;

Line 4734: if p_effective_date is null or p_effective_date = hr_api.g_date then

4730: end if;
4731: --
4732: -- Set the effective date (handling possible defaults).
4733: --
4734: if p_effective_date is null or p_effective_date = hr_api.g_date then
4735: l_effective_date := hr_api.g_sys;
4736: else
4737: l_effective_date := p_effective_date;
4738: end if;

Line 4735: l_effective_date := hr_api.g_sys;

4731: --
4732: -- Set the effective date (handling possible defaults).
4733: --
4734: if p_effective_date is null or p_effective_date = hr_api.g_date then
4735: l_effective_date := hr_api.g_sys;
4736: else
4737: l_effective_date := p_effective_date;
4738: end if;
4739: if p_meaning_or_code is null or p_meaning_or_code = hr_api.g_varchar2

Line 4739: if p_meaning_or_code is null or p_meaning_or_code = hr_api.g_varchar2

4735: l_effective_date := hr_api.g_sys;
4736: else
4737: l_effective_date := p_effective_date;
4738: end if;
4739: if p_meaning_or_code is null or p_meaning_or_code = hr_api.g_varchar2
4740: then
4741: --
4742: -- Defaulted values will be returned unchanged.
4743: --

Line 5041: ELSIF p_competence_name = hr_api_g_varchar2 then

5037: IF p_competence_name is NULL then
5038:
5039: return null;
5040:
5041: ELSIF p_competence_name = hr_api_g_varchar2 then
5042:
5043: return hr_api_g_number;
5044:
5045: ELSE

Line 5043: return hr_api_g_number;

5039: return null;
5040:
5041: ELSIF p_competence_name = hr_api_g_varchar2 then
5042:
5043: return hr_api_g_number;
5044:
5045: ELSE
5046:
5047: IF p_business_group_id is null THEN

Line 5095: ELSIF p_competence_name = hr_api_g_varchar2 then

5091: IF p_competence_name is NULL then
5092:
5093: return null;
5094:
5095: ELSIF p_competence_name = hr_api_g_varchar2 then
5096:
5097: return hr_api_g_number;
5098:
5099: ELSE

Line 5097: return hr_api_g_number;

5093: return null;
5094:
5095: ELSIF p_competence_name = hr_api_g_varchar2 then
5096:
5097: return hr_api_g_number;
5098:
5099: ELSE
5100:
5101: IF p_business_group_id is null THEN

Line 5146: ELSIF p_qualification_type_name = hr_api_g_varchar2 then

5142: IF p_qualification_type_name is NULL then
5143:
5144: return null;
5145:
5146: ELSIF p_qualification_type_name = hr_api_g_varchar2 then
5147:
5148: return hr_api_g_number;
5149:
5150: ELSE

Line 5148: return hr_api_g_number;

5144: return null;
5145:
5146: ELSIF p_qualification_type_name = hr_api_g_varchar2 then
5147:
5148: return hr_api_g_number;
5149:
5150: ELSE
5151:
5152: SELECT qualification_type_id

Line 5184: ELSIF p_outcome_name = hr_api_g_varchar2 then

5180: IF p_outcome_name is NULL then
5181:
5182: return null;
5183:
5184: ELSIF p_outcome_name = hr_api_g_varchar2 then
5185:
5186: return hr_api_g_number;
5187:
5188: ELSE

Line 5186: return hr_api_g_number;

5182: return null;
5183:
5184: ELSIF p_outcome_name = hr_api_g_varchar2 then
5185:
5186: return hr_api_g_number;
5187:
5188: ELSE
5189:
5190: SELECT outcome_id

Line 5225: ELSIF p_outcome_name = hr_api_g_varchar2 then

5221: IF p_outcome_name is NULL then
5222:
5223: return null;
5224:
5225: ELSIF p_outcome_name = hr_api_g_varchar2 then
5226:
5227: return hr_api_g_number;
5228:
5229: ELSE

Line 5227: return hr_api_g_number;

5223: return null;
5224:
5225: ELSIF p_outcome_name = hr_api_g_varchar2 then
5226:
5227: return hr_api_g_number;
5228:
5229: ELSE
5230:
5231: SELECT object_version_number

Line 5266: ELSIF p_qualification_type_name = hr_api_g_varchar2 then

5262: IF p_qualification_type_name is NULL then
5263:
5264: return null;
5265:
5266: ELSIF p_qualification_type_name = hr_api_g_varchar2 then
5267:
5268: return hr_api_g_number;
5269:
5270: ELSE

Line 5268: return hr_api_g_number;

5264: return null;
5265:
5266: ELSIF p_qualification_type_name = hr_api_g_varchar2 then
5267:
5268: return hr_api_g_number;
5269:
5270: ELSE
5271:
5272: SELECT object_version_number

Line 5307: ELSIF p_element_outcome_name = hr_api_g_varchar2 then

5303: IF p_element_outcome_name is NULL then
5304:
5305: return null;
5306:
5307: ELSIF p_element_outcome_name = hr_api_g_varchar2 then
5308:
5309: return hr_api_g_number;
5310:
5311: ELSE

Line 5309: return hr_api_g_number;

5305: return null;
5306:
5307: ELSIF p_element_outcome_name = hr_api_g_varchar2 then
5308:
5309: return hr_api_g_number;
5310:
5311: ELSE
5312:
5313: SELECT object_version_number

Line 5385: ELSIF p_cost_flex_stru_code = hr_api_g_varchar2 then

5381: IF p_cost_flex_stru_code is NULL then
5382:
5383: return null;
5384:
5385: ELSIF p_cost_flex_stru_code = hr_api_g_varchar2 then
5386:
5387: return hr_api_g_number;
5388:
5389: ELSE

Line 5387: return hr_api_g_number;

5383: return null;
5384:
5385: ELSIF p_cost_flex_stru_code = hr_api_g_varchar2 then
5386:
5387: return hr_api_g_number;
5388:
5389: ELSE
5390:
5391: select id_flex_num into l_cost_code

Line 5419: ELSIF p_grade_flex_stru_code = hr_api_g_varchar2 then

5415: IF p_grade_flex_stru_code is NULL then
5416:
5417: return null;
5418:
5419: ELSIF p_grade_flex_stru_code = hr_api_g_varchar2 then
5420:
5421: return hr_api_g_number;
5422:
5423: ELSE

Line 5421: return hr_api_g_number;

5417: return null;
5418:
5419: ELSIF p_grade_flex_stru_code = hr_api_g_varchar2 then
5420:
5421: return hr_api_g_number;
5422:
5423: ELSE
5424: select id_flex_num into l_grade_code
5425: from fnd_id_flex_structures

Line 5453: ELSIF p_job_flex_stru_code = hr_api_g_varchar2 then

5449: IF p_job_flex_stru_code is NULL then
5450:
5451: return null;
5452:
5453: ELSIF p_job_flex_stru_code = hr_api_g_varchar2 then
5454:
5455: return hr_api_g_number;
5456:
5457: ELSE

Line 5455: return hr_api_g_number;

5451: return null;
5452:
5453: ELSIF p_job_flex_stru_code = hr_api_g_varchar2 then
5454:
5455: return hr_api_g_number;
5456:
5457: ELSE
5458:
5459: select id_flex_num into l_job_code

Line 5487: ELSIF p_position_flex_stru_code = hr_api_g_varchar2 then

5483: IF p_position_flex_stru_code is NULL then
5484:
5485: return null;
5486:
5487: ELSIF p_position_flex_stru_code = hr_api_g_varchar2 then
5488:
5489: return hr_api_g_number;
5490:
5491: ELSE

Line 5489: return hr_api_g_number;

5485: return null;
5486:
5487: ELSIF p_position_flex_stru_code = hr_api_g_varchar2 then
5488:
5489: return hr_api_g_number;
5490:
5491: ELSE
5492:
5493: select id_flex_num into l_position_code

Line 5521: ELSIF p_group_flex_stru_code = hr_api_g_varchar2 then

5517: IF p_group_flex_stru_code is NULL then
5518:
5519: return null;
5520:
5521: ELSIF p_group_flex_stru_code = hr_api_g_varchar2 then
5522:
5523: return hr_api_g_number;
5524:
5525: ELSE

Line 5523: return hr_api_g_number;

5519: return null;
5520:
5521: ELSIF p_group_flex_stru_code = hr_api_g_varchar2 then
5522:
5523: return hr_api_g_number;
5524:
5525: ELSE
5526:
5527: select id_flex_num into l_group_code

Line 5555: ELSIF p_competence_flex_stru_code = hr_api_g_varchar2 then

5551: IF p_competence_flex_stru_code is NULL then
5552:
5553: return null;
5554:
5555: ELSIF p_competence_flex_stru_code = hr_api_g_varchar2 then
5556:
5557: return hr_api_g_number;
5558:
5559: ELSE

Line 5557: return hr_api_g_number;

5553: return null;
5554:
5555: ELSIF p_competence_flex_stru_code = hr_api_g_varchar2 then
5556:
5557: return hr_api_g_number;
5558:
5559: ELSE
5560:
5561: select id_flex_num into l_competence_code

Line 5590: ELSIF p_security_group_name = hr_api_g_varchar2 then

5586: IF p_security_group_name is NULL then
5587:
5588: return null;
5589:
5590: ELSIF p_security_group_name = hr_api_g_varchar2 then
5591:
5592: return hr_api_g_number;
5593:
5594: ELSE

Line 5592: return hr_api_g_number;

5588: return null;
5589:
5590: ELSIF p_security_group_name = hr_api_g_varchar2 then
5591:
5592: return hr_api_g_number;
5593:
5594: ELSE
5595:
5596: select security_group_id into l_get_sec_group_id

Line 5626: ELSIF p_security_profile_name = hr_api_g_varchar2 then

5622: IF p_security_profile_name is NULL then
5623:
5624: return null;
5625:
5626: ELSIF p_security_profile_name = hr_api_g_varchar2 then
5627:
5628: return hr_api_g_number;
5629:
5630: ELSE

Line 5628: return hr_api_g_number;

5624: return null;
5625:
5626: ELSIF p_security_profile_name = hr_api_g_varchar2 then
5627:
5628: return hr_api_g_number;
5629:
5630: ELSE
5631:
5632: select security_profile_id into l_sec_profile_id

Line 5663: ELSIF p_parent_organization_name = hr_api_g_varchar2 then

5659: IF p_parent_organization_name is NULL then
5660:
5661: return null;
5662:
5663: ELSIF p_parent_organization_name = hr_api_g_varchar2 then
5664:
5665: return hr_api_g_number;
5666:
5667: ELSE

Line 5665: return hr_api_g_number;

5661: return null;
5662:
5663: ELSIF p_parent_organization_name = hr_api_g_varchar2 then
5664:
5665: return hr_api_g_number;
5666:
5667: ELSE
5668:
5669: select org.organization_id

Line 5700: ELSIF p_child_organization_name = hr_api_g_varchar2 then

5696: IF p_child_organization_name is NULL then
5697:
5698: return null;
5699:
5700: ELSIF p_child_organization_name = hr_api_g_varchar2 then
5701:
5702: return hr_api_g_number;
5703:
5704: ELSE

Line 5702: return hr_api_g_number;

5698: return null;
5699:
5700: ELSIF p_child_organization_name = hr_api_g_varchar2 then
5701:
5702: return hr_api_g_number;
5703:
5704: ELSE
5705: select org.organization_id
5706: into l_organization_id