DBA Data[Home] [Help]

PACKAGE: APPS.PV_ENTYROUT_PVT

Source


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;