[Home] [Help]
PACKAGE: APPS.OKC_DOCLIST_PUB
Source
1 PACKAGE OKC_DOCLIST_PUB AUTHID CURRENT_USER AS
2 /*$Header: OKCPUBLS.pls 120.0 2005/05/25 22:47:55 appldev noship $*/
3
4 --===================
5 -- TYPES
6 --===================
7 --
8
9
10 --===================
11 -- CONSTANTS
12 --===================
13 --
14 g_unexpected_error CONSTANT VARCHAR2(200) := 'OKC_UBL_UNEXP_ERROR';
15 g_sqlerrm_token CONSTANT VARCHAR2(200) := 'SQLerrm';
16 g_sqlcode_token CONSTANT VARCHAR2(200) := 'SQLcode';
17 g_uppercase_required CONSTANT VARCHAR2(200) := 'OKC_UPPER_CASE_REQUIRED';
18
19 g_package_name CONSTANT VARCHAR2(200) := 'OKC_DOCLIST_PUB';
20 g_package_version CONSTANT NUMBER := 1;
21 g_application_name CONSTANT VARCHAR2(10) := okc_api.g_app_name;
22 g_init_msg_list CONSTANT VARCHAR2(1) := okc_api.g_true;
23
24 g_recent_type CONSTANT VARCHAR2(12) := 'RECENT';
25 g_bookmark_type CONSTANT VARCHAR2(12) := 'BOOKMARK';
26
27 --===================
28 -- PUBLIC VARIABLES
29 --===================
30 -- none used
31
32 --===================
33 -- PROCEDURES AND FUNCTIONS
34 --===================
35 --
36 PROCEDURE add_recent (
37 p_contract_id IN OKC_K_HEADERS_B.id%TYPE
38 ,p_contract_number IN OKC_K_HEADERS_B.contract_number%TYPE
39 ,p_contract_type IN OKC_K_HEADERS_B.chr_type%TYPE
40 ,p_contract_modifier IN OKC_K_HEADERS_B.contract_number_modifier%TYPE
41 ,p_short_description IN OKC_K_HEADERS_TL.short_description%TYPE
42 ,p_program_name IN OKC_USER_BINS.program_name%TYPE
43 ,x_return_status OUT NOCOPY VARCHAR2
44 ,x_msg_count OUT NOCOPY NUMBER
45 ,x_msg_data OUT NOCOPY VARCHAR2 );
46
47
48 PROCEDURE add_bookmark (
49 p_contract_id IN OKC_K_HEADERS_B.id%TYPE
50 ,p_contract_number IN OKC_K_HEADERS_B.contract_number%TYPE
51 ,p_contract_type IN OKC_K_HEADERS_B.chr_type%TYPE
52 ,p_contract_modifier IN OKC_K_HEADERS_B.contract_number_modifier%TYPE
53 ,p_short_description IN OKC_K_HEADERS_TL.short_description%TYPE
54 ,p_program_name IN VARCHAR2
55 ,x_return_status OUT NOCOPY VARCHAR2
56 ,x_msg_count OUT NOCOPY NUMBER
57 ,x_msg_data OUT NOCOPY VARCHAR2 );
58
59 PROCEDURE delete_entry (
60 x_ubl_id IN OKC_USER_BINS.id%TYPE
61 ,x_return_status OUT NOCOPY VARCHAR2
62 ,x_msg_count OUT NOCOPY NUMBER
63 ,x_msg_data OUT NOCOPY VARCHAR2 );
64
65 END OKC_DOCLIST_PUB;