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_PVT dependencies on EGO_COL_NAME_VALUE_PAIR_OBJ

Line 2250: EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_ITEM_ID', p_inventory_item_id)

2246:
2247: BEGIN
2248:
2249: l_pk_column_values := EGO_COL_NAME_VALUE_PAIR_ARRAY(
2250: EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_ITEM_ID', p_inventory_item_id)
2251: ,EGO_COL_NAME_VALUE_PAIR_OBJ('ORGANIZATION_ID', p_organization_id)
2252: );
2253:
2254: l_class_code_values := EGO_COL_NAME_VALUE_PAIR_ARRAY(

Line 2251: ,EGO_COL_NAME_VALUE_PAIR_OBJ('ORGANIZATION_ID', p_organization_id)

2247: BEGIN
2248:
2249: l_pk_column_values := EGO_COL_NAME_VALUE_PAIR_ARRAY(
2250: EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_ITEM_ID', p_inventory_item_id)
2251: ,EGO_COL_NAME_VALUE_PAIR_OBJ('ORGANIZATION_ID', p_organization_id)
2252: );
2253:
2254: l_class_code_values := EGO_COL_NAME_VALUE_PAIR_ARRAY(
2255: EGO_COL_NAME_VALUE_PAIR_OBJ('ITEM_CATALOG_GROUP_ID', NVL(p_item_catalog_group_id, -1))

Line 2255: EGO_COL_NAME_VALUE_PAIR_OBJ('ITEM_CATALOG_GROUP_ID', NVL(p_item_catalog_group_id, -1))

2251: ,EGO_COL_NAME_VALUE_PAIR_OBJ('ORGANIZATION_ID', p_organization_id)
2252: );
2253:
2254: l_class_code_values := EGO_COL_NAME_VALUE_PAIR_ARRAY(
2255: EGO_COL_NAME_VALUE_PAIR_OBJ('ITEM_CATALOG_GROUP_ID', NVL(p_item_catalog_group_id, -1))
2256: );
2257:
2258: SELECT DISPLAY_NAME
2259: INTO l_label

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

2459:
2460: -------------------------------------------------------------------
2461: -- We build a list of all parent catalog groups, as long as the --
2462: -- list is less than 151 characters long (the longest we can fit --
2463: -- into the EGO_COL_NAME_VALUE_PAIR_OBJ is 150 chars); if the --
2464: -- list is too long to fully copy, we can only hope that the --
2465: -- portion we copied will contain all the information we need. --
2466: -------------------------------------------------------------------
2467: FOR cat_rec IN parent_catalog_group_cursor

Line 2764: EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_ITEM_ID', TO_CHAR(p_inventory_item_id))

2760: -- Get PKs organized --
2761: -----------------------
2762: l_pk_column_values :=
2763: EGO_COL_NAME_VALUE_PAIR_ARRAY(
2764: EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_ITEM_ID', TO_CHAR(p_inventory_item_id))
2765: ,EGO_COL_NAME_VALUE_PAIR_OBJ('ORGANIZATION_ID', TO_CHAR(p_organization_id))
2766: );
2767:
2768: -----------------------------------------------------------------

Line 2765: ,EGO_COL_NAME_VALUE_PAIR_OBJ('ORGANIZATION_ID', TO_CHAR(p_organization_id))

2761: -----------------------
2762: l_pk_column_values :=
2763: EGO_COL_NAME_VALUE_PAIR_ARRAY(
2764: EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_ITEM_ID', TO_CHAR(p_inventory_item_id))
2765: ,EGO_COL_NAME_VALUE_PAIR_OBJ('ORGANIZATION_ID', TO_CHAR(p_organization_id))
2766: );
2767:
2768: -----------------------------------------------------------------
2769: -- Get the Item Catalog Group ID as well as a comma-delimited --

Line 2827: EGO_COL_NAME_VALUE_PAIR_OBJ('ITEM_CATALOG_GROUP_ID', TO_CHAR(l_item_catalog_group_id))

2823: );
2824:
2825: l_class_code_values :=
2826: EGO_COL_NAME_VALUE_PAIR_ARRAY(
2827: EGO_COL_NAME_VALUE_PAIR_OBJ('ITEM_CATALOG_GROUP_ID', TO_CHAR(l_item_catalog_group_id))
2828: ,EGO_COL_NAME_VALUE_PAIR_OBJ('RELATED_CLASS_CODE_LIST_1', l_related_class_codes_list)
2829: );
2830:
2831: ---------------------------------------------------------------

Line 2828: ,EGO_COL_NAME_VALUE_PAIR_OBJ('RELATED_CLASS_CODE_LIST_1', l_related_class_codes_list)

2824:
2825: l_class_code_values :=
2826: EGO_COL_NAME_VALUE_PAIR_ARRAY(
2827: EGO_COL_NAME_VALUE_PAIR_OBJ('ITEM_CATALOG_GROUP_ID', TO_CHAR(l_item_catalog_group_id))
2828: ,EGO_COL_NAME_VALUE_PAIR_OBJ('RELATED_CLASS_CODE_LIST_1', l_related_class_codes_list)
2829: );
2830:
2831: ---------------------------------------------------------------
2832: -- Next, we build our privileges table for the current user; --

Line 3019: EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_ITEM_ID', TO_CHAR(p_inventory_item_id))

3015: -- Get PKs organized --
3016: -----------------------
3017: l_pk_column_values :=
3018: EGO_COL_NAME_VALUE_PAIR_ARRAY(
3019: EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_ITEM_ID', TO_CHAR(p_inventory_item_id))
3020: ,EGO_COL_NAME_VALUE_PAIR_OBJ('ORGANIZATION_ID', TO_CHAR(p_organization_id))
3021: );
3022:
3023: ---------------------------------------------------------------

Line 3020: ,EGO_COL_NAME_VALUE_PAIR_OBJ('ORGANIZATION_ID', TO_CHAR(p_organization_id))

3016: -----------------------
3017: l_pk_column_values :=
3018: EGO_COL_NAME_VALUE_PAIR_ARRAY(
3019: EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_ITEM_ID', TO_CHAR(p_inventory_item_id))
3020: ,EGO_COL_NAME_VALUE_PAIR_OBJ('ORGANIZATION_ID', TO_CHAR(p_organization_id))
3021: );
3022:
3023: ---------------------------------------------------------------
3024: -- Next, we build our privileges table for the current user; --

Line 5352: EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_ITEM_ID', TO_CHAR(p_inventory_item_id))

5348: -- Get PKs organized --
5349: -----------------------
5350: l_pk_column_values :=
5351: EGO_COL_NAME_VALUE_PAIR_ARRAY(
5352: EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_ITEM_ID', TO_CHAR(p_inventory_item_id))
5353: ,EGO_COL_NAME_VALUE_PAIR_OBJ('ORGANIZATION_ID', TO_CHAR(p_organization_id))
5354: );
5355:
5356: ----------------------

Line 5353: ,EGO_COL_NAME_VALUE_PAIR_OBJ('ORGANIZATION_ID', TO_CHAR(p_organization_id))

5349: -----------------------
5350: l_pk_column_values :=
5351: EGO_COL_NAME_VALUE_PAIR_ARRAY(
5352: EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_ITEM_ID', TO_CHAR(p_inventory_item_id))
5353: ,EGO_COL_NAME_VALUE_PAIR_OBJ('ORGANIZATION_ID', TO_CHAR(p_organization_id))
5354: );
5355:
5356: ----------------------
5357: -- Get Class Codes --

Line 5370: EGO_COL_NAME_VALUE_PAIR_OBJ('ITEM_CATALOG_GROUP_ID', TO_CHAR(l_item_catalog_group_id))

5366: );
5367:
5368: l_class_code_values :=
5369: EGO_COL_NAME_VALUE_PAIR_ARRAY(
5370: EGO_COL_NAME_VALUE_PAIR_OBJ('ITEM_CATALOG_GROUP_ID', TO_CHAR(l_item_catalog_group_id))
5371: ,EGO_COL_NAME_VALUE_PAIR_OBJ('RELATED_CLASS_CODE_LIST_1', l_related_class_codes_list)
5372: );
5373:
5374: ----------------------

Line 5371: ,EGO_COL_NAME_VALUE_PAIR_OBJ('RELATED_CLASS_CODE_LIST_1', l_related_class_codes_list)

5367:
5368: l_class_code_values :=
5369: EGO_COL_NAME_VALUE_PAIR_ARRAY(
5370: EGO_COL_NAME_VALUE_PAIR_OBJ('ITEM_CATALOG_GROUP_ID', TO_CHAR(l_item_catalog_group_id))
5371: ,EGO_COL_NAME_VALUE_PAIR_OBJ('RELATED_CLASS_CODE_LIST_1', l_related_class_codes_list)
5372: );
5373:
5374: ----------------------
5375: -- Get Data Levels --

Line 5379: EGO_COL_NAME_VALUE_PAIR_OBJ('ITEM_LEVEL', null)

