[Home] [Help]
PACKAGE: APPS.OKC_ALLOWED_TMPL_USAGES_PVT
Source
1 PACKAGE OKC_ALLOWED_TMPL_USAGES_PVT AS
2 /* $Header: OKCVALDTMPLUSGS.pls 120.0 2005/05/25 22:44:39 appldev noship $ */
3
4 ---------------------------------------------------------------------------
5 -- Procedures and Functions
6 ---------------------------------------------------------------------------
7
8 PROCEDURE insert_row(
9 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
10 x_return_status OUT NOCOPY VARCHAR2,
11
12 p_template_id IN NUMBER,
13 p_document_type IN VARCHAR2,
14 p_default_yn IN VARCHAR2,
15 p_allowed_tmpl_usages_id IN NUMBER := NULL,
16
17 p_attribute_category IN VARCHAR2 := NULL,
18 p_attribute1 IN VARCHAR2 := NULL,
19 p_attribute2 IN VARCHAR2 := NULL,
20 p_attribute3 IN VARCHAR2 := NULL,
21 p_attribute4 IN VARCHAR2 := NULL,
22 p_attribute5 IN VARCHAR2 := NULL,
23 p_attribute6 IN VARCHAR2 := NULL,
24 p_attribute7 IN VARCHAR2 := NULL,
25 p_attribute8 IN VARCHAR2 := NULL,
26 p_attribute9 IN VARCHAR2 := NULL,
27 p_attribute10 IN VARCHAR2 := NULL,
28 p_attribute11 IN VARCHAR2 := NULL,
29 p_attribute12 IN VARCHAR2 := NULL,
30 p_attribute13 IN VARCHAR2 := NULL,
31 p_attribute14 IN VARCHAR2 := NULL,
32 p_attribute15 IN VARCHAR2 := NULL,
33
34 x_allowed_tmpl_usages_id OUT NOCOPY NUMBER
35 );
36
37 PROCEDURE lock_row(
38 x_return_status OUT NOCOPY VARCHAR2,
39
40 p_allowed_tmpl_usages_id IN NUMBER,
41
42 p_object_version_number IN NUMBER
43 );
44
45 PROCEDURE update_row(
46 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
47 x_return_status OUT NOCOPY VARCHAR2,
48
49 p_allowed_tmpl_usages_id IN NUMBER,
50
51 p_template_id IN NUMBER := NULL,
52 p_document_type IN VARCHAR2 := NULL,
53 p_default_yn IN VARCHAR2 := NULL,
54 p_attribute_category IN VARCHAR2 := NULL,
55 p_attribute1 IN VARCHAR2 := NULL,
56 p_attribute2 IN VARCHAR2 := NULL,
57 p_attribute3 IN VARCHAR2 := NULL,
58 p_attribute4 IN VARCHAR2 := NULL,
59 p_attribute5 IN VARCHAR2 := NULL,
60 p_attribute6 IN VARCHAR2 := NULL,
61 p_attribute7 IN VARCHAR2 := NULL,
62 p_attribute8 IN VARCHAR2 := NULL,
63 p_attribute9 IN VARCHAR2 := NULL,
64 p_attribute10 IN VARCHAR2 := NULL,
65 p_attribute11 IN VARCHAR2 := NULL,
66 p_attribute12 IN VARCHAR2 := NULL,
67 p_attribute13 IN VARCHAR2 := NULL,
68 p_attribute14 IN VARCHAR2 := NULL,
69 p_attribute15 IN VARCHAR2 := NULL,
70
71 p_object_version_number IN NUMBER
72 );
73
74 PROCEDURE delete_row(
75 x_return_status OUT NOCOPY VARCHAR2,
76
77 p_allowed_tmpl_usages_id IN NUMBER,
78
79 p_object_version_number IN NUMBER
80 );
81
82 PROCEDURE validate_row(
83 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
84 x_return_status OUT NOCOPY VARCHAR2,
85
86 p_template_id IN NUMBER,
87 p_document_type IN VARCHAR2,
88 p_default_yn IN VARCHAR2,
89 p_allowed_tmpl_usages_id IN NUMBER,
90
91 p_attribute_category IN VARCHAR2 := NULL,
92 p_attribute1 IN VARCHAR2 := NULL,
93 p_attribute2 IN VARCHAR2 := NULL,
94 p_attribute3 IN VARCHAR2 := NULL,
95 p_attribute4 IN VARCHAR2 := NULL,
96 p_attribute5 IN VARCHAR2 := NULL,
97 p_attribute6 IN VARCHAR2 := NULL,
98 p_attribute7 IN VARCHAR2 := NULL,
99 p_attribute8 IN VARCHAR2 := NULL,
100 p_attribute9 IN VARCHAR2 := NULL,
101 p_attribute10 IN VARCHAR2 := NULL,
102 p_attribute11 IN VARCHAR2 := NULL,
103 p_attribute12 IN VARCHAR2 := NULL,
104 p_attribute13 IN VARCHAR2 := NULL,
105 p_attribute14 IN VARCHAR2 := NULL,
106 p_attribute15 IN VARCHAR2 := NULL,
107
108 p_object_version_number IN NUMBER
109 );
110
111 FUNCTION get_rec (
112 p_allowed_tmpl_usages_id IN NUMBER,
113
114 x_template_id OUT NOCOPY NUMBER,
115 x_document_type OUT NOCOPY VARCHAR2,
116 x_default_yn OUT NOCOPY VARCHAR2,
117 x_attribute_category OUT NOCOPY VARCHAR2,
118 x_attribute1 OUT NOCOPY VARCHAR2,
119 x_attribute2 OUT NOCOPY VARCHAR2,
120 x_attribute3 OUT NOCOPY VARCHAR2,
121 x_attribute4 OUT NOCOPY VARCHAR2,
122 x_attribute5 OUT NOCOPY VARCHAR2,
123 x_attribute6 OUT NOCOPY VARCHAR2,
124 x_attribute7 OUT NOCOPY VARCHAR2,
125 x_attribute8 OUT NOCOPY VARCHAR2,
126 x_attribute9 OUT NOCOPY VARCHAR2,
127 x_attribute10 OUT NOCOPY VARCHAR2,
128 x_attribute11 OUT NOCOPY VARCHAR2,
129 x_attribute12 OUT NOCOPY VARCHAR2,
130 x_attribute13 OUT NOCOPY VARCHAR2,
131 x_attribute14 OUT NOCOPY VARCHAR2,
132 x_attribute15 OUT NOCOPY VARCHAR2,
133 x_object_version_number OUT NOCOPY NUMBER,
134 x_created_by OUT NOCOPY NUMBER,
135 x_creation_date OUT NOCOPY DATE,
136 x_last_updated_by OUT NOCOPY NUMBER,
137 x_last_update_login OUT NOCOPY NUMBER,
138 x_last_update_date OUT NOCOPY DATE
139
140 ) RETURN VARCHAR2;
141
142
143 END OKC_ALLOWED_TMPL_USAGES_PVT;