APPS.HR_SFLUTIL_SS dependencies on FND_FORM_FUNCTIONS_VL

Line 326: lv_selected_func_prompt fnd_form_functions_vl.USER_FUNCTION_NAME%type;

322: l_current_username wf_users.name%type;
323: lv_process_display_name wf_runnable_processes_v.display_name%type;
324: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
325: --ln_transaction_id hr_api_transactions.transaction_id%type;
326: lv_selected_func_prompt fnd_form_functions_vl.USER_FUNCTION_NAME%type;
327: lv_ntfSubMsg wf_item_attribute_values.text_value%type;
328: lv_TransCtx_xpath varchar2(20000) default 'Transaction/TransCtx';
329:
330: begin

Line 372: from fnd_form_functions_vl fffv

368: /*
369: begin
370: -- get the user function name
371: select USER_FUNCTION_NAME into lv_selected_func_prompt
372: from fnd_form_functions_vl fffv
373: where fffv.function_id=lr_hr_api_transaction_rec.FUNCTION_ID;
374: exception
375: when no_data_found then
376: if(hr_utility.debug_enabled) then

Line 378: hr_utility.set_location('no record found in fnd_form_functions_vl for the id :'|| ln_transaction_id, 4);

374: exception
375: when no_data_found then
376: if(hr_utility.debug_enabled) then
377: -- write debug statements
378: hr_utility.set_location('no record found in fnd_form_functions_vl for the id :'|| ln_transaction_id, 4);
379: end if;
380: when others then
381: -- fnd_message.set_name('PER', SQLERRM ||' '||to_char(SQLCODE));
382: --hr_utility.raise_error;

Line 564: from hr_api_transactions hat,fnd_form_functions_vl fffv

560: begin
561:
562: select fffv.user_function_name,hat.section_display_name
563: into lv_subject,lv_section_display_name
564: from hr_api_transactions hat,fnd_form_functions_vl fffv
565: where hat.transaction_id=p_transaction_id
566: and hat.function_id=fffv.function_id;
567:
568: exception