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.POR_UDA_PKG dependencies on EGO_COL_NAME_VALUE_PAIR_OBJ

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

49: OPEN c_get_usage_context(p_req_line_id);
50: FETCH c_get_usage_context INTO l_contract_type;
51: CLOSE c_get_usage_context;
52:
53: l_context := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'CONTRACT_LINE_TYPE', l_contract_type),
54: EGO_COL_NAME_VALUE_PAIR_OBJ( 'IDC_TYPE', 'IDC_NA'));
55: END IF;
56:
57: IF(p_is_amd_mode = 'true' AND c_get_usages_rec.attribute_category = 'CHAIN') THEN

Line 54: EGO_COL_NAME_VALUE_PAIR_OBJ( 'IDC_TYPE', 'IDC_NA'));

50: FETCH c_get_usage_context INTO l_contract_type;
51: CLOSE c_get_usage_context;
52:
53: l_context := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'CONTRACT_LINE_TYPE', l_contract_type),
54: EGO_COL_NAME_VALUE_PAIR_OBJ( 'IDC_TYPE', 'IDC_NA'));
55: END IF;
56:
57: IF(p_is_amd_mode = 'true' AND c_get_usages_rec.attribute_category = 'CHAIN') THEN
58: IF PO_LOG.d_stmt THEN

Line 118: l_ext_name_val_obj EGO_COL_NAME_VALUE_PAIR_OBJ;

114: l_msg_data VARCHAR2(4000);
115: t_count NUMBER;
116:
117: l_ext_attr_value_pairs_ind NUMBER;
118: l_ext_name_val_obj EGO_COL_NAME_VALUE_PAIR_OBJ;
119: l_uda_return_status VARCHAR2(10);
120: l_uda_msg_data VARCHAR2(4000);
121: l_final_return_status VARCHAR2(10);
122: l_final_msg_data VARCHAR2(4000);

Line 308: l_ext_name_val_obj EGO_COL_NAME_VALUE_PAIR_OBJ;

304: l_attr_name_value_pairs EGO_USER_ATTR_DATA_TABLE;
305: l_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
306:
307: l_ext_attr_value_pairs_ind NUMBER;
308: l_ext_name_val_obj EGO_COL_NAME_VALUE_PAIR_OBJ;
309:
310:
311: BEGIN
312:

Line 450: l_pk_column_name_value_pairs(l_pk_column_name_value_pairs.COUNT) := EGO_COL_NAME_VALUE_PAIR_OBJ

446: where o.obj_name = PO_UDA_DATA_UTIL.g_object_dff_tl(l_entity_code).l_object_name;
447:
448: IF p_pk1_value IS NOT NULL THEN
449: l_pk_column_name_value_pairs.EXTEND(1);
450: l_pk_column_name_value_pairs(l_pk_column_name_value_pairs.COUNT) := EGO_COL_NAME_VALUE_PAIR_OBJ
451: (
452: l_pk1_column_name, p_pk1_value
453: );
454: END IF;

Line 457: l_pk_column_name_value_pairs(l_pk_column_name_value_pairs.COUNT) := EGO_COL_NAME_VALUE_PAIR_OBJ

453: );
454: END IF;
455: IF p_pk2_value IS NOT NULL THEN
456: l_pk_column_name_value_pairs.EXTEND(1);
457: l_pk_column_name_value_pairs(l_pk_column_name_value_pairs.COUNT) := EGO_COL_NAME_VALUE_PAIR_OBJ
458: (
459: l_pk2_column_name, p_pk2_value
460: );
461: END IF;

Line 464: l_pk_column_name_value_pairs(l_pk_column_name_value_pairs.COUNT) := EGO_COL_NAME_VALUE_PAIR_OBJ

460: );
461: END IF;
462: IF p_pk3_value IS NOT NULL THEN
463: l_pk_column_name_value_pairs.EXTEND(1);
464: l_pk_column_name_value_pairs(l_pk_column_name_value_pairs.COUNT) := EGO_COL_NAME_VALUE_PAIR_OBJ
465: (
466: l_pk3_column_name, p_pk3_value
467: );
468: END IF;

Line 471: l_pk_column_name_value_pairs(l_pk_column_name_value_pairs.COUNT) := EGO_COL_NAME_VALUE_PAIR_OBJ

467: );
468: END IF;
469: IF p_pk4_value IS NOT NULL THEN
470: l_pk_column_name_value_pairs.EXTEND(1);
471: l_pk_column_name_value_pairs(l_pk_column_name_value_pairs.COUNT) := EGO_COL_NAME_VALUE_PAIR_OBJ
472: (
473: l_pk4_column_name, p_pk4_value
474: );
475: END IF;

Line 478: l_pk_column_name_value_pairs(l_pk_column_name_value_pairs.COUNT) := EGO_COL_NAME_VALUE_PAIR_OBJ

