APPS.HR_FORM_TAB_PAGES_PKG dependencies on HR_FORM_TAB_PAGES_B

Line 39: cursor C is select ROWID from HR_FORM_TAB_PAGES_B

35: X_LAST_UPDATE_DATE in DATE,
36: X_LAST_UPDATED_BY in NUMBER,
37: X_LAST_UPDATE_LOGIN in NUMBER
38: ) is
39: cursor C is select ROWID from HR_FORM_TAB_PAGES_B
40: where FORM_TAB_PAGE_ID = X_FORM_TAB_PAGE_ID
41: ;
42: begin
43: insert into HR_FORM_TAB_PAGES_B (

Line 43: insert into HR_FORM_TAB_PAGES_B (

39: cursor C is select ROWID from HR_FORM_TAB_PAGES_B
40: where FORM_TAB_PAGE_ID = X_FORM_TAB_PAGE_ID
41: ;
42: begin
43: insert into HR_FORM_TAB_PAGES_B (
44: VISIBLE_OVERRIDE,
45: FORM_TAB_PAGE_ID,
46: OBJECT_VERSION_NUMBER,
47: FORM_CANVAS_ID,

Line 125: from HR_FORM_TAB_PAGES_B

121: OBJECT_VERSION_NUMBER,
122: FORM_CANVAS_ID,
123: TAB_PAGE_NAME,
124: DISPLAY_ORDER
125: from HR_FORM_TAB_PAGES_B
126: where FORM_TAB_PAGE_ID = X_FORM_TAB_PAGE_ID
127: for update of FORM_TAB_PAGE_ID nowait;
128: recinfo c%rowtype;
129:

Line 190: update HR_FORM_TAB_PAGES_B set

186: X_LAST_UPDATED_BY in NUMBER,
187: X_LAST_UPDATE_LOGIN in NUMBER
188: ) is
189: begin
190: update HR_FORM_TAB_PAGES_B set
191: VISIBLE_OVERRIDE = X_VISIBLE_OVERRIDE,
192: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
193: FORM_CANVAS_ID = X_FORM_CANVAS_ID,
194: TAB_PAGE_NAME = X_TAB_PAGE_NAME,

Line 231: delete from HR_FORM_TAB_PAGES_B

227: if (sql%notfound) then
228: raise no_data_found;
229: end if;
230:
231: delete from HR_FORM_TAB_PAGES_B
232: where FORM_TAB_PAGE_ID = X_FORM_TAB_PAGE_ID;
233:
234: if (sql%notfound) then
235: raise no_data_found;

Line 245: from HR_FORM_TAB_PAGES_B B

241: begin
242: delete from HR_FORM_TAB_PAGES_TL T
243: where not exists
244: (select NULL
245: from HR_FORM_TAB_PAGES_B B
246: where B.FORM_TAB_PAGE_ID = T.FORM_TAB_PAGE_ID
247: );
248:
249: update HR_FORM_TAB_PAGES_TL T set (

Line 350: ,hr_form_tab_pages_b ftp

346: select hfc.form_canvas_id,hfw.form_window_id,ftp.form_tab_page_id
347: into x_form_canvas_id,x_form_window_id,x_form_tab_page_id
348: from hr_form_canvases_b hfc
349: ,hr_form_windows_b hfw
350: ,hr_form_tab_pages_b ftp
351: where hfc.canvas_name = x_canvas_name
352: and hfw.application_id = x_application_id
353: and hfw.form_id = x_form_id
354: and hfc.form_window_id = hfw.form_window_id

Line 432: from hr_form_tab_pages_b ftp

428:
429: begin
430: select ftp.form_tab_page_id
431: into x_form_tab_page_id
432: from hr_form_tab_pages_b ftp
433: where ftp.form_canvas_id = x_form_canvas_id
434: and ftp.tab_page_name = x_tab_page_name;
435: exception
436: when no_data_found then

Line 437: select hr_form_tab_pages_b_s.nextval

433: where ftp.form_canvas_id = x_form_canvas_id
434: and ftp.tab_page_name = x_tab_page_name;
435: exception
436: when no_data_found then
437: select hr_form_tab_pages_b_s.nextval
438: into x_form_tab_page_id
439: from dual;
440: end;
441: