24: FUNCTION user_id RETURN NUMBER;
25:
26: /* added by raverma */
27: PROCEDURE Validate_any_id(p_api_version IN NUMBER := 1.0,
28: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
29: x_msg_count OUT NOCOPY NUMBER,
30: x_msg_data OUT NOCOPY VARCHAR2,
31: x_return_status OUT NOCOPY VARCHAR2,
32: p_col_id IN NUMBER,
34: p_table_name IN VARCHAR2);
35:
36: -- added raverma 01162002
37: PROCEDURE Validate_any_varchar(p_api_version IN NUMBER := 1.0,
38: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
39: x_msg_count OUT NOCOPY NUMBER,
40: x_msg_data OUT NOCOPY VARCHAR2,
41: x_return_status OUT NOCOPY VARCHAR2,
42: p_col_value IN VARCHAR2,
43: p_col_name IN VARCHAR2,
44: p_table_name IN VARCHAR2);
45:
46: PROCEDURE Validate_Lookup_CODE(p_api_version IN NUMBER := 1.0,
47: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
48: x_msg_count OUT NOCOPY NUMBER,
49: x_msg_data OUT NOCOPY VARCHAR2,
50: x_return_status OUT NOCOPY VARCHAR2,
51: p_lookup_type IN VARCHAR2,