1 PACKAGE MSC_WS_SNO AS
2 /* $Header: MSCWSNOS.pls 120.5.12010000.1 2008/05/02 19:09:19 appldev ship $ */
3
4 -- =============================================================
5 -- Desc: This procedure is invoke from web services to extract SNO
6 -- plan model. It mirrors all the parameters from the Launch
7 -- SNO Plan concurrent program.
8 -- Input:
9 -- solveOnServer can be conditionally be Y or N
10 -- Output: possible output status value include following
11 -- INVALID_PLANID, INVALID_FND_USERID
12 -- =============================================================
13
14 PROCEDURE GENERATE_SNO_MODEL (
15 processId OUT NOCOPY NUMBER,
16 status OUT NOCOPY VARCHAR2,
17 userId IN NUMBER,
18 respId IN NUMBER,
19 planId IN NUMBER,
20 solveOnServer IN VARCHAR2
21 ) ;
22
23
24 PROCEDURE GENERATE_SNO_MODEL_PUBLIC (
25 processId OUT NOCOPY NUMBER,
26 status OUT NOCOPY VARCHAR2,
27 UserName IN VARCHAR2,
28 RespName IN VARCHAR2,
29 RespApplName IN VARCHAR2,
30 SecurityGroupName IN VARCHAR2,
31 Language IN VARCHAR2,
32 planId IN NUMBER,
33 solveOnServer IN VARCHAR2
34 ) ;
35
36 -- =============================================================
37 -- Desc: This procedure is invoke from web services to publish SNO
38 -- plan. It mirrors all the parameters from the Publish
39 -- SNO Plan concurrent program.
40 -- Input:
41 -- solveOnServer can be conditionally be Y or N
42 -- Output: possible output status value include following
43 -- INVALID_PLANID, INVALID_FND_USERID
44 -- =============================================================
45
46 PROCEDURE PUBLISH_SNO_PLAN (
47 processId OUT NOCOPY NUMBER,
48 status OUT NOCOPY VARCHAR2,
49 userId IN NUMBER,
50 respId IN NUMBER,
51 planId IN NUMBER,
52 appProfile IN VARCHAR2
53 ) ;
54
55 PROCEDURE PUBLISH_SNO_PLAN_PUBLIC (
56 processId OUT NOCOPY NUMBER,
57 status OUT NOCOPY VARCHAR2,
58 UserName IN VARCHAR2,
59 RespName IN VARCHAR2,
60 RespApplName IN VARCHAR2,
61 SecurityGroupName IN VARCHAR2,
62 Language IN VARCHAR2,
63 planId IN NUMBER,
64 appProfile IN VARCHAR2
65 ) ;
66 END MSC_WS_SNO;