1 PACKAGE AS_SALES_LEAD_OWNER AUTHID CURRENT_USER AS
2 /* $Header: asxvslns.pls 115.5 2002/11/22 07:20:52 aanjaria ship $ */
3
4
5 TYPE lead_owner_rec_type IS RECORD
6 (
7 LEAD_OWNER_ID NUMBER,
8 CATEGORY VARCHAR2(30),
9 COUNTRY VARCHAR2(100),
10 FROM_POSTAL_CODE VARCHAR2(40),
11 TO_POSTAL_CODE VARCHAR2(40),
12 CM_RESOURCE_ID NUMBER,
13 REFERRAL_TYPE VARCHAR2(30),
14 OWNER_FLAG VARCHAR2(1),
15 LAST_UPDATE_DATE DATE,
16 LAST_UPDATED_BY NUMBER,
17 CREATION_DATE DATE,
18 CREATED_BY NUMBER,
19 LAST_UPDATE_LOGIN NUMBER,
20 OBJECT_VERSION_NUMBER NUMBER,
21 REQUEST_ID NUMBER,
22 PROGRAM_APPLICATION_ID NUMBER,
23 PROGRAM_ID NUMBER,
24 PROGRAM_UPDATE_DATE DATE
25 );
26
27 type lead_owner_rec_tbl_type is TABLE OF lead_owner_rec_type;
28
29 ---------------------------------------------------------------------
30 -- PROCEDURE
31 -- Create_Lead_Owner
32 --
33 -- PURPOSE
34 -- Create a new mdf owner record
35 --
36 -- PARAMETERS
37 -- p_lead_owner_rec : the new record to be inserted
38 -- x_lead_owner_id : return the LEAD_OWNER_id of the new record.
39 --
40 -- NOTES
41 -- 1. object_version_number will be set to 1.
42 -- 2. If lead_owner_id is passed in, the uniqueness will be checked.
43 -- Raise exception in case of duplicates.
44 -- 3. If lead_owner_id is not passed in, generate a unique one from
45 -- the sequence.
46 -- 4. If a flag column is passed in, check if it is 'Y' or 'N'.
47 -- Raise exception for invalid flag.
48 -- 5. If a flag column is not passed in, default it to 'Y' or 'N'.
49 -- 6. Please don't pass in any FND_API.g_mess_char/num/date.
50 ---------------------------------------------------------------------
51 PROCEDURE Create_Lead_Owner(
52 p_api_version IN NUMBER
53 ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
54 ,p_commit IN VARCHAR2 := FND_API.g_false
55 ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
56
57 ,x_return_status OUT NOCOPY VARCHAR2
58 ,x_msg_count OUT NOCOPY NUMBER
59 ,x_msg_data OUT NOCOPY VARCHAR2
60
61 ,p_LEAD_OWNER_rec IN LEAD_OWNER_rec_type
62 ,x_LEAD_OWNER_id OUT NOCOPY NUMBER
63 );
64
65
66 --------------------------------------------------------------------
67 -- PROCEDURE
68 -- Delete_Lead_Owner
69 --
70 -- PURPOSE
71 -- Delete a lead_owner_id.
72 --
73 -- PARAMETERS
74 -- p_lead_owner_id: the lead_owner_id
75 -- p_object_version: the object_version_number
76 --
77 -- NOTES
78 -- 1. Raise exception if the object_version_number doesn't match.
79 --------------------------------------------------------------------
80 PROCEDURE Delete_Lead_Owner(
81 p_api_version IN NUMBER
82 ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
83 ,p_commit IN VARCHAR2 := FND_API.g_false
84
85 ,x_return_status OUT NOCOPY VARCHAR2
86 ,x_msg_count OUT NOCOPY NUMBER
87 ,x_msg_data OUT NOCOPY VARCHAR2
88
89 ,p_LEAD_OWNER_id IN NUMBER
90 ,p_object_version IN NUMBER
91
92 );
93
94 ---------------------------------------------------------------------
95 -- PROCEDURE
96 -- Update_Lead_Owner
97 --
98 -- PURPOSE
99 -- Update a Lead_Owner.
100 --
101 -- PARAMETERS
102 -- p_lead_owner_rec: the record with new items.
103 -- p_mode : determines what sort of validation is to be performed during update.
104 --
105 -- NOTES
106 -- 1. Raise exception if the object_version_number doesn't match.
107 -- 2. If an attribute is passed in as FND_API.g_miss_char/num/date,
108 -- that column won't be updated.
109 ----------------------------------------------------------------------
110 PROCEDURE Update_Lead_Owner(
111 p_api_version IN NUMBER
112 ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
113 ,p_commit IN VARCHAR2 := FND_API.g_false
114 ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
115
116 ,x_return_status OUT NOCOPY VARCHAR2
117 ,x_msg_count OUT NOCOPY NUMBER
118 ,x_msg_data OUT NOCOPY VARCHAR2
119 ,p_LEAD_OWNER_rec IN LEAD_OWNER_rec_type
120
121 );
122
123 ---------------------------------------------------------------------
124 -- PROCEDURE
125 -- Get_Salesreps
126 --
127 -- PURPOSE
128 -- Get the salesreps based on the country, postal code
129 --
130 -- PARAMETERS
131 -- p_lead_id : lead_id
132 --
133 -- NOTES
134 -- 1. Raise exception if the object_version_number doesn't match.
135 -- 2. If an attribute is passed in as FND_API.g_miss_char/num/date,
136 -- that column won't be updated.
137 ----------------------------------------------------------------------
138 PROCEDURE Get_Salesreps(
139 p_api_version IN NUMBER
140 ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
141 ,p_commit IN VARCHAR2 := FND_API.g_false
142 ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
143
144 ,p_sales_lead_id IN NUMBER
145 ,x_salesreps_tbl OUT NOCOPY lead_owner_rec_tbl_type
146
147 ,x_return_status OUT NOCOPY VARCHAR2
148 ,x_msg_count OUT NOCOPY NUMBER
149 ,x_msg_data OUT NOCOPY VARCHAR2
150 );
151
152 ---------------------------------------------------------------------
153 -- PROCEDURE
154 -- Get_Immatured_Lead_Owner
155 --
156 -- PURPOSE
157 -- Get the lead owner for matured lead
158 --
159 -- PARAMETERS
160 -- p_lead_id : lead_id
161 --
162 -- NOTES
163 -- 1. Raise exception if the object_version_number doesn't match.
164 -- 2. If an attribute is passed in as FND_API.g_miss_char/num/date,
165 -- that column won't be updated.
166 -- 3. Returns the saleforce id of the marketing owner
167 ----------------------------------------------------------------------
168 PROCEDURE Get_Immatured_Lead_Owner(
169 p_api_version IN NUMBER
170 ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
171 ,p_commit IN VARCHAR2 := FND_API.g_false
172 ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
173
174 ,p_sales_lead_id IN NUMBER
175 ,x_salesforce_id OUT NOCOPY NUMBER
176
177 ,x_return_status OUT NOCOPY VARCHAR2
178 ,x_msg_count OUT NOCOPY NUMBER
179 ,x_msg_data OUT NOCOPY VARCHAR2
180 );
181
182 END AS_SALES_LEAD_OWNER;