APPS.JTF_NAV_TABS_PKG dependencies on JTF_NAV_TABS_B

Line 26: insert into JTF_NAV_TABS_b

22:
23: SELECT jtf_nav_tabs_s.nextval
24: INTO l_tab_id
25: FROM dual;
26: insert into JTF_NAV_TABS_b
27: (tab_id,
28: TAB_VALUE,
29: NAVIGATOR_TYPE,
30: APPLICATION_ID,

Line 93: update JTF_NAV_TABS_B SET

89: X_LAST_UPDATE_DATE in DATE,
90: X_LAST_UPDATED_BY in NUMBER,
91: X_LAST_UPDATE_LOGIN in NUMBER) IS
92: begin
93: update JTF_NAV_TABS_B SET
94: tab_value = x_tab_value,
95: NAVIGATOR_type = X_NAVIGATOR_TYPE,
96: APPLICATION_ID = X_APPLICATION_ID,
97: ICON_NAME = X_ICON_NAME,

Line 133: FROM JTF_NAV_TABS_B

129: X_TAB_LABEL in VARCHAR2) IS
130: cursor c IS
131: SELECT tab_value, APPLICATION_ID, ICON_NAME,
132: sequence_number, navigator_type
133: FROM JTF_NAV_TABS_B
134: WHERE TAB_id = X_TAB_id
135: FOR UPDATE OF TAB_ID nowait;
136: recinfo c%rowtype;
137:

Line 190: delete from JTF_NAV_TABS_B

186: if (sql%notfound) then
187: raise no_data_found;
188: end if;
189:
190: delete from JTF_NAV_TABS_B
191: where TAB_id = X_TAB_id;
192:
193: if (sql%notfound) then
194: raise no_data_found;

Line 204: from JTF_NAV_TABS_B B

200: begin
201: delete from JTF_NAV_TABS_TL T
202: where not exists
203: (select NULL
204: from JTF_NAV_TABS_B B
205: where B.TAB_id = T.TAB_id
206: );
207:
208: update JTF_NAV_TABS_TL T set (

Line 290: UPDATE jtf_nav_tabs_b SET

286: */
287: user_id := fnd_load_util.owner_id(x_owner);
288:
289: -- Load The record to _B table
290: UPDATE jtf_nav_tabs_b SET
291: navigator_type = x_navigator_type,
292: application_id = x_application_id,
293: icon_name = x_icon_name,
294: sequence_number = x_sequence_number,

Line 306: INSERT INTO jtf_nav_tabs_b

302: SELECT jtf_nav_tabs_s.nextval
303: INTO l_tab_id
304: FROM dual;
305:
306: INSERT INTO jtf_nav_tabs_b
307: (tab_id,
308: tab_value,
309: navigator_type,
310: application_id,

Line 335: FROM jtf_nav_tabs_b

331: END IF;
332:
333: SELECT tab_id
334: INTO l_tab_id
335: FROM jtf_nav_tabs_b
336: WHERE tab_value = x_tab_value;
337:
338: -- Load The record to _TL table
339: UPDATE jtf_nav_tabs_tl SET

Line 412: FROM jtf_nav_tabs_b

408:
409: --find the correct tab id
410: SELECT tab_id
411: INTO l_tab_id
412: FROM jtf_nav_tabs_b
413: WHERE tab_value = x_tab_value;
414:
415: -- Update the translation
416: UPDATE jtf_nav_tabs_tl SET