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
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
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
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
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
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
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
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
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
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
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
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
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
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:
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(
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
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
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: