1 PACKAGE PV_SELCRIT_PVT AUTHID CURRENT_USER as
2 /* $Header: pvrvescs.pls 120.0 2005/05/27 15:23:01 appldev noship $ */
3 -- Start of Comments
4 -- Package name : PV_SELCRIT_PVT
5 -- Purpose :
6 -- History :
7 -- NOTE :
8 -- End of Comments
9
10
11 -- *******************************************************
12 -- Start of Comments
13 -- *******************************************************
14 -- API Name: Create_selcrit
15 -- Type : Private
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
25 := PV_RULE_RECTYPE_PUB.G_MISS_SELCRIT_REC,
26 X_SELECTION_CRITERIA_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_selcrit
36 -- Type : Private
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,
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_selcrit
55 -- Type : Private
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,
65 X_Return_Status OUT NOCOPY VARCHAR2,
66 X_Msg_Count OUT NOCOPY NUMBER,
67 X_Msg_Data OUT NOCOPY VARCHAR2
68 );
69
70 -- Start of Comments
71 --
72 -- Item level validation procedures
73 --
74 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
75 -- For create: G_CREATE, for update: G_UPDATE
76 -- Note: 1. This is automated generated item level validation procedure.
77 -- The actual validation detail is needed to be added.
78 --
79 -- End of Comments
80
81 PROCEDURE Validate_SELECTION_CRITERIA_ID (
82 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
83 P_Validation_mode IN VARCHAR2,
84 P_SELECTION_CRITERIA_ID IN NUMBER,
85 X_Return_Status OUT NOCOPY VARCHAR2,
86 X_Msg_Count OUT NOCOPY NUMBER,
87 X_Msg_Data OUT NOCOPY VARCHAR2
88 );
89
90
91 -- Start of Comments
92 --
93 -- validation procedures
94 --
95 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
96 -- For create: G_CREATE, for update: G_UPDATE
97 -- Note: 1. This is automated generated item level validation procedure.
98 -- The actual validation detail is needed to be added.
99 -- 2. We can also validate table instead of record. There will be an option for user to choose.
100 -- End of Comments
101
102 PROCEDURE Validate_selcrit(
103 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
104 P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
105 P_Validation_mode IN VARCHAR2,
106 P_SELCRIT_Rec IN PV_RULE_RECTYPE_PUB.SELCRIT_Rec_Type,
107 X_Return_Status OUT NOCOPY VARCHAR2,
108 X_Msg_Count OUT NOCOPY NUMBER,
109 X_Msg_Data OUT NOCOPY VARCHAR2
110 );
111 End PV_SELCRIT_PVT;