[Home] [Help]
PACKAGE: APPS.QP_QUALIFIERS_UTIL_MOD
Source
1 PACKAGE QP_Qualifiers_Util_Mod AUTHID CURRENT_USER AS
2 /* $Header: QPXUQRSS.pls 120.0 2005/06/02 00:42:19 appldev noship $ */
3
4 -- Attributes global constants
5 /*
6 G_ATTRIBUTE1 CONSTANT NUMBER := 1;
7 G_ATTRIBUTE10 CONSTANT NUMBER := 2;
8 G_ATTRIBUTE11 CONSTANT NUMBER := 3;
9 G_ATTRIBUTE12 CONSTANT NUMBER := 4;
10 G_ATTRIBUTE13 CONSTANT NUMBER := 5;
11 G_ATTRIBUTE14 CONSTANT NUMBER := 6;
12 G_ATTRIBUTE15 CONSTANT NUMBER := 7;
13 G_ATTRIBUTE2 CONSTANT NUMBER := 8;
14 G_ATTRIBUTE3 CONSTANT NUMBER := 9;
15 G_ATTRIBUTE4 CONSTANT NUMBER := 10;
16 G_ATTRIBUTE5 CONSTANT NUMBER := 11;
17 G_ATTRIBUTE6 CONSTANT NUMBER := 12;
18 G_ATTRIBUTE7 CONSTANT NUMBER := 13;
19 G_ATTRIBUTE8 CONSTANT NUMBER := 14;
20 G_ATTRIBUTE9 CONSTANT NUMBER := 15;
21 G_COMPARISON_OPERATOR CONSTANT NUMBER := 16;
22 G_CONTEXT CONSTANT NUMBER := 17;
23 G_CREATED_BY CONSTANT NUMBER := 18;
24 G_CREATED_FROM_RULE CONSTANT NUMBER := 19;
25 G_CREATION_DATE CONSTANT NUMBER := 20;
26 G_END_DATE_ACTIVE CONSTANT NUMBER := 21;
27 G_EXCLUDER CONSTANT NUMBER := 22;
28 G_LAST_UPDATED_BY CONSTANT NUMBER := 23;
29 G_LAST_UPDATE_DATE CONSTANT NUMBER := 24;
30 G_LAST_UPDATE_LOGIN CONSTANT NUMBER := 25;
31 G_LIST_HEADER CONSTANT NUMBER := 26;
32 G_LIST_LINE CONSTANT NUMBER := 27;
33 G_PROGRAM_APPLICATION CONSTANT NUMBER := 28;
34 G_PROGRAM CONSTANT NUMBER := 29;
35 G_PROGRAM_UPDATE_DATE CONSTANT NUMBER := 30;
36 G_QUALIFIER_ATTRIBUTE CONSTANT NUMBER := 31;
37 G_QUALIFIER_ATTR_VALUE CONSTANT NUMBER := 32;
38 G_QUALIFIER_CONTEXT CONSTANT NUMBER := 33;
39 G_QUALIFIER_GROUPING_NO CONSTANT NUMBER := 34;
40 G_QUALIFIER CONSTANT NUMBER := 35;
41 G_QUALIFIER_RULE CONSTANT NUMBER := 36;
42 G_REQUEST CONSTANT NUMBER := 37;
43 G_START_DATE_ACTIVE CONSTANT NUMBER := 38;
44 G_MAX_ATTR_ID CONSTANT NUMBER := 39;
45
46 -- Procedure Clear_Dependent_Attr
47
48 PROCEDURE Clear_Dependent_Attr
49 ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
50 , p_QUALIFIERS_rec IN QP_Modifiers_PUB.Qualifiers_Rec_Type
51 , p_old_QUALIFIERS_rec IN QP_Modifiers_PUB.Qualifiers_Rec_Type :=
52 QP_Modifiers_PUB.G_MISS_QUALIFIERS_REC
53 , x_QUALIFIERS_rec OUT QP_Modifiers_PUB.Qualifiers_Rec_Type
54 );
55
56 -- Procedure Apply_Attribute_Changes
57
58 PROCEDURE Apply_Attribute_Changes
59 ( p_QUALIFIERS_rec IN QP_Modifiers_PUB.Qualifiers_Rec_Type
60 , p_old_QUALIFIERS_rec IN QP_Modifiers_PUB.Qualifiers_Rec_Type :=
61 QP_Modifiers_PUB.G_MISS_QUALIFIERS_REC
62 , x_QUALIFIERS_rec OUT QP_Modifiers_PUB.Qualifiers_Rec_Type
63 );
64
65 -- Function Complete_Record
66
67 FUNCTION Complete_Record
68 ( p_QUALIFIERS_rec IN QP_Modifiers_PUB.Qualifiers_Rec_Type
69 , p_old_QUALIFIERS_rec IN QP_Modifiers_PUB.Qualifiers_Rec_Type
70 ) RETURN QP_Modifiers_PUB.Qualifiers_Rec_Type;
71
72 -- Function Convert_Miss_To_Null
73
74 FUNCTION Convert_Miss_To_Null
75 ( p_QUALIFIERS_rec IN QP_Modifiers_PUB.Qualifiers_Rec_Type
76 ) RETURN QP_Modifiers_PUB.Qualifiers_Rec_Type;
77
78 -- Procedure Update_Row
79
80 PROCEDURE Update_Row
81 ( p_QUALIFIERS_rec IN QP_Modifiers_PUB.Qualifiers_Rec_Type
82 );
83
84 -- Procedure Insert_Row
85
86 PROCEDURE Insert_Row
87 ( p_QUALIFIERS_rec IN QP_Modifiers_PUB.Qualifiers_Rec_Type
88 );
89
90 -- Procedure Delete_Row
91
92 PROCEDURE Delete_Row
93 ( p_qualifier_id IN NUMBER
94 );
95
96 -- Function Query_Row
97
98 FUNCTION Query_Row
99 ( p_qualifier_id IN NUMBER
100 ) RETURN QP_Modifiers_PUB.Qualifiers_Rec_Type;
101
102 -- Function Query_Rows
103
104 --
105 */
106 FUNCTION Query_Rows
107 ( p_qualifier_id IN NUMBER :=
108 FND_API.G_MISS_NUM
109 , p_list_header_id IN NUMBER :=
110 FND_API.G_MISS_NUM
111 ) RETURN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
112
113 -- Procedure lock_Row
114 --
115 /*
116 PROCEDURE Lock_Row
117 ( x_return_status OUT VARCHAR2
118 , p_QUALIFIERS_rec IN QP_Modifiers_PUB.Qualifiers_Rec_Type
119 , x_QUALIFIERS_rec OUT QP_Modifiers_PUB.Qualifiers_Rec_Type
120 );
121
122 -- Function Get_Values
123
124 FUNCTION Get_Values
125 ( p_QUALIFIERS_rec IN QP_Modifiers_PUB.Qualifiers_Rec_Type
126 , p_old_QUALIFIERS_rec IN QP_Modifiers_PUB.Qualifiers_Rec_Type :=
127 QP_Modifiers_PUB.G_MISS_QUALIFIERS_REC
128 ) RETURN QP_Modifiers_PUB.Qualifiers_Val_Rec_Type;
129
130 -- Function Get_Ids
131
132 FUNCTION Get_Ids
133 ( p_QUALIFIERS_rec IN QP_Modifiers_PUB.Qualifiers_Rec_Type
134 , p_QUALIFIERS_val_rec IN QP_Modifiers_PUB.Qualifiers_Val_Rec_Type
135 ) RETURN QP_Modifiers_PUB.Qualifiers_Rec_Type;
136 */
137 END QP_Qualifiers_Util_Mod;