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_ASYNC_PVT dependencies on OKC_ASYNC_PVT

Line 1: package body OKC_ASYNC_PVT as

1: package body OKC_ASYNC_PVT as
2: /* $Header: OKCRASNB.pls 120.3 2005/12/14 22:11:36 npalepu noship $ */
3:
4: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
5:

Line 8: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_ASYNC_PVT';

4: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
5:
6: G_MUTE_PROFILE CONSTANT VARCHAR2(30) := 'OKC_SUPPRESS_EMAILS';
7: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
8: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_ASYNC_PVT';
9: G_LEVEL CONSTANT VARCHAR2(4) := '_PVT';
10: l_api_version CONSTANT NUMBER := 1;
11:
12:

Line 38: l_proc varchar2(72) := ' OKC_ASYNC_PVT.'||'save_env';

34: where usr.user_name = p_recipient
35: and fndl.installed_flag = 'B';
36:
37: --
38: l_proc varchar2(72) := ' OKC_ASYNC_PVT.'||'save_env';
39: --
40:
41: begin
42:

Line 240: l_proc varchar2(72) := ' OKC_ASYNC_PVT.'||'wf_call';

236: i NUMBER;
237: j NUMBER;
238: P_VERSION NUMBER := 2;
239: --
240: l_proc varchar2(72) := ' OKC_ASYNC_PVT.'||'wf_call';
241: --
242:
243: BEGIN
244:

Line 482: l_proc varchar2(72) := ' OKC_ASYNC_PVT.'||'set_env';

478: from NLS_SESSION_PARAMETERS
479: where PARAMETER=p;
480: l_version number;
481: --
482: l_proc varchar2(72) := ' OKC_ASYNC_PVT.'||'set_env';
483: --
484: begin
485:
486: IF (l_debug = 'Y') THEN

Line 568: l_proc varchar2(72) := ' OKC_ASYNC_PVT.'||'Selector';

564: command in varchar2,
565: resultout out nocopy varchar2 ) is
566: -- local declarations
567: --
568: l_proc varchar2(72) := ' OKC_ASYNC_PVT.'||'Selector';
569: --
570: begin
571:
572: IF (l_debug = 'Y') THEN

Line 673: l_proc varchar2(72) := ' OKC_ASYNC_PVT.'||'get_version';

669: funcmode in varchar2,
670: resultout out nocopy varchar2 ) is
671: P_VERSION varchar2(6) := '1';
672: --
673: l_proc varchar2(72) := ' OKC_ASYNC_PVT.'||'get_version';
674: --
675:
676: begin
677:

Line 776: l_proc varchar2(72) := ' OKC_ASYNC_PVT.'||'proc_call';

772: P_PROC varchar2(8000);
773: P_SUBJ_FIRST_MSG varchar2(1);
774: P_VERSION number;
775: --
776: l_proc varchar2(72) := ' OKC_ASYNC_PVT.'||'proc_call';
777: --
778: begin
779:
780: IF (l_debug = 'Y') THEN

Line 866: l_proc varchar2(72) := ' OKC_ASYNC_PVT.'||'load_mess';

862: fnd_buf varchar2(2000);
863: nl varchar2(4);
864: text_limit number := 32000;
865: --
866: l_proc varchar2(72) := ' OKC_ASYNC_PVT.'||'load_mess';
867: --
868: --NPALEPU
869: --14-DEC-2005
870: --for bug # 4699009

Line 1052: l_proc varchar2(72) := ' OKC_ASYNC_PVT.'||'fun_generic';

1048: where usr.user_name = p_recipient;
1049:
1050: --
1051: --
1052: l_proc varchar2(72) := ' OKC_ASYNC_PVT.'||'fun_generic';
1053: --
1054: begin
1055:
1056: IF (l_debug = 'Y') THEN

Line 1292: l_proc varchar2(72) := ' OKC_ASYNC_PVT.'||'accept';

1288: funcmode in varchar2,
1289: resultout out nocopy varchar2) is
1290: x_return_status varchar2(1);
1291: --
1292: l_proc varchar2(72) := ' OKC_ASYNC_PVT.'||'accept';
1293: --
1294: begin
1295:
1296: IF (l_debug = 'Y') THEN

Line 1379: l_proc varchar2(72) := ' OKC_ASYNC_PVT.'||'reject';

1375: funcmode in varchar2,
1376: resultout out nocopy varchar2) is
1377: x_return_status varchar2(1);
1378: --
1379: l_proc varchar2(72) := ' OKC_ASYNC_PVT.'||'reject';
1380: --
1381:
1382: begin
1383:

Line 1467: l_proc varchar2(72) := ' OKC_ASYNC_PVT.'||'timeout';

1463: funcmode in varchar2,
1464: resultout out nocopy varchar2) is
1465: x_return_status varchar2(1);
1466: --
1467: l_proc varchar2(72) := ' OKC_ASYNC_PVT.'||'timeout';
1468: --
1469: begin
1470:
1471: IF (l_debug = 'Y') THEN

Line 1583: l_proc varchar2(72) := ' OKC_ASYNC_PVT.'||'resolver_call';

1579: l_api_name CONSTANT VARCHAR2(30) := 'RESOLVER_CALL';
1580: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1581: l_key varchar2(100);
1582: --
1583: l_proc varchar2(72) := ' OKC_ASYNC_PVT.'||'resolver_call';
1584: --
1585:
1586: BEGIN
1587:

Line 1749: l_proc varchar2(72) := ' OKC_ASYNC_PVT.'||'periodic';

1745: resultout out nocopy varchar2 ) is
1746: P_PERIOD_DAYS number;
1747: P_STOP_DATE date;
1748: --
1749: l_proc varchar2(72) := ' OKC_ASYNC_PVT.'||'periodic';
1750: --
1751:
1752: begin
1753:

Line 1838: l_proc varchar2(72) := ' OKC_ASYNC_PVT.'||'time_over';

1834: actid in number,
1835: funcmode in varchar2,
1836: resultout out nocopy varchar2 ) is
1837: --
1838: l_proc varchar2(72) := ' OKC_ASYNC_PVT.'||'time_over';
1839: --
1840: begin
1841:
1842: IF (l_debug = 'Y') THEN

Line 1918: l_proc varchar2(72) := ' OKC_ASYNC_PVT.'||'get_doc';

1914: display_type in varchar2,
1915: document in out nocopy CLOB,
1916: document_type in out nocopy varchar2) is
1917: --
1918: l_proc varchar2(72) := ' OKC_ASYNC_PVT.'||'get_doc';
1919: --
1920: begin
1921:
1922: IF (l_debug = 'Y') THEN

Line 1997: l_proc varchar2(72) := ' OKC_ASYNC_PVT.'||'loop_call';

1993: from WF_ITEM_ATTRIBUTES
1994: where ITEM_TYPE = G_WF_NAME
1995: and NAME = 'P_TIMEOUT_MINUTES';
1996: --
1997: l_proc varchar2(72) := ' OKC_ASYNC_PVT.'||'loop_call';
1998: --
1999: l_timeout_minutes NUMBER := p_timeout_minutes;
2000: l_wf_timeout_minutes NUMBER;
2001: --

Line 2240: l_proc varchar2(72) := ' OKC_ASYNC_PVT.'||'No_Email';

2236: actid in number,
2237: funcmode in varchar2,
2238: resultout out nocopy varchar2 ) is
2239: --
2240: l_proc varchar2(72) := ' OKC_ASYNC_PVT.'||'No_Email';
2241: --
2242: begin
2243:
2244: IF (l_debug = 'Y') THEN

Line 2279: wf_core.context('OKC_ASYNC_PVT',

2275: --
2276:
2277: exception
2278: when others then
2279: wf_core.context('OKC_ASYNC_PVT',
2280: 'NO_EMAIL',
2281: itemtype,
2282: itemkey,
2283: to_char(actid),

Line 2305: l_proc varchar2(72) := ' OKC_ASYNC_PVT.'||'success_mute';

2301: where user_name=p_name;
2302: l_user_id number;
2303: l_p_value varchar2(3);
2304: --
2305: l_proc varchar2(72) := ' OKC_ASYNC_PVT.'||'success_mute';
2306: --
2307: begin
2308:
2309: IF (l_debug = 'Y') THEN

Line 2406: l_proc varchar2(72) := ' OKC_ASYNC_PVT.'||'error_mute';

2402: where user_name=p_name;
2403: l_user_id number;
2404: l_p_value varchar2(3);
2405: --
2406: l_proc varchar2(72) := ' OKC_ASYNC_PVT.'||'error_mute';
2407: --
2408: begin
2409:
2410: IF (l_debug = 'Y') THEN

Line 2513: l_proc varchar2(72) := ' OKC_ASYNC_PVT.'||'fyi_mute';

2509:
2510: l_user_id number;
2511: l_p_value varchar2(3);
2512: --
2513: l_proc varchar2(72) := ' OKC_ASYNC_PVT.'||'fyi_mute';
2514: --
2515:
2516: begin
2517:

Line 2623: l_proc varchar2(72) := ' OKC_ASYNC_PVT.'||'mute_nxt_pfmr';

2619:
2620: l_user_id number;
2621: l_p_value varchar2(3);
2622: --
2623: l_proc varchar2(72) := ' OKC_ASYNC_PVT.'||'mute_nxt_pfmr';
2624: --
2625:
2626: begin
2627:

Line 2733: l_proc varchar2(72) := ' OKC_ASYNC_PVT.'||'mute_k_admin';

2729:
2730: l_user_id number;
2731: l_p_value varchar2(3);
2732: --
2733: l_proc varchar2(72) := ' OKC_ASYNC_PVT.'||'mute_k_admin';
2734: --
2735:
2736: begin
2737:

Line 2843: l_proc varchar2(72) := ' OKC_ASYNC_PVT.'||'mute_signer';

2839:
2840: l_user_id number;
2841: l_p_value varchar2(3);
2842: --
2843: l_proc varchar2(72) := ' OKC_ASYNC_PVT.'||'mute_signer';
2844: --
2845:
2846: begin
2847:

Line 2943: l_proc varchar2(72) := ' OKC_ASYNC_PVT.'||'unmute';

2939: funcmode in varchar2,
2940: resultout out nocopy varchar2 ) is
2941:
2942: --
2943: l_proc varchar2(72) := ' OKC_ASYNC_PVT.'||'unmute';
2944: --
2945:
2946: begin
2947:

Line 3016: end OKC_ASYNC_PVT;

3012:
3013: begin
3014: G_WF_NAME := 'OKCALERT';
3015: G_PROCESS_NAME := 'ALERT_PROCESS';
3016: end OKC_ASYNC_PVT;