[Home] [Help]
PACKAGE: APPS.OKC_ALLOWED_TMPL_USAGES_GRP
Source
1 PACKAGE OKC_ALLOWED_TMPL_USAGES_GRP AUTHID CURRENT_USER AS
2 /* $Header: OKCGALDTMPLUSGS.pls 120.0 2005/05/25 22:50:02 appldev noship $ */
3
4 ---------------------------------------------------------------------------
5 -- Procedures and Functions
6 ---------------------------------------------------------------------------
7
8 PROCEDURE Create_Allowed_Tmpl_Usages(
9 p_api_version IN NUMBER,
10 p_init_msg_list IN VARCHAR2 ,
11 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
12 p_commit IN VARCHAR2 := FND_API.G_FALSE,
13
14 x_return_status OUT NOCOPY VARCHAR2,
15 x_msg_count OUT NOCOPY NUMBER,
16 x_msg_data OUT NOCOPY VARCHAR2,
17
18 p_template_id IN NUMBER,
19 p_document_type IN VARCHAR2,
20 p_default_yn IN VARCHAR2,
21 p_allowed_tmpl_usages_id IN NUMBER := NULL,
22
23 p_attribute_category IN VARCHAR2 := NULL,
24 p_attribute1 IN VARCHAR2 := NULL,
25 p_attribute2 IN VARCHAR2 := NULL,
26 p_attribute3 IN VARCHAR2 := NULL,
27 p_attribute4 IN VARCHAR2 := NULL,
28 p_attribute5 IN VARCHAR2 := NULL,
29 p_attribute6 IN VARCHAR2 := NULL,
30 p_attribute7 IN VARCHAR2 := NULL,
31 p_attribute8 IN VARCHAR2 := NULL,
32 p_attribute9 IN VARCHAR2 := NULL,
33 p_attribute10 IN VARCHAR2 := NULL,
34 p_attribute11 IN VARCHAR2 := NULL,
35 p_attribute12 IN VARCHAR2 := NULL,
36 p_attribute13 IN VARCHAR2 := NULL,
37 p_attribute14 IN VARCHAR2 := NULL,
38 p_attribute15 IN VARCHAR2 := NULL,
39
40 x_allowed_tmpl_usages_id OUT NOCOPY NUMBER
41
42 );
43
44 PROCEDURE Lock_Allowed_Tmpl_Usages(
45 p_api_version IN NUMBER,
46 p_init_msg_list IN VARCHAR2 ,
47
48 x_return_status OUT NOCOPY VARCHAR2,
49 x_msg_count OUT NOCOPY NUMBER,
50 x_msg_data OUT NOCOPY VARCHAR2,
51
52 p_allowed_tmpl_usages_id IN NUMBER,
53
54 p_object_version_number IN NUMBER
55
56 );
57
58 PROCEDURE Update_Allowed_Tmpl_Usages(
59 p_api_version IN NUMBER,
60 p_init_msg_list IN VARCHAR2 ,
61 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
62 p_commit IN VARCHAR2 := FND_API.G_FALSE,
63
64 x_return_status OUT NOCOPY VARCHAR2,
65 x_msg_count OUT NOCOPY NUMBER,
66 x_msg_data OUT NOCOPY VARCHAR2,
67
68 p_template_id IN NUMBER,
69 p_document_type IN VARCHAR2,
70 p_default_yn IN VARCHAR2,
71 p_allowed_tmpl_usages_id IN NUMBER,
72
73 p_attribute_category IN VARCHAR2 := NULL,
74 p_attribute1 IN VARCHAR2 := NULL,
75 p_attribute2 IN VARCHAR2 := NULL,
76 p_attribute3 IN VARCHAR2 := NULL,
77 p_attribute4 IN VARCHAR2 := NULL,
78 p_attribute5 IN VARCHAR2 := NULL,
79 p_attribute6 IN VARCHAR2 := NULL,
80 p_attribute7 IN VARCHAR2 := NULL,
81 p_attribute8 IN VARCHAR2 := NULL,
82 p_attribute9 IN VARCHAR2 := NULL,
83 p_attribute10 IN VARCHAR2 := NULL,
84 p_attribute11 IN VARCHAR2 := NULL,
85 p_attribute12 IN VARCHAR2 := NULL,
86 p_attribute13 IN VARCHAR2 := NULL,
87 p_attribute14 IN VARCHAR2 := NULL,
88 p_attribute15 IN VARCHAR2 := NULL,
89
90 p_object_version_number IN NUMBER
91 );
92
93 PROCEDURE Delete_Allowed_Tmpl_Usages(
94 p_api_version IN NUMBER,
95 p_init_msg_list IN VARCHAR2 ,
96 p_commit IN VARCHAR2 := FND_API.G_FALSE,
97
98 x_return_status OUT NOCOPY VARCHAR2,
99 x_msg_count OUT NOCOPY NUMBER,
100 x_msg_data OUT NOCOPY VARCHAR2,
101
102 p_allowed_tmpl_usages_id IN NUMBER,
103
104 p_object_version_number IN NUMBER
105 );
106
107 PROCEDURE Validate_Allowed_Tmpl_Usages(
108 p_api_version IN NUMBER,
109 p_init_msg_list IN VARCHAR2 ,
110 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
111
112 x_return_status OUT NOCOPY VARCHAR2,
113 x_msg_count OUT NOCOPY NUMBER,
114 x_msg_data OUT NOCOPY VARCHAR2,
115
116 p_template_id IN NUMBER,
117 p_document_type IN VARCHAR2,
118 p_default_yn IN VARCHAR2,
119 p_allowed_tmpl_usages_id IN NUMBER,
120
121 p_attribute_category IN VARCHAR2 := NULL,
122 p_attribute1 IN VARCHAR2 := NULL,
123 p_attribute2 IN VARCHAR2 := NULL,
124 p_attribute3 IN VARCHAR2 := NULL,
125 p_attribute4 IN VARCHAR2 := NULL,
126 p_attribute5 IN VARCHAR2 := NULL,
127 p_attribute6 IN VARCHAR2 := NULL,
128 p_attribute7 IN VARCHAR2 := NULL,
129 p_attribute8 IN VARCHAR2 := NULL,
130 p_attribute9 IN VARCHAR2 := NULL,
131 p_attribute10 IN VARCHAR2 := NULL,
132 p_attribute11 IN VARCHAR2 := NULL,
133 p_attribute12 IN VARCHAR2 := NULL,
134 p_attribute13 IN VARCHAR2 := NULL,
135 p_attribute14 IN VARCHAR2 := NULL,
136 p_attribute15 IN VARCHAR2 := NULL,
137
138 p_object_version_number IN NUMBER
139 );
140
141 END OKC_ALLOWED_TMPL_USAGES_GRP;