DBA Data[Home] [Help]

APPS.EGO_GTIN_PVT dependencies on EGO_USER_ATTR_DIFF_TABLE

Line 1811: l_attr_diffs EGO_USER_ATTR_DIFF_TABLE;

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
1815: write_debug_log('Entering EGO_GTIN_PVT.PROCESS_UCCNET_ATTRIBUTES ... Date and Time - '||to_char(sysdate, 'dd-mon-yyyy hh:mi:ss'));

Line 1822: l_attr_diffs := EGO_USER_ATTR_DIFF_TABLE();

1818: l_error := FALSE;
1819: l_msib_upd_reqd := FALSE;
1820: l_attribute_names := EGO_VARCHAR_TBL_TYPE(null);
1821: k := 0;
1822: l_attr_diffs := EGO_USER_ATTR_DIFF_TABLE();
1823: -- find whether updated item is an UCCnet enabled item or not
1824: BEGIN
1825: SELECT GDSN_OUTBOUND_ENABLED_FLAG INTO l_gdsn_outbound_enabled_flag
1826: FROM MTL_SYSTEM_ITEMS_B

Line 2175: , p_attr_diffs IN EGO_USER_ATTR_DIFF_TABLE

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
2179: )

Line 2751: , p_attr_diffs IN EGO_USER_ATTR_DIFF_TABLE

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
2755: )

Line 2787: , px_attr_diffs IN OUT NOCOPY EGO_USER_ATTR_DIFF_TABLE

2783: , p_attr_group_id IN NUMBER DEFAULT NULL
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