APPS.JTF_LOGICALCONTENT_GRP SQL Statements

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

Line: 7

   SELECT jtf_dsp_obj_lgl_ctnt_s1.NEXTVAL
     FROM DUAL;

Line: 11

PROCEDURE delete_logical_content(
   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_object_type		IN  VARCHAR2,
  p_lgl_ctnt_rec	IN OBJ_LGL_CTNT_REC_TYPE
 )
IS
   l_api_name    CONSTANT VARCHAR2(30) := 'delete_logical_content';

Line: 31

   SAVEPOINT delete_logical_content;

Line: 61

  delete from jtf_dsp_obj_lgl_ctnt where
	 obj_lgl_ctnt_id = p_lgl_ctnt_rec.obj_lgl_ctnt_id and
	 object_version_number = p_lgl_ctnt_rec.object_version_number;

Line: 86

      ROLLBACK TO delete_logical_content;

Line: 95

      ROLLBACK TO delete_logical_content;

Line: 105

   ROLLBACK TO delete_logical_content;

Line: 116

      ROLLBACK TO delete_logical_content;

Line: 128

END delete_logical_content;

Line: 296

	delete from JTF_DSP_OBJ_LGL_CTNT where
		obj_lgl_ctnt_id = p_lgl_ctnt_rec.obj_lgl_ctnt_id and
                object_version_number = p_lgl_ctnt_rec.object_version_number and
		object_type = l_object_type;

Line: 308

INSERT INTO JTF_DSP_OBJ_LGL_CTNT (
OBJ_LGL_CTNT_ID,
OBJECT_VERSION_NUMBER,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_LOGIN,
OBJECT_ID,
OBJECT_TYPE,
CONTEXT_ID,
ITEM_ID
)
 VALUES (
l_obj_lgl_ctnt_id,
1,
SYSDATE,
FND_GLOBAL.user_id,
SYSDATE,
FND_GLOBAL.user_id,
FND_GLOBAL.user_id,
p_lgl_ctnt_rec.object_id,
l_object_type,
p_lgl_ctnt_rec.context_id,
p_lgl_ctnt_rec.deliverable_id);

Line: 343

UPDATE  JTF_DSP_OBJ_LGL_CTNT  SET
LAST_UPDATE_DATE = SYSDATE,
LAST_UPDATED_BY = FND_GLOBAL.user_id,
LAST_UPDATE_LOGIN= FND_GLOBAL.user_id,
OBJECT_ID = p_lgl_ctnt_rec.object_id,
OBJECT_TYPE = l_object_type,
CONTEXT_ID = p_lgl_ctnt_rec.context_id,
ITEM_ID = p_lgl_ctnt_rec.deliverable_id ,
OBJECT_VERSION_NUMBER = p_lgl_ctnt_rec.object_version_number + 1
WHERE
OBJ_LGL_CTNT_ID = p_lgl_ctnt_rec.obj_lgl_ctnt_id and
OBJECT_VERSION_NUMBER  = p_lgl_ctnt_rec.object_version_number;

Line: 435

PROCEDURE save_delete_lgl_ctnt(
   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_object_type_code	 IN   VARCHAR2,
  p_lgl_ctnt_tbl	      IN OBJ_LGL_CTNT_TBL_TYPE
 )
IS

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

Line: 459

   SAVEPOINT save_delete_itm_lgl_ctnt;

Line: 493

   IF p_lgl_ctnt_tbl(l_index).obj_lgl_ctnt_delete = FND_API.g_true
   then

--dbms_output.put_line('CALLING DELETE_LOGICAL_CONTENT');

Line: 497

	delete_logical_content(
           p_api_version,
	     FND_API.g_false,
	     FND_API.g_false,
           l_return_status,
           l_msg_count,
	     l_msg_data,
	    p_object_type_code,
           p_lgl_ctnt_tbl(l_index));

Line: 507

   ELSIF p_lgl_ctnt_tbl(l_index).obj_lgl_ctnt_delete = FND_API.g_false
	then

--dbms_output.put_line('CALLING SAVE_LOGICAL_CONTENT');

Line: 543

      ROLLBACK TO save_delete_itm_lgl_ctnt;

Line: 552

      ROLLBACK TO save_delete_itm_lgl_ctnt;

Line: 562

      ROLLBACK TO save_delete_itm_lgl_ctnt;

Line: 574

END save_delete_lgl_ctnt;

Line: 576

PROCEDURE delete_section(
   p_section_id          IN   NUMBER
 )
IS
   l_api_name    CONSTANT VARCHAR2(30) := 'delete_section';

Line: 583

SAVEPOINT delete_section;

Line: 589

 DELETE FROM JTF_DSP_OBJ_LGL_CTNT where
 OBJECT_TYPE = 'S' and
 OBJECT_ID = p_section_id;

Line: 595

      ROLLBACK TO delete_section;

Line: 597

END delete_section;

Line: 599

PROCEDURE delete_deliverable(
   p_deliverable_id          IN   NUMBER
 )
IS
   l_api_name    CONSTANT VARCHAR2(30) := 'delete_deliverable';

Line: 605

SAVEPOINT delete_deliverable;

Line: 610

 UPDATE  JTF_DSP_OBJ_LGL_CTNT SET
 ITEM_ID = null where
 ITEM_ID = p_deliverable_id ;

Line: 618

      ROLLBACK TO delete_deliverable;

Line: 619

END delete_deliverable;

Line: 622

PROCEDURE delete_category(
   p_category_id          IN   NUMBER
 )
IS
   l_api_name    CONSTANT VARCHAR2(30) := 'delete_category';

Line: 632

 DELETE FROM JTF_DSP_OBJ_LGL_CTNT where
 OBJECT_TYPE = 'C' and
 OBJECT_ID = p_category_id;

Line: 640

END delete_category;

Line: 642

PROCEDURE delete_item(
   p_item_id          IN   NUMBER
 )
IS
   l_api_name    CONSTANT VARCHAR2(30) := 'delete_item';

Line: 652

 DELETE FROM JTF_DSP_OBJ_LGL_CTNT where
 OBJECT_TYPE = 'I' and
 OBJECT_ID = p_item_id;

Line: 660

END delete_item;

Line: 663

PROCEDURE delete_context(
   p_context_id          IN   NUMBER
 )
IS
   l_api_name    CONSTANT VARCHAR2(30) := 'delete_context';

Line: 669

SAVEPOINT delete_context;

Line: 674

delete JTF_DSP_OBJ_LGL_CTNT
where context_id = p_context_id;

Line: 680

      ROLLBACK TO delete_context;

Line: 681

END delete_context;

Line: 683

PROCEDURE delete_category_dlv(
   p_category_id          IN   NUMBER,
   p_deliverable_id	    IN   NUMBER
 )
IS
   l_api_name    CONSTANT VARCHAR2(30) := 'delete_category_dlv';

Line: 690

SAVEPOINT delete_category_dlv;

Line: 696

UPDATE  JTF_DSP_OBJ_LGL_CTNT
set item_id = null
where object_type  = 'C' and
	    object_id = p_category_id and
	    ITEM_ID   = p_deliverable_id;

Line: 706

      ROLLBACK TO delete_category_dlv;

Line: 708

END delete_category_dlv;