DBA Data[Home] [Help]

APPS.AS_SALES_LEAD_ASSIGN_PVT dependencies on JTF_ASSIGN_PUB

Line 376: l_AssignResources_Tbl JTF_ASSIGN_PUB.AssignResources_Tbl_type;

372: and mem.resource_id = X_Resource_Id;
373:
374: l_api_name CONSTANT VARCHAR2(30) := 'Assign_Sales_Lead';
375: l_api_version_number CONSTANT NUMBER := 2.0;
376: l_AssignResources_Tbl JTF_ASSIGN_PUB.AssignResources_Tbl_type;
377: -- JTF_TERRITORY_PUB.WinningTerrMember_tbl_type;
378: l_AssignResources_Rec JTF_ASSIGN_PUB.AssignResources_Rec_type;
379: -- JTF_TERRITORY_PUB.JTF_Lead_rec_type;
380: -- l_lead_rec JTF_ASSIGN_PUB.JTF_Lead_rec_type;

Line 378: l_AssignResources_Rec JTF_ASSIGN_PUB.AssignResources_Rec_type;

374: l_api_name CONSTANT VARCHAR2(30) := 'Assign_Sales_Lead';
375: l_api_version_number CONSTANT NUMBER := 2.0;
376: l_AssignResources_Tbl JTF_ASSIGN_PUB.AssignResources_Tbl_type;
377: -- JTF_TERRITORY_PUB.WinningTerrMember_tbl_type;
378: l_AssignResources_Rec JTF_ASSIGN_PUB.AssignResources_Rec_type;
379: -- JTF_TERRITORY_PUB.JTF_Lead_rec_type;
380: -- l_lead_rec JTF_ASSIGN_PUB.JTF_Lead_rec_type;
381: l_lead_rec JTF_TERRITORY_PUB.JTF_Lead_BULK_rec_type;
382: l_resource_id NUMBER;

Line 380: -- l_lead_rec JTF_ASSIGN_PUB.JTF_Lead_rec_type;

376: l_AssignResources_Tbl JTF_ASSIGN_PUB.AssignResources_Tbl_type;
377: -- JTF_TERRITORY_PUB.WinningTerrMember_tbl_type;
378: l_AssignResources_Rec JTF_ASSIGN_PUB.AssignResources_Rec_type;
379: -- JTF_TERRITORY_PUB.JTF_Lead_rec_type;
380: -- l_lead_rec JTF_ASSIGN_PUB.JTF_Lead_rec_type;
381: l_lead_rec JTF_TERRITORY_PUB.JTF_Lead_BULK_rec_type;
382: l_resource_id NUMBER;
383: l_count INTEGER := 0;
384: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;

Line 581: 'Calling JTF_ASSIGN_PUB.Get_Assign_Lead_Resources');

577: nvl(FND_PROFILE.Value('AS_SL_ASSIGN_CALENDAR_REQ'),'N');
578:
579: IF (AS_DEBUG_LOW_ON) THEN
580: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
581: 'Calling JTF_ASSIGN_PUB.Get_Assign_Lead_Resources');
582: END IF;
583:
584: JTF_ASSIGN_PUB.Get_Assign_Lead_Resources (
585: p_api_version => 1.0

Line 584: JTF_ASSIGN_PUB.Get_Assign_Lead_Resources (

580: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
581: 'Calling JTF_ASSIGN_PUB.Get_Assign_Lead_Resources');
582: END IF;
583:
584: JTF_ASSIGN_PUB.Get_Assign_Lead_Resources (
585: p_api_version => 1.0
586: ,p_init_msg_list => JTF_ASSIGN_PUB.AM_FALSE
587: -- ,p_commit => FND_API.G_FALSE
588: ,p_resource_type => p_resource_type

Line 586: ,p_init_msg_list => JTF_ASSIGN_PUB.AM_FALSE

582: END IF;
583:
584: JTF_ASSIGN_PUB.Get_Assign_Lead_Resources (
585: p_api_version => 1.0
586: ,p_init_msg_list => JTF_ASSIGN_PUB.AM_FALSE
587: -- ,p_commit => FND_API.G_FALSE
588: ,p_resource_type => p_resource_type
589: ,p_role => p_role
590: ,p_no_of_resources => p_no_of_resources

Line 608: 'After JTF_ASSIGN_PUB.Get_Assign_Lead_Resources:' ||

604: );
605:
606: IF (AS_DEBUG_LOW_ON) THEN
607: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
608: 'After JTF_ASSIGN_PUB.Get_Assign_Lead_Resources:' ||
609: x_return_status);
610: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
611: 'count=' || l_assignresources_tbl.count);
612: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 641: 'After JTF_ASSIGN_PUB.Get_Assign_Lead_Resources:');

637: END IF;
638:
639: IF (AS_DEBUG_LOW_ON) THEN
640: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
641: 'After JTF_ASSIGN_PUB.Get_Assign_Lead_Resources:');
642: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
643: 'l_assignresources_tbl.count: ' || l_assignresources_tbl.count);
644: END IF;
645:

Line 1219: l_AssignResources_Tbl JTF_ASSIGN_PUB.AssignResources_Tbl_type;

1215: l_partner_name VARCHAR2(360);
1216:
1217: l_lead_owner_tbl AS_SALES_LEAD_OWNER.lead_owner_rec_tbl_type;
1218:
1219: l_AssignResources_Tbl JTF_ASSIGN_PUB.AssignResources_Tbl_type;
1220: -- JTF_TERRITORY_PUB.WinningTerrMember_tbl_type;
1221: l_AssignResources_Rec JTF_ASSIGN_PUB.AssignResources_Rec_type;
1222: -- JTF_TERRITORY_PUB.JTF_Lead_rec_type;
1223: -- l_lead_rec JTF_ASSIGN_PUB.JTF_Lead_rec_type;

Line 1221: l_AssignResources_Rec JTF_ASSIGN_PUB.AssignResources_Rec_type;

1217: l_lead_owner_tbl AS_SALES_LEAD_OWNER.lead_owner_rec_tbl_type;
1218:
1219: l_AssignResources_Tbl JTF_ASSIGN_PUB.AssignResources_Tbl_type;
1220: -- JTF_TERRITORY_PUB.WinningTerrMember_tbl_type;
1221: l_AssignResources_Rec JTF_ASSIGN_PUB.AssignResources_Rec_type;
1222: -- JTF_TERRITORY_PUB.JTF_Lead_rec_type;
1223: -- l_lead_rec JTF_ASSIGN_PUB.JTF_Lead_rec_type;
1224: l_lead_rec JTF_TERRITORY_PUB.JTF_Lead_BULK_rec_type;
1225: l_return_status VARCHAR2(10);

Line 1223: -- l_lead_rec JTF_ASSIGN_PUB.JTF_Lead_rec_type;

1219: l_AssignResources_Tbl JTF_ASSIGN_PUB.AssignResources_Tbl_type;
1220: -- JTF_TERRITORY_PUB.WinningTerrMember_tbl_type;
1221: l_AssignResources_Rec JTF_ASSIGN_PUB.AssignResources_Rec_type;
1222: -- JTF_TERRITORY_PUB.JTF_Lead_rec_type;
1223: -- l_lead_rec JTF_ASSIGN_PUB.JTF_Lead_rec_type;
1224: l_lead_rec JTF_TERRITORY_PUB.JTF_Lead_BULK_rec_type;
1225: l_return_status VARCHAR2(10);
1226: l_count INTEGER := 0;
1227: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;

Line 1649: 'Calling JTF_ASSIGN_PUB.Get_Assign_Lead_Resources');

