16: -- Pre-Req :
17: --
18: PROCEDURE Create_selattval(
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_SELATTVAL_Rec IN PV_RULE_RECTYPE_PUB.SELATTVAL_Rec_Type
17: --
18: PROCEDURE Create_selattval(
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_SELATTVAL_Rec IN PV_RULE_RECTYPE_PUB.SELATTVAL_Rec_Type
25: := PV_RULE_RECTYPE_PUB.G_MISS_SELATTVAL_REC,
18: PROCEDURE Create_selattval(
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_SELATTVAL_Rec IN PV_RULE_RECTYPE_PUB.SELATTVAL_Rec_Type
25: := PV_RULE_RECTYPE_PUB.G_MISS_SELATTVAL_REC,
26: X_ATTR_VALUE_ID OUT NOCOPY NUMBER,
37: -- Pre-Req :
38:
39: PROCEDURE Update_selattval(
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_SELATTVAL_Rec IN PV_RULE_RECTYPE_PUB.SELATTVAL_Rec_Type,
38:
39: PROCEDURE Update_selattval(
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_SELATTVAL_Rec IN PV_RULE_RECTYPE_PUB.SELATTVAL_Rec_Type,
46: X_Return_Status OUT NOCOPY VARCHAR2,
39: PROCEDURE Update_selattval(
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_SELATTVAL_Rec IN PV_RULE_RECTYPE_PUB.SELATTVAL_Rec_Type,
46: X_Return_Status OUT NOCOPY VARCHAR2,
47: X_Msg_Count OUT NOCOPY NUMBER,
56: -- Pre-Req :
57:
58: PROCEDURE Delete_selattval(
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_SELATTVAL_Rec IN PV_RULE_RECTYPE_PUB.SELATTVAL_Rec_Type,
57:
58: PROCEDURE Delete_selattval(
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_SELATTVAL_Rec IN PV_RULE_RECTYPE_PUB.SELATTVAL_Rec_Type,
65: X_Return_Status OUT NOCOPY VARCHAR2,
58: PROCEDURE Delete_selattval(
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_SELATTVAL_Rec IN PV_RULE_RECTYPE_PUB.SELATTVAL_Rec_Type,
65: X_Return_Status OUT NOCOPY VARCHAR2,
66: X_Msg_Count OUT NOCOPY NUMBER,
79: --
80: -- End of Comments
81:
82: PROCEDURE Validate_ATTR_VALUE_ID (
83: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
84: P_Validation_mode IN VARCHAR2,
85: P_ATTR_VALUE_ID IN NUMBER,
86: X_Return_Status OUT NOCOPY VARCHAR2,
87: X_Msg_Count OUT NOCOPY NUMBER,
100: --
101: -- End of Comments
102:
103: PROCEDURE Validate_SELECTION_CRITERIA_ID (
104: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
105: P_Validation_mode IN VARCHAR2,
106: P_SELECTION_CRITERIA_ID IN NUMBER,
107: X_Return_Status OUT NOCOPY VARCHAR2,
108: X_Msg_Count OUT NOCOPY NUMBER,
120: -- 2. We can also validate table instead of record. There will be an option for user to choose.
121: -- End of Comments
122:
123: PROCEDURE Validate_selattval(
124: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
125: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
126: P_Validation_mode IN VARCHAR2,
127: P_SELATTVAL_Rec IN PV_RULE_RECTYPE_PUB.SELATTVAL_Rec_Type,
128: X_Return_Status OUT NOCOPY VARCHAR2,
121: -- End of Comments
122:
123: PROCEDURE Validate_selattval(
124: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
125: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
126: P_Validation_mode IN VARCHAR2,
127: P_SELATTVAL_Rec IN PV_RULE_RECTYPE_PUB.SELATTVAL_Rec_Type,
128: X_Return_Status OUT NOCOPY VARCHAR2,
129: X_Msg_Count OUT NOCOPY NUMBER,