373: and mem.resource_id = X_Resource_Id;
374:
375: l_api_name CONSTANT VARCHAR2(30) := 'Assign_Sales_Lead';
376: l_api_version_number CONSTANT NUMBER := 2.0;
377: l_AssignResources_Tbl JTF_ASSIGN_PUB.AssignResources_Tbl_type;
378: -- JTF_TERRITORY_PUB.WinningTerrMember_tbl_type;
379: l_AssignResources_Rec JTF_ASSIGN_PUB.AssignResources_Rec_type;
380: -- JTF_TERRITORY_PUB.JTF_Lead_rec_type;
381: -- l_lead_rec JTF_ASSIGN_PUB.JTF_Lead_rec_type;
375: l_api_name CONSTANT VARCHAR2(30) := 'Assign_Sales_Lead';
376: l_api_version_number CONSTANT NUMBER := 2.0;
377: l_AssignResources_Tbl JTF_ASSIGN_PUB.AssignResources_Tbl_type;
378: -- JTF_TERRITORY_PUB.WinningTerrMember_tbl_type;
379: l_AssignResources_Rec JTF_ASSIGN_PUB.AssignResources_Rec_type;
380: -- JTF_TERRITORY_PUB.JTF_Lead_rec_type;
381: -- l_lead_rec JTF_ASSIGN_PUB.JTF_Lead_rec_type;
382: l_lead_rec JTF_TERRITORY_PUB.JTF_Lead_BULK_rec_type;
383: l_resource_id NUMBER;
377: l_AssignResources_Tbl JTF_ASSIGN_PUB.AssignResources_Tbl_type;
378: -- JTF_TERRITORY_PUB.WinningTerrMember_tbl_type;
379: l_AssignResources_Rec JTF_ASSIGN_PUB.AssignResources_Rec_type;
380: -- JTF_TERRITORY_PUB.JTF_Lead_rec_type;
381: -- l_lead_rec JTF_ASSIGN_PUB.JTF_Lead_rec_type;
382: l_lead_rec JTF_TERRITORY_PUB.JTF_Lead_BULK_rec_type;
383: l_resource_id NUMBER;
384: l_count INTEGER := 0;
385: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;
578: nvl(FND_PROFILE.Value('AS_SL_ASSIGN_CALENDAR_REQ'),'N');
579:
580: IF (AS_DEBUG_LOW_ON) THEN
581: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
582: 'Calling JTF_ASSIGN_PUB.Get_Assign_Lead_Resources');
583: END IF;
584:
585: JTF_ASSIGN_PUB.Get_Assign_Lead_Resources (
586: p_api_version => 1.0
581: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
582: 'Calling JTF_ASSIGN_PUB.Get_Assign_Lead_Resources');
583: END IF;
584:
585: JTF_ASSIGN_PUB.Get_Assign_Lead_Resources (
586: p_api_version => 1.0
587: ,p_init_msg_list => JTF_ASSIGN_PUB.AM_FALSE
588: -- ,p_commit => FND_API.G_FALSE
589: ,p_resource_type => p_resource_type
583: END IF;
584:
585: JTF_ASSIGN_PUB.Get_Assign_Lead_Resources (
586: p_api_version => 1.0
587: ,p_init_msg_list => JTF_ASSIGN_PUB.AM_FALSE
588: -- ,p_commit => FND_API.G_FALSE
589: ,p_resource_type => p_resource_type
590: ,p_role => p_role
591: ,p_no_of_resources => p_no_of_resources
605: );
606:
607: IF (AS_DEBUG_LOW_ON) THEN
608: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
609: 'After JTF_ASSIGN_PUB.Get_Assign_Lead_Resources:' ||
610: x_return_status);
611: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
612: 'count=' || l_assignresources_tbl.count);
613: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
638: END IF;
639:
640: IF (AS_DEBUG_LOW_ON) THEN
641: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
642: 'After JTF_ASSIGN_PUB.Get_Assign_Lead_Resources:');
643: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
644: 'l_assignresources_tbl.count: ' || l_assignresources_tbl.count);
645: END IF;
646:
1216: l_partner_name VARCHAR2(360);
1217:
1218: l_lead_owner_tbl AS_SALES_LEAD_OWNER.lead_owner_rec_tbl_type;
1219:
1220: l_AssignResources_Tbl JTF_ASSIGN_PUB.AssignResources_Tbl_type;
1221: -- JTF_TERRITORY_PUB.WinningTerrMember_tbl_type;
1222: l_AssignResources_Rec JTF_ASSIGN_PUB.AssignResources_Rec_type;
1223: -- JTF_TERRITORY_PUB.JTF_Lead_rec_type;
1224: -- l_lead_rec JTF_ASSIGN_PUB.JTF_Lead_rec_type;
1218: l_lead_owner_tbl AS_SALES_LEAD_OWNER.lead_owner_rec_tbl_type;
1219:
1220: l_AssignResources_Tbl JTF_ASSIGN_PUB.AssignResources_Tbl_type;
1221: -- JTF_TERRITORY_PUB.WinningTerrMember_tbl_type;
1222: l_AssignResources_Rec JTF_ASSIGN_PUB.AssignResources_Rec_type;
1223: -- JTF_TERRITORY_PUB.JTF_Lead_rec_type;
1224: -- l_lead_rec JTF_ASSIGN_PUB.JTF_Lead_rec_type;
1225: l_lead_rec JTF_TERRITORY_PUB.JTF_Lead_BULK_rec_type;
1226: l_return_status VARCHAR2(10);
1220: l_AssignResources_Tbl JTF_ASSIGN_PUB.AssignResources_Tbl_type;
1221: -- JTF_TERRITORY_PUB.WinningTerrMember_tbl_type;
1222: l_AssignResources_Rec JTF_ASSIGN_PUB.AssignResources_Rec_type;
1223: -- JTF_TERRITORY_PUB.JTF_Lead_rec_type;
1224: -- l_lead_rec JTF_ASSIGN_PUB.JTF_Lead_rec_type;
1225: l_lead_rec JTF_TERRITORY_PUB.JTF_Lead_BULK_rec_type;
1226: l_return_status VARCHAR2(10);
1227: l_count INTEGER := 0;
1228: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;
1646: 'DUNS_NUMBER_C: ' || l_lead_rec.SQUAL_CHAR11(1));
1647: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1648: 'CHANNEL_CODE: ' || l_lead_rec.SQUAL_CHAR30(1));
1649: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1650: 'Calling JTF_ASSIGN_PUB.Get_Assign_Lead_Resources');
1651: END IF;
1652:
1653: JTF_ASSIGN_PUB.Get_Assign_Lead_Resources (
1654: p_api_version => 1.0
1649: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1650: 'Calling JTF_ASSIGN_PUB.Get_Assign_Lead_Resources');
1651: END IF;
1652:
1653: JTF_ASSIGN_PUB.Get_Assign_Lead_Resources (
1654: p_api_version => 1.0
1655: ,p_init_msg_list => JTF_ASSIGN_PUB.AM_FALSE
1656: -- ,p_commit => FND_API.G_FALSE
1657: ,p_resource_type => NULL
1651: END IF;
1652:
1653: JTF_ASSIGN_PUB.Get_Assign_Lead_Resources (
1654: p_api_version => 1.0
1655: ,p_init_msg_list => JTF_ASSIGN_PUB.AM_FALSE
1656: -- ,p_commit => FND_API.G_FALSE
1657: ,p_resource_type => NULL
1658: ,p_role => NULL
1659: ,p_no_of_resources => 999
2320: l_new_address_id NUMBER;
2321: l_assign_to_salesforce_id NUMBER;
2322: l_assign_sales_group_id NUMBER;
2323: l_reject_reason_code VARCHAR2(30);
2324: l_AssignResources_Tbl JTF_ASSIGN_PUB.AssignResources_Tbl_type;
2325: -- JTF_TERRITORY_PUB.WinningTerrMember_tbl_type;
2326: l_AssignResources_Rec JTF_ASSIGN_PUB.AssignResources_Rec_type;
2327: -- JTF_TERRITORY_PUB.JTF_Lead_rec_type;
2328: --l_lead_rec JTF_ASSIGN_PUB.JTF_Lead_rec_type;
2322: l_assign_sales_group_id NUMBER;
2323: l_reject_reason_code VARCHAR2(30);
2324: l_AssignResources_Tbl JTF_ASSIGN_PUB.AssignResources_Tbl_type;
2325: -- JTF_TERRITORY_PUB.WinningTerrMember_tbl_type;
2326: l_AssignResources_Rec JTF_ASSIGN_PUB.AssignResources_Rec_type;
2327: -- JTF_TERRITORY_PUB.JTF_Lead_rec_type;
2328: --l_lead_rec JTF_ASSIGN_PUB.JTF_Lead_rec_type;
2329: l_lead_rec JTF_TERRITORY_PUB.JTF_Lead_BULK_rec_type;
2330: l_return_status VARCHAR2(10);
2324: l_AssignResources_Tbl JTF_ASSIGN_PUB.AssignResources_Tbl_type;
2325: -- JTF_TERRITORY_PUB.WinningTerrMember_tbl_type;
2326: l_AssignResources_Rec JTF_ASSIGN_PUB.AssignResources_Rec_type;
2327: -- JTF_TERRITORY_PUB.JTF_Lead_rec_type;
2328: --l_lead_rec JTF_ASSIGN_PUB.JTF_Lead_rec_type;
2329: l_lead_rec JTF_TERRITORY_PUB.JTF_Lead_BULK_rec_type;
2330: l_return_status VARCHAR2(10);
2331: l_count INTEGER := 0;
2332: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;
2693: 'DUNS_NUMBER_C: ' || l_lead_rec.SQUAL_CHAR11(1));
2694: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2695: 'CHANNEL_CODE: ' || l_lead_rec.SQUAL_CHAR30(1));
2696: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2697: 'Calling JTF_ASSIGN_PUB.Get_Assign_Lead_Resources');
2698: END IF;
2699:
2700: JTF_ASSIGN_PUB.Get_Assign_Lead_Resources (
2701: p_api_version => 1.0
2696: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2697: 'Calling JTF_ASSIGN_PUB.Get_Assign_Lead_Resources');
2698: END IF;
2699:
2700: JTF_ASSIGN_PUB.Get_Assign_Lead_Resources (
2701: p_api_version => 1.0
2702: ,p_init_msg_list => JTF_ASSIGN_PUB.AM_FALSE
2703: -- ,p_commit => FND_API.G_FALSE
2704: ,p_resource_type => NULL
2698: END IF;
2699:
2700: JTF_ASSIGN_PUB.Get_Assign_Lead_Resources (
2701: p_api_version => 1.0
2702: ,p_init_msg_list => JTF_ASSIGN_PUB.AM_FALSE
2703: -- ,p_commit => FND_API.G_FALSE
2704: ,p_resource_type => NULL
2705: ,p_role => NULL
2706: ,p_no_of_resources => 999