DBA Data[Home] [Help]

APPS.BOM_COMPUTE_FUNCTIONS dependencies on EGO_COL_NAME_VALUE_PAIR_ARRAY

Line 881: l_pk_column_values EGO_COL_NAME_VALUE_PAIR_ARRAY;

877: ,x_return_status OUT NOCOPY VARCHAR2
878: ,x_error_message OUT NOCOPY VARCHAR2
879: )
880: IS
881: l_pk_column_values EGO_COL_NAME_VALUE_PAIR_ARRAY;
882: l_pk_column_value EGO_COL_NAME_VALUE_PAIR_OBJ;
883: l_error_message VARCHAR2(2000);
884: l_item_catalog_group_id NUMBER;
885: l_extension_ids EGO_NUMBER_TBL_TYPE;

Line 942: l_pk_column_values := EGO_COL_NAME_VALUE_PAIR_ARRAY(

938: END IF;
939:
940: END IF;
941:
942: l_pk_column_values := EGO_COL_NAME_VALUE_PAIR_ARRAY(
943: EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_ITEM_ID', p_header_item_id)
944: ,EGO_COL_NAME_VALUE_PAIR_OBJ('ORGANIZATION_ID', p_organization_id)
945: );
946:

Line 1013: EGO_COL_NAME_VALUE_PAIR_ARRAY

1009: l_item_catalog_group_id := c1.item_catalog_group_id;
1010: END LOOP;
1011:
1012: Bom_Rollup_Pub.g_class_code_name_value_pairs :=
1013: EGO_COL_NAME_VALUE_PAIR_ARRAY
1014: (EGO_COL_NAME_VALUE_PAIR_OBJ('ITEM_CATALOG_GROUP_ID', to_char(l_item_catalog_group_id)));
1015:
1016: END IF;
1017: --Call the update api only if Bom_Rollup_Pub.g_attr_diffs is not null.

Line 1250: l_pk_columns EGO_COL_NAME_VALUE_PAIR_ARRAY;

1246: , x_msg_count OUT NOCOPY VARCHAR2
1247: , x_msg_data OUT NOCOPY VARCHAR2
1248: )
1249: IS
1250: l_pk_columns EGO_COL_NAME_VALUE_PAIR_ARRAY;
1251: l_class_code EGO_COL_NAME_VALUE_PAIR_ARRAY;
1252: l_data_level EGO_COL_NAME_VALUE_PAIR_ARRAY;
1253: l_item_catalog_group_id NUMBER;
1254: l_error_code NUMBER;

Line 1251: l_class_code EGO_COL_NAME_VALUE_PAIR_ARRAY;

1247: , x_msg_data OUT NOCOPY VARCHAR2
1248: )
1249: IS
1250: l_pk_columns EGO_COL_NAME_VALUE_PAIR_ARRAY;
1251: l_class_code EGO_COL_NAME_VALUE_PAIR_ARRAY;
1252: l_data_level EGO_COL_NAME_VALUE_PAIR_ARRAY;
1253: l_item_catalog_group_id NUMBER;
1254: l_error_code NUMBER;
1255:

Line 1252: l_data_level EGO_COL_NAME_VALUE_PAIR_ARRAY;

1248: )
1249: IS
1250: l_pk_columns EGO_COL_NAME_VALUE_PAIR_ARRAY;
1251: l_class_code EGO_COL_NAME_VALUE_PAIR_ARRAY;
1252: l_data_level EGO_COL_NAME_VALUE_PAIR_ARRAY;
1253: l_item_catalog_group_id NUMBER;
1254: l_error_code NUMBER;
1255:
1256: --Cursor for creating the classification code

Line 1269: l_pk_columns := EGO_COL_NAME_VALUE_PAIR_ARRAY

1265: AND organization_id = p_organization_id;
1266:
1267: BEGIN
1268:
1269: l_pk_columns := EGO_COL_NAME_VALUE_PAIR_ARRAY
1270: ( EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_ITEM_ID', p_item_id)
1271: , EGO_COL_NAME_VALUE_PAIR_OBJ('ORGANIZATION_ID', p_organization_id)
1272: );
1273:

Line 1279: l_class_code := EGO_COL_NAME_VALUE_PAIR_ARRAY

1275: LOOP
1276: l_item_catalog_group_id := c1.item_catalog_group_id;
1277: END LOOP;
1278:
1279: l_class_code := EGO_COL_NAME_VALUE_PAIR_ARRAY
1280: (EGO_COL_NAME_VALUE_PAIR_OBJ('ITEM_CATALOG_GROUP_ID', to_char(l_item_catalog_group_id)));
1281:
1282: l_data_level := EGO_COL_NAME_VALUE_PAIR_ARRAY
1283: (EGO_COL_NAME_VALUE_PAIR_OBJ('DATA_LEVEL', 'EGO_ITEM'));

Line 1282: l_data_level := EGO_COL_NAME_VALUE_PAIR_ARRAY

1278:
1279: l_class_code := EGO_COL_NAME_VALUE_PAIR_ARRAY
1280: (EGO_COL_NAME_VALUE_PAIR_OBJ('ITEM_CATALOG_GROUP_ID', to_char(l_item_catalog_group_id)));
1281:
1282: l_data_level := EGO_COL_NAME_VALUE_PAIR_ARRAY
1283: (EGO_COL_NAME_VALUE_PAIR_OBJ('DATA_LEVEL', 'EGO_ITEM'));
1284:
1285: EGO_USER_ATTRS_DATA_PVT.Perform_DML_On_Row(
1286: p_api_version => 1.0