DBA Data[Home] [Help]

APPS.HR_ITEM_PROPERTIES_PKG dependencies on HR_ITEM_PROPERTIES_B_S

Line 122: update HR_ITEM_PROPERTIES_B set

118: fetch csr_original into l_original;
119: if csr_original%found then
120: close csr_original;
121: for l_copy in csr_copies loop
122: update HR_ITEM_PROPERTIES_B set
123: ALIGNMENT = decode(nvl(ALIGNMENT,hr_api.g_number),nvl(l_original.ALIGNMENT,hr_api.g_number),X_ALIGNMENT,ALIGNMENT),
124: BEVEL = decode(nvl(BEVEL,hr_api.g_number),nvl(l_original.BEVEL,hr_api.g_number),X_BEVEL,BEVEL),
125: CASE_RESTRICTION = decode(nvl(CASE_RESTRICTION,hr_api.g_number),nvl(l_original.CASE_RESTRICTION,hr_api.g_number),X_CASE_RESTRICTION,CASE_RESTRICTION),
126: ENABLED = decode(nvl(ENABLED,hr_api.g_number),nvl(l_original.ENABLED,hr_api.g_number),X_ENABLED,ENABLED),

Line 939: update HR_ITEM_PROPERTIES_B set

935: X_LAST_UPDATED_BY in NUMBER,
936: X_LAST_UPDATE_LOGIN in NUMBER
937: ) is
938: begin
939: update HR_ITEM_PROPERTIES_B set
940: UPDATE_ALLOWED = X_UPDATE_ALLOWED,
941: INFORMATION20 = X_INFORMATION20,
942: INFORMATION21 = X_INFORMATION21,
943: INFORMATION22 = X_INFORMATION22,

Line 1800: select hr_item_properties_b_s.nextval

1796: */
1797:
1798: exception
1799: when no_data_found then
1800: select hr_item_properties_b_s.nextval
1801: into x_item_property_id
1802: from dual;
1803: end;
1804: