DBA Data[Home] [Help]

APPS.PON_UDA_PKG dependencies on PO_UDA_USAGE_OBJECT

Line 153: l_po_uda_usage_object_array PO_UDA_USAGE_OBJECT_ARRAY;

149:
150: PROCEDURE DEFAULT_NON_RENDER_UDA( p_auction_header_id IN NUMBER,
151: x_return_status OUT NOCOPY VARCHAR2) IS
152:
153: l_po_uda_usage_object_array PO_UDA_USAGE_OBJECT_ARRAY;
154: l_po_uda_usage_object PO_UDA_USAGE_OBJECT;
155: l_context EGO_COL_NAME_VALUE_PAIR_ARRAY ;
156: l_template_id NUMBER;
157: l_amd_flag Varchar2(1);

Line 154: l_po_uda_usage_object PO_UDA_USAGE_OBJECT;

150: PROCEDURE DEFAULT_NON_RENDER_UDA( p_auction_header_id IN NUMBER,
151: x_return_status OUT NOCOPY VARCHAR2) IS
152:
153: l_po_uda_usage_object_array PO_UDA_USAGE_OBJECT_ARRAY;
154: l_po_uda_usage_object PO_UDA_USAGE_OBJECT;
155: l_context EGO_COL_NAME_VALUE_PAIR_ARRAY ;
156: l_template_id NUMBER;
157: l_amd_flag Varchar2(1);
158: l_address_lookup_type varchar2(100);

Line 168: l_po_uda_usage_object := PO_UDA_USAGE_OBJECT();

164: l_msg_data Varchar2(2000);
165:
166:
167: BEGIN
168: l_po_uda_usage_object := PO_UDA_USAGE_OBJECT();
169: l_po_uda_usage_object_array := PO_UDA_USAGE_OBJECT_ARRAY();
170: l_context := EGO_COL_NAME_VALUE_PAIR_ARRAY();
171:
172: select uda_template_id,nvl(amendment_flag,'N') into l_template_id,l_amd_flag from pon_auction_headers_all where auction_header_id = p_auction_header_id;

Line 169: l_po_uda_usage_object_array := PO_UDA_USAGE_OBJECT_ARRAY();

165:
166:
167: BEGIN
168: l_po_uda_usage_object := PO_UDA_USAGE_OBJECT();
169: l_po_uda_usage_object_array := PO_UDA_USAGE_OBJECT_ARRAY();
170: l_context := EGO_COL_NAME_VALUE_PAIR_ARRAY();
171:
172: select uda_template_id,nvl(amendment_flag,'N') into l_template_id,l_amd_flag from pon_auction_headers_all where auction_header_id = p_auction_header_id;
173:

Line 180: l_po_uda_usage_object := po_uda_usage_object.new_instance(l_template_id,'ADDRESS',l_context );

176: else
177: l_address_lookup_type := 'SOL_UDA_ADDRESS_TYPES';
178: end if;
179:
180: l_po_uda_usage_object := po_uda_usage_object.new_instance(l_template_id,'ADDRESS',l_context );
181: l_po_uda_usage_object_array.extend(1);
182: l_po_uda_usage_object_array(1) := l_po_uda_usage_object;
183:
184:

Line 181: l_po_uda_usage_object_array.extend(1);

177: l_address_lookup_type := 'SOL_UDA_ADDRESS_TYPES';
178: end if;
179:
180: l_po_uda_usage_object := po_uda_usage_object.new_instance(l_template_id,'ADDRESS',l_context );
181: l_po_uda_usage_object_array.extend(1);
182: l_po_uda_usage_object_array(1) := l_po_uda_usage_object;
183:
184:
185: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --{

Line 182: l_po_uda_usage_object_array(1) := l_po_uda_usage_object;

178: end if;
179:
180: l_po_uda_usage_object := po_uda_usage_object.new_instance(l_template_id,'ADDRESS',l_context );
181: l_po_uda_usage_object_array.extend(1);
182: l_po_uda_usage_object_array(1) := l_po_uda_usage_object;
183:
184:
185: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --{
186: FND_LOG.string(log_level => FND_LOG.level_procedure,

Line 197: ,x_po_uda_usage_object_array => l_po_uda_usage_object_array

193: p_pk1_value => p_auction_header_id
194: ,p_template_id => l_template_id
195: ,p_address_lookup_type => l_address_lookup_type
196: ,x_external_attr_value_pairs => l_external_attr_value_pairs
197: ,x_po_uda_usage_object_array => l_po_uda_usage_object_array
198: ,x_return_status => l_return_status
199: ,x_errorcode => l_errorcode
200: ,x_msg_count => l_msg_count
201: ,x_msg_data => l_msg_data