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:

Line 51: p_entity_name => 'HR_FORM_TAB_PAGES_B',

47: --
48:
49: BEGIN
50: PER_RIC_PKG.chk_integrity (
51: p_entity_name => 'HR_FORM_TAB_PAGES_B',
52: p_ref_entity => 'HR_FORM_CANVASES_B',
53: p_ref_column_name => 'FORM_CANVAS_ID',
54: p_ref_col_value_number => X_FORM_CANVAS_ID,
55: p_ref_col_value_varchar => NULL,

Line 63: insert into HR_FORM_TAB_PAGES_B (

59: END;
60: --
61: -- Code Ends Here.
62: --
63: insert into HR_FORM_TAB_PAGES_B (
64: VISIBLE_OVERRIDE,
65: FORM_TAB_PAGE_ID,
66: OBJECT_VERSION_NUMBER,
67: FORM_CANVAS_ID,

Line 97: p_ref_entity => 'HR_FORM_TAB_PAGES_B',

93:
94: BEGIN
95: PER_RIC_PKG.chk_integrity (
96: p_entity_name => 'HR_FORM_TAB_PAGES_TL',
97: p_ref_entity => 'HR_FORM_TAB_PAGES_B',
98: p_ref_column_name => 'FORM_TAB_PAGE_ID',
99: p_ref_col_value_number => X_FORM_TAB_PAGE_ID,
100: p_ref_col_value_varchar => NULL,
101: p_ref_col_value_date => NULL,

Line 165: from HR_FORM_TAB_PAGES_B

161: OBJECT_VERSION_NUMBER,
162: FORM_CANVAS_ID,
163: TAB_PAGE_NAME,
164: DISPLAY_ORDER
165: from HR_FORM_TAB_PAGES_B
166: where FORM_TAB_PAGE_ID = X_FORM_TAB_PAGE_ID
167: for update of FORM_TAB_PAGE_ID nowait;
168: recinfo c%rowtype;
169:

Line 230: update HR_FORM_TAB_PAGES_B set

226: X_LAST_UPDATED_BY in NUMBER,
227: X_LAST_UPDATE_LOGIN in NUMBER
228: ) is
229: begin
230: update HR_FORM_TAB_PAGES_B set
231: VISIBLE_OVERRIDE = X_VISIBLE_OVERRIDE,
232: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
233: FORM_CANVAS_ID = X_FORM_CANVAS_ID,
234: TAB_PAGE_NAME = X_TAB_PAGE_NAME,

Line 277: p_entity_name => 'HR_FORM_TAB_PAGES_B',

273: --
274:
275: BEGIN
276: PER_RIC_PKG.chk_integrity (
277: p_entity_name => 'HR_FORM_TAB_PAGES_B',
278: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
279: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
280: PER_RIC_PKG.col_info_rec('FORM_TAB_PAGE_ID',NULL,X_FORM_TAB_PAGE_ID,NULL))),
281: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(

Line 298: delete from HR_FORM_TAB_PAGES_B

294: END;
295: --
296: -- Code Ends Here.
297: --
298: delete from HR_FORM_TAB_PAGES_B
299: where FORM_TAB_PAGE_ID = X_FORM_TAB_PAGE_ID;
300:
301: if (sql%notfound) then
302: raise no_data_found;

Line 312: from HR_FORM_TAB_PAGES_B B

308: begin
309: delete from HR_FORM_TAB_PAGES_TL T
310: where not exists
311: (select NULL
312: from HR_FORM_TAB_PAGES_B B
313: where B.FORM_TAB_PAGE_ID = T.FORM_TAB_PAGE_ID
314: );
315:
316: update HR_FORM_TAB_PAGES_TL T set (

Line 417: ,hr_form_tab_pages_b ftp

413: select hfc.form_canvas_id,hfw.form_window_id,ftp.form_tab_page_id
414: into x_form_canvas_id,x_form_window_id,x_form_tab_page_id
415: from hr_form_canvases_b hfc
416: ,hr_form_windows_b hfw
417: ,hr_form_tab_pages_b ftp
418: where hfc.canvas_name = x_canvas_name
419: and hfw.application_id = x_application_id
420: and hfw.form_id = x_form_id
421: and hfc.form_window_id = hfw.form_window_id

Line 499: from hr_form_tab_pages_b ftp

495:
496: begin
497: select ftp.form_tab_page_id
498: into x_form_tab_page_id
499: from hr_form_tab_pages_b ftp
500: where ftp.form_canvas_id = x_form_canvas_id
501: and ftp.tab_page_name = x_tab_page_name;
502: exception
503: when no_data_found then

Line 504: select hr_form_tab_pages_b_s.nextval

500: where ftp.form_canvas_id = x_form_canvas_id
501: and ftp.tab_page_name = x_tab_page_name;
502: exception
503: when no_data_found then
504: select hr_form_tab_pages_b_s.nextval
505: into x_form_tab_page_id
506: from dual;
507: end;
508: