[Home] [Help]
PACKAGE: APPS.AMS_WEB_CITEM_ASSOC_PKG
Source
1 PACKAGE AMS_WEB_CITEM_ASSOC_PKG AS
2 /* $Header: amstwmps.pls 120.0 2005/07/01 03:54:21 appldev noship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- AMS_WEB_CITEM_ASSOC_PKG
7 -- Purpose
8 -- Table api to insert/update/delete WebPlanner Citems Associations.
9 -- History
10 -- 10-May-2005 sikalyan Created.
11 -- NOTE
12 --
13 -- End of Comments
14 -- ===============================================================
15
16
17 -- ===============================================================
18 -- Start of Comments
19 -- Procedure name
20 -- Insert_Row
21 -- Purpose
22 -- Table api to insert WebPlanner Citems Associations.
23 -- History
24 -- 10-May-2005 sikalyan Created.
25 -- NOTE
26 --
27 -- End of Comments
28 -- ===============================================================
29
30 PROCEDURE Insert_Row(
31 px_placement_citem_id IN OUT NOCOPY NUMBER,
32 p_placement_mp_id NUMBER,
33 p_content_item_id NUMBER,
34 p_citem_version_id NUMBER,
35 p_created_by NUMBER,
36 p_creation_date DATE,
37 p_last_updated_by NUMBER,
38 p_last_update_date DATE,
39 p_last_update_login NUMBER,
40 px_object_version_number IN OUT NOCOPY NUMBER,
41 p_return_status OUT NOCOPY VARCHAR2,
42 p_msg_count OUT NOCOPY NUMBER,
43 p_msg_data OUT NOCOPY VARCHAR2
44 );
45
46 -- ===============================================================
47 -- Start of Comments
48 -- Procedure name
49 -- Update_Row
50 -- Purpose
51 -- Table api to update WebPlanner Citems Associations.
52 -- History
53 -- 10-May-2005 sikalyan Created.
54 -- NOTE
55 --
56 -- End of Comments
57 -- ===============================================================
58
59 PROCEDURE Update_Row (
60 p_placement_citem_id NUMBER,
61 p_placement_mp_id NUMBER,
62 p_content_item_id NUMBER,
63 p_citem_version_id NUMBER,
64 p_created_by NUMBER,
65 p_creation_date DATE,
66 p_last_updated_by NUMBER,
67 p_last_update_date DATE,
68 p_last_update_login NUMBER,
69 p_object_version_number NUMBER);
70
71 -- ===============================================================
72 -- Start of Comments
73 -- Procedure name
74 -- Delete_Row
75 -- Purpose
76 -- Table api to Delete WebPlanner Citems Associations..
77 -- History
78 -- 10-May-2005 sikalyan Created.
79 -- NOTE
80 --
81 -- End of Comments
82 -- ===============================================================
83
84 PROCEDURE Delete_Row(
85 p_placement_citem_id NUMBER,
86 p_object_version_number NUMBER);
87
88
89 -- ===============================================================
90 -- Start of Comments
91 -- Procedure name
92 -- Lock_Row
93 -- Purpose
94 -- Table api to lock WebPlanner Citems Associations..
95 -- History
96 -- 10-May-2005 sikalyan Created.
97 -- NOTE
98 --
99 -- End of Comments
100 -- ===============================================================
101
102 PROCEDURE Lock_Row(
103 p_placement_citem_id NUMBER,
104 p_placement_mp_id NUMBER,
105 p_content_item_id NUMBER,
106 p_citem_version_id NUMBER,
107 p_created_by NUMBER,
108 p_creation_date DATE,
109 p_last_updated_by NUMBER,
110 p_last_update_date DATE,
111 p_last_update_login NUMBER,
112 p_object_version_number NUMBER);
113
114
115 PROCEDURE load_row (
116 x_placement_citem_id IN NUMBER,
117 x_placement_mp_id IN NUMBER,
118 x_content_item_id IN NUMBER,
119 x_citem_version_id IN NUMBER,
120 x_p_created_by IN NUMBER,
121 x_p_creation_date IN DATE,
122 x_p_last_updated_by IN NUMBER,
123 x_p_last_update_date IN DATE,
124 x_p_last_update_login IN NUMBER,
125 x_p_object_version_number IN NUMBER,
126 x_owner IN VARCHAR2,
127 x_custom_mode IN VARCHAR2
128 );
129
130
131 END AMS_WEB_CITEM_ASSOC_PKG;