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.EGO_ITEM_USER_ATTRS_CP_PUB dependencies on EGO_COL_NAME_VALUE_PAIR_ARRAY

Line 434: p_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

430: l_can_edit_this_instance VARCHAR2(1);
431: l_token_table ERROR_HANDLER.Token_Tbl_Type;
432: l_could_edit_prev_instance VARCHAR2(1);
433: l_at_start_of_row BOOLEAN;
434: p_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
435: p_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
436: p_attributes_row_table EGO_USER_ATTR_ROW_TABLE;
437: p_attributes_data_table EGO_USER_ATTR_DATA_TABLE;
438: l_user_privileges_table EGO_DATA_SECURITY.EGO_PRIVILEGE_NAME_TABLE_TYPE;

Line 435: p_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

431: l_token_table ERROR_HANDLER.Token_Tbl_Type;
432: l_could_edit_prev_instance VARCHAR2(1);
433: l_at_start_of_row BOOLEAN;
434: p_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
435: p_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
436: p_attributes_row_table EGO_USER_ATTR_ROW_TABLE;
437: p_attributes_data_table EGO_USER_ATTR_DATA_TABLE;
438: l_user_privileges_table EGO_DATA_SECURITY.EGO_PRIVILEGE_NAME_TABLE_TYPE;
439: l_privilege_table_index NUMBER;

Line 496: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

492: l_com_attr_group_name VARCHAR2(30) := NULL;
493: l_com_attr_group_id NUMBER;
494: l_com_attr_int_name VARCHAR2(30);
495: l_attributes_data_table EGO_USER_ATTR_DATA_TABLE;
496: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
497: --l_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
498: l_telco_return_status VARCHAR2(1);
499: l_error_messages EGO_COL_NAME_VALUE_PAIR_ARRAY := EGO_COL_NAME_VALUE_PAIR_ARRAY();
500: l_error_col_name_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY :=EGO_COL_NAME_VALUE_PAIR_ARRAY();

Line 497: --l_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

493: l_com_attr_group_id NUMBER;
494: l_com_attr_int_name VARCHAR2(30);
495: l_attributes_data_table EGO_USER_ATTR_DATA_TABLE;
496: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
497: --l_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
498: l_telco_return_status VARCHAR2(1);
499: l_error_messages EGO_COL_NAME_VALUE_PAIR_ARRAY := EGO_COL_NAME_VALUE_PAIR_ARRAY();
500: l_error_col_name_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY :=EGO_COL_NAME_VALUE_PAIR_ARRAY();
501:

Line 499: l_error_messages EGO_COL_NAME_VALUE_PAIR_ARRAY := EGO_COL_NAME_VALUE_PAIR_ARRAY();

495: l_attributes_data_table EGO_USER_ATTR_DATA_TABLE;
496: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
497: --l_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
498: l_telco_return_status VARCHAR2(1);
499: l_error_messages EGO_COL_NAME_VALUE_PAIR_ARRAY := EGO_COL_NAME_VALUE_PAIR_ARRAY();
500: l_error_col_name_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY :=EGO_COL_NAME_VALUE_PAIR_ARRAY();
501:
502: l_old_com_attr_group_type VARCHAR2(30);
503: l_old_com_attr_group_name VARCHAR2(30);

Line 500: l_error_col_name_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY :=EGO_COL_NAME_VALUE_PAIR_ARRAY();

496: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
497: --l_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
498: l_telco_return_status VARCHAR2(1);
499: l_error_messages EGO_COL_NAME_VALUE_PAIR_ARRAY := EGO_COL_NAME_VALUE_PAIR_ARRAY();
500: l_error_col_name_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY :=EGO_COL_NAME_VALUE_PAIR_ARRAY();
501:
502: l_old_com_attr_group_type VARCHAR2(30);
503: l_old_com_attr_group_name VARCHAR2(30);
504: l_old_com_attr_group_id NUMBER;

Line 671: l_default_dl_view_priv_list EGO_COL_NAME_VALUE_PAIR_ARRAY;

667: FROM EGO_DATA_LEVEL_B
668: WHERE APPLICATION_ID = 431
669: AND ATTR_GROUP_TYPE = 'EGO_ITEMMGMT_GROUP';
670:
671: l_default_dl_view_priv_list EGO_COL_NAME_VALUE_PAIR_ARRAY;
672: l_default_dl_edit_priv_list EGO_COL_NAME_VALUE_PAIR_ARRAY;
673: l_default_dl_view_priv_obj EGO_COL_NAME_VALUE_PAIR_OBJ;
674: l_default_dl_edit_priv_obj EGO_COL_NAME_VALUE_PAIR_OBJ;
675:

Line 672: l_default_dl_edit_priv_list EGO_COL_NAME_VALUE_PAIR_ARRAY;

