APPS.HR_TRANSACTION_SS dependencies on HR_UTIL_WEB

Line 1046: when hr_util_web.g_error_handled then

1042: hr_utility.set_location(' Leaving:'||l_proc, 30);
1043: END IF;
1044: hr_utility.set_location('Leaving: '|| l_proc,35);
1045: exception
1046: when hr_util_web.g_error_handled then
1047: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
1048: -- error from validating the login
1049: rollback to start_transaction;
1050: when others then

Line 2117: ,p_trans_step_id_tbl IN hr_util_web.g_varchar2_tab_type)

2113: */
2114: FUNCTION get_activity_trans_step_id
2115: (p_activity_name IN
2116: wf_item_activity_statuses_v.activity_name%TYPE
2117: ,p_trans_step_id_tbl IN hr_util_web.g_varchar2_tab_type)
2118: RETURN hr_api_transaction_steps.transaction_step_id%TYPE IS
2119: ln_transaction_step_id
2120: hr_api_transaction_steps.transaction_step_id%TYPE;
2121: li_step_count INTEGER;

Line 2161: ltt_trans_step_ids hr_util_web.g_varchar2_tab_type;

2157: RETURN BOOLEAN
2158: IS
2159:
2160: ln_transaction_id NUMBER ;
2161: ltt_trans_step_ids hr_util_web.g_varchar2_tab_type;
2162: ltt_trans_obj_vers_num hr_util_web.g_varchar2_tab_type;
2163: ln_trans_step_rows number ;
2164: l_proc constant varchar2(100) := g_package || ' check_txn_step_exists';
2165: BEGIN

Line 2162: ltt_trans_obj_vers_num hr_util_web.g_varchar2_tab_type;

2158: IS
2159:
2160: ln_transaction_id NUMBER ;
2161: ltt_trans_step_ids hr_util_web.g_varchar2_tab_type;
2162: ltt_trans_obj_vers_num hr_util_web.g_varchar2_tab_type;
2163: ln_trans_step_rows number ;
2164: l_proc constant varchar2(100) := g_package || ' check_txn_step_exists';
2165: BEGIN
2166: hr_utility.set_location('Entering: '|| l_proc,5);

Line 2213: ltt_trans_step_ids hr_util_web.g_varchar2_tab_type;

2209: IS
2210: ln_ovn NUMBER ;
2211: ln_transaction_step_id NUMBER;
2212: ln_transaction_id hr_api_transactions.transaction_id%TYPE;
2213: ltt_trans_step_ids hr_util_web.g_varchar2_tab_type;
2214: ltt_trans_obj_vers_num hr_util_web.g_varchar2_tab_type;
2215: ln_trans_step_rows NUMBER ;
2216: ln_value_id NUMBER ;
2217: l_proc constant varchar2(100) := g_package || ' delete_trn_step_by_act_name';

Line 2214: ltt_trans_obj_vers_num hr_util_web.g_varchar2_tab_type;

2210: ln_ovn NUMBER ;
2211: ln_transaction_step_id NUMBER;
2212: ln_transaction_id hr_api_transactions.transaction_id%TYPE;
2213: ltt_trans_step_ids hr_util_web.g_varchar2_tab_type;
2214: ltt_trans_obj_vers_num hr_util_web.g_varchar2_tab_type;
2215: ln_trans_step_rows NUMBER ;
2216: ln_value_id NUMBER ;
2217: l_proc constant varchar2(100) := g_package || ' delete_trn_step_by_act_name';
2218: BEGIN

Line 2271: l_trans_step_ids hr_util_web.g_varchar2_tab_type;

2267: p_item_key IN varchar2,
2268: p_actid IN varchar2 default null,
2269: p_login_person_id IN varchar2) IS
2270:
2271: l_trans_step_ids hr_util_web.g_varchar2_tab_type;
2272: l_trans_obj_vers_num hr_util_web.g_varchar2_tab_type;
2273: l_trans_step_rows NUMBER;
2274: l_proc constant varchar2(100) := g_package || ' delete_transaction_steps';
2275:

Line 2272: l_trans_obj_vers_num hr_util_web.g_varchar2_tab_type;

2268: p_actid IN varchar2 default null,
2269: p_login_person_id IN varchar2) IS
2270:
2271: l_trans_step_ids hr_util_web.g_varchar2_tab_type;
2272: l_trans_obj_vers_num hr_util_web.g_varchar2_tab_type;
2273: l_trans_step_rows NUMBER;
2274: l_proc constant varchar2(100) := g_package || ' delete_transaction_steps';
2275:
2276: BEGIN