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_COMP_OUTCOME_PROFILE_SS dependencies on HR_COMP_OUTCOME_PROFILE_SS

Line 1: PACKAGE BODY HR_COMP_OUTCOME_PROFILE_SS AS

1: PACKAGE BODY HR_COMP_OUTCOME_PROFILE_SS AS
2: /* $Header: hrcorwrs.pkb 120.0 2005/05/30 23:23:03 appldev noship $ */
3: --
4: -- Private globals
5: g_package constant varchar2(30) := 'HR_COMP_OUTCOME_PROFILE_SS';

Line 5: g_package constant varchar2(30) := 'HR_COMP_OUTCOME_PROFILE_SS';

1: PACKAGE BODY HR_COMP_OUTCOME_PROFILE_SS AS
2: /* $Header: hrcorwrs.pkb 120.0 2005/05/30 23:23:03 appldev noship $ */
3: --
4: -- Private globals
5: g_package constant varchar2(30) := 'HR_COMP_OUTCOME_PROFILE_SS';
6: g_person_id per_all_people_f.person_id%type;
7: g_business_group_id per_all_people_f.business_group_id%type;
8: g_language_code varchar2(5) default null;
9: --

Line 399: WHEN hr_comp_outcome_profile_ss.g_data_err THEN

395: When g_invalid_entry then
396: hr_utility.set_location(' Entering:' || l_proc,70);
397: raise g_invalid_entry;
398: --
399: WHEN hr_comp_outcome_profile_ss.g_data_err THEN
400: hr_utility.set_location(' Entering:' || l_proc,80);
401: raise hr_utility.hr_error;
402: --
403: WHEN hr_comp_outcome_profile_ss.g_access_violation_err THEN

Line 403: WHEN hr_comp_outcome_profile_ss.g_access_violation_err THEN

399: WHEN hr_comp_outcome_profile_ss.g_data_err THEN
400: hr_utility.set_location(' Entering:' || l_proc,80);
401: raise hr_utility.hr_error;
402: --
403: WHEN hr_comp_outcome_profile_ss.g_access_violation_err THEN
404: hr_utility.set_location(' Entering:' || l_proc,90);
405: raise hr_utility.hr_error;
406: --
407: When others THEN

Line 440: AND ts.API_NAME = 'HR_COMP_OUTCOME_PROFILE_SS.PROCESS_API'

436: Where ts.transaction_step_id = tv.transaction_step_id
437: AND ts.item_type = p_item_type
438: AND ts.item_key = p_item_key
439: AND ts.activity_id = p_activity_id
440: AND ts.API_NAME = 'HR_COMP_OUTCOME_PROFILE_SS.PROCESS_API'
441: And tv4.transaction_step_id = ts.transaction_step_id
442: And tv4.NAME = 'P_PERSON_ID'
443: AND tv4.Number_Value = p_person_id
444: AND tv1.transaction_step_id(+) = ts.transaction_step_id

Line 468: AND ts.API_NAME = 'HR_COMP_OUTCOME_PROFILE_SS.DELETE'

464: AND ts.item_key = p_item_key
465: AND ts.activity_id = p_activity_id
466: AND ts.transaction_step_id = tv.transaction_step_id
467: AND tv.NAME = 'P_COMP_ELEMENT_OUTCOME_ID'
468: AND ts.API_NAME = 'HR_COMP_OUTCOME_PROFILE_SS.DELETE'
469: AND tv.number_value = ceo.COMP_ELEMENT_OUTCOME_ID;
470: --
471: Cursor get_unchngd_outcomes(p_comp_ele_id IN NUMBER ) is
472: Select co.outcome_id

Line 489: and s.api_name = 'HR_COMP_OUTCOME_PROFILE_SS.PROCESS_API'

485: WHERE tv1.transaction_step_id = s.transaction_step_id
486: and s.item_type = p_item_type
487: and s.item_key = p_item_key
488: and s.activity_id = nvl(to_number(p_activity_id),s.activity_id)
489: and s.api_name = 'HR_COMP_OUTCOME_PROFILE_SS.PROCESS_API'
490: And tv2.transaction_step_id = s.transaction_step_id
491: And tv3.transaction_step_id = s.transaction_step_id
492: AND tv4.transaction_step_id = s.transaction_step_id
493: AND tv4.NAME = 'P_PERSON_ID'

Line 515: and s1.api_name = 'HR_COMP_OUTCOME_PROFILE_SS.DELETE'

511: hr_api_transaction_values C
512: Where s1.item_type = p_item_type
513: and s1.item_key = p_item_key
514: and s1.activity_id = nvl((p_activity_id),s1.activity_id)
515: and s1.api_name = 'HR_COMP_OUTCOME_PROFILE_SS.DELETE'
516: and c.transaction_step_id = s1.transaction_step_id
517: AND C.NAME = 'P_COMP_ELEMENT_OUTCOME_ID'
518: AND ceo.comp_element_outcome_id = C.number_value);
519: Cursor get_new_compele_dtls( p_new_comp_ele_id IN number) is

Line 577: HR_COMP_OUTCOME_PROFILE_SS.process_api(

573: hr_utility.set_location(' Entering:' || l_proc,30);
574: hr_utility.set_location(' p_new_competence_element_id:' || p_new_competence_element_id,30);
575: hr_utility.set_location(' p_effective_date:' || l_proc,30);
576: hr_utility.set_location(' p_transaction_step_id: ' || txnids.transaction_step_id,30);
577: HR_COMP_OUTCOME_PROFILE_SS.process_api(
578: p_validate => p_validate
579: ,p_competence_element_id => p_new_competence_element_id
580: ,p_effective_date => p_effective_date
581: ,p_transaction_step_id => txnids.transaction_step_id);

Line 598: RAISE hr_comp_outcome_profile_ss.g_data_err;

594: OPEN get_new_compele_dtls(p_new_competence_element_id);
595: FETCH get_new_compele_dtls INTO new_compele_dtl_record;
596: IF get_new_compele_dtls%NOTFOUND then
597: CLOSE get_new_compele_dtls;
598: RAISE hr_comp_outcome_profile_ss.g_data_err;
599: else
600: CLOSE get_new_compele_dtls;
601: END if;
602: END if;

Line 648: WHEN hr_comp_outcome_profile_ss.g_data_err THEN

644: END if;
645: -- hr_utility.trace_off;
646: --
647: EXCEPTION
648: WHEN hr_comp_outcome_profile_ss.g_data_err THEN
649: hr_utility.set_location(' Entering:' || l_proc,90);
650: raise hr_utility.hr_error;
651: --
652: WHEN hr_comp_outcome_profile_ss.g_access_violation_err THEN

Line 652: WHEN hr_comp_outcome_profile_ss.g_access_violation_err THEN

648: WHEN hr_comp_outcome_profile_ss.g_data_err THEN
649: hr_utility.set_location(' Entering:' || l_proc,90);
650: raise hr_utility.hr_error;
651: --
652: WHEN hr_comp_outcome_profile_ss.g_access_violation_err THEN
653: hr_utility.set_location(' Entering:' || l_proc,100);
654: raise hr_utility.hr_error;
655: --
656: When others THEN

Line 975: hr_comp_outcome_profile_ss.check_if_cmpocm_rec_changed

971: End if;
972: l_mode := p_change_mode;
973: IF (p_comp_element_outcome_id is not NULL) THEN
974: hr_utility.set_location(' Entering:' || l_proc,30);
975: hr_comp_outcome_profile_ss.check_if_cmpocm_rec_changed
976: (p_comp_element_outcome_id => x_comp_ele_out_Id
977: ,p_competence_element_id => x_comp_ele_id
978: ,p_competence_id => x_comp_id
979: ,p_outcome_id => p_outcome_id

Line 993: l_mode := HR_COMP_OUTCOME_PROFILE_SS.OUTCOME_CHANGED;

989: delete_transaction_step_id(p_transaction_step_id);
990: END IF;
991: return; -- added on 17-Nov-2004
992: end if;
993: l_mode := HR_COMP_OUTCOME_PROFILE_SS.OUTCOME_CHANGED;
994: --
995: END IF;
996: --
997: IF ( p_date_from IS NULL OR to_date(p_date_from,g_date_format) IS null ) then

Line 1083: and s.api_name = 'HR_COMP_OUTCOME_PROFILE_SS.DELETE'

1079: hr_api_transaction_steps S, hr_api_transaction_values C
1080: Where s.item_type = p_item_type
1081: and s.item_key = p_item_key
1082: and s.activity_id = nvl(to_number(p_activity_id),s.activity_id)
1083: and s.api_name = 'HR_COMP_OUTCOME_PROFILE_SS.DELETE'
1084: and c.transaction_step_id = s.transaction_step_id
1085: AND C.NAME = 'P_COMP_ELEMENT_OUTCOME_ID'
1086: AND C.NUMBER_VALUE = CEO.COMP_ELEMENT_OUTCOME_ID);
1087: hr_utility.set_location(' Entering x_count:' || x_count,107);

Line 1107: and s.api_name = 'HR_COMP_OUTCOME_PROFILE_SS.DELETE'

1103: hr_api_transaction_steps S, hr_api_transaction_values C
1104: Where s.item_type = p_item_type
1105: and s.item_key = p_item_key
1106: and s.activity_id = nvl(to_number(p_activity_id),s.activity_id)
1107: and s.api_name = 'HR_COMP_OUTCOME_PROFILE_SS.DELETE'
1108: and c.transaction_step_id = s.transaction_step_id
1109: AND C.NAME = 'P_COMP_ELEMENT_OUTCOME_ID'
1110: AND C.NUMBER_VALUE = CEO.COMP_ELEMENT_OUTCOME_ID);
1111: hr_utility.set_location(' Entering x_count:' || x_count,108);

