16: -- Pre-Req :
17: --
18: PROCEDURE Create_selcrit(
19: P_Api_Version_Number IN NUMBER,
20: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
21: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
22: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
23: P_Identity_Resource_Id IN NUMBER,
24: P_SELCRIT_Rec IN PV_RULE_RECTYPE_PUB.SELCRIT_Rec_Type := PV_RULE_RECTYPE_PUB.G_MISS_SELCRIT_REC,
17: --
18: PROCEDURE Create_selcrit(
19: P_Api_Version_Number IN NUMBER,
20: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
21: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
22: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
23: P_Identity_Resource_Id IN NUMBER,
24: P_SELCRIT_Rec IN PV_RULE_RECTYPE_PUB.SELCRIT_Rec_Type := PV_RULE_RECTYPE_PUB.G_MISS_SELCRIT_REC,
25: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
18: PROCEDURE Create_selcrit(
19: P_Api_Version_Number IN NUMBER,
20: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
21: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
22: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
23: P_Identity_Resource_Id IN NUMBER,
24: P_SELCRIT_Rec IN PV_RULE_RECTYPE_PUB.SELCRIT_Rec_Type := PV_RULE_RECTYPE_PUB.G_MISS_SELCRIT_REC,
25: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
26: X_SELECTION_CRITERIA_ID OUT NOCOPY NUMBER,
37: -- Pre-Req :
38:
39: PROCEDURE Update_selcrit(
40: P_Api_Version_Number IN NUMBER,
41: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
42: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
43: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
44: P_Identity_Resource_Id IN NUMBER,
45: P_SELCRIT_Rec IN PV_RULE_RECTYPE_PUB.SELCRIT_Rec_Type,
38:
39: PROCEDURE Update_selcrit(
40: P_Api_Version_Number IN NUMBER,
41: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
42: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
43: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
44: P_Identity_Resource_Id IN NUMBER,
45: P_SELCRIT_Rec IN PV_RULE_RECTYPE_PUB.SELCRIT_Rec_Type,
46: X_Return_Status OUT NOCOPY VARCHAR2,
39: PROCEDURE Update_selcrit(
40: P_Api_Version_Number IN NUMBER,
41: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
42: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
43: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
44: P_Identity_Resource_Id IN NUMBER,
45: P_SELCRIT_Rec IN PV_RULE_RECTYPE_PUB.SELCRIT_Rec_Type,
46: X_Return_Status OUT NOCOPY VARCHAR2,
47: X_Msg_Count OUT NOCOPY NUMBER,
56: -- Pre-Req :
57:
58: PROCEDURE Delete_selcrit(
59: P_Api_Version_Number IN NUMBER,
60: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
61: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
62: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
63: P_Identity_Resource_Id IN NUMBER,
64: P_SELCRIT_Rec IN PV_RULE_RECTYPE_PUB.SELCRIT_Rec_Type,
57:
58: PROCEDURE Delete_selcrit(
59: P_Api_Version_Number IN NUMBER,
60: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
61: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
62: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
63: P_Identity_Resource_Id IN NUMBER,
64: P_SELCRIT_Rec IN PV_RULE_RECTYPE_PUB.SELCRIT_Rec_Type,
65: X_Return_Status OUT NOCOPY VARCHAR2,
58: PROCEDURE Delete_selcrit(
59: P_Api_Version_Number IN NUMBER,
60: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
61: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
62: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
63: P_Identity_Resource_Id IN NUMBER,
64: P_SELCRIT_Rec IN PV_RULE_RECTYPE_PUB.SELCRIT_Rec_Type,
65: X_Return_Status OUT NOCOPY VARCHAR2,
66: X_Msg_Count OUT NOCOPY NUMBER,