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