[Home] [Help]
PACKAGE: APPS.OKL_PIT_PVT
Source
1 PACKAGE OKL_PIT_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLSPITS.pls 115.9 2002/06/14 17:01:46 pkm ship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 TYPE pit_rec_type IS RECORD (
7 id NUMBER := Okc_Api.G_MISS_NUM,
8 pdt_id NUMBER := Okc_Api.G_MISS_NUM,
9 template_name OKL_PRD_PRICE_TMPLS.TEMPLATE_NAME%TYPE := Okc_Api.G_MISS_CHAR,
10 -- mvasudev, 05/13/2002
11 template_path OKL_PRD_PRICE_TMPLS.TEMPLATE_PATH%TYPE := Okc_Api.G_MISS_CHAR,
12 --
13 version OKL_PRD_PRICE_TMPLS.VERSION%TYPE := Okc_Api.G_MISS_CHAR,
14 start_date OKL_PRD_PRICE_TMPLS.START_DATE%TYPE := Okc_Api.G_MISS_DATE,
15 object_version_number NUMBER := Okc_Api.G_MISS_NUM,
16 end_date OKL_PRD_PRICE_TMPLS.END_DATE%TYPE := Okc_Api.G_MISS_DATE,
17 description OKL_PRD_PRICE_TMPLS.DESCRIPTION%TYPE := Okc_Api.G_MISS_CHAR,
18 created_by NUMBER := Okc_Api.G_MISS_NUM,
19 creation_date OKL_PRD_PRICE_TMPLS.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
20 last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
21 last_update_date OKL_PRD_PRICE_TMPLS.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
22 last_update_login NUMBER := Okc_Api.G_MISS_NUM);
23 g_miss_pit_rec pit_rec_type;
24 TYPE pit_tbl_type IS TABLE OF pit_rec_type
25 INDEX BY BINARY_INTEGER;
26 TYPE pitv_rec_type IS RECORD (
27 id NUMBER := Okc_Api.G_MISS_NUM,
28 object_version_number NUMBER := Okc_Api.G_MISS_NUM,
29 pdt_id NUMBER := Okc_Api.G_MISS_NUM,
30 template_name OKL_PRD_PRICE_TMPLS_V.TEMPLATE_NAME%TYPE := Okc_Api.G_MISS_CHAR,
31 -- mvasudev, 05/13/2002
32 template_path OKL_PRD_PRICE_TMPLS_V.TEMPLATE_PATH%TYPE := Okc_Api.G_MISS_CHAR,
33 --
34 version OKL_PRD_PRICE_TMPLS_V.VERSION%TYPE := Okc_Api.G_MISS_CHAR,
35 start_date OKL_PRD_PRICE_TMPLS_V.START_DATE%TYPE := Okc_Api.G_MISS_DATE,
36 end_date OKL_PRD_PRICE_TMPLS_V.END_DATE%TYPE := Okc_Api.G_MISS_DATE,
37 description OKL_PRD_PRICE_TMPLS_V.DESCRIPTION%TYPE := Okc_Api.G_MISS_CHAR,
38 created_by NUMBER := Okc_Api.G_MISS_NUM,
39 creation_date OKL_PRD_PRICE_TMPLS_V.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
40 last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
41 last_update_date OKL_PRD_PRICE_TMPLS_V.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
42 last_update_login NUMBER := Okc_Api.G_MISS_NUM);
43 g_miss_pitv_rec pitv_rec_type;
44 TYPE pitv_tbl_type IS TABLE OF pitv_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_OKC_APP CONSTANT VARCHAR2(200) := Okc_Api.G_APP_NAME;
51 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_UNABLE_TO_RESERVE_REC;
52 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_DELETED;
53 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_CHANGED;
54 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_RECORD_LOGICALLY_DELETED;
55 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
56 G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_INVALID_VALUE;
57 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_COL_NAME_TOKEN;
58 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_PARENT_TABLE_TOKEN;
59 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_CHILD_TABLE_TOKEN;
60
61 -- START CHANGE : akjain -- 05/07/2001
62 -- Adding MESSAGE CONSTANTs for 'Unique Key Validation','SQLCode', 'SQLErrM','Unexpected Error'
63 G_OKL_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLerrm';
64 G_OKL_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLcode';
65 G_OKL_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
66 G_OKL_UNQS CONSTANT VARCHAR2(200) := 'OKL_PIT_NOT_UNIQUE';
67
68 -- Added Exception for Halt_validation
69 --------------------------------------------------------------------------------
70 -- ERRORS AND EXCEPTIONS
71 --------------------------------------------------------------------------------
72 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
73 -- END change : akjain
74
75
76
77 ---------------------------------------------------------------------------
78 -- GLOBAL VARIABLES
79 ---------------------------------------------------------------------------
80 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_PIT_PVT';
81 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
82 ---------------------------------------------------------------------------
83 -- Procedures and Functions
84 ---------------------------------------------------------------------------
85
86 PROCEDURE qc;
87 PROCEDURE change_version;
88 PROCEDURE api_copy;
89 PROCEDURE insert_row(
90 p_api_version IN NUMBER,
91 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
92 x_return_status OUT NOCOPY VARCHAR2,
93 x_msg_count OUT NOCOPY NUMBER,
94 x_msg_data OUT NOCOPY VARCHAR2,
95 p_pitv_rec IN pitv_rec_type,
96 x_pitv_rec OUT NOCOPY pitv_rec_type);
97
98 PROCEDURE insert_row(
99 p_api_version IN NUMBER,
100 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
101 x_return_status OUT NOCOPY VARCHAR2,
102 x_msg_count OUT NOCOPY NUMBER,
103 x_msg_data OUT NOCOPY VARCHAR2,
104 p_pitv_tbl IN pitv_tbl_type,
105 x_pitv_tbl OUT NOCOPY pitv_tbl_type);
106
107 PROCEDURE lock_row(
108 p_api_version IN NUMBER,
109 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
110 x_return_status OUT NOCOPY VARCHAR2,
111 x_msg_count OUT NOCOPY NUMBER,
112 x_msg_data OUT NOCOPY VARCHAR2,
113 p_pitv_rec IN pitv_rec_type);
114
115 PROCEDURE lock_row(
116 p_api_version IN NUMBER,
117 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
118 x_return_status OUT NOCOPY VARCHAR2,
119 x_msg_count OUT NOCOPY NUMBER,
120 x_msg_data OUT NOCOPY VARCHAR2,
121 p_pitv_tbl IN pitv_tbl_type);
122
123 PROCEDURE update_row(
124 p_api_version IN NUMBER,
125 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
126 x_return_status OUT NOCOPY VARCHAR2,
127 x_msg_count OUT NOCOPY NUMBER,
128 x_msg_data OUT NOCOPY VARCHAR2,
129 p_pitv_rec IN pitv_rec_type,
130 x_pitv_rec OUT NOCOPY pitv_rec_type);
131
132 PROCEDURE update_row(
133 p_api_version IN NUMBER,
134 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
135 x_return_status OUT NOCOPY VARCHAR2,
136 x_msg_count OUT NOCOPY NUMBER,
137 x_msg_data OUT NOCOPY VARCHAR2,
138 p_pitv_tbl IN pitv_tbl_type,
139 x_pitv_tbl OUT NOCOPY pitv_tbl_type);
140
141 PROCEDURE delete_row(
142 p_api_version IN NUMBER,
143 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
144 x_return_status OUT NOCOPY VARCHAR2,
145 x_msg_count OUT NOCOPY NUMBER,
146 x_msg_data OUT NOCOPY VARCHAR2,
147 p_pitv_rec IN pitv_rec_type);
148
149 PROCEDURE delete_row(
150 p_api_version IN NUMBER,
151 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
152 x_return_status OUT NOCOPY VARCHAR2,
153 x_msg_count OUT NOCOPY NUMBER,
154 x_msg_data OUT NOCOPY VARCHAR2,
155 p_pitv_tbl IN pitv_tbl_type);
156
157 PROCEDURE validate_row(
158 p_api_version IN NUMBER,
159 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
160 x_return_status OUT NOCOPY VARCHAR2,
161 x_msg_count OUT NOCOPY NUMBER,
162 x_msg_data OUT NOCOPY VARCHAR2,
163 p_pitv_rec IN pitv_rec_type);
164
165 PROCEDURE validate_row(
166 p_api_version IN NUMBER,
167 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
168 x_return_status OUT NOCOPY VARCHAR2,
169 x_msg_count OUT NOCOPY NUMBER,
170 x_msg_data OUT NOCOPY VARCHAR2,
171 p_pitv_tbl IN pitv_tbl_type);
172
173 END Okl_Pit_Pvt;