1 PACKAGE JTF_LogicalContent_GRP AUTHID CURRENT_USER AS
2 /* $Header: JTFGLCTS.pls 115.9 2004/07/09 18:49:58 applrt ship $ */
3
4
5 g_api_version CONSTANT NUMBER := 1.0;
6 g_pkg_name CONSTANT VARCHAR2(30):='JTF_LogicalContent_GRP';
7
8 TYPE obj_lgl_ctnt_rec_type IS RECORD (
9 obj_lgl_ctnt_delete VARCHAR2(1),
10 OBJ_lgl_ctnt_id NUMBER,
11 Object_Version_Number NUMBER,
12 Object_id NUMBER,
13 Context_id NUMBER,
14 deliverable_id NUMBER
15 );
16
17 TYPE obj_lgl_ctnt_tbl_type IS TABLE OF
18 obj_lgl_ctnt_rec_type INDEX BY BINARY_INTEGER;
19
20
21 PROCEDURE save_delete_lgl_ctnt(
22 p_api_version IN NUMBER,
23 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
24 p_commit IN VARCHAR2 := FND_API.g_false,
25 x_return_status OUT VARCHAR2,
26 x_msg_count OUT NUMBER,
27 x_msg_data OUT VARCHAR2,
28 p_object_type_code IN VARCHAR2,
29 p_lgl_ctnt_tbl IN OBJ_LGL_CTNT_TBL_TYPE
30 );
31
32
33 -----------------------------------------------------------------------
34 -- NOTES
35 -- 1. Deletes all the references to display context in
36 -- JTF_DSP_OBJ_LGL_CTNT table
37 -- Note : This method should not be called from the application
38 ---------------------------------------------------------------------
39 PROCEDURE delete_context(
40 p_context_id IN NUMBER
41 );
42
43 -----------------------------------------------------------------------
44 -- NOTES
45 -- 1. Deletes all references to category and deliverable in
46 -- JTF_DSP_OBJ_LGL_CTNT table
47 -- Note : This method should not be called from the application
48 ---------------------------------------------------------------------
49 PROCEDURE delete_category_dlv(
50 p_category_id IN NUMBER,
51 p_deliverable_id IN NUMBER
52 );
53
54 -----------------------------------------------------------------------
55 -- NOTES
56 -- 1. Deletes all references to section in JTF_DSP_OBJ_LGL_CTNT table
57 -- Note : This method should not be called from the application
58 ---------------------------------------------------------------------
59 PROCEDURE delete_section(
60 p_section_id IN NUMBER
61 );
62
63 -----------------------------------------------------------------------
64 -- NOTES
65 -- 1. Deletes all the refrences to category in JTF_DSP_OBJ_LGL_CTNT table
66 -- Note : This method should not be called from the application
67 ---------------------------------------------------------------------
68 PROCEDURE delete_category(
69 p_category_id IN NUMBER
70 );
71
72 -----------------------------------------------------------------------
73 -- NOTES
74 -- 1. Deletes all the refrences to item in JTF_DSP_OBJ_LGL_CTNT table
75 -- Note : This method should not be called from the application
76 ---------------------------------------------------------------------
77 PROCEDURE delete_item(
78 p_item_id IN NUMBER
79 );
80
81 -----------------------------------------------------------------------
82 -- NOTES
83 -- 1. Update all references to deliverable to null in JTF_DSP_OBJ_LGL_CTNT table
84 -- Note : This method should not be called from the application
85 ---------------------------------------------------------------------
86 PROCEDURE delete_deliverable(
87 p_deliverable_id IN NUMBER
88 );
89
90 END JTF_LogicalContent_GRP;
91