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_ARRAY

Line 1808: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

1804: dumm_status NUMBER;
1805: l_error BOOLEAN := FALSE;
1806: l_gross_weight NUMBER := NULL;
1807: l_msib_upd_reqd BOOLEAN := FALSE;
1808: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1809: l_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1810: l_data_level_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1811: l_attr_diffs EGO_USER_ATTR_DIFF_TABLE;
1812: l_error_message VARCHAR2(2000);

Line 1809: l_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

1805: l_error BOOLEAN := FALSE;
1806: l_gross_weight NUMBER := NULL;
1807: l_msib_upd_reqd BOOLEAN := FALSE;
1808: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1809: l_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1810: l_data_level_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1811: l_attr_diffs EGO_USER_ATTR_DIFF_TABLE;
1812: l_error_message VARCHAR2(2000);
1813: l_item_catalog_group_id NUMBER;

Line 1810: l_data_level_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

1806: l_gross_weight NUMBER := NULL;
1807: l_msib_upd_reqd BOOLEAN := FALSE;
1808: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1809: l_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1810: l_data_level_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1811: l_attr_diffs EGO_USER_ATTR_DIFF_TABLE;
1812: l_error_message VARCHAR2(2000);
1813: l_item_catalog_group_id NUMBER;
1814: BEGIN

Line 2055: l_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY

2051: END IF;
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:

Line 2067: l_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY

2063: FROM mtl_system_items_b
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'));

Line 2070: l_data_level_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY

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:
2073: -- achampan: add call to item_propagate_attributes
2074: EGO_GTIN_PVT.Item_Propagate_Attributes

