DBA Data[Home] [Help]

PACKAGE: APPS.OKC_COE_PVT

Source


1 Package OKC_COE_PVT AS
2 /* $Header: OKCSCOES.pls 120.0 2005/05/25 18:52:27 appldev noship $ */
3   ---------------------------------------------------------------------------
4   -- GLOBAL DATASTRUCTURES
5   ---------------------------------------------------------------------------
6   TYPE coe_rec_type IS RECORD (
7     id                             NUMBER := OKC_API.G_MISS_NUM,
8     cnh_id                         NUMBER := OKC_API.G_MISS_NUM,
9     datetime                       OKC_CONDITION_OCCURS.DATETIME%TYPE := OKC_API.G_MISS_DATE,
10     object_version_number          NUMBER := OKC_API.G_MISS_NUM,
11     created_by                     NUMBER := OKC_API.G_MISS_NUM,
12     creation_date                  OKC_CONDITION_OCCURS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
13     last_updated_by                NUMBER := OKC_API.G_MISS_NUM,
14     last_update_date               OKC_CONDITION_OCCURS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
15     last_update_login              NUMBER := OKC_API.G_MISS_NUM);
16   g_miss_coe_rec                          coe_rec_type;
17   TYPE coe_tbl_type IS TABLE OF coe_rec_type
18         INDEX BY BINARY_INTEGER;
19   TYPE coev_rec_type IS RECORD (
20     id                             NUMBER := OKC_API.G_MISS_NUM,
21     cnh_id                         NUMBER := OKC_API.G_MISS_NUM,
22     object_version_number          NUMBER := OKC_API.G_MISS_NUM,
23     datetime                       OKC_CONDITION_OCCURS_V.DATETIME%TYPE := OKC_API.G_MISS_DATE,
24     created_by                     NUMBER := OKC_API.G_MISS_NUM,
25     creation_date                  OKC_CONDITION_OCCURS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
26     last_updated_by                NUMBER := OKC_API.G_MISS_NUM,
27     last_update_date               OKC_CONDITION_OCCURS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
28     last_update_login              NUMBER := OKC_API.G_MISS_NUM);
29   g_miss_coev_rec                         coev_rec_type;
30   TYPE coev_tbl_type IS TABLE OF coev_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_UNEXPECTED_ERROR		CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
46   G_SQLERRM_TOKEN   		CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
47   G_SQLCODE_TOKEN   		CONSTANT VARCHAR2(200) := 'ERROR_CODE';
48   G_UPPERCASE_REQUIRED		CONSTANT VARCHAR2(200) := 'OKC_UPPER_CASE_REQUIRED';
49   ---------------------------------------------------------------------------
50 
51   --GLOBAL EXCEPTION
52   ---------------------------------------------------------------------------
53   G_EXCEPTION_HALT_VALIDATION EXCEPTION;
54   ---------------------------------------------------------------------------
55 
56   -- GLOBAL VARIABLES
57   ---------------------------------------------------------------------------
58   G_PKG_NAME			CONSTANT VARCHAR2(200) := 'OKC_COE_PVT';
59   G_APP_NAME			CONSTANT VARCHAR2(3)   :=  OKC_API.G_APP_NAME;
60   ---------------------------------------------------------------------------
61   -- Procedures and Functions
62   ---------------------------------------------------------------------------
63 
64   PROCEDURE qc;
65   PROCEDURE change_version;
66   PROCEDURE api_copy;
67   PROCEDURE insert_row(
68     p_api_version                  IN NUMBER,
69     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
70     x_return_status                OUT NOCOPY VARCHAR2,
71     x_msg_count                    OUT NOCOPY NUMBER,
72     x_msg_data                     OUT NOCOPY VARCHAR2,
73     p_coev_rec                     IN coev_rec_type,
74     x_coev_rec                     OUT NOCOPY coev_rec_type);
75 
76   PROCEDURE insert_row(
77     p_api_version                  IN NUMBER,
78     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
79     x_return_status                OUT NOCOPY VARCHAR2,
80     x_msg_count                    OUT NOCOPY NUMBER,
81     x_msg_data                     OUT NOCOPY VARCHAR2,
82     p_coev_tbl                     IN coev_tbl_type,
83     x_coev_tbl                     OUT NOCOPY coev_tbl_type);
84 
85   PROCEDURE lock_row(
86     p_api_version                  IN NUMBER,
87     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
88     x_return_status                OUT NOCOPY VARCHAR2,
89     x_msg_count                    OUT NOCOPY NUMBER,
90     x_msg_data                     OUT NOCOPY VARCHAR2,
91     p_coev_rec                     IN coev_rec_type);
92 
93   PROCEDURE lock_row(
94     p_api_version                  IN NUMBER,
95     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
96     x_return_status                OUT NOCOPY VARCHAR2,
97     x_msg_count                    OUT NOCOPY NUMBER,
98     x_msg_data                     OUT NOCOPY VARCHAR2,
99     p_coev_tbl                     IN coev_tbl_type);
100 
101   PROCEDURE update_row(
102     p_api_version                  IN NUMBER,
103     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
104     x_return_status                OUT NOCOPY VARCHAR2,
105     x_msg_count                    OUT NOCOPY NUMBER,
106     x_msg_data                     OUT NOCOPY VARCHAR2,
107     p_coev_rec                     IN coev_rec_type,
108     x_coev_rec                     OUT NOCOPY coev_rec_type);
109 
110   PROCEDURE update_row(
111     p_api_version                  IN NUMBER,
112     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
113     x_return_status                OUT NOCOPY VARCHAR2,
114     x_msg_count                    OUT NOCOPY NUMBER,
115     x_msg_data                     OUT NOCOPY VARCHAR2,
116     p_coev_tbl                     IN coev_tbl_type,
117     x_coev_tbl                     OUT NOCOPY coev_tbl_type);
118 
119   PROCEDURE delete_row(
120     p_api_version                  IN NUMBER,
121     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
122     x_return_status                OUT NOCOPY VARCHAR2,
123     x_msg_count                    OUT NOCOPY NUMBER,
124     x_msg_data                     OUT NOCOPY VARCHAR2,
125     p_coev_rec                     IN coev_rec_type);
126 
127   PROCEDURE delete_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_coev_tbl                     IN coev_tbl_type);
134 
135   PROCEDURE validate_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_coev_rec                     IN coev_rec_type);
142 
143   PROCEDURE validate_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_coev_tbl                     IN coev_tbl_type);
150 
151   PROCEDURE INSERT_ROW_UPG(x_return_status OUT NOCOPY VARCHAR2, p_coev_tbl coev_tbl_type);
152 END OKC_COE_PVT;