460: RETURN varchar2 IS
461:
462: cursor csr_item_type_key is
463: select item_type,item_key
464: from hr_api_transaction_steps
465: where transaction_step_id = p_transaction_step_id;
466:
467: l_item_type hr_api_transaction_steps.item_type%type;
468: l_item_key hr_api_transaction_steps.item_key%type;
463: select item_type,item_key
464: from hr_api_transaction_steps
465: where transaction_step_id = p_transaction_step_id;
466:
467: l_item_type hr_api_transaction_steps.item_type%type;
468: l_item_key hr_api_transaction_steps.item_key%type;
469: l_effective_date varchar2(100);
470: l_proc constant varchar2(100) := g_package || ' get_wf_effective_date';
471: BEGIN
464: from hr_api_transaction_steps
465: where transaction_step_id = p_transaction_step_id;
466:
467: l_item_type hr_api_transaction_steps.item_type%type;
468: l_item_key hr_api_transaction_steps.item_key%type;
469: l_effective_date varchar2(100);
470: l_proc constant varchar2(100) := g_package || ' get_wf_effective_date';
471: BEGIN
472: hr_utility.set_location('Entering: '|| l_proc,5);
758: ,ld_trans_effec_date in out nocopy hr_api_transactions.transaction_effective_date%TYPE
759: ,lv_transaction_type in out nocopy hr_api_transactions.transaction_type%TYPE
760: )
761: AS
762: cursor get_function_info ( p_item_type HR_API_TRANSACTION_STEPS.item_type%TYPE
763: ,p_item_key HR_API_TRANSACTION_STEPS.item_key%TYPE ) is
764: select fff.function_id, fff.function_name from
765: fnd_form_functions_vl fff
766: where fff.function_name = ( select iav.text_value
759: ,lv_transaction_type in out nocopy hr_api_transactions.transaction_type%TYPE
760: )
761: AS
762: cursor get_function_info ( p_item_type HR_API_TRANSACTION_STEPS.item_type%TYPE
763: ,p_item_key HR_API_TRANSACTION_STEPS.item_key%TYPE ) is
764: select fff.function_id, fff.function_name from
765: fnd_form_functions_vl fff
766: where fff.function_name = ( select iav.text_value
767: from wf_item_attribute_values iav
1328: ,trs.item_type
1329: ,trs.item_key
1330: ,trs.activity_id
1331: ,trs.creator_person_id
1332: from hr_api_transaction_steps trs
1333: where trs.transaction_id = l_transaction_id
1334: and trs.api_name <> 'HR_COMP_OUTCOME_PROFILE_SS.PROCESS_API' --#4110654
1335: and object_type is null
1336: order by trs.processing_order,trs.transaction_step_id ; --#2313279
1874: ,p_effective_date_option in varchar2 default null
1875: ) AS
1876:
1877:
1878: cursor get_trans_id ( p_trans_step_id HR_API_TRANSACTION_STEPS.transaction_step_id%TYPE) is
1879: select transaction_id from hr_api_transaction_steps
1880: where transaction_step_id = p_trans_step_id;
1881:
1882: l_count INTEGER := 0;
1875: ) AS
1876:
1877:
1878: cursor get_trans_id ( p_trans_step_id HR_API_TRANSACTION_STEPS.transaction_step_id%TYPE) is
1879: select transaction_id from hr_api_transaction_steps
1880: where transaction_step_id = p_trans_step_id;
1881:
1882: l_count INTEGER := 0;
1883: l_result VARCHAR2(100);
1880: where transaction_step_id = p_trans_step_id;
1881:
1882: l_count INTEGER := 0;
1883: l_result VARCHAR2(100);
1884: l_trs_ovn hr_api_transaction_steps.object_version_number%TYPE;
1885: l_original_date date; --ns
1886: l_original_number number; --ns
1887: l_transaction_state varchar2(10) := hr_api.g_varchar2; --ns
1888: l_date date;
1896: lv_section_display_name hr_api_transactions.section_display_name%TYPE;
1897: ln_assignment_id hr_api_transactions.assignment_id%TYPE;
1898: ld_trans_effec_date hr_api_transactions.transaction_effective_date%TYPE;
1899: lv_transaction_type hr_api_transactions.transaction_type%TYPE;
1900: ln_transaction_id hr_api_transaction_steps.transaction_id%TYPE;
1901:
1902: BEGIN
1903:
1904: hr_utility.set_location('Entering: '|| l_proc,5);
2114: FUNCTION get_activity_trans_step_id
2115: (p_activity_name IN
2116: wf_item_activity_statuses_v.activity_name%TYPE
2117: ,p_trans_step_id_tbl IN hr_util_web.g_varchar2_tab_type)
2118: RETURN hr_api_transaction_steps.transaction_step_id%TYPE IS
2119: ln_transaction_step_id
2120: hr_api_transaction_steps.transaction_step_id%TYPE;
2121: li_step_count INTEGER;
2122: l_proc constant varchar2(100) := g_package || ' get_activity_trans_step_id';
2116: wf_item_activity_statuses_v.activity_name%TYPE
2117: ,p_trans_step_id_tbl IN hr_util_web.g_varchar2_tab_type)
2118: RETURN hr_api_transaction_steps.transaction_step_id%TYPE IS
2119: ln_transaction_step_id
2120: hr_api_transaction_steps.transaction_step_id%TYPE;
2121: li_step_count INTEGER;
2122: l_proc constant varchar2(100) := g_package || ' get_activity_trans_step_id';
2123: BEGIN
2124:
2384: return number is
2385:
2386: cursor csr_hats is
2387: select hats.object_version_number
2388: from hr_api_transaction_steps hats
2389: where hats.transaction_step_id = p_transaction_step_id;
2390:
2391: l_ovb number;
2392: l_proc constant varchar2(100) := g_package || ' get_transaction_step_ovn';
2516: ,p_status OUT NOCOPY VARCHAR2) IS
2517:
2518: l_tmp_proc_call varchar2(32000);
2519: l_tmp_proc_call1 varchar2(32000);
2520: l_transaction_step_id hr_api_transaction_steps.transaction_step_id%type;
2521: l_delimiter varchar2(3) := '|!|';
2522: l_start number;
2523: l_start1 number;
2524: l_pos number;
2536: -- csr_wf_active_item Returns the item key of any process which
2537: -- is currently active with the name of p_process and belonging to
2538: -- the given person id
2539: cursor csr_hatv (
2540: p_item_key in hr_api_transaction_steps.item_key%type
2541: ,p_item_Type in hr_api_transaction_steps.item_Type%type
2542: ,p_name in hr_api_transaction_values.name%type
2543: ) is
2544: select val.varchar2_value, val.transaction_step_id
2537: -- is currently active with the name of p_process and belonging to
2538: -- the given person id
2539: cursor csr_hatv (
2540: p_item_key in hr_api_transaction_steps.item_key%type
2541: ,p_item_Type in hr_api_transaction_steps.item_Type%type
2542: ,p_name in hr_api_transaction_values.name%type
2543: ) is
2544: select val.varchar2_value, val.transaction_step_id
2545: from hr_api_transaction_values val, hr_api_transaction_steps step
2541: ,p_item_Type in hr_api_transaction_steps.item_Type%type
2542: ,p_name in hr_api_transaction_values.name%type
2543: ) is
2544: select val.varchar2_value, val.transaction_step_id
2545: from hr_api_transaction_values val, hr_api_transaction_steps step
2546: where step.item_type = p_item_type
2547: and step.item_key = p_item_key
2548: and step.transaction_step_id = val.transaction_step_id
2549: and val.name = p_name
2551: order by step.processing_order, step.transaction_step_id asc;
2552:
2553: cursor csr_act (
2554: p_transaction_step_id
2555: in hr_api_transaction_steps.transaction_step_id%type
2556: ,p_name in hr_api_transaction_values.name%type
2557: ) is
2558: select varchar2_value
2559: from hr_api_transaction_values
2567: p_status := 'SUCCESS';
2568:
2569: select count(transaction_step_id)
2570: into l_tx_step_count
2571: from hr_api_transaction_steps
2572: where item_key = p_item_key
2573: and item_type = p_item_type;
2574:
2575: if l_tx_step_count <> 0 then -- user has changed data in one of the previous pages