DBA Data[Home] [Help]

APPS.PV_SELCRIT_PVT dependencies on PV_RULE_RECTYPE_PUB

Line 26: P_SELCRIT_Rec IN PV_RULE_RECTYPE_PUB.SELCRIT_Rec_Type

22: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
23: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
24: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
25: P_Identity_Resource_Id IN NUMBER,
26: P_SELCRIT_Rec IN PV_RULE_RECTYPE_PUB.SELCRIT_Rec_Type
27: := PV_RULE_RECTYPE_PUB.G_MISS_SELCRIT_REC,
28: X_SELECTION_CRITERIA_ID OUT NOCOPY NUMBER,
29: X_Return_Status OUT NOCOPY VARCHAR2,
30: X_Msg_Count OUT NOCOPY NUMBER,

Line 27: := PV_RULE_RECTYPE_PUB.G_MISS_SELCRIT_REC,

23: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
24: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
25: P_Identity_Resource_Id IN NUMBER,
26: P_SELCRIT_Rec IN PV_RULE_RECTYPE_PUB.SELCRIT_Rec_Type
27: := PV_RULE_RECTYPE_PUB.G_MISS_SELCRIT_REC,
28: X_SELECTION_CRITERIA_ID OUT NOCOPY NUMBER,
29: X_Return_Status OUT NOCOPY VARCHAR2,
30: X_Msg_Count OUT NOCOPY NUMBER,
31: X_Msg_Data OUT NOCOPY VARCHAR2

Line 246: P_SELCRIT_Rec IN PV_RULE_RECTYPE_PUB.SELCRIT_Rec_Type,

242: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
243: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
244: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
245: P_Identity_Resource_Id IN NUMBER,
246: P_SELCRIT_Rec IN PV_RULE_RECTYPE_PUB.SELCRIT_Rec_Type,
247: X_Return_Status OUT NOCOPY VARCHAR2,
248: X_Msg_Count OUT NOCOPY NUMBER,
249: X_Msg_Data OUT NOCOPY VARCHAR2
250: )

Line 264: l_ref_SELCRIT_rec PV_RULE_RECTYPE_PUB.SELCRIT_Rec_Type;

260: l_api_name CONSTANT VARCHAR2(30) := 'Update_selcrit';
261: l_api_version_number CONSTANT NUMBER := 2.0;
262: l_previous_status VARCHAR2(30);
263: -- Local Variables
264: l_ref_SELCRIT_rec PV_RULE_RECTYPE_PUB.SELCRIT_Rec_Type;
265: l_tar_SELCRIT_rec PV_RULE_RECTYPE_PUB.SELCRIT_Rec_Type := P_SELCRIT_Rec;
266: l_rowid ROWID;
267: BEGIN
268: -- Standard Start of API savepoint

Line 265: l_tar_SELCRIT_rec PV_RULE_RECTYPE_PUB.SELCRIT_Rec_Type := P_SELCRIT_Rec;

261: l_api_version_number CONSTANT NUMBER := 2.0;
262: l_previous_status VARCHAR2(30);
263: -- Local Variables
264: l_ref_SELCRIT_rec PV_RULE_RECTYPE_PUB.SELCRIT_Rec_Type;
265: l_tar_SELCRIT_rec PV_RULE_RECTYPE_PUB.SELCRIT_Rec_Type := P_SELCRIT_Rec;
266: l_rowid ROWID;
267: BEGIN
268: -- Standard Start of API savepoint
269: SAVEPOINT UPDATE_SELCRIT_PVT;

Line 505: P_SELCRIT_Rec IN PV_RULE_RECTYPE_PUB.SELCRIT_Rec_Type,

501: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
502: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
503: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
504: P_Identity_Resource_Id IN NUMBER,
505: P_SELCRIT_Rec IN PV_RULE_RECTYPE_PUB.SELCRIT_Rec_Type,
506: X_Return_Status OUT NOCOPY VARCHAR2,
507: X_Msg_Count OUT NOCOPY NUMBER,
508: X_Msg_Data OUT NOCOPY VARCHAR2
509: )

Line 519: l_SELATTVAL_rec PV_RULE_RECTYPE_PUB.SELATTVAL_Rec_Type;

515: cursor lc_value_rows(pc_criteria_id number) is
516: select attr_value_id from pv_selected_attr_values
517: where selection_criteria_id = pc_criteria_id;
518:
519: l_SELATTVAL_rec PV_RULE_RECTYPE_PUB.SELATTVAL_Rec_Type;
520:
521: l_attr_value_id number;
522:
523: BEGIN

Line 750: P_SELCRIT_Rec IN PV_RULE_RECTYPE_PUB.SELCRIT_Rec_Type,

746: PROCEDURE Validate_selcrit(
747: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
748: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
749: P_Validation_mode IN VARCHAR2,
750: P_SELCRIT_Rec IN PV_RULE_RECTYPE_PUB.SELCRIT_Rec_Type,
751: X_Return_Status OUT NOCOPY VARCHAR2,
752: X_Msg_Count OUT NOCOPY NUMBER,
753: X_Msg_Data OUT NOCOPY VARCHAR2
754: )