APPS.HR_FORM_WINDOWS_PKG dependencies on HR_FORM_WINDOWS_B

Line 38: cursor C is select ROWID from HR_FORM_WINDOWS_B

34: X_LAST_UPDATE_DATE in DATE,
35: X_LAST_UPDATED_BY in NUMBER,
36: X_LAST_UPDATE_LOGIN in NUMBER
37: ) is
38: cursor C is select ROWID from HR_FORM_WINDOWS_B
39: where FORM_WINDOW_ID = X_FORM_WINDOW_ID
40: ;
41: begin
42: insert into HR_FORM_WINDOWS_B (

Line 42: insert into HR_FORM_WINDOWS_B (

38: cursor C is select ROWID from HR_FORM_WINDOWS_B
39: where FORM_WINDOW_ID = X_FORM_WINDOW_ID
40: ;
41: begin
42: insert into HR_FORM_WINDOWS_B (
43: WINDOW_NAME,
44: FORM_ID,
45: FORM_WINDOW_ID,
46: OBJECT_VERSION_NUMBER,

Line 120: from HR_FORM_WINDOWS_B

116: WINDOW_NAME,
117: FORM_ID,
118: OBJECT_VERSION_NUMBER,
119: APPLICATION_ID
120: from HR_FORM_WINDOWS_B
121: where FORM_WINDOW_ID = X_FORM_WINDOW_ID
122: for update of FORM_WINDOW_ID nowait;
123: recinfo c%rowtype;
124:

Line 182: update HR_FORM_WINDOWS_B set

178: X_LAST_UPDATED_BY in NUMBER,
179: X_LAST_UPDATE_LOGIN in NUMBER
180: ) is
181: begin
182: update HR_FORM_WINDOWS_B set
183: WINDOW_NAME = X_WINDOW_NAME,
184: FORM_ID = X_FORM_ID,
185: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
186: APPLICATION_ID = X_APPLICATION_ID,

Line 222: delete from HR_FORM_WINDOWS_B

218: if (sql%notfound) then
219: raise no_data_found;
220: end if;
221:
222: delete from HR_FORM_WINDOWS_B
223: where FORM_WINDOW_ID = X_FORM_WINDOW_ID;
224:
225: if (sql%notfound) then
226: raise no_data_found;

Line 236: from HR_FORM_WINDOWS_B B

232: begin
233: delete from HR_FORM_WINDOWS_TL T
234: where not exists
235: (select NULL
236: from HR_FORM_WINDOWS_B B
237: where B.FORM_WINDOW_ID = T.FORM_WINDOW_ID
238: );
239:
240: update HR_FORM_WINDOWS_TL T set (

Line 335: from hr_form_windows_b

331: and application_id = x_application_id;
332:
333: select form_window_id
334: into x_form_window_id
335: from hr_form_windows_b
336: where window_name = x_window_name
337: and application_id = x_application_id
338: and form_id = x_form_id;
339:

Line 394: from hr_form_windows_b

390:
391: begin
392: select form_window_id
393: into x_form_window_id
394: from hr_form_windows_b
395: where window_name = x_window_name
396: and application_id = x_application_id
397: and form_id = x_form_id;
398: exception

Line 400: select hr_form_windows_b_s.nextval

396: and application_id = x_application_id
397: and form_id = x_form_id;
398: exception
399: when no_data_found then
400: select hr_form_windows_b_s.nextval
401: into x_form_window_id
402: from dual;
403: end;
404: