591: END get_call_exec;
592:
593: PROCEDURE set_view_param
594: (
595: p_name iby_view_parameters_gt.name%TYPE,
596: p_val iby_view_parameters_gt.value%TYPE
597: )
598: IS
599: BEGIN
592:
593: PROCEDURE set_view_param
594: (
595: p_name iby_view_parameters_gt.name%TYPE,
596: p_val iby_view_parameters_gt.value%TYPE
597: )
598: IS
599: BEGIN
600:
597: )
598: IS
599: BEGIN
600:
601: INSERT INTO iby_view_parameters_gt
602: (name,value,created_by,creation_date,last_updated_by,last_update_date,
603: last_update_login,object_version_number)
604: VALUES
605: (p_name,p_val,fnd_global.user_id,sysdate,fnd_global.user_id,
608: -- no commit, as data deleted at the end of the current
609: -- transaction
610: END set_view_param;
611:
612: FUNCTION get_view_param( p_name iby_view_parameters_gt.name%TYPE )
613: RETURN iby_view_parameters_gt.value%TYPE
614: IS
615: l_val iby_view_parameters_gt.value%TYPE;
616:
609: -- transaction
610: END set_view_param;
611:
612: FUNCTION get_view_param( p_name iby_view_parameters_gt.name%TYPE )
613: RETURN iby_view_parameters_gt.value%TYPE
614: IS
615: l_val iby_view_parameters_gt.value%TYPE;
616:
617: CURSOR c_param_val
611:
612: FUNCTION get_view_param( p_name iby_view_parameters_gt.name%TYPE )
613: RETURN iby_view_parameters_gt.value%TYPE
614: IS
615: l_val iby_view_parameters_gt.value%TYPE;
616:
617: CURSOR c_param_val
618: (ci_name iby_view_parameters_gt.name%TYPE)
619: IS
614: IS
615: l_val iby_view_parameters_gt.value%TYPE;
616:
617: CURSOR c_param_val
618: (ci_name iby_view_parameters_gt.name%TYPE)
619: IS
620: SELECT value
621: FROM iby_view_parameters_gt
622: WHERE (name=ci_name);
617: CURSOR c_param_val
618: (ci_name iby_view_parameters_gt.name%TYPE)
619: IS
620: SELECT value
621: FROM iby_view_parameters_gt
622: WHERE (name=ci_name);
623:
624: BEGIN
625: