DBA Data[Home] [Help]

APPS.AS_OPP_COMPETITOR_PVT dependencies on AS_UTILITY_PUB

Line 21: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,

17: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
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,

Line 44: L_Item_Property_Rec AS_UTILITY_PUB.ITEM_PROPERTY_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;
44: L_Item_Property_Rec AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE;
45: L_Access_Flag VARCHAR2(1);
46: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
47: l_module CONSTANT VARCHAR2(255) := 'as.plsql.cmppv.Create_competitors';
48:

Line 359: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,

355: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
356: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
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,

Line 737: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,

733: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
734: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
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,

Line 988: X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,

984: PROCEDURE Validate_LEAD_COMPETITOR_ID (
985: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
986: P_Validation_mode IN VARCHAR2,
987: P_LEAD_COMPETITOR_ID IN NUMBER,
988: X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
989: X_Return_Status OUT NOCOPY VARCHAR2,
990: X_Msg_Count OUT NOCOPY NUMBER,
991: X_Msg_Data OUT NOCOPY VARCHAR2
992: )

Line 1079: X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,

1075: PROCEDURE Validate_LEAD_ID (
1076: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1077: P_Validation_mode IN VARCHAR2,
1078: P_LEAD_ID IN NUMBER,
1079: X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
1080: X_Return_Status OUT NOCOPY VARCHAR2,
1081: X_Msg_Count OUT NOCOPY NUMBER,
1082: X_Msg_Data OUT NOCOPY VARCHAR2
1083: )

Line 1158: X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,

1154: PROCEDURE Validate_COMPETITOR_ID (
1155: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1156: P_Validation_mode IN VARCHAR2,
1157: P_COMPETITOR_ID IN NUMBER,
1158: X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
1159: X_Return_Status OUT NOCOPY VARCHAR2,
1160: X_Msg_Count OUT NOCOPY NUMBER,
1161: X_Msg_Data OUT NOCOPY VARCHAR2
1162: )

Line 1285: l_Item_Property_Rec AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE;

1281: )
1282: IS
1283:
1284: l_api_name CONSTANT VARCHAR2(30) := 'Validate_competitor';
1285: l_Item_Property_Rec AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE;
1286: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
1287: l_module CONSTANT VARCHAR2(255) := 'as.plsql.cmppv.Validate_competitor';
1288: BEGIN
1289:

Line 1299: IF (p_validation_level >= AS_UTILITY_PUB.G_VALID_LEVEL_ITEM) THEN

1295:
1296: -- Initialize API return status to SUCCESS
1297: x_return_status := FND_API.G_RET_STS_SUCCESS;
1298:
1299: IF (p_validation_level >= AS_UTILITY_PUB.G_VALID_LEVEL_ITEM) THEN
1300: -- Hint: We provide validation procedure for every column. Developer
1301: -- should delete unnecessary validation procedures.
1302:
1303: Validate_LEAD_COMPETITOR_ID(

Line 1347: IF (p_validation_level >= AS_UTILITY_PUB.G_VALID_LEVEL_RECORD) THEN

1343:
1344: END IF;
1345:
1346: /*
1347: IF (p_validation_level >= AS_UTILITY_PUB.G_VALID_LEVEL_RECORD) THEN
1348: -- Hint: Inter-field level validation can be added here
1349: -- invoke record level validation procedures
1350: Validate_Competitor_Rec(
1351: p_init_msg_list => FND_API.G_FALSE,

Line 1365: IF (p_validation_level >= AS_UTILITY_PUB.G_VALID_LEVEL_INTER_RECORD) THEN

1361: END IF;
1362: */
1363:
1364: /*
1365: IF (p_validation_level >= AS_UTILITY_PUB.G_VALID_LEVEL_INTER_RECORD) THEN
1366: -- invoke inter-record level validation procedures
1367: NULL;
1368: END IF;
1369: */

Line 1372: IF (p_validation_level >= AS_UTILITY_PUB.G_VALID_LEVEL_INTER_ENTITY) THEN

1368: END IF;
1369: */
1370:
1371: /*
1372: IF (p_validation_level >= AS_UTILITY_PUB.G_VALID_LEVEL_INTER_ENTITY) THEN
1373: -- invoke inter-entity level validation procedures
1374: NULL;
1375: END IF;
1376: */