1 PACKAGE OKC_K_ART_VARIABLES_PVT AS
2 /* $Header: OKCVVARS.pls 120.0 2005/05/26 09:27:50 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 p_cat_id IN NUMBER,
12 p_variable_code IN VARCHAR2,
13 p_variable_type IN VARCHAR2,
14 p_external_yn IN VARCHAR2,
15 p_variable_value_id IN VARCHAR2,
16 p_variable_value IN VARCHAR2,
17 p_attribute_value_set_id IN NUMBER := NULL,
18 p_override_global_yn IN VARCHAR2 :='N',
19 x_cat_id OUT NOCOPY NUMBER,
20 x_variable_code OUT NOCOPY VARCHAR2
21 );
22
23 PROCEDURE lock_row(
24 x_return_status OUT NOCOPY VARCHAR2,
25 p_cat_id IN NUMBER,
26 p_variable_code IN VARCHAR2,
27 p_object_version_number IN NUMBER
28 );
29
30 PROCEDURE update_row(
31 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
32 x_return_status OUT NOCOPY VARCHAR2,
33 p_cat_id IN NUMBER,
34 p_variable_code IN VARCHAR2,
35 p_variable_type IN VARCHAR2 :=NULL,
36 p_external_yn IN VARCHAR2 := NULL,
37 p_variable_value_id IN VARCHAR2 := NULL,
38 p_variable_value IN VARCHAR2 := NULL,
39 p_attribute_value_set_id IN NUMBER := NULL,
40 p_override_global_yn IN VARCHAR2 := NULL,
41 p_object_version_number IN NUMBER
42 );
43
44 PROCEDURE delete_row(
45 x_return_status OUT NOCOPY VARCHAR2,
46 p_cat_id IN NUMBER,
47 p_variable_code IN VARCHAR2,
48 p_object_version_number IN NUMBER
49 );
50
51 PROCEDURE delete_set(
52 x_return_status OUT NOCOPY VARCHAR2,
53 p_cat_id IN NUMBER
54 );
55
56 PROCEDURE delete_set(
57 x_return_status OUT NOCOPY VARCHAR2,
58 p_scn_id IN NUMBER
59 );
60
61 PROCEDURE delete_set(
62 x_return_status OUT NOCOPY VARCHAR2,
63 p_doc_type IN VARCHAR2,
64 p_doc_id IN NUMBER
65 );
66
67 PROCEDURE validate_row(
68 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
69 x_return_status OUT NOCOPY VARCHAR2,
70 p_cat_id IN NUMBER,
71 p_variable_code IN VARCHAR2,
72 p_variable_type IN VARCHAR2,
73 p_external_yn IN VARCHAR2,
74 p_variable_value_id IN VARCHAR2,
75 p_variable_value IN VARCHAR2,
76 p_attribute_value_set_id IN NUMBER ,
77 p_override_global_yn IN VARCHAR2,
78 p_object_version_number IN NUMBER
79 );
80
81 FUNCTION get_rec (
82 p_cat_id IN NUMBER,
83 p_variable_code IN VARCHAR2,
84 x_variable_type OUT NOCOPY VARCHAR2,
85 x_external_yn OUT NOCOPY VARCHAR2,
86 x_variable_value_id OUT NOCOPY VARCHAR2,
87 x_variable_value OUT NOCOPY VARCHAR2,
88 x_attribute_value_set_id OUT NOCOPY NUMBER,
89 x_override_global_yn OUT NOCOPY VARCHAR2,
90 x_object_version_number OUT NOCOPY NUMBER,
91 x_created_by OUT NOCOPY NUMBER,
92 x_creation_date OUT NOCOPY DATE,
93 x_last_updated_by OUT NOCOPY NUMBER,
94 x_last_update_login OUT NOCOPY NUMBER,
95 x_last_update_date OUT NOCOPY DATE
96
97 ) RETURN VARCHAR2;
98
99
100 --This Function is called from Versioning API OKC_VERSION_PVT
101 -- Location:Base Table API
102
103 FUNCTION Create_Version(
104 p_doc_type IN VARCHAR2,
105 p_doc_id IN NUMBER,
106 p_major_version IN NUMBER
107 ) RETURN VARCHAR2;
108
109 --This Function is called from Versioning API OKC_VERSION_PVT
110 -- Location:Base Table API
111
112 FUNCTION Restore_Version(
113 p_doc_type IN VARCHAR2,
114 p_doc_id IN NUMBER,
115 p_major_version NUMBER
116 ) RETURN VARCHAR2;
117
118 --This Function is called from Versioning API OKC_VERSION_PVT
119 -- to delete variables for specified version of document
120
121 FUNCTION Delete_Version(
122 p_doc_type IN VARCHAR2,
123 p_doc_id IN NUMBER,
124 p_major_version IN NUMBER
125 ) RETURN VARCHAR2;
126
127 END OKC_K_ART_VARIABLES_PVT;