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.ICX_ON_UTILITIES dependencies on ICX_SEC

Line 27: l_language_code := icx_sec.getID(icx_sec.pv_language_code);

23: l_message varchar2(2000);
24:
25: begin
26:
27: l_language_code := icx_sec.getID(icx_sec.pv_language_code);
28:
29: if p_page_code is not null
30: then
31: select NAME,PRIMARY_REGION_APPL_ID,PRIMARY_REGION_CODE

Line 176: l_language_code varchar2(30) := icx_sec.getID(icx_sec.pv_language_code);

172: p_page_code in varchar2,
173: p_clear_button in varchar2,
174: p_advanced_button in varchar2) is
175:
176: l_language_code varchar2(30) := icx_sec.getID(icx_sec.pv_language_code);
177: l_responsibility_id number := icx_sec.getID(icx_sec.pv_responsibility_id);
178:
179: l_message varchar2(240);
180: l_page_title varchar2(80);

Line 177: l_responsibility_id number := icx_sec.getID(icx_sec.pv_responsibility_id);

173: p_clear_button in varchar2,
174: p_advanced_button in varchar2) is
175:
176: l_language_code varchar2(30) := icx_sec.getID(icx_sec.pv_language_code);
177: l_responsibility_id number := icx_sec.getID(icx_sec.pv_responsibility_id);
178:
179: l_message varchar2(240);
180: l_page_title varchar2(80);
181: l_page_description varchar2(2000);

Line 1060: l_responsibility_id := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID);

1056:
1057: c_to_region_appl_id := r.REGION_APPLICATION_ID;
1058: c_to_region_code := r.REGION_CODE;
1059:
1060: l_responsibility_id := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID);
1061: l_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
1062: if c_type = 'W'
1063: then
1064: l_return_children := 'T';

Line 1061: l_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);

1057: c_to_region_appl_id := r.REGION_APPLICATION_ID;
1058: c_to_region_code := r.REGION_CODE;
1059:
1060: l_responsibility_id := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID);
1061: l_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
1062: if c_type = 'W'
1063: then
1064: l_return_children := 'T';
1065: else

Line 1140: l_responsibility_id := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID);

1136: c_from_region_appl_id,c_from_region_code
1137: from AK_FLOW_REGION_RELATIONS
1138: where ROWID = c_rowid;
1139:
1140: l_responsibility_id := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID);
1141: l_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
1142:
1143: /* DEBUG
1144: set serverout on size 200000;

Line 1141: l_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);

1137: from AK_FLOW_REGION_RELATIONS
1138: where ROWID = c_rowid;
1139:
1140: l_responsibility_id := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID);
1141: l_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
1142:
1143: /* DEBUG
1144: set serverout on size 200000;
1145: ALTER SESSION SET SQL_TRACE TRUE;

Line 1221: l_language_code varchar2(30) := icx_sec.getID(icx_sec.pv_language_code);

1217: l_region number_table;
1218: l_region_seq number_table;
1219: l_prompt varchar2(50);
1220: l_S varchar2(2000);
1221: l_language_code varchar2(30) := icx_sec.getID(icx_sec.pv_language_code);
1222: l_cookie owa_cookie.cookie;
1223: l_page_title varchar2(240);
1224: l_page_description varchar2(2000);
1225: l_region_description varchar2(2000);

Line 1651: c_where := c_where||' trunc('||c_column_name||') = to_date(:ICXBIND'||l_index||','|| icx_sec.g_date_format || ')';

1647: elsif c_data_type = 'D'
1648: then
1649: l_input := upper(l_input);
1650: checkDate(l_input);
1651: c_where := c_where||' trunc('||c_column_name||') = to_date(:ICXBIND'||l_index||','|| icx_sec.g_date_format || ')';
1652: l_values(l_index) := l_input;
1653: l_index := l_index + 1;
1654: elsif c_data_type = 'N'
1655: then

Line 1662: c_where := c_where||' '||c_column_name||' = to_date(:ICXBIND'||l_index||','|| icx_sec.g_date_format || ')';

1658: l_index := l_index + 1;
1659: elsif c_data_type = 'T'
1660: then
1661: l_input := upper(l_input);
1662: c_where := c_where||' '||c_column_name||' = to_date(:ICXBIND'||l_index||','|| icx_sec.g_date_format || ')';
1663: l_values(l_index) := l_input;
1664: l_index := l_index + 1;
1665: else
1666: c_where := c_where||' '||c_column_name||' = :ICXBIND'||l_index;

Line 1688: c_where := c_where||' trunc('||c_column_name||') <> to_date(:ICXBIND'||l_index||','|| icx_sec.g_date_format || ')';

1684: elsif c_data_type = 'D'
1685: then
1686: l_input := upper(l_input);
1687: checkDate(l_input);
1688: c_where := c_where||' trunc('||c_column_name||') <> to_date(:ICXBIND'||l_index||','|| icx_sec.g_date_format || ')';
1689: l_values(l_index) := l_input;
1690: l_index := l_index + 1;
1691: elsif c_data_type = 'N'
1692: then

Line 1699: c_where := c_where||' '||c_column_name||' <> to_date(:ICXBIND'||l_index||','|| icx_sec.g_date_format || ')';

1695: l_index := l_index + 1;
1696: elsif c_data_type = 'T'
1697: then
1698: l_input := upper(l_input);
1699: c_where := c_where||' '||c_column_name||' <> to_date(:ICXBIND'||l_index||','|| icx_sec.g_date_format || ')';
1700: l_values(l_index) := l_input;
1701: l_index := l_index + 1;
1702: else
1703: c_where := c_where||' '||c_column_name||' <> :ICXBIND'||l_index;

Line 1745: c_where := c_where||' trunc('||c_column_name||') >= to_date(:ICXBIND'||l_index||','|| icx_sec.g_date_format || ')';

1741: then
1742: l_input := upper(l_input);
1743: if c_and = 'Y' then c_where := c_where||' and '; end if;
1744: checkDate(l_input);
1745: c_where := c_where||' trunc('||c_column_name||') >= to_date(:ICXBIND'||l_index||','|| icx_sec.g_date_format || ')';
1746: l_values(l_index) := l_input;
1747: l_index := l_index + 1;
1748: c_and := 'Y';
1749: elsif c_data_type = 'N'

Line 1760: c_where := c_where||' '||c_column_name||' >= to_date(:ICXBIND'||l_index||','|| icx_sec.g_date_format || ')';

1756: elsif c_data_type = 'T'
1757: then
1758: l_input := upper(l_input);
1759: if c_and = 'Y' then c_where := c_where||' and '; end if;
1760: c_where := c_where||' '||c_column_name||' >= to_date(:ICXBIND'||l_index||','|| icx_sec.g_date_format || ')';
1761: l_values(l_index) := l_input;
1762: l_index := l_index + 1;
1763: c_and := 'Y';
1764: else

Line 1789: c_where := c_where||' trunc('||c_column_name||') > to_date(:ICXBIND'||l_index||','|| icx_sec.g_date_format || ')';

1785: then
1786: l_input := upper(l_input);
1787: if c_and = 'Y' then c_where := c_where||' and '; end if;
1788: checkDate(l_input);
1789: c_where := c_where||' trunc('||c_column_name||') > to_date(:ICXBIND'||l_index||','|| icx_sec.g_date_format || ')';
1790: l_values(l_index) := l_input;
1791: l_index := l_index + 1;
1792: c_and := 'Y';
1793: elsif c_data_type = 'N'

Line 1804: c_where := c_where||' '||c_column_name||' > to_date(:ICXBIND'||l_index||','|| icx_sec.g_date_format || ')';

1800: elsif c_data_type = 'T'
1801: then
1802: l_input := upper(l_input);
1803: if c_and = 'Y' then c_where := c_where||' and '; end if;
1804: c_where := c_where||' '||c_column_name||' > to_date(:ICXBIND'||l_index||','|| icx_sec.g_date_format || ')';
1805: l_values(l_index) := l_input;
1806: l_index := l_index + 1;
1807: c_and := 'Y';
1808: else

Line 1832: c_where := c_where||' trunc('||c_column_name||') <= to_date(:ICXBIND'||l_index||','|| icx_sec.g_date_format || ')';

1828: then
1829: l_input := upper(l_input);
1830: if c_and = 'Y' then c_where := c_where||' and '; end if;
1831: checkDate(l_input);
1832: c_where := c_where||' trunc('||c_column_name||') <= to_date(:ICXBIND'||l_index||','|| icx_sec.g_date_format || ')';
1833: l_values(l_index) := l_input;
1834: l_index := l_index + 1;
1835: c_and := 'Y';
1836: elsif c_data_type = 'N'

Line 1847: c_where := c_where||' '||c_column_name||' <= to_date(:ICXBIND'||l_index||','|| icx_sec.g_date_format || ')';

1843: elsif c_data_type = 'T'
1844: then
1845: l_input := upper(l_input);
1846: if c_and = 'Y' then c_where := c_where||' and '; end if;
1847: c_where := c_where||' '||c_column_name||' <= to_date(:ICXBIND'||l_index||','|| icx_sec.g_date_format || ')';
1848: l_values(l_index) := l_input;
1849: l_index := l_index + 1;
1850: c_and := 'Y';
1851: else

Line 1876: c_where := c_where||' trunc('||c_column_name||') < to_date(:ICXBIND'||l_index||','|| icx_sec.g_date_format || ')';

1872: then
1873: l_input := upper(l_input);
1874: if c_and = 'Y' then c_where := c_where||' and '; end if;
1875: checkDate(l_input);
1876: c_where := c_where||' trunc('||c_column_name||') < to_date(:ICXBIND'||l_index||','|| icx_sec.g_date_format || ')';
1877: l_values(l_index) := l_input;
1878: l_index := l_index + 1;
1879: c_and := 'Y';
1880: elsif c_data_type = 'N'

Line 1891: c_where := c_where||' '||c_column_name||' < to_date(:ICXBIND'||l_index||','|| icx_sec.g_date_format || ')';

1887: elsif c_data_type = 'T'
1888: then
1889: l_input := upper(l_input);
1890: if c_and = 'Y' then c_where := c_where||' and '; end if;
1891: c_where := c_where||' '||c_column_name||' < to_date(:ICXBIND'||l_index||','|| icx_sec.g_date_format || ')';
1892: l_values(l_index) := l_input;
1893: l_index := l_index + 1;
1894: c_and := 'Y';
1895: else

Line 2100: l_dummy_db_date:=icx_sec.getNLS_PARAMETER('NLS_DATE_FORMAT');

2096:
2097: --select to_char(to_date(p_date))
2098: --into l_dummy_varchar2
2099: --from sys.dual;
2100: l_dummy_db_date:=icx_sec.getNLS_PARAMETER('NLS_DATE_FORMAT');
2101:
2102: IF (nvl(icx_sec.g_date_format,'X') <> nvl(icx_sec.g_date_format_c,'Y')) or
2103: (nvl(icx_sec.g_date_format_c,'Y') <> l_dummy_db_date) THEN
2104:

Line 2102: IF (nvl(icx_sec.g_date_format,'X') <> nvl(icx_sec.g_date_format_c,'Y')) or

2098: --into l_dummy_varchar2
2099: --from sys.dual;
2100: l_dummy_db_date:=icx_sec.getNLS_PARAMETER('NLS_DATE_FORMAT');
2101:
2102: IF (nvl(icx_sec.g_date_format,'X') <> nvl(icx_sec.g_date_format_c,'Y')) or
2103: (nvl(icx_sec.g_date_format_c,'Y') <> l_dummy_db_date) THEN
2104:
2105: c_date_format := ''''||icx_sec.g_date_format||'''';
2106: dbms_session.set_nls('NLS_DATE_FORMAT', c_date_format);

Line 2103: (nvl(icx_sec.g_date_format_c,'Y') <> l_dummy_db_date) THEN

2099: --from sys.dual;
2100: l_dummy_db_date:=icx_sec.getNLS_PARAMETER('NLS_DATE_FORMAT');
2101:
2102: IF (nvl(icx_sec.g_date_format,'X') <> nvl(icx_sec.g_date_format_c,'Y')) or
2103: (nvl(icx_sec.g_date_format_c,'Y') <> l_dummy_db_date) THEN
2104:
2105: c_date_format := ''''||icx_sec.g_date_format||'''';
2106: dbms_session.set_nls('NLS_DATE_FORMAT', c_date_format);
2107: icx_sec.g_date_format_c := icx_sec.g_date_format;

Line 2105: c_date_format := ''''||icx_sec.g_date_format||'''';

2101:
2102: IF (nvl(icx_sec.g_date_format,'X') <> nvl(icx_sec.g_date_format_c,'Y')) or
2103: (nvl(icx_sec.g_date_format_c,'Y') <> l_dummy_db_date) THEN
2104:
2105: c_date_format := ''''||icx_sec.g_date_format||'''';
2106: dbms_session.set_nls('NLS_DATE_FORMAT', c_date_format);
2107: icx_sec.g_date_format_c := icx_sec.g_date_format;
2108:
2109: END IF;

Line 2107: icx_sec.g_date_format_c := icx_sec.g_date_format;

2103: (nvl(icx_sec.g_date_format_c,'Y') <> l_dummy_db_date) THEN
2104:
2105: c_date_format := ''''||icx_sec.g_date_format||'''';
2106: dbms_session.set_nls('NLS_DATE_FORMAT', c_date_format);
2107: icx_sec.g_date_format_c := icx_sec.g_date_format;
2108:
2109: END IF;
2110:
2111: select to_date(p_date,icx_sec.g_date_format)

Line 2111: select to_date(p_date,icx_sec.g_date_format)

2107: icx_sec.g_date_format_c := icx_sec.g_date_format;
2108:
2109: END IF;
2110:
2111: select to_date(p_date,icx_sec.g_date_format)
2112: into l_dummy_date
2113: from sys.dual;
2114: -- end changes for 1618876
2115: