1 PACKAGE PV_ENTYRLS_PVT AUTHID CURRENT_USER as
2 /* $Header: pvrveras.pls 115.2 2002/12/10 20:56:35 ryellapu ship $ */
3 -- Start of Comments
4 -- Package name : PV_ENTYRLS_PVT
5 -- Purpose :
6 -- History :
7 -- NOTE :
8 -- End of Comments
9
10
11
12 -- *******************************************************
13 -- Start of Comments
14 -- *******************************************************
15 -- API Name: Create_entyrls
16 -- Type : Private
17 -- Pre-Req :
18 --
19 PROCEDURE Create_entyrls(
20 P_Api_Version_Number IN NUMBER,
21 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
22 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
23 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
24 P_Identity_Resource_Id IN NUMBER,
25 P_ENTYRLS_Rec IN PV_RULE_RECTYPE_PUB.ENTYRLS_Rec_Type
26 := PV_RULE_RECTYPE_PUB.G_MISS_ENTYRLS_REC,
27 X_ENTITY_RULE_APPLIED_ID OUT NOCOPY NUMBER,
28 X_Return_Status OUT NOCOPY VARCHAR2,
29 X_Msg_Count OUT NOCOPY NUMBER,
30 X_Msg_Data OUT NOCOPY VARCHAR2
31 );
32
33 -- *******************************************************
34 -- Start of Comments
35 -- *******************************************************
36 -- API Name: Update_entyrls
37 -- Type : Private
38 -- Pre-Req :
39
40 PROCEDURE Update_entyrls(
41 P_Api_Version_Number IN NUMBER,
42 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
43 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
44 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
45 P_Identity_Resource_Id IN NUMBER,
46 P_ENTYRLS_Rec IN PV_RULE_RECTYPE_PUB.ENTYRLS_Rec_Type,
47 X_Return_Status OUT NOCOPY VARCHAR2,
48 X_Msg_Count OUT NOCOPY NUMBER,
49 X_Msg_Data OUT NOCOPY VARCHAR2
50 );
51
52 -- *******************************************************
53 -- Start of Comments
54 -- *******************************************************
55 -- API Name: Delete_entyrls
56 -- Type : Private
57 -- Pre-Req :
58 -- Parameters:
59
60 PROCEDURE Delete_entyrls(
61 P_Api_Version_Number IN NUMBER,
62 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
63 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
64 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
65 P_Identity_Resource_Id IN NUMBER,
66 P_ENTYRLS_Rec IN PV_RULE_RECTYPE_PUB.ENTYRLS_Rec_Type,
67 X_Return_Status OUT NOCOPY VARCHAR2,
68 X_Msg_Count OUT NOCOPY NUMBER,
69 X_Msg_Data OUT NOCOPY VARCHAR2
70 );
71
72
73 -- Start of Comments
74 --
75 -- Item level validation procedures
76 --
77 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
78 -- For create: G_CREATE, for update: G_UPDATE
79 -- Note: 1. This is automated generated item level validation procedure.
80 -- The actual validation detail is needed to be added.
81 --
82 -- End of Comments
83
84 PROCEDURE Validate_ENTY_RULE_APPLIED_ID (
85 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
86 P_Validation_mode IN VARCHAR2,
87 P_ENTITY_RULE_APPLIED_ID IN NUMBER,
88 X_Return_Status OUT NOCOPY VARCHAR2,
89 X_Msg_Count OUT NOCOPY NUMBER,
90 X_Msg_Data OUT NOCOPY VARCHAR2
91 );
92
93 -- Start of Comments
94 --
95 -- validation procedures
96 --
97 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
98 -- For create: G_CREATE, for update: G_UPDATE
99 -- Note: 1. This is automated generated item level validation procedure.
100 -- The actual validation detail is needed to be added.
101 -- 2. We can also validate table instead of record. There will be an option for user to choose.
102 -- End of Comments
103
104 PROCEDURE Validate_entyrls(
105 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
106 P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
107 P_Validation_mode IN VARCHAR2,
108 P_ENTYRLS_Rec IN PV_RULE_RECTYPE_PUB.ENTYRLS_Rec_Type,
109 X_Return_Status OUT NOCOPY VARCHAR2,
110 X_Msg_Count OUT NOCOPY NUMBER,
111 X_Msg_Data OUT NOCOPY VARCHAR2
112 );
113 End PV_ENTYRLS_PVT;