[Home] [Help]
PACKAGE: APPS.AHL_MC_RULE_STMT_PVT
Source
1 PACKAGE AHL_MC_RULE_STMT_PVT AUTHID CURRENT_USER AS
2 /* $Header: AHLVRSTS.pls 120.1 2007/12/21 13:35:48 sathapli ship $ */
3
4
5 ------------------------
6 -- Declare Procedures --
7 ------------------------
8 --------------------------------
9 -- Start of Comments --
10 -- Procedure name : Validate_Rule_Stmt
11 -- Type : Private
12 -- Function : Validates the rule statement for statement errors.
13 -- Pre-reqs :
14 -- Parameters :
15 --
16 -- Validate_Rule_Stmt Parameters:
17 -- p_rule_stmt_rec IN AHL_MC_RULE_PVT.Rule_Stmt_Rec_Type Required
18 --
19 -- End of Comments.
20
21 PROCEDURE Validate_Rule_Stmt (
22 p_api_version IN NUMBER,
23 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
24 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
25 x_return_status OUT NOCOPY VARCHAR2,
26 x_msg_count OUT NOCOPY NUMBER,
27 x_msg_data OUT NOCOPY VARCHAR2,
28 p_rule_stmt_rec IN AHL_MC_RULE_PVT.Rule_Stmt_Rec_Type);
29
30 --------------------------------
31 -- Start of Comments --
32 -- Procedure name : Insert_Rule_Stmt
33 -- Type : Private
34 -- Function : Writes to DB the rule stmt
35 -- Pre-reqs :
36 -- Parameters :
37 --
38 -- Insert_Rule_Stmt Parameters:
39 -- p_x_rule_stmt_rec IN OUT NOCOPY AHL_MC_RULE_PVT.Rule_Stmt_Rec_Type Required
40 --
41 -- End of Comments.
42
43 PROCEDURE Insert_Rule_Stmt (
44 p_api_version IN NUMBER,
45 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
46 p_commit IN VARCHAR2 := FND_API.G_FALSE,
47 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
48 x_return_status OUT NOCOPY VARCHAR2,
49 x_msg_count OUT NOCOPY NUMBER,
50 x_msg_data OUT NOCOPY VARCHAR2,
51 p_module IN VARCHAR2 := 'JSP',
52 p_x_rule_stmt_rec IN OUT NOCOPY AHL_MC_RULE_PVT.Rule_Stmt_Rec_Type);
53
54 --------------------------------
55 -- Start of Comments --
56 -- Procedure name : Update_Rule_Stmt
57 -- Type : Private
58 -- Function : Writes to DB the rule stmt
59 -- Pre-reqs :
60 -- Parameters :
61 --
62 -- Update_Rule_Stmt Parameters:
63 -- p_x_rule_stmt_rec IN OUT NOCOPY AHL_MC_RULE_PVT.Rule_Stmt_Rec_Type Required
64 --
65 -- End of Comments.
66
67 PROCEDURE Update_Rule_Stmt (
68 p_api_version IN NUMBER,
69 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
70 p_commit IN VARCHAR2 := FND_API.G_FALSE,
71 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
72 x_return_status OUT NOCOPY VARCHAR2,
73 x_msg_count OUT NOCOPY NUMBER,
74 x_msg_data OUT NOCOPY VARCHAR2,
75 p_module IN VARCHAR2 := 'JSP',
76 p_rule_stmt_rec IN AHL_MC_RULE_PVT.Rule_Stmt_Rec_Type);
77
78 --------------------------------
79 -- Start of Comments --
80 -- Procedure name : Copy_Rule_Stmt
81 -- Type : Private
82 -- Function : Writes to DB the rule stmt by copying the rule stmt
83 -- Pre-reqs :
84 -- Parameters :
85 --
86 -- Update_Rule_Stmt Parameters:
87 -- p_rule_stmt_id IN NUMBER Required. rule stmt to copy
88 -- p_to_rule_id IN NUMBER Required rule_id for insert purpose
89 -- p_to_mc_header_id IN NUMBER Requred. mc_header_id to copy to
90 -- x_rule_stmt_id OUT NOCOPY NUMBER the new rule_stmt_id
91 --
92 -- End of Comments.
93
94 PROCEDURE Copy_Rule_Stmt (
95 p_api_version IN NUMBER,
96 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
97 p_commit IN VARCHAR2 := FND_API.G_FALSE,
98 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
99 x_return_status OUT NOCOPY VARCHAR2,
100 x_msg_count OUT NOCOPY NUMBER,
101 x_msg_data OUT NOCOPY VARCHAR2,
102 p_rule_stmt_id IN NUMBER,
103 p_to_rule_id IN NUMBER,
104 p_to_mc_header_id IN NUMBER,
105 x_rule_stmt_id OUT NOCOPY NUMBER);
106
107 -----------------------------
108 -- Start of Comments --
109 -- Procedure name : Delete_Rule_Stmts
110 -- Type : Private
111 -- Function : Deletes all the Rule statements corresponding to a rule
112 -- Pre-reqs :
113 -- Parameters :
114 --
115 -- Delete_Rule Parameters:
116 -- p_rule_id IN NUMBER Required
117 --
118 -- End of Comments.
119
120 PROCEDURE Delete_Rule_Stmts (
121 p_api_version IN NUMBER,
122 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
123 p_commit IN VARCHAR2 := FND_API.G_FALSE,
124 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
125 x_return_status OUT NOCOPY VARCHAR2,
126 x_msg_count OUT NOCOPY NUMBER,
127 x_msg_data OUT NOCOPY VARCHAR2,
128 p_rule_id IN NUMBER);
129
130 --------------------------------
131 -- Start of Comments --
132 -- Procedure name : validate_quantity_rules_for_mc
133 -- Type : Private
134 -- Function : Validates all the quantity rule statements for a given MC.
135 -- Pre-reqs :
136 -- Parameters :
137 --
138 -- validate_quantity_rules_for_mc Parameters:
139 -- p_mc_header_id IN NUMBER Required
140 --
141 -- API added for FP OGMA Issue# 105 - Non-Serialized Item Maintenance, 03-Dec-2007
142 --
143 -- End of Comments.
144
145 PROCEDURE validate_quantity_rules_for_mc (
146 p_api_version IN NUMBER,
147 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
148 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
149 p_mc_header_id IN NUMBER,
150 x_return_status OUT NOCOPY VARCHAR2,
151 x_msg_count OUT NOCOPY NUMBER,
152 x_msg_data OUT NOCOPY VARCHAR2);
153
154 --
155
156 End AHL_MC_RULE_STMT_PVT;