APPS.HR_TRANSACTION_SS dependencies on HR_UTIL_WEB

Line 1109: when hr_util_web.g_error_handled then

1105: hr_utility.set_location(' Leaving:'||l_proc, 30);
1106: END IF;
1107: hr_utility.set_location('Leaving: '|| l_proc,35);
1108: exception
1109: when hr_util_web.g_error_handled then
1110: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
1111: -- error from validating the login
1112: rollback to start_transaction;
1113: when others then

Line 2274: ,p_trans_step_id_tbl IN hr_util_web.g_varchar2_tab_type)

2270: */
2271: FUNCTION get_activity_trans_step_id
2272: (p_activity_name IN
2273: wf_item_activity_statuses_v.activity_name%TYPE
2274: ,p_trans_step_id_tbl IN hr_util_web.g_varchar2_tab_type)
2275: RETURN hr_api_transaction_steps.transaction_step_id%TYPE IS
2276: ln_transaction_step_id
2277: hr_api_transaction_steps.transaction_step_id%TYPE;
2278: li_step_count INTEGER;

Line 2318: ltt_trans_step_ids hr_util_web.g_varchar2_tab_type;

2314: RETURN BOOLEAN
2315: IS
2316:
2317: ln_transaction_id NUMBER ;
2318: ltt_trans_step_ids hr_util_web.g_varchar2_tab_type;
2319: ltt_trans_obj_vers_num hr_util_web.g_varchar2_tab_type;
2320: ln_trans_step_rows number ;
2321: l_proc constant varchar2(100) := g_package || ' check_txn_step_exists';
2322: BEGIN

Line 2319: ltt_trans_obj_vers_num hr_util_web.g_varchar2_tab_type;

2315: IS
2316:
2317: ln_transaction_id NUMBER ;
2318: ltt_trans_step_ids hr_util_web.g_varchar2_tab_type;
2319: ltt_trans_obj_vers_num hr_util_web.g_varchar2_tab_type;
2320: ln_trans_step_rows number ;
2321: l_proc constant varchar2(100) := g_package || ' check_txn_step_exists';
2322: BEGIN
2323: hr_utility.set_location('Entering: '|| l_proc,5);

Line 2370: ltt_trans_step_ids hr_util_web.g_varchar2_tab_type;

2366: IS
2367: ln_ovn NUMBER ;
2368: ln_transaction_step_id NUMBER;
2369: ln_transaction_id hr_api_transactions.transaction_id%TYPE;
2370: ltt_trans_step_ids hr_util_web.g_varchar2_tab_type;
2371: ltt_trans_obj_vers_num hr_util_web.g_varchar2_tab_type;
2372: ln_trans_step_rows NUMBER ;
2373: ln_value_id NUMBER ;
2374: l_proc constant varchar2(100) := g_package || ' delete_trn_step_by_act_name';

Line 2371: ltt_trans_obj_vers_num hr_util_web.g_varchar2_tab_type;

2367: ln_ovn NUMBER ;
2368: ln_transaction_step_id NUMBER;
2369: ln_transaction_id hr_api_transactions.transaction_id%TYPE;
2370: ltt_trans_step_ids hr_util_web.g_varchar2_tab_type;
2371: ltt_trans_obj_vers_num hr_util_web.g_varchar2_tab_type;
2372: ln_trans_step_rows NUMBER ;
2373: ln_value_id NUMBER ;
2374: l_proc constant varchar2(100) := g_package || ' delete_trn_step_by_act_name';
2375: BEGIN

Line 2428: l_trans_step_ids hr_util_web.g_varchar2_tab_type;

2424: p_item_key IN varchar2,
2425: p_actid IN varchar2 default null,
2426: p_login_person_id IN varchar2) IS
2427:
2428: l_trans_step_ids hr_util_web.g_varchar2_tab_type;
2429: l_trans_obj_vers_num hr_util_web.g_varchar2_tab_type;
2430: l_trans_step_rows NUMBER;
2431: l_proc constant varchar2(100) := g_package || ' delete_transaction_steps';
2432:

Line 2429: l_trans_obj_vers_num hr_util_web.g_varchar2_tab_type;

2425: p_actid IN varchar2 default null,
2426: p_login_person_id IN varchar2) IS
2427:
2428: l_trans_step_ids hr_util_web.g_varchar2_tab_type;
2429: l_trans_obj_vers_num hr_util_web.g_varchar2_tab_type;
2430: l_trans_step_rows NUMBER;
2431: l_proc constant varchar2(100) := g_package || ' delete_transaction_steps';
2432:
2433: BEGIN