[Home] [Help]
PACKAGE: APPS.AS_SALES_LEAD_OPP_PKG
Source
1 PACKAGE AS_SALES_LEAD_OPP_PKG AUTHID CURRENT_USER as
2 /* $Header: asxtslos.pls 120.1 2006/02/09 21:11:23 subabu noship $ */
3 -- Start of Comments
4 -- Package name : AS_SALES_LEAD_OPP_PKG
5 -- Purpose : Table handlers for AS_SALES_LEAD_OPPORTUNITY and
6 -- AS_SALES_LEAD_OPP_LINES
7 -- NOTE :
8 -- History : 04/09/2001 FFANG Created
9 --
10 -- End of Comments
11
12
13 PROCEDURE LEAD_OPPORTUNITY_Insert_Row(
14 px_LEAD_OPPORTUNITY_ID IN OUT NOCOPY NUMBER,
15 p_SALES_LEAD_ID NUMBER,
16 p_OPPORTUNITY_ID NUMBER,
17 p_LAST_UPDATE_DATE DATE,
18 p_LAST_UPDATED_BY NUMBER,
19 p_CREATION_DATE DATE,
20 p_CREATED_BY NUMBER,
21 p_LAST_UPDATE_LOGIN NUMBER,
22 p_REQUEST_ID NUMBER,
23 p_PROGRAM_APPLICATION_ID NUMBER,
24 p_PROGRAM_ID NUMBER,
25 p_PROGRAM_UPDATE_DATE DATE,
26 p_ATTRIBUTE_CATEGORY VARCHAR2,
27 p_ATTRIBUTE1 VARCHAR2,
28 p_ATTRIBUTE2 VARCHAR2,
29 p_ATTRIBUTE3 VARCHAR2,
30 p_ATTRIBUTE4 VARCHAR2,
31 p_ATTRIBUTE5 VARCHAR2,
32 p_ATTRIBUTE6 VARCHAR2,
33 p_ATTRIBUTE7 VARCHAR2,
34 p_ATTRIBUTE8 VARCHAR2,
35 p_ATTRIBUTE9 VARCHAR2,
36 p_ATTRIBUTE10 VARCHAR2,
37 p_ATTRIBUTE11 VARCHAR2,
38 p_ATTRIBUTE12 VARCHAR2,
39 p_ATTRIBUTE13 VARCHAR2,
40 p_ATTRIBUTE14 VARCHAR2,
41 p_ATTRIBUTE15 VARCHAR2);
42 -- p_SECURITY_GROUP_ID NUMBER);
43
44 PROCEDURE LEAD_OPPORTUNITY_Update_Row(
45 p_LEAD_OPPORTUNITY_ID NUMBER,
46 p_SALES_LEAD_ID NUMBER,
47 p_OPPORTUNITY_ID NUMBER,
48 p_LAST_UPDATE_DATE DATE,
49 p_LAST_UPDATED_BY NUMBER,
50 p_CREATION_DATE DATE,
51 p_CREATED_BY NUMBER,
52 p_LAST_UPDATE_LOGIN NUMBER,
53 p_REQUEST_ID NUMBER,
54 p_PROGRAM_APPLICATION_ID NUMBER,
55 p_PROGRAM_ID NUMBER,
56 p_PROGRAM_UPDATE_DATE DATE,
57 p_ATTRIBUTE_CATEGORY VARCHAR2,
58 p_ATTRIBUTE1 VARCHAR2,
59 p_ATTRIBUTE2 VARCHAR2,
60 p_ATTRIBUTE3 VARCHAR2,
61 p_ATTRIBUTE4 VARCHAR2,
62 p_ATTRIBUTE5 VARCHAR2,
63 p_ATTRIBUTE6 VARCHAR2,
64 p_ATTRIBUTE7 VARCHAR2,
65 p_ATTRIBUTE8 VARCHAR2,
66 p_ATTRIBUTE9 VARCHAR2,
67 p_ATTRIBUTE10 VARCHAR2,
68 p_ATTRIBUTE11 VARCHAR2,
69 p_ATTRIBUTE12 VARCHAR2,
70 p_ATTRIBUTE13 VARCHAR2,
71 p_ATTRIBUTE14 VARCHAR2,
72 p_ATTRIBUTE15 VARCHAR2);
73 -- p_SECURITY_GROUP_ID NUMBER);
74
75 PROCEDURE LEAD_OPPORTUNITY_Lock_Row(
76 p_LEAD_OPPORTUNITY_ID NUMBER,
77 p_SALES_LEAD_ID NUMBER,
78 p_OPPORTUNITY_ID NUMBER,
79 p_LAST_UPDATE_DATE DATE,
80 p_LAST_UPDATED_BY NUMBER,
81 p_CREATION_DATE DATE,
82 p_CREATED_BY NUMBER,
83 p_LAST_UPDATE_LOGIN NUMBER,
84 p_REQUEST_ID NUMBER,
85 p_PROGRAM_APPLICATION_ID NUMBER,
86 p_PROGRAM_ID NUMBER,
87 p_PROGRAM_UPDATE_DATE DATE,
88 p_ATTRIBUTE_CATEGORY VARCHAR2,
89 p_ATTRIBUTE1 VARCHAR2,
90 p_ATTRIBUTE2 VARCHAR2,
91 p_ATTRIBUTE3 VARCHAR2,
92 p_ATTRIBUTE4 VARCHAR2,
93 p_ATTRIBUTE5 VARCHAR2,
94 p_ATTRIBUTE6 VARCHAR2,
95 p_ATTRIBUTE7 VARCHAR2,
96 p_ATTRIBUTE8 VARCHAR2,
97 p_ATTRIBUTE9 VARCHAR2,
98 p_ATTRIBUTE10 VARCHAR2,
99 p_ATTRIBUTE11 VARCHAR2,
100 p_ATTRIBUTE12 VARCHAR2,
101 p_ATTRIBUTE13 VARCHAR2,
102 p_ATTRIBUTE14 VARCHAR2,
103 p_ATTRIBUTE15 VARCHAR2);
104 -- p_SECURITY_GROUP_ID NUMBER);
105
106 PROCEDURE LEAD_OPPORTUNITY_Delete_Row(
107 p_LEAD_OPPORTUNITY_ID NUMBER);
108
109 PROCEDURE LEAD_OPP_LINES_Insert_Row(
110 px_LEAD_OPP_LINE_ID IN OUT NOCOPY NUMBER,
111 p_SALES_LEAD_LINE_ID NUMBER,
112 p_OPP_LINE_ID NUMBER,
113 p_LAST_UPDATE_DATE DATE,
114 p_LAST_UPDATED_BY NUMBER,
115 p_CREATION_DATE DATE,
116 p_CREATED_BY NUMBER,
117 p_LAST_UPDATE_LOGIN NUMBER,
118 p_REQUEST_ID NUMBER,
119 p_PROGRAM_APPLICATION_ID NUMBER,
120 p_PROGRAM_ID NUMBER,
121 p_PROGRAM_UPDATE_DATE DATE,
122 p_ATTRIBUTE_CATEGORY VARCHAR2,
123 p_ATTRIBUTE1 VARCHAR2,
124 p_ATTRIBUTE2 VARCHAR2,
125 p_ATTRIBUTE3 VARCHAR2,
126 p_ATTRIBUTE4 VARCHAR2,
127 p_ATTRIBUTE5 VARCHAR2,
128 p_ATTRIBUTE6 VARCHAR2,
129 p_ATTRIBUTE7 VARCHAR2,
130 p_ATTRIBUTE8 VARCHAR2,
131 p_ATTRIBUTE9 VARCHAR2,
132 p_ATTRIBUTE10 VARCHAR2,
133 p_ATTRIBUTE11 VARCHAR2,
134 p_ATTRIBUTE12 VARCHAR2,
135 p_ATTRIBUTE13 VARCHAR2,
136 p_ATTRIBUTE14 VARCHAR2,
137 p_ATTRIBUTE15 VARCHAR2);
138 -- p_SECURITY_GROUP_ID NUMBER);
139
140 PROCEDURE LEAD_OPP_LINES_Update_Row(
141 p_LEAD_OPP_LINE_ID NUMBER,
142 p_SALES_LEAD_LINE_ID NUMBER,
143 p_OPP_LINE_ID NUMBER,
144 p_LAST_UPDATE_DATE DATE,
145 p_LAST_UPDATED_BY NUMBER,
146 p_CREATION_DATE DATE,
147 p_CREATED_BY NUMBER,
148 p_LAST_UPDATE_LOGIN NUMBER,
149 p_REQUEST_ID NUMBER,
150 p_PROGRAM_APPLICATION_ID NUMBER,
151 p_PROGRAM_ID NUMBER,
152 p_PROGRAM_UPDATE_DATE DATE,
153 p_ATTRIBUTE_CATEGORY VARCHAR2,
154 p_ATTRIBUTE1 VARCHAR2,
155 p_ATTRIBUTE2 VARCHAR2,
156 p_ATTRIBUTE3 VARCHAR2,
157 p_ATTRIBUTE4 VARCHAR2,
158 p_ATTRIBUTE5 VARCHAR2,
159 p_ATTRIBUTE6 VARCHAR2,
160 p_ATTRIBUTE7 VARCHAR2,
161 p_ATTRIBUTE8 VARCHAR2,
162 p_ATTRIBUTE9 VARCHAR2,
163 p_ATTRIBUTE10 VARCHAR2,
164 p_ATTRIBUTE11 VARCHAR2,
165 p_ATTRIBUTE12 VARCHAR2,
166 p_ATTRIBUTE13 VARCHAR2,
167 p_ATTRIBUTE14 VARCHAR2,
168 p_ATTRIBUTE15 VARCHAR2);
169 -- p_SECURITY_GROUP_ID NUMBER);
170
171 PROCEDURE LEAD_OPP_LINES_Lock_Row(
172 p_LEAD_OPP_LINE_ID NUMBER,
173 p_SALES_LEAD_LINE_ID NUMBER,
174 p_OPP_LINE_ID NUMBER,
175 p_LAST_UPDATE_DATE DATE,
176 p_LAST_UPDATED_BY NUMBER,
177 p_CREATION_DATE DATE,
178 p_CREATED_BY NUMBER,
179 p_LAST_UPDATE_LOGIN NUMBER,
180 p_REQUEST_ID NUMBER,
181 p_PROGRAM_APPLICATION_ID NUMBER,
182 p_PROGRAM_ID NUMBER,
183 p_PROGRAM_UPDATE_DATE DATE,
184 p_ATTRIBUTE_CATEGORY VARCHAR2,
185 p_ATTRIBUTE1 VARCHAR2,
186 p_ATTRIBUTE2 VARCHAR2,
187 p_ATTRIBUTE3 VARCHAR2,
188 p_ATTRIBUTE4 VARCHAR2,
189 p_ATTRIBUTE5 VARCHAR2,
190 p_ATTRIBUTE6 VARCHAR2,
191 p_ATTRIBUTE7 VARCHAR2,
192 p_ATTRIBUTE8 VARCHAR2,
193 p_ATTRIBUTE9 VARCHAR2,
194 p_ATTRIBUTE10 VARCHAR2,
195 p_ATTRIBUTE11 VARCHAR2,
196 p_ATTRIBUTE12 VARCHAR2,
197 p_ATTRIBUTE13 VARCHAR2,
198 p_ATTRIBUTE14 VARCHAR2,
199 p_ATTRIBUTE15 VARCHAR2);
200 -- p_SECURITY_GROUP_ID NUMBER);
201
202 PROCEDURE LEAD_OPP_LINES_Delete_Row(
203 p_LEAD_OPP_LINE_ID NUMBER);
204
205 End AS_SALES_LEAD_OPP_PKG;