1 package FND_CONC_PP as
2 /* $Header: AFCPPPIS.pls 120.2 2005/08/22 06:53:57 aweisber ship $ */
3
4
5
6 -- Function
7 -- MESSAGE
8 --
9 -- Purpose
10 -- Return an error message. Messages are set when
11 -- validation (program) errors occur.
12 --
13 FUNCTION message RETURN VARCHAR2;
14
15 --
16 -- Procedure
17 -- Assign
18 --
19 -- Purpose
20 -- Assign a stored procedure to a request. Returns step number if successful,-- a negative number if not.
21 --
22 -- Arguments:
23 -- Application - Application Short Name
24 --
25 -- Executable_Name - Executable Name
26 --
27 -- Req_ID - request ID
28 --
29 -- S_Flag - do we execute if request was successful? ['Y'/'N']
30 --
31 -- W_Flag - do we execute if request completed with status warning?
32 -- ['Y'/'N']
33 --
34 -- F_Flag - do we execute if request failed? ['Y'/'N']
35 --
36 -- Arg1 -> Arg10 - Arguments that may be retrieved during execution.
37 --
38 FUNCTION Assign( Application IN Varchar2,
39 Executable_Name IN Varchar2,
40 Req_ID IN Number,
41 S_Flag IN Varchar2,
42 W_Flag IN Varchar2,
43 F_Flag IN Varchar2,
44 Arg1 IN Varchar2,
45 Arg2 IN Varchar2,
46 Arg3 IN Varchar2,
47 Arg4 IN Varchar2,
48 Arg5 IN Varchar2,
49 Arg6 IN Varchar2,
50 Arg7 IN Varchar2,
51 Arg8 IN Varchar2,
52 Arg9 IN Varchar2,
53 Arg10 IN Varchar2) return number;
54
55 --
56 -- Procedure
57 -- Retrieve
58 --
59 -- Purpose
60 -- Assign a stored procedure to a request. Returns step number if successful,-- a negative number if not.
61 --
62 -- Arguments:
63 -- Req_ID - request ID
64 --
65 -- Step Number - Step Number
66 --
67 -- Arg1 -> Arg10 - Arguments that were set at assignment.
68 --
69 FUNCTION Retrieve(Req_ID IN Number,
70 Step IN Number,
71 App_short_name OUT NOCOPY Varchar2,
72 exec_name OUT NOCOPY VARCHAR2,
73 S_Flag OUT NOCOPY Varchar2,
74 W_Flag OUT NOCOPY Varchar2,
75 F_Flag OUT NOCOPY Varchar2,
76 Arg1 OUT NOCOPY Varchar2,
77 Arg2 OUT NOCOPY Varchar2,
78 Arg3 OUT NOCOPY Varchar2,
79 Arg4 OUT NOCOPY Varchar2,
80 Arg5 OUT NOCOPY Varchar2,
81 Arg6 OUT NOCOPY Varchar2,
82 Arg7 OUT NOCOPY Varchar2,
83 Arg8 OUT NOCOPY Varchar2,
84 Arg9 OUT NOCOPY Varchar2,
85 Arg10 OUT NOCOPY Varchar2) return number;
86
87 end FND_CONC_PP;