PACKAGE: APPS.AMS_CAT_ACTIVITIES_PKG

Source

1 PACKAGE AMS_CAT_ACTIVITIES_PKG AUTHID CURRENT_USER AS
2 /* $Header: amstcacs.pls 115.4 2002/12/27 11:38:51 cgoyal ship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 --          AMS_CAT_ACTIVITIES_PKG
7 -- Purpose
8 --
9 -- History
10 --       05-Nov-2001    musman    Commented out the reference to security_group_id
11 --
12 -- NOTE
13 --
14 -- End of Comments
15 -- ===============================================================
16 
17 PROCEDURE Insert_Row(
18           px_cat_activity_id   IN OUT NOCOPY NUMBER,
19           px_object_version_number   IN OUT NOCOPY NUMBER,
20           p_category_id    NUMBER,
21           p_activity_id    NUMBER,
22           p_last_update_date    DATE,
23           p_last_updated_by    NUMBER,
24           p_creation_date    DATE,
25           p_created_by    NUMBER,
26           p_last_update_login    NUMBER,
27           --p_security_group_id    NUMBER,
28           p_attribute_category    VARCHAR2,
29           p_attribute1    VARCHAR2,
30           p_attribute2    VARCHAR2,
31           p_attribute3    VARCHAR2,
32           p_attribute4    VARCHAR2,
33           p_attribute5    VARCHAR2,
34           p_attribute6    VARCHAR2,
35           p_attribute7    VARCHAR2,
36           p_attribute8    VARCHAR2,
37           p_attribute9    VARCHAR2,
38           p_attribute10    VARCHAR2,
39           p_attribute11    VARCHAR2,
40           p_attribute12    VARCHAR2,
41           p_attribute13    VARCHAR2,
42           p_attribute14    VARCHAR2,
43           p_attribute15    VARCHAR2);
44 
45 PROCEDURE Update_Row(
46           p_cat_activity_id    NUMBER,
47           p_object_version_number    NUMBER,
48           p_category_id    NUMBER,
49           p_activity_id    NUMBER,
50           p_last_update_date    DATE,
51           p_last_updated_by    NUMBER,
52           p_creation_date    DATE,
53           p_created_by    NUMBER,
54           p_last_update_login    NUMBER,
55           --p_security_group_id    NUMBER,
56           p_attribute_category    VARCHAR2,
57           p_attribute1    VARCHAR2,
58           p_attribute2    VARCHAR2,
59           p_attribute3    VARCHAR2,
60           p_attribute4    VARCHAR2,
61           p_attribute5    VARCHAR2,
62           p_attribute6    VARCHAR2,
63           p_attribute7    VARCHAR2,
64           p_attribute8    VARCHAR2,
65           p_attribute9    VARCHAR2,
66           p_attribute10    VARCHAR2,
67           p_attribute11    VARCHAR2,
68           p_attribute12    VARCHAR2,
69           p_attribute13    VARCHAR2,
70           p_attribute14    VARCHAR2,
71           p_attribute15    VARCHAR2);
72 
73 PROCEDURE Delete_Row(
74     p_CAT_ACTIVITY_ID  NUMBER,
75     p_object_version_number NUMBER);
76 PROCEDURE Lock_Row(
77           p_cat_activity_id    NUMBER,
78           p_object_version_number    NUMBER,
79           p_category_id    NUMBER,
80           p_activity_id    NUMBER,
81           p_last_update_date    DATE,
82           p_last_updated_by    NUMBER,
83           p_creation_date    DATE,
84           p_created_by    NUMBER,
85           p_last_update_login    NUMBER,
86           --p_security_group_id    NUMBER,
87           p_attribute_category    VARCHAR2,
88           p_attribute1    VARCHAR2,
89           p_attribute2    VARCHAR2,
90           p_attribute3    VARCHAR2,
91           p_attribute4    VARCHAR2,
92           p_attribute5    VARCHAR2,
93           p_attribute6    VARCHAR2,
94           p_attribute7    VARCHAR2,
95           p_attribute8    VARCHAR2,
96           p_attribute9    VARCHAR2,
97           p_attribute10    VARCHAR2,
98           p_attribute11    VARCHAR2,
99           p_attribute12    VARCHAR2,
100           p_attribute13    VARCHAR2,
101           p_attribute14    VARCHAR2,
102           p_attribute15    VARCHAR2);
103 
104 END AMS_CAT_ACTIVITIES_PKG;