DBA Data[Home] [Help]

APPS.HR_FORM_PROPERTIES_PKG dependencies on HR_FORM_PROPERTIES_S

Line 66: update HR_FORM_PROPERTIES set

62: fetch csr_original into l_original;
63: if csr_original%found then
64: close csr_original;
65: for l_copy in csr_copies loop
66: update HR_FORM_PROPERTIES set
67: HELP_TARGET = decode(nvl(HELP_TARGET,hr_api.g_varchar2),nvl(l_original.HELP_TARGET,hr_api.g_varchar2),X_HELP_TARGET,HELP_TARGET),
68: INFORMATION_CATEGORY = decode(nvl(INFORMATION_CATEGORY,hr_api.g_varchar2),nvl(l_original.INFORMATION_CATEGORY,hr_api.g_varchar2),X_INFORMATION_CATEGORY,INFORMATION_CATEGORY),
69: INFORMATION1 = decode(nvl(INFORMATION1 ,hr_api.g_varchar2),nvl(l_original.INFORMATION1 ,hr_api.g_varchar2),X_INFORMATION1 ,INFORMATION1 ),
70: INFORMATION2 = decode(nvl(INFORMATION2 ,hr_api.g_varchar2),nvl(l_original.INFORMATION2 ,hr_api.g_varchar2),X_INFORMATION2 ,INFORMATION2 ),

Line 478: update HR_FORM_PROPERTIES set

474: X_LAST_UPDATED_BY in NUMBER,
475: X_LAST_UPDATE_LOGIN in NUMBER
476: ) is
477: begin
478: update HR_FORM_PROPERTIES set
479: INFORMATION29 = X_INFORMATION29,
480: INFORMATION16 = X_INFORMATION16,
481: INFORMATION17 = X_INFORMATION17,
482: INFORMATION18 = X_INFORMATION18,

Line 637: select hr_form_properties_s.nextval

633: and nvl(form_template_id,hr_api.g_number) = nvl(x_form_template_id,hr_api.g_number);
634:
635: exception
636: when no_data_found then
637: select hr_form_properties_s.nextval
638: into x_form_property_id
639: from dual;
640: end;
641: