[Home] [Help]
PACKAGE: APPS.OKE_FORM_PVT
Source
1 PACKAGE OKE_FORM_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKEVKPFS.pls 115.5 2002/08/14 01:45:18 alaw ship $*/
3
4 -- GLOBAL DATA STRUCTURES
5
6 TYPE form_rec_type IS RECORD(
7
8 K_HEADER_ID NUMBER:= OKE_API.G_MISS_NUM,
9 K_LINE_ID NUMBER:= OKE_API.G_MISS_NUM,
10 PRINT_FORM_CODE OKE_K_PRINT_FORMS.PRINT_FORM_CODE%TYPE:=OKE_API.G_MISS_CHAR,
11 CREATION_DATE DATE:= OKE_API.G_MISS_DATE,
12 CREATED_BY NUMBER:= OKE_API.G_MISS_NUM,
13 LAST_UPDATE_DATE DATE:= OKE_API.G_MISS_DATE,
14 LAST_UPDATED_BY NUMBER:= OKE_API.G_MISS_NUM,
15 LAST_UPDATE_LOGIN NUMBER:= OKE_API.G_MISS_NUM,
16 REQUIRED_FLAG OKE_K_PRINT_FORMS.REQUIRED_FLAG%TYPE:=OKE_API.G_MISS_CHAR,
17 CUSTOMER_FURNISHED_FLAG OKE_K_PRINT_FORMS.CUSTOMER_FURNISHED_FLAG%TYPE:=OKE_API.G_MISS_CHAR,
18 COMPLETED_FLAG OKE_K_PRINT_FORMS.COMPLETED_FLAG%TYPE:=OKE_API.G_MISS_CHAR,
19 ATTRIBUTE_CATEGORY OKE_K_PRINT_FORMS.ATTRIBUTE_CATEGORY%TYPE:=OKE_API.G_MISS_CHAR,
20 ATTRIBUTE1 OKE_K_PRINT_FORMS.ATTRIBUTE1%TYPE:=OKE_API.G_MISS_CHAR,
21 ATTRIBUTE2 OKE_K_PRINT_FORMS.ATTRIBUTE2%TYPE:=OKE_API.G_MISS_CHAR,
22 ATTRIBUTE3 OKE_K_PRINT_FORMS.ATTRIBUTE3%TYPE:=OKE_API.G_MISS_CHAR,
23 ATTRIBUTE4 OKE_K_PRINT_FORMS.ATTRIBUTE4%TYPE:=OKE_API.G_MISS_CHAR,
24 ATTRIBUTE5 OKE_K_PRINT_FORMS.ATTRIBUTE5%TYPE:=OKE_API.G_MISS_CHAR,
25 ATTRIBUTE6 OKE_K_PRINT_FORMS.ATTRIBUTE6%TYPE:=OKE_API.G_MISS_CHAR,
26 ATTRIBUTE7 OKE_K_PRINT_FORMS.ATTRIBUTE7%TYPE:=OKE_API.G_MISS_CHAR,
27 ATTRIBUTE8 OKE_K_PRINT_FORMS.ATTRIBUTE8%TYPE:=OKE_API.G_MISS_CHAR,
28 ATTRIBUTE9 OKE_K_PRINT_FORMS.ATTRIBUTE9%TYPE:=OKE_API.G_MISS_CHAR,
29 ATTRIBUTE10 OKE_K_PRINT_FORMS.ATTRIBUTE10%TYPE:=OKE_API.G_MISS_CHAR,
30 ATTRIBUTE11 OKE_K_PRINT_FORMS.ATTRIBUTE11%TYPE:=OKE_API.G_MISS_CHAR,
31 ATTRIBUTE12 OKE_K_PRINT_FORMS.ATTRIBUTE12%TYPE:=OKE_API.G_MISS_CHAR,
32 ATTRIBUTE13 OKE_K_PRINT_FORMS.ATTRIBUTE13%TYPE:=OKE_API.G_MISS_CHAR,
33 ATTRIBUTE14 OKE_K_PRINT_FORMS.ATTRIBUTE14%TYPE:=OKE_API.G_MISS_CHAR,
34 ATTRIBUTE15 OKE_K_PRINT_FORMS.ATTRIBUTE15%TYPE:=OKE_API.G_MISS_CHAR
35
36 );
37
38 TYPE form_tbl_type IS TABLE OF form_rec_type
39 INDEX BY BINARY_INTEGER;
40
41 -- GLOBAL MESSAGE CONSTANTS
42
43 G_FND_APP CONSTANT VARCHAR2(200) := OKE_API.G_FND_APP;
44
45 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKE_API.G_FORM_UNABLE_TO_RESERVE_REC;
46 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKE_API.G_FORM_RECORD_DELETED;
47
48 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKE_API.G_FORM_RECORD_CHANGED;
49
50 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKE_API.G_RECORD_LOGICALLY_DELETED;
51 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKE_API.G_REQUIRED_VALUE;
52 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKE_API.G_INVALID_VALUE;
53 G_CHILD_RECORD_FOUND CONSTANT VARCHAR2(200) := OKE_API.G_CHILD_RECORD_FOUND;
54 G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := OKE_API.G_NO_PARENT_RECORD;
55 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := OKE_API.G_UNEXPECTED_ERROR;
56
57 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_COL_NAME_TOKEN;
58 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_PARENT_TABLE_TOKEN;
59 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_CHILD_TABLE_TOKEN;
60 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_SQLERRM_TOKEN;
61 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_SQLCODE_TOKEN;
62 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKE_FORM_PVT';
63 G_APP_NAME CONSTANT VARCHAR2(3) := OKE_API.G_APP_NAME;
64 G_VIEW CONSTANT VARCHAR2(200) := 'OKE_K_PRINT_FORMS_V';
65
66 G_EXCEPTION_HALT_VALIDATION exception;
67
68 -- Procedures and functions
69
70 PROCEDURE insert_row(
71 p_api_version IN NUMBER,
72 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
73 x_return_status OUT NOCOPY VARCHAR2,
74 x_msg_count OUT NOCOPY NUMBER,
75 x_msg_data OUT NOCOPY VARCHAR2,
76 p_form_rec IN form_rec_type,
77 x_form_rec OUT NOCOPY form_rec_type);
78
79 PROCEDURE insert_row(
80 p_api_version IN NUMBER,
81 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
82 x_return_status OUT NOCOPY VARCHAR2,
83 x_msg_count OUT NOCOPY NUMBER,
84 x_msg_data OUT NOCOPY VARCHAR2,
85 p_form_tbl IN form_tbl_type,
86 x_form_tbl OUT NOCOPY form_tbl_type);
87
88 PROCEDURE update_row(
89 p_api_version IN NUMBER,
90 p_init_msg_list IN VARCHAR2 DEFAULT OKE_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_form_rec IN form_rec_type,
95 x_form_rec OUT NOCOPY form_rec_type);
96
97 PROCEDURE update_row(
98 p_api_version IN NUMBER,
99 p_init_msg_list IN VARCHAR2 DEFAULT OKE_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_form_tbl IN form_tbl_type,
104 x_form_tbl OUT NOCOPY form_tbl_type);
105
106 PROCEDURE delete_row(
107 p_api_version IN NUMBER,
108 p_init_msg_list IN VARCHAR2 DEFAULT OKE_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_cle_id IN NUMBER,
113 p_pfm_cd OKE_K_PRINT_FORMS.PRINT_FORM_CODE%TYPE);
114
115
116 /* note: does not cascade into lines */
117
118 PROCEDURE delete_row(
119 p_api_version IN NUMBER,
120 p_init_msg_list IN VARCHAR2 DEFAULT OKE_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_chr_id IN NUMBER,
125 p_pfm_cd OKE_K_PRINT_FORMS.PRINT_FORM_CODE%TYPE);
126
127
128 PROCEDURE delete_row(
129 p_api_version IN NUMBER,
130 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
131 x_return_status OUT NOCOPY VARCHAR2,
132 x_msg_count OUT NOCOPY NUMBER,
133 x_msg_data OUT NOCOPY VARCHAR2,
134 p_form_rec IN form_rec_type);
135
136 PROCEDURE delete_row(
137 p_api_version IN NUMBER,
138 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
139 x_return_status OUT NOCOPY VARCHAR2,
140 x_msg_count OUT NOCOPY NUMBER,
141 x_msg_data OUT NOCOPY VARCHAR2,
142 p_form_tbl IN form_tbl_type);
143
144
145 PROCEDURE validate_row(
146 p_api_version IN NUMBER,
147 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
148 x_return_status OUT NOCOPY VARCHAR2,
149 x_msg_count OUT NOCOPY NUMBER,
150 x_msg_data OUT NOCOPY VARCHAR2,
151 p_form_rec IN form_rec_type);
152
153 PROCEDURE validate_row(
154 p_api_version IN NUMBER,
155 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
156 x_return_status OUT NOCOPY VARCHAR2,
157 x_msg_count OUT NOCOPY NUMBER,
158 x_msg_data OUT NOCOPY VARCHAR2,
159 p_form_tbl IN form_tbl_type);
160
161 PROCEDURE lock_row(
162 p_api_version IN NUMBER,
163 p_init_msg_list IN VARCHAR2 DEFAULT OKE_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_form_rec IN form_rec_type);
168
169
170 END OKE_FORM_PVT;
171