DBA Data[Home] [Help]

APPS.BIS_PMV_PAGE_PARAMS_PUB dependencies on FND_FORM_FUNCTIONS

Line 39: l_function_name fnd_form_functions.function_name%TYPE;

35:
36: --jprabhud - 07/16/03- Make this a dynamic sql to remove portal dependency
37: --Removed the cursor which was using portal table, but was not reaaly being used
38:
39: l_function_name fnd_form_functions.function_name%TYPE;
40: CURSOR c_asofdatefunc IS
41: SELECT parameters
42: FROM fnd_form_functions
43: WHERE function_name = l_function_name and

Line 42: FROM fnd_form_functions

38:
39: l_function_name fnd_form_functions.function_name%TYPE;
40: CURSOR c_asofdatefunc IS
41: SELECT parameters
42: FROM fnd_form_functions
43: WHERE function_name = l_function_name and
44: instr(parameters,'pRequestType=P') > 0
45: and instr(parameters, 'pAsOfDate=') > 0;
46: l_session_id varchar2(200);

Line 305: -- The application_id column of fnd_form_functions could be null, so we use the

301:
302: BEGIN
303:
304:
305: -- The application_id column of fnd_form_functions could be null, so we use the
306: --corr region_code to get the application_id
307: -- get the help_target and the application_id from the region
308: lAKRegionCode := getParameterValue(pParameters => p_web_html_call,
309: pParameterKey => 'akRegionCode' );