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 3192: -- Everything is HR_API-defaulted, so return HR_API default value.

3188: elsif p_payee_type is null and p_payee_person_user_key is null and
3189: p_payee_org is null then
3190: return null;
3191: --
3192: -- Everything is HR_API-defaulted, so return HR_API default value.
3193: -- User Keys are set to NULL, if defaulted, on UPDATE.
3194: --
3195: elsif p_payee_type = HR_API_G_VARCHAR2 and
3196: (p_payee_person_user_key is null or p_payee_person_user_key =

Line 3195: elsif p_payee_type = HR_API_G_VARCHAR2 and

3191: --
3192: -- Everything is HR_API-defaulted, so return HR_API default value.
3193: -- User Keys are set to NULL, if defaulted, on UPDATE.
3194: --
3195: elsif p_payee_type = HR_API_G_VARCHAR2 and
3196: (p_payee_person_user_key is null or p_payee_person_user_key =
3197: HR_API_G_VARCHAR2) and p_payee_org = HR_API_G_VARCHAR2 then
3198: return HR_API_G_NUMBER;
3199: --

Line 3197: HR_API_G_VARCHAR2) and p_payee_org = HR_API_G_VARCHAR2 then

3193: -- User Keys are set to NULL, if defaulted, on UPDATE.
3194: --
3195: elsif p_payee_type = HR_API_G_VARCHAR2 and
3196: (p_payee_person_user_key is null or p_payee_person_user_key =
3197: HR_API_G_VARCHAR2) and p_payee_org = HR_API_G_VARCHAR2 then
3198: return HR_API_G_NUMBER;
3199: --
3200: -- User has supplied an erroneous combination of arguments.
3201: --

Line 3198: return HR_API_G_NUMBER;

3194: --
3195: elsif p_payee_type = HR_API_G_VARCHAR2 and
3196: (p_payee_person_user_key is null or p_payee_person_user_key =
3197: HR_API_G_VARCHAR2) and p_payee_org = HR_API_G_VARCHAR2 then
3198: return HR_API_G_NUMBER;
3199: --
3200: -- User has supplied an erroneous combination of arguments.
3201: --
3202: else

Line 4750: if p_language_code = hr_api.g_varchar2 then

4746: end if;
4747: --
4748: -- Set language code (handling possible defaults).
4749: --
4750: if p_language_code = hr_api.g_varchar2 then
4751: --
4752: -- nvl() in the query will take care of defaulting.
4753: --
4754: l_language_code := null;

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

4757: end if;
4758: --
4759: -- Set the effective date (handling possible defaults).
4760: --
4761: if p_effective_date is null or p_effective_date = hr_api.g_date then
4762: l_effective_date := hr_api.g_sys;
4763: else
4764: l_effective_date := p_effective_date;
4765: end if;

Line 4762: l_effective_date := hr_api.g_sys;

4758: --
4759: -- Set the effective date (handling possible defaults).
4760: --
4761: if p_effective_date is null or p_effective_date = hr_api.g_date then
4762: l_effective_date := hr_api.g_sys;
4763: else
4764: l_effective_date := p_effective_date;
4765: end if;
4766: if p_meaning_or_code is null or p_meaning_or_code = hr_api.g_varchar2

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

4762: l_effective_date := hr_api.g_sys;
4763: else
4764: l_effective_date := p_effective_date;
4765: end if;
4766: if p_meaning_or_code is null or p_meaning_or_code = hr_api.g_varchar2
4767: then
4768: --
4769: -- Defaulted values will be returned unchanged.
4770: --

Line 5068: ELSIF p_competence_name = hr_api_g_varchar2 then

5064: IF p_competence_name is NULL then
5065:
5066: return null;
5067:
5068: ELSIF p_competence_name = hr_api_g_varchar2 then
5069:
5070: return hr_api_g_number;
5071:
5072: ELSE

Line 5070: return hr_api_g_number;

5066: return null;
5067:
5068: ELSIF p_competence_name = hr_api_g_varchar2 then
5069:
5070: return hr_api_g_number;
5071:
5072: ELSE
5073:
5074: IF p_business_group_id is null THEN

Line 5122: ELSIF p_competence_name = hr_api_g_varchar2 then

5118: IF p_competence_name is NULL then
5119:
5120: return null;
5121:
5122: ELSIF p_competence_name = hr_api_g_varchar2 then
5123:
5124: return hr_api_g_number;
5125:
5126: ELSE

Line 5124: return hr_api_g_number;

5120: return null;
5121:
5122: ELSIF p_competence_name = hr_api_g_varchar2 then
5123:
5124: return hr_api_g_number;
5125:
5126: ELSE
5127:
5128: IF p_business_group_id is null THEN