1645: 'DUNS_NUMBER_C: ' || l_lead_rec.SQUAL_CHAR11(1));
1646: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1647: 'CHANNEL_CODE: ' || l_lead_rec.SQUAL_CHAR30(1));
1648: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1649: 'Calling JTF_ASSIGN_PUB.Get_Assign_Lead_Resources');
1650: END IF;
1651:
1652: JTF_ASSIGN_PUB.Get_Assign_Lead_Resources (
1653: p_api_version => 1.0

Line 1652: JTF_ASSIGN_PUB.Get_Assign_Lead_Resources (

1648: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1649: 'Calling JTF_ASSIGN_PUB.Get_Assign_Lead_Resources');
1650: END IF;
1651:
1652: JTF_ASSIGN_PUB.Get_Assign_Lead_Resources (
1653: p_api_version => 1.0
1654: ,p_init_msg_list => JTF_ASSIGN_PUB.AM_FALSE
1655: -- ,p_commit => FND_API.G_FALSE
1656: ,p_resource_type => NULL

Line 1654: ,p_init_msg_list => JTF_ASSIGN_PUB.AM_FALSE

1650: END IF;
1651:
1652: JTF_ASSIGN_PUB.Get_Assign_Lead_Resources (
1653: p_api_version => 1.0
1654: ,p_init_msg_list => JTF_ASSIGN_PUB.AM_FALSE
1655: -- ,p_commit => FND_API.G_FALSE
1656: ,p_resource_type => NULL
1657: ,p_role => NULL
1658: ,p_no_of_resources => 999

Line 2323: l_AssignResources_Tbl JTF_ASSIGN_PUB.AssignResources_Tbl_type;

2319: l_new_address_id NUMBER;
2320: l_assign_to_salesforce_id NUMBER;
2321: l_assign_sales_group_id NUMBER;
2322: l_reject_reason_code VARCHAR2(30);
2323: l_AssignResources_Tbl JTF_ASSIGN_PUB.AssignResources_Tbl_type;
2324: -- JTF_TERRITORY_PUB.WinningTerrMember_tbl_type;
2325: l_AssignResources_Rec JTF_ASSIGN_PUB.AssignResources_Rec_type;
2326: -- JTF_TERRITORY_PUB.JTF_Lead_rec_type;
2327: --l_lead_rec JTF_ASSIGN_PUB.JTF_Lead_rec_type;

Line 2325: l_AssignResources_Rec JTF_ASSIGN_PUB.AssignResources_Rec_type;

2321: l_assign_sales_group_id NUMBER;
2322: l_reject_reason_code VARCHAR2(30);
2323: l_AssignResources_Tbl JTF_ASSIGN_PUB.AssignResources_Tbl_type;
2324: -- JTF_TERRITORY_PUB.WinningTerrMember_tbl_type;
2325: l_AssignResources_Rec JTF_ASSIGN_PUB.AssignResources_Rec_type;
2326: -- JTF_TERRITORY_PUB.JTF_Lead_rec_type;
2327: --l_lead_rec JTF_ASSIGN_PUB.JTF_Lead_rec_type;
2328: l_lead_rec JTF_TERRITORY_PUB.JTF_Lead_BULK_rec_type;
2329: l_return_status VARCHAR2(10);

Line 2327: --l_lead_rec JTF_ASSIGN_PUB.JTF_Lead_rec_type;

2323: l_AssignResources_Tbl JTF_ASSIGN_PUB.AssignResources_Tbl_type;
2324: -- JTF_TERRITORY_PUB.WinningTerrMember_tbl_type;
2325: l_AssignResources_Rec JTF_ASSIGN_PUB.AssignResources_Rec_type;
2326: -- JTF_TERRITORY_PUB.JTF_Lead_rec_type;
2327: --l_lead_rec JTF_ASSIGN_PUB.JTF_Lead_rec_type;
2328: l_lead_rec JTF_TERRITORY_PUB.JTF_Lead_BULK_rec_type;
2329: l_return_status VARCHAR2(10);
2330: l_count INTEGER := 0;
2331: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;

Line 2696: 'Calling JTF_ASSIGN_PUB.Get_Assign_Lead_Resources');

2692: 'DUNS_NUMBER_C: ' || l_lead_rec.SQUAL_CHAR11(1));
2693: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2694: 'CHANNEL_CODE: ' || l_lead_rec.SQUAL_CHAR30(1));
2695: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2696: 'Calling JTF_ASSIGN_PUB.Get_Assign_Lead_Resources');
2697: END IF;
2698:
2699: JTF_ASSIGN_PUB.Get_Assign_Lead_Resources (
2700: p_api_version => 1.0

Line 2699: JTF_ASSIGN_PUB.Get_Assign_Lead_Resources (

2695: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2696: 'Calling JTF_ASSIGN_PUB.Get_Assign_Lead_Resources');
2697: END IF;
2698:
2699: JTF_ASSIGN_PUB.Get_Assign_Lead_Resources (
2700: p_api_version => 1.0
2701: ,p_init_msg_list => JTF_ASSIGN_PUB.AM_FALSE
2702: -- ,p_commit => FND_API.G_FALSE
2703: ,p_resource_type => NULL

Line 2701: ,p_init_msg_list => JTF_ASSIGN_PUB.AM_FALSE

2697: END IF;
2698:
2699: JTF_ASSIGN_PUB.Get_Assign_Lead_Resources (
2700: p_api_version => 1.0
2701: ,p_init_msg_list => JTF_ASSIGN_PUB.AM_FALSE
2702: -- ,p_commit => FND_API.G_FALSE
2703: ,p_resource_type => NULL
2704: ,p_role => NULL
2705: ,p_no_of_resources => 999