1 PACKAGE AMS_Collab_assoc_PVT AS
2 /* $Header: amsvcols.pls 120.0.12000000.2 2007/08/03 12:54:19 amlal ship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- AMS_Collab_assoc_PVT
7 -- Purpose
8 --
9 -- History
10 --
11 -- NOTE
12 -- This api has been created for association of collaboration content
13 -- items and scrips from web adi
14 -- End of Comments
15 -- ===============================================================
16
17 -- Default number of records fetch per call
18 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
19 --===================================================================
20 -- Start of Comments
21 -- -------------------------------------------------------
22 -- Record name
23 -- collab_assoc_rec_type
24 -- -------------------------------------------------------
25 -- Parameters:
26 -- collab_item_id <primary key of association table>
27 -- Collab_type < < Valid value shuold be from ams_lookups:lookup type='AMS_COLLABORATION_TYPE' >
28 -- collab_assoc_value <script_name, proposal_name>
29 --- collab_assoc_id <contentId,proposalId,ScriptID)
30 -- last_update_date
31 -- last_updated_by
32 -- creation_date
33 -- created_by
34 -- last_update_login
35 -- object_version_number
36 -- obj_type
37 -- obj_id
38 -- p_assoc_object2
39 -- p_assoc_object3
40 -- p_assoc_object4
41 -- p_assoc_object5
42
43 -- Required
44 --
45 -- Defaults
46 --
47 -- Note: This is automatic generated record definition, it includes all columns
48 -- defined in the table, developer must manually add or delete some of the attributes.
49 --
50 -- End of Comments
51
52 --===================================================================
53 TYPE collab_assoc_rec_type IS RECORD
54 (
55 collab_item_id NUMBER,
56 Collab_type VARCHAR2(20),
57 collab_assoc_value VARCHAR2(240),
58 collab_assoc_id NUMBER,
59 last_update_date DATE,
60 last_updated_by NUMBER,
61 creation_date DATE,
62 created_by NUMBER,
63 last_update_login NUMBER,
64 object_version_number NUMBER ,
65 obj_type VARCHAR(100),
66 obj_id NUMBER,
67 p_assoc_object2 VARCHAR2(254),
68 p_assoc_object3 VARCHAR2(254),
69 p_assoc_object4 VARCHAR2(254),
70 p_assoc_object5 VARCHAR2(254)
71 );
72
73 TYPE cnt_point_tbl_type IS TABLE OF collab_assoc_rec_type INDEX BY BINARY_INTEGER;
74
75 -- ==============================================================================
76 -- Start of Comments
77 -- ==============================================================================
78 -- API Name
79 -- Create_collab_Assoc
80 -- Type
81 -- Private
82 -- Pre-Req
83 --
84 -- Parameters
85 --
86 -- IN
87 -- p_api_version_number IN NUMBER Required
88 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
89 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
90 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
91 -- p_collab_assoc_rec_type IN collab_assoc_rec_type Required
92 --
93 -- OUT
94 -- x_return_status OUT VARCHAR2
95 -- x_msg_count OUT NUMBER
96 -- x_msg_data OUT VARCHAR2
97 -- Version : Current version 1.0
98 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
99 -- and basic operation, developer must manually add parameters and business logic as necessary.
100 --
101 -- End of Comments
102 -- ==============================================================================
103 --
104
105 PROCEDURE Create_collab_Assoc(
106 p_api_version_number IN NUMBER,
107 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
108 p_commit IN VARCHAR2 := FND_API.G_FALSE,
109 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
110 x_return_status OUT NOCOPY VARCHAR2,
111 x_msg_count OUT NOCOPY NUMBER,
112 x_msg_data OUT NOCOPY VARCHAR2,
113 p_collab_assoc_rec_type IN collab_assoc_rec_type,
114 x_collab_item_id OUT NOCOPY NUMBER
115 );
116
117
118 END AMS_Collab_assoc_PVT;
[Home] [Help]