eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_DOC_UDA_UTIL dependencies on EGO_COL_NAME_VALUE_PAIR_ARRAY

Line 34: l_context EGO_COL_NAME_VALUE_PAIR_ARRAY ;

30: l_po_uda_usage_object po_uda_usage_object ;
31: l_attr_grp_ids_list PO_TBL_NUMBER;
32: l_x_attr_ids_count NUMBER;
33: l_clm_standard_form PO_HEADERS_ALL.CLM_STANDARD_FORM%TYPE;
34: l_context EGO_COL_NAME_VALUE_PAIR_ARRAY ;
35: l_attr_grp_ids PO_TBL_NUMBER;
36: t_count NUMBER;
37:
38: cursor c_get_usages(p_template_id number) is

Line 56: l_context := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'FORM_TYPE', l_clm_standard_form));

52:
53: IF (c_get_usages_rec.attribute_category = 'FORMS') then
54: SELECT clm_standard_form into l_clm_standard_form FROM po_headers_all
55: WHERE po_header_id = p_po_header_id;
56: l_context := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'FORM_TYPE', l_clm_standard_form));
57: END IF;
58:
59: IF((p_is_doc_mod = FND_API.G_TRUE AND c_get_usages_rec.attribute_category = 'CHAIN')
60: OR (c_get_usages_rec.attribute_category = 'DOCUMENT_NUMBERING')) THEN

Line 113: l_context EGO_COL_NAME_VALUE_PAIR_ARRAY ;

109: d_module CONSTANT VARCHAR2(100) := d_pkg_name || d_api_name;
110: d_progress NUMBER := 0;
111:
112: l_po_uda_usage_object po_uda_usage_object ;
113: l_context EGO_COL_NAME_VALUE_PAIR_ARRAY ;
114: l_attr_grp_ids_list PO_TBL_NUMBER;
115: l_contract_type PO_LINES_ALL.CONTRACT_TYPE%TYPE;
116: l_clm_idc_type PO_LINES_ALL.CLM_IDC_TYPE%TYPE;
117: l_x_attr_ids_count NUMBER;

Line 172: l_context := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'CONTRACT_LINE_TYPE', l_contract_type),

168: l_contract_type := p_contract_type;
169: l_clm_idc_type := p_clm_idc_type;
170: END IF;
171:
172: l_context := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'CONTRACT_LINE_TYPE', l_contract_type),
173: EGO_COL_NAME_VALUE_PAIR_OBJ( 'IDC_TYPE' , l_clm_idc_type ));
174: END IF;
175:
176: IF(p_is_doc_mod = FND_API.G_TRUE AND c_get_usages_rec.attribute_category = 'CHAIN') THEN

Line 228: l_context EGO_COL_NAME_VALUE_PAIR_ARRAY ;

224: d_progress NUMBER := 0;
225: l_po_uda_usage_object po_uda_usage_object ;
226: l_attr_grp_ids_list PO_TBL_NUMBER;
227: l_x_attr_ids_count NUMBER;
228: l_context EGO_COL_NAME_VALUE_PAIR_ARRAY ;
229: l_attr_grp_ids PO_TBL_NUMBER;
230: t_count NUMBER;
231:
232: CURSOR c_get_usages(p_template_id NUMBER) IS

Line 290: l_from_pk_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

286: d_api_name CONSTANT VARCHAR2(30) := 'merge_mod_uda';
287: d_module CONSTANT VARCHAR2(100) := d_pkg_name || d_api_name;
288: d_progress NUMBER := 0;
289: l_template_id NUMBER;
290: l_from_pk_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
291: l_to_pk_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
292: l_copy_attribute_groups VARCHAR2(10);
293: l_attribute_group_table PO_TBL_VARCHAR30;
294: l_attr_group_name VARCHAR2(250);

Line 291: l_to_pk_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

287: d_module CONSTANT VARCHAR2(100) := d_pkg_name || d_api_name;
288: d_progress NUMBER := 0;
289: l_template_id NUMBER;
290: l_from_pk_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
291: l_to_pk_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
292: l_copy_attribute_groups VARCHAR2(10);
293: l_attribute_group_table PO_TBL_VARCHAR30;
294: l_attr_group_name VARCHAR2(250);
295: l_return_status VARCHAR2(2);

