APPS.OKL_ACCT_GEN_RULE_PVT SQL Statements

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

Line: 30

  SELECT ID
  FROM OKL_ACC_GEN_RULES_V
  WHERE ae_line_type    = p_ae_line_type
  AND   set_of_books_id = v_set_of_books_id;

Line: 38

  SELECT  ID
         ,SEGMENT
 	 ,SEGMENT_NUMBER
         ,AGR_ID
         ,SOURCE
 	 ,CONSTANTS
 	 ,OBJECT_VERSION_NUMBER
 	 ,ATTRIBUTE_CATEGORY
 	 ,ATTRIBUTE1
 	 ,ATTRIBUTE2
 	 ,ATTRIBUTE3
 	 ,ATTRIBUTE4
 	 ,ATTRIBUTE5
 	 ,ATTRIBUTE6
 	 ,ATTRIBUTE7
 	 ,ATTRIBUTE8
 	 ,ATTRIBUTE9
 	 ,ATTRIBUTE10
 	 ,ATTRIBUTE11
 	 ,ATTRIBUTE12
 	 ,ATTRIBUTE13
 	 ,ATTRIBUTE14
 	 ,ATTRIBUTE15
 	 ,CREATED_BY
 	 ,CREATION_DATE
 	 ,LAST_UPDATED_BY
 	 ,LAST_UPDATE_DATE
 	 ,LAST_UPDATE_LOGIN
  FROM  OKL_ACC_GEN_RUL_LNS_V
  WHERE agr_id = v_agr_id;

Line: 144

  SELECT ID
  FROM OKL_ACC_GEN_RULES_V
  WHERE ae_line_type    = p_ae_line_type
  AND   set_of_books_id = v_set_of_books_id;

Line: 152

  SELECT  ID
         ,SEGMENT
 	 ,SEGMENT_NUMBER
         ,AGR_ID
         ,SOURCE
 	 ,CONSTANTS
 	 ,OBJECT_VERSION_NUMBER
 	 ,ATTRIBUTE_CATEGORY
 	 ,ATTRIBUTE1
 	 ,ATTRIBUTE2
 	 ,ATTRIBUTE3
 	 ,ATTRIBUTE4
 	 ,ATTRIBUTE5
 	 ,ATTRIBUTE6
 	 ,ATTRIBUTE7
 	 ,ATTRIBUTE8
 	 ,ATTRIBUTE9
 	 ,ATTRIBUTE10
 	 ,ATTRIBUTE11
 	 ,ATTRIBUTE12
 	 ,ATTRIBUTE13
 	 ,ATTRIBUTE14
 	 ,ATTRIBUTE15
 	 ,CREATED_BY
 	 ,CREATION_DATE
 	 ,LAST_UPDATED_BY
 	 ,LAST_UPDATE_DATE
 	 ,LAST_UPDATE_LOGIN
  FROM  OKL_ACC_GEN_RUL_LNS_V
  WHERE agr_id = v_agr_id;

Line: 251

  	 l_acc_lines(i).LAST_UPDATED_BY  	  := acgl_rec.LAST_UPDATED_BY;

Line: 252

  	 l_acc_lines(i).LAST_UPDATE_DATE  	  := acgl_rec.LAST_UPDATE_DATE;

Line: 253

  	 l_acc_lines(i).LAST_UPDATE_LOGIN  	  := acgl_rec.LAST_UPDATE_LOGIN;

Line: 310

        p_aulv_tbl(i).LAST_UPDATED_BY        := p_acc_lines(i).LAST_UPDATED_BY;

Line: 311

        p_aulv_tbl(i).LAST_UPDATE_DATE       := p_acc_lines(i).LAST_UPDATE_DATE;

Line: 312

        p_aulv_tbl(i).LAST_UPDATE_LOGIN      := p_acc_lines(i).LAST_UPDATE_LOGIN;

Line: 358

        p_acc_lines(i).LAST_UPDATED_BY        := p_aulv_tbl(i).LAST_UPDATED_BY;

Line: 359

        p_acc_lines(i).LAST_UPDATE_DATE       := p_aulv_tbl(i).LAST_UPDATE_DATE;

Line: 360

        p_acc_lines(i).LAST_UPDATE_LOGIN      := p_aulv_tbl(i).LAST_UPDATE_LOGIN;

Line: 382

SELECT '1'
FROM OKL_ACC_GEN_RULES_V
WHERE ae_line_type    = v_ae_line_type
AND   set_of_books_id = v_set_of_books_id;

Line: 458

      OKL_ACC_GEN_RULE_PUB.update_acc_gen_rule_lns(p_api_version       => l_api_version,
                                                   p_init_msg_list     => l_init_msg_list,
                                                   x_return_status     => l_return_status,
                                                   x_msg_count         => l_msg_count,
                                                   x_msg_data          => l_msg_data,
                                                   p_aulv_tbl          => l_aulv_tbl_in,
                                                   x_aulv_tbl          => l_aulv_tbl_out);