[Home] [Help]
PACKAGE: APPS.OKL_CGM_PVT
Source
1 Package OKL_CGM_PVT AS
2 /* $Header: OKLSCGMS.pls 120.2 2006/12/07 06:15:06 ssdeshpa noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 TYPE cgm_rec_type IS RECORD (
7 id NUMBER := OKC_API.G_MISS_NUM,
8 cgr_id NUMBER := OKC_API.G_MISS_NUM,
9 pmr_id NUMBER := OKC_API.G_MISS_NUM,
10 object_version_number NUMBER := OKC_API.G_MISS_NUM,
11 created_by NUMBER := OKC_API.G_MISS_NUM,
12 creation_date OKL_CNTX_GRP_PRMTRS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
13 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
14 last_update_date OKL_CNTX_GRP_PRMTRS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
15 last_update_login NUMBER := OKC_API.G_MISS_NUM);
16 g_miss_cgm_rec cgm_rec_type;
17 TYPE cgm_tbl_type IS TABLE OF cgm_rec_type
18 INDEX BY BINARY_INTEGER;
19 TYPE cgmv_rec_type IS RECORD (
20 id NUMBER := OKC_API.G_MISS_NUM,
21 object_version_number NUMBER := OKC_API.G_MISS_NUM,
22 cgr_id NUMBER := OKC_API.G_MISS_NUM,
23 pmr_id NUMBER := OKC_API.G_MISS_NUM,
24 created_by NUMBER := OKC_API.G_MISS_NUM,
25 creation_date OKL_CNTX_GRP_PRMTRS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
26 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
27 last_update_date OKL_CNTX_GRP_PRMTRS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
28 last_update_login NUMBER := OKC_API.G_MISS_NUM);
29 g_miss_cgmv_rec cgmv_rec_type;
30 TYPE cgmv_tbl_type IS TABLE OF cgmv_rec_type
31 INDEX BY BINARY_INTEGER;
32 ---------------------------------------------------------------------------
33 -- GLOBAL MESSAGE CONSTANTS
34 ---------------------------------------------------------------------------
35 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
36 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
37 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
38 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
39 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
40 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
41 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
42 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
43 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
44 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
45 G_TABLE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_TABLE_NAME';
46 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
47 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKC_SQLERRM';
48 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKC_SQLCODE';
49 G_UPPERCASE_REQUIRED CONSTANT VARCHAR2(200) := 'OKC_UPPER_CASE_REQUIRED';
50 G_ONE_DOI CONSTANT VARCHAR2(200) := 'OKC_ONE_DOI';
51 G_UNQS CONSTANT VARCHAR2(200) := 'OKL_NOT_UNIQUE';
52 ---------------------------------------------------------------------------
53 -- GLOBAL VARIABLES
54 ---------------------------------------------------------------------------
55 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_CGM_PVT';
56 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
57 ---------------------------------------------------------------------------
58 -- GLOBAL EXCEPTION
59 ---------------------------------------------------------------------------
60 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
61
62 ---------------------------------------------------------------------------
63 -- Procedures and Functions
64 ---------------------------------------------------------------------------
65
66 PROCEDURE qc;
67 PROCEDURE change_version;
68 PROCEDURE api_copy;
69 PROCEDURE insert_row(
70 p_api_version IN NUMBER,
71 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
72 x_return_status OUT NOCOPY VARCHAR2,
73 x_msg_count OUT NOCOPY NUMBER,
74 x_msg_data OUT NOCOPY VARCHAR2,
75 p_cgmv_rec IN cgmv_rec_type,
76 x_cgmv_rec OUT NOCOPY cgmv_rec_type);
77
78 PROCEDURE insert_row(
79 p_api_version IN NUMBER,
80 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
81 x_return_status OUT NOCOPY VARCHAR2,
82 x_msg_count OUT NOCOPY NUMBER,
83 x_msg_data OUT NOCOPY VARCHAR2,
84 p_cgmv_tbl IN cgmv_tbl_type,
85 x_cgmv_tbl OUT NOCOPY cgmv_tbl_type);
86
87 PROCEDURE lock_row(
88 p_api_version IN NUMBER,
89 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
90 x_return_status OUT NOCOPY VARCHAR2,
91 x_msg_count OUT NOCOPY NUMBER,
92 x_msg_data OUT NOCOPY VARCHAR2,
93 p_cgmv_rec IN cgmv_rec_type);
94
95 PROCEDURE lock_row(
96 p_api_version IN NUMBER,
97 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
98 x_return_status OUT NOCOPY VARCHAR2,
99 x_msg_count OUT NOCOPY NUMBER,
100 x_msg_data OUT NOCOPY VARCHAR2,
101 p_cgmv_tbl IN cgmv_tbl_type);
102
103 PROCEDURE update_row(
104 p_api_version IN NUMBER,
105 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
106 x_return_status OUT NOCOPY VARCHAR2,
107 x_msg_count OUT NOCOPY NUMBER,
108 x_msg_data OUT NOCOPY VARCHAR2,
109 p_cgmv_rec IN cgmv_rec_type,
110 x_cgmv_rec OUT NOCOPY cgmv_rec_type);
111
112 PROCEDURE update_row(
113 p_api_version IN NUMBER,
114 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
115 x_return_status OUT NOCOPY VARCHAR2,
116 x_msg_count OUT NOCOPY NUMBER,
117 x_msg_data OUT NOCOPY VARCHAR2,
118 p_cgmv_tbl IN cgmv_tbl_type,
119 x_cgmv_tbl OUT NOCOPY cgmv_tbl_type);
120
121 PROCEDURE delete_row(
122 p_api_version IN NUMBER,
123 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
124 x_return_status OUT NOCOPY VARCHAR2,
125 x_msg_count OUT NOCOPY NUMBER,
126 x_msg_data OUT NOCOPY VARCHAR2,
127 p_cgmv_rec IN cgmv_rec_type);
128
129 PROCEDURE delete_row(
130 p_api_version IN NUMBER,
131 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_cgmv_tbl IN cgmv_tbl_type);
136
137 PROCEDURE validate_row(
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_cgmv_rec IN cgmv_rec_type);
144
145 PROCEDURE validate_row(
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_cgmv_tbl IN cgmv_tbl_type);
152
153
154 PROCEDURE LOAD_SEED_ROW(
155 p_CNTX_GRP_PRMTR_ID IN VARCHAR2,
156 p_CGR_ID IN VARCHAR2,
157 p_PMR_ID IN VARCHAR2,
158 p_OBJECT_VERSION_NUMBER IN VARCHAR2,
159 p_OWNER IN VARCHAR2,
160 p_LAST_UPDATE_DATE IN VARCHAR2);
161
162
163 END OKL_CGM_PVT;