1 PACKAGE PV_ENTYROUT_PVT AUTHID CURRENT_USER as
2 /* $Header: pvrverts.pls 120.0 2005/05/27 15:29:10 appldev noship $ */
3 -- Start of Comments
4 -- Package name : PV_ENTYROUT_PVT
5 -- Purpose :
6 -- History :
7 -- NOTE :
8 -- End of Comments
9
10
11 -- *******************************************************
12 -- Start of Comments
13 -- *******************************************************
14 -- API Name: Create_entyrout
15 -- Type : Private
16 -- Pre-Req :
17 --
18 PROCEDURE Create_entyrout(
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_ENTYROUT_Rec IN PV_RULE_RECTYPE_PUB.ENTYROUT_Rec_Type
25 := PV_RULE_RECTYPE_PUB.G_MISS_ENTYROUT_REC,
26 X_ENTITY_ROUTING_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_entyrout
36 -- Type : Private
37 -- Pre-Req :
38
39 PROCEDURE Update_entyrout(
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_ENTYROUT_Rec IN PV_RULE_RECTYPE_PUB.ENTYROUT_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_entyrout
55 -- Type : Private
56 -- Pre-Req :
57
58 PROCEDURE Delete_entyrout(
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_ENTYROUT_Rec IN PV_RULE_RECTYPE_PUB.ENTYROUT_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_ENTITY_ROUTING_ID (
83 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
84 P_Validation_mode IN VARCHAR2,
85 P_ENTITY_ROUTING_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 -- Start of Comments
92 --
93 -- Item level 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 --
100 -- End of Comments
101
102 PROCEDURE Validate_UNMATCHED_INT_RS_ID (
103 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
104 P_Validation_mode IN VARCHAR2,
105 P_UNMATCHED_INT_RESOURCE_ID IN NUMBER,
106 X_Return_Status OUT NOCOPY VARCHAR2,
107 X_Msg_Count OUT NOCOPY NUMBER,
108 X_Msg_Data OUT NOCOPY VARCHAR2
109 );
110
111 -- Start of Comments
112 --
113 -- validation procedures
114 --
115 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
116 -- For create: G_CREATE, for update: G_UPDATE
117 -- Note: 1. This is automated generated item level validation procedure.
118 -- The actual validation detail is needed to be added.
119 -- 2. We can also validate table instead of record. There will be an option for user to choose.
120 -- End of Comments
121
122 PROCEDURE Validate_entyrout(
123 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
124 P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
125 P_Validation_mode IN VARCHAR2,
126 P_ENTYROUT_Rec IN PV_RULE_RECTYPE_PUB.ENTYROUT_Rec_Type,
127 X_Return_Status OUT NOCOPY VARCHAR2,
128 X_Msg_Count OUT NOCOPY NUMBER,
129 X_Msg_Data OUT NOCOPY VARCHAR2
130 );
131 End PV_ENTYROUT_PVT;