DBA Data[Home] [Help]

APPS.PA_ROLE_STATUS_MENU_UTILS dependencies on PA_VARCHAR2_30_TBL_TYPE

Line 115: ,x_status_type_tbl OUT NOCOPY SYSTEM.pa_varchar2_30_tbl_type

111: p_role_id IN NUMBER
112: ,x_role_status_menu_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type
113: ,x_status_level OUT NOCOPY VARCHAR2
114: ,x_default_menu_name OUT NOCOPY VARCHAR2
115: ,x_status_type_tbl OUT NOCOPY SYSTEM.pa_varchar2_30_tbl_type
116: ,x_status_code_tbl OUT NOCOPY SYSTEM.pa_varchar2_30_tbl_type
117: ,x_menu_name_tbl OUT NOCOPY SYSTEM.pa_varchar2_30_tbl_type
118: ,x_return_status OUT NOCOPY VARCHAR2
119: ,x_error_message_code OUT NOCOPY VARCHAR2) IS

Line 116: ,x_status_code_tbl OUT NOCOPY SYSTEM.pa_varchar2_30_tbl_type

112: ,x_role_status_menu_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type
113: ,x_status_level OUT NOCOPY VARCHAR2
114: ,x_default_menu_name OUT NOCOPY VARCHAR2
115: ,x_status_type_tbl OUT NOCOPY SYSTEM.pa_varchar2_30_tbl_type
116: ,x_status_code_tbl OUT NOCOPY SYSTEM.pa_varchar2_30_tbl_type
117: ,x_menu_name_tbl OUT NOCOPY SYSTEM.pa_varchar2_30_tbl_type
118: ,x_return_status OUT NOCOPY VARCHAR2
119: ,x_error_message_code OUT NOCOPY VARCHAR2) IS
120:

Line 117: ,x_menu_name_tbl OUT NOCOPY SYSTEM.pa_varchar2_30_tbl_type

113: ,x_status_level OUT NOCOPY VARCHAR2
114: ,x_default_menu_name OUT NOCOPY VARCHAR2
115: ,x_status_type_tbl OUT NOCOPY SYSTEM.pa_varchar2_30_tbl_type
116: ,x_status_code_tbl OUT NOCOPY SYSTEM.pa_varchar2_30_tbl_type
117: ,x_menu_name_tbl OUT NOCOPY SYSTEM.pa_varchar2_30_tbl_type
118: ,x_return_status OUT NOCOPY VARCHAR2
119: ,x_error_message_code OUT NOCOPY VARCHAR2) IS
120:
121: cursor csr_get_role_level_info is