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 499: update HR_FORM_PROPERTIES set

495: X_LAST_UPDATED_BY in NUMBER,
496: X_LAST_UPDATE_LOGIN in NUMBER
497: ) is
498: begin
499: update HR_FORM_PROPERTIES set
500: INFORMATION29 = X_INFORMATION29,
501: INFORMATION16 = X_INFORMATION16,
502: INFORMATION17 = X_INFORMATION17,
503: INFORMATION18 = X_INFORMATION18,

Line 659: select hr_form_properties_s.nextval

655: and nvl(form_template_id,hr_api.g_number) = nvl(x_form_template_id,hr_api.g_number);
656:
657: exception
658: when no_data_found then
659: select hr_form_properties_s.nextval
660: into x_form_property_id
661: from dual;
662: end;
663: