APPS.PQP_RIW_WEBADI_UTILS dependencies on FND_FORM_FUNCTIONS

Line 1381: FROM FND_FORM_FUNCTIONS

1377: ,LAST_UPDATE_LOGIN
1378: ,MAINTENANCE_MODE_SUPPORT
1379: ,CONTEXT_DEPENDENCE
1380: ,JRAD_REF_PATH
1381: FROM FND_FORM_FUNCTIONS
1382: WHERE FUNCTION_NAME = c_function_name;
1383:
1384: l_function_row c_function_row%ROWTYPE;
1385: l_rowid VARCHAR2(200);

Line 1406: FROM fnd_form_functions fff, fnd_form_functions_tl ffft

1402: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
1403:
1404: IF p_action_type = 'Update' THEN
1405: SELECT fff.function_name into l_function_name
1406: FROM fnd_form_functions fff, fnd_form_functions_tl ffft
1407: WHERE fff.FUNCTION_ID = ffft.FUNCTION_ID
1408: AND ffft.SOURCE_LANG = userenv('LANG')
1409: AND ffft.LANGUAGE = userenv('LANG')
1410: AND ffft.USER_FUNCTION_NAME = p_user_function_name;

Line 1436: fnd_form_functions_pkg.UPDATE_ROW

1432: l_func_parameters := l_func_parameters||'$pFunctionId='|| l_function_row.FUNCTION_ID;
1433: l_func_parameters := replace(l_func_parameters,'$','&');
1434:
1435:
1436: fnd_form_functions_pkg.UPDATE_ROW
1437: (X_FUNCTION_ID => l_function_row.FUNCTION_ID
1438: ,X_WEB_HOST_NAME => l_function_row.WEB_HOST_NAME
1439: ,X_WEB_AGENT_NAME => l_function_row.WEB_AGENT_NAME
1440: ,X_WEB_HTML_CALL => l_function_row.WEB_HTML_CALL --can be changed later

Line 1465: SELECT fnd_form_functions_s.nextval

1461: where flxdu_func_attribute_id = l_function_row.FUNCTION_ID
1462: and flxdu_func_name = l_function_row.FUNCTION_NAME;
1463: ELSE
1464:
1465: SELECT fnd_form_functions_s.nextval
1466: INTO l_fun_id
1467: FROM dual;
1468: l_func_parameters := l_func_parameters||'$pFunctionId='|| l_fun_id;
1469: l_func_parameters := replace(l_func_parameters,'$','&');

Line 1471: fnd_form_functions_pkg.INSERT_ROW

1467: FROM dual;
1468: l_func_parameters := l_func_parameters||'$pFunctionId='|| l_fun_id;
1469: l_func_parameters := replace(l_func_parameters,'$','&');
1470:
1471: fnd_form_functions_pkg.INSERT_ROW
1472: (X_ROWID => l_rowid
1473: ,X_FUNCTION_ID => l_fun_id
1474: ,X_WEB_HOST_NAME => l_function_row.WEB_HOST_NAME
1475: ,X_WEB_AGENT_NAME => l_function_row.WEB_AGENT_NAME

Line 1608: FROM fnd_form_functions

1604: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
1605:
1606: SELECT function_id
1607: INTO l_fun_id
1608: FROM fnd_form_functions
1609: WHERE function_name = p_function_name;
1610:
1611: SELECT max(ENTRY_SEQUENCE)
1612: INTO l_ENTRY_SEQUENCE

Line 2825: FROM fnd_form_functions fff, fnd_form_functions_tl ffft

2821:
2822: IF p_action_type = 'Update' THEN
2823:
2824: SELECT fff.function_name into l_function_name
2825: FROM fnd_form_functions fff, fnd_form_functions_tl ffft
2826: WHERE fff.FUNCTION_ID = ffft.FUNCTION_ID
2827: AND ffft.SOURCE_LANG = userenv('LANG')
2828: AND ffft.LANGUAGE = userenv('LANG')
2829: AND ffft.USER_FUNCTION_NAME = p_user_function_name;

Line 2974: FND_FORM_FUNCTIONS_PKG.DELETE_ROW(

2970: DELETE
2971: FROM PQP_FLXDU_FUNC_ATTRIBUTES
2972: WHERE FLXDU_FUNC_ATTRIBUTE_ID = p_function_id;
2973:
2974: FND_FORM_FUNCTIONS_PKG.DELETE_ROW(
2975: X_FUNCTION_ID => p_function_id);
2976:
2977:
2978: hr_utility.trace('DELETE: INTERFACE='|| l_intf_code);