DBA Data[Home] [Help]

APPS.AS_OPP_COMPETITOR_PVT dependencies on AS_OPPORTUNITY_PUB

Line 22: P_Competitor_Tbl IN AS_OPPORTUNITY_PUB.Competitor_Tbl_Type :=

18: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
19: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
20: P_Admin_Group_Id IN NUMBER,
21: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
22: P_Competitor_Tbl IN AS_OPPORTUNITY_PUB.Competitor_Tbl_Type :=
23: AS_OPPORTUNITY_PUB.G_MISS_Competitor_Tbl,
24: X_competitor_out_tbl OUT NOCOPY AS_OPPORTUNITY_PUB.competitor_out_tbl_type,
25: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
26: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,

Line 23: AS_OPPORTUNITY_PUB.G_MISS_Competitor_Tbl,

19: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
20: P_Admin_Group_Id IN NUMBER,
21: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
22: P_Competitor_Tbl IN AS_OPPORTUNITY_PUB.Competitor_Tbl_Type :=
23: AS_OPPORTUNITY_PUB.G_MISS_Competitor_Tbl,
24: X_competitor_out_tbl OUT NOCOPY AS_OPPORTUNITY_PUB.competitor_out_tbl_type,
25: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
26: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
27: P_Identity_Salesforce_Id IN NUMBER := NULL,

Line 24: X_competitor_out_tbl OUT NOCOPY AS_OPPORTUNITY_PUB.competitor_out_tbl_type,

20: P_Admin_Group_Id IN NUMBER,
21: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
22: P_Competitor_Tbl IN AS_OPPORTUNITY_PUB.Competitor_Tbl_Type :=
23: AS_OPPORTUNITY_PUB.G_MISS_Competitor_Tbl,
24: X_competitor_out_tbl OUT NOCOPY AS_OPPORTUNITY_PUB.competitor_out_tbl_type,
25: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
26: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
27: P_Identity_Salesforce_Id IN NUMBER := NULL,
28: P_Partner_Cont_Party_id IN NUMBER := FND_API.G_MISS_NUM,

Line 39: L_Competitor_Rec AS_OPPORTUNITY_PUB.Competitor_Rec_Type;

35: L_Api_Name CONSTANT VARCHAR2(30) := 'Create_Competitors';
36: L_Api_Version_Number CONSTANT NUMBER := 2.0;
37: L_Return_Status_Full VARCHAR2(1);
38: L_Identity_Sales_Member_Rec AS_SALES_MEMBER_PUB.Sales_Member_Rec_Type;
39: L_Competitor_Rec AS_OPPORTUNITY_PUB.Competitor_Rec_Type;
40: L_LEAD_COMPETITOR_ID NUMBER;
41: L_LEAD_COMPETITOR VARCHAR2(225);
42: L_Line_Count CONSTANT NUMBER := P_Competitor_Tbl.count;
43: L_Access_Profile_Rec AS_ACCESS_PUB.ACCESS_PROFILE_REC_TYPE;

Line 138: AS_OPPORTUNITY_PUB.Get_Access_Profiles(

134: RAISE FND_API.G_EXC_ERROR;
135: END IF;
136:
137: -- Call Get_Access_Profiles to get access_profile_rec
138: AS_OPPORTUNITY_PUB.Get_Access_Profiles(
139: p_profile_tbl => p_profile_tbl,
140: x_access_profile_rec => l_access_profile_rec);
141:
142: -- Access checking

Line 361: P_Competitor_Tbl IN AS_OPPORTUNITY_PUB.Competitor_Tbl_Type,

357: P_Admin_Group_Id IN NUMBER,
358: P_Identity_Salesforce_Id IN NUMBER,
359: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
360: P_Partner_Cont_Party_id IN NUMBER := FND_API.G_MISS_NUM,
361: P_Competitor_Tbl IN AS_OPPORTUNITY_PUB.Competitor_Tbl_Type,
362: X_competitor_out_tbl OUT NOCOPY AS_OPPORTUNITY_PUB.competitor_out_tbl_type,
363: X_Return_Status OUT NOCOPY VARCHAR2,
364: X_Msg_Count OUT NOCOPY NUMBER,
365: X_Msg_Data OUT NOCOPY VARCHAR2

Line 362: X_competitor_out_tbl OUT NOCOPY AS_OPPORTUNITY_PUB.competitor_out_tbl_type,

358: P_Identity_Salesforce_Id IN NUMBER,
359: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
360: P_Partner_Cont_Party_id IN NUMBER := FND_API.G_MISS_NUM,
361: P_Competitor_Tbl IN AS_OPPORTUNITY_PUB.Competitor_Tbl_Type,
362: X_competitor_out_tbl OUT NOCOPY AS_OPPORTUNITY_PUB.competitor_out_tbl_type,
363: X_Return_Status OUT NOCOPY VARCHAR2,
364: X_Msg_Count OUT NOCOPY NUMBER,
365: X_Msg_Data OUT NOCOPY VARCHAR2
366: )

Line 378: L_Ref_Competitor_Rec AS_OPPORTUNITY_PUB.Competitor_Rec_Type;

374:
375: L_Api_Name CONSTANT VARCHAR2(30) := 'Update_competitors';
376: L_Api_Version_Number CONSTANT NUMBER := 2.0;
377: L_Identity_Sales_Member_Rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;
378: L_Ref_Competitor_Rec AS_OPPORTUNITY_PUB.Competitor_Rec_Type;
379: L_Rowid ROWID;
380: L_Competitor_Rec AS_OPPORTUNITY_PUB.Competitor_Rec_Type;
381: L_Line_Count CONSTANT NUMBER := P_Competitor_Tbl.count;
382: L_Access_Profile_Rec AS_ACCESS_PUB.ACCESS_PROFILE_REC_TYPE;

