DBA Data[Home] [Help]

APPS.OKC_XPRT_QUESTION_PUB dependencies on OKC_XPRT_QUESTION_PVT

Line 30: PROCEDURE create_question( p_xprt_question_rec IN OUT NOCOPY okc_xprt_question_pvt.xprt_qn_const_rec_type

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:

Line 42: OKC_XPRT_QUESTION_PVT.create_question

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

Line 57: PROCEDURE create_question( p_xprt_question_tbl IN OUT NOCOPY okc_xprt_question_pvt.xprt_qn_const_tbl_type

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

Line 82: PROCEDURE update_question(p_xprt_update_question_rec IN OUT NOCOPY okc_xprt_question_pvt.xprt_qn_const_rec_type

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:

Line 95: OKC_XPRT_QUESTION_PVT.update_question

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

Line 111: PROCEDURE update_question(p_xprt_update_question_tbl IN OUT NOCOPY okc_xprt_question_pvt.xprt_qn_const_tbl_type

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

Line 134: PROCEDURE create_constant( p_xprt_constant_rec IN OUT NOCOPY okc_xprt_question_pvt.xprt_qn_const_rec_type

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:

Line 145: OKC_XPRT_QUESTION_PVT.create_question

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

Line 160: PROCEDURE create_constant( p_xprt_constant_tbl IN OUT NOCOPY okc_xprt_question_pvt.xprt_qn_const_tbl_type

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

Line 185: PROCEDURE update_constant(p_xprt_update_constant_rec IN OUT NOCOPY okc_xprt_question_pvt.xprt_qn_const_rec_type

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:

Line 197: OKC_XPRT_QUESTION_PVT.update_question

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

Line 213: PROCEDURE update_constant(p_xprt_update_constant_tbl IN OUT NOCOPY okc_xprt_question_pvt.xprt_qn_const_tbl_type

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