DBA Data[Home] [Help]

APPS.AS_SALES_LEAD_ASSIGN_PVT dependencies on JTF_ASSIGN_PUB

Line 377: l_AssignResources_Tbl JTF_ASSIGN_PUB.AssignResources_Tbl_type;

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;

Line 379: l_AssignResources_Rec JTF_ASSIGN_PUB.AssignResources_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;

Line 381: -- l_lead_rec JTF_ASSIGN_PUB.JTF_Lead_rec_type;

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;

Line 582: 'Calling JTF_ASSIGN_PUB.Get_Assign_Lead_Resources');

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

Line 585: JTF_ASSIGN_PUB.Get_Assign_Lead_Resources (

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

Line 587: ,p_init_msg_list => JTF_ASSIGN_PUB.AM_FALSE

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

Line 609: 'After JTF_ASSIGN_PUB.Get_Assign_Lead_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,

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

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:

Line 1220: l_AssignResources_Tbl JTF_ASSIGN_PUB.AssignResources_Tbl_type;

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;

Line 1222: l_AssignResources_Rec JTF_ASSIGN_PUB.AssignResources_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);

Line 1224: -- l_lead_rec JTF_ASSIGN_PUB.JTF_Lead_rec_type;

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;

Line 1650: 'Calling JTF_ASSIGN_PUB.Get_Assign_Lead_Resources');

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

Line 1653: JTF_ASSIGN_PUB.Get_Assign_Lead_Resources (

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

Line 1655: ,p_init_msg_list => JTF_ASSIGN_PUB.AM_FALSE

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

Line 2324: l_AssignResources_Tbl JTF_ASSIGN_PUB.AssignResources_Tbl_type;

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;

Line 2326: l_AssignResources_Rec JTF_ASSIGN_PUB.AssignResources_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);

Line 2328: --l_lead_rec JTF_ASSIGN_PUB.JTF_Lead_rec_type;

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;

Line 2697: 'Calling JTF_ASSIGN_PUB.Get_Assign_Lead_Resources');

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

Line 2700: JTF_ASSIGN_PUB.Get_Assign_Lead_Resources (

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

Line 2702: ,p_init_msg_list => JTF_ASSIGN_PUB.AM_FALSE

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