1 PACKAGE MSC_WS_PLAN_MANAGEMENT AS
2 /* $Header: MSCWPMAS.pls 120.1 2008/02/25 19:16:44 mtsui noship $ */
3
4 -- =============================================================
5 -- Desc: This procedure is invoked from web service to launch
6 -- the Copy Plan concurrent program. The input parameters
7 -- mirror the parameters for the concurrent program.
8 -- Input:
9 -- UserName User name.
10 -- RespName Responsibility name.
11 -- RespAppName Responsibility application name.
12 -- SecurityGroupName Security group name.
13 -- Language Language.
14 -- SrcPlanId Source Plan Id.
15 -- DestPlanName Destination Plan Name.
16 -- DestPlanDesc Destination Plan Description.
17 -- DestATP Destination ATP. Allowed input is Y or N
18 -- DestProd Destination Production. Allowed input is Y or N
19 -- DestNoti Destination Notification. Allowed input is Y or N
20 -- DestInacOn Destination Inactive On. Allowed input is Y or N
21 -- CopyOptionsOnly Copy Plan Options Only. Allowed input is Y or N
22 -- if 'Y', copy plan options only
23 -- else copy the entire plan
24 --
25 -- Output: Procedure returns a status and conc program req id.
26 -- The possible return statuses are:
27 -- SUCCESS if everything is ok
28 -- ERROR_SUBMIT failed to submit the concurrent program
29 -- ERROR_UNEXPECTED_# unexpected error
30 -- INVALID_USER_NAME
31 -- INVALID_LANGUAGE
32 -- INVALID_RESP_NAME
33 -- INVALID_SECUTITY_GROUP_NAME
34 -- INVALID_FND_USERID
35 -- INVALID_FND_RESPONSIBILITYID
36 -- INVALID_SRCPLNID invalid source plan id
37 -- INVALID_DESTPLNNAME duplicated destination plan name
38 -- =============================================================
39 PROCEDURE COPY_PLAN(
40 ProcessId OUT NOCOPY NUMBER,
41 Status OUT NOCOPY VARCHAR2,
42 UserName IN VARCHAR2,
43 RespName IN VARCHAR2,
44 RespAppName IN VARCHAR2,
45 SecurityGroupName IN VARCHAR2,
46 Language IN VARCHAR2,
47 SrcPlanId IN NUMBER,
48 DestPlanName IN VARCHAR2,
49 DestPlanDesc IN VARCHAR2 default NULL,
50 -- Destination Org Selection
51 DestATP IN VARCHAR2,
52 DestProd IN VARCHAR2,
53 DestNoti IN VARCHAR2,
54 DestInacOn IN DATE default NULL,
55 -- Organization ID
56 -- Instance ID
57 CopyOptionsOnly IN VARCHAR2
58 );
59
60
61 -- =============================================================
62 -- Desc: This procedure is invoked from web service to launch
63 -- the Purge Plan concurrent program. The input parameters
64 -- mirror the parameters for the concurrent program.
65 -- Input:
66 -- UserName User name.
67 -- RespName Responsibility name.
68 -- RespAppName Responsibility application name.
69 -- SecurityGroupName Security group name.
70 -- Language Language.
71 -- DesignatorId Designator Id.
72 --
73 -- Output: Procedure returns a status and conc program req id.
74 -- The possible return statuses are:
75 -- SUCCESS if everything is ok
76 -- ERROR_SUBMIT failed to submit the concurrent program
77 -- ERROR_UNEXPECTED_# unexpected error
78 -- INVALID_USER_NAME
79 -- INVALID_LANGUAGE
80 -- INVALID_RESP_NAME
81 -- INVALID_SECUTITY_GROUP_NAME
82 -- INVALID_FND_USERID
83 -- INVALID_FND_RESPONSIBILITYID
84 -- INVALID_FND_USERID
85 -- INVALID_FND_RESPONSIBILITYID
86 -- INVALID_DESIGNATORID invalid designator id
87 -- =============================================================
88 PROCEDURE PURGE_PLAN(
89 ProcessId OUT NOCOPY NUMBER,
90 Status OUT NOCOPY VARCHAR2,
91 UserName IN VARCHAR2,
92 RespName IN VARCHAR2,
93 RespAppName IN VARCHAR2,
94 SecurityGroupName IN VARCHAR2,
95 Language IN VARCHAR2,
96 DesignatorId IN NUMBER
97 );
98
99
100 -- =============================================================
101 -- Desc: This procedure is invoked from web service to launch
102 -- the Archive Plan Summary concurrent program. The input
103 -- parameters mirror the parameters for the concurrent program.
104 -- Input:
105 -- UserName User name.
106 -- RespName Responsibility name.
107 -- RespAppName Responsibility application name.
108 -- SecurityGroupName Security group name.
109 -- Language Language.
110 -- PlanId Plan Id.
111 --
112 -- Output: Procedure returns a status and conc program req id.
113 -- The possible return statuses are:
114 -- SUCCESS if everything is ok
115 -- ERROR_SUBMIT failed to submit the concurrent program
116 -- ERROR_UNEXPECTED_# unexpected error
117 -- INVALID_USER_NAME
118 -- INVALID_LANGUAGE
119 -- INVALID_RESP_NAME
120 -- INVALID_SECUTITY_GROUP_NAME
121 -- INVALID_FND_USERID
122 -- INVALID_FND_RESPONSIBILITYID
123 -- INVALID_PLAN_ID invalid plan id
124 -- =============================================================
125 PROCEDURE ARCHIVE_PLAN(
126 ProcessId OUT NOCOPY NUMBER,
127 Status OUT NOCOPY VARCHAR2,
128 UserName IN VARCHAR2,
129 RespName IN VARCHAR2,
130 RespAppName IN VARCHAR2,
131 SecurityGroupName IN VARCHAR2,
132 Language IN VARCHAR2,
133 PlanId IN NUMBER
134 );
135
136 END MSC_WS_PLAN_MANAGEMENT;
137