DBA Data[Home] [Help]

APPS.EGO_GTIN_ATTRS_PVT dependencies on EGO_VARCHAR_TBL_TYPE

Line 3606: l_attribute_names EGO_VARCHAR_TBL_TYPE := EGO_VARCHAR_TBL_TYPE(null);

3602: AND eiuai.PROCESS_STATUS = 2
3603: AND eiuai.INVENTORY_ITEM_ID = c_inventory_item_id
3604: AND eiuai.ORGANIZATION_ID = c_organization_id;
3605:
3606: l_attribute_names EGO_VARCHAR_TBL_TYPE := EGO_VARCHAR_TBL_TYPE(null);
3607: l_attr_diffs EGO_USER_ATTR_DIFF_TABLE;
3608: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3609: l_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3610: l_data_level_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

Line 3618: l_attribute_names := EGO_VARCHAR_TBL_TYPE(null);

3614: BEGIN
3615: Debug_Msg('Starting Do_Post_UCCnet_Attrs_Action');
3616: FOR i IN c_intf_rows LOOP
3617: Debug_Msg('Starting Do_Post_UCCnet_Attrs_Action for Item,Org='||i.INVENTORY_ITEM_ID||','||i.ORGANIZATION_ID);
3618: l_attribute_names := EGO_VARCHAR_TBL_TYPE(null);
3619: l_attr_diffs := EGO_USER_ATTR_DIFF_TABLE();
3620: FOR j IN c_intf_row_attrs(i.INVENTORY_ITEM_ID, i.ORGANIZATION_ID) LOOP
3621: -- populating variable for passing to EGO_GTIN_PVT.PROCESS_ATTRIBUTE_UPDATES
3622: l_attribute_names.EXTEND;

Line 3891: l_attribute_names EGO_VARCHAR_TBL_TYPE := EGO_VARCHAR_TBL_TYPE(null);

3887: l_attributes_row_table EGO_USER_ATTR_ROW_TABLE;
3888: l_attributes_data_table EGO_USER_ATTR_DATA_TABLE;
3889: l_new_row BOOLEAN;
3890: l_row_identifier NUMBER;
3891: l_attribute_names EGO_VARCHAR_TBL_TYPE := EGO_VARCHAR_TBL_TYPE(null);
3892: l_trade_item_desc MTL_SYSTEM_ITEMS_B.TRADE_ITEM_DESCRIPTOR%TYPE;
3893: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3894: l_cc_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3895: l_dl_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;