Line 2172: ( p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY

2168: -- sridhar modified
2169: --------------------------------
2170:
2171: PROCEDURE Item_Propagate_Attributes
2172: ( p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
2173: , p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
2174: , p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
2175: , p_attr_diffs IN EGO_USER_ATTR_DIFF_TABLE
2176: , p_transaction_type IN VARCHAR2

Line 2173: , p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY

2169: --------------------------------
2170:
2171: PROCEDURE Item_Propagate_Attributes
2172: ( p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
2173: , p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
2174: , p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
2175: , p_attr_diffs IN EGO_USER_ATTR_DIFF_TABLE
2176: , p_transaction_type IN VARCHAR2
2177: , p_attr_group_id IN NUMBER DEFAULT NULL

Line 2174: , p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY

2170:
2171: PROCEDURE Item_Propagate_Attributes
2172: ( p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
2173: , p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
2174: , p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
2175: , p_attr_diffs IN EGO_USER_ATTR_DIFF_TABLE
2176: , p_transaction_type IN VARCHAR2
2177: , p_attr_group_id IN NUMBER DEFAULT NULL
2178: , x_error_message OUT NOCOPY VARCHAR2

Line 2462: l_pk_columns EGO_COL_NAME_VALUE_PAIR_ARRAY;

2458: l_attr_old_value_date DATE := NULL;
2459: l_attr_old_value_uom VARCHAR2(3) := NULL;
2460: l_old_query VARCHAR2(4000);
2461:
2462: l_pk_columns EGO_COL_NAME_VALUE_PAIR_ARRAY;
2463: l_class_code EGO_COL_NAME_VALUE_PAIR_ARRAY;
2464: l_item_catalog_group_id NUMBER;
2465: l_error_code NUMBER;
2466: l_attribute_names EGO_VARCHAR_TBL_TYPE;

Line 2463: l_class_code EGO_COL_NAME_VALUE_PAIR_ARRAY;

2459: l_attr_old_value_uom VARCHAR2(3) := NULL;
2460: l_old_query VARCHAR2(4000);
2461:
2462: l_pk_columns EGO_COL_NAME_VALUE_PAIR_ARRAY;
2463: l_class_code EGO_COL_NAME_VALUE_PAIR_ARRAY;
2464: l_item_catalog_group_id NUMBER;
2465: l_error_code NUMBER;
2466: l_attribute_names EGO_VARCHAR_TBL_TYPE;
2467: l_attr_new_values EGO_USER_ATTR_DATA_TABLE;

Line 2545: l_pk_columns := EGO_COL_NAME_VALUE_PAIR_ARRAY

2541: p_attr_new_value_date IS NOT NULL AND
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:

Line 2555: l_class_code := EGO_COL_NAME_VALUE_PAIR_ARRAY

2551: LOOP
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

Line 2748: ( p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY

2744:
2745: --------------------------------
2746:
2747: PROCEDURE Update_Attributes
2748: ( p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
2749: , p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
2750: , p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
2751: , p_attr_diffs IN EGO_USER_ATTR_DIFF_TABLE
2752: , p_transaction_type IN VARCHAR2

Line 2749: , p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY

2745: --------------------------------
2746:
2747: PROCEDURE Update_Attributes
2748: ( p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
2749: , p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
2750: , p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
2751: , p_attr_diffs IN EGO_USER_ATTR_DIFF_TABLE
2752: , p_transaction_type IN VARCHAR2
2753: , p_attr_group_id IN NUMBER DEFAULT NULL

Line 2750: , p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY

2746:
2747: PROCEDURE Update_Attributes
2748: ( p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
2749: , p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
2750: , p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
2751: , p_attr_diffs IN EGO_USER_ATTR_DIFF_TABLE
2752: , p_transaction_type IN VARCHAR2
2753: , p_attr_group_id IN NUMBER DEFAULT NULL
2754: , x_error_message OUT NOCOPY VARCHAR2

Line 2788: , px_pk_column_name_value_pairs OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_ARRAY

2784: , p_application_id IN NUMBER DEFAULT NULL
2785: , p_attr_group_type IN VARCHAR2 DEFAULT NULL
2786: , p_attr_group_name IN VARCHAR2 DEFAULT NULL
2787: , px_attr_diffs IN OUT NOCOPY EGO_USER_ATTR_DIFF_TABLE
2788: , px_pk_column_name_value_pairs OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_ARRAY
2789: , px_class_code_name_value_pairs OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_ARRAY
2790: , px_data_level_name_value_pairs OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_ARRAY
2791: , x_error_message OUT NOCOPY VARCHAR2
2792: )

Line 2789: , px_class_code_name_value_pairs OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_ARRAY

2785: , p_attr_group_type IN VARCHAR2 DEFAULT NULL
2786: , p_attr_group_name IN VARCHAR2 DEFAULT NULL
2787: , px_attr_diffs IN OUT NOCOPY EGO_USER_ATTR_DIFF_TABLE
2788: , px_pk_column_name_value_pairs OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_ARRAY
2789: , px_class_code_name_value_pairs OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_ARRAY
2790: , px_data_level_name_value_pairs OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_ARRAY
2791: , x_error_message OUT NOCOPY VARCHAR2
2792: )
2793: IS

Line 2790: , px_data_level_name_value_pairs OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_ARRAY

2786: , p_attr_group_name IN VARCHAR2 DEFAULT NULL
2787: , px_attr_diffs IN OUT NOCOPY EGO_USER_ATTR_DIFF_TABLE
2788: , px_pk_column_name_value_pairs OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_ARRAY
2789: , px_class_code_name_value_pairs OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_ARRAY
2790: , px_data_level_name_value_pairs OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_ARRAY
2791: , x_error_message OUT NOCOPY VARCHAR2
2792: )
2793: IS
2794: -- l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

Line 2794: -- l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

2790: , px_data_level_name_value_pairs OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_ARRAY
2791: , x_error_message OUT NOCOPY VARCHAR2
2792: )
2793: IS
2794: -- l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
2795: -- l_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
2796: l_item_catalog_group_id NUMBER;
2797: BEGIN
2798:

Line 2795: -- l_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

2791: , x_error_message OUT NOCOPY VARCHAR2
2792: )
2793: IS
2794: -- l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
2795: -- l_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
2796: l_item_catalog_group_id NUMBER;
2797: BEGIN
2798:
2799: px_pk_column_name_value_pairs :=

Line 2800: EGO_COL_NAME_VALUE_PAIR_ARRAY

2796: l_item_catalog_group_id NUMBER;
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:

Line 2812: EGO_COL_NAME_VALUE_PAIR_ARRAY

2808: WHERE inventory_item_id = p_inventory_item_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'