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_PROFILE_SS dependencies on HR_API_TRANSACTION_STEPS

Line 328: from hr_api_transaction_steps s, hr_api_transaction_values a,

324: l_proc varchar2(200) := g_package || 'comp_not_exists';
325: l_retStatus varchar2(1) := 'T';
326: cursor c1 is
327: select 'F' status
328: from hr_api_transaction_steps s, hr_api_transaction_values a,
329: hr_api_transaction_values b
330: Where s.item_type = p_item_type
331: and s.item_key = p_item_key
332: and s.transaction_step_id = a.transaction_step_id

Line 337: select 'F' status from hr_api_transaction_steps ts, hr_api_transactions t

333: and s.transaction_step_id = b.transaction_step_id
334: and a.name = 'P_COMPETENCE_ID' and a.number_value = p_competence_id
335: and b.name = 'P_PERSON_ID' and b.number_value = p_person_id
336: union
337: select 'F' status from hr_api_transaction_steps ts, hr_api_transactions t
338: where ts.api_name = 'HR_COMP_PROFILE_SS.PROCESS_API'
339: and ts.transaction_id = t.transaction_id
340: and t.selected_person_id = p_person_id and t.status = 'Y'
341: and exists (Select 'e' From hr_api_transaction_values c

Line 604: hr_api_transaction_steps steps

600: select a.transaction_step_id
601: into l_transaction_step_id
602: from hr_api_transaction_values a,
603: hr_api_transaction_values b,
604: hr_api_transaction_steps steps
605: where steps.transaction_id = l_transaction_id
606: and steps.transaction_step_id = a.transaction_step_id
607: and a.name = 'P_CHANGE_MODE'
608: and a.varchar2_value = 'UPGRADE'

Line 1017: l_item_type hr_api_transaction_steps.item_type%type;

1013: l_upgraded_from_rec_id number DEFAULT Null;
1014: l_preupd_proficy_lvl_id number default NULL;
1015: l_competence_name per_competences_vl.name%type;
1016: l_step_value per_rating_levels.step_value%type;
1017: l_item_type hr_api_transaction_steps.item_type%type;
1018: l_item_key hr_api_transaction_steps.item_key%type;
1019: l_activity_id hr_api_transaction_steps.ACTIVITY_ID%type;
1020: l_cmp_element_id per_competence_elements.competence_element_id%type;
1021: l_achieved_date per_competence_elements.ACHIEVED_DATE%type;

Line 1018: l_item_key hr_api_transaction_steps.item_key%type;

1014: l_preupd_proficy_lvl_id number default NULL;
1015: l_competence_name per_competences_vl.name%type;
1016: l_step_value per_rating_levels.step_value%type;
1017: l_item_type hr_api_transaction_steps.item_type%type;
1018: l_item_key hr_api_transaction_steps.item_key%type;
1019: l_activity_id hr_api_transaction_steps.ACTIVITY_ID%type;
1020: l_cmp_element_id per_competence_elements.competence_element_id%type;
1021: l_achieved_date per_competence_elements.ACHIEVED_DATE%type;
1022: l_change_mode varchar2(80);

Line 1019: l_activity_id hr_api_transaction_steps.ACTIVITY_ID%type;

1015: l_competence_name per_competences_vl.name%type;
1016: l_step_value per_rating_levels.step_value%type;
1017: l_item_type hr_api_transaction_steps.item_type%type;
1018: l_item_key hr_api_transaction_steps.item_key%type;
1019: l_activity_id hr_api_transaction_steps.ACTIVITY_ID%type;
1020: l_cmp_element_id per_competence_elements.competence_element_id%type;
1021: l_achieved_date per_competence_elements.ACHIEVED_DATE%type;
1022: l_change_mode varchar2(80);
1023: l_status per_competence_elements.status%type;

Line 1133: FROM hr_api_transaction_steps

1129: (p_transaction_step_id => p_transaction_step_id
1130: ,p_name => 'P_STATUS');
1131: Select ITEM_TYPE,ITEM_KEY,ACTIVITY_ID
1132: INTO l_item_type, l_item_key, l_activity_id
1133: FROM hr_api_transaction_steps
1134: WHERE transaction_step_id = p_transaction_step_id;
1135: l_cmp_element_rec.status := PerCompStatus.Get_Competence_Status(
1136: p_item_type =>l_item_type
1137: ,p_item_key =>l_item_key

Line 1366: FROM hr_api_transaction_steps s,

1362: ,p_competence_element_id IN number
1363: ,p_competence_id IN number
1364: ,p_change_mode IN varchar2) is
1365: Select s.transaction_step_id
1366: FROM hr_api_transaction_steps s,
1367: hr_api_transaction_values c, hr_api_transaction_values d,
1368: hr_api_transaction_values e, hr_api_transaction_values f
1369: WHERE
1370: s.item_type = p_item_type

Line 1637: from hr_api_transaction_steps step, hr_api_transaction_values val

1633: ,p_rows out nocopy number) is
1634: l_proc varchar2(200) := g_package || 'get_pending_addition_ids';
1635: cursor get_add_ids (p_transaction_id number) is
1636: select step.transaction_step_id
1637: from hr_api_transaction_steps step, hr_api_transaction_values val
1638: where step.transaction_id = p_transaction_id
1639: and val.transaction_step_id = step.transaction_step_id
1640: and val.varchar2_value = 'ADD';
1641: l_index number;

