248: from as_leads_all
249: where lead_id = p_lead_id;
250:
251: l_api_name CONSTANT VARCHAR2(40) := 'RECONCILE_SALESMETHODOLOGY';
252: header_rec AS_OPPORTUNITY_PUB.Header_Rec_Type;
253: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
254: l_lead_id NUMBER;
255: l_last_update_date date;
256: BEGIN
275: 'Before calling Update opp Header Lead id : ' || p_lead_id ||' Sales Force id :'|| P_Identity_Salesforce_Id ||
276: ' Sales Group Id :' || P_identity_salesgroup_id ||
277: ' Sales Methodology id :'||p_sales_methodology_id );
278: END IF;
279: AS_OPPORTUNITY_PUB.Update_Opp_header
280: (
281: p_api_version_number => p_api_version_number,
282: p_init_msg_list => p_init_msg_list,
283: p_commit => p_commit,