Line 5173: ELSIF p_qualification_type_name = hr_api_g_varchar2 then

5169: IF p_qualification_type_name is NULL then
5170:
5171: return null;
5172:
5173: ELSIF p_qualification_type_name = hr_api_g_varchar2 then
5174:
5175: return hr_api_g_number;
5176:
5177: ELSE

Line 5175: return hr_api_g_number;

5171: return null;
5172:
5173: ELSIF p_qualification_type_name = hr_api_g_varchar2 then
5174:
5175: return hr_api_g_number;
5176:
5177: ELSE
5178:
5179: SELECT qualification_type_id

Line 5211: ELSIF p_outcome_name = hr_api_g_varchar2 then

5207: IF p_outcome_name is NULL then
5208:
5209: return null;
5210:
5211: ELSIF p_outcome_name = hr_api_g_varchar2 then
5212:
5213: return hr_api_g_number;
5214:
5215: ELSE

Line 5213: return hr_api_g_number;

5209: return null;
5210:
5211: ELSIF p_outcome_name = hr_api_g_varchar2 then
5212:
5213: return hr_api_g_number;
5214:
5215: ELSE
5216:
5217: SELECT outcome_id

Line 5252: ELSIF p_outcome_name = hr_api_g_varchar2 then

5248: IF p_outcome_name is NULL then
5249:
5250: return null;
5251:
5252: ELSIF p_outcome_name = hr_api_g_varchar2 then
5253:
5254: return hr_api_g_number;
5255:
5256: ELSE

Line 5254: return hr_api_g_number;

5250: return null;
5251:
5252: ELSIF p_outcome_name = hr_api_g_varchar2 then
5253:
5254: return hr_api_g_number;
5255:
5256: ELSE
5257:
5258: SELECT object_version_number

Line 5293: ELSIF p_qualification_type_name = hr_api_g_varchar2 then

5289: IF p_qualification_type_name is NULL then
5290:
5291: return null;
5292:
5293: ELSIF p_qualification_type_name = hr_api_g_varchar2 then
5294:
5295: return hr_api_g_number;
5296:
5297: ELSE

Line 5295: return hr_api_g_number;

5291: return null;
5292:
5293: ELSIF p_qualification_type_name = hr_api_g_varchar2 then
5294:
5295: return hr_api_g_number;
5296:
5297: ELSE
5298:
5299: SELECT object_version_number

Line 5334: ELSIF p_element_outcome_name = hr_api_g_varchar2 then

5330: IF p_element_outcome_name is NULL then
5331:
5332: return null;
5333:
5334: ELSIF p_element_outcome_name = hr_api_g_varchar2 then
5335:
5336: return hr_api_g_number;
5337:
5338: ELSE

Line 5336: return hr_api_g_number;

5332: return null;
5333:
5334: ELSIF p_element_outcome_name = hr_api_g_varchar2 then
5335:
5336: return hr_api_g_number;
5337:
5338: ELSE
5339:
5340: SELECT object_version_number

Line 5412: ELSIF p_cost_flex_stru_code = hr_api_g_varchar2 then

5408: IF p_cost_flex_stru_code is NULL then
5409:
5410: return null;
5411:
5412: ELSIF p_cost_flex_stru_code = hr_api_g_varchar2 then
5413:
5414: return hr_api_g_number;
5415:
5416: ELSE

Line 5414: return hr_api_g_number;

5410: return null;
5411:
5412: ELSIF p_cost_flex_stru_code = hr_api_g_varchar2 then
5413:
5414: return hr_api_g_number;
5415:
5416: ELSE
5417:
5418: select id_flex_num into l_cost_code

Line 5446: ELSIF p_grade_flex_stru_code = hr_api_g_varchar2 then

5442: IF p_grade_flex_stru_code is NULL then
5443:
5444: return null;
5445:
5446: ELSIF p_grade_flex_stru_code = hr_api_g_varchar2 then
5447:
5448: return hr_api_g_number;
5449:
5450: ELSE

Line 5448: return hr_api_g_number;

5444: return null;
5445:
5446: ELSIF p_grade_flex_stru_code = hr_api_g_varchar2 then
5447:
5448: return hr_api_g_number;
5449:
5450: ELSE
5451: select id_flex_num into l_grade_code
5452: from fnd_id_flex_structures

Line 5480: ELSIF p_job_flex_stru_code = hr_api_g_varchar2 then

5476: IF p_job_flex_stru_code is NULL then
5477:
5478: return null;
5479:
5480: ELSIF p_job_flex_stru_code = hr_api_g_varchar2 then
5481:
5482: return hr_api_g_number;
5483:
5484: ELSE

