1341: PROCEDURE get_url_place_cwk
1342: (p_po_line_id IN NUMBER
1343: ,p_destination OUT NOCOPY VARCHAR2)
1344: IS
1345: cursor get_function_params (p_function_name fnd_form_functions.function_name%TYPE) is
1346: select web_html_call || '&' || parameters url from fnd_form_functions
1347: where function_name = p_function_name;
1348: l_function_name fnd_form_functions.function_name%TYPE default 'HR_CWKPLACE_MGR_SS';
1349: l_url varchar2(1000);
1342: (p_po_line_id IN NUMBER
1343: ,p_destination OUT NOCOPY VARCHAR2)
1344: IS
1345: cursor get_function_params (p_function_name fnd_form_functions.function_name%TYPE) is
1346: select web_html_call || '&' || parameters url from fnd_form_functions
1347: where function_name = p_function_name;
1348: l_function_name fnd_form_functions.function_name%TYPE default 'HR_CWKPLACE_MGR_SS';
1349: l_url varchar2(1000);
1350: l_cutom_cwk_plc_func fnd_form_functions.function_name%TYPE;
1344: IS
1345: cursor get_function_params (p_function_name fnd_form_functions.function_name%TYPE) is
1346: select web_html_call || '&' || parameters url from fnd_form_functions
1347: where function_name = p_function_name;
1348: l_function_name fnd_form_functions.function_name%TYPE default 'HR_CWKPLACE_MGR_SS';
1349: l_url varchar2(1000);
1350: l_cutom_cwk_plc_func fnd_form_functions.function_name%TYPE;
1351: l_self_service_licensed varchar2(3);
1352:
1346: select web_html_call || '&' || parameters url from fnd_form_functions
1347: where function_name = p_function_name;
1348: l_function_name fnd_form_functions.function_name%TYPE default 'HR_CWKPLACE_MGR_SS';
1349: l_url varchar2(1000);
1350: l_cutom_cwk_plc_func fnd_form_functions.function_name%TYPE;
1351: l_self_service_licensed varchar2(3);
1352:
1353: BEGIN
1354: