APPS.PA_ROLE_STATUS_MENU_UTILS dependencies on PA_ROLE_STATUS_MENU_MAP

Line 27: from pa_role_status_menu_map

23: ,p_return_status out NOCOPY varchar2
24: ,p_error_message_code out NOCOPY varchar2) IS
25: cursor c_exists is
26: select 'Y'
27: from pa_role_status_menu_map
28: where role_id = p_role_id
29: and status_code = p_status_code
30: and status_type = 'PROJECT'
31: and role_status_menu_id <> nvl(p_role_status_menu_id, -99);

Line 57: -- exists in pa_role_status_menu_map - if it does, it

53: -- PROCEDURE
54: -- check_status_is_in_use
55: -- PURPOSE
56: -- This procedure checks to see that the given status
57: -- exists in pa_role_status_menu_map - if it does, it
58: -- cannot be deleted from the Project Status form.
59: -- Called from the PA_PROJECT_STUS_UTILS.Allow_Status_Deletion
60: -- procedure.
61: -- HISTORY

Line 70: from pa_role_status_menu_map

66: ,p_return_status OUT NOCOPY VARCHAR2
67: ,p_error_message_code OUT NOCOPY VARCHAR2) IS
68: cursor c_exists is
69: select 'Y'
70: from pa_role_status_menu_map
71: where status_code = p_status_code
72: and status_type = 'PROJECT';
73:
74: BEGIN

Line 108: -- from PA_ROLE_STATUS_MENU_MAP for the given role_id.

104: -- This API will return:
105: -- 1. Status Level and Default Menu Id from PA_PROJECT_ROLE_TYPES_B for
106: -- the given role_id.
107: -- 2. Tables of Status Codes, Status Type, and corresponding Menu Names
108: -- from PA_ROLE_STATUS_MENU_MAP for the given role_id.
109:
110: PROCEDURE get_role_status_menus(
111: p_role_id IN NUMBER
112: ,x_role_status_menu_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type

Line 130: from pa_role_status_menu_map prsm, fnd_menus fm

126:
127: cursor csr_get_role_status_info is
128: select prsm.role_status_menu_id, prsm.status_type,
129: prsm.status_code, fm.menu_name
130: from pa_role_status_menu_map prsm, fnd_menus fm
131: where prsm.role_id = p_role_id
132: and prsm.menu_id = fm.menu_id;
133:
134: l_count NUMBER := 1;