Line 1125: and s.api_name = 'HR_COMP_OUTCOME_PROFILE_SS.DELETE'

1121: hr_api_transaction_steps S, hr_api_transaction_values C
1122: Where s.item_type = p_item_type
1123: and s.item_key = p_item_key
1124: and s.activity_id = nvl(to_number(p_activity_id),s.activity_id)
1125: and s.api_name = 'HR_COMP_OUTCOME_PROFILE_SS.DELETE'
1126: and c.transaction_step_id = s.transaction_step_id
1127: AND C.NAME = 'P_COMP_ELEMENT_OUTCOME_ID'
1128: AND C.NUMBER_VALUE = CEO.COMP_ELEMENT_OUTCOME_ID);
1129: hr_utility.set_location(' Entering x_count:' || x_count,109);

Line 1143: -- raise hr_comp_outcome_profile_ss.g_fatal_error;

1139: hr_utility.set_location(' Entering:' || l_proc,110);
1140: OPEN get_prev_start_date(x_comp_ele_out_Id);
1141: FETCH get_prev_start_date into l_prev_date;
1142: -- IF get_prev_start_date%notfound THEN
1143: -- raise hr_comp_outcome_profile_ss.g_fatal_error;
1144: -- END IF;
1145: close get_prev_start_date;
1146: l_prev_start_date := l_prev_date;
1147: --

Line 1401: l_trans_tbl hr_comp_outcome_profile_ss.transaction_table1;

1397: l_transaction_step_id number;
1398: --
1399: --------------
1400: l_object_version_number number default null;
1401: l_trans_tbl hr_comp_outcome_profile_ss.transaction_table1;
1402: l_count number default 0;
1403: l_action_person_id number default null;
1404: l_proc varchar2(200) ;
1405: -------------

Line 1417: raise hr_comp_outcome_profile_ss.g_fatal_error;

1413: FETCH get_prev_start_date into l_prev_date;
1414: IF get_prev_start_date%notfound THEN
1415: hr_utility.set_location(' Entering:' || l_proc,20);
1416: close get_out_name;
1417: raise hr_comp_outcome_profile_ss.g_fatal_error;
1418: ELSE
1419: hr_utility.set_location(' Entering:' || l_proc,30);
1420: CLOSE get_prev_start_date;
1421: END IF;

Line 1529: And outcome.api_name = HR_COMP_OUTCOME_PROFILE_SS.g_api_name

1525: AND cto_dt.NAME = 'P_EFF_DATE_TO'
1526: And outcome.item_key = competence.item_key
1527: And outcome.item_type = competence.item_type
1528: And outcome.activity_id = competence.activity_id
1529: And outcome.api_name = HR_COMP_OUTCOME_PROFILE_SS.g_api_name
1530: AND ocomp.transaction_step_id = competence.transaction_step_id
1531: AND operson.transaction_step_id = competence.transaction_step_id
1532: AND ofrom_dt.transaction_step_id = competence.transaction_step_id
1533: AND oto_dt.transaction_step_id = competence.transaction_step_id

Line 1749: raise hr_comp_outcome_profile_ss.g_fatal_error;

1745: hr_utility.set_location(' Entering:' || l_proc || ' in loop for ',20);
1746: IF l_preupd_rec.outcome_id = p_outcome_id AND l_preupd_rec.competence_element_id = p_competence_element_id THEN
1747: null;
1748: ELSE
1749: raise hr_comp_outcome_profile_ss.g_fatal_error;
1750: END IF;
1751: --
1752: --
1753: IF l_preupd_rec.date_from is not null THEN

Line 1839: ,p_api_name => 'HR_COMP_OUTCOME_PROFILE_SS.DELETE'

