DBA Data[Home] [Help]

PACKAGE: APPS.OKS_BSL_PVT

Source


1 Package OKS_BSL_PVT AS
2 /* $Header: OKSSBSLS.pls 120.1 2006/09/19 18:56:12 hvaladip noship $ */
3   ---------------------------------------------------------------------------
4   -- GLOBAL DATASTRUCTURES
5   ---------------------------------------------------------------------------
6   TYPE bsl_rec_type IS RECORD (
7     id                             NUMBER := OKC_API.G_MISS_NUM,
8     bcl_id                         NUMBER := OKC_API.G_MISS_NUM,
9     cle_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                  OKS_BILL_SUB_LINES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
13     last_updated_by                NUMBER := OKC_API.G_MISS_NUM,
14     last_update_date               OKS_BILL_SUB_LINES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
15     average                        NUMBER := OKC_API.G_MISS_NUM,
16     amount                         NUMBER := OKC_API.G_MISS_NUM,
17     manual_credit                  NUMBER := OKC_API.G_MISS_NUM,
18     date_billed_from               OKS_BILL_SUB_LINES.DATE_BILLED_FROM%TYPE := OKC_API.G_MISS_DATE,
19     date_billed_to                 OKS_BILL_SUB_LINES.DATE_BILLED_TO%TYPE := OKC_API.G_MISS_DATE,
20     date_to_interface	           OKS_BILL_SUB_LINES.DATE_TO_INTERFACE%TYPE   := OKC_API.G_MISS_DATE,
21     last_update_login              NUMBER := OKC_API.G_MISS_NUM,
22     attribute_category             OKS_BILL_SUB_LINES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
23     attribute1                     OKS_BILL_SUB_LINES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
24     attribute2                     OKS_BILL_SUB_LINES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
25     attribute3                     OKS_BILL_SUB_LINES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
26     attribute4                     OKS_BILL_SUB_LINES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
27     attribute5                     OKS_BILL_SUB_LINES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
28     attribute6                     OKS_BILL_SUB_LINES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
29     attribute7                     OKS_BILL_SUB_LINES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
30     attribute8                     OKS_BILL_SUB_LINES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
31     attribute9                     OKS_BILL_SUB_LINES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
32     attribute10                    OKS_BILL_SUB_LINES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
33     attribute11                    OKS_BILL_SUB_LINES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
34     attribute12                    OKS_BILL_SUB_LINES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
35     attribute13                    OKS_BILL_SUB_LINES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
36     attribute14                    OKS_BILL_SUB_LINES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
37     attribute15                    OKS_BILL_SUB_LINES.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
38   g_miss_bsl_rec                          bsl_rec_type;
39   TYPE bsl_tbl_type IS TABLE OF bsl_rec_type
40         INDEX BY BINARY_INTEGER;
41   TYPE bslv_rec_type IS RECORD (
42     id                             NUMBER := OKC_API.G_MISS_NUM,
43     object_version_number          NUMBER := OKC_API.G_MISS_NUM,
44     bcl_id                         NUMBER := OKC_API.G_MISS_NUM,
45     cle_id                         NUMBER := OKC_API.G_MISS_NUM,
46     average                        NUMBER := OKC_API.G_MISS_NUM,
47     amount                         NUMBER := OKC_API.G_MISS_NUM,
48     manual_credit                  NUMBER := OKC_API.G_MISS_NUM,
49     date_billed_from               OKS_BILL_SUB_LINES_V.DATE_BILLED_FROM%TYPE := OKC_API.G_MISS_DATE,
50     date_billed_to                 OKS_BILL_SUB_LINES_V.DATE_BILLED_TO%TYPE := OKC_API.G_MISS_DATE,
51     date_to_interface              OKS_BILL_SUB_LINES_V.DATE_TO_INTERFACE%TYPE := OKC_API.G_MISS_DATE,
52     attribute_category             OKS_BILL_SUB_LINES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
53     attribute1                     OKS_BILL_SUB_LINES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
54     attribute2                     OKS_BILL_SUB_LINES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
55     attribute3                     OKS_BILL_SUB_LINES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
56     attribute4                     OKS_BILL_SUB_LINES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
57     attribute5                     OKS_BILL_SUB_LINES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
58     attribute6                     OKS_BILL_SUB_LINES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
59     attribute7                     OKS_BILL_SUB_LINES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
60     attribute8                     OKS_BILL_SUB_LINES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
61     attribute9                     OKS_BILL_SUB_LINES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
62     attribute10                    OKS_BILL_SUB_LINES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
63     attribute11                    OKS_BILL_SUB_LINES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
64     attribute12                    OKS_BILL_SUB_LINES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
65     attribute13                    OKS_BILL_SUB_LINES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
66     attribute14                    OKS_BILL_SUB_LINES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
67     attribute15                    OKS_BILL_SUB_LINES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
68     created_by                     NUMBER := OKC_API.G_MISS_NUM,
69     creation_date                  OKS_BILL_SUB_LINES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
70     last_updated_by                NUMBER := OKC_API.G_MISS_NUM,
71     last_update_date               OKS_BILL_SUB_LINES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
72     last_update_login              NUMBER := OKC_API.G_MISS_NUM);
73   g_miss_bslv_rec                         bslv_rec_type;
74   TYPE bslv_tbl_type IS TABLE OF bslv_rec_type
75         INDEX BY BINARY_INTEGER;
76   ---------------------------------------------------------------------------
77   -- GLOBAL MESSAGE CONSTANTS
78   ---------------------------------------------------------------------------
79   G_FND_APP			CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
80   G_FORM_UNABLE_TO_RESERVE_REC	CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
81   G_FORM_RECORD_DELETED		CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
82   G_FORM_RECORD_CHANGED		CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
83   G_RECORD_LOGICALLY_DELETED	CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
84   G_REQUIRED_VALUE		CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
85   G_INVALID_VALUE			CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
86   G_COL_NAME_TOKEN		CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
87   G_PARENT_TABLE_TOKEN		CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
88   G_CHILD_TABLE_TOKEN		CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
89   G_UNEXPECTED_ERROR          CONSTANT VARCHAR2(200) := 'OKS_CONTRACTS_UNEXPECTED_ERROR';
90   G_SQLCODE_TOKEN              CONSTANT VARCHAR2(200) := 'SQLcode';
91   G_SQLERRM_TOKEN              CONSTANT VARCHAR2(200) := 'SQLerrm';
92   ---------------------------------------------------------------------------
93 	   -- GLOBAL EXCEPTIONS
94   ---------------------------------------------------------------------------
95    G_EXCEPTION_HALT_VALIDATION 	EXCEPTION;
96 
97   ---------------------------------------------------------------------------
98   -- GLOBAL VARIABLES
99   ---------------------------------------------------------------------------
100   G_PKG_NAME			CONSTANT VARCHAR2(200) := 'OKS_BSL_PVT';
101   G_APP_NAME			CONSTANT VARCHAR2(3)   :=  OKC_API.G_APP_NAME;
102   ---------------------------------------------------------------------------
103   -- Procedures and Functions
104   ---------------------------------------------------------------------------
105 
106   PROCEDURE qc;
107   PROCEDURE change_version;
108   PROCEDURE api_copy;
109   PROCEDURE insert_row(
110     p_api_version                  IN NUMBER,
111     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
112     x_return_status                OUT NOCOPY VARCHAR2,
113     x_msg_count                    OUT NOCOPY NUMBER,
114     x_msg_data                     OUT NOCOPY VARCHAR2,
115     p_bslv_rec                     IN bslv_rec_type,
116     x_bslv_rec                     OUT NOCOPY bslv_rec_type);
117 
118   PROCEDURE insert_row(
119     p_api_version                  IN NUMBER,
120     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
121     x_return_status                OUT NOCOPY VARCHAR2,
122     x_msg_count                    OUT NOCOPY NUMBER,
123     x_msg_data                     OUT NOCOPY VARCHAR2,
124     p_bslv_tbl                     IN bslv_tbl_type,
125     x_bslv_tbl                     OUT NOCOPY bslv_tbl_type);
126 
127   PROCEDURE lock_row(
128     p_api_version                  IN NUMBER,
129     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
130     x_return_status                OUT NOCOPY VARCHAR2,
131     x_msg_count                    OUT NOCOPY NUMBER,
132     x_msg_data                     OUT NOCOPY VARCHAR2,
133     p_bslv_rec                     IN bslv_rec_type);
134 
135   PROCEDURE lock_row(
136     p_api_version                  IN NUMBER,
137     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
138     x_return_status                OUT NOCOPY VARCHAR2,
139     x_msg_count                    OUT NOCOPY NUMBER,
140     x_msg_data                     OUT NOCOPY VARCHAR2,
141     p_bslv_tbl                     IN bslv_tbl_type);
142 
143   PROCEDURE update_row(
144     p_api_version                  IN NUMBER,
145     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
146     x_return_status                OUT NOCOPY VARCHAR2,
147     x_msg_count                    OUT NOCOPY NUMBER,
148     x_msg_data                     OUT NOCOPY VARCHAR2,
149     p_bslv_rec                     IN bslv_rec_type,
150     x_bslv_rec                     OUT NOCOPY bslv_rec_type);
151 
152   PROCEDURE update_row(
153     p_api_version                  IN NUMBER,
154     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
155     x_return_status                OUT NOCOPY VARCHAR2,
156     x_msg_count                    OUT NOCOPY NUMBER,
157     x_msg_data                     OUT NOCOPY VARCHAR2,
158     p_bslv_tbl                     IN bslv_tbl_type,
159     x_bslv_tbl                     OUT NOCOPY bslv_tbl_type);
160 
161   PROCEDURE delete_row(
162     p_api_version                  IN NUMBER,
163     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
164     x_return_status                OUT NOCOPY VARCHAR2,
165     x_msg_count                    OUT NOCOPY NUMBER,
166     x_msg_data                     OUT NOCOPY VARCHAR2,
167     p_bslv_rec                     IN bslv_rec_type);
168 
169   PROCEDURE delete_row(
170     p_api_version                  IN NUMBER,
171     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
172     x_return_status                OUT NOCOPY VARCHAR2,
173     x_msg_count                    OUT NOCOPY NUMBER,
174     x_msg_data                     OUT NOCOPY VARCHAR2,
175     p_bslv_tbl                     IN bslv_tbl_type);
176 
177   PROCEDURE validate_row(
178     p_api_version                  IN NUMBER,
179     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
180     x_return_status                OUT NOCOPY VARCHAR2,
181     x_msg_count                    OUT NOCOPY NUMBER,
182     x_msg_data                     OUT NOCOPY VARCHAR2,
183     p_bslv_rec                     IN bslv_rec_type);
184 
185   PROCEDURE validate_row(
186     p_api_version                  IN NUMBER,
187     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
188     x_return_status                OUT NOCOPY VARCHAR2,
189     x_msg_count                    OUT NOCOPY NUMBER,
190     x_msg_data                     OUT NOCOPY VARCHAR2,
191     p_bslv_tbl                     IN bslv_tbl_type);
192 
193 END OKS_BSL_PVT;