APPS.HR_TEMPLATE_WINDOWS_PKG dependencies on HR_TEMPLATE_WINDOWS_B

Line 35: cursor C is select ROWID from HR_TEMPLATE_WINDOWS_B

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_TEMPLATE_WINDOWS_B
36: where TEMPLATE_WINDOW_ID = X_TEMPLATE_WINDOW_ID
37: ;
38: begin
39:

Line 47: p_entity_name => 'HR_TEMPLATE_WINDOWS_B',

43: --
44:
45: BEGIN
46: PER_RIC_PKG.chk_integrity (
47: p_entity_name => 'HR_TEMPLATE_WINDOWS_B',
48: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
49: PER_RIC_PKG.ref_info_rec('HR_FORM_TEMPLATES_B', PER_RIC_PKG.column_info_tbl(
50: PER_RIC_PKG.col_info_rec('FORM_TEMPLATE_ID',NULL,X_FORM_TEMPLATE_ID,NULL))),
51: PER_RIC_PKG.ref_info_rec('HR_FORM_WINDOWS_B', PER_RIC_PKG.column_info_tbl(

Line 60: insert into HR_TEMPLATE_WINDOWS_B (

56: END;
57: --
58: -- Code Ends Here.
59: --
60: insert into HR_TEMPLATE_WINDOWS_B (
61: TEMPLATE_WINDOW_ID,
62: OBJECT_VERSION_NUMBER,
63: FORM_TEMPLATE_ID,
64: FORM_WINDOW_ID,

Line 101: from HR_TEMPLATE_WINDOWS_B

97: cursor c1 is select
98: OBJECT_VERSION_NUMBER,
99: FORM_TEMPLATE_ID,
100: FORM_WINDOW_ID
101: from HR_TEMPLATE_WINDOWS_B
102: where TEMPLATE_WINDOW_ID = X_TEMPLATE_WINDOW_ID
103: for update of TEMPLATE_WINDOW_ID nowait;
104: begin
105: for tlinfo in c1 loop

Line 129: update HR_TEMPLATE_WINDOWS_B set

125: X_LAST_UPDATED_BY in NUMBER,
126: X_LAST_UPDATE_LOGIN in NUMBER
127: ) is
128: begin
129: update HR_TEMPLATE_WINDOWS_B set
130: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
131: FORM_TEMPLATE_ID = X_FORM_TEMPLATE_ID,
132: FORM_WINDOW_ID = X_FORM_WINDOW_ID,
133: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 155: p_entity_name => 'HR_TEMPLATE_WINDOWS_B',

151: --
152:
153: BEGIN
154: PER_RIC_PKG.chk_integrity (
155: p_entity_name => 'HR_TEMPLATE_WINDOWS_B',
156: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
157: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_CANVASES_B', PER_RIC_PKG.column_info_tbl(
158: PER_RIC_PKG.col_info_rec('TEMPLATE_WINDOW_ID',NULL,X_TEMPLATE_WINDOW_ID,NULL))),
159: PER_RIC_PKG.ref_info_rec('HR_WINDOW_PROPERTIES_B', PER_RIC_PKG.column_info_tbl(

Line 168: delete from HR_TEMPLATE_WINDOWS_B

164: END;
165: --
166: -- Code Ends Here.
167: --
168: delete from HR_TEMPLATE_WINDOWS_B
169: where TEMPLATE_WINDOW_ID = X_TEMPLATE_WINDOW_ID;
170:
171: if (sql%notfound) then
172: raise no_data_found;

Line 237: from hr_template_windows_b

233:
234: begin
235: select template_window_id
236: into x_template_window_id
237: from hr_template_windows_b
238: where form_template_id = x_form_template_id
239: and form_window_id = x_form_window_id;
240: exception
241: when no_data_found then

Line 242: select hr_template_windows_b_s.nextval

238: where form_template_id = x_form_template_id
239: and form_window_id = x_form_window_id;
240: exception
241: when no_data_found then
242: select hr_template_windows_b_s.nextval
243: into x_template_window_id
244: from dual;
245: end;
246: