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);
2516: lv_activity_display_name VARCHAR2(100);
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);
2516: lv_activity_display_name VARCHAR2(100);
2517: ln_no_of_components NUMBER ;
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);
2592: lv_activity_display_name VARCHAR2(100);
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);
2592: lv_activity_display_name VARCHAR2(100);
2593: ln_no_of_components NUMBER ;
3105: li_count INTEGER ;
3106: lv_api_name hr_api_transaction_steps.api_name%type ;
3107: ln_ovn hr_api_transaction_steps.object_version_number%TYPE;
3108: ln_transaction_step_id hr_api_transaction_steps.transaction_step_id%TYPE default null;
3109: ltt_trans_step_ids hr_util_web.g_varchar2_tab_type;
3110: ltt_trans_obj_vers_num hr_util_web.g_varchar2_tab_type;
3111: ln_trans_step_rows number default 0;
3112: lv_activity_name wf_item_activity_statuses_v.activity_name%TYPE;
3113: ln_no_of_components NUMBER ;
3106: lv_api_name hr_api_transaction_steps.api_name%type ;
3107: ln_ovn hr_api_transaction_steps.object_version_number%TYPE;
3108: ln_transaction_step_id hr_api_transaction_steps.transaction_step_id%TYPE default null;
3109: ltt_trans_step_ids hr_util_web.g_varchar2_tab_type;
3110: ltt_trans_obj_vers_num hr_util_web.g_varchar2_tab_type;
3111: ln_trans_step_rows number default 0;
3112: lv_activity_name wf_item_activity_statuses_v.activity_name%TYPE;
3113: ln_no_of_components NUMBER ;
3114: lv_review_url VARCHAR2(1000) ;
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 ;
4577: ln_no_of_components NUMBER ;
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 ;
4577: ln_no_of_components NUMBER ;
4578: i INTEGER ;
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 ;
5295: ln_no_of_components NUMBER ;
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 ;
5295: ln_no_of_components NUMBER ;
5296: i INTEGER ;