[Home] [Help]
PACKAGE: APPS.OKL_ICG_PVT
Source
1 Package OKL_ICG_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLSICGS.pls 115.7 2002/02/05 12:16:45 pkm ship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 TYPE icg_rec_type IS RECORD (
7 id NUMBER := OKC_API.G_MISS_NUM,
8 iac_code OKL_INS_CLASS_CATS.IAC_CODE%TYPE := OKC_API.G_MISS_CHAR,
9 iay_id NUMBER := OKC_API.G_MISS_NUM,
10 object_version_number NUMBER := OKC_API.G_MISS_NUM,
11 date_from OKL_INS_CLASS_CATS.DATE_FROM%TYPE := OKC_API.G_MISS_DATE,
12 date_to OKL_INS_CLASS_CATS.DATE_TO%TYPE := OKC_API.G_MISS_DATE,
13 created_by NUMBER := OKC_API.G_MISS_NUM,
14 creation_date OKL_INS_CLASS_CATS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
15 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
16 last_update_date OKL_INS_CLASS_CATS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
17 last_update_login NUMBER := OKC_API.G_MISS_NUM);
18
19 g_miss_icg_rec icg_rec_type;
20
21 TYPE icg_tbl_type IS TABLE OF icg_rec_type INDEX BY BINARY_INTEGER;
22
23 TYPE icgv_rec_type IS RECORD (
24 id NUMBER := OKC_API.G_MISS_NUM,
25 object_version_number NUMBER := OKC_API.G_MISS_NUM,
26 iay_id NUMBER := OKC_API.G_MISS_NUM,
27 iac_code OKL_INS_CLASS_CATS_V.IAC_CODE%TYPE := OKC_API.G_MISS_CHAR,
28 date_from OKL_INS_CLASS_CATS_V.DATE_FROM%TYPE := OKC_API.G_MISS_DATE,
29 date_to OKL_INS_CLASS_CATS_V.DATE_TO%TYPE := OKC_API.G_MISS_DATE,
30 created_by NUMBER := OKC_API.G_MISS_NUM,
31 creation_date OKL_INS_CLASS_CATS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
32 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
33 last_update_date OKL_INS_CLASS_CATS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
34 last_update_login NUMBER := OKC_API.G_MISS_NUM);
35
36 g_miss_icgv_rec icgv_rec_type;
37
38 TYPE icgv_tbl_type IS TABLE OF icgv_rec_type INDEX BY BINARY_INTEGER;
39
40 -- RFEDANE
41 -- Global constants may be picked up from OKL_API (presently using OKC_API)
42 -- once OKL_API is ready for use.
43
44 ---------------------------------------------------------------------------
45 -- GLOBAL MESSAGE CONSTANTS
46 ---------------------------------------------------------------------------
47 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
48 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
49 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
50 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
51 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
52 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := 'OKL_REQUIRED_VALUE';
53 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
54 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
55 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
56 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
57 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
58 G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKL_NO_PARENT_RECORD';
59 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
60 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
61
62
63
64
65 ---------------------------------------------------------------------------
66 -- GLOBAL VARIABLES
67 ---------------------------------------------------------------------------
68 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_ICG_PVT';
69 G_APP_NAME CONSTANT VARCHAR2(3) := 'OKL';
70
71 ---------------------------------------------------------------------------
72 -- GLOBAL EXCEPTION
73 ---------------------------------------------------------------------------
74 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
75 ---------------------------------------------------------------------------
76 -- Procedures and Functions
77 ---------------------------------------------------------------------------
78
79 PROCEDURE qc;
80 PROCEDURE change_version;
81 PROCEDURE api_copy;
82 PROCEDURE insert_row(
83 p_api_version IN NUMBER,
84 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
85 x_return_status OUT NOCOPY VARCHAR2,
86 x_msg_count OUT NOCOPY NUMBER,
87 x_msg_data OUT NOCOPY VARCHAR2,
88 p_icgv_rec IN icgv_rec_type,
89 x_icgv_rec OUT NOCOPY icgv_rec_type);
90
91 PROCEDURE insert_row(
92 p_api_version IN NUMBER,
93 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
94 x_return_status OUT NOCOPY VARCHAR2,
95 x_msg_count OUT NOCOPY NUMBER,
96 x_msg_data OUT NOCOPY VARCHAR2,
97 p_icgv_tbl IN icgv_tbl_type,
98 x_icgv_tbl OUT NOCOPY icgv_tbl_type);
99
100 PROCEDURE lock_row(
101 p_api_version IN NUMBER,
102 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
103 x_return_status OUT NOCOPY VARCHAR2,
104 x_msg_count OUT NOCOPY NUMBER,
105 x_msg_data OUT NOCOPY VARCHAR2,
106 p_icgv_rec IN icgv_rec_type);
107
108 PROCEDURE lock_row(
109 p_api_version IN NUMBER,
110 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
111 x_return_status OUT NOCOPY VARCHAR2,
112 x_msg_count OUT NOCOPY NUMBER,
113 x_msg_data OUT NOCOPY VARCHAR2,
114 p_icgv_tbl IN icgv_tbl_type);
115
116 PROCEDURE update_row(
117 p_api_version IN NUMBER,
118 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
119 x_return_status OUT NOCOPY VARCHAR2,
120 x_msg_count OUT NOCOPY NUMBER,
121 x_msg_data OUT NOCOPY VARCHAR2,
122 p_icgv_rec IN icgv_rec_type,
123 x_icgv_rec OUT NOCOPY icgv_rec_type);
124
125 PROCEDURE update_row(
126 p_api_version IN NUMBER,
127 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
128 x_return_status OUT NOCOPY VARCHAR2,
129 x_msg_count OUT NOCOPY NUMBER,
130 x_msg_data OUT NOCOPY VARCHAR2,
131 p_icgv_tbl IN icgv_tbl_type,
132 x_icgv_tbl OUT NOCOPY icgv_tbl_type);
133
134 PROCEDURE delete_row(
135 p_api_version IN NUMBER,
136 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
137 x_return_status OUT NOCOPY VARCHAR2,
138 x_msg_count OUT NOCOPY NUMBER,
139 x_msg_data OUT NOCOPY VARCHAR2,
140 p_icgv_rec IN icgv_rec_type);
141
142 PROCEDURE delete_row(
143 p_api_version IN NUMBER,
144 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
145 x_return_status OUT NOCOPY VARCHAR2,
146 x_msg_count OUT NOCOPY NUMBER,
147 x_msg_data OUT NOCOPY VARCHAR2,
148 p_icgv_tbl IN icgv_tbl_type);
149
150 PROCEDURE validate_row(
151 p_api_version IN NUMBER,
152 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_icgv_rec IN icgv_rec_type);
157
158 PROCEDURE validate_row(
159 p_api_version IN NUMBER,
160 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
161 x_return_status OUT NOCOPY VARCHAR2,
162 x_msg_count OUT NOCOPY NUMBER,
163 x_msg_data OUT NOCOPY VARCHAR2,
164 p_icgv_tbl IN icgv_tbl_type);
165
166 END OKL_ICG_PVT;