79:
80: -- ffang 091400, Add p_mode and checking g_miss_xxx
81: PROCEDURE Set_opp_default_values (
82: p_mode IN VARCHAR2,
83: p_opp_rec IN AS_OPPORTUNITY_PUB.Header_Rec_Type,
84: x_opp_rec OUT NOCOPY AS_OPPORTUNITY_PUB.Header_Rec_Type
85: )
86:
87: IS
80: -- ffang 091400, Add p_mode and checking g_miss_xxx
81: PROCEDURE Set_opp_default_values (
82: p_mode IN VARCHAR2,
83: p_opp_rec IN AS_OPPORTUNITY_PUB.Header_Rec_Type,
84: x_opp_rec OUT NOCOPY AS_OPPORTUNITY_PUB.Header_Rec_Type
85: )
86:
87: IS
88: l_opp_rec AS_OPPORTUNITY_PUB.Header_Rec_Type := p_opp_rec;
84: x_opp_rec OUT NOCOPY AS_OPPORTUNITY_PUB.Header_Rec_Type
85: )
86:
87: IS
88: l_opp_rec AS_OPPORTUNITY_PUB.Header_Rec_Type := p_opp_rec;
89:
90: BEGIN
91: IF nvl(fnd_profile.value('AS_ACTIVATE_SALES_INTEROP'), 'N') <> 'Y' THEN -- Added for ASNB
92: If (l_opp_rec.sales_stage_id IS NULL) or
175:
176:
177: PROCEDURE HEADER_CREATE_NOTE(
178: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
179: p_header_rec IN AS_OPPORTUNITY_PUB.Header_Rec_Type,
180: p_lead_number IN VARCHAR2,
181: p_win_prob IN NUMBER,
182: p_status IN VARCHAR2,
183: p_sales_stage_id IN NUMBER,
554: and competitor_id = p_competitor_id;
555:
556: l_competitor_exist VARCHAR2(1);
557:
558: l_competitor_rec AS_OPPORTUNITY_PUB.Competitor_rec_Type;
559: l_competitor_tbl AS_OPPORTUNITY_PUB.Competitor_tbl_Type;
560: x_competitor_out_tbl AS_OPPORTUNITY_PUB.Competitor_Out_Tbl_Type;
561:
562: BEGIN
555:
556: l_competitor_exist VARCHAR2(1);
557:
558: l_competitor_rec AS_OPPORTUNITY_PUB.Competitor_rec_Type;
559: l_competitor_tbl AS_OPPORTUNITY_PUB.Competitor_tbl_Type;
560: x_competitor_out_tbl AS_OPPORTUNITY_PUB.Competitor_Out_Tbl_Type;
561:
562: BEGIN
563:
556: l_competitor_exist VARCHAR2(1);
557:
558: l_competitor_rec AS_OPPORTUNITY_PUB.Competitor_rec_Type;
559: l_competitor_tbl AS_OPPORTUNITY_PUB.Competitor_tbl_Type;
560: x_competitor_out_tbl AS_OPPORTUNITY_PUB.Competitor_Out_Tbl_Type;
561:
562: BEGIN
563:
564: -- Initialize API return status to SUCCESS
638: P_Identity_Salesforce_Id IN NUMBER := NULL,
639: P_salesgroup_id IN NUMBER := NULL,
640: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
641: P_Partner_Cont_Party_id IN NUMBER := FND_API.G_MISS_NUM,
642: P_Header_Rec IN AS_OPPORTUNITY_PUB.Header_Rec_Type
643: := AS_OPPORTUNITY_PUB.G_MISS_Header_REC,
644: X_LEAD_ID OUT NOCOPY NUMBER,
645: X_Return_Status OUT NOCOPY VARCHAR2,
646: X_Msg_Count OUT NOCOPY NUMBER,
639: P_salesgroup_id IN NUMBER := NULL,
640: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
641: P_Partner_Cont_Party_id IN NUMBER := FND_API.G_MISS_NUM,
642: P_Header_Rec IN AS_OPPORTUNITY_PUB.Header_Rec_Type
643: := AS_OPPORTUNITY_PUB.G_MISS_Header_REC,
644: X_LEAD_ID OUT NOCOPY NUMBER,
645: X_Return_Status OUT NOCOPY VARCHAR2,
646: X_Msg_Count OUT NOCOPY NUMBER,
647: X_Msg_Data OUT NOCOPY VARCHAR2
652: l_api_version_number CONSTANT NUMBER := 2.0;
653: l_return_status_full VARCHAR2(1);
654: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;
655: l_LEAD_ID NUMBER;
656: l_header_rec AS_OPPORTUNITY_PUB.Header_Rec_Type
657: := P_Header_Rec;
658: l_header_rec1 AS_OPPORTUNITY_PUB.Header_Rec_Type;
659:
660: l_access_profile_rec AS_ACCESS_PUB.ACCESS_PROFILE_REC_TYPE;
654: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;
655: l_LEAD_ID NUMBER;
656: l_header_rec AS_OPPORTUNITY_PUB.Header_Rec_Type
657: := P_Header_Rec;
658: l_header_rec1 AS_OPPORTUNITY_PUB.Header_Rec_Type;
659:
660: l_access_profile_rec AS_ACCESS_PUB.ACCESS_PROFILE_REC_TYPE;
661: l_access_flag VARCHAR2(1);
662: l_access_id NUMBER;
898: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
899: 'Calling Get_Access_Profiles');
900: END IF;
901:
902: AS_OPPORTUNITY_PUB.Get_Access_Profiles(
903: p_profile_tbl => p_profile_tbl,
904: x_access_profile_rec => l_access_profile_rec);
905:
906: IF l_debug THEN
1417: P_Admin_Group_Id IN NUMBER,
1418: P_Identity_Salesforce_Id IN NUMBER := NULL,
1419: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
1420: P_Partner_Cont_Party_id IN NUMBER := FND_API.G_MISS_NUM,
1421: P_Header_Rec IN AS_OPPORTUNITY_PUB.Header_Rec_Type,
1422: X_Return_Status OUT NOCOPY VARCHAR2,
1423: X_Msg_Count OUT NOCOPY NUMBER,
1424: X_Msg_Data OUT NOCOPY VARCHAR2
1425: )
1476: l_api_name CONSTANT VARCHAR2(30) := 'Update_opp_header';
1477: l_api_version_number CONSTANT NUMBER := 2.0;
1478: -- Local Variables
1479: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;
1480: --l_tar_Header_rec AS_OPPORTUNITY_PUB.Header_Rec_Type := P_Header_Rec;
1481: l_access_profile_rec AS_ACCESS_PUB.ACCESS_PROFILE_REC_TYPE;
1482: l_access_flag VARCHAR2(1);
1483: l_deleted_flag VARCHAR2(1);
1484: l_access_id NUMBER;
1489: l_decision_date DATE;
1490: l_lead_number VARCHAR2(30);
1491: l_freeze_flag VARCHAR2(1); -- solin, bug 1554330
1492: l_note_id NUMBER;
1493: l_header_rec AS_OPPORTUNITY_PUB.Header_Rec_Type := P_Header_Rec;
1494: l_header_rec1 AS_OPPORTUNITY_PUB.Header_Rec_Type;
1495: l_allow_flag VARCHAR2(1); -- solin, bug 1554330
1496:
1497: l_old_sales_methodology_id NUMBER := null;
1490: l_lead_number VARCHAR2(30);
1491: l_freeze_flag VARCHAR2(1); -- solin, bug 1554330
1492: l_note_id NUMBER;
1493: l_header_rec AS_OPPORTUNITY_PUB.Header_Rec_Type := P_Header_Rec;
1494: l_header_rec1 AS_OPPORTUNITY_PUB.Header_Rec_Type;
1495: l_allow_flag VARCHAR2(1); -- solin, bug 1554330
1496:
1497: l_old_sales_methodology_id NUMBER := null;
1498: l_old_sales_stage_id NUMBER := null;
1790: END IF;
1791:
1792: */
1793: -- Call Get_Access_Profiles to get access_profile_rec
1794: AS_OPPORTUNITY_PUB.Get_Access_Profiles(
1795: p_profile_tbl => p_profile_tbl,
1796: x_access_profile_rec => l_access_profile_rec);
1797:
1798:
2677: */
2678:
2679:
2680: -- Call Get_Access_Profiles to get access_profile_rec
2681: AS_OPPORTUNITY_PUB.Get_Access_Profiles(
2682: p_profile_tbl => p_profile_tbl,
2683: x_access_profile_rec => l_access_profile_rec);
2684:
2685:
5867: PROCEDURE Validate_opp_header(
5868: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
5869: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
5870: P_Validation_mode IN VARCHAR2,
5871: P_Header_Rec IN AS_OPPORTUNITY_PUB.Header_Rec_Type,
5872: X_Return_Status OUT NOCOPY VARCHAR2,
5873: X_Msg_Count OUT NOCOPY NUMBER,
5874: X_Msg_Data OUT NOCOPY VARCHAR2
5875: