PACKAGE: APPS.PV_PG_MEMBERSHIPS_PKG

Source

1 PACKAGE PV_Pg_Memberships_PKG AS
2 /* $Header: pvxtmems.pls 120.1 2005/10/24 09:35:47 dgottlie noship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 --          PV_Pg_Memberships_PKG
7 -- Purpose
8 --
9 -- History
10 --
11 -- NOTE
12 --
13 -- This Api is generated with Latest version of
14 -- Rosetta, where g_miss indicates NULL and
15 -- NULL indicates missing value. Rosetta Version 1.55
16 -- End of Comments
17 -- ===============================================================
18 
19 
20 
21 
22 --  ========================================================
23 --
24 --  NAME
25 --  Insert_Row
26 --
27 --  PURPOSE
28 --
29 --  NOTES
30 --
31 --  HISTORY
32 --
33 --  ========================================================
34 PROCEDURE Insert_Row(
35           px_membership_id   IN OUT NOCOPY NUMBER,
36           px_object_version_number   IN OUT NOCOPY NUMBER,
37           p_partner_id    NUMBER,
38           p_program_id    NUMBER,
39           p_start_date    DATE,
40           p_original_end_date    DATE,
41           p_actual_end_date    DATE,
42           p_membership_status_code    VARCHAR2,
43           p_status_reason_code    VARCHAR2,
44           p_enrl_request_id    NUMBER,
45           p_created_by    NUMBER,
46           p_creation_date    DATE,
47           p_last_updated_by    NUMBER,
48           p_last_update_date    DATE,
49           p_last_update_login    NUMBER,
50 	  p_attribute1	VARCHAR2,
51 	  p_attribute2	VARCHAR2,
52 	  p_attribute3	VARCHAR2,
53 	  p_attribute4	VARCHAR2,
54 	  p_attribute5	VARCHAR2,
55 	  p_attribute6	VARCHAR2,
56 	  p_attribute7	VARCHAR2,
57 	  p_attribute8	VARCHAR2,
58 	  p_attribute9	VARCHAR2,
59 	  p_attribute10	VARCHAR2,
60 	  p_attribute11	VARCHAR2,
61 	  p_attribute12	VARCHAR2,
62 	  p_attribute13	VARCHAR2,
63 	  p_attribute14	VARCHAR2,
64 	  p_attribute15	VARCHAR2);
65 
66 
67 
68 
69 
70 --  ========================================================
71 --
72 --  NAME
73 --  Update_Row
74 --
75 --  PURPOSE
76 --
77 --  NOTES
78 --
79 --  HISTORY
80 --
81 --  ========================================================
82 PROCEDURE Update_Row(
83           p_membership_id    NUMBER,
84           p_object_version_number   IN NUMBER,
85           p_partner_id    NUMBER,
86           p_program_id    NUMBER,
87           p_start_date    DATE,
88           p_original_end_date    DATE,
89           p_actual_end_date    DATE,
90           p_membership_status_code    VARCHAR2,
91           p_status_reason_code    VARCHAR2,
92           p_enrl_request_id    NUMBER,
93           p_last_updated_by    NUMBER,
94           p_last_update_date    DATE,
95           p_last_update_login    NUMBER,
96 	  p_attribute1	VARCHAR2,
97 	  p_attribute2	VARCHAR2,
98 	  p_attribute3	VARCHAR2,
99 	  p_attribute4	VARCHAR2,
100 	  p_attribute5	VARCHAR2,
101 	  p_attribute6	VARCHAR2,
102 	  p_attribute7	VARCHAR2,
103 	  p_attribute8	VARCHAR2,
104 	  p_attribute9	VARCHAR2,
105 	  p_attribute10	VARCHAR2,
106 	  p_attribute11	VARCHAR2,
107 	  p_attribute12	VARCHAR2,
108 	  p_attribute13	VARCHAR2,
109 	  p_attribute14	VARCHAR2,
110 	  p_attribute15	VARCHAR2);
111 
112 
113 
114 
115 
116 --  ========================================================
117 --
118 --  NAME
119 --  Delete_Row
120 --
121 --  PURPOSE
122 --
123 --  NOTES
124 --
125 --  HISTORY
126 --
127 --  ========================================================
128 PROCEDURE Delete_Row(
129     p_membership_id  NUMBER,
130     p_object_version_number  NUMBER);
131 
132 
133 
134 
135 --  ========================================================
136 --
137 --  NAME
138 --  Lock_Row
139 --
140 --  PURPOSE
141 --
142 --  NOTES
143 --
144 --  HISTORY
145 --
146 --  ========================================================
147 PROCEDURE Lock_Row(
148     p_membership_id  NUMBER,
149     p_object_version_number  NUMBER);
150 
151 
152 END PV_Pg_Memberships_PKG;