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: insert into HR_FORM_TAB_STACKED_CANVASES (

Line 39: insert into HR_FORM_TAB_STACKED_CANVASES (

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: insert into HR_FORM_TAB_STACKED_CANVASES (
40: FORM_TAB_STACKED_CANVAS_ID,
41: OBJECT_VERSION_NUMBER,
42: FORM_TAB_PAGE_ID,
43: FORM_CANVAS_ID,

Line 80: from HR_FORM_TAB_STACKED_CANVASES

76: cursor c1 is select
77: OBJECT_VERSION_NUMBER,
78: FORM_TAB_PAGE_ID,
79: FORM_CANVAS_ID
80: from HR_FORM_TAB_STACKED_CANVASES
81: where FORM_TAB_STACKED_CANVAS_ID = X_FORM_TAB_STACKED_CANVAS_ID
82: for update of FORM_TAB_STACKED_CANVAS_ID nowait;
83: begin
84: for tlinfo in c1 loop

Line 108: update HR_FORM_TAB_STACKED_CANVASES set

104: X_LAST_UPDATED_BY in NUMBER,
105: X_LAST_UPDATE_LOGIN in NUMBER
106: ) is
107: begin
108: update HR_FORM_TAB_STACKED_CANVASES set
109: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
110: FORM_TAB_PAGE_ID = X_FORM_TAB_PAGE_ID,
111: FORM_CANVAS_ID = X_FORM_CANVAS_ID,
112: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 126: delete from HR_FORM_TAB_STACKED_CANVASES

122: procedure DELETE_ROW (
123: X_FORM_TAB_STACKED_CANVAS_ID in NUMBER
124: ) is
125: begin
126: delete from HR_FORM_TAB_STACKED_CANVASES
127: where FORM_TAB_STACKED_CANVAS_ID = X_FORM_TAB_STACKED_CANVAS_ID;
128:
129: if (sql%notfound) then
130: raise no_data_found;

Line 206: from hr_form_tab_stacked_canvases ftsc

202:
203: begin
204: select ftsc.form_tab_stacked_canvas_id
205: into x_form_tab_stacked_canvas_id
206: from hr_form_tab_stacked_canvases ftsc
207: where ftsc.form_canvas_id = x_form_canvas_id
208: and ftsc.form_tab_page_id = x_form_tab_page_id;
209: exception
210: when no_data_found then

Line 211: select hr_form_tab_stacked_canvases_s.nextval

207: where ftsc.form_canvas_id = x_form_canvas_id
208: and ftsc.form_tab_page_id = x_form_tab_page_id;
209: exception
210: when no_data_found then
211: select hr_form_tab_stacked_canvases_s.nextval
212: into x_form_tab_stacked_canvas_id
213: from dual;
214: end;
215: