DBA Data[Home] [Help]

APPS.HR_TRANSACTION_SS dependencies on FND_FORM_FUNCTIONS

Line 765: fnd_form_functions_vl fff

761: AS
762: cursor get_function_info ( p_item_type HR_API_TRANSACTION_STEPS.item_type%TYPE
763: ,p_item_key HR_API_TRANSACTION_STEPS.item_key%TYPE ) is
764: select fff.function_id, fff.function_name from
765: fnd_form_functions_vl fff
766: where fff.function_name = ( select iav.text_value
767: from wf_item_attribute_values iav
768: where iav.item_type = p_item_type
769: and iav.item_key = p_item_key

Line 772: l_function_name fnd_form_functions_vl.function_name%TYPE default null;

768: where iav.item_type = p_item_type
769: and iav.item_key = p_item_key
770: and iav.name = 'P_CALLED_FROM') ;
771:
772: l_function_name fnd_form_functions_vl.function_name%TYPE default null;
773: l_proc constant varchar2(100) := g_package || ' populate_null_values';
774: BEGIN
775: hr_utility.set_location('Entering: '|| l_proc,5);
776: If p_function_id is null then

Line 1340: from fnd_form_functions fff, hr_api_transactions hat

1336: order by trs.processing_order,trs.transaction_step_id ; --#2313279
1337: --
1338: cursor cur_fn is
1339: select fff.parameters
1340: from fnd_form_functions fff, hr_api_transactions hat
1341: where fff.function_id = hat.function_id
1342: and hat.transaction_id = l_transaction_id;
1343: --
1344: l_parameter fnd_form_functions.parameters%TYPE;

Line 1344: l_parameter fnd_form_functions.parameters%TYPE;

1340: from fnd_form_functions fff, hr_api_transactions hat
1341: where fff.function_id = hat.function_id
1342: and hat.transaction_id = l_transaction_id;
1343: --
1344: l_parameter fnd_form_functions.parameters%TYPE;
1345: l_effectiveDate boolean := FALSE;
1346: begin
1347: hr_utility.set_location('Entering: '|| l_proc,5);
1348: -- set the ignore warnings flag