Line 1663: from hr_api_transaction_values val, hr_api_transaction_steps steps

1659: ,p_item_key IN varchar2) is
1660: l_proc varchar2(200) := g_package || 'del_pen_currupd_ids';
1661: cursor get_upd_ids(p_transaction_id number) is
1662: select steps.transaction_step_id
1663: from hr_api_transaction_values val, hr_api_transaction_steps steps
1664: where steps.transaction_id = p_transaction_id
1665: and steps.transaction_step_id = val.transaction_step_id
1666: and val.name = 'P_CHANGE_MODE'
1667: and val.varchar2_value IN ('UPDATE_APPLY','UPDATE_HIST');

Line 1683: delete from hr_api_transaction_steps

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;
1683: delete from hr_api_transaction_steps
1684: where transaction_step_id = I.transaction_step_id;
1685: end loop;
1686: del_add_ids(p_item_type, p_item_key);
1687: commit;

Line 1696: from hr_api_transaction_values val, hr_api_transaction_steps steps

1692: ,p_item_key IN varchar2) is
1693: l_proc varchar2(200) := g_package || 'del_add_ids';
1694: cursor get_add_ids(p_transaction_id number) is
1695: select steps.transaction_step_id
1696: from hr_api_transaction_values val, hr_api_transaction_steps steps
1697: where steps.transaction_id = p_transaction_id
1698: and steps.transaction_step_id = val.transaction_step_id
1699: and val.varchar2_value = 'ADD';
1700: l_step_values number ;

Line 1711: delete from hr_api_transaction_steps

1707: for I in get_add_ids(l_transaction_id) loop
1708: hr_utility.set_location(l_proc || 'LOOP' ,10);
1709: delete from hr_api_transaction_values
1710: where transaction_step_id = I.transaction_step_id;
1711: delete from hr_api_transaction_steps
1712: where transaction_id = l_transaction_id
1713: and transaction_step_id = I.transaction_step_id;
1714: end loop ;
1715: hr_utility.set_location(' Leaving:' || l_proc,15);

Line 1783: from hr_api_transaction_steps

1779: ,p_item_key in varchar2) is
1780: l_proc varchar2(200) := g_package || 'delete_all_ids';
1781: cursor get_all_ids (p_transaction_id number) is
1782: select transaction_step_id
1783: from hr_api_transaction_steps
1784: where transaction_id = p_transaction_id;
1785: l_result number ;
1786: l_transaction_id number ;
1787: begin

Line 1796: delete from hr_api_transaction_steps

1792: for l_result in get_all_ids(p_transaction_id => l_transaction_id) loop
1793: hr_utility.set_location(l_proc || 'LOOP',10);
1794: delete from hr_api_transaction_values
1795: where transaction_step_id = l_result.transaction_step_id;
1796: delete from hr_api_transaction_steps
1797: where transaction_id = l_transaction_id
1798: and transaction_step_id = l_result.transaction_step_id;
1799: end loop ;
1800: commit;

