APPS.JTF_MENU_PUB dependencies on FND_RESP_FUNCTIONS

Line 52: temp fnd_resp_functions.rule_type%type;

48: -- p_sub_menu_id and p_function_id are simply the sub_menu_id
49: -- and function_id from the candidate menu_data
50: function check_exclusion(p_respid number, p_appid number,
51: p_sub_menu_id number, p_function_id number) return boolean is
52: temp fnd_resp_functions.rule_type%type;
53:
54: -- this cursors job is simply to help us decide whether there exists
55: -- any row which matches the given respid/appid/action_id/rule_type.
56: cursor c1(pp_respid number, pp_appid number, pp_action_id number,

Line 58: select rule_type from fnd_resp_functions where

54: -- this cursors job is simply to help us decide whether there exists
55: -- any row which matches the given respid/appid/action_id/rule_type.
56: cursor c1(pp_respid number, pp_appid number, pp_action_id number,
57: pp_rule_type varchar2) is
58: select rule_type from fnd_resp_functions where
59: application_id = pp_appid and responsibility_id = pp_respid and
60: action_id = pp_action_id and rule_type = pp_rule_type;
61: begin
62: if p_sub_menu_id is not null then