2: /* $Header: ibuhalts.pls 115.8 2003/03/27 01:18:42 lahuang ship $ */
3: AUTHID CURRENT_USER as
4:
5: procedure get_bin_name (p_api_version_number IN NUMBER,
6: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
7: p_commit IN VARCHAR := FND_API.G_FALSE,
8: p_bin_id IN NUMBER,
9: x_return_status OUT NOCOPY VARCHAR2,
10: x_msg_count OUT NOCOPY NUMBER,
3: AUTHID CURRENT_USER as
4:
5: procedure get_bin_name (p_api_version_number IN NUMBER,
6: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
7: p_commit IN VARCHAR := FND_API.G_FALSE,
8: p_bin_id IN NUMBER,
9: x_return_status OUT NOCOPY VARCHAR2,
10: x_msg_count OUT NOCOPY NUMBER,
11: x_msg_data OUT NOCOPY VARCHAR2,
12: x_bin_name out NOCOPY VARCHAR2);
13: -- x_more out NOCOPY VARCHAR2);
14:
15: procedure get_html (p_api_version_number IN NUMBER,
16: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
17: p_commit IN VARCHAR := FND_API.G_FALSE,
18: p_bin_id IN NUMBER,
19: p_cookie_url In VARCHAR2,
20: x_return_status OUT NOCOPY VARCHAR2,
13: -- x_more out NOCOPY VARCHAR2);
14:
15: procedure get_html (p_api_version_number IN NUMBER,
16: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
17: p_commit IN VARCHAR := FND_API.G_FALSE,
18: p_bin_id IN NUMBER,
19: p_cookie_url In VARCHAR2,
20: x_return_status OUT NOCOPY VARCHAR2,
21: x_msg_count OUT NOCOPY NUMBER,
22: x_msg_data OUT NOCOPY VARCHAR2,
23: x_clob out NOCOPY CLOB);
24:
25: procedure get_email_text (p_api_version_number IN NUMBER,
26: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
27: p_commit IN VARCHAR := FND_API.G_FALSE,
28: p_user_id IN NUMBER,
29: p_lang_code IN VARCHAR2,
30: p_bin_id IN NUMBER,
23: x_clob out NOCOPY CLOB);
24:
25: procedure get_email_text (p_api_version_number IN NUMBER,
26: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
27: p_commit IN VARCHAR := FND_API.G_FALSE,
28: p_user_id IN NUMBER,
29: p_lang_code IN VARCHAR2,
30: p_bin_id IN NUMBER,
31: x_return_status OUT NOCOPY VARCHAR2,