APPS.AS_LEAD_ASSIGN_WF dependencies on AS_SALES_LEADS

Line 156: FROM as_sales_leads

152: customer_id,
153: address_id,
154: assign_sales_group_id,
155: sales_lead_id
156: FROM as_sales_leads
157: WHERE sales_lead_id = x_sales_lead_id;
158:
159: l_sales_lead_id NUMBER;
160: l_resource_id NUMBER;

Line 161: l_sales_lead_rec AS_SALES_LEADS_PUB.sales_lead_rec_type ;

157: WHERE sales_lead_id = x_sales_lead_id;
158:
159: l_sales_lead_id NUMBER;
160: l_resource_id NUMBER;
161: l_sales_lead_rec AS_SALES_LEADS_PUB.sales_lead_rec_type ;
162: l_sales_lead_profile_tbl AS_UTILITY_PUB.Profile_Tbl_Type;
163: l_api_version_number NUMBER := 2.0;
164: l_cnt NUMBER := 0;
165: l_tt NUMBER := 0;

Line 199: AS_SALES_LEADS_PUB.update_sales_lead(

195: CLOSE c_sales_lead;
196:
197: l_sales_lead_rec.assign_to_salesforce_id := l_resource_id;
198:
199: AS_SALES_LEADS_PUB.update_sales_lead(
200: p_api_version_number => l_api_version_number
201: ,p_init_msg_list => fnd_api.g_false
202: ,p_commit => fnd_api.g_false
203: ,p_validation_level => 0 -- fnd_api.g_valid_level_full

Line 288: FROM as_sales_leads

284: result out VARCHAR2 )
285: IS
286: CURSOR c_lead_status (lead_id_in in number) IS
287: SELECT accept_flag
288: FROM as_sales_leads
289: WHERE sales_lead_id = lead_id_in;
290:
291: l_accept_flag VARCHAR2(50);
292: l_sales_lead_id NUMBER;