DBA Data[Home] [Help]

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 74: p_ref_entity => 'HR_FORM_WINDOWS_B',

70:
71: BEGIN
72: PER_RIC_PKG.chk_integrity (
73: p_entity_name => 'HR_FORM_WINDOWS_TL',
74: p_ref_entity => 'HR_FORM_WINDOWS_B',
75: p_ref_column_name => 'FORM_WINDOW_ID',
76: p_ref_col_value_number => X_FORM_WINDOW_ID,
77: p_ref_col_value_varchar => NULL,
78: p_ref_col_value_date => NULL,

Line 140: from HR_FORM_WINDOWS_B

136: WINDOW_NAME,
137: FORM_ID,
138: OBJECT_VERSION_NUMBER,
139: APPLICATION_ID
140: from HR_FORM_WINDOWS_B
141: where FORM_WINDOW_ID = X_FORM_WINDOW_ID
142: for update of FORM_WINDOW_ID nowait;
143: recinfo c%rowtype;
144:

Line 202: update HR_FORM_WINDOWS_B set

198: X_LAST_UPDATED_BY in NUMBER,
199: X_LAST_UPDATE_LOGIN in NUMBER
200: ) is
201: begin
202: update HR_FORM_WINDOWS_B set
203: WINDOW_NAME = X_WINDOW_NAME,
204: FORM_ID = X_FORM_ID,
205: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
206: APPLICATION_ID = X_APPLICATION_ID,

Line 249: p_entity_name => 'HR_FORM_WINDOWS_B',

245: --
246:
247: BEGIN
248: PER_RIC_PKG.chk_integrity (
249: p_entity_name => 'HR_FORM_WINDOWS_B',
250: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
251: PER_RIC_PKG.ref_info_rec('HR_FORM_CANVASES_B', PER_RIC_PKG.column_info_tbl(
252: PER_RIC_PKG.col_info_rec('FORM_WINDOW_ID',NULL,X_FORM_WINDOW_ID,NULL))),
253: PER_RIC_PKG.ref_info_rec('HR_FORM_WINDOWS_TL', PER_RIC_PKG.column_info_tbl(

Line 267: delete from HR_FORM_WINDOWS_B

263: --
264: -- Code Ends Here.
265: --
266:
267: delete from HR_FORM_WINDOWS_B
268: where FORM_WINDOW_ID = X_FORM_WINDOW_ID;
269:
270: if (sql%notfound) then
271: raise no_data_found;

Line 281: from HR_FORM_WINDOWS_B B

277: begin
278: delete from HR_FORM_WINDOWS_TL T
279: where not exists
280: (select NULL
281: from HR_FORM_WINDOWS_B B
282: where B.FORM_WINDOW_ID = T.FORM_WINDOW_ID
283: );
284:
285: update HR_FORM_WINDOWS_TL T set (

Line 380: from hr_form_windows_b

376: and application_id = x_application_id;
377:
378: select form_window_id
379: into x_form_window_id
380: from hr_form_windows_b
381: where window_name = x_window_name
382: and application_id = x_application_id
383: and form_id = x_form_id;
384:

Line 439: from hr_form_windows_b

435:
436: begin
437: select form_window_id
438: into x_form_window_id
439: from hr_form_windows_b
440: where window_name = x_window_name
441: and application_id = x_application_id
442: and form_id = x_form_id;
443: exception

Line 445: select hr_form_windows_b_s.nextval

441: and application_id = x_application_id
442: and form_id = x_form_id;
443: exception
444: when no_data_found then
445: select hr_form_windows_b_s.nextval
446: into x_form_window_id
447: from dual;
448: end;
449: