DBA Data[Home] [Help]

APPS.HR_PROCESS_PHONE_NUMBERS_SS dependencies on HR_UTIL_WEB

Line 1266: l_trans_step_ids hr_util_web.g_varchar2_tab_type;

1262: --
1263: l_trans_step_id number default null;
1264: -- l_trans_obj_vers_num number default null;
1265: l_trans_rec_count integer default 0;
1266: l_trans_step_ids hr_util_web.g_varchar2_tab_type;
1267: l_trans_obj_vers_nums hr_util_web.g_varchar2_tab_type;
1268: l_trans_step_rows NUMBER ;
1269: ln_index number default 0;
1270: l_phone_data varchar2(4000);

Line 1267: l_trans_obj_vers_nums hr_util_web.g_varchar2_tab_type;

1263: l_trans_step_id number default null;
1264: -- l_trans_obj_vers_num number default null;
1265: l_trans_rec_count integer default 0;
1266: l_trans_step_ids hr_util_web.g_varchar2_tab_type;
1267: l_trans_obj_vers_nums hr_util_web.g_varchar2_tab_type;
1268: l_trans_step_rows NUMBER ;
1269: ln_index number default 0;
1270: l_phone_data varchar2(4000);
1271: l_dummy number;

Line 1454: l_trans_step_ids hr_util_web.g_varchar2_tab_type;

1450: --
1451: l_trans_step_id number default null;
1452: -- l_trans_obj_vers_num number default null;
1453: l_trans_rec_count integer default 0;
1454: l_trans_step_ids hr_util_web.g_varchar2_tab_type;
1455: l_trans_obj_vers_nums hr_util_web.g_varchar2_tab_type;
1456: l_trans_step_rows NUMBER ;
1457: ln_index number default 0;
1458: i number default 1;

Line 1455: l_trans_obj_vers_nums hr_util_web.g_varchar2_tab_type;

1451: l_trans_step_id number default null;
1452: -- l_trans_obj_vers_num number default null;
1453: l_trans_rec_count integer default 0;
1454: l_trans_step_ids hr_util_web.g_varchar2_tab_type;
1455: l_trans_obj_vers_nums hr_util_web.g_varchar2_tab_type;
1456: l_trans_step_rows NUMBER ;
1457: ln_index number default 0;
1458: i number default 1;
1459: l_proc varchar2(72) := g_package||'get_transaction_details';

Line 1694: l_trans_step_ids hr_util_web.g_varchar2_tab_type;

1690: --
1691: l_trans_step_id number default null;
1692: -- l_trans_obj_vers_num number default null;
1693: l_trans_rec_count integer default 0;
1694: l_trans_step_ids hr_util_web.g_varchar2_tab_type;
1695: l_trans_obj_vers_nums hr_util_web.g_varchar2_tab_type;
1696: l_trans_step_rows NUMBER ;
1697: ln_index number default 0;
1698: i number default 1;

Line 1695: l_trans_obj_vers_nums hr_util_web.g_varchar2_tab_type;

1691: l_trans_step_id number default null;
1692: -- l_trans_obj_vers_num number default null;
1693: l_trans_rec_count integer default 0;
1694: l_trans_step_ids hr_util_web.g_varchar2_tab_type;
1695: l_trans_obj_vers_nums hr_util_web.g_varchar2_tab_type;
1696: l_trans_step_rows NUMBER ;
1697: ln_index number default 0;
1698: i number default 1;
1699: l_proc varchar2(72) := g_package||'get_transaction_details';