1897: -- --------------------------------------------------------------------------
1898: -- declare local variables
1899: -- --------------------------------------------------------------------------
1900: l_proc varchar2(200) := g_package || 'start_transaction';
1901: l_transaction_privilege hr_api_transactions.transaction_privilege%type;
1902: l_transaction_id hr_api_transactions.transaction_id%type;
1903: l_transaction_step_id hr_api_transaction_steps.transaction_step_id%type;
1904:
1905: -- l_person_id hr_api_transactions.creator_person_id%type := p_selected_person_id;
1898: -- declare local variables
1899: -- --------------------------------------------------------------------------
1900: l_proc varchar2(200) := g_package || 'start_transaction';
1901: l_transaction_privilege hr_api_transactions.transaction_privilege%type;
1902: l_transaction_id hr_api_transactions.transaction_id%type;
1903: l_transaction_step_id hr_api_transaction_steps.transaction_step_id%type;
1904:
1905: -- l_person_id hr_api_transactions.creator_person_id%type := p_selected_person_id;
1906:
1901: l_transaction_privilege hr_api_transactions.transaction_privilege%type;
1902: l_transaction_id hr_api_transactions.transaction_id%type;
1903: l_transaction_step_id hr_api_transaction_steps.transaction_step_id%type;
1904:
1905: -- l_person_id hr_api_transactions.creator_person_id%type := p_selected_person_id;
1906:
1907: Cursor c_get_transaction_step_id
1908: is
1909: select
2507: IS
2508:
2509: l_proc varchar2(200) := g_package || 'get_transaction_step_details';
2510:
2511: ln_transaction_id hr_api_transactions.transaction_id%TYPE;
2512: ltt_trans_step_ids hr_util_web.g_varchar2_tab_type;
2513: ltt_trans_obj_vers_num hr_util_web.g_varchar2_tab_type;
2514: ln_trans_step_rows NUMBER ;
2515: lv_activity_name VARCHAR2(100);
2583: IS
2584:
2585:
2586: l_proc varchar2(200) := g_package || 'is_transaction_exists';
2587: ln_transaction_id hr_api_transactions.transaction_id%TYPE;
2588: ltt_trans_step_ids hr_util_web.g_varchar2_tab_type;
2589: ltt_trans_obj_vers_num hr_util_web.g_varchar2_tab_type;
2590: ln_trans_step_rows NUMBER ;
2591: lv_activity_name VARCHAR2(100);
4568: p_ltt_component IN OUT NOCOPY sshr_sal_comp_tab_typ ) IS
4569:
4570: l_proc varchar2(200) := g_package || 'get_transaction_details';
4571: ln_transaction_step_id NUMBER;
4572: ln_transaction_id hr_api_transactions.transaction_id%TYPE;
4573: ltt_trans_step_ids hr_util_web.g_varchar2_tab_type;
4574: ltt_trans_obj_vers_num hr_util_web.g_varchar2_tab_type;
4575: ln_trans_step_rows NUMBER ;
4576: lv_activity_name wf_item_activity_statuses_v.activity_name%type ;
5286: p_ltt_component IN OUT NOCOPY sshr_sal_comp_tab_typ ) IS
5287:
5288: l_proc varchar2(200) := g_package || 'get_txn_details_for_review';
5289: ln_transaction_step_id NUMBER;
5290: ln_transaction_id hr_api_transactions.transaction_id%TYPE;
5291: ltt_trans_step_ids hr_util_web.g_varchar2_tab_type;
5292: ltt_trans_obj_vers_num hr_util_web.g_varchar2_tab_type;
5293: ln_trans_step_rows NUMBER ;
5294: lv_activity_name wf_item_activity_statuses_v.activity_name%type ;