[Home] [Help]
PACKAGE: APPS.QP_QUALIFIER_RULES_PVT
Source
1 PACKAGE QP_Qualifier_Rules_PVT AS
2 /* $Header: QPXVQRQS.pls 120.1 2005/06/16 00:06:00 appldev $ */
3 -- Start of Comments
4 -- API name Process_Qualifier_Rules
5 -- Type Private
6 -- Function
7 --
8 -- Pre-reqs
9 --
10 -- Parameters
11 --
12 -- Version Current version = 1.0
13 -- Initial version = 1.0
14 -- 13-Dec-99 Modified
15 -- Added Copy_Qualifier_rule Procedure
16 -- Notes
17 --
18 -- End of Comments
19
20 PROCEDURE Process_Qualifier_Rules
21 ( p_api_version_number IN NUMBER
22 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
23 , p_commit IN VARCHAR2 := FND_API.G_FALSE
24 , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
25 , p_control_rec IN QP_GLOBALS.Control_Rec_Type :=
26 QP_GLOBALS.G_MISS_CONTROL_REC
27 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
28 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
29 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
30 , p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type :=
31 QP_Qualifier_Rules_PUB.G_MISS_QUALIFIER_RULES_REC
32 , p_old_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type :=
33 QP_Qualifier_Rules_PUB.G_MISS_QUALIFIER_RULES_REC
34 , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=
35 QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL
36 , p_old_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=
37 QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL
38 , x_QUALIFIER_RULES_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
39 , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
40 );
41
42 -- Start of Comments
43 -- API name Lock_Qualifier_Rules
44 -- Type Private
45 -- Function
46 --
47 -- Pre-reqs
48 --
49 -- Parameters
50 --
51 -- Version Current version = 1.0
52 -- Initial version = 1.0
53 --
54 -- Notes
55 --
56 -- End of Comments
57
58 PROCEDURE Lock_Qualifier_Rules
59 ( p_api_version_number IN NUMBER
60 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
61 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
62 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
63 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
64 , p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type :=
65 QP_Qualifier_Rules_PUB.G_MISS_QUALIFIER_RULES_REC
66 , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=
67 QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL
68 , x_QUALIFIER_RULES_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
69 , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
70 );
71
72 -- Start of Comments
73 -- API name Get_Qualifier_Rules
74 -- Type Private
75 -- Function
76 --
77 -- Pre-reqs
78 --
79 -- Parameters
80 --
81 -- Version Current version = 1.0
82 -- Initial version = 1.0
83 --
84 -- Notes
85 --
86 -- End of Comments
87
88 PROCEDURE Get_Qualifier_Rules
89 ( p_api_version_number IN NUMBER
90 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
91 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
92 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
93 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
94 , p_qualifier_rule_id IN NUMBER
95 , x_QUALIFIER_RULES_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
96 , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
97 );
98 -- Start of Comments
99 -- API name Copy_Qualifier_Rule
100 -- Type Private
101 -- Function
102 --
103 -- Pre-reqs
104 --
105 -- Parameters
106 --
107 -- Version Current version = 1.0
108 -- Initial version = 1.0
109 --
110 -- Notes
111 --
112 -- End of Comments
113
114
115 PROCEDURE Copy_Qualifier_Rule
116 ( p_api_version_number IN NUMBER
117 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
118 , p_commit IN VARCHAR2 := FND_API.G_FALSE
119 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
120 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
121 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
122 , p_qualifier_rule_id IN NUMBER :=FND_API.G_MISS_NUM
123 , p_to_qualifier_rule IN VARCHAR2 :=FND_API.G_MISS_CHAR
124 , p_to_description IN VARCHAR2 := FND_API.G_MISS_CHAR
125 , x_qualifier_rule_id OUT NOCOPY /* file.sql.39 change */ NUMBER
126 );
127
128 -- Blanket Agreement
129
130 PROCEDURE Create_Blanket_Qualifier
131 ( p_list_header_id IN NUMBER
132 , p_old_list_header_id IN NUMBER
133 , p_blanket_id IN NUMBER
134 , p_operation IN VARCHAR2
135 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
136 );
137
138 END QP_Qualifier_Rules_PVT;