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.OKC_REPORT_PVT dependencies on FND_GLOBAL

Line 517: fnd_global.user_id,

513: userenv('LANG'),
514: l_sql_id,
515: G_mid,
516: empty_clob(),
517: fnd_global.user_id,
518: sysdate,
519: fnd_global.user_id,
520: sysdate,
521: fnd_global.login_id

Line 519: fnd_global.user_id,

515: G_mid,
516: empty_clob(),
517: fnd_global.user_id,
518: sysdate,
519: fnd_global.user_id,
520: sysdate,
521: fnd_global.login_id
522: );
523: select XML_TEXT into x_xml_text

Line 521: fnd_global.login_id

517: fnd_global.user_id,
518: sysdate,
519: fnd_global.user_id,
520: sysdate,
521: fnd_global.login_id
522: );
523: select XML_TEXT into x_xml_text
524: from okc_report_xml
525: where CHR_ID = G_kid

Line 727: fnd_global.user_id,

723: G_xid,
724: 0,
725: G_mid,
726: empty_clob(),
727: fnd_global.user_id,
728: sysdate,
729: fnd_global.user_id,
730: sysdate,
731: fnd_global.login_id

Line 729: fnd_global.user_id,

725: G_mid,
726: empty_clob(),
727: fnd_global.user_id,
728: sysdate,
729: fnd_global.user_id,
730: sysdate,
731: fnd_global.login_id
732: );
733: select HTM_TEXT into x_htm_text

Line 731: fnd_global.login_id

727: fnd_global.user_id,
728: sysdate,
729: fnd_global.user_id,
730: sysdate,
731: fnd_global.login_id
732: );
733: select HTM_TEXT into x_htm_text
734: from okc_report_htm
735: where CHR_ID = G_kid

