eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AS_COMPETITOR_PROD_PVT dependencies on AS_OPPORTUNITY_PUB

Line 46: FUNCTION check_dup(p_Competitor_Prod_rec IN AS_OPPORTUNITY_PUB.Competitor_Prod_Rec_Type

42:
43: END Opp_Won;
44:
45:
46: FUNCTION check_dup(p_Competitor_Prod_rec IN AS_OPPORTUNITY_PUB.Competitor_Prod_Rec_Type
47: := AS_OPPORTUNITY_PUB.G_MISS_Competitor_Prod_Rec)
48: RETURN BOOLEAN IS
49:
50: CURSOR dup_exist IS

Line 47: := AS_OPPORTUNITY_PUB.G_MISS_Competitor_Prod_Rec)

43: END Opp_Won;
44:
45:
46: FUNCTION check_dup(p_Competitor_Prod_rec IN AS_OPPORTUNITY_PUB.Competitor_Prod_Rec_Type
47: := AS_OPPORTUNITY_PUB.G_MISS_Competitor_Prod_Rec)
48: RETURN BOOLEAN IS
49:
50: CURSOR dup_exist IS
51: select 'Y'

Line 87: P_Competitor_Prod_Tbl IN AS_OPPORTUNITY_PUB.Competitor_Prod_Tbl_Type :=

83: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
84: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
85: P_Admin_Group_Id IN NUMBER,
86: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
87: P_Competitor_Prod_Tbl IN AS_OPPORTUNITY_PUB.Competitor_Prod_Tbl_Type :=
88: AS_OPPORTUNITY_PUB.G_MISS_Competitor_Prod_Tbl,
89: X_competitor_prod_out_tbl OUT NOCOPY AS_OPPORTUNITY_PUB.competitor_prod_out_tbl_type,
90: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
91: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,

Line 88: AS_OPPORTUNITY_PUB.G_MISS_Competitor_Prod_Tbl,

84: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
85: P_Admin_Group_Id IN NUMBER,
86: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
87: P_Competitor_Prod_Tbl IN AS_OPPORTUNITY_PUB.Competitor_Prod_Tbl_Type :=
88: AS_OPPORTUNITY_PUB.G_MISS_Competitor_Prod_Tbl,
89: X_competitor_prod_out_tbl OUT NOCOPY AS_OPPORTUNITY_PUB.competitor_prod_out_tbl_type,
90: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
91: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
92: P_Identity_Salesforce_Id IN NUMBER := NULL,

Line 89: X_competitor_prod_out_tbl OUT NOCOPY AS_OPPORTUNITY_PUB.competitor_prod_out_tbl_type,

85: P_Admin_Group_Id IN NUMBER,
86: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
87: P_Competitor_Prod_Tbl IN AS_OPPORTUNITY_PUB.Competitor_Prod_Tbl_Type :=
88: AS_OPPORTUNITY_PUB.G_MISS_Competitor_Prod_Tbl,
89: X_competitor_prod_out_tbl OUT NOCOPY AS_OPPORTUNITY_PUB.competitor_prod_out_tbl_type,
90: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
91: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
92: P_Identity_Salesforce_Id IN NUMBER := NULL,
93: P_Partner_Cont_Party_id IN NUMBER := FND_API.G_MISS_NUM,

Line 104: L_Competitor_Prod_Rec AS_OPPORTUNITY_PUB.Competitor_Prod_Rec_Type;

100: L_Api_Name CONSTANT VARCHAR2(30) := 'Create_Competitor_Prods';
101: L_Api_Version_Number CONSTANT NUMBER := 2.0;
102: L_Return_Status_Full VARCHAR2(1);
103: L_Identity_Sales_Member_Rec AS_SALES_MEMBER_PUB.Sales_Member_Rec_Type;
104: L_Competitor_Prod_Rec AS_OPPORTUNITY_PUB.Competitor_Prod_Rec_Type;
105: L_LEAD_COMPETITOR_PROD_ID NUMBER;
106: L_LEAD_COMPETITOR_PROD VARCHAR2(225);
107: L_Line_Count CONSTANT NUMBER := P_Competitor_Prod_Tbl.count;
108: L_Access_Profile_Rec AS_ACCESS_PUB.ACCESS_PROFILE_REC_TYPE;

