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_PAY_RATE_SS dependencies on HR_UTIL_WEB

Line 2412: ltt_trans_step_ids hr_util_web.g_varchar2_tab_type;

2408:
2409: l_proc varchar2(200) := g_package || 'get_transaction_step_details';
2410:
2411: ln_transaction_id hr_api_transactions.transaction_id%TYPE;
2412: ltt_trans_step_ids hr_util_web.g_varchar2_tab_type;
2413: ltt_trans_obj_vers_num hr_util_web.g_varchar2_tab_type;
2414: ln_trans_step_rows NUMBER ;
2415: lv_activity_name VARCHAR2(100);
2416: lv_activity_display_name VARCHAR2(100);

Line 2413: ltt_trans_obj_vers_num hr_util_web.g_varchar2_tab_type;

2409: l_proc varchar2(200) := g_package || 'get_transaction_step_details';
2410:
2411: ln_transaction_id hr_api_transactions.transaction_id%TYPE;
2412: ltt_trans_step_ids hr_util_web.g_varchar2_tab_type;
2413: ltt_trans_obj_vers_num hr_util_web.g_varchar2_tab_type;
2414: ln_trans_step_rows NUMBER ;
2415: lv_activity_name VARCHAR2(100);
2416: lv_activity_display_name VARCHAR2(100);
2417: ln_no_of_components NUMBER ;

Line 2488: ltt_trans_step_ids hr_util_web.g_varchar2_tab_type;

2484:
2485:
2486: l_proc varchar2(200) := g_package || 'is_transaction_exists';
2487: ln_transaction_id hr_api_transactions.transaction_id%TYPE;
2488: ltt_trans_step_ids hr_util_web.g_varchar2_tab_type;
2489: ltt_trans_obj_vers_num hr_util_web.g_varchar2_tab_type;
2490: ln_trans_step_rows NUMBER ;
2491: lv_activity_name VARCHAR2(100);
2492: lv_activity_display_name VARCHAR2(100);

Line 2489: ltt_trans_obj_vers_num hr_util_web.g_varchar2_tab_type;

2485:
2486: l_proc varchar2(200) := g_package || 'is_transaction_exists';
2487: ln_transaction_id hr_api_transactions.transaction_id%TYPE;
2488: ltt_trans_step_ids hr_util_web.g_varchar2_tab_type;
2489: ltt_trans_obj_vers_num hr_util_web.g_varchar2_tab_type;
2490: ln_trans_step_rows NUMBER ;
2491: lv_activity_name VARCHAR2(100);
2492: lv_activity_display_name VARCHAR2(100);
2493: ln_no_of_components NUMBER ;

Line 2952: ltt_trans_step_ids hr_util_web.g_varchar2_tab_type;

2948: li_count INTEGER ;
2949: lv_api_name hr_api_transaction_steps.api_name%type ;
2950: ln_ovn hr_api_transaction_steps.object_version_number%TYPE;
2951: ln_transaction_step_id hr_api_transaction_steps.transaction_step_id%TYPE default null;
2952: ltt_trans_step_ids hr_util_web.g_varchar2_tab_type;
2953: ltt_trans_obj_vers_num hr_util_web.g_varchar2_tab_type;
2954: ln_trans_step_rows number default 0;
2955: lv_activity_name wf_item_activity_statuses_v.activity_name%TYPE;
2956: ln_no_of_components NUMBER ;

Line 2953: ltt_trans_obj_vers_num hr_util_web.g_varchar2_tab_type;

2949: lv_api_name hr_api_transaction_steps.api_name%type ;
2950: ln_ovn hr_api_transaction_steps.object_version_number%TYPE;
2951: ln_transaction_step_id hr_api_transaction_steps.transaction_step_id%TYPE default null;
2952: ltt_trans_step_ids hr_util_web.g_varchar2_tab_type;
2953: ltt_trans_obj_vers_num hr_util_web.g_varchar2_tab_type;
2954: ln_trans_step_rows number default 0;
2955: lv_activity_name wf_item_activity_statuses_v.activity_name%TYPE;
2956: ln_no_of_components NUMBER ;
2957: lv_review_url VARCHAR2(1000) ;

Line 4412: ltt_trans_step_ids hr_util_web.g_varchar2_tab_type;

4408:
4409: l_proc varchar2(200) := g_package || 'get_transaction_details';
4410: ln_transaction_step_id NUMBER;
4411: ln_transaction_id hr_api_transactions.transaction_id%TYPE;
4412: ltt_trans_step_ids hr_util_web.g_varchar2_tab_type;
4413: ltt_trans_obj_vers_num hr_util_web.g_varchar2_tab_type;
4414: ln_trans_step_rows NUMBER ;
4415: lv_activity_name wf_item_activity_statuses_v.activity_name%type ;
4416: ln_no_of_components NUMBER ;

Line 4413: ltt_trans_obj_vers_num hr_util_web.g_varchar2_tab_type;

4409: l_proc varchar2(200) := g_package || 'get_transaction_details';
4410: ln_transaction_step_id NUMBER;
4411: ln_transaction_id hr_api_transactions.transaction_id%TYPE;
4412: ltt_trans_step_ids hr_util_web.g_varchar2_tab_type;
4413: ltt_trans_obj_vers_num hr_util_web.g_varchar2_tab_type;
4414: ln_trans_step_rows NUMBER ;
4415: lv_activity_name wf_item_activity_statuses_v.activity_name%type ;
4416: ln_no_of_components NUMBER ;
4417: i INTEGER ;

Line 5130: ltt_trans_step_ids hr_util_web.g_varchar2_tab_type;

5126:
5127: l_proc varchar2(200) := g_package || 'get_txn_details_for_review';
5128: ln_transaction_step_id NUMBER;
5129: ln_transaction_id hr_api_transactions.transaction_id%TYPE;
5130: ltt_trans_step_ids hr_util_web.g_varchar2_tab_type;
5131: ltt_trans_obj_vers_num hr_util_web.g_varchar2_tab_type;
5132: ln_trans_step_rows NUMBER ;
5133: lv_activity_name wf_item_activity_statuses_v.activity_name%type ;
5134: ln_no_of_components NUMBER ;

Line 5131: ltt_trans_obj_vers_num hr_util_web.g_varchar2_tab_type;

5127: l_proc varchar2(200) := g_package || 'get_txn_details_for_review';
5128: ln_transaction_step_id NUMBER;
5129: ln_transaction_id hr_api_transactions.transaction_id%TYPE;
5130: ltt_trans_step_ids hr_util_web.g_varchar2_tab_type;
5131: ltt_trans_obj_vers_num hr_util_web.g_varchar2_tab_type;
5132: ln_trans_step_rows NUMBER ;
5133: lv_activity_name wf_item_activity_statuses_v.activity_name%type ;
5134: ln_no_of_components NUMBER ;
5135: i INTEGER ;