APPS.HR_FORM_TEMPLATES_PKG dependencies on HR_FORM_TEMPLATES_B

Line 104: cursor C is select ROWID from HR_FORM_TEMPLATES_B

100: X_LAST_UPDATE_DATE in DATE,
101: X_LAST_UPDATED_BY in NUMBER,
102: X_LAST_UPDATE_LOGIN in NUMBER
103: ) is
104: cursor C is select ROWID from HR_FORM_TEMPLATES_B
105: where FORM_TEMPLATE_ID = X_FORM_TEMPLATE_ID
106: ;
107: begin
108: insert into HR_FORM_TEMPLATES_B (

Line 108: insert into HR_FORM_TEMPLATES_B (

104: cursor C is select ROWID from HR_FORM_TEMPLATES_B
105: where FORM_TEMPLATE_ID = X_FORM_TEMPLATE_ID
106: ;
107: begin
108: insert into HR_FORM_TEMPLATES_B (
109: OBJECT_VERSION_NUMBER,
110: APPLICATION_ID,
111: FORM_ID,
112: TEMPLATE_NAME,

Line 318: from HR_FORM_TEMPLATES_B

314: ATTRIBUTE30,
315: ATTRIBUTE24,
316: ATTRIBUTE25,
317: ATTRIBUTE26
318: from HR_FORM_TEMPLATES_B
319: where FORM_TEMPLATE_ID = X_FORM_TEMPLATE_ID
320: for update of FORM_TEMPLATE_ID nowait;
321: recinfo c%rowtype;
322:

Line 478: update HR_FORM_TEMPLATES_B set

474: X_LAST_UPDATED_BY in NUMBER,
475: X_LAST_UPDATE_LOGIN in NUMBER
476: ) is
477: begin
478: update HR_FORM_TEMPLATES_B set
479: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
480: APPLICATION_ID = X_APPLICATION_ID,
481: FORM_ID = X_FORM_ID,
482: TEMPLATE_NAME = X_TEMPLATE_NAME,

Line 551: delete from HR_FORM_TEMPLATES_B

547: if (sql%notfound) then
548: raise no_data_found;
549: end if;
550:
551: delete from HR_FORM_TEMPLATES_B
552: where FORM_TEMPLATE_ID = X_FORM_TEMPLATE_ID;
553:
554: if (sql%notfound) then
555: raise no_data_found;

Line 565: from HR_FORM_TEMPLATES_B B

561: begin
562: delete from HR_FORM_TEMPLATES_TL T
563: where not exists
564: (select NULL
565: from HR_FORM_TEMPLATES_B B
566: where B.FORM_TEMPLATE_ID = T.FORM_TEMPLATE_ID
567: );
568:
569: update HR_FORM_TEMPLATES_TL T set (

Line 668: from hr_form_templates_b

664:
665: begin
666: select form_template_id
667: into x_form_template_id
668: from hr_form_templates_b
669: where template_name = x_template_name
670: and ( (legislation_code is null and x_territory_short_name is null)
671: or (legislation_code = x_territory_short_name) )
672: and application_id = x_application_id

Line 764: from hr_form_templates_b

760:
761: begin
762: select form_template_id
763: into x_form_template_id
764: from hr_form_templates_b
765: where template_name = x_template_name
766: and ( (legislation_code is null and x_territory_short_name is null)
767: or (legislation_code = x_territory_short_name) )
768: and application_id = x_application_id

Line 772: select hr_form_templates_b_s.nextval

768: and application_id = x_application_id
769: and form_id = x_form_id;
770: exception
771: when no_data_found then
772: select hr_form_templates_b_s.nextval
773: into x_form_template_id
774: from dual;
775: end;
776: