APPS.PQP_RIW_WEBADI_UTILS dependencies on FND_FORM_FUNCTIONS

Line 1664: FROM FND_FORM_FUNCTIONS

1660: ,LAST_UPDATE_LOGIN
1661: ,MAINTENANCE_MODE_SUPPORT
1662: ,CONTEXT_DEPENDENCE
1663: ,JRAD_REF_PATH
1664: FROM FND_FORM_FUNCTIONS
1665: WHERE FUNCTION_NAME = c_function_name;
1666:
1667: l_function_row c_function_row%ROWTYPE;
1668: l_rowid VARCHAR2(200);

Line 1689: FROM fnd_form_functions fff, fnd_form_functions_tl ffft

1685: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
1686:
1687: IF p_action_type = 'Update' THEN
1688: SELECT fff.function_name into l_function_name
1689: FROM fnd_form_functions fff, fnd_form_functions_tl ffft
1690: WHERE fff.FUNCTION_ID = ffft.FUNCTION_ID
1691: AND ffft.SOURCE_LANG = userenv('LANG')
1692: AND ffft.LANGUAGE = userenv('LANG')
1693: AND ffft.USER_FUNCTION_NAME = p_user_function_name;

Line 1719: fnd_form_functions_pkg.UPDATE_ROW

1715: l_func_parameters := l_func_parameters||'$pFunctionId='|| l_function_row.FUNCTION_ID;
1716: l_func_parameters := replace(l_func_parameters,'$','&');
1717:
1718:
1719: fnd_form_functions_pkg.UPDATE_ROW
1720: (X_FUNCTION_ID => l_function_row.FUNCTION_ID
1721: ,X_WEB_HOST_NAME => l_function_row.WEB_HOST_NAME
1722: ,X_WEB_AGENT_NAME => l_function_row.WEB_AGENT_NAME
1723: ,X_WEB_HTML_CALL => l_function_row.WEB_HTML_CALL --can be changed later

Line 1748: SELECT fnd_form_functions_s.nextval

1744: where flxdu_func_attribute_id = l_function_row.FUNCTION_ID
1745: and flxdu_func_name = l_function_row.FUNCTION_NAME;
1746: ELSE
1747:
1748: SELECT fnd_form_functions_s.nextval
1749: INTO l_fun_id
1750: FROM dual;
1751: l_func_parameters := l_func_parameters||'$pFunctionId='|| l_fun_id;
1752: l_func_parameters := replace(l_func_parameters,'$','&');

Line 1754: fnd_form_functions_pkg.INSERT_ROW

1750: FROM dual;
1751: l_func_parameters := l_func_parameters||'$pFunctionId='|| l_fun_id;
1752: l_func_parameters := replace(l_func_parameters,'$','&');
1753:
1754: fnd_form_functions_pkg.INSERT_ROW
1755: (X_ROWID => l_rowid
1756: ,X_FUNCTION_ID => l_fun_id
1757: ,X_WEB_HOST_NAME => l_function_row.WEB_HOST_NAME
1758: ,X_WEB_AGENT_NAME => l_function_row.WEB_AGENT_NAME

Line 1891: FROM fnd_form_functions

1887: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
1888:
1889: SELECT function_id
1890: INTO l_fun_id
1891: FROM fnd_form_functions
1892: WHERE function_name = p_function_name;
1893:
1894: SELECT max(ENTRY_SEQUENCE)
1895: INTO l_ENTRY_SEQUENCE

Line 3211: FROM fnd_form_functions fff, fnd_form_functions_tl ffft

3207: ,p_new_interface_code => l_new_intrfc_code
3208: ,p_new_layout_code => l_new_layout_code);
3209:
3210: SELECT fff.function_name into l_security_func_name
3211: FROM fnd_form_functions fff, fnd_form_functions_tl ffft
3212: WHERE fff.FUNCTION_ID = ffft.FUNCTION_ID
3213: AND ffft.SOURCE_LANG = userenv('LANG')
3214: AND ffft.LANGUAGE = userenv('LANG')
3215: AND ffft.USER_FUNCTION_NAME = p_user_function_name;

Line 3234: FROM fnd_form_functions fff, fnd_form_functions_tl ffft

3230:
3231: IF p_action_type = 'Update' THEN
3232:
3233: SELECT fff.function_name into l_function_name
3234: FROM fnd_form_functions fff, fnd_form_functions_tl ffft
3235: WHERE fff.FUNCTION_ID = ffft.FUNCTION_ID
3236: AND ffft.SOURCE_LANG = userenv('LANG')
3237: AND ffft.LANGUAGE = userenv('LANG')
3238: AND ffft.USER_FUNCTION_NAME = p_user_function_name;

Line 3383: FND_FORM_FUNCTIONS_PKG.DELETE_ROW(

3379: DELETE
3380: FROM PQP_FLXDU_FUNC_ATTRIBUTES
3381: WHERE FLXDU_FUNC_ATTRIBUTE_ID = p_function_id;
3382:
3383: FND_FORM_FUNCTIONS_PKG.DELETE_ROW(
3384: X_FUNCTION_ID => p_function_id);
3385:
3386:
3387: hr_utility.trace('DELETE: INTERFACE='|| l_intf_code);