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.12020000.2 2012/07/16 16:14:41 harchand ship $ */
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:
571: /*Bugfix for 13079117*/
572: l_conc_req_id NUMBER;

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

707: funcmode in varchar2,
708: resultout out nocopy varchar2 ) is
709: P_VERSION varchar2(6) := '1';
710: --
711: l_proc varchar2(72) := ' OKC_ASYNC_PVT.'||'get_version';
712: --
713:
714: begin
715:

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

810: P_PROC varchar2(8000);
811: P_SUBJ_FIRST_MSG varchar2(1);
812: P_VERSION number;
813: --
814: l_proc varchar2(72) := ' OKC_ASYNC_PVT.'||'proc_call';
815: --
816: begin
817:
818: IF (l_debug = 'Y') THEN

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

900: fnd_buf varchar2(2000);
901: nl varchar2(4);
902: text_limit number := 32000;
903: --
904: l_proc varchar2(72) := ' OKC_ASYNC_PVT.'||'load_mess';
905: --
906: --NPALEPU
907: --14-DEC-2005
908: --for bug # 4699009

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

1086: where usr.user_name = p_recipient;
1087:
1088: --
1089: --
1090: l_proc varchar2(72) := ' OKC_ASYNC_PVT.'||'fun_generic';
1091: --
1092: begin
1093:
1094: IF (l_debug = 'Y') THEN

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

1326: funcmode in varchar2,
1327: resultout out nocopy varchar2) is
1328: x_return_status varchar2(1);
1329: --
1330: l_proc varchar2(72) := ' OKC_ASYNC_PVT.'||'accept';
1331: --
1332: begin
1333:
1334: IF (l_debug = 'Y') THEN

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

1413: funcmode in varchar2,
1414: resultout out nocopy varchar2) is
1415: x_return_status varchar2(1);
1416: --
1417: l_proc varchar2(72) := ' OKC_ASYNC_PVT.'||'reject';
1418: --
1419:
1420: begin
1421:

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

1501: funcmode in varchar2,
1502: resultout out nocopy varchar2) is
1503: x_return_status varchar2(1);
1504: --
1505: l_proc varchar2(72) := ' OKC_ASYNC_PVT.'||'timeout';
1506: --
1507: begin
1508:
1509: IF (l_debug = 'Y') THEN

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

1617: l_api_name CONSTANT VARCHAR2(30) := 'RESOLVER_CALL';
1618: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1619: l_key varchar2(100);
1620: --
1621: l_proc varchar2(72) := ' OKC_ASYNC_PVT.'||'resolver_call';
1622: --
1623:
1624: BEGIN
1625:

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

1783: resultout out nocopy varchar2 ) is
1784: P_PERIOD_DAYS number;
1785: P_STOP_DATE date;
1786: --
1787: l_proc varchar2(72) := ' OKC_ASYNC_PVT.'||'periodic';
1788: --
1789:
1790: begin
1791:

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

1872: actid in number,
1873: funcmode in varchar2,
1874: resultout out nocopy varchar2 ) is
1875: --
1876: l_proc varchar2(72) := ' OKC_ASYNC_PVT.'||'time_over';
1877: --
1878: begin
1879:
1880: IF (l_debug = 'Y') THEN

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

1952: display_type in varchar2,
1953: document in out nocopy CLOB,
1954: document_type in out nocopy varchar2) is
1955: --
1956: l_proc varchar2(72) := ' OKC_ASYNC_PVT.'||'get_doc';
1957: --
1958: begin
1959:
1960: IF (l_debug = 'Y') THEN

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

2031: from WF_ITEM_ATTRIBUTES
2032: where ITEM_TYPE = G_WF_NAME
2033: and NAME = 'P_TIMEOUT_MINUTES';
2034: --
2035: l_proc varchar2(72) := ' OKC_ASYNC_PVT.'||'loop_call';
2036: --
2037: l_timeout_minutes NUMBER := p_timeout_minutes;
2038: l_wf_timeout_minutes NUMBER;
2039: --

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

2274: actid in number,
2275: funcmode in varchar2,
2276: resultout out nocopy varchar2 ) is
2277: --
2278: l_proc varchar2(72) := ' OKC_ASYNC_PVT.'||'No_Email';
2279: --
2280: begin
2281:
2282: IF (l_debug = 'Y') THEN

Line 2317: wf_core.context('OKC_ASYNC_PVT',

2313: --
2314:
2315: exception
2316: when others then
2317: wf_core.context('OKC_ASYNC_PVT',
2318: 'NO_EMAIL',
2319: itemtype,
2320: itemkey,
2321: to_char(actid),

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

2339: where user_name=p_name;
2340: l_user_id number;
2341: l_p_value varchar2(3);
2342: --
2343: l_proc varchar2(72) := ' OKC_ASYNC_PVT.'||'success_mute';
2344: --
2345: begin
2346:
2347: IF (l_debug = 'Y') THEN

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

2440: where user_name=p_name;
2441: l_user_id number;
2442: l_p_value varchar2(3);
2443: --
2444: l_proc varchar2(72) := ' OKC_ASYNC_PVT.'||'error_mute';
2445: --
2446: begin
2447:
2448: IF (l_debug = 'Y') THEN

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

2547:
2548: l_user_id number;
2549: l_p_value varchar2(3);
2550: --
2551: l_proc varchar2(72) := ' OKC_ASYNC_PVT.'||'fyi_mute';
2552: --
2553:
2554: begin
2555:

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

2657:
2658: l_user_id number;
2659: l_p_value varchar2(3);
2660: --
2661: l_proc varchar2(72) := ' OKC_ASYNC_PVT.'||'mute_nxt_pfmr';
2662: --
2663:
2664: begin
2665:

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

2767:
2768: l_user_id number;
2769: l_p_value varchar2(3);
2770: --
2771: l_proc varchar2(72) := ' OKC_ASYNC_PVT.'||'mute_k_admin';
2772: --
2773:
2774: begin
2775:

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

2877:
2878: l_user_id number;
2879: l_p_value varchar2(3);
2880: --
2881: l_proc varchar2(72) := ' OKC_ASYNC_PVT.'||'mute_signer';
2882: --
2883:
2884: begin
2885:

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

2977: funcmode in varchar2,
2978: resultout out nocopy varchar2 ) is
2979:
2980: --
2981: l_proc varchar2(72) := ' OKC_ASYNC_PVT.'||'unmute';
2982: --
2983:
2984: begin
2985:

Line 3054: end OKC_ASYNC_PVT;

3050:
3051: begin
3052: G_WF_NAME := 'OKCALERT';
3053: G_PROCESS_NAME := 'ALERT_PROCESS';
3054: end OKC_ASYNC_PVT;