668: WHERE APPLICATION_ID = 431
669: AND ATTR_GROUP_TYPE = 'EGO_ITEMMGMT_GROUP';
670:
671: l_default_dl_view_priv_list EGO_COL_NAME_VALUE_PAIR_ARRAY;
672: l_default_dl_edit_priv_list EGO_COL_NAME_VALUE_PAIR_ARRAY;
673: l_default_dl_view_priv_obj EGO_COL_NAME_VALUE_PAIR_OBJ;
674: l_default_dl_edit_priv_obj EGO_COL_NAME_VALUE_PAIR_OBJ;
675:
676: -------------------------------------------------------------------------

Line 2455: l_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(

2451: END IF;
2452: l_attributes_data_table.EXTEND();
2453: l_attributes_data_table(l_attributes_data_table.LAST) := l_curr_data_element;
2454: END LOOP; -- loop for interface records for COM item uda for row_identifer ends
2455: l_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
2456: EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_ITEM_ID', l_inventory_item_id)
2457: ,EGO_COL_NAME_VALUE_PAIR_OBJ('ORGANIZATION_ID', l_organization_id)
2458: ,EGO_COL_NAME_VALUE_PAIR_OBJ('REVISION_ID', l_revision_id));
2459: -- call package.procedure

Line 2975: l_default_dl_view_priv_list := EGO_COL_NAME_VALUE_PAIR_ARRAY();

2971: l_privilege_predicate_api_name := NULL;
2972: END IF;
2973:
2974: -- creating default privileges
2975: l_default_dl_view_priv_list := EGO_COL_NAME_VALUE_PAIR_ARRAY();
2976: l_default_dl_edit_priv_list := EGO_COL_NAME_VALUE_PAIR_ARRAY();
2977: FOR i IN c_data_levels_for_sec LOOP
2978: IF i.ATTR_GROUP_TYPE = 'EGO_ITEMMGMT_GROUP' AND i.DATA_LEVEL_NAME IN ('ITEM_SUP', 'ITEM_SUP_SITE', 'ITEM_SUP_SITE_ORG') THEN
2979: l_default_dl_view_priv_obj := EGO_COL_NAME_VALUE_PAIR_OBJ(i.DATA_LEVEL_ID, 'EGO_VIEW_ITEM_SUP_ASSIGN');

Line 2976: l_default_dl_edit_priv_list := EGO_COL_NAME_VALUE_PAIR_ARRAY();

2972: END IF;
2973:
2974: -- creating default privileges
2975: l_default_dl_view_priv_list := EGO_COL_NAME_VALUE_PAIR_ARRAY();
2976: l_default_dl_edit_priv_list := EGO_COL_NAME_VALUE_PAIR_ARRAY();
2977: FOR i IN c_data_levels_for_sec LOOP
2978: IF i.ATTR_GROUP_TYPE = 'EGO_ITEMMGMT_GROUP' AND i.DATA_LEVEL_NAME IN ('ITEM_SUP', 'ITEM_SUP_SITE', 'ITEM_SUP_SITE_ORG') THEN
2979: l_default_dl_view_priv_obj := EGO_COL_NAME_VALUE_PAIR_OBJ(i.DATA_LEVEL_ID, 'EGO_VIEW_ITEM_SUP_ASSIGN');
2980: l_default_dl_edit_priv_obj := EGO_COL_NAME_VALUE_PAIR_OBJ(i.DATA_LEVEL_ID, 'EGO_EDIT_ITEM_SUP_ASSIGN');

Line 3845: l_old_data_level_nv_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

3841: ,x_msg_count OUT NOCOPY NUMBER
3842: ,x_msg_data OUT NOCOPY VARCHAR2
3843: ) IS
3844:
3845: l_old_data_level_nv_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3846: l_new_data_level_nv_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3847: l_api_name VARCHAR2(30);
3848:
3849: BEGIN

Line 3846: l_new_data_level_nv_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

3842: ,x_msg_data OUT NOCOPY VARCHAR2
3843: ) IS
3844:
3845: l_old_data_level_nv_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3846: l_new_data_level_nv_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3847: l_api_name VARCHAR2(30);
3848:
3849: BEGIN
3850: l_api_name := 'Impl_Item_Attr_Change_Line';

Line 3867: l_old_data_level_nv_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(

3863: ---------------------------------------------------------------------
3864: -- Build data structures to pass in Data Level info, if applicable --
3865: ---------------------------------------------------------------------
3866: IF (p_old_revision_id IS NOT NULL) THEN
3867: l_old_data_level_nv_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
3868: EGO_COL_NAME_VALUE_PAIR_OBJ('REVISION_ID',
3869: p_old_revision_id)
3870: );
3871: END IF;

Line 3873: l_new_data_level_nv_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(

3869: p_old_revision_id)
3870: );
3871: END IF;
3872: IF (p_new_revision_id IS NOT NULL) THEN
3873: l_new_data_level_nv_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
3874: EGO_COL_NAME_VALUE_PAIR_OBJ('REVISION_ID',
3875: p_new_revision_id)
3876: );
3877: END IF;