1 package FNDCP_CRM AUTHID CURRENT_USER as
2 /* $Header: AFCPCRMS.pls 115.5 2002/03/21 09:18:09 pkm ship $ */
3
4
5
6 --
7 -- Returns the number of mgr procs that can run the request
8 --
9
10 function mgr_up (reqid in number) return number;
11 pragma restrict_references (mgr_up, WNDS);
12
13
14 -- The following function is used by FND_REQUEST package in AFCPREQ*.pls
15 -- and src/process/fdprrc.lpc. This used to be in AFCPREQ*.pls, but due
16 -- to the infamous 64K limit, had to move out to here.
17
18 --
19 -- Get conflicts domain id.
20 --
21 -- Extract the value in parameter named by cd_param.
22 -- This value is a Conflicts Domain Name.
23 -- If the domain by this name exists, return its cd_id.
24 -- Else, insert a new domain by the name and return the new cd_id.
25 --
26 -- The routine is used at request submission time by programs that
27 -- have the Conflicts Domain name defined in a parameter.
28 --
29 function get_cd_id (app in varchar2,
30 program in varchar2,
31 user_id in number,
32 login_id in number,
33 cd_param in varchar2,
34 nargs in number,
35 a1 in varchar2 default chr(0),
36 a2 in varchar2 default chr(0),
37 a3 in varchar2 default chr(0),
38 a4 in varchar2 default chr(0),
39 a5 in varchar2 default chr(0),
40 a6 in varchar2 default chr(0),
41 a7 in varchar2 default chr(0),
42 a8 in varchar2 default chr(0),
43 a9 in varchar2 default chr(0),
44 a10 in varchar2 default chr(0),
45 a11 in varchar2 default chr(0),
46 a12 in varchar2 default chr(0),
47 a13 in varchar2 default chr(0),
48 a14 in varchar2 default chr(0),
49 a15 in varchar2 default chr(0),
50 a16 in varchar2 default chr(0),
51 a17 in varchar2 default chr(0),
52 a18 in varchar2 default chr(0),
53 a19 in varchar2 default chr(0),
54 a20 in varchar2 default chr(0),
55 a21 in varchar2 default chr(0),
56 a22 in varchar2 default chr(0),
57 a23 in varchar2 default chr(0),
58 a24 in varchar2 default chr(0),
59 a25 in varchar2 default chr(0),
60 a26 in varchar2 default chr(0),
61 a27 in varchar2 default chr(0),
62 a28 in varchar2 default chr(0),
63 a29 in varchar2 default chr(0),
64 a30 in varchar2 default chr(0),
65 a31 in varchar2 default chr(0),
66 a32 in varchar2 default chr(0),
67 a33 in varchar2 default chr(0),
68 a34 in varchar2 default chr(0),
69 a35 in varchar2 default chr(0),
70 a36 in varchar2 default chr(0),
71 a37 in varchar2 default chr(0),
72 a38 in varchar2 default chr(0),
73 a39 in varchar2 default chr(0),
74 a40 in varchar2 default chr(0),
75 a41 in varchar2 default chr(0),
76 a42 in varchar2 default chr(0),
77 a43 in varchar2 default chr(0),
78 a44 in varchar2 default chr(0),
79 a45 in varchar2 default chr(0),
80 a46 in varchar2 default chr(0),
81 a47 in varchar2 default chr(0),
82 a48 in varchar2 default chr(0),
83 a49 in varchar2 default chr(0),
84 a50 in varchar2 default chr(0),
85 a51 in varchar2 default chr(0),
86 a52 in varchar2 default chr(0),
87 a53 in varchar2 default chr(0),
88 a54 in varchar2 default chr(0),
89 a55 in varchar2 default chr(0),
90 a56 in varchar2 default chr(0),
91 a57 in varchar2 default chr(0),
92 a58 in varchar2 default chr(0),
93 a59 in varchar2 default chr(0),
94 a60 in varchar2 default chr(0),
95 a61 in varchar2 default chr(0),
96 a62 in varchar2 default chr(0),
97 a63 in varchar2 default chr(0),
98 a64 in varchar2 default chr(0),
99 a65 in varchar2 default chr(0),
100 a66 in varchar2 default chr(0),
101 a67 in varchar2 default chr(0),
102 a68 in varchar2 default chr(0),
103 a69 in varchar2 default chr(0),
104 a70 in varchar2 default chr(0),
105 a71 in varchar2 default chr(0),
106 a72 in varchar2 default chr(0),
107 a73 in varchar2 default chr(0),
108 a74 in varchar2 default chr(0),
109 a75 in varchar2 default chr(0),
110 a76 in varchar2 default chr(0),
111 a77 in varchar2 default chr(0),
112 a78 in varchar2 default chr(0),
113 a79 in varchar2 default chr(0),
114 a80 in varchar2 default chr(0),
115 a81 in varchar2 default chr(0),
116 a82 in varchar2 default chr(0),
117 a83 in varchar2 default chr(0),
118 a84 in varchar2 default chr(0),
119 a85 in varchar2 default chr(0),
120 a86 in varchar2 default chr(0),
121 a87 in varchar2 default chr(0),
122 a88 in varchar2 default chr(0),
123 a89 in varchar2 default chr(0),
124 a90 in varchar2 default chr(0),
125 a91 in varchar2 default chr(0),
126 a92 in varchar2 default chr(0),
127 a93 in varchar2 default chr(0),
128 a94 in varchar2 default chr(0),
129 a95 in varchar2 default chr(0),
130 a96 in varchar2 default chr(0),
131 a97 in varchar2 default chr(0),
132 a98 in varchar2 default chr(0),
133 a99 in varchar2 default chr(0),
134 a100 in varchar2 default chr(0))
135 return number;
136
137 --
138 -- Remove all unused 'dynamic' conflict domains
139 -- in order to manage the size of the table.
140 --
141 procedure purge_dynamic_domains;
142
143
144 end FNDCP_CRM;