1 PACKAGE PV_SELATTVAL_PVT as
2 /* $Header: pvrvsavs.pls 120.0 2005/05/27 15:32:48 appldev noship $ */
3 -- Start of Comments
4 -- Package name : PV_SELATTVAL_PVT
5 -- Purpose :
6 -- History :
7 -- NOTE :
8 -- End of Comments
9
10
11 -- *******************************************************
12 -- Start of Comments
13 -- *******************************************************
14 -- API Name: Create_selattval
15 -- Type : Private
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
25 := PV_RULE_RECTYPE_PUB.G_MISS_SELATTVAL_REC,
26 X_ATTR_VALUE_ID OUT NOCOPY NUMBER,
27 X_Return_Status OUT NOCOPY VARCHAR2,
28 X_Msg_Count OUT NOCOPY NUMBER,
29 X_Msg_Data OUT NOCOPY VARCHAR2
30 );
31
32 -- *******************************************************
33 -- Start of Comments
34 -- *******************************************************
35 -- API Name: Update_selattval
36 -- Type : Private
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,
46 X_Return_Status OUT NOCOPY VARCHAR2,
47 X_Msg_Count OUT NOCOPY NUMBER,
48 X_Msg_Data OUT NOCOPY VARCHAR2
49 );
50
51 -- *******************************************************
52 -- Start of Comments
53 -- *******************************************************
54 -- API Name: Delete_selattval
55 -- Type : Private
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,
65 X_Return_Status OUT NOCOPY VARCHAR2,
66 X_Msg_Count OUT NOCOPY NUMBER,
67 X_Msg_Data OUT NOCOPY VARCHAR2
68 );
69
70
71 -- Start of Comments
72 --
73 -- Item level validation procedures
74 --
75 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
76 -- For create: G_CREATE, for update: G_UPDATE
77 -- Note: 1. This is automated generated item level validation procedure.
78 -- The actual validation detail is needed to be added.
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,
88 X_Msg_Data OUT NOCOPY VARCHAR2
89 );
90
91
92 -- Start of Comments
93 --
94 -- Item level validation procedures
95 --
96 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
97 -- For create: G_CREATE, for update: G_UPDATE
98 -- Note: 1. This is automated generated item level validation procedure.
99 -- The actual validation detail is needed to be added.
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,
109 X_Msg_Data OUT NOCOPY VARCHAR2
110 );
111
112 -- Start of Comments
113 --
114 -- validation procedures
115 --
116 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
117 -- For create: G_CREATE, for update: G_UPDATE
118 -- Note: 1. This is automated generated item level validation procedure.
119 -- The actual validation detail is needed to be added.
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,
129 X_Msg_Count OUT NOCOPY NUMBER,
130 X_Msg_Data OUT NOCOPY VARCHAR2
131 );
132 End PV_SELATTVAL_PVT;