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,
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,
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,