1835: hr_transaction_api.create_transaction_step
1836: (p_validate => false
1837: ,p_creator_person_id => fnd_global.employee_id
1838: ,p_transaction_id => l_transaction_id
1839: ,p_api_name => 'HR_COMP_OUTCOME_PROFILE_SS.DELETE'
1840: ,p_item_type => p_item_type
1841: ,p_item_key => p_item_key
1842: ,p_activity_id => p_activity_id
1843: ,p_transaction_step_id => l_transaction_step_id

Line 1859: ,p_api_name => 'HR_COMP_OUTCOME_PROFILE_SS.DELETE'

1855: ,p_item_key => p_item_key
1856: ,p_actid => p_activity_id
1857: ,p_login_person_id => fnd_global.employee_id
1858: ,p_transaction_step_id => l_transaction_step_id
1859: ,p_api_name => 'HR_COMP_OUTCOME_PROFILE_SS.DELETE'
1860: ,p_transaction_data => l_trans_tbl);
1861: END mark_for_delete;
1862: ----------------------
1863: ---------------------

Line 1884: and s.api_name = 'HR_COMP_OUTCOME_PROFILE_SS.DELETE'

1880: per_competence_elements pce
1881: Where s.item_type = p_item_type
1882: and s.item_key = p_item_key
1883: and s.activity_id = nvl((p_actid),s.activity_id)
1884: and s.api_name = 'HR_COMP_OUTCOME_PROFILE_SS.DELETE'
1885: and c.transaction_step_id = s.transaction_step_id
1886: AND C.NAME = 'P_COMP_ELEMENT_OUTCOME_ID'
1887: AND ceo.outcome_id = p_outcome_id
1888: AND ceo.Competence_Element_id = pce.competence_element_id

Line 1936: and s.api_name = 'HR_COMP_OUTCOME_PROFILE_SS.PROCESS_API'

1932: hr_api_transaction_values c, hr_api_transaction_values p
1933: Where s.item_type = p_item_type
1934: and s.item_key = p_item_key
1935: and s.activity_id = nvl(p_activity_id,s.activity_id)
1936: and s.api_name = 'HR_COMP_OUTCOME_PROFILE_SS.PROCESS_API'
1937: and c.transaction_step_id = s.transaction_step_id
1938: AND CO.COMPETENCE_ID =p_competence_id
1939: AND co.date_from <= trunc(sysdate)
1940: AND nvl(co.date_to,trunc(sysdate)) >= trunc(sysdate)

Line 1964: and s.api_name = 'HR_COMP_OUTCOME_PROFILE_SS.DELETE'

1960: per_comp_element_outcomes ceo
1961: Where s.item_type = p_item_type
1962: and s.item_key = p_item_key
1963: and s.activity_id = nvl((p_activity_id),s.activity_id)
1964: and s.api_name = 'HR_COMP_OUTCOME_PROFILE_SS.DELETE'
1965: and c.transaction_step_id = s.transaction_step_id
1966: AND C.NAME = 'P_COMP_ELEMENT_OUTCOME_ID'
1967: AND ceo.Competence_Element_id = p_competence_element_id
1968: AND ceo.comp_element_outcome_id = C.number_value;

Line 2009: and s.api_name = 'HR_COMP_OUTCOME_PROFILE_SS.DELETE'

2005: per_comp_element_outcomes ceo
2006: Where s.item_type = p_item_type
2007: and s.item_key = p_item_key
2008: and s.activity_id = nvl((p_activity_id),s.activity_id)
2009: and s.api_name = 'HR_COMP_OUTCOME_PROFILE_SS.DELETE'
2010: and c.transaction_step_id = s.transaction_step_id
2011: AND C.NAME = 'P_COMP_ELEMENT_OUTCOME_ID'
2012: AND c.number_value = ceo.comp_element_outcome_id
2013: AND ceo.competence_element_id = p_competence_element_id;

Line 2034: and s.api_name = 'HR_COMP_OUTCOME_PROFILE_SS.PROCESS_API'

2030: hr_api_transaction_values C
2031: Where s.item_type = p_item_type
2032: and s.item_key = p_item_key
2033: and s.activity_id = nvl((p_activity_id),s.activity_id)
2034: and s.api_name = 'HR_COMP_OUTCOME_PROFILE_SS.PROCESS_API'
2035: AND c.transaction_step_id = s.transaction_step_id
2036: AND c.NAME = 'P_COMPETENCE_ELEMENT_ID'
2037: AND c.number_value = p_competence_element_id;
2038: begin

Line 2053: End hr_comp_outcome_profile_ss;

2049: loop
2050: delete_transaction_step_id(sid_out_cur.transaction_step_id);
2051: END loop;
2052: end;
2053: End hr_comp_outcome_profile_ss;