[Home] [Help]
PACKAGE: APPS.OKL_BCT_PVT
Source
1 PACKAGE OKL_BCT_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLSBCTS.pls 120.2 2007/05/11 22:46:45 asahoo ship $ */
3
4 --------------------------------------------------------------------------------
5 --GLOBAL DATASTRUCTURES
6 --------------------------------------------------------------------------------
7 TYPE okl_bct_rec IS RECORD (
8 USER_ID NUMBER := OKL_API.G_MISS_NUM ,
9 ORG_ID NUMBER := OKL_API.G_MISS_NUM ,
10 BATCH_NUMBER NUMBER := OKL_API.G_MISS_NUM ,
11 PROCESSING_SRL_NUMBER NUMBER := OKL_API.G_MISS_NUM ,
12 KHR_ID NUMBER := OKL_API.G_MISS_NUM ,
13 PROGRAM_NAME OKL_BOOK_CONTROLLER_TRX.PROGRAM_NAME%TYPE := OKL_API.G_MISS_CHAR ,
14 PROG_SHORT_NAME OKL_BOOK_CONTROLLER_TRX.PROG_SHORT_NAME%TYPE := OKL_API.G_MISS_CHAR ,
15 CONC_REQ_ID NUMBER := OKL_API.G_MISS_NUM ,
16 PROGRESS_STATUS OKL_BOOK_CONTROLLER_TRX.PROGRESS_STATUS%TYPE := OKL_API.G_MISS_CHAR ,
17 CREATED_BY NUMBER := OKL_API.G_MISS_NUM ,
18 CREATION_DATE OKL_BOOK_CONTROLLER_TRX.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE ,
19 LAST_UPDATED_BY NUMBER := OKL_API.G_MISS_NUM ,
20 LAST_UPDATE_DATE OKL_BOOK_CONTROLLER_TRX.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE ,
21 LAST_UPDATE_LOGIN NUMBER := OKL_API.G_MISS_NUM ,
22 ACTIVE_FLAG OKL_BOOK_CONTROLLER_TRX.ACTIVE_FLAG%TYPE := OKL_API.G_MISS_CHAR );
23
24 TYPE okl_bct_tbl IS TABLE OF okl_bct_rec
25 INDEX BY BINARY_INTEGER;
26
27 --------------------------------------------------------------------------------
28 -- GLOBAL MESSAGE CONSTANTS
29 --------------------------------------------------------------------------------
30 G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
31 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
32 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
33 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
34 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
35 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
36 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
37 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
38 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
39 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
40 --------------------------------------------------------------------------------
41 -- GLOBAL VARIABLES
42 --------------------------------------------------------------------------------
43 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_BCT_PVT';
44 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
45
46 --------------------------------------------------------------------------------
47 -- Procedures and Functions
48 --------------------------------------------------------------------------------
49 PROCEDURE change_version;
50 PROCEDURE api_copy;
51
52 -----------------------------------------------------------------------------
53 -- PROCEDURE insert_row
54 -----------------------------------------------------------------------------
55 -- Start of comments
56 --
57 -- procedure Name : insert_row
58 -- Description : Procedure to insert record into okl_book_controller_trx
59 -- Business Rules :
60 -- Parameters : p_bct_rec,x_bct_rec
61 -- Version : 1.0
62 -- History : XX-XXX-XXXX TAPI Generator Created
63 -- End of comments
64 PROCEDURE insert_row(
65 p_api_version IN NUMBER ,
66 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
67 x_return_status OUT NOCOPY VARCHAR2,
68 x_msg_count OUT NOCOPY NUMBER,
69 x_msg_data OUT NOCOPY VARCHAR2,
70 p_bct_rec IN okl_bct_rec,
71 x_bct_rec OUT NOCOPY okl_bct_rec);
72
73 -----------------------------------------------------------------------------
74 -- PROCEDURE insert_row
75 -----------------------------------------------------------------------------
76 -- Start of comments
77 --
78 -- procedure Name : insert_row
79 -- Description : Procedure to insert table of records into
80 -- okl_book_controller_trx
81 -- Business Rules :
82 -- Parameters : p_bct_tbl,x_bct_tbl
83 -- Version : 1.0
84 -- History : XX-XXX-XXXX TAPI Generator Created
85 -- End of comments
86 PROCEDURE insert_row(
87 p_api_version IN NUMBER ,
88 p_init_msg_list IN VARCHAR2 DEFAULT OKL_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_bct_tbl IN okl_bct_tbl,
93 x_bct_tbl OUT NOCOPY okl_bct_tbl);
94
95 -----------------------------------------------------------------------------
96 -- PROCEDURE update_row
97 -----------------------------------------------------------------------------
98 -- Start of comments
99 --
100 -- procedure Name : update_row
101 -- Description : Procedure to update record in okl_book_controller_trx
102 -- Business Rules :
103 -- Parameters : p_bct_rec,x_bct_rec
104 -- Version : 1.0
105 -- History : XX-XXX-XXXX TAPI Generator Created
106 -- End of comments
107 PROCEDURE update_row(
108 p_api_version IN NUMBER ,
109 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
110 x_return_status OUT NOCOPY VARCHAR2,
111 x_msg_count OUT NOCOPY NUMBER,
112 x_msg_data OUT NOCOPY VARCHAR2,
113 p_bct_rec IN okl_bct_rec,
114 x_bct_rec OUT NOCOPY okl_bct_rec);
115
116 -----------------------------------------------------------------------------
117 -- PROCEDURE update_row
118 -----------------------------------------------------------------------------
119 -- Start of comments
120 --
121 -- procedure Name : update_row
122 -- Description : Procedure to update table of records in
123 -- okl_book_controller_trx
124 -- Business Rules :
125 -- Parameters : p_bct_tbl,x_bct_tbl
126 -- Version : 1.0
127 -- History : XX-XXX-XXXX TAPI Generator Created
128 -- End of comments
129 PROCEDURE update_row(
130 p_api_version IN NUMBER ,
131 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
132 x_return_status OUT NOCOPY VARCHAR2,
133 x_msg_count OUT NOCOPY NUMBER,
134 x_msg_data OUT NOCOPY VARCHAR2,
135 p_bct_tbl IN okl_bct_tbl,
136 x_bct_tbl OUT NOCOPY okl_bct_tbl);
137
138 -----------------------------------------------------------------------------
139 -- PROCEDURE delete_row
140 -----------------------------------------------------------------------------
141 -- Start of comments
142 --
143 -- procedure Name : delete_row
144 -- Description : Procedure to delete record from okl_book_controller_trx
145 -- Business Rules :
146 -- Parameters : p_bct_rec
147 -- Version : 1.0
148 -- History : XX-XXX-XXXX TAPI Generator Created
149 -- End of comments
150 PROCEDURE delete_row(
151 p_api_version IN NUMBER ,
152 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
153 x_return_status OUT NOCOPY VARCHAR2,
154 x_msg_count OUT NOCOPY NUMBER,
155 x_msg_data OUT NOCOPY VARCHAR2,
156 p_bct_rec IN okl_bct_rec);
157
158 -----------------------------------------------------------------------------
159 -- PROCEDURE delete_row
160 -----------------------------------------------------------------------------
161 -- Start of comments
162 --
163 -- procedure Name : delete_row
164 -- Description : Procedure to delete table of record from
165 -- okl_book_controller_trx
166 -- Business Rules :
167 -- Parameters : p_bct_tbl
168 -- Version : 1.0
169 -- History : XX-XXX-XXXX TAPI Generator Created
170 -- End of comments
171 PROCEDURE delete_row(
172 p_api_version IN NUMBER ,
173 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
174 x_return_status OUT NOCOPY VARCHAR2,
175 x_msg_count OUT NOCOPY NUMBER,
176 x_msg_data OUT NOCOPY VARCHAR2,
177 p_bct_tbl IN okl_bct_tbl);
178
179 END OKL_BCT_PVT;