[Home] [Help]
PACKAGE: APPS.OKC_LINE_STYLES_PVT
Source
1 PACKAGE OKC_LINE_STYLES_PVT AS
2 /* $Header: OKCCLSES.pls 120.0 2005/05/25 22:45:35 appldev noship $ */
3 --------------------------------------------------------------------------
4 ---The following procedures cater to handling of OKC_LINE_STYLES
5 --------------------------------------------------------------------------
6
7 G_UNEXPECTED_ERROR CONSTANT varchar2(200) := 'OKC_UNEXPECTED_ERROR';
8 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_LINE_STYTLES_PVT';
9 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
10 G_SQLERRM_TOKEN CONSTANT varchar2(200) := 'ERROR_MESSAGE';
11 G_SQLCODE_TOKEN CONSTANT varchar2(200) := 'ERROR_CODE';
12 SUBTYPE lsev_rec_type is okc_lse_pvt.lsev_rec_type;
13
14
15 PROCEDURE add_language;
16
17 PROCEDURE CREATE_LINE_STYLES(
18 p_api_version IN NUMBER,
19 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
20 x_return_status OUT NOCOPY VARCHAR2,
21 x_msg_count OUT NOCOPY NUMBER,
22 x_msg_data OUT NOCOPY VARCHAR2,
23 p_lsev_rec IN lsev_rec_type,
24 x_lsev_rec OUT NOCOPY lsev_rec_type) ;
25
26 PROCEDURE UPDATE_LINE_STYLES(
27 p_api_version IN NUMBER,
28 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
29 x_return_status OUT NOCOPY VARCHAR2,
30 x_msg_count OUT NOCOPY NUMBER,
31 x_msg_data OUT NOCOPY VARCHAR2,
32 p_lsev_rec IN lsev_rec_type,
33 x_lsev_rec OUT NOCOPY lsev_rec_type) ;
34
35 PROCEDURE DELETE_LINE_STYLES(
36 p_api_version IN NUMBER,
37 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
38 x_return_status OUT NOCOPY VARCHAR2,
39 x_msg_count OUT NOCOPY NUMBER,
40 x_msg_data OUT NOCOPY VARCHAR2,
41 p_lsev_rec IN lsev_rec_type) ;
42
43 PROCEDURE LOCK_LINE_STYLES(
44 p_api_version IN NUMBER,
45 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
46 x_return_status OUT NOCOPY VARCHAR2,
47 x_msg_count OUT NOCOPY NUMBER,
48 x_msg_data OUT NOCOPY VARCHAR2,
49 p_lsev_rec IN lsev_rec_type) ;
50
51 PROCEDURE VALID_LINE_STYLES(
52 p_api_version IN NUMBER,
53 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
54 x_return_status OUT NOCOPY VARCHAR2,
55 x_msg_count OUT NOCOPY NUMBER,
56 x_msg_data OUT NOCOPY VARCHAR2,
57 p_lsev_rec IN lsev_rec_type) ;
58
59 FUNCTION USED_IN_K_LINES(p_id IN NUMBER) RETURN VARCHAR2;
60 FUNCTION USED_IN_SETUPS(p_id IN NUMBER) RETURN VARCHAR2;
61 FUNCTION USED_IN_SRC_OPS(p_id IN NUMBER) RETURN VARCHAR2;
62 --------------------------------------------------------------------------
63 ---The following procedures cater to handling of OKC_LINE_STYLE_SOURCES
64 --------------------------------------------------------------------------
65
66 SUBTYPE lssv_rec_type is okc_lss_pvt.lssv_rec_type;
67
68 PROCEDURE CREATE_LINE_STYLE_SOURCES(
69 p_api_version IN NUMBER,
70 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
71 x_return_status OUT NOCOPY VARCHAR2,
72 x_msg_count OUT NOCOPY NUMBER,
73 x_msg_data OUT NOCOPY VARCHAR2,
74 p_lssv_rec IN lssv_rec_type,
75 x_lssv_rec OUT NOCOPY lssv_rec_type) ;
76
77 PROCEDURE UPDATE_LINE_STYLE_SOURCES(
78 p_api_version IN NUMBER,
79 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
80 x_return_status OUT NOCOPY VARCHAR2,
81 x_msg_count OUT NOCOPY NUMBER,
82 x_msg_data OUT NOCOPY VARCHAR2,
83 p_lssv_rec IN lssv_rec_type,
84 x_lssv_rec OUT NOCOPY lssv_rec_type) ;
85
86 PROCEDURE DELETE_LINE_STYLE_SOURCES(
87 p_api_version IN NUMBER,
88 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
89 x_return_status OUT NOCOPY VARCHAR2,
90 x_msg_count OUT NOCOPY NUMBER,
91 x_msg_data OUT NOCOPY VARCHAR2,
92 p_lssv_rec IN lssv_rec_type) ;
93
94 PROCEDURE LOCK_LINE_STYLE_SOURCES(
95 p_api_version IN NUMBER,
96 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
97 x_return_status OUT NOCOPY VARCHAR2,
98 x_msg_count OUT NOCOPY NUMBER,
99 x_msg_data OUT NOCOPY VARCHAR2,
100 p_lssv_rec IN lssv_rec_type) ;
101
102 PROCEDURE VALID_LINE_STYLE_SOURCES(
103 p_api_version IN NUMBER,
104 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
105 x_return_status OUT NOCOPY VARCHAR2,
106 x_msg_count OUT NOCOPY NUMBER,
107 x_msg_data OUT NOCOPY VARCHAR2,
108 p_lssv_rec IN lssv_rec_type) ;
109
110
111 -- following code added by smhanda
112 --------------------------------------------------------------------------
113 ---The following procedures cater to handling of OKC_VALID_LINE_OPERATIONS
114 --------------------------------------------------------------------------
115
116 SUBTYPE vlov_rec_type is okc_vlo_pvt.vlov_rec_type;
117 SUBTYPE vlov_tbl_type is okc_vlo_pvt.vlov_tbl_type;
118
119 PROCEDURE CREATE_VAL_LINE_OPERATION(
120 p_api_version IN NUMBER,
121 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
122 x_return_status OUT NOCOPY VARCHAR2,
123 x_msg_count OUT NOCOPY NUMBER,
124 x_msg_data OUT NOCOPY VARCHAR2,
125 p_vlov_rec IN vlov_rec_type,
126 x_vlov_rec OUT NOCOPY vlov_rec_type) ;
127
128 PROCEDURE UPDATE_VAL_LINE_OPERATION(
129 p_api_version IN NUMBER,
130 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
131 x_return_status OUT NOCOPY VARCHAR2,
132 x_msg_count OUT NOCOPY NUMBER,
133 x_msg_data OUT NOCOPY VARCHAR2,
134 p_vlov_rec IN vlov_rec_type,
135 x_vlov_rec OUT NOCOPY vlov_rec_type) ;
136
137 PROCEDURE DELETE_VAL_LINE_OPERATION(
138 p_api_version IN NUMBER,
139 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
140 x_return_status OUT NOCOPY VARCHAR2,
141 x_msg_count OUT NOCOPY NUMBER,
142 x_msg_data OUT NOCOPY VARCHAR2,
143 p_vlov_rec IN vlov_rec_type) ;
144
145 PROCEDURE LOCK_VAL_LINE_OPERATION(
146 p_api_version IN NUMBER,
147 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
148 x_return_status OUT NOCOPY VARCHAR2,
149 x_msg_count OUT NOCOPY NUMBER,
150 x_msg_data OUT NOCOPY VARCHAR2,
151 p_vlov_rec IN vlov_rec_type) ;
152
153 PROCEDURE VALIDATE_VAL_LINE_OPERATION(
154 p_api_version IN NUMBER,
155 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
156 x_return_status OUT NOCOPY VARCHAR2,
157 x_msg_count OUT NOCOPY NUMBER,
158 x_msg_data OUT NOCOPY VARCHAR2,
159 p_vlov_rec IN vlov_rec_type) ;
160
161
162 END OKC_LINE_STYLES_PVT;