[Home] [Help]
PACKAGE: APPS.OKC_QA_CHECK_LIST_PVT
Source
1 PACKAGE OKC_QA_CHECK_LIST_PVT AS
2 /* $Header: OKCCQCLS.pls 120.0 2005/05/25 22:34:52 appldev noship $ */
3
4 -- simple entity object subtype definitions
5 subtype qclv_rec_type is OKC_QCL_PVT.qclv_rec_type;
6 subtype qclv_tbl_type is OKC_QCL_PVT.qclv_tbl_type;
7 subtype qlpv_rec_type is OKC_QLP_PVT.qlpv_rec_type;
8 subtype qlpv_tbl_type is OKC_QLP_PVT.qlpv_tbl_type;
9 subtype qppv_rec_type is OKC_QPP_PVT.qppv_rec_type;
10 subtype qppv_tbl_type is OKC_QPP_PVT.qppv_tbl_type;
11
12 ---------------------------------------------------------------------------
13 -- GLOBAL MESSAGE CONSTANTS
14 ---------------------------------------------------------------------------
15 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
16 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
17 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
18 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
19 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
20 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
21 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
22 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
23 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
24 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
25 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
26 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
27 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
28 G_UPPERCASE_REQUIRED CONSTANT VARCHAR2(200) := 'OKC_UPPERCASE_REQUIRED';
29
30 ------------------------------------------------------------------------------------
31 -- GLOBAL EXCEPTION
32 ---------------------------------------------------------------------------
33 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
34
35 -- GLOBAL VARIABLES
36 ---------------------------------------------------------------------------
37 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_QA_CHECK_LIST_PVT';
38 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
39 ---------------------------------------------------------------------------
40
41 PROCEDURE create_qa_check_list(
42 p_api_version IN NUMBER,
43 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
44 x_return_status OUT NOCOPY VARCHAR2,
45 x_msg_count OUT NOCOPY NUMBER,
46 x_msg_data OUT NOCOPY VARCHAR2,
47 p_qclv_rec IN qclv_rec_type,
48 x_qclv_rec OUT NOCOPY qclv_rec_type);
49
50 PROCEDURE update_qa_check_list(
51 p_api_version IN NUMBER,
52 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
53 x_return_status OUT NOCOPY VARCHAR2,
54 x_msg_count OUT NOCOPY NUMBER,
55 x_msg_data OUT NOCOPY VARCHAR2,
56 p_qclv_rec IN qclv_rec_type,
57 x_qclv_rec OUT NOCOPY qclv_rec_type);
58
59 PROCEDURE delete_qa_check_list(
60 p_api_version IN NUMBER,
61 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
62 x_return_status OUT NOCOPY VARCHAR2,
63 x_msg_count OUT NOCOPY NUMBER,
64 x_msg_data OUT NOCOPY VARCHAR2,
65 p_qclv_rec IN qclv_rec_type);
66
67 PROCEDURE lock_qa_check_list(
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_qclv_rec IN qclv_rec_type);
74
75 PROCEDURE validate_qa_check_list(
76 p_api_version IN NUMBER,
77 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
78 x_return_status OUT NOCOPY VARCHAR2,
79 x_msg_count OUT NOCOPY NUMBER,
80 x_msg_data OUT NOCOPY VARCHAR2,
81 p_qclv_rec IN qclv_rec_type);
82
83 PROCEDURE create_qa_process(
84 p_api_version IN NUMBER,
85 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
86 x_return_status OUT NOCOPY VARCHAR2,
87 x_msg_count OUT NOCOPY NUMBER,
88 x_msg_data OUT NOCOPY VARCHAR2,
89 p_qlpv_rec IN qlpv_rec_type,
90 x_qlpv_rec OUT NOCOPY qlpv_rec_type);
91
92 PROCEDURE update_qa_process(
93 p_api_version IN NUMBER,
94 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
95 x_return_status OUT NOCOPY VARCHAR2,
96 x_msg_count OUT NOCOPY NUMBER,
97 x_msg_data OUT NOCOPY VARCHAR2,
98 p_qlpv_rec IN qlpv_rec_type,
99 x_qlpv_rec OUT NOCOPY qlpv_rec_type);
100
101 PROCEDURE delete_qa_process(
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_qlpv_rec IN qlpv_rec_type);
108
109 PROCEDURE lock_qa_process(
110 p_api_version IN NUMBER,
111 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
112 x_return_status OUT NOCOPY VARCHAR2,
113 x_msg_count OUT NOCOPY NUMBER,
114 x_msg_data OUT NOCOPY VARCHAR2,
115 p_qlpv_rec IN qlpv_rec_type);
116
117 PROCEDURE validate_qa_process(
118 p_api_version IN NUMBER,
119 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
120 x_return_status OUT NOCOPY VARCHAR2,
121 x_msg_count OUT NOCOPY NUMBER,
122 x_msg_data OUT NOCOPY VARCHAR2,
123 p_qlpv_rec IN qlpv_rec_type);
124
125 PROCEDURE create_qa_parm(
126 p_api_version IN NUMBER,
127 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
128 x_return_status OUT NOCOPY VARCHAR2,
129 x_msg_count OUT NOCOPY NUMBER,
130 x_msg_data OUT NOCOPY VARCHAR2,
131 p_qppv_rec IN qppv_rec_type,
132 x_qppv_rec OUT NOCOPY qppv_rec_type);
133
134 PROCEDURE update_qa_parm(
135 p_api_version IN NUMBER,
136 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
137 x_return_status OUT NOCOPY VARCHAR2,
138 x_msg_count OUT NOCOPY NUMBER,
139 x_msg_data OUT NOCOPY VARCHAR2,
140 p_qppv_rec IN qppv_rec_type,
141 x_qppv_rec OUT NOCOPY qppv_rec_type);
142
143 PROCEDURE delete_qa_parm(
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_qppv_rec IN qppv_rec_type);
150
151 PROCEDURE lock_qa_parm(
152 p_api_version IN NUMBER,
153 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
154 x_return_status OUT NOCOPY VARCHAR2,
155 x_msg_count OUT NOCOPY NUMBER,
156 x_msg_data OUT NOCOPY VARCHAR2,
157 p_qppv_rec IN qppv_rec_type);
158
159 PROCEDURE validate_qa_parm(
160 p_api_version IN NUMBER,
161 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
162 x_return_status OUT NOCOPY VARCHAR2,
163 x_msg_count OUT NOCOPY NUMBER,
164 x_msg_data OUT NOCOPY VARCHAR2,
165 p_qppv_rec IN qppv_rec_type);
166
167 PROCEDURE add_language;
168
169 END OKC_QA_CHECK_LIST_PVT;