64: -- Change sql for trigger handlers.
65: -- 04/23/2003 SOLIN Bug 2921105
66: -- Add channel_code in lead trigger.
67: -- 04/28/2003 SOLIN Bug 2926777
68: -- Close_reason should be FND_API.G_MISS_CHAR when
69: -- lead is reassigned.
70: -- 04/30/2003 SOLIN Bug 2931721
71: -- Reset g_resource_id_tbl in Get_Available_Resource.
72: -- 05/01/2003 SOLIN Bug 2928041
237: -- API Name: Assign_Sales_Lead
238:
239: PROCEDURE Assign_Sales_Lead (
240: P_Api_Version_Number IN NUMBER,
241: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
242: p_commit IN VARCHAR2 := FND_API.G_FALSE,
243: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
244: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
245: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
238:
239: PROCEDURE Assign_Sales_Lead (
240: P_Api_Version_Number IN NUMBER,
241: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
242: p_commit IN VARCHAR2 := FND_API.G_FALSE,
243: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
244: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
245: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
246: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
239: PROCEDURE Assign_Sales_Lead (
240: P_Api_Version_Number IN NUMBER,
241: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
242: p_commit IN VARCHAR2 := FND_API.G_FALSE,
243: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
244: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
245: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
246: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
247: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
240: P_Api_Version_Number IN NUMBER,
241: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
242: p_commit IN VARCHAR2 := FND_API.G_FALSE,
243: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
244: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
245: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
246: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
247: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
248: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
241: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
242: p_commit IN VARCHAR2 := FND_API.G_FALSE,
243: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
244: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
245: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
246: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
247: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
248: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
249: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
242: p_commit IN VARCHAR2 := FND_API.G_FALSE,
243: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
244: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
245: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
246: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
247: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
248: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
249: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
250: P_resource_type IN VARCHAR2 := NULL,
243: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
244: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
245: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
246: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
247: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
248: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
249: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
250: P_resource_type IN VARCHAR2 := NULL,
251: P_role IN VARCHAR2 := NULL,
395: -- Standard Start of API savepoint
396: SAVEPOINT ASSIGN_SALES_LEAD_PVT;
397:
398: -- Standard call to check for call compatibility.
399: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
400: p_api_version_number,
401: l_api_name,
402: G_PKG_NAME)
403: THEN
400: p_api_version_number,
401: l_api_name,
402: G_PKG_NAME)
403: THEN
404: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
405: END IF;
406:
407: -- Initialize message list IF p_init_msg_list is set to TRUE.
408: IF FND_API.to_Boolean( p_init_msg_list )
404: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
405: END IF;
406:
407: -- Initialize message list IF p_init_msg_list is set to TRUE.
408: IF FND_API.to_Boolean( p_init_msg_list )
409: THEN
410: FND_MSG_PUB.initialize;
411: END IF;
412:
416: 'PVT:' || l_api_name || ' Start');
417: END IF;
418:
419: -- Initialize API return status to SUCCESS
420: x_return_status := FND_API.G_RET_STS_SUCCESS;
421:
422: --
423: -- Api body
424: --
436: p_msg_name => 'UT_CANNOT_GET_PROFILE_VALUE',
437: p_token1 => 'PROFILE',
438: p_token1_value => 'USER_ID');
439: END IF;
440: RAISE FND_API.G_EXC_ERROR;
441: END IF;
442:
443: IF (p_validation_level = fnd_api.g_valid_level_full)
444: THEN
439: END IF;
440: RAISE FND_API.G_EXC_ERROR;
441: END IF;
442:
443: IF (p_validation_level = fnd_api.g_valid_level_full)
444: THEN
445: AS_SALES_ORG_MANAGER_PVT.Get_CurrentUser(
446: p_api_version_number => 2.0
447: ,p_init_msg_list => p_init_msg_list
452: ,x_msg_data => x_msg_data
453: ,x_sales_member_rec => l_identity_sales_member_rec);
454: END IF;
455:
456: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
457: RAISE FND_API.G_EXC_ERROR;
458: END IF;
459:
460: ffang 112800 */
453: ,x_sales_member_rec => l_identity_sales_member_rec);
454: END IF;
455:
456: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
457: RAISE FND_API.G_EXC_ERROR;
458: END IF;
459:
460: ffang 112800 */
461:
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
592: ,p_auto_select_flag => p_auto_select_flag
618:
619: IF x_return_status = 'E' THEN
620: FND_MSG_PUB.Get (
621: p_msg_index => FND_MSG_PUB.G_LAST,
622: p_encoded => FND_API.G_TRUE ,
623: p_data => l_data,
624: p_msg_index_out => l_index_out
625: );
626: IF (AS_DEBUG_LOW_ON) THEN
627: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
628: l_data);
629: END IF;
630:
631: ELSIF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
632: IF (AS_DEBUG_LOW_ON) THEN
633: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
634: 'JTF AM failed');
635: END IF;
633: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
634: 'JTF AM failed');
635: END IF;
636: -- exit;
637: -- raise FND_API.G_EXC_ERROR;
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,
667: -- END of API body
668: --
669:
670: -- Standard check for p_commit
671: IF FND_API.to_Boolean( p_commit )
672: THEN
673: COMMIT WORK;
674: END IF;
675:
685: ( p_count => x_msg_count,
686: p_data => x_msg_data );
687:
688: EXCEPTION
689: WHEN FND_API.G_EXC_ERROR THEN
690: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
691: P_API_NAME => L_API_NAME
692: ,P_PKG_NAME => G_PKG_NAME
693: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
695: ,X_MSG_COUNT => X_MSG_COUNT
696: ,X_MSG_DATA => X_MSG_DATA
697: ,X_RETURN_STATUS => X_RETURN_STATUS);
698:
699: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
700: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
701: P_API_NAME => L_API_NAME
702: ,P_PKG_NAME => G_PKG_NAME
703: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
721:
722:
723: PROCEDURE CALL_WF_TO_ASSIGN (
724: P_Api_Version_Number IN NUMBER,
725: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
726: p_commit IN VARCHAR2 := FND_API.G_FALSE,
727: P_Sales_Lead_Id IN NUMBER,
728: P_assigned_resource_id IN NUMBER := NULL,
729: X_Return_Status OUT NOCOPY VARCHAR2,
722:
723: PROCEDURE CALL_WF_TO_ASSIGN (
724: P_Api_Version_Number IN NUMBER,
725: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
726: p_commit IN VARCHAR2 := FND_API.G_FALSE,
727: P_Sales_Lead_Id IN NUMBER,
728: P_assigned_resource_id IN NUMBER := NULL,
729: X_Return_Status OUT NOCOPY VARCHAR2,
730: X_Msg_Count OUT NOCOPY NUMBER,
740: -- Standard Start of API savepoint
741: SAVEPOINT CALL_WF_TO_ASSIGN_PVT;
742:
743: -- Standard call to check for call compatibility.
744: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
745: p_api_version_number,
746: l_api_name,
747: G_PKG_NAME)
748: THEN
745: p_api_version_number,
746: l_api_name,
747: G_PKG_NAME)
748: THEN
749: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
750: END IF;
751:
752: -- Initialize message list IF p_init_msg_list is set to TRUE.
753: IF FND_API.to_Boolean( p_init_msg_list )
749: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
750: END IF;
751:
752: -- Initialize message list IF p_init_msg_list is set to TRUE.
753: IF FND_API.to_Boolean( p_init_msg_list )
754: THEN
755: FND_MSG_PUB.initialize;
756: END IF;
757:
761: 'PVT:' || l_api_name || ' Start');
762: END IF;
763:
764: -- Initialize API return status to SUCCESS
765: x_return_status := FND_API.G_RET_STS_SUCCESS;
766:
767: --
768: -- Api body
769: --
779: p_msg_name => 'UT_CANNOT_GET_PROFILE_VALUE',
780: p_token1 => 'PROFILE',
781: p_token1_value => 'USER_ID');
782: END IF;
783: RAISE FND_API.G_EXC_ERROR;
784: END IF;
785:
786: -- Debug Message
787: IF (AS_DEBUG_LOW_ON) THEN
790: END IF;
791:
792: AS_LEAD_ROUTING_WF.STARTPROCESS (
793: p_sales_lead_id => p_sales_lead_id,
794: p_salesgroup_id => fnd_api.g_miss_num,
795: x_return_status => x_return_status,
796: x_item_type => l_itemtype,
797: x_item_key => l_itemkey );
798:
802: END IF;
803:
804: -- verify the valid values of return_status from WF and handle them
805: IF x_return_status = '#NULL' THEN
806: x_return_status := FND_API.G_RET_STS_SUCCESS;
807: -- Will add these error messages to dictionary
808: -- AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR,
809: -- 'No assignment has been made.');
810: ELSIF x_return_status = 'ERROR' THEN
811: IF (AS_DEBUG_ERROR_ON) THEN
812: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR,
813: 'AS_LEAD_ASSIGN_FAIL');
814: END IF;
815: RAISE FND_API.G_EXC_ERROR;
816:
817: -- code change for bug 1613424 start
818:
819: ELSIF x_return_status = 'W' THEN
826: -- code change for bug 1613424 end
827:
828: ELSE
829:
830: x_return_status := FND_API.G_RET_STS_SUCCESS;
831: END IF;
832:
833: --
834: -- END of API body
834: -- END of API body
835: --
836:
837: -- Standard check for p_commit
838: IF FND_API.to_Boolean( p_commit )
839: THEN
840: COMMIT WORK;
841: END IF;
842:
856: -- API Name: Build_Lead_Sales_Team
857:
858: PROCEDURE Build_Lead_Sales_Team(
859: P_Api_Version_Number IN NUMBER,
860: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
861: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
862: p_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
863: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
864: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
857:
858: PROCEDURE Build_Lead_Sales_Team(
859: P_Api_Version_Number IN NUMBER,
860: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
861: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
862: p_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
863: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
864: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
865: P_Salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
858: PROCEDURE Build_Lead_Sales_Team(
859: P_Api_Version_Number IN NUMBER,
860: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
861: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
862: p_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
863: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
864: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
865: P_Salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
866: P_Sales_Lead_Id IN NUMBER,
859: P_Api_Version_Number IN NUMBER,
860: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
861: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
862: p_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
863: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
864: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
865: P_Salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
866: P_Sales_Lead_Id IN NUMBER,
867: X_Request_Id OUT NOCOPY NUMBER,
860: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
861: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
862: p_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
863: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
864: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
865: P_Salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
866: P_Sales_Lead_Id IN NUMBER,
867: X_Request_Id OUT NOCOPY NUMBER,
868: X_Return_Status OUT NOCOPY VARCHAR2,
861: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
862: p_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
863: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
864: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
865: P_Salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
866: P_Sales_Lead_Id IN NUMBER,
867: X_Request_Id OUT NOCOPY NUMBER,
868: X_Return_Status OUT NOCOPY VARCHAR2,
869: X_Msg_Count OUT NOCOPY NUMBER,
1264: -- Standard Start of API savepoint
1265: SAVEPOINT BUILD_LEAD_SALES_TEAM_PVT;
1266:
1267: -- Standard call to check for call compatibility.
1268: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1269: p_api_version_number,
1270: l_api_name,
1271: G_PKG_NAME)
1272: THEN
1269: p_api_version_number,
1270: l_api_name,
1271: G_PKG_NAME)
1272: THEN
1273: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1274: END IF;
1275:
1276: -- Initialize message list IF p_init_msg_list is set to TRUE.
1277: IF FND_API.to_Boolean( p_init_msg_list )
1273: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1274: END IF;
1275:
1276: -- Initialize message list IF p_init_msg_list is set to TRUE.
1277: IF FND_API.to_Boolean( p_init_msg_list )
1278: THEN
1279: FND_MSG_PUB.initialize;
1280: END IF;
1281:
1285: 'PVT:' || l_api_name || ' Start');
1286: END IF;
1287:
1288: -- Initialize API return status to SUCCESS
1289: x_return_status := FND_API.G_RET_STS_SUCCESS;
1290:
1291: --
1292: -- Api body
1293: --
1304: p_msg_name => 'UT_CANNOT_GET_PROFILE_VALUE',
1305: p_token1 => 'PROFILE',
1306: p_token1_value => 'USER_ID');
1307: END IF;
1308: RAISE FND_API.G_EXC_ERROR;
1309: END IF;
1310:
1311: IF (p_validation_level = fnd_api.g_valid_level_full)
1312: THEN
1307: END IF;
1308: RAISE FND_API.G_EXC_ERROR;
1309: END IF;
1310:
1311: IF (p_validation_level = fnd_api.g_valid_level_full)
1312: THEN
1313: AS_SALES_ORG_MANAGER_PVT.Get_CurrentUser(
1314: p_api_version_number => 2.0
1315: ,p_init_msg_list => p_init_msg_list
1320: ,x_msg_data => x_msg_data
1321: ,x_sales_member_rec => l_identity_sales_member_rec);
1322: END IF;
1323:
1324: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1325: RAISE FND_API.G_EXC_ERROR;
1326: END IF;
1327:
1328: OPEN C_Get_Lead_Info(p_Sales_Lead_Id);
1321: ,x_sales_member_rec => l_identity_sales_member_rec);
1322: END IF;
1323:
1324: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1325: RAISE FND_API.G_EXC_ERROR;
1326: END IF;
1327:
1328: OPEN C_Get_Lead_Info(p_Sales_Lead_Id);
1329: FETCH C_Get_Lead_Info INTO
1367: END IF;
1368:
1369: AS_SALES_LEAD_OWNER.Get_Salesreps(
1370: p_api_version => 2.0
1371: ,p_init_msg_list => FND_API.g_false
1372: ,p_commit => FND_API.g_false
1373: ,p_validation_level => p_Validation_Level
1374: ,p_sales_lead_id => p_sales_lead_id
1375: ,x_salesreps_tbl => l_lead_owner_tbl
1368:
1369: AS_SALES_LEAD_OWNER.Get_Salesreps(
1370: p_api_version => 2.0
1371: ,p_init_msg_list => FND_API.g_false
1372: ,p_commit => FND_API.g_false
1373: ,p_validation_level => p_Validation_Level
1374: ,p_sales_lead_id => p_sales_lead_id
1375: ,x_salesreps_tbl => l_lead_owner_tbl
1376: ,x_return_status => l_return_status
1376: ,x_return_status => l_return_status
1377: ,x_msg_count => x_msg_count
1378: ,x_msg_data => x_msg_data);
1379:
1380: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1381: RAISE FND_API.G_EXC_ERROR;
1382: END IF;
1383:
1384: IF (AS_DEBUG_LOW_ON) THEN
1377: ,x_msg_count => x_msg_count
1378: ,x_msg_data => x_msg_data);
1379:
1380: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1381: RAISE FND_API.G_EXC_ERROR;
1382: END IF;
1383:
1384: IF (AS_DEBUG_LOW_ON) THEN
1385: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
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
1660: ,p_auto_select_flag => NULL
1674: IF l_return_status = 'E'
1675: THEN
1676: FND_MSG_PUB.Get (
1677: p_msg_index => FND_MSG_PUB.G_LAST,
1678: p_encoded => FND_API.G_TRUE ,
1679: p_data => l_data,
1680: p_msg_index_out => l_index_out
1681: );
1682: IF (AS_DEBUG_LOW_ON) THEN
1683: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1684: l_data);
1685: END IF;
1686:
1687: ELSIF l_return_status <> FND_API.G_RET_STS_SUCCESS
1688: THEN
1689: RAISE FND_API.G_EXC_ERROR;
1690: END IF;
1691:
1685: END IF;
1686:
1687: ELSIF l_return_status <> FND_API.G_RET_STS_SUCCESS
1688: THEN
1689: RAISE FND_API.G_EXC_ERROR;
1690: END IF;
1691:
1692: IF (AS_DEBUG_LOW_ON) THEN
1693: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1940: -- END of API body
1941: --
1942:
1943: -- Standard check for p_commit
1944: IF FND_API.to_Boolean( p_commit )
1945: THEN
1946: COMMIT WORK;
1947: END IF;
1948:
1956: IF x_return_status = 'W'
1957: THEN
1958: FND_MSG_PUB.Count_And_Get
1959: (
1960: p_encoded => FND_API.G_FALSE,
1961: p_count => x_msg_count,
1962: p_data => x_msg_data );
1963: ELSE
1964: FND_MSG_PUB.Count_And_Get
1966: p_data => x_msg_data );
1967: END IF;
1968:
1969: EXCEPTION
1970: WHEN FND_API.G_EXC_ERROR THEN
1971: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1972: P_API_NAME => L_API_NAME
1973: ,P_PKG_NAME => G_PKG_NAME
1974: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1976: ,X_MSG_COUNT => X_MSG_COUNT
1977: ,X_MSG_DATA => X_MSG_DATA
1978: ,X_RETURN_STATUS => X_RETURN_STATUS);
1979:
1980: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1981: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1982: P_API_NAME => L_API_NAME
1983: ,P_PKG_NAME => G_PKG_NAME
1984: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2004: -- API Name: Rebuild_Lead_Sales_Team
2005:
2006: PROCEDURE Rebuild_Lead_Sales_Team(
2007: P_Api_Version_Number IN NUMBER,
2008: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2009: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
2010: p_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2011: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
2012: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
2005:
2006: PROCEDURE Rebuild_Lead_Sales_Team(
2007: P_Api_Version_Number IN NUMBER,
2008: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2009: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
2010: p_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2011: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
2012: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
2013: P_Salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
2006: PROCEDURE Rebuild_Lead_Sales_Team(
2007: P_Api_Version_Number IN NUMBER,
2008: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2009: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
2010: p_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2011: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
2012: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
2013: P_Salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
2014: P_Sales_Lead_Id IN NUMBER,
2007: P_Api_Version_Number IN NUMBER,
2008: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2009: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
2010: p_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2011: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
2012: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
2013: P_Salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
2014: P_Sales_Lead_Id IN NUMBER,
2015: X_Request_id OUT NOCOPY NUMBER,
2008: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2009: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
2010: p_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2011: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
2012: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
2013: P_Salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
2014: P_Sales_Lead_Id IN NUMBER,
2015: X_Request_id OUT NOCOPY NUMBER,
2016: X_Return_Status OUT NOCOPY VARCHAR2,
2009: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
2010: p_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2011: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
2012: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
2013: P_Salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
2014: P_Sales_Lead_Id IN NUMBER,
2015: X_Request_id OUT NOCOPY NUMBER,
2016: X_Return_Status OUT NOCOPY VARCHAR2,
2017: X_Msg_Count OUT NOCOPY NUMBER,
2315: l_api_name CONSTANT VARCHAR2(30)
2316: := 'Rebuild_Lead_Sales_Team';
2317: l_api_version_number CONSTANT NUMBER := 2.0;
2318: l_customer_id NUMBER;
2319: l_old_address_id NUMBER := FND_API.G_MISS_NUM;
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);
2363: -- Standard Start of API savepoint
2364: SAVEPOINT REBUILD_LEAD_SALES_TEAM_PVT;
2365:
2366: -- Standard call to check for call compatibility.
2367: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2368: p_api_version_number,
2369: l_api_name,
2370: G_PKG_NAME)
2371: THEN
2368: p_api_version_number,
2369: l_api_name,
2370: G_PKG_NAME)
2371: THEN
2372: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2373: END IF;
2374:
2375: -- Initialize message list IF p_init_msg_list is set to TRUE.
2376: IF FND_API.to_Boolean( p_init_msg_list )
2372: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2373: END IF;
2374:
2375: -- Initialize message list IF p_init_msg_list is set to TRUE.
2376: IF FND_API.to_Boolean( p_init_msg_list )
2377: THEN
2378: FND_MSG_PUB.initialize;
2379: END IF;
2380:
2384: 'PVT:' || l_api_name || ' Start');
2385: END IF;
2386:
2387: -- Initialize API return status to SUCCESS
2388: x_return_status := FND_API.G_RET_STS_SUCCESS;
2389:
2390: --
2391: -- Api body
2392: --
2407: OPEN C_Check_Changed(p_sales_lead_id);
2408: FETCH C_Check_Changed INTO l_old_address_id;
2409: CLOSE C_Check_Changed;
2410:
2411: IF l_old_address_id = FND_API.G_MISS_NUM
2412: THEN
2413: -- There's no need to rebuild sales team for this sales lead
2414: -- because there's no record in as_changed_accounts_all
2415: IF (AS_DEBUG_LOW_ON) THEN
2478: p_msg_name => 'UT_CANNOT_GET_PROFILE_VALUE',
2479: p_token1 => 'PROFILE',
2480: p_token1_value => 'USER_ID');
2481: END IF;
2482: RAISE FND_API.G_EXC_ERROR;
2483: END IF;
2484:
2485: IF (p_validation_level = fnd_api.g_valid_level_full)
2486: THEN
2481: END IF;
2482: RAISE FND_API.G_EXC_ERROR;
2483: END IF;
2484:
2485: IF (p_validation_level = fnd_api.g_valid_level_full)
2486: THEN
2487: AS_SALES_ORG_MANAGER_PVT.Get_CurrentUser(
2488: p_api_version_number => 2.0
2489: ,p_init_msg_list => p_init_msg_list
2494: ,x_msg_data => x_msg_data
2495: ,x_sales_member_rec => l_identity_sales_member_rec);
2496: END IF;
2497:
2498: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2499: RAISE FND_API.G_EXC_ERROR;
2500: END IF;
2501:
2502: -- Get access_id, terr_id for the records that come from LEAD territory.
2495: ,x_sales_member_rec => l_identity_sales_member_rec);
2496: END IF;
2497:
2498: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2499: RAISE FND_API.G_EXC_ERROR;
2500: END IF;
2501:
2502: -- Get access_id, terr_id for the records that come from LEAD territory.
2503: -- Delete these records before new resource records are created in
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
2707: ,p_auto_select_flag => NULL
2721: IF l_return_status = 'E'
2722: THEN
2723: FND_MSG_PUB.Get (
2724: p_msg_index => FND_MSG_PUB.G_LAST,
2725: p_encoded => FND_API.G_TRUE ,
2726: p_data => l_data,
2727: p_msg_index_out => l_index_out
2728: );
2729: IF (AS_DEBUG_LOW_ON) THEN
2730: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2731: l_data);
2732: END IF;
2733:
2734: ELSIF l_return_status <> FND_API.G_RET_STS_SUCCESS
2735: THEN
2736: RAISE FND_API.G_EXC_ERROR;
2737: END IF;
2738:
2732: END IF;
2733:
2734: ELSIF l_return_status <> FND_API.G_RET_STS_SUCCESS
2735: THEN
2736: RAISE FND_API.G_EXC_ERROR;
2737: END IF;
2738:
2739: l_request_id := FND_GLOBAL.Conc_Request_Id;
2740: IF (AS_DEBUG_LOW_ON) THEN
2965: -- END of API body
2966: --
2967:
2968: -- Standard check for p_commit
2969: IF FND_API.to_Boolean( p_commit )
2970: THEN
2971: COMMIT WORK;
2972: END IF;
2973:
2982: IF x_return_status = 'W'
2983: THEN
2984: FND_MSG_PUB.Count_And_Get
2985: (
2986: p_encoded => FND_API.G_FALSE,
2987: p_count => x_msg_count,
2988: p_data => x_msg_data );
2989: ELSE
2990: FND_MSG_PUB.Count_And_Get
2992: p_data => x_msg_data );
2993: END IF;
2994:
2995: EXCEPTION
2996: WHEN FND_API.G_EXC_ERROR THEN
2997: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2998: P_API_NAME => L_API_NAME
2999: ,P_PKG_NAME => G_PKG_NAME
3000: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
3002: ,X_MSG_COUNT => X_MSG_COUNT
3003: ,X_MSG_DATA => X_MSG_DATA
3004: ,X_RETURN_STATUS => X_RETURN_STATUS);
3005:
3006: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3007: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3008: P_API_NAME => L_API_NAME
3009: ,P_PKG_NAME => G_PKG_NAME
3010: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
4179: -- If not, add as view only access.
4180: -- SOLIN, bug 4702335
4181: l_rs_id := p_identity_salesforce_id;
4182: IF p_identity_salesforce_id IS NULL
4183: OR p_identity_salesforce_id = FND_API.G_MISS_NUM
4184: THEN
4185: -- if login user's resource_id is not passed in, get from the system
4186: OPEN C_get_current_resource;
4187: FETCH C_get_current_resource INTO l_rs_id;
4217: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4218: 'Add current user to sales team');
4219: END IF;
4220:
4221: IF p_salesgroup_id = fnd_api.g_miss_num
4222: THEN
4223: OPEN c_get_group_id (l_rs_id, 'RS_GROUP_MEMBER', 'SALES',
4224: 'TELESALES', 'FIELDSALES', 'PRM', 'Y');
4225: FETCH c_get_group_id INTO l_group_id;
4385: CURSOR c_get_user_id(c_resource_id NUMBER) IS
4386: SELECT user_id from jtf_rs_resource_extns
4387: WHERE resource_id= c_resource_id;
4388: BEGIN
4389: x_return_status := FND_API.G_RET_STS_SUCCESS;
4390: --l_resource_id := fnd_profile.value('AS_DEFAULT_RESOURCE_ID'); --code commented for bug12766399
4391:
4392: --code added for bug12766399
4393: OPEN C_get_user_id(p_resource_id);
4429: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4430: 'Users resource id is:' || l_resource_id);
4431: END IF;
4432:
4433: IF p_salesgroup_id = fnd_api.g_miss_num
4434: THEN
4435: OPEN c_get_group_id (l_resource_id);
4436: FETCH c_get_group_id INTO l_group_id;
4437: CLOSE c_get_group_id;
4507: AS_SALES_LEADS_PKG.Sales_Lead_Update_Row(
4508: p_SALES_LEAD_ID => p_SALES_LEAD_ID,
4509: p_LAST_UPDATE_DATE => SYSDATE,
4510: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
4511: p_CREATION_DATE => FND_API.G_MISS_DATE,
4512: p_CREATED_BY => FND_API.G_MISS_NUM,
4513: p_LAST_UPDATE_LOGIN => FND_API.G_MISS_NUM,
4514: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,
4515: p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id,
4508: p_SALES_LEAD_ID => p_SALES_LEAD_ID,
4509: p_LAST_UPDATE_DATE => SYSDATE,
4510: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
4511: p_CREATION_DATE => FND_API.G_MISS_DATE,
4512: p_CREATED_BY => FND_API.G_MISS_NUM,
4513: p_LAST_UPDATE_LOGIN => FND_API.G_MISS_NUM,
4514: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,
4515: p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id,
4516: p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id,
4509: p_LAST_UPDATE_DATE => SYSDATE,
4510: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
4511: p_CREATION_DATE => FND_API.G_MISS_DATE,
4512: p_CREATED_BY => FND_API.G_MISS_NUM,
4513: p_LAST_UPDATE_LOGIN => FND_API.G_MISS_NUM,
4514: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,
4515: p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id,
4516: p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id,
4517: p_PROGRAM_UPDATE_DATE => SYSDATE,
4514: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,
4515: p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id,
4516: p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id,
4517: p_PROGRAM_UPDATE_DATE => SYSDATE,
4518: p_LEAD_NUMBER => FND_API.G_MISS_CHAR,
4519: p_STATUS_CODE => FND_API.G_MISS_CHAR, --l_routing_status,
4520: p_CUSTOMER_ID => l_CUSTOMER_ID,
4521: p_ADDRESS_ID => l_ADDRESS_ID,
4522: p_SOURCE_PROMOTION_ID => FND_API.G_MISS_NUM,
4515: p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id,
4516: p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id,
4517: p_PROGRAM_UPDATE_DATE => SYSDATE,
4518: p_LEAD_NUMBER => FND_API.G_MISS_CHAR,
4519: p_STATUS_CODE => FND_API.G_MISS_CHAR, --l_routing_status,
4520: p_CUSTOMER_ID => l_CUSTOMER_ID,
4521: p_ADDRESS_ID => l_ADDRESS_ID,
4522: p_SOURCE_PROMOTION_ID => FND_API.G_MISS_NUM,
4523: p_INITIATING_CONTACT_ID => FND_API.G_MISS_NUM,
4518: p_LEAD_NUMBER => FND_API.G_MISS_CHAR,
4519: p_STATUS_CODE => FND_API.G_MISS_CHAR, --l_routing_status,
4520: p_CUSTOMER_ID => l_CUSTOMER_ID,
4521: p_ADDRESS_ID => l_ADDRESS_ID,
4522: p_SOURCE_PROMOTION_ID => FND_API.G_MISS_NUM,
4523: p_INITIATING_CONTACT_ID => FND_API.G_MISS_NUM,
4524: p_ORIG_SYSTEM_REFERENCE => FND_API.G_MISS_CHAR,
4525: p_CONTACT_ROLE_CODE => FND_API.G_MISS_CHAR,
4526: p_CHANNEL_CODE => FND_API.G_MISS_CHAR,
4519: p_STATUS_CODE => FND_API.G_MISS_CHAR, --l_routing_status,
4520: p_CUSTOMER_ID => l_CUSTOMER_ID,
4521: p_ADDRESS_ID => l_ADDRESS_ID,
4522: p_SOURCE_PROMOTION_ID => FND_API.G_MISS_NUM,
4523: p_INITIATING_CONTACT_ID => FND_API.G_MISS_NUM,
4524: p_ORIG_SYSTEM_REFERENCE => FND_API.G_MISS_CHAR,
4525: p_CONTACT_ROLE_CODE => FND_API.G_MISS_CHAR,
4526: p_CHANNEL_CODE => FND_API.G_MISS_CHAR,
4527: p_BUDGET_AMOUNT => FND_API.G_MISS_NUM,
4520: p_CUSTOMER_ID => l_CUSTOMER_ID,
4521: p_ADDRESS_ID => l_ADDRESS_ID,
4522: p_SOURCE_PROMOTION_ID => FND_API.G_MISS_NUM,
4523: p_INITIATING_CONTACT_ID => FND_API.G_MISS_NUM,
4524: p_ORIG_SYSTEM_REFERENCE => FND_API.G_MISS_CHAR,
4525: p_CONTACT_ROLE_CODE => FND_API.G_MISS_CHAR,
4526: p_CHANNEL_CODE => FND_API.G_MISS_CHAR,
4527: p_BUDGET_AMOUNT => FND_API.G_MISS_NUM,
4528: p_CURRENCY_CODE => FND_API.G_MISS_CHAR,
4521: p_ADDRESS_ID => l_ADDRESS_ID,
4522: p_SOURCE_PROMOTION_ID => FND_API.G_MISS_NUM,
4523: p_INITIATING_CONTACT_ID => FND_API.G_MISS_NUM,
4524: p_ORIG_SYSTEM_REFERENCE => FND_API.G_MISS_CHAR,
4525: p_CONTACT_ROLE_CODE => FND_API.G_MISS_CHAR,
4526: p_CHANNEL_CODE => FND_API.G_MISS_CHAR,
4527: p_BUDGET_AMOUNT => FND_API.G_MISS_NUM,
4528: p_CURRENCY_CODE => FND_API.G_MISS_CHAR,
4529: p_DECISION_TIMEFRAME_CODE => FND_API.G_MISS_CHAR,
4522: p_SOURCE_PROMOTION_ID => FND_API.G_MISS_NUM,
4523: p_INITIATING_CONTACT_ID => FND_API.G_MISS_NUM,
4524: p_ORIG_SYSTEM_REFERENCE => FND_API.G_MISS_CHAR,
4525: p_CONTACT_ROLE_CODE => FND_API.G_MISS_CHAR,
4526: p_CHANNEL_CODE => FND_API.G_MISS_CHAR,
4527: p_BUDGET_AMOUNT => FND_API.G_MISS_NUM,
4528: p_CURRENCY_CODE => FND_API.G_MISS_CHAR,
4529: p_DECISION_TIMEFRAME_CODE => FND_API.G_MISS_CHAR,
4530: p_CLOSE_REASON => FND_API.G_MISS_CHAR,
4523: p_INITIATING_CONTACT_ID => FND_API.G_MISS_NUM,
4524: p_ORIG_SYSTEM_REFERENCE => FND_API.G_MISS_CHAR,
4525: p_CONTACT_ROLE_CODE => FND_API.G_MISS_CHAR,
4526: p_CHANNEL_CODE => FND_API.G_MISS_CHAR,
4527: p_BUDGET_AMOUNT => FND_API.G_MISS_NUM,
4528: p_CURRENCY_CODE => FND_API.G_MISS_CHAR,
4529: p_DECISION_TIMEFRAME_CODE => FND_API.G_MISS_CHAR,
4530: p_CLOSE_REASON => FND_API.G_MISS_CHAR,
4531: p_LEAD_RANK_ID => FND_API.G_MISS_NUM,
4524: p_ORIG_SYSTEM_REFERENCE => FND_API.G_MISS_CHAR,
4525: p_CONTACT_ROLE_CODE => FND_API.G_MISS_CHAR,
4526: p_CHANNEL_CODE => FND_API.G_MISS_CHAR,
4527: p_BUDGET_AMOUNT => FND_API.G_MISS_NUM,
4528: p_CURRENCY_CODE => FND_API.G_MISS_CHAR,
4529: p_DECISION_TIMEFRAME_CODE => FND_API.G_MISS_CHAR,
4530: p_CLOSE_REASON => FND_API.G_MISS_CHAR,
4531: p_LEAD_RANK_ID => FND_API.G_MISS_NUM,
4532: p_LEAD_RANK_CODE => FND_API.G_MISS_CHAR,
4525: p_CONTACT_ROLE_CODE => FND_API.G_MISS_CHAR,
4526: p_CHANNEL_CODE => FND_API.G_MISS_CHAR,
4527: p_BUDGET_AMOUNT => FND_API.G_MISS_NUM,
4528: p_CURRENCY_CODE => FND_API.G_MISS_CHAR,
4529: p_DECISION_TIMEFRAME_CODE => FND_API.G_MISS_CHAR,
4530: p_CLOSE_REASON => FND_API.G_MISS_CHAR,
4531: p_LEAD_RANK_ID => FND_API.G_MISS_NUM,
4532: p_LEAD_RANK_CODE => FND_API.G_MISS_CHAR,
4533: p_PARENT_PROJECT => FND_API.G_MISS_CHAR,
4526: p_CHANNEL_CODE => FND_API.G_MISS_CHAR,
4527: p_BUDGET_AMOUNT => FND_API.G_MISS_NUM,
4528: p_CURRENCY_CODE => FND_API.G_MISS_CHAR,
4529: p_DECISION_TIMEFRAME_CODE => FND_API.G_MISS_CHAR,
4530: p_CLOSE_REASON => FND_API.G_MISS_CHAR,
4531: p_LEAD_RANK_ID => FND_API.G_MISS_NUM,
4532: p_LEAD_RANK_CODE => FND_API.G_MISS_CHAR,
4533: p_PARENT_PROJECT => FND_API.G_MISS_CHAR,
4534: p_DESCRIPTION => FND_API.G_MISS_CHAR,
4527: p_BUDGET_AMOUNT => FND_API.G_MISS_NUM,
4528: p_CURRENCY_CODE => FND_API.G_MISS_CHAR,
4529: p_DECISION_TIMEFRAME_CODE => FND_API.G_MISS_CHAR,
4530: p_CLOSE_REASON => FND_API.G_MISS_CHAR,
4531: p_LEAD_RANK_ID => FND_API.G_MISS_NUM,
4532: p_LEAD_RANK_CODE => FND_API.G_MISS_CHAR,
4533: p_PARENT_PROJECT => FND_API.G_MISS_CHAR,
4534: p_DESCRIPTION => FND_API.G_MISS_CHAR,
4535: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
4528: p_CURRENCY_CODE => FND_API.G_MISS_CHAR,
4529: p_DECISION_TIMEFRAME_CODE => FND_API.G_MISS_CHAR,
4530: p_CLOSE_REASON => FND_API.G_MISS_CHAR,
4531: p_LEAD_RANK_ID => FND_API.G_MISS_NUM,
4532: p_LEAD_RANK_CODE => FND_API.G_MISS_CHAR,
4533: p_PARENT_PROJECT => FND_API.G_MISS_CHAR,
4534: p_DESCRIPTION => FND_API.G_MISS_CHAR,
4535: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
4536: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
4529: p_DECISION_TIMEFRAME_CODE => FND_API.G_MISS_CHAR,
4530: p_CLOSE_REASON => FND_API.G_MISS_CHAR,
4531: p_LEAD_RANK_ID => FND_API.G_MISS_NUM,
4532: p_LEAD_RANK_CODE => FND_API.G_MISS_CHAR,
4533: p_PARENT_PROJECT => FND_API.G_MISS_CHAR,
4534: p_DESCRIPTION => FND_API.G_MISS_CHAR,
4535: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
4536: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
4537: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
4530: p_CLOSE_REASON => FND_API.G_MISS_CHAR,
4531: p_LEAD_RANK_ID => FND_API.G_MISS_NUM,
4532: p_LEAD_RANK_CODE => FND_API.G_MISS_CHAR,
4533: p_PARENT_PROJECT => FND_API.G_MISS_CHAR,
4534: p_DESCRIPTION => FND_API.G_MISS_CHAR,
4535: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
4536: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
4537: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
4538: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
4531: p_LEAD_RANK_ID => FND_API.G_MISS_NUM,
4532: p_LEAD_RANK_CODE => FND_API.G_MISS_CHAR,
4533: p_PARENT_PROJECT => FND_API.G_MISS_CHAR,
4534: p_DESCRIPTION => FND_API.G_MISS_CHAR,
4535: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
4536: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
4537: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
4538: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
4539: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
4532: p_LEAD_RANK_CODE => FND_API.G_MISS_CHAR,
4533: p_PARENT_PROJECT => FND_API.G_MISS_CHAR,
4534: p_DESCRIPTION => FND_API.G_MISS_CHAR,
4535: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
4536: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
4537: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
4538: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
4539: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
4540: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
4533: p_PARENT_PROJECT => FND_API.G_MISS_CHAR,
4534: p_DESCRIPTION => FND_API.G_MISS_CHAR,
4535: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
4536: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
4537: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
4538: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
4539: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
4540: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
4541: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
4534: p_DESCRIPTION => FND_API.G_MISS_CHAR,
4535: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
4536: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
4537: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
4538: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
4539: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
4540: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
4541: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
4542: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
4535: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
4536: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
4537: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
4538: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
4539: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
4540: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
4541: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
4542: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
4543: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
4536: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
4537: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
4538: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
4539: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
4540: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
4541: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
4542: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
4543: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
4544: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
4537: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
4538: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
4539: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
4540: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
4541: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
4542: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
4543: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
4544: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
4545: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
4538: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
4539: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
4540: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
4541: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
4542: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
4543: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
4544: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
4545: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
4546: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
4539: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
4540: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
4541: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
4542: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
4543: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
4544: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
4545: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
4546: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
4547: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
4540: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
4541: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
4542: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
4543: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
4544: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
4545: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
4546: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
4547: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
4548: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
4541: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
4542: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
4543: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
4544: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
4545: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
4546: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
4547: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
4548: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
4549: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
4542: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
4543: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
4544: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
4545: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
4546: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
4547: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
4548: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
4549: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
4550: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
4543: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
4544: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
4545: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
4546: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
4547: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
4548: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
4549: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
4550: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
4551: p_ASSIGN_TO_PERSON_ID => l_person_id,
4544: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
4545: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
4546: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
4547: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
4548: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
4549: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
4550: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
4551: p_ASSIGN_TO_PERSON_ID => l_person_id,
4552: p_ASSIGN_TO_SALESFORCE_ID => l_resource_id,
4545: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
4546: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
4547: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
4548: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
4549: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
4550: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
4551: p_ASSIGN_TO_PERSON_ID => l_person_id,
4552: p_ASSIGN_TO_SALESFORCE_ID => l_resource_id,
4553: p_ASSIGN_SALES_GROUP_ID => l_group_id,
4546: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
4547: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
4548: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
4549: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
4550: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
4551: p_ASSIGN_TO_PERSON_ID => l_person_id,
4552: p_ASSIGN_TO_SALESFORCE_ID => l_resource_id,
4553: p_ASSIGN_SALES_GROUP_ID => l_group_id,
4554: p_ASSIGN_DATE => SYSDATE,
4551: p_ASSIGN_TO_PERSON_ID => l_person_id,
4552: p_ASSIGN_TO_SALESFORCE_ID => l_resource_id,
4553: p_ASSIGN_SALES_GROUP_ID => l_group_id,
4554: p_ASSIGN_DATE => SYSDATE,
4555: p_BUDGET_STATUS_CODE => FND_API.G_MISS_CHAR,
4556: p_ACCEPT_FLAG => 'N',
4557: p_VEHICLE_RESPONSE_CODE => FND_API.G_MISS_CHAR,
4558: p_TOTAL_SCORE => FND_API.G_MISS_NUM,
4559: p_SCORECARD_ID => FND_API.G_MISS_NUM,
4553: p_ASSIGN_SALES_GROUP_ID => l_group_id,
4554: p_ASSIGN_DATE => SYSDATE,
4555: p_BUDGET_STATUS_CODE => FND_API.G_MISS_CHAR,
4556: p_ACCEPT_FLAG => 'N',
4557: p_VEHICLE_RESPONSE_CODE => FND_API.G_MISS_CHAR,
4558: p_TOTAL_SCORE => FND_API.G_MISS_NUM,
4559: p_SCORECARD_ID => FND_API.G_MISS_NUM,
4560: p_KEEP_FLAG => FND_API.G_MISS_CHAR,
4561: p_URGENT_FLAG => FND_API.G_MISS_CHAR,
4554: p_ASSIGN_DATE => SYSDATE,
4555: p_BUDGET_STATUS_CODE => FND_API.G_MISS_CHAR,
4556: p_ACCEPT_FLAG => 'N',
4557: p_VEHICLE_RESPONSE_CODE => FND_API.G_MISS_CHAR,
4558: p_TOTAL_SCORE => FND_API.G_MISS_NUM,
4559: p_SCORECARD_ID => FND_API.G_MISS_NUM,
4560: p_KEEP_FLAG => FND_API.G_MISS_CHAR,
4561: p_URGENT_FLAG => FND_API.G_MISS_CHAR,
4562: p_IMPORT_FLAG => FND_API.G_MISS_CHAR,
4555: p_BUDGET_STATUS_CODE => FND_API.G_MISS_CHAR,
4556: p_ACCEPT_FLAG => 'N',
4557: p_VEHICLE_RESPONSE_CODE => FND_API.G_MISS_CHAR,
4558: p_TOTAL_SCORE => FND_API.G_MISS_NUM,
4559: p_SCORECARD_ID => FND_API.G_MISS_NUM,
4560: p_KEEP_FLAG => FND_API.G_MISS_CHAR,
4561: p_URGENT_FLAG => FND_API.G_MISS_CHAR,
4562: p_IMPORT_FLAG => FND_API.G_MISS_CHAR,
4563: p_REJECT_REASON_CODE => NULL, --l_reject_reason_code,
4556: p_ACCEPT_FLAG => 'N',
4557: p_VEHICLE_RESPONSE_CODE => FND_API.G_MISS_CHAR,
4558: p_TOTAL_SCORE => FND_API.G_MISS_NUM,
4559: p_SCORECARD_ID => FND_API.G_MISS_NUM,
4560: p_KEEP_FLAG => FND_API.G_MISS_CHAR,
4561: p_URGENT_FLAG => FND_API.G_MISS_CHAR,
4562: p_IMPORT_FLAG => FND_API.G_MISS_CHAR,
4563: p_REJECT_REASON_CODE => NULL, --l_reject_reason_code,
4564: p_DELETED_FLAG => FND_API.G_MISS_CHAR,
4557: p_VEHICLE_RESPONSE_CODE => FND_API.G_MISS_CHAR,
4558: p_TOTAL_SCORE => FND_API.G_MISS_NUM,
4559: p_SCORECARD_ID => FND_API.G_MISS_NUM,
4560: p_KEEP_FLAG => FND_API.G_MISS_CHAR,
4561: p_URGENT_FLAG => FND_API.G_MISS_CHAR,
4562: p_IMPORT_FLAG => FND_API.G_MISS_CHAR,
4563: p_REJECT_REASON_CODE => NULL, --l_reject_reason_code,
4564: p_DELETED_FLAG => FND_API.G_MISS_CHAR,
4565: p_OFFER_ID => FND_API.G_MISS_NUM,
4558: p_TOTAL_SCORE => FND_API.G_MISS_NUM,
4559: p_SCORECARD_ID => FND_API.G_MISS_NUM,
4560: p_KEEP_FLAG => FND_API.G_MISS_CHAR,
4561: p_URGENT_FLAG => FND_API.G_MISS_CHAR,
4562: p_IMPORT_FLAG => FND_API.G_MISS_CHAR,
4563: p_REJECT_REASON_CODE => NULL, --l_reject_reason_code,
4564: p_DELETED_FLAG => FND_API.G_MISS_CHAR,
4565: p_OFFER_ID => FND_API.G_MISS_NUM,
4566: p_QUALIFIED_FLAG => l_qualified_flag,
4560: p_KEEP_FLAG => FND_API.G_MISS_CHAR,
4561: p_URGENT_FLAG => FND_API.G_MISS_CHAR,
4562: p_IMPORT_FLAG => FND_API.G_MISS_CHAR,
4563: p_REJECT_REASON_CODE => NULL, --l_reject_reason_code,
4564: p_DELETED_FLAG => FND_API.G_MISS_CHAR,
4565: p_OFFER_ID => FND_API.G_MISS_NUM,
4566: p_QUALIFIED_FLAG => l_qualified_flag,
4567: p_ORIG_SYSTEM_CODE => FND_API.G_MISS_CHAR,
4568: -- p_SECURITY_GROUP_ID => FND_API.G_MISS_NUM,
4561: p_URGENT_FLAG => FND_API.G_MISS_CHAR,
4562: p_IMPORT_FLAG => FND_API.G_MISS_CHAR,
4563: p_REJECT_REASON_CODE => NULL, --l_reject_reason_code,
4564: p_DELETED_FLAG => FND_API.G_MISS_CHAR,
4565: p_OFFER_ID => FND_API.G_MISS_NUM,
4566: p_QUALIFIED_FLAG => l_qualified_flag,
4567: p_ORIG_SYSTEM_CODE => FND_API.G_MISS_CHAR,
4568: -- p_SECURITY_GROUP_ID => FND_API.G_MISS_NUM,
4569: p_INC_PARTNER_PARTY_ID => FND_API.G_MISS_NUM,
4563: p_REJECT_REASON_CODE => NULL, --l_reject_reason_code,
4564: p_DELETED_FLAG => FND_API.G_MISS_CHAR,
4565: p_OFFER_ID => FND_API.G_MISS_NUM,
4566: p_QUALIFIED_FLAG => l_qualified_flag,
4567: p_ORIG_SYSTEM_CODE => FND_API.G_MISS_CHAR,
4568: -- p_SECURITY_GROUP_ID => FND_API.G_MISS_NUM,
4569: p_INC_PARTNER_PARTY_ID => FND_API.G_MISS_NUM,
4570: p_INC_PARTNER_RESOURCE_ID => FND_API.G_MISS_NUM,
4571: p_PRM_EXEC_SPONSOR_FLAG => FND_API.G_MISS_CHAR,
4564: p_DELETED_FLAG => FND_API.G_MISS_CHAR,
4565: p_OFFER_ID => FND_API.G_MISS_NUM,
4566: p_QUALIFIED_FLAG => l_qualified_flag,
4567: p_ORIG_SYSTEM_CODE => FND_API.G_MISS_CHAR,
4568: -- p_SECURITY_GROUP_ID => FND_API.G_MISS_NUM,
4569: p_INC_PARTNER_PARTY_ID => FND_API.G_MISS_NUM,
4570: p_INC_PARTNER_RESOURCE_ID => FND_API.G_MISS_NUM,
4571: p_PRM_EXEC_SPONSOR_FLAG => FND_API.G_MISS_CHAR,
4572: p_PRM_PRJ_LEAD_IN_PLACE_FLAG => FND_API.G_MISS_CHAR,
4565: p_OFFER_ID => FND_API.G_MISS_NUM,
4566: p_QUALIFIED_FLAG => l_qualified_flag,
4567: p_ORIG_SYSTEM_CODE => FND_API.G_MISS_CHAR,
4568: -- p_SECURITY_GROUP_ID => FND_API.G_MISS_NUM,
4569: p_INC_PARTNER_PARTY_ID => FND_API.G_MISS_NUM,
4570: p_INC_PARTNER_RESOURCE_ID => FND_API.G_MISS_NUM,
4571: p_PRM_EXEC_SPONSOR_FLAG => FND_API.G_MISS_CHAR,
4572: p_PRM_PRJ_LEAD_IN_PLACE_FLAG => FND_API.G_MISS_CHAR,
4573: p_PRM_SALES_LEAD_TYPE => FND_API.G_MISS_CHAR,
4566: p_QUALIFIED_FLAG => l_qualified_flag,
4567: p_ORIG_SYSTEM_CODE => FND_API.G_MISS_CHAR,
4568: -- p_SECURITY_GROUP_ID => FND_API.G_MISS_NUM,
4569: p_INC_PARTNER_PARTY_ID => FND_API.G_MISS_NUM,
4570: p_INC_PARTNER_RESOURCE_ID => FND_API.G_MISS_NUM,
4571: p_PRM_EXEC_SPONSOR_FLAG => FND_API.G_MISS_CHAR,
4572: p_PRM_PRJ_LEAD_IN_PLACE_FLAG => FND_API.G_MISS_CHAR,
4573: p_PRM_SALES_LEAD_TYPE => FND_API.G_MISS_CHAR,
4574: p_PRM_IND_CLASSIFICATION_CODE => FND_API.G_MISS_CHAR,
4567: p_ORIG_SYSTEM_CODE => FND_API.G_MISS_CHAR,
4568: -- p_SECURITY_GROUP_ID => FND_API.G_MISS_NUM,
4569: p_INC_PARTNER_PARTY_ID => FND_API.G_MISS_NUM,
4570: p_INC_PARTNER_RESOURCE_ID => FND_API.G_MISS_NUM,
4571: p_PRM_EXEC_SPONSOR_FLAG => FND_API.G_MISS_CHAR,
4572: p_PRM_PRJ_LEAD_IN_PLACE_FLAG => FND_API.G_MISS_CHAR,
4573: p_PRM_SALES_LEAD_TYPE => FND_API.G_MISS_CHAR,
4574: p_PRM_IND_CLASSIFICATION_CODE => FND_API.G_MISS_CHAR,
4575: p_PRM_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
4568: -- p_SECURITY_GROUP_ID => FND_API.G_MISS_NUM,
4569: p_INC_PARTNER_PARTY_ID => FND_API.G_MISS_NUM,
4570: p_INC_PARTNER_RESOURCE_ID => FND_API.G_MISS_NUM,
4571: p_PRM_EXEC_SPONSOR_FLAG => FND_API.G_MISS_CHAR,
4572: p_PRM_PRJ_LEAD_IN_PLACE_FLAG => FND_API.G_MISS_CHAR,
4573: p_PRM_SALES_LEAD_TYPE => FND_API.G_MISS_CHAR,
4574: p_PRM_IND_CLASSIFICATION_CODE => FND_API.G_MISS_CHAR,
4575: p_PRM_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
4576: p_AUTO_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
4569: p_INC_PARTNER_PARTY_ID => FND_API.G_MISS_NUM,
4570: p_INC_PARTNER_RESOURCE_ID => FND_API.G_MISS_NUM,
4571: p_PRM_EXEC_SPONSOR_FLAG => FND_API.G_MISS_CHAR,
4572: p_PRM_PRJ_LEAD_IN_PLACE_FLAG => FND_API.G_MISS_CHAR,
4573: p_PRM_SALES_LEAD_TYPE => FND_API.G_MISS_CHAR,
4574: p_PRM_IND_CLASSIFICATION_CODE => FND_API.G_MISS_CHAR,
4575: p_PRM_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
4576: p_AUTO_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
4577: p_PRIMARY_CONTACT_PARTY_ID => FND_API.G_MISS_NUM,
4570: p_INC_PARTNER_RESOURCE_ID => FND_API.G_MISS_NUM,
4571: p_PRM_EXEC_SPONSOR_FLAG => FND_API.G_MISS_CHAR,
4572: p_PRM_PRJ_LEAD_IN_PLACE_FLAG => FND_API.G_MISS_CHAR,
4573: p_PRM_SALES_LEAD_TYPE => FND_API.G_MISS_CHAR,
4574: p_PRM_IND_CLASSIFICATION_CODE => FND_API.G_MISS_CHAR,
4575: p_PRM_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
4576: p_AUTO_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
4577: p_PRIMARY_CONTACT_PARTY_ID => FND_API.G_MISS_NUM,
4578: p_PRIMARY_CNT_PERSON_PARTY_ID => FND_API.G_MISS_NUM,
4571: p_PRM_EXEC_SPONSOR_FLAG => FND_API.G_MISS_CHAR,
4572: p_PRM_PRJ_LEAD_IN_PLACE_FLAG => FND_API.G_MISS_CHAR,
4573: p_PRM_SALES_LEAD_TYPE => FND_API.G_MISS_CHAR,
4574: p_PRM_IND_CLASSIFICATION_CODE => FND_API.G_MISS_CHAR,
4575: p_PRM_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
4576: p_AUTO_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
4577: p_PRIMARY_CONTACT_PARTY_ID => FND_API.G_MISS_NUM,
4578: p_PRIMARY_CNT_PERSON_PARTY_ID => FND_API.G_MISS_NUM,
4579: p_PRIMARY_CONTACT_PHONE_ID => FND_API.G_MISS_NUM,
4572: p_PRM_PRJ_LEAD_IN_PLACE_FLAG => FND_API.G_MISS_CHAR,
4573: p_PRM_SALES_LEAD_TYPE => FND_API.G_MISS_CHAR,
4574: p_PRM_IND_CLASSIFICATION_CODE => FND_API.G_MISS_CHAR,
4575: p_PRM_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
4576: p_AUTO_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
4577: p_PRIMARY_CONTACT_PARTY_ID => FND_API.G_MISS_NUM,
4578: p_PRIMARY_CNT_PERSON_PARTY_ID => FND_API.G_MISS_NUM,
4579: p_PRIMARY_CONTACT_PHONE_ID => FND_API.G_MISS_NUM,
4580: p_REFERRED_BY => FND_API.G_MISS_NUM,
4573: p_PRM_SALES_LEAD_TYPE => FND_API.G_MISS_CHAR,
4574: p_PRM_IND_CLASSIFICATION_CODE => FND_API.G_MISS_CHAR,
4575: p_PRM_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
4576: p_AUTO_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
4577: p_PRIMARY_CONTACT_PARTY_ID => FND_API.G_MISS_NUM,
4578: p_PRIMARY_CNT_PERSON_PARTY_ID => FND_API.G_MISS_NUM,
4579: p_PRIMARY_CONTACT_PHONE_ID => FND_API.G_MISS_NUM,
4580: p_REFERRED_BY => FND_API.G_MISS_NUM,
4581: p_REFERRAL_TYPE => FND_API.G_MISS_CHAR,
4574: p_PRM_IND_CLASSIFICATION_CODE => FND_API.G_MISS_CHAR,
4575: p_PRM_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
4576: p_AUTO_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
4577: p_PRIMARY_CONTACT_PARTY_ID => FND_API.G_MISS_NUM,
4578: p_PRIMARY_CNT_PERSON_PARTY_ID => FND_API.G_MISS_NUM,
4579: p_PRIMARY_CONTACT_PHONE_ID => FND_API.G_MISS_NUM,
4580: p_REFERRED_BY => FND_API.G_MISS_NUM,
4581: p_REFERRAL_TYPE => FND_API.G_MISS_CHAR,
4582: p_REFERRAL_STATUS => FND_API.G_MISS_CHAR,
4575: p_PRM_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
4576: p_AUTO_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
4577: p_PRIMARY_CONTACT_PARTY_ID => FND_API.G_MISS_NUM,
4578: p_PRIMARY_CNT_PERSON_PARTY_ID => FND_API.G_MISS_NUM,
4579: p_PRIMARY_CONTACT_PHONE_ID => FND_API.G_MISS_NUM,
4580: p_REFERRED_BY => FND_API.G_MISS_NUM,
4581: p_REFERRAL_TYPE => FND_API.G_MISS_CHAR,
4582: p_REFERRAL_STATUS => FND_API.G_MISS_CHAR,
4583: p_REF_DECLINE_REASON => FND_API.G_MISS_CHAR,
4576: p_AUTO_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
4577: p_PRIMARY_CONTACT_PARTY_ID => FND_API.G_MISS_NUM,
4578: p_PRIMARY_CNT_PERSON_PARTY_ID => FND_API.G_MISS_NUM,
4579: p_PRIMARY_CONTACT_PHONE_ID => FND_API.G_MISS_NUM,
4580: p_REFERRED_BY => FND_API.G_MISS_NUM,
4581: p_REFERRAL_TYPE => FND_API.G_MISS_CHAR,
4582: p_REFERRAL_STATUS => FND_API.G_MISS_CHAR,
4583: p_REF_DECLINE_REASON => FND_API.G_MISS_CHAR,
4584: p_REF_COMM_LTR_STATUS => FND_API.G_MISS_CHAR,
4577: p_PRIMARY_CONTACT_PARTY_ID => FND_API.G_MISS_NUM,
4578: p_PRIMARY_CNT_PERSON_PARTY_ID => FND_API.G_MISS_NUM,
4579: p_PRIMARY_CONTACT_PHONE_ID => FND_API.G_MISS_NUM,
4580: p_REFERRED_BY => FND_API.G_MISS_NUM,
4581: p_REFERRAL_TYPE => FND_API.G_MISS_CHAR,
4582: p_REFERRAL_STATUS => FND_API.G_MISS_CHAR,
4583: p_REF_DECLINE_REASON => FND_API.G_MISS_CHAR,
4584: p_REF_COMM_LTR_STATUS => FND_API.G_MISS_CHAR,
4585: p_REF_ORDER_NUMBER => FND_API.G_MISS_NUM,
4578: p_PRIMARY_CNT_PERSON_PARTY_ID => FND_API.G_MISS_NUM,
4579: p_PRIMARY_CONTACT_PHONE_ID => FND_API.G_MISS_NUM,
4580: p_REFERRED_BY => FND_API.G_MISS_NUM,
4581: p_REFERRAL_TYPE => FND_API.G_MISS_CHAR,
4582: p_REFERRAL_STATUS => FND_API.G_MISS_CHAR,
4583: p_REF_DECLINE_REASON => FND_API.G_MISS_CHAR,
4584: p_REF_COMM_LTR_STATUS => FND_API.G_MISS_CHAR,
4585: p_REF_ORDER_NUMBER => FND_API.G_MISS_NUM,
4586: p_REF_ORDER_AMT => FND_API.G_MISS_NUM,
4579: p_PRIMARY_CONTACT_PHONE_ID => FND_API.G_MISS_NUM,
4580: p_REFERRED_BY => FND_API.G_MISS_NUM,
4581: p_REFERRAL_TYPE => FND_API.G_MISS_CHAR,
4582: p_REFERRAL_STATUS => FND_API.G_MISS_CHAR,
4583: p_REF_DECLINE_REASON => FND_API.G_MISS_CHAR,
4584: p_REF_COMM_LTR_STATUS => FND_API.G_MISS_CHAR,
4585: p_REF_ORDER_NUMBER => FND_API.G_MISS_NUM,
4586: p_REF_ORDER_AMT => FND_API.G_MISS_NUM,
4587: p_REF_COMM_AMT => FND_API.G_MISS_NUM,
4580: p_REFERRED_BY => FND_API.G_MISS_NUM,
4581: p_REFERRAL_TYPE => FND_API.G_MISS_CHAR,
4582: p_REFERRAL_STATUS => FND_API.G_MISS_CHAR,
4583: p_REF_DECLINE_REASON => FND_API.G_MISS_CHAR,
4584: p_REF_COMM_LTR_STATUS => FND_API.G_MISS_CHAR,
4585: p_REF_ORDER_NUMBER => FND_API.G_MISS_NUM,
4586: p_REF_ORDER_AMT => FND_API.G_MISS_NUM,
4587: p_REF_COMM_AMT => FND_API.G_MISS_NUM,
4588: -- bug No.2341515, 2368075
4581: p_REFERRAL_TYPE => FND_API.G_MISS_CHAR,
4582: p_REFERRAL_STATUS => FND_API.G_MISS_CHAR,
4583: p_REF_DECLINE_REASON => FND_API.G_MISS_CHAR,
4584: p_REF_COMM_LTR_STATUS => FND_API.G_MISS_CHAR,
4585: p_REF_ORDER_NUMBER => FND_API.G_MISS_NUM,
4586: p_REF_ORDER_AMT => FND_API.G_MISS_NUM,
4587: p_REF_COMM_AMT => FND_API.G_MISS_NUM,
4588: -- bug No.2341515, 2368075
4589: p_LEAD_DATE => FND_API.G_MISS_DATE,
4582: p_REFERRAL_STATUS => FND_API.G_MISS_CHAR,
4583: p_REF_DECLINE_REASON => FND_API.G_MISS_CHAR,
4584: p_REF_COMM_LTR_STATUS => FND_API.G_MISS_CHAR,
4585: p_REF_ORDER_NUMBER => FND_API.G_MISS_NUM,
4586: p_REF_ORDER_AMT => FND_API.G_MISS_NUM,
4587: p_REF_COMM_AMT => FND_API.G_MISS_NUM,
4588: -- bug No.2341515, 2368075
4589: p_LEAD_DATE => FND_API.G_MISS_DATE,
4590: p_SOURCE_SYSTEM => FND_API.G_MISS_CHAR,
4583: p_REF_DECLINE_REASON => FND_API.G_MISS_CHAR,
4584: p_REF_COMM_LTR_STATUS => FND_API.G_MISS_CHAR,
4585: p_REF_ORDER_NUMBER => FND_API.G_MISS_NUM,
4586: p_REF_ORDER_AMT => FND_API.G_MISS_NUM,
4587: p_REF_COMM_AMT => FND_API.G_MISS_NUM,
4588: -- bug No.2341515, 2368075
4589: p_LEAD_DATE => FND_API.G_MISS_DATE,
4590: p_SOURCE_SYSTEM => FND_API.G_MISS_CHAR,
4591: p_COUNTRY => FND_API.G_MISS_CHAR,
4585: p_REF_ORDER_NUMBER => FND_API.G_MISS_NUM,
4586: p_REF_ORDER_AMT => FND_API.G_MISS_NUM,
4587: p_REF_COMM_AMT => FND_API.G_MISS_NUM,
4588: -- bug No.2341515, 2368075
4589: p_LEAD_DATE => FND_API.G_MISS_DATE,
4590: p_SOURCE_SYSTEM => FND_API.G_MISS_CHAR,
4591: p_COUNTRY => FND_API.G_MISS_CHAR,
4592: p_TOTAL_AMOUNT => FND_API.G_MISS_NUM,
4593: p_EXPIRATION_DATE => FND_API.G_MISS_DATE,
4586: p_REF_ORDER_AMT => FND_API.G_MISS_NUM,
4587: p_REF_COMM_AMT => FND_API.G_MISS_NUM,
4588: -- bug No.2341515, 2368075
4589: p_LEAD_DATE => FND_API.G_MISS_DATE,
4590: p_SOURCE_SYSTEM => FND_API.G_MISS_CHAR,
4591: p_COUNTRY => FND_API.G_MISS_CHAR,
4592: p_TOTAL_AMOUNT => FND_API.G_MISS_NUM,
4593: p_EXPIRATION_DATE => FND_API.G_MISS_DATE,
4594: p_LEAD_RANK_IND => FND_API.G_MISS_CHAR,
4587: p_REF_COMM_AMT => FND_API.G_MISS_NUM,
4588: -- bug No.2341515, 2368075
4589: p_LEAD_DATE => FND_API.G_MISS_DATE,
4590: p_SOURCE_SYSTEM => FND_API.G_MISS_CHAR,
4591: p_COUNTRY => FND_API.G_MISS_CHAR,
4592: p_TOTAL_AMOUNT => FND_API.G_MISS_NUM,
4593: p_EXPIRATION_DATE => FND_API.G_MISS_DATE,
4594: p_LEAD_RANK_IND => FND_API.G_MISS_CHAR,
4595: p_LEAD_ENGINE_RUN_DATE => FND_API.G_MISS_DATE,
4588: -- bug No.2341515, 2368075
4589: p_LEAD_DATE => FND_API.G_MISS_DATE,
4590: p_SOURCE_SYSTEM => FND_API.G_MISS_CHAR,
4591: p_COUNTRY => FND_API.G_MISS_CHAR,
4592: p_TOTAL_AMOUNT => FND_API.G_MISS_NUM,
4593: p_EXPIRATION_DATE => FND_API.G_MISS_DATE,
4594: p_LEAD_RANK_IND => FND_API.G_MISS_CHAR,
4595: p_LEAD_ENGINE_RUN_DATE => FND_API.G_MISS_DATE,
4596: p_CURRENT_REROUTES => FND_API.G_MISS_NUM,
4589: p_LEAD_DATE => FND_API.G_MISS_DATE,
4590: p_SOURCE_SYSTEM => FND_API.G_MISS_CHAR,
4591: p_COUNTRY => FND_API.G_MISS_CHAR,
4592: p_TOTAL_AMOUNT => FND_API.G_MISS_NUM,
4593: p_EXPIRATION_DATE => FND_API.G_MISS_DATE,
4594: p_LEAD_RANK_IND => FND_API.G_MISS_CHAR,
4595: p_LEAD_ENGINE_RUN_DATE => FND_API.G_MISS_DATE,
4596: p_CURRENT_REROUTES => FND_API.G_MISS_NUM,
4597: p_STATUS_OPEN_FLAG => FND_API.G_MISS_CHAR,
4590: p_SOURCE_SYSTEM => FND_API.G_MISS_CHAR,
4591: p_COUNTRY => FND_API.G_MISS_CHAR,
4592: p_TOTAL_AMOUNT => FND_API.G_MISS_NUM,
4593: p_EXPIRATION_DATE => FND_API.G_MISS_DATE,
4594: p_LEAD_RANK_IND => FND_API.G_MISS_CHAR,
4595: p_LEAD_ENGINE_RUN_DATE => FND_API.G_MISS_DATE,
4596: p_CURRENT_REROUTES => FND_API.G_MISS_NUM,
4597: p_STATUS_OPEN_FLAG => FND_API.G_MISS_CHAR,
4598: p_LEAD_RANK_SCORE => FND_API.G_MISS_NUM,
4591: p_COUNTRY => FND_API.G_MISS_CHAR,
4592: p_TOTAL_AMOUNT => FND_API.G_MISS_NUM,
4593: p_EXPIRATION_DATE => FND_API.G_MISS_DATE,
4594: p_LEAD_RANK_IND => FND_API.G_MISS_CHAR,
4595: p_LEAD_ENGINE_RUN_DATE => FND_API.G_MISS_DATE,
4596: p_CURRENT_REROUTES => FND_API.G_MISS_NUM,
4597: p_STATUS_OPEN_FLAG => FND_API.G_MISS_CHAR,
4598: p_LEAD_RANK_SCORE => FND_API.G_MISS_NUM,
4599: -- 11.5.10 new columns
4592: p_TOTAL_AMOUNT => FND_API.G_MISS_NUM,
4593: p_EXPIRATION_DATE => FND_API.G_MISS_DATE,
4594: p_LEAD_RANK_IND => FND_API.G_MISS_CHAR,
4595: p_LEAD_ENGINE_RUN_DATE => FND_API.G_MISS_DATE,
4596: p_CURRENT_REROUTES => FND_API.G_MISS_NUM,
4597: p_STATUS_OPEN_FLAG => FND_API.G_MISS_CHAR,
4598: p_LEAD_RANK_SCORE => FND_API.G_MISS_NUM,
4599: -- 11.5.10 new columns
4600: p_MARKETING_SCORE => FND_API.G_MISS_NUM,
4593: p_EXPIRATION_DATE => FND_API.G_MISS_DATE,
4594: p_LEAD_RANK_IND => FND_API.G_MISS_CHAR,
4595: p_LEAD_ENGINE_RUN_DATE => FND_API.G_MISS_DATE,
4596: p_CURRENT_REROUTES => FND_API.G_MISS_NUM,
4597: p_STATUS_OPEN_FLAG => FND_API.G_MISS_CHAR,
4598: p_LEAD_RANK_SCORE => FND_API.G_MISS_NUM,
4599: -- 11.5.10 new columns
4600: p_MARKETING_SCORE => FND_API.G_MISS_NUM,
4601: p_INTERACTION_SCORE => FND_API.G_MISS_NUM,
4594: p_LEAD_RANK_IND => FND_API.G_MISS_CHAR,
4595: p_LEAD_ENGINE_RUN_DATE => FND_API.G_MISS_DATE,
4596: p_CURRENT_REROUTES => FND_API.G_MISS_NUM,
4597: p_STATUS_OPEN_FLAG => FND_API.G_MISS_CHAR,
4598: p_LEAD_RANK_SCORE => FND_API.G_MISS_NUM,
4599: -- 11.5.10 new columns
4600: p_MARKETING_SCORE => FND_API.G_MISS_NUM,
4601: p_INTERACTION_SCORE => FND_API.G_MISS_NUM,
4602: p_SOURCE_PRIMARY_REFERENCE => FND_API.G_MISS_CHAR,
4596: p_CURRENT_REROUTES => FND_API.G_MISS_NUM,
4597: p_STATUS_OPEN_FLAG => FND_API.G_MISS_CHAR,
4598: p_LEAD_RANK_SCORE => FND_API.G_MISS_NUM,
4599: -- 11.5.10 new columns
4600: p_MARKETING_SCORE => FND_API.G_MISS_NUM,
4601: p_INTERACTION_SCORE => FND_API.G_MISS_NUM,
4602: p_SOURCE_PRIMARY_REFERENCE => FND_API.G_MISS_CHAR,
4603: p_SOURCE_SECONDARY_REFERENCE => FND_API.G_MISS_CHAR,
4604: p_SALES_METHODOLOGY_ID => FND_API.G_MISS_NUM,
4597: p_STATUS_OPEN_FLAG => FND_API.G_MISS_CHAR,
4598: p_LEAD_RANK_SCORE => FND_API.G_MISS_NUM,
4599: -- 11.5.10 new columns
4600: p_MARKETING_SCORE => FND_API.G_MISS_NUM,
4601: p_INTERACTION_SCORE => FND_API.G_MISS_NUM,
4602: p_SOURCE_PRIMARY_REFERENCE => FND_API.G_MISS_CHAR,
4603: p_SOURCE_SECONDARY_REFERENCE => FND_API.G_MISS_CHAR,
4604: p_SALES_METHODOLOGY_ID => FND_API.G_MISS_NUM,
4605: p_SALES_STAGE_ID => FND_API.G_MISS_NUM);
4598: p_LEAD_RANK_SCORE => FND_API.G_MISS_NUM,
4599: -- 11.5.10 new columns
4600: p_MARKETING_SCORE => FND_API.G_MISS_NUM,
4601: p_INTERACTION_SCORE => FND_API.G_MISS_NUM,
4602: p_SOURCE_PRIMARY_REFERENCE => FND_API.G_MISS_CHAR,
4603: p_SOURCE_SECONDARY_REFERENCE => FND_API.G_MISS_CHAR,
4604: p_SALES_METHODOLOGY_ID => FND_API.G_MISS_NUM,
4605: p_SALES_STAGE_ID => FND_API.G_MISS_NUM);
4606:
4599: -- 11.5.10 new columns
4600: p_MARKETING_SCORE => FND_API.G_MISS_NUM,
4601: p_INTERACTION_SCORE => FND_API.G_MISS_NUM,
4602: p_SOURCE_PRIMARY_REFERENCE => FND_API.G_MISS_CHAR,
4603: p_SOURCE_SECONDARY_REFERENCE => FND_API.G_MISS_CHAR,
4604: p_SALES_METHODOLOGY_ID => FND_API.G_MISS_NUM,
4605: p_SALES_STAGE_ID => FND_API.G_MISS_NUM);
4606:
4607: -- Check whether this resource is in sales team or not
4600: p_MARKETING_SCORE => FND_API.G_MISS_NUM,
4601: p_INTERACTION_SCORE => FND_API.G_MISS_NUM,
4602: p_SOURCE_PRIMARY_REFERENCE => FND_API.G_MISS_CHAR,
4603: p_SOURCE_SECONDARY_REFERENCE => FND_API.G_MISS_CHAR,
4604: p_SALES_METHODOLOGY_ID => FND_API.G_MISS_NUM,
4605: p_SALES_STAGE_ID => FND_API.G_MISS_NUM);
4606:
4607: -- Check whether this resource is in sales team or not
4608: l_access_exist_flag := 'N';
4601: p_INTERACTION_SCORE => FND_API.G_MISS_NUM,
4602: p_SOURCE_PRIMARY_REFERENCE => FND_API.G_MISS_CHAR,
4603: p_SOURCE_SECONDARY_REFERENCE => FND_API.G_MISS_CHAR,
4604: p_SALES_METHODOLOGY_ID => FND_API.G_MISS_NUM,
4605: p_SALES_STAGE_ID => FND_API.G_MISS_NUM);
4606:
4607: -- Check whether this resource is in sales team or not
4608: l_access_exist_flag := 'N';
4609: OPEN c_access_exist(p_sales_lead_id, l_resource_id, l_group_id);
4778: l_sales_lead_rec.sales_lead_id := p_sales_lead_id;
4779:
4780: AS_LEAD_ROUTING_WF_CUHK.Get_Owner_Pre(
4781: p_api_version_number => 2.0,
4782: p_init_msg_list => FND_API.G_FALSE,
4783: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
4784: p_commit => FND_API.G_FALSE,
4785: p_resource_id_tbl => l_resource_id_tbl,
4786: p_group_id_tbl => l_group_id_tbl,
4779:
4780: AS_LEAD_ROUTING_WF_CUHK.Get_Owner_Pre(
4781: p_api_version_number => 2.0,
4782: p_init_msg_list => FND_API.G_FALSE,
4783: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
4784: p_commit => FND_API.G_FALSE,
4785: p_resource_id_tbl => l_resource_id_tbl,
4786: p_group_id_tbl => l_group_id_tbl,
4787: p_person_id_tbl => l_person_id_tbl,
4780: AS_LEAD_ROUTING_WF_CUHK.Get_Owner_Pre(
4781: p_api_version_number => 2.0,
4782: p_init_msg_list => FND_API.G_FALSE,
4783: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
4784: p_commit => FND_API.G_FALSE,
4785: p_resource_id_tbl => l_resource_id_tbl,
4786: p_group_id_tbl => l_group_id_tbl,
4787: p_person_id_tbl => l_person_id_tbl,
4788: p_resource_flag_tbl => l_resource_flag_tbl,
4793: x_return_status => x_return_status,
4794: x_msg_count => x_msg_count,
4795: x_msg_data => x_msg_data);
4796:
4797: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4798: RAISE FND_API.G_EXC_ERROR;
4799: END IF;
4800:
4801: IF l_resource_id IS NULL
4794: x_msg_count => x_msg_count,
4795: x_msg_data => x_msg_data);
4796:
4797: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4798: RAISE FND_API.G_EXC_ERROR;
4799: END IF;
4800:
4801: IF l_resource_id IS NULL
4802: THEN
4850: AS_SALES_LEADS_PKG.Sales_Lead_Update_Row(
4851: p_SALES_LEAD_ID => p_SALES_LEAD_ID,
4852: p_LAST_UPDATE_DATE => SYSDATE,
4853: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
4854: p_CREATION_DATE => FND_API.G_MISS_DATE,
4855: p_CREATED_BY => FND_API.G_MISS_NUM,
4856: p_LAST_UPDATE_LOGIN => FND_API.G_MISS_NUM,
4857: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,
4858: p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id,
4851: p_SALES_LEAD_ID => p_SALES_LEAD_ID,
4852: p_LAST_UPDATE_DATE => SYSDATE,
4853: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
4854: p_CREATION_DATE => FND_API.G_MISS_DATE,
4855: p_CREATED_BY => FND_API.G_MISS_NUM,
4856: p_LAST_UPDATE_LOGIN => FND_API.G_MISS_NUM,
4857: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,
4858: p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id,
4859: p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id,
4852: p_LAST_UPDATE_DATE => SYSDATE,
4853: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
4854: p_CREATION_DATE => FND_API.G_MISS_DATE,
4855: p_CREATED_BY => FND_API.G_MISS_NUM,
4856: p_LAST_UPDATE_LOGIN => FND_API.G_MISS_NUM,
4857: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,
4858: p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id,
4859: p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id,
4860: p_PROGRAM_UPDATE_DATE => SYSDATE,
4857: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,
4858: p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id,
4859: p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id,
4860: p_PROGRAM_UPDATE_DATE => SYSDATE,
4861: p_LEAD_NUMBER => FND_API.G_MISS_CHAR,
4862: p_STATUS_CODE => FND_API.G_MISS_CHAR, --l_routing_status,
4863: p_CUSTOMER_ID => l_CUSTOMER_ID,
4864: p_ADDRESS_ID => l_ADDRESS_ID,
4865: p_SOURCE_PROMOTION_ID => FND_API.G_MISS_NUM,
4858: p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id,
4859: p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id,
4860: p_PROGRAM_UPDATE_DATE => SYSDATE,
4861: p_LEAD_NUMBER => FND_API.G_MISS_CHAR,
4862: p_STATUS_CODE => FND_API.G_MISS_CHAR, --l_routing_status,
4863: p_CUSTOMER_ID => l_CUSTOMER_ID,
4864: p_ADDRESS_ID => l_ADDRESS_ID,
4865: p_SOURCE_PROMOTION_ID => FND_API.G_MISS_NUM,
4866: p_INITIATING_CONTACT_ID => FND_API.G_MISS_NUM,
4861: p_LEAD_NUMBER => FND_API.G_MISS_CHAR,
4862: p_STATUS_CODE => FND_API.G_MISS_CHAR, --l_routing_status,
4863: p_CUSTOMER_ID => l_CUSTOMER_ID,
4864: p_ADDRESS_ID => l_ADDRESS_ID,
4865: p_SOURCE_PROMOTION_ID => FND_API.G_MISS_NUM,
4866: p_INITIATING_CONTACT_ID => FND_API.G_MISS_NUM,
4867: p_ORIG_SYSTEM_REFERENCE => FND_API.G_MISS_CHAR,
4868: p_CONTACT_ROLE_CODE => FND_API.G_MISS_CHAR,
4869: p_CHANNEL_CODE => FND_API.G_MISS_CHAR,
4862: p_STATUS_CODE => FND_API.G_MISS_CHAR, --l_routing_status,
4863: p_CUSTOMER_ID => l_CUSTOMER_ID,
4864: p_ADDRESS_ID => l_ADDRESS_ID,
4865: p_SOURCE_PROMOTION_ID => FND_API.G_MISS_NUM,
4866: p_INITIATING_CONTACT_ID => FND_API.G_MISS_NUM,
4867: p_ORIG_SYSTEM_REFERENCE => FND_API.G_MISS_CHAR,
4868: p_CONTACT_ROLE_CODE => FND_API.G_MISS_CHAR,
4869: p_CHANNEL_CODE => FND_API.G_MISS_CHAR,
4870: p_BUDGET_AMOUNT => FND_API.G_MISS_NUM,
4863: p_CUSTOMER_ID => l_CUSTOMER_ID,
4864: p_ADDRESS_ID => l_ADDRESS_ID,
4865: p_SOURCE_PROMOTION_ID => FND_API.G_MISS_NUM,
4866: p_INITIATING_CONTACT_ID => FND_API.G_MISS_NUM,
4867: p_ORIG_SYSTEM_REFERENCE => FND_API.G_MISS_CHAR,
4868: p_CONTACT_ROLE_CODE => FND_API.G_MISS_CHAR,
4869: p_CHANNEL_CODE => FND_API.G_MISS_CHAR,
4870: p_BUDGET_AMOUNT => FND_API.G_MISS_NUM,
4871: p_CURRENCY_CODE => FND_API.G_MISS_CHAR,
4864: p_ADDRESS_ID => l_ADDRESS_ID,
4865: p_SOURCE_PROMOTION_ID => FND_API.G_MISS_NUM,
4866: p_INITIATING_CONTACT_ID => FND_API.G_MISS_NUM,
4867: p_ORIG_SYSTEM_REFERENCE => FND_API.G_MISS_CHAR,
4868: p_CONTACT_ROLE_CODE => FND_API.G_MISS_CHAR,
4869: p_CHANNEL_CODE => FND_API.G_MISS_CHAR,
4870: p_BUDGET_AMOUNT => FND_API.G_MISS_NUM,
4871: p_CURRENCY_CODE => FND_API.G_MISS_CHAR,
4872: p_DECISION_TIMEFRAME_CODE => FND_API.G_MISS_CHAR,
4865: p_SOURCE_PROMOTION_ID => FND_API.G_MISS_NUM,
4866: p_INITIATING_CONTACT_ID => FND_API.G_MISS_NUM,
4867: p_ORIG_SYSTEM_REFERENCE => FND_API.G_MISS_CHAR,
4868: p_CONTACT_ROLE_CODE => FND_API.G_MISS_CHAR,
4869: p_CHANNEL_CODE => FND_API.G_MISS_CHAR,
4870: p_BUDGET_AMOUNT => FND_API.G_MISS_NUM,
4871: p_CURRENCY_CODE => FND_API.G_MISS_CHAR,
4872: p_DECISION_TIMEFRAME_CODE => FND_API.G_MISS_CHAR,
4873: p_CLOSE_REASON => FND_API.G_MISS_CHAR,
4866: p_INITIATING_CONTACT_ID => FND_API.G_MISS_NUM,
4867: p_ORIG_SYSTEM_REFERENCE => FND_API.G_MISS_CHAR,
4868: p_CONTACT_ROLE_CODE => FND_API.G_MISS_CHAR,
4869: p_CHANNEL_CODE => FND_API.G_MISS_CHAR,
4870: p_BUDGET_AMOUNT => FND_API.G_MISS_NUM,
4871: p_CURRENCY_CODE => FND_API.G_MISS_CHAR,
4872: p_DECISION_TIMEFRAME_CODE => FND_API.G_MISS_CHAR,
4873: p_CLOSE_REASON => FND_API.G_MISS_CHAR,
4874: p_LEAD_RANK_ID => FND_API.G_MISS_NUM,
4867: p_ORIG_SYSTEM_REFERENCE => FND_API.G_MISS_CHAR,
4868: p_CONTACT_ROLE_CODE => FND_API.G_MISS_CHAR,
4869: p_CHANNEL_CODE => FND_API.G_MISS_CHAR,
4870: p_BUDGET_AMOUNT => FND_API.G_MISS_NUM,
4871: p_CURRENCY_CODE => FND_API.G_MISS_CHAR,
4872: p_DECISION_TIMEFRAME_CODE => FND_API.G_MISS_CHAR,
4873: p_CLOSE_REASON => FND_API.G_MISS_CHAR,
4874: p_LEAD_RANK_ID => FND_API.G_MISS_NUM,
4875: p_LEAD_RANK_CODE => FND_API.G_MISS_CHAR,
4868: p_CONTACT_ROLE_CODE => FND_API.G_MISS_CHAR,
4869: p_CHANNEL_CODE => FND_API.G_MISS_CHAR,
4870: p_BUDGET_AMOUNT => FND_API.G_MISS_NUM,
4871: p_CURRENCY_CODE => FND_API.G_MISS_CHAR,
4872: p_DECISION_TIMEFRAME_CODE => FND_API.G_MISS_CHAR,
4873: p_CLOSE_REASON => FND_API.G_MISS_CHAR,
4874: p_LEAD_RANK_ID => FND_API.G_MISS_NUM,
4875: p_LEAD_RANK_CODE => FND_API.G_MISS_CHAR,
4876: p_PARENT_PROJECT => FND_API.G_MISS_CHAR,
4869: p_CHANNEL_CODE => FND_API.G_MISS_CHAR,
4870: p_BUDGET_AMOUNT => FND_API.G_MISS_NUM,
4871: p_CURRENCY_CODE => FND_API.G_MISS_CHAR,
4872: p_DECISION_TIMEFRAME_CODE => FND_API.G_MISS_CHAR,
4873: p_CLOSE_REASON => FND_API.G_MISS_CHAR,
4874: p_LEAD_RANK_ID => FND_API.G_MISS_NUM,
4875: p_LEAD_RANK_CODE => FND_API.G_MISS_CHAR,
4876: p_PARENT_PROJECT => FND_API.G_MISS_CHAR,
4877: p_DESCRIPTION => FND_API.G_MISS_CHAR,
4870: p_BUDGET_AMOUNT => FND_API.G_MISS_NUM,
4871: p_CURRENCY_CODE => FND_API.G_MISS_CHAR,
4872: p_DECISION_TIMEFRAME_CODE => FND_API.G_MISS_CHAR,
4873: p_CLOSE_REASON => FND_API.G_MISS_CHAR,
4874: p_LEAD_RANK_ID => FND_API.G_MISS_NUM,
4875: p_LEAD_RANK_CODE => FND_API.G_MISS_CHAR,
4876: p_PARENT_PROJECT => FND_API.G_MISS_CHAR,
4877: p_DESCRIPTION => FND_API.G_MISS_CHAR,
4878: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
4871: p_CURRENCY_CODE => FND_API.G_MISS_CHAR,
4872: p_DECISION_TIMEFRAME_CODE => FND_API.G_MISS_CHAR,
4873: p_CLOSE_REASON => FND_API.G_MISS_CHAR,
4874: p_LEAD_RANK_ID => FND_API.G_MISS_NUM,
4875: p_LEAD_RANK_CODE => FND_API.G_MISS_CHAR,
4876: p_PARENT_PROJECT => FND_API.G_MISS_CHAR,
4877: p_DESCRIPTION => FND_API.G_MISS_CHAR,
4878: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
4879: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
4872: p_DECISION_TIMEFRAME_CODE => FND_API.G_MISS_CHAR,
4873: p_CLOSE_REASON => FND_API.G_MISS_CHAR,
4874: p_LEAD_RANK_ID => FND_API.G_MISS_NUM,
4875: p_LEAD_RANK_CODE => FND_API.G_MISS_CHAR,
4876: p_PARENT_PROJECT => FND_API.G_MISS_CHAR,
4877: p_DESCRIPTION => FND_API.G_MISS_CHAR,
4878: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
4879: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
4880: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
4873: p_CLOSE_REASON => FND_API.G_MISS_CHAR,
4874: p_LEAD_RANK_ID => FND_API.G_MISS_NUM,
4875: p_LEAD_RANK_CODE => FND_API.G_MISS_CHAR,
4876: p_PARENT_PROJECT => FND_API.G_MISS_CHAR,
4877: p_DESCRIPTION => FND_API.G_MISS_CHAR,
4878: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
4879: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
4880: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
4881: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
4874: p_LEAD_RANK_ID => FND_API.G_MISS_NUM,
4875: p_LEAD_RANK_CODE => FND_API.G_MISS_CHAR,
4876: p_PARENT_PROJECT => FND_API.G_MISS_CHAR,
4877: p_DESCRIPTION => FND_API.G_MISS_CHAR,
4878: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
4879: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
4880: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
4881: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
4882: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
4875: p_LEAD_RANK_CODE => FND_API.G_MISS_CHAR,
4876: p_PARENT_PROJECT => FND_API.G_MISS_CHAR,
4877: p_DESCRIPTION => FND_API.G_MISS_CHAR,
4878: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
4879: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
4880: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
4881: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
4882: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
4883: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
4876: p_PARENT_PROJECT => FND_API.G_MISS_CHAR,
4877: p_DESCRIPTION => FND_API.G_MISS_CHAR,
4878: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
4879: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
4880: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
4881: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
4882: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
4883: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
4884: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
4877: p_DESCRIPTION => FND_API.G_MISS_CHAR,
4878: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
4879: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
4880: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
4881: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
4882: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
4883: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
4884: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
4885: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
4878: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
4879: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
4880: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
4881: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
4882: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
4883: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
4884: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
4885: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
4886: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
4879: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
4880: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
4881: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
4882: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
4883: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
4884: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
4885: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
4886: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
4887: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
4880: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
4881: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
4882: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
4883: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
4884: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
4885: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
4886: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
4887: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
4888: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
4881: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
4882: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
4883: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
4884: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
4885: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
4886: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
4887: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
4888: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
4889: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
4882: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
4883: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
4884: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
4885: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
4886: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
4887: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
4888: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
4889: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
4890: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
4883: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
4884: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
4885: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
4886: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
4887: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
4888: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
4889: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
4890: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
4891: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
4884: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
4885: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
4886: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
4887: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
4888: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
4889: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
4890: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
4891: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
4892: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
4885: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
4886: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
4887: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
4888: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
4889: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
4890: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
4891: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
4892: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
4893: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
4886: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
4887: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
4888: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
4889: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
4890: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
4891: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
4892: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
4893: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
4894: p_ASSIGN_TO_PERSON_ID => l_person_id,
4887: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
4888: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
4889: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
4890: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
4891: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
4892: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
4893: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
4894: p_ASSIGN_TO_PERSON_ID => l_person_id,
4895: p_ASSIGN_TO_SALESFORCE_ID => l_resource_id,
4888: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
4889: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
4890: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
4891: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
4892: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
4893: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
4894: p_ASSIGN_TO_PERSON_ID => l_person_id,
4895: p_ASSIGN_TO_SALESFORCE_ID => l_resource_id,
4896: p_ASSIGN_SALES_GROUP_ID => l_group_id,
4889: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
4890: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
4891: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
4892: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
4893: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
4894: p_ASSIGN_TO_PERSON_ID => l_person_id,
4895: p_ASSIGN_TO_SALESFORCE_ID => l_resource_id,
4896: p_ASSIGN_SALES_GROUP_ID => l_group_id,
4897: p_ASSIGN_DATE => SYSDATE,
4894: p_ASSIGN_TO_PERSON_ID => l_person_id,
4895: p_ASSIGN_TO_SALESFORCE_ID => l_resource_id,
4896: p_ASSIGN_SALES_GROUP_ID => l_group_id,
4897: p_ASSIGN_DATE => SYSDATE,
4898: p_BUDGET_STATUS_CODE => FND_API.G_MISS_CHAR,
4899: p_ACCEPT_FLAG => 'N',
4900: p_VEHICLE_RESPONSE_CODE => FND_API.G_MISS_CHAR,
4901: p_TOTAL_SCORE => FND_API.G_MISS_NUM,
4902: p_SCORECARD_ID => FND_API.G_MISS_NUM,
4896: p_ASSIGN_SALES_GROUP_ID => l_group_id,
4897: p_ASSIGN_DATE => SYSDATE,
4898: p_BUDGET_STATUS_CODE => FND_API.G_MISS_CHAR,
4899: p_ACCEPT_FLAG => 'N',
4900: p_VEHICLE_RESPONSE_CODE => FND_API.G_MISS_CHAR,
4901: p_TOTAL_SCORE => FND_API.G_MISS_NUM,
4902: p_SCORECARD_ID => FND_API.G_MISS_NUM,
4903: p_KEEP_FLAG => FND_API.G_MISS_CHAR,
4904: p_URGENT_FLAG => FND_API.G_MISS_CHAR,
4897: p_ASSIGN_DATE => SYSDATE,
4898: p_BUDGET_STATUS_CODE => FND_API.G_MISS_CHAR,
4899: p_ACCEPT_FLAG => 'N',
4900: p_VEHICLE_RESPONSE_CODE => FND_API.G_MISS_CHAR,
4901: p_TOTAL_SCORE => FND_API.G_MISS_NUM,
4902: p_SCORECARD_ID => FND_API.G_MISS_NUM,
4903: p_KEEP_FLAG => FND_API.G_MISS_CHAR,
4904: p_URGENT_FLAG => FND_API.G_MISS_CHAR,
4905: p_IMPORT_FLAG => FND_API.G_MISS_CHAR,
4898: p_BUDGET_STATUS_CODE => FND_API.G_MISS_CHAR,
4899: p_ACCEPT_FLAG => 'N',
4900: p_VEHICLE_RESPONSE_CODE => FND_API.G_MISS_CHAR,
4901: p_TOTAL_SCORE => FND_API.G_MISS_NUM,
4902: p_SCORECARD_ID => FND_API.G_MISS_NUM,
4903: p_KEEP_FLAG => FND_API.G_MISS_CHAR,
4904: p_URGENT_FLAG => FND_API.G_MISS_CHAR,
4905: p_IMPORT_FLAG => FND_API.G_MISS_CHAR,
4906: p_REJECT_REASON_CODE => NULL, --l_reject_reason_code,
4899: p_ACCEPT_FLAG => 'N',
4900: p_VEHICLE_RESPONSE_CODE => FND_API.G_MISS_CHAR,
4901: p_TOTAL_SCORE => FND_API.G_MISS_NUM,
4902: p_SCORECARD_ID => FND_API.G_MISS_NUM,
4903: p_KEEP_FLAG => FND_API.G_MISS_CHAR,
4904: p_URGENT_FLAG => FND_API.G_MISS_CHAR,
4905: p_IMPORT_FLAG => FND_API.G_MISS_CHAR,
4906: p_REJECT_REASON_CODE => NULL, --l_reject_reason_code,
4907: p_DELETED_FLAG => FND_API.G_MISS_CHAR,
4900: p_VEHICLE_RESPONSE_CODE => FND_API.G_MISS_CHAR,
4901: p_TOTAL_SCORE => FND_API.G_MISS_NUM,
4902: p_SCORECARD_ID => FND_API.G_MISS_NUM,
4903: p_KEEP_FLAG => FND_API.G_MISS_CHAR,
4904: p_URGENT_FLAG => FND_API.G_MISS_CHAR,
4905: p_IMPORT_FLAG => FND_API.G_MISS_CHAR,
4906: p_REJECT_REASON_CODE => NULL, --l_reject_reason_code,
4907: p_DELETED_FLAG => FND_API.G_MISS_CHAR,
4908: p_OFFER_ID => FND_API.G_MISS_NUM,
4901: p_TOTAL_SCORE => FND_API.G_MISS_NUM,
4902: p_SCORECARD_ID => FND_API.G_MISS_NUM,
4903: p_KEEP_FLAG => FND_API.G_MISS_CHAR,
4904: p_URGENT_FLAG => FND_API.G_MISS_CHAR,
4905: p_IMPORT_FLAG => FND_API.G_MISS_CHAR,
4906: p_REJECT_REASON_CODE => NULL, --l_reject_reason_code,
4907: p_DELETED_FLAG => FND_API.G_MISS_CHAR,
4908: p_OFFER_ID => FND_API.G_MISS_NUM,
4909: p_QUALIFIED_FLAG => l_qualified_flag,
4903: p_KEEP_FLAG => FND_API.G_MISS_CHAR,
4904: p_URGENT_FLAG => FND_API.G_MISS_CHAR,
4905: p_IMPORT_FLAG => FND_API.G_MISS_CHAR,
4906: p_REJECT_REASON_CODE => NULL, --l_reject_reason_code,
4907: p_DELETED_FLAG => FND_API.G_MISS_CHAR,
4908: p_OFFER_ID => FND_API.G_MISS_NUM,
4909: p_QUALIFIED_FLAG => l_qualified_flag,
4910: p_ORIG_SYSTEM_CODE => FND_API.G_MISS_CHAR,
4911: -- p_SECURITY_GROUP_ID => FND_API.G_MISS_NUM,
4904: p_URGENT_FLAG => FND_API.G_MISS_CHAR,
4905: p_IMPORT_FLAG => FND_API.G_MISS_CHAR,
4906: p_REJECT_REASON_CODE => NULL, --l_reject_reason_code,
4907: p_DELETED_FLAG => FND_API.G_MISS_CHAR,
4908: p_OFFER_ID => FND_API.G_MISS_NUM,
4909: p_QUALIFIED_FLAG => l_qualified_flag,
4910: p_ORIG_SYSTEM_CODE => FND_API.G_MISS_CHAR,
4911: -- p_SECURITY_GROUP_ID => FND_API.G_MISS_NUM,
4912: p_INC_PARTNER_PARTY_ID => FND_API.G_MISS_NUM,
4906: p_REJECT_REASON_CODE => NULL, --l_reject_reason_code,
4907: p_DELETED_FLAG => FND_API.G_MISS_CHAR,
4908: p_OFFER_ID => FND_API.G_MISS_NUM,
4909: p_QUALIFIED_FLAG => l_qualified_flag,
4910: p_ORIG_SYSTEM_CODE => FND_API.G_MISS_CHAR,
4911: -- p_SECURITY_GROUP_ID => FND_API.G_MISS_NUM,
4912: p_INC_PARTNER_PARTY_ID => FND_API.G_MISS_NUM,
4913: p_INC_PARTNER_RESOURCE_ID => FND_API.G_MISS_NUM,
4914: p_PRM_EXEC_SPONSOR_FLAG => FND_API.G_MISS_CHAR,
4907: p_DELETED_FLAG => FND_API.G_MISS_CHAR,
4908: p_OFFER_ID => FND_API.G_MISS_NUM,
4909: p_QUALIFIED_FLAG => l_qualified_flag,
4910: p_ORIG_SYSTEM_CODE => FND_API.G_MISS_CHAR,
4911: -- p_SECURITY_GROUP_ID => FND_API.G_MISS_NUM,
4912: p_INC_PARTNER_PARTY_ID => FND_API.G_MISS_NUM,
4913: p_INC_PARTNER_RESOURCE_ID => FND_API.G_MISS_NUM,
4914: p_PRM_EXEC_SPONSOR_FLAG => FND_API.G_MISS_CHAR,
4915: p_PRM_PRJ_LEAD_IN_PLACE_FLAG => FND_API.G_MISS_CHAR,
4908: p_OFFER_ID => FND_API.G_MISS_NUM,
4909: p_QUALIFIED_FLAG => l_qualified_flag,
4910: p_ORIG_SYSTEM_CODE => FND_API.G_MISS_CHAR,
4911: -- p_SECURITY_GROUP_ID => FND_API.G_MISS_NUM,
4912: p_INC_PARTNER_PARTY_ID => FND_API.G_MISS_NUM,
4913: p_INC_PARTNER_RESOURCE_ID => FND_API.G_MISS_NUM,
4914: p_PRM_EXEC_SPONSOR_FLAG => FND_API.G_MISS_CHAR,
4915: p_PRM_PRJ_LEAD_IN_PLACE_FLAG => FND_API.G_MISS_CHAR,
4916: p_PRM_SALES_LEAD_TYPE => FND_API.G_MISS_CHAR,
4909: p_QUALIFIED_FLAG => l_qualified_flag,
4910: p_ORIG_SYSTEM_CODE => FND_API.G_MISS_CHAR,
4911: -- p_SECURITY_GROUP_ID => FND_API.G_MISS_NUM,
4912: p_INC_PARTNER_PARTY_ID => FND_API.G_MISS_NUM,
4913: p_INC_PARTNER_RESOURCE_ID => FND_API.G_MISS_NUM,
4914: p_PRM_EXEC_SPONSOR_FLAG => FND_API.G_MISS_CHAR,
4915: p_PRM_PRJ_LEAD_IN_PLACE_FLAG => FND_API.G_MISS_CHAR,
4916: p_PRM_SALES_LEAD_TYPE => FND_API.G_MISS_CHAR,
4917: p_PRM_IND_CLASSIFICATION_CODE => FND_API.G_MISS_CHAR,
4910: p_ORIG_SYSTEM_CODE => FND_API.G_MISS_CHAR,
4911: -- p_SECURITY_GROUP_ID => FND_API.G_MISS_NUM,
4912: p_INC_PARTNER_PARTY_ID => FND_API.G_MISS_NUM,
4913: p_INC_PARTNER_RESOURCE_ID => FND_API.G_MISS_NUM,
4914: p_PRM_EXEC_SPONSOR_FLAG => FND_API.G_MISS_CHAR,
4915: p_PRM_PRJ_LEAD_IN_PLACE_FLAG => FND_API.G_MISS_CHAR,
4916: p_PRM_SALES_LEAD_TYPE => FND_API.G_MISS_CHAR,
4917: p_PRM_IND_CLASSIFICATION_CODE => FND_API.G_MISS_CHAR,
4918: p_PRM_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
4911: -- p_SECURITY_GROUP_ID => FND_API.G_MISS_NUM,
4912: p_INC_PARTNER_PARTY_ID => FND_API.G_MISS_NUM,
4913: p_INC_PARTNER_RESOURCE_ID => FND_API.G_MISS_NUM,
4914: p_PRM_EXEC_SPONSOR_FLAG => FND_API.G_MISS_CHAR,
4915: p_PRM_PRJ_LEAD_IN_PLACE_FLAG => FND_API.G_MISS_CHAR,
4916: p_PRM_SALES_LEAD_TYPE => FND_API.G_MISS_CHAR,
4917: p_PRM_IND_CLASSIFICATION_CODE => FND_API.G_MISS_CHAR,
4918: p_PRM_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
4919: p_AUTO_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
4912: p_INC_PARTNER_PARTY_ID => FND_API.G_MISS_NUM,
4913: p_INC_PARTNER_RESOURCE_ID => FND_API.G_MISS_NUM,
4914: p_PRM_EXEC_SPONSOR_FLAG => FND_API.G_MISS_CHAR,
4915: p_PRM_PRJ_LEAD_IN_PLACE_FLAG => FND_API.G_MISS_CHAR,
4916: p_PRM_SALES_LEAD_TYPE => FND_API.G_MISS_CHAR,
4917: p_PRM_IND_CLASSIFICATION_CODE => FND_API.G_MISS_CHAR,
4918: p_PRM_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
4919: p_AUTO_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
4920: p_PRIMARY_CONTACT_PARTY_ID => FND_API.G_MISS_NUM,
4913: p_INC_PARTNER_RESOURCE_ID => FND_API.G_MISS_NUM,
4914: p_PRM_EXEC_SPONSOR_FLAG => FND_API.G_MISS_CHAR,
4915: p_PRM_PRJ_LEAD_IN_PLACE_FLAG => FND_API.G_MISS_CHAR,
4916: p_PRM_SALES_LEAD_TYPE => FND_API.G_MISS_CHAR,
4917: p_PRM_IND_CLASSIFICATION_CODE => FND_API.G_MISS_CHAR,
4918: p_PRM_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
4919: p_AUTO_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
4920: p_PRIMARY_CONTACT_PARTY_ID => FND_API.G_MISS_NUM,
4921: p_PRIMARY_CNT_PERSON_PARTY_ID => FND_API.G_MISS_NUM,
4914: p_PRM_EXEC_SPONSOR_FLAG => FND_API.G_MISS_CHAR,
4915: p_PRM_PRJ_LEAD_IN_PLACE_FLAG => FND_API.G_MISS_CHAR,
4916: p_PRM_SALES_LEAD_TYPE => FND_API.G_MISS_CHAR,
4917: p_PRM_IND_CLASSIFICATION_CODE => FND_API.G_MISS_CHAR,
4918: p_PRM_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
4919: p_AUTO_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
4920: p_PRIMARY_CONTACT_PARTY_ID => FND_API.G_MISS_NUM,
4921: p_PRIMARY_CNT_PERSON_PARTY_ID => FND_API.G_MISS_NUM,
4922: p_PRIMARY_CONTACT_PHONE_ID => FND_API.G_MISS_NUM,
4915: p_PRM_PRJ_LEAD_IN_PLACE_FLAG => FND_API.G_MISS_CHAR,
4916: p_PRM_SALES_LEAD_TYPE => FND_API.G_MISS_CHAR,
4917: p_PRM_IND_CLASSIFICATION_CODE => FND_API.G_MISS_CHAR,
4918: p_PRM_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
4919: p_AUTO_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
4920: p_PRIMARY_CONTACT_PARTY_ID => FND_API.G_MISS_NUM,
4921: p_PRIMARY_CNT_PERSON_PARTY_ID => FND_API.G_MISS_NUM,
4922: p_PRIMARY_CONTACT_PHONE_ID => FND_API.G_MISS_NUM,
4923: p_REFERRED_BY => FND_API.G_MISS_NUM,
4916: p_PRM_SALES_LEAD_TYPE => FND_API.G_MISS_CHAR,
4917: p_PRM_IND_CLASSIFICATION_CODE => FND_API.G_MISS_CHAR,
4918: p_PRM_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
4919: p_AUTO_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
4920: p_PRIMARY_CONTACT_PARTY_ID => FND_API.G_MISS_NUM,
4921: p_PRIMARY_CNT_PERSON_PARTY_ID => FND_API.G_MISS_NUM,
4922: p_PRIMARY_CONTACT_PHONE_ID => FND_API.G_MISS_NUM,
4923: p_REFERRED_BY => FND_API.G_MISS_NUM,
4924: p_REFERRAL_TYPE => FND_API.G_MISS_CHAR,
4917: p_PRM_IND_CLASSIFICATION_CODE => FND_API.G_MISS_CHAR,
4918: p_PRM_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
4919: p_AUTO_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
4920: p_PRIMARY_CONTACT_PARTY_ID => FND_API.G_MISS_NUM,
4921: p_PRIMARY_CNT_PERSON_PARTY_ID => FND_API.G_MISS_NUM,
4922: p_PRIMARY_CONTACT_PHONE_ID => FND_API.G_MISS_NUM,
4923: p_REFERRED_BY => FND_API.G_MISS_NUM,
4924: p_REFERRAL_TYPE => FND_API.G_MISS_CHAR,
4925: p_REFERRAL_STATUS => FND_API.G_MISS_CHAR,
4918: p_PRM_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
4919: p_AUTO_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
4920: p_PRIMARY_CONTACT_PARTY_ID => FND_API.G_MISS_NUM,
4921: p_PRIMARY_CNT_PERSON_PARTY_ID => FND_API.G_MISS_NUM,
4922: p_PRIMARY_CONTACT_PHONE_ID => FND_API.G_MISS_NUM,
4923: p_REFERRED_BY => FND_API.G_MISS_NUM,
4924: p_REFERRAL_TYPE => FND_API.G_MISS_CHAR,
4925: p_REFERRAL_STATUS => FND_API.G_MISS_CHAR,
4926: p_REF_DECLINE_REASON => FND_API.G_MISS_CHAR,
4919: p_AUTO_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
4920: p_PRIMARY_CONTACT_PARTY_ID => FND_API.G_MISS_NUM,
4921: p_PRIMARY_CNT_PERSON_PARTY_ID => FND_API.G_MISS_NUM,
4922: p_PRIMARY_CONTACT_PHONE_ID => FND_API.G_MISS_NUM,
4923: p_REFERRED_BY => FND_API.G_MISS_NUM,
4924: p_REFERRAL_TYPE => FND_API.G_MISS_CHAR,
4925: p_REFERRAL_STATUS => FND_API.G_MISS_CHAR,
4926: p_REF_DECLINE_REASON => FND_API.G_MISS_CHAR,
4927: p_REF_COMM_LTR_STATUS => FND_API.G_MISS_CHAR,
4920: p_PRIMARY_CONTACT_PARTY_ID => FND_API.G_MISS_NUM,
4921: p_PRIMARY_CNT_PERSON_PARTY_ID => FND_API.G_MISS_NUM,
4922: p_PRIMARY_CONTACT_PHONE_ID => FND_API.G_MISS_NUM,
4923: p_REFERRED_BY => FND_API.G_MISS_NUM,
4924: p_REFERRAL_TYPE => FND_API.G_MISS_CHAR,
4925: p_REFERRAL_STATUS => FND_API.G_MISS_CHAR,
4926: p_REF_DECLINE_REASON => FND_API.G_MISS_CHAR,
4927: p_REF_COMM_LTR_STATUS => FND_API.G_MISS_CHAR,
4928: p_REF_ORDER_NUMBER => FND_API.G_MISS_NUM,
4921: p_PRIMARY_CNT_PERSON_PARTY_ID => FND_API.G_MISS_NUM,
4922: p_PRIMARY_CONTACT_PHONE_ID => FND_API.G_MISS_NUM,
4923: p_REFERRED_BY => FND_API.G_MISS_NUM,
4924: p_REFERRAL_TYPE => FND_API.G_MISS_CHAR,
4925: p_REFERRAL_STATUS => FND_API.G_MISS_CHAR,
4926: p_REF_DECLINE_REASON => FND_API.G_MISS_CHAR,
4927: p_REF_COMM_LTR_STATUS => FND_API.G_MISS_CHAR,
4928: p_REF_ORDER_NUMBER => FND_API.G_MISS_NUM,
4929: p_REF_ORDER_AMT => FND_API.G_MISS_NUM,
4922: p_PRIMARY_CONTACT_PHONE_ID => FND_API.G_MISS_NUM,
4923: p_REFERRED_BY => FND_API.G_MISS_NUM,
4924: p_REFERRAL_TYPE => FND_API.G_MISS_CHAR,
4925: p_REFERRAL_STATUS => FND_API.G_MISS_CHAR,
4926: p_REF_DECLINE_REASON => FND_API.G_MISS_CHAR,
4927: p_REF_COMM_LTR_STATUS => FND_API.G_MISS_CHAR,
4928: p_REF_ORDER_NUMBER => FND_API.G_MISS_NUM,
4929: p_REF_ORDER_AMT => FND_API.G_MISS_NUM,
4930: p_REF_COMM_AMT => FND_API.G_MISS_NUM,
4923: p_REFERRED_BY => FND_API.G_MISS_NUM,
4924: p_REFERRAL_TYPE => FND_API.G_MISS_CHAR,
4925: p_REFERRAL_STATUS => FND_API.G_MISS_CHAR,
4926: p_REF_DECLINE_REASON => FND_API.G_MISS_CHAR,
4927: p_REF_COMM_LTR_STATUS => FND_API.G_MISS_CHAR,
4928: p_REF_ORDER_NUMBER => FND_API.G_MISS_NUM,
4929: p_REF_ORDER_AMT => FND_API.G_MISS_NUM,
4930: p_REF_COMM_AMT => FND_API.G_MISS_NUM,
4931: -- bug No.2341515, 2368075
4924: p_REFERRAL_TYPE => FND_API.G_MISS_CHAR,
4925: p_REFERRAL_STATUS => FND_API.G_MISS_CHAR,
4926: p_REF_DECLINE_REASON => FND_API.G_MISS_CHAR,
4927: p_REF_COMM_LTR_STATUS => FND_API.G_MISS_CHAR,
4928: p_REF_ORDER_NUMBER => FND_API.G_MISS_NUM,
4929: p_REF_ORDER_AMT => FND_API.G_MISS_NUM,
4930: p_REF_COMM_AMT => FND_API.G_MISS_NUM,
4931: -- bug No.2341515, 2368075
4932: p_LEAD_DATE => FND_API.G_MISS_DATE,
4925: p_REFERRAL_STATUS => FND_API.G_MISS_CHAR,
4926: p_REF_DECLINE_REASON => FND_API.G_MISS_CHAR,
4927: p_REF_COMM_LTR_STATUS => FND_API.G_MISS_CHAR,
4928: p_REF_ORDER_NUMBER => FND_API.G_MISS_NUM,
4929: p_REF_ORDER_AMT => FND_API.G_MISS_NUM,
4930: p_REF_COMM_AMT => FND_API.G_MISS_NUM,
4931: -- bug No.2341515, 2368075
4932: p_LEAD_DATE => FND_API.G_MISS_DATE,
4933: p_SOURCE_SYSTEM => FND_API.G_MISS_CHAR,
4926: p_REF_DECLINE_REASON => FND_API.G_MISS_CHAR,
4927: p_REF_COMM_LTR_STATUS => FND_API.G_MISS_CHAR,
4928: p_REF_ORDER_NUMBER => FND_API.G_MISS_NUM,
4929: p_REF_ORDER_AMT => FND_API.G_MISS_NUM,
4930: p_REF_COMM_AMT => FND_API.G_MISS_NUM,
4931: -- bug No.2341515, 2368075
4932: p_LEAD_DATE => FND_API.G_MISS_DATE,
4933: p_SOURCE_SYSTEM => FND_API.G_MISS_CHAR,
4934: p_COUNTRY => FND_API.G_MISS_CHAR,
4928: p_REF_ORDER_NUMBER => FND_API.G_MISS_NUM,
4929: p_REF_ORDER_AMT => FND_API.G_MISS_NUM,
4930: p_REF_COMM_AMT => FND_API.G_MISS_NUM,
4931: -- bug No.2341515, 2368075
4932: p_LEAD_DATE => FND_API.G_MISS_DATE,
4933: p_SOURCE_SYSTEM => FND_API.G_MISS_CHAR,
4934: p_COUNTRY => FND_API.G_MISS_CHAR,
4935: p_TOTAL_AMOUNT => FND_API.G_MISS_NUM,
4936: p_EXPIRATION_DATE => FND_API.G_MISS_DATE,
4929: p_REF_ORDER_AMT => FND_API.G_MISS_NUM,
4930: p_REF_COMM_AMT => FND_API.G_MISS_NUM,
4931: -- bug No.2341515, 2368075
4932: p_LEAD_DATE => FND_API.G_MISS_DATE,
4933: p_SOURCE_SYSTEM => FND_API.G_MISS_CHAR,
4934: p_COUNTRY => FND_API.G_MISS_CHAR,
4935: p_TOTAL_AMOUNT => FND_API.G_MISS_NUM,
4936: p_EXPIRATION_DATE => FND_API.G_MISS_DATE,
4937: p_LEAD_RANK_IND => FND_API.G_MISS_CHAR,
4930: p_REF_COMM_AMT => FND_API.G_MISS_NUM,
4931: -- bug No.2341515, 2368075
4932: p_LEAD_DATE => FND_API.G_MISS_DATE,
4933: p_SOURCE_SYSTEM => FND_API.G_MISS_CHAR,
4934: p_COUNTRY => FND_API.G_MISS_CHAR,
4935: p_TOTAL_AMOUNT => FND_API.G_MISS_NUM,
4936: p_EXPIRATION_DATE => FND_API.G_MISS_DATE,
4937: p_LEAD_RANK_IND => FND_API.G_MISS_CHAR,
4938: p_LEAD_ENGINE_RUN_DATE => FND_API.G_MISS_DATE,
4931: -- bug No.2341515, 2368075
4932: p_LEAD_DATE => FND_API.G_MISS_DATE,
4933: p_SOURCE_SYSTEM => FND_API.G_MISS_CHAR,
4934: p_COUNTRY => FND_API.G_MISS_CHAR,
4935: p_TOTAL_AMOUNT => FND_API.G_MISS_NUM,
4936: p_EXPIRATION_DATE => FND_API.G_MISS_DATE,
4937: p_LEAD_RANK_IND => FND_API.G_MISS_CHAR,
4938: p_LEAD_ENGINE_RUN_DATE => FND_API.G_MISS_DATE,
4939: p_CURRENT_REROUTES => FND_API.G_MISS_NUM,
4932: p_LEAD_DATE => FND_API.G_MISS_DATE,
4933: p_SOURCE_SYSTEM => FND_API.G_MISS_CHAR,
4934: p_COUNTRY => FND_API.G_MISS_CHAR,
4935: p_TOTAL_AMOUNT => FND_API.G_MISS_NUM,
4936: p_EXPIRATION_DATE => FND_API.G_MISS_DATE,
4937: p_LEAD_RANK_IND => FND_API.G_MISS_CHAR,
4938: p_LEAD_ENGINE_RUN_DATE => FND_API.G_MISS_DATE,
4939: p_CURRENT_REROUTES => FND_API.G_MISS_NUM,
4940: p_STATUS_OPEN_FLAG => FND_API.G_MISS_CHAR,
4933: p_SOURCE_SYSTEM => FND_API.G_MISS_CHAR,
4934: p_COUNTRY => FND_API.G_MISS_CHAR,
4935: p_TOTAL_AMOUNT => FND_API.G_MISS_NUM,
4936: p_EXPIRATION_DATE => FND_API.G_MISS_DATE,
4937: p_LEAD_RANK_IND => FND_API.G_MISS_CHAR,
4938: p_LEAD_ENGINE_RUN_DATE => FND_API.G_MISS_DATE,
4939: p_CURRENT_REROUTES => FND_API.G_MISS_NUM,
4940: p_STATUS_OPEN_FLAG => FND_API.G_MISS_CHAR,
4941: p_LEAD_RANK_SCORE => FND_API.G_MISS_NUM,
4934: p_COUNTRY => FND_API.G_MISS_CHAR,
4935: p_TOTAL_AMOUNT => FND_API.G_MISS_NUM,
4936: p_EXPIRATION_DATE => FND_API.G_MISS_DATE,
4937: p_LEAD_RANK_IND => FND_API.G_MISS_CHAR,
4938: p_LEAD_ENGINE_RUN_DATE => FND_API.G_MISS_DATE,
4939: p_CURRENT_REROUTES => FND_API.G_MISS_NUM,
4940: p_STATUS_OPEN_FLAG => FND_API.G_MISS_CHAR,
4941: p_LEAD_RANK_SCORE => FND_API.G_MISS_NUM,
4942: -- 11.5.10 new columns
4935: p_TOTAL_AMOUNT => FND_API.G_MISS_NUM,
4936: p_EXPIRATION_DATE => FND_API.G_MISS_DATE,
4937: p_LEAD_RANK_IND => FND_API.G_MISS_CHAR,
4938: p_LEAD_ENGINE_RUN_DATE => FND_API.G_MISS_DATE,
4939: p_CURRENT_REROUTES => FND_API.G_MISS_NUM,
4940: p_STATUS_OPEN_FLAG => FND_API.G_MISS_CHAR,
4941: p_LEAD_RANK_SCORE => FND_API.G_MISS_NUM,
4942: -- 11.5.10 new columns
4943: p_MARKETING_SCORE => FND_API.G_MISS_NUM,
4936: p_EXPIRATION_DATE => FND_API.G_MISS_DATE,
4937: p_LEAD_RANK_IND => FND_API.G_MISS_CHAR,
4938: p_LEAD_ENGINE_RUN_DATE => FND_API.G_MISS_DATE,
4939: p_CURRENT_REROUTES => FND_API.G_MISS_NUM,
4940: p_STATUS_OPEN_FLAG => FND_API.G_MISS_CHAR,
4941: p_LEAD_RANK_SCORE => FND_API.G_MISS_NUM,
4942: -- 11.5.10 new columns
4943: p_MARKETING_SCORE => FND_API.G_MISS_NUM,
4944: p_INTERACTION_SCORE => FND_API.G_MISS_NUM,
4937: p_LEAD_RANK_IND => FND_API.G_MISS_CHAR,
4938: p_LEAD_ENGINE_RUN_DATE => FND_API.G_MISS_DATE,
4939: p_CURRENT_REROUTES => FND_API.G_MISS_NUM,
4940: p_STATUS_OPEN_FLAG => FND_API.G_MISS_CHAR,
4941: p_LEAD_RANK_SCORE => FND_API.G_MISS_NUM,
4942: -- 11.5.10 new columns
4943: p_MARKETING_SCORE => FND_API.G_MISS_NUM,
4944: p_INTERACTION_SCORE => FND_API.G_MISS_NUM,
4945: p_SOURCE_PRIMARY_REFERENCE => FND_API.G_MISS_CHAR,
4939: p_CURRENT_REROUTES => FND_API.G_MISS_NUM,
4940: p_STATUS_OPEN_FLAG => FND_API.G_MISS_CHAR,
4941: p_LEAD_RANK_SCORE => FND_API.G_MISS_NUM,
4942: -- 11.5.10 new columns
4943: p_MARKETING_SCORE => FND_API.G_MISS_NUM,
4944: p_INTERACTION_SCORE => FND_API.G_MISS_NUM,
4945: p_SOURCE_PRIMARY_REFERENCE => FND_API.G_MISS_CHAR,
4946: p_SOURCE_SECONDARY_REFERENCE => FND_API.G_MISS_CHAR,
4947: p_SALES_METHODOLOGY_ID => FND_API.G_MISS_NUM,
4940: p_STATUS_OPEN_FLAG => FND_API.G_MISS_CHAR,
4941: p_LEAD_RANK_SCORE => FND_API.G_MISS_NUM,
4942: -- 11.5.10 new columns
4943: p_MARKETING_SCORE => FND_API.G_MISS_NUM,
4944: p_INTERACTION_SCORE => FND_API.G_MISS_NUM,
4945: p_SOURCE_PRIMARY_REFERENCE => FND_API.G_MISS_CHAR,
4946: p_SOURCE_SECONDARY_REFERENCE => FND_API.G_MISS_CHAR,
4947: p_SALES_METHODOLOGY_ID => FND_API.G_MISS_NUM,
4948: p_SALES_STAGE_ID => FND_API.G_MISS_NUM);
4941: p_LEAD_RANK_SCORE => FND_API.G_MISS_NUM,
4942: -- 11.5.10 new columns
4943: p_MARKETING_SCORE => FND_API.G_MISS_NUM,
4944: p_INTERACTION_SCORE => FND_API.G_MISS_NUM,
4945: p_SOURCE_PRIMARY_REFERENCE => FND_API.G_MISS_CHAR,
4946: p_SOURCE_SECONDARY_REFERENCE => FND_API.G_MISS_CHAR,
4947: p_SALES_METHODOLOGY_ID => FND_API.G_MISS_NUM,
4948: p_SALES_STAGE_ID => FND_API.G_MISS_NUM);
4949:
4942: -- 11.5.10 new columns
4943: p_MARKETING_SCORE => FND_API.G_MISS_NUM,
4944: p_INTERACTION_SCORE => FND_API.G_MISS_NUM,
4945: p_SOURCE_PRIMARY_REFERENCE => FND_API.G_MISS_CHAR,
4946: p_SOURCE_SECONDARY_REFERENCE => FND_API.G_MISS_CHAR,
4947: p_SALES_METHODOLOGY_ID => FND_API.G_MISS_NUM,
4948: p_SALES_STAGE_ID => FND_API.G_MISS_NUM);
4949:
4950:
4943: p_MARKETING_SCORE => FND_API.G_MISS_NUM,
4944: p_INTERACTION_SCORE => FND_API.G_MISS_NUM,
4945: p_SOURCE_PRIMARY_REFERENCE => FND_API.G_MISS_CHAR,
4946: p_SOURCE_SECONDARY_REFERENCE => FND_API.G_MISS_CHAR,
4947: p_SALES_METHODOLOGY_ID => FND_API.G_MISS_NUM,
4948: p_SALES_STAGE_ID => FND_API.G_MISS_NUM);
4949:
4950:
4951: l_access_exist_flag := 'N';
4944: p_INTERACTION_SCORE => FND_API.G_MISS_NUM,
4945: p_SOURCE_PRIMARY_REFERENCE => FND_API.G_MISS_CHAR,
4946: p_SOURCE_SECONDARY_REFERENCE => FND_API.G_MISS_CHAR,
4947: p_SALES_METHODOLOGY_ID => FND_API.G_MISS_NUM,
4948: p_SALES_STAGE_ID => FND_API.G_MISS_NUM);
4949:
4950:
4951: l_access_exist_flag := 'N';
4952: OPEN c_access_exist(p_sales_lead_id, l_resource_id, l_group_id);
5135: IF (AS_DEBUG_ERROR_ON) THEN
5136: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR,
5137: 'AS_NO_DEFAULT_CM');
5138: END IF;
5139: RAISE FND_API.G_EXC_ERROR;
5140: END IF;
5141:
5142: OPEN c_get_group_id(l_resource_id);
5143: FETCH c_get_group_id INTO l_group_id;
5187: AS_SALES_LEADS_PKG.Sales_Lead_Update_Row(
5188: p_SALES_LEAD_ID => p_SALES_LEAD_ID,
5189: p_LAST_UPDATE_DATE => SYSDATE,
5190: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
5191: p_CREATION_DATE => FND_API.G_MISS_DATE,
5192: p_CREATED_BY => FND_API.G_MISS_NUM,
5193: p_LAST_UPDATE_LOGIN => FND_API.G_MISS_NUM,
5194: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,
5195: p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id,
5188: p_SALES_LEAD_ID => p_SALES_LEAD_ID,
5189: p_LAST_UPDATE_DATE => SYSDATE,
5190: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
5191: p_CREATION_DATE => FND_API.G_MISS_DATE,
5192: p_CREATED_BY => FND_API.G_MISS_NUM,
5193: p_LAST_UPDATE_LOGIN => FND_API.G_MISS_NUM,
5194: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,
5195: p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id,
5196: p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id,
5189: p_LAST_UPDATE_DATE => SYSDATE,
5190: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
5191: p_CREATION_DATE => FND_API.G_MISS_DATE,
5192: p_CREATED_BY => FND_API.G_MISS_NUM,
5193: p_LAST_UPDATE_LOGIN => FND_API.G_MISS_NUM,
5194: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,
5195: p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id,
5196: p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id,
5197: p_PROGRAM_UPDATE_DATE => SYSDATE,
5194: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,
5195: p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id,
5196: p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id,
5197: p_PROGRAM_UPDATE_DATE => SYSDATE,
5198: p_LEAD_NUMBER => FND_API.G_MISS_CHAR,
5199: p_STATUS_CODE => FND_API.G_MISS_CHAR, --l_routing_status,
5200: p_CUSTOMER_ID => l_CUSTOMER_ID,
5201: p_ADDRESS_ID => l_ADDRESS_ID,
5202: p_SOURCE_PROMOTION_ID => FND_API.G_MISS_NUM,
5195: p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id,
5196: p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id,
5197: p_PROGRAM_UPDATE_DATE => SYSDATE,
5198: p_LEAD_NUMBER => FND_API.G_MISS_CHAR,
5199: p_STATUS_CODE => FND_API.G_MISS_CHAR, --l_routing_status,
5200: p_CUSTOMER_ID => l_CUSTOMER_ID,
5201: p_ADDRESS_ID => l_ADDRESS_ID,
5202: p_SOURCE_PROMOTION_ID => FND_API.G_MISS_NUM,
5203: p_INITIATING_CONTACT_ID => FND_API.G_MISS_NUM,
5198: p_LEAD_NUMBER => FND_API.G_MISS_CHAR,
5199: p_STATUS_CODE => FND_API.G_MISS_CHAR, --l_routing_status,
5200: p_CUSTOMER_ID => l_CUSTOMER_ID,
5201: p_ADDRESS_ID => l_ADDRESS_ID,
5202: p_SOURCE_PROMOTION_ID => FND_API.G_MISS_NUM,
5203: p_INITIATING_CONTACT_ID => FND_API.G_MISS_NUM,
5204: p_ORIG_SYSTEM_REFERENCE => FND_API.G_MISS_CHAR,
5205: p_CONTACT_ROLE_CODE => FND_API.G_MISS_CHAR,
5206: p_CHANNEL_CODE => FND_API.G_MISS_CHAR,
5199: p_STATUS_CODE => FND_API.G_MISS_CHAR, --l_routing_status,
5200: p_CUSTOMER_ID => l_CUSTOMER_ID,
5201: p_ADDRESS_ID => l_ADDRESS_ID,
5202: p_SOURCE_PROMOTION_ID => FND_API.G_MISS_NUM,
5203: p_INITIATING_CONTACT_ID => FND_API.G_MISS_NUM,
5204: p_ORIG_SYSTEM_REFERENCE => FND_API.G_MISS_CHAR,
5205: p_CONTACT_ROLE_CODE => FND_API.G_MISS_CHAR,
5206: p_CHANNEL_CODE => FND_API.G_MISS_CHAR,
5207: p_BUDGET_AMOUNT => FND_API.G_MISS_NUM,
5200: p_CUSTOMER_ID => l_CUSTOMER_ID,
5201: p_ADDRESS_ID => l_ADDRESS_ID,
5202: p_SOURCE_PROMOTION_ID => FND_API.G_MISS_NUM,
5203: p_INITIATING_CONTACT_ID => FND_API.G_MISS_NUM,
5204: p_ORIG_SYSTEM_REFERENCE => FND_API.G_MISS_CHAR,
5205: p_CONTACT_ROLE_CODE => FND_API.G_MISS_CHAR,
5206: p_CHANNEL_CODE => FND_API.G_MISS_CHAR,
5207: p_BUDGET_AMOUNT => FND_API.G_MISS_NUM,
5208: p_CURRENCY_CODE => FND_API.G_MISS_CHAR,
5201: p_ADDRESS_ID => l_ADDRESS_ID,
5202: p_SOURCE_PROMOTION_ID => FND_API.G_MISS_NUM,
5203: p_INITIATING_CONTACT_ID => FND_API.G_MISS_NUM,
5204: p_ORIG_SYSTEM_REFERENCE => FND_API.G_MISS_CHAR,
5205: p_CONTACT_ROLE_CODE => FND_API.G_MISS_CHAR,
5206: p_CHANNEL_CODE => FND_API.G_MISS_CHAR,
5207: p_BUDGET_AMOUNT => FND_API.G_MISS_NUM,
5208: p_CURRENCY_CODE => FND_API.G_MISS_CHAR,
5209: p_DECISION_TIMEFRAME_CODE => FND_API.G_MISS_CHAR,
5202: p_SOURCE_PROMOTION_ID => FND_API.G_MISS_NUM,
5203: p_INITIATING_CONTACT_ID => FND_API.G_MISS_NUM,
5204: p_ORIG_SYSTEM_REFERENCE => FND_API.G_MISS_CHAR,
5205: p_CONTACT_ROLE_CODE => FND_API.G_MISS_CHAR,
5206: p_CHANNEL_CODE => FND_API.G_MISS_CHAR,
5207: p_BUDGET_AMOUNT => FND_API.G_MISS_NUM,
5208: p_CURRENCY_CODE => FND_API.G_MISS_CHAR,
5209: p_DECISION_TIMEFRAME_CODE => FND_API.G_MISS_CHAR,
5210: p_CLOSE_REASON => FND_API.G_MISS_CHAR,
5203: p_INITIATING_CONTACT_ID => FND_API.G_MISS_NUM,
5204: p_ORIG_SYSTEM_REFERENCE => FND_API.G_MISS_CHAR,
5205: p_CONTACT_ROLE_CODE => FND_API.G_MISS_CHAR,
5206: p_CHANNEL_CODE => FND_API.G_MISS_CHAR,
5207: p_BUDGET_AMOUNT => FND_API.G_MISS_NUM,
5208: p_CURRENCY_CODE => FND_API.G_MISS_CHAR,
5209: p_DECISION_TIMEFRAME_CODE => FND_API.G_MISS_CHAR,
5210: p_CLOSE_REASON => FND_API.G_MISS_CHAR,
5211: p_LEAD_RANK_ID => FND_API.G_MISS_NUM,
5204: p_ORIG_SYSTEM_REFERENCE => FND_API.G_MISS_CHAR,
5205: p_CONTACT_ROLE_CODE => FND_API.G_MISS_CHAR,
5206: p_CHANNEL_CODE => FND_API.G_MISS_CHAR,
5207: p_BUDGET_AMOUNT => FND_API.G_MISS_NUM,
5208: p_CURRENCY_CODE => FND_API.G_MISS_CHAR,
5209: p_DECISION_TIMEFRAME_CODE => FND_API.G_MISS_CHAR,
5210: p_CLOSE_REASON => FND_API.G_MISS_CHAR,
5211: p_LEAD_RANK_ID => FND_API.G_MISS_NUM,
5212: p_LEAD_RANK_CODE => FND_API.G_MISS_CHAR,
5205: p_CONTACT_ROLE_CODE => FND_API.G_MISS_CHAR,
5206: p_CHANNEL_CODE => FND_API.G_MISS_CHAR,
5207: p_BUDGET_AMOUNT => FND_API.G_MISS_NUM,
5208: p_CURRENCY_CODE => FND_API.G_MISS_CHAR,
5209: p_DECISION_TIMEFRAME_CODE => FND_API.G_MISS_CHAR,
5210: p_CLOSE_REASON => FND_API.G_MISS_CHAR,
5211: p_LEAD_RANK_ID => FND_API.G_MISS_NUM,
5212: p_LEAD_RANK_CODE => FND_API.G_MISS_CHAR,
5213: p_PARENT_PROJECT => FND_API.G_MISS_CHAR,
5206: p_CHANNEL_CODE => FND_API.G_MISS_CHAR,
5207: p_BUDGET_AMOUNT => FND_API.G_MISS_NUM,
5208: p_CURRENCY_CODE => FND_API.G_MISS_CHAR,
5209: p_DECISION_TIMEFRAME_CODE => FND_API.G_MISS_CHAR,
5210: p_CLOSE_REASON => FND_API.G_MISS_CHAR,
5211: p_LEAD_RANK_ID => FND_API.G_MISS_NUM,
5212: p_LEAD_RANK_CODE => FND_API.G_MISS_CHAR,
5213: p_PARENT_PROJECT => FND_API.G_MISS_CHAR,
5214: p_DESCRIPTION => FND_API.G_MISS_CHAR,
5207: p_BUDGET_AMOUNT => FND_API.G_MISS_NUM,
5208: p_CURRENCY_CODE => FND_API.G_MISS_CHAR,
5209: p_DECISION_TIMEFRAME_CODE => FND_API.G_MISS_CHAR,
5210: p_CLOSE_REASON => FND_API.G_MISS_CHAR,
5211: p_LEAD_RANK_ID => FND_API.G_MISS_NUM,
5212: p_LEAD_RANK_CODE => FND_API.G_MISS_CHAR,
5213: p_PARENT_PROJECT => FND_API.G_MISS_CHAR,
5214: p_DESCRIPTION => FND_API.G_MISS_CHAR,
5215: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
5208: p_CURRENCY_CODE => FND_API.G_MISS_CHAR,
5209: p_DECISION_TIMEFRAME_CODE => FND_API.G_MISS_CHAR,
5210: p_CLOSE_REASON => FND_API.G_MISS_CHAR,
5211: p_LEAD_RANK_ID => FND_API.G_MISS_NUM,
5212: p_LEAD_RANK_CODE => FND_API.G_MISS_CHAR,
5213: p_PARENT_PROJECT => FND_API.G_MISS_CHAR,
5214: p_DESCRIPTION => FND_API.G_MISS_CHAR,
5215: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
5216: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
5209: p_DECISION_TIMEFRAME_CODE => FND_API.G_MISS_CHAR,
5210: p_CLOSE_REASON => FND_API.G_MISS_CHAR,
5211: p_LEAD_RANK_ID => FND_API.G_MISS_NUM,
5212: p_LEAD_RANK_CODE => FND_API.G_MISS_CHAR,
5213: p_PARENT_PROJECT => FND_API.G_MISS_CHAR,
5214: p_DESCRIPTION => FND_API.G_MISS_CHAR,
5215: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
5216: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
5217: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
5210: p_CLOSE_REASON => FND_API.G_MISS_CHAR,
5211: p_LEAD_RANK_ID => FND_API.G_MISS_NUM,
5212: p_LEAD_RANK_CODE => FND_API.G_MISS_CHAR,
5213: p_PARENT_PROJECT => FND_API.G_MISS_CHAR,
5214: p_DESCRIPTION => FND_API.G_MISS_CHAR,
5215: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
5216: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
5217: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
5218: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
5211: p_LEAD_RANK_ID => FND_API.G_MISS_NUM,
5212: p_LEAD_RANK_CODE => FND_API.G_MISS_CHAR,
5213: p_PARENT_PROJECT => FND_API.G_MISS_CHAR,
5214: p_DESCRIPTION => FND_API.G_MISS_CHAR,
5215: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
5216: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
5217: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
5218: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
5219: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
5212: p_LEAD_RANK_CODE => FND_API.G_MISS_CHAR,
5213: p_PARENT_PROJECT => FND_API.G_MISS_CHAR,
5214: p_DESCRIPTION => FND_API.G_MISS_CHAR,
5215: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
5216: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
5217: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
5218: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
5219: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
5220: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
5213: p_PARENT_PROJECT => FND_API.G_MISS_CHAR,
5214: p_DESCRIPTION => FND_API.G_MISS_CHAR,
5215: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
5216: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
5217: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
5218: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
5219: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
5220: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
5221: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
5214: p_DESCRIPTION => FND_API.G_MISS_CHAR,
5215: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
5216: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
5217: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
5218: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
5219: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
5220: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
5221: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
5222: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
5215: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
5216: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
5217: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
5218: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
5219: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
5220: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
5221: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
5222: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
5223: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
5216: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
5217: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
5218: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
5219: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
5220: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
5221: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
5222: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
5223: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
5224: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
5217: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
5218: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
5219: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
5220: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
5221: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
5222: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
5223: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
5224: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
5225: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
5218: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
5219: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
5220: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
5221: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
5222: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
5223: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
5224: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
5225: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
5226: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
5219: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
5220: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
5221: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
5222: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
5223: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
5224: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
5225: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
5226: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
5227: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
5220: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
5221: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
5222: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
5223: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
5224: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
5225: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
5226: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
5227: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
5228: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
5221: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
5222: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
5223: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
5224: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
5225: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
5226: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
5227: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
5228: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
5229: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
5222: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
5223: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
5224: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
5225: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
5226: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
5227: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
5228: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
5229: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
5230: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
5223: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
5224: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
5225: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
5226: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
5227: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
5228: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
5229: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
5230: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
5231: p_ASSIGN_TO_PERSON_ID => l_person_id,
5224: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
5225: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
5226: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
5227: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
5228: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
5229: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
5230: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
5231: p_ASSIGN_TO_PERSON_ID => l_person_id,
5232: p_ASSIGN_TO_SALESFORCE_ID => l_resource_id,
5225: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
5226: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
5227: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
5228: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
5229: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
5230: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
5231: p_ASSIGN_TO_PERSON_ID => l_person_id,
5232: p_ASSIGN_TO_SALESFORCE_ID => l_resource_id,
5233: p_ASSIGN_SALES_GROUP_ID => l_group_id,
5226: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
5227: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
5228: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
5229: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
5230: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
5231: p_ASSIGN_TO_PERSON_ID => l_person_id,
5232: p_ASSIGN_TO_SALESFORCE_ID => l_resource_id,
5233: p_ASSIGN_SALES_GROUP_ID => l_group_id,
5234: p_ASSIGN_DATE => SYSDATE,
5231: p_ASSIGN_TO_PERSON_ID => l_person_id,
5232: p_ASSIGN_TO_SALESFORCE_ID => l_resource_id,
5233: p_ASSIGN_SALES_GROUP_ID => l_group_id,
5234: p_ASSIGN_DATE => SYSDATE,
5235: p_BUDGET_STATUS_CODE => FND_API.G_MISS_CHAR,
5236: p_ACCEPT_FLAG => 'N',
5237: p_VEHICLE_RESPONSE_CODE => FND_API.G_MISS_CHAR,
5238: p_TOTAL_SCORE => FND_API.G_MISS_NUM,
5239: p_SCORECARD_ID => FND_API.G_MISS_NUM,
5233: p_ASSIGN_SALES_GROUP_ID => l_group_id,
5234: p_ASSIGN_DATE => SYSDATE,
5235: p_BUDGET_STATUS_CODE => FND_API.G_MISS_CHAR,
5236: p_ACCEPT_FLAG => 'N',
5237: p_VEHICLE_RESPONSE_CODE => FND_API.G_MISS_CHAR,
5238: p_TOTAL_SCORE => FND_API.G_MISS_NUM,
5239: p_SCORECARD_ID => FND_API.G_MISS_NUM,
5240: p_KEEP_FLAG => FND_API.G_MISS_CHAR,
5241: p_URGENT_FLAG => FND_API.G_MISS_CHAR,
5234: p_ASSIGN_DATE => SYSDATE,
5235: p_BUDGET_STATUS_CODE => FND_API.G_MISS_CHAR,
5236: p_ACCEPT_FLAG => 'N',
5237: p_VEHICLE_RESPONSE_CODE => FND_API.G_MISS_CHAR,
5238: p_TOTAL_SCORE => FND_API.G_MISS_NUM,
5239: p_SCORECARD_ID => FND_API.G_MISS_NUM,
5240: p_KEEP_FLAG => FND_API.G_MISS_CHAR,
5241: p_URGENT_FLAG => FND_API.G_MISS_CHAR,
5242: p_IMPORT_FLAG => FND_API.G_MISS_CHAR,
5235: p_BUDGET_STATUS_CODE => FND_API.G_MISS_CHAR,
5236: p_ACCEPT_FLAG => 'N',
5237: p_VEHICLE_RESPONSE_CODE => FND_API.G_MISS_CHAR,
5238: p_TOTAL_SCORE => FND_API.G_MISS_NUM,
5239: p_SCORECARD_ID => FND_API.G_MISS_NUM,
5240: p_KEEP_FLAG => FND_API.G_MISS_CHAR,
5241: p_URGENT_FLAG => FND_API.G_MISS_CHAR,
5242: p_IMPORT_FLAG => FND_API.G_MISS_CHAR,
5243: p_REJECT_REASON_CODE => NULL, --l_reject_reason_code,
5236: p_ACCEPT_FLAG => 'N',
5237: p_VEHICLE_RESPONSE_CODE => FND_API.G_MISS_CHAR,
5238: p_TOTAL_SCORE => FND_API.G_MISS_NUM,
5239: p_SCORECARD_ID => FND_API.G_MISS_NUM,
5240: p_KEEP_FLAG => FND_API.G_MISS_CHAR,
5241: p_URGENT_FLAG => FND_API.G_MISS_CHAR,
5242: p_IMPORT_FLAG => FND_API.G_MISS_CHAR,
5243: p_REJECT_REASON_CODE => NULL, --l_reject_reason_code,
5244: p_DELETED_FLAG => FND_API.G_MISS_CHAR,
5237: p_VEHICLE_RESPONSE_CODE => FND_API.G_MISS_CHAR,
5238: p_TOTAL_SCORE => FND_API.G_MISS_NUM,
5239: p_SCORECARD_ID => FND_API.G_MISS_NUM,
5240: p_KEEP_FLAG => FND_API.G_MISS_CHAR,
5241: p_URGENT_FLAG => FND_API.G_MISS_CHAR,
5242: p_IMPORT_FLAG => FND_API.G_MISS_CHAR,
5243: p_REJECT_REASON_CODE => NULL, --l_reject_reason_code,
5244: p_DELETED_FLAG => FND_API.G_MISS_CHAR,
5245: p_OFFER_ID => FND_API.G_MISS_NUM,
5238: p_TOTAL_SCORE => FND_API.G_MISS_NUM,
5239: p_SCORECARD_ID => FND_API.G_MISS_NUM,
5240: p_KEEP_FLAG => FND_API.G_MISS_CHAR,
5241: p_URGENT_FLAG => FND_API.G_MISS_CHAR,
5242: p_IMPORT_FLAG => FND_API.G_MISS_CHAR,
5243: p_REJECT_REASON_CODE => NULL, --l_reject_reason_code,
5244: p_DELETED_FLAG => FND_API.G_MISS_CHAR,
5245: p_OFFER_ID => FND_API.G_MISS_NUM,
5246: p_QUALIFIED_FLAG => l_qualified_flag,
5240: p_KEEP_FLAG => FND_API.G_MISS_CHAR,
5241: p_URGENT_FLAG => FND_API.G_MISS_CHAR,
5242: p_IMPORT_FLAG => FND_API.G_MISS_CHAR,
5243: p_REJECT_REASON_CODE => NULL, --l_reject_reason_code,
5244: p_DELETED_FLAG => FND_API.G_MISS_CHAR,
5245: p_OFFER_ID => FND_API.G_MISS_NUM,
5246: p_QUALIFIED_FLAG => l_qualified_flag,
5247: p_ORIG_SYSTEM_CODE => FND_API.G_MISS_CHAR,
5248: -- p_SECURITY_GROUP_ID => FND_API.G_MISS_NUM,
5241: p_URGENT_FLAG => FND_API.G_MISS_CHAR,
5242: p_IMPORT_FLAG => FND_API.G_MISS_CHAR,
5243: p_REJECT_REASON_CODE => NULL, --l_reject_reason_code,
5244: p_DELETED_FLAG => FND_API.G_MISS_CHAR,
5245: p_OFFER_ID => FND_API.G_MISS_NUM,
5246: p_QUALIFIED_FLAG => l_qualified_flag,
5247: p_ORIG_SYSTEM_CODE => FND_API.G_MISS_CHAR,
5248: -- p_SECURITY_GROUP_ID => FND_API.G_MISS_NUM,
5249: p_INC_PARTNER_PARTY_ID => FND_API.G_MISS_NUM,
5243: p_REJECT_REASON_CODE => NULL, --l_reject_reason_code,
5244: p_DELETED_FLAG => FND_API.G_MISS_CHAR,
5245: p_OFFER_ID => FND_API.G_MISS_NUM,
5246: p_QUALIFIED_FLAG => l_qualified_flag,
5247: p_ORIG_SYSTEM_CODE => FND_API.G_MISS_CHAR,
5248: -- p_SECURITY_GROUP_ID => FND_API.G_MISS_NUM,
5249: p_INC_PARTNER_PARTY_ID => FND_API.G_MISS_NUM,
5250: p_INC_PARTNER_RESOURCE_ID => FND_API.G_MISS_NUM,
5251: p_PRM_EXEC_SPONSOR_FLAG => FND_API.G_MISS_CHAR,
5244: p_DELETED_FLAG => FND_API.G_MISS_CHAR,
5245: p_OFFER_ID => FND_API.G_MISS_NUM,
5246: p_QUALIFIED_FLAG => l_qualified_flag,
5247: p_ORIG_SYSTEM_CODE => FND_API.G_MISS_CHAR,
5248: -- p_SECURITY_GROUP_ID => FND_API.G_MISS_NUM,
5249: p_INC_PARTNER_PARTY_ID => FND_API.G_MISS_NUM,
5250: p_INC_PARTNER_RESOURCE_ID => FND_API.G_MISS_NUM,
5251: p_PRM_EXEC_SPONSOR_FLAG => FND_API.G_MISS_CHAR,
5252: p_PRM_PRJ_LEAD_IN_PLACE_FLAG => FND_API.G_MISS_CHAR,
5245: p_OFFER_ID => FND_API.G_MISS_NUM,
5246: p_QUALIFIED_FLAG => l_qualified_flag,
5247: p_ORIG_SYSTEM_CODE => FND_API.G_MISS_CHAR,
5248: -- p_SECURITY_GROUP_ID => FND_API.G_MISS_NUM,
5249: p_INC_PARTNER_PARTY_ID => FND_API.G_MISS_NUM,
5250: p_INC_PARTNER_RESOURCE_ID => FND_API.G_MISS_NUM,
5251: p_PRM_EXEC_SPONSOR_FLAG => FND_API.G_MISS_CHAR,
5252: p_PRM_PRJ_LEAD_IN_PLACE_FLAG => FND_API.G_MISS_CHAR,
5253: p_PRM_SALES_LEAD_TYPE => FND_API.G_MISS_CHAR,
5246: p_QUALIFIED_FLAG => l_qualified_flag,
5247: p_ORIG_SYSTEM_CODE => FND_API.G_MISS_CHAR,
5248: -- p_SECURITY_GROUP_ID => FND_API.G_MISS_NUM,
5249: p_INC_PARTNER_PARTY_ID => FND_API.G_MISS_NUM,
5250: p_INC_PARTNER_RESOURCE_ID => FND_API.G_MISS_NUM,
5251: p_PRM_EXEC_SPONSOR_FLAG => FND_API.G_MISS_CHAR,
5252: p_PRM_PRJ_LEAD_IN_PLACE_FLAG => FND_API.G_MISS_CHAR,
5253: p_PRM_SALES_LEAD_TYPE => FND_API.G_MISS_CHAR,
5254: p_PRM_IND_CLASSIFICATION_CODE => FND_API.G_MISS_CHAR,
5247: p_ORIG_SYSTEM_CODE => FND_API.G_MISS_CHAR,
5248: -- p_SECURITY_GROUP_ID => FND_API.G_MISS_NUM,
5249: p_INC_PARTNER_PARTY_ID => FND_API.G_MISS_NUM,
5250: p_INC_PARTNER_RESOURCE_ID => FND_API.G_MISS_NUM,
5251: p_PRM_EXEC_SPONSOR_FLAG => FND_API.G_MISS_CHAR,
5252: p_PRM_PRJ_LEAD_IN_PLACE_FLAG => FND_API.G_MISS_CHAR,
5253: p_PRM_SALES_LEAD_TYPE => FND_API.G_MISS_CHAR,
5254: p_PRM_IND_CLASSIFICATION_CODE => FND_API.G_MISS_CHAR,
5255: p_PRM_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
5248: -- p_SECURITY_GROUP_ID => FND_API.G_MISS_NUM,
5249: p_INC_PARTNER_PARTY_ID => FND_API.G_MISS_NUM,
5250: p_INC_PARTNER_RESOURCE_ID => FND_API.G_MISS_NUM,
5251: p_PRM_EXEC_SPONSOR_FLAG => FND_API.G_MISS_CHAR,
5252: p_PRM_PRJ_LEAD_IN_PLACE_FLAG => FND_API.G_MISS_CHAR,
5253: p_PRM_SALES_LEAD_TYPE => FND_API.G_MISS_CHAR,
5254: p_PRM_IND_CLASSIFICATION_CODE => FND_API.G_MISS_CHAR,
5255: p_PRM_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
5256: p_AUTO_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
5249: p_INC_PARTNER_PARTY_ID => FND_API.G_MISS_NUM,
5250: p_INC_PARTNER_RESOURCE_ID => FND_API.G_MISS_NUM,
5251: p_PRM_EXEC_SPONSOR_FLAG => FND_API.G_MISS_CHAR,
5252: p_PRM_PRJ_LEAD_IN_PLACE_FLAG => FND_API.G_MISS_CHAR,
5253: p_PRM_SALES_LEAD_TYPE => FND_API.G_MISS_CHAR,
5254: p_PRM_IND_CLASSIFICATION_CODE => FND_API.G_MISS_CHAR,
5255: p_PRM_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
5256: p_AUTO_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
5257: p_PRIMARY_CONTACT_PARTY_ID => FND_API.G_MISS_NUM,
5250: p_INC_PARTNER_RESOURCE_ID => FND_API.G_MISS_NUM,
5251: p_PRM_EXEC_SPONSOR_FLAG => FND_API.G_MISS_CHAR,
5252: p_PRM_PRJ_LEAD_IN_PLACE_FLAG => FND_API.G_MISS_CHAR,
5253: p_PRM_SALES_LEAD_TYPE => FND_API.G_MISS_CHAR,
5254: p_PRM_IND_CLASSIFICATION_CODE => FND_API.G_MISS_CHAR,
5255: p_PRM_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
5256: p_AUTO_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
5257: p_PRIMARY_CONTACT_PARTY_ID => FND_API.G_MISS_NUM,
5258: p_PRIMARY_CNT_PERSON_PARTY_ID => FND_API.G_MISS_NUM,
5251: p_PRM_EXEC_SPONSOR_FLAG => FND_API.G_MISS_CHAR,
5252: p_PRM_PRJ_LEAD_IN_PLACE_FLAG => FND_API.G_MISS_CHAR,
5253: p_PRM_SALES_LEAD_TYPE => FND_API.G_MISS_CHAR,
5254: p_PRM_IND_CLASSIFICATION_CODE => FND_API.G_MISS_CHAR,
5255: p_PRM_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
5256: p_AUTO_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
5257: p_PRIMARY_CONTACT_PARTY_ID => FND_API.G_MISS_NUM,
5258: p_PRIMARY_CNT_PERSON_PARTY_ID => FND_API.G_MISS_NUM,
5259: p_PRIMARY_CONTACT_PHONE_ID => FND_API.G_MISS_NUM,
5252: p_PRM_PRJ_LEAD_IN_PLACE_FLAG => FND_API.G_MISS_CHAR,
5253: p_PRM_SALES_LEAD_TYPE => FND_API.G_MISS_CHAR,
5254: p_PRM_IND_CLASSIFICATION_CODE => FND_API.G_MISS_CHAR,
5255: p_PRM_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
5256: p_AUTO_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
5257: p_PRIMARY_CONTACT_PARTY_ID => FND_API.G_MISS_NUM,
5258: p_PRIMARY_CNT_PERSON_PARTY_ID => FND_API.G_MISS_NUM,
5259: p_PRIMARY_CONTACT_PHONE_ID => FND_API.G_MISS_NUM,
5260: p_REFERRED_BY => FND_API.G_MISS_NUM,
5253: p_PRM_SALES_LEAD_TYPE => FND_API.G_MISS_CHAR,
5254: p_PRM_IND_CLASSIFICATION_CODE => FND_API.G_MISS_CHAR,
5255: p_PRM_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
5256: p_AUTO_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
5257: p_PRIMARY_CONTACT_PARTY_ID => FND_API.G_MISS_NUM,
5258: p_PRIMARY_CNT_PERSON_PARTY_ID => FND_API.G_MISS_NUM,
5259: p_PRIMARY_CONTACT_PHONE_ID => FND_API.G_MISS_NUM,
5260: p_REFERRED_BY => FND_API.G_MISS_NUM,
5261: p_REFERRAL_TYPE => FND_API.G_MISS_CHAR,
5254: p_PRM_IND_CLASSIFICATION_CODE => FND_API.G_MISS_CHAR,
5255: p_PRM_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
5256: p_AUTO_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
5257: p_PRIMARY_CONTACT_PARTY_ID => FND_API.G_MISS_NUM,
5258: p_PRIMARY_CNT_PERSON_PARTY_ID => FND_API.G_MISS_NUM,
5259: p_PRIMARY_CONTACT_PHONE_ID => FND_API.G_MISS_NUM,
5260: p_REFERRED_BY => FND_API.G_MISS_NUM,
5261: p_REFERRAL_TYPE => FND_API.G_MISS_CHAR,
5262: p_REFERRAL_STATUS => FND_API.G_MISS_CHAR,
5255: p_PRM_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
5256: p_AUTO_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
5257: p_PRIMARY_CONTACT_PARTY_ID => FND_API.G_MISS_NUM,
5258: p_PRIMARY_CNT_PERSON_PARTY_ID => FND_API.G_MISS_NUM,
5259: p_PRIMARY_CONTACT_PHONE_ID => FND_API.G_MISS_NUM,
5260: p_REFERRED_BY => FND_API.G_MISS_NUM,
5261: p_REFERRAL_TYPE => FND_API.G_MISS_CHAR,
5262: p_REFERRAL_STATUS => FND_API.G_MISS_CHAR,
5263: p_REF_DECLINE_REASON => FND_API.G_MISS_CHAR,
5256: p_AUTO_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
5257: p_PRIMARY_CONTACT_PARTY_ID => FND_API.G_MISS_NUM,
5258: p_PRIMARY_CNT_PERSON_PARTY_ID => FND_API.G_MISS_NUM,
5259: p_PRIMARY_CONTACT_PHONE_ID => FND_API.G_MISS_NUM,
5260: p_REFERRED_BY => FND_API.G_MISS_NUM,
5261: p_REFERRAL_TYPE => FND_API.G_MISS_CHAR,
5262: p_REFERRAL_STATUS => FND_API.G_MISS_CHAR,
5263: p_REF_DECLINE_REASON => FND_API.G_MISS_CHAR,
5264: p_REF_COMM_LTR_STATUS => FND_API.G_MISS_CHAR,
5257: p_PRIMARY_CONTACT_PARTY_ID => FND_API.G_MISS_NUM,
5258: p_PRIMARY_CNT_PERSON_PARTY_ID => FND_API.G_MISS_NUM,
5259: p_PRIMARY_CONTACT_PHONE_ID => FND_API.G_MISS_NUM,
5260: p_REFERRED_BY => FND_API.G_MISS_NUM,
5261: p_REFERRAL_TYPE => FND_API.G_MISS_CHAR,
5262: p_REFERRAL_STATUS => FND_API.G_MISS_CHAR,
5263: p_REF_DECLINE_REASON => FND_API.G_MISS_CHAR,
5264: p_REF_COMM_LTR_STATUS => FND_API.G_MISS_CHAR,
5265: p_REF_ORDER_NUMBER => FND_API.G_MISS_NUM,
5258: p_PRIMARY_CNT_PERSON_PARTY_ID => FND_API.G_MISS_NUM,
5259: p_PRIMARY_CONTACT_PHONE_ID => FND_API.G_MISS_NUM,
5260: p_REFERRED_BY => FND_API.G_MISS_NUM,
5261: p_REFERRAL_TYPE => FND_API.G_MISS_CHAR,
5262: p_REFERRAL_STATUS => FND_API.G_MISS_CHAR,
5263: p_REF_DECLINE_REASON => FND_API.G_MISS_CHAR,
5264: p_REF_COMM_LTR_STATUS => FND_API.G_MISS_CHAR,
5265: p_REF_ORDER_NUMBER => FND_API.G_MISS_NUM,
5266: p_REF_ORDER_AMT => FND_API.G_MISS_NUM,
5259: p_PRIMARY_CONTACT_PHONE_ID => FND_API.G_MISS_NUM,
5260: p_REFERRED_BY => FND_API.G_MISS_NUM,
5261: p_REFERRAL_TYPE => FND_API.G_MISS_CHAR,
5262: p_REFERRAL_STATUS => FND_API.G_MISS_CHAR,
5263: p_REF_DECLINE_REASON => FND_API.G_MISS_CHAR,
5264: p_REF_COMM_LTR_STATUS => FND_API.G_MISS_CHAR,
5265: p_REF_ORDER_NUMBER => FND_API.G_MISS_NUM,
5266: p_REF_ORDER_AMT => FND_API.G_MISS_NUM,
5267: p_REF_COMM_AMT => FND_API.G_MISS_NUM,
5260: p_REFERRED_BY => FND_API.G_MISS_NUM,
5261: p_REFERRAL_TYPE => FND_API.G_MISS_CHAR,
5262: p_REFERRAL_STATUS => FND_API.G_MISS_CHAR,
5263: p_REF_DECLINE_REASON => FND_API.G_MISS_CHAR,
5264: p_REF_COMM_LTR_STATUS => FND_API.G_MISS_CHAR,
5265: p_REF_ORDER_NUMBER => FND_API.G_MISS_NUM,
5266: p_REF_ORDER_AMT => FND_API.G_MISS_NUM,
5267: p_REF_COMM_AMT => FND_API.G_MISS_NUM,
5268: -- bug No.2341515, 2368075
5261: p_REFERRAL_TYPE => FND_API.G_MISS_CHAR,
5262: p_REFERRAL_STATUS => FND_API.G_MISS_CHAR,
5263: p_REF_DECLINE_REASON => FND_API.G_MISS_CHAR,
5264: p_REF_COMM_LTR_STATUS => FND_API.G_MISS_CHAR,
5265: p_REF_ORDER_NUMBER => FND_API.G_MISS_NUM,
5266: p_REF_ORDER_AMT => FND_API.G_MISS_NUM,
5267: p_REF_COMM_AMT => FND_API.G_MISS_NUM,
5268: -- bug No.2341515, 2368075
5269: p_LEAD_DATE => FND_API.G_MISS_DATE,
5262: p_REFERRAL_STATUS => FND_API.G_MISS_CHAR,
5263: p_REF_DECLINE_REASON => FND_API.G_MISS_CHAR,
5264: p_REF_COMM_LTR_STATUS => FND_API.G_MISS_CHAR,
5265: p_REF_ORDER_NUMBER => FND_API.G_MISS_NUM,
5266: p_REF_ORDER_AMT => FND_API.G_MISS_NUM,
5267: p_REF_COMM_AMT => FND_API.G_MISS_NUM,
5268: -- bug No.2341515, 2368075
5269: p_LEAD_DATE => FND_API.G_MISS_DATE,
5270: p_SOURCE_SYSTEM => FND_API.G_MISS_CHAR,
5263: p_REF_DECLINE_REASON => FND_API.G_MISS_CHAR,
5264: p_REF_COMM_LTR_STATUS => FND_API.G_MISS_CHAR,
5265: p_REF_ORDER_NUMBER => FND_API.G_MISS_NUM,
5266: p_REF_ORDER_AMT => FND_API.G_MISS_NUM,
5267: p_REF_COMM_AMT => FND_API.G_MISS_NUM,
5268: -- bug No.2341515, 2368075
5269: p_LEAD_DATE => FND_API.G_MISS_DATE,
5270: p_SOURCE_SYSTEM => FND_API.G_MISS_CHAR,
5271: p_COUNTRY => FND_API.G_MISS_CHAR,
5265: p_REF_ORDER_NUMBER => FND_API.G_MISS_NUM,
5266: p_REF_ORDER_AMT => FND_API.G_MISS_NUM,
5267: p_REF_COMM_AMT => FND_API.G_MISS_NUM,
5268: -- bug No.2341515, 2368075
5269: p_LEAD_DATE => FND_API.G_MISS_DATE,
5270: p_SOURCE_SYSTEM => FND_API.G_MISS_CHAR,
5271: p_COUNTRY => FND_API.G_MISS_CHAR,
5272: p_TOTAL_AMOUNT => FND_API.G_MISS_NUM,
5273: p_EXPIRATION_DATE => FND_API.G_MISS_DATE,
5266: p_REF_ORDER_AMT => FND_API.G_MISS_NUM,
5267: p_REF_COMM_AMT => FND_API.G_MISS_NUM,
5268: -- bug No.2341515, 2368075
5269: p_LEAD_DATE => FND_API.G_MISS_DATE,
5270: p_SOURCE_SYSTEM => FND_API.G_MISS_CHAR,
5271: p_COUNTRY => FND_API.G_MISS_CHAR,
5272: p_TOTAL_AMOUNT => FND_API.G_MISS_NUM,
5273: p_EXPIRATION_DATE => FND_API.G_MISS_DATE,
5274: p_LEAD_RANK_IND => FND_API.G_MISS_CHAR,
5267: p_REF_COMM_AMT => FND_API.G_MISS_NUM,
5268: -- bug No.2341515, 2368075
5269: p_LEAD_DATE => FND_API.G_MISS_DATE,
5270: p_SOURCE_SYSTEM => FND_API.G_MISS_CHAR,
5271: p_COUNTRY => FND_API.G_MISS_CHAR,
5272: p_TOTAL_AMOUNT => FND_API.G_MISS_NUM,
5273: p_EXPIRATION_DATE => FND_API.G_MISS_DATE,
5274: p_LEAD_RANK_IND => FND_API.G_MISS_CHAR,
5275: p_LEAD_ENGINE_RUN_DATE => FND_API.G_MISS_DATE,
5268: -- bug No.2341515, 2368075
5269: p_LEAD_DATE => FND_API.G_MISS_DATE,
5270: p_SOURCE_SYSTEM => FND_API.G_MISS_CHAR,
5271: p_COUNTRY => FND_API.G_MISS_CHAR,
5272: p_TOTAL_AMOUNT => FND_API.G_MISS_NUM,
5273: p_EXPIRATION_DATE => FND_API.G_MISS_DATE,
5274: p_LEAD_RANK_IND => FND_API.G_MISS_CHAR,
5275: p_LEAD_ENGINE_RUN_DATE => FND_API.G_MISS_DATE,
5276: p_CURRENT_REROUTES => FND_API.G_MISS_NUM,
5269: p_LEAD_DATE => FND_API.G_MISS_DATE,
5270: p_SOURCE_SYSTEM => FND_API.G_MISS_CHAR,
5271: p_COUNTRY => FND_API.G_MISS_CHAR,
5272: p_TOTAL_AMOUNT => FND_API.G_MISS_NUM,
5273: p_EXPIRATION_DATE => FND_API.G_MISS_DATE,
5274: p_LEAD_RANK_IND => FND_API.G_MISS_CHAR,
5275: p_LEAD_ENGINE_RUN_DATE => FND_API.G_MISS_DATE,
5276: p_CURRENT_REROUTES => FND_API.G_MISS_NUM,
5277: p_STATUS_OPEN_FLAG => FND_API.G_MISS_CHAR,
5270: p_SOURCE_SYSTEM => FND_API.G_MISS_CHAR,
5271: p_COUNTRY => FND_API.G_MISS_CHAR,
5272: p_TOTAL_AMOUNT => FND_API.G_MISS_NUM,
5273: p_EXPIRATION_DATE => FND_API.G_MISS_DATE,
5274: p_LEAD_RANK_IND => FND_API.G_MISS_CHAR,
5275: p_LEAD_ENGINE_RUN_DATE => FND_API.G_MISS_DATE,
5276: p_CURRENT_REROUTES => FND_API.G_MISS_NUM,
5277: p_STATUS_OPEN_FLAG => FND_API.G_MISS_CHAR,
5278: p_LEAD_RANK_SCORE => FND_API.G_MISS_NUM,
5271: p_COUNTRY => FND_API.G_MISS_CHAR,
5272: p_TOTAL_AMOUNT => FND_API.G_MISS_NUM,
5273: p_EXPIRATION_DATE => FND_API.G_MISS_DATE,
5274: p_LEAD_RANK_IND => FND_API.G_MISS_CHAR,
5275: p_LEAD_ENGINE_RUN_DATE => FND_API.G_MISS_DATE,
5276: p_CURRENT_REROUTES => FND_API.G_MISS_NUM,
5277: p_STATUS_OPEN_FLAG => FND_API.G_MISS_CHAR,
5278: p_LEAD_RANK_SCORE => FND_API.G_MISS_NUM,
5279: -- 11.5.10 new columns
5272: p_TOTAL_AMOUNT => FND_API.G_MISS_NUM,
5273: p_EXPIRATION_DATE => FND_API.G_MISS_DATE,
5274: p_LEAD_RANK_IND => FND_API.G_MISS_CHAR,
5275: p_LEAD_ENGINE_RUN_DATE => FND_API.G_MISS_DATE,
5276: p_CURRENT_REROUTES => FND_API.G_MISS_NUM,
5277: p_STATUS_OPEN_FLAG => FND_API.G_MISS_CHAR,
5278: p_LEAD_RANK_SCORE => FND_API.G_MISS_NUM,
5279: -- 11.5.10 new columns
5280: p_MARKETING_SCORE => FND_API.G_MISS_NUM,
5273: p_EXPIRATION_DATE => FND_API.G_MISS_DATE,
5274: p_LEAD_RANK_IND => FND_API.G_MISS_CHAR,
5275: p_LEAD_ENGINE_RUN_DATE => FND_API.G_MISS_DATE,
5276: p_CURRENT_REROUTES => FND_API.G_MISS_NUM,
5277: p_STATUS_OPEN_FLAG => FND_API.G_MISS_CHAR,
5278: p_LEAD_RANK_SCORE => FND_API.G_MISS_NUM,
5279: -- 11.5.10 new columns
5280: p_MARKETING_SCORE => FND_API.G_MISS_NUM,
5281: p_INTERACTION_SCORE => FND_API.G_MISS_NUM,
5274: p_LEAD_RANK_IND => FND_API.G_MISS_CHAR,
5275: p_LEAD_ENGINE_RUN_DATE => FND_API.G_MISS_DATE,
5276: p_CURRENT_REROUTES => FND_API.G_MISS_NUM,
5277: p_STATUS_OPEN_FLAG => FND_API.G_MISS_CHAR,
5278: p_LEAD_RANK_SCORE => FND_API.G_MISS_NUM,
5279: -- 11.5.10 new columns
5280: p_MARKETING_SCORE => FND_API.G_MISS_NUM,
5281: p_INTERACTION_SCORE => FND_API.G_MISS_NUM,
5282: p_SOURCE_PRIMARY_REFERENCE => FND_API.G_MISS_CHAR,
5276: p_CURRENT_REROUTES => FND_API.G_MISS_NUM,
5277: p_STATUS_OPEN_FLAG => FND_API.G_MISS_CHAR,
5278: p_LEAD_RANK_SCORE => FND_API.G_MISS_NUM,
5279: -- 11.5.10 new columns
5280: p_MARKETING_SCORE => FND_API.G_MISS_NUM,
5281: p_INTERACTION_SCORE => FND_API.G_MISS_NUM,
5282: p_SOURCE_PRIMARY_REFERENCE => FND_API.G_MISS_CHAR,
5283: p_SOURCE_SECONDARY_REFERENCE => FND_API.G_MISS_CHAR,
5284: p_SALES_METHODOLOGY_ID => FND_API.G_MISS_NUM,
5277: p_STATUS_OPEN_FLAG => FND_API.G_MISS_CHAR,
5278: p_LEAD_RANK_SCORE => FND_API.G_MISS_NUM,
5279: -- 11.5.10 new columns
5280: p_MARKETING_SCORE => FND_API.G_MISS_NUM,
5281: p_INTERACTION_SCORE => FND_API.G_MISS_NUM,
5282: p_SOURCE_PRIMARY_REFERENCE => FND_API.G_MISS_CHAR,
5283: p_SOURCE_SECONDARY_REFERENCE => FND_API.G_MISS_CHAR,
5284: p_SALES_METHODOLOGY_ID => FND_API.G_MISS_NUM,
5285: p_SALES_STAGE_ID => FND_API.G_MISS_NUM);
5278: p_LEAD_RANK_SCORE => FND_API.G_MISS_NUM,
5279: -- 11.5.10 new columns
5280: p_MARKETING_SCORE => FND_API.G_MISS_NUM,
5281: p_INTERACTION_SCORE => FND_API.G_MISS_NUM,
5282: p_SOURCE_PRIMARY_REFERENCE => FND_API.G_MISS_CHAR,
5283: p_SOURCE_SECONDARY_REFERENCE => FND_API.G_MISS_CHAR,
5284: p_SALES_METHODOLOGY_ID => FND_API.G_MISS_NUM,
5285: p_SALES_STAGE_ID => FND_API.G_MISS_NUM);
5286:
5279: -- 11.5.10 new columns
5280: p_MARKETING_SCORE => FND_API.G_MISS_NUM,
5281: p_INTERACTION_SCORE => FND_API.G_MISS_NUM,
5282: p_SOURCE_PRIMARY_REFERENCE => FND_API.G_MISS_CHAR,
5283: p_SOURCE_SECONDARY_REFERENCE => FND_API.G_MISS_CHAR,
5284: p_SALES_METHODOLOGY_ID => FND_API.G_MISS_NUM,
5285: p_SALES_STAGE_ID => FND_API.G_MISS_NUM);
5286:
5287: l_access_exist_flag := 'N';
5280: p_MARKETING_SCORE => FND_API.G_MISS_NUM,
5281: p_INTERACTION_SCORE => FND_API.G_MISS_NUM,
5282: p_SOURCE_PRIMARY_REFERENCE => FND_API.G_MISS_CHAR,
5283: p_SOURCE_SECONDARY_REFERENCE => FND_API.G_MISS_CHAR,
5284: p_SALES_METHODOLOGY_ID => FND_API.G_MISS_NUM,
5285: p_SALES_STAGE_ID => FND_API.G_MISS_NUM);
5286:
5287: l_access_exist_flag := 'N';
5288: OPEN c_access_exist(p_sales_lead_id, l_resource_id, l_group_id);
5281: p_INTERACTION_SCORE => FND_API.G_MISS_NUM,
5282: p_SOURCE_PRIMARY_REFERENCE => FND_API.G_MISS_CHAR,
5283: p_SOURCE_SECONDARY_REFERENCE => FND_API.G_MISS_CHAR,
5284: p_SALES_METHODOLOGY_ID => FND_API.G_MISS_NUM,
5285: p_SALES_STAGE_ID => FND_API.G_MISS_NUM);
5286:
5287: l_access_exist_flag := 'N';
5288: OPEN c_access_exist(p_sales_lead_id, l_resource_id, l_group_id);
5289: FETCH c_access_exist INTO l_access_exist_flag;
5408: IF (AS_DEBUG_LOW_ON) THEN
5409: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5410: 'User''s resource id is:' || l_rs_id);
5411: END IF;
5412: IF p_salesgroup_id = fnd_api.g_miss_num
5413: THEN
5414: g_group_id_tbl(1) := NULL;
5415: OPEN c_get_group_id (l_rs_id);
5416: FETCH c_get_group_id INTO g_group_id_tbl(1);
5471: IF (AS_DEBUG_LOW_ON) THEN
5472: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5473: 'User''s resource id is:' || l_rs_id);
5474: END IF;
5475: IF p_salesgroup_id = fnd_api.g_miss_num
5476: THEN
5477: g_group_id_tbl(2) := NULL;
5478: OPEN c_get_group_id (l_rs_id);
5479: FETCH c_get_group_id INTO g_group_id_tbl(2);
5538: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5539: 'Get_Available_Resource: Start');
5540: END IF;
5541:
5542: x_return_status := FND_API.G_RET_STS_SUCCESS;
5543:
5544: -- Get sales team for the sales lead
5545: OPEN c_get_lead_resource(p_sales_lead_id);
5546: FETCH c_get_lead_resource BULK COLLECT INTO
5573: -- Check the calendar for resource availability
5574: -- Call Calendar API
5575: JTF_CALENDAR_PUB.GET_AVAILABLE_SLOT(
5576: P_API_VERSION => 1.0,
5577: P_INIT_MSG_LIST => FND_API.G_FALSE,
5578: P_RESOURCE_ID => l_resource_id_tbl(l_index1),
5579: P_RESOURCE_TYPE => 'RS_EMPLOYEE',
5580: P_START_DATE_TIME => SYSDATE-1,
5581: P_END_DATE_TIME => SYSDATE+1,
5587: X_SLOT_END_DATE => l_planned_end_date,
5588: X_SHIFT_CONSTRUCT_ID => l_shift_construct_id,
5589: X_AVAILABILITY_TYPE => l_availability_type);
5590:
5591: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
5592: RAISE fnd_api.g_exc_error;
5593: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5594: RAISE fnd_api.g_exc_unexpected_error;
5595: END IF;
5588: X_SHIFT_CONSTRUCT_ID => l_shift_construct_id,
5589: X_AVAILABILITY_TYPE => l_availability_type);
5590:
5591: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
5592: RAISE fnd_api.g_exc_error;
5593: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5594: RAISE fnd_api.g_exc_unexpected_error;
5595: END IF;
5596:
5589: X_AVAILABILITY_TYPE => l_availability_type);
5590:
5591: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
5592: RAISE fnd_api.g_exc_error;
5593: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5594: RAISE fnd_api.g_exc_unexpected_error;
5595: END IF;
5596:
5597: IF (AS_DEBUG_LOW_ON) THEN
5590:
5591: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
5592: RAISE fnd_api.g_exc_error;
5593: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5594: RAISE fnd_api.g_exc_unexpected_error;
5595: END IF;
5596:
5597: IF (AS_DEBUG_LOW_ON) THEN
5598: AS_UTILITY_PVT.Debug_Message(
5693: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5694: 'Get_Owner: Start');
5695: END IF;
5696:
5697: x_return_status := FND_API.G_RET_STS_SUCCESS;
5698: IF g_resource_id_tbl.count = 0
5699: THEN
5700: Get_Alternate_Resource(p_salesgroup_id);
5701: END IF;
5788: END IF;
5789:
5790: AS_LEAD_ROUTING_WF_CUHK.Get_Owner_Pre(
5791: p_api_version_number => 2.0,
5792: p_init_msg_list => FND_API.G_FALSE,
5793: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
5794: p_commit => FND_API.G_FALSE,
5795: p_resource_id_tbl => g_resource_id_tbl,
5796: p_group_id_tbl => g_group_id_tbl,
5789:
5790: AS_LEAD_ROUTING_WF_CUHK.Get_Owner_Pre(
5791: p_api_version_number => 2.0,
5792: p_init_msg_list => FND_API.G_FALSE,
5793: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
5794: p_commit => FND_API.G_FALSE,
5795: p_resource_id_tbl => g_resource_id_tbl,
5796: p_group_id_tbl => g_group_id_tbl,
5797: p_person_id_tbl => g_person_id_tbl,
5790: AS_LEAD_ROUTING_WF_CUHK.Get_Owner_Pre(
5791: p_api_version_number => 2.0,
5792: p_init_msg_list => FND_API.G_FALSE,
5793: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
5794: p_commit => FND_API.G_FALSE,
5795: p_resource_id_tbl => g_resource_id_tbl,
5796: p_group_id_tbl => g_group_id_tbl,
5797: p_person_id_tbl => g_person_id_tbl,
5798: p_resource_flag_tbl => g_resource_flag_tbl,
5803: x_return_status => x_return_status,
5804: x_msg_count => x_msg_count,
5805: x_msg_data => x_msg_data);
5806:
5807: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
5808: RAISE fnd_api.g_exc_error;
5809: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5810: RAISE fnd_api.g_exc_unexpected_error;
5811: END IF;
5804: x_msg_count => x_msg_count,
5805: x_msg_data => x_msg_data);
5806:
5807: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
5808: RAISE fnd_api.g_exc_error;
5809: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5810: RAISE fnd_api.g_exc_unexpected_error;
5811: END IF;
5812: END IF; -- call user hook
5805: x_msg_data => x_msg_data);
5806:
5807: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
5808: RAISE fnd_api.g_exc_error;
5809: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5810: RAISE fnd_api.g_exc_unexpected_error;
5811: END IF;
5812: END IF; -- call user hook
5813:
5806:
5807: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
5808: RAISE fnd_api.g_exc_error;
5809: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5810: RAISE fnd_api.g_exc_unexpected_error;
5811: END IF;
5812: END IF; -- call user hook
5813:
5814: IF (l_call_user_hook AND l_resource_id IS NULL) OR
5948: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5949: 'group id in upd='||p_group_id);
5950: END IF;
5951:
5952: x_return_status := FND_API.G_RET_STS_SUCCESS;
5953: OPEN c_sales_lead(p_sales_lead_id);
5954: FETCH c_sales_lead INTO l_customer_id, l_address_id,
5955: l_reject_reason_code, l_lead_rank_id,
5956: l_qualified_flag, l_status_code;
5985: AS_SALES_LEADS_PKG.Sales_Lead_Update_Row(
5986: p_SALES_LEAD_ID => p_SALES_LEAD_ID,
5987: p_LAST_UPDATE_DATE => SYSDATE,
5988: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
5989: p_CREATION_DATE => FND_API.G_MISS_DATE,
5990: p_CREATED_BY => FND_API.G_MISS_NUM,
5991: p_LAST_UPDATE_LOGIN => FND_API.G_MISS_NUM,
5992: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,
5993: p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id,
5986: p_SALES_LEAD_ID => p_SALES_LEAD_ID,
5987: p_LAST_UPDATE_DATE => SYSDATE,
5988: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
5989: p_CREATION_DATE => FND_API.G_MISS_DATE,
5990: p_CREATED_BY => FND_API.G_MISS_NUM,
5991: p_LAST_UPDATE_LOGIN => FND_API.G_MISS_NUM,
5992: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,
5993: p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id,
5994: p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id,
5987: p_LAST_UPDATE_DATE => SYSDATE,
5988: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
5989: p_CREATION_DATE => FND_API.G_MISS_DATE,
5990: p_CREATED_BY => FND_API.G_MISS_NUM,
5991: p_LAST_UPDATE_LOGIN => FND_API.G_MISS_NUM,
5992: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,
5993: p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id,
5994: p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id,
5995: p_PROGRAM_UPDATE_DATE => SYSDATE,
5992: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,
5993: p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id,
5994: p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id,
5995: p_PROGRAM_UPDATE_DATE => SYSDATE,
5996: p_LEAD_NUMBER => FND_API.G_MISS_CHAR,
5997: p_STATUS_CODE => FND_API.G_MISS_CHAR, --l_routing_status,
5998: p_CUSTOMER_ID => l_CUSTOMER_ID,
5999: p_ADDRESS_ID => l_ADDRESS_ID,
6000: p_SOURCE_PROMOTION_ID => FND_API.G_MISS_NUM,
5993: p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id,
5994: p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id,
5995: p_PROGRAM_UPDATE_DATE => SYSDATE,
5996: p_LEAD_NUMBER => FND_API.G_MISS_CHAR,
5997: p_STATUS_CODE => FND_API.G_MISS_CHAR, --l_routing_status,
5998: p_CUSTOMER_ID => l_CUSTOMER_ID,
5999: p_ADDRESS_ID => l_ADDRESS_ID,
6000: p_SOURCE_PROMOTION_ID => FND_API.G_MISS_NUM,
6001: p_INITIATING_CONTACT_ID => FND_API.G_MISS_NUM,
5996: p_LEAD_NUMBER => FND_API.G_MISS_CHAR,
5997: p_STATUS_CODE => FND_API.G_MISS_CHAR, --l_routing_status,
5998: p_CUSTOMER_ID => l_CUSTOMER_ID,
5999: p_ADDRESS_ID => l_ADDRESS_ID,
6000: p_SOURCE_PROMOTION_ID => FND_API.G_MISS_NUM,
6001: p_INITIATING_CONTACT_ID => FND_API.G_MISS_NUM,
6002: p_ORIG_SYSTEM_REFERENCE => FND_API.G_MISS_CHAR,
6003: p_CONTACT_ROLE_CODE => FND_API.G_MISS_CHAR,
6004: p_CHANNEL_CODE => FND_API.G_MISS_CHAR,
5997: p_STATUS_CODE => FND_API.G_MISS_CHAR, --l_routing_status,
5998: p_CUSTOMER_ID => l_CUSTOMER_ID,
5999: p_ADDRESS_ID => l_ADDRESS_ID,
6000: p_SOURCE_PROMOTION_ID => FND_API.G_MISS_NUM,
6001: p_INITIATING_CONTACT_ID => FND_API.G_MISS_NUM,
6002: p_ORIG_SYSTEM_REFERENCE => FND_API.G_MISS_CHAR,
6003: p_CONTACT_ROLE_CODE => FND_API.G_MISS_CHAR,
6004: p_CHANNEL_CODE => FND_API.G_MISS_CHAR,
6005: p_BUDGET_AMOUNT => FND_API.G_MISS_NUM,
5998: p_CUSTOMER_ID => l_CUSTOMER_ID,
5999: p_ADDRESS_ID => l_ADDRESS_ID,
6000: p_SOURCE_PROMOTION_ID => FND_API.G_MISS_NUM,
6001: p_INITIATING_CONTACT_ID => FND_API.G_MISS_NUM,
6002: p_ORIG_SYSTEM_REFERENCE => FND_API.G_MISS_CHAR,
6003: p_CONTACT_ROLE_CODE => FND_API.G_MISS_CHAR,
6004: p_CHANNEL_CODE => FND_API.G_MISS_CHAR,
6005: p_BUDGET_AMOUNT => FND_API.G_MISS_NUM,
6006: p_CURRENCY_CODE => FND_API.G_MISS_CHAR,
5999: p_ADDRESS_ID => l_ADDRESS_ID,
6000: p_SOURCE_PROMOTION_ID => FND_API.G_MISS_NUM,
6001: p_INITIATING_CONTACT_ID => FND_API.G_MISS_NUM,
6002: p_ORIG_SYSTEM_REFERENCE => FND_API.G_MISS_CHAR,
6003: p_CONTACT_ROLE_CODE => FND_API.G_MISS_CHAR,
6004: p_CHANNEL_CODE => FND_API.G_MISS_CHAR,
6005: p_BUDGET_AMOUNT => FND_API.G_MISS_NUM,
6006: p_CURRENCY_CODE => FND_API.G_MISS_CHAR,
6007: p_DECISION_TIMEFRAME_CODE => FND_API.G_MISS_CHAR,
6000: p_SOURCE_PROMOTION_ID => FND_API.G_MISS_NUM,
6001: p_INITIATING_CONTACT_ID => FND_API.G_MISS_NUM,
6002: p_ORIG_SYSTEM_REFERENCE => FND_API.G_MISS_CHAR,
6003: p_CONTACT_ROLE_CODE => FND_API.G_MISS_CHAR,
6004: p_CHANNEL_CODE => FND_API.G_MISS_CHAR,
6005: p_BUDGET_AMOUNT => FND_API.G_MISS_NUM,
6006: p_CURRENCY_CODE => FND_API.G_MISS_CHAR,
6007: p_DECISION_TIMEFRAME_CODE => FND_API.G_MISS_CHAR,
6008: p_CLOSE_REASON => FND_API.G_MISS_CHAR,
6001: p_INITIATING_CONTACT_ID => FND_API.G_MISS_NUM,
6002: p_ORIG_SYSTEM_REFERENCE => FND_API.G_MISS_CHAR,
6003: p_CONTACT_ROLE_CODE => FND_API.G_MISS_CHAR,
6004: p_CHANNEL_CODE => FND_API.G_MISS_CHAR,
6005: p_BUDGET_AMOUNT => FND_API.G_MISS_NUM,
6006: p_CURRENCY_CODE => FND_API.G_MISS_CHAR,
6007: p_DECISION_TIMEFRAME_CODE => FND_API.G_MISS_CHAR,
6008: p_CLOSE_REASON => FND_API.G_MISS_CHAR,
6009: p_LEAD_RANK_ID => FND_API.G_MISS_NUM,
6002: p_ORIG_SYSTEM_REFERENCE => FND_API.G_MISS_CHAR,
6003: p_CONTACT_ROLE_CODE => FND_API.G_MISS_CHAR,
6004: p_CHANNEL_CODE => FND_API.G_MISS_CHAR,
6005: p_BUDGET_AMOUNT => FND_API.G_MISS_NUM,
6006: p_CURRENCY_CODE => FND_API.G_MISS_CHAR,
6007: p_DECISION_TIMEFRAME_CODE => FND_API.G_MISS_CHAR,
6008: p_CLOSE_REASON => FND_API.G_MISS_CHAR,
6009: p_LEAD_RANK_ID => FND_API.G_MISS_NUM,
6010: p_LEAD_RANK_CODE => FND_API.G_MISS_CHAR,
6003: p_CONTACT_ROLE_CODE => FND_API.G_MISS_CHAR,
6004: p_CHANNEL_CODE => FND_API.G_MISS_CHAR,
6005: p_BUDGET_AMOUNT => FND_API.G_MISS_NUM,
6006: p_CURRENCY_CODE => FND_API.G_MISS_CHAR,
6007: p_DECISION_TIMEFRAME_CODE => FND_API.G_MISS_CHAR,
6008: p_CLOSE_REASON => FND_API.G_MISS_CHAR,
6009: p_LEAD_RANK_ID => FND_API.G_MISS_NUM,
6010: p_LEAD_RANK_CODE => FND_API.G_MISS_CHAR,
6011: p_PARENT_PROJECT => FND_API.G_MISS_CHAR,
6004: p_CHANNEL_CODE => FND_API.G_MISS_CHAR,
6005: p_BUDGET_AMOUNT => FND_API.G_MISS_NUM,
6006: p_CURRENCY_CODE => FND_API.G_MISS_CHAR,
6007: p_DECISION_TIMEFRAME_CODE => FND_API.G_MISS_CHAR,
6008: p_CLOSE_REASON => FND_API.G_MISS_CHAR,
6009: p_LEAD_RANK_ID => FND_API.G_MISS_NUM,
6010: p_LEAD_RANK_CODE => FND_API.G_MISS_CHAR,
6011: p_PARENT_PROJECT => FND_API.G_MISS_CHAR,
6012: p_DESCRIPTION => FND_API.G_MISS_CHAR,
6005: p_BUDGET_AMOUNT => FND_API.G_MISS_NUM,
6006: p_CURRENCY_CODE => FND_API.G_MISS_CHAR,
6007: p_DECISION_TIMEFRAME_CODE => FND_API.G_MISS_CHAR,
6008: p_CLOSE_REASON => FND_API.G_MISS_CHAR,
6009: p_LEAD_RANK_ID => FND_API.G_MISS_NUM,
6010: p_LEAD_RANK_CODE => FND_API.G_MISS_CHAR,
6011: p_PARENT_PROJECT => FND_API.G_MISS_CHAR,
6012: p_DESCRIPTION => FND_API.G_MISS_CHAR,
6013: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
6006: p_CURRENCY_CODE => FND_API.G_MISS_CHAR,
6007: p_DECISION_TIMEFRAME_CODE => FND_API.G_MISS_CHAR,
6008: p_CLOSE_REASON => FND_API.G_MISS_CHAR,
6009: p_LEAD_RANK_ID => FND_API.G_MISS_NUM,
6010: p_LEAD_RANK_CODE => FND_API.G_MISS_CHAR,
6011: p_PARENT_PROJECT => FND_API.G_MISS_CHAR,
6012: p_DESCRIPTION => FND_API.G_MISS_CHAR,
6013: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
6014: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
6007: p_DECISION_TIMEFRAME_CODE => FND_API.G_MISS_CHAR,
6008: p_CLOSE_REASON => FND_API.G_MISS_CHAR,
6009: p_LEAD_RANK_ID => FND_API.G_MISS_NUM,
6010: p_LEAD_RANK_CODE => FND_API.G_MISS_CHAR,
6011: p_PARENT_PROJECT => FND_API.G_MISS_CHAR,
6012: p_DESCRIPTION => FND_API.G_MISS_CHAR,
6013: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
6014: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
6015: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
6008: p_CLOSE_REASON => FND_API.G_MISS_CHAR,
6009: p_LEAD_RANK_ID => FND_API.G_MISS_NUM,
6010: p_LEAD_RANK_CODE => FND_API.G_MISS_CHAR,
6011: p_PARENT_PROJECT => FND_API.G_MISS_CHAR,
6012: p_DESCRIPTION => FND_API.G_MISS_CHAR,
6013: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
6014: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
6015: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
6016: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
6009: p_LEAD_RANK_ID => FND_API.G_MISS_NUM,
6010: p_LEAD_RANK_CODE => FND_API.G_MISS_CHAR,
6011: p_PARENT_PROJECT => FND_API.G_MISS_CHAR,
6012: p_DESCRIPTION => FND_API.G_MISS_CHAR,
6013: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
6014: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
6015: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
6016: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
6017: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
6010: p_LEAD_RANK_CODE => FND_API.G_MISS_CHAR,
6011: p_PARENT_PROJECT => FND_API.G_MISS_CHAR,
6012: p_DESCRIPTION => FND_API.G_MISS_CHAR,
6013: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
6014: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
6015: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
6016: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
6017: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
6018: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
6011: p_PARENT_PROJECT => FND_API.G_MISS_CHAR,
6012: p_DESCRIPTION => FND_API.G_MISS_CHAR,
6013: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
6014: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
6015: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
6016: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
6017: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
6018: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
6019: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
6012: p_DESCRIPTION => FND_API.G_MISS_CHAR,
6013: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
6014: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
6015: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
6016: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
6017: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
6018: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
6019: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
6020: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
6013: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
6014: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
6015: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
6016: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
6017: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
6018: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
6019: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
6020: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
6021: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
6014: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
6015: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
6016: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
6017: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
6018: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
6019: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
6020: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
6021: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
6022: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
6015: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
6016: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
6017: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
6018: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
6019: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
6020: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
6021: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
6022: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
6023: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
6016: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
6017: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
6018: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
6019: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
6020: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
6021: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
6022: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
6023: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
6024: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
6017: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
6018: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
6019: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
6020: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
6021: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
6022: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
6023: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
6024: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
6025: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
6018: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
6019: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
6020: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
6021: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
6022: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
6023: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
6024: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
6025: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
6026: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
6019: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
6020: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
6021: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
6022: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
6023: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
6024: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
6025: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
6026: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
6027: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
6020: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
6021: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
6022: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
6023: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
6024: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
6025: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
6026: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
6027: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
6028: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
6021: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
6022: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
6023: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
6024: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
6025: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
6026: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
6027: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
6028: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
6029: p_ASSIGN_TO_PERSON_ID => p_person_id,
6022: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
6023: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
6024: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
6025: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
6026: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
6027: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
6028: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
6029: p_ASSIGN_TO_PERSON_ID => p_person_id,
6030: p_ASSIGN_TO_SALESFORCE_ID => p_resource_id,
6023: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
6024: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
6025: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
6026: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
6027: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
6028: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
6029: p_ASSIGN_TO_PERSON_ID => p_person_id,
6030: p_ASSIGN_TO_SALESFORCE_ID => p_resource_id,
6031: p_ASSIGN_SALES_GROUP_ID => p_group_id,
6024: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
6025: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
6026: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
6027: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
6028: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
6029: p_ASSIGN_TO_PERSON_ID => p_person_id,
6030: p_ASSIGN_TO_SALESFORCE_ID => p_resource_id,
6031: p_ASSIGN_SALES_GROUP_ID => p_group_id,
6032: p_ASSIGN_DATE => SYSDATE,
6029: p_ASSIGN_TO_PERSON_ID => p_person_id,
6030: p_ASSIGN_TO_SALESFORCE_ID => p_resource_id,
6031: p_ASSIGN_SALES_GROUP_ID => p_group_id,
6032: p_ASSIGN_DATE => SYSDATE,
6033: p_BUDGET_STATUS_CODE => FND_API.G_MISS_CHAR,
6034: p_ACCEPT_FLAG => 'N',
6035: p_VEHICLE_RESPONSE_CODE => FND_API.G_MISS_CHAR,
6036: p_TOTAL_SCORE => FND_API.G_MISS_NUM,
6037: p_SCORECARD_ID => FND_API.G_MISS_NUM,
6031: p_ASSIGN_SALES_GROUP_ID => p_group_id,
6032: p_ASSIGN_DATE => SYSDATE,
6033: p_BUDGET_STATUS_CODE => FND_API.G_MISS_CHAR,
6034: p_ACCEPT_FLAG => 'N',
6035: p_VEHICLE_RESPONSE_CODE => FND_API.G_MISS_CHAR,
6036: p_TOTAL_SCORE => FND_API.G_MISS_NUM,
6037: p_SCORECARD_ID => FND_API.G_MISS_NUM,
6038: p_KEEP_FLAG => FND_API.G_MISS_CHAR,
6039: p_URGENT_FLAG => FND_API.G_MISS_CHAR,
6032: p_ASSIGN_DATE => SYSDATE,
6033: p_BUDGET_STATUS_CODE => FND_API.G_MISS_CHAR,
6034: p_ACCEPT_FLAG => 'N',
6035: p_VEHICLE_RESPONSE_CODE => FND_API.G_MISS_CHAR,
6036: p_TOTAL_SCORE => FND_API.G_MISS_NUM,
6037: p_SCORECARD_ID => FND_API.G_MISS_NUM,
6038: p_KEEP_FLAG => FND_API.G_MISS_CHAR,
6039: p_URGENT_FLAG => FND_API.G_MISS_CHAR,
6040: p_IMPORT_FLAG => FND_API.G_MISS_CHAR,
6033: p_BUDGET_STATUS_CODE => FND_API.G_MISS_CHAR,
6034: p_ACCEPT_FLAG => 'N',
6035: p_VEHICLE_RESPONSE_CODE => FND_API.G_MISS_CHAR,
6036: p_TOTAL_SCORE => FND_API.G_MISS_NUM,
6037: p_SCORECARD_ID => FND_API.G_MISS_NUM,
6038: p_KEEP_FLAG => FND_API.G_MISS_CHAR,
6039: p_URGENT_FLAG => FND_API.G_MISS_CHAR,
6040: p_IMPORT_FLAG => FND_API.G_MISS_CHAR,
6041: p_REJECT_REASON_CODE => NULL, --l_reject_reason_code,
6034: p_ACCEPT_FLAG => 'N',
6035: p_VEHICLE_RESPONSE_CODE => FND_API.G_MISS_CHAR,
6036: p_TOTAL_SCORE => FND_API.G_MISS_NUM,
6037: p_SCORECARD_ID => FND_API.G_MISS_NUM,
6038: p_KEEP_FLAG => FND_API.G_MISS_CHAR,
6039: p_URGENT_FLAG => FND_API.G_MISS_CHAR,
6040: p_IMPORT_FLAG => FND_API.G_MISS_CHAR,
6041: p_REJECT_REASON_CODE => NULL, --l_reject_reason_code,
6042: p_DELETED_FLAG => FND_API.G_MISS_CHAR,
6035: p_VEHICLE_RESPONSE_CODE => FND_API.G_MISS_CHAR,
6036: p_TOTAL_SCORE => FND_API.G_MISS_NUM,
6037: p_SCORECARD_ID => FND_API.G_MISS_NUM,
6038: p_KEEP_FLAG => FND_API.G_MISS_CHAR,
6039: p_URGENT_FLAG => FND_API.G_MISS_CHAR,
6040: p_IMPORT_FLAG => FND_API.G_MISS_CHAR,
6041: p_REJECT_REASON_CODE => NULL, --l_reject_reason_code,
6042: p_DELETED_FLAG => FND_API.G_MISS_CHAR,
6043: p_OFFER_ID => FND_API.G_MISS_NUM,
6036: p_TOTAL_SCORE => FND_API.G_MISS_NUM,
6037: p_SCORECARD_ID => FND_API.G_MISS_NUM,
6038: p_KEEP_FLAG => FND_API.G_MISS_CHAR,
6039: p_URGENT_FLAG => FND_API.G_MISS_CHAR,
6040: p_IMPORT_FLAG => FND_API.G_MISS_CHAR,
6041: p_REJECT_REASON_CODE => NULL, --l_reject_reason_code,
6042: p_DELETED_FLAG => FND_API.G_MISS_CHAR,
6043: p_OFFER_ID => FND_API.G_MISS_NUM,
6044: p_QUALIFIED_FLAG => l_qualified_flag,
6038: p_KEEP_FLAG => FND_API.G_MISS_CHAR,
6039: p_URGENT_FLAG => FND_API.G_MISS_CHAR,
6040: p_IMPORT_FLAG => FND_API.G_MISS_CHAR,
6041: p_REJECT_REASON_CODE => NULL, --l_reject_reason_code,
6042: p_DELETED_FLAG => FND_API.G_MISS_CHAR,
6043: p_OFFER_ID => FND_API.G_MISS_NUM,
6044: p_QUALIFIED_FLAG => l_qualified_flag,
6045: p_ORIG_SYSTEM_CODE => FND_API.G_MISS_CHAR,
6046: p_INC_PARTNER_PARTY_ID => FND_API.G_MISS_NUM,
6039: p_URGENT_FLAG => FND_API.G_MISS_CHAR,
6040: p_IMPORT_FLAG => FND_API.G_MISS_CHAR,
6041: p_REJECT_REASON_CODE => NULL, --l_reject_reason_code,
6042: p_DELETED_FLAG => FND_API.G_MISS_CHAR,
6043: p_OFFER_ID => FND_API.G_MISS_NUM,
6044: p_QUALIFIED_FLAG => l_qualified_flag,
6045: p_ORIG_SYSTEM_CODE => FND_API.G_MISS_CHAR,
6046: p_INC_PARTNER_PARTY_ID => FND_API.G_MISS_NUM,
6047: p_INC_PARTNER_RESOURCE_ID => FND_API.G_MISS_NUM,
6041: p_REJECT_REASON_CODE => NULL, --l_reject_reason_code,
6042: p_DELETED_FLAG => FND_API.G_MISS_CHAR,
6043: p_OFFER_ID => FND_API.G_MISS_NUM,
6044: p_QUALIFIED_FLAG => l_qualified_flag,
6045: p_ORIG_SYSTEM_CODE => FND_API.G_MISS_CHAR,
6046: p_INC_PARTNER_PARTY_ID => FND_API.G_MISS_NUM,
6047: p_INC_PARTNER_RESOURCE_ID => FND_API.G_MISS_NUM,
6048: p_PRM_EXEC_SPONSOR_FLAG => FND_API.G_MISS_CHAR,
6049: p_PRM_PRJ_LEAD_IN_PLACE_FLAG => FND_API.G_MISS_CHAR,
6042: p_DELETED_FLAG => FND_API.G_MISS_CHAR,
6043: p_OFFER_ID => FND_API.G_MISS_NUM,
6044: p_QUALIFIED_FLAG => l_qualified_flag,
6045: p_ORIG_SYSTEM_CODE => FND_API.G_MISS_CHAR,
6046: p_INC_PARTNER_PARTY_ID => FND_API.G_MISS_NUM,
6047: p_INC_PARTNER_RESOURCE_ID => FND_API.G_MISS_NUM,
6048: p_PRM_EXEC_SPONSOR_FLAG => FND_API.G_MISS_CHAR,
6049: p_PRM_PRJ_LEAD_IN_PLACE_FLAG => FND_API.G_MISS_CHAR,
6050: p_PRM_SALES_LEAD_TYPE => FND_API.G_MISS_CHAR,
6043: p_OFFER_ID => FND_API.G_MISS_NUM,
6044: p_QUALIFIED_FLAG => l_qualified_flag,
6045: p_ORIG_SYSTEM_CODE => FND_API.G_MISS_CHAR,
6046: p_INC_PARTNER_PARTY_ID => FND_API.G_MISS_NUM,
6047: p_INC_PARTNER_RESOURCE_ID => FND_API.G_MISS_NUM,
6048: p_PRM_EXEC_SPONSOR_FLAG => FND_API.G_MISS_CHAR,
6049: p_PRM_PRJ_LEAD_IN_PLACE_FLAG => FND_API.G_MISS_CHAR,
6050: p_PRM_SALES_LEAD_TYPE => FND_API.G_MISS_CHAR,
6051: p_PRM_IND_CLASSIFICATION_CODE => FND_API.G_MISS_CHAR,
6044: p_QUALIFIED_FLAG => l_qualified_flag,
6045: p_ORIG_SYSTEM_CODE => FND_API.G_MISS_CHAR,
6046: p_INC_PARTNER_PARTY_ID => FND_API.G_MISS_NUM,
6047: p_INC_PARTNER_RESOURCE_ID => FND_API.G_MISS_NUM,
6048: p_PRM_EXEC_SPONSOR_FLAG => FND_API.G_MISS_CHAR,
6049: p_PRM_PRJ_LEAD_IN_PLACE_FLAG => FND_API.G_MISS_CHAR,
6050: p_PRM_SALES_LEAD_TYPE => FND_API.G_MISS_CHAR,
6051: p_PRM_IND_CLASSIFICATION_CODE => FND_API.G_MISS_CHAR,
6052: p_PRM_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
6045: p_ORIG_SYSTEM_CODE => FND_API.G_MISS_CHAR,
6046: p_INC_PARTNER_PARTY_ID => FND_API.G_MISS_NUM,
6047: p_INC_PARTNER_RESOURCE_ID => FND_API.G_MISS_NUM,
6048: p_PRM_EXEC_SPONSOR_FLAG => FND_API.G_MISS_CHAR,
6049: p_PRM_PRJ_LEAD_IN_PLACE_FLAG => FND_API.G_MISS_CHAR,
6050: p_PRM_SALES_LEAD_TYPE => FND_API.G_MISS_CHAR,
6051: p_PRM_IND_CLASSIFICATION_CODE => FND_API.G_MISS_CHAR,
6052: p_PRM_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
6053: p_AUTO_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
6046: p_INC_PARTNER_PARTY_ID => FND_API.G_MISS_NUM,
6047: p_INC_PARTNER_RESOURCE_ID => FND_API.G_MISS_NUM,
6048: p_PRM_EXEC_SPONSOR_FLAG => FND_API.G_MISS_CHAR,
6049: p_PRM_PRJ_LEAD_IN_PLACE_FLAG => FND_API.G_MISS_CHAR,
6050: p_PRM_SALES_LEAD_TYPE => FND_API.G_MISS_CHAR,
6051: p_PRM_IND_CLASSIFICATION_CODE => FND_API.G_MISS_CHAR,
6052: p_PRM_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
6053: p_AUTO_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
6054: p_PRIMARY_CONTACT_PARTY_ID => FND_API.G_MISS_NUM,
6047: p_INC_PARTNER_RESOURCE_ID => FND_API.G_MISS_NUM,
6048: p_PRM_EXEC_SPONSOR_FLAG => FND_API.G_MISS_CHAR,
6049: p_PRM_PRJ_LEAD_IN_PLACE_FLAG => FND_API.G_MISS_CHAR,
6050: p_PRM_SALES_LEAD_TYPE => FND_API.G_MISS_CHAR,
6051: p_PRM_IND_CLASSIFICATION_CODE => FND_API.G_MISS_CHAR,
6052: p_PRM_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
6053: p_AUTO_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
6054: p_PRIMARY_CONTACT_PARTY_ID => FND_API.G_MISS_NUM,
6055: p_PRIMARY_CNT_PERSON_PARTY_ID => FND_API.G_MISS_NUM,
6048: p_PRM_EXEC_SPONSOR_FLAG => FND_API.G_MISS_CHAR,
6049: p_PRM_PRJ_LEAD_IN_PLACE_FLAG => FND_API.G_MISS_CHAR,
6050: p_PRM_SALES_LEAD_TYPE => FND_API.G_MISS_CHAR,
6051: p_PRM_IND_CLASSIFICATION_CODE => FND_API.G_MISS_CHAR,
6052: p_PRM_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
6053: p_AUTO_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
6054: p_PRIMARY_CONTACT_PARTY_ID => FND_API.G_MISS_NUM,
6055: p_PRIMARY_CNT_PERSON_PARTY_ID => FND_API.G_MISS_NUM,
6056: p_PRIMARY_CONTACT_PHONE_ID => FND_API.G_MISS_NUM,
6049: p_PRM_PRJ_LEAD_IN_PLACE_FLAG => FND_API.G_MISS_CHAR,
6050: p_PRM_SALES_LEAD_TYPE => FND_API.G_MISS_CHAR,
6051: p_PRM_IND_CLASSIFICATION_CODE => FND_API.G_MISS_CHAR,
6052: p_PRM_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
6053: p_AUTO_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
6054: p_PRIMARY_CONTACT_PARTY_ID => FND_API.G_MISS_NUM,
6055: p_PRIMARY_CNT_PERSON_PARTY_ID => FND_API.G_MISS_NUM,
6056: p_PRIMARY_CONTACT_PHONE_ID => FND_API.G_MISS_NUM,
6057: p_REFERRED_BY => FND_API.G_MISS_NUM,
6050: p_PRM_SALES_LEAD_TYPE => FND_API.G_MISS_CHAR,
6051: p_PRM_IND_CLASSIFICATION_CODE => FND_API.G_MISS_CHAR,
6052: p_PRM_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
6053: p_AUTO_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
6054: p_PRIMARY_CONTACT_PARTY_ID => FND_API.G_MISS_NUM,
6055: p_PRIMARY_CNT_PERSON_PARTY_ID => FND_API.G_MISS_NUM,
6056: p_PRIMARY_CONTACT_PHONE_ID => FND_API.G_MISS_NUM,
6057: p_REFERRED_BY => FND_API.G_MISS_NUM,
6058: p_REFERRAL_TYPE => FND_API.G_MISS_CHAR,
6051: p_PRM_IND_CLASSIFICATION_CODE => FND_API.G_MISS_CHAR,
6052: p_PRM_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
6053: p_AUTO_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
6054: p_PRIMARY_CONTACT_PARTY_ID => FND_API.G_MISS_NUM,
6055: p_PRIMARY_CNT_PERSON_PARTY_ID => FND_API.G_MISS_NUM,
6056: p_PRIMARY_CONTACT_PHONE_ID => FND_API.G_MISS_NUM,
6057: p_REFERRED_BY => FND_API.G_MISS_NUM,
6058: p_REFERRAL_TYPE => FND_API.G_MISS_CHAR,
6059: p_REFERRAL_STATUS => FND_API.G_MISS_CHAR,
6052: p_PRM_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
6053: p_AUTO_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
6054: p_PRIMARY_CONTACT_PARTY_ID => FND_API.G_MISS_NUM,
6055: p_PRIMARY_CNT_PERSON_PARTY_ID => FND_API.G_MISS_NUM,
6056: p_PRIMARY_CONTACT_PHONE_ID => FND_API.G_MISS_NUM,
6057: p_REFERRED_BY => FND_API.G_MISS_NUM,
6058: p_REFERRAL_TYPE => FND_API.G_MISS_CHAR,
6059: p_REFERRAL_STATUS => FND_API.G_MISS_CHAR,
6060: p_REF_DECLINE_REASON => FND_API.G_MISS_CHAR,
6053: p_AUTO_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
6054: p_PRIMARY_CONTACT_PARTY_ID => FND_API.G_MISS_NUM,
6055: p_PRIMARY_CNT_PERSON_PARTY_ID => FND_API.G_MISS_NUM,
6056: p_PRIMARY_CONTACT_PHONE_ID => FND_API.G_MISS_NUM,
6057: p_REFERRED_BY => FND_API.G_MISS_NUM,
6058: p_REFERRAL_TYPE => FND_API.G_MISS_CHAR,
6059: p_REFERRAL_STATUS => FND_API.G_MISS_CHAR,
6060: p_REF_DECLINE_REASON => FND_API.G_MISS_CHAR,
6061: p_REF_COMM_LTR_STATUS => FND_API.G_MISS_CHAR,
6054: p_PRIMARY_CONTACT_PARTY_ID => FND_API.G_MISS_NUM,
6055: p_PRIMARY_CNT_PERSON_PARTY_ID => FND_API.G_MISS_NUM,
6056: p_PRIMARY_CONTACT_PHONE_ID => FND_API.G_MISS_NUM,
6057: p_REFERRED_BY => FND_API.G_MISS_NUM,
6058: p_REFERRAL_TYPE => FND_API.G_MISS_CHAR,
6059: p_REFERRAL_STATUS => FND_API.G_MISS_CHAR,
6060: p_REF_DECLINE_REASON => FND_API.G_MISS_CHAR,
6061: p_REF_COMM_LTR_STATUS => FND_API.G_MISS_CHAR,
6062: p_REF_ORDER_NUMBER => FND_API.G_MISS_NUM,
6055: p_PRIMARY_CNT_PERSON_PARTY_ID => FND_API.G_MISS_NUM,
6056: p_PRIMARY_CONTACT_PHONE_ID => FND_API.G_MISS_NUM,
6057: p_REFERRED_BY => FND_API.G_MISS_NUM,
6058: p_REFERRAL_TYPE => FND_API.G_MISS_CHAR,
6059: p_REFERRAL_STATUS => FND_API.G_MISS_CHAR,
6060: p_REF_DECLINE_REASON => FND_API.G_MISS_CHAR,
6061: p_REF_COMM_LTR_STATUS => FND_API.G_MISS_CHAR,
6062: p_REF_ORDER_NUMBER => FND_API.G_MISS_NUM,
6063: p_REF_ORDER_AMT => FND_API.G_MISS_NUM,
6056: p_PRIMARY_CONTACT_PHONE_ID => FND_API.G_MISS_NUM,
6057: p_REFERRED_BY => FND_API.G_MISS_NUM,
6058: p_REFERRAL_TYPE => FND_API.G_MISS_CHAR,
6059: p_REFERRAL_STATUS => FND_API.G_MISS_CHAR,
6060: p_REF_DECLINE_REASON => FND_API.G_MISS_CHAR,
6061: p_REF_COMM_LTR_STATUS => FND_API.G_MISS_CHAR,
6062: p_REF_ORDER_NUMBER => FND_API.G_MISS_NUM,
6063: p_REF_ORDER_AMT => FND_API.G_MISS_NUM,
6064: p_REF_COMM_AMT => FND_API.G_MISS_NUM,
6057: p_REFERRED_BY => FND_API.G_MISS_NUM,
6058: p_REFERRAL_TYPE => FND_API.G_MISS_CHAR,
6059: p_REFERRAL_STATUS => FND_API.G_MISS_CHAR,
6060: p_REF_DECLINE_REASON => FND_API.G_MISS_CHAR,
6061: p_REF_COMM_LTR_STATUS => FND_API.G_MISS_CHAR,
6062: p_REF_ORDER_NUMBER => FND_API.G_MISS_NUM,
6063: p_REF_ORDER_AMT => FND_API.G_MISS_NUM,
6064: p_REF_COMM_AMT => FND_API.G_MISS_NUM,
6065: -- bug No.2341515, 2368075
6058: p_REFERRAL_TYPE => FND_API.G_MISS_CHAR,
6059: p_REFERRAL_STATUS => FND_API.G_MISS_CHAR,
6060: p_REF_DECLINE_REASON => FND_API.G_MISS_CHAR,
6061: p_REF_COMM_LTR_STATUS => FND_API.G_MISS_CHAR,
6062: p_REF_ORDER_NUMBER => FND_API.G_MISS_NUM,
6063: p_REF_ORDER_AMT => FND_API.G_MISS_NUM,
6064: p_REF_COMM_AMT => FND_API.G_MISS_NUM,
6065: -- bug No.2341515, 2368075
6066: p_LEAD_DATE => FND_API.G_MISS_DATE,
6059: p_REFERRAL_STATUS => FND_API.G_MISS_CHAR,
6060: p_REF_DECLINE_REASON => FND_API.G_MISS_CHAR,
6061: p_REF_COMM_LTR_STATUS => FND_API.G_MISS_CHAR,
6062: p_REF_ORDER_NUMBER => FND_API.G_MISS_NUM,
6063: p_REF_ORDER_AMT => FND_API.G_MISS_NUM,
6064: p_REF_COMM_AMT => FND_API.G_MISS_NUM,
6065: -- bug No.2341515, 2368075
6066: p_LEAD_DATE => FND_API.G_MISS_DATE,
6067: p_SOURCE_SYSTEM => FND_API.G_MISS_CHAR,
6060: p_REF_DECLINE_REASON => FND_API.G_MISS_CHAR,
6061: p_REF_COMM_LTR_STATUS => FND_API.G_MISS_CHAR,
6062: p_REF_ORDER_NUMBER => FND_API.G_MISS_NUM,
6063: p_REF_ORDER_AMT => FND_API.G_MISS_NUM,
6064: p_REF_COMM_AMT => FND_API.G_MISS_NUM,
6065: -- bug No.2341515, 2368075
6066: p_LEAD_DATE => FND_API.G_MISS_DATE,
6067: p_SOURCE_SYSTEM => FND_API.G_MISS_CHAR,
6068: p_COUNTRY => FND_API.G_MISS_CHAR,
6062: p_REF_ORDER_NUMBER => FND_API.G_MISS_NUM,
6063: p_REF_ORDER_AMT => FND_API.G_MISS_NUM,
6064: p_REF_COMM_AMT => FND_API.G_MISS_NUM,
6065: -- bug No.2341515, 2368075
6066: p_LEAD_DATE => FND_API.G_MISS_DATE,
6067: p_SOURCE_SYSTEM => FND_API.G_MISS_CHAR,
6068: p_COUNTRY => FND_API.G_MISS_CHAR,
6069: p_TOTAL_AMOUNT => FND_API.G_MISS_NUM,
6070: p_EXPIRATION_DATE => FND_API.G_MISS_DATE,
6063: p_REF_ORDER_AMT => FND_API.G_MISS_NUM,
6064: p_REF_COMM_AMT => FND_API.G_MISS_NUM,
6065: -- bug No.2341515, 2368075
6066: p_LEAD_DATE => FND_API.G_MISS_DATE,
6067: p_SOURCE_SYSTEM => FND_API.G_MISS_CHAR,
6068: p_COUNTRY => FND_API.G_MISS_CHAR,
6069: p_TOTAL_AMOUNT => FND_API.G_MISS_NUM,
6070: p_EXPIRATION_DATE => FND_API.G_MISS_DATE,
6071: p_LEAD_RANK_IND => FND_API.G_MISS_CHAR,
6064: p_REF_COMM_AMT => FND_API.G_MISS_NUM,
6065: -- bug No.2341515, 2368075
6066: p_LEAD_DATE => FND_API.G_MISS_DATE,
6067: p_SOURCE_SYSTEM => FND_API.G_MISS_CHAR,
6068: p_COUNTRY => FND_API.G_MISS_CHAR,
6069: p_TOTAL_AMOUNT => FND_API.G_MISS_NUM,
6070: p_EXPIRATION_DATE => FND_API.G_MISS_DATE,
6071: p_LEAD_RANK_IND => FND_API.G_MISS_CHAR,
6072: p_LEAD_ENGINE_RUN_DATE => FND_API.G_MISS_DATE,
6065: -- bug No.2341515, 2368075
6066: p_LEAD_DATE => FND_API.G_MISS_DATE,
6067: p_SOURCE_SYSTEM => FND_API.G_MISS_CHAR,
6068: p_COUNTRY => FND_API.G_MISS_CHAR,
6069: p_TOTAL_AMOUNT => FND_API.G_MISS_NUM,
6070: p_EXPIRATION_DATE => FND_API.G_MISS_DATE,
6071: p_LEAD_RANK_IND => FND_API.G_MISS_CHAR,
6072: p_LEAD_ENGINE_RUN_DATE => FND_API.G_MISS_DATE,
6073: p_CURRENT_REROUTES => FND_API.G_MISS_NUM,
6066: p_LEAD_DATE => FND_API.G_MISS_DATE,
6067: p_SOURCE_SYSTEM => FND_API.G_MISS_CHAR,
6068: p_COUNTRY => FND_API.G_MISS_CHAR,
6069: p_TOTAL_AMOUNT => FND_API.G_MISS_NUM,
6070: p_EXPIRATION_DATE => FND_API.G_MISS_DATE,
6071: p_LEAD_RANK_IND => FND_API.G_MISS_CHAR,
6072: p_LEAD_ENGINE_RUN_DATE => FND_API.G_MISS_DATE,
6073: p_CURRENT_REROUTES => FND_API.G_MISS_NUM,
6074: p_STATUS_OPEN_FLAG => FND_API.G_MISS_CHAR,
6067: p_SOURCE_SYSTEM => FND_API.G_MISS_CHAR,
6068: p_COUNTRY => FND_API.G_MISS_CHAR,
6069: p_TOTAL_AMOUNT => FND_API.G_MISS_NUM,
6070: p_EXPIRATION_DATE => FND_API.G_MISS_DATE,
6071: p_LEAD_RANK_IND => FND_API.G_MISS_CHAR,
6072: p_LEAD_ENGINE_RUN_DATE => FND_API.G_MISS_DATE,
6073: p_CURRENT_REROUTES => FND_API.G_MISS_NUM,
6074: p_STATUS_OPEN_FLAG => FND_API.G_MISS_CHAR,
6075: p_LEAD_RANK_SCORE => FND_API.G_MISS_NUM,
6068: p_COUNTRY => FND_API.G_MISS_CHAR,
6069: p_TOTAL_AMOUNT => FND_API.G_MISS_NUM,
6070: p_EXPIRATION_DATE => FND_API.G_MISS_DATE,
6071: p_LEAD_RANK_IND => FND_API.G_MISS_CHAR,
6072: p_LEAD_ENGINE_RUN_DATE => FND_API.G_MISS_DATE,
6073: p_CURRENT_REROUTES => FND_API.G_MISS_NUM,
6074: p_STATUS_OPEN_FLAG => FND_API.G_MISS_CHAR,
6075: p_LEAD_RANK_SCORE => FND_API.G_MISS_NUM,
6076: -- 11.5.10 new columns
6069: p_TOTAL_AMOUNT => FND_API.G_MISS_NUM,
6070: p_EXPIRATION_DATE => FND_API.G_MISS_DATE,
6071: p_LEAD_RANK_IND => FND_API.G_MISS_CHAR,
6072: p_LEAD_ENGINE_RUN_DATE => FND_API.G_MISS_DATE,
6073: p_CURRENT_REROUTES => FND_API.G_MISS_NUM,
6074: p_STATUS_OPEN_FLAG => FND_API.G_MISS_CHAR,
6075: p_LEAD_RANK_SCORE => FND_API.G_MISS_NUM,
6076: -- 11.5.10 new columns
6077: p_MARKETING_SCORE => FND_API.G_MISS_NUM,
6070: p_EXPIRATION_DATE => FND_API.G_MISS_DATE,
6071: p_LEAD_RANK_IND => FND_API.G_MISS_CHAR,
6072: p_LEAD_ENGINE_RUN_DATE => FND_API.G_MISS_DATE,
6073: p_CURRENT_REROUTES => FND_API.G_MISS_NUM,
6074: p_STATUS_OPEN_FLAG => FND_API.G_MISS_CHAR,
6075: p_LEAD_RANK_SCORE => FND_API.G_MISS_NUM,
6076: -- 11.5.10 new columns
6077: p_MARKETING_SCORE => FND_API.G_MISS_NUM,
6078: p_INTERACTION_SCORE => FND_API.G_MISS_NUM,
6071: p_LEAD_RANK_IND => FND_API.G_MISS_CHAR,
6072: p_LEAD_ENGINE_RUN_DATE => FND_API.G_MISS_DATE,
6073: p_CURRENT_REROUTES => FND_API.G_MISS_NUM,
6074: p_STATUS_OPEN_FLAG => FND_API.G_MISS_CHAR,
6075: p_LEAD_RANK_SCORE => FND_API.G_MISS_NUM,
6076: -- 11.5.10 new columns
6077: p_MARKETING_SCORE => FND_API.G_MISS_NUM,
6078: p_INTERACTION_SCORE => FND_API.G_MISS_NUM,
6079: p_SOURCE_PRIMARY_REFERENCE => FND_API.G_MISS_CHAR,
6073: p_CURRENT_REROUTES => FND_API.G_MISS_NUM,
6074: p_STATUS_OPEN_FLAG => FND_API.G_MISS_CHAR,
6075: p_LEAD_RANK_SCORE => FND_API.G_MISS_NUM,
6076: -- 11.5.10 new columns
6077: p_MARKETING_SCORE => FND_API.G_MISS_NUM,
6078: p_INTERACTION_SCORE => FND_API.G_MISS_NUM,
6079: p_SOURCE_PRIMARY_REFERENCE => FND_API.G_MISS_CHAR,
6080: p_SOURCE_SECONDARY_REFERENCE => FND_API.G_MISS_CHAR,
6081: p_SALES_METHODOLOGY_ID => FND_API.G_MISS_NUM,
6074: p_STATUS_OPEN_FLAG => FND_API.G_MISS_CHAR,
6075: p_LEAD_RANK_SCORE => FND_API.G_MISS_NUM,
6076: -- 11.5.10 new columns
6077: p_MARKETING_SCORE => FND_API.G_MISS_NUM,
6078: p_INTERACTION_SCORE => FND_API.G_MISS_NUM,
6079: p_SOURCE_PRIMARY_REFERENCE => FND_API.G_MISS_CHAR,
6080: p_SOURCE_SECONDARY_REFERENCE => FND_API.G_MISS_CHAR,
6081: p_SALES_METHODOLOGY_ID => FND_API.G_MISS_NUM,
6082: p_SALES_STAGE_ID => FND_API.G_MISS_NUM);
6075: p_LEAD_RANK_SCORE => FND_API.G_MISS_NUM,
6076: -- 11.5.10 new columns
6077: p_MARKETING_SCORE => FND_API.G_MISS_NUM,
6078: p_INTERACTION_SCORE => FND_API.G_MISS_NUM,
6079: p_SOURCE_PRIMARY_REFERENCE => FND_API.G_MISS_CHAR,
6080: p_SOURCE_SECONDARY_REFERENCE => FND_API.G_MISS_CHAR,
6081: p_SALES_METHODOLOGY_ID => FND_API.G_MISS_NUM,
6082: p_SALES_STAGE_ID => FND_API.G_MISS_NUM);
6083:
6076: -- 11.5.10 new columns
6077: p_MARKETING_SCORE => FND_API.G_MISS_NUM,
6078: p_INTERACTION_SCORE => FND_API.G_MISS_NUM,
6079: p_SOURCE_PRIMARY_REFERENCE => FND_API.G_MISS_CHAR,
6080: p_SOURCE_SECONDARY_REFERENCE => FND_API.G_MISS_CHAR,
6081: p_SALES_METHODOLOGY_ID => FND_API.G_MISS_NUM,
6082: p_SALES_STAGE_ID => FND_API.G_MISS_NUM);
6083:
6084:
6077: p_MARKETING_SCORE => FND_API.G_MISS_NUM,
6078: p_INTERACTION_SCORE => FND_API.G_MISS_NUM,
6079: p_SOURCE_PRIMARY_REFERENCE => FND_API.G_MISS_CHAR,
6080: p_SOURCE_SECONDARY_REFERENCE => FND_API.G_MISS_CHAR,
6081: p_SALES_METHODOLOGY_ID => FND_API.G_MISS_NUM,
6082: p_SALES_STAGE_ID => FND_API.G_MISS_NUM);
6083:
6084:
6085: OPEN c_access_exist(p_sales_lead_id, p_resource_id, p_group_id);
6078: p_INTERACTION_SCORE => FND_API.G_MISS_NUM,
6079: p_SOURCE_PRIMARY_REFERENCE => FND_API.G_MISS_CHAR,
6080: p_SOURCE_SECONDARY_REFERENCE => FND_API.G_MISS_CHAR,
6081: p_SALES_METHODOLOGY_ID => FND_API.G_MISS_NUM,
6082: p_SALES_STAGE_ID => FND_API.G_MISS_NUM);
6083:
6084:
6085: OPEN c_access_exist(p_sales_lead_id, p_resource_id, p_group_id);
6086: FETCH c_access_exist INTO l_access_exist_flag;
6168: l_return_status VARCHAR2(1);
6169: l_msg_count NUMBER;
6170: l_msg_data VARCHAR2(2000);
6171: BEGIN
6172: x_return_status := FND_API.G_RET_STS_SUCCESS;
6173: OPEN C_Get_Lead_Info(p_sales_lead_id);
6174: FETCH C_Get_Lead_Info INTO l_referral_type;
6175: CLOSE C_Get_Lead_Info;
6176:
6212: x_return_status => x_return_status,
6213: x_msg_count => x_msg_count,
6214: x_msg_data => x_msg_data);
6215:
6216: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
6217: RAISE fnd_api.g_exc_error;
6218: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
6219: RAISE fnd_api.g_exc_unexpected_error;
6220: END IF;
6213: x_msg_count => x_msg_count,
6214: x_msg_data => x_msg_data);
6215:
6216: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
6217: RAISE fnd_api.g_exc_error;
6218: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
6219: RAISE fnd_api.g_exc_unexpected_error;
6220: END IF;
6221:
6214: x_msg_data => x_msg_data);
6215:
6216: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
6217: RAISE fnd_api.g_exc_error;
6218: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
6219: RAISE fnd_api.g_exc_unexpected_error;
6220: END IF;
6221:
6222: Get_Owner(
6215:
6216: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
6217: RAISE fnd_api.g_exc_error;
6218: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
6219: RAISE fnd_api.g_exc_unexpected_error;
6220: END IF;
6221:
6222: Get_Owner(
6223: p_sales_lead_id => p_sales_lead_id,
6228: x_return_status => l_return_status,
6229: x_msg_count => x_msg_count,
6230: x_msg_data => x_msg_data);
6231:
6232: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
6233: RAISE fnd_api.g_exc_error;
6234: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
6235: RAISE fnd_api.g_exc_unexpected_error;
6236: END IF;
6229: x_msg_count => x_msg_count,
6230: x_msg_data => x_msg_data);
6231:
6232: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
6233: RAISE fnd_api.g_exc_error;
6234: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
6235: RAISE fnd_api.g_exc_unexpected_error;
6236: END IF;
6237:
6230: x_msg_data => x_msg_data);
6231:
6232: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
6233: RAISE fnd_api.g_exc_error;
6234: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
6235: RAISE fnd_api.g_exc_unexpected_error;
6236: END IF;
6237:
6238: Update_Sales_Leads (
6231:
6232: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
6233: RAISE fnd_api.g_exc_error;
6234: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
6235: RAISE fnd_api.g_exc_unexpected_error;
6236: END IF;
6237:
6238: Update_Sales_Leads (
6239: p_sales_lead_id => p_sales_lead_id,
6243: x_return_status => x_return_status,
6244: x_msg_count => x_msg_count,
6245: x_msg_data => x_msg_data);
6246:
6247: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
6248: RAISE fnd_api.g_exc_error;
6249: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
6250: RAISE fnd_api.g_exc_unexpected_error;
6251: END IF;
6244: x_msg_count => x_msg_count,
6245: x_msg_data => x_msg_data);
6246:
6247: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
6248: RAISE fnd_api.g_exc_error;
6249: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
6250: RAISE fnd_api.g_exc_unexpected_error;
6251: END IF;
6252:
6245: x_msg_data => x_msg_data);
6246:
6247: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
6248: RAISE fnd_api.g_exc_error;
6249: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
6250: RAISE fnd_api.g_exc_unexpected_error;
6251: END IF;
6252:
6253: IF l_return_status = 'W' THEN
6246:
6247: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
6248: RAISE fnd_api.g_exc_error;
6249: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
6250: RAISE fnd_api.g_exc_unexpected_error;
6251: END IF;
6252:
6253: IF l_return_status = 'W' THEN
6254: x_return_status := 'W';