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

Line 527: from hr_api_transaction_steps

523: RETURN varchar2 IS
524:
525: cursor csr_item_type_key is
526: select item_type,item_key
527: from hr_api_transaction_steps
528: where transaction_step_id = p_transaction_step_id;
529:
530: l_item_type hr_api_transaction_steps.item_type%type;
531: l_item_key hr_api_transaction_steps.item_key%type;

Line 530: l_item_type hr_api_transaction_steps.item_type%type;

526: select item_type,item_key
527: from hr_api_transaction_steps
528: where transaction_step_id = p_transaction_step_id;
529:
530: l_item_type hr_api_transaction_steps.item_type%type;
531: l_item_key hr_api_transaction_steps.item_key%type;
532: l_effective_date varchar2(100);
533: l_proc constant varchar2(100) := g_package || ' get_wf_effective_date';
534: BEGIN

Line 531: l_item_key hr_api_transaction_steps.item_key%type;

527: from hr_api_transaction_steps
528: where transaction_step_id = p_transaction_step_id;
529:
530: l_item_type hr_api_transaction_steps.item_type%type;
531: l_item_key hr_api_transaction_steps.item_key%type;
532: l_effective_date varchar2(100);
533: l_proc constant varchar2(100) := g_package || ' get_wf_effective_date';
534: BEGIN
535: hr_utility.set_location('Entering: '|| l_proc,5);

Line 825: cursor get_function_info ( p_item_type HR_API_TRANSACTION_STEPS.item_type%TYPE

821: ,ld_trans_effec_date in out nocopy hr_api_transactions.transaction_effective_date%TYPE
822: ,lv_transaction_type in out nocopy hr_api_transactions.transaction_type%TYPE
823: )
824: AS
825: cursor get_function_info ( p_item_type HR_API_TRANSACTION_STEPS.item_type%TYPE
826: ,p_item_key HR_API_TRANSACTION_STEPS.item_key%TYPE ) is
827: select fff.function_id, fff.function_name from
828: fnd_form_functions_vl fff
829: where fff.function_name = ( select iav.text_value

Line 826: ,p_item_key HR_API_TRANSACTION_STEPS.item_key%TYPE ) is

822: ,lv_transaction_type in out nocopy hr_api_transactions.transaction_type%TYPE
823: )
824: AS
825: cursor get_function_info ( p_item_type HR_API_TRANSACTION_STEPS.item_type%TYPE
826: ,p_item_key HR_API_TRANSACTION_STEPS.item_key%TYPE ) is
827: select fff.function_id, fff.function_name from
828: fnd_form_functions_vl fff
829: where fff.function_name = ( select iav.text_value
830: from wf_item_attribute_values iav

Line 1418: from hr_api_transaction_steps trs

1414: ,trs.item_type
1415: ,trs.item_key
1416: ,trs.activity_id
1417: ,trs.creator_person_id
1418: from hr_api_transaction_steps trs
1419: where trs.transaction_id = l_transaction_id
1420: and trs.api_name <> 'HR_COMP_OUTCOME_PROFILE_SS.PROCESS_API' --#4110654
1421: and object_type is null
1422: order by trs.processing_order,trs.transaction_step_id ; --#2313279

Line 2035: cursor get_trans_id ( p_trans_step_id HR_API_TRANSACTION_STEPS.transaction_step_id%TYPE) is

2031: ,p_effective_date_option in varchar2 default null
2032: ) AS
2033:
2034:
2035: cursor get_trans_id ( p_trans_step_id HR_API_TRANSACTION_STEPS.transaction_step_id%TYPE) is
2036: select transaction_id from hr_api_transaction_steps
2037: where transaction_step_id = p_trans_step_id;
2038:
2039: l_count INTEGER := 0;

Line 2036: select transaction_id from hr_api_transaction_steps

2032: ) AS
2033:
2034:
2035: cursor get_trans_id ( p_trans_step_id HR_API_TRANSACTION_STEPS.transaction_step_id%TYPE) is
2036: select transaction_id from hr_api_transaction_steps
2037: where transaction_step_id = p_trans_step_id;
2038:
2039: l_count INTEGER := 0;
2040: l_result VARCHAR2(100);

Line 2041: l_trs_ovn hr_api_transaction_steps.object_version_number%TYPE;

2037: where transaction_step_id = p_trans_step_id;
2038:
2039: l_count INTEGER := 0;
2040: l_result VARCHAR2(100);
2041: l_trs_ovn hr_api_transaction_steps.object_version_number%TYPE;
2042: l_original_date date; --ns
2043: l_original_number number; --ns
2044: l_transaction_state varchar2(10) := hr_api.g_varchar2; --ns
2045: l_date date;

Line 2057: ln_transaction_id hr_api_transaction_steps.transaction_id%TYPE;

2053: lv_section_display_name hr_api_transactions.section_display_name%TYPE;
2054: ln_assignment_id hr_api_transactions.assignment_id%TYPE;
2055: ld_trans_effec_date hr_api_transactions.transaction_effective_date%TYPE;
2056: lv_transaction_type hr_api_transactions.transaction_type%TYPE;
2057: ln_transaction_id hr_api_transaction_steps.transaction_id%TYPE;
2058:
2059: BEGIN
2060:
2061: hr_utility.set_location('Entering: '|| l_proc,5);

Line 2275: RETURN hr_api_transaction_steps.transaction_step_id%TYPE IS

2271: FUNCTION get_activity_trans_step_id
2272: (p_activity_name IN
2273: wf_item_activity_statuses_v.activity_name%TYPE
2274: ,p_trans_step_id_tbl IN hr_util_web.g_varchar2_tab_type)
2275: RETURN hr_api_transaction_steps.transaction_step_id%TYPE IS
2276: ln_transaction_step_id
2277: hr_api_transaction_steps.transaction_step_id%TYPE;
2278: li_step_count INTEGER;
2279: l_proc constant varchar2(100) := g_package || ' get_activity_trans_step_id';

Line 2277: hr_api_transaction_steps.transaction_step_id%TYPE;

2273: wf_item_activity_statuses_v.activity_name%TYPE
2274: ,p_trans_step_id_tbl IN hr_util_web.g_varchar2_tab_type)
2275: RETURN hr_api_transaction_steps.transaction_step_id%TYPE IS
2276: ln_transaction_step_id
2277: hr_api_transaction_steps.transaction_step_id%TYPE;
2278: li_step_count INTEGER;
2279: l_proc constant varchar2(100) := g_package || ' get_activity_trans_step_id';
2280: BEGIN
2281:

Line 2545: from hr_api_transaction_steps hats

2541: return number is
2542:
2543: cursor csr_hats is
2544: select hats.object_version_number
2545: from hr_api_transaction_steps hats
2546: where hats.transaction_step_id = p_transaction_step_id;
2547:
2548: l_ovb number;
2549: l_proc constant varchar2(100) := g_package || ' get_transaction_step_ovn';

Line 2677: l_transaction_step_id hr_api_transaction_steps.transaction_step_id%type;

2673: ,p_status OUT NOCOPY VARCHAR2) IS
2674:
2675: l_tmp_proc_call varchar2(32000);
2676: l_tmp_proc_call1 varchar2(32000);
2677: l_transaction_step_id hr_api_transaction_steps.transaction_step_id%type;
2678: l_delimiter varchar2(3) := '|!|';
2679: l_start number;
2680: l_start1 number;
2681: l_pos number;

Line 2697: p_item_key in hr_api_transaction_steps.item_key%type

2693: -- csr_wf_active_item Returns the item key of any process which
2694: -- is currently active with the name of p_process and belonging to
2695: -- the given person id
2696: cursor csr_hatv (
2697: p_item_key in hr_api_transaction_steps.item_key%type
2698: ,p_item_Type in hr_api_transaction_steps.item_Type%type
2699: ,p_name in hr_api_transaction_values.name%type
2700: ) is
2701: select val.varchar2_value, val.transaction_step_id

Line 2698: ,p_item_Type in hr_api_transaction_steps.item_Type%type

2694: -- is currently active with the name of p_process and belonging to
2695: -- the given person id
2696: cursor csr_hatv (
2697: p_item_key in hr_api_transaction_steps.item_key%type
2698: ,p_item_Type in hr_api_transaction_steps.item_Type%type
2699: ,p_name in hr_api_transaction_values.name%type
2700: ) is
2701: select val.varchar2_value, val.transaction_step_id
2702: from hr_api_transaction_values val, hr_api_transaction_steps step

Line 2702: from hr_api_transaction_values val, hr_api_transaction_steps step

2698: ,p_item_Type in hr_api_transaction_steps.item_Type%type
2699: ,p_name in hr_api_transaction_values.name%type
2700: ) is
2701: select val.varchar2_value, val.transaction_step_id
2702: from hr_api_transaction_values val, hr_api_transaction_steps step
2703: where step.item_type = p_item_type
2704: and step.item_key = p_item_key
2705: and step.transaction_step_id = val.transaction_step_id
2706: and val.name = p_name

Line 2712: in hr_api_transaction_steps.transaction_step_id%type

2708: order by step.processing_order, step.transaction_step_id asc;
2709:
2710: cursor csr_act (
2711: p_transaction_step_id
2712: in hr_api_transaction_steps.transaction_step_id%type
2713: ,p_name in hr_api_transaction_values.name%type
2714: ) is
2715: select varchar2_value
2716: from hr_api_transaction_values

Line 2728: from hr_api_transaction_steps

2724: p_status := 'SUCCESS';
2725:
2726: select count(transaction_step_id)
2727: into l_tx_step_count
2728: from hr_api_transaction_steps
2729: where item_key = p_item_key
2730: and item_type = p_item_type;
2731:
2732: if l_tx_step_count <> 0 then -- user has changed data in one of the previous pages