5375: -- Get Data Levels --
5376: ----------------------
5377: l_data_level_values :=
5378: EGO_COL_NAME_VALUE_PAIR_ARRAY(
5379: EGO_COL_NAME_VALUE_PAIR_OBJ('ITEM_LEVEL', null)
5380: ,EGO_COL_NAME_VALUE_PAIR_OBJ('ITEM_REVISION_LEVEL', TO_CHAR(p_revision_id))
5381: );
5382:
5383: ---------------------------------

Line 5380: ,EGO_COL_NAME_VALUE_PAIR_OBJ('ITEM_REVISION_LEVEL', TO_CHAR(p_revision_id))

5376: ----------------------
5377: l_data_level_values :=
5378: EGO_COL_NAME_VALUE_PAIR_ARRAY(
5379: EGO_COL_NAME_VALUE_PAIR_OBJ('ITEM_LEVEL', null)
5380: ,EGO_COL_NAME_VALUE_PAIR_OBJ('ITEM_REVISION_LEVEL', TO_CHAR(p_revision_id))
5381: );
5382:
5383: ---------------------------------
5384: -- Setup attribute group type --

Line 6188: ( EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_ITEM_ID', TO_CHAR(attr_default_rec.INVENTORY_ITEM_ID))

6184: l_catalog_group_id := attr_default_rec.ITEM_CATALOG_GROUP_ID;
6185: l_attribute_group_type := attr_default_rec.ATTRIBUTE_GROUP_TYPE;
6186: l_commit := p_commit;
6187: l_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY
6188: ( EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_ITEM_ID', TO_CHAR(attr_default_rec.INVENTORY_ITEM_ID))
6189: , EGO_COL_NAME_VALUE_PAIR_OBJ('ORGANIZATION_ID', TO_CHAR(attr_default_rec.ORGANIZATION_ID)));
6190:
6191: l_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY
6192: (EGO_COL_NAME_VALUE_PAIR_OBJ('ITEM_CATALOG_GROUP_ID', to_char(attr_default_rec.ITEM_CATALOG_GROUP_ID)));

Line 6189: , EGO_COL_NAME_VALUE_PAIR_OBJ('ORGANIZATION_ID', TO_CHAR(attr_default_rec.ORGANIZATION_ID)));

6185: l_attribute_group_type := attr_default_rec.ATTRIBUTE_GROUP_TYPE;
6186: l_commit := p_commit;
6187: l_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY
6188: ( EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_ITEM_ID', TO_CHAR(attr_default_rec.INVENTORY_ITEM_ID))
6189: , EGO_COL_NAME_VALUE_PAIR_OBJ('ORGANIZATION_ID', TO_CHAR(attr_default_rec.ORGANIZATION_ID)));
6190:
6191: l_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY
6192: (EGO_COL_NAME_VALUE_PAIR_OBJ('ITEM_CATALOG_GROUP_ID', to_char(attr_default_rec.ITEM_CATALOG_GROUP_ID)));
6193:

Line 6192: (EGO_COL_NAME_VALUE_PAIR_OBJ('ITEM_CATALOG_GROUP_ID', to_char(attr_default_rec.ITEM_CATALOG_GROUP_ID)));

6188: ( EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_ITEM_ID', TO_CHAR(attr_default_rec.INVENTORY_ITEM_ID))
6189: , EGO_COL_NAME_VALUE_PAIR_OBJ('ORGANIZATION_ID', TO_CHAR(attr_default_rec.ORGANIZATION_ID)));
6190:
6191: l_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY
6192: (EGO_COL_NAME_VALUE_PAIR_OBJ('ITEM_CATALOG_GROUP_ID', to_char(attr_default_rec.ITEM_CATALOG_GROUP_ID)));
6193:
6194: l_data_level_values := EGO_COL_NAME_VALUE_PAIR_ARRAY
6195: (EGO_COL_NAME_VALUE_PAIR_OBJ('REVISION_ID', to_char(attr_default_rec.REVISION_ID)));
6196:

Line 6195: (EGO_COL_NAME_VALUE_PAIR_OBJ('REVISION_ID', to_char(attr_default_rec.REVISION_ID)));

6191: l_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY
6192: (EGO_COL_NAME_VALUE_PAIR_OBJ('ITEM_CATALOG_GROUP_ID', to_char(attr_default_rec.ITEM_CATALOG_GROUP_ID)));
6193:
6194: l_data_level_values := EGO_COL_NAME_VALUE_PAIR_ARRAY
6195: (EGO_COL_NAME_VALUE_PAIR_OBJ('REVISION_ID', to_char(attr_default_rec.REVISION_ID)));
6196:
6197: Get_Related_Class_Codes ( p_classification_code => l_catalog_group_id,
6198: x_related_class_codes_list => l_additional_class_Code_list);
6199: IF l_additional_class_Code_list IS NULL THEN