PACKAGE: APPS.AMS_IBA_PS_POSTINGS_B_PKG

Source

1 PACKAGE AMS_IBA_PS_POSTINGS_B_PKG AUTHID CURRENT_USER AS
2 /* $Header: amstpsts.pls 115.7 2002/12/19 04:17:02 ryedator ship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 --          AMS_IBA_PS_POSTINGS_B_PKG
7 -- Purpose
8 --
9 -- History
10 --
11 -- NOTE
12 --
13 -- End of Comments
14 -- ===============================================================
15 
16 PROCEDURE Insert_Row(
17           p_created_by    NUMBER,
18           p_creation_date    DATE,
19           p_last_updated_by    NUMBER,
20           p_last_update_date    DATE,
21           p_last_update_login    NUMBER,
22           px_object_version_number   IN OUT NOCOPY NUMBER,
23           px_posting_id   IN OUT NOCOPY NUMBER,
24           p_max_no_contents    NUMBER,
25           p_posting_type    VARCHAR2,
26           p_content_type    VARCHAR2,
27           p_default_content_id    NUMBER,
28           p_status_code    VARCHAR2,
29 	  p_posting_name   IN VARCHAR2,
30 	  p_display_name   IN VARCHAR2,
31 	  p_posting_description IN VARCHAR2,
32           p_attribute_category    VARCHAR2,
33           p_attribute1    VARCHAR2,
34           p_attribute2    VARCHAR2,
35           p_attribute3    VARCHAR2,
36           p_attribute4    VARCHAR2,
37           p_attribute5    VARCHAR2,
38           p_attribute6    VARCHAR2,
39           p_attribute7    VARCHAR2,
40           p_attribute8    VARCHAR2,
41           p_attribute9    VARCHAR2,
42           p_attribute10    VARCHAR2,
43           p_attribute11    VARCHAR2,
44           p_attribute12    VARCHAR2,
45           p_attribute13    VARCHAR2,
46           p_attribute14    VARCHAR2,
47           p_attribute15    VARCHAR2);
48 
49 PROCEDURE Update_Row(
50           p_created_by    NUMBER,
51           p_creation_date    DATE,
52           p_last_updated_by    NUMBER,
53           p_last_update_date    DATE,
54           p_last_update_login    NUMBER,
55           p_object_version_number    NUMBER,
56           p_posting_id    NUMBER,
57           p_max_no_contents    NUMBER,
58           p_posting_type    VARCHAR2,
59           p_content_type    VARCHAR2,
60           p_default_content_id    NUMBER,
61           p_status_code    VARCHAR2,
62           p_posting_name   IN VARCHAR2,
63           p_display_name   IN VARCHAR2,
64           p_posting_description IN VARCHAR2,
65           p_attribute_category    VARCHAR2,
66           p_attribute1    VARCHAR2,
67           p_attribute2    VARCHAR2,
68           p_attribute3    VARCHAR2,
69           p_attribute4    VARCHAR2,
70           p_attribute5    VARCHAR2,
71           p_attribute6    VARCHAR2,
72           p_attribute7    VARCHAR2,
73           p_attribute8    VARCHAR2,
74           p_attribute9    VARCHAR2,
75           p_attribute10    VARCHAR2,
76           p_attribute11    VARCHAR2,
77           p_attribute12    VARCHAR2,
78           p_attribute13    VARCHAR2,
79           p_attribute14    VARCHAR2,
80           p_attribute15    VARCHAR2);
81 
82 
83 PROCEDURE Delete_Row(
84     p_POSTING_ID  NUMBER);
85 
86 PROCEDURE Lock_Row(
87           p_created_by    NUMBER,
88           p_creation_date    DATE,
89           p_last_updated_by    NUMBER,
90           p_last_update_date    DATE,
91           p_last_update_login    NUMBER,
92           p_object_version_number    NUMBER,
93           p_posting_id    NUMBER,
94           p_max_no_contents    NUMBER,
95           p_posting_type    VARCHAR2,
96           p_content_type    VARCHAR2,
97           p_default_content_id    NUMBER,
98           p_status_code    VARCHAR2,
99           p_attribute_category    VARCHAR2,
100           p_attribute1    VARCHAR2,
101           p_attribute2    VARCHAR2,
102           p_attribute3    VARCHAR2,
103           p_attribute4    VARCHAR2,
104           p_attribute5    VARCHAR2,
105           p_attribute6    VARCHAR2,
106           p_attribute7    VARCHAR2,
107           p_attribute8    VARCHAR2,
108           p_attribute9    VARCHAR2,
109           p_attribute10    VARCHAR2,
110           p_attribute11    VARCHAR2,
111           p_attribute12    VARCHAR2,
112           p_attribute13    VARCHAR2,
113           p_attribute14    VARCHAR2,
114           p_attribute15    VARCHAR2);
115 
116 PROCEDURE ADD_LANGUAGE;
117 
118 END AMS_IBA_PS_POSTINGS_B_PKG;