DBA Data[Home] [Help]

APPS.AS_OPP_OBSTACLE_PVT dependencies on AS_OPPORTUNITY_PUB

Line 26: P_Obstacle_tbl IN AS_OPPORTUNITY_PUB.Obstacle_tbl_Type := AS_OPPORTUNITY_PUB.G_MISS_Obstacle_tbl,

22: P_Admin_Group_Id IN NUMBER,
23: P_Identity_Salesforce_Id IN VARCHAR2 := FND_API.G_FALSE,
24: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
25: p_partner_cont_party_id IN NUMBER := FND_API.G_MISS_NUM,
26: P_Obstacle_tbl IN AS_OPPORTUNITY_PUB.Obstacle_tbl_Type := AS_OPPORTUNITY_PUB.G_MISS_Obstacle_tbl,
27: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
28: X_LEAD_OBSTACLE_out_tbl OUT NOCOPY AS_OPPORTUNITY_PUB.obstacle_out_tbl_type,
29: X_Return_Status OUT NOCOPY VARCHAR2,
30: X_Msg_Count OUT NOCOPY NUMBER,

Line 28: X_LEAD_OBSTACLE_out_tbl OUT NOCOPY AS_OPPORTUNITY_PUB.obstacle_out_tbl_type,

24: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
25: p_partner_cont_party_id IN NUMBER := FND_API.G_MISS_NUM,
26: P_Obstacle_tbl IN AS_OPPORTUNITY_PUB.Obstacle_tbl_Type := AS_OPPORTUNITY_PUB.G_MISS_Obstacle_tbl,
27: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
28: X_LEAD_OBSTACLE_out_tbl OUT NOCOPY AS_OPPORTUNITY_PUB.obstacle_out_tbl_type,
29: X_Return_Status OUT NOCOPY VARCHAR2,
30: X_Msg_Count OUT NOCOPY NUMBER,
31: X_Msg_Data OUT NOCOPY VARCHAR2
32: )

Line 40: l_OBSTACLE_rec AS_OPPORTUNITY_PUB.OBSTACLE_Rec_Type;

36: l_api_name CONSTANT VARCHAR2(30) := 'Create_obstacles';
37: l_api_version_number CONSTANT NUMBER := 2.0;
38: l_return_status_full VARCHAR2(1);
39: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;
40: l_OBSTACLE_rec AS_OPPORTUNITY_PUB.OBSTACLE_Rec_Type;
41: l_LEAD_OBSTACLE_ID NUMBER;
42: l_access_profile_rec AS_ACCESS_PUB.ACCESS_PROFILE_REC_TYPE;
43: l_access_flag VARCHAR2(1);
44: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

Line 130: AS_OPPORTUNITY_PUB.Get_Access_Profiles(

126: RAISE FND_API.G_EXC_ERROR;
127: END IF;
128:
129: -- Call Get_Access_Profiles to get access_profile_rec
130: AS_OPPORTUNITY_PUB.Get_Access_Profiles(
131: p_profile_tbl => p_profile_tbl,
132: x_access_profile_rec => l_access_profile_rec);
133:
134: IF( p_check_access_flag = 'Y' )

Line 366: P_Obstacle_tbl IN AS_OPPORTUNITY_PUB.Obstacle_tbl_type,

362: P_Admin_Group_Id IN NUMBER,
363: P_Identity_Salesforce_Id IN NUMBER,
364: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
365: p_partner_cont_party_id IN NUMBER := FND_API.G_MISS_NUM,
366: P_Obstacle_tbl IN AS_OPPORTUNITY_PUB.Obstacle_tbl_type,
367: X_LEAD_OBSTACLE_out_tbl OUT NOCOPY AS_OPPORTUNITY_PUB.obstacle_out_tbl_type,
368: X_Return_Status OUT NOCOPY VARCHAR2,
369: X_Msg_Count OUT NOCOPY NUMBER,
370: X_Msg_Data OUT NOCOPY VARCHAR2

Line 367: X_LEAD_OBSTACLE_out_tbl OUT NOCOPY AS_OPPORTUNITY_PUB.obstacle_out_tbl_type,

363: P_Identity_Salesforce_Id IN NUMBER,
364: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
365: p_partner_cont_party_id IN NUMBER := FND_API.G_MISS_NUM,
366: P_Obstacle_tbl IN AS_OPPORTUNITY_PUB.Obstacle_tbl_type,
367: X_LEAD_OBSTACLE_out_tbl OUT NOCOPY AS_OPPORTUNITY_PUB.obstacle_out_tbl_type,
368: X_Return_Status OUT NOCOPY VARCHAR2,
369: X_Msg_Count OUT NOCOPY NUMBER,
370: X_Msg_Data OUT NOCOPY VARCHAR2
371: )

Line 418: l_ref_Obstacle_rec AS_OPPORTUNITY_PUB.Obstacle_Rec_Type;

414: l_api_name CONSTANT VARCHAR2(30) := 'Update_obstacles';
415: l_api_version_number CONSTANT NUMBER := 2.0;
416: -- Local Variables
417: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;
418: l_ref_Obstacle_rec AS_OPPORTUNITY_PUB.Obstacle_Rec_Type;
419: l_tar_Obstacle_rec AS_OPPORTUNITY_PUB.Obstacle_Rec_Type;
420: l_Obstacle_rec AS_OPPORTUNITY_PUB.Obstacle_Rec_Type;
421: l_rowid ROWID;
422: l_access_profile_rec AS_ACCESS_PUB.ACCESS_PROFILE_REC_TYPE;

Line 419: l_tar_Obstacle_rec AS_OPPORTUNITY_PUB.Obstacle_Rec_Type;

415: l_api_version_number CONSTANT NUMBER := 2.0;
416: -- Local Variables
417: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;
418: l_ref_Obstacle_rec AS_OPPORTUNITY_PUB.Obstacle_Rec_Type;
419: l_tar_Obstacle_rec AS_OPPORTUNITY_PUB.Obstacle_Rec_Type;
420: l_Obstacle_rec AS_OPPORTUNITY_PUB.Obstacle_Rec_Type;
421: l_rowid ROWID;
422: l_access_profile_rec AS_ACCESS_PUB.ACCESS_PROFILE_REC_TYPE;
423: l_access_flag VARCHAR2(1);

Line 420: l_Obstacle_rec AS_OPPORTUNITY_PUB.Obstacle_Rec_Type;

416: -- Local Variables
417: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;
418: l_ref_Obstacle_rec AS_OPPORTUNITY_PUB.Obstacle_Rec_Type;
419: l_tar_Obstacle_rec AS_OPPORTUNITY_PUB.Obstacle_Rec_Type;
420: l_Obstacle_rec AS_OPPORTUNITY_PUB.Obstacle_Rec_Type;
421: l_rowid ROWID;
422: l_access_profile_rec AS_ACCESS_PUB.ACCESS_PROFILE_REC_TYPE;
423: l_access_flag VARCHAR2(1);
424: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

Line 496: AS_OPPORTUNITY_PUB.Get_Access_Profiles(

492: RAISE FND_API.G_EXC_ERROR;
493: END IF;
494:
495: -- Call Get_Access_Profiles to get access_profile_rec
496: AS_OPPORTUNITY_PUB.Get_Access_Profiles(
497: p_profile_tbl => p_profile_tbl,
498: x_access_profile_rec => l_access_profile_rec);
499:
500: IF( p_check_access_flag = 'Y' )

Line 809: P_Obstacle_tbl IN AS_OPPORTUNITY_PUB.Obstacle_tbl_type,

805: P_Admin_Group_Id IN NUMBER,
806: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
807: P_identity_salesforce_id IN NUMBER := NULL,
808: p_partner_cont_party_id IN NUMBER := FND_API.G_MISS_NUM,
809: P_Obstacle_tbl IN AS_OPPORTUNITY_PUB.Obstacle_tbl_type,
810: X_LEAD_OBSTACLE_out_tbl OUT NOCOPY AS_OPPORTUNITY_PUB.obstacle_out_tbl_type,
811: X_Return_Status OUT NOCOPY VARCHAR2,
812: X_Msg_Count OUT NOCOPY NUMBER,
813: X_Msg_Data OUT NOCOPY VARCHAR2

Line 810: X_LEAD_OBSTACLE_out_tbl OUT NOCOPY AS_OPPORTUNITY_PUB.obstacle_out_tbl_type,

806: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
807: P_identity_salesforce_id IN NUMBER := NULL,
808: p_partner_cont_party_id IN NUMBER := FND_API.G_MISS_NUM,
809: P_Obstacle_tbl IN AS_OPPORTUNITY_PUB.Obstacle_tbl_type,
810: X_LEAD_OBSTACLE_out_tbl OUT NOCOPY AS_OPPORTUNITY_PUB.obstacle_out_tbl_type,
811: X_Return_Status OUT NOCOPY VARCHAR2,
812: X_Msg_Count OUT NOCOPY NUMBER,
813: X_Msg_Data OUT NOCOPY VARCHAR2
814: )

Line 820: l_Obstacle_rec AS_OPPORTUNITY_PUB.Obstacle_Rec_Type;

816: IS
817: l_api_name CONSTANT VARCHAR2(30) := 'Delete_obstacles';
818: l_api_version_number CONSTANT NUMBER := 2.0;
819: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;
820: l_Obstacle_rec AS_OPPORTUNITY_PUB.Obstacle_Rec_Type;
821: l_access_profile_rec AS_ACCESS_PUB.ACCESS_PROFILE_REC_TYPE;
822: l_access_flag VARCHAR2(1);
823: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
824: l_module CONSTANT VARCHAR2(255) := 'as.plsql.lobpv.Delete_obstacles';

Line 894: AS_OPPORTUNITY_PUB.Get_Access_Profiles(

890: RAISE FND_API.G_EXC_ERROR;
891: END IF;
892:
893: -- Call Get_Access_Profiles to get access_profile_rec
894: AS_OPPORTUNITY_PUB.Get_Access_Profiles(
895: p_profile_tbl => p_profile_tbl,
896: x_access_profile_rec => l_access_profile_rec);
897:
898: IF( p_check_access_flag = 'Y' )

Line 1283: P_Obstacle_Rec IN AS_OPPORTUNITY_PUB.Obstacle_Rec_Type,

1279: -- stored in database table.
1280: PROCEDURE Validate_Obstacle_rec(
1281: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1282: P_Validation_mode IN VARCHAR2,
1283: P_Obstacle_Rec IN AS_OPPORTUNITY_PUB.Obstacle_Rec_Type,
1284: X_Return_Status OUT NOCOPY VARCHAR2,
1285: X_Msg_Count OUT NOCOPY NUMBER,
1286: X_Msg_Data OUT NOCOPY VARCHAR2
1287: )

Line 1326: P_Obstacle_Rec IN AS_OPPORTUNITY_PUB.Obstacle_Rec_Type,

1322: PROCEDURE Validate_obstacle(
1323: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1324: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1325: P_Validation_mode IN VARCHAR2,
1326: P_Obstacle_Rec IN AS_OPPORTUNITY_PUB.Obstacle_Rec_Type,
1327: X_Return_Status OUT NOCOPY VARCHAR2,
1328: X_Msg_Count OUT NOCOPY NUMBER,
1329: X_Msg_Data OUT NOCOPY VARCHAR2
1330: )