[Home] [Help]
PACKAGE: APPS.OKL_OVD_PVT
Source
1 Package OKL_OVD_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLSOVDS.pls 115.7 2002/02/05 12:18:19 pkm ship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 TYPE ovd_rec_type IS RECORD (
7 id NUMBER := OKC_API.G_MISS_NUM,
8 context_intent OKL_OPV_RULES.CONTEXT_INTENT%TYPE := OKC_API.G_MISS_CHAR,
9 orl_id NUMBER := OKC_API.G_MISS_NUM,
10 ove_id NUMBER := OKC_API.G_MISS_NUM,
11 copy_or_enter_flag OKL_OPV_RULES.COPY_OR_ENTER_FLAG%TYPE := OKC_API.G_MISS_CHAR,
12 object_version_number NUMBER := OKC_API.G_MISS_NUM,
13 context_inv_org NUMBER := OKC_API.G_MISS_NUM,
14 context_org NUMBER := OKC_API.G_MISS_NUM,
15 context_asset_book OKL_OPV_RULES.CONTEXT_ASSET_BOOK%TYPE := OKC_API.G_MISS_CHAR,
16 created_by NUMBER := OKC_API.G_MISS_NUM,
17 creation_date OKL_OPV_RULES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
18 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
19 last_update_date OKL_OPV_RULES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
20 individual_instructions OKL_OPV_RULES.INDIVIDUAL_INSTRUCTIONS%TYPE := OKC_API.G_MISS_CHAR,
21 last_update_login NUMBER := OKC_API.G_MISS_NUM);
22 g_miss_ovd_rec ovd_rec_type;
23 TYPE ovd_tbl_type IS TABLE OF ovd_rec_type
24 INDEX BY BINARY_INTEGER;
25 TYPE ovdv_rec_type IS RECORD (
26 id NUMBER := OKC_API.G_MISS_NUM,
27 context_intent OKL_OPV_RULES_V.CONTEXT_INTENT%TYPE := OKC_API.G_MISS_CHAR,
28 object_version_number NUMBER := OKC_API.G_MISS_NUM,
29 orl_id NUMBER := OKC_API.G_MISS_NUM,
30 ove_id NUMBER := OKC_API.G_MISS_NUM,
31 individual_instructions OKL_OPV_RULES_V.INDIVIDUAL_INSTRUCTIONS%TYPE := OKC_API.G_MISS_CHAR,
32 copy_or_enter_flag OKL_OPV_RULES_V.COPY_OR_ENTER_FLAG%TYPE := OKC_API.G_MISS_CHAR,
33 context_org NUMBER := OKC_API.G_MISS_NUM,
34 context_inv_org NUMBER := OKC_API.G_MISS_NUM,
35 context_asset_book OKL_OPV_RULES_V.CONTEXT_ASSET_BOOK%TYPE := OKC_API.G_MISS_CHAR,
36 created_by NUMBER := OKC_API.G_MISS_NUM,
37 creation_date OKL_OPV_RULES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
38 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
39 last_update_date OKL_OPV_RULES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
40 last_update_login NUMBER := OKC_API.G_MISS_NUM);
41 g_miss_ovdv_rec ovdv_rec_type;
42 TYPE ovdv_tbl_type IS TABLE OF ovdv_rec_type
43 INDEX BY BINARY_INTEGER;
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) := OKC_API.G_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
58 -- RPOONUGA001: Add new global variables
59 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
60 G_TABLE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_TABLE_NAME';
61 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLERRM';
62 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLCODE';
63 G_UNQS CONSTANT VARCHAR2(200) := 'OKL_NOT_UNIQUE';
64
65 -- RPOONUGA001: Add new exception
66 ---------------------------------------------------------------------------
67 -- GLOBAL EXCEPTION
68 ---------------------------------------------------------------------------
69 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
70 G_ITEM_NOT_FOUND_ERROR EXCEPTION;
71 ---------------------------------------------------------------------------
72 -- GLOBAL VARIABLES
73 ---------------------------------------------------------------------------
74 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_OVD_PVT';
75 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
76 -- RPOONUGA001: Add new global variables
77 G_LOOKUP_TYPE CONSTANT VARCHAR2(50) := 'OKL_OPTION_VALUE_RULE_FLAG';
78 G_INTENT_TYPE CONSTANT VARCHAR2(50) := 'OKL_INTENT_TYPE';
79 ---------------------------------------------------------------------------
80 -- Procedures and Functions
81 ---------------------------------------------------------------------------
82
83 PROCEDURE qc;
84 PROCEDURE change_version;
85 PROCEDURE api_copy;
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_ovdv_rec IN ovdv_rec_type,
93 x_ovdv_rec OUT NOCOPY ovdv_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_ovdv_tbl IN ovdv_tbl_type,
102 x_ovdv_tbl OUT NOCOPY ovdv_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_ovdv_rec IN ovdv_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_ovdv_tbl IN ovdv_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_ovdv_rec IN ovdv_rec_type,
127 x_ovdv_rec OUT NOCOPY ovdv_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_ovdv_tbl IN ovdv_tbl_type,
136 x_ovdv_tbl OUT NOCOPY ovdv_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_ovdv_rec IN ovdv_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_ovdv_tbl IN ovdv_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_ovdv_rec IN ovdv_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_ovdv_tbl IN ovdv_tbl_type);
169
170 END OKL_OVD_PVT;