APPS.JTF_TPLCATEGORY_GRP SQL Statements

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

Line: 6

   SELECT jtf_dsp_tpl_ctg_s1.NEXTVAL
     FROM DUAL;

Line: 80

		INSERT INTO JTF_DSP_TPL_CTG (
		TPL_CTG_ID,
		OBJECT_VERSION_NUMBER,
		LAST_UPDATE_DATE,
		LAST_UPDATED_BY,
		CREATION_DATE,
		CREATED_BY,
		LAST_UPDATE_LOGIN,
		ITEM_ID,
		CATEGORY_ID
		)
 		VALUES (
		l_dsp_tpl_seq_id,
		1,
		SYSDATE,
		FND_GLOBAL.user_id,
		SYSDATE,
		FND_GLOBAL.user_id,
		FND_GLOBAL.user_id,
		p_template_id,
		p_category_id);

Line: 102

	        ---dbms_output.put_line('insert record ' || p_template_id || '0-0'|| p_category_id);

Line: 311

PROCEDURE delete_tpl_ctg_relation(
   p_api_version         IN  NUMBER,
   p_init_msg_list	   IN VARCHAR2 := FND_API.g_false,
   p_commit              IN  VARCHAR2 := FND_API.g_false,
   x_return_status              OUT VARCHAR2,
   x_msg_count          OUT  NUMBER,
   x_msg_data           OUT  VARCHAR2,
   p_tpl_ctg_id_tbl     IN  tpl_ctg_id_TBL_TYPE
)
IS
   l_api_name    CONSTANT VARCHAR2(30) := 'delete_tpl_ctg_relation';

Line: 328

	       SELECT category_id ,ITEM_ID from jtf_dsp_tpl_ctg where
		 tpl_ctg_id = p_tpl_ctg_id;

Line: 334

   SAVEPOINT delete_tpl_ctg_relation;

Line: 354

   SAVEPOINT delete_ctg_relation;

Line: 366

  DELETE FROM JTF_DSP_TPL_CTG WHERE
  			TPL_CTG_ID  = p_tpl_ctg_id_tbl(l_index);

Line: 370

  JTF_LogicalContent_grp.delete_category_dlv( l_category_id,
								      l_deliverable_id);

Line: 378

      ROLLBACK TO delete_ctg_relation;

Line: 398

      ROLLBACK TO delete_tpl_ctg_relation;

Line: 407

      ROLLBACK TO delete_tpl_ctg_relation;

Line: 417

      ROLLBACK TO delete_tpl_ctg_relation;

Line: 432

END delete_tpl_ctg_relation;

Line: 580

PROCEDURE delete_deliverable(
   p_template_id      IN  NUMBER
)
IS
BEGIN
   --------------------- initialize -----------------------
   SAVEPOINT delete_deliverable;

Line: 589

  delete from jtf_dsp_tpl_ctg where
  item_id = p_template_id;

Line: 596

      ROLLBACK TO delete_deliverable;

Line: 598

END delete_deliverable;

Line: 607

PROCEDURE delete_category(
   p_category_id      IN  NUMBER
)
IS
BEGIN
   --------------------- initialize -----------------------
   SAVEPOINT delete_category;

Line: 616

  delete from jtf_dsp_tpl_ctg where
  category_id = p_category_id;

Line: 622

      ROLLBACK TO delete_category;

Line: 624

END delete_category;