Line 205: AS_OPPORTUNITY_PUB.Get_Access_Profiles(

201: RAISE FND_API.G_EXC_ERROR;
202: END IF;
203:
204: -- Call Get_Access_Profiles to get access_profile_rec
205: AS_OPPORTUNITY_PUB.Get_Access_Profiles(
206: p_profile_tbl => p_profile_tbl,
207: x_access_profile_rec => l_access_profile_rec);
208:
209: -- Access checking

Line 474: P_Competitor_Prod_Tbl IN AS_OPPORTUNITY_PUB.Competitor_Prod_Tbl_Type,

470: P_Admin_Group_Id IN NUMBER,
471: P_Identity_Salesforce_Id IN NUMBER,
472: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
473: P_Partner_Cont_Party_id IN NUMBER := FND_API.G_MISS_NUM,
474: P_Competitor_Prod_Tbl IN AS_OPPORTUNITY_PUB.Competitor_Prod_Tbl_Type,
475: X_competitor_prod_out_tbl OUT NOCOPY AS_OPPORTUNITY_PUB.competitor_prod_out_tbl_type,
476: X_Return_Status OUT NOCOPY VARCHAR2,
477: X_Msg_Count OUT NOCOPY NUMBER,
478: X_Msg_Data OUT NOCOPY VARCHAR2

Line 475: X_competitor_prod_out_tbl OUT NOCOPY AS_OPPORTUNITY_PUB.competitor_prod_out_tbl_type,

471: P_Identity_Salesforce_Id IN NUMBER,
472: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
473: P_Partner_Cont_Party_id IN NUMBER := FND_API.G_MISS_NUM,
474: P_Competitor_Prod_Tbl IN AS_OPPORTUNITY_PUB.Competitor_Prod_Tbl_Type,
475: X_competitor_prod_out_tbl OUT NOCOPY AS_OPPORTUNITY_PUB.competitor_prod_out_tbl_type,
476: X_Return_Status OUT NOCOPY VARCHAR2,
477: X_Msg_Count OUT NOCOPY NUMBER,
478: X_Msg_Data OUT NOCOPY VARCHAR2
479: )

Line 491: L_Ref_Competitor_Prod_Rec AS_OPPORTUNITY_PUB.Competitor_Prod_Rec_Type;

487:
488: L_Api_Name CONSTANT VARCHAR2(30) := 'Update_competitor_prods';
489: L_Api_Version_Number CONSTANT NUMBER := 2.0;
490: L_Identity_Sales_Member_Rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;
491: L_Ref_Competitor_Prod_Rec AS_OPPORTUNITY_PUB.Competitor_Prod_Rec_Type;
492: L_Rowid ROWID;
493: L_Competitor_Prod_Rec AS_OPPORTUNITY_PUB.Competitor_Prod_Rec_Type;
494: L_Line_Count CONSTANT NUMBER := P_Competitor_Prod_Tbl.count;
495: L_Access_Profile_Rec AS_ACCESS_PUB.ACCESS_PROFILE_REC_TYPE;

Line 493: L_Competitor_Prod_Rec AS_OPPORTUNITY_PUB.Competitor_Prod_Rec_Type;

489: L_Api_Version_Number CONSTANT NUMBER := 2.0;
490: L_Identity_Sales_Member_Rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;
491: L_Ref_Competitor_Prod_Rec AS_OPPORTUNITY_PUB.Competitor_Prod_Rec_Type;
492: L_Rowid ROWID;
493: L_Competitor_Prod_Rec AS_OPPORTUNITY_PUB.Competitor_Prod_Rec_Type;
494: L_Line_Count CONSTANT NUMBER := P_Competitor_Prod_Tbl.count;
495: L_Access_Profile_Rec AS_ACCESS_PUB.ACCESS_PROFILE_REC_TYPE;
496: L_Last_Update_Date DATE;
497: L_Access_Flag VARCHAR2(1);

