APPS.OKC_XPRT_QUESTION_PUB SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 82

PROCEDURE update_question(p_xprt_update_question_rec  IN OUT  NOCOPY okc_xprt_question_pvt.xprt_qn_const_rec_type
                          ,p_commit              IN              VARCHAR2 := fnd_api.g_false)
IS


x_return_status varchar2(1);

Line: 93

 p_xprt_update_question_rec.QN_CONST_type := 'Q';

Line: 95

 OKC_XPRT_QUESTION_PVT.update_question
                          (p_xprt_update_question_rec  => p_xprt_update_question_rec,
                           p_commit             => p_commit,
                           x_return_status      => x_return_status,
                           x_msg_data           => x_msg_data
                          );

Line: 101

                          p_xprt_update_question_rec.sts := x_return_status;

Line: 102

                          p_xprt_update_question_rec.MSG := x_msg_data;

Line: 106

END update_question;

Line: 111

PROCEDURE update_question(p_xprt_update_question_tbl  IN OUT  NOCOPY okc_xprt_question_pvt.xprt_qn_const_tbl_type
                          ,p_commit              IN              VARCHAR2 := fnd_api.g_false)
IS
l_count NUMBER;

Line: 116

   l_count:=p_xprt_update_question_tbl.Count;

Line: 117

   FOR i IN p_xprt_update_question_tbl.first ..p_xprt_update_question_tbl.last
   LOOP
      BEGIN
      update_question (p_xprt_update_question_rec => p_xprt_update_question_tbl(i)
                      ,p_commit             => p_commit);

Line: 124

         p_xprt_update_question_tbl(i).sts := G_RET_STS_UNEXP_ERROR;

Line: 125

         p_xprt_update_question_tbl(i).MSG := SQLERRM;

Line: 131

END update_question;

Line: 185

PROCEDURE update_constant(p_xprt_update_constant_rec  IN OUT  NOCOPY okc_xprt_question_pvt.xprt_qn_const_rec_type
                          ,p_commit              IN              VARCHAR2 := fnd_api.g_false)
IS


x_return_status varchar2(1);

Line: 196

 p_xprt_update_constant_rec.QN_CONST_type := 'C';

Line: 197

 OKC_XPRT_QUESTION_PVT.update_question
                          (p_xprt_update_question_rec  => p_xprt_update_constant_rec,
                           p_commit             => p_commit,
                           x_return_status      => x_return_status,
                           x_msg_data           => x_msg_data
                          );

Line: 203

                          p_xprt_update_constant_rec.sts := x_return_status;

Line: 204

                          p_xprt_update_constant_rec.MSG := x_msg_data;

Line: 208

END update_constant;

Line: 213

PROCEDURE update_constant(p_xprt_update_constant_tbl  IN OUT  NOCOPY okc_xprt_question_pvt.xprt_qn_const_tbl_type
                          ,p_commit              IN              VARCHAR2 := fnd_api.g_false)
IS
l_count NUMBER;

Line: 218

   l_count:=p_xprt_update_constant_tbl.Count;

Line: 219

   FOR i IN p_xprt_update_constant_tbl.first ..p_xprt_update_constant_tbl.last
   LOOP
      BEGIN
      update_constant (p_xprt_update_constant_rec => p_xprt_update_constant_tbl(i)
                      ,p_commit             => p_commit);

Line: 226

         p_xprt_update_constant_tbl(i).sts := G_RET_STS_UNEXP_ERROR;

Line: 227

         p_xprt_update_constant_tbl(i).MSG := SQLERRM;

Line: 233

END update_constant;