DBA Data[Home] [Help]

APPS.HR_WINDOW_PROPERTIES_PKG dependencies on HR_WINDOW_PROPERTIES_B_S

Line 74: update HR_WINDOW_PROPERTIES_B set

70: fetch csr_original into l_original;
71: if csr_original%found then
72: close csr_original;
73: for l_copy in csr_copies loop
74: update HR_WINDOW_PROPERTIES_B set
75: HEIGHT = decode(nvl(HEIGHT,hr_api.g_number),nvl(l_original.HEIGHT,hr_api.g_number),X_HEIGHT,HEIGHT),
76: WIDTH = decode(nvl(WIDTH,hr_api.g_number),nvl(l_original.WIDTH,hr_api.g_number),X_WIDTH,WIDTH),
77: X_POSITION = decode(nvl(X_POSITION,hr_api.g_number),nvl(l_original.X_POSITION,hr_api.g_number),X_X_POSITION,X_POSITION),
78: Y_POSITION = decode(nvl(Y_POSITION,hr_api.g_number),nvl(l_original.Y_POSITION,hr_api.g_number),X_Y_POSITION,Y_POSITION),

Line 575: update HR_WINDOW_PROPERTIES_B set

571: X_LAST_UPDATED_BY in NUMBER,
572: X_LAST_UPDATE_LOGIN in NUMBER
573: ) is
574: begin
575: update HR_WINDOW_PROPERTIES_B set
576: INFORMATION17 = X_INFORMATION17,
577: INFORMATION18 = X_INFORMATION18,
578: INFORMATION19 = X_INFORMATION19,
579: INFORMATION20 = X_INFORMATION20,

Line 914: select hr_window_properties_b_s.nextval

910: where nvl(form_window_id,hr_api.g_number) = nvl(x_form_window_id,hr_api.g_number)
911: and nvl(template_window_id,hr_api.g_number) = nvl(x_template_window_id,hr_api.g_number);
912: exception
913: when no_data_found then
914: select hr_window_properties_b_s.nextval
915: into x_window_property_id
916: from dual;
917: end;
918: