278: FROM fnd_attachment_functions
279: WHERE function_type = 'O'
280: AND (function_name, application_id) =
281: (SELECT distinct ff.form_name, ff.application_id
282: FROM fnd_form ff,
283: fnd_form_functions fff
284: WHERE ff.application_id = fff.application_id
285: AND ff.form_id = fff.form_id
286: AND fff.function_name = l_function_name)
279: WHERE function_type = 'O'
280: AND (function_name, application_id) =
281: (SELECT distinct ff.form_name, ff.application_id
282: FROM fnd_form ff,
283: fnd_form_functions fff
284: WHERE ff.application_id = fff.application_id
285: AND ff.form_id = fff.form_id
286: AND fff.function_name = l_function_name)
287: GROUP BY function_name;
364: FROM fnd_attachment_functions
365: WHERE function_type = 'O'
366: AND (function_name, application_id) =
367: (SELECT distinct ff.form_name, ff.application_id
368: FROM fnd_form ff,
369: fnd_form_functions fff
370: WHERE ff.application_id = fff.application_id
371: AND ff.form_id = fff.form_id
372: AND fff.function_name = l_function_name);
365: WHERE function_type = 'O'
366: AND (function_name, application_id) =
367: (SELECT distinct ff.form_name, ff.application_id
368: FROM fnd_form ff,
369: fnd_form_functions fff
370: WHERE ff.application_id = fff.application_id
371: AND ff.form_id = fff.form_id
372: AND fff.function_name = l_function_name);
373:
503: x_application_id IN NUMBER,
504: x_function_name IN VARCHAR2) RETURN VARCHAR2 IS
505: CURSOR get_form IS
506: SELECT user_form_name
507: FROM fnd_form_vl
508: WHERE form_name = x_function_name
509: AND application_id = x_application_id;
510:
511: CURSOR get_function IS
509: AND application_id = x_application_id;
510:
511: CURSOR get_function IS
512: SELECT user_function_name
513: FROM fnd_form_functions_vl
514: WHERE function_name = x_function_name;
515:
516: CURSOR get_report IS
517: SELECT user_concurrent_program_name