1 PACKAGE PV_ENTYATTMAP_PVT AUTHID CURRENT_USER as
2 /* $Header: pvrveams.pls 115.2 2002/12/10 20:56:30 ryellapu ship $ */
3 -- Start of Comments
4 -- Package name : PV_ENTYATTMAP_PVT
5 -- Purpose :
6 -- History :
7 -- NOTE :
8 -- End of Comments
9
10
11 -- *******************************************************
12 -- Start of Comments
13 -- *******************************************************
14 -- API Name: Create_entyattmap
15 -- Type : Private
16 -- Pre-Req :
17 --
18 PROCEDURE Create_entyattmap(
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_ENTYATTMAP_Rec IN PV_RULE_RECTYPE_PUB.ENTYATTMAP_Rec_Type
25 := PV_RULE_RECTYPE_PUB.G_MISS_ENTYATTMAP_REC,
26 X_MAPPING_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_entyattmap
36 -- Type : Private
37 -- Pre-Req :
38
39 PROCEDURE Update_entyattmap(
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_ENTYATTMAP_Rec IN PV_RULE_RECTYPE_PUB.ENTYATTMAP_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_entyattmap
55 -- Type : Private
56 -- Pre-Req :
57
58 PROCEDURE Delete_entyattmap(
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_ENTYATTMAP_Rec IN PV_RULE_RECTYPE_PUB.ENTYATTMAP_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_MAPPING_ID (
83 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
84 P_Validation_mode IN VARCHAR2,
85 P_MAPPING_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_MAPPING_OPERATOR (
104 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
105 P_Validation_mode IN VARCHAR2,
106 P_ATTRIBUTE_ID IN NUMBER,
107 P_OPERATOR IN VARCHAR2,
108 X_Return_Status OUT NOCOPY VARCHAR2,
109 X_Msg_Count OUT NOCOPY NUMBER,
110 X_Msg_Data OUT NOCOPY VARCHAR2
111 );
112
113 -- Start of Comments
114 --
115 -- validation procedures
116 --
117 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
118 -- For create: G_CREATE, for update: G_UPDATE
119 -- Note: 1. This is automated generated item level validation procedure.
120 -- The actual validation detail is needed to be added.
121 -- 2. We can also validate table instead of record. There will be an option for user to choose.
122 -- End of Comments
123
124 PROCEDURE Validate_entyattmap(
125 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
126 P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
127 P_Validation_mode IN VARCHAR2,
128 P_ENTYATTMAP_Rec IN PV_RULE_RECTYPE_PUB.ENTYATTMAP_Rec_Type,
129 X_Return_Status OUT NOCOPY VARCHAR2,
130 X_Msg_Count OUT NOCOPY NUMBER,
131 X_Msg_Data OUT NOCOPY VARCHAR2
132 );
133
134 End PV_ENTYATTMAP_PVT;