26: G_UNEXPECTED_ERROR CONSTANT varchar2(200) := 'OKC_UNEXPECTED_ERROR';
27: G_SQLERRM_TOKEN CONSTANT varchar2(200) := 'ERROR_MESSAGE';
28: G_SQLCODE_TOKEN CONSTANT varchar2(200) := 'ERROR_CODE';
29:
30: PROCEDURE create_question( p_xprt_question_rec IN OUT NOCOPY okc_xprt_question_pvt.xprt_qn_const_rec_type
31: ,p_commit IN VARCHAR2 := fnd_api.g_false
32: )
33: IS
34:
38: BEGIN
39:
40: p_xprt_question_rec.QN_CONST_type := 'Q';
41:
42: OKC_XPRT_QUESTION_PVT.create_question
43: (p_xprt_question_rec => p_xprt_question_rec,
44: p_commit => p_commit,
45: x_return_status => x_return_status,
46: x_msg_data => x_msg_data
53: WHEN OTHERS THEN
54: RAISE;
55: END create_question;
56:
57: PROCEDURE create_question( p_xprt_question_tbl IN OUT NOCOPY okc_xprt_question_pvt.xprt_qn_const_tbl_type
58: ,p_commit IN VARCHAR2 := fnd_api.g_false)
59: IS
60: l_count NUMBER;
61: BEGIN
78: END create_question;
79:
80:
81:
82: PROCEDURE update_question(p_xprt_update_question_rec IN OUT NOCOPY okc_xprt_question_pvt.xprt_qn_const_rec_type
83: ,p_commit IN VARCHAR2 := fnd_api.g_false)
84: IS
85:
86:
91: BEGIN
92:
93: p_xprt_update_question_rec.QN_CONST_type := 'Q';
94:
95: OKC_XPRT_QUESTION_PVT.update_question
96: (p_xprt_update_question_rec => p_xprt_update_question_rec,
97: p_commit => p_commit,
98: x_return_status => x_return_status,
99: x_msg_data => x_msg_data
107:
108:
109:
110:
111: PROCEDURE update_question(p_xprt_update_question_tbl IN OUT NOCOPY okc_xprt_question_pvt.xprt_qn_const_tbl_type
112: ,p_commit IN VARCHAR2 := fnd_api.g_false)
113: IS
114: l_count NUMBER;
115: BEGIN
130: RAISE;
131: END update_question;
132:
133:
134: PROCEDURE create_constant( p_xprt_constant_rec IN OUT NOCOPY okc_xprt_question_pvt.xprt_qn_const_rec_type
135: ,p_commit IN VARCHAR2 := fnd_api.g_false
136: )
137: IS
138:
141:
142: BEGIN
143: p_xprt_constant_rec.QN_CONST_type := 'C';
144:
145: OKC_XPRT_QUESTION_PVT.create_question
146: (p_xprt_question_rec => p_xprt_constant_rec,
147: p_commit => p_commit,
148: x_return_status => x_return_status,
149: x_msg_data => x_msg_data
156: WHEN OTHERS THEN
157: RAISE;
158: END create_constant;
159:
160: PROCEDURE create_constant( p_xprt_constant_tbl IN OUT NOCOPY okc_xprt_question_pvt.xprt_qn_const_tbl_type
161: ,p_commit IN VARCHAR2 := fnd_api.g_false)
162: IS
163: l_count NUMBER;
164: BEGIN
181: END create_constant;
182:
183:
184:
185: PROCEDURE update_constant(p_xprt_update_constant_rec IN OUT NOCOPY okc_xprt_question_pvt.xprt_qn_const_rec_type
186: ,p_commit IN VARCHAR2 := fnd_api.g_false)
187: IS
188:
189:
193:
194: BEGIN
195:
196: p_xprt_update_constant_rec.QN_CONST_type := 'C';
197: OKC_XPRT_QUESTION_PVT.update_question
198: (p_xprt_update_question_rec => p_xprt_update_constant_rec,
199: p_commit => p_commit,
200: x_return_status => x_return_status,
201: x_msg_data => x_msg_data
209:
210:
211:
212:
213: PROCEDURE update_constant(p_xprt_update_constant_tbl IN OUT NOCOPY okc_xprt_question_pvt.xprt_qn_const_tbl_type
214: ,p_commit IN VARCHAR2 := fnd_api.g_false)
215: IS
216: l_count NUMBER;
217: BEGIN