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
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,