Line 5482: return hr_api_g_number;

5478: return null;
5479:
5480: ELSIF p_job_flex_stru_code = hr_api_g_varchar2 then
5481:
5482: return hr_api_g_number;
5483:
5484: ELSE
5485:
5486: select id_flex_num into l_job_code

Line 5514: ELSIF p_position_flex_stru_code = hr_api_g_varchar2 then

5510: IF p_position_flex_stru_code is NULL then
5511:
5512: return null;
5513:
5514: ELSIF p_position_flex_stru_code = hr_api_g_varchar2 then
5515:
5516: return hr_api_g_number;
5517:
5518: ELSE

Line 5516: return hr_api_g_number;

5512: return null;
5513:
5514: ELSIF p_position_flex_stru_code = hr_api_g_varchar2 then
5515:
5516: return hr_api_g_number;
5517:
5518: ELSE
5519:
5520: select id_flex_num into l_position_code

Line 5548: ELSIF p_group_flex_stru_code = hr_api_g_varchar2 then

5544: IF p_group_flex_stru_code is NULL then
5545:
5546: return null;
5547:
5548: ELSIF p_group_flex_stru_code = hr_api_g_varchar2 then
5549:
5550: return hr_api_g_number;
5551:
5552: ELSE

Line 5550: return hr_api_g_number;

5546: return null;
5547:
5548: ELSIF p_group_flex_stru_code = hr_api_g_varchar2 then
5549:
5550: return hr_api_g_number;
5551:
5552: ELSE
5553:
5554: select id_flex_num into l_group_code

Line 5582: ELSIF p_competence_flex_stru_code = hr_api_g_varchar2 then

5578: IF p_competence_flex_stru_code is NULL then
5579:
5580: return null;
5581:
5582: ELSIF p_competence_flex_stru_code = hr_api_g_varchar2 then
5583:
5584: return hr_api_g_number;
5585:
5586: ELSE

Line 5584: return hr_api_g_number;

5580: return null;
5581:
5582: ELSIF p_competence_flex_stru_code = hr_api_g_varchar2 then
5583:
5584: return hr_api_g_number;
5585:
5586: ELSE
5587:
5588: select id_flex_num into l_competence_code

Line 5617: ELSIF p_security_group_name = hr_api_g_varchar2 then

5613: IF p_security_group_name is NULL then
5614:
5615: return null;
5616:
5617: ELSIF p_security_group_name = hr_api_g_varchar2 then
5618:
5619: return hr_api_g_number;
5620:
5621: ELSE

Line 5619: return hr_api_g_number;

5615: return null;
5616:
5617: ELSIF p_security_group_name = hr_api_g_varchar2 then
5618:
5619: return hr_api_g_number;
5620:
5621: ELSE
5622:
5623: select security_group_id into l_get_sec_group_id

Line 5653: ELSIF p_security_profile_name = hr_api_g_varchar2 then

5649: IF p_security_profile_name is NULL then
5650:
5651: return null;
5652:
5653: ELSIF p_security_profile_name = hr_api_g_varchar2 then
5654:
5655: return hr_api_g_number;
5656:
5657: ELSE

Line 5655: return hr_api_g_number;

5651: return null;
5652:
5653: ELSIF p_security_profile_name = hr_api_g_varchar2 then
5654:
5655: return hr_api_g_number;
5656:
5657: ELSE
5658:
5659: select security_profile_id into l_sec_profile_id

Line 5690: ELSIF p_parent_organization_name = hr_api_g_varchar2 then

5686: IF p_parent_organization_name is NULL then
5687:
5688: return null;
5689:
5690: ELSIF p_parent_organization_name = hr_api_g_varchar2 then
5691:
5692: return hr_api_g_number;
5693:
5694: ELSE

Line 5692: return hr_api_g_number;

5688: return null;
5689:
5690: ELSIF p_parent_organization_name = hr_api_g_varchar2 then
5691:
5692: return hr_api_g_number;
5693:
5694: ELSE
5695:
5696: select org.organization_id

Line 5727: ELSIF p_child_organization_name = hr_api_g_varchar2 then

5723: IF p_child_organization_name is NULL then
5724:
5725: return null;
5726:
5727: ELSIF p_child_organization_name = hr_api_g_varchar2 then
5728:
5729: return hr_api_g_number;
5730:
5731: ELSE

Line 5729: return hr_api_g_number;

5725: return null;
5726:
5727: ELSIF p_child_organization_name = hr_api_g_varchar2 then
5728:
5729: return hr_api_g_number;
5730:
5731: ELSE
5732: select org.organization_id
5733: into l_organization_id