APPS.HR_WINDOW_PROPERTIES_PKG dependencies on HR_WINDOW_PROPERTIES_B

Line 57: from HR_WINDOW_PROPERTIES_B wnp

53: where WINDOW_PROPERTY_ID = X_WINDOW_PROPERTY_ID;
54: l_original csr_original%rowtype;
55: cursor csr_copies is
56: select wnp.window_property_id
57: from HR_WINDOW_PROPERTIES_B wnp
58: ,HR_TEMPLATE_WINDOWS_B twn
59: ,HR_TEMPLATE_WINDOWS_B two
60: where wnp.TEMPLATE_WINDOW_ID = twn.TEMPLATE_WINDOW_ID
61: and twn.FORM_TEMPLATE_ID in (select sft.FORM_TEMPLATE_ID_TO

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 202: cursor C is select ROWID from HR_WINDOW_PROPERTIES_B

198: X_LAST_UPDATE_DATE in DATE,
199: X_LAST_UPDATED_BY in NUMBER,
200: X_LAST_UPDATE_LOGIN in NUMBER
201: ) is
202: cursor C is select ROWID from HR_WINDOW_PROPERTIES_B
203: where WINDOW_PROPERTY_ID = X_WINDOW_PROPERTY_ID
204: ;
205: begin
206: insert into HR_WINDOW_PROPERTIES_B (

Line 206: insert into HR_WINDOW_PROPERTIES_B (

202: cursor C is select ROWID from HR_WINDOW_PROPERTIES_B
203: where WINDOW_PROPERTY_ID = X_WINDOW_PROPERTY_ID
204: ;
205: begin
206: insert into HR_WINDOW_PROPERTIES_B (
207: INFORMATION17,
208: INFORMATION18,
209: INFORMATION19,
210: INFORMATION20,

Line 413: from HR_WINDOW_PROPERTIES_B

409: INFORMATION1,
410: INFORMATION2,
411: INFORMATION3,
412: INFORMATION4
413: from HR_WINDOW_PROPERTIES_B
414: where WINDOW_PROPERTY_ID = X_WINDOW_PROPERTY_ID
415: for update of WINDOW_PROPERTY_ID nowait;
416: recinfo c%rowtype;
417:

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 647: delete from HR_WINDOW_PROPERTIES_B

643: if (sql%notfound) then
644: raise no_data_found;
645: end if;
646:
647: delete from HR_WINDOW_PROPERTIES_B
648: where WINDOW_PROPERTY_ID = X_WINDOW_PROPERTY_ID;
649:
650: if (sql%notfound) then
651: raise no_data_found;

Line 661: from HR_WINDOW_PROPERTIES_B B

657: begin
658: delete from HR_WINDOW_PROPERTIES_TL T
659: where not exists
660: (select NULL
661: from HR_WINDOW_PROPERTIES_B B
662: where B.WINDOW_PROPERTY_ID = T.WINDOW_PROPERTY_ID
663: );
664:
665: update HR_WINDOW_PROPERTIES_TL T set (

Line 786: from hr_window_properties_b

782: END IF;
783:
784: select window_property_id
785: into x_window_property_id
786: from hr_window_properties_b
787: where nvl(form_window_id,hr_api.g_number) = nvl(x_form_window_id,hr_api.g_number)
788: and nvl(template_window_id,hr_api.g_number) = nvl(x_template_window_id,hr_api.g_number);
789:
790: update HR_WINDOW_PROPERTIES_TL set

Line 909: from hr_window_properties_b

905:
906: begin
907: select window_property_id
908: into x_window_property_id
909: from hr_window_properties_b
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

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: