1 PACKAGE IBE_LogicalContent_GRP AUTHID CURRENT_USER AS
2 /* $Header: IBEGLCTS.pls 115.1 2002/12/14 07:50:34 schak ship $ */
3
4
5 g_api_version CONSTANT NUMBER := 1.0;
6 g_pkg_name CONSTANT VARCHAR2(30):='IBE_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 TYPE obj_lgl_ctnt_tbl_type IS TABLE OF
17 obj_lgl_ctnt_rec_type INDEX BY BINARY_INTEGER;
18
19 PROCEDURE save_delete_lgl_ctnt(
20 p_api_version IN NUMBER,
21 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
22 p_commit IN VARCHAR2 := FND_API.g_false,
23 x_return_status OUT NOCOPY VARCHAR2,
24 x_msg_count OUT NOCOPY NUMBER,
25 x_msg_data OUT NOCOPY VARCHAR2,
26 p_object_type_code IN VARCHAR2,
27 p_lgl_ctnt_tbl IN OBJ_LGL_CTNT_TBL_TYPE );
28
29 -----------------------------------------------------------------------+
30 -- NOTES
31 -- 1. Deletes all the references to display context in
32 -- IBE_DSP_OBJ_LGL_CTNT table
33 -- Note : This method should not be called from the application
34 ---------------------------------------------------------------------+
35 PROCEDURE delete_context(p_context_id IN NUMBER );
36
37 -----------------------------------------------------------------------+
38 -- NOTES
39 -- 1. Deletes all references to category and deliverable in
40 -- IBE_DSP_OBJ_LGL_CTNT table
41 -- Note : This method should not be called from the application
42 ---------------------------------------------------------------------+
43 PROCEDURE delete_category_dlv(
44 p_category_id IN NUMBER,
45 p_deliverable_id IN NUMBER );
46
47 -----------------------------------------------------------------------+
48 -- NOTES
49 -- 1. Deletes all references to section in IBE_DSP_OBJ_LGL_CTNT table
50 -- Note : This method should not be called from the application
51 ---------------------------------------------------------------------+
52 PROCEDURE delete_section(p_section_id IN NUMBER );
53
54 -----------------------------------------------------------------------+
55 -- NOTES
56 -- 1. Deletes all the refrences to category in IBE_DSP_OBJ_LGL_CTNT table
57 -- Note : This method should not be called from the application
58 ---------------------------------------------------------------------+
59 PROCEDURE delete_category(p_category_id IN NUMBER );
60
61 -----------------------------------------------------------------------+
62 -- NOTES
63 -- 1. Deletes all the refrences to item in IBE_DSP_OBJ_LGL_CTNT table
64 -- Note : This method should not be called from the application
65 ---------------------------------------------------------------------+
66 PROCEDURE delete_item(p_item_id IN NUMBER );
67
68 -----------------------------------------------------------------------+
69 -- NOTES
70 -- 1. Update all references to deliverable to null in
71 -- IBE_DSP_OBJ_LGL_CTNT table
72 -- Note : This method should not be called from the application
73 ---------------------------------------------------------------------
74 PROCEDURE delete_deliverable(p_deliverable_id IN NUMBER );
75
76 END IBE_LogicalContent_GRP;