[Home] [Help]
PACKAGE: APPS.AS_SALES_LEAD_LINES_PKG
Source
1 PACKAGE AS_SALES_LEAD_LINES_PKG AUTHID CURRENT_USER as
2 /* $Header: asxtslls.pls 115.5 2003/09/18 22:22:47 ckapoor ship $ */
3 -- Start of Comments
4 -- Package name : AS_SALES_LEAD_LINES_PKG
5 -- Purpose : Sales lead lines table handlers
6 -- NOTE :
7 -- History : 04/09/2001 FFANG Created
8 --
9 -- End of Comments
10
11
12
13 PROCEDURE Sales_Lead_Line_Insert_Row(
14 px_SALES_LEAD_LINE_ID IN OUT NOCOPY NUMBER,
15 p_LAST_UPDATE_DATE DATE,
16 p_LAST_UPDATED_BY NUMBER,
17 p_CREATION_DATE DATE,
18 p_CREATED_BY NUMBER,
19 p_LAST_UPDATE_LOGIN NUMBER,
20 p_REQUEST_ID NUMBER,
21 p_PROGRAM_APPLICATION_ID NUMBER,
22 p_PROGRAM_ID NUMBER,
23 p_PROGRAM_UPDATE_DATE DATE,
24 p_SALES_LEAD_ID NUMBER,
25 p_STATUS_CODE VARCHAR2,
26
27 -- 11.5.10 Rivendell product category changes
28
29 --p_INTEREST_TYPE_ID NUMBER,
30 --p_PRIMARY_INTEREST_CODE_ID NUMBER,
31 --p_SECONDARY_INTEREST_CODE_ID NUMBER,
32
33 p_CATEGORY_ID NUMBER,
34 p_CATEGORY_SET_ID NUMBER,
35
36 p_INVENTORY_ITEM_ID NUMBER,
37 p_ORGANIZATION_ID NUMBER,
38 p_UOM_CODE VARCHAR2,
39 p_QUANTITY NUMBER,
40 p_BUDGET_AMOUNT NUMBER,
41 p_SOURCE_PROMOTION_ID NUMBER,
42 p_ATTRIBUTE_CATEGORY VARCHAR2,
43 p_ATTRIBUTE1 VARCHAR2,
44 p_ATTRIBUTE2 VARCHAR2,
45 p_ATTRIBUTE3 VARCHAR2,
46 p_ATTRIBUTE4 VARCHAR2,
47 p_ATTRIBUTE5 VARCHAR2,
48 p_ATTRIBUTE6 VARCHAR2,
49 p_ATTRIBUTE7 VARCHAR2,
50 p_ATTRIBUTE8 VARCHAR2,
51 p_ATTRIBUTE9 VARCHAR2,
52 p_ATTRIBUTE10 VARCHAR2,
53 p_ATTRIBUTE11 VARCHAR2,
54 p_ATTRIBUTE12 VARCHAR2,
55 p_ATTRIBUTE13 VARCHAR2,
56 p_ATTRIBUTE14 VARCHAR2,
57 p_ATTRIBUTE15 VARCHAR2,
58 p_OFFER_ID NUMBER);
59 -- p_SECURITY_GROUP_ID NUMBER);
60
61
62 PROCEDURE Sales_Lead_Line_Update_Row(
63 p_SALES_LEAD_LINE_ID NUMBER,
64 p_LAST_UPDATE_DATE DATE,
65 p_LAST_UPDATED_BY NUMBER,
66 p_CREATION_DATE DATE,
67 p_CREATED_BY NUMBER,
68 p_LAST_UPDATE_LOGIN NUMBER,
69 p_REQUEST_ID NUMBER,
70 p_PROGRAM_APPLICATION_ID NUMBER,
71 p_PROGRAM_ID NUMBER,
72 p_PROGRAM_UPDATE_DATE DATE,
73 p_SALES_LEAD_ID NUMBER,
74 p_STATUS_CODE VARCHAR2,
75
76 -- 11.5.10 rivendell product category changes
77
78 --p_INTEREST_TYPE_ID NUMBER,
79 --p_PRIMARY_INTEREST_CODE_ID NUMBER,
80 --p_SECONDARY_INTEREST_CODE_ID NUMBER,
81
82 p_CATEGORY_ID NUMBER,
83 p_CATEGORY_SET_ID NUMBER,
84
85
86 p_INVENTORY_ITEM_ID NUMBER,
87 p_ORGANIZATION_ID NUMBER,
88 p_UOM_CODE VARCHAR2,
89 p_QUANTITY NUMBER,
90 p_BUDGET_AMOUNT NUMBER,
91 p_SOURCE_PROMOTION_ID NUMBER,
92 p_ATTRIBUTE_CATEGORY VARCHAR2,
93 p_ATTRIBUTE1 VARCHAR2,
94 p_ATTRIBUTE2 VARCHAR2,
95 p_ATTRIBUTE3 VARCHAR2,
96 p_ATTRIBUTE4 VARCHAR2,
97 p_ATTRIBUTE5 VARCHAR2,
98 p_ATTRIBUTE6 VARCHAR2,
99 p_ATTRIBUTE7 VARCHAR2,
100 p_ATTRIBUTE8 VARCHAR2,
101 p_ATTRIBUTE9 VARCHAR2,
102 p_ATTRIBUTE10 VARCHAR2,
103 p_ATTRIBUTE11 VARCHAR2,
104 p_ATTRIBUTE12 VARCHAR2,
105 p_ATTRIBUTE13 VARCHAR2,
106 p_ATTRIBUTE14 VARCHAR2,
107 p_ATTRIBUTE15 VARCHAR2,
108 p_OFFER_ID NUMBER);
109 -- p_SECURITY_GROUP_ID NUMBER);
110
111
112 PROCEDURE Sales_Lead_Line_Delete_Row( p_sales_lead_line_id NUMBER);
113
114
115 PROCEDURE Sales_Lead_Line_Lock_Row(
116 p_SALES_LEAD_LINE_ID NUMBER,
117 p_LAST_UPDATE_DATE DATE,
118 p_LAST_UPDATED_BY NUMBER,
119 p_CREATION_DATE DATE,
120 p_CREATED_BY NUMBER,
121 p_LAST_UPDATE_LOGIN NUMBER,
122 p_REQUEST_ID NUMBER,
123 p_PROGRAM_APPLICATION_ID NUMBER,
124 p_PROGRAM_ID NUMBER,
125 p_PROGRAM_UPDATE_DATE DATE,
126 p_SALES_LEAD_ID NUMBER,
127 p_STATUS_CODE VARCHAR2,
128
129 -- 11.5.10 rivendell product category changes
130
131 --p_INTEREST_TYPE_ID NUMBER,
132 --p_PRIMARY_INTEREST_CODE_ID NUMBER,
133 --p_SECONDARY_INTEREST_CODE_ID NUMBER,
134
135 p_CATEGORY_ID NUMBER,
136 p_CATEGORY_SET_ID NUMBER,
137
138 p_INVENTORY_ITEM_ID NUMBER,
139 p_ORGANIZATION_ID NUMBER,
140 p_UOM_CODE VARCHAR2,
141 p_QUANTITY NUMBER,
142 p_BUDGET_AMOUNT NUMBER,
143 p_SOURCE_PROMOTION_ID NUMBER,
144 p_ATTRIBUTE_CATEGORY VARCHAR2,
145 p_ATTRIBUTE1 VARCHAR2,
146 p_ATTRIBUTE2 VARCHAR2,
147 p_ATTRIBUTE3 VARCHAR2,
148 p_ATTRIBUTE4 VARCHAR2,
149 p_ATTRIBUTE5 VARCHAR2,
150 p_ATTRIBUTE6 VARCHAR2,
151 p_ATTRIBUTE7 VARCHAR2,
152 p_ATTRIBUTE8 VARCHAR2,
153 p_ATTRIBUTE9 VARCHAR2,
154 p_ATTRIBUTE10 VARCHAR2,
155 p_ATTRIBUTE11 VARCHAR2,
156 p_ATTRIBUTE12 VARCHAR2,
157 p_ATTRIBUTE13 VARCHAR2,
158 p_ATTRIBUTE14 VARCHAR2,
159 p_ATTRIBUTE15 VARCHAR2,
160 p_OFFER_ID NUMBER);
161 -- p_SECURITY_GROUP_ID NUMBER);
162
163
164
165 End AS_SALES_LEAD_LINES_PKG;