[Home] [Help]
PACKAGE: APPS.QP_ATTR_MAPPING_PUB
Source
1 PACKAGE QP_Attr_Mapping_PUB AUTHID CURRENT_USER AS
2 /* $Header: QPXPSRCS.pls 120.4.12020000.1 2012/06/27 21:09:23 appldev ship $ */
3
4 --
5 g_dynamic_mapping_needed varchar2(1) := 'Y';
6 --added for MOAC
7 G_ORG_ID NUMBER;
8 --
9 g_dynamic_mapping_count BINARY_INTEGER:=0; -- 7323926
10 TYPE Contexts_Result_Rec_Type IS RECORD
11 ( context_name VARCHAR2(30)
12 , attribute_name VARCHAR2(240)
13 , attribute_value VARCHAR2(240)
14 );
15
16 TYPE Sourced_Contexts_Rec_Type IS RECORD
17 ( attribute_name VARCHAR2(240)
18 , src_type VARCHAR2(30)
19 , src_api_pkg VARCHAR2(1000)
20 , src_api_fn VARCHAR2(1000)
21 , src_profile_option VARCHAR2(240)
22 , src_system_variable VARCHAR2(240)
23 , src_constant_value VARCHAR2(240)
24 , context_name VARCHAR2(240)
25 , context_type VARCHAR2(30)
26 );
27
28 TYPE New_Sourced_Contexts_Rec_Type IS RECORD
29 ( attribute_name VARCHAR2(240)
30 , src_type VARCHAR2(30)
31 , value_string VARCHAR2(2000)
32 , context_name VARCHAR2(240)
33 , context_type VARCHAR2(30)
34 );
35
36 TYPE New_Sourced_Contexts_Tbl_Type IS TABLE OF New_Sourced_Contexts_Rec_Type INDEX BY BINARY_INTEGER;
37
38 TYPE t_Segment_Ctr IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
39
40 TYPE Contexts_Result_Tbl_Type IS TABLE OF Contexts_Result_Rec_Type INDEX BY BINARY_INTEGER;
41
42 TYPE Sourced_Contexts_Tbl_Type IS TABLE OF Sourced_Contexts_Rec_Type INDEX BY BINARY_INTEGER;
43
44 TYPE t_MultiRecord IS TABLE OF VARCHAR2(240) INDEX BY BINARY_INTEGER;
45
46 TYPE User_Attribute_Rec_Type IS RECORD
47 ( context_name VARCHAR2(30)
48 , attribute_name VARCHAR2(240)
49 );
50
51 TYPE User_Attribute_Tbl_Type IS TABLE OF User_Attribute_Rec_Type INDEX BY BINARY_INTEGER;
52
53 PROCEDURE Put_line (Text VARCHAR2);
54
55 PROCEDURE Print_Line(Text VARCHAR2); --Bug#4509601
56
57 PROCEDURE Init_Applsys_Schema;
58
59 PROCEDURE New_Line;
60
61 PROCEDURE Comment
62 ( p_comment IN VARCHAR2
63 , p_level IN NUMBER default 1
64 );
65
66 PROCEDURE Text
67 ( p_string IN VARCHAR2
68 , p_level IN NUMBER default 1
69 );
70
71 PROCEDURE Pkg_End
72 ( p_pkg_name IN VARCHAR2
73 , p_pkg_type IN VARCHAR2
74 );
75
76 PROCEDURE Pkg_Header
77 ( p_pkg_name IN VARCHAR2
78 , p_pkg_type IN VARCHAR2
79 );
80
81 PROCEDURE Create_Sourcing_Calls
82 ( p_request_type_code IN VARCHAR2
83 , p_pricing_type IN VARCHAR2
84 , p_HVOP_Call IN VARCHAR2 := 'N'
85 );
86
87 PROCEDURE Build_Sourcing_Package
88 ( err_buff OUT NOCOPY VARCHAR2
89 , retcode OUT NOCOPY NUMBER
90 );
91
92
93 PROCEDURE Build_Contexts
94 ( p_request_type_code IN VARCHAR2
95 , p_pricing_type IN VARCHAR2
96 --added for MOAC
97 , p_org_id IN NUMBER DEFAULT NULL
98 , x_price_contexts_result_tbl OUT NOCOPY CONTEXTS_RESULT_TBL_TYPE
99 , x_qual_contexts_result_tbl OUT NOCOPY CONTEXTS_RESULT_TBL_TYPE
100 );
101
102 /*
103 overloading build_contexts for AG purpose performance fix
104 to insert into tmp tables directly for OM Integration
105 changes by spgopal
106 */
107
108 PROCEDURE Build_Contexts
109 ( p_request_type_code IN VARCHAR2
110 , p_line_index IN NUMBER
111 , p_pricing_type_code IN VARCHAR2
112 , p_price_list_validated_flag IN VARCHAR2 DEFAULT NULL
113 --added for MOAC
114 , p_org_id IN NUMBER DEFAULT NULL
115 );
116
117
118
119 PROCEDURE Get_User_Item_Pricing_Attribs
120 ( p_request_type_code IN VARCHAR2
121 , p_item_id IN VARCHAR2
122 , p_user_attribs_tbl OUT NOCOPY USER_ATTRIBUTE_TBL_TYPE
123 );
124
125 PROCEDURE Get_User_Item_Pricing_Attribs
126 ( p_request_type_code IN VARCHAR2
127 , p_user_attribs_tbl OUT NOCOPY USER_ATTRIBUTE_TBL_TYPE
128 );
129
130 PROCEDURE Get_User_Item_Pricing_Contexts
131 ( p_request_type_code IN VARCHAR2
132 , p_user_attribs_tbl OUT NOCOPY USER_ATTRIBUTE_TBL_TYPE
133 );
134
135 FUNCTION Is_Attribute_Used (p_attribute_context IN VARCHAR2, p_attribute_code IN VARCHAR2) RETURN VARCHAR2;
136
137 PROCEDURE Check_line_group_items(p_pricing_type_code IN VARCHAR2);
138
139 --Overloeaded in the pl/sql path for changed lines linegroup item dependency
140 PROCEDURE Build_Contexts
141 ( p_request_type_code IN VARCHAR2
142 , p_pricing_type IN VARCHAR2
143 , p_check_line_flag IN VARCHAR2
144 , p_pricing_event IN VARCHAR2
145 --added for MOAC
146 , p_org_id IN NUMBER DEFAULT NULL
147 , x_price_contexts_result_tbl OUT NOCOPY CONTEXTS_RESULT_TBL_TYPE
148 , x_qual_contexts_result_tbl OUT NOCOPY CONTEXTS_RESULT_TBL_TYPE
149 , x_pass_line OUT NOCOPY VARCHAR2
150 );
151
152
153 PROCEDURE Build_Contexts
154 ( p_request_type_code IN VARCHAR2
155 , p_line_index IN NUMBER
156 , p_check_line_flag IN VARCHAR2
157 , p_pricing_event IN VARCHAR2
158 , p_pricing_type_code IN VARCHAR2
159 , p_price_list_validated_flag IN VARCHAR2 DEFAULT NULL
160 --added for MOAC
161 , p_org_id IN NUMBER DEFAULT NULL
162 , x_pass_line OUT NOCOPY VARCHAR2
163 );
164
165 PROCEDURE Map_Used_But_Not_Mapped_Attrs
166 ( p_request_type_code IN VARCHAR2
167 , p_pricing_type IN VARCHAR2
168 , x_price_contexts_result_tbl OUT NOCOPY CONTEXTS_RESULT_TBL_TYPE
169 , x_qual_contexts_result_tbl OUT NOCOPY CONTEXTS_RESULT_TBL_TYPE
170 );
171
172 PROCEDURE Check_All_Mapping
173 ( err_buff OUT NOCOPY VARCHAR2
174 , retcode OUT NOCOPY NUMBER
175 , p_request_type_code IN VARCHAR2
176 );
177
178 G_Temp_Value VARCHAR2(200);
179 G_Temp_MultiValue t_MultiRecord;
180 G_Test_MultiValue t_MultiRecord;
181 G_Segment_Ctr t_Segment_Ctr;
182 G_User_Attribs_Tbl USER_ATTRIBUTE_TBL_TYPE;
183 G_Price_Contexts_Rslt_Tbl Contexts_Result_Tbl_Type;
184 G_Qualf_Contexts_Rslt_Tbl Contexts_Result_Tbl_Type;
185 G_Sourced_Contexts_Tbl Sourced_Contexts_Tbl_Type;
186 G_New_Sourced_Contexts_Tbl New_Sourced_Contexts_Tbl_Type;
187 g_retcode VARCHAR2(30);
188 g_errbuf VARCHAR2(240);
189 G_ATTRMGR_INSTALLED VARCHAR2(30);
190 G_Product_Attr_Tbl Contexts_Result_Tbl_Type;
191 G_PASS_THIS_LINE VARCHAR2(1) := 'Y';
192 G_CHECK_LINE_FLAG VARCHAR2(1) := 'N';
193 G_IGNORE_PRICE VARCHAR(1) := 'N'; --8589909
194
195 -- bug#3848849 Added global variable to store request type code
196 G_REQ_TYPE_CODE VARCHAR2(10);
197
198 END QP_Attr_Mapping_PUB;