Line 325: l_from_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('PO_HEADER_ID', p_po_header_id),

321: INTO l_template_id
322: FROM po_headers_all
323: WHERE po_header_id = p_po_header_id;
324:
325: l_from_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('PO_HEADER_ID', p_po_header_id),
326: EGO_COL_NAME_VALUE_PAIR_OBJ('DRAFT_ID', p_draft_id));
327: l_to_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('PO_HEADER_ID', p_po_header_id),
328: EGO_COL_NAME_VALUE_PAIR_OBJ('DRAFT_ID', -1));
329: l_attribute_group_table := PO_TBL_VARCHAR30();

Line 327: l_to_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('PO_HEADER_ID', p_po_header_id),

323: WHERE po_header_id = p_po_header_id;
324:
325: l_from_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('PO_HEADER_ID', p_po_header_id),
326: EGO_COL_NAME_VALUE_PAIR_OBJ('DRAFT_ID', p_draft_id));
327: l_to_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('PO_HEADER_ID', p_po_header_id),
328: EGO_COL_NAME_VALUE_PAIR_OBJ('DRAFT_ID', -1));
329: l_attribute_group_table := PO_TBL_VARCHAR30();
330: FOR c_get_add_agids_tbl_rec IN c_get_add_agids_tbl(l_template_id)
331: LOOP

Line 389: l_from_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('PO_LINE_ID', l_po_line_ids(i)),

385: INTO l_template_id
386: FROM po_lines_all
387: WHERE po_line_id = l_po_line_ids(i);
388:
389: l_from_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('PO_LINE_ID', l_po_line_ids(i)),
390: EGO_COL_NAME_VALUE_PAIR_OBJ('DRAFT_ID', p_draft_id));
391: l_to_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('PO_LINE_ID', l_po_line_ids(i)),
392: EGO_COL_NAME_VALUE_PAIR_OBJ('DRAFT_ID', -1));
393:

Line 391: l_to_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('PO_LINE_ID', l_po_line_ids(i)),

387: WHERE po_line_id = l_po_line_ids(i);
388:
389: l_from_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('PO_LINE_ID', l_po_line_ids(i)),
390: EGO_COL_NAME_VALUE_PAIR_OBJ('DRAFT_ID', p_draft_id));
391: l_to_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('PO_LINE_ID', l_po_line_ids(i)),
392: EGO_COL_NAME_VALUE_PAIR_OBJ('DRAFT_ID', -1));
393:
394: SELECT CONTRACT_TYPE, CLM_IDC_TYPE
395: INTO l_drft_contract_type, l_drft_idc_type

Line 445: l_from_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('LINE_LOCATION_ID', l_po_line_location_ids(j)),

441: INTO l_template_id
442: FROM po_line_locations_all
443: WHERE line_location_id = l_po_line_location_ids(j);
444:
445: l_from_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('LINE_LOCATION_ID', l_po_line_location_ids(j)),
446: EGO_COL_NAME_VALUE_PAIR_OBJ('DRAFT_ID', p_draft_id));
447: l_to_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('LINE_LOCATION_ID', l_po_line_location_ids(j)),
448: EGO_COL_NAME_VALUE_PAIR_OBJ('DRAFT_ID', -1));
449:

Line 447: l_to_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('LINE_LOCATION_ID', l_po_line_location_ids(j)),

443: WHERE line_location_id = l_po_line_location_ids(j);
444:
445: l_from_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('LINE_LOCATION_ID', l_po_line_location_ids(j)),
446: EGO_COL_NAME_VALUE_PAIR_OBJ('DRAFT_ID', p_draft_id));
447: l_to_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('LINE_LOCATION_ID', l_po_line_location_ids(j)),
448: EGO_COL_NAME_VALUE_PAIR_OBJ('DRAFT_ID', -1));
449:
450: PO_UDA_DATA_UTIL.AutoCreate_User_Attrs
451: (