[Home] [Help]
PACKAGE: APPS.OKC_SCR_PVT
Source
1 PACKAGE OKC_SCR_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKCRSCRS.pls 120.0 2005/05/25 19:14:02 appldev noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 TYPE scr_rec_type IS RECORD (
7 id NUMBER := OKC_API.G_MISS_NUM,
8 percent NUMBER := OKC_API.G_MISS_NUM,
9
10 chr_id NUMBER := OKC_API.G_MISS_NUM,
11 dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
12
13 cle_id NUMBER := OKC_API.G_MISS_NUM,
14
15 --ctc_id NUMBER := OKC_API.G_MISS_NUM,
16 --replaced by SALESREP_ID1, SALESREP_ID2
17 SALESREP_ID1 OKC_K_SALES_CREDITS.SALESREP_ID1%TYPE := OKC_API.G_MISS_CHAR,
18 SALESREP_ID2 OKC_K_SALES_CREDITS.SALESREP_ID2%TYPE := OKC_API.G_MISS_CHAR,
19
20 sales_credit_type_id1 OKC_K_SALES_CREDITS.SALES_CREDIT_TYPE_ID1%TYPE := OKC_API.G_MISS_CHAR,
21 sales_credit_type_id2 OKC_K_SALES_CREDITS.SALES_CREDIT_TYPE_ID2%TYPE := OKC_API.G_MISS_CHAR,
22 object_version_number NUMBER := OKC_API.G_MISS_NUM,
23 created_by NUMBER := OKC_API.G_MISS_NUM,
24 creation_date OKC_K_SALES_CREDITS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
25 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
26 last_update_date OKC_K_SALES_CREDITS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE);
27 g_miss_scr_rec scr_rec_type;
28 TYPE scr_tbl_type IS TABLE OF scr_rec_type
29 INDEX BY BINARY_INTEGER;
30 TYPE scrv_rec_type IS RECORD (
31 id NUMBER := OKC_API.G_MISS_NUM,
32 percent NUMBER := OKC_API.G_MISS_NUM,
33
34 chr_id NUMBER := OKC_API.G_MISS_NUM,
35 dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
36
37 cle_id NUMBER := OKC_API.G_MISS_NUM,
38
39 --ctc_id NUMBER := OKC_API.G_MISS_NUM,
40 --replaced by SALESREP_ID1, SALESREP_ID2
41 SALESREP_ID1 OKC_K_SALES_CREDITS.SALESREP_ID1%TYPE := OKC_API.G_MISS_CHAR,
42 SALESREP_ID2 OKC_K_SALES_CREDITS.SALESREP_ID2%TYPE := OKC_API.G_MISS_CHAR,
43
44 sales_credit_type_id1 OKC_K_SALES_CREDITS.SALES_CREDIT_TYPE_ID1%TYPE := OKC_API.G_MISS_CHAR,
45 sales_credit_type_id2 OKC_K_SALES_CREDITS.SALES_CREDIT_TYPE_ID2%TYPE := OKC_API.G_MISS_CHAR,
46 object_version_number NUMBER := OKC_API.G_MISS_NUM,
47 created_by NUMBER := OKC_API.G_MISS_NUM,
48 creation_date OKC_K_SALES_CREDITS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
49 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
50 last_update_date OKC_K_SALES_CREDITS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE);
51 G_Miss_SCRV_REC scrv_rec_type;
52 TYPE scrv_tbl_type IS TABLE OF scrv_rec_type
53 INDEX BY BINARY_INTEGER;
54 ---------------------------------------------------------------------------
55 -- GLOBAL MESSAGE CONSTANTS
56 ---------------------------------------------------------------------------
57 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
58 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
59 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
60 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
61 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
62 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
63 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
64 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
65 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
66 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
67 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_SALES_CREDITS_UNEXPECTED_ERROR';
68 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
69 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
70 ---------------------------------------------------------------------------
71 -- GLOBAL EXCEPTIONS
72 ---------------------------------------------------------------------------
73 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
74
75 ---------------------------------------------------------------------------
76 -- GLOBAL VARIABLES
77 ---------------------------------------------------------------------------
78 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_SCR_PVT';
79 ---G_APP_NAME CONSTANT VARCHAR2(3) := OKO_DATATYPES.G_APP_NAME;
80 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
81 ---------------------------------------------------------------------------
82 -- Procedures and Functions
83 ---------------------------------------------------------------------------
84
85 PROCEDURE qc;
86 PROCEDURE change_version;
87 PROCEDURE api_copy;
88 PROCEDURE insert_row(
89 p_api_version IN NUMBER,
90 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
91 x_return_status OUT NOCOPY VARCHAR2,
92 x_msg_count OUT NOCOPY NUMBER,
93 x_msg_data OUT NOCOPY VARCHAR2,
94 p_scrv_rec IN scrv_rec_type,
95 x_scrv_rec OUT NOCOPY scrv_rec_type);
96
97 PROCEDURE insert_row(
98 p_api_version IN NUMBER,
99 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
100 x_return_status OUT NOCOPY VARCHAR2,
101 x_msg_count OUT NOCOPY NUMBER,
102 x_msg_data OUT NOCOPY VARCHAR2,
103 p_scrv_tbl IN scrv_tbl_type,
104 x_scrv_tbl OUT NOCOPY scrv_tbl_type);
105
106 PROCEDURE lock_row(
107 p_api_version IN NUMBER,
108 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
109 x_return_status OUT NOCOPY VARCHAR2,
110 x_msg_count OUT NOCOPY NUMBER,
111 x_msg_data OUT NOCOPY VARCHAR2,
112 p_scrv_rec IN scrv_rec_type);
113
114 PROCEDURE lock_row(
115 p_api_version IN NUMBER,
116 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
117 x_return_status OUT NOCOPY VARCHAR2,
118 x_msg_count OUT NOCOPY NUMBER,
119 x_msg_data OUT NOCOPY VARCHAR2,
120 p_scrv_tbl IN scrv_tbl_type);
121
122 PROCEDURE update_row(
123 p_api_version IN NUMBER,
124 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
125 x_return_status OUT NOCOPY VARCHAR2,
126 x_msg_count OUT NOCOPY NUMBER,
127 x_msg_data OUT NOCOPY VARCHAR2,
128 p_scrv_rec IN scrv_rec_type,
129 x_scrv_rec OUT NOCOPY scrv_rec_type);
130
131 PROCEDURE update_row(
132 p_api_version IN NUMBER,
133 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
134 x_return_status OUT NOCOPY VARCHAR2,
135 x_msg_count OUT NOCOPY NUMBER,
136 x_msg_data OUT NOCOPY VARCHAR2,
137 p_scrv_tbl IN scrv_tbl_type,
138 x_scrv_tbl OUT NOCOPY scrv_tbl_type);
139
140 PROCEDURE delete_row(
141 p_api_version IN NUMBER,
142 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
143 x_return_status OUT NOCOPY VARCHAR2,
144 x_msg_count OUT NOCOPY NUMBER,
145 x_msg_data OUT NOCOPY VARCHAR2,
146 p_scrv_rec IN scrv_rec_type);
147
148 PROCEDURE delete_row(
149 p_api_version IN NUMBER,
150 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
151 x_return_status OUT NOCOPY VARCHAR2,
152 x_msg_count OUT NOCOPY NUMBER,
153 x_msg_data OUT NOCOPY VARCHAR2,
154 p_scrv_tbl IN scrv_tbl_type);
155
156 PROCEDURE validate_row(
157 p_api_version IN NUMBER,
158 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
159 x_return_status OUT NOCOPY VARCHAR2,
160 x_msg_count OUT NOCOPY NUMBER,
161 x_msg_data OUT NOCOPY VARCHAR2,
162 p_scrv_rec IN scrv_rec_type);
163
164 PROCEDURE validate_row(
165 p_api_version IN NUMBER,
166 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
167 x_return_status OUT NOCOPY VARCHAR2,
168 x_msg_count OUT NOCOPY NUMBER,
169 x_msg_data OUT NOCOPY VARCHAR2,
170 p_scrv_tbl IN scrv_tbl_type);
171
172
173 FUNCTION create_version(
174 p_chr_id IN NUMBER,
175 p_major_version IN NUMBER) RETURN VARCHAR2;
176
177 FUNCTION restore_version(
178 p_chr_id IN NUMBER,
179 p_major_version IN NUMBER) RETURN VARCHAR2;
180
181 END OKC_SCR_PVT;