APPS.HR_FSC_PKG dependencies on HR_FORM_TAB_STACKED_CANVASES

Line 35: cursor C is select ROWID from HR_FORM_TAB_STACKED_CANVASES

31: X_LAST_UPDATE_DATE in DATE,
32: X_LAST_UPDATED_BY in NUMBER,
33: X_LAST_UPDATE_LOGIN in NUMBER
34: ) is
35: cursor C is select ROWID from HR_FORM_TAB_STACKED_CANVASES
36: where FORM_TAB_STACKED_CANVAS_ID = X_FORM_TAB_STACKED_CANVAS_ID
37: ;
38: begin
39:

Line 47: p_entity_name => 'HR_FORM_TAB_STACKED_CANVASES',

43: --
44:
45: BEGIN
46: PER_RIC_PKG.chk_integrity (
47: p_entity_name => 'HR_FORM_TAB_STACKED_CANVASES',
48: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
49: PER_RIC_PKG.ref_info_rec('HR_FORM_TAB_PAGES_B', PER_RIC_PKG.column_info_tbl(
50: PER_RIC_PKG.col_info_rec('FORM_TAB_PAGE_ID',NULL,X_FORM_TAB_PAGE_ID,NULL))),
51: PER_RIC_PKG.ref_info_rec('HR_FORM_CANVASES_B', PER_RIC_PKG.column_info_tbl(

Line 61: insert into HR_FORM_TAB_STACKED_CANVASES (

57: --
58: -- Code Ends Here.
59: --
60:
61: insert into HR_FORM_TAB_STACKED_CANVASES (
62: FORM_TAB_STACKED_CANVAS_ID,
63: OBJECT_VERSION_NUMBER,
64: FORM_TAB_PAGE_ID,
65: FORM_CANVAS_ID,

Line 102: from HR_FORM_TAB_STACKED_CANVASES

98: cursor c1 is select
99: OBJECT_VERSION_NUMBER,
100: FORM_TAB_PAGE_ID,
101: FORM_CANVAS_ID
102: from HR_FORM_TAB_STACKED_CANVASES
103: where FORM_TAB_STACKED_CANVAS_ID = X_FORM_TAB_STACKED_CANVAS_ID
104: for update of FORM_TAB_STACKED_CANVAS_ID nowait;
105: begin
106: for tlinfo in c1 loop

Line 130: update HR_FORM_TAB_STACKED_CANVASES set

126: X_LAST_UPDATED_BY in NUMBER,
127: X_LAST_UPDATE_LOGIN in NUMBER
128: ) is
129: begin
130: update HR_FORM_TAB_STACKED_CANVASES set
131: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
132: FORM_TAB_PAGE_ID = X_FORM_TAB_PAGE_ID,
133: FORM_CANVAS_ID = X_FORM_CANVAS_ID,
134: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 148: delete from HR_FORM_TAB_STACKED_CANVASES

144: procedure DELETE_ROW (
145: X_FORM_TAB_STACKED_CANVAS_ID in NUMBER
146: ) is
147: begin
148: delete from HR_FORM_TAB_STACKED_CANVASES
149: where FORM_TAB_STACKED_CANVAS_ID = X_FORM_TAB_STACKED_CANVAS_ID;
150:
151: if (sql%notfound) then
152: raise no_data_found;

Line 228: from hr_form_tab_stacked_canvases ftsc

224:
225: begin
226: select ftsc.form_tab_stacked_canvas_id
227: into x_form_tab_stacked_canvas_id
228: from hr_form_tab_stacked_canvases ftsc
229: where ftsc.form_canvas_id = x_form_canvas_id
230: and ftsc.form_tab_page_id = x_form_tab_page_id;
231: exception
232: when no_data_found then

Line 233: select hr_form_tab_stacked_canvases_s.nextval

229: where ftsc.form_canvas_id = x_form_canvas_id
230: and ftsc.form_tab_page_id = x_form_tab_page_id;
231: exception
232: when no_data_found then
233: select hr_form_tab_stacked_canvases_s.nextval
234: into x_form_tab_stacked_canvas_id
235: from dual;
236: end;
237: