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_ITEM_PROPERTIES_PKG dependencies on HR_ITEM_PROPERTIES_B

Line 105: from HR_ITEM_PROPERTIES_B itp

101: where ITEM_PROPERTY_ID = X_ITEM_PROPERTY_ID;
102: l_original csr_original%rowtype;
103: cursor csr_copies is
104: select itp.item_property_id
105: from HR_ITEM_PROPERTIES_B itp
106: ,HR_TEMPLATE_ITEMS_B tim
107: ,HR_TEMPLATE_ITEMS_B tio
108: where itp.TEMPLATE_ITEM_ID = tim.TEMPLATE_ITEM_ID
109: and tim.FORM_TEMPLATE_ID in (select sft.FORM_TEMPLATE_ID_TO

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 321: cursor C is select ROWID from HR_ITEM_PROPERTIES_B

317: X_LAST_UPDATE_DATE in DATE,
318: X_LAST_UPDATED_BY in NUMBER,
319: X_LAST_UPDATE_LOGIN in NUMBER
320: ) is
321: cursor C is select ROWID from HR_ITEM_PROPERTIES_B
322: where ITEM_PROPERTY_ID = X_ITEM_PROPERTY_ID
323: ;
324: begin
325:

Line 333: p_entity_name => 'HR_ITEM_PROPERTIES_B',

329: --
330:
331: BEGIN
332: PER_RIC_PKG.chk_integrity (
333: p_entity_name => 'HR_ITEM_PROPERTIES_B',
334: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
335: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
336: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_FORM_ITEM_ID,NULL))),
337: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(

Line 373: insert into HR_ITEM_PROPERTIES_B (

369: --
370: -- Code Ends Here.
371: --
372:
373: insert into HR_ITEM_PROPERTIES_B (
374: UPDATE_ALLOWED,
375: INFORMATION20,
376: INFORMATION21,
377: INFORMATION22,

Line 533: p_ref_entity => 'HR_ITEM_PROPERTIES_B',

529:
530: BEGIN
531: PER_RIC_PKG.chk_integrity (
532: p_entity_name => 'HR_ITEM_PROPERTIES_TL',
533: p_ref_entity => 'HR_ITEM_PROPERTIES_B',
534: p_ref_column_name => 'ITEM_PROPERTY_ID',
535: p_ref_col_value_number => X_ITEM_PROPERTY_ID,
536: p_ref_col_value_varchar => NULL,
537: p_ref_col_value_date => NULL,

Line 736: from HR_ITEM_PROPERTIES_B

732: INSERT_ALLOWED,
733: PROMPT_ALIGNMENT_OFFSET,
734: PROMPT_DISPLAY_STYLE,
735: PROMPT_EDGE
736: from HR_ITEM_PROPERTIES_B
737: where ITEM_PROPERTY_ID = X_ITEM_PROPERTY_ID
738: for update of ITEM_PROPERTY_ID nowait;
739: recinfo c%rowtype;
740:

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 1120: p_entity_name => 'HR_ITEM_PROPERTIES_B',

1116: --
1117:
1118: BEGIN
1119: PER_RIC_PKG.chk_integrity (
1120: p_entity_name => 'HR_ITEM_PROPERTIES_B',
1121: p_ref_entity => 'HR_ITEM_PROPERTIES_TL',
1122: p_ref_column_name => 'ITEM_PROPERTY_ID',
1123: p_ref_col_value_number => X_ITEM_PROPERTY_ID,
1124: p_ref_col_value_varchar => NULL,

Line 1132: delete from HR_ITEM_PROPERTIES_B

1128: END;
1129: --
1130: -- Code Ends Here.
1131: --
1132: delete from HR_ITEM_PROPERTIES_B
1133: where ITEM_PROPERTY_ID = X_ITEM_PROPERTY_ID;
1134:
1135: if (sql%notfound) then
1136: raise no_data_found;

Line 1146: from HR_ITEM_PROPERTIES_B B

1142: begin
1143: delete from HR_ITEM_PROPERTIES_TL T
1144: where not exists
1145: (select NULL
1146: from HR_ITEM_PROPERTIES_B B
1147: where B.ITEM_PROPERTY_ID = T.ITEM_PROPERTY_ID
1148: );
1149:
1150: update HR_ITEM_PROPERTIES_TL T set (

Line 1853: from hr_item_properties_b

1849: x_form_item_id := null;
1850: x_template_item_id := null;
1851: select item_property_id
1852: into x_item_property_id
1853: from hr_item_properties_b
1854: where template_item_context_id=x_template_item_context_id;
1855: else
1856: x_template_item_context_id := null;
1857: if x_template_name is null then

Line 1861: from hr_item_properties_b

1857: if x_template_name is null then
1858: x_template_item_id := null;
1859: select item_property_id
1860: into x_item_property_id
1861: from hr_item_properties_b
1862: where form_item_id=x_form_item_id;
1863: else
1864: x_form_item_id := null;
1865: select item_property_id

Line 1867: from hr_item_properties_b

1863: else
1864: x_form_item_id := null;
1865: select item_property_id
1866: into x_item_property_id
1867: from hr_item_properties_b
1868: where template_item_id=x_template_item_id;
1869: end if;
1870: end if;
1871:

Line 1878: from hr_item_properties_b

1874:
1875: begin
1876: select item_property_id
1877: into x_item_property_id
1878: from hr_item_properties_b
1879: where nvl(form_item_id,hr_api.g_number) = nvl(x_form_item_id,hr_api.g_number)
1880: and nvl(template_item_id,hr_api.g_number) = nvl(x_template_item_id,hr_api.g_number)
1881: and nvl(template_item_context_id,hr_api.g_number) = nvl(x_template_item_context_id,hr_api.g_number);
1882: */

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:

Line 2371: from hr_item_properties_b

2367: x_form_item_id := null;
2368: x_template_item_id := null;
2369: select item_property_id
2370: into x_item_property_id
2371: from hr_item_properties_b
2372: where template_item_context_id=x_template_item_context_id;
2373: else --x_id_flex_structure_code is null
2374: x_template_item_context_id := null;
2375: if x_template_name is null then

Line 2379: from hr_item_properties_b

2375: if x_template_name is null then
2376: x_template_item_id := null;
2377: select item_property_id
2378: into x_item_property_id
2379: from hr_item_properties_b
2380: where form_item_id=x_form_item_id;
2381: else
2382: x_form_item_id := null;
2383: select item_property_id

Line 2385: from hr_item_properties_b

2381: else
2382: x_form_item_id := null;
2383: select item_property_id
2384: into x_item_property_id
2385: from hr_item_properties_b
2386: where template_item_id=x_template_item_id;
2387: end if;
2388: end if; --endif x_id_flex_structure_code is not null
2389:

Line 2398: from hr_item_properties_b

2394:
2395: /* removed for performance reasons, replaced by separate sql stmts immediately above
2396: select item_property_id
2397: into x_item_property_id
2398: from hr_item_properties_b
2399: where nvl(form_item_id,hr_api.g_number) = nvl(x_form_item_id,hr_api.g_number)
2400: and nvl(template_item_id,hr_api.g_number) = nvl(x_template_item_id,hr_api.g_number)
2401: and nvl(template_item_context_id,hr_api.g_number) = nvl(x_template_item_context_id,hr_api.g_number);
2402: */

Line 2659: from hr_item_properties_b

2655: x_form_item_id := null;
2656: x_template_item_id := null;
2657: select item_property_id
2658: into x_item_property_id
2659: from hr_item_properties_b
2660: where template_item_context_id=x_template_item_context_id;
2661: else --x_id_flex_structure_code is null
2662: x_template_item_context_id := null;
2663: if x_template_name is null then

Line 2667: from hr_item_properties_b

2663: if x_template_name is null then
2664: x_template_item_id := null;
2665: select item_property_id
2666: into x_item_property_id
2667: from hr_item_properties_b
2668: where form_item_id=x_form_item_id;
2669: else
2670: x_form_item_id := null;
2671: select item_property_id

Line 2673: from hr_item_properties_b

2669: else
2670: x_form_item_id := null;
2671: select item_property_id
2672: into x_item_property_id
2673: from hr_item_properties_b
2674: where template_item_id=x_template_item_id;
2675: end if;
2676: end if; --endif x_id_flex_structure_code is not null
2677:

Line 2686: from hr_item_properties_b

2682:
2683: /* removed for performance reasons, replaced by separate sql stmts immediately above
2684: select item_property_id
2685: into x_item_property_id
2686: from hr_item_properties_b
2687: where nvl(form_item_id,hr_api.g_number) = nvl(x_form_item_id,hr_api.g_number)
2688: and nvl(template_item_id,hr_api.g_number) = nvl(x_template_item_id,hr_api.g_number)
2689: and nvl(template_item_context_id,hr_api.g_number) = nvl(x_template_item_context_id,hr_api.g_number);
2690: */