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 1007: update HR_ITEM_PROPERTIES_B set

1003: X_LAST_UPDATED_BY in NUMBER,
1004: X_LAST_UPDATE_LOGIN in NUMBER
1005: ) is
1006: begin
1007: update HR_ITEM_PROPERTIES_B set
1008: UPDATE_ALLOWED = X_UPDATE_ALLOWED,
1009: INFORMATION20 = X_INFORMATION20,
1010: INFORMATION21 = X_INFORMATION21,
1011: INFORMATION22 = X_INFORMATION22,

Line 1886: select hr_item_properties_b_s.nextval

1882: */
1883:
1884: exception
1885: when no_data_found then
1886: select hr_item_properties_b_s.nextval
1887: into x_item_property_id
1888: from dual;
1889: end;
1890: