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_OBJ

Line 276: -- into the EGO_COL_NAME_VALUE_PAIR_OBJ is 150 chars); if the --

272:
273: -------------------------------------------------------------------
274: -- We build a list of all parent catalog groups, as long as the --
275: -- list is less than 151 characters long (the longest we can fit --
276: -- into the EGO_COL_NAME_VALUE_PAIR_OBJ is 150 chars); if the --
277: -- list is too long to fully copy, we can only hope that the --
278: -- portion we copied will contain all the information we need. --
279: -------------------------------------------------------------------
280: FOR cat_rec IN parent_catalog_group_cursor

Line 511: l_curr_pk_col_name_val_element EGO_COL_NAME_VALUE_PAIR_OBJ;

507: l_old_organization_id NUMBER;
508: l_old_catalog_category_id NUMBER;
509:
510: l_curr_data_element EGO_USER_ATTR_DATA_OBJ;
511: l_curr_pk_col_name_val_element EGO_COL_NAME_VALUE_PAIR_OBJ;
512: l_curr_class_cd_val_element EGO_COL_NAME_VALUE_PAIR_OBJ;
513: l_error_element EGO_COL_NAME_VALUE_PAIR_OBJ;
514:
515: l_inventory_item_id NUMBER;

Line 512: l_curr_class_cd_val_element EGO_COL_NAME_VALUE_PAIR_OBJ;

508: l_old_catalog_category_id NUMBER;
509:
510: l_curr_data_element EGO_USER_ATTR_DATA_OBJ;
511: l_curr_pk_col_name_val_element EGO_COL_NAME_VALUE_PAIR_OBJ;
512: l_curr_class_cd_val_element EGO_COL_NAME_VALUE_PAIR_OBJ;
513: l_error_element EGO_COL_NAME_VALUE_PAIR_OBJ;
514:
515: l_inventory_item_id NUMBER;
516: l_revision_id NUMBER;

Line 513: l_error_element EGO_COL_NAME_VALUE_PAIR_OBJ;

509:
510: l_curr_data_element EGO_USER_ATTR_DATA_OBJ;
511: l_curr_pk_col_name_val_element EGO_COL_NAME_VALUE_PAIR_OBJ;
512: l_curr_class_cd_val_element EGO_COL_NAME_VALUE_PAIR_OBJ;
513: l_error_element EGO_COL_NAME_VALUE_PAIR_OBJ;
514:
515: l_inventory_item_id NUMBER;
516: l_revision_id NUMBER;
517: l_organization_id NUMBER;

Line 673: l_default_dl_view_priv_obj EGO_COL_NAME_VALUE_PAIR_OBJ;

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: -------------------------------------------------------------------------
677: -- PIM for Telco item uda validations --

Line 674: l_default_dl_edit_priv_obj EGO_COL_NAME_VALUE_PAIR_OBJ;

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: -------------------------------------------------------------------------
677: -- PIM for Telco item uda validations --
678: -------------------------------------------------------------------------

Line 2456: EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_ITEM_ID', l_inventory_item_id)

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
2460: IF (EGO_COM_ATTR_VALIDATION.Is_Attribute_Group_Telco(l_com_attr_group_name,l_com_attr_group_type)) THEN

Line 2457: ,EGO_COL_NAME_VALUE_PAIR_OBJ('ORGANIZATION_ID', l_organization_id)

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
2460: IF (EGO_COM_ATTR_VALIDATION.Is_Attribute_Group_Telco(l_com_attr_group_name,l_com_attr_group_type)) THEN
2461: EGO_COM_ATTR_VALIDATION.Validate_Attributes (

Line 2458: ,EGO_COL_NAME_VALUE_PAIR_OBJ('REVISION_ID', l_revision_id));

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
2460: IF (EGO_COM_ATTR_VALIDATION.Is_Attribute_Group_Telco(l_com_attr_group_name,l_com_attr_group_type)) THEN
2461: EGO_COM_ATTR_VALIDATION.Validate_Attributes (
2462: p_attr_group_type => l_com_attr_group_type

Line 2979: l_default_dl_view_priv_obj := EGO_COL_NAME_VALUE_PAIR_OBJ(i.DATA_LEVEL_ID, 'EGO_VIEW_ITEM_SUP_ASSIGN');

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');
2981: ELSE
2982: l_default_dl_view_priv_obj := EGO_COL_NAME_VALUE_PAIR_OBJ(i.DATA_LEVEL_ID, 'EGO_VIEW_ITEM');
2983: l_default_dl_edit_priv_obj := EGO_COL_NAME_VALUE_PAIR_OBJ(i.DATA_LEVEL_ID, 'EGO_EDIT_ITEM');

Line 2980: l_default_dl_edit_priv_obj := EGO_COL_NAME_VALUE_PAIR_OBJ(i.DATA_LEVEL_ID, 'EGO_EDIT_ITEM_SUP_ASSIGN');

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');
2981: ELSE
2982: l_default_dl_view_priv_obj := EGO_COL_NAME_VALUE_PAIR_OBJ(i.DATA_LEVEL_ID, 'EGO_VIEW_ITEM');
2983: l_default_dl_edit_priv_obj := EGO_COL_NAME_VALUE_PAIR_OBJ(i.DATA_LEVEL_ID, 'EGO_EDIT_ITEM');
2984: END IF;

Line 2982: l_default_dl_view_priv_obj := EGO_COL_NAME_VALUE_PAIR_OBJ(i.DATA_LEVEL_ID, 'EGO_VIEW_ITEM');

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');
2981: ELSE
2982: l_default_dl_view_priv_obj := EGO_COL_NAME_VALUE_PAIR_OBJ(i.DATA_LEVEL_ID, 'EGO_VIEW_ITEM');
2983: l_default_dl_edit_priv_obj := EGO_COL_NAME_VALUE_PAIR_OBJ(i.DATA_LEVEL_ID, 'EGO_EDIT_ITEM');
2984: END IF;
2985: l_default_dl_view_priv_list.EXTEND;
2986: l_default_dl_view_priv_list(l_default_dl_view_priv_list.COUNT) := l_default_dl_view_priv_obj;

Line 2983: l_default_dl_edit_priv_obj := EGO_COL_NAME_VALUE_PAIR_OBJ(i.DATA_LEVEL_ID, 'EGO_EDIT_ITEM');

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');
2981: ELSE
2982: l_default_dl_view_priv_obj := EGO_COL_NAME_VALUE_PAIR_OBJ(i.DATA_LEVEL_ID, 'EGO_VIEW_ITEM');
2983: l_default_dl_edit_priv_obj := EGO_COL_NAME_VALUE_PAIR_OBJ(i.DATA_LEVEL_ID, 'EGO_EDIT_ITEM');
2984: END IF;
2985: l_default_dl_view_priv_list.EXTEND;
2986: l_default_dl_view_priv_list(l_default_dl_view_priv_list.COUNT) := l_default_dl_view_priv_obj;
2987:

Line 3868: EGO_COL_NAME_VALUE_PAIR_OBJ('REVISION_ID',

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;
3872: IF (p_new_revision_id IS NOT NULL) THEN

Line 3874: EGO_COL_NAME_VALUE_PAIR_OBJ('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;
3878: