APPS.HR_FORM_ITEMS_PKG dependencies on HR_FORM_ITEMS_B

Line 45: cursor C is select ROWID from HR_FORM_ITEMS_B

41: X_LAST_UPDATE_DATE in DATE,
42: X_LAST_UPDATED_BY in NUMBER,
43: X_LAST_UPDATE_LOGIN in NUMBER
44: ) is
45: cursor C is select ROWID from HR_FORM_ITEMS_B
46: where FORM_ITEM_ID = X_FORM_ITEM_ID
47: ;
48: begin
49: insert into HR_FORM_ITEMS_B (

Line 49: insert into HR_FORM_ITEMS_B (

45: cursor C is select ROWID from HR_FORM_ITEMS_B
46: where FORM_ITEM_ID = X_FORM_ITEM_ID
47: ;
48: begin
49: insert into HR_FORM_ITEMS_B (
50: FORM_ITEM_ID,
51: OBJECT_VERSION_NUMBER,
52: APPLICATION_ID,
53: FORM_ID,

Line 155: from HR_FORM_ITEMS_B

151: RADIO_BUTTON_NAME,
152: REQUIRED_OVERRIDE,
153: FORM_TAB_PAGE_ID_OVERRIDE,
154: VISIBLE_OVERRIDE
155: from HR_FORM_ITEMS_B
156: where FORM_ITEM_ID = X_FORM_ITEM_ID
157: for update of FORM_ITEM_ID nowait;
158: recinfo c%rowtype;
159:

Line 236: update HR_FORM_ITEMS_B set

232: X_LAST_UPDATED_BY in NUMBER,
233: X_LAST_UPDATE_LOGIN in NUMBER
234: ) is
235: begin
236: update HR_FORM_ITEMS_B set
237: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
238: APPLICATION_ID = X_APPLICATION_ID,
239: FORM_ID = X_FORM_ID,
240: FORM_CANVAS_ID = X_FORM_CANVAS_ID,

Line 283: delete from HR_FORM_ITEMS_B

279: if (sql%notfound) then
280: raise no_data_found;
281: end if;
282:
283: delete from HR_FORM_ITEMS_B
284: where FORM_ITEM_ID = X_FORM_ITEM_ID;
285:
286: if (sql%notfound) then
287: raise no_data_found;

Line 297: from HR_FORM_ITEMS_B B

293: begin
294: delete from HR_FORM_ITEMS_TL T
295: where not exists
296: (select NULL
297: from HR_FORM_ITEMS_B B
298: where B.FORM_ITEM_ID = T.FORM_ITEM_ID
299: );
300:
301: update HR_FORM_ITEMS_TL T set (

Line 401: from hr_form_items_b

397: and application_id = x_application_id;
398:
399: select form_item_id
400: into x_form_item_id
401: from hr_form_items_b
402: where full_item_name = x_full_item_name
403: and application_id = x_application_id
404: and form_id = x_form_id
405: and ( radio_button_name = x_radio_button_name

Line 510: from hr_form_items_b

506:
507: begin
508: select form_item_id
509: into x_form_item_id
510: from hr_form_items_b
511: where full_item_name = x_full_item_name
512: and application_id = x_application_id
513: and form_id = x_form_id
514: and ( radio_button_name = x_radio_button_name

Line 518: select hr_form_items_b_s.nextval

514: and ( radio_button_name = x_radio_button_name
515: or (radio_button_name is null and x_radio_button_name is null) );
516: exception
517: when no_data_found then
518: select hr_form_items_b_s.nextval
519: into x_form_item_id
520: from dual;
521: end;
522: begin