eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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:

Line 214: p_entity_name => 'HR_WINDOW_PROPERTIES_B',

210: --
211:
212: BEGIN
213: PER_RIC_PKG.chk_integrity (
214: p_entity_name => 'HR_WINDOW_PROPERTIES_B',
215: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
216: PER_RIC_PKG.ref_info_rec('HR_FORM_WINDOWS_B', PER_RIC_PKG.column_info_tbl(
217: PER_RIC_PKG.col_info_rec('FORM_WINDOW_ID',NULL,X_FORM_WINDOW_ID,NULL))),
218: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_WINDOWS_B', PER_RIC_PKG.column_info_tbl(

Line 227: insert into HR_WINDOW_PROPERTIES_B (

223: END;
224: --
225: -- Code Ends Here.
226: --
227: insert into HR_WINDOW_PROPERTIES_B (
228: INFORMATION17,
229: INFORMATION18,
230: INFORMATION19,
231: INFORMATION20,

Line 325: p_ref_entity => 'HR_WINDOW_PROPERTIES_B',

321:
322: BEGIN
323: PER_RIC_PKG.chk_integrity (
324: p_entity_name => 'HR_WINDOW_PROPERTIES_TL',
325: p_ref_entity => 'HR_WINDOW_PROPERTIES_B',
326: p_ref_column_name => 'WINDOW_PROPERTY_ID',
327: p_ref_col_value_number => X_WINDOW_PROPERTY_ID,
328: p_ref_col_value_varchar => NULL,
329: p_ref_col_value_date => NULL,

Line 453: from HR_WINDOW_PROPERTIES_B

449: INFORMATION1,
450: INFORMATION2,
451: INFORMATION3,
452: INFORMATION4
453: from HR_WINDOW_PROPERTIES_B
454: where WINDOW_PROPERTY_ID = X_WINDOW_PROPERTY_ID
455: for update of WINDOW_PROPERTY_ID nowait;
456: recinfo c%rowtype;
457:

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 693: p_entity_name => 'HR_WINDOW_PROPERTIES_B',

689: --
690:
691: BEGIN
692: PER_RIC_PKG.chk_integrity (
693: p_entity_name => 'HR_WINDOW_PROPERTIES_B',
694: p_ref_entity => 'HR_WINDOW_PROPERTIES_TL',
695: p_ref_column_name => 'WINDOW_PROPERTY_ID',
696: p_ref_col_value_number => X_WINDOW_PROPERTY_ID,
697: p_ref_col_value_varchar => NULL,

Line 705: delete from HR_WINDOW_PROPERTIES_B

701: END;
702: --
703: -- Code Ends Here.
704: --
705: delete from HR_WINDOW_PROPERTIES_B
706: where WINDOW_PROPERTY_ID = X_WINDOW_PROPERTY_ID;
707:
708: if (sql%notfound) then
709: raise no_data_found;

Line 719: from HR_WINDOW_PROPERTIES_B B

715: begin
716: delete from HR_WINDOW_PROPERTIES_TL T
717: where not exists
718: (select NULL
719: from HR_WINDOW_PROPERTIES_B B
720: where B.WINDOW_PROPERTY_ID = T.WINDOW_PROPERTY_ID
721: );
722:
723: update HR_WINDOW_PROPERTIES_TL T set (

Line 844: from hr_window_properties_b

840: END IF;
841:
842: select window_property_id
843: into x_window_property_id
844: from hr_window_properties_b
845: where nvl(form_window_id,hr_api.g_number) = nvl(x_form_window_id,hr_api.g_number)
846: and nvl(template_window_id,hr_api.g_number) = nvl(x_template_window_id,hr_api.g_number);
847:
848: update HR_WINDOW_PROPERTIES_TL set

Line 967: from hr_window_properties_b

963:
964: begin
965: select window_property_id
966: into x_window_property_id
967: from hr_window_properties_b
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

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: