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: insert into HR_ITEM_PROPERTIES_B (

Line 325: insert into HR_ITEM_PROPERTIES_B (

321: cursor C is select ROWID from HR_ITEM_PROPERTIES_B
322: where ITEM_PROPERTY_ID = X_ITEM_PROPERTY_ID
323: ;
324: begin
325: insert into HR_ITEM_PROPERTIES_B (
326: UPDATE_ALLOWED,
327: INFORMATION20,
328: INFORMATION21,
329: INFORMATION22,

Line 668: from HR_ITEM_PROPERTIES_B

664: INSERT_ALLOWED,
665: PROMPT_ALIGNMENT_OFFSET,
666: PROMPT_DISPLAY_STYLE,
667: PROMPT_EDGE
668: from HR_ITEM_PROPERTIES_B
669: where ITEM_PROPERTY_ID = X_ITEM_PROPERTY_ID
670: for update of ITEM_PROPERTY_ID nowait;
671: recinfo c%rowtype;
672:

Line 939: update HR_ITEM_PROPERTIES_B set

935: X_LAST_UPDATED_BY in NUMBER,
936: X_LAST_UPDATE_LOGIN in NUMBER
937: ) is
938: begin
939: update HR_ITEM_PROPERTIES_B set
940: UPDATE_ALLOWED = X_UPDATE_ALLOWED,
941: INFORMATION20 = X_INFORMATION20,
942: INFORMATION21 = X_INFORMATION21,
943: INFORMATION22 = X_INFORMATION22,

Line 1046: delete from HR_ITEM_PROPERTIES_B

1042: if (sql%notfound) then
1043: raise no_data_found;
1044: end if;
1045:
1046: delete from HR_ITEM_PROPERTIES_B
1047: where ITEM_PROPERTY_ID = X_ITEM_PROPERTY_ID;
1048:
1049: if (sql%notfound) then
1050: raise no_data_found;

Line 1060: from HR_ITEM_PROPERTIES_B B

1056: begin
1057: delete from HR_ITEM_PROPERTIES_TL T
1058: where not exists
1059: (select NULL
1060: from HR_ITEM_PROPERTIES_B B
1061: where B.ITEM_PROPERTY_ID = T.ITEM_PROPERTY_ID
1062: );
1063:
1064: update HR_ITEM_PROPERTIES_TL T set (

Line 1767: from hr_item_properties_b

1763: x_form_item_id := null;
1764: x_template_item_id := null;
1765: select item_property_id
1766: into x_item_property_id
1767: from hr_item_properties_b
1768: where template_item_context_id=x_template_item_context_id;
1769: else
1770: x_template_item_context_id := null;
1771: if x_template_name is null then

Line 1775: from hr_item_properties_b

1771: if x_template_name is null then
1772: x_template_item_id := null;
1773: select item_property_id
1774: into x_item_property_id
1775: from hr_item_properties_b
1776: where form_item_id=x_form_item_id;
1777: else
1778: x_form_item_id := null;
1779: select item_property_id

Line 1781: from hr_item_properties_b

1777: else
1778: x_form_item_id := null;
1779: select item_property_id
1780: into x_item_property_id
1781: from hr_item_properties_b
1782: where template_item_id=x_template_item_id;
1783: end if;
1784: end if;
1785:

Line 1792: from hr_item_properties_b

1788:
1789: begin
1790: select item_property_id
1791: into x_item_property_id
1792: from hr_item_properties_b
1793: where nvl(form_item_id,hr_api.g_number) = nvl(x_form_item_id,hr_api.g_number)
1794: and nvl(template_item_id,hr_api.g_number) = nvl(x_template_item_id,hr_api.g_number)
1795: and nvl(template_item_context_id,hr_api.g_number) = nvl(x_template_item_context_id,hr_api.g_number);
1796: */

Line 1800: select hr_item_properties_b_s.nextval

1796: */
1797:
1798: exception
1799: when no_data_found then
1800: select hr_item_properties_b_s.nextval
1801: into x_item_property_id
1802: from dual;
1803: end;
1804:

Line 2285: from hr_item_properties_b

2281: x_form_item_id := null;
2282: x_template_item_id := null;
2283: select item_property_id
2284: into x_item_property_id
2285: from hr_item_properties_b
2286: where template_item_context_id=x_template_item_context_id;
2287: else --x_id_flex_structure_code is null
2288: x_template_item_context_id := null;
2289: if x_template_name is null then

Line 2293: from hr_item_properties_b

2289: if x_template_name is null then
2290: x_template_item_id := null;
2291: select item_property_id
2292: into x_item_property_id
2293: from hr_item_properties_b
2294: where form_item_id=x_form_item_id;
2295: else
2296: x_form_item_id := null;
2297: select item_property_id

Line 2299: from hr_item_properties_b

2295: else
2296: x_form_item_id := null;
2297: select item_property_id
2298: into x_item_property_id
2299: from hr_item_properties_b
2300: where template_item_id=x_template_item_id;
2301: end if;
2302: end if; --endif x_id_flex_structure_code is not null
2303:

Line 2312: from hr_item_properties_b

2308:
2309: /* removed for performance reasons, replaced by separate sql stmts immediately above
2310: select item_property_id
2311: into x_item_property_id
2312: from hr_item_properties_b
2313: where nvl(form_item_id,hr_api.g_number) = nvl(x_form_item_id,hr_api.g_number)
2314: and nvl(template_item_id,hr_api.g_number) = nvl(x_template_item_id,hr_api.g_number)
2315: and nvl(template_item_context_id,hr_api.g_number) = nvl(x_template_item_context_id,hr_api.g_number);
2316: */

Line 2573: from hr_item_properties_b

2569: x_form_item_id := null;
2570: x_template_item_id := null;
2571: select item_property_id
2572: into x_item_property_id
2573: from hr_item_properties_b
2574: where template_item_context_id=x_template_item_context_id;
2575: else --x_id_flex_structure_code is null
2576: x_template_item_context_id := null;
2577: if x_template_name is null then

Line 2581: from hr_item_properties_b

2577: if x_template_name is null then
2578: x_template_item_id := null;
2579: select item_property_id
2580: into x_item_property_id
2581: from hr_item_properties_b
2582: where form_item_id=x_form_item_id;
2583: else
2584: x_form_item_id := null;
2585: select item_property_id

Line 2587: from hr_item_properties_b

2583: else
2584: x_form_item_id := null;
2585: select item_property_id
2586: into x_item_property_id
2587: from hr_item_properties_b
2588: where template_item_id=x_template_item_id;
2589: end if;
2590: end if; --endif x_id_flex_structure_code is not null
2591:

Line 2600: from hr_item_properties_b

2596:
2597: /* removed for performance reasons, replaced by separate sql stmts immediately above
2598: select item_property_id
2599: into x_item_property_id
2600: from hr_item_properties_b
2601: where nvl(form_item_id,hr_api.g_number) = nvl(x_form_item_id,hr_api.g_number)
2602: and nvl(template_item_id,hr_api.g_number) = nvl(x_template_item_id,hr_api.g_number)
2603: and nvl(template_item_context_id,hr_api.g_number) = nvl(x_template_item_context_id,hr_api.g_number);
2604: */