DBA Data[Home] [Help]

PACKAGE: APPS.OKL_CGR_PVT

Source


1 Package OKL_CGR_PVT AS
2 /* $Header: OKLSCGRS.pls 120.2 2006/12/07 06:14:25 ssdeshpa noship $ */
3   ---------------------------------------------------------------------------
4   -- GLOBAL DATASTRUCTURES
5   ---------------------------------------------------------------------------
6   TYPE cgr_rec_type IS RECORD (
7     id                             NUMBER := OKC_API.G_MISS_NUM,
8     name                           OKL_CONTEXT_GROUPS_B.NAME%TYPE := OKC_API.G_MISS_CHAR,
9     object_version_number          NUMBER := OKC_API.G_MISS_NUM,
10     created_by                     NUMBER := OKC_API.G_MISS_NUM,
11     creation_date                  OKL_CONTEXT_GROUPS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
12     last_updated_by                NUMBER := OKC_API.G_MISS_NUM,
13     last_update_date               OKL_CONTEXT_GROUPS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
14     last_update_login              NUMBER := OKC_API.G_MISS_NUM);
15   g_miss_cgr_rec                          cgr_rec_type;
16   TYPE cgr_tbl_type IS TABLE OF cgr_rec_type
17         INDEX BY BINARY_INTEGER;
18   TYPE okl_context_groups_tl_rec_type IS RECORD (
19     id                             NUMBER := OKC_API.G_MISS_NUM,
20     language                       OKL_CONTEXT_GROUPS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
21     source_lang                    OKL_CONTEXT_GROUPS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
22     sfwt_flag                      OKL_CONTEXT_GROUPS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
23     description                    OKL_CONTEXT_GROUPS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
24     created_by                     NUMBER := OKC_API.G_MISS_NUM,
25     creation_date                  OKL_CONTEXT_GROUPS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
26     last_updated_by                NUMBER := OKC_API.G_MISS_NUM,
27     last_update_date               OKL_CONTEXT_GROUPS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
28     last_update_login              NUMBER := OKC_API.G_MISS_NUM);
29   GMissOklContextGroupsTlRec              okl_context_groups_tl_rec_type;
30   TYPE okl_context_groups_tl_tbl_type IS TABLE OF okl_context_groups_tl_rec_type
31         INDEX BY BINARY_INTEGER;
32   TYPE cgrv_rec_type IS RECORD (
33     id                             NUMBER := OKC_API.G_MISS_NUM,
34     object_version_number          NUMBER := OKC_API.G_MISS_NUM,
35     sfwt_flag                      OKL_CONTEXT_GROUPS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
36     name                           OKL_CONTEXT_GROUPS_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
37     description                    OKL_CONTEXT_GROUPS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
38     created_by                     NUMBER := OKC_API.G_MISS_NUM,
39     creation_date                  OKL_CONTEXT_GROUPS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
40     last_updated_by                NUMBER := OKC_API.G_MISS_NUM,
41     last_update_date               OKL_CONTEXT_GROUPS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
42     last_update_login              NUMBER := OKC_API.G_MISS_NUM);
43   g_miss_cgrv_rec                         cgrv_rec_type;
44   TYPE cgrv_tbl_type IS TABLE OF cgrv_rec_type
45         INDEX BY BINARY_INTEGER;
46   ---------------------------------------------------------------------------
47   -- GLOBAL MESSAGE CONSTANTS
48   ---------------------------------------------------------------------------
49   G_FND_APP			CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
50   G_FORM_UNABLE_TO_RESERVE_REC	CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
51   G_FORM_RECORD_DELETED		CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
52   G_FORM_RECORD_CHANGED		CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
53   G_RECORD_LOGICALLY_DELETED	CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
54   G_REQUIRED_VALUE		CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
55   G_INVALID_VALUE			CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
56   G_COL_NAME_TOKEN		CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
57   G_PARENT_TABLE_TOKEN		CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
58   G_CHILD_TABLE_TOKEN		CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
59 
60   -- RPOONUGA001: Adding MESSAGE CONSTANTs for 'Unique Key Validation','SQLCode', 'SQLErrM','Unexpected Error'
61   G_SQLERRM_TOKEN             	CONSTANT VARCHAR2(200) := 'OKL_SQLERRM';
62   G_SQLCODE_TOKEN             	CONSTANT VARCHAR2(200) := 'OKL_SQLCODE';
63   G_TABLE_TOKEN             	CONSTANT VARCHAR2(200) := 'OKL_TABLE_NAME';
64   G_UNEXPECTED_ERROR          	CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
65   ---G_UNQS			            CONSTANT VARCHAR2(200) := 'OKL_CGR_NOT_UNIQUE'; --- CHG001
66   G_UNQS			            CONSTANT VARCHAR2(200) := 'OKL_NOT_UNIQUE';    --- CHG001
67 
68   ---------------------------------------------------------------------------
69   -- RPOONUGA001: EXCEPTION CONSTANTS
70   ---------------------------------------------------------------------------
71   G_EXCEPTION_HALT_VALIDATION	EXCEPTION;
72 
73   ---------------------------------------------------------------------------
74   -- GLOBAL VARIABLES
75   ---------------------------------------------------------------------------
76   G_PKG_NAME			CONSTANT VARCHAR2(200) := 'OKL_CGR_PVT';
77   G_APP_NAME			CONSTANT VARCHAR2(3)   :=  OKC_API.G_APP_NAME;
78   ---------------------------------------------------------------------------
79   -- Procedures and Functions
80   ---------------------------------------------------------------------------
81 
82   PROCEDURE qc;
83   PROCEDURE change_version;
84   PROCEDURE api_copy;
85   PROCEDURE add_language;
86   PROCEDURE insert_row(
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_cgrv_rec                     IN cgrv_rec_type,
93     x_cgrv_rec                     OUT NOCOPY cgrv_rec_type);
94 
95   PROCEDURE insert_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_cgrv_tbl                     IN cgrv_tbl_type,
102     x_cgrv_tbl                     OUT NOCOPY cgrv_tbl_type);
103 
104   PROCEDURE lock_row(
105     p_api_version                  IN NUMBER,
106     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
107     x_return_status                OUT NOCOPY VARCHAR2,
108     x_msg_count                    OUT NOCOPY NUMBER,
109     x_msg_data                     OUT NOCOPY VARCHAR2,
110     p_cgrv_rec                     IN cgrv_rec_type);
111 
112   PROCEDURE lock_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_cgrv_tbl                     IN cgrv_tbl_type);
119 
120   PROCEDURE update_row(
121     p_api_version                  IN NUMBER,
122     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
123     x_return_status                OUT NOCOPY VARCHAR2,
124     x_msg_count                    OUT NOCOPY NUMBER,
125     x_msg_data                     OUT NOCOPY VARCHAR2,
126     p_cgrv_rec                     IN cgrv_rec_type,
127     x_cgrv_rec                     OUT NOCOPY cgrv_rec_type);
128 
129   PROCEDURE update_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_cgrv_tbl                     IN cgrv_tbl_type,
136     x_cgrv_tbl                     OUT NOCOPY cgrv_tbl_type);
137 
138   PROCEDURE delete_row(
139     p_api_version                  IN NUMBER,
140     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
141     x_return_status                OUT NOCOPY VARCHAR2,
142     x_msg_count                    OUT NOCOPY NUMBER,
143     x_msg_data                     OUT NOCOPY VARCHAR2,
144     p_cgrv_rec                     IN cgrv_rec_type);
145 
146   PROCEDURE delete_row(
147     p_api_version                  IN NUMBER,
148     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
149     x_return_status                OUT NOCOPY VARCHAR2,
150     x_msg_count                    OUT NOCOPY NUMBER,
151     x_msg_data                     OUT NOCOPY VARCHAR2,
152     p_cgrv_tbl                     IN cgrv_tbl_type);
153 
154   PROCEDURE validate_row(
155     p_api_version                  IN NUMBER,
156     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
157     x_return_status                OUT NOCOPY VARCHAR2,
158     x_msg_count                    OUT NOCOPY NUMBER,
159     x_msg_data                     OUT NOCOPY VARCHAR2,
160     p_cgrv_rec                     IN cgrv_rec_type);
161 
162   PROCEDURE validate_row(
163     p_api_version                  IN NUMBER,
164     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
165     x_return_status                OUT NOCOPY VARCHAR2,
166     x_msg_count                    OUT NOCOPY NUMBER,
167     x_msg_data                     OUT NOCOPY VARCHAR2,
168     p_cgrv_tbl                     IN cgrv_tbl_type);
169 
170 
171   PROCEDURE LOAD_SEED_ROW(
172     p_upload_mode             IN VARCHAR2,
173     p_context_group_id        IN VARCHAR2,
174     p_name                    IN VARCHAR2,
175     p_object_version_number   IN VARCHAR2,
176     p_last_update_date        IN VARCHAR2,
177     p_owner                   IN VARCHAR2,
178     p_description             IN VARCHAR2);
179 
180 END OKL_CGR_PVT;