DBA Data[Home] [Help]

APPS.HR_COMP_PROFILE_SS dependencies on HR_COMP_OUTCOME_PROFILE_SS

Line 1184: HR_COMP_OUTCOME_PROFILE_SS.call_process_api(

1180: --
1181: If l_change_mode LIKE 'UPGRADE%' then
1182: null;
1183: else
1184: HR_COMP_OUTCOME_PROFILE_SS.call_process_api(
1185: p_validate => p_validate
1186: ,p_competence_id => l_cmp_element_rec.competence_id
1187: ,p_competence_element_id => l_cmp_element_id
1188: ,p_new_competence_element_id => l_cmp_element_rec.competence_element_id

Line 1225: HR_COMP_OUTCOME_PROFILE_SS.call_process_api(

1221: --
1222: If l_change_mode LIKE 'UPGRADE%' then
1223: null;
1224: else
1225: HR_COMP_OUTCOME_PROFILE_SS.call_process_api(
1226: p_validate => p_validate
1227: ,p_competence_id => l_cmp_element_rec.competence_id
1228: ,p_competence_element_id => l_cmp_element_id
1229: ,p_new_competence_element_id => l_cmp_element_rec.competence_element_id

Line 1262: HR_COMP_OUTCOME_PROFILE_SS.call_process_api(

1258: ,p_effective_date => trunc(sysdate));
1259: IF l_cmp_element_id IS NULL then
1260: l_cmp_element_id := l_cmp_element_rec.competence_element_id;
1261: END if;
1262: HR_COMP_OUTCOME_PROFILE_SS.call_process_api(
1263: p_validate => p_validate
1264: ,p_competence_id => l_cmp_element_rec.competence_id
1265: ,p_competence_element_id => l_cmp_element_id
1266: ,p_new_competence_element_id => l_cmp_element_rec.competence_element_id

Line 1416: HR_COMP_OUTCOME_PROFILE_SS.check_if_cmptnce_rec_changed

1412: ,p_change_mode => p_change_mode
1413: ,p_rec_changed => l_changed);
1414: if l_changed = false THEN
1415: hr_utility.set_location(l_proc,20);
1416: HR_COMP_OUTCOME_PROFILE_SS.check_if_cmptnce_rec_changed
1417: (p_item_type => p_item_type
1418: ,p_item_key => p_item_key
1419: ,p_activity_id => p_activity_id
1420: ,p_pid => p_pid

Line 1678: -- HR_COMP_OUTCOME_PROFILE_SS.delete_add_page(

1674: ,p_item_key => p_item_key);
1675: for I in get_upd_ids(l_transaction_id) loop
1676: hr_utility.set_location(l_proc || 'LOOP' ,10);
1677: -- Added for competence Qualification link enhancement
1678: -- HR_COMP_OUTCOME_PROFILE_SS.delete_add_page(
1679: -- p_transaction_step_id => I.transaction_step_id);
1680: -- End for competence Qualification link enhancement
1681: delete from hr_api_transaction_values
1682: where transaction_step_id = I.transaction_step_id;

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

2549: hr_api_transaction_values D
2550: Where s.item_type = p_item_type
2551: and s.item_key = p_item_key
2552: and s.activity_id = nvl((p_activity_id),s.activity_id)
2553: and s.api_name = 'HR_COMP_OUTCOME_PROFILE_SS.PROCESS_API'
2554: AND c.transaction_step_id = s.transaction_step_id
2555: AND c.NAME = 'P_COMPETENCE_ID'
2556: AND c.number_value = p_competence_id
2557: AND a.transaction_step_id = s.transaction_step_id

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

2589: hr_api_transaction_values D
2590: Where s.item_type = p_item_type
2591: and s.item_key = p_item_key
2592: and s.activity_id = nvl((p_activity_id),s.activity_id)
2593: and s.api_name = 'HR_COMP_OUTCOME_PROFILE_SS.PROCESS_API'
2594: AND c.transaction_step_id = s.transaction_step_id
2595: AND c.NAME = 'P_COMPETENCE_ID'
2596: AND c.number_value = p_competence_id
2597: AND a.transaction_step_id = s.transaction_step_id

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

2769: hr_api_transaction_values D
2770: Where s.item_type = p_item_type
2771: and s.item_key = p_item_key
2772: and s.activity_id = nvl((p_activity_id),s.activity_id)
2773: and s.api_name = 'HR_COMP_OUTCOME_PROFILE_SS.PROCESS_API'
2774: AND c.transaction_step_id = s.transaction_step_id
2775: AND c.NAME = 'P_COMPETENCE_ID'
2776: AND c.number_value = p_competence_id
2777: AND a.transaction_step_id = s.transaction_step_id

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

2794: hr_api_transaction_values D
2795: Where s.item_type = p_item_type
2796: and s.item_key = p_item_key
2797: and s.activity_id = nvl((p_activity_id),s.activity_id)
2798: and s.api_name = 'HR_COMP_OUTCOME_PROFILE_SS.PROCESS_API'
2799: AND c.transaction_step_id = s.transaction_step_id
2800: AND c.NAME = 'P_COMPETENCE_ID'
2801: AND c.number_value = p_competence_id
2802: AND a.transaction_step_id = s.transaction_step_id

Line 2891: /* HR_COMP_OUTCOME_PROFILE_SS.delete_add_page(

2887: hr_utility.set_location(l_proc || 'LOOP' , 10);
2888: if substr(transaction_step_ids,i,1) = ',' then
2889: hr_utility.set_location(l_proc , 15);
2890: -- Calling the procedure to delete related transaction step ids for outcome.
2891: /* HR_COMP_OUTCOME_PROFILE_SS.delete_add_page(
2892: p_transaction_step_id => to_number(j)); */
2893: delete from hr_api_transaction_values where transaction_step_id = to_number(j);
2894: delete from hr_api_transaction_steps where transaction_step_id = to_number(j);
2895: j := '' ;