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:

Line 111: insert into HR_FORM_TEMPLATES_B (

107: begin
108:
109:
110:
111: insert into HR_FORM_TEMPLATES_B (
112: OBJECT_VERSION_NUMBER,
113: APPLICATION_ID,
114: FORM_ID,
115: TEMPLATE_NAME,

Line 209: p_ref_entity => 'HR_FORM_TEMPLATES_B',

205:
206: BEGIN
207: PER_RIC_PKG.chk_integrity (
208: p_entity_name => 'HR_FORM_TEMPLATES_TL',
209: p_ref_entity => 'HR_FORM_TEMPLATES_B',
210: p_ref_column_name => 'FORM_TEMPLATE_ID',
211: p_ref_col_value_number => X_FORM_TEMPLATE_ID,
212: p_ref_col_value_varchar => NULL,
213: p_ref_col_value_date => NULL,

Line 341: from HR_FORM_TEMPLATES_B

337: ATTRIBUTE30,
338: ATTRIBUTE24,
339: ATTRIBUTE25,
340: ATTRIBUTE26
341: from HR_FORM_TEMPLATES_B
342: where FORM_TEMPLATE_ID = X_FORM_TEMPLATE_ID
343: for update of FORM_TEMPLATE_ID nowait;
344: recinfo c%rowtype;
345:

Line 501: update HR_FORM_TEMPLATES_B set

497: X_LAST_UPDATED_BY in NUMBER,
498: X_LAST_UPDATE_LOGIN in NUMBER
499: ) is
500: begin
501: update HR_FORM_TEMPLATES_B set
502: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
503: APPLICATION_ID = X_APPLICATION_ID,
504: FORM_ID = X_FORM_ID,
505: TEMPLATE_NAME = X_TEMPLATE_NAME,

Line 581: p_entity_name => 'HR_FORM_TEMPLATES_B',

577: --
578:
579: BEGIN
580: PER_RIC_PKG.chk_integrity (
581: p_entity_name => 'HR_FORM_TEMPLATES_B',
582: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
583: PER_RIC_PKG.ref_info_rec('HR_FORM_PROPERTIES', PER_RIC_PKG.column_info_tbl(
584: PER_RIC_PKG.col_info_rec('FORM_TEMPLATE_ID',NULL,X_FORM_TEMPLATE_ID,NULL))),
585: PER_RIC_PKG.ref_info_rec('HR_FORM_TEMPLATES_TL', PER_RIC_PKG.column_info_tbl(

Line 605: delete from HR_FORM_TEMPLATES_B

601: --
602: -- Code Ends Here.
603: --
604:
605: delete from HR_FORM_TEMPLATES_B
606: where FORM_TEMPLATE_ID = X_FORM_TEMPLATE_ID;
607:
608: if (sql%notfound) then
609: raise no_data_found;

Line 619: from HR_FORM_TEMPLATES_B B

615: begin
616: delete from HR_FORM_TEMPLATES_TL T
617: where not exists
618: (select NULL
619: from HR_FORM_TEMPLATES_B B
620: where B.FORM_TEMPLATE_ID = T.FORM_TEMPLATE_ID
621: );
622:
623: update HR_FORM_TEMPLATES_TL T set (

Line 722: from hr_form_templates_b

718:
719: begin
720: select form_template_id
721: into x_form_template_id
722: from hr_form_templates_b
723: where template_name = x_template_name
724: and ( (legislation_code is null and x_territory_short_name is null)
725: or (legislation_code = x_territory_short_name) )
726: and application_id = x_application_id

Line 818: from hr_form_templates_b

814:
815: begin
816: select form_template_id
817: into x_form_template_id
818: from hr_form_templates_b
819: where template_name = x_template_name
820: and ( (legislation_code is null and x_territory_short_name is null)
821: or (legislation_code = x_territory_short_name) )
822: and application_id = x_application_id

Line 826: select hr_form_templates_b_s.nextval

822: and application_id = x_application_id
823: and form_id = x_form_id;
824: exception
825: when no_data_found then
826: select hr_form_templates_b_s.nextval
827: into x_form_template_id
828: from dual;
829: end;
830: