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