APPS.HR_FORM_DATA_GROUPS_PKG dependencies on HR_FORM_DATA_GROUPS_B

Line 38: cursor C is select ROWID from HR_FORM_DATA_GROUPS_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_DATA_GROUPS_B
39: where FORM_DATA_GROUP_ID = X_FORM_DATA_GROUP_ID
40: ;
41: begin
42: insert into HR_FORM_DATA_GROUPS_B (

Line 42: insert into HR_FORM_DATA_GROUPS_B (

38: cursor C is select ROWID from HR_FORM_DATA_GROUPS_B
39: where FORM_DATA_GROUP_ID = X_FORM_DATA_GROUP_ID
40: ;
41: begin
42: insert into HR_FORM_DATA_GROUPS_B (
43: OBJECT_VERSION_NUMBER,
44: APPLICATION_ID,
45: FORM_ID,
46: DATA_GROUP_NAME,

Line 73: p_ref_entity => 'HR_FORM_DATA_GROUPS_B',

69: --
70: BEGIN
71: PER_RIC_PKG.chk_integrity (
72: p_entity_name => 'HR_FORM_DATA_GROUPS_TL',
73: p_ref_entity => 'HR_FORM_DATA_GROUPS_B',
74: p_ref_column_name => 'FORM_DATA_GROUP_ID',
75: p_ref_col_value_number => X_FORM_DATA_GROUP_ID,
76: p_ref_col_value_varchar => NULL,
77: p_ref_col_value_date => NULL,

Line 139: from HR_FORM_DATA_GROUPS_B

135: OBJECT_VERSION_NUMBER,
136: APPLICATION_ID,
137: FORM_ID,
138: DATA_GROUP_NAME
139: from HR_FORM_DATA_GROUPS_B
140: where FORM_DATA_GROUP_ID = X_FORM_DATA_GROUP_ID
141: for update of FORM_DATA_GROUP_ID nowait;
142: recinfo c%rowtype;
143:

Line 201: update HR_FORM_DATA_GROUPS_B set

197: X_LAST_UPDATED_BY in NUMBER,
198: X_LAST_UPDATE_LOGIN in NUMBER
199: ) is
200: begin
201: update HR_FORM_DATA_GROUPS_B set
202: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
203: APPLICATION_ID = X_APPLICATION_ID,
204: FORM_ID = X_FORM_ID,
205: DATA_GROUP_NAME = X_DATA_GROUP_NAME,

Line 248: p_entity_name => 'HR_FORM_DATA_GROUPS_B',

244: --
245:
246: BEGIN
247: PER_RIC_PKG.chk_integrity (
248: p_entity_name => 'HR_FORM_DATA_GROUPS_B',
249: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
250: PER_RIC_PKG.ref_info_rec('HR_FORM_DATA_GROUPS_TL', PER_RIC_PKG.column_info_tbl(
251: PER_RIC_PKG.col_info_rec('FORM_DATA_GROUP_ID',NULL,X_FORM_DATA_GROUP_ID,NULL))),
252: PER_RIC_PKG.ref_info_rec('HR_FORM_DATA_GROUP_ITEMS', PER_RIC_PKG.column_info_tbl(

Line 265: delete from HR_FORM_DATA_GROUPS_B

261: --
262: -- Code Ends Here.
263: --
264:
265: delete from HR_FORM_DATA_GROUPS_B
266: where FORM_DATA_GROUP_ID = X_FORM_DATA_GROUP_ID;
267:
268: if (sql%notfound) then
269: raise no_data_found;

Line 279: from HR_FORM_DATA_GROUPS_B B

275: begin
276: delete from HR_FORM_DATA_GROUPS_TL T
277: where not exists
278: (select NULL
279: from HR_FORM_DATA_GROUPS_B B
280: where B.FORM_DATA_GROUP_ID = T.FORM_DATA_GROUP_ID
281: );
282:
283: update HR_FORM_DATA_GROUPS_TL T set (

Line 380: from hr_form_data_groups_b

376: and application_id = x_application_id;
377:
378: select form_data_group_id
379: into x_form_data_group_id
380: from hr_form_data_groups_b
381: where data_group_name = x_data_group_name
382: and application_id = x_application_id
383: and form_id = x_form_id;
384:

Line 439: from hr_form_data_groups_b

435:
436: begin
437: select form_data_group_id
438: into x_form_data_group_id
439: from hr_form_data_groups_b
440: where data_group_name = x_data_group_name
441: and application_id = x_application_id
442: and form_id = x_form_id;
443: exception

Line 445: select hr_form_data_groups_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_data_groups_b_s.nextval
446: into x_form_data_group_id
447: from dual;
448: end;
449: