DBA Data[Home] [Help]

APPS.HR_TRANSACTION_SS dependencies on FND_FORM_FUNCTIONS

Line 828: fnd_form_functions_vl fff

824: AS
825: cursor get_function_info ( p_item_type HR_API_TRANSACTION_STEPS.item_type%TYPE
826: ,p_item_key HR_API_TRANSACTION_STEPS.item_key%TYPE ) is
827: select fff.function_id, fff.function_name from
828: fnd_form_functions_vl fff
829: where fff.function_name = ( select iav.text_value
830: from wf_item_attribute_values iav
831: where iav.item_type = p_item_type
832: and iav.item_key = p_item_key

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

831: where iav.item_type = p_item_type
832: and iav.item_key = p_item_key
833: and iav.name = 'P_CALLED_FROM') ;
834:
835: l_function_name fnd_form_functions_vl.function_name%TYPE default null;
836: l_proc constant varchar2(100) := g_package || ' populate_null_values';
837: BEGIN
838: hr_utility.set_location('Entering: '|| l_proc,5);
839: If p_function_id is null then

Line 1426: from fnd_form_functions fff, hr_api_transactions hat

1422: order by trs.processing_order,trs.transaction_step_id ; --#2313279
1423: --
1424: cursor cur_fn is
1425: select fff.parameters
1426: from fnd_form_functions fff, hr_api_transactions hat
1427: where fff.function_id = hat.function_id
1428: and hat.transaction_id = l_transaction_id;
1429: --
1430: l_parameter fnd_form_functions.parameters%TYPE;

Line 1430: l_parameter fnd_form_functions.parameters%TYPE;

1426: from fnd_form_functions fff, hr_api_transactions hat
1427: where fff.function_id = hat.function_id
1428: and hat.transaction_id = l_transaction_id;
1429: --
1430: l_parameter fnd_form_functions.parameters%TYPE;
1431: l_effectiveDate boolean := FALSE;
1432: begin
1433: hr_utility.set_location('Entering: '|| l_proc,5);
1434: -- set the ignore warnings flag