DBA Data[Home] [Help]

PACKAGE: APPS.ZPB_DC_OBJECTS_PVT

Source


1 PACKAGE ZPB_DC_OBJECTS_PVT AS
2 /* $Header: ZPBDCGTS.pls 120.0.12010.4 2006/08/03 11:56:06 appldev noship $ */
3 
4 
5 
6 PROCEDURE Generate_Template_CP(
7   errbuf                OUT     NOCOPY      VARCHAR2,
8   retcode               OUT     NOCOPY      VARCHAR2,
9   --
10   p_task_id             IN      NUMBER,
11   p_ac_id               IN      NUMBER,
12   p_instance_id         IN      NUMBER);
13 
14 PROCEDURE Generate_Template(
15   p_api_version         IN      NUMBER,
16   p_init_msg_list       IN      VARCHAR2,
17   p_commit              IN      VARCHAR2,
18   p_validation_level    IN      NUMBER,
19   x_return_status       OUT     NOCOPY     VARCHAR2,
20   x_msg_count           OUT     NOCOPY     NUMBER,
21   x_msg_data            OUT     NOCOPY     VARCHAR2,
22   --
23   p_task_id           	IN      NUMBER,
24   p_ac_id               IN      NUMBER,
25   p_instance_id         IN      NUMBER);
26 
27 PROCEDURE Auto_Distribute_CP(
28   errbuf                OUT     NOCOPY      VARCHAR2,
29   retcode               OUT     NOCOPY      VARCHAR2,
30   --
31   p_task_id             IN      NUMBER,
32   p_template_id         IN      NUMBER);
33 
34 
35 PROCEDURE Auto_Distribute(
36   p_api_version         IN      NUMBER,
37   p_init_msg_list       IN      VARCHAR2,
38   p_commit              IN      VARCHAR2,
39   p_validation_level    IN      NUMBER,
40   x_return_status       OUT     NOCOPY     VARCHAR2,
41   x_msg_count           OUT     NOCOPY     NUMBER,
42   x_msg_data            OUT     NOCOPY     VARCHAR2,
43   --
44   p_task_id             IN      NUMBER,
45   p_template_id       	IN      NUMBER);
46 
47 
48 PROCEDURE Manual_Distribute_CP(
49   errbuf                OUT     NOCOPY      VARCHAR2,
50   retcode               OUT     NOCOPY      VARCHAR2,
51   --
52   p_object_id       IN number,
53   p_recipient_type  IN varchar2,
54   p_dist_list_id    IN number,
55   p_approver_type   IN varchar2,
56   p_deadline_date   IN varchar2,
57   p_overwrite_cust  IN varchar2,
58   p_overwrite_data  IN varchar2);
59 
60 PROCEDURE Manual_Distribute(
61   p_api_version         IN      NUMBER,
62   p_init_msg_list       IN      VARCHAR2,
63   p_commit              IN      VARCHAR2,
64   p_validation_level    IN      NUMBER,
65   x_return_status       OUT     NOCOPY     VARCHAR2,
66   x_msg_count           OUT     NOCOPY     NUMBER,
67   x_msg_data            OUT     NOCOPY     VARCHAR2,
68   --
69   p_object_id       IN number,
70   p_recipient_type  IN varchar2,
71   p_dist_list_id    IN number,
72   p_approver_type   IN varchar2,
73   p_deadline_date   IN date,
74   p_overwrite_cust  IN varchar2,
75   p_overwrite_data  IN varchar2);
76 
77 PROCEDURE Set_Template_Recipient(
78   p_api_version         IN    NUMBER,
79   p_init_msg_list       IN    VARCHAR2,
80   p_commit              IN    VARCHAR2,
81   p_validation_level    IN    NUMBER,
82   x_return_status       OUT   NOCOPY VARCHAR2,
83   x_msg_count           OUT   NOCOPY NUMBER,
84   x_msg_data            OUT   NOCOPY VARCHAR2,
85   --
86   p_template_id         IN    NUMBER,
87   x_role_name           OUT   NOCOPY VARCHAR2);
88 
89 
90 PROCEDURE Set_Ws_Recipient(
91   p_api_version         IN    NUMBER,
92   p_init_msg_list       IN    VARCHAR2,
93   p_commit              IN    VARCHAR2,
94   p_validation_level    IN    NUMBER,
95   x_return_status       OUT   NOCOPY VARCHAR2,
96   x_msg_count           OUT   NOCOPY NUMBER,
97   x_msg_data            OUT   NOCOPY VARCHAR2,
98   --
99   p_task_id             IN      NUMBER,
100   p_template_id         IN      NUMBER,
101   p_dist_list_id        IN      NUMBER,
102   p_object_id           IN      NUMBER,
103   p_recipient_type      IN      VARCHAR2,
104   x_role_name           OUT     NOCOPY VARCHAR2,
105   x_resultout             OUT     nocopy varchar2  );
106 
107 
108 PROCEDURE Complete_Review(
109   p_api_version         IN      NUMBER,
110   p_init_msg_list       IN      VARCHAR2,
111   p_commit              IN      VARCHAR2,
112   p_validation_level    IN      NUMBER,
113   x_return_status       OUT     NOCOPY     VARCHAR2,
114   x_msg_count           OUT     NOCOPY     NUMBER,
115   x_msg_data            OUT     NOCOPY     VARCHAR2,
116   --
117   p_template_id         IN      NUMBER);
118 
119 
120 PROCEDURE Delete_Template(
121   p_api_version         IN      NUMBER,
122   p_init_msg_list       IN      VARCHAR2,
123   p_commit              IN      VARCHAR2,
124   p_validation_level    IN      NUMBER,
125   x_return_status       OUT     NOCOPY     VARCHAR2,
126   x_msg_count           OUT     NOCOPY     NUMBER,
127   x_msg_data            OUT     NOCOPY     VARCHAR2,
128   --
129   p_analysis_cycle_instance_id   IN      NUMBER);
130 
131  PROCEDURE Set_Submit_Ntf_Recipients(
132   p_api_version         IN    NUMBER,
133   p_init_msg_list       IN    VARCHAR2,
134   p_commit              IN    VARCHAR2,
135   p_validation_level    IN    NUMBER,
136   x_return_status       OUT   NOCOPY VARCHAR2,
137   x_msg_count           OUT   NOCOPY NUMBER,
138   x_msg_data            OUT   NOCOPY VARCHAR2,
139   --
140   p_object_id           IN    NUMBER,
141   x_role_name           OUT   NOCOPY VARCHAR2);
142 
143 
144 PROCEDURE Populate_Approvers(
145   p_api_version         IN    NUMBER,
146   p_init_msg_list       IN    VARCHAR2,
147   p_commit              IN    VARCHAR2,
148   p_validation_level    IN    NUMBER,
149   x_return_status       OUT   NOCOPY VARCHAR2,
150   x_msg_count           OUT   NOCOPY NUMBER,
151   x_msg_data            OUT   NOCOPY VARCHAR2,
152   --
153   p_object_id           IN    NUMBER,
154   p_approver_user_id    IN    NUMBER,
155   p_approval_date       IN    DATE);
156 
157 
158 PROCEDURE Set_Source_Type(
159   p_api_version         IN    NUMBER,
160   p_init_msg_list       IN    VARCHAR2,
161   p_commit              IN    VARCHAR2,
162   p_validation_level    IN    NUMBER,
163   x_return_status       OUT   NOCOPY VARCHAR2,
164   x_msg_count           OUT   NOCOPY NUMBER,
165   x_msg_data            OUT   NOCOPY VARCHAR2,
166   --
167   p_ac_instance_id      IN    NUMBER);
168 
169 PROCEDURE Update_Template_View_Type(
170   p_template_id		IN	NUMBER,
171   p_view_type		IN	VARCHAR2,
172   p_result_out		OUT	NOCOPY VARCHAR2);
173 
174 PROCEDURE Update_Worksheet_View_Type(
175   p_template_id		IN	NUMBER,
176   p_object_id		IN	NUMBER,
177   p_view_type		IN	VARCHAR2,
178   p_result_out		OUT	NOCOPY VARCHAR2);
179 
180 END ZPB_DC_OBJECTS_PVT;