Line 380: L_Competitor_Rec AS_OPPORTUNITY_PUB.Competitor_Rec_Type;

376: L_Api_Version_Number CONSTANT NUMBER := 2.0;
377: L_Identity_Sales_Member_Rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;
378: L_Ref_Competitor_Rec AS_OPPORTUNITY_PUB.Competitor_Rec_Type;
379: L_Rowid ROWID;
380: L_Competitor_Rec AS_OPPORTUNITY_PUB.Competitor_Rec_Type;
381: L_Line_Count CONSTANT NUMBER := P_Competitor_Tbl.count;
382: L_Access_Profile_Rec AS_ACCESS_PUB.ACCESS_PROFILE_REC_TYPE;
383: L_Last_Update_Date DATE;
384: L_Access_Flag VARCHAR2(1);

Line 464: AS_OPPORTUNITY_PUB.Get_Access_Profiles(

460: RAISE FND_API.G_EXC_ERROR;
461: END IF;
462:
463: -- Call Get_Access_Profiles to get access_profile_rec
464: AS_OPPORTUNITY_PUB.Get_Access_Profiles(
465: p_profile_tbl => p_profile_tbl,
466: x_access_profile_rec => l_access_profile_rec);
467:
468: -- Access checking

Line 739: P_Competitor_Tbl IN AS_OPPORTUNITY_PUB.Competitor_Tbl_Type,

735: P_Admin_Group_Id IN NUMBER,
736: P_Identity_Salesforce_Id IN NUMBER,
737: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
738: P_Partner_Cont_Party_id IN NUMBER := FND_API.G_MISS_NUM,
739: P_Competitor_Tbl IN AS_OPPORTUNITY_PUB.Competitor_Tbl_Type,
740: X_competitor_out_tbl OUT NOCOPY AS_OPPORTUNITY_PUB.competitor_out_tbl_type,
741: X_Return_Status OUT NOCOPY VARCHAR2,
742: X_Msg_Count OUT NOCOPY NUMBER,
743: X_Msg_Data OUT NOCOPY VARCHAR2

Line 740: X_competitor_out_tbl OUT NOCOPY AS_OPPORTUNITY_PUB.competitor_out_tbl_type,

736: P_Identity_Salesforce_Id IN NUMBER,
737: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
738: P_Partner_Cont_Party_id IN NUMBER := FND_API.G_MISS_NUM,
739: P_Competitor_Tbl IN AS_OPPORTUNITY_PUB.Competitor_Tbl_Type,
740: X_competitor_out_tbl OUT NOCOPY AS_OPPORTUNITY_PUB.competitor_out_tbl_type,
741: X_Return_Status OUT NOCOPY VARCHAR2,
742: X_Msg_Count OUT NOCOPY NUMBER,
743: X_Msg_Data OUT NOCOPY VARCHAR2
744: )

Line 751: L_Competitor_Rec AS_OPPORTUNITY_PUB.Competitor_Rec_Type;

747:
748: L_Api_Name CONSTANT VARCHAR2(30) := 'Delete_competitors';
749: L_Api_Version_Number CONSTANT NUMBER := 2.0;
750: L_Identity_Sales_Member_Rec AS_SALES_MEMBER_PUB.Sales_Member_Rec_Type;
751: L_Competitor_Rec AS_OPPORTUNITY_PUB.Competitor_Rec_Type;
752: L_Lead_Competitor_Id NUMBER;
753: L_Line_Count CONSTANT NUMBER := P_Competitor_Tbl.count;
754: L_Access_Profile_Rec AS_ACCESS_PUB.ACCESS_PROFILE_REC_TYPE;
755: L_Access_Flag VARCHAR2(1);

Line 831: AS_OPPORTUNITY_PUB.Get_Access_Profiles(

827: RAISE FND_API.G_EXC_ERROR;
828: END IF;
829:
830: -- Call Get_Access_Profiles to get access_profile_rec
831: AS_OPPORTUNITY_PUB.Get_Access_Profiles(
832: p_profile_tbl => p_profile_tbl,
833: x_access_profile_rec => l_access_profile_rec);
834:
835: -- Access checking

Line 1232: P_Competitor_Rec IN AS_OPPORTUNITY_PUB.Competitor_Rec_Type,

1228: -- table.
1229: PROCEDURE Validate_Competitor_rec(
1230: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1231: P_Validation_mode IN VARCHAR2,
1232: P_Competitor_Rec IN AS_OPPORTUNITY_PUB.Competitor_Rec_Type,
1233: X_Return_Status OUT NOCOPY VARCHAR2,
1234: X_Msg_Count OUT NOCOPY NUMBER,
1235: X_Msg_Data OUT NOCOPY VARCHAR2
1236: )

Line 1277: P_Competitor_Rec IN AS_OPPORTUNITY_PUB.Competitor_Rec_Type,

1273: PROCEDURE Validate_competitor(
1274: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1275: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1276: P_Validation_mode IN VARCHAR2,
1277: P_Competitor_Rec IN AS_OPPORTUNITY_PUB.Competitor_Rec_Type,
1278: X_Return_Status OUT NOCOPY VARCHAR2,
1279: X_Msg_Count OUT NOCOPY NUMBER,
1280: X_Msg_Data OUT NOCOPY VARCHAR2
1281: )