APPS.PA_ROLE_STATUS_MENU_PKG dependencies on PA_ROLE_STATUS_MENU_MAP

Line 26: select PA_ROLE_STATUS_MENU_MAP_S.nextval

22: -- Initialize object version number.
23: p_object_version_number := 1;
24:
25: -- Get the next sequence number for the primary key.
26: select PA_ROLE_STATUS_MENU_MAP_S.nextval
27: into P_ROLE_STATUS_MENU_ID
28: from sys.dual;
29:
30: insert into pa_role_status_menu_map (

Line 30: insert into pa_role_status_menu_map (

26: select PA_ROLE_STATUS_MENU_MAP_S.nextval
27: into P_ROLE_STATUS_MENU_ID
28: from sys.dual;
29:
30: insert into pa_role_status_menu_map (
31: ROLE_STATUS_MENU_ID,
32: ROLE_ID,
33: STATUS_TYPE,
34: STATUS_CODE,

Line 68: FROM pa_role_status_menu_map

64:
65: CURSOR c
66: IS
67: SELECT *
68: FROM pa_role_status_menu_map
69: WHERE ROLE_STATUS_MENU_ID = P_ROLE_STATUS_MENU_ID
70: FOR UPDATE NOWAIT;
71:
72: Recinfo c%ROWTYPE;

Line 127: update pa_role_status_menu_map

123:
124: -- Increment the object version number.
125: p_object_version_number := p_object_version_number + 1;
126:
127: update pa_role_status_menu_map
128: set
129: STATUS_CODE = P_STATUS_CODE,
130: MENU_ID = P_MENU_ID,
131: OBJECT_VERSION_NUMBER = P_OBJECT_VERSION_NUMBER,

Line 160: delete from pa_role_status_menu_map

156: P_ROLE_STATUS_MENU_ID,
157: P_OBJECT_VERSION_NUMBER
158: );
159:
160: delete from pa_role_status_menu_map
161: where role_status_menu_id = p_role_status_menu_id;
162:
163: if (sql%notfound) then
164: raise no_data_found;