Line 1011: fnd_global.apps_initialize(

1007: select value
1008: from NLS_SESSION_PARAMETERS
1009: where PARAMETER=param;
1010: begin
1011: fnd_global.apps_initialize(
1012: user_id => to_number(p_uid),
1013: resp_id => to_number(p_rid),
1014: resp_appl_id => to_number(p_aid),
1015: security_group_id => to_number(p_gid)

Line 1057: -- uid=fnd_global.user_id

1053: -- vid=p_major_version
1054: -- sid=p_scn_id
1055: -- nlsl=
1056: -- nlst=
1057: -- uid=fnd_global.user_id
1058: -- rid=fnd_global.resp_id
1059: -- aid=fnd_global.resp_appl_id
1060: -- gid=fnd_global.security_group_id
1061: -- xid=xts_id

Line 1058: -- rid=fnd_global.resp_id

1054: -- sid=p_scn_id
1055: -- nlsl=
1056: -- nlst=
1057: -- uid=fnd_global.user_id
1058: -- rid=fnd_global.resp_id
1059: -- aid=fnd_global.resp_appl_id
1060: -- gid=fnd_global.security_group_id
1061: -- xid=xts_id
1062: --

Line 1059: -- aid=fnd_global.resp_appl_id

1055: -- nlsl=
1056: -- nlst=
1057: -- uid=fnd_global.user_id
1058: -- rid=fnd_global.resp_id
1059: -- aid=fnd_global.resp_appl_id
1060: -- gid=fnd_global.security_group_id
1061: -- xid=xts_id
1062: --
1063:

Line 1060: -- gid=fnd_global.security_group_id

1056: -- nlst=
1057: -- uid=fnd_global.user_id
1058: -- rid=fnd_global.resp_id
1059: -- aid=fnd_global.resp_appl_id
1060: -- gid=fnd_global.security_group_id
1061: -- xid=xts_id
1062: --
1063:
1064: function report_url(

Line 1102: l_url := l_url||'&'||'uid='||to_char(fnd_global.user_id)

1098: from NLS_SESSION_PARAMETERS
1099: where PARAMETER='NLS_TERRITORY';
1100: l_url := l_url||l_value;
1101: --
1102: l_url := l_url||'&'||'uid='||to_char(fnd_global.user_id)
1103: ||'&'||'rid='||to_char(fnd_global.resp_id)
1104: ||'&'||'aid='||to_char(fnd_global.resp_appl_id)
1105: ||'&'||'gid='||to_char(fnd_global.security_group_id)
1106: ||'&'||'key='||substr(to_char(okc_p_util.raw_to_number(sys_guid())),-10)

Line 1103: ||'&'||'rid='||to_char(fnd_global.resp_id)

1099: where PARAMETER='NLS_TERRITORY';
1100: l_url := l_url||l_value;
1101: --
1102: l_url := l_url||'&'||'uid='||to_char(fnd_global.user_id)
1103: ||'&'||'rid='||to_char(fnd_global.resp_id)
1104: ||'&'||'aid='||to_char(fnd_global.resp_appl_id)
1105: ||'&'||'gid='||to_char(fnd_global.security_group_id)
1106: ||'&'||'key='||substr(to_char(okc_p_util.raw_to_number(sys_guid())),-10)
1107: ;

Line 1104: ||'&'||'aid='||to_char(fnd_global.resp_appl_id)

1100: l_url := l_url||l_value;
1101: --
1102: l_url := l_url||'&'||'uid='||to_char(fnd_global.user_id)
1103: ||'&'||'rid='||to_char(fnd_global.resp_id)
1104: ||'&'||'aid='||to_char(fnd_global.resp_appl_id)
1105: ||'&'||'gid='||to_char(fnd_global.security_group_id)
1106: ||'&'||'key='||substr(to_char(okc_p_util.raw_to_number(sys_guid())),-10)
1107: ;
1108: return l_url;

Line 1105: ||'&'||'gid='||to_char(fnd_global.security_group_id)

1101: --
1102: l_url := l_url||'&'||'uid='||to_char(fnd_global.user_id)
1103: ||'&'||'rid='||to_char(fnd_global.resp_id)
1104: ||'&'||'aid='||to_char(fnd_global.resp_appl_id)
1105: ||'&'||'gid='||to_char(fnd_global.security_group_id)
1106: ||'&'||'key='||substr(to_char(okc_p_util.raw_to_number(sys_guid())),-10)
1107: ;
1108: return l_url;
1109: end report_url;

Line 1333: set last_updated_by = fnd_global.user_id,

1329: if l_dummy = '?' then
1330: raise NO_DATA_FOUND;
1331: end if;
1332: update OKC_K_HEADERS_TL
1333: set last_updated_by = fnd_global.user_id,
1334: last_update_date = sysdate+1/144
1335: where ID = p_chr_id
1336: and LANGUAGE = userenv('LANG');
1337: x_url := report_url(p_chr_id,l_major_version, l_scn_id);

Line 1372: and last_updated_by = fnd_global.user_id

1368: select '!'
1369: from OKC_K_HEADERS_TL
1370: where ID = p_chr_id
1371: and LANGUAGE = userenv('LANG')
1372: and last_updated_by = fnd_global.user_id
1373: and last_update_date > sysdate
1374: for update of last_update_date
1375: nowait;
1376: l_dummy varchar2(1) := '?';

Line 1773: l_user_id number := fnd_global.user_id;

1769: -- PURPOSE
1770: -- for internal use only
1771: --
1772: function get_new_id(p_entity varchar2) return number is
1773: l_user_id number := fnd_global.user_id;
1774: l_n number;
1775: begin
1776: if (l_user_id <> 1) then
1777: return okc_p_util.raw_to_number(sys_guid());

Line 2037: return replace(fnd_message.get,'<',fnd_global.local_chr(38)||'lt;');

2033: function get_zero_mess return varchar2 is
2034: begin
2035: fnd_message.clear;
2036: fnd_message.set_name(APPLICATION=>'CN',NAME=>'CN_NO_RECS_FOUND');
2037: return replace(fnd_message.get,'<',fnd_global.local_chr(38)||'lt;');
2038: end;
2039:
2040: function get_much_mess return varchar2 is
2041: begin

Line 2044: return replace(fnd_message.get,'<',fnd_global.local_chr(38)||'lt;');

2040: function get_much_mess return varchar2 is
2041: begin
2042: fnd_message.clear;
2043: fnd_message.set_name(APPLICATION=>'PER',NAME=>'HR_WEB_RETRIEVE_LIMIT_EXCEEDED');
2044: return replace(fnd_message.get,'<',fnd_global.local_chr(38)||'lt;');
2045: end;
2046:
2047: procedure get_labels(
2048: x_title out nocopy varchar2,

Line 2055: select replace(prompt,'<',fnd_global.local_chr(38)||'lt;'), lov_query

2051: x_name out nocopy varchar2,
2052: x_description out nocopy varchar2,
2053: x_sql out nocopy varchar2) is
2054: cursor c1 is
2055: select replace(prompt,'<',fnd_global.local_chr(38)||'lt;'), lov_query
2056: from okc_report_prm_v PRM, okc_report_xst_v XST
2057: where PRM.sql_id = XST.sql_id
2058: and XST.id = fnd_profile.value('OKC_WEB_REPORT')
2059: and PRM.code = OKC_PARAMETERS_PUB.get('__param_code');

Line 2061: select replace(MEANING,'<',fnd_global.local_chr(38)||'lt;') from fnd_lookups

2057: where PRM.sql_id = XST.sql_id
2058: and XST.id = fnd_profile.value('OKC_WEB_REPORT')
2059: and PRM.code = OKC_PARAMETERS_PUB.get('__param_code');
2060: cursor c2 is
2061: select replace(MEANING,'<',fnd_global.local_chr(38)||'lt;') from fnd_lookups
2062: where LOOKUP_TYPE='OKS_ITEM_DISPLAY_PREFERENCE'
2063: and lookup_code='DISPLAY_NAME';
2064: cursor c3 is
2065: select replace(MEANING,'<',fnd_global.local_chr(38)||'lt;') from fnd_lookups

Line 2065: select replace(MEANING,'<',fnd_global.local_chr(38)||'lt;') from fnd_lookups

2061: select replace(MEANING,'<',fnd_global.local_chr(38)||'lt;') from fnd_lookups
2062: where LOOKUP_TYPE='OKS_ITEM_DISPLAY_PREFERENCE'
2063: and lookup_code='DISPLAY_NAME';
2064: cursor c3 is
2065: select replace(MEANING,'<',fnd_global.local_chr(38)||'lt;') from fnd_lookups
2066: where LOOKUP_TYPE='OKS_ITEM_DISPLAY_PREFERENCE'
2067: and lookup_code='DISPLAY_DESC';
2068: cursor c4 is
2069: select replace(description,'<',fnd_global.local_chr(38)||'lt;') from fnd_lookups

Line 2069: select replace(description,'<',fnd_global.local_chr(38)||'lt;') from fnd_lookups

2065: select replace(MEANING,'<',fnd_global.local_chr(38)||'lt;') from fnd_lookups
2066: where LOOKUP_TYPE='OKS_ITEM_DISPLAY_PREFERENCE'
2067: and lookup_code='DISPLAY_DESC';
2068: cursor c4 is
2069: select replace(description,'<',fnd_global.local_chr(38)||'lt;') from fnd_lookups
2070: where LOOKUP_TYPE='FLEX_VALIDATION_EVENTS'
2071: and LOOKUP_CODE='Q';
2072:
2073: begin

Line 2102: x_run1 := replace(fnd_message.get,'<',fnd_global.local_chr(38)||'lt;');

2098: x_close out nocopy varchar2) is
2099: begin
2100: fnd_message.clear;
2101: fnd_message.set_name(APPLICATION=>'OKC',NAME=>'OKC_XML_RUN1');
2102: x_run1 := replace(fnd_message.get,'<',fnd_global.local_chr(38)||'lt;');
2103: fnd_message.clear;
2104: fnd_message.set_name(APPLICATION=>'OKC',NAME=>'OKC_XML_RUN2');
2105: x_run2 := replace(fnd_message.get,'<',fnd_global.local_chr(38)||'lt;');
2106: fnd_message.clear;

Line 2105: x_run2 := replace(fnd_message.get,'<',fnd_global.local_chr(38)||'lt;');

2101: fnd_message.set_name(APPLICATION=>'OKC',NAME=>'OKC_XML_RUN1');
2102: x_run1 := replace(fnd_message.get,'<',fnd_global.local_chr(38)||'lt;');
2103: fnd_message.clear;
2104: fnd_message.set_name(APPLICATION=>'OKC',NAME=>'OKC_XML_RUN2');
2105: x_run2 := replace(fnd_message.get,'<',fnd_global.local_chr(38)||'lt;');
2106: fnd_message.clear;
2107: fnd_message.set_name(APPLICATION=>'OKC',NAME=>'OKC_XML_CLOSE');
2108: x_close := replace(fnd_message.get,'<',fnd_global.local_chr(38)||'lt;');
2109: end;

Line 2108: x_close := replace(fnd_message.get,'<',fnd_global.local_chr(38)||'lt;');

2104: fnd_message.set_name(APPLICATION=>'OKC',NAME=>'OKC_XML_RUN2');
2105: x_run2 := replace(fnd_message.get,'<',fnd_global.local_chr(38)||'lt;');
2106: fnd_message.clear;
2107: fnd_message.set_name(APPLICATION=>'OKC',NAME=>'OKC_XML_CLOSE');
2108: x_close := replace(fnd_message.get,'<',fnd_global.local_chr(38)||'lt;');
2109: end;
2110:
2111: procedure document_link(
2112: p_kid in NUMBER,

Line 2220: if ((p_recipient is NULL) or (p_recipient = fnd_global.local_chr(0))) then

2216: x_msg_count NUMBER;
2217: x_msg_data VARCHAR2(2000);
2218:
2219: begin
2220: if ((p_recipient is NULL) or (p_recipient = fnd_global.local_chr(0))) then
2221: return;
2222: end if;
2223: OKC_ASYNC_PUB.send_doc(
2224: p_api_version => 1,

Line 2338: if ((p_recipient is NULL) or (p_recipient = fnd_global.local_chr(0))) then

2334:
2335: begin
2336: errbuf := '';
2337: retcode := '0';
2338: if ((p_recipient is NULL) or (p_recipient = fnd_global.local_chr(0))) then
2339: return;
2340: end if;
2341: open c1(p_chr_id);
2342: fetch c1 into l_n,l_m;

Line 2373: if ((p_cc is NULL) or (p_cc = fnd_global.local_chr(0))) then

2369: p_recipient => p_recipient,
2370: p_msg_subj => l_s,
2371: p_msg_body => l_b,
2372: p_contract_id => p_chr_id);
2373: if ((p_cc is NULL) or (p_cc = fnd_global.local_chr(0))) then
2374: return;
2375: end if;
2376: OKC_ASYNC_PUB.msg_call(
2377: p_api_version => 1,