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 120: from HR_FORM_DATA_GROUPS_B

116: OBJECT_VERSION_NUMBER,
117: APPLICATION_ID,
118: FORM_ID,
119: DATA_GROUP_NAME
120: from HR_FORM_DATA_GROUPS_B
121: where FORM_DATA_GROUP_ID = X_FORM_DATA_GROUP_ID
122: for update of FORM_DATA_GROUP_ID nowait;
123: recinfo c%rowtype;
124:

Line 182: update HR_FORM_DATA_GROUPS_B set

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

Line 222: delete from HR_FORM_DATA_GROUPS_B

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

Line 236: from HR_FORM_DATA_GROUPS_B B

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

Line 336: from hr_form_data_groups_b

332: and application_id = x_application_id;
333:
334: select form_data_group_id
335: into x_form_data_group_id
336: from hr_form_data_groups_b
337: where data_group_name = x_data_group_name
338: and application_id = x_application_id
339: and form_id = x_form_id;
340:

Line 395: from hr_form_data_groups_b

391:
392: begin
393: select form_data_group_id
394: into x_form_data_group_id
395: from hr_form_data_groups_b
396: where data_group_name = x_data_group_name
397: and application_id = x_application_id
398: and form_id = x_form_id;
399: exception

Line 401: select hr_form_data_groups_b_s.nextval

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