DBA Data[Home] [Help]

APPS.HR_PAY_RATE_SS dependencies on HR_UTIL_WEB

Line 2512: ltt_trans_step_ids hr_util_web.g_varchar2_tab_type;

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);

Line 2513: ltt_trans_obj_vers_num hr_util_web.g_varchar2_tab_type;

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 ;

Line 2588: ltt_trans_step_ids hr_util_web.g_varchar2_tab_type;

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);

Line 2589: ltt_trans_obj_vers_num hr_util_web.g_varchar2_tab_type;

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 ;

Line 3109: ltt_trans_step_ids hr_util_web.g_varchar2_tab_type;

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 ;

Line 3110: ltt_trans_obj_vers_num hr_util_web.g_varchar2_tab_type;

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) ;

Line 4573: ltt_trans_step_ids hr_util_web.g_varchar2_tab_type;

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 ;

Line 4574: ltt_trans_obj_vers_num hr_util_web.g_varchar2_tab_type;

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 ;

Line 5291: ltt_trans_step_ids hr_util_web.g_varchar2_tab_type;

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 ;

Line 5292: ltt_trans_obj_vers_num hr_util_web.g_varchar2_tab_type;

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 ;