41: p_debug_mode IN VARCHAR2)
42: IS
43: CURSOR c_sales_lead IS
44: SELECT sales_lead_id, assign_to_salesforce_id
45: FROM as_sales_leads
46: WHERE nvl(status_code, 'NULL') <> 'DECLINED'
47: AND nvl(deleted_flag,'NULL') <> 'Y';
48:
49: l_request_id NUMBER;
140: l_sales_lead_id NUMBER;
141:
142: CURSOR c_sales_lead (sales_lead_id_in NUMBER) IS
143: SELECT assign_to_salesforce_id
144: FROM as_sales_leads
145: WHERE sales_lead_id = sales_lead_id_in;
146:
147: BEGIN
148: Debug('*** ASXSLAGWF start ***');