APPS.JTF_NAV_VIEWBYS_PKG dependencies on JTF_NAV_VIEWBYS_B

Line 21: insert into JTF_NAV_VIEWBYS_B

17: BEGIN
18: SELECT jtf_nav_viewbys_s.nextval
19: INTO l_viewby_id
20: FROM dual;
21: insert into JTF_NAV_VIEWBYS_B
22: (viewby_id,
23: VIEWBY_VALUE,
24: TAB_id,
25: SEQUENCE_NUMBER,

Line 82: update JTF_NAV_VIEWBYS_B SET

78: X_LAST_UPDATE_DATE in DATE,
79: X_LAST_UPDATED_BY in NUMBER,
80: X_LAST_UPDATE_LOGIN in NUMBER) is
81: begin
82: update JTF_NAV_VIEWBYS_B SET
83: viewby_value = x_viewby_value,
84: TAB_id = X_TAB_id,
85: SEQUENCE_NUMBER = X_SEQUENCE_NUMBER,
86: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 118: from JTF_NAV_VIEWBYS_B

114: X_VIEWBY_LABEL in VARCHAR2) is
115:
116: cursor c IS
117: select viewby_value, TAB_id, SEQUENCE_NUMBER
118: from JTF_NAV_VIEWBYS_B
119: where VIEWBY_id = X_VIEWBY_id
120: for update of VIEWBY_id nowait;
121: recinfo c%rowtype;
122:

Line 174: delete from JTF_NAV_VIEWBYS_B

170: if (sql%notfound) then
171: raise no_data_found;
172: end if;
173:
174: delete from JTF_NAV_VIEWBYS_B
175: where VIEWBY_id = X_VIEWBY_id;
176:
177: if (sql%notfound) then
178: raise no_data_found;

Line 188: from JTF_NAV_VIEWBYS_B B

184: begin
185: delete from JTF_NAV_VIEWBYS_TL T
186: where not exists
187: (select NULL
188: from JTF_NAV_VIEWBYS_B B
189: where B.VIEWBY_id = T.VIEWBY_id
190: );
191:
192: update JTF_NAV_VIEWBYS_TL T set (

Line 279: UPDATE jtf_nav_viewbys_b SET

275: FROM jtf_nav_tabs_b
276: WHERE tab_value = x_tab_value;
277:
278: -- Load The record to _B table
279: UPDATE jtf_nav_viewbys_b SET
280: tab_id = l_tab_id,
281: sequence_number = x_sequence_number,
282: last_update_date = sysdate,
283: last_updated_by = user_id,

Line 293: INSERT INTO jtf_nav_viewbys_b

289: SELECT jtf_nav_viewbys_s.nextval
290: INTO l_viewby_id
291: FROM dual;
292:
293: INSERT INTO jtf_nav_viewbys_b
294: (viewby_id,
295: viewby_value,
296: tab_id,
297: sequence_number,

Line 319: FROM jtf_nav_viewbys_b

315:
316: --select the viewby id
317: SELECT viewby_id
318: INTO l_viewby_id
319: FROM jtf_nav_viewbys_b
320: WHERE viewby_value = x_viewby_value;
321:
322: -- Load The record to _TL table
323: UPDATE jtf_nav_viewbys_tl SET

Line 396: FROM jtf_nav_viewbys_b

392:
393: --select the viewby_id
394: SELECT viewby_id
395: INTO l_viewby_id
396: FROM jtf_nav_viewbys_b
397: WHERE viewby_value = x_viewby_value;
398:
399: -- Update the translation
400: UPDATE jtf_nav_viewbys_tl SET