APPS.BIS_FORM_FUNCTIONS_PUB dependencies on FND_FORM_FUNCTIONS_VL

Line 222: from fnd_form_functions_vl

218: application_id,
219: form_id,
220: maintenance_mode_support,
221: context_dependence
222: from fnd_form_functions_vl
223: where function_id = X_FUNCTION_ID;
224:
225: begin
226:

Line 319: from fnd_form_functions_vl

315: context_dependence,
316: user_function_name,
317: description,
318: parameters
319: from fnd_form_functions_vl
320: where function_id = p_FUNCTION_ID;
321:
322: begin
323:

Line 393: from fnd_form_functions_vl

389: X_MAINTENANCE_MODE_SUPPORT => l_formFunction_rec.maintenance_mode_support,
390: X_CONTEXT_DEPENDENCE => l_formFunction_rec.context_dependence);
391: if p_functional_area_id <> BIS_COMMON_UTILS.G_DEF_NUM and p_object_type <> BIS_COMMON_UTILS.G_DEF_CHAR and p_application_id <> BIS_COMMON_UTILS.G_DEF_NUM then
392: select function_name into l_function_name
393: from fnd_form_functions_vl
394: where function_id = p_FUNCTION_ID;
395: select count(1) into l_count from bis_form_function_extension where upper(object_name) = upper(l_function_name);
396: l_Form_Func_Extn_Rec.object_type := p_object_type;
397: l_Form_Func_Extn_Rec.object_name := upper(l_function_name);

Line 699: l_form_func_parameters FND_FORM_FUNCTIONS_VL.PARAMETERS%TYPE;

695: x_return_status OUT nocopy VARCHAR2,
696: x_Msg_Count OUT NOCOPY NUMBER,
697: x_msg_data OUT nocopy VARCHAR2
698: ) IS
699: l_form_func_parameters FND_FORM_FUNCTIONS_VL.PARAMETERS%TYPE;
700: l_form_function_id FND_FORM_FUNCTIONS_VL.FUNCTION_ID%TYPE;
701: l_form_func_description FND_FORM_FUNCTIONS_VL.DESCRIPTION%TYPE;
702:
703: BEGIN

Line 700: l_form_function_id FND_FORM_FUNCTIONS_VL.FUNCTION_ID%TYPE;

696: x_Msg_Count OUT NOCOPY NUMBER,
697: x_msg_data OUT nocopy VARCHAR2
698: ) IS
699: l_form_func_parameters FND_FORM_FUNCTIONS_VL.PARAMETERS%TYPE;
700: l_form_function_id FND_FORM_FUNCTIONS_VL.FUNCTION_ID%TYPE;
701: l_form_func_description FND_FORM_FUNCTIONS_VL.DESCRIPTION%TYPE;
702:
703: BEGIN
704: SAVEPOINT FormFunctionObsoleteUpdate;

Line 701: l_form_func_description FND_FORM_FUNCTIONS_VL.DESCRIPTION%TYPE;

697: x_msg_data OUT nocopy VARCHAR2
698: ) IS
699: l_form_func_parameters FND_FORM_FUNCTIONS_VL.PARAMETERS%TYPE;
700: l_form_function_id FND_FORM_FUNCTIONS_VL.FUNCTION_ID%TYPE;
701: l_form_func_description FND_FORM_FUNCTIONS_VL.DESCRIPTION%TYPE;
702:
703: BEGIN
704: SAVEPOINT FormFunctionObsoleteUpdate;
705: IF (p_func_name IS NULL OR p_func_name = '') THEN

Line 719: FROM fnd_form_functions_vl

715: END IF;
716:
717: SELECT function_id,parameters,description
718: INTO l_form_function_id,l_form_func_parameters,l_form_func_description
719: FROM fnd_form_functions_vl
720: WHERE function_name = p_func_name;
721:
722: IF (p_obsolete = 'Y') THEN
723: l_form_func_parameters := l_form_func_parameters || '&pObsoleteFlag=Y';