474: );
475: END IF;
476: IF p_pk5_value IS NOT NULL THEN
477: l_pk_column_name_value_pairs.EXTEND(1);
478: l_pk_column_name_value_pairs(l_pk_column_name_value_pairs.COUNT) := EGO_COL_NAME_VALUE_PAIR_OBJ
479: (
480: l_pk5_column_name, p_pk5_value
481: );
482: END IF;

Line 492: EGO_COL_NAME_VALUE_PAIR_OBJ

488: l_attr_name_value_pairs := EGO_USER_ATTR_DATA_TABLE();
489:
490: l_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY
491: (
492: EGO_COL_NAME_VALUE_PAIR_OBJ
493: (
494: 'UDA_TEMPLATE_ID'
495: ,p_template_id || ''
496: )

Line 687: EGO_COL_NAME_VALUE_PAIR_OBJ(

683: FETCH get_source_ids INTO l_req_source_hdr_id, l_template_id ;
684: CLOSE get_source_ids;
685:
686: l_from_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
687: EGO_COL_NAME_VALUE_PAIR_OBJ(
688: 'REQUISITION_HEADER_ID', l_req_source_hdr_id ));
689:
690: l_to_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
691: EGO_COL_NAME_VALUE_PAIR_OBJ(

Line 691: EGO_COL_NAME_VALUE_PAIR_OBJ(

687: EGO_COL_NAME_VALUE_PAIR_OBJ(
688: 'REQUISITION_HEADER_ID', l_req_source_hdr_id ));
689:
690: l_to_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
691: EGO_COL_NAME_VALUE_PAIR_OBJ(
692: 'REQUISITION_HEADER_ID', p_confirmed_id ));
693:
694: l_attribute_group_table := PO_TBL_VARCHAR30();
695: FOR c_get_add_agids_tbl_rec IN c_get_add_agids_tbl(l_template_id) LOOP

Line 799: l_from_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ(

795:
796: SELECT uda_template_id INTO l_template_id
797: FROM po_requisition_lines_all WHERE REQUISITION_LINE_ID = l_line_ids(i);
798:
799: l_from_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ(
800: 'REQUISITION_LINE_ID', l_line_ids(i)));
801:
802: l_to_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ(
803: 'REQUISITION_LINE_ID', l_conformed_line_ids(i)));

Line 802: l_to_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ(

798:
799: l_from_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ(
800: 'REQUISITION_LINE_ID', l_line_ids(i)));
801:
802: l_to_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ(
803: 'REQUISITION_LINE_ID', l_conformed_line_ids(i)));
804: END IF;
805:
806: PO_UDA_DATA_UTIL.AutoCreate_User_Attrs

Line 871: EGO_COL_NAME_VALUE_PAIR_OBJ(

867: FETCH get_source_ids INTO l_template_id ;
868: CLOSE get_source_ids;
869:
870: l_from_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
871: EGO_COL_NAME_VALUE_PAIR_OBJ(
872: 'REQUISITION_HEADER_ID', p_from_req_header_id ));
873:
874: l_to_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
875: EGO_COL_NAME_VALUE_PAIR_OBJ(

Line 875: EGO_COL_NAME_VALUE_PAIR_OBJ(

871: EGO_COL_NAME_VALUE_PAIR_OBJ(
872: 'REQUISITION_HEADER_ID', p_from_req_header_id ));
873:
874: l_to_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
875: EGO_COL_NAME_VALUE_PAIR_OBJ(
876: 'REQUISITION_HEADER_ID', p_to_req_header_id ));
877:
878: PO_UDA_DATA_UTIL.Copy_User_Attrs
879: (

Line 958: l_from_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ(

954:
955: SELECT uda_template_id INTO l_template_id
956: FROM po_requisition_lines_all WHERE REQUISITION_LINE_ID = l_from_line_ids(i);
957:
958: l_from_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ(
959: 'REQUISITION_LINE_ID', l_from_line_ids(i)));
960:
961: l_to_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ(
962: 'REQUISITION_LINE_ID', l_to_line_ids(i)));

Line 961: l_to_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ(

957:
958: l_from_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ(
959: 'REQUISITION_LINE_ID', l_from_line_ids(i)));
960:
961: l_to_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ(
962: 'REQUISITION_LINE_ID', l_to_line_ids(i)));
963: END IF;
964:
965: PO_UDA_DATA_UTIL.Copy_User_Attrs

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

1108: OPEN c_get_usage_context(c_get_lines_rec.requisition_line_id);
1109: FETCH c_get_usage_context INTO l_contract_type;
1110: CLOSE c_get_usage_context;
1111:
1112: l_context := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'CONTRACT_LINE_TYPE', l_contract_type));
1113: END IF;
1114:
1115: l_po_uda_usage_object := po_uda_usage_object.new_instance(l_template_id,c_get_line_usages_rec.attribute_category,l_context );
1116: l_attr_grp_ids_list := l_po_uda_usage_object.Attr_group_Id;