1 PACKAGE OKC_REVIEW_VAR_VALUES_PVT AS
2 /* $Header: OKCVRUVS.pls 120.2 2005/09/13 22:37 vnanjang noship $ */
3 ---------------------------------------------------------------------------
4 -- Procedures and Functions
5 ---------------------------------------------------------------------------
6
7 PROCEDURE insert_row(
8 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
9 x_return_status OUT NOCOPY VARCHAR2,
10
11 p_REVIEW_VAR_VALUES_id IN NUMBER,
12 p_review_upld_terms_id IN NUMBER,
13 p_variable_name IN VARCHAR2,
14 p_variable_code IN VARCHAR2,
15 p_variable_type IN VARCHAR2,
16 p_variable_value_id IN NUMBER,
17 p_variable_value IN VARCHAR2,
18
19 p_attribute_value_set_id IN NUMBER := NULL,
20
21 x_review_upld_terms_id OUT NOCOPY NUMBER
22 );
23
24 PROCEDURE lock_row(
25 x_return_status OUT NOCOPY VARCHAR2,
26
27 p_review_upld_terms_id IN NUMBER,
28
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
36 p_review_upld_terms_id IN NUMBER,
37
38 p_REVIEW_VAR_VALUES_id IN NUMBER := NULL,
39 p_variable_name IN VARCHAR2 := NULL,
40 p_variable_code IN VARCHAR2 := NULL,
41 p_variable_type IN VARCHAR2 := NULL,
42 p_variable_value_id IN NUMBER := NULL,
43 p_variable_value IN VARCHAR2 := NULL,
44 p_attribute_value_set_id IN NUMBER := NULL,
45
46 p_object_version_number IN NUMBER
47 );
48
49 PROCEDURE delete_row(
50 x_return_status OUT NOCOPY VARCHAR2,
51
52 p_review_upld_terms_id IN NUMBER,
53
54 p_object_version_number IN NUMBER
55 );
56
57 PROCEDURE validate_row(
58 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
59 x_return_status OUT NOCOPY VARCHAR2,
60
61 p_REVIEW_VAR_VALUES_id IN NUMBER,
62 p_review_upld_terms_id IN NUMBER,
63 p_variable_name IN VARCHAR2,
64 p_variable_code IN VARCHAR2,
65 p_variable_type IN VARCHAR2,
66 p_variable_value_id IN NUMBER,
67 p_variable_value IN VARCHAR2,
68
69 p_attribute_value_set_id IN NUMBER := NULL,
70
71 p_object_version_number IN NUMBER
72 );
73
74 FUNCTION get_rec (
75 p_review_upld_terms_id IN NUMBER,
76
77 x_REVIEW_VAR_VALUES_id OUT NOCOPY NUMBER,
78 x_variable_name OUT NOCOPY VARCHAR2,
79 x_variable_code OUT NOCOPY VARCHAR2,
80 x_variable_type OUT NOCOPY VARCHAR2,
81 x_variable_value_id OUT NOCOPY NUMBER,
82 x_variable_value OUT NOCOPY VARCHAR2,
83 x_attribute_value_set_id OUT NOCOPY NUMBER,
84 x_object_version_number OUT NOCOPY NUMBER,
85 x_created_by OUT NOCOPY NUMBER,
86 x_creation_date OUT NOCOPY DATE,
87 x_last_updated_by OUT NOCOPY NUMBER,
88 x_last_update_login OUT NOCOPY NUMBER,
89 x_last_update_date OUT NOCOPY DATE,
90 x_language OUT NOCOPY VARCHAR2
91
92 ) RETURN VARCHAR2;
93
94
95
96 END OKC_REVIEW_VAR_VALUES_PVT;
97