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

Line 2056: ( EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_ITEM_ID', to_char(i.inventory_item_id))

2052:
2053: IF P_Suppress_Rollup <> 'Y' THEN
2054:
2055: l_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY
2056: ( EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_ITEM_ID', to_char(i.inventory_item_id))
2057: , EGO_COL_NAME_VALUE_PAIR_OBJ('ORGANIZATION_ID', to_char(i.organization_id))
2058: );
2059:
2060: -- issue query against MSIB for item_cat_group_id, value for item_id, org_id

Line 2057: , EGO_COL_NAME_VALUE_PAIR_OBJ('ORGANIZATION_ID', to_char(i.organization_id))

2053: IF P_Suppress_Rollup <> 'Y' THEN
2054:
2055: l_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY
2056: ( EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_ITEM_ID', to_char(i.inventory_item_id))
2057: , EGO_COL_NAME_VALUE_PAIR_OBJ('ORGANIZATION_ID', to_char(i.organization_id))
2058: );
2059:
2060: -- issue query against MSIB for item_cat_group_id, value for item_id, org_id
2061: SELECT item_catalog_group_id

Line 2068: (EGO_COL_NAME_VALUE_PAIR_OBJ('ITEM_CATALOG_GROUP_ID', to_char(l_item_catalog_group_id)));

2064: WHERE inventory_item_id = i.inventory_item_id
2065: AND organization_id = i.organization_id;
2066:
2067: l_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY
2068: (EGO_COL_NAME_VALUE_PAIR_OBJ('ITEM_CATALOG_GROUP_ID', to_char(l_item_catalog_group_id)));
2069:
2070: l_data_level_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY
2071: (EGO_COL_NAME_VALUE_PAIR_OBJ('DATA_LEVEL', 'EGO_ITEM'));
2072:

Line 2071: (EGO_COL_NAME_VALUE_PAIR_OBJ('DATA_LEVEL', 'EGO_ITEM'));

2067: l_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY
2068: (EGO_COL_NAME_VALUE_PAIR_OBJ('ITEM_CATALOG_GROUP_ID', to_char(l_item_catalog_group_id)));
2069:
2070: l_data_level_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY
2071: (EGO_COL_NAME_VALUE_PAIR_OBJ('DATA_LEVEL', 'EGO_ITEM'));
2072:
2073: -- achampan: add call to item_propagate_attributes
2074: EGO_GTIN_PVT.Item_Propagate_Attributes
2075: ( p_pk_column_name_value_pairs => l_pk_column_name_value_pairs

Line 2546: ( EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_ITEM_ID', p_inventory_item_id)

2542: l_attr_old_value_date = p_attr_new_value_date)))
2543: THEN
2544:
2545: l_pk_columns := EGO_COL_NAME_VALUE_PAIR_ARRAY
2546: ( EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_ITEM_ID', p_inventory_item_id)
2547: , EGO_COL_NAME_VALUE_PAIR_OBJ('ORGANIZATION_ID', p_organization_id)
2548: );
2549:
2550: FOR c1 IN get_classification_code

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

2543: THEN
2544:
2545: l_pk_columns := EGO_COL_NAME_VALUE_PAIR_ARRAY
2546: ( EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_ITEM_ID', p_inventory_item_id)
2547: , EGO_COL_NAME_VALUE_PAIR_OBJ('ORGANIZATION_ID', p_organization_id)
2548: );
2549:
2550: FOR c1 IN get_classification_code
2551: LOOP

Line 2556: (EGO_COL_NAME_VALUE_PAIR_OBJ( 'ITEM_CATALOG_GROUP_ID', to_char(l_item_catalog_group_id)));

2552: l_item_catalog_group_id := c1.item_catalog_group_id;
2553: END LOOP;
2554:
2555: l_class_code := EGO_COL_NAME_VALUE_PAIR_ARRAY
2556: (EGO_COL_NAME_VALUE_PAIR_OBJ( 'ITEM_CATALOG_GROUP_ID', to_char(l_item_catalog_group_id)));
2557:
2558: l_attr_new_values :=
2559: EGO_USER_ATTR_DATA_TABLE
2560: ( EGO_USER_ATTR_DATA_OBJ

Line 2801: ( EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_ITEM_ID', to_char(p_inventory_item_id))

2797: BEGIN
2798:
2799: px_pk_column_name_value_pairs :=
2800: EGO_COL_NAME_VALUE_PAIR_ARRAY
2801: ( EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_ITEM_ID', to_char(p_inventory_item_id))
2802: , EGO_COL_NAME_VALUE_PAIR_OBJ('ORGANIZATION_ID', to_char(p_org_id))
2803: );
2804:
2805: -- issue query against MSIB for item_cat_group_id, value for item_id, org_id

Line 2802: , EGO_COL_NAME_VALUE_PAIR_OBJ('ORGANIZATION_ID', to_char(p_org_id))

2798:
2799: px_pk_column_name_value_pairs :=
2800: EGO_COL_NAME_VALUE_PAIR_ARRAY
2801: ( EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_ITEM_ID', to_char(p_inventory_item_id))
2802: , EGO_COL_NAME_VALUE_PAIR_OBJ('ORGANIZATION_ID', to_char(p_org_id))
2803: );
2804:
2805: -- issue query against MSIB for item_cat_group_id, value for item_id, org_id
2806: SELECT item_catalog_group_id INTO l_item_catalog_group_id

Line 2813: (EGO_COL_NAME_VALUE_PAIR_OBJ('ITEM_CATALOG_GROUP_ID', to_char(l_item_catalog_group_id)));

2809: AND organization_id = p_org_id;
2810:
2811: px_class_code_name_value_pairs :=
2812: EGO_COL_NAME_VALUE_PAIR_ARRAY
2813: (EGO_COL_NAME_VALUE_PAIR_OBJ('ITEM_CATALOG_GROUP_ID', to_char(l_item_catalog_group_id)));
2814:
2815: EGO_USER_ATTRS_DATA_PVT.Get_Attr_Diffs
2816: ( p_object_name => 'EGO_ITEM'
2817: , p_pk_column_name_value_pairs => px_pk_column_name_value_pairs