Line 578: AS_OPPORTUNITY_PUB.Get_Access_Profiles(

574: RAISE FND_API.G_EXC_ERROR;
575: END IF;
576:
577: -- Call Get_Access_Profiles to get access_profile_rec
578: AS_OPPORTUNITY_PUB.Get_Access_Profiles(
579: p_profile_tbl => p_profile_tbl,
580: x_access_profile_rec => l_access_profile_rec);
581:
582: -- Access checking

Line 879: P_Competitor_Prod_Tbl IN AS_OPPORTUNITY_PUB.Competitor_Prod_Tbl_Type,

875: P_Admin_Group_Id IN NUMBER,
876: P_Identity_Salesforce_Id IN NUMBER,
877: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
878: P_Partner_Cont_Party_id IN NUMBER := FND_API.G_MISS_NUM,
879: P_Competitor_Prod_Tbl IN AS_OPPORTUNITY_PUB.Competitor_Prod_Tbl_Type,
880: X_competitor_prod_out_tbl OUT NOCOPY AS_OPPORTUNITY_PUB.competitor_prod_out_tbl_type,
881: X_Return_Status OUT NOCOPY VARCHAR2,
882: X_Msg_Count OUT NOCOPY NUMBER,
883: X_Msg_Data OUT NOCOPY VARCHAR2

Line 880: X_competitor_prod_out_tbl OUT NOCOPY AS_OPPORTUNITY_PUB.competitor_prod_out_tbl_type,

876: P_Identity_Salesforce_Id IN NUMBER,
877: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
878: P_Partner_Cont_Party_id IN NUMBER := FND_API.G_MISS_NUM,
879: P_Competitor_Prod_Tbl IN AS_OPPORTUNITY_PUB.Competitor_Prod_Tbl_Type,
880: X_competitor_prod_out_tbl OUT NOCOPY AS_OPPORTUNITY_PUB.competitor_prod_out_tbl_type,
881: X_Return_Status OUT NOCOPY VARCHAR2,
882: X_Msg_Count OUT NOCOPY NUMBER,
883: X_Msg_Data OUT NOCOPY VARCHAR2
884: )

Line 890: L_Competitor_Prod_Rec AS_OPPORTUNITY_PUB.Competitor_Prod_Rec_Type;

886: IS
887: L_Api_Name CONSTANT VARCHAR2(30) := 'Delete_competitor_prods';
888: L_Api_Version_Number CONSTANT NUMBER := 2.0;
889: L_Identity_Sales_Member_Rec AS_SALES_MEMBER_PUB.Sales_Member_Rec_Type;
890: L_Competitor_Prod_Rec AS_OPPORTUNITY_PUB.Competitor_Prod_Rec_Type;
891: L_Lead_Competitor_Prod_Id NUMBER;
892: L_Line_Count CONSTANT NUMBER := P_Competitor_Prod_Tbl.count;
893: L_Access_Profile_Rec AS_ACCESS_PUB.ACCESS_PROFILE_REC_TYPE;
894: L_Access_Flag VARCHAR2(1);

Line 969: AS_OPPORTUNITY_PUB.Get_Access_Profiles(

965: RAISE FND_API.G_EXC_ERROR;
966: END IF;
967:
968: -- Call Get_Access_Profiles to get access_profile_rec
969: AS_OPPORTUNITY_PUB.Get_Access_Profiles(
970: p_profile_tbl => p_profile_tbl,
971: x_access_profile_rec => l_access_profile_rec);
972:
973: -- Access checking

Line 1539: P_Competitor_Prod_Rec IN as_opportunity_pub.Competitor_Prod_Rec_Type,

1535:
1536: PROCEDURE Validate_Competitor_Prod_rec(
1537: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1538: P_Validation_mode IN VARCHAR2,
1539: P_Competitor_Prod_Rec IN as_opportunity_pub.Competitor_Prod_Rec_Type,
1540: X_Return_Status OUT NOCOPY VARCHAR2,
1541: X_Msg_Count OUT NOCOPY NUMBER,
1542: X_Msg_Data OUT NOCOPY VARCHAR2
1543: )

Line 1576: P_Competitor_Prod_Rec IN as_opportunity_pub.Competitor_Prod_Rec_Type,

1572: PROCEDURE Validate_competitor_prod(
1573: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1574: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1575: P_Validation_mode IN VARCHAR2,
1576: P_Competitor_Prod_Rec IN as_opportunity_pub.Competitor_Prod_Rec_Type,
1577: X_Return_Status OUT NOCOPY VARCHAR2,
1578: X_Msg_Count OUT NOCOPY NUMBER,
1579: X_Msg_Data OUT NOCOPY VARCHAR2
1580: )