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
236: -- API Name: Assign_Sales_Lead
237:
238: PROCEDURE Assign_Sales_Lead (
239: P_Api_Version_Number IN NUMBER,
240: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
241: p_commit IN VARCHAR2 := FND_API.G_FALSE,
242: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
243: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
244: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
237:
238: PROCEDURE Assign_Sales_Lead (
239: P_Api_Version_Number IN NUMBER,
240: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
241: p_commit IN VARCHAR2 := FND_API.G_FALSE,
242: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
243: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
244: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
245: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
238: PROCEDURE Assign_Sales_Lead (
239: P_Api_Version_Number IN NUMBER,
240: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
241: p_commit IN VARCHAR2 := FND_API.G_FALSE,
242: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
243: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
244: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
245: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
246: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
239: P_Api_Version_Number IN NUMBER,
240: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
241: p_commit IN VARCHAR2 := FND_API.G_FALSE,
242: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
243: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
244: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
245: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
246: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
247: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
240: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
241: p_commit IN VARCHAR2 := FND_API.G_FALSE,
242: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
243: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
244: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
245: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
246: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
247: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
248: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
241: p_commit IN VARCHAR2 := FND_API.G_FALSE,
242: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
243: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
244: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
245: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
246: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
247: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
248: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
249: P_resource_type IN VARCHAR2 := NULL,
242: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
243: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
244: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
245: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
246: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
247: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
248: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
249: P_resource_type IN VARCHAR2 := NULL,
250: P_role IN VARCHAR2 := NULL,
394: -- Standard Start of API savepoint
395: SAVEPOINT ASSIGN_SALES_LEAD_PVT;
396:
397: -- Standard call to check for call compatibility.
398: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
399: p_api_version_number,
400: l_api_name,
401: G_PKG_NAME)
402: THEN
399: p_api_version_number,
400: l_api_name,
401: G_PKG_NAME)
402: THEN
403: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
404: END IF;
405:
406: -- Initialize message list IF p_init_msg_list is set to TRUE.
407: IF FND_API.to_Boolean( p_init_msg_list )
403: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
404: END IF;
405:
406: -- Initialize message list IF p_init_msg_list is set to TRUE.
407: IF FND_API.to_Boolean( p_init_msg_list )
408: THEN
409: FND_MSG_PUB.initialize;
410: END IF;
411:
415: 'PVT:' || l_api_name || ' Start');
416: END IF;
417:
418: -- Initialize API return status to SUCCESS
419: x_return_status := FND_API.G_RET_STS_SUCCESS;
420:
421: --
422: -- Api body
423: --
435: p_msg_name => 'UT_CANNOT_GET_PROFILE_VALUE',
436: p_token1 => 'PROFILE',
437: p_token1_value => 'USER_ID');
438: END IF;
439: RAISE FND_API.G_EXC_ERROR;
440: END IF;
441:
442: IF (p_validation_level = fnd_api.g_valid_level_full)
443: THEN
438: END IF;
439: RAISE FND_API.G_EXC_ERROR;
440: END IF;
441:
442: IF (p_validation_level = fnd_api.g_valid_level_full)
443: THEN
444: AS_SALES_ORG_MANAGER_PVT.Get_CurrentUser(
445: p_api_version_number => 2.0
446: ,p_init_msg_list => p_init_msg_list
451: ,x_msg_data => x_msg_data
452: ,x_sales_member_rec => l_identity_sales_member_rec);
453: END IF;
454:
455: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
456: RAISE FND_API.G_EXC_ERROR;
457: END IF;
458:
459: ffang 112800 */
452: ,x_sales_member_rec => l_identity_sales_member_rec);
453: END IF;
454:
455: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
456: RAISE FND_API.G_EXC_ERROR;
457: END IF;
458:
459: ffang 112800 */
460:
583:
584: JTF_ASSIGN_PUB.Get_Assign_Lead_Resources (
585: p_api_version => 1.0
586: ,p_init_msg_list => JTF_ASSIGN_PUB.AM_FALSE
587: -- ,p_commit => FND_API.G_FALSE
588: ,p_resource_type => p_resource_type
589: ,p_role => p_role
590: ,p_no_of_resources => p_no_of_resources
591: ,p_auto_select_flag => p_auto_select_flag
617:
618: IF x_return_status = 'E' THEN
619: FND_MSG_PUB.Get (
620: p_msg_index => FND_MSG_PUB.G_LAST,
621: p_encoded => FND_API.G_TRUE ,
622: p_data => l_data,
623: p_msg_index_out => l_index_out
624: );
625: IF (AS_DEBUG_LOW_ON) THEN
626: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
627: l_data);
628: END IF;
629:
630: ELSIF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
631: IF (AS_DEBUG_LOW_ON) THEN
632: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
633: 'JTF AM failed');
634: END IF;
632: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
633: 'JTF AM failed');
634: END IF;
635: -- exit;
636: -- raise FND_API.G_EXC_ERROR;
637: END IF;
638:
639: IF (AS_DEBUG_LOW_ON) THEN
640: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
666: -- END of API body
667: --
668:
669: -- Standard check for p_commit
670: IF FND_API.to_Boolean( p_commit )
671: THEN
672: COMMIT WORK;
673: END IF;
674:
684: ( p_count => x_msg_count,
685: p_data => x_msg_data );
686:
687: EXCEPTION
688: WHEN FND_API.G_EXC_ERROR THEN
689: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
690: P_API_NAME => L_API_NAME
691: ,P_PKG_NAME => G_PKG_NAME
692: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
694: ,X_MSG_COUNT => X_MSG_COUNT
695: ,X_MSG_DATA => X_MSG_DATA
696: ,X_RETURN_STATUS => X_RETURN_STATUS);
697:
698: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
699: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
700: P_API_NAME => L_API_NAME
701: ,P_PKG_NAME => G_PKG_NAME
702: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
720:
721:
722: PROCEDURE CALL_WF_TO_ASSIGN (
723: P_Api_Version_Number IN NUMBER,
724: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
725: p_commit IN VARCHAR2 := FND_API.G_FALSE,
726: P_Sales_Lead_Id IN NUMBER,
727: P_assigned_resource_id IN NUMBER := NULL,
728: X_Return_Status OUT NOCOPY VARCHAR2,
721:
722: PROCEDURE CALL_WF_TO_ASSIGN (
723: P_Api_Version_Number IN NUMBER,
724: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
725: p_commit IN VARCHAR2 := FND_API.G_FALSE,
726: P_Sales_Lead_Id IN NUMBER,
727: P_assigned_resource_id IN NUMBER := NULL,
728: X_Return_Status OUT NOCOPY VARCHAR2,
729: X_Msg_Count OUT NOCOPY NUMBER,
739: -- Standard Start of API savepoint
740: SAVEPOINT CALL_WF_TO_ASSIGN_PVT;
741:
742: -- Standard call to check for call compatibility.
743: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
744: p_api_version_number,
745: l_api_name,
746: G_PKG_NAME)
747: THEN
744: p_api_version_number,
745: l_api_name,
746: G_PKG_NAME)
747: THEN
748: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
749: END IF;
750:
751: -- Initialize message list IF p_init_msg_list is set to TRUE.
752: IF FND_API.to_Boolean( p_init_msg_list )
748: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
749: END IF;
750:
751: -- Initialize message list IF p_init_msg_list is set to TRUE.
752: IF FND_API.to_Boolean( p_init_msg_list )
753: THEN
754: FND_MSG_PUB.initialize;
755: END IF;
756:
760: 'PVT:' || l_api_name || ' Start');
761: END IF;
762:
763: -- Initialize API return status to SUCCESS
764: x_return_status := FND_API.G_RET_STS_SUCCESS;
765:
766: --
767: -- Api body
768: --
778: p_msg_name => 'UT_CANNOT_GET_PROFILE_VALUE',
779: p_token1 => 'PROFILE',
780: p_token1_value => 'USER_ID');
781: END IF;
782: RAISE FND_API.G_EXC_ERROR;
783: END IF;
784:
785: -- Debug Message
786: IF (AS_DEBUG_LOW_ON) THEN
789: END IF;
790:
791: AS_LEAD_ROUTING_WF.STARTPROCESS (
792: p_sales_lead_id => p_sales_lead_id,
793: p_salesgroup_id => fnd_api.g_miss_num,
794: x_return_status => x_return_status,
795: x_item_type => l_itemtype,
796: x_item_key => l_itemkey );
797:
801: END IF;
802:
803: -- verify the valid values of return_status from WF and handle them
804: IF x_return_status = '#NULL' THEN
805: x_return_status := FND_API.G_RET_STS_SUCCESS;
806: -- Will add these error messages to dictionary
807: -- AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR,
808: -- 'No assignment has been made.');
809: ELSIF x_return_status = 'ERROR' THEN
810: IF (AS_DEBUG_ERROR_ON) THEN
811: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR,
812: 'AS_LEAD_ASSIGN_FAIL');
813: END IF;
814: RAISE FND_API.G_EXC_ERROR;
815:
816: -- code change for bug 1613424 start
817:
818: ELSIF x_return_status = 'W' THEN
825: -- code change for bug 1613424 end
826:
827: ELSE
828:
829: x_return_status := FND_API.G_RET_STS_SUCCESS;
830: END IF;
831:
832: --
833: -- END of API body
833: -- END of API body
834: --
835:
836: -- Standard check for p_commit
837: IF FND_API.to_Boolean( p_commit )
838: THEN
839: COMMIT WORK;
840: END IF;
841:
855: -- API Name: Build_Lead_Sales_Team
856:
857: PROCEDURE Build_Lead_Sales_Team(
858: P_Api_Version_Number IN NUMBER,
859: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
860: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
861: p_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
862: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
863: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
856:
857: PROCEDURE Build_Lead_Sales_Team(
858: P_Api_Version_Number IN NUMBER,
859: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
860: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
861: p_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
862: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
863: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
864: P_Salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
857: PROCEDURE Build_Lead_Sales_Team(
858: P_Api_Version_Number IN NUMBER,
859: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
860: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
861: p_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
862: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
863: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
864: P_Salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
865: P_Sales_Lead_Id IN NUMBER,
858: P_Api_Version_Number IN NUMBER,
859: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
860: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
861: p_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
862: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
863: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
864: P_Salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
865: P_Sales_Lead_Id IN NUMBER,
866: X_Request_Id OUT NOCOPY NUMBER,
859: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
860: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
861: p_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
862: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
863: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
864: P_Salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
865: P_Sales_Lead_Id IN NUMBER,
866: X_Request_Id OUT NOCOPY NUMBER,
867: X_Return_Status OUT NOCOPY VARCHAR2,
860: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
861: p_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
862: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
863: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
864: P_Salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
865: P_Sales_Lead_Id IN NUMBER,
866: X_Request_Id OUT NOCOPY NUMBER,
867: X_Return_Status OUT NOCOPY VARCHAR2,
868: X_Msg_Count OUT NOCOPY NUMBER,
1263: -- Standard Start of API savepoint
1264: SAVEPOINT BUILD_LEAD_SALES_TEAM_PVT;
1265:
1266: -- Standard call to check for call compatibility.
1267: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1268: p_api_version_number,
1269: l_api_name,
1270: G_PKG_NAME)
1271: THEN
1268: p_api_version_number,
1269: l_api_name,
1270: G_PKG_NAME)
1271: THEN
1272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1273: END IF;
1274:
1275: -- Initialize message list IF p_init_msg_list is set to TRUE.
1276: IF FND_API.to_Boolean( p_init_msg_list )
1272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1273: END IF;
1274:
1275: -- Initialize message list IF p_init_msg_list is set to TRUE.
1276: IF FND_API.to_Boolean( p_init_msg_list )
1277: THEN
1278: FND_MSG_PUB.initialize;
1279: END IF;
1280:
1284: 'PVT:' || l_api_name || ' Start');
1285: END IF;
1286:
1287: -- Initialize API return status to SUCCESS
1288: x_return_status := FND_API.G_RET_STS_SUCCESS;
1289:
1290: --
1291: -- Api body
1292: --
1303: p_msg_name => 'UT_CANNOT_GET_PROFILE_VALUE',
1304: p_token1 => 'PROFILE',
1305: p_token1_value => 'USER_ID');
1306: END IF;
1307: RAISE FND_API.G_EXC_ERROR;
1308: END IF;
1309:
1310: IF (p_validation_level = fnd_api.g_valid_level_full)
1311: THEN
1306: END IF;
1307: RAISE FND_API.G_EXC_ERROR;
1308: END IF;
1309:
1310: IF (p_validation_level = fnd_api.g_valid_level_full)
1311: THEN
1312: AS_SALES_ORG_MANAGER_PVT.Get_CurrentUser(
1313: p_api_version_number => 2.0
1314: ,p_init_msg_list => p_init_msg_list
1319: ,x_msg_data => x_msg_data
1320: ,x_sales_member_rec => l_identity_sales_member_rec);
1321: END IF;
1322:
1323: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1324: RAISE FND_API.G_EXC_ERROR;
1325: END IF;
1326:
1327: OPEN C_Get_Lead_Info(p_Sales_Lead_Id);
1320: ,x_sales_member_rec => l_identity_sales_member_rec);
1321: END IF;
1322:
1323: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1324: RAISE FND_API.G_EXC_ERROR;
1325: END IF;
1326:
1327: OPEN C_Get_Lead_Info(p_Sales_Lead_Id);
1328: FETCH C_Get_Lead_Info INTO
1366: END IF;
1367:
1368: AS_SALES_LEAD_OWNER.Get_Salesreps(
1369: p_api_version => 2.0
1370: ,p_init_msg_list => FND_API.g_false
1371: ,p_commit => FND_API.g_false
1372: ,p_validation_level => p_Validation_Level
1373: ,p_sales_lead_id => p_sales_lead_id
1374: ,x_salesreps_tbl => l_lead_owner_tbl
1367:
1368: AS_SALES_LEAD_OWNER.Get_Salesreps(
1369: p_api_version => 2.0
1370: ,p_init_msg_list => FND_API.g_false
1371: ,p_commit => FND_API.g_false
1372: ,p_validation_level => p_Validation_Level
1373: ,p_sales_lead_id => p_sales_lead_id
1374: ,x_salesreps_tbl => l_lead_owner_tbl
1375: ,x_return_status => l_return_status
1375: ,x_return_status => l_return_status
1376: ,x_msg_count => x_msg_count
1377: ,x_msg_data => x_msg_data);
1378:
1379: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1380: RAISE FND_API.G_EXC_ERROR;
1381: END IF;
1382:
1383: IF (AS_DEBUG_LOW_ON) THEN
1376: ,x_msg_count => x_msg_count
1377: ,x_msg_data => x_msg_data);
1378:
1379: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1380: RAISE FND_API.G_EXC_ERROR;
1381: END IF;
1382:
1383: IF (AS_DEBUG_LOW_ON) THEN
1384: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1651:
1652: JTF_ASSIGN_PUB.Get_Assign_Lead_Resources (
1653: p_api_version => 1.0
1654: ,p_init_msg_list => JTF_ASSIGN_PUB.AM_FALSE
1655: -- ,p_commit => FND_API.G_FALSE
1656: ,p_resource_type => NULL
1657: ,p_role => NULL
1658: ,p_no_of_resources => 999
1659: ,p_auto_select_flag => NULL
1673: IF l_return_status = 'E'
1674: THEN
1675: FND_MSG_PUB.Get (
1676: p_msg_index => FND_MSG_PUB.G_LAST,
1677: p_encoded => FND_API.G_TRUE ,
1678: p_data => l_data,
1679: p_msg_index_out => l_index_out
1680: );
1681: IF (AS_DEBUG_LOW_ON) THEN
1682: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1683: l_data);
1684: END IF;
1685:
1686: ELSIF l_return_status <> FND_API.G_RET_STS_SUCCESS
1687: THEN
1688: RAISE FND_API.G_EXC_ERROR;
1689: END IF;
1690:
1684: END IF;
1685:
1686: ELSIF l_return_status <> FND_API.G_RET_STS_SUCCESS
1687: THEN
1688: RAISE FND_API.G_EXC_ERROR;
1689: END IF;
1690:
1691: IF (AS_DEBUG_LOW_ON) THEN
1692: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1939: -- END of API body
1940: --
1941:
1942: -- Standard check for p_commit
1943: IF FND_API.to_Boolean( p_commit )
1944: THEN
1945: COMMIT WORK;
1946: END IF;
1947:
1955: IF x_return_status = 'W'
1956: THEN
1957: FND_MSG_PUB.Count_And_Get
1958: (
1959: p_encoded => FND_API.G_FALSE,
1960: p_count => x_msg_count,
1961: p_data => x_msg_data );
1962: ELSE
1963: FND_MSG_PUB.Count_And_Get
1965: p_data => x_msg_data );
1966: END IF;
1967:
1968: EXCEPTION
1969: WHEN FND_API.G_EXC_ERROR THEN
1970: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1971: P_API_NAME => L_API_NAME
1972: ,P_PKG_NAME => G_PKG_NAME
1973: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1975: ,X_MSG_COUNT => X_MSG_COUNT
1976: ,X_MSG_DATA => X_MSG_DATA
1977: ,X_RETURN_STATUS => X_RETURN_STATUS);
1978:
1979: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1980: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1981: P_API_NAME => L_API_NAME
1982: ,P_PKG_NAME => G_PKG_NAME
1983: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2003: -- API Name: Rebuild_Lead_Sales_Team
2004:
2005: PROCEDURE Rebuild_Lead_Sales_Team(
2006: P_Api_Version_Number IN NUMBER,
2007: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2008: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
2009: p_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2010: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
2011: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
2004:
2005: PROCEDURE Rebuild_Lead_Sales_Team(
2006: P_Api_Version_Number IN NUMBER,
2007: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2008: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
2009: p_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2010: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
2011: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
2012: P_Salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
2005: PROCEDURE Rebuild_Lead_Sales_Team(
2006: P_Api_Version_Number IN NUMBER,
2007: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2008: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
2009: p_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2010: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
2011: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
2012: P_Salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
2013: P_Sales_Lead_Id IN NUMBER,
2006: P_Api_Version_Number IN NUMBER,
2007: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2008: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
2009: p_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2010: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
2011: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
2012: P_Salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
2013: P_Sales_Lead_Id IN NUMBER,
2014: X_Request_id OUT NOCOPY NUMBER,
2007: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2008: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
2009: p_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2010: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
2011: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
2012: P_Salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
2013: P_Sales_Lead_Id IN NUMBER,
2014: X_Request_id OUT NOCOPY NUMBER,
2015: X_Return_Status OUT NOCOPY VARCHAR2,
2008: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
2009: p_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2010: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
2011: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
2012: P_Salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
2013: P_Sales_Lead_Id IN NUMBER,
2014: X_Request_id OUT NOCOPY NUMBER,
2015: X_Return_Status OUT NOCOPY VARCHAR2,
2016: X_Msg_Count OUT NOCOPY NUMBER,
2314: l_api_name CONSTANT VARCHAR2(30)
2315: := 'Rebuild_Lead_Sales_Team';
2316: l_api_version_number CONSTANT NUMBER := 2.0;
2317: l_customer_id NUMBER;
2318: l_old_address_id NUMBER := FND_API.G_MISS_NUM;
2319: l_new_address_id NUMBER;
2320: l_assign_to_salesforce_id NUMBER;
2321: l_assign_sales_group_id NUMBER;
2322: l_reject_reason_code VARCHAR2(30);
2362: -- Standard Start of API savepoint
2363: SAVEPOINT REBUILD_LEAD_SALES_TEAM_PVT;
2364:
2365: -- Standard call to check for call compatibility.
2366: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2367: p_api_version_number,
2368: l_api_name,
2369: G_PKG_NAME)
2370: THEN
2367: p_api_version_number,
2368: l_api_name,
2369: G_PKG_NAME)
2370: THEN
2371: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2372: END IF;
2373:
2374: -- Initialize message list IF p_init_msg_list is set to TRUE.
2375: IF FND_API.to_Boolean( p_init_msg_list )
2371: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2372: END IF;
2373:
2374: -- Initialize message list IF p_init_msg_list is set to TRUE.
2375: IF FND_API.to_Boolean( p_init_msg_list )
2376: THEN
2377: FND_MSG_PUB.initialize;
2378: END IF;
2379:
2383: 'PVT:' || l_api_name || ' Start');
2384: END IF;
2385:
2386: -- Initialize API return status to SUCCESS
2387: x_return_status := FND_API.G_RET_STS_SUCCESS;
2388:
2389: --
2390: -- Api body
2391: --
2406: OPEN C_Check_Changed(p_sales_lead_id);
2407: FETCH C_Check_Changed INTO l_old_address_id;
2408: CLOSE C_Check_Changed;
2409:
2410: IF l_old_address_id = FND_API.G_MISS_NUM
2411: THEN
2412: -- There's no need to rebuild sales team for this sales lead
2413: -- because there's no record in as_changed_accounts_all
2414: IF (AS_DEBUG_LOW_ON) THEN
2477: p_msg_name => 'UT_CANNOT_GET_PROFILE_VALUE',
2478: p_token1 => 'PROFILE',
2479: p_token1_value => 'USER_ID');
2480: END IF;
2481: RAISE FND_API.G_EXC_ERROR;
2482: END IF;
2483:
2484: IF (p_validation_level = fnd_api.g_valid_level_full)
2485: THEN
2480: END IF;
2481: RAISE FND_API.G_EXC_ERROR;
2482: END IF;
2483:
2484: IF (p_validation_level = fnd_api.g_valid_level_full)
2485: THEN
2486: AS_SALES_ORG_MANAGER_PVT.Get_CurrentUser(
2487: p_api_version_number => 2.0
2488: ,p_init_msg_list => p_init_msg_list
2493: ,x_msg_data => x_msg_data
2494: ,x_sales_member_rec => l_identity_sales_member_rec);
2495: END IF;
2496:
2497: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2498: RAISE FND_API.G_EXC_ERROR;
2499: END IF;
2500:
2501: -- Get access_id, terr_id for the records that come from LEAD territory.
2494: ,x_sales_member_rec => l_identity_sales_member_rec);
2495: END IF;
2496:
2497: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2498: RAISE FND_API.G_EXC_ERROR;
2499: END IF;
2500:
2501: -- Get access_id, terr_id for the records that come from LEAD territory.
2502: -- Delete these records before new resource records are created in
2698:
2699: JTF_ASSIGN_PUB.Get_Assign_Lead_Resources (
2700: p_api_version => 1.0
2701: ,p_init_msg_list => JTF_ASSIGN_PUB.AM_FALSE
2702: -- ,p_commit => FND_API.G_FALSE
2703: ,p_resource_type => NULL
2704: ,p_role => NULL
2705: ,p_no_of_resources => 999
2706: ,p_auto_select_flag => NULL
2720: IF l_return_status = 'E'
2721: THEN
2722: FND_MSG_PUB.Get (
2723: p_msg_index => FND_MSG_PUB.G_LAST,
2724: p_encoded => FND_API.G_TRUE ,
2725: p_data => l_data,
2726: p_msg_index_out => l_index_out
2727: );
2728: IF (AS_DEBUG_LOW_ON) THEN
2729: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2730: l_data);
2731: END IF;
2732:
2733: ELSIF l_return_status <> FND_API.G_RET_STS_SUCCESS
2734: THEN
2735: RAISE FND_API.G_EXC_ERROR;
2736: END IF;
2737:
2731: END IF;
2732:
2733: ELSIF l_return_status <> FND_API.G_RET_STS_SUCCESS
2734: THEN
2735: RAISE FND_API.G_EXC_ERROR;
2736: END IF;
2737:
2738: l_request_id := FND_GLOBAL.Conc_Request_Id;
2739: IF (AS_DEBUG_LOW_ON) THEN
2964: -- END of API body
2965: --
2966:
2967: -- Standard check for p_commit
2968: IF FND_API.to_Boolean( p_commit )
2969: THEN
2970: COMMIT WORK;
2971: END IF;
2972:
2981: IF x_return_status = 'W'
2982: THEN
2983: FND_MSG_PUB.Count_And_Get
2984: (
2985: p_encoded => FND_API.G_FALSE,
2986: p_count => x_msg_count,
2987: p_data => x_msg_data );
2988: ELSE
2989: FND_MSG_PUB.Count_And_Get
2991: p_data => x_msg_data );
2992: END IF;
2993:
2994: EXCEPTION
2995: WHEN FND_API.G_EXC_ERROR THEN
2996: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2997: P_API_NAME => L_API_NAME
2998: ,P_PKG_NAME => G_PKG_NAME
2999: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
3001: ,X_MSG_COUNT => X_MSG_COUNT
3002: ,X_MSG_DATA => X_MSG_DATA
3003: ,X_RETURN_STATUS => X_RETURN_STATUS);
3004:
3005: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3006: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3007: P_API_NAME => L_API_NAME
3008: ,P_PKG_NAME => G_PKG_NAME
3009: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
4178: -- If not, add as view only access.
4179: -- SOLIN, bug 4702335
4180: l_rs_id := p_identity_salesforce_id;
4181: IF p_identity_salesforce_id IS NULL
4182: OR p_identity_salesforce_id = FND_API.G_MISS_NUM
4183: THEN
4184: -- if login user's resource_id is not passed in, get from the system
4185: OPEN C_get_current_resource;
4186: FETCH C_get_current_resource INTO l_rs_id;
4216: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4217: 'Add current user to sales team');
4218: END IF;
4219:
4220: IF p_salesgroup_id = fnd_api.g_miss_num
4221: THEN
4222: OPEN c_get_group_id (l_rs_id, 'RS_GROUP_MEMBER', 'SALES',
4223: 'TELESALES', 'FIELDSALES', 'PRM', 'Y');
4224: FETCH c_get_group_id INTO l_group_id;
4377: WHERE sl.sales_lead_id = c_sales_lead_id
4378: AND sl.status_code = sta.status_code
4379: AND sl.lead_rank_id = rk.rank_id(+);
4380: BEGIN
4381: x_return_status := FND_API.G_RET_STS_SUCCESS;
4382: l_resource_id := fnd_profile.value('AS_DEFAULT_RESOURCE_ID');
4383: IF l_resource_id IS NULL
4384: THEN
4385: IF (AS_DEBUG_LOW_ON) THEN
4407: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4408: 'Users resource id is:' || l_resource_id);
4409: END IF;
4410:
4411: IF p_salesgroup_id = fnd_api.g_miss_num
4412: THEN
4413: OPEN c_get_group_id (l_resource_id);
4414: FETCH c_get_group_id INTO l_group_id;
4415: CLOSE c_get_group_id;
4485: AS_SALES_LEADS_PKG.Sales_Lead_Update_Row(
4486: p_SALES_LEAD_ID => p_SALES_LEAD_ID,
4487: p_LAST_UPDATE_DATE => SYSDATE,
4488: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
4489: p_CREATION_DATE => FND_API.G_MISS_DATE,
4490: p_CREATED_BY => FND_API.G_MISS_NUM,
4491: p_LAST_UPDATE_LOGIN => FND_API.G_MISS_NUM,
4492: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,
4493: p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id,
4486: p_SALES_LEAD_ID => p_SALES_LEAD_ID,
4487: p_LAST_UPDATE_DATE => SYSDATE,
4488: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
4489: p_CREATION_DATE => FND_API.G_MISS_DATE,
4490: p_CREATED_BY => FND_API.G_MISS_NUM,
4491: p_LAST_UPDATE_LOGIN => FND_API.G_MISS_NUM,
4492: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,
4493: p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id,
4494: p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id,
4487: p_LAST_UPDATE_DATE => SYSDATE,
4488: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
4489: p_CREATION_DATE => FND_API.G_MISS_DATE,
4490: p_CREATED_BY => FND_API.G_MISS_NUM,
4491: p_LAST_UPDATE_LOGIN => FND_API.G_MISS_NUM,
4492: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,
4493: p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id,
4494: p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id,
4495: p_PROGRAM_UPDATE_DATE => SYSDATE,
4492: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,
4493: p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id,
4494: p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id,
4495: p_PROGRAM_UPDATE_DATE => SYSDATE,
4496: p_LEAD_NUMBER => FND_API.G_MISS_CHAR,
4497: p_STATUS_CODE => FND_API.G_MISS_CHAR, --l_routing_status,
4498: p_CUSTOMER_ID => l_CUSTOMER_ID,
4499: p_ADDRESS_ID => l_ADDRESS_ID,
4500: p_SOURCE_PROMOTION_ID => FND_API.G_MISS_NUM,
4493: p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id,
4494: p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id,
4495: p_PROGRAM_UPDATE_DATE => SYSDATE,
4496: p_LEAD_NUMBER => FND_API.G_MISS_CHAR,
4497: p_STATUS_CODE => FND_API.G_MISS_CHAR, --l_routing_status,
4498: p_CUSTOMER_ID => l_CUSTOMER_ID,
4499: p_ADDRESS_ID => l_ADDRESS_ID,
4500: p_SOURCE_PROMOTION_ID => FND_API.G_MISS_NUM,
4501: p_INITIATING_CONTACT_ID => FND_API.G_MISS_NUM,
4496: p_LEAD_NUMBER => FND_API.G_MISS_CHAR,
4497: p_STATUS_CODE => FND_API.G_MISS_CHAR, --l_routing_status,
4498: p_CUSTOMER_ID => l_CUSTOMER_ID,
4499: p_ADDRESS_ID => l_ADDRESS_ID,
4500: p_SOURCE_PROMOTION_ID => FND_API.G_MISS_NUM,
4501: p_INITIATING_CONTACT_ID => FND_API.G_MISS_NUM,
4502: p_ORIG_SYSTEM_REFERENCE => FND_API.G_MISS_CHAR,
4503: p_CONTACT_ROLE_CODE => FND_API.G_MISS_CHAR,
4504: p_CHANNEL_CODE => FND_API.G_MISS_CHAR,
4497: p_STATUS_CODE => FND_API.G_MISS_CHAR, --l_routing_status,
4498: p_CUSTOMER_ID => l_CUSTOMER_ID,
4499: p_ADDRESS_ID => l_ADDRESS_ID,
4500: p_SOURCE_PROMOTION_ID => FND_API.G_MISS_NUM,
4501: p_INITIATING_CONTACT_ID => FND_API.G_MISS_NUM,
4502: p_ORIG_SYSTEM_REFERENCE => FND_API.G_MISS_CHAR,
4503: p_CONTACT_ROLE_CODE => FND_API.G_MISS_CHAR,
4504: p_CHANNEL_CODE => FND_API.G_MISS_CHAR,
4505: p_BUDGET_AMOUNT => FND_API.G_MISS_NUM,
4498: p_CUSTOMER_ID => l_CUSTOMER_ID,
4499: p_ADDRESS_ID => l_ADDRESS_ID,
4500: p_SOURCE_PROMOTION_ID => FND_API.G_MISS_NUM,
4501: p_INITIATING_CONTACT_ID => FND_API.G_MISS_NUM,
4502: p_ORIG_SYSTEM_REFERENCE => FND_API.G_MISS_CHAR,
4503: p_CONTACT_ROLE_CODE => FND_API.G_MISS_CHAR,
4504: p_CHANNEL_CODE => FND_API.G_MISS_CHAR,
4505: p_BUDGET_AMOUNT => FND_API.G_MISS_NUM,
4506: p_CURRENCY_CODE => FND_API.G_MISS_CHAR,
4499: p_ADDRESS_ID => l_ADDRESS_ID,
4500: p_SOURCE_PROMOTION_ID => FND_API.G_MISS_NUM,
4501: p_INITIATING_CONTACT_ID => FND_API.G_MISS_NUM,
4502: p_ORIG_SYSTEM_REFERENCE => FND_API.G_MISS_CHAR,
4503: p_CONTACT_ROLE_CODE => FND_API.G_MISS_CHAR,
4504: p_CHANNEL_CODE => FND_API.G_MISS_CHAR,
4505: p_BUDGET_AMOUNT => FND_API.G_MISS_NUM,
4506: p_CURRENCY_CODE => FND_API.G_MISS_CHAR,
4507: p_DECISION_TIMEFRAME_CODE => FND_API.G_MISS_CHAR,
4500: p_SOURCE_PROMOTION_ID => FND_API.G_MISS_NUM,
4501: p_INITIATING_CONTACT_ID => FND_API.G_MISS_NUM,
4502: p_ORIG_SYSTEM_REFERENCE => FND_API.G_MISS_CHAR,
4503: p_CONTACT_ROLE_CODE => FND_API.G_MISS_CHAR,
4504: p_CHANNEL_CODE => FND_API.G_MISS_CHAR,
4505: p_BUDGET_AMOUNT => FND_API.G_MISS_NUM,
4506: p_CURRENCY_CODE => FND_API.G_MISS_CHAR,
4507: p_DECISION_TIMEFRAME_CODE => FND_API.G_MISS_CHAR,
4508: p_CLOSE_REASON => FND_API.G_MISS_CHAR,
4501: p_INITIATING_CONTACT_ID => FND_API.G_MISS_NUM,
4502: p_ORIG_SYSTEM_REFERENCE => FND_API.G_MISS_CHAR,
4503: p_CONTACT_ROLE_CODE => FND_API.G_MISS_CHAR,
4504: p_CHANNEL_CODE => FND_API.G_MISS_CHAR,
4505: p_BUDGET_AMOUNT => FND_API.G_MISS_NUM,
4506: p_CURRENCY_CODE => FND_API.G_MISS_CHAR,
4507: p_DECISION_TIMEFRAME_CODE => FND_API.G_MISS_CHAR,
4508: p_CLOSE_REASON => FND_API.G_MISS_CHAR,
4509: p_LEAD_RANK_ID => FND_API.G_MISS_NUM,
4502: p_ORIG_SYSTEM_REFERENCE => FND_API.G_MISS_CHAR,
4503: p_CONTACT_ROLE_CODE => FND_API.G_MISS_CHAR,
4504: p_CHANNEL_CODE => FND_API.G_MISS_CHAR,
4505: p_BUDGET_AMOUNT => FND_API.G_MISS_NUM,
4506: p_CURRENCY_CODE => FND_API.G_MISS_CHAR,
4507: p_DECISION_TIMEFRAME_CODE => FND_API.G_MISS_CHAR,
4508: p_CLOSE_REASON => FND_API.G_MISS_CHAR,
4509: p_LEAD_RANK_ID => FND_API.G_MISS_NUM,
4510: p_LEAD_RANK_CODE => FND_API.G_MISS_CHAR,
4503: p_CONTACT_ROLE_CODE => FND_API.G_MISS_CHAR,
4504: p_CHANNEL_CODE => FND_API.G_MISS_CHAR,
4505: p_BUDGET_AMOUNT => FND_API.G_MISS_NUM,
4506: p_CURRENCY_CODE => FND_API.G_MISS_CHAR,
4507: p_DECISION_TIMEFRAME_CODE => FND_API.G_MISS_CHAR,
4508: p_CLOSE_REASON => FND_API.G_MISS_CHAR,
4509: p_LEAD_RANK_ID => FND_API.G_MISS_NUM,
4510: p_LEAD_RANK_CODE => FND_API.G_MISS_CHAR,
4511: p_PARENT_PROJECT => FND_API.G_MISS_CHAR,
4504: p_CHANNEL_CODE => FND_API.G_MISS_CHAR,
4505: p_BUDGET_AMOUNT => FND_API.G_MISS_NUM,
4506: p_CURRENCY_CODE => FND_API.G_MISS_CHAR,
4507: p_DECISION_TIMEFRAME_CODE => FND_API.G_MISS_CHAR,
4508: p_CLOSE_REASON => FND_API.G_MISS_CHAR,
4509: p_LEAD_RANK_ID => FND_API.G_MISS_NUM,
4510: p_LEAD_RANK_CODE => FND_API.G_MISS_CHAR,
4511: p_PARENT_PROJECT => FND_API.G_MISS_CHAR,
4512: p_DESCRIPTION => FND_API.G_MISS_CHAR,
4505: p_BUDGET_AMOUNT => FND_API.G_MISS_NUM,
4506: p_CURRENCY_CODE => FND_API.G_MISS_CHAR,
4507: p_DECISION_TIMEFRAME_CODE => FND_API.G_MISS_CHAR,
4508: p_CLOSE_REASON => FND_API.G_MISS_CHAR,
4509: p_LEAD_RANK_ID => FND_API.G_MISS_NUM,
4510: p_LEAD_RANK_CODE => FND_API.G_MISS_CHAR,
4511: p_PARENT_PROJECT => FND_API.G_MISS_CHAR,
4512: p_DESCRIPTION => FND_API.G_MISS_CHAR,
4513: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
4506: p_CURRENCY_CODE => FND_API.G_MISS_CHAR,
4507: p_DECISION_TIMEFRAME_CODE => FND_API.G_MISS_CHAR,
4508: p_CLOSE_REASON => FND_API.G_MISS_CHAR,
4509: p_LEAD_RANK_ID => FND_API.G_MISS_NUM,
4510: p_LEAD_RANK_CODE => FND_API.G_MISS_CHAR,
4511: p_PARENT_PROJECT => FND_API.G_MISS_CHAR,
4512: p_DESCRIPTION => FND_API.G_MISS_CHAR,
4513: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
4514: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
4507: p_DECISION_TIMEFRAME_CODE => FND_API.G_MISS_CHAR,
4508: p_CLOSE_REASON => FND_API.G_MISS_CHAR,
4509: p_LEAD_RANK_ID => FND_API.G_MISS_NUM,
4510: p_LEAD_RANK_CODE => FND_API.G_MISS_CHAR,
4511: p_PARENT_PROJECT => FND_API.G_MISS_CHAR,
4512: p_DESCRIPTION => FND_API.G_MISS_CHAR,
4513: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
4514: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
4515: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
4508: p_CLOSE_REASON => FND_API.G_MISS_CHAR,
4509: p_LEAD_RANK_ID => FND_API.G_MISS_NUM,
4510: p_LEAD_RANK_CODE => FND_API.G_MISS_CHAR,
4511: p_PARENT_PROJECT => FND_API.G_MISS_CHAR,
4512: p_DESCRIPTION => FND_API.G_MISS_CHAR,
4513: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
4514: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
4515: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
4516: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
4509: p_LEAD_RANK_ID => FND_API.G_MISS_NUM,
4510: p_LEAD_RANK_CODE => FND_API.G_MISS_CHAR,
4511: p_PARENT_PROJECT => FND_API.G_MISS_CHAR,
4512: p_DESCRIPTION => FND_API.G_MISS_CHAR,
4513: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
4514: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
4515: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
4516: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
4517: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
4510: p_LEAD_RANK_CODE => FND_API.G_MISS_CHAR,
4511: p_PARENT_PROJECT => FND_API.G_MISS_CHAR,
4512: p_DESCRIPTION => FND_API.G_MISS_CHAR,
4513: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
4514: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
4515: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
4516: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
4517: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
4518: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
4511: p_PARENT_PROJECT => FND_API.G_MISS_CHAR,
4512: p_DESCRIPTION => FND_API.G_MISS_CHAR,
4513: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
4514: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
4515: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
4516: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
4517: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
4518: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
4519: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
4512: p_DESCRIPTION => FND_API.G_MISS_CHAR,
4513: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
4514: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
4515: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
4516: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
4517: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
4518: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
4519: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
4520: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
4513: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
4514: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
4515: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
4516: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
4517: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
4518: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
4519: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
4520: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
4521: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
4514: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
4515: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
4516: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
4517: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
4518: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
4519: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
4520: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
4521: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
4522: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
4515: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
4516: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
4517: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
4518: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
4519: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
4520: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
4521: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
4522: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
4523: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
4516: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
4517: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
4518: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
4519: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
4520: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
4521: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
4522: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
4523: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
4524: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
4517: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
4518: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
4519: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
4520: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
4521: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
4522: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
4523: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
4524: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
4525: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
4518: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
4519: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
4520: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
4521: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
4522: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
4523: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
4524: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
4525: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
4526: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
4519: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
4520: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
4521: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
4522: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
4523: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
4524: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
4525: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
4526: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
4527: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
4520: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
4521: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
4522: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
4523: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
4524: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
4525: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
4526: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
4527: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
4528: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
4521: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
4522: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
4523: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
4524: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
4525: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
4526: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
4527: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
4528: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
4529: p_ASSIGN_TO_PERSON_ID => l_person_id,
4522: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
4523: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
4524: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
4525: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
4526: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
4527: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
4528: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
4529: p_ASSIGN_TO_PERSON_ID => l_person_id,
4530: p_ASSIGN_TO_SALESFORCE_ID => l_resource_id,
4523: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
4524: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
4525: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
4526: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
4527: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
4528: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
4529: p_ASSIGN_TO_PERSON_ID => l_person_id,
4530: p_ASSIGN_TO_SALESFORCE_ID => l_resource_id,
4531: p_ASSIGN_SALES_GROUP_ID => l_group_id,
4524: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
4525: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
4526: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
4527: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
4528: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
4529: p_ASSIGN_TO_PERSON_ID => l_person_id,
4530: p_ASSIGN_TO_SALESFORCE_ID => l_resource_id,
4531: p_ASSIGN_SALES_GROUP_ID => l_group_id,
4532: p_ASSIGN_DATE => SYSDATE,
4529: p_ASSIGN_TO_PERSON_ID => l_person_id,
4530: p_ASSIGN_TO_SALESFORCE_ID => l_resource_id,
4531: p_ASSIGN_SALES_GROUP_ID => l_group_id,
4532: p_ASSIGN_DATE => SYSDATE,
4533: p_BUDGET_STATUS_CODE => FND_API.G_MISS_CHAR,
4534: p_ACCEPT_FLAG => 'N',
4535: p_VEHICLE_RESPONSE_CODE => FND_API.G_MISS_CHAR,
4536: p_TOTAL_SCORE => FND_API.G_MISS_NUM,
4537: p_SCORECARD_ID => FND_API.G_MISS_NUM,
4531: p_ASSIGN_SALES_GROUP_ID => l_group_id,
4532: p_ASSIGN_DATE => SYSDATE,
4533: p_BUDGET_STATUS_CODE => FND_API.G_MISS_CHAR,
4534: p_ACCEPT_FLAG => 'N',
4535: p_VEHICLE_RESPONSE_CODE => FND_API.G_MISS_CHAR,
4536: p_TOTAL_SCORE => FND_API.G_MISS_NUM,
4537: p_SCORECARD_ID => FND_API.G_MISS_NUM,
4538: p_KEEP_FLAG => FND_API.G_MISS_CHAR,
4539: p_URGENT_FLAG => FND_API.G_MISS_CHAR,
4532: p_ASSIGN_DATE => SYSDATE,
4533: p_BUDGET_STATUS_CODE => FND_API.G_MISS_CHAR,
4534: p_ACCEPT_FLAG => 'N',
4535: p_VEHICLE_RESPONSE_CODE => FND_API.G_MISS_CHAR,
4536: p_TOTAL_SCORE => FND_API.G_MISS_NUM,
4537: p_SCORECARD_ID => FND_API.G_MISS_NUM,
4538: p_KEEP_FLAG => FND_API.G_MISS_CHAR,
4539: p_URGENT_FLAG => FND_API.G_MISS_CHAR,
4540: p_IMPORT_FLAG => FND_API.G_MISS_CHAR,
4533: p_BUDGET_STATUS_CODE => FND_API.G_MISS_CHAR,
4534: p_ACCEPT_FLAG => 'N',
4535: p_VEHICLE_RESPONSE_CODE => FND_API.G_MISS_CHAR,
4536: p_TOTAL_SCORE => FND_API.G_MISS_NUM,
4537: p_SCORECARD_ID => FND_API.G_MISS_NUM,
4538: p_KEEP_FLAG => FND_API.G_MISS_CHAR,
4539: p_URGENT_FLAG => FND_API.G_MISS_CHAR,
4540: p_IMPORT_FLAG => FND_API.G_MISS_CHAR,
4541: p_REJECT_REASON_CODE => NULL, --l_reject_reason_code,
4534: p_ACCEPT_FLAG => 'N',
4535: p_VEHICLE_RESPONSE_CODE => FND_API.G_MISS_CHAR,
4536: p_TOTAL_SCORE => FND_API.G_MISS_NUM,
4537: p_SCORECARD_ID => FND_API.G_MISS_NUM,
4538: p_KEEP_FLAG => FND_API.G_MISS_CHAR,
4539: p_URGENT_FLAG => FND_API.G_MISS_CHAR,
4540: p_IMPORT_FLAG => FND_API.G_MISS_CHAR,
4541: p_REJECT_REASON_CODE => NULL, --l_reject_reason_code,
4542: p_DELETED_FLAG => FND_API.G_MISS_CHAR,
4535: p_VEHICLE_RESPONSE_CODE => FND_API.G_MISS_CHAR,
4536: p_TOTAL_SCORE => FND_API.G_MISS_NUM,
4537: p_SCORECARD_ID => FND_API.G_MISS_NUM,
4538: p_KEEP_FLAG => FND_API.G_MISS_CHAR,
4539: p_URGENT_FLAG => FND_API.G_MISS_CHAR,
4540: p_IMPORT_FLAG => FND_API.G_MISS_CHAR,
4541: p_REJECT_REASON_CODE => NULL, --l_reject_reason_code,
4542: p_DELETED_FLAG => FND_API.G_MISS_CHAR,
4543: p_OFFER_ID => FND_API.G_MISS_NUM,
4536: p_TOTAL_SCORE => FND_API.G_MISS_NUM,
4537: p_SCORECARD_ID => FND_API.G_MISS_NUM,
4538: p_KEEP_FLAG => FND_API.G_MISS_CHAR,
4539: p_URGENT_FLAG => FND_API.G_MISS_CHAR,
4540: p_IMPORT_FLAG => FND_API.G_MISS_CHAR,
4541: p_REJECT_REASON_CODE => NULL, --l_reject_reason_code,
4542: p_DELETED_FLAG => FND_API.G_MISS_CHAR,
4543: p_OFFER_ID => FND_API.G_MISS_NUM,
4544: p_QUALIFIED_FLAG => l_qualified_flag,
4538: p_KEEP_FLAG => FND_API.G_MISS_CHAR,
4539: p_URGENT_FLAG => FND_API.G_MISS_CHAR,
4540: p_IMPORT_FLAG => FND_API.G_MISS_CHAR,
4541: p_REJECT_REASON_CODE => NULL, --l_reject_reason_code,
4542: p_DELETED_FLAG => FND_API.G_MISS_CHAR,
4543: p_OFFER_ID => FND_API.G_MISS_NUM,
4544: p_QUALIFIED_FLAG => l_qualified_flag,
4545: p_ORIG_SYSTEM_CODE => FND_API.G_MISS_CHAR,
4546: -- p_SECURITY_GROUP_ID => FND_API.G_MISS_NUM,
4539: p_URGENT_FLAG => FND_API.G_MISS_CHAR,
4540: p_IMPORT_FLAG => FND_API.G_MISS_CHAR,
4541: p_REJECT_REASON_CODE => NULL, --l_reject_reason_code,
4542: p_DELETED_FLAG => FND_API.G_MISS_CHAR,
4543: p_OFFER_ID => FND_API.G_MISS_NUM,
4544: p_QUALIFIED_FLAG => l_qualified_flag,
4545: p_ORIG_SYSTEM_CODE => FND_API.G_MISS_CHAR,
4546: -- p_SECURITY_GROUP_ID => FND_API.G_MISS_NUM,
4547: p_INC_PARTNER_PARTY_ID => FND_API.G_MISS_NUM,
4541: p_REJECT_REASON_CODE => NULL, --l_reject_reason_code,
4542: p_DELETED_FLAG => FND_API.G_MISS_CHAR,
4543: p_OFFER_ID => FND_API.G_MISS_NUM,
4544: p_QUALIFIED_FLAG => l_qualified_flag,
4545: p_ORIG_SYSTEM_CODE => FND_API.G_MISS_CHAR,
4546: -- p_SECURITY_GROUP_ID => FND_API.G_MISS_NUM,
4547: p_INC_PARTNER_PARTY_ID => FND_API.G_MISS_NUM,
4548: p_INC_PARTNER_RESOURCE_ID => FND_API.G_MISS_NUM,
4549: p_PRM_EXEC_SPONSOR_FLAG => FND_API.G_MISS_CHAR,
4542: p_DELETED_FLAG => FND_API.G_MISS_CHAR,
4543: p_OFFER_ID => FND_API.G_MISS_NUM,
4544: p_QUALIFIED_FLAG => l_qualified_flag,
4545: p_ORIG_SYSTEM_CODE => FND_API.G_MISS_CHAR,
4546: -- p_SECURITY_GROUP_ID => FND_API.G_MISS_NUM,
4547: p_INC_PARTNER_PARTY_ID => FND_API.G_MISS_NUM,
4548: p_INC_PARTNER_RESOURCE_ID => FND_API.G_MISS_NUM,
4549: p_PRM_EXEC_SPONSOR_FLAG => FND_API.G_MISS_CHAR,
4550: p_PRM_PRJ_LEAD_IN_PLACE_FLAG => FND_API.G_MISS_CHAR,
4543: p_OFFER_ID => FND_API.G_MISS_NUM,
4544: p_QUALIFIED_FLAG => l_qualified_flag,
4545: p_ORIG_SYSTEM_CODE => FND_API.G_MISS_CHAR,
4546: -- p_SECURITY_GROUP_ID => FND_API.G_MISS_NUM,
4547: p_INC_PARTNER_PARTY_ID => FND_API.G_MISS_NUM,
4548: p_INC_PARTNER_RESOURCE_ID => FND_API.G_MISS_NUM,
4549: p_PRM_EXEC_SPONSOR_FLAG => FND_API.G_MISS_CHAR,
4550: p_PRM_PRJ_LEAD_IN_PLACE_FLAG => FND_API.G_MISS_CHAR,
4551: p_PRM_SALES_LEAD_TYPE => FND_API.G_MISS_CHAR,
4544: p_QUALIFIED_FLAG => l_qualified_flag,
4545: p_ORIG_SYSTEM_CODE => FND_API.G_MISS_CHAR,
4546: -- p_SECURITY_GROUP_ID => FND_API.G_MISS_NUM,
4547: p_INC_PARTNER_PARTY_ID => FND_API.G_MISS_NUM,
4548: p_INC_PARTNER_RESOURCE_ID => FND_API.G_MISS_NUM,
4549: p_PRM_EXEC_SPONSOR_FLAG => FND_API.G_MISS_CHAR,
4550: p_PRM_PRJ_LEAD_IN_PLACE_FLAG => FND_API.G_MISS_CHAR,
4551: p_PRM_SALES_LEAD_TYPE => FND_API.G_MISS_CHAR,
4552: p_PRM_IND_CLASSIFICATION_CODE => FND_API.G_MISS_CHAR,
4545: p_ORIG_SYSTEM_CODE => FND_API.G_MISS_CHAR,
4546: -- p_SECURITY_GROUP_ID => FND_API.G_MISS_NUM,
4547: p_INC_PARTNER_PARTY_ID => FND_API.G_MISS_NUM,
4548: p_INC_PARTNER_RESOURCE_ID => FND_API.G_MISS_NUM,
4549: p_PRM_EXEC_SPONSOR_FLAG => FND_API.G_MISS_CHAR,
4550: p_PRM_PRJ_LEAD_IN_PLACE_FLAG => FND_API.G_MISS_CHAR,
4551: p_PRM_SALES_LEAD_TYPE => FND_API.G_MISS_CHAR,
4552: p_PRM_IND_CLASSIFICATION_CODE => FND_API.G_MISS_CHAR,
4553: p_PRM_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
4546: -- p_SECURITY_GROUP_ID => FND_API.G_MISS_NUM,
4547: p_INC_PARTNER_PARTY_ID => FND_API.G_MISS_NUM,
4548: p_INC_PARTNER_RESOURCE_ID => FND_API.G_MISS_NUM,
4549: p_PRM_EXEC_SPONSOR_FLAG => FND_API.G_MISS_CHAR,
4550: p_PRM_PRJ_LEAD_IN_PLACE_FLAG => FND_API.G_MISS_CHAR,
4551: p_PRM_SALES_LEAD_TYPE => FND_API.G_MISS_CHAR,
4552: p_PRM_IND_CLASSIFICATION_CODE => FND_API.G_MISS_CHAR,
4553: p_PRM_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
4554: p_AUTO_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
4547: p_INC_PARTNER_PARTY_ID => FND_API.G_MISS_NUM,
4548: p_INC_PARTNER_RESOURCE_ID => FND_API.G_MISS_NUM,
4549: p_PRM_EXEC_SPONSOR_FLAG => FND_API.G_MISS_CHAR,
4550: p_PRM_PRJ_LEAD_IN_PLACE_FLAG => FND_API.G_MISS_CHAR,
4551: p_PRM_SALES_LEAD_TYPE => FND_API.G_MISS_CHAR,
4552: p_PRM_IND_CLASSIFICATION_CODE => FND_API.G_MISS_CHAR,
4553: p_PRM_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
4554: p_AUTO_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
4555: p_PRIMARY_CONTACT_PARTY_ID => FND_API.G_MISS_NUM,
4548: p_INC_PARTNER_RESOURCE_ID => FND_API.G_MISS_NUM,
4549: p_PRM_EXEC_SPONSOR_FLAG => FND_API.G_MISS_CHAR,
4550: p_PRM_PRJ_LEAD_IN_PLACE_FLAG => FND_API.G_MISS_CHAR,
4551: p_PRM_SALES_LEAD_TYPE => FND_API.G_MISS_CHAR,
4552: p_PRM_IND_CLASSIFICATION_CODE => FND_API.G_MISS_CHAR,
4553: p_PRM_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
4554: p_AUTO_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
4555: p_PRIMARY_CONTACT_PARTY_ID => FND_API.G_MISS_NUM,
4556: p_PRIMARY_CNT_PERSON_PARTY_ID => FND_API.G_MISS_NUM,
4549: p_PRM_EXEC_SPONSOR_FLAG => FND_API.G_MISS_CHAR,
4550: p_PRM_PRJ_LEAD_IN_PLACE_FLAG => FND_API.G_MISS_CHAR,
4551: p_PRM_SALES_LEAD_TYPE => FND_API.G_MISS_CHAR,
4552: p_PRM_IND_CLASSIFICATION_CODE => FND_API.G_MISS_CHAR,
4553: p_PRM_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
4554: p_AUTO_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
4555: p_PRIMARY_CONTACT_PARTY_ID => FND_API.G_MISS_NUM,
4556: p_PRIMARY_CNT_PERSON_PARTY_ID => FND_API.G_MISS_NUM,
4557: p_PRIMARY_CONTACT_PHONE_ID => FND_API.G_MISS_NUM,
4550: p_PRM_PRJ_LEAD_IN_PLACE_FLAG => FND_API.G_MISS_CHAR,
4551: p_PRM_SALES_LEAD_TYPE => FND_API.G_MISS_CHAR,
4552: p_PRM_IND_CLASSIFICATION_CODE => FND_API.G_MISS_CHAR,
4553: p_PRM_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
4554: p_AUTO_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
4555: p_PRIMARY_CONTACT_PARTY_ID => FND_API.G_MISS_NUM,
4556: p_PRIMARY_CNT_PERSON_PARTY_ID => FND_API.G_MISS_NUM,
4557: p_PRIMARY_CONTACT_PHONE_ID => FND_API.G_MISS_NUM,
4558: p_REFERRED_BY => FND_API.G_MISS_NUM,
4551: p_PRM_SALES_LEAD_TYPE => FND_API.G_MISS_CHAR,
4552: p_PRM_IND_CLASSIFICATION_CODE => FND_API.G_MISS_CHAR,
4553: p_PRM_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
4554: p_AUTO_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
4555: p_PRIMARY_CONTACT_PARTY_ID => FND_API.G_MISS_NUM,
4556: p_PRIMARY_CNT_PERSON_PARTY_ID => FND_API.G_MISS_NUM,
4557: p_PRIMARY_CONTACT_PHONE_ID => FND_API.G_MISS_NUM,
4558: p_REFERRED_BY => FND_API.G_MISS_NUM,
4559: p_REFERRAL_TYPE => FND_API.G_MISS_CHAR,
4552: p_PRM_IND_CLASSIFICATION_CODE => FND_API.G_MISS_CHAR,
4553: p_PRM_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
4554: p_AUTO_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
4555: p_PRIMARY_CONTACT_PARTY_ID => FND_API.G_MISS_NUM,
4556: p_PRIMARY_CNT_PERSON_PARTY_ID => FND_API.G_MISS_NUM,
4557: p_PRIMARY_CONTACT_PHONE_ID => FND_API.G_MISS_NUM,
4558: p_REFERRED_BY => FND_API.G_MISS_NUM,
4559: p_REFERRAL_TYPE => FND_API.G_MISS_CHAR,
4560: p_REFERRAL_STATUS => FND_API.G_MISS_CHAR,
4553: p_PRM_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
4554: p_AUTO_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
4555: p_PRIMARY_CONTACT_PARTY_ID => FND_API.G_MISS_NUM,
4556: p_PRIMARY_CNT_PERSON_PARTY_ID => FND_API.G_MISS_NUM,
4557: p_PRIMARY_CONTACT_PHONE_ID => FND_API.G_MISS_NUM,
4558: p_REFERRED_BY => FND_API.G_MISS_NUM,
4559: p_REFERRAL_TYPE => FND_API.G_MISS_CHAR,
4560: p_REFERRAL_STATUS => FND_API.G_MISS_CHAR,
4561: p_REF_DECLINE_REASON => FND_API.G_MISS_CHAR,
4554: p_AUTO_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
4555: p_PRIMARY_CONTACT_PARTY_ID => FND_API.G_MISS_NUM,
4556: p_PRIMARY_CNT_PERSON_PARTY_ID => FND_API.G_MISS_NUM,
4557: p_PRIMARY_CONTACT_PHONE_ID => FND_API.G_MISS_NUM,
4558: p_REFERRED_BY => FND_API.G_MISS_NUM,
4559: p_REFERRAL_TYPE => FND_API.G_MISS_CHAR,
4560: p_REFERRAL_STATUS => FND_API.G_MISS_CHAR,
4561: p_REF_DECLINE_REASON => FND_API.G_MISS_CHAR,
4562: p_REF_COMM_LTR_STATUS => FND_API.G_MISS_CHAR,
4555: p_PRIMARY_CONTACT_PARTY_ID => FND_API.G_MISS_NUM,
4556: p_PRIMARY_CNT_PERSON_PARTY_ID => FND_API.G_MISS_NUM,
4557: p_PRIMARY_CONTACT_PHONE_ID => FND_API.G_MISS_NUM,
4558: p_REFERRED_BY => FND_API.G_MISS_NUM,
4559: p_REFERRAL_TYPE => FND_API.G_MISS_CHAR,
4560: p_REFERRAL_STATUS => FND_API.G_MISS_CHAR,
4561: p_REF_DECLINE_REASON => FND_API.G_MISS_CHAR,
4562: p_REF_COMM_LTR_STATUS => FND_API.G_MISS_CHAR,
4563: p_REF_ORDER_NUMBER => FND_API.G_MISS_NUM,
4556: p_PRIMARY_CNT_PERSON_PARTY_ID => FND_API.G_MISS_NUM,
4557: p_PRIMARY_CONTACT_PHONE_ID => FND_API.G_MISS_NUM,
4558: p_REFERRED_BY => FND_API.G_MISS_NUM,
4559: p_REFERRAL_TYPE => FND_API.G_MISS_CHAR,
4560: p_REFERRAL_STATUS => FND_API.G_MISS_CHAR,
4561: p_REF_DECLINE_REASON => FND_API.G_MISS_CHAR,
4562: p_REF_COMM_LTR_STATUS => FND_API.G_MISS_CHAR,
4563: p_REF_ORDER_NUMBER => FND_API.G_MISS_NUM,
4564: p_REF_ORDER_AMT => FND_API.G_MISS_NUM,
4557: p_PRIMARY_CONTACT_PHONE_ID => FND_API.G_MISS_NUM,
4558: p_REFERRED_BY => FND_API.G_MISS_NUM,
4559: p_REFERRAL_TYPE => FND_API.G_MISS_CHAR,
4560: p_REFERRAL_STATUS => FND_API.G_MISS_CHAR,
4561: p_REF_DECLINE_REASON => FND_API.G_MISS_CHAR,
4562: p_REF_COMM_LTR_STATUS => FND_API.G_MISS_CHAR,
4563: p_REF_ORDER_NUMBER => FND_API.G_MISS_NUM,
4564: p_REF_ORDER_AMT => FND_API.G_MISS_NUM,
4565: p_REF_COMM_AMT => FND_API.G_MISS_NUM,
4558: p_REFERRED_BY => FND_API.G_MISS_NUM,
4559: p_REFERRAL_TYPE => FND_API.G_MISS_CHAR,
4560: p_REFERRAL_STATUS => FND_API.G_MISS_CHAR,
4561: p_REF_DECLINE_REASON => FND_API.G_MISS_CHAR,
4562: p_REF_COMM_LTR_STATUS => FND_API.G_MISS_CHAR,
4563: p_REF_ORDER_NUMBER => FND_API.G_MISS_NUM,
4564: p_REF_ORDER_AMT => FND_API.G_MISS_NUM,
4565: p_REF_COMM_AMT => FND_API.G_MISS_NUM,
4566: -- bug No.2341515, 2368075
4559: p_REFERRAL_TYPE => FND_API.G_MISS_CHAR,
4560: p_REFERRAL_STATUS => FND_API.G_MISS_CHAR,
4561: p_REF_DECLINE_REASON => FND_API.G_MISS_CHAR,
4562: p_REF_COMM_LTR_STATUS => FND_API.G_MISS_CHAR,
4563: p_REF_ORDER_NUMBER => FND_API.G_MISS_NUM,
4564: p_REF_ORDER_AMT => FND_API.G_MISS_NUM,
4565: p_REF_COMM_AMT => FND_API.G_MISS_NUM,
4566: -- bug No.2341515, 2368075
4567: p_LEAD_DATE => FND_API.G_MISS_DATE,
4560: p_REFERRAL_STATUS => FND_API.G_MISS_CHAR,
4561: p_REF_DECLINE_REASON => FND_API.G_MISS_CHAR,
4562: p_REF_COMM_LTR_STATUS => FND_API.G_MISS_CHAR,
4563: p_REF_ORDER_NUMBER => FND_API.G_MISS_NUM,
4564: p_REF_ORDER_AMT => FND_API.G_MISS_NUM,
4565: p_REF_COMM_AMT => FND_API.G_MISS_NUM,
4566: -- bug No.2341515, 2368075
4567: p_LEAD_DATE => FND_API.G_MISS_DATE,
4568: p_SOURCE_SYSTEM => FND_API.G_MISS_CHAR,
4561: p_REF_DECLINE_REASON => FND_API.G_MISS_CHAR,
4562: p_REF_COMM_LTR_STATUS => FND_API.G_MISS_CHAR,
4563: p_REF_ORDER_NUMBER => FND_API.G_MISS_NUM,
4564: p_REF_ORDER_AMT => FND_API.G_MISS_NUM,
4565: p_REF_COMM_AMT => FND_API.G_MISS_NUM,
4566: -- bug No.2341515, 2368075
4567: p_LEAD_DATE => FND_API.G_MISS_DATE,
4568: p_SOURCE_SYSTEM => FND_API.G_MISS_CHAR,
4569: p_COUNTRY => FND_API.G_MISS_CHAR,
4563: p_REF_ORDER_NUMBER => FND_API.G_MISS_NUM,
4564: p_REF_ORDER_AMT => FND_API.G_MISS_NUM,
4565: p_REF_COMM_AMT => FND_API.G_MISS_NUM,
4566: -- bug No.2341515, 2368075
4567: p_LEAD_DATE => FND_API.G_MISS_DATE,
4568: p_SOURCE_SYSTEM => FND_API.G_MISS_CHAR,
4569: p_COUNTRY => FND_API.G_MISS_CHAR,
4570: p_TOTAL_AMOUNT => FND_API.G_MISS_NUM,
4571: p_EXPIRATION_DATE => FND_API.G_MISS_DATE,
4564: p_REF_ORDER_AMT => FND_API.G_MISS_NUM,
4565: p_REF_COMM_AMT => FND_API.G_MISS_NUM,
4566: -- bug No.2341515, 2368075
4567: p_LEAD_DATE => FND_API.G_MISS_DATE,
4568: p_SOURCE_SYSTEM => FND_API.G_MISS_CHAR,
4569: p_COUNTRY => FND_API.G_MISS_CHAR,
4570: p_TOTAL_AMOUNT => FND_API.G_MISS_NUM,
4571: p_EXPIRATION_DATE => FND_API.G_MISS_DATE,
4572: p_LEAD_RANK_IND => FND_API.G_MISS_CHAR,
4565: p_REF_COMM_AMT => FND_API.G_MISS_NUM,
4566: -- bug No.2341515, 2368075
4567: p_LEAD_DATE => FND_API.G_MISS_DATE,
4568: p_SOURCE_SYSTEM => FND_API.G_MISS_CHAR,
4569: p_COUNTRY => FND_API.G_MISS_CHAR,
4570: p_TOTAL_AMOUNT => FND_API.G_MISS_NUM,
4571: p_EXPIRATION_DATE => FND_API.G_MISS_DATE,
4572: p_LEAD_RANK_IND => FND_API.G_MISS_CHAR,
4573: p_LEAD_ENGINE_RUN_DATE => FND_API.G_MISS_DATE,
4566: -- bug No.2341515, 2368075
4567: p_LEAD_DATE => FND_API.G_MISS_DATE,
4568: p_SOURCE_SYSTEM => FND_API.G_MISS_CHAR,
4569: p_COUNTRY => FND_API.G_MISS_CHAR,
4570: p_TOTAL_AMOUNT => FND_API.G_MISS_NUM,
4571: p_EXPIRATION_DATE => FND_API.G_MISS_DATE,
4572: p_LEAD_RANK_IND => FND_API.G_MISS_CHAR,
4573: p_LEAD_ENGINE_RUN_DATE => FND_API.G_MISS_DATE,
4574: p_CURRENT_REROUTES => FND_API.G_MISS_NUM,
4567: p_LEAD_DATE => FND_API.G_MISS_DATE,
4568: p_SOURCE_SYSTEM => FND_API.G_MISS_CHAR,
4569: p_COUNTRY => FND_API.G_MISS_CHAR,
4570: p_TOTAL_AMOUNT => FND_API.G_MISS_NUM,
4571: p_EXPIRATION_DATE => FND_API.G_MISS_DATE,
4572: p_LEAD_RANK_IND => FND_API.G_MISS_CHAR,
4573: p_LEAD_ENGINE_RUN_DATE => FND_API.G_MISS_DATE,
4574: p_CURRENT_REROUTES => FND_API.G_MISS_NUM,
4575: p_STATUS_OPEN_FLAG => FND_API.G_MISS_CHAR,
4568: p_SOURCE_SYSTEM => FND_API.G_MISS_CHAR,
4569: p_COUNTRY => FND_API.G_MISS_CHAR,
4570: p_TOTAL_AMOUNT => FND_API.G_MISS_NUM,
4571: p_EXPIRATION_DATE => FND_API.G_MISS_DATE,
4572: p_LEAD_RANK_IND => FND_API.G_MISS_CHAR,
4573: p_LEAD_ENGINE_RUN_DATE => FND_API.G_MISS_DATE,
4574: p_CURRENT_REROUTES => FND_API.G_MISS_NUM,
4575: p_STATUS_OPEN_FLAG => FND_API.G_MISS_CHAR,
4576: p_LEAD_RANK_SCORE => FND_API.G_MISS_NUM,
4569: p_COUNTRY => FND_API.G_MISS_CHAR,
4570: p_TOTAL_AMOUNT => FND_API.G_MISS_NUM,
4571: p_EXPIRATION_DATE => FND_API.G_MISS_DATE,
4572: p_LEAD_RANK_IND => FND_API.G_MISS_CHAR,
4573: p_LEAD_ENGINE_RUN_DATE => FND_API.G_MISS_DATE,
4574: p_CURRENT_REROUTES => FND_API.G_MISS_NUM,
4575: p_STATUS_OPEN_FLAG => FND_API.G_MISS_CHAR,
4576: p_LEAD_RANK_SCORE => FND_API.G_MISS_NUM,
4577: -- 11.5.10 new columns
4570: p_TOTAL_AMOUNT => FND_API.G_MISS_NUM,
4571: p_EXPIRATION_DATE => FND_API.G_MISS_DATE,
4572: p_LEAD_RANK_IND => FND_API.G_MISS_CHAR,
4573: p_LEAD_ENGINE_RUN_DATE => FND_API.G_MISS_DATE,
4574: p_CURRENT_REROUTES => FND_API.G_MISS_NUM,
4575: p_STATUS_OPEN_FLAG => FND_API.G_MISS_CHAR,
4576: p_LEAD_RANK_SCORE => FND_API.G_MISS_NUM,
4577: -- 11.5.10 new columns
4578: p_MARKETING_SCORE => FND_API.G_MISS_NUM,
4571: p_EXPIRATION_DATE => FND_API.G_MISS_DATE,
4572: p_LEAD_RANK_IND => FND_API.G_MISS_CHAR,
4573: p_LEAD_ENGINE_RUN_DATE => FND_API.G_MISS_DATE,
4574: p_CURRENT_REROUTES => FND_API.G_MISS_NUM,
4575: p_STATUS_OPEN_FLAG => FND_API.G_MISS_CHAR,
4576: p_LEAD_RANK_SCORE => FND_API.G_MISS_NUM,
4577: -- 11.5.10 new columns
4578: p_MARKETING_SCORE => FND_API.G_MISS_NUM,
4579: p_INTERACTION_SCORE => FND_API.G_MISS_NUM,
4572: p_LEAD_RANK_IND => FND_API.G_MISS_CHAR,
4573: p_LEAD_ENGINE_RUN_DATE => FND_API.G_MISS_DATE,
4574: p_CURRENT_REROUTES => FND_API.G_MISS_NUM,
4575: p_STATUS_OPEN_FLAG => FND_API.G_MISS_CHAR,
4576: p_LEAD_RANK_SCORE => FND_API.G_MISS_NUM,
4577: -- 11.5.10 new columns
4578: p_MARKETING_SCORE => FND_API.G_MISS_NUM,
4579: p_INTERACTION_SCORE => FND_API.G_MISS_NUM,
4580: p_SOURCE_PRIMARY_REFERENCE => FND_API.G_MISS_CHAR,
4574: p_CURRENT_REROUTES => FND_API.G_MISS_NUM,
4575: p_STATUS_OPEN_FLAG => FND_API.G_MISS_CHAR,
4576: p_LEAD_RANK_SCORE => FND_API.G_MISS_NUM,
4577: -- 11.5.10 new columns
4578: p_MARKETING_SCORE => FND_API.G_MISS_NUM,
4579: p_INTERACTION_SCORE => FND_API.G_MISS_NUM,
4580: p_SOURCE_PRIMARY_REFERENCE => FND_API.G_MISS_CHAR,
4581: p_SOURCE_SECONDARY_REFERENCE => FND_API.G_MISS_CHAR,
4582: p_SALES_METHODOLOGY_ID => FND_API.G_MISS_NUM,
4575: p_STATUS_OPEN_FLAG => FND_API.G_MISS_CHAR,
4576: p_LEAD_RANK_SCORE => FND_API.G_MISS_NUM,
4577: -- 11.5.10 new columns
4578: p_MARKETING_SCORE => FND_API.G_MISS_NUM,
4579: p_INTERACTION_SCORE => FND_API.G_MISS_NUM,
4580: p_SOURCE_PRIMARY_REFERENCE => FND_API.G_MISS_CHAR,
4581: p_SOURCE_SECONDARY_REFERENCE => FND_API.G_MISS_CHAR,
4582: p_SALES_METHODOLOGY_ID => FND_API.G_MISS_NUM,
4583: p_SALES_STAGE_ID => FND_API.G_MISS_NUM);
4576: p_LEAD_RANK_SCORE => FND_API.G_MISS_NUM,
4577: -- 11.5.10 new columns
4578: p_MARKETING_SCORE => FND_API.G_MISS_NUM,
4579: p_INTERACTION_SCORE => FND_API.G_MISS_NUM,
4580: p_SOURCE_PRIMARY_REFERENCE => FND_API.G_MISS_CHAR,
4581: p_SOURCE_SECONDARY_REFERENCE => FND_API.G_MISS_CHAR,
4582: p_SALES_METHODOLOGY_ID => FND_API.G_MISS_NUM,
4583: p_SALES_STAGE_ID => FND_API.G_MISS_NUM);
4584:
4577: -- 11.5.10 new columns
4578: p_MARKETING_SCORE => FND_API.G_MISS_NUM,
4579: p_INTERACTION_SCORE => FND_API.G_MISS_NUM,
4580: p_SOURCE_PRIMARY_REFERENCE => FND_API.G_MISS_CHAR,
4581: p_SOURCE_SECONDARY_REFERENCE => FND_API.G_MISS_CHAR,
4582: p_SALES_METHODOLOGY_ID => FND_API.G_MISS_NUM,
4583: p_SALES_STAGE_ID => FND_API.G_MISS_NUM);
4584:
4585: -- Check whether this resource is in sales team or not
4578: p_MARKETING_SCORE => FND_API.G_MISS_NUM,
4579: p_INTERACTION_SCORE => FND_API.G_MISS_NUM,
4580: p_SOURCE_PRIMARY_REFERENCE => FND_API.G_MISS_CHAR,
4581: p_SOURCE_SECONDARY_REFERENCE => FND_API.G_MISS_CHAR,
4582: p_SALES_METHODOLOGY_ID => FND_API.G_MISS_NUM,
4583: p_SALES_STAGE_ID => FND_API.G_MISS_NUM);
4584:
4585: -- Check whether this resource is in sales team or not
4586: l_access_exist_flag := 'N';
4579: p_INTERACTION_SCORE => FND_API.G_MISS_NUM,
4580: p_SOURCE_PRIMARY_REFERENCE => FND_API.G_MISS_CHAR,
4581: p_SOURCE_SECONDARY_REFERENCE => FND_API.G_MISS_CHAR,
4582: p_SALES_METHODOLOGY_ID => FND_API.G_MISS_NUM,
4583: p_SALES_STAGE_ID => FND_API.G_MISS_NUM);
4584:
4585: -- Check whether this resource is in sales team or not
4586: l_access_exist_flag := 'N';
4587: OPEN c_access_exist(p_sales_lead_id, l_resource_id, l_group_id);
4755: l_sales_lead_rec.sales_lead_id := p_sales_lead_id;
4756:
4757: AS_LEAD_ROUTING_WF_CUHK.Get_Owner_Pre(
4758: p_api_version_number => 2.0,
4759: p_init_msg_list => FND_API.G_FALSE,
4760: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
4761: p_commit => FND_API.G_FALSE,
4762: p_resource_id_tbl => l_resource_id_tbl,
4763: p_group_id_tbl => l_group_id_tbl,
4756:
4757: AS_LEAD_ROUTING_WF_CUHK.Get_Owner_Pre(
4758: p_api_version_number => 2.0,
4759: p_init_msg_list => FND_API.G_FALSE,
4760: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
4761: p_commit => FND_API.G_FALSE,
4762: p_resource_id_tbl => l_resource_id_tbl,
4763: p_group_id_tbl => l_group_id_tbl,
4764: p_person_id_tbl => l_person_id_tbl,
4757: AS_LEAD_ROUTING_WF_CUHK.Get_Owner_Pre(
4758: p_api_version_number => 2.0,
4759: p_init_msg_list => FND_API.G_FALSE,
4760: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
4761: p_commit => FND_API.G_FALSE,
4762: p_resource_id_tbl => l_resource_id_tbl,
4763: p_group_id_tbl => l_group_id_tbl,
4764: p_person_id_tbl => l_person_id_tbl,
4765: p_resource_flag_tbl => l_resource_flag_tbl,
4770: x_return_status => x_return_status,
4771: x_msg_count => x_msg_count,
4772: x_msg_data => x_msg_data);
4773:
4774: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4775: RAISE FND_API.G_EXC_ERROR;
4776: END IF;
4777:
4778: IF l_resource_id IS NULL
4771: x_msg_count => x_msg_count,
4772: x_msg_data => x_msg_data);
4773:
4774: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4775: RAISE FND_API.G_EXC_ERROR;
4776: END IF;
4777:
4778: IF l_resource_id IS NULL
4779: THEN
4826: AS_SALES_LEADS_PKG.Sales_Lead_Update_Row(
4827: p_SALES_LEAD_ID => p_SALES_LEAD_ID,
4828: p_LAST_UPDATE_DATE => SYSDATE,
4829: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
4830: p_CREATION_DATE => FND_API.G_MISS_DATE,
4831: p_CREATED_BY => FND_API.G_MISS_NUM,
4832: p_LAST_UPDATE_LOGIN => FND_API.G_MISS_NUM,
4833: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,
4834: p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id,
4827: p_SALES_LEAD_ID => p_SALES_LEAD_ID,
4828: p_LAST_UPDATE_DATE => SYSDATE,
4829: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
4830: p_CREATION_DATE => FND_API.G_MISS_DATE,
4831: p_CREATED_BY => FND_API.G_MISS_NUM,
4832: p_LAST_UPDATE_LOGIN => FND_API.G_MISS_NUM,
4833: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,
4834: p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id,
4835: p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id,
4828: p_LAST_UPDATE_DATE => SYSDATE,
4829: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
4830: p_CREATION_DATE => FND_API.G_MISS_DATE,
4831: p_CREATED_BY => FND_API.G_MISS_NUM,
4832: p_LAST_UPDATE_LOGIN => FND_API.G_MISS_NUM,
4833: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,
4834: p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id,
4835: p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id,
4836: p_PROGRAM_UPDATE_DATE => SYSDATE,
4833: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,
4834: p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id,
4835: p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id,
4836: p_PROGRAM_UPDATE_DATE => SYSDATE,
4837: p_LEAD_NUMBER => FND_API.G_MISS_CHAR,
4838: p_STATUS_CODE => FND_API.G_MISS_CHAR, --l_routing_status,
4839: p_CUSTOMER_ID => l_CUSTOMER_ID,
4840: p_ADDRESS_ID => l_ADDRESS_ID,
4841: p_SOURCE_PROMOTION_ID => FND_API.G_MISS_NUM,
4834: p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id,
4835: p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id,
4836: p_PROGRAM_UPDATE_DATE => SYSDATE,
4837: p_LEAD_NUMBER => FND_API.G_MISS_CHAR,
4838: p_STATUS_CODE => FND_API.G_MISS_CHAR, --l_routing_status,
4839: p_CUSTOMER_ID => l_CUSTOMER_ID,
4840: p_ADDRESS_ID => l_ADDRESS_ID,
4841: p_SOURCE_PROMOTION_ID => FND_API.G_MISS_NUM,
4842: p_INITIATING_CONTACT_ID => FND_API.G_MISS_NUM,
4837: p_LEAD_NUMBER => FND_API.G_MISS_CHAR,
4838: p_STATUS_CODE => FND_API.G_MISS_CHAR, --l_routing_status,
4839: p_CUSTOMER_ID => l_CUSTOMER_ID,
4840: p_ADDRESS_ID => l_ADDRESS_ID,
4841: p_SOURCE_PROMOTION_ID => FND_API.G_MISS_NUM,
4842: p_INITIATING_CONTACT_ID => FND_API.G_MISS_NUM,
4843: p_ORIG_SYSTEM_REFERENCE => FND_API.G_MISS_CHAR,
4844: p_CONTACT_ROLE_CODE => FND_API.G_MISS_CHAR,
4845: p_CHANNEL_CODE => FND_API.G_MISS_CHAR,
4838: p_STATUS_CODE => FND_API.G_MISS_CHAR, --l_routing_status,
4839: p_CUSTOMER_ID => l_CUSTOMER_ID,
4840: p_ADDRESS_ID => l_ADDRESS_ID,
4841: p_SOURCE_PROMOTION_ID => FND_API.G_MISS_NUM,
4842: p_INITIATING_CONTACT_ID => FND_API.G_MISS_NUM,
4843: p_ORIG_SYSTEM_REFERENCE => FND_API.G_MISS_CHAR,
4844: p_CONTACT_ROLE_CODE => FND_API.G_MISS_CHAR,
4845: p_CHANNEL_CODE => FND_API.G_MISS_CHAR,
4846: p_BUDGET_AMOUNT => FND_API.G_MISS_NUM,
4839: p_CUSTOMER_ID => l_CUSTOMER_ID,
4840: p_ADDRESS_ID => l_ADDRESS_ID,
4841: p_SOURCE_PROMOTION_ID => FND_API.G_MISS_NUM,
4842: p_INITIATING_CONTACT_ID => FND_API.G_MISS_NUM,
4843: p_ORIG_SYSTEM_REFERENCE => FND_API.G_MISS_CHAR,
4844: p_CONTACT_ROLE_CODE => FND_API.G_MISS_CHAR,
4845: p_CHANNEL_CODE => FND_API.G_MISS_CHAR,
4846: p_BUDGET_AMOUNT => FND_API.G_MISS_NUM,
4847: p_CURRENCY_CODE => FND_API.G_MISS_CHAR,
4840: p_ADDRESS_ID => l_ADDRESS_ID,
4841: p_SOURCE_PROMOTION_ID => FND_API.G_MISS_NUM,
4842: p_INITIATING_CONTACT_ID => FND_API.G_MISS_NUM,
4843: p_ORIG_SYSTEM_REFERENCE => FND_API.G_MISS_CHAR,
4844: p_CONTACT_ROLE_CODE => FND_API.G_MISS_CHAR,
4845: p_CHANNEL_CODE => FND_API.G_MISS_CHAR,
4846: p_BUDGET_AMOUNT => FND_API.G_MISS_NUM,
4847: p_CURRENCY_CODE => FND_API.G_MISS_CHAR,
4848: p_DECISION_TIMEFRAME_CODE => FND_API.G_MISS_CHAR,
4841: p_SOURCE_PROMOTION_ID => FND_API.G_MISS_NUM,
4842: p_INITIATING_CONTACT_ID => FND_API.G_MISS_NUM,
4843: p_ORIG_SYSTEM_REFERENCE => FND_API.G_MISS_CHAR,
4844: p_CONTACT_ROLE_CODE => FND_API.G_MISS_CHAR,
4845: p_CHANNEL_CODE => FND_API.G_MISS_CHAR,
4846: p_BUDGET_AMOUNT => FND_API.G_MISS_NUM,
4847: p_CURRENCY_CODE => FND_API.G_MISS_CHAR,
4848: p_DECISION_TIMEFRAME_CODE => FND_API.G_MISS_CHAR,
4849: p_CLOSE_REASON => FND_API.G_MISS_CHAR,
4842: p_INITIATING_CONTACT_ID => FND_API.G_MISS_NUM,
4843: p_ORIG_SYSTEM_REFERENCE => FND_API.G_MISS_CHAR,
4844: p_CONTACT_ROLE_CODE => FND_API.G_MISS_CHAR,
4845: p_CHANNEL_CODE => FND_API.G_MISS_CHAR,
4846: p_BUDGET_AMOUNT => FND_API.G_MISS_NUM,
4847: p_CURRENCY_CODE => FND_API.G_MISS_CHAR,
4848: p_DECISION_TIMEFRAME_CODE => FND_API.G_MISS_CHAR,
4849: p_CLOSE_REASON => FND_API.G_MISS_CHAR,
4850: p_LEAD_RANK_ID => FND_API.G_MISS_NUM,
4843: p_ORIG_SYSTEM_REFERENCE => FND_API.G_MISS_CHAR,
4844: p_CONTACT_ROLE_CODE => FND_API.G_MISS_CHAR,
4845: p_CHANNEL_CODE => FND_API.G_MISS_CHAR,
4846: p_BUDGET_AMOUNT => FND_API.G_MISS_NUM,
4847: p_CURRENCY_CODE => FND_API.G_MISS_CHAR,
4848: p_DECISION_TIMEFRAME_CODE => FND_API.G_MISS_CHAR,
4849: p_CLOSE_REASON => FND_API.G_MISS_CHAR,
4850: p_LEAD_RANK_ID => FND_API.G_MISS_NUM,
4851: p_LEAD_RANK_CODE => FND_API.G_MISS_CHAR,
4844: p_CONTACT_ROLE_CODE => FND_API.G_MISS_CHAR,
4845: p_CHANNEL_CODE => FND_API.G_MISS_CHAR,
4846: p_BUDGET_AMOUNT => FND_API.G_MISS_NUM,
4847: p_CURRENCY_CODE => FND_API.G_MISS_CHAR,
4848: p_DECISION_TIMEFRAME_CODE => FND_API.G_MISS_CHAR,
4849: p_CLOSE_REASON => FND_API.G_MISS_CHAR,
4850: p_LEAD_RANK_ID => FND_API.G_MISS_NUM,
4851: p_LEAD_RANK_CODE => FND_API.G_MISS_CHAR,
4852: p_PARENT_PROJECT => FND_API.G_MISS_CHAR,
4845: p_CHANNEL_CODE => FND_API.G_MISS_CHAR,
4846: p_BUDGET_AMOUNT => FND_API.G_MISS_NUM,
4847: p_CURRENCY_CODE => FND_API.G_MISS_CHAR,
4848: p_DECISION_TIMEFRAME_CODE => FND_API.G_MISS_CHAR,
4849: p_CLOSE_REASON => FND_API.G_MISS_CHAR,
4850: p_LEAD_RANK_ID => FND_API.G_MISS_NUM,
4851: p_LEAD_RANK_CODE => FND_API.G_MISS_CHAR,
4852: p_PARENT_PROJECT => FND_API.G_MISS_CHAR,
4853: p_DESCRIPTION => FND_API.G_MISS_CHAR,
4846: p_BUDGET_AMOUNT => FND_API.G_MISS_NUM,
4847: p_CURRENCY_CODE => FND_API.G_MISS_CHAR,
4848: p_DECISION_TIMEFRAME_CODE => FND_API.G_MISS_CHAR,
4849: p_CLOSE_REASON => FND_API.G_MISS_CHAR,
4850: p_LEAD_RANK_ID => FND_API.G_MISS_NUM,
4851: p_LEAD_RANK_CODE => FND_API.G_MISS_CHAR,
4852: p_PARENT_PROJECT => FND_API.G_MISS_CHAR,
4853: p_DESCRIPTION => FND_API.G_MISS_CHAR,
4854: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
4847: p_CURRENCY_CODE => FND_API.G_MISS_CHAR,
4848: p_DECISION_TIMEFRAME_CODE => FND_API.G_MISS_CHAR,
4849: p_CLOSE_REASON => FND_API.G_MISS_CHAR,
4850: p_LEAD_RANK_ID => FND_API.G_MISS_NUM,
4851: p_LEAD_RANK_CODE => FND_API.G_MISS_CHAR,
4852: p_PARENT_PROJECT => FND_API.G_MISS_CHAR,
4853: p_DESCRIPTION => FND_API.G_MISS_CHAR,
4854: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
4855: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
4848: p_DECISION_TIMEFRAME_CODE => FND_API.G_MISS_CHAR,
4849: p_CLOSE_REASON => FND_API.G_MISS_CHAR,
4850: p_LEAD_RANK_ID => FND_API.G_MISS_NUM,
4851: p_LEAD_RANK_CODE => FND_API.G_MISS_CHAR,
4852: p_PARENT_PROJECT => FND_API.G_MISS_CHAR,
4853: p_DESCRIPTION => FND_API.G_MISS_CHAR,
4854: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
4855: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
4856: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
4849: p_CLOSE_REASON => FND_API.G_MISS_CHAR,
4850: p_LEAD_RANK_ID => FND_API.G_MISS_NUM,
4851: p_LEAD_RANK_CODE => FND_API.G_MISS_CHAR,
4852: p_PARENT_PROJECT => FND_API.G_MISS_CHAR,
4853: p_DESCRIPTION => FND_API.G_MISS_CHAR,
4854: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
4855: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
4856: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
4857: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
4850: p_LEAD_RANK_ID => FND_API.G_MISS_NUM,
4851: p_LEAD_RANK_CODE => FND_API.G_MISS_CHAR,
4852: p_PARENT_PROJECT => FND_API.G_MISS_CHAR,
4853: p_DESCRIPTION => FND_API.G_MISS_CHAR,
4854: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
4855: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
4856: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
4857: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
4858: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
4851: p_LEAD_RANK_CODE => FND_API.G_MISS_CHAR,
4852: p_PARENT_PROJECT => FND_API.G_MISS_CHAR,
4853: p_DESCRIPTION => FND_API.G_MISS_CHAR,
4854: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
4855: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
4856: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
4857: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
4858: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
4859: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
4852: p_PARENT_PROJECT => FND_API.G_MISS_CHAR,
4853: p_DESCRIPTION => FND_API.G_MISS_CHAR,
4854: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
4855: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
4856: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
4857: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
4858: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
4859: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
4860: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
4853: p_DESCRIPTION => FND_API.G_MISS_CHAR,
4854: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
4855: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
4856: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
4857: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
4858: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
4859: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
4860: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
4861: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
4854: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
4855: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
4856: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
4857: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
4858: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
4859: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
4860: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
4861: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
4862: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
4855: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
4856: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
4857: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
4858: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
4859: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
4860: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
4861: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
4862: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
4863: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
4856: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
4857: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
4858: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
4859: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
4860: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
4861: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
4862: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
4863: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
4864: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
4857: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
4858: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
4859: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
4860: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
4861: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
4862: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
4863: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
4864: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
4865: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
4858: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
4859: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
4860: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
4861: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
4862: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
4863: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
4864: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
4865: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
4866: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
4859: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
4860: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
4861: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
4862: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
4863: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
4864: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
4865: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
4866: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
4867: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
4860: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
4861: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
4862: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
4863: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
4864: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
4865: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
4866: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
4867: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
4868: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
4861: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
4862: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
4863: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
4864: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
4865: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
4866: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
4867: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
4868: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
4869: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
4862: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
4863: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
4864: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
4865: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
4866: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
4867: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
4868: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
4869: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
4870: p_ASSIGN_TO_PERSON_ID => l_person_id,
4863: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
4864: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
4865: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
4866: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
4867: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
4868: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
4869: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
4870: p_ASSIGN_TO_PERSON_ID => l_person_id,
4871: p_ASSIGN_TO_SALESFORCE_ID => l_resource_id,
4864: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
4865: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
4866: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
4867: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
4868: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
4869: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
4870: p_ASSIGN_TO_PERSON_ID => l_person_id,
4871: p_ASSIGN_TO_SALESFORCE_ID => l_resource_id,
4872: p_ASSIGN_SALES_GROUP_ID => l_group_id,
4865: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
4866: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
4867: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
4868: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
4869: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
4870: p_ASSIGN_TO_PERSON_ID => l_person_id,
4871: p_ASSIGN_TO_SALESFORCE_ID => l_resource_id,
4872: p_ASSIGN_SALES_GROUP_ID => l_group_id,
4873: p_ASSIGN_DATE => SYSDATE,
4870: p_ASSIGN_TO_PERSON_ID => l_person_id,
4871: p_ASSIGN_TO_SALESFORCE_ID => l_resource_id,
4872: p_ASSIGN_SALES_GROUP_ID => l_group_id,
4873: p_ASSIGN_DATE => SYSDATE,
4874: p_BUDGET_STATUS_CODE => FND_API.G_MISS_CHAR,
4875: p_ACCEPT_FLAG => 'N',
4876: p_VEHICLE_RESPONSE_CODE => FND_API.G_MISS_CHAR,
4877: p_TOTAL_SCORE => FND_API.G_MISS_NUM,
4878: p_SCORECARD_ID => FND_API.G_MISS_NUM,
4872: p_ASSIGN_SALES_GROUP_ID => l_group_id,
4873: p_ASSIGN_DATE => SYSDATE,
4874: p_BUDGET_STATUS_CODE => FND_API.G_MISS_CHAR,
4875: p_ACCEPT_FLAG => 'N',
4876: p_VEHICLE_RESPONSE_CODE => FND_API.G_MISS_CHAR,
4877: p_TOTAL_SCORE => FND_API.G_MISS_NUM,
4878: p_SCORECARD_ID => FND_API.G_MISS_NUM,
4879: p_KEEP_FLAG => FND_API.G_MISS_CHAR,
4880: p_URGENT_FLAG => FND_API.G_MISS_CHAR,
4873: p_ASSIGN_DATE => SYSDATE,
4874: p_BUDGET_STATUS_CODE => FND_API.G_MISS_CHAR,
4875: p_ACCEPT_FLAG => 'N',
4876: p_VEHICLE_RESPONSE_CODE => FND_API.G_MISS_CHAR,
4877: p_TOTAL_SCORE => FND_API.G_MISS_NUM,
4878: p_SCORECARD_ID => FND_API.G_MISS_NUM,
4879: p_KEEP_FLAG => FND_API.G_MISS_CHAR,
4880: p_URGENT_FLAG => FND_API.G_MISS_CHAR,
4881: p_IMPORT_FLAG => FND_API.G_MISS_CHAR,
4874: p_BUDGET_STATUS_CODE => FND_API.G_MISS_CHAR,
4875: p_ACCEPT_FLAG => 'N',
4876: p_VEHICLE_RESPONSE_CODE => FND_API.G_MISS_CHAR,
4877: p_TOTAL_SCORE => FND_API.G_MISS_NUM,
4878: p_SCORECARD_ID => FND_API.G_MISS_NUM,
4879: p_KEEP_FLAG => FND_API.G_MISS_CHAR,
4880: p_URGENT_FLAG => FND_API.G_MISS_CHAR,
4881: p_IMPORT_FLAG => FND_API.G_MISS_CHAR,
4882: p_REJECT_REASON_CODE => NULL, --l_reject_reason_code,
4875: p_ACCEPT_FLAG => 'N',
4876: p_VEHICLE_RESPONSE_CODE => FND_API.G_MISS_CHAR,
4877: p_TOTAL_SCORE => FND_API.G_MISS_NUM,
4878: p_SCORECARD_ID => FND_API.G_MISS_NUM,
4879: p_KEEP_FLAG => FND_API.G_MISS_CHAR,
4880: p_URGENT_FLAG => FND_API.G_MISS_CHAR,
4881: p_IMPORT_FLAG => FND_API.G_MISS_CHAR,
4882: p_REJECT_REASON_CODE => NULL, --l_reject_reason_code,
4883: p_DELETED_FLAG => FND_API.G_MISS_CHAR,
4876: p_VEHICLE_RESPONSE_CODE => FND_API.G_MISS_CHAR,
4877: p_TOTAL_SCORE => FND_API.G_MISS_NUM,
4878: p_SCORECARD_ID => FND_API.G_MISS_NUM,
4879: p_KEEP_FLAG => FND_API.G_MISS_CHAR,
4880: p_URGENT_FLAG => FND_API.G_MISS_CHAR,
4881: p_IMPORT_FLAG => FND_API.G_MISS_CHAR,
4882: p_REJECT_REASON_CODE => NULL, --l_reject_reason_code,
4883: p_DELETED_FLAG => FND_API.G_MISS_CHAR,
4884: p_OFFER_ID => FND_API.G_MISS_NUM,
4877: p_TOTAL_SCORE => FND_API.G_MISS_NUM,
4878: p_SCORECARD_ID => FND_API.G_MISS_NUM,
4879: p_KEEP_FLAG => FND_API.G_MISS_CHAR,
4880: p_URGENT_FLAG => FND_API.G_MISS_CHAR,
4881: p_IMPORT_FLAG => FND_API.G_MISS_CHAR,
4882: p_REJECT_REASON_CODE => NULL, --l_reject_reason_code,
4883: p_DELETED_FLAG => FND_API.G_MISS_CHAR,
4884: p_OFFER_ID => FND_API.G_MISS_NUM,
4885: p_QUALIFIED_FLAG => l_qualified_flag,
4879: p_KEEP_FLAG => FND_API.G_MISS_CHAR,
4880: p_URGENT_FLAG => FND_API.G_MISS_CHAR,
4881: p_IMPORT_FLAG => FND_API.G_MISS_CHAR,
4882: p_REJECT_REASON_CODE => NULL, --l_reject_reason_code,
4883: p_DELETED_FLAG => FND_API.G_MISS_CHAR,
4884: p_OFFER_ID => FND_API.G_MISS_NUM,
4885: p_QUALIFIED_FLAG => l_qualified_flag,
4886: p_ORIG_SYSTEM_CODE => FND_API.G_MISS_CHAR,
4887: -- p_SECURITY_GROUP_ID => FND_API.G_MISS_NUM,
4880: p_URGENT_FLAG => FND_API.G_MISS_CHAR,
4881: p_IMPORT_FLAG => FND_API.G_MISS_CHAR,
4882: p_REJECT_REASON_CODE => NULL, --l_reject_reason_code,
4883: p_DELETED_FLAG => FND_API.G_MISS_CHAR,
4884: p_OFFER_ID => FND_API.G_MISS_NUM,
4885: p_QUALIFIED_FLAG => l_qualified_flag,
4886: p_ORIG_SYSTEM_CODE => FND_API.G_MISS_CHAR,
4887: -- p_SECURITY_GROUP_ID => FND_API.G_MISS_NUM,
4888: p_INC_PARTNER_PARTY_ID => FND_API.G_MISS_NUM,
4882: p_REJECT_REASON_CODE => NULL, --l_reject_reason_code,
4883: p_DELETED_FLAG => FND_API.G_MISS_CHAR,
4884: p_OFFER_ID => FND_API.G_MISS_NUM,
4885: p_QUALIFIED_FLAG => l_qualified_flag,
4886: p_ORIG_SYSTEM_CODE => FND_API.G_MISS_CHAR,
4887: -- p_SECURITY_GROUP_ID => FND_API.G_MISS_NUM,
4888: p_INC_PARTNER_PARTY_ID => FND_API.G_MISS_NUM,
4889: p_INC_PARTNER_RESOURCE_ID => FND_API.G_MISS_NUM,
4890: p_PRM_EXEC_SPONSOR_FLAG => FND_API.G_MISS_CHAR,
4883: p_DELETED_FLAG => FND_API.G_MISS_CHAR,
4884: p_OFFER_ID => FND_API.G_MISS_NUM,
4885: p_QUALIFIED_FLAG => l_qualified_flag,
4886: p_ORIG_SYSTEM_CODE => FND_API.G_MISS_CHAR,
4887: -- p_SECURITY_GROUP_ID => FND_API.G_MISS_NUM,
4888: p_INC_PARTNER_PARTY_ID => FND_API.G_MISS_NUM,
4889: p_INC_PARTNER_RESOURCE_ID => FND_API.G_MISS_NUM,
4890: p_PRM_EXEC_SPONSOR_FLAG => FND_API.G_MISS_CHAR,
4891: p_PRM_PRJ_LEAD_IN_PLACE_FLAG => FND_API.G_MISS_CHAR,
4884: p_OFFER_ID => FND_API.G_MISS_NUM,
4885: p_QUALIFIED_FLAG => l_qualified_flag,
4886: p_ORIG_SYSTEM_CODE => FND_API.G_MISS_CHAR,
4887: -- p_SECURITY_GROUP_ID => FND_API.G_MISS_NUM,
4888: p_INC_PARTNER_PARTY_ID => FND_API.G_MISS_NUM,
4889: p_INC_PARTNER_RESOURCE_ID => FND_API.G_MISS_NUM,
4890: p_PRM_EXEC_SPONSOR_FLAG => FND_API.G_MISS_CHAR,
4891: p_PRM_PRJ_LEAD_IN_PLACE_FLAG => FND_API.G_MISS_CHAR,
4892: p_PRM_SALES_LEAD_TYPE => FND_API.G_MISS_CHAR,
4885: p_QUALIFIED_FLAG => l_qualified_flag,
4886: p_ORIG_SYSTEM_CODE => FND_API.G_MISS_CHAR,
4887: -- p_SECURITY_GROUP_ID => FND_API.G_MISS_NUM,
4888: p_INC_PARTNER_PARTY_ID => FND_API.G_MISS_NUM,
4889: p_INC_PARTNER_RESOURCE_ID => FND_API.G_MISS_NUM,
4890: p_PRM_EXEC_SPONSOR_FLAG => FND_API.G_MISS_CHAR,
4891: p_PRM_PRJ_LEAD_IN_PLACE_FLAG => FND_API.G_MISS_CHAR,
4892: p_PRM_SALES_LEAD_TYPE => FND_API.G_MISS_CHAR,
4893: p_PRM_IND_CLASSIFICATION_CODE => FND_API.G_MISS_CHAR,
4886: p_ORIG_SYSTEM_CODE => FND_API.G_MISS_CHAR,
4887: -- p_SECURITY_GROUP_ID => FND_API.G_MISS_NUM,
4888: p_INC_PARTNER_PARTY_ID => FND_API.G_MISS_NUM,
4889: p_INC_PARTNER_RESOURCE_ID => FND_API.G_MISS_NUM,
4890: p_PRM_EXEC_SPONSOR_FLAG => FND_API.G_MISS_CHAR,
4891: p_PRM_PRJ_LEAD_IN_PLACE_FLAG => FND_API.G_MISS_CHAR,
4892: p_PRM_SALES_LEAD_TYPE => FND_API.G_MISS_CHAR,
4893: p_PRM_IND_CLASSIFICATION_CODE => FND_API.G_MISS_CHAR,
4894: p_PRM_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
4887: -- p_SECURITY_GROUP_ID => FND_API.G_MISS_NUM,
4888: p_INC_PARTNER_PARTY_ID => FND_API.G_MISS_NUM,
4889: p_INC_PARTNER_RESOURCE_ID => FND_API.G_MISS_NUM,
4890: p_PRM_EXEC_SPONSOR_FLAG => FND_API.G_MISS_CHAR,
4891: p_PRM_PRJ_LEAD_IN_PLACE_FLAG => FND_API.G_MISS_CHAR,
4892: p_PRM_SALES_LEAD_TYPE => FND_API.G_MISS_CHAR,
4893: p_PRM_IND_CLASSIFICATION_CODE => FND_API.G_MISS_CHAR,
4894: p_PRM_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
4895: p_AUTO_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
4888: p_INC_PARTNER_PARTY_ID => FND_API.G_MISS_NUM,
4889: p_INC_PARTNER_RESOURCE_ID => FND_API.G_MISS_NUM,
4890: p_PRM_EXEC_SPONSOR_FLAG => FND_API.G_MISS_CHAR,
4891: p_PRM_PRJ_LEAD_IN_PLACE_FLAG => FND_API.G_MISS_CHAR,
4892: p_PRM_SALES_LEAD_TYPE => FND_API.G_MISS_CHAR,
4893: p_PRM_IND_CLASSIFICATION_CODE => FND_API.G_MISS_CHAR,
4894: p_PRM_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
4895: p_AUTO_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
4896: p_PRIMARY_CONTACT_PARTY_ID => FND_API.G_MISS_NUM,
4889: p_INC_PARTNER_RESOURCE_ID => FND_API.G_MISS_NUM,
4890: p_PRM_EXEC_SPONSOR_FLAG => FND_API.G_MISS_CHAR,
4891: p_PRM_PRJ_LEAD_IN_PLACE_FLAG => FND_API.G_MISS_CHAR,
4892: p_PRM_SALES_LEAD_TYPE => FND_API.G_MISS_CHAR,
4893: p_PRM_IND_CLASSIFICATION_CODE => FND_API.G_MISS_CHAR,
4894: p_PRM_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
4895: p_AUTO_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
4896: p_PRIMARY_CONTACT_PARTY_ID => FND_API.G_MISS_NUM,
4897: p_PRIMARY_CNT_PERSON_PARTY_ID => FND_API.G_MISS_NUM,
4890: p_PRM_EXEC_SPONSOR_FLAG => FND_API.G_MISS_CHAR,
4891: p_PRM_PRJ_LEAD_IN_PLACE_FLAG => FND_API.G_MISS_CHAR,
4892: p_PRM_SALES_LEAD_TYPE => FND_API.G_MISS_CHAR,
4893: p_PRM_IND_CLASSIFICATION_CODE => FND_API.G_MISS_CHAR,
4894: p_PRM_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
4895: p_AUTO_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
4896: p_PRIMARY_CONTACT_PARTY_ID => FND_API.G_MISS_NUM,
4897: p_PRIMARY_CNT_PERSON_PARTY_ID => FND_API.G_MISS_NUM,
4898: p_PRIMARY_CONTACT_PHONE_ID => FND_API.G_MISS_NUM,
4891: p_PRM_PRJ_LEAD_IN_PLACE_FLAG => FND_API.G_MISS_CHAR,
4892: p_PRM_SALES_LEAD_TYPE => FND_API.G_MISS_CHAR,
4893: p_PRM_IND_CLASSIFICATION_CODE => FND_API.G_MISS_CHAR,
4894: p_PRM_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
4895: p_AUTO_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
4896: p_PRIMARY_CONTACT_PARTY_ID => FND_API.G_MISS_NUM,
4897: p_PRIMARY_CNT_PERSON_PARTY_ID => FND_API.G_MISS_NUM,
4898: p_PRIMARY_CONTACT_PHONE_ID => FND_API.G_MISS_NUM,
4899: p_REFERRED_BY => FND_API.G_MISS_NUM,
4892: p_PRM_SALES_LEAD_TYPE => FND_API.G_MISS_CHAR,
4893: p_PRM_IND_CLASSIFICATION_CODE => FND_API.G_MISS_CHAR,
4894: p_PRM_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
4895: p_AUTO_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
4896: p_PRIMARY_CONTACT_PARTY_ID => FND_API.G_MISS_NUM,
4897: p_PRIMARY_CNT_PERSON_PARTY_ID => FND_API.G_MISS_NUM,
4898: p_PRIMARY_CONTACT_PHONE_ID => FND_API.G_MISS_NUM,
4899: p_REFERRED_BY => FND_API.G_MISS_NUM,
4900: p_REFERRAL_TYPE => FND_API.G_MISS_CHAR,
4893: p_PRM_IND_CLASSIFICATION_CODE => FND_API.G_MISS_CHAR,
4894: p_PRM_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
4895: p_AUTO_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
4896: p_PRIMARY_CONTACT_PARTY_ID => FND_API.G_MISS_NUM,
4897: p_PRIMARY_CNT_PERSON_PARTY_ID => FND_API.G_MISS_NUM,
4898: p_PRIMARY_CONTACT_PHONE_ID => FND_API.G_MISS_NUM,
4899: p_REFERRED_BY => FND_API.G_MISS_NUM,
4900: p_REFERRAL_TYPE => FND_API.G_MISS_CHAR,
4901: p_REFERRAL_STATUS => FND_API.G_MISS_CHAR,
4894: p_PRM_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
4895: p_AUTO_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
4896: p_PRIMARY_CONTACT_PARTY_ID => FND_API.G_MISS_NUM,
4897: p_PRIMARY_CNT_PERSON_PARTY_ID => FND_API.G_MISS_NUM,
4898: p_PRIMARY_CONTACT_PHONE_ID => FND_API.G_MISS_NUM,
4899: p_REFERRED_BY => FND_API.G_MISS_NUM,
4900: p_REFERRAL_TYPE => FND_API.G_MISS_CHAR,
4901: p_REFERRAL_STATUS => FND_API.G_MISS_CHAR,
4902: p_REF_DECLINE_REASON => FND_API.G_MISS_CHAR,
4895: p_AUTO_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
4896: p_PRIMARY_CONTACT_PARTY_ID => FND_API.G_MISS_NUM,
4897: p_PRIMARY_CNT_PERSON_PARTY_ID => FND_API.G_MISS_NUM,
4898: p_PRIMARY_CONTACT_PHONE_ID => FND_API.G_MISS_NUM,
4899: p_REFERRED_BY => FND_API.G_MISS_NUM,
4900: p_REFERRAL_TYPE => FND_API.G_MISS_CHAR,
4901: p_REFERRAL_STATUS => FND_API.G_MISS_CHAR,
4902: p_REF_DECLINE_REASON => FND_API.G_MISS_CHAR,
4903: p_REF_COMM_LTR_STATUS => FND_API.G_MISS_CHAR,
4896: p_PRIMARY_CONTACT_PARTY_ID => FND_API.G_MISS_NUM,
4897: p_PRIMARY_CNT_PERSON_PARTY_ID => FND_API.G_MISS_NUM,
4898: p_PRIMARY_CONTACT_PHONE_ID => FND_API.G_MISS_NUM,
4899: p_REFERRED_BY => FND_API.G_MISS_NUM,
4900: p_REFERRAL_TYPE => FND_API.G_MISS_CHAR,
4901: p_REFERRAL_STATUS => FND_API.G_MISS_CHAR,
4902: p_REF_DECLINE_REASON => FND_API.G_MISS_CHAR,
4903: p_REF_COMM_LTR_STATUS => FND_API.G_MISS_CHAR,
4904: p_REF_ORDER_NUMBER => FND_API.G_MISS_NUM,
4897: p_PRIMARY_CNT_PERSON_PARTY_ID => FND_API.G_MISS_NUM,
4898: p_PRIMARY_CONTACT_PHONE_ID => FND_API.G_MISS_NUM,
4899: p_REFERRED_BY => FND_API.G_MISS_NUM,
4900: p_REFERRAL_TYPE => FND_API.G_MISS_CHAR,
4901: p_REFERRAL_STATUS => FND_API.G_MISS_CHAR,
4902: p_REF_DECLINE_REASON => FND_API.G_MISS_CHAR,
4903: p_REF_COMM_LTR_STATUS => FND_API.G_MISS_CHAR,
4904: p_REF_ORDER_NUMBER => FND_API.G_MISS_NUM,
4905: p_REF_ORDER_AMT => FND_API.G_MISS_NUM,
4898: p_PRIMARY_CONTACT_PHONE_ID => FND_API.G_MISS_NUM,
4899: p_REFERRED_BY => FND_API.G_MISS_NUM,
4900: p_REFERRAL_TYPE => FND_API.G_MISS_CHAR,
4901: p_REFERRAL_STATUS => FND_API.G_MISS_CHAR,
4902: p_REF_DECLINE_REASON => FND_API.G_MISS_CHAR,
4903: p_REF_COMM_LTR_STATUS => FND_API.G_MISS_CHAR,
4904: p_REF_ORDER_NUMBER => FND_API.G_MISS_NUM,
4905: p_REF_ORDER_AMT => FND_API.G_MISS_NUM,
4906: p_REF_COMM_AMT => FND_API.G_MISS_NUM,
4899: p_REFERRED_BY => FND_API.G_MISS_NUM,
4900: p_REFERRAL_TYPE => FND_API.G_MISS_CHAR,
4901: p_REFERRAL_STATUS => FND_API.G_MISS_CHAR,
4902: p_REF_DECLINE_REASON => FND_API.G_MISS_CHAR,
4903: p_REF_COMM_LTR_STATUS => FND_API.G_MISS_CHAR,
4904: p_REF_ORDER_NUMBER => FND_API.G_MISS_NUM,
4905: p_REF_ORDER_AMT => FND_API.G_MISS_NUM,
4906: p_REF_COMM_AMT => FND_API.G_MISS_NUM,
4907: -- bug No.2341515, 2368075
4900: p_REFERRAL_TYPE => FND_API.G_MISS_CHAR,
4901: p_REFERRAL_STATUS => FND_API.G_MISS_CHAR,
4902: p_REF_DECLINE_REASON => FND_API.G_MISS_CHAR,
4903: p_REF_COMM_LTR_STATUS => FND_API.G_MISS_CHAR,
4904: p_REF_ORDER_NUMBER => FND_API.G_MISS_NUM,
4905: p_REF_ORDER_AMT => FND_API.G_MISS_NUM,
4906: p_REF_COMM_AMT => FND_API.G_MISS_NUM,
4907: -- bug No.2341515, 2368075
4908: p_LEAD_DATE => FND_API.G_MISS_DATE,
4901: p_REFERRAL_STATUS => FND_API.G_MISS_CHAR,
4902: p_REF_DECLINE_REASON => FND_API.G_MISS_CHAR,
4903: p_REF_COMM_LTR_STATUS => FND_API.G_MISS_CHAR,
4904: p_REF_ORDER_NUMBER => FND_API.G_MISS_NUM,
4905: p_REF_ORDER_AMT => FND_API.G_MISS_NUM,
4906: p_REF_COMM_AMT => FND_API.G_MISS_NUM,
4907: -- bug No.2341515, 2368075
4908: p_LEAD_DATE => FND_API.G_MISS_DATE,
4909: p_SOURCE_SYSTEM => FND_API.G_MISS_CHAR,
4902: p_REF_DECLINE_REASON => FND_API.G_MISS_CHAR,
4903: p_REF_COMM_LTR_STATUS => FND_API.G_MISS_CHAR,
4904: p_REF_ORDER_NUMBER => FND_API.G_MISS_NUM,
4905: p_REF_ORDER_AMT => FND_API.G_MISS_NUM,
4906: p_REF_COMM_AMT => FND_API.G_MISS_NUM,
4907: -- bug No.2341515, 2368075
4908: p_LEAD_DATE => FND_API.G_MISS_DATE,
4909: p_SOURCE_SYSTEM => FND_API.G_MISS_CHAR,
4910: p_COUNTRY => FND_API.G_MISS_CHAR,
4904: p_REF_ORDER_NUMBER => FND_API.G_MISS_NUM,
4905: p_REF_ORDER_AMT => FND_API.G_MISS_NUM,
4906: p_REF_COMM_AMT => FND_API.G_MISS_NUM,
4907: -- bug No.2341515, 2368075
4908: p_LEAD_DATE => FND_API.G_MISS_DATE,
4909: p_SOURCE_SYSTEM => FND_API.G_MISS_CHAR,
4910: p_COUNTRY => FND_API.G_MISS_CHAR,
4911: p_TOTAL_AMOUNT => FND_API.G_MISS_NUM,
4912: p_EXPIRATION_DATE => FND_API.G_MISS_DATE,
4905: p_REF_ORDER_AMT => FND_API.G_MISS_NUM,
4906: p_REF_COMM_AMT => FND_API.G_MISS_NUM,
4907: -- bug No.2341515, 2368075
4908: p_LEAD_DATE => FND_API.G_MISS_DATE,
4909: p_SOURCE_SYSTEM => FND_API.G_MISS_CHAR,
4910: p_COUNTRY => FND_API.G_MISS_CHAR,
4911: p_TOTAL_AMOUNT => FND_API.G_MISS_NUM,
4912: p_EXPIRATION_DATE => FND_API.G_MISS_DATE,
4913: p_LEAD_RANK_IND => FND_API.G_MISS_CHAR,
4906: p_REF_COMM_AMT => FND_API.G_MISS_NUM,
4907: -- bug No.2341515, 2368075
4908: p_LEAD_DATE => FND_API.G_MISS_DATE,
4909: p_SOURCE_SYSTEM => FND_API.G_MISS_CHAR,
4910: p_COUNTRY => FND_API.G_MISS_CHAR,
4911: p_TOTAL_AMOUNT => FND_API.G_MISS_NUM,
4912: p_EXPIRATION_DATE => FND_API.G_MISS_DATE,
4913: p_LEAD_RANK_IND => FND_API.G_MISS_CHAR,
4914: p_LEAD_ENGINE_RUN_DATE => FND_API.G_MISS_DATE,
4907: -- bug No.2341515, 2368075
4908: p_LEAD_DATE => FND_API.G_MISS_DATE,
4909: p_SOURCE_SYSTEM => FND_API.G_MISS_CHAR,
4910: p_COUNTRY => FND_API.G_MISS_CHAR,
4911: p_TOTAL_AMOUNT => FND_API.G_MISS_NUM,
4912: p_EXPIRATION_DATE => FND_API.G_MISS_DATE,
4913: p_LEAD_RANK_IND => FND_API.G_MISS_CHAR,
4914: p_LEAD_ENGINE_RUN_DATE => FND_API.G_MISS_DATE,
4915: p_CURRENT_REROUTES => FND_API.G_MISS_NUM,
4908: p_LEAD_DATE => FND_API.G_MISS_DATE,
4909: p_SOURCE_SYSTEM => FND_API.G_MISS_CHAR,
4910: p_COUNTRY => FND_API.G_MISS_CHAR,
4911: p_TOTAL_AMOUNT => FND_API.G_MISS_NUM,
4912: p_EXPIRATION_DATE => FND_API.G_MISS_DATE,
4913: p_LEAD_RANK_IND => FND_API.G_MISS_CHAR,
4914: p_LEAD_ENGINE_RUN_DATE => FND_API.G_MISS_DATE,
4915: p_CURRENT_REROUTES => FND_API.G_MISS_NUM,
4916: p_STATUS_OPEN_FLAG => FND_API.G_MISS_CHAR,
4909: p_SOURCE_SYSTEM => FND_API.G_MISS_CHAR,
4910: p_COUNTRY => FND_API.G_MISS_CHAR,
4911: p_TOTAL_AMOUNT => FND_API.G_MISS_NUM,
4912: p_EXPIRATION_DATE => FND_API.G_MISS_DATE,
4913: p_LEAD_RANK_IND => FND_API.G_MISS_CHAR,
4914: p_LEAD_ENGINE_RUN_DATE => FND_API.G_MISS_DATE,
4915: p_CURRENT_REROUTES => FND_API.G_MISS_NUM,
4916: p_STATUS_OPEN_FLAG => FND_API.G_MISS_CHAR,
4917: p_LEAD_RANK_SCORE => FND_API.G_MISS_NUM,
4910: p_COUNTRY => FND_API.G_MISS_CHAR,
4911: p_TOTAL_AMOUNT => FND_API.G_MISS_NUM,
4912: p_EXPIRATION_DATE => FND_API.G_MISS_DATE,
4913: p_LEAD_RANK_IND => FND_API.G_MISS_CHAR,
4914: p_LEAD_ENGINE_RUN_DATE => FND_API.G_MISS_DATE,
4915: p_CURRENT_REROUTES => FND_API.G_MISS_NUM,
4916: p_STATUS_OPEN_FLAG => FND_API.G_MISS_CHAR,
4917: p_LEAD_RANK_SCORE => FND_API.G_MISS_NUM,
4918: -- 11.5.10 new columns
4911: p_TOTAL_AMOUNT => FND_API.G_MISS_NUM,
4912: p_EXPIRATION_DATE => FND_API.G_MISS_DATE,
4913: p_LEAD_RANK_IND => FND_API.G_MISS_CHAR,
4914: p_LEAD_ENGINE_RUN_DATE => FND_API.G_MISS_DATE,
4915: p_CURRENT_REROUTES => FND_API.G_MISS_NUM,
4916: p_STATUS_OPEN_FLAG => FND_API.G_MISS_CHAR,
4917: p_LEAD_RANK_SCORE => FND_API.G_MISS_NUM,
4918: -- 11.5.10 new columns
4919: p_MARKETING_SCORE => FND_API.G_MISS_NUM,
4912: p_EXPIRATION_DATE => FND_API.G_MISS_DATE,
4913: p_LEAD_RANK_IND => FND_API.G_MISS_CHAR,
4914: p_LEAD_ENGINE_RUN_DATE => FND_API.G_MISS_DATE,
4915: p_CURRENT_REROUTES => FND_API.G_MISS_NUM,
4916: p_STATUS_OPEN_FLAG => FND_API.G_MISS_CHAR,
4917: p_LEAD_RANK_SCORE => FND_API.G_MISS_NUM,
4918: -- 11.5.10 new columns
4919: p_MARKETING_SCORE => FND_API.G_MISS_NUM,
4920: p_INTERACTION_SCORE => FND_API.G_MISS_NUM,
4913: p_LEAD_RANK_IND => FND_API.G_MISS_CHAR,
4914: p_LEAD_ENGINE_RUN_DATE => FND_API.G_MISS_DATE,
4915: p_CURRENT_REROUTES => FND_API.G_MISS_NUM,
4916: p_STATUS_OPEN_FLAG => FND_API.G_MISS_CHAR,
4917: p_LEAD_RANK_SCORE => FND_API.G_MISS_NUM,
4918: -- 11.5.10 new columns
4919: p_MARKETING_SCORE => FND_API.G_MISS_NUM,
4920: p_INTERACTION_SCORE => FND_API.G_MISS_NUM,
4921: p_SOURCE_PRIMARY_REFERENCE => FND_API.G_MISS_CHAR,
4915: p_CURRENT_REROUTES => FND_API.G_MISS_NUM,
4916: p_STATUS_OPEN_FLAG => FND_API.G_MISS_CHAR,
4917: p_LEAD_RANK_SCORE => FND_API.G_MISS_NUM,
4918: -- 11.5.10 new columns
4919: p_MARKETING_SCORE => FND_API.G_MISS_NUM,
4920: p_INTERACTION_SCORE => FND_API.G_MISS_NUM,
4921: p_SOURCE_PRIMARY_REFERENCE => FND_API.G_MISS_CHAR,
4922: p_SOURCE_SECONDARY_REFERENCE => FND_API.G_MISS_CHAR,
4923: p_SALES_METHODOLOGY_ID => FND_API.G_MISS_NUM,
4916: p_STATUS_OPEN_FLAG => FND_API.G_MISS_CHAR,
4917: p_LEAD_RANK_SCORE => FND_API.G_MISS_NUM,
4918: -- 11.5.10 new columns
4919: p_MARKETING_SCORE => FND_API.G_MISS_NUM,
4920: p_INTERACTION_SCORE => FND_API.G_MISS_NUM,
4921: p_SOURCE_PRIMARY_REFERENCE => FND_API.G_MISS_CHAR,
4922: p_SOURCE_SECONDARY_REFERENCE => FND_API.G_MISS_CHAR,
4923: p_SALES_METHODOLOGY_ID => FND_API.G_MISS_NUM,
4924: p_SALES_STAGE_ID => FND_API.G_MISS_NUM);
4917: p_LEAD_RANK_SCORE => FND_API.G_MISS_NUM,
4918: -- 11.5.10 new columns
4919: p_MARKETING_SCORE => FND_API.G_MISS_NUM,
4920: p_INTERACTION_SCORE => FND_API.G_MISS_NUM,
4921: p_SOURCE_PRIMARY_REFERENCE => FND_API.G_MISS_CHAR,
4922: p_SOURCE_SECONDARY_REFERENCE => FND_API.G_MISS_CHAR,
4923: p_SALES_METHODOLOGY_ID => FND_API.G_MISS_NUM,
4924: p_SALES_STAGE_ID => FND_API.G_MISS_NUM);
4925:
4918: -- 11.5.10 new columns
4919: p_MARKETING_SCORE => FND_API.G_MISS_NUM,
4920: p_INTERACTION_SCORE => FND_API.G_MISS_NUM,
4921: p_SOURCE_PRIMARY_REFERENCE => FND_API.G_MISS_CHAR,
4922: p_SOURCE_SECONDARY_REFERENCE => FND_API.G_MISS_CHAR,
4923: p_SALES_METHODOLOGY_ID => FND_API.G_MISS_NUM,
4924: p_SALES_STAGE_ID => FND_API.G_MISS_NUM);
4925:
4926:
4919: p_MARKETING_SCORE => FND_API.G_MISS_NUM,
4920: p_INTERACTION_SCORE => FND_API.G_MISS_NUM,
4921: p_SOURCE_PRIMARY_REFERENCE => FND_API.G_MISS_CHAR,
4922: p_SOURCE_SECONDARY_REFERENCE => FND_API.G_MISS_CHAR,
4923: p_SALES_METHODOLOGY_ID => FND_API.G_MISS_NUM,
4924: p_SALES_STAGE_ID => FND_API.G_MISS_NUM);
4925:
4926:
4927: l_access_exist_flag := 'N';
4920: p_INTERACTION_SCORE => FND_API.G_MISS_NUM,
4921: p_SOURCE_PRIMARY_REFERENCE => FND_API.G_MISS_CHAR,
4922: p_SOURCE_SECONDARY_REFERENCE => FND_API.G_MISS_CHAR,
4923: p_SALES_METHODOLOGY_ID => FND_API.G_MISS_NUM,
4924: p_SALES_STAGE_ID => FND_API.G_MISS_NUM);
4925:
4926:
4927: l_access_exist_flag := 'N';
4928: OPEN c_access_exist(p_sales_lead_id, l_resource_id, l_group_id);
5111: IF (AS_DEBUG_ERROR_ON) THEN
5112: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR,
5113: 'AS_NO_DEFAULT_CM');
5114: END IF;
5115: RAISE FND_API.G_EXC_ERROR;
5116: END IF;
5117:
5118: OPEN c_get_group_id(l_resource_id);
5119: FETCH c_get_group_id INTO l_group_id;
5163: AS_SALES_LEADS_PKG.Sales_Lead_Update_Row(
5164: p_SALES_LEAD_ID => p_SALES_LEAD_ID,
5165: p_LAST_UPDATE_DATE => SYSDATE,
5166: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
5167: p_CREATION_DATE => FND_API.G_MISS_DATE,
5168: p_CREATED_BY => FND_API.G_MISS_NUM,
5169: p_LAST_UPDATE_LOGIN => FND_API.G_MISS_NUM,
5170: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,
5171: p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id,
5164: p_SALES_LEAD_ID => p_SALES_LEAD_ID,
5165: p_LAST_UPDATE_DATE => SYSDATE,
5166: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
5167: p_CREATION_DATE => FND_API.G_MISS_DATE,
5168: p_CREATED_BY => FND_API.G_MISS_NUM,
5169: p_LAST_UPDATE_LOGIN => FND_API.G_MISS_NUM,
5170: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,
5171: p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id,
5172: p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id,
5165: p_LAST_UPDATE_DATE => SYSDATE,
5166: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
5167: p_CREATION_DATE => FND_API.G_MISS_DATE,
5168: p_CREATED_BY => FND_API.G_MISS_NUM,
5169: p_LAST_UPDATE_LOGIN => FND_API.G_MISS_NUM,
5170: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,
5171: p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id,
5172: p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id,
5173: p_PROGRAM_UPDATE_DATE => SYSDATE,
5170: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,
5171: p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id,
5172: p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id,
5173: p_PROGRAM_UPDATE_DATE => SYSDATE,
5174: p_LEAD_NUMBER => FND_API.G_MISS_CHAR,
5175: p_STATUS_CODE => FND_API.G_MISS_CHAR, --l_routing_status,
5176: p_CUSTOMER_ID => l_CUSTOMER_ID,
5177: p_ADDRESS_ID => l_ADDRESS_ID,
5178: p_SOURCE_PROMOTION_ID => FND_API.G_MISS_NUM,
5171: p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id,
5172: p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id,
5173: p_PROGRAM_UPDATE_DATE => SYSDATE,
5174: p_LEAD_NUMBER => FND_API.G_MISS_CHAR,
5175: p_STATUS_CODE => FND_API.G_MISS_CHAR, --l_routing_status,
5176: p_CUSTOMER_ID => l_CUSTOMER_ID,
5177: p_ADDRESS_ID => l_ADDRESS_ID,
5178: p_SOURCE_PROMOTION_ID => FND_API.G_MISS_NUM,
5179: p_INITIATING_CONTACT_ID => FND_API.G_MISS_NUM,
5174: p_LEAD_NUMBER => FND_API.G_MISS_CHAR,
5175: p_STATUS_CODE => FND_API.G_MISS_CHAR, --l_routing_status,
5176: p_CUSTOMER_ID => l_CUSTOMER_ID,
5177: p_ADDRESS_ID => l_ADDRESS_ID,
5178: p_SOURCE_PROMOTION_ID => FND_API.G_MISS_NUM,
5179: p_INITIATING_CONTACT_ID => FND_API.G_MISS_NUM,
5180: p_ORIG_SYSTEM_REFERENCE => FND_API.G_MISS_CHAR,
5181: p_CONTACT_ROLE_CODE => FND_API.G_MISS_CHAR,
5182: p_CHANNEL_CODE => FND_API.G_MISS_CHAR,
5175: p_STATUS_CODE => FND_API.G_MISS_CHAR, --l_routing_status,
5176: p_CUSTOMER_ID => l_CUSTOMER_ID,
5177: p_ADDRESS_ID => l_ADDRESS_ID,
5178: p_SOURCE_PROMOTION_ID => FND_API.G_MISS_NUM,
5179: p_INITIATING_CONTACT_ID => FND_API.G_MISS_NUM,
5180: p_ORIG_SYSTEM_REFERENCE => FND_API.G_MISS_CHAR,
5181: p_CONTACT_ROLE_CODE => FND_API.G_MISS_CHAR,
5182: p_CHANNEL_CODE => FND_API.G_MISS_CHAR,
5183: p_BUDGET_AMOUNT => FND_API.G_MISS_NUM,
5176: p_CUSTOMER_ID => l_CUSTOMER_ID,
5177: p_ADDRESS_ID => l_ADDRESS_ID,
5178: p_SOURCE_PROMOTION_ID => FND_API.G_MISS_NUM,
5179: p_INITIATING_CONTACT_ID => FND_API.G_MISS_NUM,
5180: p_ORIG_SYSTEM_REFERENCE => FND_API.G_MISS_CHAR,
5181: p_CONTACT_ROLE_CODE => FND_API.G_MISS_CHAR,
5182: p_CHANNEL_CODE => FND_API.G_MISS_CHAR,
5183: p_BUDGET_AMOUNT => FND_API.G_MISS_NUM,
5184: p_CURRENCY_CODE => FND_API.G_MISS_CHAR,
5177: p_ADDRESS_ID => l_ADDRESS_ID,
5178: p_SOURCE_PROMOTION_ID => FND_API.G_MISS_NUM,
5179: p_INITIATING_CONTACT_ID => FND_API.G_MISS_NUM,
5180: p_ORIG_SYSTEM_REFERENCE => FND_API.G_MISS_CHAR,
5181: p_CONTACT_ROLE_CODE => FND_API.G_MISS_CHAR,
5182: p_CHANNEL_CODE => FND_API.G_MISS_CHAR,
5183: p_BUDGET_AMOUNT => FND_API.G_MISS_NUM,
5184: p_CURRENCY_CODE => FND_API.G_MISS_CHAR,
5185: p_DECISION_TIMEFRAME_CODE => FND_API.G_MISS_CHAR,
5178: p_SOURCE_PROMOTION_ID => FND_API.G_MISS_NUM,
5179: p_INITIATING_CONTACT_ID => FND_API.G_MISS_NUM,
5180: p_ORIG_SYSTEM_REFERENCE => FND_API.G_MISS_CHAR,
5181: p_CONTACT_ROLE_CODE => FND_API.G_MISS_CHAR,
5182: p_CHANNEL_CODE => FND_API.G_MISS_CHAR,
5183: p_BUDGET_AMOUNT => FND_API.G_MISS_NUM,
5184: p_CURRENCY_CODE => FND_API.G_MISS_CHAR,
5185: p_DECISION_TIMEFRAME_CODE => FND_API.G_MISS_CHAR,
5186: p_CLOSE_REASON => FND_API.G_MISS_CHAR,
5179: p_INITIATING_CONTACT_ID => FND_API.G_MISS_NUM,
5180: p_ORIG_SYSTEM_REFERENCE => FND_API.G_MISS_CHAR,
5181: p_CONTACT_ROLE_CODE => FND_API.G_MISS_CHAR,
5182: p_CHANNEL_CODE => FND_API.G_MISS_CHAR,
5183: p_BUDGET_AMOUNT => FND_API.G_MISS_NUM,
5184: p_CURRENCY_CODE => FND_API.G_MISS_CHAR,
5185: p_DECISION_TIMEFRAME_CODE => FND_API.G_MISS_CHAR,
5186: p_CLOSE_REASON => FND_API.G_MISS_CHAR,
5187: p_LEAD_RANK_ID => FND_API.G_MISS_NUM,
5180: p_ORIG_SYSTEM_REFERENCE => FND_API.G_MISS_CHAR,
5181: p_CONTACT_ROLE_CODE => FND_API.G_MISS_CHAR,
5182: p_CHANNEL_CODE => FND_API.G_MISS_CHAR,
5183: p_BUDGET_AMOUNT => FND_API.G_MISS_NUM,
5184: p_CURRENCY_CODE => FND_API.G_MISS_CHAR,
5185: p_DECISION_TIMEFRAME_CODE => FND_API.G_MISS_CHAR,
5186: p_CLOSE_REASON => FND_API.G_MISS_CHAR,
5187: p_LEAD_RANK_ID => FND_API.G_MISS_NUM,
5188: p_LEAD_RANK_CODE => FND_API.G_MISS_CHAR,
5181: p_CONTACT_ROLE_CODE => FND_API.G_MISS_CHAR,
5182: p_CHANNEL_CODE => FND_API.G_MISS_CHAR,
5183: p_BUDGET_AMOUNT => FND_API.G_MISS_NUM,
5184: p_CURRENCY_CODE => FND_API.G_MISS_CHAR,
5185: p_DECISION_TIMEFRAME_CODE => FND_API.G_MISS_CHAR,
5186: p_CLOSE_REASON => FND_API.G_MISS_CHAR,
5187: p_LEAD_RANK_ID => FND_API.G_MISS_NUM,
5188: p_LEAD_RANK_CODE => FND_API.G_MISS_CHAR,
5189: p_PARENT_PROJECT => FND_API.G_MISS_CHAR,
5182: p_CHANNEL_CODE => FND_API.G_MISS_CHAR,
5183: p_BUDGET_AMOUNT => FND_API.G_MISS_NUM,
5184: p_CURRENCY_CODE => FND_API.G_MISS_CHAR,
5185: p_DECISION_TIMEFRAME_CODE => FND_API.G_MISS_CHAR,
5186: p_CLOSE_REASON => FND_API.G_MISS_CHAR,
5187: p_LEAD_RANK_ID => FND_API.G_MISS_NUM,
5188: p_LEAD_RANK_CODE => FND_API.G_MISS_CHAR,
5189: p_PARENT_PROJECT => FND_API.G_MISS_CHAR,
5190: p_DESCRIPTION => FND_API.G_MISS_CHAR,
5183: p_BUDGET_AMOUNT => FND_API.G_MISS_NUM,
5184: p_CURRENCY_CODE => FND_API.G_MISS_CHAR,
5185: p_DECISION_TIMEFRAME_CODE => FND_API.G_MISS_CHAR,
5186: p_CLOSE_REASON => FND_API.G_MISS_CHAR,
5187: p_LEAD_RANK_ID => FND_API.G_MISS_NUM,
5188: p_LEAD_RANK_CODE => FND_API.G_MISS_CHAR,
5189: p_PARENT_PROJECT => FND_API.G_MISS_CHAR,
5190: p_DESCRIPTION => FND_API.G_MISS_CHAR,
5191: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
5184: p_CURRENCY_CODE => FND_API.G_MISS_CHAR,
5185: p_DECISION_TIMEFRAME_CODE => FND_API.G_MISS_CHAR,
5186: p_CLOSE_REASON => FND_API.G_MISS_CHAR,
5187: p_LEAD_RANK_ID => FND_API.G_MISS_NUM,
5188: p_LEAD_RANK_CODE => FND_API.G_MISS_CHAR,
5189: p_PARENT_PROJECT => FND_API.G_MISS_CHAR,
5190: p_DESCRIPTION => FND_API.G_MISS_CHAR,
5191: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
5192: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
5185: p_DECISION_TIMEFRAME_CODE => FND_API.G_MISS_CHAR,
5186: p_CLOSE_REASON => FND_API.G_MISS_CHAR,
5187: p_LEAD_RANK_ID => FND_API.G_MISS_NUM,
5188: p_LEAD_RANK_CODE => FND_API.G_MISS_CHAR,
5189: p_PARENT_PROJECT => FND_API.G_MISS_CHAR,
5190: p_DESCRIPTION => FND_API.G_MISS_CHAR,
5191: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
5192: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
5193: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
5186: p_CLOSE_REASON => FND_API.G_MISS_CHAR,
5187: p_LEAD_RANK_ID => FND_API.G_MISS_NUM,
5188: p_LEAD_RANK_CODE => FND_API.G_MISS_CHAR,
5189: p_PARENT_PROJECT => FND_API.G_MISS_CHAR,
5190: p_DESCRIPTION => FND_API.G_MISS_CHAR,
5191: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
5192: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
5193: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
5194: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
5187: p_LEAD_RANK_ID => FND_API.G_MISS_NUM,
5188: p_LEAD_RANK_CODE => FND_API.G_MISS_CHAR,
5189: p_PARENT_PROJECT => FND_API.G_MISS_CHAR,
5190: p_DESCRIPTION => FND_API.G_MISS_CHAR,
5191: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
5192: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
5193: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
5194: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
5195: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
5188: p_LEAD_RANK_CODE => FND_API.G_MISS_CHAR,
5189: p_PARENT_PROJECT => FND_API.G_MISS_CHAR,
5190: p_DESCRIPTION => FND_API.G_MISS_CHAR,
5191: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
5192: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
5193: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
5194: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
5195: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
5196: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
5189: p_PARENT_PROJECT => FND_API.G_MISS_CHAR,
5190: p_DESCRIPTION => FND_API.G_MISS_CHAR,
5191: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
5192: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
5193: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
5194: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
5195: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
5196: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
5197: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
5190: p_DESCRIPTION => FND_API.G_MISS_CHAR,
5191: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
5192: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
5193: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
5194: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
5195: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
5196: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
5197: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
5198: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
5191: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
5192: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
5193: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
5194: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
5195: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
5196: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
5197: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
5198: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
5199: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
5192: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
5193: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
5194: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
5195: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
5196: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
5197: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
5198: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
5199: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
5200: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
5193: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
5194: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
5195: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
5196: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
5197: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
5198: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
5199: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
5200: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
5201: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
5194: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
5195: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
5196: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
5197: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
5198: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
5199: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
5200: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
5201: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
5202: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
5195: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
5196: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
5197: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
5198: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
5199: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
5200: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
5201: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
5202: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
5203: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
5196: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
5197: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
5198: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
5199: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
5200: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
5201: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
5202: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
5203: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
5204: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
5197: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
5198: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
5199: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
5200: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
5201: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
5202: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
5203: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
5204: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
5205: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
5198: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
5199: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
5200: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
5201: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
5202: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
5203: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
5204: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
5205: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
5206: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
5199: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
5200: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
5201: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
5202: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
5203: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
5204: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
5205: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
5206: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
5207: p_ASSIGN_TO_PERSON_ID => l_person_id,
5200: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
5201: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
5202: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
5203: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
5204: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
5205: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
5206: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
5207: p_ASSIGN_TO_PERSON_ID => l_person_id,
5208: p_ASSIGN_TO_SALESFORCE_ID => l_resource_id,
5201: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
5202: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
5203: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
5204: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
5205: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
5206: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
5207: p_ASSIGN_TO_PERSON_ID => l_person_id,
5208: p_ASSIGN_TO_SALESFORCE_ID => l_resource_id,
5209: p_ASSIGN_SALES_GROUP_ID => l_group_id,
5202: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
5203: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
5204: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
5205: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
5206: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
5207: p_ASSIGN_TO_PERSON_ID => l_person_id,
5208: p_ASSIGN_TO_SALESFORCE_ID => l_resource_id,
5209: p_ASSIGN_SALES_GROUP_ID => l_group_id,
5210: p_ASSIGN_DATE => SYSDATE,
5207: p_ASSIGN_TO_PERSON_ID => l_person_id,
5208: p_ASSIGN_TO_SALESFORCE_ID => l_resource_id,
5209: p_ASSIGN_SALES_GROUP_ID => l_group_id,
5210: p_ASSIGN_DATE => SYSDATE,
5211: p_BUDGET_STATUS_CODE => FND_API.G_MISS_CHAR,
5212: p_ACCEPT_FLAG => 'N',
5213: p_VEHICLE_RESPONSE_CODE => FND_API.G_MISS_CHAR,
5214: p_TOTAL_SCORE => FND_API.G_MISS_NUM,
5215: p_SCORECARD_ID => FND_API.G_MISS_NUM,
5209: p_ASSIGN_SALES_GROUP_ID => l_group_id,
5210: p_ASSIGN_DATE => SYSDATE,
5211: p_BUDGET_STATUS_CODE => FND_API.G_MISS_CHAR,
5212: p_ACCEPT_FLAG => 'N',
5213: p_VEHICLE_RESPONSE_CODE => FND_API.G_MISS_CHAR,
5214: p_TOTAL_SCORE => FND_API.G_MISS_NUM,
5215: p_SCORECARD_ID => FND_API.G_MISS_NUM,
5216: p_KEEP_FLAG => FND_API.G_MISS_CHAR,
5217: p_URGENT_FLAG => FND_API.G_MISS_CHAR,
5210: p_ASSIGN_DATE => SYSDATE,
5211: p_BUDGET_STATUS_CODE => FND_API.G_MISS_CHAR,
5212: p_ACCEPT_FLAG => 'N',
5213: p_VEHICLE_RESPONSE_CODE => FND_API.G_MISS_CHAR,
5214: p_TOTAL_SCORE => FND_API.G_MISS_NUM,
5215: p_SCORECARD_ID => FND_API.G_MISS_NUM,
5216: p_KEEP_FLAG => FND_API.G_MISS_CHAR,
5217: p_URGENT_FLAG => FND_API.G_MISS_CHAR,
5218: p_IMPORT_FLAG => FND_API.G_MISS_CHAR,
5211: p_BUDGET_STATUS_CODE => FND_API.G_MISS_CHAR,
5212: p_ACCEPT_FLAG => 'N',
5213: p_VEHICLE_RESPONSE_CODE => FND_API.G_MISS_CHAR,
5214: p_TOTAL_SCORE => FND_API.G_MISS_NUM,
5215: p_SCORECARD_ID => FND_API.G_MISS_NUM,
5216: p_KEEP_FLAG => FND_API.G_MISS_CHAR,
5217: p_URGENT_FLAG => FND_API.G_MISS_CHAR,
5218: p_IMPORT_FLAG => FND_API.G_MISS_CHAR,
5219: p_REJECT_REASON_CODE => NULL, --l_reject_reason_code,
5212: p_ACCEPT_FLAG => 'N',
5213: p_VEHICLE_RESPONSE_CODE => FND_API.G_MISS_CHAR,
5214: p_TOTAL_SCORE => FND_API.G_MISS_NUM,
5215: p_SCORECARD_ID => FND_API.G_MISS_NUM,
5216: p_KEEP_FLAG => FND_API.G_MISS_CHAR,
5217: p_URGENT_FLAG => FND_API.G_MISS_CHAR,
5218: p_IMPORT_FLAG => FND_API.G_MISS_CHAR,
5219: p_REJECT_REASON_CODE => NULL, --l_reject_reason_code,
5220: p_DELETED_FLAG => FND_API.G_MISS_CHAR,
5213: p_VEHICLE_RESPONSE_CODE => FND_API.G_MISS_CHAR,
5214: p_TOTAL_SCORE => FND_API.G_MISS_NUM,
5215: p_SCORECARD_ID => FND_API.G_MISS_NUM,
5216: p_KEEP_FLAG => FND_API.G_MISS_CHAR,
5217: p_URGENT_FLAG => FND_API.G_MISS_CHAR,
5218: p_IMPORT_FLAG => FND_API.G_MISS_CHAR,
5219: p_REJECT_REASON_CODE => NULL, --l_reject_reason_code,
5220: p_DELETED_FLAG => FND_API.G_MISS_CHAR,
5221: p_OFFER_ID => FND_API.G_MISS_NUM,
5214: p_TOTAL_SCORE => FND_API.G_MISS_NUM,
5215: p_SCORECARD_ID => FND_API.G_MISS_NUM,
5216: p_KEEP_FLAG => FND_API.G_MISS_CHAR,
5217: p_URGENT_FLAG => FND_API.G_MISS_CHAR,
5218: p_IMPORT_FLAG => FND_API.G_MISS_CHAR,
5219: p_REJECT_REASON_CODE => NULL, --l_reject_reason_code,
5220: p_DELETED_FLAG => FND_API.G_MISS_CHAR,
5221: p_OFFER_ID => FND_API.G_MISS_NUM,
5222: p_QUALIFIED_FLAG => l_qualified_flag,
5216: p_KEEP_FLAG => FND_API.G_MISS_CHAR,
5217: p_URGENT_FLAG => FND_API.G_MISS_CHAR,
5218: p_IMPORT_FLAG => FND_API.G_MISS_CHAR,
5219: p_REJECT_REASON_CODE => NULL, --l_reject_reason_code,
5220: p_DELETED_FLAG => FND_API.G_MISS_CHAR,
5221: p_OFFER_ID => FND_API.G_MISS_NUM,
5222: p_QUALIFIED_FLAG => l_qualified_flag,
5223: p_ORIG_SYSTEM_CODE => FND_API.G_MISS_CHAR,
5224: -- p_SECURITY_GROUP_ID => FND_API.G_MISS_NUM,
5217: p_URGENT_FLAG => FND_API.G_MISS_CHAR,
5218: p_IMPORT_FLAG => FND_API.G_MISS_CHAR,
5219: p_REJECT_REASON_CODE => NULL, --l_reject_reason_code,
5220: p_DELETED_FLAG => FND_API.G_MISS_CHAR,
5221: p_OFFER_ID => FND_API.G_MISS_NUM,
5222: p_QUALIFIED_FLAG => l_qualified_flag,
5223: p_ORIG_SYSTEM_CODE => FND_API.G_MISS_CHAR,
5224: -- p_SECURITY_GROUP_ID => FND_API.G_MISS_NUM,
5225: p_INC_PARTNER_PARTY_ID => FND_API.G_MISS_NUM,
5219: p_REJECT_REASON_CODE => NULL, --l_reject_reason_code,
5220: p_DELETED_FLAG => FND_API.G_MISS_CHAR,
5221: p_OFFER_ID => FND_API.G_MISS_NUM,
5222: p_QUALIFIED_FLAG => l_qualified_flag,
5223: p_ORIG_SYSTEM_CODE => FND_API.G_MISS_CHAR,
5224: -- p_SECURITY_GROUP_ID => FND_API.G_MISS_NUM,
5225: p_INC_PARTNER_PARTY_ID => FND_API.G_MISS_NUM,
5226: p_INC_PARTNER_RESOURCE_ID => FND_API.G_MISS_NUM,
5227: p_PRM_EXEC_SPONSOR_FLAG => FND_API.G_MISS_CHAR,
5220: p_DELETED_FLAG => FND_API.G_MISS_CHAR,
5221: p_OFFER_ID => FND_API.G_MISS_NUM,
5222: p_QUALIFIED_FLAG => l_qualified_flag,
5223: p_ORIG_SYSTEM_CODE => FND_API.G_MISS_CHAR,
5224: -- p_SECURITY_GROUP_ID => FND_API.G_MISS_NUM,
5225: p_INC_PARTNER_PARTY_ID => FND_API.G_MISS_NUM,
5226: p_INC_PARTNER_RESOURCE_ID => FND_API.G_MISS_NUM,
5227: p_PRM_EXEC_SPONSOR_FLAG => FND_API.G_MISS_CHAR,
5228: p_PRM_PRJ_LEAD_IN_PLACE_FLAG => FND_API.G_MISS_CHAR,
5221: p_OFFER_ID => FND_API.G_MISS_NUM,
5222: p_QUALIFIED_FLAG => l_qualified_flag,
5223: p_ORIG_SYSTEM_CODE => FND_API.G_MISS_CHAR,
5224: -- p_SECURITY_GROUP_ID => FND_API.G_MISS_NUM,
5225: p_INC_PARTNER_PARTY_ID => FND_API.G_MISS_NUM,
5226: p_INC_PARTNER_RESOURCE_ID => FND_API.G_MISS_NUM,
5227: p_PRM_EXEC_SPONSOR_FLAG => FND_API.G_MISS_CHAR,
5228: p_PRM_PRJ_LEAD_IN_PLACE_FLAG => FND_API.G_MISS_CHAR,
5229: p_PRM_SALES_LEAD_TYPE => FND_API.G_MISS_CHAR,
5222: p_QUALIFIED_FLAG => l_qualified_flag,
5223: p_ORIG_SYSTEM_CODE => FND_API.G_MISS_CHAR,
5224: -- p_SECURITY_GROUP_ID => FND_API.G_MISS_NUM,
5225: p_INC_PARTNER_PARTY_ID => FND_API.G_MISS_NUM,
5226: p_INC_PARTNER_RESOURCE_ID => FND_API.G_MISS_NUM,
5227: p_PRM_EXEC_SPONSOR_FLAG => FND_API.G_MISS_CHAR,
5228: p_PRM_PRJ_LEAD_IN_PLACE_FLAG => FND_API.G_MISS_CHAR,
5229: p_PRM_SALES_LEAD_TYPE => FND_API.G_MISS_CHAR,
5230: p_PRM_IND_CLASSIFICATION_CODE => FND_API.G_MISS_CHAR,
5223: p_ORIG_SYSTEM_CODE => FND_API.G_MISS_CHAR,
5224: -- p_SECURITY_GROUP_ID => FND_API.G_MISS_NUM,
5225: p_INC_PARTNER_PARTY_ID => FND_API.G_MISS_NUM,
5226: p_INC_PARTNER_RESOURCE_ID => FND_API.G_MISS_NUM,
5227: p_PRM_EXEC_SPONSOR_FLAG => FND_API.G_MISS_CHAR,
5228: p_PRM_PRJ_LEAD_IN_PLACE_FLAG => FND_API.G_MISS_CHAR,
5229: p_PRM_SALES_LEAD_TYPE => FND_API.G_MISS_CHAR,
5230: p_PRM_IND_CLASSIFICATION_CODE => FND_API.G_MISS_CHAR,
5231: p_PRM_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
5224: -- p_SECURITY_GROUP_ID => FND_API.G_MISS_NUM,
5225: p_INC_PARTNER_PARTY_ID => FND_API.G_MISS_NUM,
5226: p_INC_PARTNER_RESOURCE_ID => FND_API.G_MISS_NUM,
5227: p_PRM_EXEC_SPONSOR_FLAG => FND_API.G_MISS_CHAR,
5228: p_PRM_PRJ_LEAD_IN_PLACE_FLAG => FND_API.G_MISS_CHAR,
5229: p_PRM_SALES_LEAD_TYPE => FND_API.G_MISS_CHAR,
5230: p_PRM_IND_CLASSIFICATION_CODE => FND_API.G_MISS_CHAR,
5231: p_PRM_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
5232: p_AUTO_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
5225: p_INC_PARTNER_PARTY_ID => FND_API.G_MISS_NUM,
5226: p_INC_PARTNER_RESOURCE_ID => FND_API.G_MISS_NUM,
5227: p_PRM_EXEC_SPONSOR_FLAG => FND_API.G_MISS_CHAR,
5228: p_PRM_PRJ_LEAD_IN_PLACE_FLAG => FND_API.G_MISS_CHAR,
5229: p_PRM_SALES_LEAD_TYPE => FND_API.G_MISS_CHAR,
5230: p_PRM_IND_CLASSIFICATION_CODE => FND_API.G_MISS_CHAR,
5231: p_PRM_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
5232: p_AUTO_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
5233: p_PRIMARY_CONTACT_PARTY_ID => FND_API.G_MISS_NUM,
5226: p_INC_PARTNER_RESOURCE_ID => FND_API.G_MISS_NUM,
5227: p_PRM_EXEC_SPONSOR_FLAG => FND_API.G_MISS_CHAR,
5228: p_PRM_PRJ_LEAD_IN_PLACE_FLAG => FND_API.G_MISS_CHAR,
5229: p_PRM_SALES_LEAD_TYPE => FND_API.G_MISS_CHAR,
5230: p_PRM_IND_CLASSIFICATION_CODE => FND_API.G_MISS_CHAR,
5231: p_PRM_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
5232: p_AUTO_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
5233: p_PRIMARY_CONTACT_PARTY_ID => FND_API.G_MISS_NUM,
5234: p_PRIMARY_CNT_PERSON_PARTY_ID => FND_API.G_MISS_NUM,
5227: p_PRM_EXEC_SPONSOR_FLAG => FND_API.G_MISS_CHAR,
5228: p_PRM_PRJ_LEAD_IN_PLACE_FLAG => FND_API.G_MISS_CHAR,
5229: p_PRM_SALES_LEAD_TYPE => FND_API.G_MISS_CHAR,
5230: p_PRM_IND_CLASSIFICATION_CODE => FND_API.G_MISS_CHAR,
5231: p_PRM_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
5232: p_AUTO_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
5233: p_PRIMARY_CONTACT_PARTY_ID => FND_API.G_MISS_NUM,
5234: p_PRIMARY_CNT_PERSON_PARTY_ID => FND_API.G_MISS_NUM,
5235: p_PRIMARY_CONTACT_PHONE_ID => FND_API.G_MISS_NUM,
5228: p_PRM_PRJ_LEAD_IN_PLACE_FLAG => FND_API.G_MISS_CHAR,
5229: p_PRM_SALES_LEAD_TYPE => FND_API.G_MISS_CHAR,
5230: p_PRM_IND_CLASSIFICATION_CODE => FND_API.G_MISS_CHAR,
5231: p_PRM_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
5232: p_AUTO_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
5233: p_PRIMARY_CONTACT_PARTY_ID => FND_API.G_MISS_NUM,
5234: p_PRIMARY_CNT_PERSON_PARTY_ID => FND_API.G_MISS_NUM,
5235: p_PRIMARY_CONTACT_PHONE_ID => FND_API.G_MISS_NUM,
5236: p_REFERRED_BY => FND_API.G_MISS_NUM,
5229: p_PRM_SALES_LEAD_TYPE => FND_API.G_MISS_CHAR,
5230: p_PRM_IND_CLASSIFICATION_CODE => FND_API.G_MISS_CHAR,
5231: p_PRM_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
5232: p_AUTO_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
5233: p_PRIMARY_CONTACT_PARTY_ID => FND_API.G_MISS_NUM,
5234: p_PRIMARY_CNT_PERSON_PARTY_ID => FND_API.G_MISS_NUM,
5235: p_PRIMARY_CONTACT_PHONE_ID => FND_API.G_MISS_NUM,
5236: p_REFERRED_BY => FND_API.G_MISS_NUM,
5237: p_REFERRAL_TYPE => FND_API.G_MISS_CHAR,
5230: p_PRM_IND_CLASSIFICATION_CODE => FND_API.G_MISS_CHAR,
5231: p_PRM_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
5232: p_AUTO_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
5233: p_PRIMARY_CONTACT_PARTY_ID => FND_API.G_MISS_NUM,
5234: p_PRIMARY_CNT_PERSON_PARTY_ID => FND_API.G_MISS_NUM,
5235: p_PRIMARY_CONTACT_PHONE_ID => FND_API.G_MISS_NUM,
5236: p_REFERRED_BY => FND_API.G_MISS_NUM,
5237: p_REFERRAL_TYPE => FND_API.G_MISS_CHAR,
5238: p_REFERRAL_STATUS => FND_API.G_MISS_CHAR,
5231: p_PRM_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
5232: p_AUTO_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
5233: p_PRIMARY_CONTACT_PARTY_ID => FND_API.G_MISS_NUM,
5234: p_PRIMARY_CNT_PERSON_PARTY_ID => FND_API.G_MISS_NUM,
5235: p_PRIMARY_CONTACT_PHONE_ID => FND_API.G_MISS_NUM,
5236: p_REFERRED_BY => FND_API.G_MISS_NUM,
5237: p_REFERRAL_TYPE => FND_API.G_MISS_CHAR,
5238: p_REFERRAL_STATUS => FND_API.G_MISS_CHAR,
5239: p_REF_DECLINE_REASON => FND_API.G_MISS_CHAR,
5232: p_AUTO_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
5233: p_PRIMARY_CONTACT_PARTY_ID => FND_API.G_MISS_NUM,
5234: p_PRIMARY_CNT_PERSON_PARTY_ID => FND_API.G_MISS_NUM,
5235: p_PRIMARY_CONTACT_PHONE_ID => FND_API.G_MISS_NUM,
5236: p_REFERRED_BY => FND_API.G_MISS_NUM,
5237: p_REFERRAL_TYPE => FND_API.G_MISS_CHAR,
5238: p_REFERRAL_STATUS => FND_API.G_MISS_CHAR,
5239: p_REF_DECLINE_REASON => FND_API.G_MISS_CHAR,
5240: p_REF_COMM_LTR_STATUS => FND_API.G_MISS_CHAR,
5233: p_PRIMARY_CONTACT_PARTY_ID => FND_API.G_MISS_NUM,
5234: p_PRIMARY_CNT_PERSON_PARTY_ID => FND_API.G_MISS_NUM,
5235: p_PRIMARY_CONTACT_PHONE_ID => FND_API.G_MISS_NUM,
5236: p_REFERRED_BY => FND_API.G_MISS_NUM,
5237: p_REFERRAL_TYPE => FND_API.G_MISS_CHAR,
5238: p_REFERRAL_STATUS => FND_API.G_MISS_CHAR,
5239: p_REF_DECLINE_REASON => FND_API.G_MISS_CHAR,
5240: p_REF_COMM_LTR_STATUS => FND_API.G_MISS_CHAR,
5241: p_REF_ORDER_NUMBER => FND_API.G_MISS_NUM,
5234: p_PRIMARY_CNT_PERSON_PARTY_ID => FND_API.G_MISS_NUM,
5235: p_PRIMARY_CONTACT_PHONE_ID => FND_API.G_MISS_NUM,
5236: p_REFERRED_BY => FND_API.G_MISS_NUM,
5237: p_REFERRAL_TYPE => FND_API.G_MISS_CHAR,
5238: p_REFERRAL_STATUS => FND_API.G_MISS_CHAR,
5239: p_REF_DECLINE_REASON => FND_API.G_MISS_CHAR,
5240: p_REF_COMM_LTR_STATUS => FND_API.G_MISS_CHAR,
5241: p_REF_ORDER_NUMBER => FND_API.G_MISS_NUM,
5242: p_REF_ORDER_AMT => FND_API.G_MISS_NUM,
5235: p_PRIMARY_CONTACT_PHONE_ID => FND_API.G_MISS_NUM,
5236: p_REFERRED_BY => FND_API.G_MISS_NUM,
5237: p_REFERRAL_TYPE => FND_API.G_MISS_CHAR,
5238: p_REFERRAL_STATUS => FND_API.G_MISS_CHAR,
5239: p_REF_DECLINE_REASON => FND_API.G_MISS_CHAR,
5240: p_REF_COMM_LTR_STATUS => FND_API.G_MISS_CHAR,
5241: p_REF_ORDER_NUMBER => FND_API.G_MISS_NUM,
5242: p_REF_ORDER_AMT => FND_API.G_MISS_NUM,
5243: p_REF_COMM_AMT => FND_API.G_MISS_NUM,
5236: p_REFERRED_BY => FND_API.G_MISS_NUM,
5237: p_REFERRAL_TYPE => FND_API.G_MISS_CHAR,
5238: p_REFERRAL_STATUS => FND_API.G_MISS_CHAR,
5239: p_REF_DECLINE_REASON => FND_API.G_MISS_CHAR,
5240: p_REF_COMM_LTR_STATUS => FND_API.G_MISS_CHAR,
5241: p_REF_ORDER_NUMBER => FND_API.G_MISS_NUM,
5242: p_REF_ORDER_AMT => FND_API.G_MISS_NUM,
5243: p_REF_COMM_AMT => FND_API.G_MISS_NUM,
5244: -- bug No.2341515, 2368075
5237: p_REFERRAL_TYPE => FND_API.G_MISS_CHAR,
5238: p_REFERRAL_STATUS => FND_API.G_MISS_CHAR,
5239: p_REF_DECLINE_REASON => FND_API.G_MISS_CHAR,
5240: p_REF_COMM_LTR_STATUS => FND_API.G_MISS_CHAR,
5241: p_REF_ORDER_NUMBER => FND_API.G_MISS_NUM,
5242: p_REF_ORDER_AMT => FND_API.G_MISS_NUM,
5243: p_REF_COMM_AMT => FND_API.G_MISS_NUM,
5244: -- bug No.2341515, 2368075
5245: p_LEAD_DATE => FND_API.G_MISS_DATE,
5238: p_REFERRAL_STATUS => FND_API.G_MISS_CHAR,
5239: p_REF_DECLINE_REASON => FND_API.G_MISS_CHAR,
5240: p_REF_COMM_LTR_STATUS => FND_API.G_MISS_CHAR,
5241: p_REF_ORDER_NUMBER => FND_API.G_MISS_NUM,
5242: p_REF_ORDER_AMT => FND_API.G_MISS_NUM,
5243: p_REF_COMM_AMT => FND_API.G_MISS_NUM,
5244: -- bug No.2341515, 2368075
5245: p_LEAD_DATE => FND_API.G_MISS_DATE,
5246: p_SOURCE_SYSTEM => FND_API.G_MISS_CHAR,
5239: p_REF_DECLINE_REASON => FND_API.G_MISS_CHAR,
5240: p_REF_COMM_LTR_STATUS => FND_API.G_MISS_CHAR,
5241: p_REF_ORDER_NUMBER => FND_API.G_MISS_NUM,
5242: p_REF_ORDER_AMT => FND_API.G_MISS_NUM,
5243: p_REF_COMM_AMT => FND_API.G_MISS_NUM,
5244: -- bug No.2341515, 2368075
5245: p_LEAD_DATE => FND_API.G_MISS_DATE,
5246: p_SOURCE_SYSTEM => FND_API.G_MISS_CHAR,
5247: p_COUNTRY => FND_API.G_MISS_CHAR,
5241: p_REF_ORDER_NUMBER => FND_API.G_MISS_NUM,
5242: p_REF_ORDER_AMT => FND_API.G_MISS_NUM,
5243: p_REF_COMM_AMT => FND_API.G_MISS_NUM,
5244: -- bug No.2341515, 2368075
5245: p_LEAD_DATE => FND_API.G_MISS_DATE,
5246: p_SOURCE_SYSTEM => FND_API.G_MISS_CHAR,
5247: p_COUNTRY => FND_API.G_MISS_CHAR,
5248: p_TOTAL_AMOUNT => FND_API.G_MISS_NUM,
5249: p_EXPIRATION_DATE => FND_API.G_MISS_DATE,
5242: p_REF_ORDER_AMT => FND_API.G_MISS_NUM,
5243: p_REF_COMM_AMT => FND_API.G_MISS_NUM,
5244: -- bug No.2341515, 2368075
5245: p_LEAD_DATE => FND_API.G_MISS_DATE,
5246: p_SOURCE_SYSTEM => FND_API.G_MISS_CHAR,
5247: p_COUNTRY => FND_API.G_MISS_CHAR,
5248: p_TOTAL_AMOUNT => FND_API.G_MISS_NUM,
5249: p_EXPIRATION_DATE => FND_API.G_MISS_DATE,
5250: p_LEAD_RANK_IND => FND_API.G_MISS_CHAR,
5243: p_REF_COMM_AMT => FND_API.G_MISS_NUM,
5244: -- bug No.2341515, 2368075
5245: p_LEAD_DATE => FND_API.G_MISS_DATE,
5246: p_SOURCE_SYSTEM => FND_API.G_MISS_CHAR,
5247: p_COUNTRY => FND_API.G_MISS_CHAR,
5248: p_TOTAL_AMOUNT => FND_API.G_MISS_NUM,
5249: p_EXPIRATION_DATE => FND_API.G_MISS_DATE,
5250: p_LEAD_RANK_IND => FND_API.G_MISS_CHAR,
5251: p_LEAD_ENGINE_RUN_DATE => FND_API.G_MISS_DATE,
5244: -- bug No.2341515, 2368075
5245: p_LEAD_DATE => FND_API.G_MISS_DATE,
5246: p_SOURCE_SYSTEM => FND_API.G_MISS_CHAR,
5247: p_COUNTRY => FND_API.G_MISS_CHAR,
5248: p_TOTAL_AMOUNT => FND_API.G_MISS_NUM,
5249: p_EXPIRATION_DATE => FND_API.G_MISS_DATE,
5250: p_LEAD_RANK_IND => FND_API.G_MISS_CHAR,
5251: p_LEAD_ENGINE_RUN_DATE => FND_API.G_MISS_DATE,
5252: p_CURRENT_REROUTES => FND_API.G_MISS_NUM,
5245: p_LEAD_DATE => FND_API.G_MISS_DATE,
5246: p_SOURCE_SYSTEM => FND_API.G_MISS_CHAR,
5247: p_COUNTRY => FND_API.G_MISS_CHAR,
5248: p_TOTAL_AMOUNT => FND_API.G_MISS_NUM,
5249: p_EXPIRATION_DATE => FND_API.G_MISS_DATE,
5250: p_LEAD_RANK_IND => FND_API.G_MISS_CHAR,
5251: p_LEAD_ENGINE_RUN_DATE => FND_API.G_MISS_DATE,
5252: p_CURRENT_REROUTES => FND_API.G_MISS_NUM,
5253: p_STATUS_OPEN_FLAG => FND_API.G_MISS_CHAR,
5246: p_SOURCE_SYSTEM => FND_API.G_MISS_CHAR,
5247: p_COUNTRY => FND_API.G_MISS_CHAR,
5248: p_TOTAL_AMOUNT => FND_API.G_MISS_NUM,
5249: p_EXPIRATION_DATE => FND_API.G_MISS_DATE,
5250: p_LEAD_RANK_IND => FND_API.G_MISS_CHAR,
5251: p_LEAD_ENGINE_RUN_DATE => FND_API.G_MISS_DATE,
5252: p_CURRENT_REROUTES => FND_API.G_MISS_NUM,
5253: p_STATUS_OPEN_FLAG => FND_API.G_MISS_CHAR,
5254: p_LEAD_RANK_SCORE => FND_API.G_MISS_NUM,
5247: p_COUNTRY => FND_API.G_MISS_CHAR,
5248: p_TOTAL_AMOUNT => FND_API.G_MISS_NUM,
5249: p_EXPIRATION_DATE => FND_API.G_MISS_DATE,
5250: p_LEAD_RANK_IND => FND_API.G_MISS_CHAR,
5251: p_LEAD_ENGINE_RUN_DATE => FND_API.G_MISS_DATE,
5252: p_CURRENT_REROUTES => FND_API.G_MISS_NUM,
5253: p_STATUS_OPEN_FLAG => FND_API.G_MISS_CHAR,
5254: p_LEAD_RANK_SCORE => FND_API.G_MISS_NUM,
5255: -- 11.5.10 new columns
5248: p_TOTAL_AMOUNT => FND_API.G_MISS_NUM,
5249: p_EXPIRATION_DATE => FND_API.G_MISS_DATE,
5250: p_LEAD_RANK_IND => FND_API.G_MISS_CHAR,
5251: p_LEAD_ENGINE_RUN_DATE => FND_API.G_MISS_DATE,
5252: p_CURRENT_REROUTES => FND_API.G_MISS_NUM,
5253: p_STATUS_OPEN_FLAG => FND_API.G_MISS_CHAR,
5254: p_LEAD_RANK_SCORE => FND_API.G_MISS_NUM,
5255: -- 11.5.10 new columns
5256: p_MARKETING_SCORE => FND_API.G_MISS_NUM,
5249: p_EXPIRATION_DATE => FND_API.G_MISS_DATE,
5250: p_LEAD_RANK_IND => FND_API.G_MISS_CHAR,
5251: p_LEAD_ENGINE_RUN_DATE => FND_API.G_MISS_DATE,
5252: p_CURRENT_REROUTES => FND_API.G_MISS_NUM,
5253: p_STATUS_OPEN_FLAG => FND_API.G_MISS_CHAR,
5254: p_LEAD_RANK_SCORE => FND_API.G_MISS_NUM,
5255: -- 11.5.10 new columns
5256: p_MARKETING_SCORE => FND_API.G_MISS_NUM,
5257: p_INTERACTION_SCORE => FND_API.G_MISS_NUM,
5250: p_LEAD_RANK_IND => FND_API.G_MISS_CHAR,
5251: p_LEAD_ENGINE_RUN_DATE => FND_API.G_MISS_DATE,
5252: p_CURRENT_REROUTES => FND_API.G_MISS_NUM,
5253: p_STATUS_OPEN_FLAG => FND_API.G_MISS_CHAR,
5254: p_LEAD_RANK_SCORE => FND_API.G_MISS_NUM,
5255: -- 11.5.10 new columns
5256: p_MARKETING_SCORE => FND_API.G_MISS_NUM,
5257: p_INTERACTION_SCORE => FND_API.G_MISS_NUM,
5258: p_SOURCE_PRIMARY_REFERENCE => FND_API.G_MISS_CHAR,
5252: p_CURRENT_REROUTES => FND_API.G_MISS_NUM,
5253: p_STATUS_OPEN_FLAG => FND_API.G_MISS_CHAR,
5254: p_LEAD_RANK_SCORE => FND_API.G_MISS_NUM,
5255: -- 11.5.10 new columns
5256: p_MARKETING_SCORE => FND_API.G_MISS_NUM,
5257: p_INTERACTION_SCORE => FND_API.G_MISS_NUM,
5258: p_SOURCE_PRIMARY_REFERENCE => FND_API.G_MISS_CHAR,
5259: p_SOURCE_SECONDARY_REFERENCE => FND_API.G_MISS_CHAR,
5260: p_SALES_METHODOLOGY_ID => FND_API.G_MISS_NUM,
5253: p_STATUS_OPEN_FLAG => FND_API.G_MISS_CHAR,
5254: p_LEAD_RANK_SCORE => FND_API.G_MISS_NUM,
5255: -- 11.5.10 new columns
5256: p_MARKETING_SCORE => FND_API.G_MISS_NUM,
5257: p_INTERACTION_SCORE => FND_API.G_MISS_NUM,
5258: p_SOURCE_PRIMARY_REFERENCE => FND_API.G_MISS_CHAR,
5259: p_SOURCE_SECONDARY_REFERENCE => FND_API.G_MISS_CHAR,
5260: p_SALES_METHODOLOGY_ID => FND_API.G_MISS_NUM,
5261: p_SALES_STAGE_ID => FND_API.G_MISS_NUM);
5254: p_LEAD_RANK_SCORE => FND_API.G_MISS_NUM,
5255: -- 11.5.10 new columns
5256: p_MARKETING_SCORE => FND_API.G_MISS_NUM,
5257: p_INTERACTION_SCORE => FND_API.G_MISS_NUM,
5258: p_SOURCE_PRIMARY_REFERENCE => FND_API.G_MISS_CHAR,
5259: p_SOURCE_SECONDARY_REFERENCE => FND_API.G_MISS_CHAR,
5260: p_SALES_METHODOLOGY_ID => FND_API.G_MISS_NUM,
5261: p_SALES_STAGE_ID => FND_API.G_MISS_NUM);
5262:
5255: -- 11.5.10 new columns
5256: p_MARKETING_SCORE => FND_API.G_MISS_NUM,
5257: p_INTERACTION_SCORE => FND_API.G_MISS_NUM,
5258: p_SOURCE_PRIMARY_REFERENCE => FND_API.G_MISS_CHAR,
5259: p_SOURCE_SECONDARY_REFERENCE => FND_API.G_MISS_CHAR,
5260: p_SALES_METHODOLOGY_ID => FND_API.G_MISS_NUM,
5261: p_SALES_STAGE_ID => FND_API.G_MISS_NUM);
5262:
5263: l_access_exist_flag := 'N';
5256: p_MARKETING_SCORE => FND_API.G_MISS_NUM,
5257: p_INTERACTION_SCORE => FND_API.G_MISS_NUM,
5258: p_SOURCE_PRIMARY_REFERENCE => FND_API.G_MISS_CHAR,
5259: p_SOURCE_SECONDARY_REFERENCE => FND_API.G_MISS_CHAR,
5260: p_SALES_METHODOLOGY_ID => FND_API.G_MISS_NUM,
5261: p_SALES_STAGE_ID => FND_API.G_MISS_NUM);
5262:
5263: l_access_exist_flag := 'N';
5264: OPEN c_access_exist(p_sales_lead_id, l_resource_id, l_group_id);
5257: p_INTERACTION_SCORE => FND_API.G_MISS_NUM,
5258: p_SOURCE_PRIMARY_REFERENCE => FND_API.G_MISS_CHAR,
5259: p_SOURCE_SECONDARY_REFERENCE => FND_API.G_MISS_CHAR,
5260: p_SALES_METHODOLOGY_ID => FND_API.G_MISS_NUM,
5261: p_SALES_STAGE_ID => FND_API.G_MISS_NUM);
5262:
5263: l_access_exist_flag := 'N';
5264: OPEN c_access_exist(p_sales_lead_id, l_resource_id, l_group_id);
5265: FETCH c_access_exist INTO l_access_exist_flag;
5384: IF (AS_DEBUG_LOW_ON) THEN
5385: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5386: 'User''s resource id is:' || l_rs_id);
5387: END IF;
5388: IF p_salesgroup_id = fnd_api.g_miss_num
5389: THEN
5390: g_group_id_tbl(1) := NULL;
5391: OPEN c_get_group_id (l_rs_id);
5392: FETCH c_get_group_id INTO g_group_id_tbl(1);
5447: IF (AS_DEBUG_LOW_ON) THEN
5448: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5449: 'User''s resource id is:' || l_rs_id);
5450: END IF;
5451: IF p_salesgroup_id = fnd_api.g_miss_num
5452: THEN
5453: g_group_id_tbl(2) := NULL;
5454: OPEN c_get_group_id (l_rs_id);
5455: FETCH c_get_group_id INTO g_group_id_tbl(2);
5514: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5515: 'Get_Available_Resource: Start');
5516: END IF;
5517:
5518: x_return_status := FND_API.G_RET_STS_SUCCESS;
5519:
5520: -- Get sales team for the sales lead
5521: OPEN c_get_lead_resource(p_sales_lead_id);
5522: FETCH c_get_lead_resource BULK COLLECT INTO
5549: -- Check the calendar for resource availability
5550: -- Call Calendar API
5551: JTF_CALENDAR_PUB.GET_AVAILABLE_SLOT(
5552: P_API_VERSION => 1.0,
5553: P_INIT_MSG_LIST => FND_API.G_FALSE,
5554: P_RESOURCE_ID => l_resource_id_tbl(l_index1),
5555: P_RESOURCE_TYPE => 'RS_EMPLOYEE',
5556: P_START_DATE_TIME => SYSDATE-1,
5557: P_END_DATE_TIME => SYSDATE+1,
5563: X_SLOT_END_DATE => l_planned_end_date,
5564: X_SHIFT_CONSTRUCT_ID => l_shift_construct_id,
5565: X_AVAILABILITY_TYPE => l_availability_type);
5566:
5567: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
5568: RAISE fnd_api.g_exc_error;
5569: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5570: RAISE fnd_api.g_exc_unexpected_error;
5571: END IF;
5564: X_SHIFT_CONSTRUCT_ID => l_shift_construct_id,
5565: X_AVAILABILITY_TYPE => l_availability_type);
5566:
5567: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
5568: RAISE fnd_api.g_exc_error;
5569: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5570: RAISE fnd_api.g_exc_unexpected_error;
5571: END IF;
5572:
5565: X_AVAILABILITY_TYPE => l_availability_type);
5566:
5567: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
5568: RAISE fnd_api.g_exc_error;
5569: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5570: RAISE fnd_api.g_exc_unexpected_error;
5571: END IF;
5572:
5573: IF (AS_DEBUG_LOW_ON) THEN
5566:
5567: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
5568: RAISE fnd_api.g_exc_error;
5569: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5570: RAISE fnd_api.g_exc_unexpected_error;
5571: END IF;
5572:
5573: IF (AS_DEBUG_LOW_ON) THEN
5574: AS_UTILITY_PVT.Debug_Message(
5669: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5670: 'Get_Owner: Start');
5671: END IF;
5672:
5673: x_return_status := FND_API.G_RET_STS_SUCCESS;
5674: IF g_resource_id_tbl.count = 0
5675: THEN
5676: Get_Alternate_Resource(p_salesgroup_id);
5677: END IF;
5764: END IF;
5765:
5766: AS_LEAD_ROUTING_WF_CUHK.Get_Owner_Pre(
5767: p_api_version_number => 2.0,
5768: p_init_msg_list => FND_API.G_FALSE,
5769: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
5770: p_commit => FND_API.G_FALSE,
5771: p_resource_id_tbl => g_resource_id_tbl,
5772: p_group_id_tbl => g_group_id_tbl,
5765:
5766: AS_LEAD_ROUTING_WF_CUHK.Get_Owner_Pre(
5767: p_api_version_number => 2.0,
5768: p_init_msg_list => FND_API.G_FALSE,
5769: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
5770: p_commit => FND_API.G_FALSE,
5771: p_resource_id_tbl => g_resource_id_tbl,
5772: p_group_id_tbl => g_group_id_tbl,
5773: p_person_id_tbl => g_person_id_tbl,
5766: AS_LEAD_ROUTING_WF_CUHK.Get_Owner_Pre(
5767: p_api_version_number => 2.0,
5768: p_init_msg_list => FND_API.G_FALSE,
5769: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
5770: p_commit => FND_API.G_FALSE,
5771: p_resource_id_tbl => g_resource_id_tbl,
5772: p_group_id_tbl => g_group_id_tbl,
5773: p_person_id_tbl => g_person_id_tbl,
5774: p_resource_flag_tbl => g_resource_flag_tbl,
5779: x_return_status => x_return_status,
5780: x_msg_count => x_msg_count,
5781: x_msg_data => x_msg_data);
5782:
5783: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
5784: RAISE fnd_api.g_exc_error;
5785: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5786: RAISE fnd_api.g_exc_unexpected_error;
5787: END IF;
5780: x_msg_count => x_msg_count,
5781: x_msg_data => x_msg_data);
5782:
5783: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
5784: RAISE fnd_api.g_exc_error;
5785: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5786: RAISE fnd_api.g_exc_unexpected_error;
5787: END IF;
5788: END IF; -- call user hook
5781: x_msg_data => x_msg_data);
5782:
5783: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
5784: RAISE fnd_api.g_exc_error;
5785: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5786: RAISE fnd_api.g_exc_unexpected_error;
5787: END IF;
5788: END IF; -- call user hook
5789:
5782:
5783: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
5784: RAISE fnd_api.g_exc_error;
5785: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5786: RAISE fnd_api.g_exc_unexpected_error;
5787: END IF;
5788: END IF; -- call user hook
5789:
5790: IF (l_call_user_hook AND l_resource_id IS NULL) OR
5924: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5925: 'group id in upd='||p_group_id);
5926: END IF;
5927:
5928: x_return_status := FND_API.G_RET_STS_SUCCESS;
5929: OPEN c_sales_lead(p_sales_lead_id);
5930: FETCH c_sales_lead INTO l_customer_id, l_address_id,
5931: l_reject_reason_code, l_lead_rank_id,
5932: l_qualified_flag, l_status_code;
5961: AS_SALES_LEADS_PKG.Sales_Lead_Update_Row(
5962: p_SALES_LEAD_ID => p_SALES_LEAD_ID,
5963: p_LAST_UPDATE_DATE => SYSDATE,
5964: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
5965: p_CREATION_DATE => FND_API.G_MISS_DATE,
5966: p_CREATED_BY => FND_API.G_MISS_NUM,
5967: p_LAST_UPDATE_LOGIN => FND_API.G_MISS_NUM,
5968: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,
5969: p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id,
5962: p_SALES_LEAD_ID => p_SALES_LEAD_ID,
5963: p_LAST_UPDATE_DATE => SYSDATE,
5964: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
5965: p_CREATION_DATE => FND_API.G_MISS_DATE,
5966: p_CREATED_BY => FND_API.G_MISS_NUM,
5967: p_LAST_UPDATE_LOGIN => FND_API.G_MISS_NUM,
5968: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,
5969: p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id,
5970: p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id,
5963: p_LAST_UPDATE_DATE => SYSDATE,
5964: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
5965: p_CREATION_DATE => FND_API.G_MISS_DATE,
5966: p_CREATED_BY => FND_API.G_MISS_NUM,
5967: p_LAST_UPDATE_LOGIN => FND_API.G_MISS_NUM,
5968: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,
5969: p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id,
5970: p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id,
5971: p_PROGRAM_UPDATE_DATE => SYSDATE,
5968: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,
5969: p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id,
5970: p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id,
5971: p_PROGRAM_UPDATE_DATE => SYSDATE,
5972: p_LEAD_NUMBER => FND_API.G_MISS_CHAR,
5973: p_STATUS_CODE => FND_API.G_MISS_CHAR, --l_routing_status,
5974: p_CUSTOMER_ID => l_CUSTOMER_ID,
5975: p_ADDRESS_ID => l_ADDRESS_ID,
5976: p_SOURCE_PROMOTION_ID => FND_API.G_MISS_NUM,
5969: p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id,
5970: p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id,
5971: p_PROGRAM_UPDATE_DATE => SYSDATE,
5972: p_LEAD_NUMBER => FND_API.G_MISS_CHAR,
5973: p_STATUS_CODE => FND_API.G_MISS_CHAR, --l_routing_status,
5974: p_CUSTOMER_ID => l_CUSTOMER_ID,
5975: p_ADDRESS_ID => l_ADDRESS_ID,
5976: p_SOURCE_PROMOTION_ID => FND_API.G_MISS_NUM,
5977: p_INITIATING_CONTACT_ID => FND_API.G_MISS_NUM,
5972: p_LEAD_NUMBER => FND_API.G_MISS_CHAR,
5973: p_STATUS_CODE => FND_API.G_MISS_CHAR, --l_routing_status,
5974: p_CUSTOMER_ID => l_CUSTOMER_ID,
5975: p_ADDRESS_ID => l_ADDRESS_ID,
5976: p_SOURCE_PROMOTION_ID => FND_API.G_MISS_NUM,
5977: p_INITIATING_CONTACT_ID => FND_API.G_MISS_NUM,
5978: p_ORIG_SYSTEM_REFERENCE => FND_API.G_MISS_CHAR,
5979: p_CONTACT_ROLE_CODE => FND_API.G_MISS_CHAR,
5980: p_CHANNEL_CODE => FND_API.G_MISS_CHAR,
5973: p_STATUS_CODE => FND_API.G_MISS_CHAR, --l_routing_status,
5974: p_CUSTOMER_ID => l_CUSTOMER_ID,
5975: p_ADDRESS_ID => l_ADDRESS_ID,
5976: p_SOURCE_PROMOTION_ID => FND_API.G_MISS_NUM,
5977: p_INITIATING_CONTACT_ID => FND_API.G_MISS_NUM,
5978: p_ORIG_SYSTEM_REFERENCE => FND_API.G_MISS_CHAR,
5979: p_CONTACT_ROLE_CODE => FND_API.G_MISS_CHAR,
5980: p_CHANNEL_CODE => FND_API.G_MISS_CHAR,
5981: p_BUDGET_AMOUNT => FND_API.G_MISS_NUM,
5974: p_CUSTOMER_ID => l_CUSTOMER_ID,
5975: p_ADDRESS_ID => l_ADDRESS_ID,
5976: p_SOURCE_PROMOTION_ID => FND_API.G_MISS_NUM,
5977: p_INITIATING_CONTACT_ID => FND_API.G_MISS_NUM,
5978: p_ORIG_SYSTEM_REFERENCE => FND_API.G_MISS_CHAR,
5979: p_CONTACT_ROLE_CODE => FND_API.G_MISS_CHAR,
5980: p_CHANNEL_CODE => FND_API.G_MISS_CHAR,
5981: p_BUDGET_AMOUNT => FND_API.G_MISS_NUM,
5982: p_CURRENCY_CODE => FND_API.G_MISS_CHAR,
5975: p_ADDRESS_ID => l_ADDRESS_ID,
5976: p_SOURCE_PROMOTION_ID => FND_API.G_MISS_NUM,
5977: p_INITIATING_CONTACT_ID => FND_API.G_MISS_NUM,
5978: p_ORIG_SYSTEM_REFERENCE => FND_API.G_MISS_CHAR,
5979: p_CONTACT_ROLE_CODE => FND_API.G_MISS_CHAR,
5980: p_CHANNEL_CODE => FND_API.G_MISS_CHAR,
5981: p_BUDGET_AMOUNT => FND_API.G_MISS_NUM,
5982: p_CURRENCY_CODE => FND_API.G_MISS_CHAR,
5983: p_DECISION_TIMEFRAME_CODE => FND_API.G_MISS_CHAR,
5976: p_SOURCE_PROMOTION_ID => FND_API.G_MISS_NUM,
5977: p_INITIATING_CONTACT_ID => FND_API.G_MISS_NUM,
5978: p_ORIG_SYSTEM_REFERENCE => FND_API.G_MISS_CHAR,
5979: p_CONTACT_ROLE_CODE => FND_API.G_MISS_CHAR,
5980: p_CHANNEL_CODE => FND_API.G_MISS_CHAR,
5981: p_BUDGET_AMOUNT => FND_API.G_MISS_NUM,
5982: p_CURRENCY_CODE => FND_API.G_MISS_CHAR,
5983: p_DECISION_TIMEFRAME_CODE => FND_API.G_MISS_CHAR,
5984: p_CLOSE_REASON => FND_API.G_MISS_CHAR,
5977: p_INITIATING_CONTACT_ID => FND_API.G_MISS_NUM,
5978: p_ORIG_SYSTEM_REFERENCE => FND_API.G_MISS_CHAR,
5979: p_CONTACT_ROLE_CODE => FND_API.G_MISS_CHAR,
5980: p_CHANNEL_CODE => FND_API.G_MISS_CHAR,
5981: p_BUDGET_AMOUNT => FND_API.G_MISS_NUM,
5982: p_CURRENCY_CODE => FND_API.G_MISS_CHAR,
5983: p_DECISION_TIMEFRAME_CODE => FND_API.G_MISS_CHAR,
5984: p_CLOSE_REASON => FND_API.G_MISS_CHAR,
5985: p_LEAD_RANK_ID => FND_API.G_MISS_NUM,
5978: p_ORIG_SYSTEM_REFERENCE => FND_API.G_MISS_CHAR,
5979: p_CONTACT_ROLE_CODE => FND_API.G_MISS_CHAR,
5980: p_CHANNEL_CODE => FND_API.G_MISS_CHAR,
5981: p_BUDGET_AMOUNT => FND_API.G_MISS_NUM,
5982: p_CURRENCY_CODE => FND_API.G_MISS_CHAR,
5983: p_DECISION_TIMEFRAME_CODE => FND_API.G_MISS_CHAR,
5984: p_CLOSE_REASON => FND_API.G_MISS_CHAR,
5985: p_LEAD_RANK_ID => FND_API.G_MISS_NUM,
5986: p_LEAD_RANK_CODE => FND_API.G_MISS_CHAR,
5979: p_CONTACT_ROLE_CODE => FND_API.G_MISS_CHAR,
5980: p_CHANNEL_CODE => FND_API.G_MISS_CHAR,
5981: p_BUDGET_AMOUNT => FND_API.G_MISS_NUM,
5982: p_CURRENCY_CODE => FND_API.G_MISS_CHAR,
5983: p_DECISION_TIMEFRAME_CODE => FND_API.G_MISS_CHAR,
5984: p_CLOSE_REASON => FND_API.G_MISS_CHAR,
5985: p_LEAD_RANK_ID => FND_API.G_MISS_NUM,
5986: p_LEAD_RANK_CODE => FND_API.G_MISS_CHAR,
5987: p_PARENT_PROJECT => FND_API.G_MISS_CHAR,
5980: p_CHANNEL_CODE => FND_API.G_MISS_CHAR,
5981: p_BUDGET_AMOUNT => FND_API.G_MISS_NUM,
5982: p_CURRENCY_CODE => FND_API.G_MISS_CHAR,
5983: p_DECISION_TIMEFRAME_CODE => FND_API.G_MISS_CHAR,
5984: p_CLOSE_REASON => FND_API.G_MISS_CHAR,
5985: p_LEAD_RANK_ID => FND_API.G_MISS_NUM,
5986: p_LEAD_RANK_CODE => FND_API.G_MISS_CHAR,
5987: p_PARENT_PROJECT => FND_API.G_MISS_CHAR,
5988: p_DESCRIPTION => FND_API.G_MISS_CHAR,
5981: p_BUDGET_AMOUNT => FND_API.G_MISS_NUM,
5982: p_CURRENCY_CODE => FND_API.G_MISS_CHAR,
5983: p_DECISION_TIMEFRAME_CODE => FND_API.G_MISS_CHAR,
5984: p_CLOSE_REASON => FND_API.G_MISS_CHAR,
5985: p_LEAD_RANK_ID => FND_API.G_MISS_NUM,
5986: p_LEAD_RANK_CODE => FND_API.G_MISS_CHAR,
5987: p_PARENT_PROJECT => FND_API.G_MISS_CHAR,
5988: p_DESCRIPTION => FND_API.G_MISS_CHAR,
5989: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
5982: p_CURRENCY_CODE => FND_API.G_MISS_CHAR,
5983: p_DECISION_TIMEFRAME_CODE => FND_API.G_MISS_CHAR,
5984: p_CLOSE_REASON => FND_API.G_MISS_CHAR,
5985: p_LEAD_RANK_ID => FND_API.G_MISS_NUM,
5986: p_LEAD_RANK_CODE => FND_API.G_MISS_CHAR,
5987: p_PARENT_PROJECT => FND_API.G_MISS_CHAR,
5988: p_DESCRIPTION => FND_API.G_MISS_CHAR,
5989: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
5990: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
5983: p_DECISION_TIMEFRAME_CODE => FND_API.G_MISS_CHAR,
5984: p_CLOSE_REASON => FND_API.G_MISS_CHAR,
5985: p_LEAD_RANK_ID => FND_API.G_MISS_NUM,
5986: p_LEAD_RANK_CODE => FND_API.G_MISS_CHAR,
5987: p_PARENT_PROJECT => FND_API.G_MISS_CHAR,
5988: p_DESCRIPTION => FND_API.G_MISS_CHAR,
5989: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
5990: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
5991: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
5984: p_CLOSE_REASON => FND_API.G_MISS_CHAR,
5985: p_LEAD_RANK_ID => FND_API.G_MISS_NUM,
5986: p_LEAD_RANK_CODE => FND_API.G_MISS_CHAR,
5987: p_PARENT_PROJECT => FND_API.G_MISS_CHAR,
5988: p_DESCRIPTION => FND_API.G_MISS_CHAR,
5989: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
5990: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
5991: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
5992: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
5985: p_LEAD_RANK_ID => FND_API.G_MISS_NUM,
5986: p_LEAD_RANK_CODE => FND_API.G_MISS_CHAR,
5987: p_PARENT_PROJECT => FND_API.G_MISS_CHAR,
5988: p_DESCRIPTION => FND_API.G_MISS_CHAR,
5989: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
5990: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
5991: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
5992: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
5993: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
5986: p_LEAD_RANK_CODE => FND_API.G_MISS_CHAR,
5987: p_PARENT_PROJECT => FND_API.G_MISS_CHAR,
5988: p_DESCRIPTION => FND_API.G_MISS_CHAR,
5989: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
5990: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
5991: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
5992: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
5993: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
5994: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
5987: p_PARENT_PROJECT => FND_API.G_MISS_CHAR,
5988: p_DESCRIPTION => FND_API.G_MISS_CHAR,
5989: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
5990: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
5991: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
5992: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
5993: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
5994: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
5995: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
5988: p_DESCRIPTION => FND_API.G_MISS_CHAR,
5989: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
5990: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
5991: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
5992: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
5993: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
5994: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
5995: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
5996: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
5989: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
5990: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
5991: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
5992: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
5993: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
5994: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
5995: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
5996: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
5997: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
5990: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
5991: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
5992: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
5993: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
5994: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
5995: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
5996: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
5997: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
5998: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
5991: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
5992: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
5993: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
5994: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
5995: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
5996: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
5997: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
5998: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
5999: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
5992: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
5993: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
5994: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
5995: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
5996: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
5997: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
5998: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
5999: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
6000: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
5993: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
5994: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
5995: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
5996: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
5997: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
5998: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
5999: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
6000: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
6001: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
5994: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
5995: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
5996: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
5997: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
5998: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
5999: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
6000: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
6001: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
6002: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
5995: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
5996: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
5997: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
5998: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
5999: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
6000: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
6001: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
6002: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
6003: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
5996: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
5997: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
5998: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
5999: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
6000: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
6001: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
6002: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
6003: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
6004: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
5997: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
5998: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
5999: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
6000: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
6001: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
6002: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
6003: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
6004: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
6005: p_ASSIGN_TO_PERSON_ID => p_person_id,
5998: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
5999: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
6000: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
6001: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
6002: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
6003: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
6004: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
6005: p_ASSIGN_TO_PERSON_ID => p_person_id,
6006: p_ASSIGN_TO_SALESFORCE_ID => p_resource_id,
5999: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
6000: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
6001: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
6002: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
6003: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
6004: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
6005: p_ASSIGN_TO_PERSON_ID => p_person_id,
6006: p_ASSIGN_TO_SALESFORCE_ID => p_resource_id,
6007: p_ASSIGN_SALES_GROUP_ID => p_group_id,
6000: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
6001: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
6002: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
6003: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
6004: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
6005: p_ASSIGN_TO_PERSON_ID => p_person_id,
6006: p_ASSIGN_TO_SALESFORCE_ID => p_resource_id,
6007: p_ASSIGN_SALES_GROUP_ID => p_group_id,
6008: p_ASSIGN_DATE => SYSDATE,
6005: p_ASSIGN_TO_PERSON_ID => p_person_id,
6006: p_ASSIGN_TO_SALESFORCE_ID => p_resource_id,
6007: p_ASSIGN_SALES_GROUP_ID => p_group_id,
6008: p_ASSIGN_DATE => SYSDATE,
6009: p_BUDGET_STATUS_CODE => FND_API.G_MISS_CHAR,
6010: p_ACCEPT_FLAG => 'N',
6011: p_VEHICLE_RESPONSE_CODE => FND_API.G_MISS_CHAR,
6012: p_TOTAL_SCORE => FND_API.G_MISS_NUM,
6013: p_SCORECARD_ID => FND_API.G_MISS_NUM,
6007: p_ASSIGN_SALES_GROUP_ID => p_group_id,
6008: p_ASSIGN_DATE => SYSDATE,
6009: p_BUDGET_STATUS_CODE => FND_API.G_MISS_CHAR,
6010: p_ACCEPT_FLAG => 'N',
6011: p_VEHICLE_RESPONSE_CODE => FND_API.G_MISS_CHAR,
6012: p_TOTAL_SCORE => FND_API.G_MISS_NUM,
6013: p_SCORECARD_ID => FND_API.G_MISS_NUM,
6014: p_KEEP_FLAG => FND_API.G_MISS_CHAR,
6015: p_URGENT_FLAG => FND_API.G_MISS_CHAR,
6008: p_ASSIGN_DATE => SYSDATE,
6009: p_BUDGET_STATUS_CODE => FND_API.G_MISS_CHAR,
6010: p_ACCEPT_FLAG => 'N',
6011: p_VEHICLE_RESPONSE_CODE => FND_API.G_MISS_CHAR,
6012: p_TOTAL_SCORE => FND_API.G_MISS_NUM,
6013: p_SCORECARD_ID => FND_API.G_MISS_NUM,
6014: p_KEEP_FLAG => FND_API.G_MISS_CHAR,
6015: p_URGENT_FLAG => FND_API.G_MISS_CHAR,
6016: p_IMPORT_FLAG => FND_API.G_MISS_CHAR,
6009: p_BUDGET_STATUS_CODE => FND_API.G_MISS_CHAR,
6010: p_ACCEPT_FLAG => 'N',
6011: p_VEHICLE_RESPONSE_CODE => FND_API.G_MISS_CHAR,
6012: p_TOTAL_SCORE => FND_API.G_MISS_NUM,
6013: p_SCORECARD_ID => FND_API.G_MISS_NUM,
6014: p_KEEP_FLAG => FND_API.G_MISS_CHAR,
6015: p_URGENT_FLAG => FND_API.G_MISS_CHAR,
6016: p_IMPORT_FLAG => FND_API.G_MISS_CHAR,
6017: p_REJECT_REASON_CODE => NULL, --l_reject_reason_code,
6010: p_ACCEPT_FLAG => 'N',
6011: p_VEHICLE_RESPONSE_CODE => FND_API.G_MISS_CHAR,
6012: p_TOTAL_SCORE => FND_API.G_MISS_NUM,
6013: p_SCORECARD_ID => FND_API.G_MISS_NUM,
6014: p_KEEP_FLAG => FND_API.G_MISS_CHAR,
6015: p_URGENT_FLAG => FND_API.G_MISS_CHAR,
6016: p_IMPORT_FLAG => FND_API.G_MISS_CHAR,
6017: p_REJECT_REASON_CODE => NULL, --l_reject_reason_code,
6018: p_DELETED_FLAG => FND_API.G_MISS_CHAR,
6011: p_VEHICLE_RESPONSE_CODE => FND_API.G_MISS_CHAR,
6012: p_TOTAL_SCORE => FND_API.G_MISS_NUM,
6013: p_SCORECARD_ID => FND_API.G_MISS_NUM,
6014: p_KEEP_FLAG => FND_API.G_MISS_CHAR,
6015: p_URGENT_FLAG => FND_API.G_MISS_CHAR,
6016: p_IMPORT_FLAG => FND_API.G_MISS_CHAR,
6017: p_REJECT_REASON_CODE => NULL, --l_reject_reason_code,
6018: p_DELETED_FLAG => FND_API.G_MISS_CHAR,
6019: p_OFFER_ID => FND_API.G_MISS_NUM,
6012: p_TOTAL_SCORE => FND_API.G_MISS_NUM,
6013: p_SCORECARD_ID => FND_API.G_MISS_NUM,
6014: p_KEEP_FLAG => FND_API.G_MISS_CHAR,
6015: p_URGENT_FLAG => FND_API.G_MISS_CHAR,
6016: p_IMPORT_FLAG => FND_API.G_MISS_CHAR,
6017: p_REJECT_REASON_CODE => NULL, --l_reject_reason_code,
6018: p_DELETED_FLAG => FND_API.G_MISS_CHAR,
6019: p_OFFER_ID => FND_API.G_MISS_NUM,
6020: p_QUALIFIED_FLAG => l_qualified_flag,
6014: p_KEEP_FLAG => FND_API.G_MISS_CHAR,
6015: p_URGENT_FLAG => FND_API.G_MISS_CHAR,
6016: p_IMPORT_FLAG => FND_API.G_MISS_CHAR,
6017: p_REJECT_REASON_CODE => NULL, --l_reject_reason_code,
6018: p_DELETED_FLAG => FND_API.G_MISS_CHAR,
6019: p_OFFER_ID => FND_API.G_MISS_NUM,
6020: p_QUALIFIED_FLAG => l_qualified_flag,
6021: p_ORIG_SYSTEM_CODE => FND_API.G_MISS_CHAR,
6022: p_INC_PARTNER_PARTY_ID => FND_API.G_MISS_NUM,
6015: p_URGENT_FLAG => FND_API.G_MISS_CHAR,
6016: p_IMPORT_FLAG => FND_API.G_MISS_CHAR,
6017: p_REJECT_REASON_CODE => NULL, --l_reject_reason_code,
6018: p_DELETED_FLAG => FND_API.G_MISS_CHAR,
6019: p_OFFER_ID => FND_API.G_MISS_NUM,
6020: p_QUALIFIED_FLAG => l_qualified_flag,
6021: p_ORIG_SYSTEM_CODE => FND_API.G_MISS_CHAR,
6022: p_INC_PARTNER_PARTY_ID => FND_API.G_MISS_NUM,
6023: p_INC_PARTNER_RESOURCE_ID => FND_API.G_MISS_NUM,
6017: p_REJECT_REASON_CODE => NULL, --l_reject_reason_code,
6018: p_DELETED_FLAG => FND_API.G_MISS_CHAR,
6019: p_OFFER_ID => FND_API.G_MISS_NUM,
6020: p_QUALIFIED_FLAG => l_qualified_flag,
6021: p_ORIG_SYSTEM_CODE => FND_API.G_MISS_CHAR,
6022: p_INC_PARTNER_PARTY_ID => FND_API.G_MISS_NUM,
6023: p_INC_PARTNER_RESOURCE_ID => FND_API.G_MISS_NUM,
6024: p_PRM_EXEC_SPONSOR_FLAG => FND_API.G_MISS_CHAR,
6025: p_PRM_PRJ_LEAD_IN_PLACE_FLAG => FND_API.G_MISS_CHAR,
6018: p_DELETED_FLAG => FND_API.G_MISS_CHAR,
6019: p_OFFER_ID => FND_API.G_MISS_NUM,
6020: p_QUALIFIED_FLAG => l_qualified_flag,
6021: p_ORIG_SYSTEM_CODE => FND_API.G_MISS_CHAR,
6022: p_INC_PARTNER_PARTY_ID => FND_API.G_MISS_NUM,
6023: p_INC_PARTNER_RESOURCE_ID => FND_API.G_MISS_NUM,
6024: p_PRM_EXEC_SPONSOR_FLAG => FND_API.G_MISS_CHAR,
6025: p_PRM_PRJ_LEAD_IN_PLACE_FLAG => FND_API.G_MISS_CHAR,
6026: p_PRM_SALES_LEAD_TYPE => FND_API.G_MISS_CHAR,
6019: p_OFFER_ID => FND_API.G_MISS_NUM,
6020: p_QUALIFIED_FLAG => l_qualified_flag,
6021: p_ORIG_SYSTEM_CODE => FND_API.G_MISS_CHAR,
6022: p_INC_PARTNER_PARTY_ID => FND_API.G_MISS_NUM,
6023: p_INC_PARTNER_RESOURCE_ID => FND_API.G_MISS_NUM,
6024: p_PRM_EXEC_SPONSOR_FLAG => FND_API.G_MISS_CHAR,
6025: p_PRM_PRJ_LEAD_IN_PLACE_FLAG => FND_API.G_MISS_CHAR,
6026: p_PRM_SALES_LEAD_TYPE => FND_API.G_MISS_CHAR,
6027: p_PRM_IND_CLASSIFICATION_CODE => FND_API.G_MISS_CHAR,
6020: p_QUALIFIED_FLAG => l_qualified_flag,
6021: p_ORIG_SYSTEM_CODE => FND_API.G_MISS_CHAR,
6022: p_INC_PARTNER_PARTY_ID => FND_API.G_MISS_NUM,
6023: p_INC_PARTNER_RESOURCE_ID => FND_API.G_MISS_NUM,
6024: p_PRM_EXEC_SPONSOR_FLAG => FND_API.G_MISS_CHAR,
6025: p_PRM_PRJ_LEAD_IN_PLACE_FLAG => FND_API.G_MISS_CHAR,
6026: p_PRM_SALES_LEAD_TYPE => FND_API.G_MISS_CHAR,
6027: p_PRM_IND_CLASSIFICATION_CODE => FND_API.G_MISS_CHAR,
6028: p_PRM_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
6021: p_ORIG_SYSTEM_CODE => FND_API.G_MISS_CHAR,
6022: p_INC_PARTNER_PARTY_ID => FND_API.G_MISS_NUM,
6023: p_INC_PARTNER_RESOURCE_ID => FND_API.G_MISS_NUM,
6024: p_PRM_EXEC_SPONSOR_FLAG => FND_API.G_MISS_CHAR,
6025: p_PRM_PRJ_LEAD_IN_PLACE_FLAG => FND_API.G_MISS_CHAR,
6026: p_PRM_SALES_LEAD_TYPE => FND_API.G_MISS_CHAR,
6027: p_PRM_IND_CLASSIFICATION_CODE => FND_API.G_MISS_CHAR,
6028: p_PRM_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
6029: p_AUTO_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
6022: p_INC_PARTNER_PARTY_ID => FND_API.G_MISS_NUM,
6023: p_INC_PARTNER_RESOURCE_ID => FND_API.G_MISS_NUM,
6024: p_PRM_EXEC_SPONSOR_FLAG => FND_API.G_MISS_CHAR,
6025: p_PRM_PRJ_LEAD_IN_PLACE_FLAG => FND_API.G_MISS_CHAR,
6026: p_PRM_SALES_LEAD_TYPE => FND_API.G_MISS_CHAR,
6027: p_PRM_IND_CLASSIFICATION_CODE => FND_API.G_MISS_CHAR,
6028: p_PRM_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
6029: p_AUTO_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
6030: p_PRIMARY_CONTACT_PARTY_ID => FND_API.G_MISS_NUM,
6023: p_INC_PARTNER_RESOURCE_ID => FND_API.G_MISS_NUM,
6024: p_PRM_EXEC_SPONSOR_FLAG => FND_API.G_MISS_CHAR,
6025: p_PRM_PRJ_LEAD_IN_PLACE_FLAG => FND_API.G_MISS_CHAR,
6026: p_PRM_SALES_LEAD_TYPE => FND_API.G_MISS_CHAR,
6027: p_PRM_IND_CLASSIFICATION_CODE => FND_API.G_MISS_CHAR,
6028: p_PRM_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
6029: p_AUTO_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
6030: p_PRIMARY_CONTACT_PARTY_ID => FND_API.G_MISS_NUM,
6031: p_PRIMARY_CNT_PERSON_PARTY_ID => FND_API.G_MISS_NUM,
6024: p_PRM_EXEC_SPONSOR_FLAG => FND_API.G_MISS_CHAR,
6025: p_PRM_PRJ_LEAD_IN_PLACE_FLAG => FND_API.G_MISS_CHAR,
6026: p_PRM_SALES_LEAD_TYPE => FND_API.G_MISS_CHAR,
6027: p_PRM_IND_CLASSIFICATION_CODE => FND_API.G_MISS_CHAR,
6028: p_PRM_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
6029: p_AUTO_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
6030: p_PRIMARY_CONTACT_PARTY_ID => FND_API.G_MISS_NUM,
6031: p_PRIMARY_CNT_PERSON_PARTY_ID => FND_API.G_MISS_NUM,
6032: p_PRIMARY_CONTACT_PHONE_ID => FND_API.G_MISS_NUM,
6025: p_PRM_PRJ_LEAD_IN_PLACE_FLAG => FND_API.G_MISS_CHAR,
6026: p_PRM_SALES_LEAD_TYPE => FND_API.G_MISS_CHAR,
6027: p_PRM_IND_CLASSIFICATION_CODE => FND_API.G_MISS_CHAR,
6028: p_PRM_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
6029: p_AUTO_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
6030: p_PRIMARY_CONTACT_PARTY_ID => FND_API.G_MISS_NUM,
6031: p_PRIMARY_CNT_PERSON_PARTY_ID => FND_API.G_MISS_NUM,
6032: p_PRIMARY_CONTACT_PHONE_ID => FND_API.G_MISS_NUM,
6033: p_REFERRED_BY => FND_API.G_MISS_NUM,
6026: p_PRM_SALES_LEAD_TYPE => FND_API.G_MISS_CHAR,
6027: p_PRM_IND_CLASSIFICATION_CODE => FND_API.G_MISS_CHAR,
6028: p_PRM_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
6029: p_AUTO_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
6030: p_PRIMARY_CONTACT_PARTY_ID => FND_API.G_MISS_NUM,
6031: p_PRIMARY_CNT_PERSON_PARTY_ID => FND_API.G_MISS_NUM,
6032: p_PRIMARY_CONTACT_PHONE_ID => FND_API.G_MISS_NUM,
6033: p_REFERRED_BY => FND_API.G_MISS_NUM,
6034: p_REFERRAL_TYPE => FND_API.G_MISS_CHAR,
6027: p_PRM_IND_CLASSIFICATION_CODE => FND_API.G_MISS_CHAR,
6028: p_PRM_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
6029: p_AUTO_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
6030: p_PRIMARY_CONTACT_PARTY_ID => FND_API.G_MISS_NUM,
6031: p_PRIMARY_CNT_PERSON_PARTY_ID => FND_API.G_MISS_NUM,
6032: p_PRIMARY_CONTACT_PHONE_ID => FND_API.G_MISS_NUM,
6033: p_REFERRED_BY => FND_API.G_MISS_NUM,
6034: p_REFERRAL_TYPE => FND_API.G_MISS_CHAR,
6035: p_REFERRAL_STATUS => FND_API.G_MISS_CHAR,
6028: p_PRM_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
6029: p_AUTO_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
6030: p_PRIMARY_CONTACT_PARTY_ID => FND_API.G_MISS_NUM,
6031: p_PRIMARY_CNT_PERSON_PARTY_ID => FND_API.G_MISS_NUM,
6032: p_PRIMARY_CONTACT_PHONE_ID => FND_API.G_MISS_NUM,
6033: p_REFERRED_BY => FND_API.G_MISS_NUM,
6034: p_REFERRAL_TYPE => FND_API.G_MISS_CHAR,
6035: p_REFERRAL_STATUS => FND_API.G_MISS_CHAR,
6036: p_REF_DECLINE_REASON => FND_API.G_MISS_CHAR,
6029: p_AUTO_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
6030: p_PRIMARY_CONTACT_PARTY_ID => FND_API.G_MISS_NUM,
6031: p_PRIMARY_CNT_PERSON_PARTY_ID => FND_API.G_MISS_NUM,
6032: p_PRIMARY_CONTACT_PHONE_ID => FND_API.G_MISS_NUM,
6033: p_REFERRED_BY => FND_API.G_MISS_NUM,
6034: p_REFERRAL_TYPE => FND_API.G_MISS_CHAR,
6035: p_REFERRAL_STATUS => FND_API.G_MISS_CHAR,
6036: p_REF_DECLINE_REASON => FND_API.G_MISS_CHAR,
6037: p_REF_COMM_LTR_STATUS => FND_API.G_MISS_CHAR,
6030: p_PRIMARY_CONTACT_PARTY_ID => FND_API.G_MISS_NUM,
6031: p_PRIMARY_CNT_PERSON_PARTY_ID => FND_API.G_MISS_NUM,
6032: p_PRIMARY_CONTACT_PHONE_ID => FND_API.G_MISS_NUM,
6033: p_REFERRED_BY => FND_API.G_MISS_NUM,
6034: p_REFERRAL_TYPE => FND_API.G_MISS_CHAR,
6035: p_REFERRAL_STATUS => FND_API.G_MISS_CHAR,
6036: p_REF_DECLINE_REASON => FND_API.G_MISS_CHAR,
6037: p_REF_COMM_LTR_STATUS => FND_API.G_MISS_CHAR,
6038: p_REF_ORDER_NUMBER => FND_API.G_MISS_NUM,
6031: p_PRIMARY_CNT_PERSON_PARTY_ID => FND_API.G_MISS_NUM,
6032: p_PRIMARY_CONTACT_PHONE_ID => FND_API.G_MISS_NUM,
6033: p_REFERRED_BY => FND_API.G_MISS_NUM,
6034: p_REFERRAL_TYPE => FND_API.G_MISS_CHAR,
6035: p_REFERRAL_STATUS => FND_API.G_MISS_CHAR,
6036: p_REF_DECLINE_REASON => FND_API.G_MISS_CHAR,
6037: p_REF_COMM_LTR_STATUS => FND_API.G_MISS_CHAR,
6038: p_REF_ORDER_NUMBER => FND_API.G_MISS_NUM,
6039: p_REF_ORDER_AMT => FND_API.G_MISS_NUM,
6032: p_PRIMARY_CONTACT_PHONE_ID => FND_API.G_MISS_NUM,
6033: p_REFERRED_BY => FND_API.G_MISS_NUM,
6034: p_REFERRAL_TYPE => FND_API.G_MISS_CHAR,
6035: p_REFERRAL_STATUS => FND_API.G_MISS_CHAR,
6036: p_REF_DECLINE_REASON => FND_API.G_MISS_CHAR,
6037: p_REF_COMM_LTR_STATUS => FND_API.G_MISS_CHAR,
6038: p_REF_ORDER_NUMBER => FND_API.G_MISS_NUM,
6039: p_REF_ORDER_AMT => FND_API.G_MISS_NUM,
6040: p_REF_COMM_AMT => FND_API.G_MISS_NUM,
6033: p_REFERRED_BY => FND_API.G_MISS_NUM,
6034: p_REFERRAL_TYPE => FND_API.G_MISS_CHAR,
6035: p_REFERRAL_STATUS => FND_API.G_MISS_CHAR,
6036: p_REF_DECLINE_REASON => FND_API.G_MISS_CHAR,
6037: p_REF_COMM_LTR_STATUS => FND_API.G_MISS_CHAR,
6038: p_REF_ORDER_NUMBER => FND_API.G_MISS_NUM,
6039: p_REF_ORDER_AMT => FND_API.G_MISS_NUM,
6040: p_REF_COMM_AMT => FND_API.G_MISS_NUM,
6041: -- bug No.2341515, 2368075
6034: p_REFERRAL_TYPE => FND_API.G_MISS_CHAR,
6035: p_REFERRAL_STATUS => FND_API.G_MISS_CHAR,
6036: p_REF_DECLINE_REASON => FND_API.G_MISS_CHAR,
6037: p_REF_COMM_LTR_STATUS => FND_API.G_MISS_CHAR,
6038: p_REF_ORDER_NUMBER => FND_API.G_MISS_NUM,
6039: p_REF_ORDER_AMT => FND_API.G_MISS_NUM,
6040: p_REF_COMM_AMT => FND_API.G_MISS_NUM,
6041: -- bug No.2341515, 2368075
6042: p_LEAD_DATE => FND_API.G_MISS_DATE,
6035: p_REFERRAL_STATUS => FND_API.G_MISS_CHAR,
6036: p_REF_DECLINE_REASON => FND_API.G_MISS_CHAR,
6037: p_REF_COMM_LTR_STATUS => FND_API.G_MISS_CHAR,
6038: p_REF_ORDER_NUMBER => FND_API.G_MISS_NUM,
6039: p_REF_ORDER_AMT => FND_API.G_MISS_NUM,
6040: p_REF_COMM_AMT => FND_API.G_MISS_NUM,
6041: -- bug No.2341515, 2368075
6042: p_LEAD_DATE => FND_API.G_MISS_DATE,
6043: p_SOURCE_SYSTEM => FND_API.G_MISS_CHAR,
6036: p_REF_DECLINE_REASON => FND_API.G_MISS_CHAR,
6037: p_REF_COMM_LTR_STATUS => FND_API.G_MISS_CHAR,
6038: p_REF_ORDER_NUMBER => FND_API.G_MISS_NUM,
6039: p_REF_ORDER_AMT => FND_API.G_MISS_NUM,
6040: p_REF_COMM_AMT => FND_API.G_MISS_NUM,
6041: -- bug No.2341515, 2368075
6042: p_LEAD_DATE => FND_API.G_MISS_DATE,
6043: p_SOURCE_SYSTEM => FND_API.G_MISS_CHAR,
6044: p_COUNTRY => FND_API.G_MISS_CHAR,
6038: p_REF_ORDER_NUMBER => FND_API.G_MISS_NUM,
6039: p_REF_ORDER_AMT => FND_API.G_MISS_NUM,
6040: p_REF_COMM_AMT => FND_API.G_MISS_NUM,
6041: -- bug No.2341515, 2368075
6042: p_LEAD_DATE => FND_API.G_MISS_DATE,
6043: p_SOURCE_SYSTEM => FND_API.G_MISS_CHAR,
6044: p_COUNTRY => FND_API.G_MISS_CHAR,
6045: p_TOTAL_AMOUNT => FND_API.G_MISS_NUM,
6046: p_EXPIRATION_DATE => FND_API.G_MISS_DATE,
6039: p_REF_ORDER_AMT => FND_API.G_MISS_NUM,
6040: p_REF_COMM_AMT => FND_API.G_MISS_NUM,
6041: -- bug No.2341515, 2368075
6042: p_LEAD_DATE => FND_API.G_MISS_DATE,
6043: p_SOURCE_SYSTEM => FND_API.G_MISS_CHAR,
6044: p_COUNTRY => FND_API.G_MISS_CHAR,
6045: p_TOTAL_AMOUNT => FND_API.G_MISS_NUM,
6046: p_EXPIRATION_DATE => FND_API.G_MISS_DATE,
6047: p_LEAD_RANK_IND => FND_API.G_MISS_CHAR,
6040: p_REF_COMM_AMT => FND_API.G_MISS_NUM,
6041: -- bug No.2341515, 2368075
6042: p_LEAD_DATE => FND_API.G_MISS_DATE,
6043: p_SOURCE_SYSTEM => FND_API.G_MISS_CHAR,
6044: p_COUNTRY => FND_API.G_MISS_CHAR,
6045: p_TOTAL_AMOUNT => FND_API.G_MISS_NUM,
6046: p_EXPIRATION_DATE => FND_API.G_MISS_DATE,
6047: p_LEAD_RANK_IND => FND_API.G_MISS_CHAR,
6048: p_LEAD_ENGINE_RUN_DATE => FND_API.G_MISS_DATE,
6041: -- bug No.2341515, 2368075
6042: p_LEAD_DATE => FND_API.G_MISS_DATE,
6043: p_SOURCE_SYSTEM => FND_API.G_MISS_CHAR,
6044: p_COUNTRY => FND_API.G_MISS_CHAR,
6045: p_TOTAL_AMOUNT => FND_API.G_MISS_NUM,
6046: p_EXPIRATION_DATE => FND_API.G_MISS_DATE,
6047: p_LEAD_RANK_IND => FND_API.G_MISS_CHAR,
6048: p_LEAD_ENGINE_RUN_DATE => FND_API.G_MISS_DATE,
6049: p_CURRENT_REROUTES => FND_API.G_MISS_NUM,
6042: p_LEAD_DATE => FND_API.G_MISS_DATE,
6043: p_SOURCE_SYSTEM => FND_API.G_MISS_CHAR,
6044: p_COUNTRY => FND_API.G_MISS_CHAR,
6045: p_TOTAL_AMOUNT => FND_API.G_MISS_NUM,
6046: p_EXPIRATION_DATE => FND_API.G_MISS_DATE,
6047: p_LEAD_RANK_IND => FND_API.G_MISS_CHAR,
6048: p_LEAD_ENGINE_RUN_DATE => FND_API.G_MISS_DATE,
6049: p_CURRENT_REROUTES => FND_API.G_MISS_NUM,
6050: p_STATUS_OPEN_FLAG => FND_API.G_MISS_CHAR,
6043: p_SOURCE_SYSTEM => FND_API.G_MISS_CHAR,
6044: p_COUNTRY => FND_API.G_MISS_CHAR,
6045: p_TOTAL_AMOUNT => FND_API.G_MISS_NUM,
6046: p_EXPIRATION_DATE => FND_API.G_MISS_DATE,
6047: p_LEAD_RANK_IND => FND_API.G_MISS_CHAR,
6048: p_LEAD_ENGINE_RUN_DATE => FND_API.G_MISS_DATE,
6049: p_CURRENT_REROUTES => FND_API.G_MISS_NUM,
6050: p_STATUS_OPEN_FLAG => FND_API.G_MISS_CHAR,
6051: p_LEAD_RANK_SCORE => FND_API.G_MISS_NUM,
6044: p_COUNTRY => FND_API.G_MISS_CHAR,
6045: p_TOTAL_AMOUNT => FND_API.G_MISS_NUM,
6046: p_EXPIRATION_DATE => FND_API.G_MISS_DATE,
6047: p_LEAD_RANK_IND => FND_API.G_MISS_CHAR,
6048: p_LEAD_ENGINE_RUN_DATE => FND_API.G_MISS_DATE,
6049: p_CURRENT_REROUTES => FND_API.G_MISS_NUM,
6050: p_STATUS_OPEN_FLAG => FND_API.G_MISS_CHAR,
6051: p_LEAD_RANK_SCORE => FND_API.G_MISS_NUM,
6052: -- 11.5.10 new columns
6045: p_TOTAL_AMOUNT => FND_API.G_MISS_NUM,
6046: p_EXPIRATION_DATE => FND_API.G_MISS_DATE,
6047: p_LEAD_RANK_IND => FND_API.G_MISS_CHAR,
6048: p_LEAD_ENGINE_RUN_DATE => FND_API.G_MISS_DATE,
6049: p_CURRENT_REROUTES => FND_API.G_MISS_NUM,
6050: p_STATUS_OPEN_FLAG => FND_API.G_MISS_CHAR,
6051: p_LEAD_RANK_SCORE => FND_API.G_MISS_NUM,
6052: -- 11.5.10 new columns
6053: p_MARKETING_SCORE => FND_API.G_MISS_NUM,
6046: p_EXPIRATION_DATE => FND_API.G_MISS_DATE,
6047: p_LEAD_RANK_IND => FND_API.G_MISS_CHAR,
6048: p_LEAD_ENGINE_RUN_DATE => FND_API.G_MISS_DATE,
6049: p_CURRENT_REROUTES => FND_API.G_MISS_NUM,
6050: p_STATUS_OPEN_FLAG => FND_API.G_MISS_CHAR,
6051: p_LEAD_RANK_SCORE => FND_API.G_MISS_NUM,
6052: -- 11.5.10 new columns
6053: p_MARKETING_SCORE => FND_API.G_MISS_NUM,
6054: p_INTERACTION_SCORE => FND_API.G_MISS_NUM,
6047: p_LEAD_RANK_IND => FND_API.G_MISS_CHAR,
6048: p_LEAD_ENGINE_RUN_DATE => FND_API.G_MISS_DATE,
6049: p_CURRENT_REROUTES => FND_API.G_MISS_NUM,
6050: p_STATUS_OPEN_FLAG => FND_API.G_MISS_CHAR,
6051: p_LEAD_RANK_SCORE => FND_API.G_MISS_NUM,
6052: -- 11.5.10 new columns
6053: p_MARKETING_SCORE => FND_API.G_MISS_NUM,
6054: p_INTERACTION_SCORE => FND_API.G_MISS_NUM,
6055: p_SOURCE_PRIMARY_REFERENCE => FND_API.G_MISS_CHAR,
6049: p_CURRENT_REROUTES => FND_API.G_MISS_NUM,
6050: p_STATUS_OPEN_FLAG => FND_API.G_MISS_CHAR,
6051: p_LEAD_RANK_SCORE => FND_API.G_MISS_NUM,
6052: -- 11.5.10 new columns
6053: p_MARKETING_SCORE => FND_API.G_MISS_NUM,
6054: p_INTERACTION_SCORE => FND_API.G_MISS_NUM,
6055: p_SOURCE_PRIMARY_REFERENCE => FND_API.G_MISS_CHAR,
6056: p_SOURCE_SECONDARY_REFERENCE => FND_API.G_MISS_CHAR,
6057: p_SALES_METHODOLOGY_ID => FND_API.G_MISS_NUM,
6050: p_STATUS_OPEN_FLAG => FND_API.G_MISS_CHAR,
6051: p_LEAD_RANK_SCORE => FND_API.G_MISS_NUM,
6052: -- 11.5.10 new columns
6053: p_MARKETING_SCORE => FND_API.G_MISS_NUM,
6054: p_INTERACTION_SCORE => FND_API.G_MISS_NUM,
6055: p_SOURCE_PRIMARY_REFERENCE => FND_API.G_MISS_CHAR,
6056: p_SOURCE_SECONDARY_REFERENCE => FND_API.G_MISS_CHAR,
6057: p_SALES_METHODOLOGY_ID => FND_API.G_MISS_NUM,
6058: p_SALES_STAGE_ID => FND_API.G_MISS_NUM);
6051: p_LEAD_RANK_SCORE => FND_API.G_MISS_NUM,
6052: -- 11.5.10 new columns
6053: p_MARKETING_SCORE => FND_API.G_MISS_NUM,
6054: p_INTERACTION_SCORE => FND_API.G_MISS_NUM,
6055: p_SOURCE_PRIMARY_REFERENCE => FND_API.G_MISS_CHAR,
6056: p_SOURCE_SECONDARY_REFERENCE => FND_API.G_MISS_CHAR,
6057: p_SALES_METHODOLOGY_ID => FND_API.G_MISS_NUM,
6058: p_SALES_STAGE_ID => FND_API.G_MISS_NUM);
6059:
6052: -- 11.5.10 new columns
6053: p_MARKETING_SCORE => FND_API.G_MISS_NUM,
6054: p_INTERACTION_SCORE => FND_API.G_MISS_NUM,
6055: p_SOURCE_PRIMARY_REFERENCE => FND_API.G_MISS_CHAR,
6056: p_SOURCE_SECONDARY_REFERENCE => FND_API.G_MISS_CHAR,
6057: p_SALES_METHODOLOGY_ID => FND_API.G_MISS_NUM,
6058: p_SALES_STAGE_ID => FND_API.G_MISS_NUM);
6059:
6060:
6053: p_MARKETING_SCORE => FND_API.G_MISS_NUM,
6054: p_INTERACTION_SCORE => FND_API.G_MISS_NUM,
6055: p_SOURCE_PRIMARY_REFERENCE => FND_API.G_MISS_CHAR,
6056: p_SOURCE_SECONDARY_REFERENCE => FND_API.G_MISS_CHAR,
6057: p_SALES_METHODOLOGY_ID => FND_API.G_MISS_NUM,
6058: p_SALES_STAGE_ID => FND_API.G_MISS_NUM);
6059:
6060:
6061: OPEN c_access_exist(p_sales_lead_id, p_resource_id, p_group_id);
6054: p_INTERACTION_SCORE => FND_API.G_MISS_NUM,
6055: p_SOURCE_PRIMARY_REFERENCE => FND_API.G_MISS_CHAR,
6056: p_SOURCE_SECONDARY_REFERENCE => FND_API.G_MISS_CHAR,
6057: p_SALES_METHODOLOGY_ID => FND_API.G_MISS_NUM,
6058: p_SALES_STAGE_ID => FND_API.G_MISS_NUM);
6059:
6060:
6061: OPEN c_access_exist(p_sales_lead_id, p_resource_id, p_group_id);
6062: FETCH c_access_exist INTO l_access_exist_flag;
6143: l_return_status VARCHAR2(1);
6144: l_msg_count NUMBER;
6145: l_msg_data VARCHAR2(2000);
6146: BEGIN
6147: x_return_status := FND_API.G_RET_STS_SUCCESS;
6148: OPEN C_Get_Lead_Info(p_sales_lead_id);
6149: FETCH C_Get_Lead_Info INTO l_referral_type;
6150: CLOSE C_Get_Lead_Info;
6151:
6186: x_return_status => x_return_status,
6187: x_msg_count => x_msg_count,
6188: x_msg_data => x_msg_data);
6189:
6190: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
6191: RAISE fnd_api.g_exc_error;
6192: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
6193: RAISE fnd_api.g_exc_unexpected_error;
6194: END IF;
6187: x_msg_count => x_msg_count,
6188: x_msg_data => x_msg_data);
6189:
6190: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
6191: RAISE fnd_api.g_exc_error;
6192: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
6193: RAISE fnd_api.g_exc_unexpected_error;
6194: END IF;
6195:
6188: x_msg_data => x_msg_data);
6189:
6190: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
6191: RAISE fnd_api.g_exc_error;
6192: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
6193: RAISE fnd_api.g_exc_unexpected_error;
6194: END IF;
6195:
6196: Get_Owner(
6189:
6190: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
6191: RAISE fnd_api.g_exc_error;
6192: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
6193: RAISE fnd_api.g_exc_unexpected_error;
6194: END IF;
6195:
6196: Get_Owner(
6197: p_sales_lead_id => p_sales_lead_id,
6202: x_return_status => l_return_status,
6203: x_msg_count => x_msg_count,
6204: x_msg_data => x_msg_data);
6205:
6206: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
6207: RAISE fnd_api.g_exc_error;
6208: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
6209: RAISE fnd_api.g_exc_unexpected_error;
6210: END IF;
6203: x_msg_count => x_msg_count,
6204: x_msg_data => x_msg_data);
6205:
6206: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
6207: RAISE fnd_api.g_exc_error;
6208: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
6209: RAISE fnd_api.g_exc_unexpected_error;
6210: END IF;
6211:
6204: x_msg_data => x_msg_data);
6205:
6206: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
6207: RAISE fnd_api.g_exc_error;
6208: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
6209: RAISE fnd_api.g_exc_unexpected_error;
6210: END IF;
6211:
6212: Update_Sales_Leads (
6205:
6206: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
6207: RAISE fnd_api.g_exc_error;
6208: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
6209: RAISE fnd_api.g_exc_unexpected_error;
6210: END IF;
6211:
6212: Update_Sales_Leads (
6213: p_sales_lead_id => p_sales_lead_id,
6217: x_return_status => x_return_status,
6218: x_msg_count => x_msg_count,
6219: x_msg_data => x_msg_data);
6220:
6221: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
6222: RAISE fnd_api.g_exc_error;
6223: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
6224: RAISE fnd_api.g_exc_unexpected_error;
6225: END IF;
6218: x_msg_count => x_msg_count,
6219: x_msg_data => x_msg_data);
6220:
6221: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
6222: RAISE fnd_api.g_exc_error;
6223: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
6224: RAISE fnd_api.g_exc_unexpected_error;
6225: END IF;
6226:
6219: x_msg_data => x_msg_data);
6220:
6221: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
6222: RAISE fnd_api.g_exc_error;
6223: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
6224: RAISE fnd_api.g_exc_unexpected_error;
6225: END IF;
6226:
6227: IF l_return_status = 'W' THEN
6220:
6221: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
6222: RAISE fnd_api.g_exc_error;
6223: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
6224: RAISE fnd_api.g_exc_unexpected_error;
6225: END IF;
6226:
6227: IF l_return_status = 'W' THEN
6228: x_return_status := 'W';