[Home] [Help]
PACKAGE: APPS.OKC_CIM_PVT
Source
1 Package OKC_CIM_PVT AS
2 /* $Header: OKCSCIMS.pls 120.0 2005/05/25 22:40:38 appldev noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 TYPE cim_rec_type IS RECORD (
7 id NUMBER := OKC_API.G_MISS_NUM,
8 cle_id NUMBER := OKC_API.G_MISS_NUM,
9 chr_id NUMBER := OKC_API.G_MISS_NUM,
10 cle_id_for NUMBER := OKC_API.G_MISS_NUM,
11 dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
12 object1_id1 OKC_K_ITEMS.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
13 object1_id2 OKC_K_ITEMS.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
14 jtot_object1_code OKC_K_ITEMS.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR,
15 uom_code OKC_K_ITEMS.UOM_CODE%TYPE := OKC_API.G_MISS_CHAR,
16 exception_yn OKC_K_ITEMS.EXCEPTION_YN%TYPE := OKC_API.G_MISS_CHAR,
17 number_of_items NUMBER := OKC_API.G_MISS_NUM,
18 priced_item_yn OKC_K_ITEMS.PRICED_ITEM_YN%TYPE := OKC_API.G_MISS_CHAR,
19 upg_orig_system_ref OKC_K_ITEMS.UPG_ORIG_SYSTEM_REF%TYPE := OKC_API.G_MISS_CHAR,
20 upg_orig_system_ref_id NUMBER := OKC_API.G_MISS_NUM,
21 object_version_number NUMBER := OKC_API.G_MISS_NUM,
22 created_by NUMBER := OKC_API.G_MISS_NUM,
23 creation_date OKC_K_ITEMS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
24 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
25 last_update_date OKC_K_ITEMS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
26 last_update_login NUMBER := OKC_API.G_MISS_NUM,
27 request_id NUMBER := OKC_API.G_MISS_NUM,
28 program_id NUMBER := OKC_API.G_MISS_NUM,
29 program_application_id NUMBER := OKC_API.G_MISS_NUM,
30 PROGRAM_UPDATE_DATE OKC_K_ITEMS.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE);
31
32 g_miss_cim_rec cim_rec_type;
33 TYPE cim_tbl_type IS TABLE OF cim_rec_type
34 INDEX BY BINARY_INTEGER;
35 TYPE cimv_rec_type IS RECORD (
36 id NUMBER := OKC_API.G_MISS_NUM,
37 object_version_number NUMBER := OKC_API.G_MISS_NUM,
38 cle_id NUMBER := OKC_API.G_MISS_NUM,
39 chr_id NUMBER := OKC_API.G_MISS_NUM,
40 cle_id_for NUMBER := OKC_API.G_MISS_NUM,
41 dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
42 object1_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
43 object1_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
44 jtot_object1_code OKC_K_ITEMS_V.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR,
45 uom_code OKC_K_ITEMS_V.UOM_CODE%TYPE := OKC_API.G_MISS_CHAR,
46 exception_yn OKC_K_ITEMS_V.EXCEPTION_YN%TYPE := OKC_API.G_MISS_CHAR,
47 number_of_items NUMBER := OKC_API.G_MISS_NUM,
48 upg_orig_system_ref OKC_K_ITEMS_V.UPG_ORIG_SYSTEM_REF%TYPE := OKC_API.G_MISS_CHAR,
49 upg_orig_system_ref_id NUMBER := OKC_API.G_MISS_NUM,
50 priced_item_yn OKC_K_ITEMS_V.PRICED_ITEM_YN%TYPE := OKC_API.G_MISS_CHAR,
51 created_by NUMBER := OKC_API.G_MISS_NUM,
52 creation_date OKC_K_ITEMS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
53 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
54 last_update_date OKC_K_ITEMS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
55 last_update_login NUMBER := OKC_API.G_MISS_NUM,
56 request_id NUMBER := OKC_API.G_MISS_NUM,
57 program_id NUMBER := OKC_API.G_MISS_NUM,
58 program_application_id NUMBER := OKC_API.G_MISS_NUM,
59 PROGRAM_UPDATE_DATE OKC_K_ITEMS_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE);
60
61 g_miss_cimv_rec cimv_rec_type;
62 TYPE cimv_tbl_type IS TABLE OF cimv_rec_type
63 INDEX BY BINARY_INTEGER;
64 ---------------------------------------------------------------------------
65 -- GLOBAL MESSAGE CONSTANTS
66 ---------------------------------------------------------------------------
67 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
68 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
69 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
70 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
71 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
72 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
73 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
74 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
75 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
76 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
77 ---------------------------------------------------------------------------
78 -- GLOBAL VARIABLES
79 ---------------------------------------------------------------------------
80 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_CIM_PVT';
81 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
82 ---------------------------------------------------------------------------
83 -- Procedures and Functions
84 ---------------------------------------------------------------------------
85
86 PROCEDURE qc;
87 PROCEDURE change_version;
88 PROCEDURE api_copy;
89 PROCEDURE insert_row(
90 p_api_version IN NUMBER,
91 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
92 x_return_status OUT NOCOPY VARCHAR2,
93 x_msg_count OUT NOCOPY NUMBER,
94 x_msg_data OUT NOCOPY VARCHAR2,
95 p_cimv_rec IN cimv_rec_type,
96 x_cimv_rec OUT NOCOPY cimv_rec_type);
97
98 PROCEDURE insert_row(
99 p_api_version IN NUMBER,
100 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
101 x_return_status OUT NOCOPY VARCHAR2,
102 x_msg_count OUT NOCOPY NUMBER,
103 x_msg_data OUT NOCOPY VARCHAR2,
104 p_cimv_tbl IN cimv_tbl_type,
105 x_cimv_tbl OUT NOCOPY cimv_tbl_type);
106
107 PROCEDURE lock_row(
108 p_api_version IN NUMBER,
109 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_cimv_rec IN cimv_rec_type);
114
115 PROCEDURE lock_row(
116 p_api_version IN NUMBER,
117 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
118 x_return_status OUT NOCOPY VARCHAR2,
119 x_msg_count OUT NOCOPY NUMBER,
120 x_msg_data OUT NOCOPY VARCHAR2,
121 p_cimv_tbl IN cimv_tbl_type);
122
123 PROCEDURE update_row(
124 p_api_version IN NUMBER,
125 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
126 x_return_status OUT NOCOPY VARCHAR2,
127 x_msg_count OUT NOCOPY NUMBER,
128 x_msg_data OUT NOCOPY VARCHAR2,
129 p_cimv_rec IN cimv_rec_type,
130 x_cimv_rec OUT NOCOPY cimv_rec_type);
131
132 PROCEDURE update_row(
133 p_api_version IN NUMBER,
134 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
135 x_return_status OUT NOCOPY VARCHAR2,
136 x_msg_count OUT NOCOPY NUMBER,
137 x_msg_data OUT NOCOPY VARCHAR2,
138 p_cimv_tbl IN cimv_tbl_type,
139 x_cimv_tbl OUT NOCOPY cimv_tbl_type);
140
141 PROCEDURE delete_row(
142 p_api_version IN NUMBER,
143 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
144 x_return_status OUT NOCOPY VARCHAR2,
145 x_msg_count OUT NOCOPY NUMBER,
146 x_msg_data OUT NOCOPY VARCHAR2,
147 p_cimv_rec IN cimv_rec_type);
148
149 PROCEDURE delete_row(
150 p_api_version IN NUMBER,
151 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
152 x_return_status OUT NOCOPY VARCHAR2,
153 x_msg_count OUT NOCOPY NUMBER,
154 x_msg_data OUT NOCOPY VARCHAR2,
155 p_cimv_tbl IN cimv_tbl_type);
156
157 PROCEDURE validate_row(
158 p_api_version IN NUMBER,
159 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
160 x_return_status OUT NOCOPY VARCHAR2,
161 x_msg_count OUT NOCOPY NUMBER,
162 x_msg_data OUT NOCOPY VARCHAR2,
163 p_cimv_rec IN cimv_rec_type);
164
165 PROCEDURE validate_row(
166 p_api_version IN NUMBER,
167 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
168 x_return_status OUT NOCOPY VARCHAR2,
169 x_msg_count OUT NOCOPY NUMBER,
170 x_msg_data OUT NOCOPY VARCHAR2,
171 p_cimv_tbl IN cimv_tbl_type);
172
173 PROCEDURE INSERT_ROW_UPG(x_return_status OUT NOCOPY VARCHAR2, p_cimv_tbl cimv_tbl_type);
174
175 FUNCTION create_version(
176 p_chr_id IN NUMBER,
177 p_major_version IN NUMBER) RETURN VARCHAR2;
178
179 FUNCTION restore_version(
180 p_chr_id IN NUMBER,
181 p_major_version IN NUMBER) RETURN VARCHAR2;
182
183 END OKC_CIM_PVT;