APPS.PON_UDA_PKG dependencies on EGO_COL_NAME_VALUE_PAIR_ARRAY

Line 155: l_context EGO_COL_NAME_VALUE_PAIR_ARRAY ;

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);
159: l_external_attr_value_pairs EGO_COL_NAME_VALUE_PAIR_TABLE;

Line 170: l_context := EGO_COL_NAME_VALUE_PAIR_ARRAY();

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:
174: if ( l_amd_flag = 'Y' ) then

Line 314: pk_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

310: x_errorcode OUT NOCOPY NUMBER,
311: x_msg_count OUT NOCOPY NUMBER,
312: x_msg_data OUT NOCOPY VARCHAR2) IS
313:
314: pk_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
315: l_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
316: l_failed_row_id_list VARCHAR2(100);
317: l_count number;
318:

Line 315: l_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

311: x_msg_count OUT NOCOPY NUMBER,
312: x_msg_data OUT NOCOPY VARCHAR2) IS
313:
314: pk_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
315: l_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
316: l_failed_row_id_list VARCHAR2(100);
317: l_count number;
318:
319: --Bug : 16838468

Line 324: pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY

320: l_attr_grp_id NUMBER;
321:
322: BEGIN
323: --print_debug_messages('Start of procedure IMPORT_EXCEL_UDA, p_bid_number : '||p_bid_number||' p_line_number '||p_line_number||' p_template_id '||p_template_id);
324: pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY
325: (
326: EGO_COL_NAME_VALUE_PAIR_OBJ('BID_NUMBER', p_bid_number),
327: EGO_COL_NAME_VALUE_PAIR_OBJ('LINE_NUMBER', p_line_number)
328: );

Line 356: l_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY

352: exit;
353: END IF;
354: END LOOP;*/
355:
356: l_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY
357: (
358: EGO_COL_NAME_VALUE_PAIR_OBJ
359: (
360: 'UDA_TEMPLATE_ID',p_template_id || ''

Line 405: l_pk_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

401: x_errorcode OUT NOCOPY NUMBER,
402: x_msg_count OUT NOCOPY NUMBER,
403: x_msg_data OUT NOCOPY VARCHAR2) IS
404:
405: l_pk_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
406: l_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
407: l_failed_row_id_list VARCHAR2(100);
408:
409: BEGIN

Line 406: l_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

402: x_msg_count OUT NOCOPY NUMBER,
403: x_msg_data OUT NOCOPY VARCHAR2) IS
404:
405: l_pk_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
406: l_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
407: l_failed_row_id_list VARCHAR2(100);
408:
409: BEGIN
410: --print_debug_messages('Start of procedure validate_uda.');

Line 412: l_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY

408:
409: BEGIN
410: --print_debug_messages('Start of procedure validate_uda.');
411:
412: l_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY
413: (
414: EGO_COL_NAME_VALUE_PAIR_OBJ('BID_NUMBER', p_bid_number),
415: EGO_COL_NAME_VALUE_PAIR_OBJ('LINE_NUMBER', p_line_number)
416: );

Line 418: l_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(

414: EGO_COL_NAME_VALUE_PAIR_OBJ('BID_NUMBER', p_bid_number),
415: EGO_COL_NAME_VALUE_PAIR_OBJ('LINE_NUMBER', p_line_number)
416: );
417:
418: l_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
419: EGO_COL_NAME_VALUE_PAIR_OBJ
420: (
421: 'UDA_TEMPLATE_ID',p_template_id || ''
422: ));