APPS.OKC_XPRT_TMPL_RULE_ASSNS_PVT SQL Statements

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

Line: 41

SELECT org_id
  FROM okc_terms_templates_all
 WHERE template_id = p_template_id;

Line: 47

SELECT t.rule_id
  FROM okc_xprt_template_rules t,
       okc_xprt_rule_hdrs_all r
 WHERE r.rule_id = t.rule_id
   AND r.status_code <> 'INACTIVE'
   AND NVL(t.deleted_flag,'N') <> 'Y'
   AND t.template_id = p_source_template_id;

Line: 60

SELECT question_id,
       mandatory_flag,
	  sequence_num,
	  question_rule_status,
	  runtime_available_flag
  FROM okc_xprt_question_orders
 WHERE template_id = p_source_template_id;

Line: 148

       	    INSERT INTO okc_xprt_template_rules
       	       (
                    TEMPLATE_RULE_ID,
                    TEMPLATE_ID,
                    RULE_ID,
                    OBJECT_VERSION_NUMBER,
                    CREATED_BY,
                    CREATION_DATE,
                    LAST_UPDATED_BY,
                    LAST_UPDATE_DATE,
                    LAST_UPDATE_LOGIN,
				DELETED_FLAG
       		  )
       	    VALUES
       	       (
       		   okc_xprt_template_rules_s.NEXTVAL,
                  p_target_template_id,
       		   rule_id_tbl(i),
       		   1,
       		   Fnd_Global.User_Id,
                  sysdate,
                  Fnd_Global.User_Id,
                  sysdate,
                  Fnd_Global.Login_Id,
			   'N'
       		  );

Line: 190

       	    INSERT INTO okc_xprt_question_orders
       	       (
                   QUESTION_ORDER_ID,
                   TEMPLATE_ID,
                   QUESTION_ID,
                   MANDATORY_FLAG,
                   OBJECT_VERSION_NUMBER,
                   CREATED_BY,
                   CREATION_DATE,
                   LAST_UPDATED_BY,
                   LAST_UPDATE_DATE,
                   LAST_UPDATE_LOGIN,
                   SEQUENCE_NUM,
                   QUESTION_RULE_STATUS,
                   RUNTIME_AVAILABLE_FLAG
       		  )
       	    VALUES
       	       (
       		   okc_xprt_question_orders_s.NEXTVAL,
                  p_target_template_id,
       		   question_id_tbl(i),
			   mandatory_flag_tbl(i),
       		   1,
       		   Fnd_Global.User_Id,
                  sysdate,
                  Fnd_Global.User_Id,
                  sysdate,
                  Fnd_Global.Login_Id,
			   sequence_num_tbl(i),
			   question_rule_status_tbl(i),
			   runtime_available_flag_tbl(i)
       		  );

Line: 287

PROCEDURE delete_template_rule_assns
(
 p_api_version           IN NUMBER,
 p_init_msg_list	     IN VARCHAR2,
 p_commit	               IN VARCHAR2,
 p_template_id           IN NUMBER,
 x_return_status	     OUT NOCOPY VARCHAR2,
 x_msg_data	          OUT NOCOPY VARCHAR2,
 x_msg_count	          OUT NOCOPY NUMBER
) IS

l_api_name                CONSTANT VARCHAR2(30) := 'delete_template_rule_assns';

Line: 323

  DELETE FROM okc_xprt_template_rules
        WHERE template_id = p_template_id;

Line: 327

  DELETE FROM okc_xprt_question_orders
        WHERE template_id = p_template_id;

Line: 386

END delete_template_rule_assns;

Line: 404

SELECT NVL(contract_expert_enabled,'N')
   FROM okc_terms_templates_all
 WHERE template_id = p_parent_template_id;

Line: 432

     DELETE FROM okc_xprt_template_rules
	     WHERE  template_id = p_parent_template_id;

Line: 436

     DELETE FROM okc_xprt_question_orders
	      WHERE  template_id = p_parent_template_id;

Line: 448

     DELETE FROM okc_xprt_template_rules
            WHERE  template_id = p_template_id;

Line: 452

     DELETE FROM okc_xprt_question_orders
            WHERE  template_id = p_template_id;

Line: 459

     UPDATE okc_xprt_template_rules
	   SET template_id = p_parent_template_id,
	       last_update_date = SYSDATE,
		  last_updated_by= FND_GLOBAL.USER_ID,
		  last_update_login= FND_GLOBAL.LOGIN_ID
     WHERE template_id = p_template_id;

Line: 467

     UPDATE okc_xprt_question_orders
        SET template_id = p_parent_template_id,
	       last_update_date = SYSDATE,
		  last_updated_by= FND_GLOBAL.USER_ID,
		  last_update_login= FND_GLOBAL.LOGIN_ID
     WHERE template_id = p_template_id;