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 615: update HR_WINDOW_PROPERTIES_B set

611: X_LAST_UPDATED_BY in NUMBER,
612: X_LAST_UPDATE_LOGIN in NUMBER
613: ) is
614: begin
615: update HR_WINDOW_PROPERTIES_B set
616: INFORMATION17 = X_INFORMATION17,
617: INFORMATION18 = X_INFORMATION18,
618: INFORMATION19 = X_INFORMATION19,
619: INFORMATION20 = X_INFORMATION20,

Line 972: select hr_window_properties_b_s.nextval

968: where nvl(form_window_id,hr_api.g_number) = nvl(x_form_window_id,hr_api.g_number)
969: and nvl(template_window_id,hr_api.g_number) = nvl(x_template_window_id,hr_api.g_number);
970: exception
971: when no_data_found then
972: select hr_window_properties_b_s.nextval
973: into x_window_property_id
974: from dual;
975: end;
976: