[Home] [Help]
PACKAGE: APPS.FND_CONC_RAC_UTILS
Source
1 package FND_CONC_RAC_UTILS AUTHID CURRENT_USER as
2 /* $Header: AFCPRACS.pls 120.2 2008/01/11 17:38:14 pferguso noship $ */
3
4 --
5 -- Package
6 -- FND_CONC_RAC_UTILS
7 -- Purpose
8 -- Utilities for RAC
9 -- History
10
11 --
12 -- PUBLIC VARIABLES
13 --
14
15 -- Exceptions
16
17 -- Exception Pragmas
18
19 --
20 -- PUBLIC FUNCTIONS
21 --
22 -- Name
23 -- kill_session
24 -- Purpose
25 -- Called by DBMS_JOB
26 -- Kills a session given a session id (sid) and serial#
27 --
28 -- Parameters:
29 -- p_sid - ID of session to kill.
30 -- p_serial - Instance ID of session.
31 --
32 --
33 procedure kill_session (p_sid in number,
34 p_serial# in number) ;
35
36 --
37 -- Name
38 -- submit_kill_session
39 -- Purpose
40 -- Calls dbms_scheduler to submit a job to kill a session
41 -- in a specific instance
42 -- CAUTION: This procedure does a COMMIT
43 --
44 -- Parameters:
45 -- p_jobno - Job number of the dbms_job
46 -- p_message - Oracle error message, allow 4000 characters
47 -- p_sid - Session ID of session to kill
48 -- p_serial# - Serial# of session to kill
49 -- p_inst - Instance ID where dbms_job should run
50 --
51 -- Returns:
52 -- 0 - Oracle error, message available
53 -- 1 - Could not submit job in given instance, message available
54 -- 2 - Success
55 --
56 function submit_kill_session (
57 p_jobno in out NOCOPY number,
58 p_message in out NOCOPY varchar2,
59 p_sid in number,
60 p_serial# in number,
61 p_inst in number default 1) return number;
62
63 --
64 -- Name
65 -- submit_manager_kill_session
66 -- Purpose
67 -- Calls submit_kill_session given the concurrent_process_id of a manager
68 --
69 -- Parameters:
70 -- p_cpid - concurrent_process_id of manager to kill
71 -- p_jobno - job number of the dbms_job
72 -- p_message - message buffer for error, allow 4000 characters
73 --
74 -- Returns:
75 -- 0 - Oracle error. Check message
76 -- 1 - Session not found
77 -- 2 - Success
78 --
79 function submit_manager_kill_session (p_cpid in number,
80 p_jobno in out NOCOPY number,
81 p_message in out NOCOPY varchar2)
82 return number;
83
84 --
85 -- Name
86 -- submit_req_mgr_kill_session
87 -- Purpose
88 -- Calls submit_kill_session given the request_id of a concurrent request
89 --
90 -- Parameters:
91 -- p_reqid - request_id for which manager session must be killed
92 -- p_jobno - job number of the dbms_job
93 -- p_message - message buffer for error, allow 4000 characters
94 --
95 -- Returns:
96 -- 0 - Oracle error. Check message
97 -- 1 - Request/Session not found
98 -- 2 - Success
99 --
100 function submit_req_mgr_kill_session (p_reqid in number,
101 p_jobno in out NOCOPY number,
102 p_message in out NOCOPY varchar2)
103 return number;
104
105
106
107 --
108 -- Name
109 -- submit_req_kill_session
110 -- Purpose
111 -- Calls submit_kill_session given the request_id of a concurrent request
112 --
113 -- Parameters:
114 -- p_reqid - request_id for which session must be killed
115 -- p_jobno - job number of the dbms_job
116 -- p_message - message buffer for error, allow 4000 characters
117 --
118 -- Returns:
119 -- 0 - Oracle error. Check message
120 -- 1 - Request/Session not found
121 -- 2 - Success
122 --
126 return number;
123 function submit_req_kill_session (p_reqid in number,
124 p_jobno in out NOCOPY number,
125 p_message in out NOCOPY varchar2)
127
128 end FND_CONC_RAC_UTILS;