Line 1816: from hr_api_transaction_steps

1812: BEGIN
1813: hr_utility.set_location(' Entering:' || l_proc,5);
1814: l_transaction_step_id := p_transaction_step_id;
1815: select transaction_id into l_transaction_id
1816: from hr_api_transaction_steps
1817: where transaction_step_id = l_transaction_step_id
1818: and rownum = 1;
1819: select varchar2_value
1820: into l_mode

Line 1833: hr_api_transaction_steps steps

1829: where transaction_step_id = l_transaction_step_id
1830: and NAME = 'P_UPGRADED_FROM_REC_ID';
1831: select a.transaction_step_id into l_txid
1832: from hr_api_transaction_values a,hr_api_transaction_values b,
1833: hr_api_transaction_steps steps
1834: where steps.transaction_id = l_transaction_id
1835: and steps.transaction_step_id = a.transaction_step_id
1836: and a.name = 'P_CHANGE_MODE'
1837: and a.varchar2_value = 'UPGRADE'

Line 1843: delete from hr_api_transaction_steps where transaction_step_id = l_transaction_step_id ;

1839: and b.name = 'P_COMPETENCE_ELEMENT_ID'
1840: and b.number_value = l_competence_element_id
1841: and a.transaction_step_id <> l_transaction_step_id;
1842: delete from hr_api_transaction_values where transaction_step_id = l_transaction_step_id ;
1843: delete from hr_api_transaction_steps where transaction_step_id = l_transaction_step_id ;
1844: delete from hr_api_transaction_values where transaction_step_id = l_txid ;
1845: delete from hr_api_transaction_steps where transaction_step_id = l_txid ;
1846: else
1847: delete from hr_api_transaction_values where transaction_step_id = l_transaction_step_id ;

Line 1845: delete from hr_api_transaction_steps where transaction_step_id = l_txid ;

1841: and a.transaction_step_id <> l_transaction_step_id;
1842: delete from hr_api_transaction_values where transaction_step_id = l_transaction_step_id ;
1843: delete from hr_api_transaction_steps where transaction_step_id = l_transaction_step_id ;
1844: delete from hr_api_transaction_values where transaction_step_id = l_txid ;
1845: delete from hr_api_transaction_steps where transaction_step_id = l_txid ;
1846: else
1847: delete from hr_api_transaction_values where transaction_step_id = l_transaction_step_id ;
1848: delete from hr_api_transaction_steps where transaction_step_id = l_transaction_step_id ;
1849: end if;

Line 1848: delete from hr_api_transaction_steps where transaction_step_id = l_transaction_step_id ;

1844: delete from hr_api_transaction_values where transaction_step_id = l_txid ;
1845: delete from hr_api_transaction_steps where transaction_step_id = l_txid ;
1846: else
1847: delete from hr_api_transaction_values where transaction_step_id = l_transaction_step_id ;
1848: delete from hr_api_transaction_steps where transaction_step_id = l_transaction_step_id ;
1849: end if;
1850: commit ;
1851: hr_utility.set_location(' Leaving:' || l_proc,15);
1852: END;

Line 2153: hr_api_transaction_steps steps

2149: update hr_api_transaction_values val
2150: set val.varchar2_value = 'UPGRADE'
2151: where val.transaction_step_id in (select val1.transaction_step_id
2152: from hr_api_transaction_values val1,
2153: hr_api_transaction_steps steps
2154: where steps.transaction_id = l_transaction_id
2155: and steps.transaction_step_id = val1.transaction_step_id
2156: and val1.name = 'P_COMPETENCE_ELEMENT_ID'
2157: and val1.number_value = p_competence_element_id)

Line 2199: hr_api_transaction_steps steps

2195: where transaction_step_id = l_transaction_step_id
2196: and NAME = 'P_UPGRADED_FROM_REC_ID';
2197: select a.transaction_step_id into l_tx_step_id
2198: from hr_api_transaction_values a,hr_api_transaction_values b,
2199: hr_api_transaction_steps steps
2200: where steps.transaction_id = l_transaction_id
2201: and steps.transaction_step_id = a.transaction_step_id
2202: and a.name = 'P_CHANGE_MODE'
2203: and a.varchar2_value = 'UPGRADE'

Line 2546: FROM hr_api_transaction_steps S,

2542: END if;
2543: hr_utility.set_location(' Leaving:' || l_proc,10);
2544: -- added for competency start date > outcome start date
2545: Select count(*) INTO l_count
2546: FROM hr_api_transaction_steps S,
2547: hr_api_transaction_values A,
2548: hr_api_transaction_values C,
2549: hr_api_transaction_values D
2550: Where s.item_type = p_item_type

Line 2586: FROM hr_api_transaction_steps S,

2582: p_app_short_name => 'PER',
2583: P_SINGLE_ERROR_MESSAGE => 'HR_COMP_INV_LEVEL_SS');
2584: else
2585: Select count(*) INTO l_count
2586: FROM hr_api_transaction_steps S,
2587: hr_api_transaction_values A,
2588: hr_api_transaction_values C,
2589: hr_api_transaction_values D
2590: Where s.item_type = p_item_type

Line 2665: from hr_api_transaction_steps s, hr_api_transaction_values a,

2661: where competence_id = p_competence_id;
2662: --bug 2946360 Fix
2663: cursor c1 is
2664: select 'F' status
2665: from hr_api_transaction_steps s, hr_api_transaction_values a,
2666: hr_api_transaction_values b, hr_api_transaction_values d
2667: Where s.item_type = p_item_type
2668: and s.item_key = p_item_key
2669: and s.transaction_step_id = a.transaction_step_id

Line 2676: select 'F' status from hr_api_transaction_steps ts, hr_api_transactions t

2672: and a.name = 'P_COMPETENCE_ID' and a.number_value = p_competence_id
2673: and b.name = 'P_PERSON_ID' and b.number_value = p_person_id
2674: and d.name = 'P_CHANGE_MODE' and d.varchar2_value <> 'ADD'
2675: union
2676: select 'F' status from hr_api_transaction_steps ts, hr_api_transactions t
2677: where ts.api_name = 'HR_COMP_PROFILE_SS.PROCESS_API'
2678: and ts.transaction_id = t.transaction_id
2679: and t.selected_person_id = p_person_id and t.status = 'Y'
2680: and exists (Select 'e' From hr_api_transaction_values c

Line 2766: FROM hr_api_transaction_steps S,

2762:
2763: --FOR bug fix 4136402
2764: End If;
2765: Select count(*) INTO l_count
2766: FROM hr_api_transaction_steps S,
2767: hr_api_transaction_values A,
2768: hr_api_transaction_values C,
2769: hr_api_transaction_values D
2770: Where s.item_type = p_item_type

Line 2791: FROM hr_api_transaction_steps S,

2787: END if;
2788:
2789: IF (p_eff_date_to IS NOT null) then
2790: Select count(*) INTO l_count
2791: FROM hr_api_transaction_steps S,
2792: hr_api_transaction_values A,
2793: hr_api_transaction_values C,
2794: hr_api_transaction_values D
2795: Where s.item_type = p_item_type

Line 2894: delete from hr_api_transaction_steps where transaction_step_id = to_number(j);

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 := '' ;
2896: else
2897: hr_utility.set_location(l_proc , 20);
2898: j := j || substr(transaction_step_ids,i,1);

Line 2917: from hr_api_transaction_steps steps

2913: ,p_item_key => p_item_key);
2914: update hr_api_transaction_values val
2915: set val.varchar2_value = 'ADDITION'
2916: where transaction_step_id in (select transaction_step_id
2917: from hr_api_transaction_steps steps
2918: where steps.transaction_id = l_transaction_id)
2919: and val.name = 'P_CHANGE_MODE' and val.varchar2_value = 'ADD';
2920: hr_utility.set_location(' Leaving:' || l_proc,10);
2921: end add_to_addition;

Line 3004: from hr_api_transaction_steps

3000: ,p_review_proc_call in varchar2) is
3001: l_proc varchar2(200) := g_package || 'write_proc_actid';
3002: cursor c1 is
3003: select transaction_step_id
3004: from hr_api_transaction_steps
3005: where item_type = p_item_type
3006: and item_key = p_item_key
3007: and activity_id = p_activity_id;
3008: l_step_values c1%rowtype;